UNPKG

igo/sql/20160711-books.sql

Version:

283 Bapplication/x-sqlView Raw

1
2
3--
4
5CREATE TABLE `books` (
6  `id`            INT NOT NULL AUTO_INCREMENT,
7  `code`          VARCHAR(50),
8  `title`         VARCHAR(100),
9  `details_json`  TEXT,
10  `is_available`  TINYINT(0),
11  `created_at`    DATETIME,
12  PRIMARY KEY (`id`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

1
2
3	`--`
4
5	CREATE TABLE `books` (
6	`id` INT NOT NULL AUTO_INCREMENT,
7	`code` VARCHAR(50),
8	`title` VARCHAR(100),
9	`details_json` TEXT,
10	`is_available` TINYINT(0),
11	`created_at` DATETIME,
12	PRIMARY KEY (`id`)
13	`) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;`