From 04afd774aecc70dca37559fdd8b9a716829c18cd Mon Sep 17 00:00:00 2001
From: Roberto Sánchez <roberto.sanchez@curisit.net>
Date: Fri, 17 Jan 2014 12:27:16 +0000
Subject: [PATCH] #396 feature - Added LocalStorage support and http interceptor for unauthorized access

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

diff --git a/securis/src/main/resources/db/schema.sql b/securis/src/main/resources/db/schema.sql
index e13879a..ee3bda6 100644
--- a/securis/src/main/resources/db/schema.sql
+++ b/securis/src/main/resources/db/schema.sql
@@ -68,16 +68,20 @@
 CREATE TABLE IF NOT EXISTS license (
   id INT NOT NULL,
   code VARCHAR(100) NOT NULL ,
+  request_data VARCHAR(1024) NULL ,
+  license_data VARCHAR(1024) NULL ,
   pack_id INT NOT NULL,  
-  user_name INT NULL,  
-  user_email INT NOT NULL,  
+  full_name VARCHAR(150) NULL,  
+  email VARCHAR(100)  NOT NULL,  
   creation_timestamp DATETIME NOT NULL ,  
-  sent_timestamp DATETIME NULL ,  
+  send_timestamp DATETIME NULL ,  
   modification_timestamp DATETIME NULL ,  
+  activation_timestamp DATETIME NULL ,  
   cancelation_timestamp DATETIME NULL ,  
+  last_access_timestamp DATETIME NULL ,  
   canceled_by varchar(45) NULL ,  
   created_by varchar(45) NULL ,  
-  status VARCHAR(3) NULL ,  
+  status VARCHAR(3) NOT NULL default 0,  
   PRIMARY KEY (id));
   
   

--
Gitblit v1.3.2