blob: 5b2c8001e631408581779c560a8edf8b5dd9f88e (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
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)
|
