#2021 config - Added application Metadata management

rsanchez

2014-10-14 fb1b6755a9ecd43601dc4fbef9166d11d8a86f24

 securis/src/main/resources/db/schema.sql
..
..
@@ -26,6 +26,15 @@
26
26
   creation_timestamp DATETIME NULL ,  
27
27
   PRIMARY KEY (id));
28
28
 
29
+drop table IF EXISTS application_metadata;
30
+CREATE TABLE IF NOT EXISTS application_metadata (
31
+  application_id INT NOT NULL ,
32
+  key VARCHAR(100) NOT NULL ,
33
+  value VARCHAR(200) NULL ,
34
+  mandatory BOOLEAN NOT NULL default true,
35
+  creation_timestamp DATETIME NOT NULL ,  
36
+  PRIMARY KEY (application_id, key));
37
+
29
38
 
30
39
 drop table IF EXISTS license_type;
31
40
 CREATE  TABLE IF NOT EXISTS license_type (
..
..
@@ -35,6 +44,14 @@
35
44
   description VARCHAR(100) NULL ,
36
45
   application_id INT NULL ,
37
46
   creation_timestamp DATETIME NULL ,  
47
+  PRIMARY KEY (id));
48
+
49
+drop table IF EXISTS licensetype_metadata;
50
+CREATE TABLE IF NOT EXISTS licensetype_metadata (
51
+  id INT NOT NULL auto_increment,
52
+  license_type_id INT NOT NULL ,
53
+  key VARCHAR(100) NOT NULL ,
54
+  value VARCHAR(200) NULL ,
38
55
   PRIMARY KEY (id));
39
56
 
40
57
 drop table IF EXISTS organization;
..
..
@@ -66,6 +83,16 @@
66
83
   creation_timestamp DATETIME NOT NULL ,  
67
84
   PRIMARY KEY (id));
68
85
   
86
+drop table IF EXISTS pack_metadata;
87
+CREATE TABLE IF NOT EXISTS pack_metadata (
88
+  id INT NOT NULL auto_increment,
89
+  pack_id INT NOT NULL ,
90
+  key VARCHAR(100) NOT NULL ,
91
+  value VARCHAR(200) NULL ,
92
+  readonly BOOlEAN NOT NULL default false,
93
+  PRIMARY KEY (id));
94
+  
95
+  
69
96
 drop table IF EXISTS license;
70
97
 CREATE TABLE IF NOT EXISTS license (
71
98
   id INT NOT NULL auto_increment,