UNPKG

igo/sql/20171025-libraries.sql

Version:

296 Bapplication/x-sqlView Raw

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