From 6d8aff7b3657332020ef215eb1b2fc16017e4cc8 Mon Sep 17 00:00:00 2001
From: Roberto Sánchez <roberto.sanchez@curisit.net>
Date: Sun, 26 Jan 2014 13:34:03 +0000
Subject: [PATCH] #395 feature - Added license history entity and new angular directive to load file content

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

diff --git a/securis/src/main/resources/db/schema.sql b/securis/src/main/resources/db/schema.sql
index 813b45a..4860b61 100644
--- a/securis/src/main/resources/db/schema.sql
+++ b/securis/src/main/resources/db/schema.sql
@@ -76,14 +76,22 @@
   email VARCHAR(100)  NOT NULL,  
   comments VARCHAR(1024) NULL ,
   creation_timestamp DATETIME NOT 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) NOT NULL default 0,  
+  status INT NOT NULL default 0,  
+  PRIMARY KEY (id));
+  
+  
+drop table IF EXISTS license_history;
+CREATE TABLE IF NOT EXISTS license_history (
+  id INT NOT NULL auto_increment,
+  license_id INT NOT NULL,
+  username VARCHAR(45) NOT NULL,
+  timestamp DATETIME NOT NULL ,
+  action VARCHAR(40) , 
+  comments VARCHAR(512) ,
   PRIMARY KEY (id));
   
   

--
Gitblit v1.3.2