From: Pierre Habouzit <madcoder@debian.org>
Date: Sun, 17 Aug 2003 14:33:09 +0000 (+0000)
Subject: sql code to create the databases/tables
X-Git-Tag: procmail~69
X-Git-Url: http://git.polytechnique.org/?p=old-projects.git;a=commitdiff_plain;h=405d0b1da323c541d9a02bb8b512a48cc11df961

sql code to create the databases/tables
---

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;
+