roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From snoopd...@apache.org
Subject svn commit: r330858 - in /incubator/roller/trunk/metadata/database: 120-to-130-migration-raw.sql db_db2.properties db_derby.properties db_hsql.properties db_mysql.properties db_postgresql.properties
Date Fri, 04 Nov 2005 18:14:11 GMT
Author: snoopdave
Date: Fri Nov  4 10:14:08 2005
New Revision: 330858

URL: http://svn.apache.org/viewcvs?rev=330858&view=rev
Log:
Better way to handle removal of not null constraint

Modified:
    incubator/roller/trunk/metadata/database/120-to-130-migration-raw.sql
    incubator/roller/trunk/metadata/database/db_db2.properties
    incubator/roller/trunk/metadata/database/db_derby.properties
    incubator/roller/trunk/metadata/database/db_hsql.properties
    incubator/roller/trunk/metadata/database/db_mysql.properties
    incubator/roller/trunk/metadata/database/db_postgresql.properties

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=330858&r1=330857&r2=330858&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 10:14:08
2005
@@ -1,10 +1,2 @@
 
--- 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;
\ No newline at end of file
+@ALTER_DEFAULTPAGEID_ALLOW_NULL@;
\ No newline at end of file

Modified: incubator/roller/trunk/metadata/database/db_db2.properties
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/metadata/database/db_db2.properties?rev=330858&r1=330857&r2=330858&view=diff
==============================================================================
--- incubator/roller/trunk/metadata/database/db_db2.properties (original)
+++ incubator/roller/trunk/metadata/database/db_db2.properties Fri Nov  4 10:14:08 2005
@@ -1,3 +1 @@
-TEXT_SQL_TYPE=clob(102400)
BOOLEAN_SQL_TYPE_FALSE=smallint default 0
BOOLEAN_SQL_TYPE_TRUE=smallint
default 1
BOOLEAN_SQL_TYPE=smallint
BOOLEAN_FALSE=0
BOOLEAN_TRUE=1
INDEXSIZE=
INDEXSIZE_LARGE=
ALTER_TABLE_NOT_NULL=
not null
ADDL_FK_PARAMS=on delete no action on update no action enforced enable query optimization
-TIMESTAMP_SQL_TYPE_NULL=timestamp null
-ALTER_PUBTIME_ALLOW_NULL=
+TEXT_SQL_TYPE=clob(102400)
BOOLEAN_SQL_TYPE_FALSE=smallint default 0
BOOLEAN_SQL_TYPE_TRUE=smallint
default 1
BOOLEAN_SQL_TYPE=smallint
BOOLEAN_FALSE=0
BOOLEAN_TRUE=1
INDEXSIZE=
INDEXSIZE_LARGE=
ALTER_TABLE_NOT_NULL=
not null
ADDL_FK_PARAMS=on delete no action on update no action enforced enable query optimization
TIMESTAMP_SQL_TYPE_NULL=timestamp
null
ALTER_PUBTIME_ALLOW_NULL=
ALTER_DEFAULTPAGEID_ALLOW_NULL=alter table website alter column
defaultpageid drop not null
\ No newline at end of file

Modified: incubator/roller/trunk/metadata/database/db_derby.properties
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/metadata/database/db_derby.properties?rev=330858&r1=330857&r2=330858&view=diff
==============================================================================
--- incubator/roller/trunk/metadata/database/db_derby.properties (original)
+++ incubator/roller/trunk/metadata/database/db_derby.properties Fri Nov  4 10:14:08 2005
@@ -1,3 +1 @@
-TEXT_SQL_TYPE=clob(102400)
BOOLEAN_SQL_TYPE_FALSE=smallint default 0
BOOLEAN_SQL_TYPE_TRUE=smallint
default 1
BOOLEAN_SQL_TYPE=smallint
BOOLEAN_FALSE=0
BOOLEAN_TRUE=1
INDEXSIZE=
INDEXSIZE_LARGE=
ALTER_TABLE_NOT_NULL=
not null
ADDL_FK_PARAMS=
-TIMESTAMP_SQL_TYPE_NULL=timestamp null
-ALTER_PUBTIME_ALLOW_NULL=
+TEXT_SQL_TYPE=clob(102400)
BOOLEAN_SQL_TYPE_FALSE=smallint default 0
BOOLEAN_SQL_TYPE_TRUE=smallint
default 1
BOOLEAN_SQL_TYPE=smallint
BOOLEAN_FALSE=0
BOOLEAN_TRUE=1
INDEXSIZE=
INDEXSIZE_LARGE=
ALTER_TABLE_NOT_NULL=
not null
ADDL_FK_PARAMS=
TIMESTAMP_SQL_TYPE_NULL=timestamp null
ALTER_PUBTIME_ALLOW_NULL=
ALTER_DEFAULTPAGEID_ALLOW_NULL=alter
table website alter column defaultpageid drop not null
\ No newline at end of file

