Peter M. Groen / knowledgetree

workflow-into-metadata.sql 581 Bytes
1 2 3 4 5 6 
ALTER TABLE `document_metadata_version` ADD COLUMN `workflow_id` int(11) default NULL;
ALTER TABLE `document_metadata_version` ADD COLUMN `workflow_state_id` int(11) default NULL;
ALTER TABLE `document_metadata_version` ADD INDEX `workflow_id` (`workflow_id`);
ALTER TABLE `document_metadata_version` ADD INDEX `workflow_state_id` (`workflow_state_id`);

UPDATE document_metadata_version AS DC, workflow_documents AS WC, documents AS D SET DC.workflow_id = WC.workflow_id, DC.workflow_state_id = WC.state_id WHERE DC.document_id = WC.document_id AND DC.id = D.metadata_version_id;