WxM7it59

1CREATE TABLE IF NOT EXISTS `articles` (
2    `ID` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
3    `title` VARCHAR(1024) COLLATE utf8_unicode_ci NOT NULL,
4    `sub_title` VARCHAR(1024) COLLATE utf8_unicode_ci DEFAULT NULL,
5    `content` TEXT COLLATE utf8_unicode_ci,
6    `author` VARCHAR(256) COLLATE utf8_unicode_ci DEFAULT NULL,
7    `images` VARCHAR(1024) COLLATE utf8_unicode_ci DEFAULT NULL,
8    `thumbnails` VARCHAR(1024) COLLATE utf8_unicode_ci DEFAULT NULL,
9    `media_link` VARCHAR(1024) COLLATE utf8_unicode_ci DEFAULT NULL,
10    `images_info` VARCHAR(1024) COLLATE utf8_unicode_ci DEFAULT NULL,
11    `region` VARCHAR(2) COLLATE utf8_unicode_ci DEFAULT NULL,
12    `tags` VARCHAR(256) COLLATE utf8_unicode_ci DEFAULT NULL,
13    `published_date` DATETIME DEFAULT NULL,
14    `imported_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
15    `source_url` VARCHAR(512) COLLATE utf8_unicode_ci DEFAULT NULL,
16    `hash` VARCHAR(32) COLLATE utf8_unicode_ci DEFAULT NULL,
17    `category` VARCHAR(256) COLLATE utf8_unicode_ci NOT NULL,
18    `channel_code` VARCHAR(7) COLLATE utf8_unicode_ci NOT NULL,
19    `source_code` VARCHAR(7) COLLATE utf8_unicode_ci NOT NULL,
20    PRIMARY KEY (`ID`),
21    INDEX `article_index` (`category` ASC)
22)
23
24ENGINE=InnoDB
25DEFAULT CHARACTER SET = utf8
26COLLATE = utf8_unicode_ci;