Hx6v47Lv

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