From 96b177a197fad3bec1332f2e140cdf3863970cce Mon Sep 17 00:00:00 2001
From: David Sommerseth <dazo@users.sourceforge.net>
Date: Tue, 2 Dec 2008 23:42:21 +0100
Subject: Enhanced the access control by introducing access levels

---
 database/sqlite/sql-schema.sql | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

(limited to 'database/sqlite/sql-schema.sql')

diff --git a/database/sqlite/sql-schema.sql b/database/sqlite/sql-schema.sql
index 7fb6769..7f0d1af 100644
--- a/database/sqlite/sql-schema.sql
+++ b/database/sqlite/sql-schema.sql
@@ -15,7 +15,6 @@ CREATE TABLE openvpn_users (
        activated     timestamp    ,
        deactivated   timestamp    ,
        last_accessed timestamp    ,
-       acc_admin     boolean      ,
        uid           integer      PRIMARY KEY AUTOINCREMENT
 );
 CREATE UNIQUE INDEX openvpn_users_uname ON openvpn_users(username);
@@ -128,3 +127,10 @@ CREATE TABLE eurephia_adminlog (
 CREATE INDEX eurephia_adminlog_uid ON eurephia_adminlog(uid);
 CREATE INDEX eurephia_adminlog_sesskey ON eurephia_adminlog(sessionkey);
 
+CREATE TABLE eurephia_adminaccess (
+       uid            integer     NOT NULL,
+       interface      char        NOT NULL,  -- C-onsole, W-eb
+       access         varchar(64) NOT NULL
+);
+CREATE INDEX eurephia_adminacc_uid ON eurephia_adminaccess (uid);
+CREATE INDEX eurephia_adminacc_uid_intf ON eurephia_adminaccess (uid,interface);
-- 
cgit 

