roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From snoopd...@apache.org
Subject svn commit: r330823 - /incubator/roller/branches/roller_1.x/metadata/database/120-to-130-migration-raw.sql
Date Fri, 04 Nov 2005 15:09:58 GMT
Author: snoopdave
Date: Fri Nov  4 07:09:56 2005
New Revision: 330823

URL: http://svn.apache.org/viewcvs?rev=330823&view=rev
Log:
Added note and MySQL specific alter table syntax

Modified:
    incubator/roller/branches/roller_1.x/metadata/database/120-to-130-migration-raw.sql

Modified: incubator/roller/branches/roller_1.x/metadata/database/120-to-130-migration-raw.sql
URL: http://svn.apache.org/viewcvs/incubator/roller/branches/roller_1.x/metadata/database/120-to-130-migration-raw.sql?rev=330823&r1=330822&r2=330823&view=diff
==============================================================================
--- incubator/roller/branches/roller_1.x/metadata/database/120-to-130-migration-raw.sql (original)
+++ incubator/roller/branches/roller_1.x/metadata/database/120-to-130-migration-raw.sql Fri
Nov  4 07:09:56 2005
@@ -1,3 +1,10 @@
 
--- when using a shared theme, website need not track defauld page id
+-- Upgrading from 1.2 to 1.3 requires one small change. The website table
+-- column defaultpageid is now allowed to be null. Unfortunately, MySQL
+-- requires non-standard alter table syntax for this.
+
+-- So if you're on MySQL do this:
+alter table website modify defaultpageid varchar(48);
+
+-- And for all other databases do this:
 alter table website alter column defaultpageid drop not null;



Mime
View raw message