Scarab commit: svn commit: r10926 - branches/release/0.22/src/sql/scarab-default-data.sql

Author: jhoech
Date: 2010-02-25 07:59:15-0800
New Revision: 10926

Modified:
   branches/release/0.22/src/sql/scarab-default-data.sql

Log:
FIX - Default data revised.
  FIX - SCB3019 Global attribute groups from default data were invisible to user, because of wrong module id.
  ADD - Global mappings for issue types and attribute options added.
  ADD - Global mappings for user attributes and issue types added.


Modified: branches/release/0.22/src/sql/scarab-default-data.sql
Url: http://scarab.tigris.org/source/browse/scarab/branches/release/0.22/src/sql/scarab-default-data.sql?view=diff&pathrev=10926&r1=10925&r2=10926
==============================================================================
--- branches/release/0.22/src/sql/scarab-default-data.sql	(original)
+++ branches/release/0.22/src/sql/scarab-default-data.sql	2010-02-25 07:59:15-0800
@@ -439,20 +439,20 @@
 -- Insert attribute groups for project 0
 -- group_id, name, description, module_id, issue_type_id, active, dedupe, preferred order
 
-INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (1, 'AttributeGroupOne', 'dedupeAttributes', 0, 1, 1, 1, 1,NULL);
-INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (2, 'AttributeGroupTwo', 'nonDedupeAttributes', 0, 1, 1, 0, 3,NULL);
+INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (1, 'AttributeGroupOne', 'dedupeAttributes', NULL, 1, 1, 1, 1,NULL);
+INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (2, 'AttributeGroupTwo', 'nonDedupeAttributes', NULL, 1, 1, 0, 3,NULL);
 
-INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (3, 'AttributeGroupOne', 'dedupeAttributes', 0, 3, 1, 1, 1,NULL);
-INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (4, 'AttributeGroupTwo', 'nonDedupeAttributes', 0, 3, 1, 0, 3,NULL);
+INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (3, 'AttributeGroupOne', 'dedupeAttributes', NULL, 3, 1, 1, 1,NULL);
+INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (4, 'AttributeGroupTwo', 'nonDedupeAttributes', NULL, 3, 1, 0, 3,NULL);
 
-INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (5, 'AttributeGroupOne', 'dedupeAttributes', 0, 5, 1, 1, 1,NULL);
-INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (6, 'AttributeGroupTwo', 'nonDedupeAttributes', 0, 5, 1, 0, 3,NULL);
+INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (5, 'AttributeGroupOne', 'dedupeAttributes', NULL, 5, 1, 1, 1,NULL);
+INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (6, 'AttributeGroupTwo', 'nonDedupeAttributes', NULL, 5, 1, 0, 3,NULL);
 
-INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (7, 'AttributeGroupOne', 'dedupeAttributes', 0, 7, 1, 1, 1,NULL);
-INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (8, 'AttributeGroupTwo', 'nonDedupeAttributes', 0, 7, 1, 0, 3,NULL);
+INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (7, 'AttributeGroupOne', 'dedupeAttributes', NULL, 7, 1, 1, 1,NULL);
+INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (8, 'AttributeGroupTwo', 'nonDedupeAttributes', NULL, 7, 1, 0, 3,NULL);
 
-INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (9, 'AttributeGroupOne', 'dedupeAttributes', 0, 9, 1, 1, 1,NULL);
-INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (10, 'AttributeGroupTwo', 'nonDedupeAttributes', 0, 9, 1, 0, 3,NULL);
+INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (9, 'AttributeGroupOne', 'dedupeAttributes', NULL, 9, 1, 1, 1,NULL);
+INSERT INTO SCARAB_ATTRIBUTE_GROUP VALUES (10, 'AttributeGroupTwo', 'nonDedupeAttributes', NULL, 9, 1, 0, 3,NULL);
  
 -- Insert mapping between attributes and groups 
 -- group_id, attribute_id, preferred order
@@ -1065,4 +1065,266 @@
 INSERT INTO SCARAB_R_MODULE_OPTION VALUES (0,9,90,NULL,1,3,3);
 INSERT INTO SCARAB_R_MODULE_OPTION VALUES (0,10,90,NULL,1,3,3);
 
