From c3d9abdd3cd55a12d6509ade288648c2408baeb5 Mon Sep 17 00:00:00 2001
From: Roberto Sánchez <roberto.sanchez@curisit.net>
Date: Mon, 27 Jan 2014 11:18:59 +0000
Subject: [PATCH] #395 feature - Added expiration date to license and automatic preactivation flag

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

diff --git a/securis/src/main/resources/db/schema.sql b/securis/src/main/resources/db/schema.sql
index 4860b61..96fcb49 100644
--- a/securis/src/main/resources/db/schema.sql
+++ b/securis/src/main/resources/db/schema.sql
@@ -61,6 +61,7 @@
   comments VARCHAR(1024) NULL ,
   license_type_id INT NOT NULL,  
   organization_id INT NOT NULL,  
+  license_preactivation BOOLEAN NOT NULL DEFAULT true,  
   created_by varchar(45) NULL ,  
   creation_timestamp DATETIME NOT NULL ,  
   PRIMARY KEY (id));
@@ -78,6 +79,7 @@
   creation_timestamp DATETIME NOT NULL ,  
   modification_timestamp DATETIME NULL ,  
   last_access_timestamp DATETIME NULL ,  
+  expiration_date DATETIME NULL ,  
   canceled_by varchar(45) NULL ,  
   created_by varchar(45) NULL ,  
   status INT NOT NULL default 0,  

--
Gitblit v1.3.2