--  *********************************************************************
--  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-1.2.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-1.2.0.xml::tm-1.2.0.32::mpagnon::(Checksum: 3:90da51d034265bddab458bf2cb1340e6)
INSERT INTO `ACL_GROUP` (`QUALIFIED_NAME`) VALUES ('squashtest.acl.group.tm.ProjectManager');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project'), '32');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project'), '2');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project'), '4');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project'), '8');

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', '', NOW(), 'Insert Row (x6)', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.32', '2.0.5', '3:90da51d034265bddab458bf2cb1340e6', 104);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.34-1::mpagnon::(Checksum: 3:7ec2104ebfaac35cfc9daac99d3a9326)
--  add acl-class and acl-groups
INSERT INTO `ACL_CLASS` (`CLASSNAME`) VALUES ('org.squashtest.csp.tm.domain.requirement.RequirementLibrary');

INSERT INTO `ACL_CLASS` (`CLASSNAME`) VALUES ('org.squashtest.csp.tm.domain.testcase.TestCaseLibrary');

INSERT INTO `ACL_CLASS` (`CLASSNAME`) VALUES ('org.squashtest.csp.tm.domain.campaign.CampaignLibrary');

INSERT INTO `ACL_GROUP` (`QUALIFIED_NAME`) VALUES ('squashtest.acl.group.tm.TestRunner');

INSERT INTO `ACL_GROUP` (`QUALIFIED_NAME`) VALUES ('squashtest.acl.group.tm.TestDesigner');

INSERT INTO `ACL_GROUP` (`QUALIFIED_NAME`) VALUES ('squashtest.acl.group.tm.AdvanceTester');

INSERT INTO `ACL_GROUP` (`QUALIFIED_NAME`) VALUES ('squashtest.acl.group.tm.Validator');

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'add acl-class and acl-groups', NOW(), 'Insert Row (x7)', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.34-1', '2.0.5', '3:7ec2104ebfaac35cfc9daac99d3a9326', 105);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.34-2::mpagnon::(Checksum: 3:e89ca0317424a04b6fd94396619224a6)
--  remove existing permissions and redefine them
TRUNCATE TABLE ACL_GROUP_PERMISSION;

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'remove existing permissions and redefine them', NOW(), 'Custom SQL', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.34-2', '2.0.5', '3:e89ca0317424a04b6fd94396619224a6', 106);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.34-3::mpagnon::(Checksum: 3:225504bd6a738b6d974968be183c87f2)
--  ProjectManager / CampaignLibrary
INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project'), '32');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '2');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '4');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '8');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '64');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '256');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '512');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '1024');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '2');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '4');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '8');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '64');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '256');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '512');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '1024');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '2');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '4');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '8');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '64');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '128');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '256');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectManager'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '1024');

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'ProjectManager / CampaignLibrary', NOW(), 'Insert Row (x26)', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.34-3', '2.0.5', '3:225504bd6a738b6d974968be183c87f2', 107);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.34-4::mpagnon::(Checksum: 3:0b1e26bb09cae69721b814e68ab3e85b)
--  TestEditor / CampaignLibrary
INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '2');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '4');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '8');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '64');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '256');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '1024');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '2');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '4');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '8');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '64');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '256');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '1024');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '2');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '4');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '8');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '64');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '128');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '256');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestEditor'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '1024');

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'TestEditor / CampaignLibrary', NOW(), 'Insert Row (x23)', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.34-4', '2.0.5', '3:0b1e26bb09cae69721b814e68ab3e85b', 108);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.34-5::mpagnon::(Checksum: 3:978f35b6b98e4c777664656ca5842573)
--  ProjectViewer / CampaignLibrary
INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectViewer'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectViewer'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectViewer'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.ProjectViewer'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '1');

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'ProjectViewer / CampaignLibrary', NOW(), 'Insert Row (x4)', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.34-5', '2.0.5', '3:978f35b6b98e4c777664656ca5842573', 109);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.34-6::mpagnon::(Checksum: 3:bee4f7ed123e4e6a36f03f51f9167c98)
--  TestRunner / CampaignLibrary
INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestRunner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestRunner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestRunner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestRunner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '128');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestRunner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '1024');

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'TestRunner / CampaignLibrary', NOW(), 'Insert Row (x5)', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.34-6', '2.0.5', '3:bee4f7ed123e4e6a36f03f51f9167c98', 110);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.34-7::mpagnon::(Checksum: 3:a80fff3186b159d8f7d260916f70bd9a)
--  TestDesigner / CampaignLibrary
INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestDesigner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestDesigner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestDesigner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '2');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestDesigner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '4');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestDesigner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '8');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestDesigner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '64');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestDesigner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '256');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestDesigner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '1024');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestDesigner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestDesigner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '2');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestDesigner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '4');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestDesigner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '8');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestDesigner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '64');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestDesigner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '256');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestDesigner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '1024');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.TestDesigner'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '1');

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'TestDesigner / CampaignLibrary', NOW(), 'Insert Row (x16)', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.34-7', '2.0.5', '3:a80fff3186b159d8f7d260916f70bd9a', 111);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.34-8::mpagnon::(Checksum: 3:3c3a9108132480e399c803596ae9c4f2)
--  AdvanceTester / CampaignLibrary
INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.AdvanceTester'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.AdvanceTester'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.AdvanceTester'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.AdvanceTester'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '2');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.AdvanceTester'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '64');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.AdvanceTester'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '1024');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.AdvanceTester'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.AdvanceTester'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '2');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.AdvanceTester'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '4');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.AdvanceTester'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '8');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.AdvanceTester'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '64');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.AdvanceTester'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '128');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.AdvanceTester'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '256');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.AdvanceTester'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '1024');

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'AdvanceTester / CampaignLibrary', NOW(), 'Insert Row (x14)', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.34-8', '2.0.5', '3:3c3a9108132480e399c803596ae9c4f2', 112);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.34-9::mpagnon::(Checksum: 3:e3fcbf536483063022c4843f78d506c1)
--  Validator / CampaignLibrary
INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.Validator'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.Validator'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.Validator'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'), '64');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.Validator'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '1');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.Validator'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'), '64');