-
+-- issue type options for defect
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,1,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,2,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,3,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,4,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,5,1,0,5,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,6,1,0,6,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,7,1,0,7,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,8,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,9,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,10,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,11,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,12,1,0,5,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,13,1,0,6,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,14,1,0,7,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,15,1,0,8,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,16,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,17,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,18,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,19,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,20,1,0,5,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,21,1,0,6,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,22,1,0,7,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,23,1,0,8,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,24,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,25,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,26,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,27,1,0,5,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,28,1,0,6,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,29,1,0,7,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,30,1,0,8,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,31,1,0,10,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,32,1,0,11,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,33,1,0,12,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,34,1,0,13,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,35,1,0,14,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,36,1,0,15,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,37,1,0,16,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,38,1,0,23,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,39,1,0,29,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,40,1,0,20,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,41,1,0,21,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,42,1,0,22,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,43,1,0,30,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,44,1,0,31,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,45,1,0,32,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,46,1,0,33,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,47,1,0,41,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,48,1,0,38,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,49,1,0,39,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,50,1,0,34,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,51,1,0,35,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,52,1,0,36,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,53,1,0,37,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,54,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,55,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,56,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,57,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,58,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,59,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,60,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,61,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,62,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,63,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,64,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,65,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,66,1,0,5,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,67,1,0,6,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,68,1,0,7,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,69,1,0,8,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,70,1,0,9,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,71,1,0,10,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,75,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,76,1,0,9,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,77,1,0,17,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,78,1,0,24,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,79,1,0,25,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,80,1,0,26,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,81,1,0,27,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,82,1,0,19,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,83,1,0,28,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,84,1,0,40,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,85,1,0,42,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,86,1,0,43,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,87,1,0,18,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,88,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,89,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (1,90,1,0,3,-1);
+
+-- issue type options for patch
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,1,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,2,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,3,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,4,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,5,1,0,5,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,6,1,0,6,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,7,1,0,7,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,8,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,9,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,10,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,11,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,12,1,0,5,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,13,1,0,6,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,14,1,0,7,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,15,1,0,8,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,16,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,17,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,18,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,19,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,20,1,0,5,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,21,1,0,6,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,22,1,0,7,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,23,1,0,8,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,24,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,25,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,26,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,27,1,0,5,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,28,1,0,6,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,29,1,0,7,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,30,1,0,8,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,31,1,0,10,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,32,1,0,11,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,33,1,0,12,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,34,1,0,13,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,35,1,0,14,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,36,1,0,15,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,37,1,0,16,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,38,1,0,23,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,39,1,0,29,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,40,1,0,20,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,41,1,0,21,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,42,1,0,22,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,43,1,0,30,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,44,1,0,31,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,45,1,0,32,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,46,1,0,33,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,47,1,0,41,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,48,1,0,38,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,49,1,0,39,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,50,1,0,34,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,51,1,0,35,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,52,1,0,36,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,53,1,0,37,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,54,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,55,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,56,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,57,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,58,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,59,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,60,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,61,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,75,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,76,1,0,9,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,77,1,0,17,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,78,1,0,24,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,79,1,0,25,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,80,1,0,26,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,81,1,0,27,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,82,1,0,19,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,83,1,0,28,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,84,1,0,40,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,85,1,0,42,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,86,1,0,43,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,87,1,0,18,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,88,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,89,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (3,90,1,0,3,-1);
+
+-- issue type options for task
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,1,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,2,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,3,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,4,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,5,1,0,5,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,6,1,0,6,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,7,1,0,7,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,8,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,9,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,10,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,11,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,12,1,0,5,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,13,1,0,6,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,14,1,0,7,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,15,1,0,8,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,54,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,55,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,56,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,57,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,58,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,59,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,60,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,61,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,88,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,89,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (5,90,1,0,3,-1);
+
+-- issue type options for feature
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,1,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,2,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,3,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,4,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,5,1,0,5,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,6,1,0,6,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,7,1,0,7,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,8,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,9,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,10,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,11,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,12,1,0,5,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,13,1,0,6,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,14,1,0,7,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,15,1,0,8,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,54,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,55,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,56,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,57,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,58,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,59,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,60,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,61,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,88,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,89,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (7,90,1,0,3,-1);
+
+--issue type options for enhancement
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,1,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,2,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,3,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,4,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,5,1,0,5,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,6,1,0,6,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,7,1,0,7,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,8,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,9,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,10,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,11,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,12,1,0,5,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,13,1,0,6,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,14,1,0,7,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,15,1,0,8,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,54,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,55,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,56,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,57,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,58,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,59,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,60,1,0,3,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,61,1,0,4,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,88,1,0,1,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,89,1,0,2,-1);
+INSERT INTO SCARAB_R_ISSUETYPE_OPTION VALUES (9,90,1,0,3,-1);
+
+-- user attributes for issue types
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (2,1,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (13,1,1,0,1,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (2,3,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (13,3,1,0,1,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (2,5,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (13,5,1,0,1,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (2,7,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (13,7,1,0,1,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (2,9,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (13,9,1,0,1,0,0,0);

------------------------------------------------------
http://scarab.tigris.org/ds/viewMessage.do?dsForumId=3577&dsMessageId=2452121