KZCLe7Zs

1DROP PROCEDURE IF EXISTS generate_schema;
2DELIMITER $$
3CREATE PROCEDURE generate_schema()
4BEGIN
5    DROP TABLE IF EXISTS `foo`;
6    DROP TABLE IF EXISTS `bar`;
7
8    CREATE TABLE `foo`
9    (
10        `id`   INT          NOT NULL AUTO_INCREMENT,
11        `name` VARCHAR(255) NOT NULL,
12        `year` INT          NOT NULL,
13        PRIMARY KEY (`id`)
14    ) ENGINE = InnoDB;
15
16    CREATE TABLE `bar`
17    (
18        `id`   INT          NOT NULL AUTO_INCREMENT,
19        `name` VARCHAR(255) NOT NULL,
20        `year` INT          NOT NULL,
21        PRIMARY KEY (`id`)
22    ) ENGINE = InnoDB;
23
24    INSERT INTO `foo` (id, name, year) VALUES (1, "stack", 1993);
25    INSERT INTO `foo` (id, name, year) VALUES (2, "over", 1994);
26    INSERT INTO `foo` (id, name, year) VALUES (3, "flow", 1995);
27    INSERT INTO `bar` (id, name, year) VALUES (2, "xyz", 2019);
28
29END$$
30DELIMITER ;
31
32CALL generate_schema();