--  *********************************************************************
--  Update Database Script
--  *********************************************************************
--  Change Log: /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/upgrade/upgrade.changelog-up-to-0.20.0.xml
--  Ran at: 04/03/15 11:45
--  Against: squashtest_adm@localhost@jdbc:mysql://localhost:3306/squashtest_maint
--  Liquibase version: 2.0.5
--  *********************************************************************

--  Lock Database
--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.19.0.xml::tm-0.19.0.01::ramoussou::(Checksum: 3:a2c617f3cd30d4df478396383ec1120b)
--  We have to set campaign_ID and Test_plan_order to "true" to let hibernate persist new items
CREATE TABLE `CAMPAIGN_TEST_PLAN_ITEM` (`CTPI_ID` BIGINT AUTO_INCREMENT NOT NULL, `CAMPAIGN_ID` BIGINT NULL, `TEST_CASE_ID` BIGINT NOT NULL, `USER_ID` BIGINT NULL, `TEST_PLAN_ORDER` INT NULL, CONSTRAINT `PK_CAMPAIGN_TEST_PLAN_ITEM` PRIMARY KEY (`CTPI_ID`), CONSTRAINT `fk_camp_tp_user` FOREIGN KEY (`USER_ID`) REFERENCES CORE_USER(ID), CONSTRAINT `fk_camp_tp_campaign` FOREIGN KEY (`CAMPAIGN_ID`) REFERENCES CAMPAIGN(CLN_ID), CONSTRAINT `fk_camp_tp_testcase` FOREIGN KEY (`TEST_CASE_ID`) REFERENCES TEST_CASE(TCLN_ID));

