rsanchez
2014-12-11 36edce38f6b17f73322fa38404d6e01818a44fd2
securis/src/main/resources/db/schema.sql
....@@ -85,7 +85,8 @@
8585 license_type_id INT NOT NULL,
8686 organization_id INT NOT NULL,
8787 license_preactivation BOOLEAN NOT NULL DEFAULT true,
88
- default_valid_period INT NOT NULL DEFAULT 60,
88
+ preactivation_valid_period INT NOT NULL DEFAULT 7,
89
+ renew_valid_period INT NOT NULL DEFAULT 30,
8990 created_by varchar(45) NULL ,
9091 creation_timestamp TIMESTAMP NOT NULL default now(),
9192 PRIMARY KEY (id));
....@@ -110,7 +111,7 @@
110111 license_data VARCHAR(1024) NULL ,
111112 pack_id INT NOT NULL,
112113 full_name VARCHAR(150) NULL,
113
- email VARCHAR(100) NOT NULL,
114
+ email VARCHAR(100) NULL,
114115 comments VARCHAR(1024) NULL ,
115116 creation_timestamp TIMESTAMP NOT NULL default now(),
116117 modification_timestamp TIMESTAMP NULL ,