-- ----------------------------
-- Table structure for cms_news
-- ----------------------------
DROP TABLE IF EXISTS `cms_news`;
CREATE TABLE `cms_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
`shortstory` text COLLATE latin1_general_ci,
`longstory` text COLLATE latin1_general_ci,
`published` int(10) NOT NULL DEFAULT '0',
`image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
`campaign` int(1) NOT NULL DEFAULT '0',
`campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL,
`author` int(6) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;