INSERT INTO NODE (NODE_ORDER,ASCENDING,VISIBLE,CONTENT_ID,KEY_ROOT_DOMAIN_OBJECT,KEY_PARENT,KEY_CHILD,OJB_CONCRETE_CLASS) VALUES (0,1,1,'65e23f693ef3282401aee832a4619e0e:fdd1d1ca-6da9-43b5-ae2e-b251229d842c',1,1,2,'net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode')  ;

UPDATE NODE SET NODE_ORDER=5,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:4ed4d84c-263f-4847-bedc-5f7df53f845f',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=3,KEY_CHILD=4,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:4ed4d84c-263f-4847-bedc-5f7df53f845f'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:c1f83c82-e52c-4ef3-a990-0f7966aacf16',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=5,KEY_CHILD=6,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:c1f83c82-e52c-4ef3-a990-0f7966aacf16'  ;

UPDATE NODE SET NODE_ORDER=16,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:592f20ab097893241348101697514a71',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=7,KEY_CHILD=8,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:592f20ab097893241348101697514a71'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:b803b190-293a-439e-bfb2-8831f586b6ba',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=9,KEY_CHILD=10,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:b803b190-293a-439e-bfb2-8831f586b6ba'  ;

UPDATE NODE SET NODE_ORDER=7,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:6dfbae767183e66ebeb8b63e57ac84ce',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=11,KEY_CHILD=12,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:6dfbae767183e66ebeb8b63e57ac84ce'  ;

UPDATE NODE SET NODE_ORDER=6,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:a4b037ab-1c71-4015-a7a0-385e27dba21a',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=13,KEY_CHILD=14,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:a4b037ab-1c71-4015-a7a0-385e27dba21a'  ;

UPDATE NODE SET NODE_ORDER=21,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:9b85bd677aaa13d973ac06a8052a5e86',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=15,KEY_CHILD=16,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:9b85bd677aaa13d973ac06a8052a5e86'  ;

UPDATE NODE SET NODE_ORDER=22,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:0379a4f669d516191a3471dffa6b6010',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=17,KEY_CHILD=18,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:0379a4f669d516191a3471dffa6b6010'  ;

UPDATE NODE SET NODE_ORDER=8,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:d091e4cb-549b-4c90-aa64-19316dde8da9',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=19,KEY_CHILD=20,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:d091e4cb-549b-4c90-aa64-19316dde8da9'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=0,CONTENT_ID='07e13208e2bb5697b7c6c378ef4471ba:65e23f693ef3282401aee832a4619e0e',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=21,KEY_CHILD=22,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '07e13208e2bb5697b7c6c378ef4471ba:65e23f693ef3282401aee832a4619e0e'  ;

UPDATE NODE SET NODE_ORDER=9,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:51c9d0f5-3380-46b3-94b2-2b202ea28a00',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=23,KEY_CHILD=24,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:51c9d0f5-3380-46b3-94b2-2b202ea28a00'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:fdd1d1ca-6da9-43b5-ae2e-b251229d842c',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=25,KEY_CHILD=26,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:fdd1d1ca-6da9-43b5-ae2e-b251229d842c'  ;

UPDATE NODE SET NODE_ORDER=11,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:23393306d6da5ad5313d322e32d2fb0f',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=27,KEY_CHILD=28,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:23393306d6da5ad5313d322e32d2fb0f'  ;

UPDATE NODE SET NODE_ORDER=9,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:9ab7b6541d1d6c3191c74f181c5910a0',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=29,KEY_CHILD=30,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:9ab7b6541d1d6c3191c74f181c5910a0'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='07e13208e2bb5697b7c6c378ef4471ba:8d123cd3-b4ce-4152-9860-ab3b1b8ab900',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=31,KEY_CHILD=32,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '07e13208e2bb5697b7c6c378ef4471ba:8d123cd3-b4ce-4152-9860-ab3b1b8ab900'  ;

UPDATE NODE SET NODE_ORDER=20,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:b845e4cec80d742dd65c0f07ad87c25d',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=33,KEY_CHILD=34,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:b845e4cec80d742dd65c0f07ad87c25d'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='07e13208e2bb5697b7c6c378ef4471ba:e1c6122a-8cbe-4153-a513-ba6de3e21d15',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=35,KEY_CHILD=36,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '07e13208e2bb5697b7c6c378ef4471ba:e1c6122a-8cbe-4153-a513-ba6de3e21d15'  ;

UPDATE NODE SET NODE_ORDER=4,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:427fb6e0-52a6-415d-acf9-31923c268e39',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=37,KEY_CHILD=38,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:427fb6e0-52a6-415d-acf9-31923c268e39'  ;

UPDATE NODE SET NODE_ORDER=14,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:61170836e536fb5d242a5c7841022981',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=39,KEY_CHILD=40,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:61170836e536fb5d242a5c7841022981'  ;

UPDATE NODE SET NODE_ORDER=8,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:d4139d56d74eb984154187ab9912cee4',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=41,KEY_CHILD=42,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:d4139d56d74eb984154187ab9912cee4'  ;

UPDATE NODE SET NODE_ORDER=17,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:76dbbe3844251a2e7971577f385903d2',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=43,KEY_CHILD=44,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:76dbbe3844251a2e7971577f385903d2'  ;

UPDATE NODE SET NODE_ORDER=18,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:343eb56f57f3c95a14013fce9a3d5950',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=45,KEY_CHILD=46,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:343eb56f57f3c95a14013fce9a3d5950'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:5f5a6bff-4265-46d8-8935-e2066eb0b05d',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=47,KEY_CHILD=48,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:5f5a6bff-4265-46d8-8935-e2066eb0b05d'  ;

UPDATE NODE SET NODE_ORDER=4,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:07e13208e2bb5697b7c6c378ef4471ba',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=49,KEY_CHILD=50,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:07e13208e2bb5697b7c6c378ef4471ba'  ;

UPDATE NODE SET NODE_ORDER=15,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:5249372314ad5960e89158f2b70043da',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=51,KEY_CHILD=52,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:5249372314ad5960e89158f2b70043da'  ;

UPDATE NODE SET NODE_ORDER=5,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:1fef8c2bddadd955b467823c314d998e',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=53,KEY_CHILD=54,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:1fef8c2bddadd955b467823c314d998e'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:2f6fb424c2ba29adb334cc0f58cbf86f',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=55,KEY_CHILD=56,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:2f6fb424c2ba29adb334cc0f58cbf86f'  ;

UPDATE NODE SET NODE_ORDER=10,ASCENDING=1,VISIBLE=0,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:f23f84e7d82cd6e887e14def141945b0',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=57,KEY_CHILD=58,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:f23f84e7d82cd6e887e14def141945b0'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:e677ef29c11442dbe6da18b33114c5af',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=59,KEY_CHILD=60,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:e677ef29c11442dbe6da18b33114c5af'  ;

UPDATE NODE SET NODE_ORDER=7,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:d74bab3c-2541-42f4-9b62-306a9cb7e8ba',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=61,KEY_CHILD=62,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:d74bab3c-2541-42f4-9b62-306a9cb7e8ba'  ;

UPDATE NODE SET NODE_ORDER=12,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:63f53441e65ffce6e5a5386b05fa05e5',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=63,KEY_CHILD=64,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:63f53441e65ffce6e5a5386b05fa05e5'  ;

UPDATE NODE SET NODE_ORDER=6,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:2e4c8afd4e6603be60e680efd140e8fb',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=65,KEY_CHILD=66,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:2e4c8afd4e6603be60e680efd140e8fb'  ;

UPDATE NODE SET NODE_ORDER=19,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:9c67f8682418f5707ac09e6dca36f4df',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=67,KEY_CHILD=68,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:9c67f8682418f5707ac09e6dca36f4df'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:13c341db-d995-4eea-a57f-e2919bb0c7ca',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=69,KEY_CHILD=70,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:13c341db-d995-4eea-a57f-e2919bb0c7ca'  ;

UPDATE NODE SET NODE_ORDER=10,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:926ee120-1cd2-4b92-ba2a-c6b7590ee4f6',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=71,KEY_CHILD=72,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:926ee120-1cd2-4b92-ba2a-c6b7590ee4f6'  ;

UPDATE NODE SET NODE_ORDER=13,ASCENDING=1,VISIBLE=1,CONTENT_ID='1db36353c645e064a956e779b64cd4d8:0aa85e191544982b2da51866612c7825',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=73,KEY_CHILD=74,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '1db36353c645e064a956e779b64cd4d8:0aa85e191544982b2da51866612c7825'  ;

