SHARE
TWEET

6-createCalmSchema

a guest Nov 18th, 2013 376 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. USE [RIDW]
  2. GO
  3.  
  4. CREATE SCHEMA [RICALM] AUTHORIZATION [db_owner]
  5. GO
  6.  
  7. USE [RIDW]
  8. GO
  9.  
  10. CREATE SCHEMA AUTHORIZATION RICALM
  11. GO
  12.  
  13. CREATE TABLE RICALM.REQUEST_COMPONENT_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_COMPONENT_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  14. GO
  15.  
  16. CREATE TABLE RICALM.REQUEST_CATEGORY_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_REQUEST_CATEGORY_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  17. GO
  18.  
  19. CREATE TABLE RICALM.REQUEST_RESOURCE_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_RESOURCE_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  20. GO
  21.  
  22. CREATE TABLE RICALM.REQUEST_RELEASE_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_RELEASE_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  23. GO
  24.  
  25. CREATE TABLE RICALM.REQUEST_ITERATION_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_ITERATION_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  26. GO
  27.  
  28. CREATE TABLE RICALM.REQUEST_PROJECT_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_PROJECT_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  29. GO
  30.  
  31. CREATE TABLE RICALM.REQUEST_TEAM_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_TEAM_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  32. GO
  33.  
  34. CREATE TABLE RICALM.REQUEST_TIMELINE_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_TIMELINE_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  35. GO
  36.  
  37. CREATE TABLE RICALM.REQUEST_REQUEST_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_REQUEST_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  38. GO
  39.  
  40. CREATE TABLE RICALM.REQUEST_HISTORY_COMPONENT_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_COMPONENT_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  41. GO
  42.  
  43. CREATE TABLE RICALM.REQUEST_HISTORY_CATEGORY_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_REQUEST_CATEGORY_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  44. GO
  45.  
  46. CREATE TABLE RICALM.REQUEST_HISTORY_RESOURCE_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_RESOURCE_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  47. GO
  48.  
  49. CREATE TABLE RICALM.REQUEST_HISTORY_RELEASE_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_RELEASE_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  50. GO
  51.  
  52. CREATE TABLE RICALM.REQUEST_HISTORY_ITERATION_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_ITERATION_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  53. GO
  54.  
  55. CREATE TABLE RICALM.REQUEST_HISTORY_PROJECT_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_PROJECT_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  56. GO
  57.  
  58. CREATE TABLE RICALM.REQUEST_HISTORY_TEAM_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_TEAM_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  59. GO
  60.  
  61. CREATE TABLE RICALM.REQUEST_HISTORY_TIMELINE_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_TIMELINE_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  62. GO
  63.  
  64. CREATE TABLE RICALM.REQUEST_HISTORY_REQUEST_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL_REQUEST_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  65. GO
  66.  
  67. CREATE TABLE RICALM.REQUEST_APPROVAL_TYPE ( REQUEST_APPROVAL_TYPE_ID INT NOT NULL, NAME NVARCHAR(255) DEFAULT 'Approval Type Name Missing' NOT NULL, REFERENCE_ID NVARCHAR(50), EXTERNAL_ID NVARCHAR(100), PROJECT_ID INT DEFAULT -1 NOT NULL, URL NVARCHAR(2048), EXTERNAL_KEY1 INT DEFAULT -1 NOT NULL, EXTERNAL_KEY2 NCHAR(40) DEFAULT '-1' NOT NULL, SOURCE_ID NVARCHAR (36) DEFAULT '-1' NOT NULL, REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  68. GO
  69.  
  70. CREATE TABLE RICALM.REQUEST_APPROVAL_STATE ( REQUEST_APPROVAL_STATE_ID INT NOT NULL, NAME NVARCHAR(255) DEFAULT 'Approval State Name Missing' NOT NULL, REFERENCE_ID NVARCHAR(50), EXTERNAL_ID NVARCHAR(100), PROJECT_ID INT DEFAULT -1 NOT NULL, URL NVARCHAR(2048), EXTERNAL_KEY1 INT DEFAULT -1 NOT NULL, EXTERNAL_KEY2 NCHAR(40) DEFAULT '-1' NOT NULL, SOURCE_ID NVARCHAR (36) DEFAULT '-1' NOT NULL, REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  71. GO
  72.  
  73. CREATE TABLE RICALM.REQUEST_APPROVAL_DESCRIPTOR ( REQUEST_APPROVAL_DESCRIPTOR_ID INT NOT NULL, REQUEST_ID INT DEFAULT -1 NOT NULL, REQUEST_APPROVAL_TYPE_ID INT DEFAULT -1 NOT NULL, CUMULATIVE_STATE_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255), DUE_DATE DATETIME, CUMULATIVE_STATE_DATE DATETIME, EXTERNAL_KEY1 INT DEFAULT -1 NOT NULL, EXTERNAL_KEY2 NCHAR(40) DEFAULT '-1' NOT NULL, SOURCE_ID NVARCHAR (36) DEFAULT '-1' NOT NULL, URL NVARCHAR(2048), REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  74. GO
  75.  
  76. CREATE TABLE RICALM.REQUEST_APPROVAL ( REQUEST_APPROVAL_ID INT NOT NULL, REQUEST_APPROVAL_DESCRIPTOR_ID INTEGER DEFAULT -1 NOT NULL, REQUEST_APPROVAL_STATE_ID INT DEFAULT -1 NOT NULL, APPROVER_ID INT DEFAULT -1 NOT NULL, STATE_DATE DATETIME, EXTERNAL_KEY1 INT DEFAULT -1 NOT NULL, EXTERNAL_KEY2 NCHAR(40) DEFAULT '-1' NOT NULL, SOURCE_ID NVARCHAR (36) DEFAULT '-1' NOT NULL, URL NVARCHAR(2048), REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  77. GO
  78.  
  79. CREATE TABLE RICALM.TIMESHEET_ENTRY ( TIMESHEET_ENTRY_ID INT NOT NULL, TIMESHEET_ID INT DEFAULT -1 NOT NULL, ACTIVITY_ID INT DEFAULT -1 NOT NULL, TIMESHEET_REPORTING_WEEK DATETIME, REFERENCE_ID NVARCHAR(50), WORK_DATE DATETIME, DAY_NAME NVARCHAR(60) NOT NULL, WORK_TIME INT DEFAULT 0, EXTERNAL_ID NVARCHAR(100), EXTERNAL_KEY1 INT DEFAULT -1 NOT NULL, EXTERNAL_KEY2 NCHAR(40) DEFAULT '-1' NOT NULL, EXTERNAL_KEY3 NCHAR(40) DEFAULT '-1' NOT NULL, SOURCE_ID NVARCHAR (36) DEFAULT '-1' NOT NULL, URL NVARCHAR(2048), REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  80. GO
  81.  
  82. CREATE TABLE RICALM.TEAM_CAPACITY ( TEAM_CAPACITY_ID INT NOT NULL, TEAM_ID INT NOT NULL, PROJECT_ID INT NOT NULL, TIMELINE_ID INT NOT NULL, CAPACITY BIGINT, REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL, SOURCE_ID NVARCHAR (36) DEFAULT '-1' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  83. GO
  84.  
  85. CREATE TABLE RICALM.GROUP_NAME_FACET ( GROUP_NAME_FACET_ID INT NOT NULL, GROUP_NAME NVARCHAR(255) DEFAULT 'Group Missing' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Name Missing' NOT NULL, FACET NVARCHAR(255) DEFAULT 'Facet Missing' NOT NULL ) ON VNF_32K
  86. GO
  87.  
  88. CREATE TABLE RICALM.SCALAR_COUNTER ( SCALAR_COUNTER_ID INT NOT NULL, REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL, GROUP_NAME_FACET_ID INT DEFAULT -1 NOT NULL, VAL BIGINT, MIN_VALUE BIGINT, MAX_VALUE BIGINT, SOURCE_ID NVARCHAR (36) DEFAULT '-1' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  89. GO
  90.  
  91. CREATE TABLE RICALM.RANGE_COUNTER ( RANGE_COUNTER_ID INT NOT NULL, REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL, GROUP_NAME_FACET_ID INT DEFAULT -1 NOT NULL, COUNT_VALUE BIGINT, TOTAL_VALUE DECIMAL(20, 2), MIN_VALUE DECIMAL(20, 2), MAX_VALUE DECIMAL(20, 2), AVERAGE_VALUE DECIMAL(20, 2), STD_DEV_VALUE DECIMAL(20, 2), SOURCE_ID NVARCHAR (36) DEFAULT '-1' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  92. GO
  93.  
  94. CREATE TABLE RICALM.INTEGRAL_RANGE_COUNTER ( INTEGRAL_RANGE_COUNTER_ID INT NOT NULL, REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL, GROUP_NAME_FACET_ID INT DEFAULT -1 NOT NULL, COUNT_VALUE BIGINT, TOTAL_VALUE BIGINT, MIN_VALUE BIGINT, MAX_VALUE BIGINT, AVERAGE_VALUE BIGINT, STD_DEV_VALUE BIGINT, SOURCE_ID NVARCHAR (36) DEFAULT '-1' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  95. GO
  96.  
  97. CREATE TABLE RICALM.ITEM_TYPE_STORAGE ( ITEM_TYPE_STORAGE_ID INT NOT NULL, REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL, NAMESPACE NVARCHAR(255) DEFAULT 'Item Type Namespace Missing' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Item Type Name Missing' NOT NULL, NUM_STATES BIGINT, NUM_ITEMS BIGINT, SIZE_VAL BIGINT, CONTENT_SIZE BIGINT, ORM_SIZE BIGINT, PERSISTED_CONTENT_SIZE BIGINT, SOURCE_ID NVARCHAR (36) DEFAULT '-1' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  98. GO
  99.  
  100. CREATE TABLE RICALM.REQUEST_HISTORY ( REQUEST_HISTORY_ID INT NOT NULL, REQUEST_CLASS_ID INT DEFAULT -1 NOT NULL, REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Request Name Missing' NOT NULL, REFERENCE_ID NVARCHAR(50), EXTERNAL_ID NVARCHAR(100), PROJECT_ID INT DEFAULT -1 NOT NULL, COMPONENT_ID INT DEFAULT -1 NOT NULL, BUILD_ID INT DEFAULT -1 NOT NULL, PROJECT_CATEGORY_ID INT DEFAULT -1 NOT NULL, PHASE_ID INT DEFAULT -1 NOT NULL, REQUEST_SEVERITY_ID INT DEFAULT -1 NOT NULL, REQUEST_STATE_ID INT DEFAULT -1 NOT NULL, REQUEST_PRIORITY_ID INT DEFAULT -1 NOT NULL, PLATFORM NVARCHAR(255), ITERATION_ID INT DEFAULT -1 NOT NULL, RELEASE_ID INT DEFAULT -1 NOT NULL, FIXEDINRELEASE_ID INT DEFAULT -1 NOT NULL, SLOC_CHANGE INT DEFAULT 0, OWNER_ID INT DEFAULT -1 NOT NULL, REQUEST_CATEGORY_ID INT DEFAULT -1 NOT NULL, TEAM_ID INT DEFAULT -1 NOT NULL, RESOLVER_ID INT DEFAULT -1 NOT NULL, IS_BLOCKING INT DEFAULT 0 NOT NULL, REQUEST_SOURCE NVARCHAR(255), CREATION_DATE DATETIME, CLOSED_DATE DATETIME, SUBMIT_DATE
  101. DATETIME, RESOLVED_DATE DATETIME, ASSIGNED_DATE DATETIME, DUPLICATE_DATE DATETIME, ACTIVATE_DATE DATETIME, DUE_DATE DATETIME, CREATOR_ID INT DEFAULT -1 NOT NULL, MODIFIER_ID INT DEFAULT -1 NOT NULL, REQUEST_STATUS_ID INT DEFAULT -1 NOT NULL, CUSTOMER_PRIORITY NVARCHAR(255), REQUEST_RESOLUTION_ID INT DEFAULT -1 NOT NULL, REQUEST_TYPE_ID INT DEFAULT -1 NOT NULL, PLANNED_WORK INT , ACTUAL_WORK INT , COMMENT_COUNT INT , SUBSCRIBER_COUNT INT , STORY_POINTS INT , TAGS NVARCHAR (255), SUMMARY NVARCHAR (1000), URL NVARCHAR(2048), EXTERNAL_KEY1 INT DEFAULT -1 NOT NULL, EXTERNAL_KEY2 NCHAR(40) DEFAULT '-1' NOT NULL, SOURCE_ID NVARCHAR (36) DEFAULT '-1' NOT NULL, REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL, REC_DATE DATETIME DEFAULT GETDATE() NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, PREV_REQUEST_HISTORY_ID INT DEFAULT -1 ) ON VNF_32K
  102. GO
  103.  
  104. CREATE TABLE RICALM.REQUEST_BASELINE ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL ) ON VNF_32K
  105. GO
  106.  
  107. CREATE TABLE RICALM.REQUEST_INT_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL INT ) ON VNF_32K
  108. GO
  109.  
  110. CREATE TABLE RICALM.REQUEST_LONG_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL BIGINT ) ON VNF_32K
  111. GO
  112.  
  113. CREATE TABLE RICALM.REQUEST_BOOL_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL SMALLINT ) ON VNF_32K
  114. GO
  115.  
  116. CREATE TABLE RICALM.REQUEST_STRING_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL NVARCHAR(255), NUM_VAL DOUBLE PRECISION ) ON VNF_32K
  117. GO
  118.  
  119. CREATE TABLE RICALM.REQUEST_STRING_M_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL NVARCHAR(1023), NUM_VAL DOUBLE PRECISION ) ON VNF_32K
  120. GO
  121.  
  122. CREATE TABLE RICALM.REQUEST_STRING_L_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL NVARCHAR(4000), NUM_VAL DOUBLE PRECISION ) ON VNF_32K
  123. GO
  124.  
  125. CREATE TABLE RICALM.REQUEST_TIMESTAMP_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL DATETIME ) ON VNF_32K
  126. GO
  127.  
  128. CREATE TABLE RICALM.REQUEST_DECIMAL_EXT ( REQUEST_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL DECIMAL(18,2) ) ON VNF_32K
  129. GO
  130.  
  131. CREATE TABLE RICALM.REQUEST_HISTORY_INT_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL INT ) ON VNF_32K
  132. GO
  133.  
  134. CREATE TABLE RICALM.REQUEST_HISTORY_LONG_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL BIGINT ) ON VNF_32K
  135. GO
  136.  
  137. CREATE TABLE RICALM.REQUEST_HISTORY_BOOL_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL SMALLINT ) ON VNF_32K
  138. GO
  139.  
  140. CREATE TABLE RICALM.REQUEST_HISTORY_STRING_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL NVARCHAR(255), NUM_VAL DOUBLE PRECISION ) ON VNF_32K
  141. GO
  142.  
  143. CREATE TABLE RICALM.REQUEST_HISTORY_STRING_M_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL NVARCHAR(1023), NUM_VAL DOUBLE PRECISION ) ON VNF_32K
  144. GO
  145.  
  146. CREATE TABLE RICALM.REQUEST_HISTORY_STRING_L_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL NVARCHAR(4000), NUM_VAL DOUBLE PRECISION ) ON VNF_32K
  147. GO
  148.  
  149. CREATE TABLE RICALM.REQUEST_HISTORY_TIMESTAMP_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL DATETIME ) ON VNF_32K
  150. GO
  151.  
  152. CREATE TABLE RICALM.REQUEST_HISTORY_DECIMAL_EXT ( REQUEST_HISTORY_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL DECIMAL(18,2) ) ON VNF_32K
  153. GO
  154.  
  155. CREATE TABLE RICALM.REQUEST_ENUMERATION ( REQUEST_ENUMERATION_ID INT NOT NULL, ENUMERATION_NAME NVARCHAR(255) DEFAULT 'Request Enumeration Name Missing' NOT NULL, LITERAL_NAME NVARCHAR(255) DEFAULT 'Request Enumeration Literal Name Missing' NOT NULL, REFERENCE_ID NVARCHAR(50), EXTERNAL_ID NVARCHAR(100), PROJECT_ID INT DEFAULT -1 NOT NULL, URL NVARCHAR(2048), EXTERNAL_KEY1 INT DEFAULT -1 NOT NULL, EXTERNAL_KEY2 NCHAR(40) DEFAULT '-1' NOT NULL, SOURCE_ID NVARCHAR (36) DEFAULT '-1' NOT NULL, REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  156. GO
  157.  
  158. CREATE TABLE RICALM.RQRMENT_HISTORY ( REQUIREMENT_HISTORY_ID INT NOT NULL, REQUIREMENT_ID INT NOT NULL, REQUIREMENT_CLASS_ID INT DEFAULT -1 NOT NULL, NAME NVARCHAR(255) DEFAULT 'Requirement Name Missing' NOT NULL, REFERENCE_ID NVARCHAR(50), EXTERNAL_ID NVARCHAR(100), PROJECT_ID INT DEFAULT -1 NOT NULL, PLANNED_ITERATION_ID INT DEFAULT -1 NOT NULL, ACTUAL_ITERATION_ID INT DEFAULT -1 NOT NULL, RELEASE_ID INT DEFAULT -1 NOT NULL, STATUS NVARCHAR(255), REQUIREMENT_TYPE NVARCHAR(255), REQUIREMENT_STATE NVARCHAR(255), OWNER_ID INT DEFAULT -1 NOT NULL, DIFFICULTY NVARCHAR(255), STABILITY NVARCHAR(255), COMPONENT_ID INT DEFAULT -1 NOT NULL, CREATION_DATE DATETIME, PRIORITY NVARCHAR(255), CUSTOMER_PRIORITY NVARCHAR(255), PLATFORM NVARCHAR(255), REVISION_NUMBER NVARCHAR(50), REVISION_DATE DATETIME DEFAULT GETDATE() NOT NULL, URL NVARCHAR(2048), EXTERNAL_KEY1 INT DEFAULT -1 NOT NULL, EXTERNAL_KEY2 NCHAR(40) DEFAULT '-1' NOT NULL, SOURCE_ID NVARCHAR (36) DEFAULT '-1' NOT NULL, REC_DATETIME DATETIME DEFAULT GETDATE()
  159. NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, PREV_REQUIREMENT_HISTORY_ID INT DEFAULT -1 ) ON VNF_32K
  160. GO
  161.  
  162. CREATE TABLE RICALM.RQRMENT_TYPE ( REQUIREMENT_TYPE_ID INT NOT NULL, IDENTIFIER NVARCHAR(255) NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, PROJECT_ID INT DEFAULT -1 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  163. GO
  164.  
  165. CREATE TABLE RICALM.RQRMENT_ATTRDEF ( REQUIREMENT_ATTRDEF_ID INT NOT NULL, REQUIREMENT_TYPE_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) NOT NULL, NAME NVARCHAR(255) DEFAULT 'Extension Name Missing' NOT NULL, DATATYPE NVARCHAR(255), IS_ENUMERATION SMALLINT DEFAULT 0 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  166. GO
  167.  
  168. CREATE TABLE RICALM.RQRMENT_TYPE_ATTRDEF ( REQUIREMENT_ATTRDEF_ID INT NOT NULL, REQUIREMENT_TYPE_ID INT DEFAULT -1 NOT NULL ) ON VNF_32K
  169. GO
  170.  
  171. CREATE TABLE RICALM.RQRMENT_STRING_EXT ( REQUIREMENT_ID INT DEFAULT -1 NOT NULL, REQUIREMENT_ATTRDEF_ID INT DEFAULT -1 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL NVARCHAR(255) ) ON VNF_32K
  172. GO
  173.  
  174. CREATE TABLE RICALM.RQRMENT_STRING_L_EXT ( REQUIREMENT_ID INT DEFAULT -1 NOT NULL, REQUIREMENT_ATTRDEF_ID INT DEFAULT -1 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL NVARCHAR(4000) ) ON VNF_32K
  175. GO
  176.  
  177. CREATE TABLE RICALM.RQRMENT_INT_EXT ( REQUIREMENT_ID INT DEFAULT -1 NOT NULL, REQUIREMENT_ATTRDEF_ID INT DEFAULT -1 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL INT ) ON VNF_32K
  178. GO
  179.  
  180. CREATE TABLE RICALM.RQRMENT_DECIMAL_EXT ( REQUIREMENT_ID INT DEFAULT -1 NOT NULL, REQUIREMENT_ATTRDEF_ID INT DEFAULT -1 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL DECIMAL(18,2) ) ON VNF_32K
  181. GO
  182.  
  183. CREATE TABLE RICALM.RQRMENT_BOOL_EXT ( REQUIREMENT_ID INT DEFAULT -1 NOT NULL, REQUIREMENT_ATTRDEF_ID INT DEFAULT -1 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL SMALLINT ) ON VNF_32K
  184. GO
  185.  
  186. CREATE TABLE RICALM.RQRMENT_TIMESTAMP_EXT ( REQUIREMENT_ID INT DEFAULT -1 NOT NULL, REQUIREMENT_ATTRDEF_ID INT DEFAULT -1 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL DATETIME ) ON VNF_32K
  187. GO
  188.  
  189. CREATE TABLE RICALM.RQRMENT_DATE_EXT ( REQUIREMENT_ID INT DEFAULT -1 NOT NULL, REQUIREMENT_ATTRDEF_ID INT DEFAULT -1 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL DATE ) ON VNF_32K
  190. GO
  191.  
  192. CREATE TABLE RICALM.RQRMENT_ENUMERATION ( REQUIREMENT_ENUMERATION_ID INT NOT NULL, REQUIREMENT_ATTRDEF_ID INT DEFAULT -1 NOT NULL, LITERAL_NAME NVARCHAR(255) DEFAULT ' Requirement Enumeration Literal Name Missing' NOT NULL, REQUIREMENT_ID INT DEFAULT -1 NOT NULL, EXTERNAL_ID NVARCHAR(255), PROJECT_ID INT DEFAULT -1 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  193. GO
  194.  
  195. CREATE TABLE RICALM.RQRMENT_HISTORY_INT_EXT ( REQUIREMENT_HISTORY_ID INT DEFAULT -1 NOT NULL, REQUIREMENT_ATTRDEF_ID INT DEFAULT -1 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL INT ) ON VNF_32K
  196. GO
  197.  
  198. CREATE TABLE RICALM.RQRMENT_HISTORY_BOOL_EXT ( REQUIREMENT_HISTORY_ID INT DEFAULT -1 NOT NULL, REQUIREMENT_ATTRDEF_ID INT DEFAULT -1 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL SMALLINT ) ON VNF_32K
  199. GO
  200.  
  201. CREATE TABLE RICALM.RQRMENT_HISTORY_STRING_EXT ( REQUIREMENT_HISTORY_ID INT DEFAULT -1 NOT NULL, REQUIREMENT_ATTRDEF_ID INT DEFAULT -1 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL NVARCHAR(255) ) ON VNF_32K
  202. GO
  203.  
  204. CREATE TABLE RICALM.RQRMENT_HISTORY_TIMESTAMP_EXT ( REQUIREMENT_HISTORY_ID INT DEFAULT -1 NOT NULL, REQUIREMENT_ATTRDEF_ID INT DEFAULT -1 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL DATETIME ) ON VNF_32K
  205. GO
  206.  
  207. CREATE TABLE RICALM.RQRMENT_HISTORY_STRING_L_EXT ( REQUIREMENT_HISTORY_ID INT DEFAULT -1 NOT NULL, REQUIREMENT_ATTRDEF_ID INT DEFAULT -1 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL NVARCHAR(4000) ) ON VNF_32K
  208. GO
  209.  
  210. CREATE TABLE RICALM.RQRMENT_HISTORY_DECIMAL_EXT ( REQUIREMENT_HISTORY_ID INT DEFAULT -1 NOT NULL, REQUIREMENT_ATTRDEF_ID INT DEFAULT -1 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL, VAL DECIMAL(18,2) ) ON VNF_32K
  211. GO
  212.  
  213. CREATE TABLE RICALM.REQUIREMENT_EXTERNAL_LINK ( EXTERNAL_ID NVARCHAR(100), PRED_REQUIREMENT_ID INT DEFAULT -1 NOT NULL, LINK_TYPE_ID INT DEFAULT -1 NOT NULL, EXTERNAL_LABEL NVARCHAR(255), EXTERNAL_URL NVARCHAR(2048) ) ON VNF_32K
  214. GO
  215.  
  216. CREATE TABLE RICALM.KEYWORD ( KEYWORD_ID INT NOT NULL, KEYWORD_CLASS_ID INT DEFAULT -1 NOT NULL, TITLE NVARCHAR(255) DEFAULT 'KeyWord Title Missing' NOT NULL, TAG NVARCHAR(255), DEFAULT_SCRIPT_ID INT DEFAULT -1 NOT NULL, URL NVARCHAR(2048), REFERENCE_ID NVARCHAR(50), EXTERNAL_ID NVARCHAR(100), PROJECT_ID INT DEFAULT -1 NOT NULL, EXTERNAL_KEY1 INT DEFAULT -1 NOT NULL, EXTERNAL_KEY2 NCHAR(40) DEFAULT '-1' NOT NULL, SOURCE_ID NVARCHAR (36) DEFAULT '-1' NOT NULL, LAST_UPDATED DATETIME, REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  217. GO
  218.  
  219. CREATE TABLE RICALM.KEYWORD_CLASSIFICATION ( KEYWORD_CLASS_ID INT NOT NULL, NAME NVARCHAR(50) DEFAULT 'KeyWord Class Name Missing' NOT NULL, REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL ) ON VNF_32K
  220. GO
  221.  
  222. CREATE TABLE RICALM.KEYWORD_SCRIPT_LOOKUP ( KEYWORD_ID INT NOT NULL, TESTSCRIPT_ID INT NOT NULL ) ON VNF_32K
  223. GO
  224.  
  225. CREATE TABLE RICALM.QUALITY_OBJECTIVE ( OBJECTIVE_ID INT NOT NULL, OBJECTIVE_CLASS_ID INT DEFAULT -1 NOT NULL, TITLE NVARCHAR(255) DEFAULT 'Quaility Objective Title Missing' NOT NULL, DESCRIPTION NVARCHAR(255), CREATOR_ID INT DEFAULT -1 NOT NULL, OPERATOR NVARCHAR(20), TARGET_VALUE INT DEFAULT 0 NOT NULL, EVALUATOR_ID NVARCHAR(255), URL NVARCHAR(2048), REFERENCE_ID NVARCHAR(50), EXTERNAL_ID NVARCHAR(100), PROJECT_ID INT DEFAULT -1 NOT NULL, EXTERNAL_KEY1 INT DEFAULT -1 NOT NULL, EXTERNAL_KEY2 NCHAR(40) DEFAULT '-1' NOT NULL, SOURCE_ID NVARCHAR (36) DEFAULT '-1' NOT NULL, LAST_UPDATED DATETIME, REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  226. GO
  227.  
  228. CREATE TABLE RICALM.OBJECTIVE_CLASSIFICATION ( OBJECTIVE_CLASS_ID INT NOT NULL, NAME NVARCHAR(50) DEFAULT 'Quaility Objective Class Name Missing' NOT NULL, REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL ) ON VNF_32K
  229. GO
  230.  
  231. CREATE TABLE RICALM.TESTPLAN_OBJECTIVESTATUS ( TESTPLAN_OBJECTIVESTATUS_ID INT NOT NULL, TESTPLAN_ID INT DEFAULT -1 NOT NULL, OBJECTIVE_ID INT DEFAULT -1 NOT NULL, GROUP_ORDER INT DEFAULT -1 NOT NULL, ACTUAL_VALUE INT DEFAULT 0 NOT NULL, STATE NVARCHAR(255), COMMENT NVARCHAR(255), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  232. GO
  233.  
  234. CREATE TABLE RICALM.TESTPLAN_OBJECTIVE_LOOKUP ( TESTPLAN_ID INT NOT NULL, OBJECTIVE_ID INT NOT NULL ) ON VNF_32K
  235. GO
  236.  
  237. CREATE TABLE RICALM.LABREQUEST ( LABREQUEST_ID INT NOT NULL, LABREQUEST_CLASS_ID INT DEFAULT -1 NOT NULL, TITLE NVARCHAR(255) DEFAULT 'LabRequest Title Missing' NOT NULL, SUMMARY NVARCHAR(255), COMMENTS NVARCHAR(1024), CREATE_DATE DATETIME DEFAULT GETDATE() NOT NULL, CONFIRMATION_DATE DATETIME, REQUESTER_ID INT DEFAULT -1 NOT NULL, FULFILLER_ID INT DEFAULT -1 NOT NULL, PRIORITY NVARCHAR(255), CURRENT_STATE NVARCHAR(255), VISIBLE_ID INT DEFAULT -1 NOT NULL, CONFIGURATION NVARCHAR(2048), RESERVE_FROM DATETIME, RESERVE_TO DATETIME, URL NVARCHAR(2048), REFERENCE_ID NVARCHAR(50), EXTERNAL_ID NVARCHAR(100), PROJECT_ID INT DEFAULT -1 NOT NULL, EXTERNAL_KEY1 INT DEFAULT -1 NOT NULL, EXTERNAL_KEY2 NCHAR(40) DEFAULT '-1' NOT NULL, SOURCE_ID NVARCHAR (36) DEFAULT '-1' NOT NULL, LAST_UPDATED DATETIME, REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  238. GO
  239.  
  240. CREATE TABLE RICALM.LABREQUEST_CLASSIFICATION ( LABREQUEST_CLASS_ID INT NOT NULL, NAME NVARCHAR(50) DEFAULT 'LabRequest Class Name Missing' NOT NULL, REC_DATETIME DATETIME DEFAULT GETDATE() NOT NULL ) ON VNF_32K
  241. GO
  242.  
  243. CREATE TABLE RICALM.LABREQUEST_CHANGESTATE ( CHANGESTATE_ID INT NOT NULL, LABREQUEST_ID INT DEFAULT -1 NOT NULL, STATE_UUID NVARCHAR(255) DEFAULT '-1' NOT NULL, FROM_STATE NVARCHAR(255), TO_STATE NVARCHAR(255), FROM_TIME DATETIME, TO_TIME DATETIME, USER_ID INT DEFAULT -1 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  244. GO
  245.  
  246. CREATE TABLE RICALM.RESERVATION_LABREQUEST_LOOKUP ( RESERVATION_ID INT NOT NULL, LABREQUEST_ID INT NOT NULL ) ON VNF_32K
  247. GO
  248.  
  249. CREATE TABLE RICALM.TESTPLAN_STRING_EXT ( TESTPLAN_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR NVARCHAR(255), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  250. GO
  251.  
  252. CREATE TABLE RICALM.TESTPLAN_STRING_M_EXT ( TESTPLAN_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR NVARCHAR(1024), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  253. GO
  254.  
  255. CREATE TABLE RICALM.TESTPLAN_INT_EXT ( TESTPLAN_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR INT , ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  256. GO
  257.  
  258. CREATE TABLE RICALM.TESTPLAN_TIMESTAMP_EXT ( TESTPLAN_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR DATETIME, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  259. GO
  260.  
  261. CREATE TABLE RICALM.TESTCASE_STRING_EXT ( TESTCASE_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR NVARCHAR(255), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  262. GO
  263.  
  264. CREATE TABLE RICALM.TESTCASE_STRING_M_EXT ( TESTCASE_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR NVARCHAR(1024), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  265. GO
  266.  
  267. CREATE TABLE RICALM.TESTCASE_INT_EXT ( TESTCASE_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR INT , ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  268. GO
  269.  
  270. CREATE TABLE RICALM.TESTCASE_TIMESTAMP_EXT ( TESTCASE_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR DATETIME, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  271. GO
  272.  
  273. CREATE TABLE RICALM.TESTSCRIPT_STRING_EXT ( TESTSCRIPT_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR NVARCHAR(255), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  274. GO
  275.  
  276. CREATE TABLE RICALM.TESTSCRIPT_STRING_M_EXT ( TESTSCRIPT_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR NVARCHAR(1024), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  277. GO
  278.  
  279. CREATE TABLE RICALM.TESTSCRIPT_INT_EXT ( TESTSCRIPT_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR INT , ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  280. GO
  281.  
  282. CREATE TABLE RICALM.TESTSCRIPT_TIMESTAMP_EXT ( TESTSCRIPT_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR DATETIME, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  283. GO
  284.  
  285. CREATE TABLE RICALM.TESTSUITE_STRING_EXT ( TESTSUITE_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR NVARCHAR(255), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  286. GO
  287.  
  288. CREATE TABLE RICALM.TESTSUITE_STRING_M_EXT ( TESTSUITE_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR NVARCHAR(1024), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  289. GO
  290.  
  291. CREATE TABLE RICALM.TESTSUITE_INT_EXT ( TESTSUITE_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR INT , ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  292. GO
  293.  
  294. CREATE TABLE RICALM.TESTSUITE_TIMESTAMP_EXT ( TESTSUITE_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR DATETIME, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  295. GO
  296.  
  297. CREATE TABLE RICALM.EXECWORKITEM_STRING_EXT ( EXECWORKITEM_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR NVARCHAR(255), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  298. GO
  299.  
  300. CREATE TABLE RICALM.EXECWORKITEM_STRING_M_EXT ( EXECWORKITEM_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR NVARCHAR(1024), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  301. GO
  302.  
  303. CREATE TABLE RICALM.EXECWORKITEM_INT_EXT ( EXECWORKITEM_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR INT , ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  304. GO
  305.  
  306. CREATE TABLE RICALM.EXECWORKITEM_TIMESTAMP_EXT ( EXECWORKITEM_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR DATETIME, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  307. GO
  308.  
  309. CREATE TABLE RICALM.TSTSUITEXECREC_STRING_EXT ( TESTSUITE_EXECRECORD_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR NVARCHAR(255), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  310. GO
  311.  
  312. CREATE TABLE RICALM.TSTSUITEXECREC_STRING_M_EXT ( TESTSUITE_EXECRECORD_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR NVARCHAR(1024), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  313. GO
  314.  
  315. CREATE TABLE RICALM.TSTSUITEXECREC_INT_EXT ( TESTSUITE_EXECRECORD_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR INT , ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  316. GO
  317.  
  318. CREATE TABLE RICALM.TSTSUITEXECREC_TIMESTAMP_EXT ( TESTSUITE_EXECRECORD_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR DATETIME, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  319. GO
  320.  
  321. CREATE TABLE RICALM.EXECRES_STRING_EXT ( EXECUTION_RESULT_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR NVARCHAR(255), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  322. GO
  323.  
  324. CREATE TABLE RICALM.EXECRES_STRING_M_EXT ( EXECUTION_RESULT_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR NVARCHAR(1024), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  325. GO
  326.  
  327. CREATE TABLE RICALM.EXECRES_INT_EXT ( EXECUTION_RESULT_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR INT , ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  328. GO
  329.  
  330. CREATE TABLE RICALM.EXECRES_TIMESTAMP_EXT ( EXECUTION_RESULT_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR DATETIME, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  331. GO
  332.  
  333. CREATE TABLE RICALM.TESTSUITELOG_STRING_EXT ( TESTSUITELOG_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR NVARCHAR(255), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  334. GO
  335.  
  336. CREATE TABLE RICALM.TESTSUITELOG_STRING_M_EXT ( TESTSUITELOG_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR NVARCHAR(1024), ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  337. GO
  338.  
  339. CREATE TABLE RICALM.TESTSUITELOG_INT_EXT ( TESTSUITELOG_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR INT , ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  340. GO
  341.  
  342. CREATE TABLE RICALM.TESTSUITELOG_TIMESTAMP_EXT ( TESTSUITELOG_ID INT DEFAULT -1 NOT NULL, IDENTIFIER NVARCHAR(255) DEFAULT '-1' NOT NULL, NAME NVARCHAR(255) DEFAULT 'Custom Attribute Name Missing' NOT NULL, VAR DATETIME, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  343. GO
  344.  
  345. CREATE TABLE RICALM.ITERATION_EXEC_DETAIL ( ITER_EXEC_DETAIL_ID INT NOT NULL, ITERATION_ID INT DEFAULT -1 NOT NULL, COMMENT NVARCHAR(255), EXEC_DATE DATETIME DEFAULT GETDATE() NOT NULL, POINT_ATTEMPTED INT DEFAULT 0 NOT NULL, POINT_COMPLETED INT DEFAULT 0 NOT NULL, ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL ) ON VNF_32K
  346. GO
  347.  
  348. CREATE TABLE RICALM.TEMP_REQUIREMENT_STG ( ID INTEGER NOT NULL, NAME VARCHAR(255), EXTERNAL_ID VARCHAR(100), EXTERNAL_KEY1 VARCHAR(250), FORMAT VARCHAR(250), CREATORUUID VARCHAR(100), CREATION_DATE DATETIME, REC_DATETIME DATETIME, PROJECTUUID VARCHAR(100), URL VARCHAR(2048), REQUIREMENT_TYPE VARCHAR(255), DATATYPE VARCHAR(255), ISENUMERATION VARCHAR(250), REQUIREMENT_ATTRDEF_ID VARCHAR(255), LITERALID VARCHAR(255), LITERAL_NAME VARCHAR(255), ATTRNAME VARCHAR(255), VAL VARCHAR(255), VAL_TIME DATETIME, ATTRTYPENAME VARCHAR(255), REQUIREMENT_TYPE_ID VARCHAR(255), REQUIREMENTUUID VARCHAR(100), PROJECTAREAUUID VARCHAR(100), ISDELETED VARCHAR(250), ISMULTIVALUED VARCHAR(250), DATASOURCE_ID VARCHAR(36) ) ON VNF_32K
  349. GO
  350.  
  351. CREATE TABLE RICALM.TEMP_REQUIREMENT_LINK_STG ( ID INTEGER NOT NULL, EXTERNAL_ID VARCHAR(100), FORMAT VARCHAR(250), IMPLEMENTEDBY VARCHAR(100), IMPLEMENTEDBYURL VARCHAR(2048), VALIDATEDBY VARCHAR(100), EXTERNAL_UUID VARCHAR(100), EXTERNAL_URL VARCHAR(2048), EXTERNAL_LABEL VARCHAR(255), EXTERNALLINKTYPE VARCHAR(100), LINKRELATION VARCHAR(100), LINKRELATIONURL VARCHAR(2048), AFFECTEDBY VARCHAR(100), TRACKEDBY VARCHAR(100), LINKTITLE VARCHAR(255), LINKTYPEUUID VARCHAR(100), LINKTYPENAME VARCHAR(255), ISPARENTLINK VARCHAR(250), ISCHILDLINK VARCHAR(250), MODULEARTIFACTUUID VARCHAR(100), MODULEUUID VARCHAR(100), DATASOURCE_ID VARCHAR(36) ) ON VNF_32K
  352. GO
  353.  
  354. CREATE INDEX REQCMPEXT_IDX1 ON RICALM.REQUEST_COMPONENT_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  355. GO
  356.  
  357. CREATE INDEX REQCMPEXT_IDX2 ON RICALM.REQUEST_COMPONENT_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  358. GO
  359.  
  360. CREATE INDEX REQCTGEXT_IDX1 ON RICALM.REQUEST_CATEGORY_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  361. GO
  362.  
  363. CREATE INDEX REQCTGEXT_IDX2 ON RICALM.REQUEST_CATEGORY_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  364. GO
  365.  
  366. CREATE INDEX REQRSREXT_IDX1 ON RICALM.REQUEST_RESOURCE_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  367. GO
  368.  
  369. CREATE INDEX REQRSREXT_IDX2 ON RICALM.REQUEST_RESOURCE_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  370. GO
  371.  
  372. CREATE INDEX REQRLSEXT_IDX1 ON RICALM.REQUEST_RELEASE_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  373. GO
  374.  
  375. CREATE INDEX REQRLSEXT_IDX2 ON RICALM.REQUEST_RELEASE_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  376. GO
  377.  
  378. CREATE INDEX REQITEEXT_IDX1 ON RICALM.REQUEST_ITERATION_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  379. GO
  380.  
  381. CREATE INDEX REQITEEXT_IDX2 ON RICALM.REQUEST_ITERATION_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  382. GO
  383.  
  384. CREATE INDEX REQPRJEXT_IDX1 ON RICALM.REQUEST_PROJECT_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  385. GO
  386.  
  387. CREATE INDEX REQPRJEXT_IDX2 ON RICALM.REQUEST_PROJECT_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  388. GO
  389.  
  390. CREATE INDEX REQTMAEXT_IDX1 ON RICALM.REQUEST_TEAM_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  391. GO
  392.  
  393. CREATE INDEX REQTMAEXT_IDX2 ON RICALM.REQUEST_TEAM_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  394. GO
  395.  
  396. CREATE INDEX REQTLNEXT_IDX1 ON RICALM.REQUEST_TIMELINE_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  397. GO
  398.  
  399. CREATE INDEX REQTLNEXT_IDX2 ON RICALM.REQUEST_TIMELINE_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  400. GO
  401.  
  402. CREATE INDEX REQREQEXT_IDX1 ON RICALM.REQUEST_REQUEST_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  403. GO
  404.  
  405. CREATE INDEX REQREQEXT_IDX2 ON RICALM.REQUEST_REQUEST_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  406. GO
  407.  
  408. CREATE INDEX REQHISCMPEXT_IDX1 ON RICALM.REQUEST_HISTORY_COMPONENT_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  409. GO
  410.  
  411. CREATE INDEX REQHISCMPEXT_IDX2 ON RICALM.REQUEST_HISTORY_COMPONENT_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  412. GO
  413.  
  414. CREATE INDEX REQHISCTGEXT_IDX1 ON RICALM.REQUEST_HISTORY_CATEGORY_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  415. GO
  416.  
  417. CREATE INDEX REQHISCTGEXT_IDX2 ON RICALM.REQUEST_HISTORY_CATEGORY_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  418. GO
  419.  
  420. CREATE INDEX REQHISRSREXT_IDX1 ON RICALM.REQUEST_HISTORY_RESOURCE_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  421. GO
  422.  
  423. CREATE INDEX REQHISRSREXT_IDX2 ON RICALM.REQUEST_HISTORY_RESOURCE_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  424. GO
  425.  
  426. CREATE INDEX REQHISRLSEXT_IDX1 ON RICALM.REQUEST_HISTORY_RELEASE_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  427. GO
  428.  
  429. CREATE INDEX REQHISRLSEXT_IDX2 ON RICALM.REQUEST_HISTORY_RELEASE_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  430. GO
  431.  
  432. CREATE INDEX REQHISITEEXT_IDX1 ON RICALM.REQUEST_HISTORY_ITERATION_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  433. GO
  434.  
  435. CREATE INDEX REQHISITEEXT_IDX2 ON RICALM.REQUEST_HISTORY_ITERATION_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  436. GO
  437.  
  438. CREATE INDEX REQHISPRJEXT_IDX1 ON RICALM.REQUEST_HISTORY_PROJECT_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  439. GO
  440.  
  441. CREATE INDEX REQHISPRJEXT_IDX2 ON RICALM.REQUEST_HISTORY_PROJECT_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  442. GO
  443.  
  444. CREATE INDEX REQHISTMAEXT_IDX1 ON RICALM.REQUEST_HISTORY_TEAM_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  445. GO
  446.  
  447. CREATE INDEX REQHISTMAEXT_IDX2 ON RICALM.REQUEST_HISTORY_TEAM_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  448. GO
  449.  
  450. CREATE INDEX REQHISTLNEXT_IDX1 ON RICALM.REQUEST_HISTORY_TIMELINE_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  451. GO
  452.  
  453. CREATE INDEX REQHISTLNEXT_IDX2 ON RICALM.REQUEST_HISTORY_TIMELINE_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  454. GO
  455.  
  456. CREATE INDEX REQHISREQEXT_IDX1 ON RICALM.REQUEST_HISTORY_REQUEST_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  457. GO
  458.  
  459. CREATE INDEX REQHISREQEXT_IDX2 ON RICALM.REQUEST_HISTORY_REQUEST_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  460. GO
  461.  
  462. CREATE INDEX RQSAPDS_IDX1 ON RICALM.REQUEST_APPROVAL_DESCRIPTOR (EXTERNAL_KEY2 ASC) ON VNF_IDX
  463. GO
  464.  
  465. CREATE INDEX RQSAPPR_IDX1 ON RICALM.REQUEST_APPROVAL (EXTERNAL_KEY2 ASC) ON VNF_IDX
  466. GO
  467.  
  468. CREATE INDEX TMENTRY_IDX1 ON RICALM.TIMESHEET_ENTRY (EXTERNAL_KEY2 ASC) ON VNF_IDX
  469. GO
  470.  
  471. CREATE INDEX TMENTRY_IDX2 ON RICALM.TIMESHEET_ENTRY (EXTERNAL_KEY3 ASC) ON VNF_IDX
  472. GO
  473.  
  474. CREATE INDEX GRNMFC_IDX1 ON RICALM.GROUP_NAME_FACET (GROUP_NAME ASC, NAME ASC, FACET ASC) ON VNF_IDX
  475. GO
  476.  
  477. CREATE INDEX REQHIS_IDX3 ON RICALM.REQUEST_HISTORY (EXTERNAL_KEY2 ASC) ON VNF_IDX
  478. GO
  479.  
  480. CREATE INDEX REQHIS_IDX4 ON RICALM.REQUEST_HISTORY (EXTERNAL_KEY1 ASC, SOURCE_ID ASC) ON VNF_IDX
  481. GO
  482.  
  483. CREATE INDEX REQHIS_IDX5 ON RICALM.REQUEST_HISTORY (EXTERNAL_KEY2 ASC, SOURCE_ID ASC) ON VNF_IDX
  484. GO
  485.  
  486. CREATE INDEX REQHIS_IDX6 ON RICALM.REQUEST_HISTORY (ISSOFTDELETED ASC) ON VNF_IDX
  487. GO
  488.  
  489. CREATE INDEX REQHIS_IDX7 ON RICALM.REQUEST_HISTORY (REQUEST_CLASS_ID ASC, REQUEST_HISTORY_ID ASC, EXTERNAL_KEY1 ASC, SOURCE_ID ASC) ON VNF_IDX
  490. GO
  491.  
  492. CREATE INDEX REQHIS_IDX8 ON RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID ASC, EXTERNAL_KEY1 ASC, SOURCE_ID ASC) ON VNF_IDX
  493. GO
  494.  
  495. CREATE INDEX REQHIS_IDX9 ON RICALM.REQUEST_HISTORY (BUILD_ID ASC, REQUEST_HISTORY_ID ASC) ON VNF_IDX
  496. GO
  497.  
  498. CREATE INDEX REQHIS_IDX10 ON RICALM.REQUEST_HISTORY (REQUEST_CLASS_ID ASC, PROJECT_ID ASC, COMPONENT_ID ASC, OWNER_ID ASC, REQUEST_HISTORY_ID ASC, ITERATION_ID ASC) ON VNF_IDX
  499. GO
  500.  
  501. CREATE INDEX REQHIS_IDX11 ON RICALM.REQUEST_HISTORY (REQUEST_SOURCE ASC) ON VNF_IDX
  502. GO
  503.  
  504. CREATE INDEX REQHIS_IDX12 ON RICALM.REQUEST_HISTORY (REQUEST_TYPE_ID ASC) ON VNF_IDX
  505. GO
  506.  
  507. CREATE INDEX REQHIS_IDX13 ON RICALM.REQUEST_HISTORY (REQUEST_STATUS_ID ASC) ON VNF_IDX
  508. GO
  509.  
  510. CREATE INDEX REQHIS_IDX14 ON RICALM.REQUEST_HISTORY (COMPONENT_ID ASC, IS_BLOCKING ASC, REQUEST_HISTORY_ID ASC) ON VNF_IDX
  511. GO
  512.  
  513. CREATE INDEX REQHIS_IDX15 ON RICALM.REQUEST_HISTORY (REQUEST_CLASS_ID ASC, REQUEST_HISTORY_ID ASC) ON VNF_IDX
  514. GO
  515.  
  516. CREATE INDEX REQHIS_IDX16 ON RICALM.REQUEST_HISTORY (REQUEST_ID ASC) ON VNF_IDX
  517. GO
  518.  
  519. CREATE INDEX REQHIS_IDX17 ON RICALM.REQUEST_HISTORY (REC_DATETIME ASC) ON VNF_IDX
  520. GO
  521.  
  522. CREATE INDEX REQHIS_IDX18 ON RICALM.REQUEST_HISTORY (PREV_REQUEST_HISTORY_ID ASC) ON VNF_IDX
  523. GO
  524.  
  525. CREATE INDEX REQBASE_IDX1 ON RICALM.REQUEST_BASELINE (REQUEST_HISTORY_ID ASC) ON VNF_IDX
  526. GO
  527.  
  528. CREATE INDEX REQBASE_IDX2 ON RICALM.REQUEST_BASELINE (REC_DATETIME ASC) ON VNF_IDX
  529. GO
  530.  
  531. CREATE INDEX REQBASE_IDX3 ON RICALM.REQUEST_BASELINE (REQUEST_HISTORY_ID ASC, REC_DATETIME ASC) ON VNF_IDX
  532. GO
  533.  
  534. CREATE INDEX REQINTEXT_IDX1 ON RICALM.REQUEST_INT_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  535. GO
  536.  
  537. CREATE INDEX REQINTEXT_IDX2 ON RICALM.REQUEST_INT_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  538. GO
  539.  
  540. CREATE INDEX REQLONGEXT_IDX1 ON RICALM.REQUEST_LONG_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  541. GO
  542.  
  543. CREATE INDEX REQLONGEXT_IDX2 ON RICALM.REQUEST_LONG_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  544. GO
  545.  
  546. CREATE INDEX REQBOOLEXT_IDX1 ON RICALM.REQUEST_BOOL_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  547. GO
  548.  
  549. CREATE INDEX REQBOOLEXT_IDX2 ON RICALM.REQUEST_BOOL_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  550. GO
  551.  
  552. CREATE INDEX REQBOOLEXT_IDX3 ON RICALM.REQUEST_BOOL_EXT (REQUEST_ID ASC, NAME ASC, VAL ASC) ON VNF_IDX
  553. GO
  554.  
  555. CREATE INDEX REQSTREXT_IDX1 ON RICALM.REQUEST_STRING_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  556. GO
  557.  
  558. CREATE INDEX REQSTREXT_IDX2 ON RICALM.REQUEST_STRING_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  559. GO
  560.  
  561. CREATE INDEX REQSTREXT_IDX3 ON RICALM.REQUEST_STRING_EXT (REQUEST_ID ASC, VAL ASC) ON VNF_IDX
  562. GO
  563.  
  564. CREATE INDEX REQSTRMEXT_IDX1 ON RICALM.REQUEST_STRING_M_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  565. GO
  566.  
  567. CREATE INDEX REQSTRMEXT_IDX2 ON RICALM.REQUEST_STRING_M_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  568. GO
  569.  
  570. CREATE INDEX REQSTRLEXT_IDX1 ON RICALM.REQUEST_STRING_L_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  571. GO
  572.  
  573. CREATE INDEX REQSTRLEXT_IDX2 ON RICALM.REQUEST_STRING_L_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  574. GO
  575.  
  576. CREATE INDEX REQTSEXT_IDX1 ON RICALM.REQUEST_TIMESTAMP_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  577. GO
  578.  
  579. CREATE INDEX REQTSEXT_IDX2 ON RICALM.REQUEST_TIMESTAMP_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  580. GO
  581.  
  582. CREATE INDEX REQDECEXT_IDX1 ON RICALM.REQUEST_DECIMAL_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  583. GO
  584.  
  585. CREATE INDEX REQDECEXT_IDX2 ON RICALM.REQUEST_DECIMAL_EXT (REQUEST_ID ASC, NAME ASC) ON VNF_IDX
  586. GO
  587.  
  588. CREATE INDEX REQHISINTEXT_IDX1 ON RICALM.REQUEST_HISTORY_INT_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  589. GO
  590.  
  591. CREATE INDEX REQHISINTEXT_IDX2 ON RICALM.REQUEST_HISTORY_INT_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  592. GO
  593.  
  594. CREATE INDEX REQHISLONGEXT_IDX1 ON RICALM.REQUEST_HISTORY_LONG_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  595. GO
  596.  
  597. CREATE INDEX REQHISLONGEXT_IDX2 ON RICALM.REQUEST_HISTORY_LONG_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  598. GO
  599.  
  600. CREATE INDEX REQHISBOOLEXT_IDX1 ON RICALM.REQUEST_HISTORY_BOOL_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  601. GO
  602.  
  603. CREATE INDEX REQHISBOOLEXT_IDX2 ON RICALM.REQUEST_HISTORY_BOOL_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  604. GO
  605.  
  606. CREATE INDEX REQHISBOOLEXT_IDX3 ON RICALM.REQUEST_HISTORY_BOOL_EXT (REQUEST_HISTORY_ID ASC, NAME ASC, VAL ASC) ON VNF_IDX
  607. GO
  608.  
  609. CREATE INDEX REQHISSTREXT_IDX1 ON RICALM.REQUEST_HISTORY_STRING_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  610. GO
  611.  
  612. CREATE INDEX REQHISSTREXT_IDX2 ON RICALM.REQUEST_HISTORY_STRING_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  613. GO
  614.  
  615. CREATE INDEX REQHISSTREXT_IDX3 ON RICALM.REQUEST_HISTORY_STRING_EXT (REQUEST_HISTORY_ID ASC, VAL ASC) ON VNF_IDX
  616. GO
  617.  
  618. CREATE INDEX REQHISSTRMEXT_IDX1 ON RICALM.REQUEST_HISTORY_STRING_M_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  619. GO
  620.  
  621. CREATE INDEX REQHISSTRMEXT_IDX2 ON RICALM.REQUEST_HISTORY_STRING_M_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  622. GO
  623.  
  624. CREATE INDEX REQHISSTRLEXT_IDX1 ON RICALM.REQUEST_HISTORY_STRING_L_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  625. GO
  626.  
  627. CREATE INDEX REQHISSTRLEXT_IDX2 ON RICALM.REQUEST_HISTORY_STRING_L_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  628. GO
  629.  
  630. CREATE INDEX REQHISTSEXT_IDX1 ON RICALM.REQUEST_HISTORY_TIMESTAMP_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  631. GO
  632.  
  633. CREATE INDEX REQHISTSEXT_IDX2 ON RICALM.REQUEST_HISTORY_TIMESTAMP_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  634. GO
  635.  
  636. CREATE INDEX REQHISDECEXT_IDX1 ON RICALM.REQUEST_HISTORY_DECIMAL_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  637. GO
  638.  
  639. CREATE INDEX REQHISDECEXT_IDX2 ON RICALM.REQUEST_HISTORY_DECIMAL_EXT (REQUEST_HISTORY_ID ASC, NAME ASC) ON VNF_IDX
  640. GO
  641.  
  642. CREATE INDEX REQEXTLNK_IDX1 ON RICALM.REQUIREMENT_EXTERNAL_LINK (PRED_REQUIREMENT_ID ASC, LINK_TYPE_ID ASC) ON VNF_IDX
  643. GO
  644.  
  645. CREATE INDEX REQEXTLNK_IDX2 ON RICALM.REQUIREMENT_EXTERNAL_LINK (EXTERNAL_ID ASC, PRED_REQUIREMENT_ID ASC, EXTERNAL_LABEL ASC, LINK_TYPE_ID ASC) ON VNF_IDX
  646. GO
  647.  
  648. ALTER TABLE RICALM.REQUEST_APPROVAL_TYPE ADD CONSTRAINT RQSAPTP_PK PRIMARY KEY (REQUEST_APPROVAL_TYPE_ID) ON VNF_IDX
  649. GO
  650.  
  651. ALTER TABLE RICALM.REQUEST_APPROVAL_STATE ADD CONSTRAINT RQSAPST_PK PRIMARY KEY (REQUEST_APPROVAL_STATE_ID) ON VNF_IDX
  652. GO
  653.  
  654. ALTER TABLE RICALM.REQUEST_APPROVAL_DESCRIPTOR ADD CONSTRAINT RQSAPDS_PK PRIMARY KEY (REQUEST_APPROVAL_DESCRIPTOR_ID) ON VNF_IDX
  655. GO
  656.  
  657. ALTER TABLE RICALM.REQUEST_APPROVAL ADD CONSTRAINT RQSAPPR_PK PRIMARY KEY (REQUEST_APPROVAL_ID) ON VNF_IDX
  658. GO
  659.  
  660. ALTER TABLE RICALM.TIMESHEET_ENTRY ADD CONSTRAINT TMENTRY_PK PRIMARY KEY (TIMESHEET_ENTRY_ID) ON VNF_IDX
  661. GO
  662.  
  663. ALTER TABLE RICALM.TEAM_CAPACITY ADD CONSTRAINT TEAMCAP_PK PRIMARY KEY (TEAM_CAPACITY_ID) ON VNF_IDX
  664. GO
  665.  
  666. ALTER TABLE RICALM.GROUP_NAME_FACET ADD CONSTRAINT GRNMFC_PK PRIMARY KEY (GROUP_NAME_FACET_ID) ON VNF_IDX
  667. GO
  668.  
  669. ALTER TABLE RICALM.SCALAR_COUNTER ADD CONSTRAINT SCALCNT_PK PRIMARY KEY (SCALAR_COUNTER_ID) ON VNF_IDX
  670. GO
  671.  
  672. ALTER TABLE RICALM.RANGE_COUNTER ADD CONSTRAINT RANGECNT_PK PRIMARY KEY (RANGE_COUNTER_ID) ON VNF_IDX
  673. GO
  674.  
  675. ALTER TABLE RICALM.INTEGRAL_RANGE_COUNTER ADD CONSTRAINT INTRGCNT_PK PRIMARY KEY (INTEGRAL_RANGE_COUNTER_ID) ON VNF_IDX
  676. GO
  677.  
  678. ALTER TABLE RICALM.ITEM_TYPE_STORAGE ADD CONSTRAINT ITYPESTRG_PK PRIMARY KEY (ITEM_TYPE_STORAGE_ID) ON VNF_IDX
  679. GO
  680.  
  681. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_PK PRIMARY KEY (REQUEST_HISTORY_ID) ON VNF_IDX
  682. GO
  683.  
  684. ALTER TABLE RICALM.REQUEST_ENUMERATION ADD CONSTRAINT REQENUM_PK PRIMARY KEY (REQUEST_ENUMERATION_ID) ON VNF_IDX
  685. GO
  686.  
  687. ALTER TABLE RICALM.REQUEST_COMPONENT_EXT ADD CONSTRAINT REQCMPEXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  688. GO
  689.  
  690. ALTER TABLE RICALM.REQUEST_COMPONENT_EXT ADD CONSTRAINT REQCMPEXT_FK2 FOREIGN KEY (VAL_COMPONENT_ID) REFERENCES RIODS.COMPONENT (COMPONENT_ID)
  691. GO
  692.  
  693. ALTER TABLE RICALM.REQUEST_CATEGORY_EXT ADD CONSTRAINT REQCTGEXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  694. GO
  695.  
  696. ALTER TABLE RICALM.REQUEST_CATEGORY_EXT ADD CONSTRAINT REQCTGEXT_FK2 FOREIGN KEY (VAL_REQUEST_CATEGORY_ID) REFERENCES RIODS.REQUEST_CATEGORY (REQUEST_CATEGORY_ID)
  697. GO
  698.  
  699. ALTER TABLE RICALM.REQUEST_RESOURCE_EXT ADD CONSTRAINT REQRSREXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  700. GO
  701.  
  702. ALTER TABLE RICALM.REQUEST_RESOURCE_EXT ADD CONSTRAINT REQRSREXT_FK2 FOREIGN KEY (VAL_RESOURCE_ID) REFERENCES RIODS.RESOURCE (RESOURCE_ID)
  703. GO
  704.  
  705. ALTER TABLE RICALM.REQUEST_RELEASE_EXT ADD CONSTRAINT REQRLSEXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  706. GO
  707.  
  708. ALTER TABLE RICALM.REQUEST_RELEASE_EXT ADD CONSTRAINT REQRLSEXT_FK2 FOREIGN KEY (VAL_RELEASE_ID) REFERENCES RIODS.RELEASE (RELEASE_ID)
  709. GO
  710.  
  711. ALTER TABLE RICALM.REQUEST_ITERATION_EXT ADD CONSTRAINT REQITEEXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  712. GO
  713.  
  714. ALTER TABLE RICALM.REQUEST_ITERATION_EXT ADD CONSTRAINT REQITEEXT_FK2 FOREIGN KEY (VAL_ITERATION_ID) REFERENCES RIODS.ITERATION (ITERATION_ID)
  715. GO
  716.  
  717. ALTER TABLE RICALM.REQUEST_PROJECT_EXT ADD CONSTRAINT REQPRJEXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  718. GO
  719.  
  720. ALTER TABLE RICALM.REQUEST_PROJECT_EXT ADD CONSTRAINT REQPRJEXT_FK2 FOREIGN KEY (VAL_PROJECT_ID) REFERENCES RIODS.PROJECT (PROJECT_ID)
  721. GO
  722.  
  723. ALTER TABLE RICALM.REQUEST_TEAM_EXT ADD CONSTRAINT REQTMAEXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  724. GO
  725.  
  726. ALTER TABLE RICALM.REQUEST_TEAM_EXT ADD CONSTRAINT REQTMAEXT_FK2 FOREIGN KEY (VAL_TEAM_ID) REFERENCES RIODS.TEAM (TEAM_ID)
  727. GO
  728.  
  729. ALTER TABLE RICALM.REQUEST_TIMELINE_EXT ADD CONSTRAINT REQTLNEXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  730. GO
  731.  
  732. ALTER TABLE RICALM.REQUEST_TIMELINE_EXT ADD CONSTRAINT REQTLNEXT_FK2 FOREIGN KEY (VAL_TIMELINE_ID) REFERENCES RIODS.TIMELINE (TIMELINE_ID)
  733. GO
  734.  
  735. ALTER TABLE RICALM.REQUEST_REQUEST_EXT ADD CONSTRAINT REQREQEXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  736. GO
  737.  
  738. ALTER TABLE RICALM.REQUEST_REQUEST_EXT ADD CONSTRAINT REQREQEXT_FK2 FOREIGN KEY (VAL_REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  739. GO
  740.  
  741. ALTER TABLE RICALM.REQUEST_HISTORY_COMPONENT_EXT ADD CONSTRAINT REQHISCMPEXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  742. GO
  743.  
  744. ALTER TABLE RICALM.REQUEST_HISTORY_COMPONENT_EXT ADD CONSTRAINT REQHISCMPEXT_FK2 FOREIGN KEY (VAL_COMPONENT_ID) REFERENCES RIODS.COMPONENT (COMPONENT_ID)
  745. GO
  746.  
  747. ALTER TABLE RICALM.REQUEST_HISTORY_CATEGORY_EXT ADD CONSTRAINT REQHISCTGEXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  748. GO
  749.  
  750. ALTER TABLE RICALM.REQUEST_HISTORY_CATEGORY_EXT ADD CONSTRAINT REQHISCTGEXT_FK2 FOREIGN KEY (VAL_REQUEST_CATEGORY_ID) REFERENCES RIODS.REQUEST_CATEGORY (REQUEST_CATEGORY_ID)
  751. GO
  752.  
  753. ALTER TABLE RICALM.REQUEST_HISTORY_RESOURCE_EXT ADD CONSTRAINT REQHISRSREXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  754. GO
  755.  
  756. ALTER TABLE RICALM.REQUEST_HISTORY_RESOURCE_EXT ADD CONSTRAINT REQHISRSREXT_FK2 FOREIGN KEY (VAL_RESOURCE_ID) REFERENCES RIODS.RESOURCE (RESOURCE_ID)
  757. GO
  758.  
  759. ALTER TABLE RICALM.REQUEST_HISTORY_RELEASE_EXT ADD CONSTRAINT REQHISRLSEXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  760. GO
  761.  
  762. ALTER TABLE RICALM.REQUEST_HISTORY_RELEASE_EXT ADD CONSTRAINT REQHISRLSEXT_FK2 FOREIGN KEY (VAL_RELEASE_ID) REFERENCES RIODS.RELEASE (RELEASE_ID)
  763. GO
  764.  
  765. ALTER TABLE RICALM.REQUEST_HISTORY_ITERATION_EXT ADD CONSTRAINT REQHISITEEXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  766. GO
  767.  
  768. ALTER TABLE RICALM.REQUEST_HISTORY_ITERATION_EXT ADD CONSTRAINT REQHISITEEXT_FK2 FOREIGN KEY (VAL_ITERATION_ID) REFERENCES RIODS.ITERATION (ITERATION_ID)
  769. GO
  770.  
  771. ALTER TABLE RICALM.REQUEST_HISTORY_PROJECT_EXT ADD CONSTRAINT REQHISPRJEXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  772. GO
  773.  
  774. ALTER TABLE RICALM.REQUEST_HISTORY_PROJECT_EXT ADD CONSTRAINT REQHISPRJEXT_FK2 FOREIGN KEY (VAL_PROJECT_ID) REFERENCES RIODS.PROJECT (PROJECT_ID)
  775. GO
  776.  
  777. ALTER TABLE RICALM.REQUEST_HISTORY_TEAM_EXT ADD CONSTRAINT REQHISTMAEXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  778. GO
  779.  
  780. ALTER TABLE RICALM.REQUEST_HISTORY_TEAM_EXT ADD CONSTRAINT REQHISTMAEXT_FK2 FOREIGN KEY (VAL_TEAM_ID) REFERENCES RIODS.TEAM (TEAM_ID)
  781. GO
  782.  
  783. ALTER TABLE RICALM.REQUEST_HISTORY_TIMELINE_EXT ADD CONSTRAINT REQHISTLNEXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  784. GO
  785.  
  786. ALTER TABLE RICALM.REQUEST_HISTORY_TIMELINE_EXT ADD CONSTRAINT REQHISTLNEXT_FK2 FOREIGN KEY (VAL_TIMELINE_ID) REFERENCES RIODS.TIMELINE (TIMELINE_ID)
  787. GO
  788.  
  789. ALTER TABLE RICALM.REQUEST_HISTORY_REQUEST_EXT ADD CONSTRAINT REQHISREQEXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  790. GO
  791.  
  792. ALTER TABLE RICALM.REQUEST_HISTORY_REQUEST_EXT ADD CONSTRAINT REQHISREQEXT_FK2 FOREIGN KEY (VAL_REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  793. GO
  794.  
  795. ALTER TABLE RICALM.REQUEST_APPROVAL_TYPE ADD CONSTRAINT RQSAPTP_FK1 FOREIGN KEY (PROJECT_ID) REFERENCES RIODS.PROJECT (PROJECT_ID)
  796. GO
  797.  
  798. ALTER TABLE RICALM.REQUEST_APPROVAL_STATE ADD CONSTRAINT RQSAPST_FK1 FOREIGN KEY (PROJECT_ID) REFERENCES RIODS.PROJECT (PROJECT_ID)
  799. GO
  800.  
  801. ALTER TABLE RICALM.REQUEST_APPROVAL_DESCRIPTOR ADD CONSTRAINT RQSAPDS_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  802. GO
  803.  
  804. ALTER TABLE RICALM.REQUEST_APPROVAL_DESCRIPTOR ADD CONSTRAINT RQSAPDS_FK2 FOREIGN KEY (REQUEST_APPROVAL_TYPE_ID) REFERENCES RICALM.REQUEST_APPROVAL_TYPE (REQUEST_APPROVAL_TYPE_ID)
  805. GO
  806.  
  807. ALTER TABLE RICALM.REQUEST_APPROVAL_DESCRIPTOR ADD CONSTRAINT RQSAPDS_FK3 FOREIGN KEY (CUMULATIVE_STATE_ID) REFERENCES RICALM.REQUEST_APPROVAL_STATE (REQUEST_APPROVAL_STATE_ID)
  808. GO
  809.  
  810. ALTER TABLE RICALM.REQUEST_APPROVAL ADD CONSTRAINT RQSAPPR_FK1 FOREIGN KEY (REQUEST_APPROVAL_DESCRIPTOR_ID) REFERENCES RICALM.REQUEST_APPROVAL_DESCRIPTOR (REQUEST_APPROVAL_DESCRIPTOR_ID) ON DELETE CASCADE
  811. GO
  812.  
  813. ALTER TABLE RICALM.REQUEST_APPROVAL ADD CONSTRAINT RQSAPPR_FK2 FOREIGN KEY (REQUEST_APPROVAL_STATE_ID) REFERENCES RICALM.REQUEST_APPROVAL_STATE (REQUEST_APPROVAL_STATE_ID)
  814. GO
  815.  
  816. ALTER TABLE RICALM.REQUEST_APPROVAL ADD CONSTRAINT RQSAPPR_FK3 FOREIGN KEY (APPROVER_ID) REFERENCES RIODS.RESOURCE (RESOURCE_ID)
  817. GO
  818.  
  819. ALTER TABLE RICALM.TIMESHEET_ENTRY ADD CONSTRAINT TMENTRY_FK1 FOREIGN KEY (TIMESHEET_ID) REFERENCES RIODS.TIMESHEET (TIMESHEET_ID)
  820. GO
  821.  
  822. ALTER TABLE RICALM.TIMESHEET_ENTRY ADD CONSTRAINT TMENTRY_FK2 FOREIGN KEY (ACTIVITY_ID) REFERENCES RIODS.ACTIVITY (ACTIVITY_ID)
  823. GO
  824.  
  825. ALTER TABLE RICALM.TEAM_CAPACITY ADD CONSTRAINT TEAMCAP_FK1 FOREIGN KEY (TEAM_ID) REFERENCES RIODS.TEAM (TEAM_ID)
  826. GO
  827.  
  828. ALTER TABLE RICALM.TEAM_CAPACITY ADD CONSTRAINT TEAMCAP_FK2 FOREIGN KEY (PROJECT_ID) REFERENCES RIODS.PROJECT (PROJECT_ID)
  829. GO
  830.  
  831. ALTER TABLE RICALM.TEAM_CAPACITY ADD CONSTRAINT TEAMCAP_FK3 FOREIGN KEY (TIMELINE_ID) REFERENCES RIODS.TIMELINE (TIMELINE_ID)
  832. GO
  833.  
  834. ALTER TABLE RICALM.SCALAR_COUNTER ADD CONSTRAINT SCALCNT_FK1 FOREIGN KEY (GROUP_NAME_FACET_ID) REFERENCES RICALM.GROUP_NAME_FACET (GROUP_NAME_FACET_ID)
  835. GO
  836.  
  837. ALTER TABLE RICALM.RANGE_COUNTER ADD CONSTRAINT RANGECNT_FK1 FOREIGN KEY (GROUP_NAME_FACET_ID) REFERENCES RICALM.GROUP_NAME_FACET (GROUP_NAME_FACET_ID)
  838. GO
  839.  
  840. ALTER TABLE RICALM.INTEGRAL_RANGE_COUNTER ADD CONSTRAINT INTRGCNT_FK1 FOREIGN KEY (GROUP_NAME_FACET_ID) REFERENCES RICALM.GROUP_NAME_FACET (GROUP_NAME_FACET_ID)
  841. GO
  842.  
  843. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_FK1 FOREIGN KEY (PROJECT_ID) REFERENCES RIODS.PROJECT (PROJECT_ID)
  844. GO
  845.  
  846. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_FK10 FOREIGN KEY (BUILD_ID) REFERENCES RIODS.BUILD (BUILD_ID)
  847. GO
  848.  
  849. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_FK11 FOREIGN KEY (PROJECT_CATEGORY_ID) REFERENCES RIODS.PROJECT_CATEGORY (PROJECT_CATEGORY_ID)
  850. GO
  851.  
  852. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_FK12 FOREIGN KEY (TEAM_ID) REFERENCES RIODS.TEAM (TEAM_ID)
  853. GO
  854.  
  855. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_FK13 FOREIGN KEY (PHASE_ID) REFERENCES RIODS.PHASE (PHASE_ID)
  856. GO
  857.  
  858. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_FK2 FOREIGN KEY (COMPONENT_ID) REFERENCES RIODS.COMPONENT (COMPONENT_ID)
  859. GO
  860.  
  861. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_FK3 FOREIGN KEY (ITERATION_ID) REFERENCES RIODS.ITERATION (ITERATION_ID)
  862. GO
  863.  
  864. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_FK5 FOREIGN KEY (RELEASE_ID) REFERENCES RIODS.RELEASE (RELEASE_ID)
  865. GO
  866.  
  867. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_FK6 FOREIGN KEY (FIXEDINRELEASE_ID) REFERENCES RIODS.RELEASE (RELEASE_ID)
  868. GO
  869.  
  870. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_FK7 FOREIGN KEY (REQUEST_CLASS_ID) REFERENCES RIODS.REQUEST_CLASSIFICATION (REQUEST_CLASS_ID)
  871. GO
  872.  
  873. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_FK8 FOREIGN KEY (OWNER_ID) REFERENCES RIODS.RESOURCE (RESOURCE_ID)
  874. GO
  875.  
  876. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_FK9 FOREIGN KEY (RESOLVER_ID) REFERENCES RIODS.RESOURCE (RESOURCE_ID)
  877. GO
  878.  
  879. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQUEST_FK14 FOREIGN KEY (REQUEST_STATE_ID) REFERENCES RIODS.REQUEST_STATE (REQUEST_STATE_ID)
  880. GO
  881.  
  882. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQUEST_FK15 FOREIGN KEY (REQUEST_STATUS_ID) REFERENCES RIODS.REQUEST_STATUS (REQUEST_STATUS_ID)
  883. GO
  884.  
  885. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQUEST_FK16 FOREIGN KEY (REQUEST_RESOLUTION_ID) REFERENCES RIODS.REQUEST_RESOLUTION (REQUEST_RESOLUTION_ID)
  886. GO
  887.  
  888. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQUEST_FK17 FOREIGN KEY (REQUEST_SEVERITY_ID) REFERENCES RIODS.REQUEST_SEVERITY (REQUEST_SEVERITY_ID)
  889. GO
  890.  
  891. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQUEST_FK18 FOREIGN KEY (REQUEST_PRIORITY_ID) REFERENCES RIODS.REQUEST_PRIORITY (REQUEST_PRIORITY_ID)
  892. GO
  893.  
  894. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQUEST_FK19 FOREIGN KEY (REQUEST_TYPE_ID) REFERENCES RIODS.REQUEST_TYPE (REQUEST_TYPE_ID)
  895. GO
  896.  
  897. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_FK20 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST(REQUEST_ID)
  898. GO
  899.  
  900. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_FK21 FOREIGN KEY (PREV_REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  901. GO
  902.  
  903. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_FK22 FOREIGN KEY (CREATOR_ID) REFERENCES RIODS.RESOURCE (RESOURCE_ID)
  904. GO
  905.  
  906. ALTER TABLE RICALM.REQUEST_HISTORY ADD CONSTRAINT REQHIS_FK23 FOREIGN KEY (MODIFIER_ID) REFERENCES RIODS.RESOURCE (RESOURCE_ID)
  907. GO
  908.  
  909. ALTER TABLE RICALM.REQUEST_BASELINE ADD CONSTRAINT REQBASE_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  910. GO
  911.  
  912. ALTER TABLE RICALM.REQUEST_INT_EXT ADD CONSTRAINT REQINTEXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  913. GO
  914.  
  915. ALTER TABLE RICALM.REQUEST_LONG_EXT ADD CONSTRAINT REQLONGEXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  916. GO
  917.  
  918. ALTER TABLE RICALM.REQUEST_BOOL_EXT ADD CONSTRAINT REQBOOLEXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  919. GO
  920.  
  921. ALTER TABLE RICALM.REQUEST_STRING_EXT ADD CONSTRAINT REQSTREXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  922. GO
  923.  
  924. ALTER TABLE RICALM.REQUEST_STRING_M_EXT ADD CONSTRAINT REQSTRMEXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  925. GO
  926.  
  927. ALTER TABLE RICALM.REQUEST_STRING_L_EXT ADD CONSTRAINT REQSTRLEXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  928. GO
  929.  
  930. ALTER TABLE RICALM.REQUEST_TIMESTAMP_EXT ADD CONSTRAINT REQTSEXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  931. GO
  932.  
  933. ALTER TABLE RICALM.REQUEST_DECIMAL_EXT ADD CONSTRAINT REQDECEXT_FK1 FOREIGN KEY (REQUEST_ID) REFERENCES RIODS.REQUEST (REQUEST_ID)
  934. GO
  935.  
  936. ALTER TABLE RICALM.REQUEST_HISTORY_INT_EXT ADD CONSTRAINT REQHISINTEXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  937. GO
  938.  
  939. ALTER TABLE RICALM.REQUEST_HISTORY_LONG_EXT ADD CONSTRAINT REQHISLONGEXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  940. GO
  941.  
  942. ALTER TABLE RICALM.REQUEST_HISTORY_BOOL_EXT ADD CONSTRAINT REQHISBOOLEXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  943. GO
  944.  
  945. ALTER TABLE RICALM.REQUEST_HISTORY_STRING_EXT ADD CONSTRAINT REQHISSTREXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  946. GO
  947.  
  948. ALTER TABLE RICALM.REQUEST_HISTORY_STRING_M_EXT ADD CONSTRAINT REQHISSTRMEXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  949. GO
  950.  
  951. ALTER TABLE RICALM.REQUEST_HISTORY_STRING_L_EXT ADD CONSTRAINT REQHISSTRLEXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  952. GO
  953.  
  954. ALTER TABLE RICALM.REQUEST_HISTORY_TIMESTAMP_EXT ADD CONSTRAINT REQHISTSEXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  955. GO
  956.  
  957. ALTER TABLE RICALM.REQUEST_HISTORY_DECIMAL_EXT ADD CONSTRAINT REQHISDECEXT_FK1 FOREIGN KEY (REQUEST_HISTORY_ID) REFERENCES RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID)
  958. GO
  959.  
  960. ALTER TABLE RICALM.REQUEST_ENUMERATION ADD CONSTRAINT REQENUM_FK1 FOREIGN KEY (PROJECT_ID) REFERENCES RIODS.PROJECT (PROJECT_ID)
  961. GO
  962.  
  963. ALTER TABLE RICALM.REQUIREMENT_EXTERNAL_LINK ADD CONSTRAINT REQEXTLNK_FK1 FOREIGN KEY (PRED_REQUIREMENT_ID) REFERENCES RIODS.REQUIREMENT (REQUIREMENT_ID)
  964. GO
  965.  
  966. ALTER TABLE RICALM.REQUIREMENT_EXTERNAL_LINK ADD CONSTRAINT REQEXTLNK_FK2 FOREIGN KEY (LINK_TYPE_ID) REFERENCES RIODS.REQUIREMENT_LINK_TYPE (LINK_TYPE_ID)
  967. GO
  968.  
  969. CREATE INDEX RQRHIS_IDX1 ON RICALM.RQRMENT_HISTORY (EXTERNAL_KEY2 ASC) ON VNF_IDX
  970. GO
  971.  
  972. CREATE INDEX RQRHIS_IDX2 ON RICALM.RQRMENT_HISTORY (EXTERNAL_KEY1 ASC, SOURCE_ID ASC) ON VNF_IDX
  973. GO
  974.  
  975. CREATE INDEX RQRHIS_IDX3 ON RICALM.RQRMENT_HISTORY (EXTERNAL_KEY2 ASC, SOURCE_ID ASC) ON VNF_IDX
  976. GO
  977.  
  978. CREATE INDEX RQRHIS_IDX4 ON RICALM.RQRMENT_HISTORY (ISSOFTDELETED ASC) ON VNF_IDX
  979. GO
  980.  
  981. CREATE INDEX RQRHIS_IDX5 ON RICALM.RQRMENT_HISTORY (REQUIREMENT_CLASS_ID ASC, REQUIREMENT_HISTORY_ID ASC, EXTERNAL_KEY1 ASC, SOURCE_ID ASC) ON VNF_IDX
  982. GO
  983.  
  984. CREATE INDEX RQRHIS_IDX6 ON RICALM.RQRMENT_HISTORY (REQUIREMENT_CLASS_ID ASC, REQUIREMENT_HISTORY_ID ASC) ON VNF_IDX
  985. GO
  986.  
  987. CREATE INDEX RQRHIS_IDX7 ON RICALM.RQRMENT_HISTORY (REQUIREMENT_HISTORY_ID ASC, EXTERNAL_KEY1 ASC, SOURCE_ID ASC) ON VNF_IDX
  988. GO
  989.  
  990. CREATE INDEX RQRTYPE_IDX1 ON RICALM.RQRMENT_TYPE (REQUIREMENT_TYPE_ID ASC, IDENTIFIER ASC) ON VNF_IDX
  991. GO
  992.  
  993. CREATE INDEX RQRTYPE_IDX2 ON RICALM.RQRMENT_TYPE (ISSOFTDELETED ASC) ON VNF_IDX
  994. GO
  995.  
  996. CREATE INDEX RQRATTRDEF_IDX1 ON RICALM.RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID ASC, IDENTIFIER ASC) ON VNF_IDX
  997. GO
  998.  
  999. CREATE INDEX RQRATTRDEF_IDX2 ON RICALM.RQRMENT_ATTRDEF (ISSOFTDELETED ASC) ON VNF_IDX
  1000. GO
  1001.  
  1002. CREATE INDEX RQRTYP_ATTDEF_IDX1 ON RICALM.RQRMENT_TYPE_ATTRDEF (REQUIREMENT_TYPE_ID ASC, REQUIREMENT_ATTRDEF_ID ASC) ON VNF_IDX
  1003. GO
  1004.  
  1005. CREATE INDEX RQRENUM_IDX1 ON RICALM.RQRMENT_ENUMERATION (REQUIREMENT_ID ASC, REQUIREMENT_ATTRDEF_ID ASC, PROJECT_ID ASC, EXTERNAL_ID ASC) ON VNF_IDX
  1006. GO
  1007.  
  1008. CREATE INDEX RQRINTEXT_IDX1 ON RICALM.RQRMENT_INT_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1009. GO
  1010.  
  1011. CREATE INDEX RQRINTEXT_IDX2 ON RICALM.RQRMENT_INT_EXT (REQUIREMENT_ID ASC, REQUIREMENT_ATTRDEF_ID ASC) ON VNF_IDX
  1012. GO
  1013.  
  1014. CREATE INDEX RQRBOOLEXT_IDX1 ON RICALM.RQRMENT_BOOL_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1015. GO
  1016.  
  1017. CREATE INDEX RQRBOOLEXT_IDX2 ON RICALM.RQRMENT_BOOL_EXT (REQUIREMENT_ID ASC, REQUIREMENT_ATTRDEF_ID ASC) ON VNF_IDX
  1018. GO
  1019.  
  1020. CREATE INDEX RQRBOOLEXT_IDX3 ON RICALM.RQRMENT_BOOL_EXT (REQUIREMENT_ID ASC, REQUIREMENT_ATTRDEF_ID ASC, VAL ASC) ON VNF_IDX
  1021. GO
  1022.  
  1023. CREATE INDEX RQRSTREXT_IDX1 ON RICALM.RQRMENT_STRING_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1024. GO
  1025.  
  1026. CREATE INDEX RQRSTREXT_IDX2 ON RICALM.RQRMENT_STRING_EXT (REQUIREMENT_ID ASC, REQUIREMENT_ATTRDEF_ID ASC) ON VNF_IDX
  1027. GO
  1028.  
  1029. CREATE INDEX RQRSTREXT_IDX3 ON RICALM.RQRMENT_STRING_EXT (REQUIREMENT_ID ASC, REQUIREMENT_ATTRDEF_ID ASC, VAL ASC) ON VNF_IDX
  1030. GO
  1031.  
  1032. CREATE INDEX RQRTMPEXT_IDX1 ON RICALM.RQRMENT_TIMESTAMP_EXT (REQUIREMENT_ID ASC, REQUIREMENT_ATTRDEF_ID ASC) ON VNF_IDX
  1033. GO
  1034.  
  1035. CREATE INDEX RQRTMPEXT_IDX2 ON RICALM.RQRMENT_TIMESTAMP_EXT (REQUIREMENT_ID ASC, REQUIREMENT_ATTRDEF_ID ASC, VAL ASC) ON VNF_IDX
  1036. GO
  1037.  
  1038. CREATE INDEX RQRDTEXT_IDX1 ON RICALM.RQRMENT_DATE_EXT (REQUIREMENT_ID ASC, REQUIREMENT_ATTRDEF_ID ASC) ON VNF_IDX
  1039. GO
  1040.  
  1041. CREATE INDEX RQRDTEXT_IDX2 ON RICALM.RQRMENT_DATE_EXT (REQUIREMENT_ID ASC, REQUIREMENT_ATTRDEF_ID ASC, VAL ASC) ON VNF_IDX
  1042. GO
  1043.  
  1044. CREATE INDEX RQRSTRLEXT_IDX1 ON RICALM.RQRMENT_STRING_L_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1045. GO
  1046.  
  1047. CREATE INDEX RQRSTRLEXT_IDX2 ON RICALM.RQRMENT_STRING_L_EXT (REQUIREMENT_ID ASC, REQUIREMENT_ATTRDEF_ID ASC) ON VNF_IDX
  1048. GO
  1049.  
  1050. CREATE INDEX RQRDECEXT_IDX1 ON RICALM.RQRMENT_DECIMAL_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1051. GO
  1052.  
  1053. CREATE INDEX RQRDECEXT_IDX2 ON RICALM.RQRMENT_DECIMAL_EXT (REQUIREMENT_ID ASC, REQUIREMENT_ATTRDEF_ID ASC) ON VNF_IDX
  1054. GO
  1055.  
  1056. CREATE INDEX RQRHISINTEXT_IDX1 ON RICALM.RQRMENT_HISTORY_INT_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1057. GO
  1058.  
  1059. CREATE INDEX RQRHISINTEXT_IDX2 ON RICALM.RQRMENT_HISTORY_INT_EXT (REQUIREMENT_HISTORY_ID ASC, REQUIREMENT_ATTRDEF_ID ASC) ON VNF_IDX
  1060. GO
  1061.  
  1062. CREATE INDEX RQRHISBOOLEXT_IDX1 ON RICALM.RQRMENT_HISTORY_BOOL_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1063. GO
  1064.  
  1065. CREATE INDEX RQRHISBOOLEXT_IDX2 ON RICALM.RQRMENT_HISTORY_BOOL_EXT (REQUIREMENT_HISTORY_ID ASC, REQUIREMENT_ATTRDEF_ID ASC) ON VNF_IDX
  1066. GO
  1067.  
  1068. CREATE INDEX RQRHISBOOLEXT_IDX3 ON RICALM.RQRMENT_HISTORY_BOOL_EXT (REQUIREMENT_HISTORY_ID ASC, REQUIREMENT_ATTRDEF_ID ASC, VAL ASC) ON VNF_IDX
  1069. GO
  1070.  
  1071. CREATE INDEX RQRHISSTREXT_IDX1 ON RICALM.RQRMENT_HISTORY_STRING_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1072. GO
  1073.  
  1074. CREATE INDEX RQRHISSTREXT_IDX2 ON RICALM.RQRMENT_HISTORY_STRING_EXT (REQUIREMENT_HISTORY_ID ASC, REQUIREMENT_ATTRDEF_ID ASC) ON VNF_IDX
  1075. GO
  1076.  
  1077. CREATE INDEX RQRHISSTREXT_IDX3 ON RICALM.RQRMENT_HISTORY_STRING_EXT (REQUIREMENT_HISTORY_ID ASC, REQUIREMENT_ATTRDEF_ID ASC, VAL ASC) ON VNF_IDX
  1078. GO
  1079.  
  1080. CREATE INDEX RQRHISTMPEXT_IDX1 ON RICALM.RQRMENT_HISTORY_TIMESTAMP_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1081. GO
  1082.  
  1083. CREATE INDEX RQRHISTMPEXT_IDX2 ON RICALM.RQRMENT_HISTORY_TIMESTAMP_EXT (REQUIREMENT_HISTORY_ID ASC, REQUIREMENT_ATTRDEF_ID ASC) ON VNF_IDX
  1084. GO
  1085.  
  1086. CREATE INDEX RQRHISTMPEXT_IDX3 ON RICALM.RQRMENT_HISTORY_TIMESTAMP_EXT (REQUIREMENT_HISTORY_ID ASC, REQUIREMENT_ATTRDEF_ID ASC, VAL ASC) ON VNF_IDX
  1087. GO
  1088.  
  1089. CREATE INDEX RQRHISSTRLEXT_IDX1 ON RICALM.RQRMENT_HISTORY_STRING_L_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1090. GO
  1091.  
  1092. CREATE INDEX RQRHISSTRLEXT_IDX2 ON RICALM.RQRMENT_HISTORY_STRING_L_EXT (REQUIREMENT_HISTORY_ID ASC, REQUIREMENT_ATTRDEF_ID ASC) ON VNF_IDX
  1093. GO
  1094.  
  1095. CREATE INDEX RQRHISDECEXT_IDX1 ON RICALM.RQRMENT_HISTORY_DECIMAL_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1096. GO
  1097.  
  1098. CREATE INDEX RQRHISDECEXT_IDX2 ON RICALM.RQRMENT_HISTORY_DECIMAL_EXT (REQUIREMENT_HISTORY_ID ASC, REQUIREMENT_ATTRDEF_ID ASC) ON VNF_IDX
  1099. GO
  1100.  
  1101. ALTER TABLE RICALM.RQRMENT_HISTORY ADD CONSTRAINT RQRHIS_PK PRIMARY KEY (REQUIREMENT_HISTORY_ID) ON VNF_IDX
  1102. GO
  1103.  
  1104. ALTER TABLE RICALM.RQRMENT_HISTORY ADD CONSTRAINT RQRHIS_FK1 FOREIGN KEY (PROJECT_ID) REFERENCES RIODS.PROJECT (PROJECT_ID)
  1105. GO
  1106.  
  1107. ALTER TABLE RICALM.RQRMENT_HISTORY ADD CONSTRAINT RQRHIS_FK3 FOREIGN KEY (REQUIREMENT_CLASS_ID) REFERENCES RIODS.REQUIREMENT_CLASSIFICATION (REQUIREMENT_CLASS_ID)
  1108. GO
  1109.  
  1110. ALTER TABLE RICALM.RQRMENT_HISTORY ADD CONSTRAINT RQRHIS_FK4 FOREIGN KEY (OWNER_ID) REFERENCES RIODS.RESOURCE (RESOURCE_ID)
  1111. GO
  1112.  
  1113. ALTER TABLE RICALM.RQRMENT_HISTORY ADD CONSTRAINT RQRHIS_FK5 FOREIGN KEY (REQUIREMENT_ID) REFERENCES RIODS.REQUIREMENT(REQUIREMENT_ID)
  1114. GO
  1115.  
  1116. ALTER TABLE RICALM.RQRMENT_HISTORY ADD CONSTRAINT RQRHIS_FK7 FOREIGN KEY (PREV_REQUIREMENT_HISTORY_ID) REFERENCES RICALM.RQRMENT_HISTORY (REQUIREMENT_HISTORY_ID)
  1117. GO
  1118.  
  1119. ALTER TABLE RICALM.RQRMENT_TYPE ADD CONSTRAINT RQRMENT_TYPE_PK PRIMARY KEY (REQUIREMENT_TYPE_ID) ON VNF_IDX
  1120. GO
  1121.  
  1122. ALTER TABLE RICALM.RQRMENT_TYPE ADD CONSTRAINT RQRMENT_TYPE_FK1 FOREIGN KEY (PROJECT_ID) REFERENCES RIODS.PROJECT (PROJECT_ID)
  1123. GO
  1124.  
  1125. ALTER TABLE RICALM.RQRMENT_ATTRDEF ADD CONSTRAINT RQRMENT_ATTRDEF_PK PRIMARY KEY (REQUIREMENT_ATTRDEF_ID) ON VNF_IDX
  1126. GO
  1127.  
  1128. ALTER TABLE RICALM.RQRMENT_ATTRDEF ADD CONSTRAINT RQRMENT_ATTRDEF_FK1 FOREIGN KEY (REQUIREMENT_TYPE_ID) REFERENCES RICALM.RQRMENT_TYPE (REQUIREMENT_TYPE_ID)
  1129. GO
  1130.  
  1131. ALTER TABLE RICALM.RQRMENT_TYPE_ATTRDEF ADD CONSTRAINT RQRTYPE_ATTRDEF_FK1 FOREIGN KEY (REQUIREMENT_TYPE_ID) REFERENCES RICALM.RQRMENT_TYPE (REQUIREMENT_TYPE_ID)
  1132. GO
  1133.  
  1134. ALTER TABLE RICALM.RQRMENT_TYPE_ATTRDEF ADD CONSTRAINT RQRTYPE_ATTRDEF_FK2 FOREIGN KEY (REQUIREMENT_ATTRDEF_ID) REFERENCES RICALM.RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID)
  1135. GO
  1136.  
  1137. ALTER TABLE RICALM.RQRMENT_INT_EXT ADD CONSTRAINT RQRINTEXT_FK1 FOREIGN KEY (REQUIREMENT_ID) REFERENCES RIODS.REQUIREMENT (REQUIREMENT_ID)
  1138. GO
  1139.  
  1140. ALTER TABLE RICALM.RQRMENT_INT_EXT ADD CONSTRAINT RQRINTEXT_FK2 FOREIGN KEY (REQUIREMENT_ATTRDEF_ID) REFERENCES RICALM.RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID)
  1141. GO
  1142.  
  1143. ALTER TABLE RICALM.RQRMENT_BOOL_EXT ADD CONSTRAINT RQRBOOLEXT_FK1 FOREIGN KEY (REQUIREMENT_ID) REFERENCES RIODS.REQUIREMENT (REQUIREMENT_ID)
  1144. GO
  1145.  
  1146. ALTER TABLE RICALM.RQRMENT_BOOL_EXT ADD CONSTRAINT RQRBOOLEXT_FK2 FOREIGN KEY (REQUIREMENT_ATTRDEF_ID) REFERENCES RICALM.RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID)
  1147. GO
  1148.  
  1149. ALTER TABLE RICALM.RQRMENT_STRING_EXT ADD CONSTRAINT RQRSTREXT_FK1 FOREIGN KEY (REQUIREMENT_ID) REFERENCES RIODS.REQUIREMENT (REQUIREMENT_ID)
  1150. GO
  1151.  
  1152. ALTER TABLE RICALM.RQRMENT_STRING_EXT ADD CONSTRAINT RQRSTREXT_FK2 FOREIGN KEY (REQUIREMENT_ATTRDEF_ID) REFERENCES RICALM.RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID)
  1153. GO
  1154.  
  1155. ALTER TABLE RICALM.RQRMENT_TIMESTAMP_EXT ADD CONSTRAINT RQRTMPEXT_FK1 FOREIGN KEY (REQUIREMENT_ID) REFERENCES RIODS.REQUIREMENT (REQUIREMENT_ID)
  1156. GO
  1157.  
  1158. ALTER TABLE RICALM.RQRMENT_TIMESTAMP_EXT ADD CONSTRAINT RQRTMPEXT_FK2 FOREIGN KEY (REQUIREMENT_ATTRDEF_ID) REFERENCES RICALM.RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID)
  1159. GO
  1160.  
  1161. ALTER TABLE RICALM.RQRMENT_DATE_EXT ADD CONSTRAINT RQRDTEXT_FK1 FOREIGN KEY (REQUIREMENT_ID) REFERENCES RIODS.REQUIREMENT (REQUIREMENT_ID)
  1162. GO
  1163.  
  1164. ALTER TABLE RICALM.RQRMENT_DATE_EXT ADD CONSTRAINT RQRDTEXT_FK2 FOREIGN KEY (REQUIREMENT_ATTRDEF_ID) REFERENCES RICALM.RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID)
  1165. GO
  1166.  
  1167. ALTER TABLE RICALM.RQRMENT_STRING_L_EXT ADD CONSTRAINT RQRSTRLEXT_FK1 FOREIGN KEY (REQUIREMENT_ID) REFERENCES RIODS.REQUIREMENT (REQUIREMENT_ID)
  1168. GO
  1169.  
  1170. ALTER TABLE RICALM.RQRMENT_STRING_L_EXT ADD CONSTRAINT RQRSTRLEXT_FK2 FOREIGN KEY (REQUIREMENT_ATTRDEF_ID) REFERENCES RICALM.RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID)
  1171. GO
  1172.  
  1173. ALTER TABLE RICALM.RQRMENT_DECIMAL_EXT ADD CONSTRAINT RQRDECEXT_FK1 FOREIGN KEY (REQUIREMENT_ID) REFERENCES RIODS.REQUIREMENT (REQUIREMENT_ID)
  1174. GO
  1175.  
  1176. ALTER TABLE RICALM.RQRMENT_DECIMAL_EXT ADD CONSTRAINT RQRDECEXT_FK2 FOREIGN KEY (REQUIREMENT_ATTRDEF_ID) REFERENCES RICALM.RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID)
  1177. GO
  1178.  
  1179. ALTER TABLE RICALM.RQRMENT_HISTORY_INT_EXT ADD CONSTRAINT RQRHISINTEXT_FK1 FOREIGN KEY (REQUIREMENT_HISTORY_ID) REFERENCES RICALM.RQRMENT_HISTORY (REQUIREMENT_HISTORY_ID)
  1180. GO
  1181.  
  1182. ALTER TABLE RICALM.RQRMENT_HISTORY_INT_EXT ADD CONSTRAINT RQRHISINTEXT_FK2 FOREIGN KEY (REQUIREMENT_ATTRDEF_ID) REFERENCES RICALM.RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID)
  1183. GO
  1184.  
  1185. ALTER TABLE RICALM.RQRMENT_HISTORY_BOOL_EXT ADD CONSTRAINT RQRHISBOOLEXT_FK1 FOREIGN KEY (REQUIREMENT_HISTORY_ID) REFERENCES RICALM.RQRMENT_HISTORY (REQUIREMENT_HISTORY_ID)
  1186. GO
  1187.  
  1188. ALTER TABLE RICALM.RQRMENT_HISTORY_BOOL_EXT ADD CONSTRAINT RQRHISBOOLEXT_FK2 FOREIGN KEY (REQUIREMENT_ATTRDEF_ID) REFERENCES RICALM.RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID)
  1189. GO
  1190.  
  1191. ALTER TABLE RICALM.RQRMENT_HISTORY_STRING_EXT ADD CONSTRAINT RQRHISSTREXT_FK1 FOREIGN KEY (REQUIREMENT_HISTORY_ID) REFERENCES RICALM.RQRMENT_HISTORY (REQUIREMENT_HISTORY_ID)
  1192. GO
  1193.  
  1194. ALTER TABLE RICALM.RQRMENT_HISTORY_STRING_EXT ADD CONSTRAINT RQRHISSTREXT_FK2 FOREIGN KEY (REQUIREMENT_ATTRDEF_ID) REFERENCES RICALM.RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID)
  1195. GO
  1196.  
  1197. ALTER TABLE RICALM.RQRMENT_HISTORY_TIMESTAMP_EXT ADD CONSTRAINT RQRHISTMPEXT_FK1 FOREIGN KEY (REQUIREMENT_HISTORY_ID) REFERENCES RICALM.RQRMENT_HISTORY (REQUIREMENT_HISTORY_ID)
  1198. GO
  1199.  
  1200. ALTER TABLE RICALM.RQRMENT_HISTORY_TIMESTAMP_EXT ADD CONSTRAINT RQRHISTMPEXT_FK2 FOREIGN KEY (REQUIREMENT_ATTRDEF_ID) REFERENCES RICALM.RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID)
  1201. GO
  1202.  
  1203. ALTER TABLE RICALM.RQRMENT_HISTORY_STRING_L_EXT ADD CONSTRAINT RQRHISSTRLEXT_FK1 FOREIGN KEY (REQUIREMENT_HISTORY_ID) REFERENCES RICALM.RQRMENT_HISTORY (REQUIREMENT_HISTORY_ID)
  1204. GO
  1205.  
  1206. ALTER TABLE RICALM.RQRMENT_HISTORY_STRING_L_EXT ADD CONSTRAINT RQRHISSTRLEXT_FK2 FOREIGN KEY (REQUIREMENT_ATTRDEF_ID) REFERENCES RICALM.RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID)
  1207. GO
  1208.  
  1209. ALTER TABLE RICALM.RQRMENT_HISTORY_DECIMAL_EXT ADD CONSTRAINT RQRHISDECEXT_FK1 FOREIGN KEY (REQUIREMENT_HISTORY_ID) REFERENCES RICALM.RQRMENT_HISTORY (REQUIREMENT_HISTORY_ID)
  1210. GO
  1211.  
  1212. ALTER TABLE RICALM.RQRMENT_HISTORY_DECIMAL_EXT ADD CONSTRAINT RQRHISDECEXT_FK2 FOREIGN KEY (REQUIREMENT_ATTRDEF_ID) REFERENCES RICALM.RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID)
  1213. GO
  1214.  
  1215. ALTER TABLE RICALM.RQRMENT_ENUMERATION ADD CONSTRAINT RQRENUM_PK PRIMARY KEY (REQUIREMENT_ENUMERATION_ID) ON VNF_IDX
  1216. GO
  1217.  
  1218. ALTER TABLE RICALM.RQRMENT_ENUMERATION ADD CONSTRAINT RQRMENT_ENUMERATION_FK1 FOREIGN KEY (REQUIREMENT_ATTRDEF_ID) REFERENCES RICALM.RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID)
  1219. GO
  1220.  
  1221. ALTER TABLE RICALM.RQRMENT_ENUMERATION ADD CONSTRAINT RQRMENT_ENUMERATION_FK2 FOREIGN KEY (REQUIREMENT_ID) REFERENCES RIODS.REQUIREMENT (REQUIREMENT_ID)
  1222. GO
  1223.  
  1224. CREATE INDEX KEYWORD_IDX1 ON RICALM.KEYWORD (EXTERNAL_KEY2 ASC) ON VNF_IDX
  1225. GO
  1226.  
  1227. CREATE INDEX KEYWORD_IDX2 ON RICALM.KEYWORD (EXTERNAL_KEY1 ASC, SOURCE_ID ASC) ON VNF_IDX
  1228. GO
  1229.  
  1230. CREATE INDEX KEYWORD_IDX3 ON RICALM.KEYWORD (EXTERNAL_KEY2 ASC, SOURCE_ID ASC) ON VNF_IDX
  1231. GO
  1232.  
  1233. CREATE INDEX KEYWORD_IDX4 ON RICALM.KEYWORD (EXTERNAL_ID ASC) ON VNF_IDX
  1234. GO
  1235.  
  1236. CREATE INDEX KEYWORD_IDX5 ON RICALM.KEYWORD (EXTERNAL_ID ASC, PROJECT_ID ASC, SOURCE_ID ASC) ON VNF_IDX
  1237. GO
  1238.  
  1239. CREATE INDEX KEYWORD_IDX6 ON RICALM.KEYWORD (TITLE ASC, KEYWORD_CLASS_ID ASC) ON VNF_IDX
  1240. GO
  1241.  
  1242. CREATE INDEX KEYWORD_IDX7 ON RICALM.KEYWORD (ISSOFTDELETED ASC) ON VNF_IDX
  1243. GO
  1244.  
  1245. CREATE INDEX QOBJ_IDX1 ON RICALM.QUALITY_OBJECTIVE (EXTERNAL_KEY2 ASC) ON VNF_IDX
  1246. GO
  1247.  
  1248. CREATE INDEX QOBJ_IDX2 ON RICALM.QUALITY_OBJECTIVE (EXTERNAL_KEY1 ASC, SOURCE_ID ASC) ON VNF_IDX
  1249. GO
  1250.  
  1251. CREATE INDEX QOBJ_IDX3 ON RICALM.QUALITY_OBJECTIVE (EXTERNAL_KEY2 ASC, SOURCE_ID ASC) ON VNF_IDX
  1252. GO
  1253.  
  1254. CREATE INDEX QOBJ_IDX4 ON RICALM.QUALITY_OBJECTIVE (EXTERNAL_ID ASC) ON VNF_IDX
  1255. GO
  1256.  
  1257. CREATE INDEX QOBJ_IDX5 ON RICALM.QUALITY_OBJECTIVE (EXTERNAL_ID ASC, PROJECT_ID ASC, SOURCE_ID ASC) ON VNF_IDX
  1258. GO
  1259.  
  1260. CREATE INDEX QOBJ_IDX6 ON RICALM.QUALITY_OBJECTIVE (TITLE ASC, OBJECTIVE_CLASS_ID ASC) ON VNF_IDX
  1261. GO
  1262.  
  1263. CREATE INDEX QOBJ_IDX7 ON RICALM.QUALITY_OBJECTIVE (ISSOFTDELETED ASC) ON VNF_IDX
  1264. GO
  1265.  
  1266. CREATE INDEX TPOBJSTA_IDX1 ON RICALM.TESTPLAN_OBJECTIVESTATUS (TESTPLAN_ID ASC) ON VNF_IDX
  1267. GO
  1268.  
  1269. CREATE INDEX TPOBJSTA_IDX2 ON RICALM.TESTPLAN_OBJECTIVESTATUS (TESTPLAN_ID ASC, OBJECTIVE_ID ASC) ON VNF_IDX
  1270. GO
  1271.  
  1272. CREATE INDEX TPOBJSTA_IDX3 ON RICALM.TESTPLAN_OBJECTIVESTATUS (ISSOFTDELETED ASC) ON VNF_IDX
  1273. GO
  1274.  
  1275. CREATE INDEX LABREQ_IDX1 ON RICALM.LABREQUEST (EXTERNAL_KEY2 ASC) ON VNF_IDX
  1276. GO
  1277.  
  1278. CREATE INDEX LABREQ_IDX2 ON RICALM.LABREQUEST (EXTERNAL_KEY1 ASC, SOURCE_ID ASC) ON VNF_IDX
  1279. GO
  1280.  
  1281. CREATE INDEX LABREQ_IDX3 ON RICALM.LABREQUEST (EXTERNAL_KEY2 ASC, SOURCE_ID ASC) ON VNF_IDX
  1282. GO
  1283.  
  1284. CREATE INDEX LABREQ_IDX4 ON RICALM.LABREQUEST (EXTERNAL_ID ASC) ON VNF_IDX
  1285. GO
  1286.  
  1287. CREATE INDEX LABREQ_IDX5 ON RICALM.LABREQUEST (EXTERNAL_ID ASC, PROJECT_ID ASC, SOURCE_ID ASC) ON VNF_IDX
  1288. GO
  1289.  
  1290. CREATE INDEX LABREQ_IDX6 ON RICALM.LABREQUEST (VISIBLE_ID ASC) ON VNF_IDX
  1291. GO
  1292.  
  1293. CREATE INDEX LABREQ_IDX7 ON RICALM.LABREQUEST (PRIORITY ASC) ON VNF_IDX
  1294. GO
  1295.  
  1296. CREATE INDEX LABREQ_IDX8 ON RICALM.LABREQUEST (CURRENT_STATE ASC) ON VNF_IDX
  1297. GO
  1298.  
  1299. CREATE INDEX LABREQ_IDX9 ON RICALM.LABREQUEST (ISSOFTDELETED ASC) ON VNF_IDX
  1300. GO
  1301.  
  1302. CREATE INDEX REQCS_IDX1 ON RICALM.LABREQUEST_CHANGESTATE (LABREQUEST_ID ASC) ON VNF_IDX
  1303. GO
  1304.  
  1305. CREATE INDEX REQCS_IDX2 ON RICALM.LABREQUEST_CHANGESTATE (CHANGESTATE_ID ASC, LABREQUEST_ID ASC) ON VNF_IDX
  1306. GO
  1307.  
  1308. CREATE INDEX REQCS_IDX3 ON RICALM.LABREQUEST_CHANGESTATE (ISSOFTDELETED ASC) ON VNF_IDX
  1309. GO
  1310.  
  1311. CREATE INDEX TPSTREXT_IDX1 ON RICALM.TESTPLAN_STRING_EXT (TESTPLAN_ID ASC, NAME ASC) ON VNF_IDX
  1312. GO
  1313.  
  1314. CREATE INDEX TPSTREXT_IDX2 ON RICALM.TESTPLAN_STRING_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1315. GO
  1316.  
  1317. CREATE INDEX TPSTRMEXT_IDX1 ON RICALM.TESTPLAN_STRING_M_EXT (TESTPLAN_ID ASC, NAME ASC) ON VNF_IDX
  1318. GO
  1319.  
  1320. CREATE INDEX TPSTRMEXT_IDX2 ON RICALM.TESTPLAN_STRING_M_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1321. GO
  1322.  
  1323. CREATE INDEX TPINTEXT_IDX1 ON RICALM.TESTPLAN_INT_EXT (TESTPLAN_ID ASC, NAME ASC) ON VNF_IDX
  1324. GO
  1325.  
  1326. CREATE INDEX TPINTEXT_IDX2 ON RICALM.TESTPLAN_INT_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1327. GO
  1328.  
  1329. CREATE INDEX TPTIMEEXT_IDX1 ON RICALM.TESTPLAN_TIMESTAMP_EXT (TESTPLAN_ID ASC, NAME ASC) ON VNF_IDX
  1330. GO
  1331.  
  1332. CREATE INDEX TPTIMEEXT_IDX2 ON RICALM.TESTPLAN_TIMESTAMP_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1333. GO
  1334.  
  1335. CREATE INDEX TCSTREXT_IDX1 ON RICALM.TESTCASE_STRING_EXT (TESTCASE_ID ASC, NAME ASC) ON VNF_IDX
  1336. GO
  1337.  
  1338. CREATE INDEX TCSTREXT_IDX2 ON RICALM.TESTCASE_STRING_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1339. GO
  1340.  
  1341. CREATE INDEX TCSTRMEXT_IDX1 ON RICALM.TESTCASE_STRING_M_EXT (TESTCASE_ID ASC, NAME ASC) ON VNF_IDX
  1342. GO
  1343.  
  1344. CREATE INDEX TCSTRMEXT_IDX2 ON RICALM.TESTCASE_STRING_M_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1345. GO
  1346.  
  1347. CREATE INDEX TCINTEXT_IDX1 ON RICALM.TESTCASE_INT_EXT (TESTCASE_ID ASC, NAME ASC) ON VNF_IDX
  1348. GO
  1349.  
  1350. CREATE INDEX TCINTEXT_IDX2 ON RICALM.TESTCASE_INT_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1351. GO
  1352.  
  1353. CREATE INDEX TCTIMEEXT_IDX1 ON RICALM.TESTCASE_TIMESTAMP_EXT (TESTCASE_ID ASC, NAME ASC) ON VNF_IDX
  1354. GO
  1355.  
  1356. CREATE INDEX TCTIMEEXT_IDX2 ON RICALM.TESTCASE_TIMESTAMP_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1357. GO
  1358.  
  1359. CREATE INDEX TSCSTREXT_IDX1 ON RICALM.TESTSCRIPT_STRING_EXT (TESTSCRIPT_ID ASC, NAME ASC) ON VNF_IDX
  1360. GO
  1361.  
  1362. CREATE INDEX TSCSTREXT_IDX2 ON RICALM.TESTSCRIPT_STRING_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1363. GO
  1364.  
  1365. CREATE INDEX TSCSTRMEXT_IDX1 ON RICALM.TESTSCRIPT_STRING_M_EXT (TESTSCRIPT_ID ASC, NAME ASC) ON VNF_IDX
  1366. GO
  1367.  
  1368. CREATE INDEX TSCSTRMEXT_IDX2 ON RICALM.TESTSCRIPT_STRING_M_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1369. GO
  1370.  
  1371. CREATE INDEX TSCINTEXT_IDX1 ON RICALM.TESTSCRIPT_INT_EXT (TESTSCRIPT_ID ASC, NAME ASC) ON VNF_IDX
  1372. GO
  1373.  
  1374. CREATE INDEX TSCINTEXT_IDX2 ON RICALM.TESTSCRIPT_INT_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1375. GO
  1376.  
  1377. CREATE INDEX TSCTIMEEXT_IDX1 ON RICALM.TESTSCRIPT_TIMESTAMP_EXT (TESTSCRIPT_ID ASC, NAME ASC) ON VNF_IDX
  1378. GO
  1379.  
  1380. CREATE INDEX TSCTIMEEXT_IDX2 ON RICALM.TESTSCRIPT_TIMESTAMP_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1381. GO
  1382.  
  1383. CREATE INDEX TSUSTREXT_IDX1 ON RICALM.TESTSUITE_STRING_EXT (TESTSUITE_ID ASC, NAME ASC) ON VNF_IDX
  1384. GO
  1385.  
  1386. CREATE INDEX TSUSTREXT_IDX2 ON RICALM.TESTSUITE_STRING_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1387. GO
  1388.  
  1389. CREATE INDEX TSUSTRMEXT_IDX1 ON RICALM.TESTSUITE_STRING_M_EXT (TESTSUITE_ID ASC, NAME ASC) ON VNF_IDX
  1390. GO
  1391.  
  1392. CREATE INDEX TSUSTRMEXT_IDX2 ON RICALM.TESTSUITE_STRING_M_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1393. GO
  1394.  
  1395. CREATE INDEX TSUINTEXT_IDX1 ON RICALM.TESTSUITE_INT_EXT (TESTSUITE_ID ASC, NAME ASC) ON VNF_IDX
  1396. GO
  1397.  
  1398. CREATE INDEX TSUINTEXT_IDX2 ON RICALM.TESTSUITE_INT_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1399. GO
  1400.  
  1401. CREATE INDEX TSUTIMEEXT_IDX1 ON RICALM.TESTSUITE_TIMESTAMP_EXT (TESTSUITE_ID ASC, NAME ASC) ON VNF_IDX
  1402. GO
  1403.  
  1404. CREATE INDEX TSUTIMEEXT_IDX2 ON RICALM.TESTSUITE_TIMESTAMP_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1405. GO
  1406.  
  1407. CREATE INDEX EWISTREXT_IDX1 ON RICALM.EXECWORKITEM_STRING_EXT (EXECWORKITEM_ID ASC, NAME ASC) ON VNF_IDX
  1408. GO
  1409.  
  1410. CREATE INDEX EWISTREXT_IDX2 ON RICALM.EXECWORKITEM_STRING_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1411. GO
  1412.  
  1413. CREATE INDEX EWISTRMEXT_IDX1 ON RICALM.EXECWORKITEM_STRING_M_EXT (EXECWORKITEM_ID ASC, NAME ASC) ON VNF_IDX
  1414. GO
  1415.  
  1416. CREATE INDEX EWISTRMEXT_IDX2 ON RICALM.EXECWORKITEM_STRING_M_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1417. GO
  1418.  
  1419. CREATE INDEX EWIINTEXT_IDX1 ON RICALM.EXECWORKITEM_INT_EXT (EXECWORKITEM_ID ASC, NAME ASC) ON VNF_IDX
  1420. GO
  1421.  
  1422. CREATE INDEX EWIINTEXT_IDX2 ON RICALM.EXECWORKITEM_INT_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1423. GO
  1424.  
  1425. CREATE INDEX EWITIMEEXT_IDX1 ON RICALM.EXECWORKITEM_TIMESTAMP_EXT (EXECWORKITEM_ID ASC, NAME ASC) ON VNF_IDX
  1426. GO
  1427.  
  1428. CREATE INDEX EWITIMEEXT_IDX2 ON RICALM.EXECWORKITEM_TIMESTAMP_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1429. GO
  1430.  
  1431. CREATE INDEX TSERSTREXT_IDX1 ON RICALM.TSTSUITEXECREC_STRING_EXT (TESTSUITE_EXECRECORD_ID ASC, NAME ASC) ON VNF_IDX
  1432. GO
  1433.  
  1434. CREATE INDEX TSERSTREXT_IDX2 ON RICALM.TSTSUITEXECREC_STRING_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1435. GO
  1436.  
  1437. CREATE INDEX TSERSTRMEXT_IDX1 ON RICALM.TSTSUITEXECREC_STRING_M_EXT (TESTSUITE_EXECRECORD_ID ASC, NAME ASC) ON VNF_IDX
  1438. GO
  1439.  
  1440. CREATE INDEX TSERSTRMEXT_IDX2 ON RICALM.TSTSUITEXECREC_STRING_M_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1441. GO
  1442.  
  1443. CREATE INDEX TSERINTEXT_IDX1 ON RICALM.TSTSUITEXECREC_INT_EXT (TESTSUITE_EXECRECORD_ID ASC, NAME ASC) ON VNF_IDX
  1444. GO
  1445.  
  1446. CREATE INDEX TSERINTEXT_IDX2 ON RICALM.TSTSUITEXECREC_INT_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1447. GO
  1448.  
  1449. CREATE INDEX TSERTIMEEXT_IDX1 ON RICALM.TSTSUITEXECREC_TIMESTAMP_EXT (TESTSUITE_EXECRECORD_ID ASC, NAME ASC) ON VNF_IDX
  1450. GO
  1451.  
  1452. CREATE INDEX TSERTIMEEXT_IDX2 ON RICALM.TSTSUITEXECREC_TIMESTAMP_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1453. GO
  1454.  
  1455. CREATE INDEX EXCRESSTREXT_IDX1 ON RICALM.EXECRES_STRING_EXT (EXECUTION_RESULT_ID ASC, NAME ASC) ON VNF_IDX
  1456. GO
  1457.  
  1458. CREATE INDEX EXCRESSTREXT_IDX2 ON RICALM.EXECRES_STRING_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1459. GO
  1460.  
  1461. CREATE INDEX EXCRESSTRMEXT_IDX1 ON RICALM.EXECRES_STRING_M_EXT (EXECUTION_RESULT_ID ASC, NAME ASC) ON VNF_IDX
  1462. GO
  1463.  
  1464. CREATE INDEX EXCRESSTRMEXT_IDX2 ON RICALM.EXECRES_STRING_M_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1465. GO
  1466.  
  1467. CREATE INDEX EXCRESINTEXT_IDX1 ON RICALM.EXECRES_INT_EXT (EXECUTION_RESULT_ID ASC, NAME ASC) ON VNF_IDX
  1468. GO
  1469.  
  1470. CREATE INDEX EXCRESINTEXT_IDX2 ON RICALM.EXECRES_INT_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1471. GO
  1472.  
  1473. CREATE INDEX EXCRESTIMEEXT_IDX1 ON RICALM.EXECRES_TIMESTAMP_EXT (EXECUTION_RESULT_ID ASC, NAME ASC) ON VNF_IDX
  1474. GO
  1475.  
  1476. CREATE INDEX EXCRESTIMEEXT_IDX2 ON RICALM.EXECRES_TIMESTAMP_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1477. GO
  1478.  
  1479. CREATE INDEX TSULOGSTREXT_IDX1 ON RICALM.TESTSUITELOG_STRING_EXT (TESTSUITELOG_ID ASC, NAME ASC) ON VNF_IDX
  1480. GO
  1481.  
  1482. CREATE INDEX TSULOGSTREXT_IDX2 ON RICALM.TESTSUITELOG_STRING_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1483. GO
  1484.  
  1485. CREATE INDEX TSULOGSTRMEXT_IDX1 ON RICALM.TESTSUITELOG_STRING_M_EXT (TESTSUITELOG_ID ASC, NAME ASC) ON VNF_IDX
  1486. GO
  1487.  
  1488. CREATE INDEX TSULOGSTRMEXT_IDX2 ON RICALM.TESTSUITELOG_STRING_M_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1489. GO
  1490.  
  1491. CREATE INDEX TSULOGINTEXT_IDX1 ON RICALM.TESTSUITELOG_INT_EXT (TESTSUITELOG_ID ASC, NAME ASC) ON VNF_IDX
  1492. GO
  1493.  
  1494. CREATE INDEX TSULOGINTEXT_IDX2 ON RICALM.TESTSUITELOG_INT_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1495. GO
  1496.  
  1497. CREATE INDEX TSULOGTIMEEXT_IDX1 ON RICALM.TESTSUITELOG_TIMESTAMP_EXT (TESTSUITELOG_ID ASC, NAME ASC) ON VNF_IDX
  1498. GO
  1499.  
  1500. CREATE INDEX TSULOGTIMEEXT_IDX2 ON RICALM.TESTSUITELOG_TIMESTAMP_EXT (ISSOFTDELETED ASC) ON VNF_IDX
  1501. GO
  1502.  
  1503. CREATE INDEX ITERDET_IDX1 ON RICALM.ITERATION_EXEC_DETAIL (ITERATION_ID ASC) ON VNF_IDX
  1504. GO
  1505.  
  1506. CREATE INDEX ITERDET_IDX2 ON RICALM.ITERATION_EXEC_DETAIL (ISSOFTDELETED ASC) ON VNF_IDX
  1507. GO
  1508.  
  1509. ALTER TABLE RICALM.KEYWORD ADD CONSTRAINT KEYWORD_PK PRIMARY KEY (KEYWORD_ID) ON VNF_IDX
  1510. GO
  1511.  
  1512. ALTER TABLE RICALM.KEYWORD_CLASSIFICATION ADD CONSTRAINT KWCLASS_PK PRIMARY KEY (KEYWORD_CLASS_ID) ON VNF_IDX
  1513. GO
  1514.  
  1515. ALTER TABLE RICALM.KEYWORD_SCRIPT_LOOKUP ADD CONSTRAINT KWSCRIPT_PK PRIMARY KEY (KEYWORD_ID, TESTSCRIPT_ID) ON VNF_IDX
  1516. GO
  1517.  
  1518. ALTER TABLE RICALM.QUALITY_OBJECTIVE ADD CONSTRAINT QOBJ_PK PRIMARY KEY (OBJECTIVE_ID) ON VNF_IDX
  1519. GO
  1520.  
  1521. ALTER TABLE RICALM.OBJECTIVE_CLASSIFICATION ADD CONSTRAINT QOBJCLASS_PK PRIMARY KEY (OBJECTIVE_CLASS_ID) ON VNF_IDX
  1522. GO
  1523.  
  1524. ALTER TABLE RICALM.TESTPLAN_OBJECTIVESTATUS ADD CONSTRAINT TPOBJSTA_PK PRIMARY KEY (TESTPLAN_OBJECTIVESTATUS_ID) ON VNF_IDX
  1525. GO
  1526.  
  1527. ALTER TABLE RICALM.TESTPLAN_OBJECTIVE_LOOKUP ADD CONSTRAINT TPOBJ_PK PRIMARY KEY (TESTPLAN_ID, OBJECTIVE_ID) ON VNF_IDX
  1528. GO
  1529.  
  1530. ALTER TABLE RICALM.LABREQUEST ADD CONSTRAINT LABREQ_PK PRIMARY KEY (LABREQUEST_ID) ON VNF_IDX
  1531. GO
  1532.  
  1533. ALTER TABLE RICALM.LABREQUEST_CLASSIFICATION ADD CONSTRAINT REQCLASS_PK PRIMARY KEY (LABREQUEST_CLASS_ID) ON VNF_IDX
  1534. GO
  1535.  
  1536. ALTER TABLE RICALM.LABREQUEST_CHANGESTATE ADD CONSTRAINT REQCS_PK PRIMARY KEY (CHANGESTATE_ID) ON VNF_IDX
  1537. GO
  1538.  
  1539. ALTER TABLE RICALM.RESERVATION_LABREQUEST_LOOKUP ADD CONSTRAINT RESVREQ_PK PRIMARY KEY (RESERVATION_ID, LABREQUEST_ID) ON VNF_IDX
  1540. GO
  1541.  
  1542. ALTER TABLE RICALM.TESTPLAN_STRING_EXT ADD CONSTRAINT TPSTREXT_PK PRIMARY KEY (TESTPLAN_ID, IDENTIFIER) ON VNF_IDX
  1543. GO
  1544.  
  1545. ALTER TABLE RICALM.TESTPLAN_STRING_M_EXT ADD CONSTRAINT TPSTRMEXT_PK PRIMARY KEY (TESTPLAN_ID, IDENTIFIER) ON VNF_IDX
  1546. GO
  1547.  
  1548. ALTER TABLE RICALM.TESTPLAN_INT_EXT ADD CONSTRAINT TPINTEXT_PK PRIMARY KEY (TESTPLAN_ID, IDENTIFIER) ON VNF_IDX
  1549. GO
  1550.  
  1551. ALTER TABLE RICALM.TESTPLAN_TIMESTAMP_EXT ADD CONSTRAINT TPTIMEEXT_PK PRIMARY KEY (TESTPLAN_ID, IDENTIFIER) ON VNF_IDX
  1552. GO
  1553.  
  1554. ALTER TABLE RICALM.TESTCASE_STRING_EXT ADD CONSTRAINT TCSTREXT_PK PRIMARY KEY (TESTCASE_ID, IDENTIFIER) ON VNF_IDX
  1555. GO
  1556.  
  1557. ALTER TABLE RICALM.TESTCASE_STRING_M_EXT ADD CONSTRAINT TCSTRMEXT_PK PRIMARY KEY (TESTCASE_ID, IDENTIFIER) ON VNF_IDX
  1558. GO
  1559.  
  1560. ALTER TABLE RICALM.TESTCASE_INT_EXT ADD CONSTRAINT TCINTEXT_PK PRIMARY KEY (TESTCASE_ID, IDENTIFIER) ON VNF_IDX
  1561. GO
  1562.  
  1563. ALTER TABLE RICALM.TESTCASE_TIMESTAMP_EXT ADD CONSTRAINT TCTIMEEXT_PK PRIMARY KEY (TESTCASE_ID, IDENTIFIER) ON VNF_IDX
  1564. GO
  1565.  
  1566. ALTER TABLE RICALM.TESTSCRIPT_STRING_EXT ADD CONSTRAINT TSCSTREXT_PK PRIMARY KEY (TESTSCRIPT_ID, IDENTIFIER) ON VNF_IDX
  1567. GO
  1568.  
  1569. ALTER TABLE RICALM.TESTSCRIPT_STRING_M_EXT ADD CONSTRAINT TSCSTRMEXT_PK PRIMARY KEY (TESTSCRIPT_ID, IDENTIFIER) ON VNF_IDX
  1570. GO
  1571.  
  1572. ALTER TABLE RICALM.TESTSCRIPT_INT_EXT ADD CONSTRAINT TSCINTEXT_PK PRIMARY KEY (TESTSCRIPT_ID, IDENTIFIER) ON VNF_IDX
  1573. GO
  1574.  
  1575. ALTER TABLE RICALM.TESTSCRIPT_TIMESTAMP_EXT ADD CONSTRAINT TSCTIMEEXT_PK PRIMARY KEY (TESTSCRIPT_ID, IDENTIFIER) ON VNF_IDX
  1576. GO
  1577.  
  1578. ALTER TABLE RICALM.TESTSUITE_STRING_EXT ADD CONSTRAINT TSUSTREXT_PK PRIMARY KEY (TESTSUITE_ID, IDENTIFIER) ON VNF_IDX
  1579. GO
  1580.  
  1581. ALTER TABLE RICALM.TESTSUITE_STRING_M_EXT ADD CONSTRAINT TSUSTRMEXT_PK PRIMARY KEY (TESTSUITE_ID, IDENTIFIER) ON VNF_IDX
  1582. GO
  1583.  
  1584. ALTER TABLE RICALM.TESTSUITE_INT_EXT ADD CONSTRAINT TSUINTEXT_PK PRIMARY KEY (TESTSUITE_ID, IDENTIFIER) ON VNF_IDX
  1585. GO
  1586.  
  1587. ALTER TABLE RICALM.TESTSUITE_TIMESTAMP_EXT ADD CONSTRAINT TSUTIMEEXT_PK PRIMARY KEY (TESTSUITE_ID, IDENTIFIER) ON VNF_IDX
  1588. GO
  1589.  
  1590. ALTER TABLE RICALM.EXECWORKITEM_STRING_EXT ADD CONSTRAINT EWISTREXT_PK PRIMARY KEY (EXECWORKITEM_ID, IDENTIFIER) ON VNF_IDX
  1591. GO
  1592.  
  1593. ALTER TABLE RICALM.EXECWORKITEM_STRING_M_EXT ADD CONSTRAINT EWISTRMEXT_PK PRIMARY KEY (EXECWORKITEM_ID, IDENTIFIER) ON VNF_IDX
  1594. GO
  1595.  
  1596. ALTER TABLE RICALM.EXECWORKITEM_INT_EXT ADD CONSTRAINT EWIINTEXT_PK PRIMARY KEY (EXECWORKITEM_ID, IDENTIFIER) ON VNF_IDX
  1597. GO
  1598.  
  1599. ALTER TABLE RICALM.EXECWORKITEM_TIMESTAMP_EXT ADD CONSTRAINT EWITIMEEXT_PK PRIMARY KEY (EXECWORKITEM_ID, IDENTIFIER) ON VNF_IDX
  1600. GO
  1601.  
  1602. ALTER TABLE RICALM.TSTSUITEXECREC_STRING_EXT ADD CONSTRAINT TSERSTREXT_PK PRIMARY KEY (TESTSUITE_EXECRECORD_ID, IDENTIFIER) ON VNF_IDX
  1603. GO
  1604.  
  1605. ALTER TABLE RICALM.TSTSUITEXECREC_STRING_M_EXT ADD CONSTRAINT TSERSTRMEXT_PK PRIMARY KEY (TESTSUITE_EXECRECORD_ID, IDENTIFIER) ON VNF_IDX
  1606. GO
  1607.  
  1608. ALTER TABLE RICALM.TSTSUITEXECREC_INT_EXT ADD CONSTRAINT TSERINTEXT_PK PRIMARY KEY (TESTSUITE_EXECRECORD_ID, IDENTIFIER) ON VNF_IDX
  1609. GO
  1610.  
  1611. ALTER TABLE RICALM.TSTSUITEXECREC_TIMESTAMP_EXT ADD CONSTRAINT TSERTIMEEXT_PK PRIMARY KEY (TESTSUITE_EXECRECORD_ID, IDENTIFIER) ON VNF_IDX
  1612. GO
  1613.  
  1614. ALTER TABLE RICALM.EXECRES_STRING_EXT ADD CONSTRAINT EXCRESSTREXT_PK PRIMARY KEY (EXECUTION_RESULT_ID, IDENTIFIER) ON VNF_IDX
  1615. GO
  1616.  
  1617. ALTER TABLE RICALM.EXECRES_STRING_M_EXT ADD CONSTRAINT EXCRESSTRMEXT_PK PRIMARY KEY (EXECUTION_RESULT_ID, IDENTIFIER) ON VNF_IDX
  1618. GO
  1619.  
  1620. ALTER TABLE RICALM.EXECRES_INT_EXT ADD CONSTRAINT EXCRESINTEXT_PK PRIMARY KEY (EXECUTION_RESULT_ID, IDENTIFIER) ON VNF_IDX
  1621. GO
  1622.  
  1623. ALTER TABLE RICALM.EXECRES_TIMESTAMP_EXT ADD CONSTRAINT EXCRESTIMEEXT_PK PRIMARY KEY (EXECUTION_RESULT_ID, IDENTIFIER) ON VNF_IDX
  1624. GO
  1625.  
  1626. ALTER TABLE RICALM.TESTSUITELOG_STRING_EXT ADD CONSTRAINT TSULOGSTREXT_PK PRIMARY KEY (TESTSUITELOG_ID, IDENTIFIER) ON VNF_IDX
  1627. GO
  1628.  
  1629. ALTER TABLE RICALM.TESTSUITELOG_STRING_M_EXT ADD CONSTRAINT TSULOGSTRMEXT_PK PRIMARY KEY (TESTSUITELOG_ID, IDENTIFIER) ON VNF_IDX
  1630. GO
  1631.  
  1632. ALTER TABLE RICALM.TESTSUITELOG_INT_EXT ADD CONSTRAINT TSULOGINTEXT_PK PRIMARY KEY (TESTSUITELOG_ID, IDENTIFIER) ON VNF_IDX
  1633. GO
  1634.  
  1635. ALTER TABLE RICALM.TESTSUITELOG_TIMESTAMP_EXT ADD CONSTRAINT TSULOGTIMEEXT_PK PRIMARY KEY (TESTSUITELOG_ID, IDENTIFIER) ON VNF_IDX
  1636. GO
  1637.  
  1638. ALTER TABLE RICALM.ITERATION_EXEC_DETAIL ADD CONSTRAINT ITERDET_PK PRIMARY KEY (ITER_EXEC_DETAIL_ID) ON VNF_IDX
  1639. GO
  1640.  
  1641. ALTER TABLE RICALM.KEYWORD ADD CONSTRAINT KEYWORD_FK1 FOREIGN KEY (PROJECT_ID) REFERENCES RIODS.PROJECT (PROJECT_ID)
  1642. GO
  1643.  
  1644. ALTER TABLE RICALM.KEYWORD ADD CONSTRAINT KEYWORD_FK2 FOREIGN KEY (KEYWORD_CLASS_ID) REFERENCES RICALM.KEYWORD_CLASSIFICATION (KEYWORD_CLASS_ID)
  1645. GO
  1646.  
  1647. ALTER TABLE RICALM.KEYWORD ADD CONSTRAINT KEYWORD_FK3 FOREIGN KEY (DEFAULT_SCRIPT_ID) REFERENCES RIODS.TESTSCRIPT (TESTSCRIPT_ID)
  1648. GO
  1649.  
  1650. ALTER TABLE RICALM.KEYWORD_SCRIPT_LOOKUP ADD CONSTRAINT KWSCRIPT_FK1 FOREIGN KEY (KEYWORD_ID) REFERENCES RICALM.KEYWORD (KEYWORD_ID)
  1651. GO
  1652.  
  1653. ALTER TABLE RICALM.KEYWORD_SCRIPT_LOOKUP ADD CONSTRAINT KWSCRIPT_FK2 FOREIGN KEY (TESTSCRIPT_ID) REFERENCES RIODS.TESTSCRIPT (TESTSCRIPT_ID)
  1654. GO
  1655.  
  1656. ALTER TABLE RICALM.QUALITY_OBJECTIVE ADD CONSTRAINT QOBJ_FK1 FOREIGN KEY (PROJECT_ID) REFERENCES RIODS.PROJECT (PROJECT_ID)
  1657. GO
  1658.  
  1659. ALTER TABLE RICALM.QUALITY_OBJECTIVE ADD CONSTRAINT QOBJ_FK2 FOREIGN KEY (CREATOR_ID) REFERENCES RIODS.RESOURCE (RESOURCE_ID)
  1660. GO
  1661.  
  1662. ALTER TABLE RICALM.QUALITY_OBJECTIVE ADD CONSTRAINT QOBJ_FK3 FOREIGN KEY (OBJECTIVE_CLASS_ID) REFERENCES RICALM.OBJECTIVE_CLASSIFICATION (OBJECTIVE_CLASS_ID)
  1663. GO
  1664.  
  1665. ALTER TABLE RICALM.TESTPLAN_OBJECTIVESTATUS ADD CONSTRAINT TPOBJSTA_FK1 FOREIGN KEY (TESTPLAN_ID) REFERENCES RIODS.TESTPLAN (TESTPLAN_ID) ON DELETE CASCADE
  1666. GO
  1667.  
  1668. ALTER TABLE RICALM.TESTPLAN_OBJECTIVESTATUS ADD CONSTRAINT TPOBJSTA_FK2 FOREIGN KEY (OBJECTIVE_ID) REFERENCES RICALM.QUALITY_OBJECTIVE (OBJECTIVE_ID)
  1669. GO
  1670.  
  1671. ALTER TABLE RICALM.TESTPLAN_OBJECTIVE_LOOKUP ADD CONSTRAINT TPOBJ_FK1 FOREIGN KEY (TESTPLAN_ID) REFERENCES RIODS.TESTPLAN (TESTPLAN_ID)
  1672. GO
  1673.  
  1674. ALTER TABLE RICALM.TESTPLAN_OBJECTIVE_LOOKUP ADD CONSTRAINT TPOBJ_FK2 FOREIGN KEY (OBJECTIVE_ID) REFERENCES RICALM.QUALITY_OBJECTIVE (OBJECTIVE_ID)
  1675. GO
  1676.  
  1677. ALTER TABLE RICALM.LABREQUEST ADD CONSTRAINT LABREQ_FK1 FOREIGN KEY (PROJECT_ID) REFERENCES RIODS.PROJECT (PROJECT_ID)
  1678. GO
  1679.  
  1680. ALTER TABLE RICALM.LABREQUEST ADD CONSTRAINT LABREQ_FK2 FOREIGN KEY (REQUESTER_ID) REFERENCES RIODS.RESOURCE (RESOURCE_ID)
  1681. GO
  1682.  
  1683. ALTER TABLE RICALM.LABREQUEST ADD CONSTRAINT LABREQ_FK3 FOREIGN KEY (FULFILLER_ID) REFERENCES RIODS.RESOURCE (RESOURCE_ID)
  1684. GO
  1685.  
  1686. ALTER TABLE RICALM.LABREQUEST ADD CONSTRAINT LABREQ_FK4 FOREIGN KEY (LABREQUEST_CLASS_ID) REFERENCES RICALM.LABREQUEST_CLASSIFICATION (LABREQUEST_CLASS_ID)
  1687. GO
  1688.  
  1689. ALTER TABLE RICALM.LABREQUEST_CHANGESTATE ADD CONSTRAINT REQCS_FK1 FOREIGN KEY (LABREQUEST_ID) REFERENCES RICALM.LABREQUEST (LABREQUEST_ID) ON DELETE CASCADE
  1690. GO
  1691.  
  1692. ALTER TABLE RICALM.LABREQUEST_CHANGESTATE ADD CONSTRAINT REQCS_FK2 FOREIGN KEY (USER_ID) REFERENCES RIODS.RESOURCE (RESOURCE_ID)
  1693. GO
  1694.  
  1695. ALTER TABLE RICALM.RESERVATION_LABREQUEST_LOOKUP ADD CONSTRAINT RESVREQ_FK1 FOREIGN KEY (RESERVATION_ID) REFERENCES RIODS.RESERVATION (RESERVATION_ID)
  1696. GO
  1697.  
  1698. ALTER TABLE RICALM.RESERVATION_LABREQUEST_LOOKUP ADD CONSTRAINT RESVREQ_FK2 FOREIGN KEY (LABREQUEST_ID) REFERENCES RICALM.LABREQUEST (LABREQUEST_ID)
  1699. GO
  1700.  
  1701. ALTER TABLE RICALM.TESTPLAN_STRING_EXT ADD CONSTRAINT TPSTREXT_FK1 FOREIGN KEY (TESTPLAN_ID) REFERENCES RIODS.TESTPLAN (TESTPLAN_ID) ON DELETE CASCADE
  1702. GO
  1703.  
  1704. ALTER TABLE RICALM.TESTPLAN_STRING_M_EXT ADD CONSTRAINT TPSTRMEXT_FK1 FOREIGN KEY (TESTPLAN_ID) REFERENCES RIODS.TESTPLAN (TESTPLAN_ID) ON DELETE CASCADE
  1705. GO
  1706.  
  1707. ALTER TABLE RICALM.TESTPLAN_INT_EXT ADD CONSTRAINT TPINTEXT_FK1 FOREIGN KEY (TESTPLAN_ID) REFERENCES RIODS.TESTPLAN (TESTPLAN_ID) ON DELETE CASCADE
  1708. GO
  1709.  
  1710. ALTER TABLE RICALM.TESTPLAN_TIMESTAMP_EXT ADD CONSTRAINT TPTIMEEXT_FK1 FOREIGN KEY (TESTPLAN_ID) REFERENCES RIODS.TESTPLAN (TESTPLAN_ID) ON DELETE CASCADE
  1711. GO
  1712.  
  1713. ALTER TABLE RICALM.TESTCASE_STRING_EXT ADD CONSTRAINT TCSTREXT_FK1 FOREIGN KEY (TESTCASE_ID) REFERENCES RIODS.TESTCASE (TESTCASE_ID) ON DELETE CASCADE
  1714. GO
  1715.  
  1716. ALTER TABLE RICALM.TESTCASE_STRING_M_EXT ADD CONSTRAINT TCSTRMEXT_FK1 FOREIGN KEY (TESTCASE_ID) REFERENCES RIODS.TESTCASE (TESTCASE_ID) ON DELETE CASCADE
  1717. GO
  1718.  
  1719. ALTER TABLE RICALM.TESTCASE_INT_EXT ADD CONSTRAINT TCINTEXT_FK1 FOREIGN KEY (TESTCASE_ID) REFERENCES RIODS.TESTCASE (TESTCASE_ID) ON DELETE CASCADE
  1720. GO
  1721.  
  1722. ALTER TABLE RICALM.TESTCASE_TIMESTAMP_EXT ADD CONSTRAINT TCTIMEEXT_FK1 FOREIGN KEY (TESTCASE_ID) REFERENCES RIODS.TESTCASE (TESTCASE_ID) ON DELETE CASCADE
  1723. GO
  1724.  
  1725. ALTER TABLE RICALM.TESTSCRIPT_STRING_EXT ADD CONSTRAINT TSCSTREXT_FK1 FOREIGN KEY (TESTSCRIPT_ID) REFERENCES RIODS.TESTSCRIPT (TESTSCRIPT_ID) ON DELETE CASCADE
  1726. GO
  1727.  
  1728. ALTER TABLE RICALM.TESTSCRIPT_STRING_M_EXT ADD CONSTRAINT TSCSTRMEXT_FK1 FOREIGN KEY (TESTSCRIPT_ID) REFERENCES RIODS.TESTSCRIPT (TESTSCRIPT_ID) ON DELETE CASCADE
  1729. GO
  1730.  
  1731. ALTER TABLE RICALM.TESTSCRIPT_INT_EXT ADD CONSTRAINT TSCINTEXT_FK1 FOREIGN KEY (TESTSCRIPT_ID) REFERENCES RIODS.TESTSCRIPT (TESTSCRIPT_ID) ON DELETE CASCADE
  1732. GO
  1733.  
  1734. ALTER TABLE RICALM.TESTSCRIPT_TIMESTAMP_EXT ADD CONSTRAINT TSCTIMEEXT_FK1 FOREIGN KEY (TESTSCRIPT_ID) REFERENCES RIODS.TESTSCRIPT (TESTSCRIPT_ID) ON DELETE CASCADE
  1735. GO
  1736.  
  1737. ALTER TABLE RICALM.TESTSUITE_STRING_EXT ADD CONSTRAINT TSUSTREXT_FK1 FOREIGN KEY (TESTSUITE_ID) REFERENCES RIODS.TESTSUITE (TESTSUITE_ID) ON DELETE CASCADE
  1738. GO
  1739.  
  1740. ALTER TABLE RICALM.TESTSUITE_STRING_M_EXT ADD CONSTRAINT TSUSTRMEXT_FK1 FOREIGN KEY (TESTSUITE_ID) REFERENCES RIODS.TESTSUITE (TESTSUITE_ID) ON DELETE CASCADE
  1741. GO
  1742.  
  1743. ALTER TABLE RICALM.TESTSUITE_INT_EXT ADD CONSTRAINT TSUINTEXT_FK1 FOREIGN KEY (TESTSUITE_ID) REFERENCES RIODS.TESTSUITE (TESTSUITE_ID) ON DELETE CASCADE
  1744. GO
  1745.  
  1746. ALTER TABLE RICALM.TESTSUITE_TIMESTAMP_EXT ADD CONSTRAINT TSUTIMEEXT_FK1 FOREIGN KEY (TESTSUITE_ID) REFERENCES RIODS.TESTSUITE (TESTSUITE_ID) ON DELETE CASCADE
  1747. GO
  1748.  
  1749. ALTER TABLE RICALM.EXECWORKITEM_STRING_EXT ADD CONSTRAINT EWISTREXT_FK1 FOREIGN KEY (EXECWORKITEM_ID) REFERENCES RIODS.EXECUTION_WORKITEM (EXECWORKITEM_ID) ON DELETE CASCADE
  1750. GO
  1751.  
  1752. ALTER TABLE RICALM.EXECWORKITEM_STRING_M_EXT ADD CONSTRAINT EWISTRMEXT_FK1 FOREIGN KEY (EXECWORKITEM_ID) REFERENCES RIODS.EXECUTION_WORKITEM (EXECWORKITEM_ID) ON DELETE CASCADE
  1753. GO
  1754.  
  1755. ALTER TABLE RICALM.EXECWORKITEM_INT_EXT ADD CONSTRAINT EWIINTEXT_FK1 FOREIGN KEY (EXECWORKITEM_ID) REFERENCES RIODS.EXECUTION_WORKITEM (EXECWORKITEM_ID) ON DELETE CASCADE
  1756. GO
  1757.  
  1758. ALTER TABLE RICALM.EXECWORKITEM_TIMESTAMP_EXT ADD CONSTRAINT EWITIMEEXT_FK1 FOREIGN KEY (EXECWORKITEM_ID) REFERENCES RIODS.EXECUTION_WORKITEM (EXECWORKITEM_ID) ON DELETE CASCADE
  1759. GO
  1760.  
  1761. ALTER TABLE RICALM.TSTSUITEXECREC_STRING_EXT ADD CONSTRAINT TSERSTREXT_FK1 FOREIGN KEY (TESTSUITE_EXECRECORD_ID) REFERENCES RIODS.TESTSUITE_EXECUTION_RECORD (TESTSUITE_EXECRECORD_ID) ON DELETE CASCADE
  1762. GO
  1763.  
  1764. ALTER TABLE RICALM.TSTSUITEXECREC_STRING_M_EXT ADD CONSTRAINT TSERSTRMEXT_FK1 FOREIGN KEY (TESTSUITE_EXECRECORD_ID) REFERENCES RIODS.TESTSUITE_EXECUTION_RECORD (TESTSUITE_EXECRECORD_ID) ON DELETE CASCADE
  1765. GO
  1766.  
  1767. ALTER TABLE RICALM.TSTSUITEXECREC_INT_EXT ADD CONSTRAINT TSERINTEXT_FK1 FOREIGN KEY (TESTSUITE_EXECRECORD_ID) REFERENCES RIODS.TESTSUITE_EXECUTION_RECORD (TESTSUITE_EXECRECORD_ID) ON DELETE CASCADE
  1768. GO
  1769.  
  1770. ALTER TABLE RICALM.TSTSUITEXECREC_TIMESTAMP_EXT ADD CONSTRAINT TSERTIMEEXT_FK1 FOREIGN KEY (TESTSUITE_EXECRECORD_ID) REFERENCES RIODS.TESTSUITE_EXECUTION_RECORD (TESTSUITE_EXECRECORD_ID) ON DELETE CASCADE
  1771. GO
  1772.  
  1773. ALTER TABLE RICALM.EXECRES_STRING_EXT ADD CONSTRAINT EXCRESSTREXT_FK1 FOREIGN KEY (EXECUTION_RESULT_ID) REFERENCES RIODS.EXECUTION_RESULT (EXECUTION_RESULT_ID) ON DELETE CASCADE
  1774. GO
  1775.  
  1776. ALTER TABLE RICALM.EXECRES_STRING_M_EXT ADD CONSTRAINT EXCRESSTRMEXT_FK1 FOREIGN KEY (EXECUTION_RESULT_ID) REFERENCES RIODS.EXECUTION_RESULT (EXECUTION_RESULT_ID) ON DELETE CASCADE
  1777. GO
  1778.  
  1779. ALTER TABLE RICALM.EXECRES_INT_EXT ADD CONSTRAINT EXCRESINTEXT_FK1 FOREIGN KEY (EXECUTION_RESULT_ID) REFERENCES RIODS.EXECUTION_RESULT (EXECUTION_RESULT_ID) ON DELETE CASCADE
  1780. GO
  1781.  
  1782. ALTER TABLE RICALM.EXECRES_TIMESTAMP_EXT ADD CONSTRAINT EXCRESTIMEEXT_FK1 FOREIGN KEY (EXECUTION_RESULT_ID) REFERENCES RIODS.EXECUTION_RESULT (EXECUTION_RESULT_ID) ON DELETE CASCADE
  1783. GO
  1784.  
  1785. ALTER TABLE RICALM.TESTSUITELOG_STRING_EXT ADD CONSTRAINT TSULOGSTREXT_FK1 FOREIGN KEY (TESTSUITELOG_ID) REFERENCES RIODS.TESTSUITELOG (TESTSUITELOG_ID) ON DELETE CASCADE
  1786. GO
  1787.  
  1788. ALTER TABLE RICALM.TESTSUITELOG_STRING_M_EXT ADD CONSTRAINT TSULOGSTRMEXT_FK1 FOREIGN KEY (TESTSUITELOG_ID) REFERENCES RIODS.TESTSUITELOG (TESTSUITELOG_ID) ON DELETE CASCADE
  1789. GO
  1790.  
  1791. ALTER TABLE RICALM.TESTSUITELOG_INT_EXT ADD CONSTRAINT TSULOGINTEXT_FK1 FOREIGN KEY (TESTSUITELOG_ID) REFERENCES RIODS.TESTSUITELOG (TESTSUITELOG_ID) ON DELETE CASCADE
  1792. GO
  1793.  
  1794. ALTER TABLE RICALM.TESTSUITELOG_TIMESTAMP_EXT ADD CONSTRAINT TSULOGTIMEEXT_FK1 FOREIGN KEY (TESTSUITELOG_ID) REFERENCES RIODS.TESTSUITELOG (TESTSUITELOG_ID) ON DELETE CASCADE
  1795. GO
  1796.  
  1797. ALTER TABLE RICALM.ITERATION_EXEC_DETAIL ADD CONSTRAINT ITERDET_FK1 FOREIGN KEY (ITERATION_ID) REFERENCES RIODS.ITERATION (ITERATION_ID) ON DELETE CASCADE
  1798. GO
  1799.  
  1800. CREATE TRIGGER TRG_RQSAPDS ON RIODS.REQUEST FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.REQUEST_APPROVAL_DESCRIPTOR WHERE REQUEST_ID IN (SELECT REQUEST_ID FROM INSERTED ) END
  1801. GO
  1802.  
  1803. CREATE TRIGGER TRG_KWSCRD ON RICALM.KEYWORD FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.KEYWORD_SCRIPT_LOOKUP WHERE KEYWORD_ID IN (SELECT KEYWORD_ID FROM INSERTED ) END
  1804. GO
  1805.  
  1806. CREATE TRIGGER TRG_TPOBJSTAD ON RIODS.TESTPLAN FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTPLAN_OBJECTIVESTATUS WHERE TESTPLAN_ID IN (SELECT TESTPLAN_ID FROM INSERTED ) END
  1807. GO
  1808.  
  1809. CREATE TRIGGER TRG_TPOBJD ON RIODS.TESTPLAN FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTPLAN_OBJECTIVE_LOOKUP WHERE TESTPLAN_ID IN (SELECT TESTPLAN_ID FROM INSERTED ) END
  1810. GO
  1811.  
  1812. CREATE TRIGGER TRG_REQCSD ON RICALM.LABREQUEST FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.LABREQUEST_CHANGESTATE WHERE LABREQUEST_ID IN (SELECT LABREQUEST_ID FROM INSERTED ) END
  1813. GO
  1814.  
  1815. CREATE TRIGGER TRG_RESVREQD ON RIODS.RESERVATION FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.RESERVATION_LABREQUEST_LOOKUP WHERE RESERVATION_ID IN (SELECT RESERVATION_ID FROM INSERTED ) END
  1816. GO
  1817.  
  1818. CREATE TRIGGER TRG_TPSTREXTD ON RIODS.TESTPLAN FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTPLAN_STRING_EXT WHERE TESTPLAN_ID IN (SELECT TESTPLAN_ID FROM INSERTED ) END
  1819. GO
  1820.  
  1821. CREATE TRIGGER TRG_TPSTRMEXTD ON RIODS.TESTPLAN FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTPLAN_STRING_M_EXT WHERE TESTPLAN_ID IN (SELECT TESTPLAN_ID FROM INSERTED ) END
  1822. GO
  1823.  
  1824. CREATE TRIGGER TRG_TPINTEXTD ON RIODS.TESTPLAN FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTPLAN_INT_EXT WHERE TESTPLAN_ID IN (SELECT TESTPLAN_ID FROM INSERTED ) END
  1825. GO
  1826.  
  1827. CREATE TRIGGER TRG_TPTIMEEXTD ON RIODS.TESTPLAN FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTPLAN_TIMESTAMP_EXT WHERE TESTPLAN_ID IN (SELECT TESTPLAN_ID FROM INSERTED ) END
  1828. GO
  1829.  
  1830. CREATE TRIGGER TRG_TCSTREXTD ON RIODS.TESTCASE FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTCASE_STRING_EXT WHERE TESTCASE_ID IN (SELECT TESTCASE_ID FROM INSERTED ) END
  1831. GO
  1832.  
  1833. CREATE TRIGGER TRG_TCSTRMEXTD ON RIODS.TESTCASE FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTCASE_STRING_M_EXT WHERE TESTCASE_ID IN (SELECT TESTCASE_ID FROM INSERTED ) END
  1834. GO
  1835.  
  1836. CREATE TRIGGER TRG_TCINTEXTD ON RIODS.TESTCASE FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTCASE_INT_EXT WHERE TESTCASE_ID IN (SELECT TESTCASE_ID FROM INSERTED ) END
  1837. GO
  1838.  
  1839. CREATE TRIGGER TRG_TCTIMEEXTD ON RIODS.TESTCASE FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTCASE_TIMESTAMP_EXT WHERE TESTCASE_ID IN (SELECT TESTCASE_ID FROM INSERTED ) END
  1840. GO
  1841.  
  1842. CREATE TRIGGER TRG_TSCSTREXTD ON RIODS.TESTSCRIPT FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTSCRIPT_STRING_EXT WHERE TESTSCRIPT_ID IN (SELECT TESTSCRIPT_ID FROM INSERTED ) END
  1843. GO
  1844.  
  1845. CREATE TRIGGER TRG_TSCSTRMEXTD ON RIODS.TESTSCRIPT FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTSCRIPT_STRING_M_EXT WHERE TESTSCRIPT_ID IN (SELECT TESTSCRIPT_ID FROM INSERTED ) END
  1846. GO
  1847.  
  1848. CREATE TRIGGER TRG_TSCINTEXTD ON RIODS.TESTSCRIPT FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTSCRIPT_INT_EXT WHERE TESTSCRIPT_ID IN (SELECT TESTSCRIPT_ID FROM INSERTED ) END
  1849. GO
  1850.  
  1851. CREATE TRIGGER TRG_TSCTIMEEXTD ON RIODS.TESTSCRIPT FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTSCRIPT_TIMESTAMP_EXT WHERE TESTSCRIPT_ID IN (SELECT TESTSCRIPT_ID FROM INSERTED ) END
  1852. GO
  1853.  
  1854. CREATE TRIGGER TRG_TSUSTREXTD ON RIODS.TESTSUITE FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTSUITE_STRING_EXT WHERE TESTSUITE_ID IN (SELECT TESTSUITE_ID FROM INSERTED ) END
  1855. GO
  1856.  
  1857. CREATE TRIGGER TRG_TSUSTRMEXTD ON RIODS.TESTSUITE FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTSUITE_STRING_M_EXT WHERE TESTSUITE_ID IN (SELECT TESTSUITE_ID FROM INSERTED ) END
  1858. GO
  1859.  
  1860. CREATE TRIGGER TRG_TSUINTEXTD ON RIODS.TESTSUITE FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTSUITE_INT_EXT WHERE TESTSUITE_ID IN (SELECT TESTSUITE_ID FROM INSERTED ) END
  1861. GO
  1862.  
  1863. CREATE TRIGGER TRG_TSUTIMEEXTD ON RIODS.TESTSUITE FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTSUITE_TIMESTAMP_EXT WHERE TESTSUITE_ID IN (SELECT TESTSUITE_ID FROM INSERTED ) END
  1864. GO
  1865.  
  1866. CREATE TRIGGER TRG_EWISTREXTD ON RIODS.EXECUTION_WORKITEM FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.EXECWORKITEM_STRING_EXT WHERE EXECWORKITEM_ID IN (SELECT EXECWORKITEM_ID FROM INSERTED ) END
  1867. GO
  1868.  
  1869. CREATE TRIGGER TRG_EWISTRMEXTD ON RIODS.EXECUTION_WORKITEM FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.EXECWORKITEM_STRING_M_EXT WHERE EXECWORKITEM_ID IN (SELECT EXECWORKITEM_ID FROM INSERTED ) END
  1870. GO
  1871.  
  1872. CREATE TRIGGER TRG_EWIINTEXTD ON RIODS.EXECUTION_WORKITEM FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.EXECWORKITEM_INT_EXT WHERE EXECWORKITEM_ID IN (SELECT EXECWORKITEM_ID FROM INSERTED ) END
  1873. GO
  1874.  
  1875. CREATE TRIGGER TRG_EWITIMEEXTD ON RIODS.EXECUTION_WORKITEM FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.EXECWORKITEM_TIMESTAMP_EXT WHERE EXECWORKITEM_ID IN (SELECT EXECWORKITEM_ID FROM INSERTED ) END
  1876. GO
  1877.  
  1878. CREATE TRIGGER TRG_TSERSTREXTD ON RIODS.TESTSUITE_EXECUTION_RECORD FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TSTSUITEXECREC_STRING_EXT WHERE TESTSUITE_EXECRECORD_ID IN (SELECT TESTSUITE_EXECRECORD_ID FROM INSERTED ) END
  1879. GO
  1880.  
  1881. CREATE TRIGGER TRG_TSERSTRMEXTD ON RIODS.TESTSUITE_EXECUTION_RECORD FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TSTSUITEXECREC_STRING_M_EXT WHERE TESTSUITE_EXECRECORD_ID IN (SELECT TESTSUITE_EXECRECORD_ID FROM INSERTED ) END
  1882. GO
  1883.  
  1884. CREATE TRIGGER TRG_TSERINTEXTD ON RIODS.TESTSUITE_EXECUTION_RECORD FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TSTSUITEXECREC_INT_EXT WHERE TESTSUITE_EXECRECORD_ID IN (SELECT TESTSUITE_EXECRECORD_ID FROM INSERTED ) END
  1885. GO
  1886.  
  1887. CREATE TRIGGER TRG_TSERTIMEEXTD ON RIODS.TESTSUITE_EXECUTION_RECORD FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TSTSUITEXECREC_TIMESTAMP_EXT WHERE TESTSUITE_EXECRECORD_ID IN (SELECT TESTSUITE_EXECRECORD_ID FROM INSERTED ) END
  1888. GO
  1889.  
  1890. CREATE TRIGGER TRG_EXCRESSTREXTD ON RIODS.EXECUTION_RESULT FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.EXECRES_STRING_EXT WHERE EXECUTION_RESULT_ID IN (SELECT EXECUTION_RESULT_ID FROM INSERTED ) END
  1891. GO
  1892.  
  1893. CREATE TRIGGER TRG_EXCRESSTRMEXTD ON RIODS.EXECUTION_RESULT FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.EXECRES_STRING_M_EXT WHERE EXECUTION_RESULT_ID IN (SELECT EXECUTION_RESULT_ID FROM INSERTED ) END
  1894. GO
  1895.  
  1896. CREATE TRIGGER TRG_EXCRESINTEXTD ON RIODS.EXECUTION_RESULT FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.EXECRES_INT_EXT WHERE EXECUTION_RESULT_ID IN (SELECT EXECUTION_RESULT_ID FROM INSERTED ) END
  1897. GO
  1898.  
  1899. CREATE TRIGGER TRG_EXCRESTIMEEXTD ON RIODS.EXECUTION_RESULT FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.EXECRES_TIMESTAMP_EXT WHERE EXECUTION_RESULT_ID IN (SELECT EXECUTION_RESULT_ID FROM INSERTED ) END
  1900. GO
  1901.  
  1902. CREATE TRIGGER TRG_TSULOGSTREXTD ON RIODS.TESTSUITELOG FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTSUITELOG_STRING_EXT WHERE TESTSUITELOG_ID IN (SELECT TESTSUITELOG_ID FROM INSERTED ) END
  1903. GO
  1904.  
  1905. CREATE TRIGGER TRG_TSULOGSTRMEXTD ON RIODS.TESTSUITELOG FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTSUITELOG_STRING_M_EXT WHERE TESTSUITELOG_ID IN (SELECT TESTSUITELOG_ID FROM INSERTED ) END
  1906. GO
  1907.  
  1908. CREATE TRIGGER TRG_TSULOGINTEXTD ON RIODS.TESTSUITELOG FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTSUITELOG_INT_EXT WHERE TESTSUITELOG_ID IN (SELECT TESTSUITELOG_ID FROM INSERTED ) END
  1909. GO
  1910.  
  1911. CREATE TRIGGER TRG_TSULOGTIMEEXTD ON RIODS.TESTSUITELOG FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.TESTSUITELOG_TIMESTAMP_EXT WHERE TESTSUITELOG_ID IN (SELECT TESTSUITELOG_ID FROM INSERTED ) END
  1912. GO
  1913.  
  1914. CREATE TRIGGER TRG_ITERDETD ON RIODS.ITERATION FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.ITERATION_EXEC_DETAIL WHERE ITERATION_ID IN (SELECT ITERATION_ID FROM INSERTED ) END
  1915. GO
  1916.  
  1917. CREATE TRIGGER TRG_REQUIATTRD ON RIODS.REQUIREMENT FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.RQRMENT_ENUMERATION WHERE REQUIREMENT_ID IN (SELECT REQUIREMENT_ID FROM INSERTED) END
  1918. GO
  1919.  
  1920. CREATE TRIGGER TRG_RQRATTRS ON RIODS.REQUIREMENT FOR UPDATE AS SET NOCOUNT ON IF UPDATE(REC_DATETIME) BEGIN DELETE FROM RICALM.RQRMENT_BOOL_EXT WHERE REQUIREMENT_ID IN (SELECT REQUIREMENT_ID FROM INSERTED) DELETE FROM RICALM.RQRMENT_DATE_EXT WHERE REQUIREMENT_ID IN (SELECT REQUIREMENT_ID FROM INSERTED) DELETE FROM RICALM.RQRMENT_DECIMAL_EXT WHERE REQUIREMENT_ID IN (SELECT REQUIREMENT_ID FROM INSERTED) DELETE FROM RICALM.RQRMENT_INT_EXT WHERE REQUIREMENT_ID IN (SELECT REQUIREMENT_ID FROM INSERTED) DELETE FROM RICALM.RQRMENT_STRING_EXT WHERE REQUIREMENT_ID IN (SELECT REQUIREMENT_ID FROM INSERTED) DELETE FROM RICALM.RQRMENT_STRING_L_EXT WHERE REQUIREMENT_ID IN (SELECT REQUIREMENT_ID FROM INSERTED) DELETE FROM RICALM.RQRMENT_TIMESTAMP_EXT WHERE REQUIREMENT_ID IN (SELECT REQUIREMENT_ID FROM INSERTED) END
  1921. GO
  1922.  
  1923. USE [RIDW]
  1924. GO
  1925.  
  1926. CREATE SCHEMA AUTHORIZATION RICALM
  1927. GO
  1928.  
  1929. CREATE VIEW RICALM.VW_RQST_COMPONENT_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL_COMPONENT_ID, COMPONENT_NAME) AS (SELECT E.REQUEST_ID, E.NAME, E.ISSOFTDELETED, E.VAL_COMPONENT_ID, I.NAME AS COMPONENT_NAME FROM RICALM.REQUEST_COMPONENT_EXT E JOIN RIODS.COMPONENT I ON E.VAL_COMPONENT_ID = I.COMPONENT_ID)
  1930. GO
  1931.  
  1932. CREATE VIEW RICALM.VW_RQST_CATEGORY_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL_REQUEST_CATEGORY_ID, CATEGORY_NAME) AS (SELECT E.REQUEST_ID, E.NAME, E.ISSOFTDELETED, E.VAL_REQUEST_CATEGORY_ID, I.NAME AS CATEGORY_NAME FROM RICALM.REQUEST_CATEGORY_EXT E JOIN RIODS.REQUEST_CATEGORY I ON E.VAL_REQUEST_CATEGORY_ID = I.REQUEST_CATEGORY_ID)
  1933. GO
  1934.  
  1935. CREATE VIEW RICALM.VW_RQST_RESOURCE_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL_RESOURCE_ID, RESOURCE_NAME) AS (SELECT E.REQUEST_ID, E.NAME, E.ISSOFTDELETED, E.VAL_RESOURCE_ID, I.FULL_NAME AS RESOURCE_NAME FROM RICALM.REQUEST_RESOURCE_EXT E JOIN RIODS.RESOURCE I ON E.VAL_RESOURCE_ID = I.RESOURCE_ID)
  1936. GO
  1937.  
  1938. CREATE VIEW RICALM.VW_RQST_RELEASE_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL_RELEASE_ID, RELEASE_NAME) AS (SELECT E.REQUEST_ID, E.NAME, E.ISSOFTDELETED, E.VAL_RELEASE_ID, I.NAME AS RELEASE_NAME FROM RICALM.REQUEST_RELEASE_EXT E JOIN RIODS.RELEASE I ON E.VAL_RELEASE_ID = I.RELEASE_ID)
  1939. GO
  1940.  
  1941. CREATE VIEW RICALM.VW_RQST_ITERATION_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL_ITERATION_ID, ITERATION_NAME) AS (SELECT E.REQUEST_ID, E.NAME, E.ISSOFTDELETED, E.VAL_ITERATION_ID, I.NAME AS ITERATION_NAME FROM RICALM.REQUEST_ITERATION_EXT E JOIN RIODS.ITERATION I ON E.VAL_ITERATION_ID = I.ITERATION_ID)
  1942. GO
  1943.  
  1944. CREATE VIEW RICALM.VW_RQST_PROJECT_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL_PROJECT_ID, PROJECT_NAME) AS (SELECT E.REQUEST_ID, E.NAME, E.ISSOFTDELETED, E.VAL_PROJECT_ID, I.NAME AS PROJECT_NAME FROM RICALM.REQUEST_PROJECT_EXT E JOIN RIODS.PROJECT I ON E.VAL_PROJECT_ID = I.PROJECT_ID)
  1945. GO
  1946.  
  1947. CREATE VIEW RICALM.VW_RQST_TEAM_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL_TEAM_ID, TEAM_NAME) AS (SELECT E.REQUEST_ID, E.NAME, E.ISSOFTDELETED, E.VAL_TEAM_ID, I.NAME AS TEAM_NAME FROM RICALM.REQUEST_TEAM_EXT E JOIN RIODS.TEAM I ON E.VAL_TEAM_ID = I.TEAM_ID)
  1948. GO
  1949.  
  1950. CREATE VIEW RICALM.VW_RQST_TIMELINE_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL_TIMELINE_ID, TIMELINE_NAME) AS (SELECT E.REQUEST_ID, E.NAME, E.ISSOFTDELETED, E.VAL_TIMELINE_ID, I.NAME AS TIMELINE_NAME FROM RICALM.REQUEST_TIMELINE_EXT E JOIN RIODS.TIMELINE I ON E.VAL_TIMELINE_ID = I.TIMELINE_ID)
  1951. GO
  1952.  
  1953. CREATE VIEW RICALM.VW_RQST_REQUEST_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL_REQUEST_ID, REQUEST_NAME) AS (SELECT E.REQUEST_ID, E.NAME, E.ISSOFTDELETED, E.VAL_REQUEST_ID, I.NAME AS REQUEST_NAME FROM RICALM.REQUEST_REQUEST_EXT E JOIN RIODS.REQUEST I ON E.VAL_REQUEST_ID = I.REQUEST_ID)
  1954. GO
  1955.  
  1956. CREATE VIEW RICALM.VW_RQST_HISTORY_COMPONENT_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL_COMPONENT_ID, COMPONENT_NAME) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL_COMPONENT_ID, I.NAME AS COMPONENT_NAME FROM RICALM.REQUEST_HISTORY_COMPONENT_EXT E JOIN RIODS.COMPONENT I ON E.VAL_COMPONENT_ID = I.COMPONENT_ID)
  1957. GO
  1958.  
  1959. CREATE VIEW RICALM.VW_RQST_HISTORY_CATEGORY_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL_REQUEST_CATEGORY_ID, CATEGORY_NAME) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL_REQUEST_CATEGORY_ID, I.NAME AS CATEGORY_NAME FROM RICALM.REQUEST_HISTORY_CATEGORY_EXT E JOIN RIODS.REQUEST_CATEGORY I ON E.VAL_REQUEST_CATEGORY_ID = I.REQUEST_CATEGORY_ID)
  1960. GO
  1961.  
  1962. CREATE VIEW RICALM.VW_RQST_HISTORY_RESOURCE_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL_RESOURCE_ID, RESOURCE_NAME) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL_RESOURCE_ID, I.FULL_NAME AS RESOURCE_NAME FROM RICALM.REQUEST_HISTORY_RESOURCE_EXT E JOIN RIODS.RESOURCE I ON E.VAL_RESOURCE_ID = I.RESOURCE_ID)
  1963. GO
  1964.  
  1965. CREATE VIEW RICALM.VW_RQST_HISTORY_RELEASE_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL_RELEASE_ID, RELEASE_NAME) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL_RELEASE_ID, I.NAME AS RELEASE_NAME FROM RICALM.REQUEST_HISTORY_RELEASE_EXT E JOIN RIODS.RELEASE I ON E.VAL_RELEASE_ID = I.RELEASE_ID)
  1966. GO
  1967.  
  1968. CREATE VIEW RICALM.VW_RQST_HISTORY_ITERATION_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL_ITERATION_ID, ITERATION_NAME) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL_ITERATION_ID, I.NAME AS ITERATION_NAME FROM RICALM.REQUEST_HISTORY_ITERATION_EXT E JOIN RIODS.ITERATION I ON E.VAL_ITERATION_ID = I.ITERATION_ID)
  1969. GO
  1970.  
  1971. CREATE VIEW RICALM.VW_RQST_HISTORY_PROJECT_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL_PROJECT_ID, PROJECT_NAME) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL_PROJECT_ID, I.NAME AS PROJECT_NAME FROM RICALM.REQUEST_HISTORY_PROJECT_EXT E JOIN RIODS.PROJECT I ON E.VAL_PROJECT_ID = I.PROJECT_ID)
  1972. GO
  1973.  
  1974. CREATE VIEW RICALM.VW_RQST_HISTORY_TEAM_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL_TEAM_ID, TEAM_NAME) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL_TEAM_ID, I.NAME AS TEAM_NAME FROM RICALM.REQUEST_HISTORY_TEAM_EXT E JOIN RIODS.TEAM I ON E.VAL_TEAM_ID = I.TEAM_ID)
  1975. GO
  1976.  
  1977. CREATE VIEW RICALM.VW_RQST_HISTORY_TIMELINE_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL_TIMELINE_ID, TIMELINE_NAME) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL_TIMELINE_ID, I.NAME AS TIMELINE_NAME FROM RICALM.REQUEST_HISTORY_TIMELINE_EXT E JOIN RIODS.TIMELINE I ON E.VAL_TIMELINE_ID = I.TIMELINE_ID)
  1978. GO
  1979.  
  1980. CREATE VIEW RICALM.VW_RQST_HISTORY_REQUEST_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL_REQUEST_ID, REQUEST_NAME) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL_REQUEST_ID, I.NAME AS REQUEST_NAME FROM RICALM.REQUEST_HISTORY_REQUEST_EXT E JOIN RIODS.REQUEST I ON E.VAL_REQUEST_ID = I.REQUEST_ID)
  1981. GO
  1982.  
  1983. CREATE VIEW RICALM.VW_REQUEST_APPROVAL_TYPE (REQUEST_APPROVAL_TYPE_ID, NAME, REFERENCE_ID, EXTERNAL_ID, PROJECT_ID, PROJECT_NAME, URL, EXTERNAL_KEY1, EXTERNAL_KEY2, SOURCE_ID, REC_DATETIME, ISSOFTDELETED) AS (SELECT RT.REQUEST_APPROVAL_TYPE_ID, RT.NAME, RT.REFERENCE_ID, RT.EXTERNAL_ID, RT.PROJECT_ID, P.NAME AS PROJECT_NAME, RT.URL, RT.EXTERNAL_KEY1, RT.EXTERNAL_KEY2, RT.SOURCE_ID, RT.REC_DATETIME, RT.ISSOFTDELETED FROM RICALM.REQUEST_APPROVAL_TYPE RT JOIN RIODS.PROJECT P ON RT.PROJECT_ID = P.PROJECT_ID)
  1984. GO
  1985.  
  1986. CREATE VIEW RICALM.VW_REQUEST_APPROVAL_STATE (REQUEST_APPROVAL_STATE_ID, NAME, REFERENCE_ID, EXTERNAL_ID, PROJECT_ID, PROJECT_NAME, URL, EXTERNAL_KEY1, EXTERNAL_KEY2, SOURCE_ID, REC_DATETIME, ISSOFTDELETED) AS (SELECT RS.REQUEST_APPROVAL_STATE_ID, RS.NAME, RS.REFERENCE_ID, RS.EXTERNAL_ID, RS.PROJECT_ID, P.NAME AS PROJECT_NAME, RS.URL, RS.EXTERNAL_KEY1, RS.EXTERNAL_KEY2, RS.SOURCE_ID, RS.REC_DATETIME, RS.ISSOFTDELETED FROM RICALM.REQUEST_APPROVAL_STATE RS JOIN RIODS.PROJECT P ON RS.PROJECT_ID = P.PROJECT_ID)
  1987. GO
  1988.  
  1989. CREATE VIEW RICALM.VW_REQUEST_APPROVAL_DESCRIPTOR (REQUEST_APPROVAL_DESCRIPTOR_ID, REQUEST_ID, SUMMARY, PROJECT_ID, PROJECT_NAME, REQUEST_APPROVAL_TYPE_ID, REQUEST_APPROVAL_TYPE_NAME, CUMULATIVE_STATE_ID, CUMULATIVE_STATE_NAME, NAME, DUE_DATE, CUMULATIVE_STATE_DATE, EXTERNAL_KEY1, EXTERNAL_KEY2, SOURCE_ID, URL, REC_DATETIME, ISSOFTDELETED) AS (SELECT RAD.REQUEST_APPROVAL_DESCRIPTOR_ID, RAD.REQUEST_ID, R.SUMMARY, R.PROJECT_ID, P.NAME AS PROJECT_NAME, RAD.REQUEST_APPROVAL_TYPE_ID, RT.NAME AS REQUEST_APPROVAL_TYPE_NAME, RAD.CUMULATIVE_STATE_ID, RS.NAME AS CUMULATIVE_STATE_NAME, RAD.NAME, RAD.DUE_DATE, RAD.CUMULATIVE_STATE_DATE, RAD.EXTERNAL_KEY1, RAD.EXTERNAL_KEY2, RAD.SOURCE_ID, RAD.URL, RAD.REC_DATETIME, RAD.ISSOFTDELETED FROM RICALM.REQUEST_APPROVAL_DESCRIPTOR RAD JOIN RIODS.REQUEST R ON RAD.REQUEST_ID = R.REQUEST_ID JOIN RIODS.PROJECT P ON R.PROJECT_ID = P.PROJECT_ID JOIN RICALM.REQUEST_APPROVAL_TYPE RT ON RAD.REQUEST_APPROVAL_TYPE_ID = RT.REQUEST_APPROVAL_TYPE_ID JOIN RICALM.REQUEST_APPROVAL_STATE
  1990. RS ON RAD.CUMULATIVE_STATE_ID = RS.REQUEST_APPROVAL_STATE_ID)
  1991. GO
  1992.  
  1993. CREATE VIEW RICALM.VW_REQUEST_APPROVAL (REQUEST_APPROVAL_ID, REQUEST_APPROVAL_DESCRIPTOR_ID, RQST_APPROVAL_DESCRIPTOR_NAME, CUMULATIVE_STATE_ID, CUMULATIVE_STATE_NAME, PROJECT_ID, PROJECT_NAME, REQUEST_APPROVAL_STATE_ID, REQUEST_APPROVAL_STATE_NAME, APPROVER_ID, APPROVER_NAME, STATE_DATE, EXTERNAL_KEY1, EXTERNAL_KEY2, SOURCE_ID, URL, REC_DATETIME, ISSOFTDELETED) AS (SELECT RA.REQUEST_APPROVAL_ID, RA.REQUEST_APPROVAL_DESCRIPTOR_ID, RAD.NAME AS RQST_APPROVAL_DESCRIPTOR_NAME, RAD.CUMULATIVE_STATE_ID, RSD.NAME AS CUMULATIVE_STATE_NAME, R.PROJECT_ID, P.NAME AS PROJECT_NAME, RA.REQUEST_APPROVAL_STATE_ID, RS.NAME AS REQUEST_APPROVAL_STATE_NAME, RA.APPROVER_ID, RE.FULL_NAME AS APPROVER_NAME, RA.STATE_DATE, RA.EXTERNAL_KEY1, RA.EXTERNAL_KEY2, RA.SOURCE_ID, RA.URL, RA.REC_DATETIME, RA.ISSOFTDELETED FROM RICALM.REQUEST_APPROVAL RA JOIN RICALM.REQUEST_APPROVAL_DESCRIPTOR RAD ON RA.REQUEST_APPROVAL_DESCRIPTOR_ID = RAD.REQUEST_APPROVAL_DESCRIPTOR_ID JOIN RIODS.REQUEST R ON RAD.REQUEST_ID = R.REQUEST_ID
  1994. JOIN RIODS.PROJECT P ON R.PROJECT_ID = P.PROJECT_ID JOIN RICALM.REQUEST_APPROVAL_STATE RSD ON RAD.CUMULATIVE_STATE_ID = RSD.REQUEST_APPROVAL_STATE_ID JOIN RICALM.REQUEST_APPROVAL_STATE RS ON RA.REQUEST_APPROVAL_STATE_ID = RS.REQUEST_APPROVAL_STATE_ID JOIN RIODS.RESOURCE RE ON RA.APPROVER_ID = RE.RESOURCE_ID)
  1995. GO
  1996.  
  1997. CREATE VIEW RICALM.VW_TEAM_CAPACITY AS (SELECT TC.TEAM_CAPACITY_ID, TC.TEAM_ID, T.NAME AS TEAM_NAME, TC.PROJECT_ID, P.NAME AS PROJECT_NAME, TC.TIMELINE_ID, TL.NAME AS TIMELINE_NAME, TC.CAPACITY, TC.REC_DATETIME, TC.SOURCE_ID, TC.ISSOFTDELETED FROM RICALM.TEAM_CAPACITY TC JOIN RIODS.PROJECT P ON P.PROJECT_ID = TC.PROJECT_ID JOIN RIODS.TEAM T ON T.TEAM_ID = TC.TEAM_ID JOIN RIODS.TIMELINE TL ON TL.TIMELINE_ID = TC.TIMELINE_ID)
  1998. GO
  1999.  
  2000. CREATE VIEW RICALM.VW_SCALAR_COUNTER AS (SELECT A.SCALAR_COUNTER_ID, A.REC_DATETIME, B.GROUP_NAME, B.NAME, B.FACET, A.VAL, A.MIN_VALUE, A.MAX_VALUE, A.SOURCE_ID, A.ISSOFTDELETED FROM RICALM.SCALAR_COUNTER A JOIN RICALM.GROUP_NAME_FACET B ON A.GROUP_NAME_FACET_ID = B.GROUP_NAME_FACET_ID)
  2001. GO
  2002.  
  2003. CREATE VIEW RICALM.VW_RANGE_COUNTER AS (SELECT A.RANGE_COUNTER_ID, A.REC_DATETIME, B.GROUP_NAME, B.NAME, B.FACET, A.COUNT_VALUE, A.TOTAL_VALUE, A.MIN_VALUE, A.MAX_VALUE, A.AVERAGE_VALUE, A.STD_DEV_VALUE, A.SOURCE_ID, A.ISSOFTDELETED FROM RICALM.RANGE_COUNTER A JOIN RICALM.GROUP_NAME_FACET B ON A.GROUP_NAME_FACET_ID = B.GROUP_NAME_FACET_ID)
  2004. GO
  2005.  
  2006. CREATE VIEW RICALM.VW_INTEGRAL_RANGE_COUNTER AS (SELECT A.INTEGRAL_RANGE_COUNTER_ID, A.REC_DATETIME, B.GROUP_NAME, B.NAME, B.FACET, A.COUNT_VALUE, A.TOTAL_VALUE, A.MIN_VALUE, A.MAX_VALUE, A.AVERAGE_VALUE, A.STD_DEV_VALUE, A.SOURCE_ID, A.ISSOFTDELETED FROM RICALM.INTEGRAL_RANGE_COUNTER A JOIN RICALM.GROUP_NAME_FACET B ON A.GROUP_NAME_FACET_ID = B.GROUP_NAME_FACET_ID)
  2007. GO
  2008.  
  2009. CREATE VIEW RICALM.VW_ITEM_TYPE_STORAGE AS (SELECT ITEM_TYPE_STORAGE_ID, REC_DATETIME, NAMESPACE, NAME, NUM_STATES, NUM_ITEMS, SIZE_VAL, CONTENT_SIZE, ORM_SIZE, PERSISTED_CONTENT_SIZE, SOURCE_ID, ISSOFTDELETED FROM RICALM.ITEM_TYPE_STORAGE)
  2010. GO
  2011.  
  2012. CREATE VIEW RICALM.VW_RQST_HISTORY (REQUEST_ID, ACTIVATE_DATE, ASSIGNED_DATE, CLOSED_DATE, COMPONENT_ID, COMPONENT_NAME, CREATION_DATE, CUSTOMER_PRIORITY, DUPLICATE_DATE, EXTERNAL_ID, FIXEDINRELEASE_ID, FIXED_IN_RELEASE_NAME, IS_BLOCKING, ITERATION_ID, ITERATION_NAME, TEAM_ID, TEAM_NAME, PLANNED_WORK, ACTUAL_WORK, COMMENT_COUNT, SUBSCRIBER_COUNT, STORY_POINTS, TAGS, NAME, PLATFORM, REQUEST_PRIORITY_ID, REQUEST_PRIORITY, REQUEST_PRIORITY_EXTERNAL_ID, PROJECT_ID, PROJECT_NAME, REFERENCE_ID, RELEASE_ID, FOUND_IN_RELEASE_NAME, REQUEST_CLASS_ID, REQUEST_CLASS, REQUEST_HISTORY_ID, OWNER_ID, REQUEST_RESPONSIBLE, REQUEST_SOURCE, REQUEST_STATE_ID, REQUEST_STATE, REQUEST_STATE_EXTERNAL_ID, REQUEST_RESOLUTION_ID, REQUEST_RESOLUTION, REQUEST_RESOLUTION_EXTERNAL_ID, RESOLVED_DATE, REQUEST_SEVERITY_ID, REQUEST_SEVERITY, REQUEST_SEVERITY_EXTERNAL_ID, SLOC_CHANGE, REQUEST_STATUS_ID, REQUEST_STATUS, REQUEST_STATUS_EXTERNAL_ID, SUBMIT_DATE, URL, DUE_DATE, CREATOR_ID, CREATOR_NAME, MODIFIER_ID, MODIFIER_NAME, BUILD_ID, BUILD_NAME,
  2013. PHASE_ID, PHASE_NAME, PROJECT_CATEGORY_ID, PROJECT_CATEGORY_NAME, EXTERNAL_KEY1, EXTERNAL_KEY2, REQUEST_TYPE_ID, REQUEST_TYPE, REQUEST_TYPE_EXTERNAL_ID, REQUEST_CATEGORY_ID, REQUEST_CATEGORY_NAME, RESOLVER_ID, RESOLVER_NAME, SUMMARY, REC_DATETIME, ISSOFTDELETED, PREV_REQUEST_HISTORY_ID) AS (SELECT R.REQUEST_ID, R.ACTIVATE_DATE, R.ASSIGNED_DATE, R.CLOSED_DATE, R.COMPONENT_ID, C.NAME AS COMPONENT_NAME, R.CREATION_DATE, R.CUSTOMER_PRIORITY, R.DUPLICATE_DATE, R.EXTERNAL_ID, R.FIXEDINRELEASE_ID, RL.NAME AS FIXED_IN_RELEASE_NAME, R.IS_BLOCKING, R.ITERATION_ID, I.NAME AS ITERATION_NAME, R.TEAM_ID, T.NAME AS TEAM_NAME, R.PLANNED_WORK, R.ACTUAL_WORK, R.COMMENT_COUNT, R.SUBSCRIBER_COUNT, R.STORY_POINTS, R.TAGS, R.NAME, R.PLATFORM, R.REQUEST_PRIORITY_ID, RP.NAME AS REQUEST_PRIORITY, RP.EXTERNAL_ID AS REQUEST_PRIORITY_EXTERNAL_ID, R.PROJECT_ID, PJ.NAME AS PROJECT_NAME, R.REFERENCE_ID, R.RELEASE_ID, RL2.NAME AS FOUND_IN_RELEASE_NAME, R.REQUEST_CLASS_ID, RQ.NAME AS REQUEST_CLASS, R.REQUEST_HISTORY_ID, R.OWNER_ID, PS.FULL_NAME
  2014. AS REQUEST_RESPONSIBLE, R.REQUEST_SOURCE, R.REQUEST_STATE_ID, RST.NAME AS REQUEST_STATE, RST.EXTERNAL_ID AS REQUEST_STATE_EXTERNAL_ID, R.REQUEST_RESOLUTION_ID, RRES.NAME AS REQUEST_RESOLUTION, RRES.EXTERNAL_ID AS REQUEST_RESOLUTION_EXTERNAL_ID, R.RESOLVED_DATE, R.REQUEST_SEVERITY_ID, RSEV.NAME AS REQUEST_SEVERITY, RSEV.EXTERNAL_ID AS REQUEST_SEVERITY_EXTERNAL_ID, R.SLOC_CHANGE, R.REQUEST_STATUS_ID, RSTU.NAME AS REQUEST_STATUS, RSTU.EXTERNAL_ID AS REQUEST_STATUS_EXTERNAL_ID, R.SUBMIT_DATE, R.URL, R.DUE_DATE, R.CREATOR_ID, RES.FULL_NAME AS CREATOR_NAME, R.MODIFIER_ID, RM.FULL_NAME AS MODIFIER_NAME, R.BUILD_ID, B.NAME AS BUILD_NAME, R.PHASE_ID, PH.NAME AS PHASE_NAME, R.PROJECT_CATEGORY_ID, PC.NAME AS PROJECT_CATEGORY_NAME, R.EXTERNAL_KEY1, R.EXTERNAL_KEY2, R.REQUEST_TYPE_ID, RT.NAME REQUEST_TYPE, RT.EXTERNAL_ID AS REQUEST_TYPE_EXTERNAL_ID, R.REQUEST_CATEGORY_ID, RC.NAME AS REQUEST_CATEGORY_NAME, R.RESOLVER_ID, RS.FULL_NAME AS RESOLVER_NAME, R.SUMMARY, R.REC_DATETIME, R.ISSOFTDELETED, R.PREV_REQUEST_HISTORY_ID FROM
  2015. RICALM.REQUEST_HISTORY R JOIN RIODS.ITERATION I ON I.ITERATION_ID=R.ITERATION_ID JOIN RIODS.TEAM T ON T.TEAM_ID=R.TEAM_ID JOIN RIODS.PROJECT PJ ON PJ.PROJECT_ID=R.PROJECT_ID JOIN RIODS.COMPONENT C ON C.COMPONENT_ID=R.COMPONENT_ID JOIN RIODS.RELEASE RL ON RL.RELEASE_ID=R.FIXEDINRELEASE_ID JOIN RIODS.RELEASE RL2 ON RL2.RELEASE_ID=R.RELEASE_ID JOIN RIODS.REQUEST_CLASSIFICATION RQ ON RQ.REQUEST_CLASS_ID=R.REQUEST_CLASS_ID JOIN RIODS.REQUEST_CATEGORY RC ON RC.REQUEST_CATEGORY_ID=R.REQUEST_CATEGORY_ID JOIN RIODS.BUILD B ON B.BUILD_ID=R.BUILD_ID JOIN RIODS.PHASE PH ON PH.PHASE_ID=R.PHASE_ID JOIN RIODS.PROJECT_CATEGORY PC ON PC.PROJECT_CATEGORY_ID=R.PROJECT_CATEGORY_ID JOIN RIODS.RESOURCE PS ON PS.RESOURCE_ID=R.OWNER_ID JOIN RIODS.RESOURCE RS ON RS.RESOURCE_ID=R.RESOLVER_ID JOIN RIODS.RESOURCE RES ON RES.RESOURCE_ID=R.CREATOR_ID JOIN RIODS.RESOURCE RM ON RM.RESOURCE_ID=R.MODIFIER_ID JOIN RIODS.REQUEST_STATE
  2016. RST ON RST.REQUEST_STATE_ID=R.REQUEST_STATE_ID JOIN RIODS.REQUEST_STATUS RSTU ON RSTU.REQUEST_STATUS_ID=R.REQUEST_STATUS_ID JOIN RIODS.REQUEST_PRIORITY RP ON RP.REQUEST_PRIORITY_ID=R.REQUEST_PRIORITY_ID JOIN RIODS.REQUEST_RESOLUTION RRES ON RRES.REQUEST_RESOLUTION_ID=R.REQUEST_RESOLUTION_ID JOIN RIODS.REQUEST_SEVERITY RSEV ON RSEV.REQUEST_SEVERITY_ID=R.REQUEST_SEVERITY_ID JOIN RIODS.REQUEST_TYPE RT ON RT.REQUEST_TYPE_ID=R.REQUEST_TYPE_ID)
  2017. GO
  2018.  
  2019. CREATE VIEW RICALM.VW_RQST_BASELINE (REQUEST_HISTORY_ID, REC_DATETIME) AS (SELECT B.REQUEST_HISTORY_ID, B.REC_DATETIME FROM RICALM.REQUEST_BASELINE B)
  2020. GO
  2021.  
  2022. CREATE VIEW RICALM.VW_RQST_INT_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL) AS (SELECT E.REQUEST_ID, E.NAME, E.ISSOFTDELETED, VAL FROM RICALM.REQUEST_INT_EXT E)
  2023. GO
  2024.  
  2025. CREATE VIEW RICALM.VW_RQST_LONG_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL) AS (SELECT E.REQUEST_ID, E.NAME, ISSOFTDELETED, E.VAL FROM REQUEST_LONG_EXT E)
  2026. GO
  2027.  
  2028. CREATE VIEW RICALM.VW_RQST_BOOL_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL) AS (SELECT E.REQUEST_ID, E.NAME, E.ISSOFTDELETED, E.VAL FROM RICALM.REQUEST_BOOL_EXT E)
  2029. GO
  2030.  
  2031. CREATE VIEW RICALM.VW_RQST_STRING_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL, NUM_VAL) AS (SELECT E.REQUEST_ID, E.NAME, E.ISSOFTDELETED, E.VAL, E.NUM_VAL FROM RICALM.REQUEST_STRING_EXT E)
  2032. GO
  2033.  
  2034. CREATE VIEW RICALM.VW_RQST_STRING_M_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL, NUM_VAL) AS (SELECT E.REQUEST_ID, E.NAME, E.ISSOFTDELETED, E.VAL, E.NUM_VAL FROM RICALM.REQUEST_STRING_M_EXT E)
  2035. GO
  2036.  
  2037. CREATE VIEW RICALM.VW_RQST_STRING_L_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL, NUM_VAL) AS (SELECT E.REQUEST_ID, E.NAME, E.ISSOFTDELETED, E.VAL, E.NUM_VAL FROM RICALM.REQUEST_STRING_L_EXT E)
  2038. GO
  2039.  
  2040. CREATE VIEW RICALM.VW_RQST_TIMESTAMP_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL) AS (SELECT E.REQUEST_ID, E.NAME, E.ISSOFTDELETED, E.VAL FROM RICALM.REQUEST_TIMESTAMP_EXT E)
  2041. GO
  2042.  
  2043. CREATE VIEW RICALM.VW_RQST_DECIMAL_EXT (REQUEST_ID, NAME, ISSOFTDELETED, VAL) AS (SELECT E.REQUEST_ID, E.NAME, E.ISSOFTDELETED, E.VAL FROM RICALM.REQUEST_DECIMAL_EXT E)
  2044. GO
  2045.  
  2046. CREATE VIEW RICALM.VW_RQST_HISTORY_INT_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL FROM RICALM.REQUEST_HISTORY_INT_EXT E)
  2047. GO
  2048.  
  2049. CREATE VIEW RICALM.VW_RQST_HISTORY_LONG_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL FROM RICALM.REQUEST_HISTORY_LONG_EXT E)
  2050. GO
  2051.  
  2052. CREATE VIEW RICALM.VW_RQST_HISTORY_BOOL_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL FROM RICALM.REQUEST_HISTORY_BOOL_EXT E)
  2053. GO
  2054.  
  2055. CREATE VIEW RICALM.VW_RQST_HISTORY_STRING_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL, NUM_VAL) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL, E.NUM_VAL FROM RICALM.REQUEST_HISTORY_STRING_EXT E)
  2056. GO
  2057.  
  2058. CREATE VIEW RICALM.VW_RQST_HISTORY_STRING_M_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL, NUM_VAL) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL, E.NUM_VAL FROM RICALM.REQUEST_HISTORY_STRING_M_EXT E)
  2059. GO
  2060.  
  2061. CREATE VIEW RICALM.VW_RQST_HISTORY_STRING_L_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL, NUM_VAL) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL, E.NUM_VAL FROM RICALM.REQUEST_HISTORY_STRING_L_EXT E)
  2062. GO
  2063.  
  2064. CREATE VIEW RICALM.VW_RQST_HISTORY_TIMESTAMP_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL FROM RICALM.REQUEST_HISTORY_TIMESTAMP_EXT E)
  2065. GO
  2066.  
  2067. CREATE VIEW RICALM.VW_RQST_HISTORY_DECIMAL_EXT (REQUEST_HISTORY_ID, NAME, ISSOFTDELETED, VAL) AS (SELECT E.REQUEST_HISTORY_ID, E.NAME, E.ISSOFTDELETED, E.VAL FROM RICALM.REQUEST_HISTORY_DECIMAL_EXT E)
  2068. GO
  2069.  
  2070. CREATE VIEW RICALM.VW_RQST_ENUMERATION (REQUEST_ENUMERATION_ID, ENUMERATION_NAME, LITERAL_NAME, REFERENCE_ID, EXTERNAL_ID, PROJECT_ID, URL, EXTERNAL_KEY1, EXTERNAL_KEY2, SOURCE_ID, REC_DATETIME, ISSOFTDELETED) AS (SELECT E.REQUEST_ENUMERATION_ID, E.ENUMERATION_NAME, E.LITERAL_NAME, E.REFERENCE_ID, E.EXTERNAL_ID, E.PROJECT_ID, URL, E.EXTERNAL_KEY1, E.EXTERNAL_KEY2, E.SOURCE_ID, E.REC_DATETIME, E.ISSOFTDELETED FROM RICALM.REQUEST_ENUMERATION E)
  2071. GO
  2072.  
  2073. CREATE VIEW RICALM.VW_RQRMENT_HISTORY (REQUIREMENT_HISTORY_ID, NAME, REFERENCE_ID, EXTERNAL_ID, URL, PROJECT_ID, PROJECT_NAME, REQUIREMENT_TYPE, CREATION_DATE, REVISION_DATE, EXTERNAL_KEY1, EXTERNAL_KEY2, REC_DATETIME, ISSOFTDELETED, PREV_REQUIREMENT_HISTORY_ID) AS (SELECT R.REQUIREMENT_HISTORY_ID, R.NAME, R.REFERENCE_ID, R.EXTERNAL_ID, R.URL, R.PROJECT_ID, PJ.NAME AS PROJECT_NAME, R.REQUIREMENT_TYPE, R.CREATION_DATE, R.REVISION_DATE, R.EXTERNAL_KEY1, R.EXTERNAL_KEY2, R.REC_DATETIME, R.ISSOFTDELETED, R.PREV_REQUIREMENT_HISTORY_ID FROM RICALM.RQRMENT_HISTORY R JOIN RIODS.PROJECT PJ ON PJ.PROJECT_ID=R.PROJECT_ID)
  2074. GO
  2075.  
  2076. CREATE VIEW RICALM.VW_RQRMENT_STRING_EXT (REQUIREMENT_ID, NAME, IDENTIFIER, DATATYPE, TYPE_NAME, TYPE_IDENTIFIER, ISSOFTDELETED, VAL) AS (SELECT E.REQUIREMENT_ID, A.NAME, A.IDENTIFIER, A.DATATYPE, T.NAME AS TYPENAME, T.IDENTIFIER AS TYPE_IDENTIFIER, E.ISSOFTDELETED, E.VAL FROM RICALM.RQRMENT_STRING_EXT E JOIN RICALM.RQRMENT_ATTRDEF A ON A.REQUIREMENT_ATTRDEF_ID=E.REQUIREMENT_ATTRDEF_ID JOIN RICALM.RQRMENT_TYPE T ON T.REQUIREMENT_TYPE_ID=A.REQUIREMENT_TYPE_ID)
  2077. GO
  2078.  
  2079. CREATE VIEW RICALM.VW_RQRMENT_TIMESTAMP_EXT (REQUIREMENT_ID, NAME, IDENTIFIER, DATATYPE, TYPE_NAME, TYPE_IDENTIFIER, ISSOFTDELETED, VAL) AS (SELECT E.REQUIREMENT_ID, A.NAME, A.IDENTIFIER, A.DATATYPE, T.NAME AS TYPENAME, T.IDENTIFIER AS TYPE_IDENTIFIER, E.ISSOFTDELETED, E.VAL FROM RICALM.RQRMENT_TIMESTAMP_EXT E JOIN RICALM.RQRMENT_ATTRDEF A ON A.REQUIREMENT_ATTRDEF_ID=E.REQUIREMENT_ATTRDEF_ID JOIN RICALM.RQRMENT_TYPE T ON T.REQUIREMENT_TYPE_ID=A.REQUIREMENT_TYPE_ID)
  2080. GO
  2081.  
  2082. CREATE VIEW RICALM.VW_RQRMENT_DATE_EXT (REQUIREMENT_ID, NAME, IDENTIFIER, DATATYPE, TYPE_NAME, TYPE_IDENTIFIER, ISSOFTDELETED, VAL) AS (SELECT E.REQUIREMENT_ID, A.NAME, A.IDENTIFIER, A.DATATYPE, T.NAME AS TYPENAME, T.IDENTIFIER AS TYPE_IDENTIFIER, E.ISSOFTDELETED, E.VAL FROM RICALM.RQRMENT_DATE_EXT E JOIN RICALM.RQRMENT_ATTRDEF A ON A.REQUIREMENT_ATTRDEF_ID=E.REQUIREMENT_ATTRDEF_ID JOIN RICALM.RQRMENT_TYPE T ON T.REQUIREMENT_TYPE_ID=A.REQUIREMENT_TYPE_ID)
  2083. GO
  2084.  
  2085. CREATE VIEW RICALM.VW_RQRMENT_STRING_L_EXT (REQUIREMENT_ID, NAME, IDENTIFIER, DATATYPE, TYPE_NAME, TYPE_IDENTIFIER, ISSOFTDELETED, VAL) AS (SELECT E.REQUIREMENT_ID, A.NAME, A.IDENTIFIER, A.DATATYPE, T.NAME AS TYPENAME, T.IDENTIFIER AS TYPE_IDENTIFIER, E.ISSOFTDELETED, E.VAL FROM RICALM.RQRMENT_STRING_L_EXT E JOIN RICALM.RQRMENT_ATTRDEF A ON A.REQUIREMENT_ATTRDEF_ID=E.REQUIREMENT_ATTRDEF_ID JOIN RICALM.RQRMENT_TYPE T ON T.REQUIREMENT_TYPE_ID=A.REQUIREMENT_TYPE_ID)
  2086. GO
  2087.  
  2088. CREATE VIEW RICALM.VW_RQRMENT_INT_EXT (REQUIREMENT_ID, NAME, IDENTIFIER, DATATYPE, TYPE_NAME, TYPE_IDENTIFIER, ISSOFTDELETED, VAL) AS (SELECT E.REQUIREMENT_ID, A.NAME, A.IDENTIFIER, A.DATATYPE, T.NAME AS TYPENAME, T.IDENTIFIER AS TYPE_IDENTIFIER, E.ISSOFTDELETED, E.VAL FROM RICALM.RQRMENT_INT_EXT E JOIN RICALM.RQRMENT_ATTRDEF A ON A.REQUIREMENT_ATTRDEF_ID=E.REQUIREMENT_ATTRDEF_ID JOIN RICALM.RQRMENT_TYPE T ON T.REQUIREMENT_TYPE_ID=A.REQUIREMENT_TYPE_ID)
  2089. GO
  2090.  
  2091. CREATE VIEW RICALM.VW_RQRMENT_DECIMAL_EXT (REQUIREMENT_ID, NAME, IDENTIFIER, DATATYPE, TYPE_NAME, TYPE_IDENTIFIER, ISSOFTDELETED, VAL) AS (SELECT E.REQUIREMENT_ID, A.NAME, A.IDENTIFIER, A.DATATYPE, T.NAME AS TYPENAME, T.IDENTIFIER AS TYPE_IDENTIFIER, E.ISSOFTDELETED, E.VAL FROM RICALM.RQRMENT_DECIMAL_EXT E JOIN RICALM.RQRMENT_ATTRDEF A ON A.REQUIREMENT_ATTRDEF_ID=E.REQUIREMENT_ATTRDEF_ID JOIN RICALM.RQRMENT_TYPE T ON T.REQUIREMENT_TYPE_ID=A.REQUIREMENT_TYPE_ID)
  2092. GO
  2093.  
  2094. CREATE VIEW RICALM.VW_RQRMENT_BOOL_EXT (REQUIREMENT_ID, NAME, IDENTIFIER, DATATYPE, TYPE_NAME, TYPE_IDENTIFIER, ISSOFTDELETED, VAL) AS (SELECT E.REQUIREMENT_ID, A.NAME, A.IDENTIFIER, A.DATATYPE, T.NAME AS TYPENAME, T.IDENTIFIER AS TYPE_IDENTIFIER, E.ISSOFTDELETED, E.VAL FROM RICALM.RQRMENT_BOOL_EXT E JOIN RICALM.RQRMENT_ATTRDEF A ON A.REQUIREMENT_ATTRDEF_ID=E.REQUIREMENT_ATTRDEF_ID JOIN RICALM.RQRMENT_TYPE T ON T.REQUIREMENT_TYPE_ID=A.REQUIREMENT_TYPE_ID)
  2095. GO
  2096.  
  2097. CREATE VIEW RICALM.VW_RQRMENT_ENUMERATION (REQUIREMENT_ENUMERATION_ID, NAME, IDENTIFIER, DATATYPE, TYPE_NAME, TYPE_IDENTIFIER, LITERAL_NAME, REQUIREMENT_ID, EXTERNAL_ID, PROJECT_ID, ISSOFTDELETED) AS (SELECT E.REQUIREMENT_ENUMERATION_ID, A.NAME, A.IDENTIFIER, A.DATATYPE, T.NAME AS TYPENAME, T.IDENTIFIER AS TYPE_IDENTIFIER, E.LITERAL_NAME, E.REQUIREMENT_ID, E.EXTERNAL_ID, E.PROJECT_ID, E.ISSOFTDELETED FROM RICALM.RQRMENT_ENUMERATION E JOIN RICALM.RQRMENT_ATTRDEF A ON A.REQUIREMENT_ATTRDEF_ID=E.REQUIREMENT_ATTRDEF_ID JOIN RICALM.RQRMENT_TYPE T ON T.REQUIREMENT_TYPE_ID=A.REQUIREMENT_TYPE_ID)
  2098. GO
  2099.  
  2100. CREATE VIEW RICALM.VW_RQRMENT_HIS_STRING_EXT (REQUIREMENT_HISTORY_ID, NAME, IDENTIFIER, DATATYPE, TYPE_NAME, TYPE_IDENTIFIER, ISSOFTDELETED, VAL) AS (SELECT E.REQUIREMENT_HISTORY_ID, A.NAME, A.IDENTIFIER, A.DATATYPE, T.NAME AS TYPENAME, T.IDENTIFIER AS TYPE_IDENTIFIER, E.ISSOFTDELETED, E.VAL FROM RICALM.RQRMENT_HISTORY_STRING_EXT E JOIN RICALM.RQRMENT_ATTRDEF A ON A.REQUIREMENT_ATTRDEF_ID=E.REQUIREMENT_ATTRDEF_ID JOIN RICALM.RQRMENT_TYPE T ON T.REQUIREMENT_TYPE_ID=A.REQUIREMENT_TYPE_ID)
  2101. GO
  2102.  
  2103. CREATE VIEW RICALM.VW_RQRMENT_HIS_TIMESTAMP_EXT (REQUIREMENT_HISTORY_ID, NAME, IDENTIFIER, DATATYPE, TYPE_NAME, TYPE_IDENTIFIER, ISSOFTDELETED, VAL) AS (SELECT E.REQUIREMENT_HISTORY_ID, A.NAME, A.IDENTIFIER, A.DATATYPE, T.NAME AS TYPENAME, T.IDENTIFIER AS TYPE_IDENTIFIER, E.ISSOFTDELETED, E.VAL FROM RICALM.RQRMENT_HISTORY_TIMESTAMP_EXT E JOIN RICALM.RQRMENT_ATTRDEF A ON A.REQUIREMENT_ATTRDEF_ID=E.REQUIREMENT_ATTRDEF_ID JOIN RICALM.RQRMENT_TYPE T ON T.REQUIREMENT_TYPE_ID=A.REQUIREMENT_TYPE_ID)
  2104. GO
  2105.  
  2106. CREATE VIEW RICALM.VW_RQRMENT_HIS_STRING_L_EXT (REQUIREMENT_HISTORY_ID, NAME, IDENTIFIER, DATATYPE, TYPE_NAME, TYPE_IDENTIFIER, ISSOFTDELETED, VAL) AS (SELECT E.REQUIREMENT_HISTORY_ID, A.NAME, A.IDENTIFIER, A.DATATYPE, T.NAME AS TYPENAME, T.IDENTIFIER AS TYPE_IDENTIFIER, E.ISSOFTDELETED, E.VAL FROM RICALM.RQRMENT_HISTORY_STRING_L_EXT E JOIN RICALM.RQRMENT_ATTRDEF A ON A.REQUIREMENT_ATTRDEF_ID=E.REQUIREMENT_ATTRDEF_ID JOIN RICALM.RQRMENT_TYPE T ON T.REQUIREMENT_TYPE_ID=A.REQUIREMENT_TYPE_ID)
  2107. GO
  2108.  
  2109. CREATE VIEW RICALM.VW_RQRMENT_HIS_INT_EXT (REQUIREMENT_HISTORY_ID, NAME, IDENTIFIER, DATATYPE, TYPE_NAME, TYPE_IDENTIFIER, ISSOFTDELETED, VAL) AS (SELECT E.REQUIREMENT_HISTORY_ID, A.NAME, A.IDENTIFIER, A.DATATYPE, T.NAME AS TYPENAME, T.IDENTIFIER AS TYPE_IDENTIFIER, E.ISSOFTDELETED, E.VAL FROM RICALM.RQRMENT_HISTORY_INT_EXT E JOIN RICALM.RQRMENT_ATTRDEF A ON A.REQUIREMENT_ATTRDEF_ID=E.REQUIREMENT_ATTRDEF_ID JOIN RICALM.RQRMENT_TYPE T ON T.REQUIREMENT_TYPE_ID=A.REQUIREMENT_TYPE_ID)
  2110. GO
  2111.  
  2112. CREATE VIEW RICALM.VW_RQRMENT_HIS_BOOL_EXT (REQUIREMENT_HISTORY_ID, NAME, IDENTIFIER, DATATYPE, TYPE_NAME, TYPE_IDENTIFIER, ISSOFTDELETED, VAL) AS (SELECT E.REQUIREMENT_HISTORY_ID, A.NAME, A.IDENTIFIER, A.DATATYPE, T.NAME AS TYPENAME, T.IDENTIFIER AS TYPE_IDENTIFIER, E.ISSOFTDELETED, E.VAL FROM RICALM.RQRMENT_HISTORY_BOOL_EXT E JOIN RICALM.RQRMENT_ATTRDEF A ON A.REQUIREMENT_ATTRDEF_ID=E.REQUIREMENT_ATTRDEF_ID JOIN RICALM.RQRMENT_TYPE T ON T.REQUIREMENT_TYPE_ID=A.REQUIREMENT_TYPE_ID)
  2113. GO
  2114.  
  2115. CREATE VIEW RICALM.VW_RQRMENT_HIS_DECIMAL_EXT (REQUIREMENT_HISTORY_ID, NAME, IDENTIFIER, DATATYPE, TYPE_NAME, TYPE_IDENTIFIER, ISSOFTDELETED, VAL) AS (SELECT E.REQUIREMENT_HISTORY_ID, A.NAME, A.IDENTIFIER, A.DATATYPE, T.NAME AS TYPENAME, T.IDENTIFIER AS TYPE_IDENTIFIER, E.ISSOFTDELETED, E.VAL FROM RICALM.RQRMENT_HISTORY_DECIMAL_EXT E JOIN RICALM.RQRMENT_ATTRDEF A ON A.REQUIREMENT_ATTRDEF_ID=E.REQUIREMENT_ATTRDEF_ID JOIN RICALM.RQRMENT_TYPE T ON T.REQUIREMENT_TYPE_ID=A.REQUIREMENT_TYPE_ID)
  2116. GO
  2117.  
  2118. CREATE VIEW RICALM.VW_KEYWORD (KEYWORD_ID, KEYWORD_CLASS_ID, TITLE, TAG, DEFAULT_SCRIPT_ID, URL, REFERENCE_ID, EXTERNAL_ID, PROJECT_ID, EXTERNAL_KEY1, EXTERNAL_KEY2, SOURCE_ID, LAST_UPDATED, REC_DATETIME, ISSOFTDELETED) AS (SELECT K.KEYWORD_ID, KC.KEYWORD_CLASS_ID, K.TITLE, K.TAG, TS.TESTSCRIPT_ID AS DEFAULT_SCRIPT_ID, K.URL, K.REFERENCE_ID, K.EXTERNAL_ID, P.PROJECT_ID, K.EXTERNAL_KEY1, K.EXTERNAL_KEY2, K.SOURCE_ID, K.LAST_UPDATED, K.REC_DATETIME, K.ISSOFTDELETED FROM RICALM.KEYWORD K JOIN RICALM.KEYWORD_CLASSIFICATION KC ON KC.KEYWORD_CLASS_ID=K.KEYWORD_CLASS_ID JOIN RIODS.TESTSCRIPT TS ON TS.TESTSCRIPT_ID=K.DEFAULT_SCRIPT_ID JOIN RIODS.PROJECT P ON P.PROJECT_ID=K.PROJECT_ID)
  2119. GO
  2120.  
  2121. CREATE VIEW RICALM.VW_KEYWORD_CLASSIFICATION (KEYWORD_CLASS_ID, NAME, REC_DATETIME) AS (SELECT KC.KEYWORD_CLASS_ID, KC.NAME, KC.REC_DATETIME FROM RICALM.KEYWORD_CLASSIFICATION KC)
  2122. GO
  2123.  
  2124. CREATE VIEW RICALM.VW_KEYWORD_SCRIPT_LOOKUP (KEYWORD_ID, TESTSCRIPT_ID) AS (SELECT K.KEYWORD_ID, TS.TESTSCRIPT_ID FROM RICALM.KEYWORD_SCRIPT_LOOKUP KSL JOIN RICALM.KEYWORD K ON K.KEYWORD_ID=KSL.KEYWORD_ID JOIN RIODS.TESTSCRIPT TS ON TS.TESTSCRIPT_ID=KSL.TESTSCRIPT_ID)
  2125. GO
  2126.  
  2127. CREATE VIEW RICALM.VW_QUALITY_OBJECTIVE (OBJECTIVE_ID, OBJECTIVE_CLASS_ID, TITLE, DESCRIPTION, CREATOR_ID, OPERATOR, TARGET_VALUE, EVALUATOR_ID, URL, REFERENCE_ID, EXTERNAL_ID, PROJECT_ID, EXTERNAL_KEY1, EXTERNAL_KEY2, SOURCE_ID, LAST_UPDATED, REC_DATETIME, ISSOFTDELETED) AS (SELECT Q.OBJECTIVE_ID, QC.OBJECTIVE_CLASS_ID, Q.TITLE, Q.DESCRIPTION, R.RESOURCE_ID AS CREATOR_ID, Q.OPERATOR, Q.TARGET_VALUE, Q.EVALUATOR_ID, Q.URL, Q.REFERENCE_ID, Q.EXTERNAL_ID, P.PROJECT_ID, Q.EXTERNAL_KEY1, Q.EXTERNAL_KEY2, Q.SOURCE_ID, Q.LAST_UPDATED, Q.REC_DATETIME, Q.ISSOFTDELETED FROM RICALM.QUALITY_OBJECTIVE Q JOIN RICALM.OBJECTIVE_CLASSIFICATION QC ON QC.OBJECTIVE_CLASS_ID=Q.OBJECTIVE_CLASS_ID JOIN RIODS.RESOURCE R ON R.RESOURCE_ID=Q.CREATOR_ID JOIN RIODS.PROJECT P ON P.PROJECT_ID=Q.PROJECT_ID)
  2128. GO
  2129.  
  2130. CREATE VIEW RICALM.VW_OBJECTIVE_CLASSIFICATION (OBJECTIVE_CLASS_ID, NAME, REC_DATETIME) AS (SELECT QC.OBJECTIVE_CLASS_ID, QC.NAME, QC.REC_DATETIME FROM RICALM.OBJECTIVE_CLASSIFICATION QC)
  2131. GO
  2132.  
  2133. CREATE VIEW RICALM.VW_TESTPLAN_OBJECTIVESTATUS (TESTPLAN_OBJECTIVESTATUS_ID, TESTPLAN_ID, OBJECTIVE_ID, GROUP_ORDER, ACTUAL_VALUE, STATE, COMMENT, ISSOFTDELETED) AS (SELECT OS.TESTPLAN_OBJECTIVESTATUS_ID, TP.TESTPLAN_ID, Q.OBJECTIVE_ID, OS.GROUP_ORDER, OS.ACTUAL_VALUE, OS.STATE, OS.COMMENT, OS.ISSOFTDELETED FROM RICALM.TESTPLAN_OBJECTIVESTATUS OS JOIN RIODS.TESTPLAN TP ON TP.TESTPLAN_ID=OS.TESTPLAN_ID JOIN RICALM.QUALITY_OBJECTIVE Q ON Q.OBJECTIVE_ID=OS.OBJECTIVE_ID)
  2134. GO
  2135.  
  2136. CREATE VIEW RICALM.VW_TESTPLAN_OBJECTIVE_LOOKUP (TESTPLAN_ID, OBJECTIVE_ID) AS (SELECT TP.TESTPLAN_ID, Q.OBJECTIVE_ID FROM RICALM.TESTPLAN_OBJECTIVE_LOOKUP TPQL JOIN RIODS.TESTPLAN TP ON TP.TESTPLAN_ID=TPQL.TESTPLAN_ID JOIN RICALM.QUALITY_OBJECTIVE Q ON Q.OBJECTIVE_ID=TPQL.OBJECTIVE_ID)
  2137. GO
  2138.  
  2139. CREATE VIEW RICALM.VW_LABREQUEST (LABREQUEST_ID, LABREQUEST_CLASS_ID, TITLE, SUMMARY, COMMENTS, CREATE_DATE, CONFIRMATION_DATE, REQUESTER_ID, FULFILLER_ID, PRIORITY, CURRENT_STATE, VISIBLE_ID, CONFIGURATION, RESERVE_FROM, RESERVE_TO, URL, REFERENCE_ID, EXTERNAL_ID, PROJECT_ID, EXTERNAL_KEY1, EXTERNAL_KEY2, SOURCE_ID, LAST_UPDATED, REC_DATETIME, ISSOFTDELETED) AS (SELECT Q.LABREQUEST_ID, QC.LABREQUEST_CLASS_ID, Q.TITLE, Q.SUMMARY, Q.COMMENTS, Q.CREATE_DATE, Q.CONFIRMATION_DATE, REQER.RESOURCE_ID AS REQUESTER_ID, FFER.RESOURCE_ID AS FULFILLER_ID, Q.PRIORITY, Q.CURRENT_STATE, Q.VISIBLE_ID, Q.CONFIGURATION, Q.RESERVE_FROM, Q.RESERVE_TO, Q.URL, Q.REFERENCE_ID, Q.EXTERNAL_ID, P.PROJECT_ID, Q.EXTERNAL_KEY1, Q.EXTERNAL_KEY2, Q.SOURCE_ID, Q.LAST_UPDATED, Q.REC_DATETIME, Q.ISSOFTDELETED FROM RICALM.LABREQUEST Q JOIN RICALM.LABREQUEST_CLASSIFICATION QC ON QC.LABREQUEST_CLASS_ID=Q.LABREQUEST_CLASS_ID JOIN RIODS.RESOURCE REQER ON REQER.RESOURCE_ID=Q.REQUESTER_ID JOIN RIODS.RESOURCE FFER
  2140. ON FFER.RESOURCE_ID=Q.FULFILLER_ID JOIN RIODS.PROJECT P ON P.PROJECT_ID=Q.PROJECT_ID)
  2141. GO
  2142.  
  2143. CREATE VIEW RICALM.VW_LABREQUEST_CLASSIFICATION (LABREQUEST_CLASS_ID, NAME, REC_DATETIME) AS (SELECT QC.LABREQUEST_CLASS_ID, QC.NAME, QC.REC_DATETIME FROM RICALM.LABREQUEST_CLASSIFICATION QC)
  2144. GO
  2145.  
  2146. CREATE VIEW RICALM.VW_LABREQUEST_CHANGESTATE (CHANGESTATE_ID, LABREQUEST_ID, STATE_UUID, FROM_STATE, TO_STATE, FROM_TIME, TO_TIME, USER_ID, ISSOFTDELETED) AS (SELECT QS.CHANGESTATE_ID, Q.LABREQUEST_ID, QS.STATE_UUID, QS.FROM_STATE, QS.TO_STATE, QS.FROM_TIME, QS.TO_TIME, R.RESOURCE_ID AS USER_ID, QS.ISSOFTDELETED FROM RICALM.LABREQUEST_CHANGESTATE QS JOIN RICALM.LABREQUEST Q ON Q.LABREQUEST_ID=QS.LABREQUEST_ID JOIN RIODS.RESOURCE R ON R.RESOURCE_ID=QS.USER_ID)
  2147. GO
  2148.  
  2149. CREATE VIEW RICALM.VW_RESERVATION_LABREQ_LOOKUP (RESERVATION_ID, LABREQUEST_ID) AS (SELECT R.RESERVATION_ID, Q.LABREQUEST_ID FROM RICALM.RESERVATION_LABREQUEST_LOOKUP RQL JOIN RIODS.RESERVATION R ON R.RESERVATION_ID=RQL.RESERVATION_ID JOIN RICALM.LABREQUEST Q ON Q.LABREQUEST_ID=RQL.LABREQUEST_ID)
  2150. GO
  2151.  
  2152. CREATE VIEW RICALM.VW_TESTPLAN_STRING_EXT (TESTPLAN_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TP.TESTPLAN_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTPLAN_STRING_EXT E JOIN RIODS.TESTPLAN TP ON TP.TESTPLAN_ID=E.TESTPLAN_ID)
  2153. GO
  2154.  
  2155. CREATE VIEW RICALM.VW_TESTPLAN_STRING_M_EXT (TESTPLAN_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TP.TESTPLAN_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTPLAN_STRING_M_EXT E JOIN RIODS.TESTPLAN TP ON TP.TESTPLAN_ID=E.TESTPLAN_ID)
  2156. GO
  2157.  
  2158. CREATE VIEW RICALM.VW_TESTPLAN_INT_EXT (TESTPLAN_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TP.TESTPLAN_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTPLAN_INT_EXT E JOIN RIODS.TESTPLAN TP ON TP.TESTPLAN_ID=E.TESTPLAN_ID)
  2159. GO
  2160.  
  2161. CREATE VIEW RICALM.VW_TESTPLAN_TIMESTAMP_EXT (TESTPLAN_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TP.TESTPLAN_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTPLAN_TIMESTAMP_EXT E JOIN RIODS.TESTPLAN TP ON TP.TESTPLAN_ID=E.TESTPLAN_ID)
  2162. GO
  2163.  
  2164. CREATE VIEW RICALM.VW_TESTCASE_STRING_EXT (TESTCASE_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TC.TESTCASE_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTCASE_STRING_EXT E JOIN RIODS.TESTCASE TC ON TC.TESTCASE_ID=E.TESTCASE_ID)
  2165. GO
  2166.  
  2167. CREATE VIEW RICALM.VW_TESTCASE_STRING_M_EXT (TESTCASE_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TC.TESTCASE_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTCASE_STRING_M_EXT E JOIN RIODS.TESTCASE TC ON TC.TESTCASE_ID=E.TESTCASE_ID)
  2168. GO
  2169.  
  2170. CREATE VIEW RICALM.VW_TESTCASE_INT_EXT (TESTCASE_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TC.TESTCASE_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTCASE_INT_EXT E JOIN RIODS.TESTCASE TC ON TC.TESTCASE_ID=E.TESTCASE_ID)
  2171. GO
  2172.  
  2173. CREATE VIEW RICALM.VW_TESTCASE_TIMESTAMP_EXT (TESTCASE_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TC.TESTCASE_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTCASE_TIMESTAMP_EXT E JOIN RIODS.TESTCASE TC ON TC.TESTCASE_ID=E.TESTCASE_ID)
  2174. GO
  2175.  
  2176. CREATE VIEW RICALM.VW_TESTSCRIPT_STRING_EXT (TESTSCRIPT_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TS.TESTSCRIPT_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTSCRIPT_STRING_EXT E JOIN RIODS.TESTSCRIPT TS ON TS.TESTSCRIPT_ID=E.TESTSCRIPT_ID)
  2177. GO
  2178.  
  2179. CREATE VIEW RICALM.VW_TESTSCRIPT_STRING_M_EXT (TESTSCRIPT_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TS.TESTSCRIPT_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTSCRIPT_STRING_M_EXT E JOIN RIODS.TESTSCRIPT TS ON TS.TESTSCRIPT_ID=E.TESTSCRIPT_ID)
  2180. GO
  2181.  
  2182. CREATE VIEW RICALM.VW_TESTSCRIPT_INT_EXT (TESTSCRIPT_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TS.TESTSCRIPT_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTSCRIPT_INT_EXT E JOIN RIODS.TESTSCRIPT TS ON TS.TESTSCRIPT_ID=E.TESTSCRIPT_ID)
  2183. GO
  2184.  
  2185. CREATE VIEW RICALM.VW_TESTSCRIPT_TIMESTAMP_EXT (TESTSCRIPT_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TS.TESTSCRIPT_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTSCRIPT_TIMESTAMP_EXT E JOIN RIODS.TESTSCRIPT TS ON TS.TESTSCRIPT_ID=E.TESTSCRIPT_ID)
  2186. GO
  2187.  
  2188. CREATE VIEW RICALM.VW_TESTSUITE_STRING_EXT (TESTSUITE_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TS.TESTSUITE_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTSUITE_STRING_EXT E JOIN RIODS.TESTSUITE TS ON TS.TESTSUITE_ID=E.TESTSUITE_ID)
  2189. GO
  2190.  
  2191. CREATE VIEW RICALM.VW_TESTSUITE_STRING_M_EXT (TESTSUITE_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TS.TESTSUITE_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTSUITE_STRING_M_EXT E JOIN RIODS.TESTSUITE TS ON TS.TESTSUITE_ID=E.TESTSUITE_ID)
  2192. GO
  2193.  
  2194. CREATE VIEW RICALM.VW_TESTSUITE_INT_EXT (TESTSUITE_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TS.TESTSUITE_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTSUITE_INT_EXT E JOIN RIODS.TESTSUITE TS ON TS.TESTSUITE_ID=E.TESTSUITE_ID)
  2195. GO
  2196.  
  2197. CREATE VIEW RICALM.VW_TESTSUITE_TIMESTAMP_EXT (TESTSUITE_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TS.TESTSUITE_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTSUITE_TIMESTAMP_EXT E JOIN RIODS.TESTSUITE TS ON TS.TESTSUITE_ID=E.TESTSUITE_ID)
  2198. GO
  2199.  
  2200. CREATE VIEW RICALM.VW_EXECWORKITEM_STRING_EXT (EXECWORKITEM_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT EWI.EXECWORKITEM_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.EXECWORKITEM_STRING_EXT E JOIN RIODS.EXECUTION_WORKITEM EWI ON EWI.EXECWORKITEM_ID=E.EXECWORKITEM_ID)
  2201. GO
  2202.  
  2203. CREATE VIEW RICALM.VW_EXECWORKITEM_STRING_M_EXT (EXECWORKITEM_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT EWI.EXECWORKITEM_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.EXECWORKITEM_STRING_M_EXT E JOIN RIODS.EXECUTION_WORKITEM EWI ON EWI.EXECWORKITEM_ID=E.EXECWORKITEM_ID)
  2204. GO
  2205.  
  2206. CREATE VIEW RICALM.VW_EXECWORKITEM_INT_EXT (EXECWORKITEM_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT EWI.EXECWORKITEM_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.EXECWORKITEM_INT_EXT E JOIN RIODS.EXECUTION_WORKITEM EWI ON EWI.EXECWORKITEM_ID=E.EXECWORKITEM_ID)
  2207. GO
  2208.  
  2209. CREATE VIEW RICALM.VW_EXECWORKITEM_TIMESTAMP_EXT (EXECWORKITEM_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT EWI.EXECWORKITEM_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.EXECWORKITEM_TIMESTAMP_EXT E JOIN RIODS.EXECUTION_WORKITEM EWI ON EWI.EXECWORKITEM_ID=E.EXECWORKITEM_ID)
  2210. GO
  2211.  
  2212. CREATE VIEW RICALM.VW_TSTSUITEXECREC_STRING_EXT (TESTSUITE_EXECRECORD_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT T.TESTSUITE_EXECRECORD_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TSTSUITEXECREC_STRING_EXT E JOIN RIODS.TESTSUITE_EXECUTION_RECORD T ON T.TESTSUITE_EXECRECORD_ID=E.TESTSUITE_EXECRECORD_ID)
  2213. GO
  2214.  
  2215. CREATE VIEW RICALM.VW_TSTSUITEXECREC_STRING_M_EXT (TESTSUITE_EXECRECORD_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT T.TESTSUITE_EXECRECORD_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TSTSUITEXECREC_STRING_M_EXT E JOIN RIODS.TESTSUITE_EXECUTION_RECORD T ON T.TESTSUITE_EXECRECORD_ID=E.TESTSUITE_EXECRECORD_ID)
  2216. GO
  2217.  
  2218. CREATE VIEW RICALM.VW_TSTSUITEXECREC_INT_EXT (TESTSUITE_EXECRECORD_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT T.TESTSUITE_EXECRECORD_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TSTSUITEXECREC_INT_EXT E JOIN RIODS.TESTSUITE_EXECUTION_RECORD T ON T.TESTSUITE_EXECRECORD_ID=E.TESTSUITE_EXECRECORD_ID)
  2219. GO
  2220.  
  2221. CREATE VIEW RICALM.VW_TSTSUITEXCREC_TIMESTAMP_EXT (TESTSUITE_EXECRECORD_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT T.TESTSUITE_EXECRECORD_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TSTSUITEXECREC_TIMESTAMP_EXT E JOIN RIODS.TESTSUITE_EXECUTION_RECORD T ON T.TESTSUITE_EXECRECORD_ID=E.TESTSUITE_EXECRECORD_ID)
  2222. GO
  2223.  
  2224. CREATE VIEW RICALM.VW_EXECRES_STRING_EXT (EXECUTION_RESULT_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT ER.EXECUTION_RESULT_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.EXECRES_STRING_EXT E JOIN RIODS.EXECUTION_RESULT ER ON ER.EXECUTION_RESULT_ID=E.EXECUTION_RESULT_ID)
  2225. GO
  2226.  
  2227. CREATE VIEW RICALM.VW_EXECRES_STRING_M_EXT (EXECUTION_RESULT_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT ER.EXECUTION_RESULT_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.EXECRES_STRING_M_EXT E JOIN RIODS.EXECUTION_RESULT ER ON ER.EXECUTION_RESULT_ID=E.EXECUTION_RESULT_ID)
  2228. GO
  2229.  
  2230. CREATE VIEW RICALM.VW_EXECRES_INT_EXT (EXECUTION_RESULT_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT ER.EXECUTION_RESULT_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.EXECRES_INT_EXT E JOIN RIODS.EXECUTION_RESULT ER ON ER.EXECUTION_RESULT_ID=E.EXECUTION_RESULT_ID)
  2231. GO
  2232.  
  2233. CREATE VIEW RICALM.VW_EXECRES_TIMESTAMP_EXT (EXECUTION_RESULT_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT ER.EXECUTION_RESULT_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.EXECRES_TIMESTAMP_EXT E JOIN RIODS.EXECUTION_RESULT ER ON ER.EXECUTION_RESULT_ID=E.EXECUTION_RESULT_ID)
  2234. GO
  2235.  
  2236. CREATE VIEW RICALM.VW_TESTSUITELOG_STRING_EXT (TESTSUITELOG_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TSL.TESTSUITELOG_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTSUITELOG_STRING_EXT E JOIN RIODS.TESTSUITELOG TSL ON TSL.TESTSUITELOG_ID=E.TESTSUITELOG_ID)
  2237. GO
  2238.  
  2239. CREATE VIEW RICALM.VW_TESTSUITELOG_STRING_M_EXT (TESTSUITELOG_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TSL.TESTSUITELOG_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTSUITELOG_STRING_M_EXT E JOIN RIODS.TESTSUITELOG TSL ON TSL.TESTSUITELOG_ID=E.TESTSUITELOG_ID)
  2240. GO
  2241.  
  2242. CREATE VIEW RICALM.VW_TESTSUITELOG_INT_EXT (TESTSUITELOG_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TSL.TESTSUITELOG_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTSUITELOG_INT_EXT E JOIN RIODS.TESTSUITELOG TSL ON TSL.TESTSUITELOG_ID=E.TESTSUITELOG_ID)
  2243. GO
  2244.  
  2245. CREATE VIEW RICALM.VW_TESTSUITELOG_TIMESTAMP_EXT (TESTSUITELOG_ID, IDENTIFIER, NAME, VAR, ISSOFTDELETED) AS (SELECT TSL.TESTSUITELOG_ID, E.IDENTIFIER, E.NAME, E.VAR, E.ISSOFTDELETED FROM RICALM.TESTSUITELOG_TIMESTAMP_EXT E JOIN RIODS.TESTSUITELOG TSL ON TSL.TESTSUITELOG_ID=E.TESTSUITELOG_ID)
  2246. GO
  2247.  
  2248. CREATE VIEW RICALM.VW_ITERATION_EXEC_DETAIL (ITER_EXEC_DETAIL_ID, ITERATION_ID, COMMENT, EXEC_DATE, POINT_ATTEMPTED, POINT_COMPLETED, ISSOFTDELETED) AS (SELECT D.ITER_EXEC_DETAIL_ID, I.ITERATION_ID, D.COMMENT, D.EXEC_DATE, D.POINT_ATTEMPTED, D.POINT_COMPLETED, D.ISSOFTDELETED FROM RICALM.ITERATION_EXEC_DETAIL D JOIN RIODS.ITERATION I ON I.ITERATION_ID=D.ITERATION_ID)
  2249. GO
  2250.  
  2251. CREATE VIEW RICALM.VW_RQRMNT_EXT_LINK (EXTERNAL_ID, PRED_REQUIREMENT_ID, PRED_REQUIREMENT_NAME, LINK_TYPE_ID, LINK_TYPE, EXTERNAL_LABEL, EXTERNAL_URL) AS (SELECT EL.EXTERNAL_ID, EL.PRED_REQUIREMENT_ID, R.NAME AS PRED_REQUIREMENT_NAME, EL.LINK_TYPE_ID, LT.NAME AS LINK_TYPE, EL.EXTERNAL_LABEL, EL.EXTERNAL_URL FROM RICALM.REQUIREMENT_EXTERNAL_LINK EL JOIN RIODS.REQUIREMENT R ON R.REQUIREMENT_ID=EL.PRED_REQUIREMENT_ID JOIN RIODS.REQUIREMENT_LINK_TYPE LT ON LT.LINK_TYPE_ID=EL.LINK_TYPE_ID)
  2252. GO
  2253.  
  2254. CREATE VIEW RICALM.VW_RQRMENT_ATTRDEF (REQUIREMENT_ATTRDEF_ID, REQUIREMENT_TYPE_ID, REQUIREMENT_TYPE_NAME, IDENTIFIER, NAME, DATATYPE, IS_ENUMERATION, ISSOFTDELETED, PROJECT_ID, PROJECT_NAME) AS (SELECT AD.REQUIREMENT_ATTRDEF_ID, RT.REQUIREMENT_TYPE_ID, RT.NAME AS REQUIREMENT_TYPE_NAME, AD.IDENTIFIER, AD.NAME, AD.DATATYPE, AD.IS_ENUMERATION, AD.ISSOFTDELETED, PJ.PROJECT_ID, PJ.NAME AS PROJECT_NAME FROM RICALM.RQRMENT_ATTRDEF AD JOIN RICALM.RQRMENT_TYPE_ATTRDEF MAP ON AD.REQUIREMENT_ATTRDEF_ID = MAP.REQUIREMENT_ATTRDEF_ID JOIN RICALM.RQRMENT_TYPE RT ON MAP.REQUIREMENT_TYPE_ID = RT.REQUIREMENT_TYPE_ID JOIN RIODS.PROJECT PJ ON PJ.PROJECT_ID = RT.PROJECT_ID)
  2255. GO
  2256.  
  2257. CREATE VIEW RICALM.VW_RQRMENT_TYPE (REQUIREMENT_TYPE_ID, IDENTIFIER, NAME, PROJECT_ID, PROJECT_NAME, ISSOFTDELETED) AS (SELECT RT.REQUIREMENT_TYPE_ID, RT.IDENTIFIER, RT.NAME, RT.PROJECT_ID, PJ.NAME AS PROJECT_NAME, RT.ISSOFTDELETED FROM RICALM.RQRMENT_TYPE RT JOIN RIODS.PROJECT PJ ON PJ.PROJECT_ID=RT.PROJECT_ID)
  2258. GO
  2259.  
  2260. USE [RIDW]
  2261. GO
  2262.  
  2263. CREATE SCHEMA AUTHORIZATION CONFIG
  2264. GO
  2265.  
  2266. INSERT INTO CONFIG.SYSCONFIG_INFO(INFO_ID,NAME,DISPLAY_NAME,INT_VALUE,CHAR_VALUE) VALUES (16,'CALM_VERSION','CALM Warehouse Version',6,'4.0.3')
  2267. GO
  2268.  
  2269. INSERT INTO CONFIG.SYSCONFIG_INFO(INFO_ID,NAME,DISPLAY_NAME,INT_VALUE,CHAR_VALUE) VALUES (17,'CALM_MINOR_VERSION','CALM Warehouse Minor Version',30,'4.0.3 RC2')
  2270. GO
  2271.  
  2272. CREATE SCHEMA AUTHORIZATION RICALM
  2273. GO
  2274.  
  2275. INSERT INTO RICALM.REQUEST_APPROVAL_TYPE (REQUEST_APPROVAL_TYPE_ID, NAME) VALUES (-1,'Info not available')
  2276. GO
  2277.  
  2278. INSERT INTO RICALM.REQUEST_APPROVAL_STATE (REQUEST_APPROVAL_STATE_ID, NAME) VALUES (-1,'Info not available')
  2279. GO
  2280.  
  2281. INSERT INTO RICALM.REQUEST_APPROVAL_DESCRIPTOR (REQUEST_APPROVAL_DESCRIPTOR_ID, NAME) VALUES (-1,'Info not available')
  2282. GO
  2283.  
  2284. INSERT INTO RICALM.GROUP_NAME_FACET (GROUP_NAME_FACET_ID, GROUP_NAME, NAME, FACET) VALUES (-1,'Info not available', 'Info not available', 'Info not available')
  2285. GO
  2286.  
  2287. INSERT INTO RICALM.REQUEST_HISTORY (REQUEST_HISTORY_ID,NAME) VALUES (-1,'Info not available')
  2288. GO
  2289.  
  2290. INSERT INTO RICALM.KEYWORD_CLASSIFICATION (KEYWORD_CLASS_ID,NAME) VALUES (-1,'Info not available')
  2291. GO
  2292.  
  2293. INSERT INTO RICALM.KEYWORD_CLASSIFICATION (KEYWORD_CLASS_ID,NAME) VALUES (1,'RQM KeyWord')
  2294. GO
  2295.  
  2296. INSERT INTO RICALM.OBJECTIVE_CLASSIFICATION (OBJECTIVE_CLASS_ID,NAME) VALUES (-1,'Info not available')
  2297. GO
  2298.  
  2299. INSERT INTO RICALM.OBJECTIVE_CLASSIFICATION (OBJECTIVE_CLASS_ID,NAME) VALUES (1,'RQM Quality Objective')
  2300. GO
  2301.  
  2302. INSERT INTO RICALM.LABREQUEST_CLASSIFICATION (LABREQUEST_CLASS_ID,NAME) VALUES (-1,'Info not available')
  2303. GO
  2304.  
  2305. INSERT INTO RICALM.LABREQUEST_CLASSIFICATION (LABREQUEST_CLASS_ID,NAME) VALUES (1,'RQM Lab Request')
  2306. GO
  2307.  
  2308. INSERT INTO RICALM.KEYWORD (KEYWORD_ID,TITLE) VALUES (-1,'Info not available')
  2309. GO
  2310.  
  2311. INSERT INTO RICALM.QUALITY_OBJECTIVE (OBJECTIVE_ID,TITLE) VALUES (-1,'Info not available')
  2312. GO
  2313.  
  2314. INSERT INTO RICALM.TESTPLAN_OBJECTIVESTATUS (TESTPLAN_OBJECTIVESTATUS_ID) VALUES (-1)
  2315. GO
  2316.  
  2317. INSERT INTO RICALM.LABREQUEST (LABREQUEST_ID,TITLE) VALUES (-1,'Info not available')
  2318. GO
  2319.  
  2320. INSERT INTO RICALM.LABREQUEST_CHANGESTATE (CHANGESTATE_ID) VALUES (-1)
  2321. GO
  2322.  
  2323. INSERT INTO RICALM.TESTPLAN_STRING_EXT (TESTPLAN_ID, NAME, VAR) VALUES (-1, 'Info not available', 'Info not available')
  2324. GO
  2325.  
  2326. INSERT INTO RICALM.TESTPLAN_STRING_M_EXT (TESTPLAN_ID, NAME, VAR) VALUES (-1, 'Info not available', 'Info not available')
  2327. GO
  2328.  
  2329. INSERT INTO RICALM.TESTPLAN_INT_EXT (TESTPLAN_ID, NAME, VAR) VALUES (-1, 'Info not available', -1)
  2330. GO
  2331.  
  2332. INSERT INTO RICALM.TESTPLAN_TIMESTAMP_EXT (TESTPLAN_ID, NAME, VAR) VALUES (-1, 'Info not available', GETDATE())
  2333. GO
  2334.  
  2335. INSERT INTO RICALM.TESTCASE_STRING_EXT (TESTCASE_ID, NAME, VAR) VALUES (-1, 'Info not available', 'Info not available')
  2336. GO
  2337.  
  2338. INSERT INTO RICALM.TESTCASE_STRING_M_EXT (TESTCASE_ID, NAME, VAR) VALUES (-1, 'Info not available', 'Info not available')
  2339. GO
  2340.  
  2341. INSERT INTO RICALM.TESTCASE_INT_EXT (TESTCASE_ID, NAME, VAR) VALUES (-1, 'Info not available', -1)
  2342. GO
  2343.  
  2344. INSERT INTO RICALM.TESTCASE_TIMESTAMP_EXT (TESTCASE_ID, NAME, VAR) VALUES (-1, 'Info not available', GETDATE())
  2345. GO
  2346.  
  2347. INSERT INTO RICALM.TESTSCRIPT_STRING_EXT (TESTSCRIPT_ID, NAME, VAR) VALUES (-1, 'Info not available', 'Info not available')
  2348. GO
  2349.  
  2350. INSERT INTO RICALM.TESTSCRIPT_STRING_M_EXT (TESTSCRIPT_ID, NAME, VAR) VALUES (-1, 'Info not available', 'Info not available')
  2351. GO
  2352.  
  2353. INSERT INTO RICALM.TESTSCRIPT_INT_EXT (TESTSCRIPT_ID, NAME, VAR) VALUES (-1, 'Info not available', -1)
  2354. GO
  2355.  
  2356. INSERT INTO RICALM.TESTSCRIPT_TIMESTAMP_EXT (TESTSCRIPT_ID, NAME, VAR) VALUES (-1, 'Info not available', GETDATE())
  2357. GO
  2358.  
  2359. INSERT INTO RICALM.TESTSUITE_STRING_EXT (TESTSUITE_ID, NAME, VAR) VALUES (-1, 'Info not available', 'Info not available')
  2360. GO
  2361.  
  2362. INSERT INTO RICALM.TESTSUITE_STRING_M_EXT (TESTSUITE_ID, NAME, VAR) VALUES (-1, 'Info not available', 'Info not available')
  2363. GO
  2364.  
  2365. INSERT INTO RICALM.TESTSUITE_INT_EXT (TESTSUITE_ID, NAME, VAR) VALUES (-1, 'Info not available', -1)
  2366. GO
  2367.  
  2368. INSERT INTO RICALM.TESTSUITE_TIMESTAMP_EXT (TESTSUITE_ID, NAME, VAR) VALUES (-1, 'Info not available', GETDATE())
  2369. GO
  2370.  
  2371. INSERT INTO RICALM.EXECWORKITEM_STRING_EXT (EXECWORKITEM_ID, NAME, VAR) VALUES (-1, 'Info not available', 'Info not available')
  2372. GO
  2373.  
  2374. INSERT INTO RICALM.EXECWORKITEM_STRING_M_EXT (EXECWORKITEM_ID, NAME, VAR) VALUES (-1, 'Info not available', 'Info not available')
  2375. GO
  2376.  
  2377. INSERT INTO RICALM.EXECWORKITEM_INT_EXT (EXECWORKITEM_ID, NAME, VAR) VALUES (-1, 'Info not available', -1)
  2378. GO
  2379.  
  2380. INSERT INTO RICALM.EXECWORKITEM_TIMESTAMP_EXT (EXECWORKITEM_ID, NAME, VAR) VALUES (-1, 'Info not available', GETDATE())
  2381. GO
  2382.  
  2383. INSERT INTO RICALM.TSTSUITEXECREC_STRING_EXT (TESTSUITE_EXECRECORD_ID, NAME, VAR) VALUES (-1, 'Info not available', 'Info not available')
  2384. GO
  2385.  
  2386. INSERT INTO RICALM.TSTSUITEXECREC_STRING_M_EXT (TESTSUITE_EXECRECORD_ID, NAME, VAR) VALUES (-1, 'Info not available', 'Info not available')
  2387. GO
  2388.  
  2389. INSERT INTO RICALM.TSTSUITEXECREC_INT_EXT (TESTSUITE_EXECRECORD_ID, NAME, VAR) VALUES (-1, 'Info not available', -1)
  2390. GO
  2391.  
  2392. INSERT INTO RICALM.TSTSUITEXECREC_TIMESTAMP_EXT (TESTSUITE_EXECRECORD_ID, NAME, VAR) VALUES (-1, 'Info not available', GETDATE())
  2393. GO
  2394.  
  2395. INSERT INTO RICALM.EXECRES_STRING_EXT (EXECUTION_RESULT_ID, NAME, VAR) VALUES (-1, 'Info not available', 'Info not available')
  2396. GO
  2397.  
  2398. INSERT INTO RICALM.EXECRES_STRING_M_EXT (EXECUTION_RESULT_ID, NAME, VAR) VALUES (-1, 'Info not available', 'Info not available')
  2399. GO
  2400.  
  2401. INSERT INTO RICALM.EXECRES_INT_EXT (EXECUTION_RESULT_ID, NAME, VAR) VALUES (-1, 'Info not available', -1)
  2402. GO
  2403.  
  2404. INSERT INTO RICALM.EXECRES_TIMESTAMP_EXT (EXECUTION_RESULT_ID, NAME, VAR) VALUES (-1, 'Info not available', GETDATE())
  2405. GO
  2406.  
  2407. INSERT INTO RICALM.TESTSUITELOG_STRING_EXT (TESTSUITELOG_ID, NAME, VAR) VALUES (-1, 'Info not available', 'Info not available')
  2408. GO
  2409.  
  2410. INSERT INTO RICALM.TESTSUITELOG_STRING_M_EXT (TESTSUITELOG_ID, NAME, VAR) VALUES (-1, 'Info not available', 'Info not available')
  2411. GO
  2412.  
  2413. INSERT INTO RICALM.TESTSUITELOG_INT_EXT (TESTSUITELOG_ID, NAME, VAR) VALUES (-1, 'Info not available', -1)
  2414. GO
  2415.  
  2416. INSERT INTO RICALM.TESTSUITELOG_TIMESTAMP_EXT (TESTSUITELOG_ID, NAME, VAR) VALUES (-1, 'Info not available', GETDATE())
  2417. GO
  2418.  
  2419. INSERT INTO RICALM.ITERATION_EXEC_DETAIL (ITER_EXEC_DETAIL_ID) VALUES (-1)
  2420. GO
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top