diff options
Diffstat (limited to 'pkg/database/sql/000_init.sql')
| -rw-r--r-- | pkg/database/sql/000_init.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/pkg/database/sql/000_init.sql b/pkg/database/sql/000_init.sql index 3530e52..0e52c60 100644 --- a/pkg/database/sql/000_init.sql +++ b/pkg/database/sql/000_init.sql @@ -24,7 +24,7 @@ CREATE TABLE sessions ( ) STRICT; CREATE TABLE states ( - id INTEGER PRIMARY KEY, + id TEXT PRIMARY KEY, path TEXT NOT NULL, lock TEXT, created INTEGER DEFAULT (unixepoch()), @@ -33,9 +33,9 @@ CREATE TABLE states ( CREATE UNIQUE INDEX states_path on states(path); CREATE TABLE versions ( - id INTEGER PRIMARY KEY, + id TEXT PRIMARY KEY, account_id TEXT NOT NULL, - state_id INTEGER, + state_id TEXT, data BLOB, lock TEXT, created INTEGER DEFAULT (unixepoch()), |