#2021 feature - Added blocked request table and refactoring License actions

rsanchez

2014-10-22 ddec2c5c7b7842536d6d705c2de20f96e16c8aa8

 securis/src/main/resources/db/schema.sql
..
..
@@ -14,6 +14,7 @@
14
14
   last_name VARCHAR(100) NULL ,
15
15
   last_login DATETIME NULL ,
16
16
   lang VARCHAR(10) NULL ,
17
+  email VARCHAR(150) NULL ,
17
18
   creation_timestamp DATETIME NULL ,  
18
19
   modification_timestamp DATETIME NULL ,  
19
20
   PRIMARY KEY (username));
..
..
@@ -78,7 +79,7 @@
78
79
   num_licenses INT NOT NULL ,
79
80
   init_valid_date DATE NOT NULL default today(),
80
81
   end_valid_date DATE NOT NULL default today(),
81
-  status VARCHAR(2) NOT NULL default 'PE',
82
+  status VARCHAR(2) NOT NULL default 'CR',
82
83
   comments VARCHAR(1024) NULL ,
83
84
   license_type_id INT NOT NULL,  
84
85
   organization_id INT NOT NULL,  
..
..
@@ -113,7 +114,7 @@
113
114
   expiration_date DATETIME NULL ,  
114
115
   canceled_by varchar(45) NULL ,  
115
116
   created_by varchar(45) NULL ,  
116
-  status INT NOT NULL default 0,  
117
+  status VARCHAR(2) NOT NULL default 'CR',  
117
118
   PRIMARY KEY (id));
118
119
   
119
120
   
..
..
@@ -127,5 +128,12 @@
127
128
   comments VARCHAR(512) ,
128
129
   PRIMARY KEY (id));
129
130
   
130
-  
131
-  
131
+   
132
+drop table IF EXISTS blocked_request;
133
+CREATE TABLE IF NOT EXISTS blocked_request (
134
+  hash VARCHAR(256) NOT NULL ,
135
+  request_data VARCHAR(1024) NULL ,
136
+  blocked_by varchar(45) NULL ,  
137
+  creation_timestamp DATETIME NOT NULL default now(),  
138
+  PRIMARY KEY (id));
139
+