· 8 years ago · Mar 08, 2018, 02:32 PM
1CREATE TABLE IF NOT EXISTS `belvg_news` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `title` varchar(100) NOT NULL,
4 `url` varchar(100) NOT NULL,
5 `short_desc` text NOT NULL,
6 `desc` text NOT NULL,
7 `time` datetime NOT NULL,
8 `user` int(11) NOT NULL,
9 `meta_keywords` text NOT NULL,
10 `meta_desc` text NOT NULL,
11 `file_preview` varchar(255) NOT NULL,
12 `file_article` varchar(255) NOT NULL,
13 `file_pdf` varchar(255) NOT NULL,
14 `allow_comments` int(11) NOT NULL,
15 `tags` text NOT NULL,
16 `store` int(11) NOT NULL,
17 `page_id` int(11) NOT NULL,
18 `rcol` int(11) NOT NULL,
19 PRIMARY KEY (`id`)
20) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
21
22CREATE TABLE IF NOT EXISTS `belvg_news_pages` (
23 `id` int(11) NOT NULL AUTO_INCREMENT,
24 `title` varchar(100) NOT NULL,
25 `url` varchar(100) NOT NULL,
26 `sort_order` int(11) NOT NULL,
27 PRIMARY KEY (`id`)
28) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;"