diff options
Diffstat (limited to 'database/sqlite')
| -rw-r--r-- | database/sqlite/Makefile | 2 | ||||
| -rw-r--r-- | database/sqlite/sql-schema.sql | 6 |
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) ); |