#2021 feature - Added Pack management (in Beta)

rsanchez

2014-10-16 4d18a46ee3ada751517f9bf767d5057a3bf5eb9e

 securis/src/main/resources/db/schema.sql
..
..
@@ -75,6 +75,9 @@
75
75
   id INT NOT NULL auto_increment,
76
76
   code VARCHAR(50) NOT NULL ,
77
77
   num_licenses INT NOT NULL ,
78
+  init_valid_date DATE NOT NULL default today(),
79
+  end_valid_date DATE NOT NULL default today(),
80
+  status VARCHAR(2) NOT NULL default 'PE',
78
81
   comments VARCHAR(1024) NULL ,
79
82
   license_type_id INT NOT NULL,  
80
83
   organization_id INT NOT NULL,