From f005d0708832c05366110f9523bb522828270a09 Mon Sep 17 00:00:00 2001
From: Kjetil Orbekk <kjetil.orbekk@gmail.com>
Date: Mon, 19 Jun 2017 21:48:52 -0400
Subject: Add acls to database schema.

---
 src/db.rs | 17 +++++++++++++++--
 1 file changed, 15 insertions(+), 2 deletions(-)

diff --git a/src/db.rs b/src/db.rs
index 872ae60..2cc81e9 100644
--- a/src/db.rs
+++ b/src/db.rs
@@ -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(())
-- 
cgit v1.2.3