From 657628af946c606f22067468306bca2b1937bbfd Mon Sep 17 00:00:00 2001
From: paul <paul@7b491191-dbf0-0310-aff6-d879d4d69008>
Date: Fri, 17 Jun 2005 11:00:36 +0000
Subject: auto-reply cleanup

git-svn-id: https://svn.ic-s.nl/svn/dbmail/trunk/dbmail@1806 7b491191-dbf0-0310-aff6-d879d4d69008
---
 sql/mysql/add_replycache.mysql      | 18 ++++++++++++++++++
 sql/postgresql/add_replycache.pgsql |  6 ++++++
 2 files changed, 24 insertions(+)
 create mode 100644 sql/mysql/add_replycache.mysql
 create mode 100644 sql/postgresql/add_replycache.pgsql

(limited to 'sql')

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);
-- 
cgit v1.2.3