From 9828725d7c40d26739700e54007a3c22287b2b78 Mon Sep 17 00:00:00 2001 From: David Sommerseth Date: Sun, 8 Jan 2012 22:54:49 +0100 Subject: edb-pgsql: Use correct sessionkey length in macaddr_history The macaddr_history table was declared with a too small field for storing session keys. Signed-off-by: David Sommerseth --- database/postgresql/sql-schema.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'database/postgresql/sql-schema.sql') diff --git a/database/postgresql/sql-schema.sql b/database/postgresql/sql-schema.sql index 3103d34..dc75a82 100644 --- a/database/postgresql/sql-schema.sql +++ b/database/postgresql/sql-schema.sql @@ -98,7 +98,7 @@ CREATE UNIQUE INDEX lastlog_sessionkey ON lastlog(sessionkey); -- Table macaddr_history: This keeps an overview over which MAC addresses a session -- have used, in case the client changes the MAC address. CREATE TABLE macaddr_history ( - sessionkey varchar(64) NOT NULL, + sessionkey varchar(128) NOT NULL, macaddr varchar(20) NOT NULL, registered timestamp DEFAULT CURRENT_TIMESTAMP, semaid SERIAL PRIMARY KEY -- cgit