2 CREATE DATABASE /*!32312 IF NOT EXISTS*/ Philter
;
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',
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`
)
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',
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`
)