Commit | Line | Data |
---|---|---|
405d0b1d PH |
1 | |
2 | CREATE DATABASE /*!32312 IF NOT EXISTS*/ Philter; | |
3 | ||
4 | ||
5 | CREATE TABLE `actions` ( | |
6 | `uid` int(11) NOT NULL default '0', | |
7 | `rid` int(11) NOT NULL default '0', | |
8 | `pid` int(11) NOT NULL default '0', | |
9 | `data` text NOT NULL | |
10 | ) TYPE=MyISAM; | |
11 | ||
12 | CREATE TABLE `emails` ( | |
13 | `uid` int(11) NOT NULL default '0', | |
14 | `mid` smallint(6) NOT NULL default '0', | |
15 | `email` tinytext NOT NULL, | |
16 | `broken` datetime NOT NULL default '0000-00-00 00:00:00', | |
17 | `flags` set('active') NOT NULL default 'active', | |
18 | PRIMARY KEY (`uid`,`mid`) | |
19 | ) TYPE=MyISAM; | |
20 | ||
21 | CREATE TABLE `matches` ( | |
22 | `uid` int(11) NOT NULL default '0', | |
23 | `rid` int(11) NOT NULL default '0', | |
24 | `pid` int(11) NOT NULL default '0', | |
25 | `data` text NOT NULL | |
26 | ) TYPE=MyISAM; | |
27 | ||
28 | CREATE TABLE `rules` ( | |
29 | `uid` int(11) NOT NULL default '0', | |
30 | `rid` int(11) NOT NULL default '0', | |
31 | `rank` int(11) NOT NULL default '0', | |
32 | `flags` set('all','block') NOT NULL default '', | |
33 | `name` tinytext NOT NULL, | |
34 | PRIMARY KEY (`uid`,`rid`), | |
35 | KEY `uid` (`uid`,`rank`) | |
36 | ) TYPE=MyISAM; | |
37 |