UNPKG

igo/sql/20171025-libraries.sql

Version:

250 Bapplication/x-sqlView Raw

1
2--
3
4CREATE TABLE `libraries` (
5  `id`          INT NOT NULL AUTO_INCREMENT,
6  `title`       VARCHAR(100),
7  `created_at`  DATETIME,
8  PRIMARY KEY (`id`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
10
11ALTER TABLE `books` ADD COLUMN `library_id` INT NULL;

1
2	`--`
3
4	CREATE TABLE `libraries` (
5	`id` INT NOT NULL AUTO_INCREMENT,
6	`title` VARCHAR(100),
7	`created_at` DATETIME,
8	PRIMARY KEY (`id`)
9	`) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;`
10
11	ALTER TABLE `books` ADD COLUMN `library_id` INT NULL;