diff options
| -rw-r--r-- | crates/rocie-server/src/storage/migrate/sql/0->1.sql | 6 | ||||
| -rw-r--r-- | crates/rocie-server/src/storage/sql/get/config/mod.rs | 2 | ||||
| -rw-r--r-- | crates/rocie-server/src/storage/sql/insert/config/mod.rs | 4 |
3 files changed, 7 insertions, 5 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 8f99322..dd7ce5f 100644 --- a/crates/rocie-server/src/storage/migrate/sql/0->1.sql +++ b/crates/rocie-server/src/storage/migrate/sql/0->1.sql @@ -179,9 +179,11 @@ CREATE TABLE txn_log ( operation TEXT NOT NULL ) STRICT; -CREATE TABLE config ( +CREATE TABLE rocie_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); + +INSERT INTO rocie_config (id, use_defaults) +VALUES (0, 0); diff --git a/crates/rocie-server/src/storage/sql/get/config/mod.rs b/crates/rocie-server/src/storage/sql/get/config/mod.rs index eb8be86..92f39c2 100644 --- a/crates/rocie-server/src/storage/sql/get/config/mod.rs +++ b/crates/rocie-server/src/storage/sql/get/config/mod.rs @@ -7,7 +7,7 @@ impl Config { let record = query!( " SELECT use_defaults - FROM config + FROM rocie_config WHERE id = 0 " ) diff --git a/crates/rocie-server/src/storage/sql/insert/config/mod.rs b/crates/rocie-server/src/storage/sql/insert/config/mod.rs index 8c81feb..597e633 100644 --- a/crates/rocie-server/src/storage/sql/insert/config/mod.rs +++ b/crates/rocie-server/src/storage/sql/insert/config/mod.rs @@ -20,7 +20,7 @@ impl Transactionable for Operation { Operation::UseDefault { value, .. } => { query!( " - UPDATE config + UPDATE rocie_config SET use_defaults = ? WHERE id = 0 ", @@ -38,7 +38,7 @@ impl Transactionable for Operation { Operation::UseDefault { old_value, .. } => { query!( " - UPDATE config + UPDATE rocie_config SET use_defaults = ? WHERE id = 0 ", |