· 10 years ago · Aug 29, 2016, 07:30 PM
1--
2SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
3SET time_zone = "+00:00";
4--
5-- Table structure for table `site_config`
6--
7
8CREATE TABLE IF NOT EXISTS `site_config` (
9 `maintenance` enum('0','1') NOT NULL DEFAULT '0',
10 `web_build` varchar(255) NOT NULL
11) ENGINE=MyISAM DEFAULT CHARSET=latin1;
12
13-- --------------------------------------------------------
14
15--
16-- Table structure for table `site_cron`
17--
18
19CREATE TABLE IF NOT EXISTS `site_cron` (
20 `id` int(11) NOT NULL AUTO_INCREMENT,
21 `prio` int(11) NOT NULL DEFAULT '5',
22 `enabled` enum('0','1') NOT NULL DEFAULT '1',
23 `scriptfile` varchar(50) NOT NULL,
24 `last_exec` int(11) NOT NULL,
25 `exec_every` int(11) NOT NULL,
26 PRIMARY KEY (`id`)
27) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
28
29-- --------------------------------------------------------
30
31--
32-- Table structure for table `site_hotcampaigns`
33--
34
35CREATE TABLE IF NOT EXISTS `site_hotcampaigns` (
36 `id` int(11) NOT NULL AUTO_INCREMENT,
37 `order_id` int(11) NOT NULL DEFAULT '1',
38 `enabled` enum('0','1') NOT NULL DEFAULT '1',
39 `IMG_url` text NOT NULL,
40 `caption` text NOT NULL,
41 `descr` text NOT NULL,
42 `url` text NOT NULL,
43 PRIMARY KEY (`id`)
44) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
45
46-- --------------------------------------------------------
47
48--
49-- Table structure for table `site_minimail`
50--
51
52CREATE TABLE IF NOT EXISTS `site_minimail` (
53 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
54 `sender_id` int(10) unsigned NOT NULL,
55 `receiver_id` int(10) unsigned NOT NULL,
56 `folder` enum('inbox','sent','trash') NOT NULL DEFAULT 'inbox',
57 `is_read` enum('0','1') NOT NULL DEFAULT '0',
58 `subject` varchar(120) NOT NULL,
59 `date` varchar(120) NOT NULL,
60 `isodate` varchar(120) NOT NULL,
61 `timestamp` int(11) NOT NULL,
62 `body` text NOT NULL,
63 PRIMARY KEY (`id`)
64) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7075 ;
65
66-- --------------------------------------------------------
67
68--
69-- Table structure for table `site_navi`
70--
71
72CREATE TABLE IF NOT EXISTS `site_navi` (
73 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
74 `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
75 `order_id` int(11) NOT NULL,
76 `caption` text NOT NULL,
77 `class` text NOT NULL,
78 `url` text NOT NULL,
79 `visibility` enum('0','1','2','3') NOT NULL COMMENT '0 = Never, 1 = Always, 2 = Logged in only, 3 = Guests only',
80 PRIMARY KEY (`id`),
81 KEY `parent_id` (`parent_id`)
82) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
83
84-- --------------------------------------------------------
85
86--
87-- Table structure for table `site_news`
88--
89
90CREATE TABLE IF NOT EXISTS `site_news` (
91 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
92 `seo_link` varchar(120) NOT NULL DEFAULT 'news-article',
93 `title` text NOT NULL,
94 `category_id` int(10) unsigned NOT NULL DEFAULT '1',
95 `topstory_IMG` text NOT NULL,
96 `body` text NOT NULL,
97 `snippet` text NOT NULL,
98 `datestr` varchar(50) NOT NULL,
99 `timestamp` int(11) NOT NULL,
100 PRIMARY KEY (`id`)
101) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;
102
103-- --------------------------------------------------------
104
105--
106-- Table structure for table `site_news_categories`
107--
108
109CREATE TABLE IF NOT EXISTS `site_news_categories` (
110 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
111 `caption` text NOT NULL,
112 PRIMARY KEY (`id`)
113) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
114
115-- --------------------------------------------------------
116
117--
118-- Table structure for table `site_news_comments`
119--
120
121CREATE TABLE IF NOT EXISTS `site_news_comments` (
122 `id` int(11) NOT NULL AUTO_INCREMENT,
123 `article` int(11) NOT NULL,
124 `userid` int(11) NOT NULL,
125 `comment` varchar(500) NOT NULL,
126 `posted_on` varchar(150) NOT NULL DEFAULT '',
127 PRIMARY KEY (`id`)
128) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1525 ;