rsanchez
2014-10-23 c4d513ca26fe80946a5d90264de5d8e13e4ea974
securis/src/main/resources/db/schema.sql
....@@ -8,7 +8,7 @@
88 drop table IF EXISTS user;
99 CREATE TABLE IF NOT EXISTS user (
1010 username VARCHAR(45) NOT NULL ,
11
- password VARCHAR(100) NULL ,
11
+ password VARCHAR(256) NULL ,
1212 roles INT NOT NULL default 0,
1313 first_name VARCHAR(100) NULL ,
1414 last_name VARCHAR(100) NULL ,
....@@ -113,12 +113,12 @@
113113 modification_timestamp DATETIME NULL ,
114114 last_access_timestamp DATETIME NULL ,
115115 expiration_date DATETIME NULL ,
116
- canceled_by varchar(45) NULL ,
116
+ cancelled_by varchar(45) NULL ,
117117 created_by varchar(45) NULL ,
118118 status VARCHAR(2) NOT NULL default 'CR',
119119 PRIMARY KEY (id));
120120
121
-create index if not exists lic_hash_req_idx on license(hash_request_data);
121
+create index if not exists lic_hash_req_idx on license(request_data_hash);
122122 create index if not exists lic_pack_idx on license(pack_id);
123123
124124 drop table IF EXISTS license_history;