· 6 years ago · May 10, 2019, 07:30 AM
1CREATE DATABASE `douban`;
2USE `douban`;
3
4DROP TABLE IF EXISTS `books`;
5CREATE TABLE `books` (
6 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
7 `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
8 `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
9 `sub_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
10 `alt_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
11 `cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
12 `summary` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
13 `authors` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
14 `author_intro` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
15 `translators` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
16 `series` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
17 `publisher` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
18 `publish_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
19 `pages` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
20 `price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
21 `binding` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
22 `isbn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
23 `tags` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
24 `douban_id` int(10) unsigned NOT NULL DEFAULT '0',
25 `douban_score` decimal(3,1) unsigned NOT NULL DEFAULT '0.0',
26 `douban_votes` int(10) unsigned NOT NULL DEFAULT '0',
27 `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
28 `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
29 PRIMARY KEY (`id`),
30 KEY `books_slug_index` (`slug`),
31 KEY `books_name_index` (`name`),
32 KEY `books_douban_id_index` (`douban_id`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
34
35
36DROP TABLE IF EXISTS `comments`;
37CREATE TABLE `comments` (
38 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
39 `douban_id` int(10) unsigned NOT NULL DEFAULT '0',
40 `douban_comment_id` int(10) unsigned NOT NULL DEFAULT '0',
41 `douban_user_nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
42 `douban_user_avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
43 `douban_user_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
44 `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
45 `votes` int(10) unsigned NOT NULL DEFAULT '0',
46 `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
47 `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
48 PRIMARY KEY (`id`),
49 KEY `comments_douban_id_index` (`douban_id`),
50 KEY `comments_douban_comment_id_index` (`douban_comment_id`)
51) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
52
53
54DROP TABLE IF EXISTS `movies`;
55CREATE TABLE `movies` (
56 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
57 `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
58 `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
59 `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
60 `alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
61 `cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
62 `year` smallint(5) unsigned NOT NULL DEFAULT '0',
63 `regions` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
64 `genres` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
65 `languages` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
66 `release_date` date DEFAULT NULL,
67 `official_site` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
68 `directors` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
69 `actors` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
70 `storyline` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
71 `mins` smallint(5) unsigned NOT NULL DEFAULT '0',
72 `recommend_tip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
73 `tags` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
74 `avg_score` decimal(3,1) unsigned NOT NULL DEFAULT '0.0',
75 `imdb_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
76 `imdb_score` decimal(3,1) unsigned NOT NULL DEFAULT '0.0',
77 `imdb_votes` int(10) unsigned NOT NULL DEFAULT '0',
78 `douban_id` int(10) unsigned NOT NULL DEFAULT '0',
79 `douban_score` decimal(3,1) unsigned NOT NULL DEFAULT '0.0',
80 `douban_votes` int(10) unsigned NOT NULL DEFAULT '0',
81 `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
82 `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
83 PRIMARY KEY (`id`),
84 KEY `movies_slug_index` (`slug`),
85 KEY `movies_name_index` (`name`),
86 KEY `movies_imdb_id_index` (`imdb_id`),
87 KEY `movies_douban_id_index` (`douban_id`)
88) ENGINE=InnoDB AUTO_INCREMENT=899 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
89
90DROP TABLE IF EXISTS `subjects`;
91CREATE TABLE `subjects` (
92 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
93 `douban_id` int(10) unsigned NOT NULL DEFAULT '0',
94 `type` enum('movie','book') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'movie',
95 PRIMARY KEY (`id`),
96 UNIQUE KEY `subjects_douban_id_unique` (`douban_id`)
97) ENGINE=InnoDB AUTO_INCREMENT=18335 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;