From 973ee9056995d1c9e7a533d9999329a70f0d2b2d Mon Sep 17 00:00:00 2001
From: rsanchez <rsanchez@curisit.net>
Date: Wed, 15 Oct 2014 07:49:46 +0000
Subject: [PATCH] #2021 config - Added pack and LicenseType Metadata management

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

diff --git a/securis/src/main/resources/db/schema.sql b/securis/src/main/resources/db/schema.sql
index c52b116..d3fdf49 100644
--- a/securis/src/main/resources/db/schema.sql
+++ b/securis/src/main/resources/db/schema.sql
@@ -48,11 +48,10 @@
 
 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));
+  PRIMARY KEY (license_type_id, key));
 
 drop table IF EXISTS organization;
 CREATE  TABLE IF NOT EXISTS organization (
@@ -85,12 +84,11 @@
   
 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));
+  PRIMARY KEY (pack_id, key));
   
   
 drop table IF EXISTS license;

--
Gitblit v1.3.2