|
|
outsidenews_daily_datas表即国外新闻表：
|
|
|
CREATE TABLE `covid19_datas_guangxi`.`outsidenews_daily_datas` (
|
|
|
`id` int(0) NOT NULL AUTO_INCREMENT,
|
|
|
`eventTime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
|
|
`eventDescription` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
|
|
`siteName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
|
|
`eventUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
|
|
`homepageUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
|
|
`item_avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 80 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
|
|
|
|
|
insidenews_daily_datas表即国内新闻表：
|
|
|
CREATE TABLE `covid19_datas_guangxi`.`insidenews_daily_datas` (
|
|
|
`ID` int(0) NOT NULL AUTO_INCREMENT,
|
|
|
`eventTime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
|
|
`eventDescription` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
|
|
`siteName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
|
|
`eventUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
|
|
`homepageUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
|
|
`item_avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
|
|
PRIMARY KEY (`ID`) USING BTREE
|
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 148 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; |
