--  SQL file representing changes to the functionalities model
--  Generated at Thu Oct 12 20:17:26 WEST 2006
--  DO NOT EDIT THIS FILE, run the generating script instead

--  Preamble

START TRANSACTION;

-- 
--  Deleting functionalities
-- 

--  ID: 15 UUID: '27767d03-18ec-40c1-b28e-c45f594d6572'
DELETE FROM ap USING `AVAILABILITY_POLICY` AS ap, `FUNCTIONALITY` AS f WHERE ap.`KEY_FUNCTIONALITY` = f.`ID_INTERNAL` AND f.`UUID` = '27767d03-18ec-40c1-b28e-c45f594d6572';
DELETE FROM `FUNCTIONALITY` WHERE `UUID` = '27767d03-18ec-40c1-b28e-c45f594d6572';

--  ID: 17 UUID: 'a4b9c5f0-a451-400b-a4f5-064f80b0ea0a'
DELETE FROM ap USING `AVAILABILITY_POLICY` AS ap, `FUNCTIONALITY` AS f WHERE ap.`KEY_FUNCTIONALITY` = f.`ID_INTERNAL` AND f.`UUID` = 'a4b9c5f0-a451-400b-a4f5-064f80b0ea0a';
DELETE FROM `FUNCTIONALITY` WHERE `UUID` = 'a4b9c5f0-a451-400b-a4f5-064f80b0ea0a';

--  ID: 18 UUID: '8215581c-3601-48bb-a2df-bd70baef2091'
DELETE FROM ap USING `AVAILABILITY_POLICY` AS ap, `FUNCTIONALITY` AS f WHERE ap.`KEY_FUNCTIONALITY` = f.`ID_INTERNAL` AND f.`UUID` = '8215581c-3601-48bb-a2df-bd70baef2091';
DELETE FROM `FUNCTIONALITY` WHERE `UUID` = '8215581c-3601-48bb-a2df-bd70baef2091';

--  ID: 19 UUID: '4c18159d-ea92-4dc0-910a-8ee6e0bb862e'
DELETE FROM ap USING `AVAILABILITY_POLICY` AS ap, `FUNCTIONALITY` AS f WHERE ap.`KEY_FUNCTIONALITY` = f.`ID_INTERNAL` AND f.`UUID` = '4c18159d-ea92-4dc0-910a-8ee6e0bb862e';
DELETE FROM `FUNCTIONALITY` WHERE `UUID` = '4c18159d-ea92-4dc0-910a-8ee6e0bb862e';

-- 
--  Updating existing functionalities
-- 

--  ID: 1 UUID: 'ca8c9543-646b-4706-8465-f41345cfadf2'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 1 WHERE own.`UUID` = 'ca8c9543-646b-4706-8465-f41345cfadf2';

--  ID: 2 UUID: '6e83db7e-efb1-4e2f-9127-3b5e6ca05904'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 2 WHERE own.`UUID` = '6e83db7e-efb1-4e2f-9127-3b5e6ca05904';

--  ID: 3 UUID: 'd30ed02d-2d26-4736-8e14-4184595cedd5'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 3 WHERE own.`UUID` = 'd30ed02d-2d26-4736-8e14-4184595cedd5';

--  ID: 4 UUID: '123c9a8e-de47-4b4f-9543-a38116c03b54'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 4 WHERE own.`UUID` = '123c9a8e-de47-4b4f-9543-a38116c03b54';

--  ID: 5 UUID: '6a97cab2-491d-4e9f-a876-3a15d1d1033f'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 5 WHERE own.`UUID` = '6a97cab2-491d-4e9f-a876-3a15d1d1033f';

--  ID: 6 UUID: '9f33514d-c6c3-4acb-b1ca-a02980128d90'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 6 WHERE own.`UUID` = '9f33514d-c6c3-4acb-b1ca-a02980128d90';

--  ID: 7 UUID: 'ffa828bb-e3d5-4b3d-9996-39b4cb226ba8'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 7 WHERE own.`UUID` = 'ffa828bb-e3d5-4b3d-9996-39b4cb226ba8';

--  ID: 8 UUID: '3cc0ecf4-b897-48d7-925c-af865f028b9b'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 8 WHERE own.`UUID` = '3cc0ecf4-b897-48d7-925c-af865f028b9b';

--  ID: 9 UUID: '85ce6f13-fddd-44dd-941e-25a1c2dd857e'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 9 WHERE own.`UUID` = '85ce6f13-fddd-44dd-941e-25a1c2dd857e';

--  ID: 10 UUID: '232d33c1-c50a-418b-a61f-c652539b90cf'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 10 WHERE own.`UUID` = '232d33c1-c50a-418b-a61f-c652539b90cf';

--  ID: 11 UUID: '36496cce-ebc4-4a27-b16e-a408672f0bf6'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 11 WHERE own.`UUID` = '36496cce-ebc4-4a27-b16e-a408672f0bf6';

--  ID: 12 UUID: '4d6686aa-9e47-4a47-a08a-a37d69f94eb5'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 12 WHERE own.`UUID` = '4d6686aa-9e47-4a47-a08a-a37d69f94eb5';

--  ID: 48 UUID: 'a219a6ee-798a-43ed-928f-d071c419a6a6'
UPDATE `FUNCTIONALITY` AS own SET own.`NAME` = 'pt31:Edição de Informação Curricularen30:Editing Curricular Information' WHERE own.`UUID` = 'a219a6ee-798a-43ed-928f-d071c419a6a6';

