From ddec2c5c7b7842536d6d705c2de20f96e16c8aa8 Mon Sep 17 00:00:00 2001 From: rsanchez <rsanchez@curisit.net> Date: Wed, 22 Oct 2014 17:38:57 +0000 Subject: [PATCH] #2021 feature - Added blocked request table and refactoring License actions --- 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 2741405..d16fde7 100644 --- a/securis/src/main/resources/db/schema.sql +++ b/securis/src/main/resources/db/schema.sql @@ -14,6 +14,7 @@ last_name VARCHAR(100) NULL , last_login DATETIME NULL , lang VARCHAR(10) NULL , + email VARCHAR(150) NULL , creation_timestamp DATETIME NULL , modification_timestamp DATETIME NULL , PRIMARY KEY (username)); @@ -78,7 +79,7 @@ num_licenses INT NOT NULL , init_valid_date DATE NOT NULL default today(), end_valid_date DATE NOT NULL default today(), - status VARCHAR(2) NOT NULL default 'PE', + status VARCHAR(2) NOT NULL default 'CR', comments VARCHAR(1024) NULL , license_type_id INT NOT NULL, organization_id INT NOT NULL, @@ -113,7 +114,7 @@ expiration_date DATETIME NULL , canceled_by varchar(45) NULL , created_by varchar(45) NULL , - status INT NOT NULL default 0, + status VARCHAR(2) NOT NULL default 'CR', PRIMARY KEY (id)); @@ -127,5 +128,12 @@ comments VARCHAR(512) , PRIMARY KEY (id)); - - \ No newline at end of file + +drop table IF EXISTS blocked_request; +CREATE TABLE IF NOT EXISTS blocked_request ( + hash VARCHAR(256) NOT NULL , + request_data VARCHAR(1024) NULL , + blocked_by varchar(45) NULL , + creation_timestamp DATETIME NOT NULL default now(), + PRIMARY KEY (id)); + \ No newline at end of file -- Gitblit v1.3.2