· 5 years ago · Mar 23, 2020, 12:56 AM
1DROP TABLE IF EXISTS `cms_news`;
2CREATE TABLE `cms_news` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NULL DEFAULT NULL,
5 `category` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NULL DEFAULT NULL,
6 `shortstory` text CHARACTER SET latin1 COLLATE latin1_general_ci NULL,
7 `longstory` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
8 `published` int(10) NOT NULL DEFAULT 0,
9 `image` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NULL DEFAULT NULL,
10 `images` text CHARACTER SET latin1 COLLATE latin1_general_ci NULL,
11 `comments` enum('0','1') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '1',
12 `fb` enum('0','1') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '1',
13 `votes` varchar(200) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '1',
14 `author` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '1',
15 `evidence` enum('0','1') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
16 PRIMARY KEY (`id`) USING BTREE
17) ENGINE = MyISAM AUTO_INCREMENT = 81 CHARACTER SET = latin1 COLLATE = latin1_general_ci ROW_FORMAT = Dynamic;