diff options
author | Kjetil Orbekk <kjetil.orbekk@gmail.com> | 2017-06-19 21:48:52 -0400 |
---|---|---|
committer | Kjetil Orbekk <kjetil.orbekk@gmail.com> | 2017-06-19 21:48:52 -0400 |
commit | f005d0708832c05366110f9523bb522828270a09 (patch) | |
tree | efc3194cd64dae8004960c92da4d6f0342e8e212 /src | |
parent | a65d615c17127fb1d9c37648a37255778a12fa22 (diff) |
Add acls to database schema.
Diffstat (limited to 'src')
-rw-r--r-- | src/db.rs | 17 |
1 files changed, 15 insertions, 2 deletions
@@ -14,12 +14,25 @@ fn is_initialized(conn: &mut Connection) -> Result<bool> { pub fn init(conn: &mut Connection) -> Result<()> { if !is_initialized(conn)? { info!("Initializing db..."); - conn.execute_batch(" + conn.execute_batch(r#" BEGIN; + CREATE TABLE IF NOT EXISTS users (username TEXT PRIMARY KEY, salt TEXT, passwd TEXT); + + CREATE TABLE IF NOT EXISTS acls + (username TEXT NOT NULL, + unit TEXT NOT NULL, + read BOOL, + change BOOL, + PRIMARY KEY (username, unit)); + + INSERT OR IGNORE INTO acls + (username, unit, read, change) VALUES + ('*', '*', 0, 0); + COMMIT; - ") + "#) .unwrap(); } Ok(()) |