#2021 feature - Upgtaded Jackson annotations version and added request data...

rsanchez

2014-10-23 bc2cedc83f6353259ea1364f98ce60bf11d7ecf4

 securis/src/main/resources/db/schema.sql
..
..
@@ -103,6 +103,7 @@
103
103
   id INT NOT NULL auto_increment,
104
104
   code VARCHAR(100) NOT NULL ,
105
105
   request_data VARCHAR(1024) NULL ,
106
+  request_data_hash VARCHAR(64) NULL ,
106
107
   license_data VARCHAR(1024) NULL ,
107
108
   pack_id INT NOT NULL,  
108
109
   full_name VARCHAR(150) NULL,  
..
..
@@ -116,7 +117,9 @@
116
117
   created_by varchar(45) NULL ,  
117
118
   status VARCHAR(2) NOT NULL default 'CR',  
118
119
   PRIMARY KEY (id));
119
-  
120
+
121
+create index if not exists lic_hash_req_idx on license(hash_request_data);  
122
+create index if not exists lic_pack_idx on license(pack_id);  
120
123
   
121
124
 drop table IF EXISTS license_history;
122
125
 CREATE TABLE IF NOT EXISTS license_history (
..
..
@@ -131,9 +134,9 @@
131
134
    
132
135
 drop table IF EXISTS blocked_request;
133
136
 CREATE TABLE IF NOT EXISTS blocked_request (
134
-  hash VARCHAR(256) NOT NULL ,
137
+  hash VARCHAR(64) NOT NULL ,
135
138
   request_data VARCHAR(1024) NULL ,
136
139
   blocked_by varchar(45) NULL ,  
137
140
   creation_timestamp DATETIME NOT NULL default now(),  
138
-  PRIMARY KEY (id));
141
+  PRIMARY KEY (hash));
139
142