From fb1b6755a9ecd43601dc4fbef9166d11d8a86f24 Mon Sep 17 00:00:00 2001
From: rsanchez <rsanchez@curisit.net>
Date: Tue, 14 Oct 2014 16:25:10 +0000
Subject: [PATCH] #2021 config - Added application Metadata management

---
 securis/src/main/resources/db/schema.sql |   27 +++++++++++++++++++++++++++
 1 files changed, 27 insertions(+), 0 deletions(-)

diff --git a/securis/src/main/resources/db/schema.sql b/securis/src/main/resources/db/schema.sql
index 96fcb49..c52b116 100644
--- a/securis/src/main/resources/db/schema.sql
+++ b/securis/src/main/resources/db/schema.sql
@@ -26,6 +26,15 @@
   creation_timestamp DATETIME NULL ,  
   PRIMARY KEY (id));
 
+drop table IF EXISTS application_metadata;
+CREATE TABLE IF NOT EXISTS application_metadata (
+  application_id INT NOT NULL ,
+  key VARCHAR(100) NOT NULL ,
+  value VARCHAR(200) NULL ,
+  mandatory BOOLEAN NOT NULL default true,
+  creation_timestamp DATETIME NOT NULL ,  
+  PRIMARY KEY (application_id, key));
+
 
 drop table IF EXISTS license_type;
 CREATE  TABLE IF NOT EXISTS license_type (
@@ -35,6 +44,14 @@
   description VARCHAR(100) NULL ,
   application_id INT NULL ,
   creation_timestamp DATETIME NULL ,  
+  PRIMARY KEY (id));
+
+drop table IF EXISTS licensetype_metadata;
+CREATE TABLE IF NOT EXISTS licensetype_metadata (
+  id INT NOT NULL auto_increment,
+  license_type_id INT NOT NULL ,
+  key VARCHAR(100) NOT NULL ,
+  value VARCHAR(200) NULL ,
   PRIMARY KEY (id));
 
 drop table IF EXISTS organization;
@@ -66,6 +83,16 @@
   creation_timestamp DATETIME NOT NULL ,  
   PRIMARY KEY (id));
   
+drop table IF EXISTS pack_metadata;
+CREATE TABLE IF NOT EXISTS pack_metadata (
+  id INT NOT NULL auto_increment,
+  pack_id INT NOT NULL ,
+  key VARCHAR(100) NOT NULL ,
+  value VARCHAR(200) NULL ,
+  readonly BOOlEAN NOT NULL default false,
+  PRIMARY KEY (id));
+  
+  
 drop table IF EXISTS license;
 CREATE TABLE IF NOT EXISTS license (
   id INT NOT NULL auto_increment,

--
Gitblit v1.3.2