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

Author: jhoech
Date: 2010-02-25 08:48:24-0800
New Revision: 10927

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

Log:
FIX - Adding an issue type to a new module is possible again. 
  ADD - Global mappings for issue types and general attributes 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=10927&r1=10926&r2=10927
==============================================================================
--- branches/release/0.22/src/sql/scarab-default-data.sql	(original)
+++ branches/release/0.22/src/sql/scarab-default-data.sql	2010-02-25 08:48:24-0800
@@ -1328,3 +1328,53 @@
 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);
+
+--issue type attributes for defect
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (1,1,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (3,1,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (4,1,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (5,1,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (6,1,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (7,1,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (8,1,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (9,1,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (11,1,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (12,1,1,0,2,0,0,0);
+
+--issue type attributes for patch
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (1,3,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (3,3,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (4,3,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (5,3,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (6,3,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (7,3,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (8,3,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (11,3,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (12,3,1,0,2,0,0,0);
+
+--issue type attributes for task
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (1,5,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (3,5,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (4,5,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (7,5,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (8,5,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (11,5,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (12,5,1,0,2,0,0,0);
+
+--issue type attributes for feature
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (1,7,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (3,7,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (4,7,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (7,7,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (8,7,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (11,7,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (12,7,1,0,2,0,0,0);
+
+--issue type attributes for enhancement
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (1,9,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (3,9,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (4,9,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (7,9,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (8,9,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (11,9,1,0,2,0,0,0);
+INSERT INTO SCARAB_R_ISSUETYPE_ATTRIBUTE VALUES (12,9,1,0,2,0,0,0);

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