UNPKG

igo/sql/20160711-books.sql

Version:

315 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  `tags_array`    VARCHAR(512),
11  `is_available`  TINYINT(0),
12  `created_at`    DATETIME,
13  PRIMARY KEY (`id`)
14) 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	`tags_array` VARCHAR(512),
11	`is_available` TINYINT(0),
12	`created_at` DATETIME,
13	PRIMARY KEY (`id`)
14	`) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;`