Scarab commit: svn commit: r10533 - trunk/src/sql/scarab-sample-data.sql

[email protected]
Newsgroups gmane.comp.java.scarab.cvs
Message-ID <[email protected]>
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.