--  ID: 216 UUID: '9ba1269a-0b8f-4daa-bde2-abbd0132327b'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 13 WHERE own.`UUID` = '9ba1269a-0b8f-4daa-bde2-abbd0132327b';

--  ID: 217 UUID: '63bb3ae4-d1a0-4fc7-be16-ae25918a8831'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 14 WHERE own.`UUID` = '63bb3ae4-d1a0-4fc7-be16-ae25918a8831';

--  ID: 218 UUID: '05edef46-6c85-4361-b35e-017d73f9bd6c'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 15 WHERE own.`UUID` = '05edef46-6c85-4361-b35e-017d73f9bd6c';

--  ID: 219 UUID: '64d01274-211d-49c1-b1ed-aa07a368efd2'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 16 WHERE own.`UUID` = '64d01274-211d-49c1-b1ed-aa07a368efd2';

--  ID: 220 UUID: 'b5d85b58-d775-4fca-8f0c-30e2fdb60cba'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 17 WHERE own.`UUID` = 'b5d85b58-d775-4fca-8f0c-30e2fdb60cba';

--  ID: 221 UUID: 'ec219d83-2928-4c5f-84ea-28768c22d5bd'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 18 WHERE own.`UUID` = 'ec219d83-2928-4c5f-84ea-28768c22d5bd';

--  ID: 222 UUID: '264b6a46-3a52-4935-9094-88be1fbfb33d'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 19 WHERE own.`UUID` = '264b6a46-3a52-4935-9094-88be1fbfb33d';

--  ID: 223 UUID: '97805947-1f30-4780-8fc6-ee283514f534'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 20 WHERE own.`UUID` = '97805947-1f30-4780-8fc6-ee283514f534';

--  ID: 224 UUID: '2375facd-190c-49f0-a011-9350502e6e54'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 21 WHERE own.`UUID` = '2375facd-190c-49f0-a011-9350502e6e54';

--  ID: 225 UUID: '615aa695-c4e3-445c-b63b-7ea40768b4f9'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 22 WHERE own.`UUID` = '615aa695-c4e3-445c-b63b-7ea40768b4f9';

--  ID: 226 UUID: '30316818-7aaf-4b0c-a770-6ac47463fd09'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 23 WHERE own.`UUID` = '30316818-7aaf-4b0c-a770-6ac47463fd09';

--  ID: 227 UUID: 'fcf57231-df5b-4173-8db3-46bf9676ef9f'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 24 WHERE own.`UUID` = 'fcf57231-df5b-4173-8db3-46bf9676ef9f';

--  ID: 228 UUID: 'd63322ea-b9c3-402a-85b1-07577df66635'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 25 WHERE own.`UUID` = 'd63322ea-b9c3-402a-85b1-07577df66635';

--  ID: 229 UUID: '20ae78b6-6c5a-4705-b5f5-e233862178ca'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 26 WHERE own.`UUID` = '20ae78b6-6c5a-4705-b5f5-e233862178ca';

--  ID: 230 UUID: 'e5325cd5-5fd1-4213-af66-42fc9ed00892'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 27 WHERE own.`UUID` = 'e5325cd5-5fd1-4213-af66-42fc9ed00892';

--  ID: 231 UUID: '353e875a-75c6-40c9-92bf-88de23686f08'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 28 WHERE own.`UUID` = '353e875a-75c6-40c9-92bf-88de23686f08';

--  ID: 232 UUID: '35fc54d5-7ae9-4195-ad94-be98894ce012'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 29 WHERE own.`UUID` = '35fc54d5-7ae9-4195-ad94-be98894ce012';

--  ID: 233 UUID: '2fc34f7f-e879-42b7-936a-e9d60db53875'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 30 WHERE own.`UUID` = '2fc34f7f-e879-42b7-936a-e9d60db53875';

--  ID: 234 UUID: 'ebad2636-7c48-402d-944e-95bc587724be'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 31 WHERE own.`UUID` = 'ebad2636-7c48-402d-944e-95bc587724be';

--  ID: 235 UUID: '315334e8-bfd5-4d19-b4c2-4097393d7dda'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 32 WHERE own.`UUID` = '315334e8-bfd5-4d19-b4c2-4097393d7dda';

--  ID: 236 UUID: 'eabed4f4-7a0b-4e77-8edb-e8525857f934'
UPDATE `FUNCTIONALITY` AS own SET own.`ORDER_IN_MODULE` = 33 WHERE own.`UUID` = 'eabed4f4-7a0b-4e77-8edb-e8525857f934';

-- 
--  Inserting new functionalities
-- 

--  ID: 252 UUID: '9cf56518-f706-4854-b28e-2108ba374c43'
INSERT INTO `FUNCTIONALITY` (`UUID`, `OJB_CONCRETE_CLASS`, `KEY_ROOT_DOMAIN_OBJECT`, `KEY_PARENT`, `KEY_MODULE`, `KEY_AVAILABILITY_POLICY`, `NAME`, `TITLE`, `DESCRIPTION`, `PATH`, `PREFIX`, `RELATIVE`, `ENABLED`, `PARAMETERS`, `ORDER_IN_MODULE`, `VISIBLE`, `MAXIMIZED`, `PRINCIPAL`) SELECT '9cf56518-f706-4854-b28e-2108ba374c43', 'net.sourceforge.fenixedu.domain.functionalities.Module', 1, NULL, NULL, NULL, 'pt11:Comunicaçãoen9:Messaging', NULL, NULL, '/messaging/index.do', '/messaging', 1, 1, NULL, 0, 1, 0, 1;

COMMIT;