DELETE FROM NODE WHERE CONTENT_ID = '07e13208e2bb5697b7c6c378ef4471ba:fdd1d1ca-6da9-43b5-ae2e-b251229d842c' ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(1,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:fdd1d1ca-6da9-43b5-ae2e-b251229d842c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(2,'fdd1d1ca-6da9-43b5-ae2e-b251229d842c','65e23f693ef3282401aee832a4619e0e:fdd1d1ca-6da9-43b5-ae2e-b251229d842c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(3,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:4ed4d84c-263f-4847-bedc-5f7df53f845f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(4,'4ed4d84c-263f-4847-bedc-5f7df53f845f','65e23f693ef3282401aee832a4619e0e:4ed4d84c-263f-4847-bedc-5f7df53f845f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(5,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:c1f83c82-e52c-4ef3-a990-0f7966aacf16') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(6,'c1f83c82-e52c-4ef3-a990-0f7966aacf16','65e23f693ef3282401aee832a4619e0e:c1f83c82-e52c-4ef3-a990-0f7966aacf16') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(7,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:592f20ab097893241348101697514a71') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(8,'592f20ab097893241348101697514a71','1db36353c645e064a956e779b64cd4d8:592f20ab097893241348101697514a71') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(9,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:b803b190-293a-439e-bfb2-8831f586b6ba') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(10,'b803b190-293a-439e-bfb2-8831f586b6ba','65e23f693ef3282401aee832a4619e0e:b803b190-293a-439e-bfb2-8831f586b6ba') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(11,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:6dfbae767183e66ebeb8b63e57ac84ce') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(12,'6dfbae767183e66ebeb8b63e57ac84ce','1db36353c645e064a956e779b64cd4d8:6dfbae767183e66ebeb8b63e57ac84ce') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(13,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:a4b037ab-1c71-4015-a7a0-385e27dba21a') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(14,'a4b037ab-1c71-4015-a7a0-385e27dba21a','65e23f693ef3282401aee832a4619e0e:a4b037ab-1c71-4015-a7a0-385e27dba21a') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(15,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:9b85bd677aaa13d973ac06a8052a5e86') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(16,'9b85bd677aaa13d973ac06a8052a5e86','1db36353c645e064a956e779b64cd4d8:9b85bd677aaa13d973ac06a8052a5e86') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(17,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:0379a4f669d516191a3471dffa6b6010') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(18,'0379a4f669d516191a3471dffa6b6010','1db36353c645e064a956e779b64cd4d8:0379a4f669d516191a3471dffa6b6010') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(19,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:d091e4cb-549b-4c90-aa64-19316dde8da9') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(20,'d091e4cb-549b-4c90-aa64-19316dde8da9','65e23f693ef3282401aee832a4619e0e:d091e4cb-549b-4c90-aa64-19316dde8da9') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(21,'07e13208e2bb5697b7c6c378ef4471ba','07e13208e2bb5697b7c6c378ef4471ba:65e23f693ef3282401aee832a4619e0e') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(22,'65e23f693ef3282401aee832a4619e0e','07e13208e2bb5697b7c6c378ef4471ba:65e23f693ef3282401aee832a4619e0e') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(23,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:51c9d0f5-3380-46b3-94b2-2b202ea28a00') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(24,'51c9d0f5-3380-46b3-94b2-2b202ea28a00','65e23f693ef3282401aee832a4619e0e:51c9d0f5-3380-46b3-94b2-2b202ea28a00') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(25,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:fdd1d1ca-6da9-43b5-ae2e-b251229d842c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(26,'fdd1d1ca-6da9-43b5-ae2e-b251229d842c','65e23f693ef3282401aee832a4619e0e:fdd1d1ca-6da9-43b5-ae2e-b251229d842c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(27,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:23393306d6da5ad5313d322e32d2fb0f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(28,'23393306d6da5ad5313d322e32d2fb0f','1db36353c645e064a956e779b64cd4d8:23393306d6da5ad5313d322e32d2fb0f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(29,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:9ab7b6541d1d6c3191c74f181c5910a0') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(30,'9ab7b6541d1d6c3191c74f181c5910a0','1db36353c645e064a956e779b64cd4d8:9ab7b6541d1d6c3191c74f181c5910a0') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(31,'07e13208e2bb5697b7c6c378ef4471ba','07e13208e2bb5697b7c6c378ef4471ba:8d123cd3-b4ce-4152-9860-ab3b1b8ab900') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(32,'8d123cd3-b4ce-4152-9860-ab3b1b8ab900','07e13208e2bb5697b7c6c378ef4471ba:8d123cd3-b4ce-4152-9860-ab3b1b8ab900') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(33,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:b845e4cec80d742dd65c0f07ad87c25d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(34,'b845e4cec80d742dd65c0f07ad87c25d','1db36353c645e064a956e779b64cd4d8:b845e4cec80d742dd65c0f07ad87c25d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(35,'07e13208e2bb5697b7c6c378ef4471ba','07e13208e2bb5697b7c6c378ef4471ba:e1c6122a-8cbe-4153-a513-ba6de3e21d15') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(36,'e1c6122a-8cbe-4153-a513-ba6de3e21d15','07e13208e2bb5697b7c6c378ef4471ba:e1c6122a-8cbe-4153-a513-ba6de3e21d15') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(37,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:427fb6e0-52a6-415d-acf9-31923c268e39') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(38,'427fb6e0-52a6-415d-acf9-31923c268e39','65e23f693ef3282401aee832a4619e0e:427fb6e0-52a6-415d-acf9-31923c268e39') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(39,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:61170836e536fb5d242a5c7841022981') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(40,'61170836e536fb5d242a5c7841022981','1db36353c645e064a956e779b64cd4d8:61170836e536fb5d242a5c7841022981') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(41,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:d4139d56d74eb984154187ab9912cee4') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(42,'d4139d56d74eb984154187ab9912cee4','1db36353c645e064a956e779b64cd4d8:d4139d56d74eb984154187ab9912cee4') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(43,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:76dbbe3844251a2e7971577f385903d2') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(44,'76dbbe3844251a2e7971577f385903d2','1db36353c645e064a956e779b64cd4d8:76dbbe3844251a2e7971577f385903d2') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(45,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:343eb56f57f3c95a14013fce9a3d5950') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(46,'343eb56f57f3c95a14013fce9a3d5950','1db36353c645e064a956e779b64cd4d8:343eb56f57f3c95a14013fce9a3d5950') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(47,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:5f5a6bff-4265-46d8-8935-e2066eb0b05d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(48,'5f5a6bff-4265-46d8-8935-e2066eb0b05d','65e23f693ef3282401aee832a4619e0e:5f5a6bff-4265-46d8-8935-e2066eb0b05d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(49,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:07e13208e2bb5697b7c6c378ef4471ba') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(50,'07e13208e2bb5697b7c6c378ef4471ba','1db36353c645e064a956e779b64cd4d8:07e13208e2bb5697b7c6c378ef4471ba') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(51,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:5249372314ad5960e89158f2b70043da') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(52,'5249372314ad5960e89158f2b70043da','1db36353c645e064a956e779b64cd4d8:5249372314ad5960e89158f2b70043da') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(53,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:1fef8c2bddadd955b467823c314d998e') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(54,'1fef8c2bddadd955b467823c314d998e','1db36353c645e064a956e779b64cd4d8:1fef8c2bddadd955b467823c314d998e') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(55,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:2f6fb424c2ba29adb334cc0f58cbf86f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(56,'2f6fb424c2ba29adb334cc0f58cbf86f','1db36353c645e064a956e779b64cd4d8:2f6fb424c2ba29adb334cc0f58cbf86f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(57,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:f23f84e7d82cd6e887e14def141945b0') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(58,'f23f84e7d82cd6e887e14def141945b0','1db36353c645e064a956e779b64cd4d8:f23f84e7d82cd6e887e14def141945b0') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(59,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:e677ef29c11442dbe6da18b33114c5af') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(60,'e677ef29c11442dbe6da18b33114c5af','1db36353c645e064a956e779b64cd4d8:e677ef29c11442dbe6da18b33114c5af') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(61,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:d74bab3c-2541-42f4-9b62-306a9cb7e8ba') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(62,'d74bab3c-2541-42f4-9b62-306a9cb7e8ba','65e23f693ef3282401aee832a4619e0e:d74bab3c-2541-42f4-9b62-306a9cb7e8ba') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(63,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:63f53441e65ffce6e5a5386b05fa05e5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(64,'63f53441e65ffce6e5a5386b05fa05e5','1db36353c645e064a956e779b64cd4d8:63f53441e65ffce6e5a5386b05fa05e5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(65,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:2e4c8afd4e6603be60e680efd140e8fb') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(66,'2e4c8afd4e6603be60e680efd140e8fb','1db36353c645e064a956e779b64cd4d8:2e4c8afd4e6603be60e680efd140e8fb') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(67,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:9c67f8682418f5707ac09e6dca36f4df') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(68,'9c67f8682418f5707ac09e6dca36f4df','1db36353c645e064a956e779b64cd4d8:9c67f8682418f5707ac09e6dca36f4df') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(69,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:13c341db-d995-4eea-a57f-e2919bb0c7ca') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(70,'13c341db-d995-4eea-a57f-e2919bb0c7ca','1db36353c645e064a956e779b64cd4d8:13c341db-d995-4eea-a57f-e2919bb0c7ca') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(71,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:926ee120-1cd2-4b92-ba2a-c6b7590ee4f6') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(72,'926ee120-1cd2-4b92-ba2a-c6b7590ee4f6','65e23f693ef3282401aee832a4619e0e:926ee120-1cd2-4b92-ba2a-c6b7590ee4f6') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(73,'1db36353c645e064a956e779b64cd4d8','1db36353c645e064a956e779b64cd4d8:0aa85e191544982b2da51866612c7825') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(74,'0aa85e191544982b2da51866612c7825','1db36353c645e064a956e779b64cd4d8:0aa85e191544982b2da51866612c7825') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='07e13208e2bb5697b7c6c378ef4471ba:8d123cd3-b4ce-4152-9860-ab3b1b8ab900',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=75,KEY_CHILD=76,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '07e13208e2bb5697b7c6c378ef4471ba:8d123cd3-b4ce-4152-9860-ab3b1b8ab900'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='07e13208e2bb5697b7c6c378ef4471ba:e1c6122a-8cbe-4153-a513-ba6de3e21d15',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=77,KEY_CHILD=78,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '07e13208e2bb5697b7c6c378ef4471ba:e1c6122a-8cbe-4153-a513-ba6de3e21d15'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='07e13208e2bb5697b7c6c378ef4471ba:65e23f693ef3282401aee832a4619e0e',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=79,KEY_CHILD=80,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '07e13208e2bb5697b7c6c378ef4471ba:65e23f693ef3282401aee832a4619e0e'  ;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=null,CONTENT_ID='65e23f693ef3282401aee832a4619e0e',CREATION_DATE='2008-01-07 19:45:40',NAME='pt27:Gestão de Unidades e Cargos',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(75,'07e13208e2bb5697b7c6c378ef4471ba','07e13208e2bb5697b7c6c378ef4471ba:8d123cd3-b4ce-4152-9860-ab3b1b8ab900') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(76,'8d123cd3-b4ce-4152-9860-ab3b1b8ab900','07e13208e2bb5697b7c6c378ef4471ba:8d123cd3-b4ce-4152-9860-ab3b1b8ab900') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(77,'07e13208e2bb5697b7c6c378ef4471ba','07e13208e2bb5697b7c6c378ef4471ba:e1c6122a-8cbe-4153-a513-ba6de3e21d15') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(78,'e1c6122a-8cbe-4153-a513-ba6de3e21d15','07e13208e2bb5697b7c6c378ef4471ba:e1c6122a-8cbe-4153-a513-ba6de3e21d15') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(79,'07e13208e2bb5697b7c6c378ef4471ba','07e13208e2bb5697b7c6c378ef4471ba:65e23f693ef3282401aee832a4619e0e') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(80,'65e23f693ef3282401aee832a4619e0e','07e13208e2bb5697b7c6c378ef4471ba:65e23f693ef3282401aee832a4619e0e') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=81,CONTENT_ID='65e23f693ef3282401aee832a4619e0e',CREATION_DATE='2008-01-07 19:45:40',NAME='pt27:Gestão de Unidades e Cargos',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(81,'fdd1d1ca-6da9-43b5-ae2e-b251229d842c','65e23f693ef3282401aee832a4619e0e') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE NODE SET NODE_ORDER=6,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:4ed4d84c-263f-4847-bedc-5f7df53f845f',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=82,KEY_CHILD=83,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:4ed4d84c-263f-4847-bedc-5f7df53f845f'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:5f5a6bff-4265-46d8-8935-e2066eb0b05d',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=84,KEY_CHILD=85,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:5f5a6bff-4265-46d8-8935-e2066eb0b05d'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:c1f83c82-e52c-4ef3-a990-0f7966aacf16',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=86,KEY_CHILD=87,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:c1f83c82-e52c-4ef3-a990-0f7966aacf16'  ;

UPDATE NODE SET NODE_ORDER=4,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:b803b190-293a-439e-bfb2-8831f586b6ba',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=88,KEY_CHILD=89,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:b803b190-293a-439e-bfb2-8831f586b6ba'  ;

UPDATE NODE SET NODE_ORDER=7,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:a4b037ab-1c71-4015-a7a0-385e27dba21a',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=90,KEY_CHILD=91,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:a4b037ab-1c71-4015-a7a0-385e27dba21a'  ;

UPDATE NODE SET NODE_ORDER=5,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:427fb6e0-52a6-415d-acf9-31923c268e39',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=92,KEY_CHILD=93,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:427fb6e0-52a6-415d-acf9-31923c268e39'  ;

UPDATE NODE SET NODE_ORDER=9,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:d091e4cb-549b-4c90-aa64-19316dde8da9',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=94,KEY_CHILD=95,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:d091e4cb-549b-4c90-aa64-19316dde8da9'  ;

UPDATE NODE SET NODE_ORDER=10,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:51c9d0f5-3380-46b3-94b2-2b202ea28a00',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=96,KEY_CHILD=97,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:51c9d0f5-3380-46b3-94b2-2b202ea28a00'  ;

UPDATE NODE SET NODE_ORDER=11,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:926ee120-1cd2-4b92-ba2a-c6b7590ee4f6',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=98,KEY_CHILD=99,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:926ee120-1cd2-4b92-ba2a-c6b7590ee4f6'  ;

UPDATE NODE SET NODE_ORDER=8,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:d74bab3c-2541-42f4-9b62-306a9cb7e8ba',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=100,KEY_CHILD=101,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:d74bab3c-2541-42f4-9b62-306a9cb7e8ba'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:fdd1d1ca-6da9-43b5-ae2e-b251229d842c',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=102,KEY_CHILD=103,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:fdd1d1ca-6da9-43b5-ae2e-b251229d842c'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(82,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:4ed4d84c-263f-4847-bedc-5f7df53f845f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(83,'4ed4d84c-263f-4847-bedc-5f7df53f845f','65e23f693ef3282401aee832a4619e0e:4ed4d84c-263f-4847-bedc-5f7df53f845f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(84,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:5f5a6bff-4265-46d8-8935-e2066eb0b05d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(85,'5f5a6bff-4265-46d8-8935-e2066eb0b05d','65e23f693ef3282401aee832a4619e0e:5f5a6bff-4265-46d8-8935-e2066eb0b05d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(86,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:c1f83c82-e52c-4ef3-a990-0f7966aacf16') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(87,'c1f83c82-e52c-4ef3-a990-0f7966aacf16','65e23f693ef3282401aee832a4619e0e:c1f83c82-e52c-4ef3-a990-0f7966aacf16') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(88,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:b803b190-293a-439e-bfb2-8831f586b6ba') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(89,'b803b190-293a-439e-bfb2-8831f586b6ba','65e23f693ef3282401aee832a4619e0e:b803b190-293a-439e-bfb2-8831f586b6ba') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(90,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:a4b037ab-1c71-4015-a7a0-385e27dba21a') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(91,'a4b037ab-1c71-4015-a7a0-385e27dba21a','65e23f693ef3282401aee832a4619e0e:a4b037ab-1c71-4015-a7a0-385e27dba21a') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(92,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:427fb6e0-52a6-415d-acf9-31923c268e39') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(93,'427fb6e0-52a6-415d-acf9-31923c268e39','65e23f693ef3282401aee832a4619e0e:427fb6e0-52a6-415d-acf9-31923c268e39') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(94,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:d091e4cb-549b-4c90-aa64-19316dde8da9') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(95,'d091e4cb-549b-4c90-aa64-19316dde8da9','65e23f693ef3282401aee832a4619e0e:d091e4cb-549b-4c90-aa64-19316dde8da9') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(96,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:51c9d0f5-3380-46b3-94b2-2b202ea28a00') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(97,'51c9d0f5-3380-46b3-94b2-2b202ea28a00','65e23f693ef3282401aee832a4619e0e:51c9d0f5-3380-46b3-94b2-2b202ea28a00') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(98,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:926ee120-1cd2-4b92-ba2a-c6b7590ee4f6') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(99,'926ee120-1cd2-4b92-ba2a-c6b7590ee4f6','65e23f693ef3282401aee832a4619e0e:926ee120-1cd2-4b92-ba2a-c6b7590ee4f6') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(100,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:d74bab3c-2541-42f4-9b62-306a9cb7e8ba') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(101,'d74bab3c-2541-42f4-9b62-306a9cb7e8ba','65e23f693ef3282401aee832a4619e0e:d74bab3c-2541-42f4-9b62-306a9cb7e8ba') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(102,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:fdd1d1ca-6da9-43b5-ae2e-b251229d842c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(103,'fdd1d1ca-6da9-43b5-ae2e-b251229d842c','65e23f693ef3282401aee832a4619e0e:fdd1d1ca-6da9-43b5-ae2e-b251229d842c') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

INSERT INTO NODE (NODE_ORDER,ASCENDING,VISIBLE,CONTENT_ID,KEY_ROOT_DOMAIN_OBJECT,KEY_PARENT,KEY_CHILD,OJB_CONCRETE_CLASS) VALUES (0,1,1,'e046e45719e698af8638fb0ab3001a90:f832317c-db1e-4c36-b67c-3c4070ccee59',1,104,105,'net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode')  ;

INSERT INTO NODE (NODE_ORDER,ASCENDING,VISIBLE,CONTENT_ID,KEY_ROOT_DOMAIN_OBJECT,KEY_PARENT,KEY_CHILD,OJB_CONCRETE_CLASS) VALUES (0,1,1,'68ef9f05d4e026bf3c6aee96f1e2237e:0cac3f6f-6be4-4476-8681-7b980edbccee',1,106,107,'net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode')  ;

INSERT INTO NODE (NODE_ORDER,ASCENDING,VISIBLE,CONTENT_ID,KEY_ROOT_DOMAIN_OBJECT,KEY_PARENT,KEY_CHILD,OJB_CONCRETE_CLASS) VALUES (0,1,1,'7a7f91fc348bc0eb115e797487be440b:fe00b1c9-b931-489c-9398-21ddf806a638',1,108,109,'net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode')  ;

INSERT INTO NODE (NODE_ORDER,ASCENDING,VISIBLE,CONTENT_ID,KEY_ROOT_DOMAIN_OBJECT,KEY_PARENT,KEY_CHILD,OJB_CONCRETE_CLASS) VALUES (0,1,1,'a2dbd965ff55ac88b6974db02f537cc5:50ab74d4-5050-4975-b88c-91b0c39ed493',1,110,111,'net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode')  ;

UPDATE NODE SET NODE_ORDER=5,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:4ed4d84c-263f-4847-bedc-5f7df53f845f',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=112,KEY_CHILD=113,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:4ed4d84c-263f-4847-bedc-5f7df53f845f'  ;

UPDATE NODE SET NODE_ORDER=4,ASCENDING=1,VISIBLE=1,CONTENT_ID='7a7f91fc348bc0eb115e797487be440b:7b1f1a12-101d-4ec0-934a-7055f35e83ef',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=114,KEY_CHILD=115,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '7a7f91fc348bc0eb115e797487be440b:7b1f1a12-101d-4ec0-934a-7055f35e83ef'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:c1f83c82-e52c-4ef3-a990-0f7966aacf16',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=116,KEY_CHILD=117,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:c1f83c82-e52c-4ef3-a990-0f7966aacf16'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:b803b190-293a-439e-bfb2-8831f586b6ba',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=118,KEY_CHILD=119,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:b803b190-293a-439e-bfb2-8831f586b6ba'  ;

UPDATE NODE SET NODE_ORDER=6,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:a4b037ab-1c71-4015-a7a0-385e27dba21a',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=120,KEY_CHILD=121,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:a4b037ab-1c71-4015-a7a0-385e27dba21a'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=0,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=122,KEY_CHILD=123,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='7a7f91fc348bc0eb115e797487be440b:1ee76765-996b-4663-8a70-d690e6f1ae75',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=124,KEY_CHILD=125,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '7a7f91fc348bc0eb115e797487be440b:1ee76765-996b-4663-8a70-d690e6f1ae75'  ;

UPDATE NODE SET NODE_ORDER=8,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:d091e4cb-549b-4c90-aa64-19316dde8da9',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=126,KEY_CHILD=127,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:d091e4cb-549b-4c90-aa64-19316dde8da9'  ;

UPDATE NODE SET NODE_ORDER=9,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:51c9d0f5-3380-46b3-94b2-2b202ea28a00',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=128,KEY_CHILD=129,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:51c9d0f5-3380-46b3-94b2-2b202ea28a00'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=0,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=130,KEY_CHILD=131,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='68ef9f05d4e026bf3c6aee96f1e2237e:1ccbe91b-103e-4be8-b7c8-311a49ed32d5',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=132,KEY_CHILD=133,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '68ef9f05d4e026bf3c6aee96f1e2237e:1ccbe91b-103e-4be8-b7c8-311a49ed32d5'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:fdd1d1ca-6da9-43b5-ae2e-b251229d842c',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=134,KEY_CHILD=135,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:fdd1d1ca-6da9-43b5-ae2e-b251229d842c'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='a2dbd965ff55ac88b6974db02f537cc5:6ff87b36-bf9e-4963-929e-60f63896dbf3',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=136,KEY_CHILD=137,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'a2dbd965ff55ac88b6974db02f537cc5:6ff87b36-bf9e-4963-929e-60f63896dbf3'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='07e13208e2bb5697b7c6c378ef4471ba:8d123cd3-b4ce-4152-9860-ab3b1b8ab900',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=138,KEY_CHILD=139,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '07e13208e2bb5697b7c6c378ef4471ba:8d123cd3-b4ce-4152-9860-ab3b1b8ab900'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='e046e45719e698af8638fb0ab3001a90:8f856c12-4be8-4175-9b87-ef29f19ed563',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=140,KEY_CHILD=141,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'e046e45719e698af8638fb0ab3001a90:8f856c12-4be8-4175-9b87-ef29f19ed563'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='a2dbd965ff55ac88b6974db02f537cc5:3c59adc8-fe3b-4373-b4ea-6eb7a37166bb',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=142,KEY_CHILD=143,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'a2dbd965ff55ac88b6974db02f537cc5:3c59adc8-fe3b-4373-b4ea-6eb7a37166bb'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='07e13208e2bb5697b7c6c378ef4471ba:e1c6122a-8cbe-4153-a513-ba6de3e21d15',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=144,KEY_CHILD=145,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '07e13208e2bb5697b7c6c378ef4471ba:e1c6122a-8cbe-4153-a513-ba6de3e21d15'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='68ef9f05d4e026bf3c6aee96f1e2237e:0cac3f6f-6be4-4476-8681-7b980edbccee',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=146,KEY_CHILD=147,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '68ef9f05d4e026bf3c6aee96f1e2237e:0cac3f6f-6be4-4476-8681-7b980edbccee'  ;

UPDATE NODE SET NODE_ORDER=4,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:427fb6e0-52a6-415d-acf9-31923c268e39',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=148,KEY_CHILD=149,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:427fb6e0-52a6-415d-acf9-31923c268e39'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=0,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=150,KEY_CHILD=151,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='a2dbd965ff55ac88b6974db02f537cc5:099a4531-aee8-420c-8b27-d6ffdfe16f41',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=152,KEY_CHILD=153,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'a2dbd965ff55ac88b6974db02f537cc5:099a4531-aee8-420c-8b27-d6ffdfe16f41'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='a2dbd965ff55ac88b6974db02f537cc5:50ab74d4-5050-4975-b88c-91b0c39ed493',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=154,KEY_CHILD=155,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'a2dbd965ff55ac88b6974db02f537cc5:50ab74d4-5050-4975-b88c-91b0c39ed493'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='7a7f91fc348bc0eb115e797487be440b:80a68f83-1172-4a70-b3bf-f1c87988c497',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=156,KEY_CHILD=157,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '7a7f91fc348bc0eb115e797487be440b:80a68f83-1172-4a70-b3bf-f1c87988c497'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='e046e45719e698af8638fb0ab3001a90:5256b6376122b526db88009f6a9f53e5',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=158,KEY_CHILD=159,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'e046e45719e698af8638fb0ab3001a90:5256b6376122b526db88009f6a9f53e5'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:5f5a6bff-4265-46d8-8935-e2066eb0b05d',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=160,KEY_CHILD=161,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:5f5a6bff-4265-46d8-8935-e2066eb0b05d'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='7a7f91fc348bc0eb115e797487be440b:e4ad482f-f854-4c33-ace1-1f976efec758',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=162,KEY_CHILD=163,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '7a7f91fc348bc0eb115e797487be440b:e4ad482f-f854-4c33-ace1-1f976efec758'  ;

UPDATE NODE SET NODE_ORDER=6,ASCENDING=1,VISIBLE=1,CONTENT_ID='7a7f91fc348bc0eb115e797487be440b:c8f900f18f344f60a56dbd324e52d425',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=164,KEY_CHILD=165,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '7a7f91fc348bc0eb115e797487be440b:c8f900f18f344f60a56dbd324e52d425'  ;

UPDATE NODE SET NODE_ORDER=5,ASCENDING=1,VISIBLE=1,CONTENT_ID='7a7f91fc348bc0eb115e797487be440b:a6c9fbe3-77ea-4187-981d-7ada15a348fa',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=166,KEY_CHILD=167,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '7a7f91fc348bc0eb115e797487be440b:a6c9fbe3-77ea-4187-981d-7ada15a348fa'  ;

UPDATE NODE SET NODE_ORDER=7,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:d74bab3c-2541-42f4-9b62-306a9cb7e8ba',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=168,KEY_CHILD=169,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:d74bab3c-2541-42f4-9b62-306a9cb7e8ba'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='e046e45719e698af8638fb0ab3001a90:f832317c-db1e-4c36-b67c-3c4070ccee59',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=170,KEY_CHILD=171,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'e046e45719e698af8638fb0ab3001a90:f832317c-db1e-4c36-b67c-3c4070ccee59'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='68ef9f05d4e026bf3c6aee96f1e2237e:e283975b-9990-4561-9cbd-44cfe8eebce0',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=172,KEY_CHILD=173,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '68ef9f05d4e026bf3c6aee96f1e2237e:e283975b-9990-4561-9cbd-44cfe8eebce0'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='7a7f91fc348bc0eb115e797487be440b:fe00b1c9-b931-489c-9398-21ddf806a638',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=174,KEY_CHILD=175,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '7a7f91fc348bc0eb115e797487be440b:fe00b1c9-b931-489c-9398-21ddf806a638'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=0,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:68ef9f05d4e026bf3c6aee96f1e2237e',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=176,KEY_CHILD=177,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:68ef9f05d4e026bf3c6aee96f1e2237e'  ;

UPDATE NODE SET NODE_ORDER=10,ASCENDING=1,VISIBLE=1,CONTENT_ID='65e23f693ef3282401aee832a4619e0e:926ee120-1cd2-4b92-ba2a-c6b7590ee4f6',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=178,KEY_CHILD=179,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '65e23f693ef3282401aee832a4619e0e:926ee120-1cd2-4b92-ba2a-c6b7590ee4f6'  ;

UPDATE NODE SET NODE_ORDER=4,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=180,KEY_CHILD=181,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='e046e45719e698af8638fb0ab3001a90:aa2611bd-827d-4be9-bc70-0dcd04d071f8',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=182,KEY_CHILD=183,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'e046e45719e698af8638fb0ab3001a90:aa2611bd-827d-4be9-bc70-0dcd04d071f8'  ;

DELETE FROM NODE WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:fe00b1c9-b931-489c-9398-21ddf806a638' ;

DELETE FROM NODE WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:50ab74d4-5050-4975-b88c-91b0c39ed493' ;

DELETE FROM NODE WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:f832317c-db1e-4c36-b67c-3c4070ccee59' ;

DELETE FROM NODE WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:0cac3f6f-6be4-4476-8681-7b980edbccee' ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(104,'e046e45719e698af8638fb0ab3001a90','e046e45719e698af8638fb0ab3001a90:f832317c-db1e-4c36-b67c-3c4070ccee59') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(105,'f832317c-db1e-4c36-b67c-3c4070ccee59','e046e45719e698af8638fb0ab3001a90:f832317c-db1e-4c36-b67c-3c4070ccee59') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(106,'68ef9f05d4e026bf3c6aee96f1e2237e','68ef9f05d4e026bf3c6aee96f1e2237e:0cac3f6f-6be4-4476-8681-7b980edbccee') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(107,'0cac3f6f-6be4-4476-8681-7b980edbccee','68ef9f05d4e026bf3c6aee96f1e2237e:0cac3f6f-6be4-4476-8681-7b980edbccee') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(108,'7a7f91fc348bc0eb115e797487be440b','7a7f91fc348bc0eb115e797487be440b:fe00b1c9-b931-489c-9398-21ddf806a638') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(109,'fe00b1c9-b931-489c-9398-21ddf806a638','7a7f91fc348bc0eb115e797487be440b:fe00b1c9-b931-489c-9398-21ddf806a638') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(110,'a2dbd965ff55ac88b6974db02f537cc5','a2dbd965ff55ac88b6974db02f537cc5:50ab74d4-5050-4975-b88c-91b0c39ed493') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(111,'50ab74d4-5050-4975-b88c-91b0c39ed493','a2dbd965ff55ac88b6974db02f537cc5:50ab74d4-5050-4975-b88c-91b0c39ed493') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(112,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:4ed4d84c-263f-4847-bedc-5f7df53f845f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(113,'4ed4d84c-263f-4847-bedc-5f7df53f845f','65e23f693ef3282401aee832a4619e0e:4ed4d84c-263f-4847-bedc-5f7df53f845f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(114,'7a7f91fc348bc0eb115e797487be440b','7a7f91fc348bc0eb115e797487be440b:7b1f1a12-101d-4ec0-934a-7055f35e83ef') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(115,'7b1f1a12-101d-4ec0-934a-7055f35e83ef','7a7f91fc348bc0eb115e797487be440b:7b1f1a12-101d-4ec0-934a-7055f35e83ef') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(116,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:c1f83c82-e52c-4ef3-a990-0f7966aacf16') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(117,'c1f83c82-e52c-4ef3-a990-0f7966aacf16','65e23f693ef3282401aee832a4619e0e:c1f83c82-e52c-4ef3-a990-0f7966aacf16') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(118,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:b803b190-293a-439e-bfb2-8831f586b6ba') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(119,'b803b190-293a-439e-bfb2-8831f586b6ba','65e23f693ef3282401aee832a4619e0e:b803b190-293a-439e-bfb2-8831f586b6ba') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(120,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:a4b037ab-1c71-4015-a7a0-385e27dba21a') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(121,'a4b037ab-1c71-4015-a7a0-385e27dba21a','65e23f693ef3282401aee832a4619e0e:a4b037ab-1c71-4015-a7a0-385e27dba21a') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(122,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(123,'a2dbd965ff55ac88b6974db02f537cc5','2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(124,'7a7f91fc348bc0eb115e797487be440b','7a7f91fc348bc0eb115e797487be440b:1ee76765-996b-4663-8a70-d690e6f1ae75') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(125,'1ee76765-996b-4663-8a70-d690e6f1ae75','7a7f91fc348bc0eb115e797487be440b:1ee76765-996b-4663-8a70-d690e6f1ae75') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(126,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:d091e4cb-549b-4c90-aa64-19316dde8da9') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(127,'d091e4cb-549b-4c90-aa64-19316dde8da9','65e23f693ef3282401aee832a4619e0e:d091e4cb-549b-4c90-aa64-19316dde8da9') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(128,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:51c9d0f5-3380-46b3-94b2-2b202ea28a00') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(129,'51c9d0f5-3380-46b3-94b2-2b202ea28a00','65e23f693ef3282401aee832a4619e0e:51c9d0f5-3380-46b3-94b2-2b202ea28a00') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(130,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(131,'e046e45719e698af8638fb0ab3001a90','2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(132,'68ef9f05d4e026bf3c6aee96f1e2237e','68ef9f05d4e026bf3c6aee96f1e2237e:1ccbe91b-103e-4be8-b7c8-311a49ed32d5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(133,'1ccbe91b-103e-4be8-b7c8-311a49ed32d5','68ef9f05d4e026bf3c6aee96f1e2237e:1ccbe91b-103e-4be8-b7c8-311a49ed32d5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(134,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:fdd1d1ca-6da9-43b5-ae2e-b251229d842c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(135,'fdd1d1ca-6da9-43b5-ae2e-b251229d842c','65e23f693ef3282401aee832a4619e0e:fdd1d1ca-6da9-43b5-ae2e-b251229d842c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(136,'a2dbd965ff55ac88b6974db02f537cc5','a2dbd965ff55ac88b6974db02f537cc5:6ff87b36-bf9e-4963-929e-60f63896dbf3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(137,'6ff87b36-bf9e-4963-929e-60f63896dbf3','a2dbd965ff55ac88b6974db02f537cc5:6ff87b36-bf9e-4963-929e-60f63896dbf3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(138,'07e13208e2bb5697b7c6c378ef4471ba','07e13208e2bb5697b7c6c378ef4471ba:8d123cd3-b4ce-4152-9860-ab3b1b8ab900') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(139,'8d123cd3-b4ce-4152-9860-ab3b1b8ab900','07e13208e2bb5697b7c6c378ef4471ba:8d123cd3-b4ce-4152-9860-ab3b1b8ab900') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(140,'e046e45719e698af8638fb0ab3001a90','e046e45719e698af8638fb0ab3001a90:8f856c12-4be8-4175-9b87-ef29f19ed563') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(141,'8f856c12-4be8-4175-9b87-ef29f19ed563','e046e45719e698af8638fb0ab3001a90:8f856c12-4be8-4175-9b87-ef29f19ed563') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(142,'a2dbd965ff55ac88b6974db02f537cc5','a2dbd965ff55ac88b6974db02f537cc5:3c59adc8-fe3b-4373-b4ea-6eb7a37166bb') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(143,'3c59adc8-fe3b-4373-b4ea-6eb7a37166bb','a2dbd965ff55ac88b6974db02f537cc5:3c59adc8-fe3b-4373-b4ea-6eb7a37166bb') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(144,'07e13208e2bb5697b7c6c378ef4471ba','07e13208e2bb5697b7c6c378ef4471ba:e1c6122a-8cbe-4153-a513-ba6de3e21d15') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(145,'e1c6122a-8cbe-4153-a513-ba6de3e21d15','07e13208e2bb5697b7c6c378ef4471ba:e1c6122a-8cbe-4153-a513-ba6de3e21d15') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(146,'68ef9f05d4e026bf3c6aee96f1e2237e','68ef9f05d4e026bf3c6aee96f1e2237e:0cac3f6f-6be4-4476-8681-7b980edbccee') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(147,'0cac3f6f-6be4-4476-8681-7b980edbccee','68ef9f05d4e026bf3c6aee96f1e2237e:0cac3f6f-6be4-4476-8681-7b980edbccee') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(148,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:427fb6e0-52a6-415d-acf9-31923c268e39') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(149,'427fb6e0-52a6-415d-acf9-31923c268e39','65e23f693ef3282401aee832a4619e0e:427fb6e0-52a6-415d-acf9-31923c268e39') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(150,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(151,'7a7f91fc348bc0eb115e797487be440b','2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(152,'a2dbd965ff55ac88b6974db02f537cc5','a2dbd965ff55ac88b6974db02f537cc5:099a4531-aee8-420c-8b27-d6ffdfe16f41') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(153,'099a4531-aee8-420c-8b27-d6ffdfe16f41','a2dbd965ff55ac88b6974db02f537cc5:099a4531-aee8-420c-8b27-d6ffdfe16f41') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(154,'a2dbd965ff55ac88b6974db02f537cc5','a2dbd965ff55ac88b6974db02f537cc5:50ab74d4-5050-4975-b88c-91b0c39ed493') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(155,'50ab74d4-5050-4975-b88c-91b0c39ed493','a2dbd965ff55ac88b6974db02f537cc5:50ab74d4-5050-4975-b88c-91b0c39ed493') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(156,'7a7f91fc348bc0eb115e797487be440b','7a7f91fc348bc0eb115e797487be440b:80a68f83-1172-4a70-b3bf-f1c87988c497') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(157,'80a68f83-1172-4a70-b3bf-f1c87988c497','7a7f91fc348bc0eb115e797487be440b:80a68f83-1172-4a70-b3bf-f1c87988c497') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(158,'e046e45719e698af8638fb0ab3001a90','e046e45719e698af8638fb0ab3001a90:5256b6376122b526db88009f6a9f53e5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(159,'5256b6376122b526db88009f6a9f53e5','e046e45719e698af8638fb0ab3001a90:5256b6376122b526db88009f6a9f53e5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(160,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:5f5a6bff-4265-46d8-8935-e2066eb0b05d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(161,'5f5a6bff-4265-46d8-8935-e2066eb0b05d','65e23f693ef3282401aee832a4619e0e:5f5a6bff-4265-46d8-8935-e2066eb0b05d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(162,'7a7f91fc348bc0eb115e797487be440b','7a7f91fc348bc0eb115e797487be440b:e4ad482f-f854-4c33-ace1-1f976efec758') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(163,'e4ad482f-f854-4c33-ace1-1f976efec758','7a7f91fc348bc0eb115e797487be440b:e4ad482f-f854-4c33-ace1-1f976efec758') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(164,'7a7f91fc348bc0eb115e797487be440b','7a7f91fc348bc0eb115e797487be440b:c8f900f18f344f60a56dbd324e52d425') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(165,'c8f900f18f344f60a56dbd324e52d425','7a7f91fc348bc0eb115e797487be440b:c8f900f18f344f60a56dbd324e52d425') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(166,'7a7f91fc348bc0eb115e797487be440b','7a7f91fc348bc0eb115e797487be440b:a6c9fbe3-77ea-4187-981d-7ada15a348fa') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(167,'a6c9fbe3-77ea-4187-981d-7ada15a348fa','7a7f91fc348bc0eb115e797487be440b:a6c9fbe3-77ea-4187-981d-7ada15a348fa') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(168,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:d74bab3c-2541-42f4-9b62-306a9cb7e8ba') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(169,'d74bab3c-2541-42f4-9b62-306a9cb7e8ba','65e23f693ef3282401aee832a4619e0e:d74bab3c-2541-42f4-9b62-306a9cb7e8ba') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(170,'e046e45719e698af8638fb0ab3001a90','e046e45719e698af8638fb0ab3001a90:f832317c-db1e-4c36-b67c-3c4070ccee59') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(171,'f832317c-db1e-4c36-b67c-3c4070ccee59','e046e45719e698af8638fb0ab3001a90:f832317c-db1e-4c36-b67c-3c4070ccee59') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(172,'68ef9f05d4e026bf3c6aee96f1e2237e','68ef9f05d4e026bf3c6aee96f1e2237e:e283975b-9990-4561-9cbd-44cfe8eebce0') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(173,'e283975b-9990-4561-9cbd-44cfe8eebce0','68ef9f05d4e026bf3c6aee96f1e2237e:e283975b-9990-4561-9cbd-44cfe8eebce0') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(174,'7a7f91fc348bc0eb115e797487be440b','7a7f91fc348bc0eb115e797487be440b:fe00b1c9-b931-489c-9398-21ddf806a638') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(175,'fe00b1c9-b931-489c-9398-21ddf806a638','7a7f91fc348bc0eb115e797487be440b:fe00b1c9-b931-489c-9398-21ddf806a638') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(176,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:68ef9f05d4e026bf3c6aee96f1e2237e') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(177,'68ef9f05d4e026bf3c6aee96f1e2237e','2e4c8afd4e6603be60e680efd140e8fb:68ef9f05d4e026bf3c6aee96f1e2237e') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(178,'65e23f693ef3282401aee832a4619e0e','65e23f693ef3282401aee832a4619e0e:926ee120-1cd2-4b92-ba2a-c6b7590ee4f6') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(179,'926ee120-1cd2-4b92-ba2a-c6b7590ee4f6','65e23f693ef3282401aee832a4619e0e:926ee120-1cd2-4b92-ba2a-c6b7590ee4f6') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(180,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(181,'6c6c707b-3a07-4f8c-b76e-7bfdce694324','2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(182,'e046e45719e698af8638fb0ab3001a90','e046e45719e698af8638fb0ab3001a90:aa2611bd-827d-4be9-bc70-0dcd04d071f8') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(183,'aa2611bd-827d-4be9-bc70-0dcd04d071f8','e046e45719e698af8638fb0ab3001a90:aa2611bd-827d-4be9-bc70-0dcd04d071f8') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE NODE SET NODE_ORDER=4,ASCENDING=1,VISIBLE=0,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=184,KEY_CHILD=185,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5'  ;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=null,CONTENT_ID='e046e45719e698af8638fb0ab3001a90',CREATION_DATE='2008-01-07 19:45:40',NAME='pt26:Estrutura de Cursos Antiga',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = 'e046e45719e698af8638fb0ab3001a90'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=186,KEY_CHILD=187,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90'  ;

UPDATE NODE SET NODE_ORDER=5,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=188,KEY_CHILD=189,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(184,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(185,'a2dbd965ff55ac88b6974db02f537cc5','2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(186,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(187,'e046e45719e698af8638fb0ab3001a90','2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(188,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(189,'6c6c707b-3a07-4f8c-b76e-7bfdce694324','2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=190,CONTENT_ID='e046e45719e698af8638fb0ab3001a90',CREATION_DATE='2008-01-07 19:45:40',NAME='pt26:Estrutura de Cursos Antiga',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = 'e046e45719e698af8638fb0ab3001a90'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(190,'f832317c-db1e-4c36-b67c-3c4070ccee59','e046e45719e698af8638fb0ab3001a90') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=null,CONTENT_ID='7a7f91fc348bc0eb115e797487be440b',CREATION_DATE='2008-01-07 19:45:40',NAME='pt19:Estrutura de Cursos',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = '7a7f91fc348bc0eb115e797487be440b'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=191,KEY_CHILD=192,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b'  ;

UPDATE NODE SET NODE_ORDER=5,ASCENDING=1,VISIBLE=0,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=193,KEY_CHILD=194,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5'  ;

UPDATE NODE SET NODE_ORDER=4,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=195,KEY_CHILD=196,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90'  ;

UPDATE NODE SET NODE_ORDER=6,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=197,KEY_CHILD=198,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(191,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(192,'7a7f91fc348bc0eb115e797487be440b','2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(193,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(194,'a2dbd965ff55ac88b6974db02f537cc5','2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(195,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(196,'e046e45719e698af8638fb0ab3001a90','2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(197,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(198,'6c6c707b-3a07-4f8c-b76e-7bfdce694324','2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=199,CONTENT_ID='7a7f91fc348bc0eb115e797487be440b',CREATION_DATE='2008-01-07 19:45:40',NAME='pt19:Estrutura de Cursos',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = '7a7f91fc348bc0eb115e797487be440b'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(199,'fe00b1c9-b931-489c-9398-21ddf806a638','7a7f91fc348bc0eb115e797487be440b') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE NODE SET NODE_ORDER=6,ASCENDING=1,VISIBLE=0,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=200,KEY_CHILD=201,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5'  ;

UPDATE NODE SET NODE_ORDER=4,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=202,KEY_CHILD=203,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:68ef9f05d4e026bf3c6aee96f1e2237e',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=204,KEY_CHILD=205,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:68ef9f05d4e026bf3c6aee96f1e2237e'  ;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=null,CONTENT_ID='68ef9f05d4e026bf3c6aee96f1e2237e',CREATION_DATE='2008-01-07 19:45:40',NAME='pt23:Competência Pré-Bolonha',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = '68ef9f05d4e026bf3c6aee96f1e2237e'  ;

UPDATE NODE SET NODE_ORDER=5,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=206,KEY_CHILD=207,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90'  ;

UPDATE NODE SET NODE_ORDER=7,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=208,KEY_CHILD=209,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(200,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(201,'a2dbd965ff55ac88b6974db02f537cc5','2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(202,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(203,'7a7f91fc348bc0eb115e797487be440b','2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(204,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:68ef9f05d4e026bf3c6aee96f1e2237e') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(205,'68ef9f05d4e026bf3c6aee96f1e2237e','2e4c8afd4e6603be60e680efd140e8fb:68ef9f05d4e026bf3c6aee96f1e2237e') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(206,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(207,'e046e45719e698af8638fb0ab3001a90','2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(208,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(209,'6c6c707b-3a07-4f8c-b76e-7bfdce694324','2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=210,CONTENT_ID='68ef9f05d4e026bf3c6aee96f1e2237e',CREATION_DATE='2008-01-07 19:45:40',NAME='pt23:Competência Pré-Bolonha',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = '68ef9f05d4e026bf3c6aee96f1e2237e'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(210,'0cac3f6f-6be4-4476-8681-7b980edbccee','68ef9f05d4e026bf3c6aee96f1e2237e') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=1,KEY_CHILD=2,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5'  ;

UPDATE NODE SET NODE_ORDER=5,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=3,KEY_CHILD=4,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b'  ;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=null,CONTENT_ID='a2dbd965ff55ac88b6974db02f537cc5',CREATION_DATE='2008-01-07 19:45:40',NAME='pt20:Competências Bolonha',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = 'a2dbd965ff55ac88b6974db02f537cc5'  ;

UPDATE NODE SET NODE_ORDER=4,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:68ef9f05d4e026bf3c6aee96f1e2237e',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=5,KEY_CHILD=6,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:68ef9f05d4e026bf3c6aee96f1e2237e'  ;

UPDATE NODE SET NODE_ORDER=6,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=7,KEY_CHILD=8,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90'  ;

UPDATE NODE SET NODE_ORDER=8,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=9,KEY_CHILD=10,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(1,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(2,'a2dbd965ff55ac88b6974db02f537cc5','2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(3,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(4,'7a7f91fc348bc0eb115e797487be440b','2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(5,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:68ef9f05d4e026bf3c6aee96f1e2237e') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(6,'68ef9f05d4e026bf3c6aee96f1e2237e','2e4c8afd4e6603be60e680efd140e8fb:68ef9f05d4e026bf3c6aee96f1e2237e') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(7,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(8,'e046e45719e698af8638fb0ab3001a90','2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(9,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(10,'6c6c707b-3a07-4f8c-b76e-7bfdce694324','2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=11,CONTENT_ID='a2dbd965ff55ac88b6974db02f537cc5',CREATION_DATE='2008-01-07 19:45:40',NAME='pt20:Competências Bolonha',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = 'a2dbd965ff55ac88b6974db02f537cc5'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(11,'50ab74d4-5050-4975-b88c-91b0c39ed493','a2dbd965ff55ac88b6974db02f537cc5') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=12,KEY_CHILD=13,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=14,KEY_CHILD=15,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:68ef9f05d4e026bf3c6aee96f1e2237e',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=16,KEY_CHILD=17,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:68ef9f05d4e026bf3c6aee96f1e2237e'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=18,KEY_CHILD=19,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90'  ;

UPDATE NODE SET NODE_ORDER=4,ASCENDING=1,VISIBLE=1,CONTENT_ID='2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=20,KEY_CHILD=21,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(12,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(13,'7a7f91fc348bc0eb115e797487be440b','2e4c8afd4e6603be60e680efd140e8fb:7a7f91fc348bc0eb115e797487be440b') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(14,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(15,'a2dbd965ff55ac88b6974db02f537cc5','2e4c8afd4e6603be60e680efd140e8fb:a2dbd965ff55ac88b6974db02f537cc5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(16,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:68ef9f05d4e026bf3c6aee96f1e2237e') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(17,'68ef9f05d4e026bf3c6aee96f1e2237e','2e4c8afd4e6603be60e680efd140e8fb:68ef9f05d4e026bf3c6aee96f1e2237e') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(18,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(19,'e046e45719e698af8638fb0ab3001a90','2e4c8afd4e6603be60e680efd140e8fb:e046e45719e698af8638fb0ab3001a90') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(20,'2e4c8afd4e6603be60e680efd140e8fb','2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(21,'6c6c707b-3a07-4f8c-b76e-7bfdce694324','2e4c8afd4e6603be60e680efd140e8fb:6c6c707b-3a07-4f8c-b76e-7bfdce694324') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

INSERT INTO NODE (NODE_ORDER,ASCENDING,VISIBLE,CONTENT_ID,KEY_ROOT_DOMAIN_OBJECT,KEY_PARENT,KEY_CHILD,OJB_CONCRETE_CLASS) VALUES (0,1,1,'ad2e606944f96a0fa5c6756101564d52:56805103-bad2-4b0b-ab11-7377a727353a',1,22,23,'net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode')  ;

INSERT INTO NODE (NODE_ORDER,ASCENDING,VISIBLE,CONTENT_ID,KEY_ROOT_DOMAIN_OBJECT,KEY_PARENT,KEY_CHILD,OJB_CONCRETE_CLASS) VALUES (0,1,1,'8fd4e133a7d4bc48c98b82451efd73ee:29428b37-4aab-48bf-8594-d46834d1f4fb',1,24,25,'net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode')  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='ad2e606944f96a0fa5c6756101564d52:426444f7-88af-4fb2-90a3-a4deaf5c0b81',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=26,KEY_CHILD=27,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'ad2e606944f96a0fa5c6756101564d52:426444f7-88af-4fb2-90a3-a4deaf5c0b81'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=0,CONTENT_ID='6dfbae767183e66ebeb8b63e57ac84ce:8fd4e133a7d4bc48c98b82451efd73ee',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=28,KEY_CHILD=29,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '6dfbae767183e66ebeb8b63e57ac84ce:8fd4e133a7d4bc48c98b82451efd73ee'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='ad2e606944f96a0fa5c6756101564d52:56805103-bad2-4b0b-ab11-7377a727353a',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=30,KEY_CHILD=31,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'ad2e606944f96a0fa5c6756101564d52:56805103-bad2-4b0b-ab11-7377a727353a'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='6dfbae767183e66ebeb8b63e57ac84ce:315710a8-b8b2-4f7d-b0df-11366d255b88',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=32,KEY_CHILD=33,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '6dfbae767183e66ebeb8b63e57ac84ce:315710a8-b8b2-4f7d-b0df-11366d255b88'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=0,CONTENT_ID='6dfbae767183e66ebeb8b63e57ac84ce:ad2e606944f96a0fa5c6756101564d52',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=34,KEY_CHILD=35,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '6dfbae767183e66ebeb8b63e57ac84ce:ad2e606944f96a0fa5c6756101564d52'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='8fd4e133a7d4bc48c98b82451efd73ee:5ef482dcc35bd07c56b919c7904337b5',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=36,KEY_CHILD=37,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '8fd4e133a7d4bc48c98b82451efd73ee:5ef482dcc35bd07c56b919c7904337b5'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='ad2e606944f96a0fa5c6756101564d52:77e493a60bc37804e2addd31ba11107a',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=38,KEY_CHILD=39,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'ad2e606944f96a0fa5c6756101564d52:77e493a60bc37804e2addd31ba11107a'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='8fd4e133a7d4bc48c98b82451efd73ee:29428b37-4aab-48bf-8594-d46834d1f4fb',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=40,KEY_CHILD=41,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '8fd4e133a7d4bc48c98b82451efd73ee:29428b37-4aab-48bf-8594-d46834d1f4fb'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='8fd4e133a7d4bc48c98b82451efd73ee:ebaa7c40-6e4c-4b1c-b5b3-8de5d7d76677',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=42,KEY_CHILD=43,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '8fd4e133a7d4bc48c98b82451efd73ee:ebaa7c40-6e4c-4b1c-b5b3-8de5d7d76677'  ;

DELETE FROM NODE WHERE CONTENT_ID = '6dfbae767183e66ebeb8b63e57ac84ce:56805103-bad2-4b0b-ab11-7377a727353a' ;

DELETE FROM NODE WHERE CONTENT_ID = '6dfbae767183e66ebeb8b63e57ac84ce:29428b37-4aab-48bf-8594-d46834d1f4fb' ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(22,'ad2e606944f96a0fa5c6756101564d52','ad2e606944f96a0fa5c6756101564d52:56805103-bad2-4b0b-ab11-7377a727353a') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(23,'56805103-bad2-4b0b-ab11-7377a727353a','ad2e606944f96a0fa5c6756101564d52:56805103-bad2-4b0b-ab11-7377a727353a') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(24,'8fd4e133a7d4bc48c98b82451efd73ee','8fd4e133a7d4bc48c98b82451efd73ee:29428b37-4aab-48bf-8594-d46834d1f4fb') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(25,'29428b37-4aab-48bf-8594-d46834d1f4fb','8fd4e133a7d4bc48c98b82451efd73ee:29428b37-4aab-48bf-8594-d46834d1f4fb') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(26,'ad2e606944f96a0fa5c6756101564d52','ad2e606944f96a0fa5c6756101564d52:426444f7-88af-4fb2-90a3-a4deaf5c0b81') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(27,'426444f7-88af-4fb2-90a3-a4deaf5c0b81','ad2e606944f96a0fa5c6756101564d52:426444f7-88af-4fb2-90a3-a4deaf5c0b81') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(28,'6dfbae767183e66ebeb8b63e57ac84ce','6dfbae767183e66ebeb8b63e57ac84ce:8fd4e133a7d4bc48c98b82451efd73ee') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(29,'8fd4e133a7d4bc48c98b82451efd73ee','6dfbae767183e66ebeb8b63e57ac84ce:8fd4e133a7d4bc48c98b82451efd73ee') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(30,'ad2e606944f96a0fa5c6756101564d52','ad2e606944f96a0fa5c6756101564d52:56805103-bad2-4b0b-ab11-7377a727353a') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(31,'56805103-bad2-4b0b-ab11-7377a727353a','ad2e606944f96a0fa5c6756101564d52:56805103-bad2-4b0b-ab11-7377a727353a') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(32,'6dfbae767183e66ebeb8b63e57ac84ce','6dfbae767183e66ebeb8b63e57ac84ce:315710a8-b8b2-4f7d-b0df-11366d255b88') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(33,'315710a8-b8b2-4f7d-b0df-11366d255b88','6dfbae767183e66ebeb8b63e57ac84ce:315710a8-b8b2-4f7d-b0df-11366d255b88') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(34,'6dfbae767183e66ebeb8b63e57ac84ce','6dfbae767183e66ebeb8b63e57ac84ce:ad2e606944f96a0fa5c6756101564d52') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(35,'ad2e606944f96a0fa5c6756101564d52','6dfbae767183e66ebeb8b63e57ac84ce:ad2e606944f96a0fa5c6756101564d52') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(36,'8fd4e133a7d4bc48c98b82451efd73ee','8fd4e133a7d4bc48c98b82451efd73ee:5ef482dcc35bd07c56b919c7904337b5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(37,'5ef482dcc35bd07c56b919c7904337b5','8fd4e133a7d4bc48c98b82451efd73ee:5ef482dcc35bd07c56b919c7904337b5') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(38,'ad2e606944f96a0fa5c6756101564d52','ad2e606944f96a0fa5c6756101564d52:77e493a60bc37804e2addd31ba11107a') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(39,'77e493a60bc37804e2addd31ba11107a','ad2e606944f96a0fa5c6756101564d52:77e493a60bc37804e2addd31ba11107a') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(40,'8fd4e133a7d4bc48c98b82451efd73ee','8fd4e133a7d4bc48c98b82451efd73ee:29428b37-4aab-48bf-8594-d46834d1f4fb') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(41,'29428b37-4aab-48bf-8594-d46834d1f4fb','8fd4e133a7d4bc48c98b82451efd73ee:29428b37-4aab-48bf-8594-d46834d1f4fb') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(42,'8fd4e133a7d4bc48c98b82451efd73ee','8fd4e133a7d4bc48c98b82451efd73ee:ebaa7c40-6e4c-4b1c-b5b3-8de5d7d76677') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(43,'ebaa7c40-6e4c-4b1c-b5b3-8de5d7d76677','8fd4e133a7d4bc48c98b82451efd73ee:ebaa7c40-6e4c-4b1c-b5b3-8de5d7d76677') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=0,CONTENT_ID='6dfbae767183e66ebeb8b63e57ac84ce:8fd4e133a7d4bc48c98b82451efd73ee',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=211,KEY_CHILD=212,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '6dfbae767183e66ebeb8b63e57ac84ce:8fd4e133a7d4bc48c98b82451efd73ee'  ;

UPDATE NODE SET NODE_ORDER=4,ASCENDING=1,VISIBLE=1,CONTENT_ID='6dfbae767183e66ebeb8b63e57ac84ce:315710a8-b8b2-4f7d-b0df-11366d255b88',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=213,KEY_CHILD=214,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '6dfbae767183e66ebeb8b63e57ac84ce:315710a8-b8b2-4f7d-b0df-11366d255b88'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='6dfbae767183e66ebeb8b63e57ac84ce:ad2e606944f96a0fa5c6756101564d52',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=215,KEY_CHILD=216,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '6dfbae767183e66ebeb8b63e57ac84ce:ad2e606944f96a0fa5c6756101564d52'  ;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=null,CONTENT_ID='ad2e606944f96a0fa5c6756101564d52',CREATION_DATE='2008-01-07 19:45:40',NAME='pt19:Currículos Execução',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = 'ad2e606944f96a0fa5c6756101564d52'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(211,'6dfbae767183e66ebeb8b63e57ac84ce','6dfbae767183e66ebeb8b63e57ac84ce:8fd4e133a7d4bc48c98b82451efd73ee') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(212,'8fd4e133a7d4bc48c98b82451efd73ee','6dfbae767183e66ebeb8b63e57ac84ce:8fd4e133a7d4bc48c98b82451efd73ee') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(213,'6dfbae767183e66ebeb8b63e57ac84ce','6dfbae767183e66ebeb8b63e57ac84ce:315710a8-b8b2-4f7d-b0df-11366d255b88') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(214,'315710a8-b8b2-4f7d-b0df-11366d255b88','6dfbae767183e66ebeb8b63e57ac84ce:315710a8-b8b2-4f7d-b0df-11366d255b88') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(215,'6dfbae767183e66ebeb8b63e57ac84ce','6dfbae767183e66ebeb8b63e57ac84ce:ad2e606944f96a0fa5c6756101564d52') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(216,'ad2e606944f96a0fa5c6756101564d52','6dfbae767183e66ebeb8b63e57ac84ce:ad2e606944f96a0fa5c6756101564d52') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=217,CONTENT_ID='ad2e606944f96a0fa5c6756101564d52',CREATION_DATE='2008-01-07 19:45:40',NAME='pt19:Currículos Execução',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = 'ad2e606944f96a0fa5c6756101564d52'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(217,'56805103-bad2-4b0b-ab11-7377a727353a','ad2e606944f96a0fa5c6756101564d52') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=null,CONTENT_ID='8fd4e133a7d4bc48c98b82451efd73ee',CREATION_DATE='2008-01-07 19:45:40',NAME='pt20:Disciplinas Execução',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = '8fd4e133a7d4bc48c98b82451efd73ee'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='6dfbae767183e66ebeb8b63e57ac84ce:8fd4e133a7d4bc48c98b82451efd73ee',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=218,KEY_CHILD=219,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '6dfbae767183e66ebeb8b63e57ac84ce:8fd4e133a7d4bc48c98b82451efd73ee'  ;

UPDATE NODE SET NODE_ORDER=5,ASCENDING=1,VISIBLE=1,CONTENT_ID='6dfbae767183e66ebeb8b63e57ac84ce:315710a8-b8b2-4f7d-b0df-11366d255b88',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=220,KEY_CHILD=221,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '6dfbae767183e66ebeb8b63e57ac84ce:315710a8-b8b2-4f7d-b0df-11366d255b88'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='6dfbae767183e66ebeb8b63e57ac84ce:ad2e606944f96a0fa5c6756101564d52',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=222,KEY_CHILD=223,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '6dfbae767183e66ebeb8b63e57ac84ce:ad2e606944f96a0fa5c6756101564d52'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(218,'6dfbae767183e66ebeb8b63e57ac84ce','6dfbae767183e66ebeb8b63e57ac84ce:8fd4e133a7d4bc48c98b82451efd73ee') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(219,'8fd4e133a7d4bc48c98b82451efd73ee','6dfbae767183e66ebeb8b63e57ac84ce:8fd4e133a7d4bc48c98b82451efd73ee') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(220,'6dfbae767183e66ebeb8b63e57ac84ce','6dfbae767183e66ebeb8b63e57ac84ce:315710a8-b8b2-4f7d-b0df-11366d255b88') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(221,'315710a8-b8b2-4f7d-b0df-11366d255b88','6dfbae767183e66ebeb8b63e57ac84ce:315710a8-b8b2-4f7d-b0df-11366d255b88') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(222,'6dfbae767183e66ebeb8b63e57ac84ce','6dfbae767183e66ebeb8b63e57ac84ce:ad2e606944f96a0fa5c6756101564d52') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(223,'ad2e606944f96a0fa5c6756101564d52','6dfbae767183e66ebeb8b63e57ac84ce:ad2e606944f96a0fa5c6756101564d52') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=224,CONTENT_ID='8fd4e133a7d4bc48c98b82451efd73ee',CREATION_DATE='2008-01-07 19:45:40',NAME='pt20:Disciplinas Execução',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = '8fd4e133a7d4bc48c98b82451efd73ee'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(224,'29428b37-4aab-48bf-8594-d46834d1f4fb','8fd4e133a7d4bc48c98b82451efd73ee') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='6dfbae767183e66ebeb8b63e57ac84ce:315710a8-b8b2-4f7d-b0df-11366d255b88',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=225,KEY_CHILD=226,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '6dfbae767183e66ebeb8b63e57ac84ce:315710a8-b8b2-4f7d-b0df-11366d255b88'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(225,'6dfbae767183e66ebeb8b63e57ac84ce','6dfbae767183e66ebeb8b63e57ac84ce:315710a8-b8b2-4f7d-b0df-11366d255b88') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(226,'315710a8-b8b2-4f7d-b0df-11366d255b88','6dfbae767183e66ebeb8b63e57ac84ce:315710a8-b8b2-4f7d-b0df-11366d255b88') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

INSERT INTO NODE (NODE_ORDER,ASCENDING,VISIBLE,CONTENT_ID,KEY_ROOT_DOMAIN_OBJECT,KEY_PARENT,KEY_CHILD,OJB_CONCRETE_CLASS) VALUES (0,1,1,'43581ca19819a7ac1592dfec7a667204:a537b475-cf4d-4df1-9b6b-c72d59205a51',1,227,228,'net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode')  ;

INSERT INTO NODE (NODE_ORDER,ASCENDING,VISIBLE,CONTENT_ID,KEY_ROOT_DOMAIN_OBJECT,KEY_PARENT,KEY_CHILD,OJB_CONCRETE_CLASS) VALUES (0,1,1,'75ba6406255175643e45901f4a1b1193:e859bbf1-1a55-496a-b554-5ba04028532d',1,229,230,'net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode')  ;

INSERT INTO NODE (NODE_ORDER,ASCENDING,VISIBLE,CONTENT_ID,KEY_ROOT_DOMAIN_OBJECT,KEY_PARENT,KEY_CHILD,OJB_CONCRETE_CLASS) VALUES (0,1,1,'b01d51b62c7833958a011dd765920d7c:906535e5-bd95-4c4f-aa2a-f97dc08efa6a',1,231,232,'net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode')  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=233,KEY_CHILD=234,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='43581ca19819a7ac1592dfec7a667204:a537b475-cf4d-4df1-9b6b-c72d59205a51',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=235,KEY_CHILD=236,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '43581ca19819a7ac1592dfec7a667204:a537b475-cf4d-4df1-9b6b-c72d59205a51'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=0,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=237,KEY_CHILD=238,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='75ba6406255175643e45901f4a1b1193:e859bbf1-1a55-496a-b554-5ba04028532d',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=239,KEY_CHILD=240,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '75ba6406255175643e45901f4a1b1193:e859bbf1-1a55-496a-b554-5ba04028532d'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=0,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:b01d51b62c7833958a011dd765920d7c',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=241,KEY_CHILD=242,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:b01d51b62c7833958a011dd765920d7c'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='43581ca19819a7ac1592dfec7a667204:faef50a575c9dc5a8a3fdc7f79128aa8',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=243,KEY_CHILD=244,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '43581ca19819a7ac1592dfec7a667204:faef50a575c9dc5a8a3fdc7f79128aa8'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='b01d51b62c7833958a011dd765920d7c:906535e5-bd95-4c4f-aa2a-f97dc08efa6a',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=245,KEY_CHILD=246,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'b01d51b62c7833958a011dd765920d7c:906535e5-bd95-4c4f-aa2a-f97dc08efa6a'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='75ba6406255175643e45901f4a1b1193:ac817de7-3060-4c7b-b8a9-3ae9742fd00b',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=247,KEY_CHILD=248,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '75ba6406255175643e45901f4a1b1193:ac817de7-3060-4c7b-b8a9-3ae9742fd00b'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='43581ca19819a7ac1592dfec7a667204:8f5d4995-1a9e-4eb4-893a-217b6771b61e',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=249,KEY_CHILD=250,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '43581ca19819a7ac1592dfec7a667204:8f5d4995-1a9e-4eb4-893a-217b6771b61e'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='b01d51b62c7833958a011dd765920d7c:5cd91f0f-dd3e-40bb-b468-dd2c58dade36',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=251,KEY_CHILD=252,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'b01d51b62c7833958a011dd765920d7c:5cd91f0f-dd3e-40bb-b468-dd2c58dade36'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='75ba6406255175643e45901f4a1b1193:7c0bb181b14a6d010836f802138e20ee',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=253,KEY_CHILD=254,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '75ba6406255175643e45901f4a1b1193:7c0bb181b14a6d010836f802138e20ee'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=0,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=255,KEY_CHILD=256,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204'  ;

DELETE FROM NODE WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:906535e5-bd95-4c4f-aa2a-f97dc08efa6a' ;

DELETE FROM NODE WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:a537b475-cf4d-4df1-9b6b-c72d59205a51' ;

DELETE FROM NODE WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:e859bbf1-1a55-496a-b554-5ba04028532d' ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(227,'43581ca19819a7ac1592dfec7a667204','43581ca19819a7ac1592dfec7a667204:a537b475-cf4d-4df1-9b6b-c72d59205a51') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(228,'a537b475-cf4d-4df1-9b6b-c72d59205a51','43581ca19819a7ac1592dfec7a667204:a537b475-cf4d-4df1-9b6b-c72d59205a51') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(229,'75ba6406255175643e45901f4a1b1193','75ba6406255175643e45901f4a1b1193:e859bbf1-1a55-496a-b554-5ba04028532d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(230,'e859bbf1-1a55-496a-b554-5ba04028532d','75ba6406255175643e45901f4a1b1193:e859bbf1-1a55-496a-b554-5ba04028532d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(231,'b01d51b62c7833958a011dd765920d7c','b01d51b62c7833958a011dd765920d7c:906535e5-bd95-4c4f-aa2a-f97dc08efa6a') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(232,'906535e5-bd95-4c4f-aa2a-f97dc08efa6a','b01d51b62c7833958a011dd765920d7c:906535e5-bd95-4c4f-aa2a-f97dc08efa6a') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(233,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(234,'517e456a-3aba-4913-9445-ec7cef27f5b3','d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(235,'43581ca19819a7ac1592dfec7a667204','43581ca19819a7ac1592dfec7a667204:a537b475-cf4d-4df1-9b6b-c72d59205a51') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(236,'a537b475-cf4d-4df1-9b6b-c72d59205a51','43581ca19819a7ac1592dfec7a667204:a537b475-cf4d-4df1-9b6b-c72d59205a51') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(237,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(238,'75ba6406255175643e45901f4a1b1193','d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(239,'75ba6406255175643e45901f4a1b1193','75ba6406255175643e45901f4a1b1193:e859bbf1-1a55-496a-b554-5ba04028532d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(240,'e859bbf1-1a55-496a-b554-5ba04028532d','75ba6406255175643e45901f4a1b1193:e859bbf1-1a55-496a-b554-5ba04028532d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(241,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:b01d51b62c7833958a011dd765920d7c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(242,'b01d51b62c7833958a011dd765920d7c','d4139d56d74eb984154187ab9912cee4:b01d51b62c7833958a011dd765920d7c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(243,'43581ca19819a7ac1592dfec7a667204','43581ca19819a7ac1592dfec7a667204:faef50a575c9dc5a8a3fdc7f79128aa8') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(244,'faef50a575c9dc5a8a3fdc7f79128aa8','43581ca19819a7ac1592dfec7a667204:faef50a575c9dc5a8a3fdc7f79128aa8') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(245,'b01d51b62c7833958a011dd765920d7c','b01d51b62c7833958a011dd765920d7c:906535e5-bd95-4c4f-aa2a-f97dc08efa6a') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(246,'906535e5-bd95-4c4f-aa2a-f97dc08efa6a','b01d51b62c7833958a011dd765920d7c:906535e5-bd95-4c4f-aa2a-f97dc08efa6a') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(247,'75ba6406255175643e45901f4a1b1193','75ba6406255175643e45901f4a1b1193:ac817de7-3060-4c7b-b8a9-3ae9742fd00b') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(248,'ac817de7-3060-4c7b-b8a9-3ae9742fd00b','75ba6406255175643e45901f4a1b1193:ac817de7-3060-4c7b-b8a9-3ae9742fd00b') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(249,'43581ca19819a7ac1592dfec7a667204','43581ca19819a7ac1592dfec7a667204:8f5d4995-1a9e-4eb4-893a-217b6771b61e') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(250,'8f5d4995-1a9e-4eb4-893a-217b6771b61e','43581ca19819a7ac1592dfec7a667204:8f5d4995-1a9e-4eb4-893a-217b6771b61e') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(251,'b01d51b62c7833958a011dd765920d7c','b01d51b62c7833958a011dd765920d7c:5cd91f0f-dd3e-40bb-b468-dd2c58dade36') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(252,'5cd91f0f-dd3e-40bb-b468-dd2c58dade36','b01d51b62c7833958a011dd765920d7c:5cd91f0f-dd3e-40bb-b468-dd2c58dade36') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(253,'75ba6406255175643e45901f4a1b1193','75ba6406255175643e45901f4a1b1193:7c0bb181b14a6d010836f802138e20ee') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(254,'7c0bb181b14a6d010836f802138e20ee','75ba6406255175643e45901f4a1b1193:7c0bb181b14a6d010836f802138e20ee') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(255,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(256,'43581ca19819a7ac1592dfec7a667204','d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE NODE SET NODE_ORDER=4,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=257,KEY_CHILD=258,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3'  ;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=null,CONTENT_ID='75ba6406255175643e45901f4a1b1193',CREATION_DATE='2008-01-07 19:45:40',NAME='pt18:Gestão de Docentes',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = '75ba6406255175643e45901f4a1b1193'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=259,KEY_CHILD=260,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=0,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=261,KEY_CHILD=262,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(257,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(258,'517e456a-3aba-4913-9445-ec7cef27f5b3','d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(259,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(260,'75ba6406255175643e45901f4a1b1193','d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(261,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(262,'43581ca19819a7ac1592dfec7a667204','d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=263,CONTENT_ID='75ba6406255175643e45901f4a1b1193',CREATION_DATE='2008-01-07 19:45:40',NAME='pt18:Gestão de Docentes',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = '75ba6406255175643e45901f4a1b1193'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(263,'e859bbf1-1a55-496a-b554-5ba04028532d','75ba6406255175643e45901f4a1b1193') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE NODE SET NODE_ORDER=5,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=264,KEY_CHILD=265,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=266,KEY_CHILD=267,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193'  ;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=null,CONTENT_ID='43581ca19819a7ac1592dfec7a667204',CREATION_DATE='2008-01-07 19:45:40',NAME='pt17:Gestão de Pessoas',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = '43581ca19819a7ac1592dfec7a667204'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=268,KEY_CHILD=269,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(264,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(265,'517e456a-3aba-4913-9445-ec7cef27f5b3','d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(266,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(267,'75ba6406255175643e45901f4a1b1193','d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(268,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(269,'43581ca19819a7ac1592dfec7a667204','d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=270,CONTENT_ID='43581ca19819a7ac1592dfec7a667204',CREATION_DATE='2008-01-07 19:45:40',NAME='pt17:Gestão de Pessoas',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = '43581ca19819a7ac1592dfec7a667204'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(270,'a537b475-cf4d-4df1-9b6b-c72d59205a51','43581ca19819a7ac1592dfec7a667204') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE NODE SET NODE_ORDER=6,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=271,KEY_CHILD=272,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3'  ;

UPDATE NODE SET NODE_ORDER=4,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=273,KEY_CHILD=274,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:b01d51b62c7833958a011dd765920d7c',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=275,KEY_CHILD=276,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:b01d51b62c7833958a011dd765920d7c'  ;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=null,CONTENT_ID='b01d51b62c7833958a011dd765920d7c',CREATION_DATE='2008-01-07 19:45:40',NAME='pt16:Gestão de Alunos',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = 'b01d51b62c7833958a011dd765920d7c'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=277,KEY_CHILD=278,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(271,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(272,'517e456a-3aba-4913-9445-ec7cef27f5b3','d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(273,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(274,'75ba6406255175643e45901f4a1b1193','d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(275,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:b01d51b62c7833958a011dd765920d7c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(276,'b01d51b62c7833958a011dd765920d7c','d4139d56d74eb984154187ab9912cee4:b01d51b62c7833958a011dd765920d7c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(277,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(278,'43581ca19819a7ac1592dfec7a667204','d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=279,CONTENT_ID='b01d51b62c7833958a011dd765920d7c',CREATION_DATE='2008-01-07 19:45:40',NAME='pt16:Gestão de Alunos',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = 'b01d51b62c7833958a011dd765920d7c'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(279,'906535e5-bd95-4c4f-aa2a-f97dc08efa6a','b01d51b62c7833958a011dd765920d7c') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE NODE SET NODE_ORDER=4,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=280,KEY_CHILD=281,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3'  ;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=282,KEY_CHILD=283,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:b01d51b62c7833958a011dd765920d7c',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=284,KEY_CHILD=285,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:b01d51b62c7833958a011dd765920d7c'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=286,KEY_CHILD=287,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(280,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(281,'517e456a-3aba-4913-9445-ec7cef27f5b3','d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(282,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(283,'75ba6406255175643e45901f4a1b1193','d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(284,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:b01d51b62c7833958a011dd765920d7c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(285,'b01d51b62c7833958a011dd765920d7c','d4139d56d74eb984154187ab9912cee4:b01d51b62c7833958a011dd765920d7c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(286,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(287,'43581ca19819a7ac1592dfec7a667204','d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE NODE SET NODE_ORDER=3,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=288,KEY_CHILD=289,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=290,KEY_CHILD=291,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:b01d51b62c7833958a011dd765920d7c',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=292,KEY_CHILD=293,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:b01d51b62c7833958a011dd765920d7c'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=294,KEY_CHILD=295,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(288,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(289,'517e456a-3aba-4913-9445-ec7cef27f5b3','d4139d56d74eb984154187ab9912cee4:517e456a-3aba-4913-9445-ec7cef27f5b3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(290,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(291,'75ba6406255175643e45901f4a1b1193','d4139d56d74eb984154187ab9912cee4:75ba6406255175643e45901f4a1b1193') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(292,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:b01d51b62c7833958a011dd765920d7c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(293,'b01d51b62c7833958a011dd765920d7c','d4139d56d74eb984154187ab9912cee4:b01d51b62c7833958a011dd765920d7c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(294,'d4139d56d74eb984154187ab9912cee4','d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(295,'43581ca19819a7ac1592dfec7a667204','d4139d56d74eb984154187ab9912cee4:43581ca19819a7ac1592dfec7a667204') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

INSERT INTO NODE (NODE_ORDER,ASCENDING,VISIBLE,CONTENT_ID,KEY_ROOT_DOMAIN_OBJECT,KEY_PARENT,KEY_CHILD,OJB_CONCRETE_CLASS) VALUES (0,1,1,'d3cec9433f13d7746edda54416b6f67d:630d2099-b0ad-46f6-a413-5fb7a8472b2f',1,296,297,'net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode')  ;

INSERT INTO NODE (NODE_ORDER,ASCENDING,VISIBLE,CONTENT_ID,KEY_ROOT_DOMAIN_OBJECT,KEY_PARENT,KEY_CHILD,OJB_CONCRETE_CLASS) VALUES (0,1,1,'f15cfb0081f849670ea0a1c9c09e348c:35e7a0f2-5cd7-4a0d-ae68-003dd109ef4f',1,298,299,'net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode')  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='d3cec9433f13d7746edda54416b6f67d:630d2099-b0ad-46f6-a413-5fb7a8472b2f',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=300,KEY_CHILD=301,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd3cec9433f13d7746edda54416b6f67d:630d2099-b0ad-46f6-a413-5fb7a8472b2f'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='f15cfb0081f849670ea0a1c9c09e348c:a53b5eb5acfbbc861b537f4174371aff',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=302,KEY_CHILD=303,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'f15cfb0081f849670ea0a1c9c09e348c:a53b5eb5acfbbc861b537f4174371aff'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=0,CONTENT_ID='f23f84e7d82cd6e887e14def141945b0:f15cfb0081f849670ea0a1c9c09e348c',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=304,KEY_CHILD=305,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'f23f84e7d82cd6e887e14def141945b0:f15cfb0081f849670ea0a1c9c09e348c'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='f15cfb0081f849670ea0a1c9c09e348c:35e7a0f2-5cd7-4a0d-ae68-003dd109ef4f',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=306,KEY_CHILD=307,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'f15cfb0081f849670ea0a1c9c09e348c:35e7a0f2-5cd7-4a0d-ae68-003dd109ef4f'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='f15cfb0081f849670ea0a1c9c09e348c:77aa114a-d30c-4e8b-ae49-fc0a67af39bf',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=308,KEY_CHILD=309,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'f15cfb0081f849670ea0a1c9c09e348c:77aa114a-d30c-4e8b-ae49-fc0a67af39bf'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='d3cec9433f13d7746edda54416b6f67d:15cb9619ffc73f39e4bf3c5c839cadcf',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=310,KEY_CHILD=311,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd3cec9433f13d7746edda54416b6f67d:15cb9619ffc73f39e4bf3c5c839cadcf'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=0,CONTENT_ID='f23f84e7d82cd6e887e14def141945b0:d3cec9433f13d7746edda54416b6f67d',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=312,KEY_CHILD=313,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'f23f84e7d82cd6e887e14def141945b0:d3cec9433f13d7746edda54416b6f67d'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='d3cec9433f13d7746edda54416b6f67d:11ad09ff-9f7c-4a1a-bf47-b4cbfac3248e',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=314,KEY_CHILD=315,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'd3cec9433f13d7746edda54416b6f67d:11ad09ff-9f7c-4a1a-bf47-b4cbfac3248e'  ;

DELETE FROM NODE WHERE CONTENT_ID = 'f23f84e7d82cd6e887e14def141945b0:35e7a0f2-5cd7-4a0d-ae68-003dd109ef4f' ;

DELETE FROM NODE WHERE CONTENT_ID = 'f23f84e7d82cd6e887e14def141945b0:630d2099-b0ad-46f6-a413-5fb7a8472b2f' ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(296,'d3cec9433f13d7746edda54416b6f67d','d3cec9433f13d7746edda54416b6f67d:630d2099-b0ad-46f6-a413-5fb7a8472b2f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(297,'630d2099-b0ad-46f6-a413-5fb7a8472b2f','d3cec9433f13d7746edda54416b6f67d:630d2099-b0ad-46f6-a413-5fb7a8472b2f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(298,'f15cfb0081f849670ea0a1c9c09e348c','f15cfb0081f849670ea0a1c9c09e348c:35e7a0f2-5cd7-4a0d-ae68-003dd109ef4f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(299,'35e7a0f2-5cd7-4a0d-ae68-003dd109ef4f','f15cfb0081f849670ea0a1c9c09e348c:35e7a0f2-5cd7-4a0d-ae68-003dd109ef4f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(300,'d3cec9433f13d7746edda54416b6f67d','d3cec9433f13d7746edda54416b6f67d:630d2099-b0ad-46f6-a413-5fb7a8472b2f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(301,'630d2099-b0ad-46f6-a413-5fb7a8472b2f','d3cec9433f13d7746edda54416b6f67d:630d2099-b0ad-46f6-a413-5fb7a8472b2f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(302,'f15cfb0081f849670ea0a1c9c09e348c','f15cfb0081f849670ea0a1c9c09e348c:a53b5eb5acfbbc861b537f4174371aff') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(303,'a53b5eb5acfbbc861b537f4174371aff','f15cfb0081f849670ea0a1c9c09e348c:a53b5eb5acfbbc861b537f4174371aff') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(304,'f23f84e7d82cd6e887e14def141945b0','f23f84e7d82cd6e887e14def141945b0:f15cfb0081f849670ea0a1c9c09e348c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(305,'f15cfb0081f849670ea0a1c9c09e348c','f23f84e7d82cd6e887e14def141945b0:f15cfb0081f849670ea0a1c9c09e348c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(306,'f15cfb0081f849670ea0a1c9c09e348c','f15cfb0081f849670ea0a1c9c09e348c:35e7a0f2-5cd7-4a0d-ae68-003dd109ef4f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(307,'35e7a0f2-5cd7-4a0d-ae68-003dd109ef4f','f15cfb0081f849670ea0a1c9c09e348c:35e7a0f2-5cd7-4a0d-ae68-003dd109ef4f') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(308,'f15cfb0081f849670ea0a1c9c09e348c','f15cfb0081f849670ea0a1c9c09e348c:77aa114a-d30c-4e8b-ae49-fc0a67af39bf') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(309,'77aa114a-d30c-4e8b-ae49-fc0a67af39bf','f15cfb0081f849670ea0a1c9c09e348c:77aa114a-d30c-4e8b-ae49-fc0a67af39bf') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(310,'d3cec9433f13d7746edda54416b6f67d','d3cec9433f13d7746edda54416b6f67d:15cb9619ffc73f39e4bf3c5c839cadcf') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(311,'15cb9619ffc73f39e4bf3c5c839cadcf','d3cec9433f13d7746edda54416b6f67d:15cb9619ffc73f39e4bf3c5c839cadcf') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(312,'f23f84e7d82cd6e887e14def141945b0','f23f84e7d82cd6e887e14def141945b0:d3cec9433f13d7746edda54416b6f67d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(313,'d3cec9433f13d7746edda54416b6f67d','f23f84e7d82cd6e887e14def141945b0:d3cec9433f13d7746edda54416b6f67d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(314,'d3cec9433f13d7746edda54416b6f67d','d3cec9433f13d7746edda54416b6f67d:11ad09ff-9f7c-4a1a-bf47-b4cbfac3248e') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(315,'11ad09ff-9f7c-4a1a-bf47-b4cbfac3248e','d3cec9433f13d7746edda54416b6f67d:11ad09ff-9f7c-4a1a-bf47-b4cbfac3248e') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='f23f84e7d82cd6e887e14def141945b0:f15cfb0081f849670ea0a1c9c09e348c',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=44,KEY_CHILD=45,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'f23f84e7d82cd6e887e14def141945b0:f15cfb0081f849670ea0a1c9c09e348c'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=0,CONTENT_ID='f23f84e7d82cd6e887e14def141945b0:d3cec9433f13d7746edda54416b6f67d',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=46,KEY_CHILD=47,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'f23f84e7d82cd6e887e14def141945b0:d3cec9433f13d7746edda54416b6f67d'  ;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=null,CONTENT_ID='f15cfb0081f849670ea0a1c9c09e348c',CREATION_DATE='2008-01-07 19:45:40',NAME='pt20:Geração de Ficheiros',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = 'f15cfb0081f849670ea0a1c9c09e348c'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(44,'f23f84e7d82cd6e887e14def141945b0','f23f84e7d82cd6e887e14def141945b0:f15cfb0081f849670ea0a1c9c09e348c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(45,'f15cfb0081f849670ea0a1c9c09e348c','f23f84e7d82cd6e887e14def141945b0:f15cfb0081f849670ea0a1c9c09e348c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(46,'f23f84e7d82cd6e887e14def141945b0','f23f84e7d82cd6e887e14def141945b0:d3cec9433f13d7746edda54416b6f67d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(47,'d3cec9433f13d7746edda54416b6f67d','f23f84e7d82cd6e887e14def141945b0:d3cec9433f13d7746edda54416b6f67d') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=48,CONTENT_ID='f15cfb0081f849670ea0a1c9c09e348c',CREATION_DATE='2008-01-07 19:45:40',NAME='pt20:Geração de Ficheiros',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = 'f15cfb0081f849670ea0a1c9c09e348c'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(48,'35e7a0f2-5cd7-4a0d-ae68-003dd109ef4f','f15cfb0081f849670ea0a1c9c09e348c') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=null,CONTENT_ID='d3cec9433f13d7746edda54416b6f67d',CREATION_DATE='2008-01-07 19:45:40',NAME='pt19:Upload de Ficheiros',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = 'd3cec9433f13d7746edda54416b6f67d'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='f23f84e7d82cd6e887e14def141945b0:f15cfb0081f849670ea0a1c9c09e348c',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=49,KEY_CHILD=50,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'f23f84e7d82cd6e887e14def141945b0:f15cfb0081f849670ea0a1c9c09e348c'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='f23f84e7d82cd6e887e14def141945b0:d3cec9433f13d7746edda54416b6f67d',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=51,KEY_CHILD=52,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'f23f84e7d82cd6e887e14def141945b0:d3cec9433f13d7746edda54416b6f67d'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(49,'f23f84e7d82cd6e887e14def141945b0','f23f84e7d82cd6e887e14def141945b0:f15cfb0081f849670ea0a1c9c09e348c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(50,'f15cfb0081f849670ea0a1c9c09e348c','f23f84e7d82cd6e887e14def141945b0:f15cfb0081f849670ea0a1c9c09e348c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(51,'f23f84e7d82cd6e887e14def141945b0','f23f84e7d82cd6e887e14def141945b0:d3cec9433f13d7746edda54416b6f67d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(52,'d3cec9433f13d7746edda54416b6f67d','f23f84e7d82cd6e887e14def141945b0:d3cec9433f13d7746edda54416b6f67d') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=53,CONTENT_ID='d3cec9433f13d7746edda54416b6f67d',CREATION_DATE='2008-01-07 19:45:40',NAME='pt19:Upload de Ficheiros',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = 'd3cec9433f13d7746edda54416b6f67d'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(53,'630d2099-b0ad-46f6-a413-5fb7a8472b2f','d3cec9433f13d7746edda54416b6f67d') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='f23f84e7d82cd6e887e14def141945b0:f15cfb0081f849670ea0a1c9c09e348c',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=54,KEY_CHILD=55,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'f23f84e7d82cd6e887e14def141945b0:f15cfb0081f849670ea0a1c9c09e348c'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='f23f84e7d82cd6e887e14def141945b0:d3cec9433f13d7746edda54416b6f67d',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=56,KEY_CHILD=57,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'f23f84e7d82cd6e887e14def141945b0:d3cec9433f13d7746edda54416b6f67d'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(54,'f23f84e7d82cd6e887e14def141945b0','f23f84e7d82cd6e887e14def141945b0:f15cfb0081f849670ea0a1c9c09e348c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(55,'f15cfb0081f849670ea0a1c9c09e348c','f23f84e7d82cd6e887e14def141945b0:f15cfb0081f849670ea0a1c9c09e348c') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(56,'f23f84e7d82cd6e887e14def141945b0','f23f84e7d82cd6e887e14def141945b0:d3cec9433f13d7746edda54416b6f67d') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(57,'d3cec9433f13d7746edda54416b6f67d','f23f84e7d82cd6e887e14def141945b0:d3cec9433f13d7746edda54416b6f67d') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

INSERT INTO NODE (NODE_ORDER,ASCENDING,VISIBLE,CONTENT_ID,KEY_ROOT_DOMAIN_OBJECT,KEY_PARENT,KEY_CHILD,OJB_CONCRETE_CLASS) VALUES (0,1,1,'a8b4281cf87a0977971434b8345a1c55:53869e02-a164-464a-b035-f9c16da169b3',1,58,59,'net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode')  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='a8b4281cf87a0977971434b8345a1c55:c2a64393f10ab6411f857af8d9412b32',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=60,KEY_CHILD=61,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'a8b4281cf87a0977971434b8345a1c55:c2a64393f10ab6411f857af8d9412b32'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='a8b4281cf87a0977971434b8345a1c55:12db3d4c-d787-4ac1-8fb1-fc9ad9981d27',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=62,KEY_CHILD=63,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'a8b4281cf87a0977971434b8345a1c55:12db3d4c-d787-4ac1-8fb1-fc9ad9981d27'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=0,CONTENT_ID='23393306d6da5ad5313d322e32d2fb0f:a8b4281cf87a0977971434b8345a1c55',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=64,KEY_CHILD=65,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '23393306d6da5ad5313d322e32d2fb0f:a8b4281cf87a0977971434b8345a1c55'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='a8b4281cf87a0977971434b8345a1c55:53869e02-a164-464a-b035-f9c16da169b3',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=66,KEY_CHILD=67,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = 'a8b4281cf87a0977971434b8345a1c55:53869e02-a164-464a-b035-f9c16da169b3'  ;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='23393306d6da5ad5313d322e32d2fb0f:dab7318f-95b2-4b28-9655-97706ece0d27',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=68,KEY_CHILD=69,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '23393306d6da5ad5313d322e32d2fb0f:dab7318f-95b2-4b28-9655-97706ece0d27'  ;

DELETE FROM NODE WHERE CONTENT_ID = '23393306d6da5ad5313d322e32d2fb0f:53869e02-a164-464a-b035-f9c16da169b3' ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(58,'a8b4281cf87a0977971434b8345a1c55','a8b4281cf87a0977971434b8345a1c55:53869e02-a164-464a-b035-f9c16da169b3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(59,'53869e02-a164-464a-b035-f9c16da169b3','a8b4281cf87a0977971434b8345a1c55:53869e02-a164-464a-b035-f9c16da169b3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(60,'a8b4281cf87a0977971434b8345a1c55','a8b4281cf87a0977971434b8345a1c55:c2a64393f10ab6411f857af8d9412b32') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(61,'c2a64393f10ab6411f857af8d9412b32','a8b4281cf87a0977971434b8345a1c55:c2a64393f10ab6411f857af8d9412b32') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(62,'a8b4281cf87a0977971434b8345a1c55','a8b4281cf87a0977971434b8345a1c55:12db3d4c-d787-4ac1-8fb1-fc9ad9981d27') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(63,'12db3d4c-d787-4ac1-8fb1-fc9ad9981d27','a8b4281cf87a0977971434b8345a1c55:12db3d4c-d787-4ac1-8fb1-fc9ad9981d27') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(64,'23393306d6da5ad5313d322e32d2fb0f','23393306d6da5ad5313d322e32d2fb0f:a8b4281cf87a0977971434b8345a1c55') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(65,'a8b4281cf87a0977971434b8345a1c55','23393306d6da5ad5313d322e32d2fb0f:a8b4281cf87a0977971434b8345a1c55') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(66,'a8b4281cf87a0977971434b8345a1c55','a8b4281cf87a0977971434b8345a1c55:53869e02-a164-464a-b035-f9c16da169b3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(67,'53869e02-a164-464a-b035-f9c16da169b3','a8b4281cf87a0977971434b8345a1c55:53869e02-a164-464a-b035-f9c16da169b3') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(68,'23393306d6da5ad5313d322e32d2fb0f','23393306d6da5ad5313d322e32d2fb0f:dab7318f-95b2-4b28-9655-97706ece0d27') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(69,'dab7318f-95b2-4b28-9655-97706ece0d27','23393306d6da5ad5313d322e32d2fb0f:dab7318f-95b2-4b28-9655-97706ece0d27') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=null,CONTENT_ID='a8b4281cf87a0977971434b8345a1c55',CREATION_DATE='2008-01-07 19:45:40',NAME='pt15:Gestão de Guias',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = 'a8b4281cf87a0977971434b8345a1c55'  ;

UPDATE NODE SET NODE_ORDER=0,ASCENDING=1,VISIBLE=1,CONTENT_ID='23393306d6da5ad5313d322e32d2fb0f:a8b4281cf87a0977971434b8345a1c55',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=70,KEY_CHILD=71,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '23393306d6da5ad5313d322e32d2fb0f:a8b4281cf87a0977971434b8345a1c55'  ;

UPDATE NODE SET NODE_ORDER=2,ASCENDING=1,VISIBLE=1,CONTENT_ID='23393306d6da5ad5313d322e32d2fb0f:dab7318f-95b2-4b28-9655-97706ece0d27',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=72,KEY_CHILD=73,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '23393306d6da5ad5313d322e32d2fb0f:dab7318f-95b2-4b28-9655-97706ece0d27'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(70,'23393306d6da5ad5313d322e32d2fb0f','23393306d6da5ad5313d322e32d2fb0f:a8b4281cf87a0977971434b8345a1c55') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(71,'a8b4281cf87a0977971434b8345a1c55','23393306d6da5ad5313d322e32d2fb0f:a8b4281cf87a0977971434b8345a1c55') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(72,'23393306d6da5ad5313d322e32d2fb0f','23393306d6da5ad5313d322e32d2fb0f:dab7318f-95b2-4b28-9655-97706ece0d27') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(73,'dab7318f-95b2-4b28-9655-97706ece0d27','23393306d6da5ad5313d322e32d2fb0f:dab7318f-95b2-4b28-9655-97706ece0d27') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE CONTENT SET ENABLED=null,MODIFICATION_DATE=null,MAXIMIZABLE=1,PREFIX=null,KEY_INITIAL_CONTENT=74,CONTENT_ID='a8b4281cf87a0977971434b8345a1c55',CREATION_DATE='2008-01-07 19:45:40',NAME='pt15:Gestão de Guias',TITLE=null,BODY=null,DESCRIPTION=null,KEY_ROOT_DOMAIN_OBJECT=1,KEY_AVAILABILITY_POLICY=null,KEY_PORTAL=null,KEY_CREATOR=null,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.Section' WHERE CONTENT_ID = 'a8b4281cf87a0977971434b8345a1c55'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(74,'53869e02-a164-464a-b035-f9c16da169b3','a8b4281cf87a0977971434b8345a1c55') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

UPDATE NODE SET NODE_ORDER=1,ASCENDING=1,VISIBLE=1,CONTENT_ID='23393306d6da5ad5313d322e32d2fb0f:dab7318f-95b2-4b28-9655-97706ece0d27',KEY_ROOT_DOMAIN_OBJECT=1,KEY_PARENT=75,KEY_CHILD=76,OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contents.ExplicitOrderNode' WHERE CONTENT_ID = '23393306d6da5ad5313d322e32d2fb0f:dab7318f-95b2-4b28-9655-97706ece0d27'  ;

CREATE TEMPORARY TABLE UUID_TEMP_TABLE(COUNTER integer, UUID varchar(255), FROM_UUID varchar(255));

INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(75,'23393306d6da5ad5313d322e32d2fb0f','23393306d6da5ad5313d322e32d2fb0f:dab7318f-95b2-4b28-9655-97706ece0d27') ;
INSERT INTO UUID_TEMP_TABLE(COUNTER,UUID,FROM_UUID) VALUES(76,'dab7318f-95b2-4b28-9655-97706ece0d27','23393306d6da5ad5313d322e32d2fb0f:dab7318f-95b2-4b28-9655-97706ece0d27') ;
ALTER TABLE UUID_TEMP_TABLE ADD INDEX (COUNTER), ADD INDEX (UUID), ADD INDEX (FROM_UUID);
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PARENT=CT.ID_INTERNAL WHERE T.KEY_PARENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE NODE T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CHILD=CT.ID_INTERNAL WHERE T.KEY_CHILD=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_INITIAL_CONTENT=CT.ID_INTERNAL WHERE T.KEY_INITIAL_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_PORTAL=CT.ID_INTERNAL WHERE T.KEY_PORTAL=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE CONTENT T, UUID_TEMP_TABLE UIT, AVAILABILITY_POLICY CT set T.KEY_AVAILABILITY_POLICY=CT.ID_INTERNAL WHERE T.KEY_AVAILABILITY_POLICY=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
UPDATE AVAILABILITY_POLICY T, UUID_TEMP_TABLE UIT, CONTENT CT set T.KEY_CONTENT=CT.ID_INTERNAL WHERE T.KEY_CONTENT=UIT.COUNTER AND T.CONTENT_ID = UIT.FROM_UUID AND CT.CONTENT_ID=UIT.UUID;
DROP TABLE UUID_TEMP_TABLE;

