From 141ce30b898c02ee4bf4dd72657be8a123d867f4 Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Thu, 21 Jun 2012 11:13:47 +0200 Subject: Fix syntax error in SQL (oops) --- loader/sql/schema.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/loader/sql/schema.sql b/loader/sql/schema.sql index 1d845c5..54cd676 100644 --- a/loader/sql/schema.sql +++ b/loader/sql/schema.sql @@ -1,3 +1,5 @@ +\set ON_ERROR_STOP on + CREATE TABLE messages ( id SERIAL NOT NULL PRIMARY KEY, parentid int REFERENCES messages, @@ -28,7 +30,7 @@ CREATE UNIQUE INDEX idx_unresolved_msgid_message ON unresolved_messages(msgid, m CREATE TABLE lists( listid int NOT NULL PRIMARY KEY, - listname text NOT NULL UNIQUE, + listname text NOT NULL UNIQUE ); CREATE TABLE list_months( -- cgit v1.2.3