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, 26 insertions, 0 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 new file mode 100644 index 000000000000..5b2c8001e631 --- /dev/null +++ b/mail/dbmail/files/patch-0008-Add-primary-key-constraint-to-dbmail_authlog @@ -0,0 +1,26 @@ +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) + |