INSERT INTO `ACL_GROUP_PERMISSION` (`ACL_GROUP_ID`, `CLASS_ID`, `PERMISSION_MASK`) VALUES ((select ID from ACL_GROUP where QUALIFIED_NAME = 'squashtest.acl.group.tm.Validator'), (select ID from ACL_CLASS where CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'), '1');

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'Validator / CampaignLibrary', NOW(), 'Insert Row (x6)', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.34-9', '2.0.5', '3:e3fcbf536483063022c4843f78d506c1', 113);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.34-10::mpagnon::(Checksum: 3:bef756c0b744c1e235e17add47210541)
--  Existing Data Update: Delete acls for deleted projects in 1.1.1
DELETE FROM ACL_RESPONSIBILITY_SCOPE_ENTRY
			 WHERE OBJECT_IDENTITY_ID not in (
				select aoi.ID from  ACL_OBJECT_IDENTITY aoi, ACL_CLASS ac , PROJECT p
				where ac.CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project' 
				and ac.ID = aoi.CLASS_ID
				and aoi.IDENTITY = p.PROJECT_ID
			);

DELETE FROM ACL_OBJECT_IDENTITY
			WHERE IDENTITY not in (
				select  p.PROJECT_ID from PROJECT p
			)
			and CLASS_ID in (
				select ac.ID from ACL_CLASS ac where ac.CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project' 
			);

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'Existing Data Update: Delete acls for deleted projects in 1.1.1', NOW(), 'Custom SQL (x2)', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.34-10', '2.0.5', '3:bef756c0b744c1e235e17add47210541', 114);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.34-11::mpagnon::(Checksum: 3:7e07f9d4d5ad2ab698697ce5fb344295)
--  Existing Data Update for ACL_OBJECT_IDENTITY / REQUIREMENT_LIBRARY
insert into ACL_OBJECT_IDENTITY (IDENTITY, CLASS_ID)
			select p.RL_ID, ac2.ID
			from  ACL_CLASS ac1, ACL_CLASS ac2, PROJECT p, ACL_OBJECT_IDENTITY aoi
			where ac2.CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary'
			and p.PROJECT_ID = aoi.IDENTITY
			and aoi.CLASS_ID = ac1.ID 
			and ac1.CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project';

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'Existing Data Update for ACL_OBJECT_IDENTITY / REQUIREMENT_LIBRARY', NOW(), 'Custom SQL', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.34-11', '2.0.5', '3:7e07f9d4d5ad2ab698697ce5fb344295', 115);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.34-12::mpagnon::(Checksum: 3:e341c11b9ecf86ac6c7680940391a38b)
--  Existing Data Update for ACL_OBJECT_IDENTITY / TEST_CASE_LIBRARY
insert into ACL_OBJECT_IDENTITY (IDENTITY, CLASS_ID)
			select p.TCL_ID, ac2.ID
			from  ACL_CLASS ac1, ACL_CLASS ac2, PROJECT p, ACL_OBJECT_IDENTITY aoi
			where ac2.CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary'
			and p.PROJECT_ID = aoi.IDENTITY
			and aoi.CLASS_ID = ac1.ID 
			and ac1.CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project';

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'Existing Data Update for ACL_OBJECT_IDENTITY / TEST_CASE_LIBRARY', NOW(), 'Custom SQL', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.34-12', '2.0.5', '3:e341c11b9ecf86ac6c7680940391a38b', 116);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.34-13::mpagnon::(Checksum: 3:33f76b9ba0f7f5f328b3c31f01b02a65)
--  Existing Data Update for ACL_OBJECT_IDENTITY / CAMPAIGN_LIBRARY
insert into ACL_OBJECT_IDENTITY (IDENTITY, CLASS_ID)
			select p.CL_ID, ac2.ID
			from  ACL_CLASS ac1, ACL_CLASS ac2, PROJECT p, ACL_OBJECT_IDENTITY aoi
			where ac2.CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary'
			and p.PROJECT_ID = aoi.IDENTITY
			and aoi.CLASS_ID = ac1.ID 
			and ac1.CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project';

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'Existing Data Update for ACL_OBJECT_IDENTITY / CAMPAIGN_LIBRARY', NOW(), 'Custom SQL', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.34-13', '2.0.5', '3:33f76b9ba0f7f5f328b3c31f01b02a65', 117);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.34-14::mpagnon::(Checksum: 3:6497fdb66ae815d8badaffaf328f8bce)
--  Existing Data Update for ACL_RESPONSIBILITY_SCOPE_ENTRY / REQUIREMENT_LIBRARY
insert into ACL_RESPONSIBILITY_SCOPE_ENTRY (USER_ID, ACL_GROUP_ID, OBJECT_IDENTITY_ID)
			select arse.USER_ID, arse.ACL_GROUP_ID, aoiRequirement.ID
			from ACL_RESPONSIBILITY_SCOPE_ENTRY arse, ACL_OBJECT_IDENTITY aoiProject, ACL_CLASS aclassProject, ACL_OBJECT_IDENTITY aoiRequirement, ACL_CLASS aclassRequirement, PROJECT p
			where arse.OBJECT_IDENTITY_ID = aoiProject.ID
			and aoiProject.CLASS_ID = aclassProject.ID
			and aclassProject.CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project'
			and p.PROJECT_ID = aoiProject.IDENTITY
			and aoiRequirement.IDENTITY = p.RL_ID
			and aoiRequirement.CLASS_ID = aclassRequirement.ID
			and aclassRequirement.CLASSNAME = 'org.squashtest.csp.tm.domain.requirement.RequirementLibrary';

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'Existing Data Update for ACL_RESPONSIBILITY_SCOPE_ENTRY / REQUIREMENT_LIBRARY', NOW(), 'Custom SQL', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.34-14', '2.0.5', '3:6497fdb66ae815d8badaffaf328f8bce', 118);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.34-15::mpagnon::(Checksum: 3:a5201760a6e03f033820401b3f488a7d)
--  Existing Data Update for ACL_RESPONSIBILITY_SCOPE_ENTRY / TEST_CASE_LIBRARY
insert into ACL_RESPONSIBILITY_SCOPE_ENTRY (USER_ID, ACL_GROUP_ID, OBJECT_IDENTITY_ID)
			select arse.USER_ID, arse.ACL_GROUP_ID, aoiTestCase.ID
			from ACL_RESPONSIBILITY_SCOPE_ENTRY arse, ACL_OBJECT_IDENTITY aoiProject, ACL_CLASS aclassProject, ACL_OBJECT_IDENTITY aoiTestCase, ACL_CLASS aclassTestCase, PROJECT p
			where arse.OBJECT_IDENTITY_ID = aoiProject.ID
			and aoiProject.CLASS_ID = aclassProject.ID
			and aclassProject.CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project'
			and p.PROJECT_ID = aoiProject.IDENTITY
			and aoiTestCase.IDENTITY = p.TCL_ID
			and aoiTestCase.CLASS_ID = aclassTestCase.ID
			and aclassTestCase.CLASSNAME = 'org.squashtest.csp.tm.domain.testcase.TestCaseLibrary';

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'Existing Data Update for ACL_RESPONSIBILITY_SCOPE_ENTRY / TEST_CASE_LIBRARY', NOW(), 'Custom SQL', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.34-15', '2.0.5', '3:a5201760a6e03f033820401b3f488a7d', 119);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.34-16::mpagnon::(Checksum: 3:cba831d75d165c2cfa3feb789de74ef9)
--  Existing Data Update for ACL_RESPONSIBILITY_SCOPE_ENTRY / CAMPAIGN_LIBRARY
insert into ACL_RESPONSIBILITY_SCOPE_ENTRY (USER_ID, ACL_GROUP_ID, OBJECT_IDENTITY_ID)
			select arse.USER_ID, arse.ACL_GROUP_ID, aoiCampaign.ID
			from ACL_RESPONSIBILITY_SCOPE_ENTRY arse, ACL_OBJECT_IDENTITY aoiProject, ACL_CLASS aclassProject, ACL_OBJECT_IDENTITY aoiCampaign, ACL_CLASS aclassCampaign, PROJECT p
			where arse.OBJECT_IDENTITY_ID = aoiProject.ID
			and aoiProject.CLASS_ID = aclassProject.ID
			and aclassProject.CLASSNAME = 'org.squashtest.csp.tm.domain.project.Project'
			and p.PROJECT_ID = aoiProject.IDENTITY
			and aoiCampaign.IDENTITY = p.CL_ID
			and aoiCampaign.CLASS_ID = aclassCampaign.ID
			and aclassCampaign.CLASSNAME = 'org.squashtest.csp.tm.domain.campaign.CampaignLibrary';

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'Existing Data Update for ACL_RESPONSIBILITY_SCOPE_ENTRY / CAMPAIGN_LIBRARY', NOW(), 'Custom SQL', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.34-16', '2.0.5', '3:cba831d75d165c2cfa3feb789de74ef9', 120);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.35-01::bsiri::(Checksum: 3:82a94192242d975538bbc05704aec87d)
--  table ISSUE nows holds the bugtracker name where the remote issues are hosted
ALTER TABLE `ISSUE` ADD `BT_NAME` VARCHAR(60) NOT NULL;

UPDATE `ISSUE` SET `BT_NAME` = 'default';

CREATE INDEX `idx_bt_name` ON `ISSUE`(`BT_NAME`);

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('bsiri', 'table ISSUE nows holds the bugtracker name where the remote issues are hosted', NOW(), 'Add Column, Create Index', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.35-01', '2.0.5', '3:82a94192242d975538bbc05704aec87d', 121);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.36-01::mpagnon::(Checksum: 3:1b5fcef232cf2faab752bd448469dc0c)
--  table RequirementVersion nows holds a Category attribute
ALTER TABLE `REQUIREMENT_VERSION` ADD `CATEGORY` VARCHAR(50) NOT NULL DEFAULT 'UNDEFINED';

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'table RequirementVersion nows holds a Category attribute', NOW(), 'Add Column', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.36-01', '2.0.5', '3:1b5fcef232cf2faab752bd448469dc0c', 122);

--  Changeset /var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml::tm-1.2.0.36-02::mpagnon::(Checksum: 3:3360838ead20282ef502404a7fefc830)
--  table Test-Case nows holds a Reference attribute
ALTER TABLE `TEST_CASE` ADD `REFERENCE` VARCHAR(20) NOT NULL DEFAULT '';

INSERT INTO `DATABASECHANGELOG` (`AUTHOR`, `COMMENTS`, `DATEEXECUTED`, `DESCRIPTION`, `EXECTYPE`, `FILENAME`, `ID`, `LIQUIBASE`, `MD5SUM`, `ORDEREXECUTED`) VALUES ('mpagnon', 'table Test-Case nows holds a Reference attribute', NOW(), 'Add Column', 'EXECUTED', '/var/lib/jenkins/jobs/build-squash-tm-distros/workspace/standalone/target/maven-shared-archive-resources/tm/tm.changelog-1.2.0.xml', 'tm-1.2.0.36-02', '2.0.5', '3:3360838ead20282ef502404a7fefc830', 123);

--  Release Database Lock
--  Release Database Lock
