diff options
| author | paul <paul@7b491191-dbf0-0310-aff6-d879d4d69008> | 2005-06-17 11:00:36 +0000 |
|---|---|---|
| committer | paul <paul@7b491191-dbf0-0310-aff6-d879d4d69008> | 2005-06-17 11:00:36 +0000 |
| commit | 657628af946c606f22067468306bca2b1937bbfd (patch) | |
| tree | 6c36560728f8473a4d185db3b415b4d4f3bfbaac /sql | |
| parent | bec364a90d197564aafb8bbb75366fba49e8e8c1 (diff) | |
auto-reply cleanup
git-svn-id: https://svn.ic-s.nl/svn/dbmail/trunk/dbmail@1806 7b491191-dbf0-0310-aff6-d879d4d69008
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mysql/add_replycache.mysql | 18 | ||||
| -rw-r--r-- | sql/postgresql/add_replycache.pgsql | 6 |
2 files changed, 24 insertions, 0 deletions
diff --git a/sql/mysql/add_replycache.mysql b/sql/mysql/add_replycache.mysql new file mode 100644 index 00000000..a81112fc --- /dev/null +++ b/sql/mysql/add_replycache.mysql @@ -0,0 +1,18 @@ +-- MySQL dump 9.11 +-- +-- Host: localhost Database: dbmail +-- ------------------------------------------------------ +-- Server version 4.0.24_Debian-7-log + +-- +-- Table structure for table `dbmail_replycache` +-- + +DROP TABLE IF EXISTS dbmail_replycache; +CREATE TABLE dbmail_replycache ( + to_addr varchar(100) NOT NULL default '', + from_addr varchar(100) NOT NULL default '', + lastseen datetime NOT NULL default '0000-00-00 00:00:00', + UNIQUE KEY replycache_1 (to_addr,from_addr) +) TYPE=InnoDB; + diff --git a/sql/postgresql/add_replycache.pgsql b/sql/postgresql/add_replycache.pgsql new file mode 100644 index 00000000..a7a733d6 --- /dev/null +++ b/sql/postgresql/add_replycache.pgsql @@ -0,0 +1,6 @@ +CREATE TABLE dbmail_replycache ( + to_addr character varying(100) DEFAULT ''::character varying NOT NULL, + from_addr character varying(100) DEFAULT ''::character varying NOT NULL, + lastseen timestamp without time zone NOT NULL +); +CREATE UNIQUE INDEX replycache_1 ON dbmail_replycache USING btree (to_addr, from_addr); |