From 732ed6d747b49a0d794114ee660e76102ecd9f95 Mon Sep 17 00:00:00 2001
From: David Sommerseth <dazo@users.sourceforge.net>
Date: Sat, 29 Nov 2008 02:50:03 +0100
Subject: Login seems to work from database driver side

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

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

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);
+
-- 
cgit 

