Author: ronvoe122
Date: 2007-12-26 15:22:18-0800
New Revision: 10533
Modified:
trunk/src/sql/scarab-sample-data.sql
Log:
SCB2426: fill lastTransId and createdTransId in sample data inserts.
Modified: trunk/src/sql/scarab-sample-data.sql
Url: http://scarab.tigris.org/source/browse/scarab/trunk/src/sql/scarab-sample-data.sql?view=diff&rev=10533&p1=trunk/src/sql/scarab-sample-data.sql&p2=trunk/src/sql/scarab-sample-data.sql&r1=10532&r2=10533
==============================================================================
--- trunk/src/sql/scarab-sample-data.sql (original)
+++ trunk/src/sql/scarab-sample-data.sql 2007-12-26 15:22:18-0800
@@ -4350,8 +4350,8 @@
insert into SCARAB_TRANSACTION(TRANSACTION_ID, TYPE_ID, CREATED_BY, CREATED_DATE)
values (1, 1, 5, '2001-09-02 00:30:00');
insert into SCARAB_ISSUE(ISSUE_ID, MODULE_ID, TYPE_ID, ID_PREFIX, ID_COUNT, ID_DOMAIN,
- CREATED_TRANS_ID)
- values (1, 5, 1, 'PACS', 1, 'local', 1);
+ CREATED_TRANS_ID, LAST_TRANS_ID)
+ values (1, 5, 1, 'PACS', 1, 'local', 1, 1);
insert into SCARAB_ACTIVITY(ACTIVITY_ID, ISSUE_ID, ATTRIBUTE_ID, TRANSACTION_ID, NEW_VALUE, DESCRIPTION)
values (1, 1, 11, 1, 'Docs are out of date.', 'Description set to Docs are out of Date');
insert into SCARAB_ACTIVITY(ACTIVITY_ID, ISSUE_ID, ATTRIBUTE_ID, TRANSACTION_ID, NEW_OPTION_ID, DESCRIPTION)
@@ -4380,8 +4380,8 @@
insert into SCARAB_TRANSACTION(TRANSACTION_ID, TYPE_ID, CREATED_BY, CREATED_DATE)
values (2, 1, 5, '2001-09-03 08:15:00');
insert into SCARAB_ISSUE(ISSUE_ID, MODULE_ID, TYPE_ID, ID_PREFIX, ID_COUNT, ID_DOMAIN,
- CREATED_TRANS_ID)
- values (2, 2, 1, 'PACD', 1, 'local', 2);
+ CREATED_TRANS_ID, LAST_TRANS_ID)
+ values (2, 2, 1, 'PACD', 1, 'local', 2, 2);
insert into SCARAB_ACTIVITY(ACTIVITY_ID, ISSUE_ID, ATTRIBUTE_ID, TRANSACTION_ID, NEW_VALUE, DESCRIPTION)
values (3, 2, 11, 2, 'Dates display in long form instead of short form.',
'Issue 2 had Description set to ''Dates display in long form instead of short form''');
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.