diff options
| author | Magnus Hagander | 2012-06-21 09:13:47 +0000 |
|---|---|---|
| committer | Magnus Hagander | 2012-06-21 09:13:47 +0000 |
| commit | 141ce30b898c02ee4bf4dd72657be8a123d867f4 (patch) | |
| tree | 57751c969bee9d446f147779f8d7caaaccea2efe | |
| parent | e07d3f690fd763228dd43496ebb5447514101dd3 (diff) | |
Fix syntax error in SQL (oops)
| -rw-r--r-- | loader/sql/schema.sql | 4 |
1 files changed, 3 insertions, 1 deletions
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( |