Author: ronvoe122
Date: 2006-12-01 09:18:24-0800
New Revision: 10373
Modified:
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:
[SCB1793] changed upgrade scripts of other dbs.
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=10373&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=10372&r2=10373
==============================================================================
--- 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-12-01 09:18:24-0800
@@ -12,7 +12,10 @@
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),
+-- [SCB1793] commented out the next fk,
+-- because in b21 a nonexistent user_id is used to
+-- save a notification for the archive emails
+-- FOREIGN KEY (RECEIVER_ID) REFERENCES TURBINE_USER (USER_ID),
FOREIGN KEY (ACTIVITY_ID) REFERENCES SCARAB_ACTIVITY (ACTIVITY_ID),
INDEX IX_NOTIF_STATUS (STATUS)
);
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=10373&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=10372&r2=10373
==============================================================================
--- 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-12-01 09:18:24-0800
@@ -18,7 +18,10 @@
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),
+-- [SCB1793] commented out the next fk,
+-- because in b21 a nonexistent user_id is used to
+-- save a notification for the archive emails
+-- FOREIGN KEY (RECEIVER_ID) REFERENCES TURBINE_USER (USER_ID),
FOREIGN KEY (ACTIVITY_ID) REFERENCES SCARAB_ACTIVITY (ACTIVITY_ID)
);
CREATE INDEX IX_NOTIF_STATUS ON SCARAB_NOTIFICATION_STATUS (STATUS);
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.