· 4 years ago · Feb 06, 2021, 06:50 PM
1-- ----------------------------
2-- Table structure for cms_news
3-- ----------------------------
4DROP TABLE IF EXISTS `cms_news`;
5CREATE TABLE `cms_news` (
6`id` int(11) NOT NULL AUTO_INCREMENT,
7`title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
8`shortstory` text COLLATE latin1_general_ci,
9`longstory` text COLLATE latin1_general_ci,
10`published` int(10) NOT NULL DEFAULT '0',
11`image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
12`campaign` int(1) NOT NULL DEFAULT '0',
13`campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL,
14`author` int(6) NOT NULL DEFAULT '1',
15PRIMARY KEY (`id`)
16) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;