#395 feature - Implemented pack section

Roberto Sánchez

2014-01-22 79121484b7e6f721f5435a102018152a164ed655

 securis/src/main/resources/db/schema.sql
..
..
@@ -55,9 +55,10 @@
55
55
   
56
56
 drop table IF EXISTS pack;
57
57
 CREATE  TABLE IF NOT EXISTS pack (
58
-  id INT NOT NULL,
58
+  id INT NOT NULL auto_increment,
59
59
   code VARCHAR(50) NOT NULL ,
60
60
   num_licenses INT NOT NULL ,
61
+  comments VARCHAR(1024) NULL ,
61
62
   license_type_id INT NOT NULL,  
62
63
   organization_id INT NOT NULL,  
63
64
   created_by varchar(45) NULL ,  
..
..
@@ -66,13 +67,14 @@
66
67
   
67
68
 drop table IF EXISTS license;
68
69
 CREATE TABLE IF NOT EXISTS license (
69
-  id INT NOT NULL,
70
+  id INT NOT NULL auto_increment,
70
71
   code VARCHAR(100) NOT NULL ,
71
72
   request_data VARCHAR(1024) NULL ,
72
73
   license_data VARCHAR(1024) NULL ,
73
74
   pack_id INT NOT NULL,  
74
75
   full_name VARCHAR(150) NULL,  
75
76
   email VARCHAR(100)  NOT NULL,  
77
+  comments VARCHAR(1024) NULL ,
76
78
   creation_timestamp DATETIME NOT NULL ,  
77
79
   send_timestamp DATETIME NULL ,  
78
80
   modification_timestamp DATETIME NULL ,