summaryrefslogtreecommitdiffstats
path: root/database/sqlite
diff options
context:
space:
mode:
authorDavid Sommerseth <dazo@users.sourceforge.net>2008-08-24 21:50:42 +0200
committerDavid Sommerseth <dazo@users.sourceforge.net>2008-08-24 21:50:42 +0200
commit568788a5feab9b54d9692cbe4b20488476a1e34c (patch)
tree7093062b483003e3c3b09fd117dd8031e3bc0f72 /database/sqlite
parent307a77f6a5127c1ae7b08794ea0db07ffb9275c6 (diff)
downloadeurephia-568788a5feab9b54d9692cbe4b20488476a1e34c.tar.gz
eurephia-568788a5feab9b54d9692cbe4b20488476a1e34c.tar.xz
eurephia-568788a5feab9b54d9692cbe4b20488476a1e34c.zip
Reverting last merge, due to failures in merging procedure
Diffstat (limited to 'database/sqlite')
-rw-r--r--database/sqlite/Makefile2
-rw-r--r--database/sqlite/sql-schema.sql6
2 files changed, 4 insertions, 4 deletions
diff --git a/database/sqlite/Makefile b/database/sqlite/Makefile
index fd5bd31..5844ed9 100644
--- a/database/sqlite/Makefile
+++ b/database/sqlite/Makefile
@@ -3,7 +3,7 @@ topdir = ../..
DRIVERVERSION=1.0
DRIVERAPIVERSION=1
-objs = eurephiadb-sqlite.o ../../eurephia_log.o ../../eurephiadb_session.o ../../eurephia_values.o ../../passwd.o ../../sha512.o sqlite.o
+objs = eurephiadb-sqlite.o ../../eurephia_log.o ../../eurephiadb_session.o ../../eurephia_values.o ../../passwd.o ../../sha1.o sqlite.o
driver=eurephiadb-sqlite.so
diff --git a/database/sqlite/sql-schema.sql b/database/sqlite/sql-schema.sql
index a8f9168..6ce39c7 100644
--- a/database/sqlite/sql-schema.sql
+++ b/database/sqlite/sql-schema.sql
@@ -11,7 +11,7 @@ CREATE UNIQUE INDEX opevpn_certificates_digest ON openvpn_certificates(digest);
CREATE TABLE openvpn_users (
username varchar(32) NOT NULL,
- password varchar(128) NOT NULL,
+ password varchar(64) NOT NULL,
activated timestamp ,
deactivated timestamp ,
last_accessed timestamp ,
@@ -91,8 +91,8 @@ CREATE UNIQUE INDEX openvpn_attempts_digest ON openvpn_attempts(digest);
CREATE UNIQUE INDEX openvpn_attempts_remoteip ON openvpn_attempts(remoteip);
CREATE TABLE openvpn_sessionkeys (
- sessionseed varchar(128) NOT NULL,
- sessionkey varchar(128) NOT NULL,
+ sessionseed varchar(64) NOT NULL,
+ sessionkey varchar(64) NOT NULL,
PRIMARY KEY(sessionseed)
);