AbfAK4yk

1
2CREATE TABLE IF NOT EXISTS `cms_news` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
5  `category` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
6  `closed` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
7  `form` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
8  `shortstory` text COLLATE latin1_general_ci,
9  `author` text COLLATE latin1_general_ci,
10  `longstory` text COLLATE latin1_general_ci,
11  `published` int(10) NOT NULL DEFAULT '0',
12  `image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
13  `campaign` int(1) NOT NULL DEFAULT '0',
14  `campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL,
15  PRIMARY KEY (`id`)
16) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=160 ;