Author: pledbrook
Date: 2006-06-13 03:09:13-0700
New Revision: 10172
Modified:
branches/release/b21/src/schema/scarab-schema.xml
branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-2.sql
branches/release/b21/src/sql/oracle/upgrade/oracle-upgrade-1.0b20-1.0b21-2.sql
branches/release/b21/src/sql/postgresql/upgrade/postgresql-upgrade-1.0b20-1.0b21-2.sql
Log:
Renamed the COMMENT column in the new SCARAB_NOTIFICATION_STATUS table
to STATUS_COMMENT. This is required so that Scarab works with Oracle,
which has "comment" as a keyword.
Modified: branches/release/b21/src/schema/scarab-schema.xml
Url: http://scarab.tigris.org/source/browse/scarab/branches/release/b21/src/schema/scarab-schema.xml?view=diff&rev=10172&p1=branches/release/b21/src/schema/scarab-schema.xml&p2=branches/release/b21/src/schema/scarab-schema.xml&r1=10171&r2=10172
==============================================================================
--- branches/release/b21/src/schema/scarab-schema.xml (original)
+++ branches/release/b21/src/schema/scarab-schema.xml 2006-06-13 03:09:13-0700
@@ -1942,7 +1942,7 @@
<!-- =============================================================== -->
<!-- optional comment (mainly used for error messages) -->
<!-- =============================================================== -->
- <column name="COMMENT" required="false" type="VARCHAR" size="255"/>
+ <column name="STATUS_COMMENT" javaName="Comment" required="false" type="VARCHAR" size="255"/>
<foreign-key foreignTable="TURBINE_USER">
Modified: branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-2.sql
Url: http://scarab.tigris.org/source/browse/scarab/branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-2.sql?view=diff&rev=10172&p1=branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-2.sql&p2=branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-2.sql&r1=10171&r2=10172
==============================================================================
--- branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-2.sql (original)
+++ branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-2.sql 2006-06-13 03:09:13-0700
@@ -18,7 +18,7 @@
STATUS MEDIUMINT NOT NULL,
CREATION_DATE DATETIME,
CHANGE_DATE DATETIME,
- COMMENT VARCHAR(255),
+ STATUS_COMMENT VARCHAR(255),
PRIMARY KEY(ACTIVITY_ID,CREATOR_ID,RECEIVER_ID),
FOREIGN KEY (CREATOR_ID) REFERENCES TURBINE_USER (USER_ID),
FOREIGN KEY (RECEIVER_ID) REFERENCES TURBINE_USER (USER_ID),
Modified: branches/release/b21/src/sql/oracle/upgrade/oracle-upgrade-1.0b20-1.0b21-2.sql
Url: http://scarab.tigris.org/source/browse/scarab/branches/release/b21/src/sql/oracle/upgrade/oracle-upgrade-1.0b20-1.0b21-2.sql?view=diff&rev=10172&p1=branches/release/b21/src/sql/oracle/upgrade/oracle-upgrade-1.0b20-1.0b21-2.sql&p2=branches/release/b21/src/sql/oracle/upgrade/oracle-upgrade-1.0b20-1.0b21-2.sql&r1=10171&r2=10172
==============================================================================
--- branches/release/b21/src/sql/oracle/upgrade/oracle-upgrade-1.0b20-1.0b21-2.sql (original)
+++ branches/release/b21/src/sql/oracle/upgrade/oracle-upgrade-1.0b20-1.0b21-2.sql 2006-06-13 03:09:13-0700
@@ -9,7 +9,7 @@
STATUS MEDIUMINT NOT NULL,
CREATION_DATE DATETIME,
CHANGE_DATE DATETIME,
- COMMENT VARCHAR2(255),
+ STATUS_COMMENT VARCHAR2(255),
PRIMARY KEY(ACTIVITY_ID,CREATOR_ID,RECEIVER_ID),
FOREIGN KEY (CREATOR_ID) REFERENCES TURBINE_USER (USER_ID),
FOREIGN KEY (RECEIVER_ID) REFERENCES TURBINE_USER (USER_ID),
Modified: branches/release/b21/src/sql/postgresql/upgrade/postgresql-upgrade-1.0b20-1.0b21-2.sql
Url: http://scarab.tigris.org/source/browse/scarab/branches/release/b21/src/sql/postgresql/upgrade/postgresql-upgrade-1.0b20-1.0b21-2.sql?view=diff&rev=10172&p1=branches/release/b21/src/sql/postgresql/upgrade/postgresql-upgrade-1.0b20-1.0b21-2.sql&p2=branches/release/b21/src/sql/postgresql/upgrade/postgresql-upgrade-1.0b20-1.0b21-2.sql&r1=10171&r2=10172
==============================================================================
--- branches/release/b21/src/sql/postgresql/upgrade/postgresql-upgrade-1.0b20-1.0b21-2.sql (original)
+++ branches/release/b21/src/sql/postgresql/upgrade/postgresql-upgrade-1.0b20-1.0b21-2.sql 2006-06-13 03:09:13-0700
@@ -15,7 +15,7 @@
STATUS INTEGER NOT NULL,
CREATION_DATE DATE,
CHANGE_DATE DATE,
- COMMENT VARCHAR(255),
+ STATUS_COMMENT VARCHAR(255),
PRIMARY KEY(ACTIVITY_ID,CREATOR_ID,RECEIVER_ID),
FOREIGN KEY (CREATOR_ID) REFERENCES TURBINE_USER (USER_ID),
FOREIGN KEY (RECEIVER_ID) REFERENCES TURBINE_USER (USER_ID),
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.