rsanchez
2017-04-03 347803bd8d8349baa0577156896a1ec924a69e6d
securis/src/main/resources/db/schema.sql
....@@ -90,6 +90,7 @@
9090 renew_valid_period INT NOT NULL DEFAULT 30,
9191 created_by varchar(45) NULL ,
9292 creation_timestamp TIMESTAMP NOT NULL default now(),
93
+ frozen BOOLEAN NOT NULL default false,
9394 PRIMARY KEY (id));
9495
9596 drop table IF EXISTS pack_metadata;
....@@ -122,6 +123,7 @@
122123 cancelled_by varchar(45) NULL ,
123124 created_by varchar(45) NULL ,
124125 status VARCHAR(2) NOT NULL default 'CR',
126
+ metadata_obsolete BOOLEAN NOT NULL default false,
125127 PRIMARY KEY (id),
126128 index(request_data_hash, pack_id));
127129