summaryrefslogtreecommitdiff
path: root/pkgbase_schema.sql
diff options
context:
space:
mode:
authorRichard Jones <richard@mechanicalcat.net>2013-01-14 14:47:30 +1100
committerRichard Jones <richard@mechanicalcat.net>2013-01-14 14:47:30 +1100
commitb76e48b5c95957755dfdf11ae8369b589038df5a (patch)
tree1f87f18f64320da82f1e350fb58a4cfb68510d45 /pkgbase_schema.sql
parentfdb45019aa70a69652670f6e4ade6e367955ce20 (diff)
downloaddecorator-b76e48b5c95957755dfdf11ae8369b589038df5a.tar.gz
update for new id column added to journals (to aid making journal rows unique in the face of duplicate activity)
Diffstat (limited to 'pkgbase_schema.sql')
-rw-r--r--pkgbase_schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/pkgbase_schema.sql b/pkgbase_schema.sql
index abad7a0..f5c9db4 100644
--- a/pkgbase_schema.sql
+++ b/pkgbase_schema.sql
@@ -64,6 +64,7 @@ CREATE INDEX rego_otk_otk_idx ON rego_otk(otk);
-- Table structure for table: journals
CREATE TABLE journals (
+ id SERIAL,
name TEXT,
version TEXT,
action TEXT,