CREATE INDEX `idx_camptestplan` ON `CAMPAIGN_TEST_PLAN_ITEM`(`CTPI_ID`);

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('ramoussou', 'We have to set campaign_ID and Test_plan_order to "true" to let hibernate persist new items', NOW(), 'Create Table, Create Index', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.19.0.xml', 'tm-0.19.0.01', '2.0.5', '3:a2c617f3cd30d4df478396383ec1120b', 60);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.19.0.xml::tm-0.19.0.02::ramoussou::(Checksum: 3:bab4e9ace40d3f38f0a909166ffa3543)
--  Migrates data from unordered campaign test plan table to ordered test plan table. 
--  	 		Items which references (soft) deleted test cases and which should not be in the table are not migrated
insert into CAMPAIGN_TEST_PLAN_ITEM (CAMPAIGN_ID, TEST_CASE_ID) 
			select tp.CAMPAIGN_ID, tp.TEST_CASE_ID 
			from CAMPAIGN_TEST_PLAN tp 
				inner join TEST_CASE_LIBRARY_NODE tc on tc.TCLN_ID = tp.TEST_CASE_ID
			where tc.DELETED_ON is null;

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('ramoussou', 'Migrates data from unordered campaign test plan table to ordered test plan table. 
	 		Items which references (soft) deleted test cases and which should not be in the table are not migrated', NOW(), 'Custom SQL', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.19.0.xml', 'tm-0.19.0.02', '2.0.5', '3:bab4e9ace40d3f38f0a909166ffa3543', 61);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.19.0.xml::tm-0.19.0.03::ramoussou::(Checksum: 3:7cf5b162cc14dd208a967e41dfb3ad4e)
--  Calculate and insert and add Not null constraint on order for Campaign Test Plan For H2
--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.19.0.xml::tm-0.19.0.04::ramoussou::(Checksum: 3:905488109451a024de6e2560c5076e65)
--  Calculate and insert and add Not null constraint on order for Campaign Test Plan for myssql
CREATE TEMPORARY TABLE `MIGRATION_CAMPAIGN_TEST_PLAN` (
			`TEST_PLAN_ORDER` BIGINT NULL DEFAULT NULL,
			`CAMPAIGN_ID` BIGINT NULL DEFAULT NULL,
			`TEST_CASE_ID` BIGINT NULL DEFAULT NULL,
			`DUMMY` BIGINT NULL DEFAULT NULL
			);

insert into MIGRATION_CAMPAIGN_TEST_PLAN (TEST_PLAN_ORDER, CAMPAIGN_ID, TEST_CASE_ID, DUMMY)
			select if(@prevcamp=CAMPAIGN_ID, @rownum:=@rownum+1, @rownum:=0) TEST_PLAN_ORDER, CAMPAIGN_ID, TEST_CASE_ID, (@prevcamp:=CAMPAIGN_ID)
			from CAMPAIGN_TEST_PLAN_ITEM ctp, (SELECT @rownum:=0) r, (SELECT @prevcamp:=0) c
			order by CAMPAIGN_ID;

update CAMPAIGN_TEST_PLAN_ITEM citp set TEST_PLAN_ORDER = 
				(select mctp.TEST_PLAN_ORDER from MIGRATION_CAMPAIGN_TEST_PLAN mctp 
				where mctp.CAMPAIGN_ID = citp.CAMPAIGN_ID 
				and mctp.TEST_CASE_ID = citp.TEST_CASE_ID);

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('ramoussou', 'Calculate and insert and add Not null constraint on order for Campaign Test Plan for myssql', NOW(), 'Custom SQL', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.19.0.xml', 'tm-0.19.0.04', '2.0.5', '3:905488109451a024de6e2560c5076e65', 62);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.19.0.xml::tm-0.19.0.04-postgres::mpagnon::(Checksum: 3:8447241e5630abc830696ab5b207c8b2)
--  Calculate and insert and add Not null constraint on order for Campaign Test Plan for postgresql
--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.19.0.xml::tm-0.19.0.06::ramoussou::(Checksum: 3:f9e834dd9a237218a636c461a1f14acb)
--  Drop table CAMPAIGN_TEST_PLAN
DROP TABLE `CAMPAIGN_TEST_PLAN`;

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('ramoussou', 'Drop table CAMPAIGN_TEST_PLAN', NOW(), 'Drop Table', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.19.0.xml', 'tm-0.19.0.06', '2.0.5', '3:f9e834dd9a237218a636c461a1f14acb', 63);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.19.0.xml::tm-0.19.0.07::ramoussou::(Checksum: 3:3464e0eb5a1a382e6691a4f727ec00e0)
ALTER TABLE `ITEM_TEST_PLAN` ADD `USER_ID` BIGINT;

ALTER TABLE `ITEM_TEST_PLAN` ADD CONSTRAINT `fk_itertestplan_user` FOREIGN KEY (`USER_ID`) REFERENCES `CORE_USER` (`ID`);

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('ramoussou', '', NOW(), 'Add Column', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.19.0.xml', 'tm-0.19.0.07', '2.0.5', '3:3464e0eb5a1a382e6691a4f727ec00e0', 64);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.20.0.xml::tm-0.20.0.01::gfouquet::(Checksum: 3:79d0a7f41b244e13231f6617599db287)
--  The PROJECT_ID foreign key in TEST_CASE_LIBRARY is useless, the useful one is in the PROJECT table
ALTER TABLE `TEST_CASE_LIBRARY` DROP FOREIGN KEY `fk_tcl_project`;

ALTER TABLE `TEST_CASE_LIBRARY` DROP COLUMN `PROJECT_ID`;

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('gfouquet', 'The PROJECT_ID foreign key in TEST_CASE_LIBRARY is useless, the useful one is in the PROJECT table', NOW(), 'Drop Foreign Key Constraint, Drop Column', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.20.0.xml', 'tm-0.20.0.01', '2.0.5', '3:79d0a7f41b244e13231f6617599db287', 65);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.20.0.xml::tm-0.20.0.02::gfouquet::(Checksum: 3:90ee0d65007fd13cf852fd74c93cc5ab)
--  The PROJECT_ID foreign key in REQUIREMENT_LIBRARY is useless, the useful one is in the PROJECT table
ALTER TABLE `REQUIREMENT_LIBRARY` DROP FOREIGN KEY `fk_rl_project`;

ALTER TABLE `REQUIREMENT_LIBRARY` DROP COLUMN `PROJECT_ID`;

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('gfouquet', 'The PROJECT_ID foreign key in REQUIREMENT_LIBRARY is useless, the useful one is in the PROJECT table', NOW(), 'Drop Foreign Key Constraint, Drop Column', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.20.0.xml', 'tm-0.20.0.02', '2.0.5', '3:90ee0d65007fd13cf852fd74c93cc5ab', 66);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.20.0.xml::tm-0.20.0.03::gfouquet::(Checksum: 3:2839276f429b636cc801c6e05258e229)
--  The PROJECT_ID foreign key in CAMPAIGN_LIBRARY is useless, the useful one is in the PROJECT table
ALTER TABLE `CAMPAIGN_LIBRARY` DROP FOREIGN KEY `fk_cl_project`;

ALTER TABLE `CAMPAIGN_LIBRARY` DROP COLUMN `PROJECT_ID`;

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('gfouquet', 'The PROJECT_ID foreign key in CAMPAIGN_LIBRARY is useless, the useful one is in the PROJECT table', NOW(), 'Drop Foreign Key Constraint, Drop Column', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.20.0.xml', 'tm-0.20.0.03', '2.0.5', '3:2839276f429b636cc801c6e05258e229', 67);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.20.0.xml::tm-0.20.0.05::bsiri::(Checksum: 3:33f92afafccb2a461ebeee6b06c0d503)
ALTER TABLE `EXECUTION` MODIFY `ISSUE_LIST_ID` BIGINT NULL;

ALTER TABLE `EXECUTION_STEP` MODIFY `ISSUE_LIST_ID` BIGINT NULL;

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('bsiri', '', NOW(), 'Drop Not-Null Constraint (x2)', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.20.0.xml', 'tm-0.20.0.05', '2.0.5', '3:33f92afafccb2a461ebeee6b06c0d503', 68);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.20.0.xml::tm-0.20.0.07::bsiri::(Checksum: 3:01c34eb5d2046c3d206c2658ef6efdb8)
--  add an ondelete set null to the fk campaign test plan item  -> core user
ALTER TABLE `CAMPAIGN_TEST_PLAN_ITEM` DROP FOREIGN KEY `fk_camp_tp_user`;

ALTER TABLE `CAMPAIGN_TEST_PLAN_ITEM` ADD CONSTRAINT `fk_camp_tp_user` FOREIGN KEY (`USER_ID`) REFERENCES `CORE_USER` (`ID`) ON DELETE SET NULL;

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('bsiri', 'add an ondelete set null to the fk campaign test plan item  -> core user', NOW(), 'Drop Foreign Key Constraint, Add Foreign Key Constraint', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.20.0.xml', 'tm-0.20.0.07', '2.0.5', '3:01c34eb5d2046c3d206c2658ef6efdb8', 69);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.20.0.xml::tm-0.20.0.40::gfouquet::(Checksum: 3:ab522a0d38bc1df143c84b75c668820b)
--  Replace the ATTACHMENT_LIST_CONTENT table by a FK in ATTACHMENT
ALTER TABLE `ATTACHMENT` ADD `ATTACHMENT_LIST_ID` BIGINT;

update ATTACHMENT a set ATTACHMENT_LIST_ID = (select AL_ID from ATTACHMENT_LIST_CONTENT alc where
			alc.ATTACHMENT_ID = a.ATTACHMENT_ID);

DROP TABLE `ATTACHMENT_LIST_CONTENT`;

ALTER TABLE `ATTACHMENT` ADD CONSTRAINT `fk_attachment_att_list` FOREIGN KEY (`ATTACHMENT_LIST_ID`) REFERENCES `ATTACHMENT_LIST` (`ATTACHMENT_LIST_ID`);

ALTER TABLE `ATTACHMENT` MODIFY `ATTACHMENT_LIST_ID` BIGINT NOT NULL;

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('gfouquet', 'Replace the ATTACHMENT_LIST_CONTENT table by a FK in ATTACHMENT', NOW(), 'Add Column, Custom SQL, Drop Table, Add Foreign Key Constraint, Add Not-Null Constraint', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.20.0.xml', 'tm-0.20.0.40', '2.0.5', '3:ab522a0d38bc1df143c84b75c668820b', 70);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.20.0.xml::tm-0.20.0.41::gfouquet::(Checksum: 3:726804bd77783ba5146a81d59aaab4ac)
--  Replace the ISSUE_LIST_CONTENT table by a FK in ISSUE
ALTER TABLE `ISSUE` ADD `ISSUE_LIST_ID` BIGINT;

update ISSUE i set ISSUE_LIST_ID = (select ISSUE_LIST_ID from ISSUE_LIST_CONTENT ilc where ilc.ISSUE_ID =
			i.ISSUE_ID);

DROP TABLE `ISSUE_LIST_CONTENT`;

ALTER TABLE `ISSUE` ADD CONSTRAINT `fk_issue_issue_list` FOREIGN KEY (`ISSUE_LIST_ID`) REFERENCES `ISSUE_LIST` (`ISSUE_LIST_ID`);

ALTER TABLE `ISSUE` MODIFY `ISSUE_LIST_ID` BIGINT NOT NULL;

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('gfouquet', 'Replace the ISSUE_LIST_CONTENT table by a FK in ISSUE', NOW(), 'Add Column, Custom SQL, Drop Table, Add Foreign Key Constraint, Add Not-Null Constraint', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.20.0.xml', 'tm-0.20.0.41', '2.0.5', '3:726804bd77783ba5146a81d59aaab4ac', 71);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.20.0.xml::tm-0.20.0.42::gfouquet::(Checksum: 3:0fe189d2c826b59230a2e5fea194ff17)
--  Rename ITEM_TEST_PLAN into ITERATION_TEST_PLAN_ITEM
ALTER TABLE `ITEM_TEST_PLAN` RENAME `ITERATION_TEST_PLAN_ITEM`;

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('gfouquet', 'Rename ITEM_TEST_PLAN into ITERATION_TEST_PLAN_ITEM', NOW(), 'Rename Table', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-0.20.0.xml', 'tm-0.20.0.42', '2.0.5', '3:0fe189d2c826b59230a2e5fea194ff17', 72);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/core/core.changelog-0.20.0.xml::core-0.20.0.01::ramoussou::(Checksum: 3:adfc6dedd979f8e29ab0a0deb61f3a42)
--  Creation of a new table CORE_CONFIG containing Application configuration
CREATE TABLE `CORE_CONFIG` (`STR_KEY` VARCHAR(255) NOT NULL, `VALUE` VARCHAR(32000) NULL, CONSTRAINT `PK_CORE_CONFIG` PRIMARY KEY (`STR_KEY`));

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('ramoussou', 'Creation of a new table CORE_CONFIG containing Application configuration', NOW(), 'Create Table', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/core/core.changelog-0.20.0.xml', 'core-0.20.0.01', '2.0.5', '3:adfc6dedd979f8e29ab0a0deb61f3a42', 73);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/core/core.changelog-0.20.0.xml::core-0.20.0.02::gfouquet::(Checksum: 3:b440864cd51c94293db4c375b14d73b4)
--  Default welcome message
insert into CORE_CONFIG (STR_KEY, VALUE) values ('WELCOME_MESSAGE', '<p><span style="color:#ff0000;">The administrator default login is <strong>admin/admin</strong> (you can change this password in the &quot;<em>My account (admin)</em>&quot; menu).</span></p><p>Go to the &quot;<em>Administration&quot;</em> menu (in the upper right corner) to create new users and projects, or change this default home message.</p><p>&nbsp;</p>');

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('gfouquet', 'Default welcome message', NOW(), 'Custom SQL', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/core/core.changelog-0.20.0.xml', 'core-0.20.0.02', '2.0.5', '3:b440864cd51c94293db4c375b14d73b4', 74);

--  Release Database Lock
--  Release Database Lock
