diff options
| author | Richard Jones <richard@mechanicalcat.net> | 2013-01-14 14:47:30 +1100 |
|---|---|---|
| committer | Richard Jones <richard@mechanicalcat.net> | 2013-01-14 14:47:30 +1100 |
| commit | b76e48b5c95957755dfdf11ae8369b589038df5a (patch) | |
| tree | 1f87f18f64320da82f1e350fb58a4cfb68510d45 /tools | |
| parent | fdb45019aa70a69652670f6e4ade6e367955ce20 (diff) | |
| download | decorator-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 'tools')
| -rw-r--r-- | tools/sql-migrate-20130114.sql | 1 | ||||
| -rw-r--r-- | tools/sqlite_create.py | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/tools/sql-migrate-20130114.sql b/tools/sql-migrate-20130114.sql new file mode 100644 index 0000000..2ebcbc6 --- /dev/null +++ b/tools/sql-migrate-20130114.sql @@ -0,0 +1 @@ +alter table journals add column id serial; diff --git a/tools/sqlite_create.py b/tools/sqlite_create.py index e04cb2d..b30b0c2 100644 --- a/tools/sqlite_create.py +++ b/tools/sqlite_create.py @@ -46,6 +46,7 @@ cursor.execute(''' )''') cursor.execute(''' create table journals ( + id integer primary key autoincrement, name varchar, version varchar, action varchar, |