From 79121484b7e6f721f5435a102018152a164ed655 Mon Sep 17 00:00:00 2001
From: Roberto Sánchez <roberto.sanchez@curisit.net>
Date: Wed, 22 Jan 2014 18:55:29 +0000
Subject: [PATCH] #395 feature - Implemented pack section

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

diff --git a/securis/src/main/resources/db/schema.sql b/securis/src/main/resources/db/schema.sql
index ee3bda6..813b45a 100644
--- a/securis/src/main/resources/db/schema.sql
+++ b/securis/src/main/resources/db/schema.sql
@@ -55,9 +55,10 @@
   
 drop table IF EXISTS pack;
 CREATE  TABLE IF NOT EXISTS pack (
-  id INT NOT NULL,
+  id INT NOT NULL auto_increment,
   code VARCHAR(50) NOT NULL ,
   num_licenses INT NOT NULL ,
+  comments VARCHAR(1024) NULL ,
   license_type_id INT NOT NULL,  
   organization_id INT NOT NULL,  
   created_by varchar(45) NULL ,  
@@ -66,13 +67,14 @@
   
 drop table IF EXISTS license;
 CREATE TABLE IF NOT EXISTS license (
-  id INT NOT NULL,
+  id INT NOT NULL auto_increment,
   code VARCHAR(100) NOT NULL ,
   request_data VARCHAR(1024) NULL ,
   license_data VARCHAR(1024) NULL ,
   pack_id INT NOT NULL,  
   full_name VARCHAR(150) NULL,  
   email VARCHAR(100)  NOT NULL,  
+  comments VARCHAR(1024) NULL ,
   creation_timestamp DATETIME NOT NULL ,  
   send_timestamp DATETIME NULL ,  
   modification_timestamp DATETIME NULL ,  

--
Gitblit v1.3.2