You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by sn...@apache.org on 2005/11/01 16:15:01 UTC
svn commit: r330069 - in /incubator/roller/trunk/metadata/database:
120-to-130-migration-raw.sql 130-to-200-migration-raw.sql createdb-raw.sql
Author: snoopdave
Date: Tue Nov 1 07:14:57 2005
New Revision: 330069
URL: http://svn.apache.org/viewcvs?rev=330069&view=rev
Log:
Fixes ROL-869 (problem saving website settings on PostgreSQL for Roller 2.x
Added:
incubator/roller/trunk/metadata/database/120-to-130-migration-raw.sql
Modified:
incubator/roller/trunk/metadata/database/130-to-200-migration-raw.sql
incubator/roller/trunk/metadata/database/createdb-raw.sql
Added: 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=330069&view=auto
==============================================================================
--- incubator/roller/trunk/metadata/database/120-to-130-migration-raw.sql (added)
+++ incubator/roller/trunk/metadata/database/120-to-130-migration-raw.sql Tue Nov 1 07:14:57 2005
@@ -0,0 +1,3 @@
+
+-- when using a shared theme, website need not track defauld page id
+alter table website alter column defaultpageid drop not null;
\ No newline at end of file
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=330069&r1=330068&r2=330069&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 Tue Nov 1 07:14:57 2005
@@ -16,6 +16,9 @@
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
Modified: incubator/roller/trunk/metadata/database/createdb-raw.sql
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/metadata/database/createdb-raw.sql?rev=330069&r1=330068&r2=330069&view=diff
==============================================================================
--- incubator/roller/trunk/metadata/database/createdb-raw.sql (original)
+++ incubator/roller/trunk/metadata/database/createdb-raw.sql Tue Nov 1 07:14:57 2005
@@ -89,7 +89,7 @@
handle varchar(255) not null,
description varchar(255) not null,
userid varchar(48) not null,
- defaultpageid varchar(48) default '' not null,
+ defaultpageid varchar(48) default '',
weblogdayid varchar(48) not null,
ignorewords @TEXT_SQL_TYPE@,
enablebloggerapi @BOOLEAN_SQL_TYPE_FALSE@ not null,