svn commit: r330814 - in /incubator/roller/trunk/metadata/database: 120-to-130-migration-raw.sql 130-to-200-migration-raw.sql

[sn...@apache.org]

Author: snoopdave
Date: Fri Nov  4 06:46:58 2005
New Revision: 330814

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

Modified:
    incubator/roller/trunk/metadata/database/120-to-130-migration-raw.sql
    incubator/roller/trunk/metadata/database/130-to-200-migration-raw.sql

Modified: incubator/roller/trunk/metadata/database/120-to-130-migration-raw.sql
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/metadata/database/120-to-130-migration-raw.sql?rev=330814&r1=330813&r2=330814&view=diff
==============================================================================
--- incubator/roller/trunk/metadata/database/120-to-130-migration-raw.sql (original)
+++ incubator/roller/trunk/metadata/database/120-to-130-migration-raw.sql Fri Nov  4 06:46:58 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;

Modified: incubator/roller/trunk/metadata/database/130-to-200-migration-raw.sql
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/metadata/database/130-to-200-migration-raw.sql?rev=330814&r1=330813&r2=330814&view=diff
==============================================================================
--- incubator/roller/trunk/metadata/database/130-to-200-migration-raw.sql (original)
+++ incubator/roller/trunk/metadata/database/130-to-200-migration-raw.sql Fri Nov  4 06:46:58 2005
@@ -16,9 +16,6 @@
 alter table website add column emailaddress varchar(255) @ALTER_TABLE_NOT_NULL@;
 create index website_handle_index on website(handle);
 
--- when using a shared theme, website need not track defauld page id
-alter table website alter column defaultpageid drop not null;
-
 -- this constraint won't work for upgrades until the handle column is
 -- populated with data, otherwise all columns are '' which will not
 -- satisfy the 'unique' condition