roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From snoopd...@apache.org
Subject svn commit: r366277 - in /incubator/roller/branches/roller_2.0/metadata/database: db_db2.properties db_derby.properties db_hsql.properties db_mysql.properties db_oracle.properties db_postgresql.properties
Date Thu, 05 Jan 2006 20:48:32 GMT
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



Mime
View raw message