API tools faq
paste
Advertisement
Guest User

6-createCalmSchema

a guest
Nov 18th, 2013
731
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 153.46 KB | None | 0 0
raw download clone embed print report
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!