Scarab commit: svn commit: r10933 - branches/release/0.22/src/sql/scarab-jira-templates-data.sql
Johannes Höchstädter <[email protected]>
| Newsgroups | gmane.comp.java.scarab.cvs |
|---|---|
| Message-ID | <[email protected]> |
Author: jhoech Date: 2010-03-01 01:07:51-0800 New Revision: 10933 Modified: branches/release/0.22/src/sql/scarab-jira-templates-data.sql Log: CHG - Id count for jira templates corrected according to documentation. Modified: branches/release/0.22/src/sql/scarab-jira-templates-data.sql Url: http://scarab.tigris.org/source/browse/scarab/branches/release/0.22/src/sql/scarab-jira-templates-data.sql?view=diff&pathrev=10933&r1=10932&r2=10933 ============================================================================== --- branches/release/0.22/src/sql/scarab-jira-templates-data.sql (original) +++ branches/release/0.22/src/sql/scarab-jira-templates-data.sql 2010-03-01 01:07:51-0800 @@ -1,303 +1,299 @@ -- --- Dumping data for table SCARAB_ISSUE_TYPE +-- Data for table SCARAB_ISSUE_TYPE -- --- TODO move this IDs starting from 200 -INSERT INTO SCARAB_ISSUE_TYPE VALUES (100,'[JIRA] Bug','Bug type for JIRA based modules.\r\nDo not modify or imports from JIRA xmls will fail.',0,1,0,0,0); -INSERT INTO SCARAB_ISSUE_TYPE VALUES (101,'[JIRA] Bug Template',NULL,100,1,0,0,0); -INSERT INTO SCARAB_ISSUE_TYPE VALUES (102,'[JIRA] New Feature','New Feature type for JIRA based modules.\r\nDo not modify or imports from JIRA xmls will fail.',0,1,0,0,0); -INSERT INTO SCARAB_ISSUE_TYPE VALUES (103,'[JIRA] New Feature Template',NULL,102,1,0,0,0); -INSERT INTO SCARAB_ISSUE_TYPE VALUES (104,'[JIRA] Improvement','Improvement type for JIRA based modules.\r\nDo not modify or imports from JIRA xmls will fail.',0,1,0,0,0); -INSERT INTO SCARAB_ISSUE_TYPE VALUES (105,'[JIRA] Improvement Template',NULL,104,1,0,0,0); -INSERT INTO SCARAB_ISSUE_TYPE VALUES (106,'[JIRA] Support Request','Support Request type for JIRA based modules.\r\nDo not modify or imports from JIRA xmls will fail.',0,1,0,0,0); -INSERT INTO SCARAB_ISSUE_TYPE VALUES (107,'[JIRA] Support Request Template',NULL,106,1,0,0,0); -INSERT INTO SCARAB_ISSUE_TYPE VALUES (108,'[JIRA] Task','Task type for JIRA based modules.\r\nDo not modify or imports from JIRA xmls will fail.',0,1,0,0,0); -INSERT INTO SCARAB_ISSUE_TYPE VALUES (109,'[JIRA] Task Template',NULL,108,1,0,0,0); - --- --- Dumping data for table SCARAB_ATTRIBUTE --- - --- TODO move this IDs starting from 200 -INSERT INTO SCARAB_ATTRIBUTE VALUES (100,'[JIRA] Summary',1,NULL,NULL,'Summary attribute for JIRA issuetypes.\r\nDo not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-06 22:36:13',0); -INSERT INTO SCARAB_ATTRIBUTE VALUES (101,'[JIRA] Description',12,NULL,NULL,'Decription attribute for JIRA issuetypes.\r\nDo not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-06 22:43:00',0); -INSERT INTO SCARAB_ATTRIBUTE VALUES (120,'[JIRA] Status',5,NULL,NULL,'Status attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-09 16:34:01',0); -INSERT INTO SCARAB_ATTRIBUTE VALUES (103,'[JIRA] Component',5,NULL,NULL,'Component attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.',NULL,NULL,'2001-12-31 13:30:00',0); -INSERT INTO SCARAB_ATTRIBUTE VALUES (121,'[JIRA] Environment',1,NULL,NULL,'Environment attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-09 16:36:17',0); -INSERT INTO SCARAB_ATTRIBUTE VALUES (122,'[JIRA] Priority',5,NULL,NULL,'Priority attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-09 16:36:40',0); -INSERT INTO SCARAB_ATTRIBUTE VALUES (123,'[JIRA] Version',5,NULL,NULL,'Version attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-09 16:37:57',0); -INSERT INTO SCARAB_ATTRIBUTE VALUES (124,'[JIRA] Due',13,NULL,NULL,'Due attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-09 16:39:19',0); -INSERT INTO SCARAB_ATTRIBUTE VALUES (125,'[JIRA] Votes',3,NULL,NULL,'Votes attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-09 16:40:10',0); -INSERT INTO SCARAB_ATTRIBUTE VALUES (140,'[JIRA] Assignee',8,'Issue | View',NULL,'Assignee attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.','to',1,'2005-12-10 14:43:31',0); -INSERT INTO SCARAB_ATTRIBUTE VALUES (141,'[JIRA] Resolution',5,NULL,5,'Resolution attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-10 14:43:55',0); - - --- --- Dumping data for table SCARAB_ATTRIBUTE_GROUP --- - -INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (214,'Summary','Summary attributes...',NULL,102,1,1,1,NULL); -INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (215,'General attributes','General attributes...',NULL,102,1,0,3,NULL); -INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (216,'Summary','Summary Attributes...',NULL,104,1,1,1,NULL); -INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (217,'General Attributes','General attributes...',NULL,104,1,0,3,NULL); -INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (218,'Summary','Summary attributes...',NULL,106,1,1,1,NULL); -INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (219,'General attributes','General attributes...',NULL,106,1,0,3,NULL); -INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (210,'Summary','Summary attributes...',NULL,100,1,1,1,NULL); -INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (211,'General Attributes','Attributes...',NULL,100,1,0,3,NULL); -INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (240,'Summary','Summary attributes',NULL,108,1,1,1,NULL); -INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (241,'General attributes','General attributes...',NULL,108,1,0,3,NULL); - --- --- Dumping data for table SCARAB_ATTRIBUTE_OPTION --- - -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (201,120,'Opened',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (202,120,'In Progress',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (203,120,'Reopened',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (204,120,'Resolved',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (206,120,'Closed',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (207,122,'Major',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (208,122,'Minor',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (209,122,'Trivial',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (210,122,'Undecided',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (230,141,'Fixed',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (231,141,'Invalid',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (232,141,'Wontfix',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (233,141,'Later',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (234,141,'Remind',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (235,141,'Duplicate',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (236,141,'Worksforme',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (237,141,'Moved',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (250,122,'Blocker',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (251,141,'Unresolved',0); -INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (271,122,'Critical',0); - --- --- Dumping data for table SCARAB_R_ATTRIBUTE_ATTRGROUP --- - -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (211,123,4); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (211,120,1); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (211,122,3); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (211,124,5); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (210,121,4); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (210,103,3); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (210,100,1); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (210,101,2); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (217,141,2); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (217,122,3); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (217,124,5); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (216,100,1); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (216,121,4); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (216,101,2); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (216,103,3); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (211,141,2); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (211,125,6); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (215,124,5); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (214,100,1); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (214,101,2); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (214,103,3); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (217,125,6); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (217,123,4); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (217,120,1); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (218,103,3); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (215,125,6); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (215,123,4); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (215,120,1); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (215,141,2); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (215,122,3); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (214,121,4); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (219,120,1); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (219,141,2); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (219,122,3); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (219,124,5); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (218,100,1); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (218,121,4); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (218,101,2); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (219,123,4); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (219,125,6); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (240,103,3); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (240,101,2); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (240,121,4); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (240,100,1); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (241,124,5); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (241,122,3); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (241,141,2); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (241,120,1); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (241,123,4); -INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (241,125,6); - --- --- Dumping data for table SCARAB_R_ISSUETYPE_ATTRIBUTE --- - --- TODO move this IDs starting from 200 -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (101,100,1,0,1,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (100,100,1,1,2,0,1,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (103,100,1,0,3,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (121,100,1,0,4,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (124,100,1,0,5,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (122,100,1,0,6,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (120,100,1,0,7,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (123,100,1,0,8,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (125,100,1,0,9,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (140,100,1,0,1,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (141,100,1,0,10,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (103,104,1,0,1,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (101,104,1,0,2,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (121,104,1,0,3,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (100,104,1,1,4,0,1,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (140,104,1,0,1,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (124,104,1,0,5,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (122,104,1,0,6,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (141,104,1,0,7,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (120,104,1,0,8,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (123,104,1,0,9,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (125,104,1,0,10,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (103,102,1,0,1,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (101,102,1,0,2,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (100,102,1,1,3,0,1,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (124,102,1,0,4,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (121,102,1,0,11,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (122,102,1,0,6,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (141,102,1,0,7,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (120,102,1,0,8,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (123,102,1,0,9,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (125,102,1,0,10,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (140,102,1,0,1,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (103,106,1,0,1,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (101,106,1,1,2,0,1,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (121,106,1,0,3,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (100,106,1,1,4,0,1,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (124,106,1,0,5,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (122,106,1,0,6,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (141,106,1,0,7,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (120,106,1,0,8,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (123,106,1,0,9,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (125,106,1,0,10,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (140,106,1,0,1,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (103,108,1,0,1,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (101,108,1,0,2,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (121,108,1,0,3,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (100,108,1,1,4,0,1,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (124,108,1,0,5,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (122,108,1,0,6,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (141,108,1,0,7,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (120,108,1,0,8,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (123,108,1,0,9,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (125,108,1,0,10,0,0,0); -INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (140,108,1,0,1,0,0,0); - - --- --- Dumping data for table SCARAB_R_ISSUETYPE_OPTION --- - --- TODO move this IDs starting from 200 -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,207,1,1,3,1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,208,1,1,4,2); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,209,1,1,5,3); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,210,1,1,6,4); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,250,1,1,1,-1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,201,1,1,1,-1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,202,1,1,2,-1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,203,1,1,3,4); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,204,1,1,4,5); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,271,1,1,2,-1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,206,1,1,5,7); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,230,1,1,1,1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,231,1,1,2,2); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,232,1,1,3,3); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,233,1,1,4,4); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,234,1,1,5,5); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,235,1,1,6,6); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,236,1,1,7,7); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,237,1,1,8,8); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,207,1,1,3,1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,208,1,1,4,2); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,209,1,1,5,3); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,210,1,1,6,4); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,230,1,1,1,1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,231,1,1,2,2); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,232,1,1,3,3); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,233,1,1,4,4); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,234,1,1,5,5); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,235,1,1,6,6); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,236,1,1,7,7); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,237,1,1,8,8); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,251,1,1,9,-1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,201,1,1,1,2); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,202,1,1,3,3); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,203,1,1,2,4); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,204,1,1,4,5); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,250,1,1,1,-1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,206,1,1,5,7); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,207,1,1,3,1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,208,1,1,4,2); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,209,1,1,5,3); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,210,1,1,6,4); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,230,1,1,1,1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,231,1,1,2,2); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,232,1,1,3,3); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,233,1,1,4,4); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,234,1,1,5,5); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,235,1,1,6,6); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,236,1,1,7,7); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,237,1,1,8,8); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,251,1,1,9,-1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,201,1,1,1,2); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,202,1,1,3,3); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,203,1,1,2,4); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,204,1,1,4,5); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,271,1,1,2,-1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,206,1,1,5,7); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,207,1,1,3,1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,208,1,1,4,2); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,209,1,1,5,3); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,210,1,1,6,4); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,230,1,1,1,1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,231,1,1,2,2); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,232,1,1,3,3); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,233,1,1,4,4); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,234,1,1,5,5); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,235,1,1,6,6); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,236,1,1,7,7); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,237,1,1,8,8); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,251,1,1,9,-1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,201,1,1,1,2); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,202,1,1,3,3); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,203,1,1,2,4); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,204,1,1,4,5); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (102,250,1,1,1,-1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (106,206,1,1,5,7); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,207,1,1,3,1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,208,1,1,4,2); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,209,1,1,5,3); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,210,1,1,6,4); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,230,1,1,1,1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,231,1,1,2,2); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,232,1,1,3,3); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,233,1,1,4,4); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,234,1,1,5,5); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,235,1,1,6,6); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,236,1,1,7,7); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,237,1,1,8,8); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,251,1,1,9,-1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,201,1,1,1,2); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,202,1,1,3,3); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,203,1,1,2,4); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,204,1,1,4,5); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (104,271,1,1,2,-1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,206,1,1,5,7); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,250,1,1,1,-1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (100,271,1,1,2,-1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,250,1,1,1,-1); -INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (108,271,1,1,2,-1); +INSERT INTO SCARAB_ISSUE_TYPE VALUES (200,'[JIRA] Bug','Bug type for JIRA based modules.\r\nDo not modify or imports from JIRA xmls will fail.',0,1,0,0,0); +INSERT INTO SCARAB_ISSUE_TYPE VALUES (201,'[JIRA] Bug Template',NULL,200,1,0,0,0); +INSERT INTO SCARAB_ISSUE_TYPE VALUES (202,'[JIRA] New Feature','New Feature type for JIRA based modules.\r\nDo not modify or imports from JIRA xmls will fail.',0,1,0,0,0); +INSERT INTO SCARAB_ISSUE_TYPE VALUES (203,'[JIRA] New Feature Template',NULL,202,1,0,0,0); +INSERT INTO SCARAB_ISSUE_TYPE VALUES (204,'[JIRA] Improvement','Improvement type for JIRA based modules.\r\nDo not modify or imports from JIRA xmls will fail.',0,1,0,0,0); +INSERT INTO SCARAB_ISSUE_TYPE VALUES (205,'[JIRA] Improvement Template',NULL,204,1,0,0,0); +INSERT INTO SCARAB_ISSUE_TYPE VALUES (206,'[JIRA] Support Request','Support Request type for JIRA based modules.\r\nDo not modify or imports from JIRA xmls will fail.',0,1,0,0,0); +INSERT INTO SCARAB_ISSUE_TYPE VALUES (207,'[JIRA] Support Request Template',NULL,206,1,0,0,0); +INSERT INTO SCARAB_ISSUE_TYPE VALUES (208,'[JIRA] Task','Task type for JIRA based modules.\r\nDo not modify or imports from JIRA xmls will fail.',0,1,0,0,0); +INSERT INTO SCARAB_ISSUE_TYPE VALUES (209,'[JIRA] Task Template',NULL,208,1,0,0,0); + +-- +-- Data for table SCARAB_ATTRIBUTE +-- + +INSERT INTO SCARAB_ATTRIBUTE VALUES (200,'[JIRA] Summary',1,NULL,NULL,'Summary attribute for JIRA issuetypes.\r\nDo not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-06 22:36:13',0); +INSERT INTO SCARAB_ATTRIBUTE VALUES (201,'[JIRA] Description',12,NULL,NULL,'Decription attribute for JIRA issuetypes.\r\nDo not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-06 22:43:00',0); +INSERT INTO SCARAB_ATTRIBUTE VALUES (220,'[JIRA] Status',5,NULL,NULL,'Status attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-09 16:34:01',0); +INSERT INTO SCARAB_ATTRIBUTE VALUES (203,'[JIRA] Component',5,NULL,NULL,'Component attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.',NULL,NULL,'2001-12-31 13:30:00',0); +INSERT INTO SCARAB_ATTRIBUTE VALUES (221,'[JIRA] Environment',1,NULL,NULL,'Environment attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-09 16:36:17',0); +INSERT INTO SCARAB_ATTRIBUTE VALUES (222,'[JIRA] Priority',5,NULL,NULL,'Priority attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-09 16:36:40',0); +INSERT INTO SCARAB_ATTRIBUTE VALUES (223,'[JIRA] Version',5,NULL,NULL,'Version attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-09 16:37:57',0); +INSERT INTO SCARAB_ATTRIBUTE VALUES (224,'[JIRA] Due',13,NULL,NULL,'Due attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-09 16:39:19',0); +INSERT INTO SCARAB_ATTRIBUTE VALUES (225,'[JIRA] Votes',3,NULL,NULL,'Votes attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-09 16:40:10',0); +INSERT INTO SCARAB_ATTRIBUTE VALUES (240,'[JIRA] Assignee',8,'Issue | View',NULL,'Assignee attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.','to',1,'2005-12-10 14:43:31',0); +INSERT INTO SCARAB_ATTRIBUTE VALUES (241,'[JIRA] Resolution',5,NULL,5,'Resolution attribute for JIRA issuetypes. Do not modify or importing JIRA xmls will fail.',NULL,1,'2005-12-10 14:43:55',0); + + +-- +-- Data for table SCARAB_ATTRIBUTE_GROUP +-- + +INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (214,'Summary','Summary attributes...',NULL,202,1,1,1,NULL); +INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (215,'General attributes','General attributes...',NULL,202,1,0,3,NULL); +INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (216,'Summary','Summary Attributes...',NULL,204,1,1,1,NULL); +INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (217,'General Attributes','General attributes...',NULL,204,1,0,3,NULL); +INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (218,'Summary','Summary attributes...',NULL,206,1,1,1,NULL); +INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (219,'General attributes','General attributes...',NULL,206,1,0,3,NULL); +INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (210,'Summary','Summary attributes...',NULL,200,1,1,1,NULL); +INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (211,'General Attributes','Attributes...',NULL,200,1,0,3,NULL); +INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (240,'Summary','Summary attributes',NULL,208,1,1,1,NULL); +INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (241,'General attributes','General attributes...',NULL,208,1,0,3,NULL); + +-- +-- Data for table SCARAB_ATTRIBUTE_OPTION +-- + +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (201,220,'Opened',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (202,220,'In Progress',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (203,220,'Reopened',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (204,220,'Resolved',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (206,220,'Closed',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (207,222,'Major',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (208,222,'Minor',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (209,222,'Trivial',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (210,222,'Undecided',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (230,241,'Fixed',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (231,241,'Invalid',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (232,241,'Wontfix',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (233,241,'Later',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (234,241,'Remind',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (235,241,'Duplicate',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (236,241,'Worksforme',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (237,241,'Moved',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (250,222,'Blocker',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (251,241,'Unresolved',0); +INSERT INTO SCARAB_ATTRIBUTE_OPTION VALUES (271,222,'Critical',0); + +-- +-- Data for table SCARAB_R_ATTRIBUTE_ATTRGROUP +-- + +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (211,223,4); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (211,220,1); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (211,222,3); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (211,224,5); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (210,221,4); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (210,203,3); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (210,200,1); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (210,201,2); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (217,241,2); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (217,222,3); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (217,224,5); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (216,200,1); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (216,221,4); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (216,201,2); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (216,203,3); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (211,241,2); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (211,225,6); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (215,224,5); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (214,200,1); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (214,201,2); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (214,203,3); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (217,225,6); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (217,223,4); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (217,220,1); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (218,203,3); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (215,225,6); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (215,223,4); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (215,220,1); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (215,241,2); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (215,222,3); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (214,221,4); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (219,220,1); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (219,241,2); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (219,222,3); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (219,224,5); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (218,200,1); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (218,221,4); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (218,201,2); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (219,223,4); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (219,225,6); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (240,203,3); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (240,201,2); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (240,221,4); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (240,200,1); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (241,224,5); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (241,222,3); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (241,241,2); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (241,220,1); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (241,223,4); +INSERT INTO SCARAB_R_ATTRIBUTE_ATTRGROUP VALUES (241,225,6); + +-- +-- Data for table SCARAB_R_ISSUETYPE_ATTRIBUTE +-- + +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (201,200,1,0,1,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (200,200,1,1,2,0,1,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (203,200,1,0,3,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (221,200,1,0,4,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (224,200,1,0,5,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (222,200,1,0,6,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (220,200,1,0,7,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (223,200,1,0,8,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (225,200,1,0,9,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (240,200,1,0,1,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (241,200,1,0,10,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (203,204,1,0,1,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (201,204,1,0,2,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (221,204,1,0,3,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (200,204,1,1,4,0,1,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (240,204,1,0,1,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (224,204,1,0,5,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (222,204,1,0,6,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (241,204,1,0,7,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (220,204,1,0,8,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (223,204,1,0,9,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (225,204,1,0,10,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (203,202,1,0,1,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (201,202,1,0,2,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (200,202,1,1,3,0,1,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (224,202,1,0,4,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (221,202,1,0,11,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (222,202,1,0,6,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (241,202,1,0,7,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (220,202,1,0,8,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (223,202,1,0,9,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (225,202,1,0,10,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (240,202,1,0,1,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (203,206,1,0,1,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (201,206,1,1,2,0,1,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (221,206,1,0,3,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (200,206,1,1,4,0,1,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (224,206,1,0,5,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (222,206,1,0,6,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (241,206,1,0,7,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (220,206,1,0,8,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (223,206,1,0,9,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (225,206,1,0,10,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (240,206,1,0,1,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (203,208,1,0,1,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (201,208,1,0,2,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (221,208,1,0,3,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (200,208,1,1,4,0,1,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (224,208,1,0,5,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (222,208,1,0,6,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (241,208,1,0,7,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (220,208,1,0,8,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (223,208,1,0,9,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (225,208,1,0,10,0,0,0); +INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (240,208,1,0,1,0,0,0); + + +-- +-- Data for table SCARAB_R_ISSUETYPE_OPTION +-- + +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,207,1,1,3,1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,208,1,1,4,2); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,209,1,1,5,3); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,210,1,1,6,4); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,250,1,1,1,-1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,201,1,1,1,-1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,202,1,1,2,-1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,203,1,1,3,4); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,204,1,1,4,5); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,271,1,1,2,-1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,206,1,1,5,7); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,230,1,1,1,1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,231,1,1,2,2); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,232,1,1,3,3); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,233,1,1,4,4); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,234,1,1,5,5); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,235,1,1,6,6); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,236,1,1,7,7); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,237,1,1,8,8); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,207,1,1,3,1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,208,1,1,4,2); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,209,1,1,5,3); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,210,1,1,6,4); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,230,1,1,1,1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,231,1,1,2,2); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,232,1,1,3,3); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,233,1,1,4,4); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,234,1,1,5,5); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,235,1,1,6,6); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,236,1,1,7,7); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,237,1,1,8,8); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,251,1,1,9,-1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,201,1,1,1,2); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,202,1,1,3,3); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,203,1,1,2,4); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,204,1,1,4,5); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,250,1,1,1,-1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,206,1,1,5,7); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,207,1,1,3,1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,208,1,1,4,2); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,209,1,1,5,3); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,210,1,1,6,4); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,230,1,1,1,1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,231,1,1,2,2); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,232,1,1,3,3); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,233,1,1,4,4); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,234,1,1,5,5); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,235,1,1,6,6); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,236,1,1,7,7); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,237,1,1,8,8); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,251,1,1,9,-1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,201,1,1,1,2); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,202,1,1,3,3); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,203,1,1,2,4); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,204,1,1,4,5); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,271,1,1,2,-1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,206,1,1,5,7); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,207,1,1,3,1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,208,1,1,4,2); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,209,1,1,5,3); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,210,1,1,6,4); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,230,1,1,1,1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,231,1,1,2,2); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,232,1,1,3,3); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,233,1,1,4,4); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,234,1,1,5,5); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,235,1,1,6,6); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,236,1,1,7,7); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,237,1,1,8,8); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,251,1,1,9,-1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,201,1,1,1,2); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,202,1,1,3,3); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,203,1,1,2,4); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,204,1,1,4,5); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (202,250,1,1,1,-1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (206,206,1,1,5,7); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,207,1,1,3,1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,208,1,1,4,2); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,209,1,1,5,3); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,210,1,1,6,4); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,230,1,1,1,1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,231,1,1,2,2); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,232,1,1,3,3); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,233,1,1,4,4); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,234,1,1,5,5); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,235,1,1,6,6); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,236,1,1,7,7); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,237,1,1,8,8); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,251,1,1,9,-1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,201,1,1,1,2); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,202,1,1,3,3); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,203,1,1,2,4); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,204,1,1,4,5); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (204,271,1,1,2,-1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,206,1,1,5,7); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,250,1,1,1,-1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (200,271,1,1,2,-1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,250,1,1,1,-1); +INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (208,271,1,1,2,-1); -- --- Dumping data for table SCARAB_R_OPTION_OPTION +-- Data for table SCARAB_R_OPTION_OPTION -- @@ -323,31 +319,29 @@ INSERT INTO SCARAB_R_OPTION_OPTION VALUES (0,203,1,4,4); -- --- Dumping data for table SCARAB_TRANSITION +-- Data for table SCARAB_TRANSITION -- --- TODO move this IDs starting from 200 -INSERT INTO SCARAB_TRANSITION VALUES (100,NULL,141,0,251,0); -INSERT INTO SCARAB_TRANSITION VALUES (130,NULL,141,251,NULL,0); -INSERT INTO SCARAB_TRANSITION VALUES (122,NULL,120,0,201,0); -INSERT INTO SCARAB_TRANSITION VALUES (123,4,120,201,202,0); -INSERT INTO SCARAB_TRANSITION VALUES (124,NULL,120,NULL,204,1); -INSERT INTO SCARAB_TRANSITION VALUES (125,5,120,204,206,1); -INSERT INTO SCARAB_TRANSITION VALUES (126,NULL,120,204,203,0); -INSERT INTO SCARAB_TRANSITION VALUES (127,NULL,120,206,203,0); - --- --- Dumping data for table SCARAB_CONDITION --- - --- TODO move this IDs starting from 200 -INSERT INTO SCARAB_CONDITION VALUES (187,125,NULL,NULL,NULL,237); -INSERT INTO SCARAB_CONDITION VALUES (186,125,NULL,NULL,NULL,236); -INSERT INTO SCARAB_CONDITION VALUES (185,125,NULL,NULL,NULL,235); -INSERT INTO SCARAB_CONDITION VALUES (171,130,NULL,NULL,NULL,204); -INSERT INTO SCARAB_CONDITION VALUES (184,125,NULL,NULL,NULL,234); -INSERT INTO SCARAB_CONDITION VALUES (183,125,NULL,NULL,NULL,233); -INSERT INTO SCARAB_CONDITION VALUES (182,125,NULL,NULL,NULL,232); -INSERT INTO SCARAB_CONDITION VALUES (181,125,NULL,NULL,NULL,231); -INSERT INTO SCARAB_CONDITION VALUES (180,125,NULL,NULL,NULL,230); +INSERT INTO SCARAB_TRANSITION VALUES (200,NULL,241,0,251,0); +INSERT INTO SCARAB_TRANSITION VALUES (230,NULL,241,251,NULL,0); +INSERT INTO SCARAB_TRANSITION VALUES (222,NULL,220,0,201,0); +INSERT INTO SCARAB_TRANSITION VALUES (223,4,220,201,202,0); +INSERT INTO SCARAB_TRANSITION VALUES (224,NULL,220,NULL,204,1); +INSERT INTO SCARAB_TRANSITION VALUES (225,5,220,204,206,1); +INSERT INTO SCARAB_TRANSITION VALUES (226,NULL,220,204,203,0); +INSERT INTO SCARAB_TRANSITION VALUES (227,NULL,220,206,203,0); + +-- +-- Data for table SCARAB_CONDITION +-- + +INSERT INTO SCARAB_CONDITION VALUES (287,225,NULL,NULL,NULL,237); +INSERT INTO SCARAB_CONDITION VALUES (286,225,NULL,NULL,NULL,236); +INSERT INTO SCARAB_CONDITION VALUES (285,225,NULL,NULL,NULL,235); +INSERT INTO SCARAB_CONDITION VALUES (271,230,NULL,NULL,NULL,204); +INSERT INTO SCARAB_CONDITION VALUES (284,225,NULL,NULL,NULL,234); +INSERT INTO SCARAB_CONDITION VALUES (283,225,NULL,NULL,NULL,233); +INSERT INTO SCARAB_CONDITION VALUES (282,225,NULL,NULL,NULL,232); +INSERT INTO SCARAB_CONDITION VALUES (281,225,NULL,NULL,NULL,231); +INSERT INTO SCARAB_CONDITION VALUES (280,225,NULL,NULL,NULL,230); ------------------------------------------------------ http://scarab.tigris.org/ds/viewMessage.do?dsForumId=3577&dsMessageId=2453316