forked from Podcastindex-org/database
-
Notifications
You must be signed in to change notification settings - Fork 0
/
create_table_statement.sql
73 lines (73 loc) · 4.25 KB
/
create_table_statement.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
CREATE TABLE `newsfeeds` (
`id` bigint NOT NULL AUTO_INCREMENT,
`title` varchar(768) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
`url` varchar(768) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`lastcheck` int NOT NULL DEFAULT '0',
`lastupdate` int NOT NULL DEFAULT '0',
`lastmod` int NOT NULL DEFAULT '0',
`createdon` int NOT NULL DEFAULT '0',
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`link` varchar(768) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
`errors` int NOT NULL DEFAULT '0',
`updated` tinyint NOT NULL DEFAULT '0',
`lastitemid` varchar(768) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`pubdate` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
`contenthash` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`lasthttpstatus` int NOT NULL DEFAULT '0',
`lastgoodhttpstatus` int NOT NULL DEFAULT '0',
`dead` tinyint NOT NULL DEFAULT '0',
`contenttype` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
`itunes_id` bigint DEFAULT NULL,
`duplicateof` bigint DEFAULT NULL,
`original_url` varchar(768) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`artwork_url_600` varchar(768) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`itunes_author` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`itunes_owner_email` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`itunes_owner_name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`itunes_new_feed_url` varchar(768) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`explicit` tinyint NOT NULL DEFAULT '0',
`image` varchar(768) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`itunes_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`type` tinyint NOT NULL DEFAULT '0',
`generator` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`parse_errors` int NOT NULL DEFAULT '0',
`lastparse` int NOT NULL DEFAULT '0',
`pullnow` tinyint NOT NULL DEFAULT '0' COMMENT 'Scan this feed immediately.',
`parsenow` tinyint NOT NULL DEFAULT '0' COMMENT 'Scan this feed immediately.',
`newest_item_pubdate` int NOT NULL DEFAULT '0',
`update_frequency` tinyint NOT NULL DEFAULT '0',
`priority` tinyint NOT NULL DEFAULT '0',
`language` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'Language in the feed.',
`detected_language` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'Language we detected.',
`chash` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`oldest_item_pubdate` int NOT NULL DEFAULT '0',
`item_count` int NOT NULL DEFAULT '0',
`popularity` int NOT NULL DEFAULT '0',
`podcast_chapters` varchar(768) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`podcast_locked` tinyint NOT NULL DEFAULT '0',
`podcast_owner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`),
KEY `title` (`title`),
KEY `itunes_id` (`itunes_id`),
KEY `updated` (`updated`),
KEY `errors` (`errors`),
KEY `lasthttpstatus` (`lasthttpstatus`),
KEY `lastgoodhttpstatus` (`lastgoodhttpstatus`),
KEY `dead` (`dead`),
KEY `original_url` (`original_url`),
KEY `lastcheck` (`lastcheck`),
KEY `lastupdate` (`lastupdate`),
KEY `pullnow` (`pullnow`),
KEY `parsenow` (`parsenow`),
KEY `newest_item_pubdate` (`newest_item_pubdate`),
KEY `update_frequency` (`update_frequency`),
KEY `language` (`language`),
KEY `priority` (`priority`),
KEY `chash` (`chash`),
KEY `item_count` (`item_count`),
KEY `podcast_locked` (`podcast_locked`),
KEY `podcast_owner` (`podcast_owner`),
CONSTRAINT `newsfeeds_ibfk_3` FOREIGN KEY (`itunes_id`) REFERENCES `directory_apple` (`itunes_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1336054 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Main podcasts table'