use TEXT datatype for dumps and reduce artifact column length to 100
This commit is contained in:
parent
bd9058badb
commit
87b2475dc5
|
@ -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;
|
||||
|
|
Reference in New Issue