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.

1 files changed, 3 insertions, 3 deletions

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