diff options
| author | David Sommerseth <dazo@users.sourceforge.net> | 2008-08-07 13:41:26 +0200 |
|---|---|---|
| committer | David Sommerseth <dazo@users.sourceforge.net> | 2008-08-07 13:41:26 +0200 |
| commit | 4d9a6514a4b2e2c65b2d2b3e515cda3db8efce50 (patch) | |
| tree | 3e74613b74c740d2d2252f1f9d0d0956fd8e4e59 /database/sqlite/sql-schema.sql | |
| parent | 5dbfe2b930328581ba026bfb5a505d8f36b5afb5 (diff) | |
| download | eurephia-4d9a6514a4b2e2c65b2d2b3e515cda3db8efce50.tar.gz eurephia-4d9a6514a4b2e2c65b2d2b3e515cda3db8efce50.tar.xz eurephia-4d9a6514a4b2e2c65b2d2b3e515cda3db8efce50.zip | |
Renamed database column from sesskey to sessionkey
Diffstat (limited to 'database/sqlite/sql-schema.sql')
| -rw-r--r-- | database/sqlite/sql-schema.sql | 10 |
1 files changed, 5 insertions, 5 deletions
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) , |