CheckExtract

by 
String typeName
;
<CheckExtract>
select locked from extractlock where 
if(length(@typeName) > 0, type = @typeName, 1=1)
order by locked desc limit 1
;

Manages status of the ‘extractlock’ based on extract type

Has potential as entity_extract_(type)

Actions

1.Rename Table

RENAME TABLE `extractlock` TO `entity_extract_type`;

2. ADD New columns

ALTER TABLE entity_extract_type
ADD COLUMN create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER elId

ALTER TABLE entity_extract_type
ADD COLUMN modified_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER create_date

ALTER TABLE entity_extract_type
ADD COLUMN authored_by VARCHAR(32) DEFAULT 'system' AFTER modified_date

ALTER TABLE entity_extract
ADD COLUMN sort_order int DEFAULT 0 AFTER authored_by

ALTER TABLE entity_extract_type
ADD COLUMN item_desc VARCHAR(64)  AFTER type

ALTER TABLE entity_extract_type
ADD COLUMN item_label VARCHAR(32)  AFTER item_desc

ALTER TABLE `entity_extract_type`
CHANGE COLUMN `type` `item_name` VARCHAR(45) NULL DEFAULT NULL COLLATE 'utf8_general_ci' AFTER `locked`;

ALTER TABLE `entity_extract_type`
ADD UNIQUE INDEX `item_name` (`item_name`);

3. Alter Code

CheckExtract.txt

String typeName
;
<CheckExtract>
select locked from entity_extract_type where 
if(length(@typeName) > 0, item_name = @typeName, 1=1)
order by locked desc limit 1
;

Leave a Comment