diff options
| author | Julien Dessaux | 2024-09-30 00:58:49 +0200 |
|---|---|---|
| committer | Julien Dessaux | 2024-09-30 01:00:59 +0200 |
| commit | 4ff490806c826cf2da4c2291ed924f0a49383fce (patch) | |
| tree | 6870f4883cd03a824095b969500f08fb59f04038 /pkg/database/sql | |
| parent | chore(tfstated): rename tfstate to tfstated (diff) | |
| download | tfstated-4ff490806c826cf2da4c2291ed924f0a49383fce.tar.gz tfstated-4ff490806c826cf2da4c2291ed924f0a49383fce.tar.bz2 tfstated-4ff490806c826cf2da4c2291ed924f0a49383fce.zip | |
feat(tfstated): implement GET and POST methods, states are encrypted in a sqlite3 database
Diffstat (limited to 'pkg/database/sql')
| -rw-r--r-- | pkg/database/sql/000_init.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/pkg/database/sql/000_init.sql b/pkg/database/sql/000_init.sql new file mode 100644 index 0000000..0248896 --- /dev/null +++ b/pkg/database/sql/000_init.sql @@ -0,0 +1,10 @@ +CREATE TABLE schema_version ( + version INTEGER NOT NULL +) STRICT; + +CREATE TABLE states ( + id INTEGER PRIMARY KEY, + name TEXT NOT NULL, + data BLOB NOT NULL +) STRICT; +CREATE UNIQUE INDEX states_name on states(name); |