Author: fpunt Date: 2010-05-17 14:19:10 +0200 (Mon, 17 May 2010) New Revision: 42184
Modified: CMSContainer/trunk/CMSContainer/migration/migration_1.7_to_1.8.txt Log: CMSC-1689 Fixed Modified: CMSContainer/trunk/CMSContainer/migration/migration_1.7_to_1.8.txt =================================================================== --- CMSContainer/trunk/CMSContainer/migration/migration_1.7_to_1.8.txt 2010-05-17 12:06:15 UTC (rev 42183) +++ CMSContainer/trunk/CMSContainer/migration/migration_1.7_to_1.8.txt 2010-05-17 12:19:10 UTC (rev 42184) @@ -44,6 +44,9 @@ * * * + + + Name: Alter two fields of the table subscriptionrecord Goal: Change the type of the two fields Type: sql-script @@ -57,4 +60,18 @@ --- End script --- Exceptions/errors/other problems and what to do: * -* \ No newline at end of file +* + + +Name: Remove from workflow db script +Goal: Missing upgrade script for the 1.7 release, made to remove stuff from the workflow +Type: sql-script +--- Start script --- +create table temp (number int(11)); +insert into temp (select max(number) as x from mm_archive group by original_node); +update mm_archive set onlive = 1, publish = 1 where number in (select number from temp); +drop table temp; +--- End script --- +Exceptions/errors/other problems and what to do: +* +* _______________________________________________ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs