· 8 years ago · Dec 19, 2017, 03:36 PM
1
2--
3-- Estrutura da tabela `cms_news`
4--
5
6CREATE TABLE IF NOT EXISTS `cms_news` (
7 `id` int(11) NOT NULL AUTO_INCREMENT,
8 `title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
9 `category` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
10 `closed` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
11 `form` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
12 `shortstory` text COLLATE latin1_general_ci,
13 `author` text COLLATE latin1_general_ci,
14 `longstory` text COLLATE latin1_general_ci,
15 `published` int(10) NOT NULL DEFAULT '0',
16 `image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
17 `campaign` int(1) NOT NULL DEFAULT '0',
18 `campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL,
19 PRIMARY KEY (`id`)
20) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;
21
22--
23-- Extraindo dados da tabela `cms_news`
24--
25
26INSERT INTO `cms_news` (`id`, `title`, `category`, `closed`, `form`, `shortstory`, `author`, `longstory`, `published`, `image`, `campaign`, `campaignimg`) VALUES
27(1, 'ggggggggggg', NULL, NULL, NULL, '<p>http://3.bp.blogspot.com/-y9CIsCfIlFQ/UmKhMauolgI/AAAAAAAABe8/J-b_BcC6Ssg/s1600/300x187_newyear2008.gif</p>', '', 'ggggggggggggggg', 1513531719, 'http://3.bp.blogspot.com/-y9CIsCfIlFQ/UmKhMauolgI/AAAAAAAABe8/J-b_BcC6Ssg/s1600/300x187_newyear2008.gif', 0, '0');