philter/philter/install.d/philter.sql

   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