diff options
| author | David Sommerseth <dazo@users.sourceforge.net> | 2012-01-08 22:54:49 +0100 |
|---|---|---|
| committer | David Sommerseth <dazo@users.sourceforge.net> | 2013-06-13 01:01:55 +0200 |
| commit | 9828725d7c40d26739700e54007a3c22287b2b78 (patch) | |
| tree | 12fa8bbd5dd29d362bdc2f42e11f029c52351d78 /database/postgresql/sql-schema.sql | |
| parent | 8793bd3557e06f1194813e02902f3780ee1ebfb8 (diff) | |
| download | eurephia-9828725d7c40d26739700e54007a3c22287b2b78.tar.gz eurephia-9828725d7c40d26739700e54007a3c22287b2b78.tar.xz eurephia-9828725d7c40d26739700e54007a3c22287b2b78.zip | |
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>
Diffstat (limited to 'database/postgresql/sql-schema.sql')
| -rw-r--r-- | database/postgresql/sql-schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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 |