database_backup.sql

CREATE DATABASE IF NOT EXISTS anychart_db;
USE anychart_db;
DROP PROCEDURE IF EXISTS init;
DELIMITER //
CREATE PROCEDURE init ()
LANGUAGE SQL
  BEGIN
    DECLARE user_exist, data_present INT;
    SET user_exist = (SELECT EXISTS (SELECT DISTINCT user FROM mysql.user WHERE user = "anychart_user"));
    IF user_exist = 0 THEN
      CREATE USER 'anychart_user'@'localhost' IDENTIFIED BY 'anychart_pass';
      GRANT ALL PRIVILEGES ON anychart_db.* TO 'anychart_user'@'localhost';
      FLUSH PRIVILEGES;
    END IF;
    CREATE TABLE IF NOT EXISTS fruits (
      id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
      name VARCHAR(64),
      value INT
    );
    SET data_present = (SELECT COUNT(*) FROM fruits);
    IF data_present = 0 THEN
      INSERT INTO fruits (name, value) VALUES
        ('apples', 10),
        ('oranges', 20),
        ('bananas', 15),
        ('lemons', 5),
        ('pears', 3),
        ('apricots', 7),
        ('kiwis', 9),
        ('mangos', 12),
        ('figs', 4),
        ('limes', 8);
    END IF;
  END;//
DELIMITER ;
CALL init();