Cjk0Yhvf

1SET foreign_key_checks=0;
2
3DROP TABLE IF EXISTS `player`;
4
5CREATE TABLE `player` (
6    `id` BIGINT unsigned NOT NULL,
7    `name` VARCHAR(191) NOT NULL,
8    `created_at` DATETIME NOT NULL,
9    `updated_at` DATETIME NOT NULL,
10    `daily_notification_at` TIME NOT NULL,
11    PRIMARY KEY (`id`)
12) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4;
13
14
15DROP TABLE IF EXISTS `entry`;
16
17CREATE TABLE `entry` (
18    `id` INTEGER NOT NULL AUTO_INCREMENT,
19    `title` VARCHAR(100) NOT NULL,
20    `public` TINYINT(1) NOT NULL DEFAULT 0,
21    `content` TEXT NOT NULL,
22    `created_at` DATETIME NOT NULL,
23    `updated_at` DATETIME NOT NULL,
24    INDEX `created_at_idx` (`created_at`),
25    INDEX `title_idx` (`title`),
26    UNIQUE `created_at_uniq_idx` (`created_at`),
27    PRIMARY KEY (`id`, `created_at`)
28) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4;
29
30
31DROP TABLE IF EXISTS `player_comment`;
32
33CREATE TABLE `player_comment` (
34    `id` INTEGER NOT NULL AUTO_INCREMENT,
35    `player_id` INTEGER NOT NULL,
36    `entry_id` INTEGER NOT NULL,
37    `comment` VARCHAR(99) NULL,
38    `created_at` DATETIME NOT NULL,
39    `updated_at` DATETIME NOT NULL,
40    INDEX `player_id_entry_id_idx` (`player_id`, `entry_id`),
41    PRIMARY KEY (`id`)
42) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4;
43
44
45DROP TABLE IF EXISTS `bookmark`;
46
47CREATE TABLE `bookmark` (
48    `id` INTEGER NOT NULL,
49    `user_id` INTEGER NOT NULL,
50    `entry_id` INTEGER NOT NULL,
51    `created_at` DATETIME NOT NULL,
52    `updated_at` DATETIME NOT NULL,
53    UNIQUE `user_id_entry_id` (`user_id`, `entry_id`),
54    PRIMARY KEY (`id`)
55) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4;
56
57SET foreign_key_checks=1;