· 7 years ago · Oct 21, 2018, 08:42 AM
1DROP TABLE IF EXISTS `Rate`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `Rate` (
5 `rate_id` int(11) NOT NULL AUTO_INCREMENT,
6 `target_id` int(11) DEFAULT NULL,
7 `related_id` int(11) DEFAULT NULL,
8 `score` int(11) DEFAULT NULL,
9 PRIMARY KEY (`rate_id`),
10 KEY `target_id` (`target_id`),
11 KEY `related_id` (`related_id`),
12 CONSTRAINT `Rate_ibfk_1` FOREIGN KEY (`target_id`) REFERENCES `sig_article` (`id`),
13 CONSTRAINT `Rate_ibfk_2` FOREIGN KEY (`related_id`) REFERENCES `sig_article` (`id`)
14) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
15/*!40101 SET character_set_client = @saved_cs_client */;
16
17
18CREATE TABLE `sig_article` (
19 `id` int(11) NOT NULL AUTO_INCREMENT,
20 `url` varchar(512) NOT NULL,
21 `title` varchar(512) NOT NULL,
22 `abstract` varchar(512) NOT NULL,
23 `text_content` mediumtext NOT NULL,
24 `extracted_content` mediumtext NOT NULL,
25 `html_content` mediumtext NOT NULL,
26 `cover_url` varchar(512) NOT NULL,
27 `published` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
28 `crawled` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
29 `wid` int(11) NOT NULL,
30 `cid` int(11) NOT NULL,
31 `meta` text,
32 `mapentities` longtext,
33 `mapclass` longtext,
34 `tfidf` longtext,
35 `maprelatednews` longtext,
36 `titlemap` longtext,
37 `mapclassnumber` longtext,
38 `mapentitiesnumber` longtext,
39 `maprelatednews_old` longtext,
40 `maprelatednews_v1` longtext,
41 `maprelatednews_v2` longtext,
42 `concepts` longtext,
43 `new_concepts` longtext,
44 PRIMARY KEY (`id`),
45 KEY `wid` (`wid`),
46 KEY `cid` (`cid`),
47 CONSTRAINT `sig_article_ibfk_1` FOREIGN KEY (`wid`) REFERENCES `sig_website` (`id`) ON DELETE CASCADE,
48 CONSTRAINT `sig_article_ibfk_2` FOREIGN KEY (`cid`) REFERENCES `sig_category` (`id`) ON DELETE CASCADE
49) ENGINE=InnoDB AUTO_INCREMENT=452 DEFAULT CHARSET=utf8;