Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv22062/migration
Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-681 - Make SQL better. See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-681 Index: migration_1.5_to_1.6.txt =================================================================== RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.5 retrieving revision 1.6 diff -u -b -r1.5 -r1.6 --- migration_1.5_to_1.6.txt 17 Dec 2008 10:18:21 -0000 1.5 +++ migration_1.5_to_1.6.txt 17 Dec 2008 10:55:22 -0000 1.6 @@ -54,58 +54,3 @@ * * * - - -Name: Add workflowrel relation between workflowitem and assetelement to typerel -Goal: Add workflowrel relation between workflowitem and assetelement to typerel -Type: sql-script ---- Start script --- -INSERT INTO mm_typerel SELECT 10001, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM mm_typedef typedef1, mm_typedef typedef2, mm_reldef reldef WHERE typedef1.name='workflowitem' AND typedef2.name='assetelement' AND reldef.sname='workflowrel'; - ---- End script --- -Exceptions/errors/other problems and what to do: -* -* -* - -Name: Add creationrel relation between assetelement and contentchannel to typerel -Goal: Add creationrel relation between assetelement and contentchannel to typerel -Type: sql-script ---- Start script --- -INSERT INTO mm_typerel SELECT 10002, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM mm_typedef typedef1, mm_typedef typedef2, mm_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='contentchannel' AND reldef.sname='creationrel'; - -INSERT INTO live_typerel SELECT 10002, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM live_typedef typedef1, live_typedef typedef2, live_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='contentchannel' AND reldef.sname='creationrel'; - ---- End script --- -Exceptions/errors/other problems and what to do: -* -* -* - -Name: Add deletionrel relation between assetelement and contentchannel to typerel -Goal: Add deletionrel relation between assetelement and contentchannel to typerel -Type: sql-script ---- Start script --- -INSERT INTO mm_typerel SELECT 10003, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM mm_typedef typedef1, mm_typedef typedef2, mm_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='contentchannel' AND reldef.sname='deletionrel'; - -INSERT INTO live_typerel SELECT 10003, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM live_typedef typedef1, live_typedef typedef2, live_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='contentchannel' AND reldef.sname='deletionrel'; - ---- End script --- -Exceptions/errors/other problems and what to do: -* -* -* - -Name: Add ownerrel relation between assetelement and user to typerel -Goal: Add ownerrel relation between assetelement and user to typerel -Type: sql-script ---- Start script --- -INSERT INTO mm_typerel SELECT 10004, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM mm_typedef typedef1, mm_typedef typedef2, mm_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='user' AND reldef.sname='ownerrel'; - -INSERT INTO live_typerel SELECT 10004, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM live_typedef typedef1, live_typedef typedef2, live_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='user' AND reldef.sname='ownerrel'; - ---- End script --- -Exceptions/errors/other problems and what to do: -* -* -* \ No newline at end of file _______________________________________________ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs