From 405d0b1da323c541d9a02bb8b512a48cc11df961 Mon Sep 17 00:00:00 2001 From: Pierre Habouzit Date: Sun, 17 Aug 2003 14:33:09 +0000 Subject: [PATCH] sql code to create the databases/tables --- philter/philter/install.d/philter.sql | 37 +++++++++++++++++++++++++++++++++++ 1 file changed, 37 insertions(+) create mode 100644 philter/philter/install.d/philter.sql diff --git a/philter/philter/install.d/philter.sql b/philter/philter/install.d/philter.sql new file mode 100644 index 0000000..104af94 --- /dev/null +++ b/philter/philter/install.d/philter.sql @@ -0,0 +1,37 @@ + +CREATE DATABASE /*!32312 IF NOT EXISTS*/ Philter; + + +CREATE TABLE `actions` ( + `uid` int(11) NOT NULL default '0', + `rid` int(11) NOT NULL default '0', + `pid` int(11) NOT NULL default '0', + `data` text NOT NULL +) TYPE=MyISAM; + +CREATE TABLE `emails` ( + `uid` int(11) NOT NULL default '0', + `mid` smallint(6) NOT NULL default '0', + `email` tinytext NOT NULL, + `broken` datetime NOT NULL default '0000-00-00 00:00:00', + `flags` set('active') NOT NULL default 'active', + PRIMARY KEY (`uid`,`mid`) +) TYPE=MyISAM; + +CREATE TABLE `matches` ( + `uid` int(11) NOT NULL default '0', + `rid` int(11) NOT NULL default '0', + `pid` int(11) NOT NULL default '0', + `data` text NOT NULL +) TYPE=MyISAM; + +CREATE TABLE `rules` ( + `uid` int(11) NOT NULL default '0', + `rid` int(11) NOT NULL default '0', + `rank` int(11) NOT NULL default '0', + `flags` set('all','block') NOT NULL default '', + `name` tinytext NOT NULL, + PRIMARY KEY (`uid`,`rid`), + KEY `uid` (`uid`,`rank`) +) TYPE=MyISAM; + -- 2.1.4