1 CREATE TABLE `chapters` (
2 `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
3 `user_id` integer NOT NULL,
4 `episode_id` integer NOT NULL,
6 `created` datetime NOT NULL,
7 `start` integer NOT NULL,
8 `end` integer NOT NULL,
9 `label` varchar(50) NOT NULL,
10 `advertisement` bool NOT NULL
13 ALTER TABLE `chapters` ADD CONSTRAINT `episode_id_refs_id_6613a857` FOREIGN KEY (`episode_id`) REFERENCES `episode` (`id`);
14 ALTER TABLE `chapters` ADD CONSTRAINT `device_id_refs_id_38552f8d` FOREIGN KEY (`device_id`) REFERENCES `device` (`id`);
15 ALTER TABLE `chapters` ADD CONSTRAINT `user_id_refs_id_2e1e1276` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);