repos / git-pr

commit

c687eee

parent

117e1ea

author

Eric Bower

date

2024-06-24 23:20:08 -0400 EDT

feat: acl

 1@@ -68,12 +68,24 @@ type DB struct {
 2 var schema = `
 3 CREATE TABLE IF NOT EXISTS app_users (
 4   id INTEGER PRIMARY KEY AUTOINCREMENT,
 5-  pubkey TEXT NOT NULL,
 6-  name TEXT NOT NULL,
 7+  pubkey UNIQUE TEXT NOT NULL,
 8+  name UNIQUE TEXT NOT NULL,
 9   created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
10-  updated_at DATETIME NOT NULL
11+  updated_at DATETIME NOT NULL,
12 );
13 
14+CREATE TABLE IF NOT EXISTS acl {
15+  id INTEGER PRIMARY KEY AUTOINCREMENT,
16+  user_id INTEGER,
17+  ip_address string,
18+  permission string,
19+  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
20+  CONSTRAINT acl_user_id_fk
21+    FOREIGN KEY(user_id) REFERENCES app_users(id)
22+    ON DELETE CASCADE
23+    ON UPDATE CASCADE
24+}
25+
26 CREATE TABLE IF NOT EXISTS patch_requests (
27   id INTEGER PRIMARY KEY AUTOINCREMENT,
28   user_id INTEGER NOT NULL,