roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From snoopd...@apache.org
Subject svn commit: r330069 - in /incubator/roller/trunk/metadata/database: 120-to-130-migration-raw.sql 130-to-200-migration-raw.sql createdb-raw.sql
Date Tue, 01 Nov 2005 15:15:01 GMT
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,



Mime
View raw message