From 4d9a6514a4b2e2c65b2d2b3e515cda3db8efce50 Mon Sep 17 00:00:00 2001
From: David Sommerseth <dazo@users.sourceforge.net>
Date: Thu, 7 Aug 2008 13:41:26 +0200
Subject: Renamed database column from sesskey to sessionkey

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

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

diff --git a/database/sqlite/sql-schema.sql b/database/sqlite/sql-schema.sql
index d387d02..6ce39c7 100644
--- a/database/sqlite/sql-schema.sql
+++ b/database/sqlite/sql-schema.sql
@@ -45,7 +45,7 @@ CREATE TABLE openvpn_lastlog (
        vpnipaddr      varchar(32)  NOT NULL,
        vpnipmask      varchar(32)  NOT NULL,
        sessionstatus  integer      NOT NULL DEFAULT 0,
-       sesskey        varchar(128) ,
+       sessionkey     varchar(128) ,
        login          timestamp    ,
        logout         timestamp    ,
        session_del    timestamp    ,
@@ -53,17 +53,17 @@ CREATE TABLE openvpn_lastlog (
        bytes_received integer      ,
        llid           integer      PRIMARY KEY AUTOINCREMENT
 );
-CREATE UNIQUE INDEX openvpn_lastlog_sesskey ON openvpn_lastlog(sesskey);
+CREATE UNIQUE INDEX openvpn_lastlog_sessionkey ON openvpn_lastlog(sessionkey);
 
 CREATE TABLE openvpn_sessions (
-       sesskey        varchar(128) NOT NULL,
+       sessionkey     varchar(128) NOT NULL,
        datakey        varchar(256) NOT NULL,
        dataval        text         ,
        registered     timestamp    DEFAULT CURRENT_TIMESTAMP,
        sessid         integer      PRIMARY KEY AUTOINCREMENT
 );
-CREATE INDEX openvpn_sessions_sesskey ON openvpn_sessions(sesskey);
-CREATE UNIQUE INDEX openvpn_sessions_sess_datakey ON openvpn_sessions(sesskey, datakey);
+CREATE INDEX openvpn_sessions_sessionkey ON openvpn_sessions(sessionkey);
+CREATE UNIQUE INDEX openvpn_sessions_sess_datakey ON openvpn_sessions(sessionkey, datakey);
 
 CREATE TABLE openvpn_blacklist (
        digest         varchar(64)  ,
-- 
cgit 

