diff options
| author | Benedikt Peetz <benedikt.peetz@b-peetz.de> | 2026-03-19 02:42:02 +0100 |
|---|---|---|
| committer | Benedikt Peetz <benedikt.peetz@b-peetz.de> | 2026-03-19 02:42:02 +0100 |
| commit | 6df299c87ba8faab75626d04392f874ec642c8dc (patch) | |
| tree | 64744ae2dea2c726d72589ce290e88679e60c564 /crates/rocie-server/src/storage/migrate/sql/0->1.sql | |
| parent | chore(rocie-client): Re-generate the client api (diff) | |
| download | server-6df299c87ba8faab75626d04392f874ec642c8dc.zip | |
feat(rocie-server): Provide default units (and other changes)
Diffstat (limited to 'crates/rocie-server/src/storage/migrate/sql/0->1.sql')
| -rw-r--r-- | crates/rocie-server/src/storage/migrate/sql/0->1.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/crates/rocie-server/src/storage/migrate/sql/0->1.sql b/crates/rocie-server/src/storage/migrate/sql/0->1.sql index ba44c68..8f99322 100644 --- a/crates/rocie-server/src/storage/migrate/sql/0->1.sql +++ b/crates/rocie-server/src/storage/migrate/sql/0->1.sql @@ -178,3 +178,10 @@ CREATE TABLE txn_log ( timestamp INTEGER NOT NULL, operation TEXT NOT NULL ) STRICT; + +CREATE TABLE config ( + -- Make it impossible to insert more than one value here. + id INTEGER PRIMARY KEY NOT NULL CHECK (id = 0), + use_defaults INTEGER NOT NULL CHECK (use_defaults = 1 OR use_defaults = 0) +) STRICT; +INSERT INTO config (id, use_defaults) VALUES (0, 0); |