diff options
Diffstat (limited to 'mail/dbmail/files/patch-0008-Add-primary-key-constraint-to-dbmail_authlog')
| -rw-r--r-- | mail/dbmail/files/patch-0008-Add-primary-key-constraint-to-dbmail_authlog | 26 |
1 files changed, 0 insertions, 26 deletions
diff --git a/mail/dbmail/files/patch-0008-Add-primary-key-constraint-to-dbmail_authlog b/mail/dbmail/files/patch-0008-Add-primary-key-constraint-to-dbmail_authlog deleted file mode 100644 index 5b2c8001e631..000000000000 --- a/mail/dbmail/files/patch-0008-Add-primary-key-constraint-to-dbmail_authlog +++ /dev/null @@ -1,26 +0,0 @@ -From 024ba19d1c83bee22b6b5901d2fff586d9391cf3 Mon Sep 17 00:00:00 2001 -From: Alan Hicks <ahicks@p-o.co.uk> -Date: Tue, 24 Feb 2015 11:27:45 +0000 -Subject: [PATCH 08/33] Add primary key constraint to dbmail_authlog - ---- - sql/postgresql/create_tables.pgsql | 3 ++- - 1 file changed, 2 insertions(+), 1 deletion(-) - -diff --git sql/postgresql/create_tables.pgsql sql/postgresql/create_tables.pgsql -index da3b694..45740fd 100644 ---- sql/postgresql/create_tables.pgsql -+++ sql/postgresql/create_tables.pgsql -@@ -46,7 +46,8 @@ CREATE TABLE dbmail_authlog ( - dst_port INT8, - status VARCHAR(32) DEFAULT 'active', - bytes_rx INT8 DEFAULT '0' NOT NULL, -- bytes_tx INT8 DEFAULT '0' NOT NULL -+ bytes_tx INT8 DEFAULT '0' NOT NULL, -+ PRIMARY KEY (id) - ); - - --- -2.10.1 (Apple Git-78) - |