ANh6dehR

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