3 -- Host: Database: so2-dev
4 -- ------------------------------------------------------
5 -- Server version 5.0.10-beta
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 /*!40101 SET NAMES utf8 */;
11 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
12 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17 -- Table structure for table `board-groups`
20 DROP TABLE IF EXISTS `board-groups`;
21 CREATE TABLE `board-groups` (
22 `groupid` tinyint(3) unsigned NOT NULL auto_increment,
23 `group_name` varchar(50) character set latin1 NOT NULL,
24 PRIMARY KEY (`groupid`)
25 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
28 -- Table structure for table `boards`
31 DROP TABLE IF EXISTS `boards`;
32 CREATE TABLE `boards` (
33 `boardid` tinyint(4) NOT NULL auto_increment,
34 `groupid` tinyint(3) unsigned NOT NULL default '0',
35 `board_name` varchar(255) NOT NULL,
36 `caption` varchar(255) NOT NULL,
37 `view_level` tinyint(3) unsigned NOT NULL default '0',
38 `topic_level` tinyint(3) unsigned NOT NULL default '0',
39 `post_level` tinyint(3) unsigned NOT NULL default '0',
40 PRIMARY KEY (`boardid`)
41 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
44 -- Table structure for table `invites`
47 DROP TABLE IF EXISTS `invites`;
48 CREATE TABLE `invites` (
49 `id` smallint(5) unsigned NOT NULL auto_increment,
50 `userid` smallint(5) unsigned NOT NULL,
51 `code` char(36) NOT NULL,
53 KEY `userid` (`userid`),
54 CONSTRAINT `invites_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE
55 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
58 -- Table structure for table `marks`
61 DROP TABLE IF EXISTS `marks`;
62 CREATE TABLE `marks` (
63 `markid` tinyint(3) unsigned NOT NULL auto_increment,
64 `messageid` mediumint(8) unsigned NOT NULL default '0',
65 `mark_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
66 `reason` char(255) NOT NULL,
67 `handled` bit(1) NOT NULL,
68 PRIMARY KEY (`markid`),
69 KEY `mk_msgid` (`messageid`)
70 ) ENGINE=MEMORY DEFAULT CHARSET=utf8;
73 -- Table structure for table `message-data`
76 DROP TABLE IF EXISTS `message-data`;
77 CREATE TABLE `message-data` (
78 `messageid` mediumint(8) unsigned NOT NULL default '0',
79 `mtext` text NOT NULL,
80 PRIMARY KEY (`messageid`),
81 CONSTRAINT `message-data_ibfk_1` FOREIGN KEY (`messageid`) REFERENCES `messages` (`messageid`) ON DELETE CASCADE
82 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
85 -- Table structure for table `messages`
88 DROP TABLE IF EXISTS `messages`;
89 CREATE TABLE `messages` (
90 `messageid` mediumint(8) unsigned NOT NULL auto_increment,
91 `topicid` mediumint(8) unsigned NOT NULL default '0',
92 `userid` smallint(5) unsigned NOT NULL default '0',
93 `mtime` int(10) unsigned NOT NULL,
94 `score` tinyint(3) NOT NULL default '0',
95 `replyto` mediumint(8) unsigned default NULL,
96 `origin_ip` int(10) unsigned NOT NULL,
97 PRIMARY KEY (`messageid`),
98 KEY `m_replyto` (`replyto`),
99 KEY `m_poster` (`userid`),
100 KEY `m_topic` (`topicid`),
101 CONSTRAINT `messages_ibfk_3` FOREIGN KEY (`replyto`) REFERENCES `messages` (`messageid`) ON DELETE CASCADE,
102 CONSTRAINT `messages_ibfk_1` FOREIGN KEY (`topicid`) REFERENCES `topics` (`topicid`) ON DELETE CASCADE,
103 CONSTRAINT `messages_ibfk_2` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE
104 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
107 -- Table structure for table `themes`
110 DROP TABLE IF EXISTS `themes`;
111 CREATE TABLE `themes` (
112 `themeid` tinyint(3) unsigned NOT NULL auto_increment,
113 `theme_name` char(20) NOT NULL,
114 `css_file` char(20) NOT NULL,
115 PRIMARY KEY (`themeid`)
116 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
119 -- Table structure for table `topics`
122 DROP TABLE IF EXISTS `topics`;
123 CREATE TABLE `topics` (
124 `topicid` mediumint(8) unsigned NOT NULL auto_increment,
125 `topic_title` varchar(255) NOT NULL,
126 `userid` smallint(5) unsigned NOT NULL default '0',
127 `boardid` tinyint(4) NOT NULL default '0',
128 `visibility` enum('normal','deleted','modded','sticky') NOT NULL default 'normal',
129 `closed` bit(1) NOT NULL default '\0',
130 `lastpost` mediumint(8) unsigned default NULL,
131 PRIMARY KEY (`topicid`),
132 KEY `t_poster` (`userid`),
133 KEY `lastpost` (`lastpost`),
134 CONSTRAINT `topics_ibfk_2` FOREIGN KEY (`lastpost`) REFERENCES `messages` (`messageid`),
135 CONSTRAINT `topics_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE
136 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
139 -- Table structure for table `users`
142 DROP TABLE IF EXISTS `users`;
143 CREATE TABLE `users` (
144 `userid` smallint(5) unsigned NOT NULL auto_increment,
145 `level` tinyint(3) NOT NULL default '10',
146 `alias` varchar(25) NOT NULL,
147 `password` binary(255) NOT NULL,
148 `points` int(10) unsigned NOT NULL default '0',
149 `referrer` smallint(5) unsigned default NULL,
150 `boardlist_layout` tinyint(1) unsigned NOT NULL default '0',
151 `topiclist_layout` tinyint(1) unsigned NOT NULL default '0',
152 `msglist_layout` tinyint(1) unsigned NOT NULL default '0',
153 `topics_page` tinyint(3) unsigned NOT NULL default '35',
154 `msgs_page` tinyint(3) unsigned NOT NULL default '35',
155 `language` varchar(32) NOT NULL default 'en_GB',
156 `timezone` tinyint(2) NOT NULL default '0',
157 `theme` tinyint(3) unsigned NOT NULL default '4',
158 `last_active_date` int(10) unsigned NOT NULL,
159 `register_date` int(10) unsigned NOT NULL,
160 `sig` varchar(255) default NULL,
161 `quote` varchar(255) default NULL,
162 `useragent` varchar(100) default NULL,
163 `public_email` varchar(70) default NULL,
164 `private_email` varchar(70) default NULL,
165 `reg_email` varchar(70) NOT NULL,
166 `last_ip` int(10) unsigned default '0',
167 `last_login_ip` int(10) unsigned default '0',
168 `reg_ip` int(10) unsigned default '0',
169 `date_format` varchar(40) NOT NULL default 'Y-m-d H:i:s',
170 PRIMARY KEY (`userid`),
171 KEY `u_referrer` (`referrer`),
172 CONSTRAINT `users_ibfk_1` FOREIGN KEY (`referrer`) REFERENCES `users` (`userid`) ON DELETE CASCADE
173 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
175 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
176 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
177 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
178 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
179 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
180 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
181 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;