diff options
| author | David Sommerseth <dazo@users.sourceforge.net> | 2008-12-02 23:42:21 +0100 |
|---|---|---|
| committer | David Sommerseth <dazo@users.sourceforge.net> | 2008-12-02 23:42:21 +0100 |
| commit | 96b177a197fad3bec1332f2e140cdf3863970cce (patch) | |
| tree | 487f6b393c56c9341e9c9d50815daa62599a64ab /database/sqlite/sql-schema.sql | |
| parent | c2528bc62d571baa4801c1c34e2bb92142c6c7bb (diff) | |
| download | eurephia-96b177a197fad3bec1332f2e140cdf3863970cce.tar.gz eurephia-96b177a197fad3bec1332f2e140cdf3863970cce.tar.xz eurephia-96b177a197fad3bec1332f2e140cdf3863970cce.zip | |
Enhanced the access control by introducing access levels
Diffstat (limited to 'database/sqlite/sql-schema.sql')
| -rw-r--r-- | database/sqlite/sql-schema.sql | 8 |
1 files changed, 7 insertions, 1 deletions
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); |