From bc2cedc83f6353259ea1364f98ce60bf11d7ecf4 Mon Sep 17 00:00:00 2001
From: rsanchez <rsanchez@curisit.net>
Date: Thu, 23 Oct 2014 12:06:14 +0000
Subject: [PATCH] #2021 feature - Upgtaded Jackson annotations version and added request data hash management
---
securis/src/main/resources/db/schema.sql | 9 ++++++---
1 files changed, 6 insertions(+), 3 deletions(-)
diff --git a/securis/src/main/resources/db/schema.sql b/securis/src/main/resources/db/schema.sql
index d16fde7..1d4b2d9 100644
--- a/securis/src/main/resources/db/schema.sql
+++ b/securis/src/main/resources/db/schema.sql
@@ -103,6 +103,7 @@
id INT NOT NULL auto_increment,
code VARCHAR(100) NOT NULL ,
request_data VARCHAR(1024) NULL ,
+ request_data_hash VARCHAR(64) NULL ,
license_data VARCHAR(1024) NULL ,
pack_id INT NOT NULL,
full_name VARCHAR(150) NULL,
@@ -116,7 +117,9 @@
created_by varchar(45) NULL ,
status VARCHAR(2) NOT NULL default 'CR',
PRIMARY KEY (id));
-
+
+create index if not exists lic_hash_req_idx on license(hash_request_data);
+create index if not exists lic_pack_idx on license(pack_id);
drop table IF EXISTS license_history;
CREATE TABLE IF NOT EXISTS license_history (
@@ -131,9 +134,9 @@
drop table IF EXISTS blocked_request;
CREATE TABLE IF NOT EXISTS blocked_request (
- hash VARCHAR(256) NOT NULL ,
+ hash VARCHAR(64) NOT NULL ,
request_data VARCHAR(1024) NULL ,
blocked_by varchar(45) NULL ,
creation_timestamp DATETIME NOT NULL default now(),
- PRIMARY KEY (id));
+ PRIMARY KEY (hash));
\ No newline at end of file
--
Gitblit v1.3.2