diff options
| author | David Sommerseth <dazo@users.sourceforge.net> | 2008-11-29 02:50:03 +0100 |
|---|---|---|
| committer | David Sommerseth <dazo@users.sourceforge.net> | 2008-11-29 02:50:03 +0100 |
| commit | 732ed6d747b49a0d794114ee660e76102ecd9f95 (patch) | |
| tree | 067bfeea1593804ce48d37f8d2de9468242ebd11 /database/sqlite/sql-schema.sql | |
| parent | ad77c8cd62ab96e2815e287b74bfc0f50af8b7ae (diff) | |
| download | eurephia-732ed6d747b49a0d794114ee660e76102ecd9f95.tar.gz eurephia-732ed6d747b49a0d794114ee660e76102ecd9f95.tar.xz eurephia-732ed6d747b49a0d794114ee660e76102ecd9f95.zip | |
Login seems to work from database driver side
Diffstat (limited to 'database/sqlite/sql-schema.sql')
| -rw-r--r-- | database/sqlite/sql-schema.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/database/sqlite/sql-schema.sql b/database/sqlite/sql-schema.sql index 81d7ea4..7fb6769 100644 --- a/database/sqlite/sql-schema.sql +++ b/database/sqlite/sql-schema.sql @@ -15,6 +15,7 @@ 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); @@ -114,3 +115,16 @@ CREATE TABLE openvpn_config ( ); CREATE UNIQUE INDEX openvpn_config_key ON openvpn_config(datakey); +CREATE TABLE eurephia_adminlog ( + uid integer NOT NULL, + interface char NOT NULL, -- C-onsole, W-eb + status integer NOT NULL, + login timestamp NOT NULL, + last_action timestamp NOT NULL, + logout timestamp , + sessionkey varchar(128) NOT NULL, + ealid integer PRIMARY KEY AUTOINCREMENT +); +CREATE INDEX eurephia_adminlog_uid ON eurephia_adminlog(uid); +CREATE INDEX eurephia_adminlog_sesskey ON eurephia_adminlog(sessionkey); + |