summaryrefslogtreecommitdiffstats
path: root/database/sqlite
diff options
context:
space:
mode:
authorDavid Sommerseth <dazo@users.sourceforge.net>2008-08-21 08:24:30 +0200
committerDavid Sommerseth <dazo@users.sourceforge.net>2008-08-21 08:24:30 +0200
commit6bf468dcee9252251d9aecacecf5d42b335f610d (patch)
treecfd7ee8837107e90d0a0e9ee127811718523faf5 /database/sqlite
parentd21a340a5594f0ebe31d4ae2345444312b8a1ca0 (diff)
downloadeurephia-6bf468dcee9252251d9aecacecf5d42b335f610d.tar.gz
eurephia-6bf468dcee9252251d9aecacecf5d42b335f610d.tar.xz
eurephia-6bf468dcee9252251d9aecacecf5d42b335f610d.zip
Changed from SHA1 hash to SHA512.
Using code from the SourceForge.net project: sha https://sourceforge.net/projects/sha/ Written by Allan Saddi. Wrote today to the developer and asked for permission to include sha512.[ch] under the BSD licence in this GPLv2 project. If it is denied, I'll need to find another SHA512 implementation.
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 5844ed9..fd5bd31 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 ../../sha1.o sqlite.o
+objs = eurephiadb-sqlite.o ../../eurephia_log.o ../../eurephiadb_session.o ../../eurephia_values.o ../../passwd.o ../../sha512.o sqlite.o
driver=eurephiadb-sqlite.so
diff --git a/database/sqlite/sql-schema.sql b/database/sqlite/sql-schema.sql
index 6ce39c7..a8f9168 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(64) NOT NULL,
+ password varchar(128) 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(64) NOT NULL,
- sessionkey varchar(64) NOT NULL,
+ sessionseed varchar(128) NOT NULL,
+ sessionkey varchar(128) NOT NULL,
PRIMARY KEY(sessionseed)
);