use TEXT datatype for dumps and reduce artifact column length to 100

This commit is contained in:
fpeters 2004-09-17 09:17:21 +00:00
parent bd9058badb
commit 87b2475dc5
1 changed files with 4 additions and 4 deletions

View File

@ -9,13 +9,13 @@
CREATE TABLE users (
user_id varchar(100) primary key,
user_dump varchar(5000),
session_dump varchar(5000)
user_dump text,
session_dump text
);
CREATE TABLE assertions (
artifact varchar(5000),
assertion varchar(5000)
artifact varchar(100),
assertion text
);
GRANT DELETE, INSERT, SELECT, UPDATE ON nameidentifiers TO idpc;