diff options
| author | Julien Dessaux | 2025-02-22 13:35:17 +0100 |
|---|---|---|
| committer | Julien Dessaux | 2025-02-22 13:35:17 +0100 |
| commit | 6fd1663d8c27fbfd5adc93a3aa973f78a2eeb719 (patch) | |
| tree | c2e5afc41acdf42cd4a43a324c80bd35ad714261 /pkg/database/sql | |
| parent | chore(webui): refactored state creation page and route (diff) | |
| download | tfstated-6fd1663d8c27fbfd5adc93a3aa973f78a2eeb719.tar.gz tfstated-6fd1663d8c27fbfd5adc93a3aa973f78a2eeb719.tar.bz2 tfstated-6fd1663d8c27fbfd5adc93a3aa973f78a2eeb719.zip | |
Diffstat (limited to 'pkg/database/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()), |