Author: snoopdave
Date: Thu Jan 5 12:48:25 2006
New Revision: 366277
URL: http://svn.apache.org/viewcvs?rev=366277&view=rev
Log:
Error in email not-null
Modified:
incubator/roller/branches/roller_2.0/metadata/database/db_db2.properties
incubator/roller/branches/roller_2.0/metadata/database/db_derby.properties
incubator/roller/branches/roller_2.0/metadata/database/db_hsql.properties
incubator/roller/branches/roller_2.0/metadata/database/db_mysql.properties
incubator/roller/branches/roller_2.0/metadata/database/db_oracle.properties
incubator/roller/branches/roller_2.0/metadata/database/db_postgresql.properties
Modified:
incubator/roller/branches/roller_2.0/metadata/database/db_db2.properties
URL:
http://svn.apache.org/viewcvs/incubator/roller/branches/roller_2.0/metadata/database/db_db2.properties?rev=366277&r1=366276&r2=366277&view=diff
==============================================================================
--- incubator/roller/branches/roller_2.0/metadata/database/db_db2.properties
(original)
+++ incubator/roller/branches/roller_2.0/metadata/database/db_db2.properties
Thu Jan 5 12:48:25 2006
@@ -1 +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=
ALTER_DEFAULTPAGEID_ALLOW_NULL=alter table website alter column defaultpageid
drop not null
ALTER_TABLE_PINGTARGET_CONDITIONCODE_NOT_NULL=alter table pingtarget modify
conditioncode set not null
ALTER_TABLE_PINGTARGET_CONDITIONCODE_DEFAULT_0=alter table pingtarget modify
conditioncode set default 0
ALTER_TABLE_WEBSITE_HANDLE_DEFAULT=alter table website alter handle
varchar(255) set default ''
ALTER_TABLE_WEBSITE_HANDLE_NOT_NULL=alter table website alter handle
varchar(255) not null
ALTER_TABLE_WEBSITE_DATECREATED_DEFAULT=alter table website alter datecreated
timestamp set default '20050101'
ALTER_
TABLE_WEBSITE_DATECREATED_NOT_NULL=alter table website alter datecreated
timestamp not null
ALTER_TABLE_WEBSITE_EMAILADDRESS_DEFAULT=alter table website alter emailaddress
varchar(255) set default ''
ALTER_TABLE_WEBSITE_EMAILADDRESS_NOT_NULL=alter table website alter handle
varchar(255) not null
ALTER_TABLE_WEBLOGENTY_USERID_DEFAULT=alter table weblogentry alter userid
varchar(48) set default ''
ALTER_TABLE_WEBLOGENTY_USERID_NOT_NULL=alter table weblogentry alter userid
varchar(48) not null
ALTER_TABLE_WEBLOGENTRY_STATUS_DEFAULT=alter table weblogentry alter status
varchar(20) set default ''
ALTER_TABLE_WEBLOGENTRY_STATUS_NOT_NULL=alter table weblogentry alter status
varchar(20) not null
ALTER_TABLE_ROLLERUSER_ISENABLED_DEFAULT=alter table rolleruser alter isenabled
boolean set default 1
ALTER_TABLE_ROLLERUSER_ISENABLED_NOT_NULL=alter table rolleruser alter
isenabled boolean not null
ALTER_TABLE_ROLLERUSER_LOCALE_DEFAULT=alter table rolleruser alter locale
varchar(50) s
et default ''
ALTER_TABLE_ROLLERUSER_LOCALE_NOT_NULL=alter table rolleruser alter locale
varchar(50) not null
ALTER_TABLE_ROLLERUSER_TIMEZONE_DEFAULT=alter table rolleruser alter timezone
varchar(50) set default ''
ALTER_TABLE_ROLLERUSER_TIMEZONE_NOT_NULL=alter table rolleruser alter timezone
varchar(50) not null
ALTER_TABLE_ROLLER_COMMENT_APPROVED_DEFAULT_FALSE= alter table roller_comment
alter approved set default false
ALTER_TABLE_ROLLER_COMMENT_APPROVED_NOT_NULL= alter table roller_comment
alter approved set not null
ALTER_TABLE_ROLLER_COMMENT_PENDING_DEFAULT_FALSE= alter table roller_comment
alter pending set default false
ALTER_TABLE_ROLLER_COMMENT_PENDING_NOT_NULL= alter table roller_comment
alter pending set not null
ALTER_TABLE_WEBSITE_COMMENTMOD_DEFAULT_FALSE= alter table website alter
commendmod set default false
ALTER_TABLE_WEBSITE_COMMENTMOD_NOT_NULL= alter table website alter
commendmod set not null;
ALTER_TABLE_WEBSITE_DEFAUL
TALLOWCOMMENTS_DEFAULT_TRUE=alter table website alter defaultallowcomments set
default true
ALTER_TABLE_WEBSITE_DEFAULTALLOWCOMMENTS_NOT_NULL= alter table website alter
defaultallowcomments set not null
ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_DEFAULT_7= alter table website alter
defaultcommentdays set default 7
ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_NOT_NULL= alter table website alter
defaultcommentdays set not null
\ No newline at end of file
+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
ALTER_TABLE_PINGTARGET_CONDITIONCODE_NOT_NULL=alter table pingtarget modify
conditioncode set not null
ALTER_TABLE_PINGTARGET_CONDITIONCODE_DEFAULT_0=alter table pingtarget modify
conditioncode set default 0
ALTER_TABLE_WEBSITE_HANDLE_DEFAULT=alter table website alter handle
varchar(255) set default ''
ALTER_TABLE_WEBSITE_HANDLE_NOT_NULL=alter table website alter handle
varchar(255) not null
ALTER_TABLE_WEBSITE_DATECREATED_DEFAULT=alter table website alter datecreated
timestamp set default '20050101'
ALTER_
TABLE_WEBSITE_DATECREATED_NOT_NULL=alter table website alter datecreated
timestamp not null
ALTER_TABLE_WEBSITE_EMAILADDRESS_DEFAULT=alter table website alter emailaddress
varchar(255) set default ''
ALTER_TABLE_WEBSITE_EMAILADDRESS_NOT_NULL=alter table website alter
emailaddress varchar(255) not null
ALTER_TABLE_WEBLOGENTY_USERID_DEFAULT=alter table weblogentry alter userid
varchar(48) set default ''
ALTER_TABLE_WEBLOGENTY_USERID_NOT_NULL=alter table weblogentry alter userid
varchar(48) not null
ALTER_TABLE_WEBLOGENTRY_STATUS_DEFAULT=alter table weblogentry alter status
varchar(20) set default ''
ALTER_TABLE_WEBLOGENTRY_STATUS_NOT_NULL=alter table weblogentry alter status
varchar(20) not null
ALTER_TABLE_ROLLERUSER_ISENABLED_DEFAULT=alter table rolleruser alter isenabled
boolean set default 1
ALTER_TABLE_ROLLERUSER_ISENABLED_NOT_NULL=alter table rolleruser alter
isenabled boolean not null
ALTER_TABLE_ROLLERUSER_LOCALE_DEFAULT=alter table rolleruser alter locale
varchar
(50) set default ''
ALTER_TABLE_ROLLERUSER_LOCALE_NOT_NULL=alter table rolleruser alter locale
varchar(50) not null
ALTER_TABLE_ROLLERUSER_TIMEZONE_DEFAULT=alter table rolleruser alter timezone
varchar(50) set default ''
ALTER_TABLE_ROLLERUSER_TIMEZONE_NOT_NULL=alter table rolleruser alter timezone
varchar(50) not null
ALTER_TABLE_ROLLER_COMMENT_APPROVED_DEFAULT_FALSE= alter table roller_comment
alter approved set default false
ALTER_TABLE_ROLLER_COMMENT_APPROVED_NOT_NULL= alter table roller_comment
alter approved set not null
ALTER_TABLE_ROLLER_COMMENT_PENDING_DEFAULT_FALSE= alter table roller_comment
alter pending set default false
ALTER_TABLE_ROLLER_COMMENT_PENDING_NOT_NULL= alter table roller_comment
alter pending set not null
ALTER_TABLE_WEBSITE_COMMENTMOD_DEFAULT_FALSE= alter table website alter
commendmod set default false
ALTER_TABLE_WEBSITE_COMMENTMOD_NOT_NULL= alter table website alter
commendmod set not null;
ALTER_TABLE_WEBSITE_
DEFAULTALLOWCOMMENTS_DEFAULT_TRUE=alter table website alter
defaultallowcomments set default true
ALTER_TABLE_WEBSITE_DEFAULTALLOWCOMMENTS_NOT_NULL= alter table website alter
defaultallowcomments set not null
ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_DEFAULT_7= alter table website alter
defaultcommentdays set default 7
ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_NOT_NULL= alter table website alter
defaultcommentdays set not null
\ No newline at end of file
Modified:
incubator/roller/branches/roller_2.0/metadata/database/db_derby.properties
URL:
http://svn.apache.org/viewcvs/incubator/roller/branches/roller_2.0/metadata/database/db_derby.properties?rev=366277&r1=366276&r2=366277&view=diff
==============================================================================
--- incubator/roller/branches/roller_2.0/metadata/database/db_derby.properties
(original)
+++ incubator/roller/branches/roller_2.0/metadata/database/db_derby.properties
Thu Jan 5 12:48:25 2006
@@ -1 +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=
ALTER_DEFAULTPAGEID_ALLOW_NULL=alter table website alter column defaultpageid
drop not null
ALTER_TABLE_PINGTARGET_CONDITIONCODE_NOT_NULL= alter table pingtarget modify
conditioncode set not null;
ALTER_TABLE_PINGTARGET_CONDITIONCODE_DEFAULT_0=alter table pingtarget modify
conditioncode set default 0;
ALTER_TABLE_WEBSITE_HANDLE_DEFAULT=alter table website alter handle
varchar(255) default ''
ALTER_TABLE_WEBSITE_HANDLE_NOT_NULL=alter table website alter handle
varchar(255) not null
ALTER_TABLE_WEBSITE_DATECREATED_DEFAULT=alter table website alter datecreated
timestamp default '20050101'
ALTER_TABLE_WEBSITE_DATECREATED_NOT_NULL=alter table website alter datecreated
timest
amp not null
ALTER_TABLE_WEBSITE_EMAILADDRESS_DEFAULT=alter table website alter emailaddress
varchar(255) default ''
ALTER_TABLE_WEBSITE_EMAILADDRESS_NOT_NULL=alter table website alter handle
varchar(255) not null
ALTER_TABLE_WEBLOGENTY_USERID_DEFAULT=alter table weblogentry alter userid
varchar(48) default ''
ALTER_TABLE_WEBLOGENTY_USERID_NOT_NULL=alter table weblogentry alter userid
varchar(48) not null
ALTER_TABLE_WEBLOGENTRY_STATUS_DEFAULT=alter table weblogentry alter status
varchar(20) default ''
ALTER_TABLE_WEBLOGENTRY_STATUS_NOT_NULL=alter table weblogentry alter status
varchar(20) not null
ALTER_TABLE_ROLLERUSER_ISENABLED_DEFAULT=alter table rolleruser alter isenabled
boolean default true
ALTER_TABLE_ROLLERUSER_ISENABLED_NOT_NULL=alter table rolleruser alter
isenabled boolean not null
ALTER_TABLE_ROLLERUSER_LOCALE_DEFAULT=alter table rolleruser alter locale
varchar(50) default ''
ALTER_TABLE_ROLLERUSER_LOCALE_NOT_NULL=alter table rolleruser alter locale
varchar
(50) not null
ALTER_TABLE_ROLLERUSER_TIMEZONE_DEFAULT=alter table rolleruser alter timezone
varchar(50) default ''
ALTER_TABLE_ROLLERUSER_TIMEZONE_NOT_NULL=alter table rolleruser alter timezone
varchar(50) not null
ALTER_TABLE_ROLLER_COMMENT_APPROVED_DEFAULT_FALSE= alter table roller_comment
alter approved set default false
ALTER_TABLE_ROLLER_COMMENT_APPROVED_NOT_NULL= alter table roller_comment
alter approved set not null
ALTER_TABLE_ROLLER_COMMENT_PENDING_DEFAULT_FALSE= alter table roller_comment
alter pending set default false
ALTER_TABLE_ROLLER_COMMENT_PENDING_NOT_NULL= alter table roller_comment
alter pending set not null
ALTER_TABLE_WEBSITE_COMMENTMOD_DEFAULT_FALSE=alter table website alter
commendmod set default false
ALTER_TABLE_WEBSITE_COMMENTMOD_NOT_NULL= alter table website alter
commendmod set not null;
ALTER_TABLE_WEBSITE_DEFAULTALLOWCOMMENTS_DEFAULT_TRUE=alter table website alter
defaultallowcomments set default true
ALTER_TABLE_WEBSITE_D
EFAULTALLOWCOMMENTS_NOT_NULL= alter table website alter
defaultallowcomments set not null
ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_DEFAULT_7= alter table website alter
defaultcommentdays set default 7
ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_NOT_NULL= alter table website alter
defaultcommentdays set not null
\ No newline at end of file
+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
ALTER_TABLE_PINGTARGET_CONDITIONCODE_NOT_NULL= alter table pingtarget modify
conditioncode set not null;
ALTER_TABLE_PINGTARGET_CONDITIONCODE_DEFAULT_0=alter table pingtarget modify
conditioncode set default 0;
ALTER_TABLE_WEBSITE_HANDLE_DEFAULT=alter table website alter handle
varchar(255) default ''
ALTER_TABLE_WEBSITE_HANDLE_NOT_NULL=alter table website alter handle
varchar(255) not null
ALTER_TABLE_WEBSITE_DATECREATED_DEFAULT=alter table website alter datecreated
timestamp default '20050101'
ALTER_TABLE_WEBSITE_DATECREATED_NOT_NULL=alter table website alter datecreated
timest
amp not null
ALTER_TABLE_WEBSITE_EMAILADDRESS_DEFAULT=alter table website alter emailaddress
varchar(255) default ''
ALTER_TABLE_WEBSITE_EMAILADDRESS_NOT_NULL=alter table website alter
emailaddress varchar(255) not null
ALTER_TABLE_WEBLOGENTY_USERID_DEFAULT=alter table weblogentry alter userid
varchar(48) default ''
ALTER_TABLE_WEBLOGENTY_USERID_NOT_NULL=alter table weblogentry alter userid
varchar(48) not null
ALTER_TABLE_WEBLOGENTRY_STATUS_DEFAULT=alter table weblogentry alter status
varchar(20) default ''
ALTER_TABLE_WEBLOGENTRY_STATUS_NOT_NULL=alter table weblogentry alter status
varchar(20) not null
ALTER_TABLE_ROLLERUSER_ISENABLED_DEFAULT=alter table rolleruser alter isenabled
boolean default true
ALTER_TABLE_ROLLERUSER_ISENABLED_NOT_NULL=alter table rolleruser alter
isenabled boolean not null
ALTER_TABLE_ROLLERUSER_LOCALE_DEFAULT=alter table rolleruser alter locale
varchar(50) default ''
ALTER_TABLE_ROLLERUSER_LOCALE_NOT_NULL=alter table rolleruser alter locale v
archar(50) not null
ALTER_TABLE_ROLLERUSER_TIMEZONE_DEFAULT=alter table rolleruser alter timezone
varchar(50) default ''
ALTER_TABLE_ROLLERUSER_TIMEZONE_NOT_NULL=alter table rolleruser alter timezone
varchar(50) not null
ALTER_TABLE_ROLLER_COMMENT_APPROVED_DEFAULT_FALSE= alter table roller_comment
alter approved set default false
ALTER_TABLE_ROLLER_COMMENT_APPROVED_NOT_NULL= alter table roller_comment
alter approved set not null
ALTER_TABLE_ROLLER_COMMENT_PENDING_DEFAULT_FALSE= alter table roller_comment
alter pending set default false
ALTER_TABLE_ROLLER_COMMENT_PENDING_NOT_NULL= alter table roller_comment
alter pending set not null
ALTER_TABLE_WEBSITE_COMMENTMOD_DEFAULT_FALSE=alter table website alter
commendmod set default false
ALTER_TABLE_WEBSITE_COMMENTMOD_NOT_NULL= alter table website alter
commendmod set not null;
ALTER_TABLE_WEBSITE_DEFAULTALLOWCOMMENTS_DEFAULT_TRUE=alter table website alter
defaultallowcomments set default true
ALTER_TABLE_WEB
SITE_DEFAULTALLOWCOMMENTS_NOT_NULL= alter table website alter
defaultallowcomments set not null
ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_DEFAULT_7= alter table website alter
defaultcommentdays set default 7
ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_NOT_NULL= alter table website alter
defaultcommentdays set not null
\ No newline at end of file
Modified:
incubator/roller/branches/roller_2.0/metadata/database/db_hsql.properties
URL:
http://svn.apache.org/viewcvs/incubator/roller/branches/roller_2.0/metadata/database/db_hsql.properties?rev=366277&r1=366276&r2=366277&view=diff
==============================================================================
--- incubator/roller/branches/roller_2.0/metadata/database/db_hsql.properties
(original)
+++ incubator/roller/branches/roller_2.0/metadata/database/db_hsql.properties
Thu Jan 5 12:48:25 2006
@@ -22,7 +22,7 @@
ALTER_TABLE_WEBSITE_DATECREATED_NOT_NULL=alter table website alter datecreated
timestamp not null
ALTER_TABLE_WEBSITE_EMAILADDRESS_DEFAULT=alter table website alter
emailaddress varchar(255) default ''
-ALTER_TABLE_WEBSITE_EMAILADDRESS_NOT_NULL=alter table website alter handle
varchar(255) not null
+ALTER_TABLE_WEBSITE_EMAILADDRESS_NOT_NULL=alter table website alter
emailaddress varchar(255) not null
ALTER_TABLE_WEBLOGENTY_USERID_DEFAULT=alter table weblogentry alter userid
varchar(48) default ''
ALTER_TABLE_WEBLOGENTY_USERID_NOT_NULL=alter table weblogentry alter userid
varchar(48) not null
@@ -52,4 +52,4 @@
ALTER_TABLE_WEBSITE_DEFAULTALLOWCOMMENTS_NOT_NULL= alter table website
alter defaultallowcomments set not null
ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_DEFAULT_7= alter table website alter
defaultcommentdays set default 7
-ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_NOT_NULL= alter table website alter
defaultcommentdays set not null
\ No newline at end of file
+ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_NOT_NULL= alter table website alter
defaultcommentdays set not null
Modified:
incubator/roller/branches/roller_2.0/metadata/database/db_mysql.properties
URL:
http://svn.apache.org/viewcvs/incubator/roller/branches/roller_2.0/metadata/database/db_mysql.properties?rev=366277&r1=366276&r2=366277&view=diff
==============================================================================
--- incubator/roller/branches/roller_2.0/metadata/database/db_mysql.properties
(original)
+++ incubator/roller/branches/roller_2.0/metadata/database/db_mysql.properties
Thu Jan 5 12:48:25 2006
@@ -22,7 +22,7 @@
ALTER_TABLE_WEBSITE_DATECREATED_NOT_NULL=alter table website modify
datecreated timestamp not null
ALTER_TABLE_WEBSITE_EMAILADDRESS_DEFAULT=alter table website modify
emailaddress varchar(255) default ''
-ALTER_TABLE_WEBSITE_EMAILADDRESS_NOT_NULL=alter table website modify handle
varchar(255) not null
+ALTER_TABLE_WEBSITE_EMAILADDRESS_NOT_NULL=alter table website modify
emailaddress varchar(255) not null
ALTER_TABLE_WEBLOGENTY_USERID_DEFAULT=alter table weblogentry modify userid
varchar(48) default ''
ALTER_TABLE_WEBLOGENTY_USERID_NOT_NULL=alter table weblogentry modify userid
varchar(48) not null
@@ -53,4 +53,3 @@
ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_DEFAULT_7=alter table website modify
defaultcommentdays integer default 7
ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_NOT_NULL= alter table website modify
defaultcommentdays integer not null
-
Modified:
incubator/roller/branches/roller_2.0/metadata/database/db_oracle.properties
URL:
http://svn.apache.org/viewcvs/incubator/roller/branches/roller_2.0/metadata/database/db_oracle.properties?rev=366277&r1=366276&r2=366277&view=diff
==============================================================================
--- incubator/roller/branches/roller_2.0/metadata/database/db_oracle.properties
(original)
+++ incubator/roller/branches/roller_2.0/metadata/database/db_oracle.properties
Thu Jan 5 12:48:25 2006
@@ -1 +1 @@
-TEXT_SQL_TYPE=clob
BOOLEAN_SQL_TYPE_FALSE=number(1) default 0
BOOLEAN_SQL_TYPE_TRUE=number(1) default 1
BOOLEAN_SQL_TYPE=number(1)
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 modify
defaultpageid varchar(48) DEFAULT ''
ALTER_TABLE_PINGTARGET_CONDITIONCODE_NOT_NULL= alter table pingtarget
modify conditioncode not null
ALTER_TABLE_PINGTARGET_CONDITIONCODE_DEFAULT_0= alter table pingtarget
modify conditioncode set default 0
ALTER_TABLE_WEBSITE_HANDLE_DEFAULT=alter table website modify handle
varchar(255) default ''
ALTER_TABLE_WEBSITE_HANDLE_NOT_NULL=alter table website modify handle
varchar(255) not null
ALTER_TABLE_WEBSITE_DATECREATED_DEFAULT=alter table website modify datecreated
timestamp default '20050101'
ALTER_TABLE_WEBSITE_DATECREATED_NOT_NULL=alter table website modif
y datecreated timestamp not null
ALTER_TABLE_WEBSITE_EMAILADDRESS_DEFAULT=alter table website modify
emailaddress varchar(255) default ''
ALTER_TABLE_WEBSITE_EMAILADDRESS_NOT_NULL=alter table website modify handle
varchar(255) not null
ALTER_TABLE_WEBLOGENTY_USERID_DEFAULT=alter table weblogentry modify userid
varchar(48) default ''
ALTER_TABLE_WEBLOGENTY_USERID_NOT_NULL=alter table weblogentry modify userid
varchar(48) not null
ALTER_TABLE_WEBLOGENTRY_STATUS_DEFAULT=alter table weblogentry modify status
varchar(20) default ''
ALTER_TABLE_WEBLOGENTRY_STATUS_NOT_NULL=alter table weblogentry modify status
varchar(20) not null
ALTER_TABLE_ROLLERUSER_ISENABLED_DEFAULT=alter table rolleruser modify
isenabled boolean default true
ALTER_TABLE_ROLLERUSER_ISENABLED_NOT_NULL=alter table rolleruser modify
isenabled boolean not null
ALTER_TABLE_ROLLERUSER_LOCALE_DEFAULT=alter table rolleruser modify locale
varchar(50) default ''
ALTER_TABLE_ROLLERUSER_LOCALE_NOT_NULL=alter table ro
lleruser modify locale varchar(50) not null
ALTER_TABLE_ROLLERUSER_TIMEZONE_DEFAULT=alter table rolleruser modify timezone
varchar(50) default ''
ALTER_TABLE_ROLLERUSER_TIMEZONE_NOT_NULL=alter table rolleruser modify timezone
varchar(50) not null
ALTER_TABLE_ROLLER_COMMENT_APPROVED_DEFAULT_FALSE= alter table roller_comment
modify approved set default false
ALTER_TABLE_ROLLER_COMMENT_APPROVED_NOT_NULL= alter table roller_comment
modify approved add not null
ALTER_TABLE_ROLLER_COMMENT_PENDING_DEFAULT_FALSE= alter table roller_comment
modify pending set default false
ALTER_TABLE_ROLLER_COMMENT_PENDING_NOT_NULL= alter table roller_comment
modify pending add not null
ALTER_TABLE_WEBSITE_COMMENTMOD_DEFAULT_FALSE=alter table website modify
commendmod set default false
ALTER_TABLE_WEBSITE_COMMENTMOD_NOT_NULL= alter table website modify
commendmod add not null;
ALTER_TABLE_WEBSITE_DEFAULTALLOWCOMMENTS_DEFAULT_TRUE=alter table website
modify defaultallowcomments
set default true
ALTER_TABLE_WEBSITE_DEFAULTALLOWCOMMENTS_NOT_NULL= alter table website
modify defaultallowcomments add not null
ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_DEFAULT_7= alter table website modify
defaultcommentdays set default 7
ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_NOT_NULL= alter table website modify
defaultcommentdays add not null
\ No newline at end of file
+TEXT_SQL_TYPE=clob
BOOLEAN_SQL_TYPE_FALSE=number(1) default 0
BOOLEAN_SQL_TYPE_TRUE=number(1) default 1
BOOLEAN_SQL_TYPE=number(1)
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 modify
defaultpageid varchar(48) DEFAULT ''
ALTER_TABLE_PINGTARGET_CONDITIONCODE_NOT_NULL= alter table pingtarget
modify conditioncode not null
ALTER_TABLE_PINGTARGET_CONDITIONCODE_DEFAULT_0= alter table pingtarget
modify conditioncode set default 0
ALTER_TABLE_WEBSITE_HANDLE_DEFAULT=alter table website modify handle
varchar(255) default ''
ALTER_TABLE_WEBSITE_HANDLE_NOT_NULL=alter table website modify handle
varchar(255) not null
ALTER_TABLE_WEBSITE_DATECREATED_DEFAULT=alter table website modify datecreated
timestamp default '20050101'
ALTER_TABLE_WEBSITE_DATECREATED_NOT_NULL=alter table website modif
y datecreated timestamp not null
ALTER_TABLE_WEBSITE_EMAILADDRESS_DEFAULT=alter table website modify
emailaddress varchar(255) default ''
ALTER_TABLE_WEBSITE_EMAILADDRESS_NOT_NULL=alter table website modify
emailaddress varchar(255) not null
ALTER_TABLE_WEBLOGENTY_USERID_DEFAULT=alter table weblogentry modify userid
varchar(48) default ''
ALTER_TABLE_WEBLOGENTY_USERID_NOT_NULL=alter table weblogentry modify userid
varchar(48) not null
ALTER_TABLE_WEBLOGENTRY_STATUS_DEFAULT=alter table weblogentry modify status
varchar(20) default ''
ALTER_TABLE_WEBLOGENTRY_STATUS_NOT_NULL=alter table weblogentry modify status
varchar(20) not null
ALTER_TABLE_ROLLERUSER_ISENABLED_DEFAULT=alter table rolleruser modify
isenabled boolean default true
ALTER_TABLE_ROLLERUSER_ISENABLED_NOT_NULL=alter table rolleruser modify
isenabled boolean not null
ALTER_TABLE_ROLLERUSER_LOCALE_DEFAULT=alter table rolleruser modify locale
varchar(50) default ''
ALTER_TABLE_ROLLERUSER_LOCALE_NOT_NULL=alter ta
ble rolleruser modify locale varchar(50) not null
ALTER_TABLE_ROLLERUSER_TIMEZONE_DEFAULT=alter table rolleruser modify timezone
varchar(50) default ''
ALTER_TABLE_ROLLERUSER_TIMEZONE_NOT_NULL=alter table rolleruser modify timezone
varchar(50) not null
ALTER_TABLE_ROLLER_COMMENT_APPROVED_DEFAULT_FALSE= alter table roller_comment
modify approved set default false
ALTER_TABLE_ROLLER_COMMENT_APPROVED_NOT_NULL= alter table roller_comment
modify approved add not null
ALTER_TABLE_ROLLER_COMMENT_PENDING_DEFAULT_FALSE= alter table roller_comment
modify pending set default false
ALTER_TABLE_ROLLER_COMMENT_PENDING_NOT_NULL= alter table roller_comment
modify pending add not null
ALTER_TABLE_WEBSITE_COMMENTMOD_DEFAULT_FALSE=alter table website modify
commendmod set default false
ALTER_TABLE_WEBSITE_COMMENTMOD_NOT_NULL= alter table website modify
commendmod add not null;
ALTER_TABLE_WEBSITE_DEFAULTALLOWCOMMENTS_DEFAULT_TRUE=alter table website
modify defaultallowco
mments set default true
ALTER_TABLE_WEBSITE_DEFAULTALLOWCOMMENTS_NOT_NULL= alter table website
modify defaultallowcomments add not null
ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_DEFAULT_7= alter table website modify
defaultcommentdays set default 7
ALTER_TABLE_WEBSITE_DEFAULTCOMMENTDAYS_NOT_NULL= alter table website modify
defaultcommentdays add not null
\ No newline at end of file
Modified:
incubator/roller/branches/roller_2.0/metadata/database/db_postgresql.properties
URL:
http://svn.apache.org/viewcvs/incubator/roller/branches/roller_2.0/metadata/database/db_postgresql.properties?rev=366277&r1=366276&r2=366277&view=diff
==============================================================================
---
incubator/roller/branches/roller_2.0/metadata/database/db_postgresql.properties
(original)
+++
incubator/roller/branches/roller_2.0/metadata/database/db_postgresql.properties
Thu Jan 5 12:48:25 2006
@@ -22,7 +22,7 @@
ALTER_TABLE_WEBSITE_DATECREATED_NOT_NULL=alter table website alter datecreated
set not null
ALTER_TABLE_WEBSITE_EMAILADDRESS_DEFAULT=alter table website alter
emailaddress set default ''
-ALTER_TABLE_WEBSITE_EMAILADDRESS_NOT_NULL=alter table website alter handle set
not null
+ALTER_TABLE_WEBSITE_EMAILADDRESS_NOT_NULL=alter table website alter
emailaddress set not null
ALTER_TABLE_WEBLOGENTY_USERID_DEFAULT=alter table weblogentry alter userid set
default ''
ALTER_TABLE_WEBLOGENTY_USERID_NOT_NULL=alter table weblogentry alter userid
set not null
