From 9828725d7c40d26739700e54007a3c22287b2b78 Mon Sep 17 00:00:00 2001
From: David Sommerseth <dazo@users.sourceforge.net>
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 <dazo@users.sourceforge.net>
---
 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 

