From 4d18a46ee3ada751517f9bf767d5057a3bf5eb9e Mon Sep 17 00:00:00 2001
From: rsanchez <rsanchez@curisit.net>
Date: Thu, 16 Oct 2014 18:16:33 +0000
Subject: [PATCH] #2021 feature - Added Pack management (in Beta) 

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

diff --git a/securis/src/main/resources/db/schema.sql b/securis/src/main/resources/db/schema.sql
index b6337b0..b249a28 100644
--- a/securis/src/main/resources/db/schema.sql
+++ b/securis/src/main/resources/db/schema.sql
@@ -75,6 +75,9 @@
   id INT NOT NULL auto_increment,
   code VARCHAR(50) NOT NULL ,
   num_licenses INT NOT NULL ,
+  init_valid_date DATE NOT NULL default today(),
+  end_valid_date DATE NOT NULL default today(),
+  status VARCHAR(2) NOT NULL default 'PE',
   comments VARCHAR(1024) NULL ,
   license_type_id INT NOT NULL,  
   organization_id INT NOT NULL,  

--
Gitblit v1.3.2