Modified: incubator/roller/trunk/metadata/database/db_hsql.properties
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/metadata/database/db_hsql.properties?rev=330858&r1=330857&r2=330858&view=diff
==============================================================================
--- incubator/roller/trunk/metadata/database/db_hsql.properties (original)
+++ incubator/roller/trunk/metadata/database/db_hsql.properties Fri Nov  4 10:14:08 2005
@@ -10,3 +10,4 @@
 ADDL_FK_PARAMS=
 TIMESTAMP_SQL_TYPE_NULL=timestamp null
 ALTER_PUBTIME_ALLOW_NULL=
+ALTER_DEFAULTPAGEID_ALLOW_NULL=alter table website alter column defaultpageid drop not null
\ No newline at end of file

Modified: incubator/roller/trunk/metadata/database/db_mysql.properties
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/metadata/database/db_mysql.properties?rev=330858&r1=330857&r2=330858&view=diff
==============================================================================
--- incubator/roller/trunk/metadata/database/db_mysql.properties (original)
+++ incubator/roller/trunk/metadata/database/db_mysql.properties Fri Nov  4 10:14:08 2005
@@ -1,3 +1 @@
-TEXT_SQL_TYPE=text
BOOLEAN_SQL_TYPE_FALSE=bit default 0
BOOLEAN_SQL_TYPE_TRUE=bit default
1
BOOLEAN_SQL_TYPE=bit
BOOLEAN_FALSE=0
BOOLEAN_TRUE=1
INDEXSIZE=(40)
INDEXSIZE_LARGE=(100)
ALTER_TABLE_NOT_NULL=
not null
ADDL_FK_PARAMS=
-TIMESTAMP_SQL_TYPE_NULL=datetime NULL
-ALTER_PUBTIME_ALLOW_NULL=alter table weblogentry modify pubtime DATETIME NULL
+TEXT_SQL_TYPE=text
BOOLEAN_SQL_TYPE_FALSE=bit default 0
BOOLEAN_SQL_TYPE_TRUE=bit default
1
BOOLEAN_SQL_TYPE=bit
BOOLEAN_FALSE=0
BOOLEAN_TRUE=1
INDEXSIZE=(40)
INDEXSIZE_LARGE=(100)
ALTER_TABLE_NOT_NULL=
not null
ADDL_FK_PARAMS=
TIMESTAMP_SQL_TYPE_NULL=datetime NULL
ALTER_PUBTIME_ALLOW_NULL=alter
table weblogentry modify pubtime DATETIME NULL
ALTER_DEFAULTPAGEID_ALLOW_NULL=alter table
website modify defaultpageid varchar(48)

\ No newline at end of file

Modified: incubator/roller/trunk/metadata/database/db_postgresql.properties
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/metadata/database/db_postgresql.properties?rev=330858&r1=330857&r2=330858&view=diff
==============================================================================
--- incubator/roller/trunk/metadata/database/db_postgresql.properties (original)
+++ incubator/roller/trunk/metadata/database/db_postgresql.properties Fri Nov  4 10:14:08
2005
@@ -10,3 +10,4 @@
 ADDL_FK_PARAMS=
 TIMESTAMP_SQL_TYPE_NULL=timestamp null
 ALTER_PUBTIME_ALLOW_NULL=alter table weblogentry alter pubtime drop not null
+ALTER_DEFAULTPAGEID_ALLOW_NULL=alter table website alter column defaultpageid drop not null
\ No newline at end of file



Mime
View raw message