rsanchez
2016-09-22 7f3f69a284d330f28d0740d31763d212bc51b64e
#3296 fix - Increasing matadata value column length
1 files modified
changed files
securis/src/main/resources/db/schema.sql patch | view | blame | history
securis/src/main/resources/db/schema.sql
....@@ -34,7 +34,7 @@
3434 CREATE TABLE IF NOT EXISTS application_metadata (
3535 application_id INT NOT NULL ,
3636 `key` VARCHAR(100) NOT NULL ,
37
- value VARCHAR(200) NULL ,
37
+ value VARCHAR(512) NULL ,
3838 mandatory BOOLEAN NOT NULL default true,
3939 creation_timestamp TIMESTAMP NULL default now(),
4040 PRIMARY KEY (application_id, `key`));
....@@ -54,7 +54,7 @@
5454 CREATE TABLE IF NOT EXISTS licensetype_metadata (
5555 license_type_id INT NOT NULL ,
5656 `key` VARCHAR(100) NOT NULL ,
57
- value VARCHAR(200) NULL ,
57
+ value VARCHAR(512) NULL ,
5858 mandatory BOOLEAN NOT NULL default true,
5959 PRIMARY KEY (license_type_id, `key`));
6060
....@@ -96,7 +96,7 @@
9696 CREATE TABLE IF NOT EXISTS pack_metadata (
9797 pack_id INT NOT NULL ,
9898 `key` VARCHAR(100) NOT NULL ,
99
- value VARCHAR(200) NULL ,
99
+ value VARCHAR(512) NULL ,
100100 readonly BOOlEAN NOT NULL default false,
101101 mandatory BOOLEAN NOT NULL default true,
102102 PRIMARY KEY (pack_id, `key`));