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:06:51 UTC
svn commit: r330066 - in
/incubator/roller/branches/roller_1.x/metadata/database:
120-to-130-migration-raw.sql createdb-raw.sql
Author: snoopdave
Date: Tue Nov 1 07:06:48 2005
New Revision: 330066
URL: http://svn.apache.org/viewcvs?rev=330066&view=rev
Log:
Fixes ROL-869 problem saving website settings on PostgreSQL for roller_1.x
Added:
incubator/roller/branches/roller_1.x/metadata/database/120-to-130-migration-raw.sql
Modified:
incubator/roller/branches/roller_1.x/metadata/database/createdb-raw.sql
Added: 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=330066&view=auto
==============================================================================
--- incubator/roller/branches/roller_1.x/metadata/database/120-to-130-migration-raw.sql (added)
+++ incubator/roller/branches/roller_1.x/metadata/database/120-to-130-migration-raw.sql Tue Nov 1 07:06:48 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/branches/roller_1.x/metadata/database/createdb-raw.sql
URL: http://svn.apache.org/viewcvs/incubator/roller/branches/roller_1.x/metadata/database/createdb-raw.sql?rev=330066&r1=330065&r2=330066&view=diff
==============================================================================
--- incubator/roller/branches/roller_1.x/metadata/database/createdb-raw.sql (original)
+++ incubator/roller/branches/roller_1.x/metadata/database/createdb-raw.sql Tue Nov 1 07:06:48 2005
@@ -59,7 +59,7 @@
name varchar(255) not null,
description varchar(255) not null,
userid varchar(48) not null,
- defaultpageid varchar(48) default 0 not null,
+ defaultpageid varchar(48) default '',
weblogdayid varchar(48) not null,
ignorewords @TEXT_SQL_TYPE@,
enablebloggerapi @BOOLEAN_SQL_TYPE_FALSE@ not null,