1. Once we are done with DRM installation, we need to create application. Update DB details and do test connection. Test connection must be successful.
2. Create schema and schema objects using below scripts. Otherwise we can run Create repository wizard also. If schema already created, execute following script on that DRM DB.
3. If we are migrating from one environment to another, go to repository wizard, select copy or Upgrade existing repository option
4. Update Source database details, test connection and click Next
5. Once system analyse the objects, click next
6. Update Target database details, test connection and click next
7. Review Source and Target schema details and click Next to start copy.
8. Once copy finished and click on Finish and restart DRM service to access application.
DRM-11016: Connection was established with the server but the connection parameters do not reference a valid DRM database. Error message: Invalid object name 'DAL_Version' To Create Database in SQL Database:/****** IMPORTANT INSTRUCTIONS FOR DATABASE ADMINISTRATORS *********
* This script must be run by a DBA. It creates a new database and a new *
* user which will serve as the database login for the Data Relationship *
* Management service. *
* *
* The sp_addlogin password parameter was supplied during configuration of *
* the new repository. Before running the script, you may want to change *
* the supplied password. If you do change the password, the new password *
* must be provided to the Oracle DRM administrator before the Oracle DRM *
* service can be started. *
* *
* A separate script has been generated to create the schema objects. *
****************************************************************************
Oracle Data Relationship Management
Database Name: <SchemaName>
Schema Version: 11.1.2.4.340.1
*/
CREATE DATABASE <SchemaName>
ON (NAME = <SchemaName>,
FILENAME = 'E:\MSSQL_HFMDEV\UserData\<SchemaName>.mdf',
SIZE = 7301)
LOG ON (NAME = <SchemaName>_log,
FILENAME = 'F:\MSSQL_HFMDEV\UserLog\<SchemaName>_log.ldf',
SIZE = 1825)
GO
ALTER DATABASE <SchemaName> SET ALLOW_SNAPSHOT_ISOLATION ON
GO
ALTER DATABASE <SchemaName> SET READ_COMMITTED_SNAPSHOT ON
GO
USE <SchemaName>
GO
IF NOT EXISTS(SELECT * FROM master.dbo.syslogins WHERE loginname = '<DBAUSER>')
EXEC sp_addlogin <DBAUSER>, '<password>', <SchemaName>
GO
IF NOT EXISTS(SELECT * FROM sysusers WHERE name = '<DBAUSER>')
EXEC sp_grantdbaccess <DBAUSER>
GO
EXEC sp_addrolemember db_owner, <DBAUSER>
GO
******************************************************************************
To Create Objects in Database:/******** IMPORTANT! READ THIS BEFORE EXECUTING THE SCRIPT **********
* *
* This script creates the objects within a newly created or otherwise empty *
* database. Be sure you are using an empty database that is dedicated for *
* use by the Data Relationship Management service. *
* *
*****************************************************************************
Oracle Hyperion Data Relationship Management
Database Name: <SchemaName>
Schema Version: 11.1.2.4.340.1
*/
USE <SchemaName>
GO
CREATE TABLE dbo.DAL_Sequence
(
c_key nvarchar(30) NOT NULL,
i_id int NOT NULL,
c_primary_table nvarchar(30) NULL
);
CREATE TABLE dbo.DAL_Updates
(
c_version nvarchar(40) NOT NULL,
b_failed bit NULL,
c_message nvarchar(2000) NULL
);
CREATE TABLE dbo.RM_Access_Group_Ctrl_Hier
(
i_security_id int NOT NULL,
i_version_id int NOT NULL,
i_hierarchy_id int NOT NULL
);
CREATE TABLE dbo.RM_Access_Group_Definition
(
i_security_id int NOT NULL,
c_abbrev nvarchar(255) NOT NULL,
c_descr nvarchar(2000) NULL,
i_order int NULL,
b_global bit NOT NULL,
c_label nvarchar(255) NOT NULL,
e_access_group_type nvarchar(30) NOT NULL,
c_css_group_name nvarchar(256) NULL
);
CREATE TABLE dbo.RM_Access_Group_Prop_Global
(
i_version_id int NOT NULL,
i_node_id int NOT NULL,
i_security_id int NOT NULL,
b_leaf bit NOT NULL,
b_locked bit NOT NULL,
e_access_level nvarchar(30) NOT NULL,
e_workflow_access_level nvarchar(30) NOT NULL
);
CREATE TABLE dbo.RM_Access_Group_Prop_Local
(
i_version_id int NOT NULL,
i_hierarchy_id int NOT NULL,
i_node_id int NOT NULL,
i_security_id int NOT NULL,
b_leaf bit NOT NULL,
b_locked bit NOT NULL,
e_access_level nvarchar(30) NOT NULL,
e_workflow_access_level nvarchar(30) NOT NULL
);
CREATE TABLE dbo.RM_Access_Group_User
(
i_security_id int NOT NULL,
i_user_id int NOT NULL
);
CREATE TABLE dbo.RM_Blender
(
i_blender_id int NOT NULL,
i_user_id int NOT NULL,
c_abbrev nvarchar(255) NOT NULL,
c_descr nvarchar(2000) NULL,
b_disable_rt_validations bit NOT NULL,
i_allowed_errors int NOT NULL,
b_create_version_copy bit NOT NULL,
b_allow_hierarchy_create bit NOT NULL,
i_maximum_passes int NOT NULL,
b_populate_blend_properties bit NOT NULL,
b_clear_blend_properties bit NOT NULL,
b_all_hierarchies bit NOT NULL,
b_default_all_hierarchies bit NOT NULL,
b_process_structure bit NOT NULL,
b_process_adds bit NOT NULL,
b_process_removes bit NOT NULL,
c_property_selection_mode nvarchar(20) NOT NULL,
c_remove_mode nvarchar(20) NOT NULL,
c_remove_indicator_property nvarchar(255) NULL,
c_version_blended_property nvarchar(255) NULL,
c_hierarchy_blended_property nvarchar(255) NULL,
c_node_created_property nvarchar(255) NULL,
c_node_added_property nvarchar(255) NULL,
c_node_moved_property nvarchar(255) NULL,
c_node_global_changed_property nvarchar(255) NULL,
c_node_local_changed_property nvarchar(255) NULL,
b_propagate_locks bit NOT NULL,
c_propagate_mode nvarchar(20) NOT NULL,
b_promote_leafs bit NOT NULL,
c_leaf_promoted_property nvarchar(255) NULL,
b_process_activations bit NOT NULL,
b_process_hier_val_assignments bit NOT NULL,
b_process_ver_val_assignments bit NOT NULL,
c_source_version_abbrev nvarchar(255) NULL,
c_target_version_abbrev nvarchar(255) NULL,
e_domain_name_blend_method nvarchar(30) NOT NULL,
b_create_domains_in_target bit NULL,
c_domain_holding_property nvarchar(255) NULL,
c_global_domain_name nvarchar(255) NULL,
c_domain_node_assigned_prop nvarchar(255) NULL,
i_access_group_id int NOT NULL,
b_target_version_from_param bit NULL,
c_copy_version_abbrev nvarchar(255) NULL,
c_copy_version_descr nvarchar(255) NULL
);
CREATE TABLE dbo.RM_Blender_Default_Param
(
i_blender_id int NOT NULL,
c_parameter nvarchar(40) NOT NULL,
x_value ntext NULL
);
CREATE TABLE dbo.RM_Blender_Hierarchy_Set
(
i_blender_id int NOT NULL,
i_hierarchy_set_id int NOT NULL,
i_blender_property_list_id int NULL,
c_source_hierarchy_abbrev nvarchar(255) NULL,
c_source_top_node_abbrev nvarchar(255) NULL,
c_target_hierarchy_abbrev nvarchar(255) NULL,
c_target_top_node_abbrev nvarchar(255) NULL,
b_process_structure bit NOT NULL,
b_process_adds bit NOT NULL,
b_process_removes bit NOT NULL,
c_remove_mode nvarchar(20) NOT NULL,
c_property_selection_mode nvarchar(20) NOT NULL,
c_remove_indicator_property nvarchar(255) NULL,
b_use_profile_defaults bit NOT NULL,
b_process_activations bit NOT NULL,
b_process_hier_val_assignments bit NOT NULL,
c_domain_holding_property nvarchar(255) NULL
);
CREATE TABLE dbo.RM_Blender_Property_List
(
i_blender_id int NOT NULL,
i_blender_property_list_id int NOT NULL,
b_default bit NOT NULL
);
CREATE TABLE dbo.RM_Blender_Property_List_Item
(
i_blender_id int NOT NULL,
i_blender_property_list_id int NOT NULL,
i_blender_property_item_id int NOT NULL,
c_prop_def_abbrev nvarchar(255) NOT NULL,
b_propagate_locks bit NOT NULL,
c_propagate_mode nvarchar(20) NOT NULL,
e_blender_list_property_action nvarchar(20) NOT NULL
);
CREATE TABLE dbo.RM_Book
(
i_book_id int NOT NULL,
i_user_id int NOT NULL,
c_book_name nvarchar(255) NULL,
c_book_descr nvarchar(2000) NULL,
c_pre_filename nvarchar(255) NULL,
c_post_filename nvarchar(255) NULL,
c_combined_filename nvarchar(255) NULL,
b_combine bit NOT NULL,
d_current_asof_datetime datetime NULL,
i_current_asof_offset_days int NULL,
i_current_asof_id int NULL,
e_version_type_param__current nvarchar(30) NOT NULL,
d_previous_asof_datetime datetime NULL,
i_previous_asof_offset_days int NULL,
i_previous_asof_id int NULL,
e_version_type_param__previous nvarchar(30) NOT NULL,
e_as_of_method__current nvarchar(30) NOT NULL,
e_as_of_method__previous nvarchar(30) NOT NULL,
i_current_asof_offset_time int NOT NULL,
i_previous_asof_offset_time int NOT NULL,
c_pre_file_connection nvarchar(40) NULL,
c_post_file_connection nvarchar(40) NULL,
c_combined_file_connection nvarchar(40) NULL,
b_client_output bit NULL,
c_current_version_abbrev nvarchar(255) NULL,
c_previous_version_abbrev nvarchar(255) NULL,
i_combined_file_codepage int NULL,
i_access_group_id int NOT NULL
);
CREATE TABLE dbo.RM_Book_Default_Param
(
i_book_id int NOT NULL,
c_parameter nvarchar(40) NOT NULL,
x_value ntext NULL
);
CREATE TABLE dbo.RM_Book_Item
(
i_book_id int NOT NULL,
i_book_item_id int NOT NULL,
i_export_id int NOT NULL
);
CREATE TABLE dbo.RM_Category
(
i_category_id int NOT NULL,
c_category_code nvarchar(255) NOT NULL,
c_descr nvarchar(2000) NULL,
i_order int NULL,
c_css_group_name_readonly nvarchar(256) NULL,
c_css_group_name_edit nvarchar(256) NULL
);
CREATE TABLE dbo.RM_Category_User
(
i_user_id int NOT NULL,
i_category_id int NOT NULL,
e_access_level nvarchar(30) NOT NULL
);
CREATE TABLE dbo.RM_Compare
(
i_compare_id int NOT NULL,
i_user_id int NOT NULL,
i_query_id int NULL,
c_from_hier nvarchar(255) NULL,
c_to_hier nvarchar(255) NULL,
c_from_node nvarchar(255) NULL,
c_to_node nvarchar(255) NULL,
b_differences bit NOT NULL,
b_user_defined bit NOT NULL,
b_compare_limbs bit NOT NULL,
b_compare_leafs bit NOT NULL,
e_comparison_type nvarchar(30) NOT NULL,
b_expand_marks bit NOT NULL,
c_compare_abbrev nvarchar(255) NULL,
c_compare_descr nvarchar(2000) NULL,
b_include_filter bit NOT NULL,
b_rename_check bit NOT NULL,
e_as_of_method__current nvarchar(30) NOT NULL,
d_current_asof_datetime datetime NULL,
i_current_asof_offset_days int NULL,
i_current_asof_id int NULL,
e_version_type_param__current nvarchar(30) NOT NULL,
e_as_of_method__previous nvarchar(30) NOT NULL,
d_previous_asof_datetime datetime NULL,
i_previous_asof_offset_days int NULL,
i_previous_asof_id int NULL,
e_version_type_param__previous nvarchar(30) NOT NULL,
c_join_property_abbrev nvarchar(255) NULL,
b_show_list bit NOT NULL,
b_mark_nodes bit NOT NULL,
i_current_asof_offset_time int NOT NULL,
i_previous_asof_offset_time int NOT NULL,
b_include_compare_properties bit NOT NULL,
c_current_version_abbrev nvarchar(255) NULL,
c_previous_version_abbrev nvarchar(255) NULL,
i_access_group_id int NOT NULL
);
CREATE TABLE dbo.RM_Compare_Default_Param
(
i_compare_id int NOT NULL,
c_parameter nvarchar(40) NOT NULL,
x_value ntext NULL
);
CREATE TABLE dbo.RM_Compare_Item
(
i_compare_id int NOT NULL,
i_item_id int NOT NULL,
c_property_abbrev nvarchar(255) NOT NULL,
i_order int NULL
);
CREATE TABLE dbo.RM_Config_Info
(
c_key nvarchar(255) NOT NULL,
c_value nvarchar(1000) NULL
);
CREATE TABLE dbo.RM_Connection
(
i_connection_id int NOT NULL,
c_name nvarchar(40) NOT NULL,
c_description nvarchar(2000) NULL,
e_connection_type nvarchar(40) NOT NULL,
c_connection_info nvarchar(1024) NULL,
c_connection_string nvarchar(1024) NULL,
c_connection_key nvarchar(2000) NULL,
i_user_id int NOT NULL,
c_user_name nvarchar(200) NULL,
c_password nvarchar(510) NULL,
i_access_group_id int NOT NULL,
e_web_service_protocol nvarchar(40) NOT NULL,
c_host_name nvarchar(1024) NULL,
i_port int NULL,
e_authentication_type nvarchar(40) NOT NULL
);
CREATE TABLE dbo.RM_Connection_Allowed_Table
(
i_connection_id int NOT NULL,
c_table_name nvarchar(128) NOT NULL,
b_is_read_only bit NULL,
b_is_view bit NULL,
c_owner nvarchar(256) NOT NULL
);
CREATE TABLE dbo.RM_Connection_Operation
(
i_connection_id int NOT NULL,
i_operation_id int NOT NULL,
c_name nvarchar(128) NOT NULL,
c_description nvarchar(255) NULL,
e_request_method nvarchar(30) NOT NULL,
x_uri ntext NULL,
x_header ntext NULL,
x_body ntext NULL,
c_list_identifier nvarchar(1024) NULL,
e_operation_type nvarchar(30) NOT NULL,
e_db_operation nvarchar(30) NOT NULL
);
CREATE TABLE dbo.RM_Connection_Operation_Column
(
i_connection_id int NOT NULL,
i_operation_id int NOT NULL,
c_column_name nvarchar(128) NOT NULL,
i_order int NULL,
c_expression nvarchar(1024) NULL
);
CREATE TABLE dbo.RM_Connection_Operation_Param
(
i_connection_id int NOT NULL,
i_operation_id int NOT NULL,
c_param_name nvarchar(128) NOT NULL,
c_description nvarchar(255) NULL,
i_order int NULL,
c_data_type nvarchar(255) NULL,
e_param_direction nvarchar(30) NOT NULL,
c_test_value nvarchar(255) NULL,
b_is_result_param bit NULL
);
CREATE TABLE dbo.RM_Derived_Property
(
c_deriver_class nvarchar(20) NOT NULL,
e_data_type nvarchar(30) NOT NULL,
c_label nvarchar(40) NULL,
c_descr nvarchar(2000) NULL,
c_required_abbrev nvarchar(255) NOT NULL,
b_required bit NOT NULL
);
CREATE TABLE dbo.RM_Derived_Property_Param
(
c_deriver_class nvarchar(20) NOT NULL,
i_template_id int NOT NULL,
e_data_type nvarchar(30) NOT NULL,
c_label nvarchar(40) NULL,
c_descr nvarchar(255) NULL,
c_value nvarchar(2000) NULL
);
CREATE TABLE dbo.RM_Domain
(
i_domain_id int NOT NULL,
c_abbrev nvarchar(255) NOT NULL,
c_descr nvarchar(2000) NULL,
c_qualifier nvarchar(2000) NULL,
b_qualifier_suffix bit NULL,
c_delimiter nvarchar(255) NULL,
b_can_edit_leaf bit NULL,
b_can_delete_nodes bit NULL
);
CREATE TABLE dbo.RM_Domain_Node
(
i_domain_id int NOT NULL,
i_domain_node_id int NOT NULL,
c_domain_node_abbrev nvarchar(255) NOT NULL,
c_domain_node_descr nvarchar(255) NOT NULL,
d_inactive_date datetime NULL,
i_update_id int NULL
);
CREATE TABLE dbo.RM_Domain_Validations
(
i_domain_id int NOT NULL,
i_validation_id int NOT NULL,
e_validation_type nvarchar(255) NOT NULL
);
CREATE TABLE dbo.RM_Domain_Version
(
i_domain_id int NOT NULL,
i_version_id int NOT NULL
);
CREATE TABLE dbo.RM_Engine_Info
(
i_id int NOT NULL,
c_engine_id nvarchar(255) NOT NULL,
c_application nvarchar(255) NOT NULL,
c_machine_name nvarchar(255) NOT NULL,
i_ping_frequency int NOT NULL,
d_last_ping datetime NOT NULL
);
CREATE TABLE dbo.RM_Export
(
i_export_id int NOT NULL,
i_validation_id int NULL,
i_query_id int NULL,
e_export_output_mode nvarchar(30) NOT NULL,
i_export_type_id int NOT NULL,
i_user_id int NOT NULL,
b_quoted_strings bit NOT NULL,
c_delimiter nvarchar(8) NULL,
b_fixed_width bit NOT NULL,
c_output_filename nvarchar(255) NULL,
c_export_abbrev nvarchar(255) NULL,
c_export_descr nvarchar(2000) NULL,
b_column_headers bit NOT NULL,
b_include_inactive bit NOT NULL,
i_access_group_id int NOT NULL
);
CREATE TABLE dbo.RM_Export_Column
(
i_export_id int NOT NULL,
i_column_id int NOT NULL,
i_width int NOT NULL,
c_title nvarchar(255) NULL,
c_default_value nvarchar(255) NULL,
x_key ntext NULL,
c_column_class nvarchar(40) NOT NULL,
c_padchar nvarchar(1) NULL,
e_export_column_layout nvarchar(30) NOT NULL,
b_pivot bit NOT NULL,
b_skip_default bit NOT NULL,
b_primarykey bit NOT NULL,
c_db_field_name nvarchar(255) NULL,
i_db_field_len int NOT NULL,
e_db_field_type nvarchar(30) NOT NULL,
b_db_key_field bit NOT NULL,
e_export_column_case nvarchar(30) NOT NULL
);
CREATE TABLE dbo.RM_Export_Default_Param
(
i_export_id int NOT NULL,
c_parameter nvarchar(40) NOT NULL,
x_value ntext NULL
);
CREATE TABLE dbo.RM_Export_Node
(
i_export_id int NOT NULL,
i_export_node_id int NOT NULL,
c_hierarchy_abbrev nvarchar(255) NULL,
c_node_abbrev nvarchar(255) NULL
);
CREATE TABLE dbo.RM_Export_Node_Prop
(
i_export_id int NOT NULL,
i_export_node_id int NOT NULL,
c_property_abbrev nvarchar(255) NOT NULL
);
CREATE TABLE dbo.RM_Export_Param
(
i_export_id int NOT NULL,
i_export_param_id int NOT NULL,
c_key nvarchar(40) NULL,
x_value ntext NULL
);
CREATE TABLE dbo.RM_Export_Type
(
i_export_type_id int NOT NULL,
c_export_class nvarchar(60) NOT NULL,
c_export_label nvarchar(80) NULL,
c_descr nvarchar(2000) NULL,
c_namespace nvarchar(200) NULL,
c_assembly_name nvarchar(80) NULL,
b_enabled bit NOT NULL
);
CREATE TABLE dbo.RM_Glyph
(
i_glyph_id int NOT NULL,
c_descr nvarchar(2000) NULL,
m_glyph image NULL,
c_abbrev nvarchar(255) NULL,
e_image_type nvarchar(50) NOT NULL
);
CREATE TABLE dbo.RM_Hierarchy
(
i_version_id int NOT NULL,
i_hierarchy_id int NOT NULL,
c_abbrev nvarchar(255) NULL,
c_descr nvarchar(255) NULL,
i_top_node_id int NULL,
i_order int NULL,
i_hierarchy_group_id int NULL,
i_user_id int NULL,
i_node_count int NOT NULL,
i_limb_count int NOT NULL,
i_leaf_count int NOT NULL,
i_primary_count int NOT NULL,
i_shared_count int NOT NULL,
b_full_count_flag bit NOT NULL,
d_count_update_timestamp datetime NULL
);
CREATE TABLE dbo.RM_Hierarchy_Group
(
i_hierarchy_group_id int NOT NULL,
c_name nvarchar(255) NOT NULL,
c_descr nvarchar(2000) NULL,
i_order int NULL
);
CREATE TABLE dbo.RM_Hierarchy_Prop
(
i_version_id int NOT NULL,
i_hierarchy_id int NOT NULL,
i_property_id int NOT NULL,
x_value ntext NULL
);
CREATE TABLE dbo.RM_Import
(
i_import_id int NOT NULL,
i_import_type_id int NULL,
i_user_id int NOT NULL,
c_import_abbrev nvarchar(255) NULL,
c_import_descr nvarchar(2000) NULL,
i_access_group_id int NOT NULL
);
CREATE TABLE dbo.RM_Import_Class
(
c_import_class nvarchar(40) NOT NULL,
c_import_label nvarchar(40) NULL,
c_import_descr nvarchar(2000) NULL
);
CREATE TABLE dbo.RM_Import_Default_Param
(
i_import_id int NOT NULL,
c_parameter nvarchar(40) NOT NULL,
x_value ntext NULL
);
CREATE TABLE dbo.RM_Import_Param
(
i_import_id int NOT NULL,
i_import_param_id int NOT NULL,
c_key nvarchar(20) NOT NULL,
x_value ntext NULL
);
CREATE TABLE dbo.RM_Import_Section
(
i_import_id int NOT NULL,
i_import_section_id int NOT NULL,
e_import_section_type nvarchar(30) NOT NULL,
b_process_section bit NOT NULL
);
CREATE TABLE dbo.RM_Import_Section_Column
(
i_import_id int NOT NULL,
i_import_section_id int NOT NULL,
i_import_section_column_id int NOT NULL,
c_property_abbrev nvarchar(255) NULL,
c_display_label nvarchar(255) NULL,
b_ignore_column bit NOT NULL,
b_is_structure_column bit NOT NULL
);
CREATE TABLE dbo.RM_Import_Section_Column_Hier
(
i_import_id int NOT NULL,
i_import_section_id int NOT NULL,
i_import_section_column_id int NOT NULL,
i_import_section_column_hierid int NOT NULL,
c_hier_abbrev nvarchar(255) NOT NULL
);
CREATE TABLE dbo.RM_Import_Section_Column_Param
(
i_import_id int NOT NULL,
i_import_section_id int NOT NULL,
i_import_section_column_id int NOT NULL,
i_import_param_id int NOT NULL,
c_key nvarchar(20) NULL,
c_value nvarchar(2000) NULL
);
CREATE TABLE dbo.RM_Import_Section_Param
(
i_import_id int NOT NULL,
i_import_section_id int NOT NULL,
i_import_param_id int NOT NULL,
c_key nvarchar(20) NULL,
c_value nvarchar(2000) NULL
);
CREATE TABLE dbo.RM_Import_Type
(
i_import_type_id int NOT NULL,
c_import_class nvarchar(40) NOT NULL,
c_import_label nvarchar(40) NULL,
c_import_descr nvarchar(2000) NULL
);
CREATE TABLE dbo.RM_Job_History
(
i_job_id int NOT NULL,
x_job_description ntext NULL,
e_job_type nvarchar(30) NOT NULL,
e_job_status nvarchar(30) NOT NULL,
d_time_started datetime NOT NULL,
d_time_finished datetime NULL,
d_results_viewed datetime NULL,
i_session_id int NOT NULL,
c_user_name nvarchar(255) NOT NULL,
c_machine_name nvarchar(255) NOT NULL,
i_process_id int NOT NULL,
i_thread_id int NOT NULL,
i_percent_complete int NULL,
c_progress_message nvarchar(2000) NULL,
c_originating_object_name nvarchar(255) NULL,
m_originating_object image NULL,
c_exception_message nvarchar(2000) NULL,
d_results_purged datetime NULL,
c_purge_reason nvarchar(2000) NULL,
c_version_from nvarchar(255) NULL,
c_version_to nvarchar(255) NULL,
i_results_size int NULL,
b_cancellable bit NULL,
b_user_notified bit NULL
);
CREATE TABLE dbo.RM_Job_History_Result
(
i_job_id int NOT NULL,
i_detail_id int NOT NULL,
c_description nvarchar(255) NULL,
m_job_result image NULL
);
CREATE TABLE dbo.RM_Merge_Log
(
i_merge_log_id int NOT NULL,
i_version_id int NOT NULL,
i_node_id int NOT NULL,
d_time datetime NULL,
c_version nvarchar(255) NULL,
c_user_name nvarchar(100) NOT NULL,
e_merge_action nvarchar(60) NOT NULL,
i_deleted_id int NULL,
c_deleted_abbrev nvarchar(255) NULL,
c_deleted_descr nvarchar(255) NULL,
i_merged_id int NULL,
c_merged_abbrev nvarchar(255) NULL,
c_merged_descr nvarchar(255) NULL,
i_delete_log_id int NULL
);
CREATE TABLE dbo.RM_Node
(
i_version_id int NOT NULL,
i_node_id int NOT NULL,
c_abbrev nvarchar(255) NOT NULL,
c_descr nvarchar(255) NULL,
b_leaf bit NOT NULL,
b_inactive bit NOT NULL,
b_approved bit NOT NULL,
c_added_by nvarchar(100) NULL,
d_added_on datetime NULL,
c_changed_by nvarchar(100) NULL,
d_changed_on datetime NULL,
b_node_changed bit NULL,
i_domain_id int NULL
);
CREATE TABLE dbo.RM_Node_Merge
(
i_version_id int NOT NULL,
i_node_id int NOT NULL,
i_merge_id int NOT NULL,
i_merge_log_id int NULL
);
CREATE TABLE dbo.RM_Node_Prop_Global
(
i_version_id int NOT NULL,
i_node_id int NOT NULL,
i_property_id int NOT NULL,
x_value ntext NULL,
b_locked bit NOT NULL
);
CREATE TABLE dbo.RM_Node_Prop_Local
(
i_version_id int NOT NULL,
i_hierarchy_id int NOT NULL,
i_node_id int NOT NULL,
i_property_id int NOT NULL,
x_value ntext NULL,
b_locked bit NOT NULL
);
CREATE TABLE dbo.RM_Node_Type
(
i_node_type_id int NOT NULL,
c_abbrev nvarchar(255) NOT NULL,
i_glyph_id int NULL,
c_descr nvarchar(2000) NULL
);
CREATE TABLE dbo.RM_Node_Type_Property
(
i_node_type_id int NOT NULL,
i_property_id int NOT NULL
);
CREATE TABLE dbo.RM_Node_Type_Validation
(
i_node_type_id int NOT NULL,
i_validation_id int NOT NULL
);
CREATE TABLE dbo.RM_Notification
(
i_notification_id int NOT NULL,
i_user_id int NOT NULL,
e_notification_method nvarchar(30) NOT NULL,
d_created datetime NOT NULL,
x_subject ntext NULL,
d_alert_fetched datetime NULL,
d_email_next_try datetime NULL,
c_last_bounce_reason nvarchar(2000) NULL,
i_email_send_failures int NULL,
d_email_sent datetime NULL,
b_from_previous_session bit NULL,
c_object_class nvarchar(255) NOT NULL,
i_object_id int NULL
);
CREATE TABLE dbo.RM_Notification_Detail
(
i_notification_id int NOT NULL,
m_message image NULL
);
CREATE TABLE dbo.RM_Object_Access_Group
(
i_access_group_id int NOT NULL,
c_abbrev nvarchar(255) NOT NULL,
c_label nvarchar(255) NOT NULL,
c_descr nvarchar(2000) NULL,
b_user_defined bit NOT NULL
);
CREATE TABLE dbo.RM_Object_Access_Group_Nag
(
i_access_group_id int NOT NULL,
i_security_id int NOT NULL,
e_object_access_level nvarchar(30) NOT NULL
);
CREATE TABLE dbo.RM_Object_Access_Group_User
(
i_access_group_id int NOT NULL,
i_user_id int NOT NULL,
e_object_access_level nvarchar(30) NOT NULL
);
CREATE TABLE dbo.RM_Property_Category
(
i_property_id int NOT NULL,
i_category_id int NOT NULL,
i_order int NULL
);
CREATE TABLE dbo.RM_Property_Constraint
(
i_property_id int NOT NULL,
c_constraint_name nvarchar(50) NOT NULL,
c_key nvarchar(50) NOT NULL,
x_value ntext NULL
);
CREATE TABLE dbo.RM_Property_Ctrl_Hier
(
i_property_id int NOT NULL,
i_version_id int NOT NULL,
i_hierarchy_id int NOT NULL
);
CREATE TABLE dbo.RM_Property_Definition
(
i_property_id int NOT NULL,
c_abbrev nvarchar(255) NOT NULL,
e_prop_type nvarchar(30) NOT NULL,
e_data_type nvarchar(30) NOT NULL,
c_default_value nvarchar(255) NULL,
c_min_value nvarchar(255) NULL,
c_max_value nvarchar(255) NULL,
c_label nvarchar(255) NOT NULL,
c_descr nvarchar(2000) NULL,
b_global bit NOT NULL,
b_list bit NOT NULL,
b_cascade bit NOT NULL,
b_hidden bit NOT NULL,
i_lookup_id int NULL,
i_column_width int NOT NULL,
c_deriver_class nvarchar(20) NULL,
e_prop_level nvarchar(30) NOT NULL,
i_assigned_domain_id int NULL,
b_indexed bit NULL,
i_connection_id int NULL,
i_operation_id int NULL,
c_key_column_name nvarchar(255) NULL
);
CREATE TABLE dbo.RM_Property_External_Col_Map
(
i_property_id int NOT NULL,
i_target_property_id int NOT NULL,
c_column_name nvarchar(128) NOT NULL
);
CREATE TABLE dbo.RM_Property_External_Param_Map
(
i_property_id int NOT NULL,
c_parameter_name nvarchar(128) NOT NULL,
e_parameter_source nvarchar(30) NOT NULL,
x_parameter_value ntext NULL
);
CREATE TABLE dbo.RM_Property_List
(
i_property_id int NOT NULL,
i_order int NOT NULL,
c_value nvarchar(255) NULL
);
CREATE TABLE dbo.RM_Property_Lookup
(
i_property_id int NOT NULL,
c_lookup_value nvarchar(255) NOT NULL,
c_result_value nvarchar(255) NULL
);
CREATE TABLE dbo.RM_Property_Param
(
i_property_id int NOT NULL,
i_param_id int NOT NULL,
c_label nvarchar(40) NOT NULL,
e_data_type nvarchar(30) NOT NULL,
c_descr nvarchar(255) NULL,
x_value ntext NULL
);
CREATE TABLE dbo.RM_Property_Query
(
i_query_id int NOT NULL,
i_user_id int NOT NULL,
c_hier_abbrev nvarchar(255) NULL,
c_node_abbrev nvarchar(255) NULL,
b_expand_list bit NOT NULL,
b_inclusive bit NOT NULL,
b_expand_marks bit NOT NULL,
c_query_abbrev nvarchar(255) NULL,
c_query_descr nvarchar(2000) NULL,
b_user_defined bit NOT NULL,
b_global_query bit NOT NULL,
b_include_filter bit NOT NULL,
b_display_criteria bit NOT NULL,
e_as_of_method nvarchar(30) NOT NULL,
d_asof_datetime datetime NULL,
i_asof_offset_days int NULL,
i_asof_id int NULL,
e_version_type_param nvarchar(30) NOT NULL,
b_show_list bit NOT NULL,
b_mark_nodes bit NOT NULL,
b_include_parents bit NOT NULL,
b_include_children bit NOT NULL,
i_asof_offset_time int NOT NULL,
c_version_abbrev nvarchar(255) NULL,
i_access_group_id int NOT NULL
);
CREATE TABLE dbo.RM_Query_Criteria
(
i_query_id int NOT NULL,
i_criteria_id int NOT NULL,
e_comparison_operator nvarchar(30) NOT NULL,
c_property_abbrev nvarchar(255) NOT NULL,
b_incl_inherited bit NOT NULL,
c_value nvarchar(255) NULL,
e_join_operator nvarchar(30) NOT NULL,
i_open_parens int NULL,
i_close_parens int NULL
);
CREATE TABLE dbo.RM_Query_Default_Param
(
i_query_id int NOT NULL,
c_parameter nvarchar(40) NOT NULL,
x_value ntext NULL
);
CREATE TABLE dbo.RM_Relationship
(
i_version_id int NOT NULL,
i_parent_id int NOT NULL,
i_child_id int NOT NULL
);
CREATE TABLE dbo.RM_Request
(
i_request_id int NOT NULL,
c_version_abbrev nvarchar(255) NULL,
c_owned_by nvarchar(255) NULL,
b_approved bit NOT NULL,
b_validated bit NOT NULL,
c_created_by nvarchar(255) NULL,
c_updated_by nvarchar(255) NULL,
c_approved_by nvarchar(255) NULL,
d_created_on datetime NULL,
d_updated_on datetime NULL,
d_approved_on datetime NULL,
c_committed_by nvarchar(255) NULL,
c_external_id nvarchar(255) NULL,
c_external_label nvarchar(255) NULL,
c_external_status nvarchar(255) NULL,
x_workflow_info ntext NULL,
x_comment ntext NULL
);
CREATE TABLE dbo.RM_Request_Item
(
i_request_id int NOT NULL,
i_request_item_id int NOT NULL,
c_action nvarchar(255) NOT NULL,
c_hier_abbrev nvarchar(255) NULL,
c_node_abbrev nvarchar(255) NULL,
m_request_item_data image NULL
);
CREATE TABLE dbo.RM_Request_Verification
(
i_request_id int NOT NULL,
i_sequence int NOT NULL,
c_verification_abbrev nvarchar(255) NULL
);
CREATE TABLE dbo.RM_Role
(
i_role_id int NOT NULL,
c_role_name nvarchar(30) NOT NULL,
e_role_type nvarchar(30) NOT NULL
);
CREATE TABLE dbo.RM_Role_Permission
(
i_role_id int NOT NULL,
e_permission nvarchar(50) NOT NULL
);
CREATE TABLE dbo.RM_Scheduled_Tasks
(
i_task_id int NOT NULL,
c_task_name nvarchar(40) NOT NULL,
c_description nvarchar(255) NOT NULL,
d_last_run datetime NULL,
d_next_run datetime NULL,
c_last_duration nvarchar(20) NULL,
i_interval int NOT NULL,
e_interval_units nvarchar(30) NOT NULL,
d_next_blackout datetime NULL,
i_blackout_duration int NULL,
c_last_status nvarchar(80) NULL,
c_notes nvarchar(255) NULL
);
CREATE TABLE dbo.RM_Session_Info
(
i_session_id int NOT NULL,
i_user_id int NOT NULL,
i_session_logon_id int NOT NULL,
b_prompt_to_change_password bit NOT NULL,
i_days_of_grace_left int NOT NULL,
b_must_change_password bit NOT NULL,
c_error_code nvarchar(255) NULL,
c_error_description nvarchar(255) NULL,
d_logon_time datetime NOT NULL,
d_last_accessed datetime NOT NULL,
x_session_parameters ntext NULL
);
CREATE TABLE dbo.RM_System_Preference
(
c_keyword nvarchar(40) NOT NULL,
e_data_type nvarchar(30) NOT NULL,
c_value nvarchar(2000) NULL,
c_min_value nvarchar(255) NULL,
c_max_value nvarchar(255) NULL,
c_label nvarchar(255) NULL,
c_descr nvarchar(255) NULL,
c_allowed_values nvarchar(255) NULL,
b_list bit NULL,
b_requires_restart bit NULL,
b_hidden bit NULL
);
CREATE TABLE dbo.RM_Transaction_History
(
i_transaction_id int NOT NULL,
i_detail_id int NOT NULL,
d_timestamp datetime NULL,
i_session_id int NULL,
c_user_name nvarchar(100) NOT NULL,
c_action nvarchar(40) NULL,
c_action_level nvarchar(40) NULL,
c_version_abbrev nvarchar(255) NULL,
i_version_id int NULL,
c_hierarchy_abbrev nvarchar(255) NULL,
i_hierarchy_id int NULL,
c_node_abbrev nvarchar(255) NULL,
i_node_id int NULL,
c_node_descr nvarchar(255) NULL,
c_property_abbrev nvarchar(255) NULL,
i_property_id int NULL,
b_leaf bit NOT NULL,
c_action_description nvarchar(1024) NULL,
x_from_value ntext NULL,
c_from_origin nvarchar(1024) NULL,
x_to_value ntext NULL,
c_to_origin nvarchar(1024) NULL,
i_originating_id int NULL,
i_originating_detail_id int NULL,
c_object_name nvarchar(255) NULL,
i_domain_id int NULL,
c_domain_abbrev nvarchar(255) NULL,
i_workflow_request_id int NULL,
i_workflow_request_item_id int NULL,
c_node_type nvarchar(255) NULL
);
CREATE TABLE dbo.RM_User
(
i_user_id int NOT NULL,
c_user_name nvarchar(100) NOT NULL,
c_full_name nvarchar(255) NULL,
c_department nvarchar(40) NULL,
c_phone_number nvarchar(20) NULL,
c_password nvarchar(255) NULL,
d_password_expire_date datetime NULL,
e_user_auth_method nvarchar(20) NOT NULL,
i_invalid_login_count int NOT NULL,
d_last_valid_login datetime NULL,
b_login_lockout bit NOT NULL,
c_login_lockout_reason nvarchar(100) NULL,
d_login_lockout_timestamp datetime NULL,
b_change_pass_on_login bit NOT NULL,
b_current_enc bit NULL,
b_exclude_from_timeout bit NULL,
b_no_password_expiration bit NULL,
b_exclude_from_lockout bit NULL,
c_email_address nvarchar(255) NULL
);
CREATE TABLE dbo.RM_User_Prop_Hierarchy
(
i_version_id int NOT NULL,
i_hierarchy_id int NOT NULL,
i_user_id int NOT NULL,
i_property_id int NOT NULL,
x_value ntext NULL
);
CREATE TABLE dbo.RM_User_Prop_Version
(
i_version_id int NOT NULL,
i_user_id int NOT NULL,
i_property_id int NOT NULL,
c_value nvarchar(255) NULL
);
CREATE TABLE dbo.RM_User_Property_Definition
(
i_user_property_id int NOT NULL,
c_abbrev nvarchar(255) NOT NULL,
e_data_type nvarchar(30) NOT NULL,
c_default_value nvarchar(255) NULL,
c_min_value nvarchar(255) NULL,
c_max_value nvarchar(255) NULL,
c_label nvarchar(255) NOT NULL,
c_descr nvarchar(2000) NULL,
b_hidden bit NOT NULL,
i_column_width int NOT NULL,
i_order int NULL,
e_prop_level nvarchar(30) NOT NULL
);
CREATE TABLE dbo.RM_User_Role
(
i_user_id int NOT NULL,
i_role_id int NOT NULL
);
CREATE TABLE dbo.RM_Validation_Definition
(
i_validation_id int NOT NULL,
c_abbrev nvarchar(255) NOT NULL,
c_label nvarchar(255) NOT NULL,
c_descr nvarchar(2000) NULL,
b_cascade bit NOT NULL,
e_validation_level nvarchar(30) NOT NULL,
e_validation_type__default nvarchar(30) NOT NULL,
c_class nvarchar(20) NOT NULL,
i_column_width int NOT NULL,
i_order int NULL,
e_validation_type__allowed nvarchar(30) NOT NULL
);
CREATE TABLE dbo.RM_Validation_Definition_Templ
(
i_valid_def_templ_id int NOT NULL,
c_label nvarchar(16) NOT NULL,
c_descr nvarchar(2000) NULL,
b_cascade bit NOT NULL,
e_validation_level nvarchar(30) NOT NULL,
e_validation_type__default nvarchar(30) NOT NULL,
c_class nvarchar(20) NOT NULL,
i_column_width int NOT NULL,
i_order int NULL,
e_validation_type__allowed nvarchar(30) NOT NULL
);
CREATE TABLE dbo.RM_Validation_Param
(
i_validation_id int NOT NULL,
i_parameter_id int NOT NULL,
e_data_type nvarchar(30) NOT NULL,
c_label nvarchar(16) NOT NULL,
c_descr nvarchar(255) NULL,
x_value ntext NULL
);
CREATE TABLE dbo.RM_Validation_Param_Templ
(
i_valid_def_templ_id int NOT NULL,
i_parameter_id int NOT NULL,
e_data_type nvarchar(30) NOT NULL,
c_label nvarchar(16) NOT NULL,
c_descr nvarchar(255) NULL,
c_value nvarchar(255) NULL
);
CREATE TABLE dbo.RM_Validation_Prop_Hierarchy
(
i_version_id int NOT NULL,
i_hierarchy_id int NOT NULL,
i_validation_id int NOT NULL,
x_value ntext NULL
);
CREATE TABLE dbo.RM_Validation_Prop_Node
(
i_version_id int NOT NULL,
i_hierarchy_id int NOT NULL,
i_node_id int NOT NULL,
i_validation_id int NOT NULL,
x_value ntext NULL,
b_locked bit NOT NULL
);
CREATE TABLE dbo.RM_Validation_Prop_Version
(
i_version_id int NOT NULL,
i_validation_id int NOT NULL,
x_value ntext NULL
);
CREATE TABLE dbo.RM_Version
(
i_version_id int NOT NULL,
c_abbrev nvarchar(300) NOT NULL,
c_descr nvarchar(300) NULL,
e_version_status nvarchar(20) NOT NULL,
e_version_type nvarchar(30) NOT NULL,
i_baseline_reference_id int NULL,
i_legacy_id int NULL,
b_exact_copy bit NOT NULL,
d_legacy_copy_timestamp datetime NULL,
b_dirty_transactions bit NOT NULL,
i_user_id int NULL,
b_partially_saved bit NULL,
i_access_group_id int NULL,
c_legacy_abbrev nvarchar(300) NULL,
i_lineage_id int NULL,
i_node_count int NOT NULL,
i_limb_count int NOT NULL,
i_leaf_count int NOT NULL,
i_primary_count int NOT NULL,
i_shared_count int NOT NULL,
i_orphan_count int NOT NULL,
b_full_count_flag bit NOT NULL,
d_count_update_timestamp datetime NULL
);
CREATE TABLE dbo.RM_Version_Prop
(
i_version_id int NOT NULL,
i_property_id int NOT NULL,
x_value ntext NULL
);
CREATE TABLE dbo.RM_WF_Model
(
i_model_id int NOT NULL,
c_abbrev nvarchar(255) NOT NULL,
c_label nvarchar(255) NOT NULL,
c_description nvarchar(2000) NULL,
i_request_duration int NULL,
i_claim_duration int NULL,
c_version_variable nvarchar(255) NULL,
c_hierarchy_group_prop nvarchar(255) NULL,
c_hierarchy_group nvarchar(255) NULL,
b_hidden bit NULL
);
CREATE TABLE dbo.RM_WF_Model_Filter_NodeType
(
i_model_id int NOT NULL,
i_filter_nodetype_id int NOT NULL,
c_node_type nvarchar(255) NOT NULL
);
CREATE TABLE dbo.RM_WF_Model_Stage
(
i_model_id int NOT NULL,
e_workflow_stage_type nvarchar(30) NOT NULL,
i_stage_id int NOT NULL,
c_label nvarchar(255) NOT NULL,
e_approval_method nvarchar(30) NOT NULL,
e_approval_sequence nvarchar(30) NOT NULL,
e_reapproval_method nvarchar(30) NOT NULL,
e_notification_group nvarchar(30) NOT NULL,
e_inclusion_method nvarchar(30) NOT NULL,
e_condition_action nvarchar(30) NOT NULL,
i_inclusion_query_id int NULL,
b_separation_of_duties bit NULL,
b_recalculate bit NULL
);
CREATE TABLE dbo.RM_WF_Model_Stage_Assg_Group
(
i_model_id int NOT NULL,
i_stage_id int NOT NULL,
i_group_id int NOT NULL,
c_assigned_group nvarchar(255) NOT NULL
);
CREATE TABLE dbo.RM_WF_Model_Stage_Task
(
i_model_id int NOT NULL,
i_stage_id int NOT NULL,
i_task_id int NOT NULL,
i_primary_task_id int NULL,
b_hidden bit NULL,
i_sort_order int NULL
);
CREATE TABLE dbo.RM_WF_Model_Stage_Validation
(
i_model_id int NOT NULL,
i_stage_id int NOT NULL,
i_validation_id int NOT NULL
);
CREATE TABLE dbo.RM_WF_Request
(
i_workflow_request_id int NOT NULL,
i_model_id int NOT NULL,
c_title nvarchar(255) NOT NULL,
i_version_id int NOT NULL,
c_created_by nvarchar(255) NOT NULL,
d_created_on datetime NOT NULL,
d_submitted_on datetime NULL,
b_overdue bit NULL,
b_escalated bit NULL,
e_workflow_status__current nvarchar(30) NOT NULL,
e_workflow_status__requested nvarchar(30) NOT NULL,
c_current_claimed_by nvarchar(255) NULL,
d_current_claimed_on datetime NULL,
i_current_stage_id int NULL,
d_expedited datetime NULL,
c_status_requested_by nvarchar(255) NULL,
c_status_requested_param nvarchar(255) NULL,
e_validation_run_status nvarchar(30) NOT NULL
);
CREATE TABLE dbo.RM_WF_Request_Activity
(
i_activity_id int NOT NULL,
i_workflow_request_id int NOT NULL,
d_timestamp datetime NOT NULL,
c_user_name nvarchar(255) NULL,
e_workflow_activity nvarchar(30) NOT NULL,
c_stage_name nvarchar(255) NULL,
e_workflow_status__from nvarchar(30) NOT NULL,
e_workflow_status__to nvarchar(30) NOT NULL,
x_from_assigned_to ntext NULL,
x_to_assigned_to ntext NULL,
x_details ntext NOT NULL,
b_system_activity bit NOT NULL,
i_message_number int NULL,
x_message_params ntext NULL
);
CREATE TABLE dbo.RM_WF_Request_Assigned_To
(
i_workflow_request_id int NOT NULL,
e_security_principal_type nvarchar(30) NOT NULL,
c_name nvarchar(255) NOT NULL,
i_id int NULL,
d_assigned datetime NOT NULL
);
CREATE TABLE dbo.RM_WF_Request_Attachment
(
i_workflow_request_id int NOT NULL,
i_attachment_id int NOT NULL,
c_filename nvarchar(255) NULL,
c_content_type nvarchar(255) NULL,
i_content_length int NULL,
c_description nvarchar(255) NULL,
c_created_by nvarchar(255) NOT NULL,
d_created_on datetime NOT NULL,
m_file_contents image NULL
);
CREATE TABLE dbo.RM_WF_Request_Item
(
i_workflow_request_id int NOT NULL,
i_workflow_request_item_id int NOT NULL,
e_workflow_action__originating nvarchar(30) NOT NULL,
i_stage_id int NOT NULL,
i_task_id int NOT NULL,
c_node_name nvarchar(255) NULL,
c_node_descr nvarchar(255) NULL,
c_parent_node_name nvarchar(255) NULL,
c_hierarchy_name nvarchar(255) NULL,
b_has_any_validation_failure bit NULL,
b_has_prop_validation_failure bit NULL,
b_has_node_validation_failure bit NULL,
c_validation_failure_reason nvarchar(255) NULL,
c_last_modified_by nvarchar(255) NULL,
d_last_modified_on datetime NULL,
b_initial_approval bit NULL,
b_enriched_item bit NULL,
i_dependent_group_id int NULL,
b_is_primary bit NULL,
i_calc_group_id int NULL
);
CREATE TABLE dbo.RM_WF_Request_Item_Fail
(
i_workflow_request_id int NOT NULL,
i_workflow_request_item_id int NOT NULL,
i_workflow_req_item_fail_id int NOT NULL,
e_failure_type nvarchar(30) NOT NULL,
c_property_name nvarchar(255) NULL,
x_validation_failure_reason ntext NULL,
i_message_number int NULL,
x_message_params ntext NULL
);
CREATE TABLE dbo.RM_WF_Request_Item_PropVal
(
i_workflow_request_id int NOT NULL,
i_workflow_request_item_id int NOT NULL,
i_workflow_req_item_prop_id int NOT NULL,
c_prop_name nvarchar(255) NOT NULL,
x_new_value ntext NULL,
b_has_new_value bit NULL,
b_has_calc_value bit NULL,
b_cannot_calculate bit NULL,
x_calculated_value ntext NULL,
c_last_modified_by nvarchar(255) NULL,
d_last_modified_on datetime NULL,
b_has_validation_failure bit NULL,
i_last_updated_stage_id int NULL,
i_last_updated_task_id int NULL,
b_value_generated bit NULL
);
CREATE TABLE dbo.RM_WF_Request_Stage
(
i_workflow_request_id int NOT NULL,
i_stage_id int NOT NULL,
i_model_stage_id int NOT NULL,
c_model_stage_class nvarchar(255) NOT NULL,
b_has_full_approval bit NULL,
d_started_on datetime NULL,
i_total_approvals_needed int NULL,
e_stage_processing nvarchar(30) NOT NULL
);
CREATE TABLE dbo.RM_WF_Request_Stage_Appr_Group
(
i_workflow_request_id int NOT NULL,
i_stage_id int NOT NULL,
i_stage_approval_id int NOT NULL,
i_stage_approval_group_id int NOT NULL,
c_approval_group nvarchar(255) NULL
);
CREATE TABLE dbo.RM_WF_Request_Stage_Approval
(
i_workflow_request_id int NOT NULL,
i_stage_id int NOT NULL,
i_stage_approval_id int NOT NULL,
c_approved_by nvarchar(255) NOT NULL,
d_approved_on datetime NOT NULL
);
CREATE TABLE dbo.RM_WF_Request_Stage_Enriched
(
i_workflow_request_id int NOT NULL,
i_stage_id int NOT NULL,
i_stage_enrich_item_id int NOT NULL,
i_item_id int NOT NULL
);
CREATE TABLE dbo.RM_WF_Request_Tag
(
i_workflow_request_id int NOT NULL,
c_name nvarchar(255) NOT NULL,
c_value nvarchar(255) NULL
);
CREATE TABLE dbo.RM_WF_Task
(
i_task_id int NOT NULL,
c_abbrev nvarchar(255) NOT NULL,
c_label nvarchar(255) NOT NULL,
c_instructions nvarchar(2000) NULL,
e_workflow_action nvarchar(30) NOT NULL,
c_hierarchy_group_filter nvarchar(255) NULL,
c_domain_abbrev nvarchar(255) NULL
);
CREATE TABLE dbo.RM_WF_Task_Commit_Op_Param
(
i_task_id int NOT NULL,
i_commit_operation_id int NOT NULL,
c_parameter_name nvarchar(128) NOT NULL,
e_parameter_source nvarchar(30) NOT NULL,
x_parameter_value ntext NULL
);
CREATE TABLE dbo.RM_WF_Task_Commit_Operation
(
i_task_id int NOT NULL,
i_commit_operation_id int NOT NULL,
i_connection_id int NOT NULL,
i_operation_id int NOT NULL,
i_status_property_id int NULL
);
CREATE TABLE dbo.RM_WF_Task_Property
(
i_task_id int NOT NULL,
i_task_property_id int NOT NULL,
c_prop_name nvarchar(255) NOT NULL,
b_editable bit NOT NULL,
b_required bit NOT NULL,
c_instructions nvarchar(2000) NULL,
c_label nvarchar(2000) NULL,
b_calculated bit NULL,
b_hidden bit NULL,
x_script ntext NULL,
i_script_timeout int NULL
);
CREATE TABLE dbo.RM_WF_Task_Validation
(
i_task_id int NOT NULL,
i_task_validation_id int NOT NULL,
i_validation_id int NOT NULL
);
CREATE TABLE dbo.RM_WF_Task_Validation_Property
(
i_task_id int NOT NULL,
i_task_validation_id int NOT NULL,
i_task_validation_prop_id int NOT NULL,
c_property_name nvarchar(255) NOT NULL
);
/* Indexes for RM_Access_Group_Ctrl_Hier */
CREATE INDEX IxRmAccessGroupCtrlHier1 ON dbo.RM_Access_Group_Ctrl_Hier
(
i_security_id ASC
);
CREATE INDEX IxRmAccessGroupCtrlHier2 ON dbo.RM_Access_Group_Ctrl_Hier
(
i_version_id ASC
);
CREATE INDEX IxRmAccessGroupCtrlHier3 ON dbo.RM_Access_Group_Ctrl_Hier
(
i_version_id ASC,
i_hierarchy_id ASC
);
/* Indexes for RM_Access_Group_Definition */
CREATE UNIQUE INDEX IxRmAccessGroupDefinition1 ON dbo.RM_Access_Group_Definition
(
c_abbrev ASC
);
/* Indexes for RM_Access_Group_Prop_Global */
CREATE INDEX IxRmAccessGroupPropGlobal1 ON dbo.RM_Access_Group_Prop_Global
(
i_security_id ASC
);
CREATE INDEX IxRmAccessGroupPropGlobal2 ON dbo.RM_Access_Group_Prop_Global
(
i_version_id ASC,
i_node_id ASC
);
/* Indexes for RM_Access_Group_Prop_Local */
CREATE INDEX IxRmAccessGroupPropLocal1 ON dbo.RM_Access_Group_Prop_Local
(
i_version_id ASC,
i_node_id ASC
);
CREATE INDEX IxRmAccessGroupPropLocal2 ON dbo.RM_Access_Group_Prop_Local
(
i_security_id ASC
);
/* Indexes for RM_Access_Group_User */
CREATE INDEX IxRmAccessGroupUser1 ON dbo.RM_Access_Group_User
(
i_security_id ASC
);
CREATE INDEX IxRmAccessGroupUser2 ON dbo.RM_Access_Group_User
(
i_user_id ASC
);
/* Indexes for RM_Blender */
CREATE UNIQUE INDEX IxRmBlender1 ON dbo.RM_Blender
(
i_access_group_id ASC,
c_abbrev ASC
);
CREATE INDEX IxRmBlender2 ON dbo.RM_Blender
(
i_access_group_id ASC
);
/* Indexes for RM_Blender_Default_Param */
CREATE INDEX IxRmBlenderDefaultParam1 ON dbo.RM_Blender_Default_Param
(
i_blender_id ASC
);
/* Indexes for RM_Blender_Hierarchy_Set */
CREATE INDEX IxRmBlenderHierarchySet1 ON dbo.RM_Blender_Hierarchy_Set
(
i_blender_id ASC,
i_blender_property_list_id ASC
);
CREATE INDEX IxRmBlenderHierarchySet2 ON dbo.RM_Blender_Hierarchy_Set
(
i_blender_id ASC
);
/* Indexes for RM_Blender_Property_List */
CREATE INDEX IxRmBlenderPropertyList1 ON dbo.RM_Blender_Property_List
(
i_blender_id ASC
);
/* Indexes for RM_Blender_Property_List_Item */
CREATE INDEX IxRmBlenderPropertyListItem1 ON dbo.RM_Blender_Property_List_Item
(
i_blender_id ASC,
i_blender_property_list_id ASC
);
/* Indexes for RM_Book */
CREATE UNIQUE INDEX IxRmBook1 ON dbo.RM_Book
(
i_access_group_id ASC,
c_book_name ASC
);
CREATE INDEX IxRmBook2 ON dbo.RM_Book
(
i_access_group_id ASC
);
/* Indexes for RM_Book_Default_Param */
CREATE INDEX IxRmBookDefaultParam1 ON dbo.RM_Book_Default_Param
(
i_book_id ASC
);
/* Indexes for RM_Book_Item */
CREATE INDEX IxRmBookItem1 ON dbo.RM_Book_Item
(
i_book_id ASC
);
CREATE INDEX IxRmBookItem2 ON dbo.RM_Book_Item
(
i_export_id ASC
);
/* Indexes for RM_Category */
CREATE UNIQUE INDEX IxRmCategory1 ON dbo.RM_Category
(
c_category_code ASC
);
/* Indexes for RM_Category_User */
CREATE INDEX IxRmCategoryUser1 ON dbo.RM_Category_User
(
i_user_id ASC
);
CREATE INDEX IxRmCategoryUser2 ON dbo.RM_Category_User
(
i_category_id ASC
);
/* Indexes for RM_Compare */
CREATE INDEX IxRmCompare1 ON dbo.RM_Compare
(
i_query_id ASC
);
CREATE INDEX IxRmCompare2 ON dbo.RM_Compare
(
e_comparison_type ASC
);
CREATE UNIQUE INDEX IxRmCompare3 ON dbo.RM_Compare
(
i_access_group_id ASC,
c_compare_abbrev ASC
);
/* Indexes for RM_Compare_Default_Param */
CREATE INDEX IxRmCompareDefaultParam1 ON dbo.RM_Compare_Default_Param
(
i_compare_id ASC
);
/* Indexes for RM_Compare_Item */
CREATE INDEX IxRmCompareItem1 ON dbo.RM_Compare_Item
(
i_compare_id ASC
);
/* Indexes for RM_Connection */
CREATE UNIQUE INDEX IxRmConnection1 ON dbo.RM_Connection
(
c_name ASC
);
CREATE UNIQUE INDEX IxRmConnection2 ON dbo.RM_Connection
(
i_access_group_id ASC,
c_name ASC
);
/* Indexes for RM_Connection_Operation */
CREATE UNIQUE INDEX IxRmConnectionOperation1 ON dbo.RM_Connection_Operation
(
i_connection_id ASC,
i_operation_id ASC
);
/* Indexes for RM_Derived_Property */
CREATE INDEX IxRmDerivedProperty1 ON dbo.RM_Derived_Property
(
e_data_type ASC
);
/* Indexes for RM_Derived_Property_Param */
CREATE INDEX IxRmDerivedPropertyParam1 ON dbo.RM_Derived_Property_Param
(
c_deriver_class ASC
);
CREATE INDEX IxRmDerivedPropertyParam2 ON dbo.RM_Derived_Property_Param
(
e_data_type ASC
);
/* Indexes for RM_Domain */
CREATE UNIQUE INDEX IxRmDomain1 ON dbo.RM_Domain
(
c_abbrev ASC
);
/* Indexes for RM_Domain_Node */
CREATE UNIQUE INDEX IxRmDomainNode1 ON dbo.RM_Domain_Node
(
i_domain_id ASC,
c_domain_node_abbrev ASC
);
CREATE INDEX IxRmDomainNode2 ON dbo.RM_Domain_Node
(
i_update_id ASC
);
/* Indexes for RM_Export */
CREATE INDEX IxRmExport1 ON dbo.RM_Export
(
i_validation_id ASC
);
CREATE UNIQUE INDEX IxRmExport2 ON dbo.RM_Export
(
i_access_group_id ASC,
c_export_abbrev ASC
);
CREATE INDEX IxRmExport3 ON dbo.RM_Export
(
i_export_type_id ASC
);
CREATE INDEX IxRmExport4 ON dbo.RM_Export
(
e_export_output_mode ASC
);
CREATE INDEX IxRmExport5 ON dbo.RM_Export
(
i_query_id ASC
);
CREATE INDEX IxRmExport6 ON dbo.RM_Export
(
i_access_group_id ASC
);
/* Indexes for RM_Export_Column */
CREATE INDEX IxRmExportColumn1 ON dbo.RM_Export_Column
(
i_export_id ASC
);
CREATE INDEX IxRmExportColumn2 ON dbo.RM_Export_Column
(
c_column_class ASC
);
/* Indexes for RM_Export_Default_Param */
CREATE INDEX IxRmExportDefaultParam1 ON dbo.RM_Export_Default_Param
(
i_export_id ASC
);
/* Indexes for RM_Export_Node */
CREATE INDEX IxRmExportNode1 ON dbo.RM_Export_Node
(
i_export_id ASC
);
/* Indexes for RM_Export_Node_Prop */
CREATE INDEX IxRmExportNodeProp1 ON dbo.RM_Export_Node_Prop
(
i_export_id ASC,
i_export_node_id ASC
);
/* Indexes for RM_Export_Param */
CREATE INDEX IxRmExportParam1 ON dbo.RM_Export_Param
(
i_export_id ASC
);
/* Indexes for RM_Export_Type */
CREATE UNIQUE INDEX IxRmExportType1 ON dbo.RM_Export_Type
(
c_export_class ASC
);
/* Indexes for RM_Glyph */
CREATE UNIQUE INDEX IxRmGlyph1 ON dbo.RM_Glyph
(
c_abbrev ASC
);
/* Indexes for RM_Hierarchy */
CREATE UNIQUE INDEX IxRmHierarchy1 ON dbo.RM_Hierarchy
(
i_version_id ASC,
c_abbrev ASC
);
CREATE INDEX IxRmHierarchy2 ON dbo.RM_Hierarchy
(
i_hierarchy_group_id ASC
);
CREATE INDEX IxRmHierarchy3 ON dbo.RM_Hierarchy
(
i_version_id ASC
);
/* Indexes for RM_Hierarchy_Group */
CREATE UNIQUE INDEX IxRmHierarchyGroup1 ON dbo.RM_Hierarchy_Group
(
c_name ASC
);
/* Indexes for RM_Hierarchy_Prop */
CREATE INDEX IxRmHierarchyProp1 ON dbo.RM_Hierarchy_Prop
(
i_version_id ASC,
i_hierarchy_id ASC
);
CREATE INDEX IxRmHierarchyProp2 ON dbo.RM_Hierarchy_Prop
(
i_property_id ASC
);
/* Indexes for RM_Import */
CREATE INDEX IxRmImport1 ON dbo.RM_Import
(
i_import_type_id ASC
);
CREATE UNIQUE INDEX IxRmImport2 ON dbo.RM_Import
(
i_access_group_id ASC,
c_import_abbrev ASC
);
CREATE INDEX IxRmImport3 ON dbo.RM_Import
(
i_access_group_id ASC
);
/* Indexes for RM_Import_Default_Param */
CREATE INDEX IxRmImportDefaultParam1 ON dbo.RM_Import_Default_Param
(
i_import_id ASC
);
/* Indexes for RM_Import_Param */
CREATE INDEX IxRmImportParam1 ON dbo.RM_Import_Param
(
i_import_id ASC
);
/* Indexes for RM_Import_Section */
CREATE INDEX IxRmImportSection1 ON dbo.RM_Import_Section
(
i_import_id ASC
);
/* Indexes for RM_Import_Section_Column */
CREATE INDEX IxRmImportSectionColumn1 ON dbo.RM_Import_Section_Column
(
i_import_id ASC,
i_import_section_id ASC
);
/* Indexes for RM_Import_Section_Column_Hier */
CREATE INDEX IxRmImportSectionColumnHier1 ON dbo.RM_Import_Section_Column_Hier
(
i_import_id ASC,
i_import_section_id ASC,
i_import_section_column_id ASC
);
/* Indexes for RM_Import_Section_Column_Param */
CREATE INDEX IxRmImportSectionColumnParam1 ON dbo.RM_Import_Section_Column_Param
(
i_import_id ASC,
i_import_section_id ASC,
i_import_section_column_id ASC
);
/* Indexes for RM_Import_Section_Param */
CREATE INDEX IxRmImportSectionParam1 ON dbo.RM_Import_Section_Param
(
i_import_id ASC,
i_import_section_id ASC
);
/* Indexes for RM_Node */
CREATE UNIQUE INDEX IxRmNode1 ON dbo.RM_Node
(
i_version_id ASC,
c_abbrev ASC
);
CREATE INDEX IxRmNode2 ON dbo.RM_Node
(
i_version_id ASC
);
/* Indexes for RM_Node_Prop_Global */
CREATE INDEX IxRmNodePropGlobal1 ON dbo.RM_Node_Prop_Global
(
i_property_id ASC
);
/* Indexes for RM_Node_Prop_Local */
CREATE INDEX IxRmNodePropLocal1 ON dbo.RM_Node_Prop_Local
(
i_property_id ASC
);
CREATE INDEX IxRmNodePropLocal2 ON dbo.RM_Node_Prop_Local
(
i_version_id ASC,
i_node_id ASC
);
/* Indexes for RM_Node_Type */
CREATE INDEX IxRmNodeType1 ON dbo.RM_Node_Type
(
i_glyph_id ASC
);
CREATE UNIQUE INDEX IxRmNodeType2 ON dbo.RM_Node_Type
(
c_abbrev ASC
);
/* Indexes for RM_Node_Type_Property */
CREATE INDEX IxRmNodeTypeProperty1 ON dbo.RM_Node_Type_Property
(
i_node_type_id ASC
);
CREATE INDEX IxRmNodeTypeProperty2 ON dbo.RM_Node_Type_Property
(
i_property_id ASC
);
/* Indexes for RM_Node_Type_Validation */
CREATE INDEX IxRmNodeTypeValidation1 ON dbo.RM_Node_Type_Validation
(
i_node_type_id ASC
);
CREATE INDEX IxRmNodeTypeValidation2 ON dbo.RM_Node_Type_Validation
(
i_validation_id ASC
);
/* Indexes for RM_Notification */
CREATE INDEX IxRmNotification1 ON dbo.RM_Notification
(
i_user_id ASC
);
/* Indexes for RM_Object_Access_Group */
CREATE UNIQUE INDEX IxRmObjectAccessGroup1 ON dbo.RM_Object_Access_Group
(
c_abbrev ASC
);
/* Indexes for RM_Property_Category */
CREATE INDEX IxRmPropertyCategory1 ON dbo.RM_Property_Category
(
i_property_id ASC
);
CREATE INDEX IxRmPropertyCategory2 ON dbo.RM_Property_Category
(
i_category_id ASC
);
/* Indexes for RM_Property_Constraint */
CREATE INDEX IxRmPropertyConstraint1 ON dbo.RM_Property_Constraint
(
i_property_id ASC
);
/* Indexes for RM_Property_Ctrl_Hier */
CREATE INDEX IxRmPropertyCtrlHier1 ON dbo.RM_Property_Ctrl_Hier
(
i_property_id ASC
);
CREATE INDEX IxRmPropertyCtrlHier2 ON dbo.RM_Property_Ctrl_Hier
(
i_version_id ASC
);
CREATE INDEX IxRmPropertyCtrlHier3 ON dbo.RM_Property_Ctrl_Hier
(
i_version_id ASC,
i_hierarchy_id ASC
);
/* Indexes for RM_Property_Definition */
CREATE UNIQUE INDEX IxRmPropertyDefinition1 ON dbo.RM_Property_Definition
(
c_abbrev ASC
);
CREATE INDEX IxRmPropertyDefinition2 ON dbo.RM_Property_Definition
(
e_data_type ASC
);
CREATE INDEX IxRmPropertyDefinition3 ON dbo.RM_Property_Definition
(
e_prop_type ASC
);
/* Indexes for RM_Property_List */
CREATE INDEX IxRmPropertyList1 ON dbo.RM_Property_List
(
i_property_id ASC
);
/* Indexes for RM_Property_Lookup */
CREATE INDEX IxRmPropertyLookup1 ON dbo.RM_Property_Lookup
(
i_property_id ASC
);
/* Indexes for RM_Property_Param */
CREATE UNIQUE INDEX IxRmPropertyParam1 ON dbo.RM_Property_Param
(
i_property_id ASC,
c_label ASC
);
CREATE INDEX IxRmPropertyParam2 ON dbo.RM_Property_Param
(
i_property_id ASC
);
/* Indexes for RM_Property_Query */
CREATE UNIQUE INDEX IxRmPropertyQuery1 ON dbo.RM_Property_Query
(
i_access_group_id ASC,
c_query_abbrev ASC
);
CREATE INDEX IxRmPropertyQuery2 ON dbo.RM_Property_Query
(
i_access_group_id ASC
);
/* Indexes for RM_Query_Default_Param */
CREATE INDEX IxRmQueryDefaultParam1 ON dbo.RM_Query_Default_Param
(
i_query_id ASC
);
/* Indexes for RM_Relationship */
CREATE INDEX IxRmRelationship1 ON dbo.RM_Relationship
(
i_version_id ASC,
i_child_id ASC
);
/* Indexes for RM_Role */
CREATE UNIQUE INDEX IxRmRole1 ON dbo.RM_Role
(
c_role_name ASC
);
/* Indexes for RM_Scheduled_Tasks */
CREATE UNIQUE INDEX IxRmScheduledTasks1 ON dbo.RM_Scheduled_Tasks
(
c_task_name ASC
);
/* Indexes for RM_System_Preference */
CREATE INDEX IxRmSystemPreference1 ON dbo.RM_System_Preference
(
e_data_type ASC
);
/* Indexes for RM_Transaction_History */
CREATE INDEX IxRmTransactionHistory1 ON dbo.RM_Transaction_History
(
i_session_id ASC
);
CREATE INDEX IxRmTransactionHistory2 ON dbo.RM_Transaction_History
(
c_version_abbrev ASC
);
CREATE INDEX IxRmTransactionHistory3 ON dbo.RM_Transaction_History
(
i_version_id ASC
);
CREATE INDEX IxRmTransactionHistory4 ON dbo.RM_Transaction_History
(
i_version_id ASC,
i_hierarchy_id ASC,
i_node_id ASC
);
CREATE INDEX IxRmTransactionHistory5 ON dbo.RM_Transaction_History
(
i_node_id ASC
);
CREATE INDEX IxRmTransactionHistory6 ON dbo.RM_Transaction_History
(
c_node_abbrev ASC
);
CREATE INDEX IxRmTransactionHistory7 ON dbo.RM_Transaction_History
(
i_version_id ASC,
d_timestamp ASC,
c_action_level ASC
);
CREATE INDEX IxRmTransactionHistory8 ON dbo.RM_Transaction_History
(
c_property_abbrev ASC
);
/* Indexes for RM_User */
CREATE UNIQUE INDEX IxRmUser1 ON dbo.RM_User
(
c_user_name ASC
);
/* Indexes for RM_User_Prop_Hierarchy */
CREATE INDEX IxRmUserPropHierarchy1 ON dbo.RM_User_Prop_Hierarchy
(
i_version_id ASC,
i_hierarchy_id ASC
);
CREATE INDEX IxRmUserPropHierarchy2 ON dbo.RM_User_Prop_Hierarchy
(
i_user_id ASC
);
CREATE INDEX IxRmUserPropHierarchy3 ON dbo.RM_User_Prop_Hierarchy
(
i_property_id ASC
);
/* Indexes for RM_User_Prop_Version */
CREATE INDEX IxRmUserPropVersion1 ON dbo.RM_User_Prop_Version
(
i_version_id ASC
);
CREATE INDEX IxRmUserPropVersion2 ON dbo.RM_User_Prop_Version
(
i_user_id ASC
);
CREATE INDEX IxRmUserPropVersion3 ON dbo.RM_User_Prop_Version
(
i_property_id ASC
);
/* Indexes for RM_User_Property_Definition */
CREATE UNIQUE INDEX IxRmUserPropertyDefinition1 ON dbo.RM_User_Property_Definition
(
c_abbrev ASC
);
CREATE INDEX IxRmUserPropertyDefinition2 ON dbo.RM_User_Property_Definition
(
e_data_type ASC
);
/* Indexes for RM_Validation_Definition */
CREATE UNIQUE INDEX IxRmValidationDefinition1 ON dbo.RM_Validation_Definition
(
c_abbrev ASC
);
/* Indexes for RM_Validation_Definition_Templ */
CREATE UNIQUE INDEX IxRmValidationDefinitionTempl1 ON dbo.RM_Validation_Definition_Templ
(
c_label ASC
);
/* Indexes for RM_Validation_Param */
CREATE INDEX IxRmValidationParam1 ON dbo.RM_Validation_Param
(
i_validation_id ASC
);
CREATE INDEX IxRmValidationParam2 ON dbo.RM_Validation_Param
(
e_data_type ASC
);
/* Indexes for RM_Validation_Param_Templ */
CREATE INDEX IxRmValidationParamTempl1 ON dbo.RM_Validation_Param_Templ
(
e_data_type ASC
);
CREATE INDEX IxRmValidationParamTempl2 ON dbo.RM_Validation_Param_Templ
(
i_valid_def_templ_id ASC
);
/* Indexes for RM_Validation_Prop_Hierarchy */
CREATE INDEX IxRmValidationPropHierarchy1 ON dbo.RM_Validation_Prop_Hierarchy
(
i_version_id ASC,
i_hierarchy_id ASC
);
CREATE INDEX IxRmValidationPropHierarchy2 ON dbo.RM_Validation_Prop_Hierarchy
(
i_validation_id ASC
);
/* Indexes for RM_Validation_Prop_Node */
CREATE INDEX IxRmValidationPropNode1 ON dbo.RM_Validation_Prop_Node
(
i_version_id ASC,
i_hierarchy_id ASC
);
CREATE INDEX IxRmValidationPropNode2 ON dbo.RM_Validation_Prop_Node
(
i_version_id ASC,
i_node_id ASC
);
CREATE INDEX IxRmValidationPropNode3 ON dbo.RM_Validation_Prop_Node
(
i_validation_id ASC
);
/* Indexes for RM_Validation_Prop_Version */
CREATE INDEX IxRmValidationPropVersion1 ON dbo.RM_Validation_Prop_Version
(
i_version_id ASC
);
CREATE INDEX IxRmValidationPropVersion2 ON dbo.RM_Validation_Prop_Version
(
i_validation_id ASC
);
/* Indexes for RM_Version */
CREATE UNIQUE INDEX IxRmVersion1 ON dbo.RM_Version
(
c_abbrev ASC
);
CREATE INDEX IxRmVersion2 ON dbo.RM_Version
(
e_version_type ASC
);
/* Indexes for RM_Version_Prop */
CREATE INDEX IxRmVersionProp1 ON dbo.RM_Version_Prop
(
i_version_id ASC
);
CREATE INDEX IxRmVersionProp2 ON dbo.RM_Version_Prop
(
i_property_id ASC
);
/* Indexes for RM_WF_Model */
CREATE UNIQUE INDEX IxRmWfModel1 ON dbo.RM_WF_Model
(
c_abbrev ASC
);
/* Indexes for RM_WF_Model_Stage */
CREATE UNIQUE INDEX IxRmWfModelStage1 ON dbo.RM_WF_Model_Stage
(
i_model_id ASC,
c_label ASC
);
/* Indexes for RM_WF_Request */
CREATE INDEX IxRmWfRequest1 ON dbo.RM_WF_Request
(
d_created_on ASC
);
CREATE INDEX IxRmWfRequest2 ON dbo.RM_WF_Request
(
c_created_by ASC,
d_created_on ASC
);
CREATE INDEX IxRmWfRequest3 ON dbo.RM_WF_Request
(
d_submitted_on ASC
);
CREATE INDEX IxRmWfRequest4 ON dbo.RM_WF_Request
(
d_current_claimed_on ASC
);
CREATE INDEX IxRmWfRequest5 ON dbo.RM_WF_Request
(
d_expedited ASC
);
CREATE INDEX IxRmWfRequest6 ON dbo.RM_WF_Request
(
e_workflow_status__current ASC
);
/* Indexes for RM_WF_Request_Activity */
CREATE INDEX IxRmWfRequestActivity1 ON dbo.RM_WF_Request_Activity
(
i_workflow_request_id ASC
);
CREATE INDEX IxRmWfRequestActivity2 ON dbo.RM_WF_Request_Activity
(
c_user_name ASC
);
CREATE INDEX IxRmWfRequestActivity3 ON dbo.RM_WF_Request_Activity
(
d_timestamp DESC
);
/* Indexes for RM_WF_Request_Assigned_To */
CREATE INDEX IxRmWfRequestAssignedTo1 ON dbo.RM_WF_Request_Assigned_To
(
e_security_principal_type ASC,
c_name ASC,
d_assigned ASC
);
CREATE INDEX IxRmWfRequestAssignedTo2 ON dbo.RM_WF_Request_Assigned_To
(
d_assigned ASC
);
/* Indexes for RM_WF_Task */
CREATE UNIQUE INDEX IxRmWfTask1 ON dbo.RM_WF_Task
(
c_abbrev ASC
);
ALTER TABLE dbo.DAL_Sequence
ADD CONSTRAINT PkDalSequence
PRIMARY KEY (c_key);
ALTER TABLE dbo.DAL_Updates
ADD CONSTRAINT PkDalUpdates
PRIMARY KEY (c_version);
ALTER TABLE dbo.RM_Access_Group_Ctrl_Hier
ADD CONSTRAINT PkRmAccessGroupCtrlHier
PRIMARY KEY (i_security_id, i_version_id);
ALTER TABLE dbo.RM_Access_Group_Definition
ADD CONSTRAINT PkRmAccessGroupDefinition
PRIMARY KEY (i_security_id);
ALTER TABLE dbo.RM_Access_Group_Prop_Global
ADD CONSTRAINT PkRmAccessGroupPropGlobal
PRIMARY KEY (i_version_id, i_node_id, i_security_id, b_leaf);
ALTER TABLE dbo.RM_Access_Group_Prop_Local
ADD CONSTRAINT PkRmAccessGroupPropLocal
PRIMARY KEY (i_version_id, i_hierarchy_id, i_node_id, i_security_id, b_leaf);
ALTER TABLE dbo.RM_Access_Group_User
ADD CONSTRAINT PkRmAccessGroupUser
PRIMARY KEY (i_security_id, i_user_id);
ALTER TABLE dbo.RM_Blender
ADD CONSTRAINT PkRmBlender
PRIMARY KEY (i_blender_id);
ALTER TABLE dbo.RM_Blender_Default_Param
ADD CONSTRAINT PkRmBlenderDefaultParam
PRIMARY KEY (i_blender_id, c_parameter);
ALTER TABLE dbo.RM_Blender_Hierarchy_Set
ADD CONSTRAINT PkRmBlenderHierarchySet
PRIMARY KEY (i_blender_id, i_hierarchy_set_id);
ALTER TABLE dbo.RM_Blender_Property_List
ADD CONSTRAINT PkRmBlenderPropertyList
PRIMARY KEY (i_blender_id, i_blender_property_list_id);
ALTER TABLE dbo.RM_Blender_Property_List_Item
ADD CONSTRAINT PkRmBlenderPropertyListItem
PRIMARY KEY (i_blender_id, i_blender_property_list_id, i_blender_property_item_id);
ALTER TABLE dbo.RM_Book
ADD CONSTRAINT PkRmBook
PRIMARY KEY (i_book_id);
ALTER TABLE dbo.RM_Book_Default_Param
ADD CONSTRAINT PkRmBookDefaultParam
PRIMARY KEY (i_book_id, c_parameter);
ALTER TABLE dbo.RM_Book_Item
ADD CONSTRAINT PkRmBookItem
PRIMARY KEY (i_book_id, i_book_item_id);
ALTER TABLE dbo.RM_Category
ADD CONSTRAINT PkRmCategory
PRIMARY KEY (i_category_id);
ALTER TABLE dbo.RM_Category_User
ADD CONSTRAINT PkRmCategoryUser
PRIMARY KEY (i_user_id, i_category_id);
ALTER TABLE dbo.RM_Compare
ADD CONSTRAINT PkRmCompare
PRIMARY KEY (i_compare_id);
ALTER TABLE dbo.RM_Compare_Default_Param
ADD CONSTRAINT PkRmCompareDefaultParam
PRIMARY KEY (i_compare_id, c_parameter);
ALTER TABLE dbo.RM_Compare_Item
ADD CONSTRAINT PkRmCompareItem
PRIMARY KEY (i_compare_id, i_item_id);
ALTER TABLE dbo.RM_Config_Info
ADD CONSTRAINT PkRmConfigInfo
PRIMARY KEY (c_key);
ALTER TABLE dbo.RM_Connection
ADD CONSTRAINT PkRmConnection
PRIMARY KEY (i_connection_id);
ALTER TABLE dbo.RM_Connection_Allowed_Table
ADD CONSTRAINT PkRmConnectionAllowedTable
PRIMARY KEY (i_connection_id, c_table_name, c_owner);
ALTER TABLE dbo.RM_Connection_Operation
ADD CONSTRAINT PkRmConnectionOperation
PRIMARY KEY (i_connection_id, c_name);
ALTER TABLE dbo.RM_Connection_Operation_Column
ADD CONSTRAINT PkRmConnectionOperationColumn
PRIMARY KEY (i_connection_id, i_operation_id, c_column_name);
ALTER TABLE dbo.RM_Connection_Operation_Param
ADD CONSTRAINT PkRmConnectionOperationParam
PRIMARY KEY (i_connection_id, i_operation_id, c_param_name);
ALTER TABLE dbo.RM_Derived_Property
ADD CONSTRAINT PkRmDerivedProperty
PRIMARY KEY (c_deriver_class);
ALTER TABLE dbo.RM_Derived_Property_Param
ADD CONSTRAINT PkRmDerivedPropertyParam
PRIMARY KEY (c_deriver_class, i_template_id);
ALTER TABLE dbo.RM_Domain
ADD CONSTRAINT PkRmDomain
PRIMARY KEY (i_domain_id);
ALTER TABLE dbo.RM_Domain_Node
ADD CONSTRAINT PkRmDomainNode
PRIMARY KEY (i_domain_id, i_domain_node_id);
ALTER TABLE dbo.RM_Domain_Validations
ADD CONSTRAINT PkRmDomainValidations
PRIMARY KEY (i_domain_id, i_validation_id);
ALTER TABLE dbo.RM_Domain_Version
ADD CONSTRAINT PkRmDomainVersion
PRIMARY KEY (i_domain_id, i_version_id);
ALTER TABLE dbo.RM_Engine_Info
ADD CONSTRAINT PkRmEngineInfo
PRIMARY KEY (i_id);
ALTER TABLE dbo.RM_Export
ADD CONSTRAINT PkRmExport
PRIMARY KEY (i_export_id);
ALTER TABLE dbo.RM_Export_Column
ADD CONSTRAINT PkRmExportColumn
PRIMARY KEY (i_export_id, i_column_id);
ALTER TABLE dbo.RM_Export_Default_Param
ADD CONSTRAINT PkRmExportDefaultParam
PRIMARY KEY (i_export_id, c_parameter);
ALTER TABLE dbo.RM_Export_Node
ADD CONSTRAINT PkRmExportNode
PRIMARY KEY (i_export_id, i_export_node_id);
ALTER TABLE dbo.RM_Export_Node_Prop
ADD CONSTRAINT PkRmExportNodeProp
PRIMARY KEY (i_export_id, i_export_node_id, c_property_abbrev);
ALTER TABLE dbo.RM_Export_Param
ADD CONSTRAINT PkRmExportParam
PRIMARY KEY (i_export_id, i_export_param_id);
ALTER TABLE dbo.RM_Export_Type
ADD CONSTRAINT PkRmExportType
PRIMARY KEY (i_export_type_id);
ALTER TABLE dbo.RM_Glyph
ADD CONSTRAINT PkRmGlyph
PRIMARY KEY (i_glyph_id);
ALTER TABLE dbo.RM_Hierarchy
ADD CONSTRAINT PkRmHierarchy
PRIMARY KEY (i_version_id, i_hierarchy_id);
ALTER TABLE dbo.RM_Hierarchy_Group
ADD CONSTRAINT PkRmHierarchyGroup
PRIMARY KEY (i_hierarchy_group_id);
ALTER TABLE dbo.RM_Hierarchy_Prop
ADD CONSTRAINT PkRmHierarchyProp
PRIMARY KEY (i_version_id, i_hierarchy_id, i_property_id);
ALTER TABLE dbo.RM_Import
ADD CONSTRAINT PkRmImport
PRIMARY KEY (i_import_id);
ALTER TABLE dbo.RM_Import_Class
ADD CONSTRAINT PkRmImportClass
PRIMARY KEY (c_import_class);
ALTER TABLE dbo.RM_Import_Default_Param
ADD CONSTRAINT PkRmImportDefaultParam
PRIMARY KEY (i_import_id, c_parameter);
ALTER TABLE dbo.RM_Import_Param
ADD CONSTRAINT PkRmImportParam
PRIMARY KEY (i_import_id, i_import_param_id);
ALTER TABLE dbo.RM_Import_Section
ADD CONSTRAINT PkRmImportSection
PRIMARY KEY (i_import_id, i_import_section_id);
ALTER TABLE dbo.RM_Import_Section_Column
ADD CONSTRAINT PkRmImportSectionColumn
PRIMARY KEY (i_import_id, i_import_section_id, i_import_section_column_id);
ALTER TABLE dbo.RM_Import_Section_Column_Hier
ADD CONSTRAINT PkRmImportSectionColumnHier
PRIMARY KEY (i_import_id, i_import_section_id, i_import_section_column_id, i_import_section_column_hierid);
ALTER TABLE dbo.RM_Import_Section_Column_Param
ADD CONSTRAINT PkRmImportSectionColumnParam
PRIMARY KEY (i_import_id, i_import_section_id, i_import_section_column_id, i_import_param_id);
ALTER TABLE dbo.RM_Import_Section_Param
ADD CONSTRAINT PkRmImportSectionParam
PRIMARY KEY (i_import_id, i_import_section_id, i_import_param_id);
ALTER TABLE dbo.RM_Import_Type
ADD CONSTRAINT PkRmImportType
PRIMARY KEY (i_import_type_id);
ALTER TABLE dbo.RM_Job_History
ADD CONSTRAINT PkRmJobHistory
PRIMARY KEY (i_job_id);
ALTER TABLE dbo.RM_Job_History_Result
ADD CONSTRAINT PkRmJobHistoryResult
PRIMARY KEY (i_job_id, i_detail_id);
ALTER TABLE dbo.RM_Merge_Log
ADD CONSTRAINT PkRmMergeLog
PRIMARY KEY (i_merge_log_id, i_version_id, i_node_id);
ALTER TABLE dbo.RM_Node
ADD CONSTRAINT PkRmNode
PRIMARY KEY (i_version_id, i_node_id);
ALTER TABLE dbo.RM_Node_Merge
ADD CONSTRAINT PkRmNodeMerge
PRIMARY KEY (i_version_id, i_node_id);
ALTER TABLE dbo.RM_Node_Prop_Global
ADD CONSTRAINT PkRmNodePropGlobal
PRIMARY KEY (i_version_id, i_node_id, i_property_id);
ALTER TABLE dbo.RM_Node_Prop_Local
ADD CONSTRAINT PkRmNodePropLocal
PRIMARY KEY (i_version_id, i_hierarchy_id, i_node_id, i_property_id);
ALTER TABLE dbo.RM_Node_Type
ADD CONSTRAINT PkRmNodeType
PRIMARY KEY (i_node_type_id);
ALTER TABLE dbo.RM_Node_Type_Property
ADD CONSTRAINT PkRmNodeTypeProperty
PRIMARY KEY (i_node_type_id, i_property_id);
ALTER TABLE dbo.RM_Node_Type_Validation
ADD CONSTRAINT PkRmNodeTypeValidation
PRIMARY KEY (i_node_type_id, i_validation_id);
ALTER TABLE dbo.RM_Notification
ADD CONSTRAINT PkRmNotification
PRIMARY KEY (i_notification_id);
ALTER TABLE dbo.RM_Notification_Detail
ADD CONSTRAINT PkRmNotificationDetail
PRIMARY KEY (i_notification_id);
ALTER TABLE dbo.RM_Object_Access_Group
ADD CONSTRAINT PkRmObjectAccessGroup
PRIMARY KEY (i_access_group_id);
ALTER TABLE dbo.RM_Object_Access_Group_Nag
ADD CONSTRAINT PkRmObjectAccessGroupNag
PRIMARY KEY (i_access_group_id, i_security_id);
ALTER TABLE dbo.RM_Object_Access_Group_User
ADD CONSTRAINT PkRmObjectAccessGroupUser
PRIMARY KEY (i_access_group_id, i_user_id);
ALTER TABLE dbo.RM_Property_Category
ADD CONSTRAINT PkRmPropertyCategory
PRIMARY KEY (i_property_id, i_category_id);
ALTER TABLE dbo.RM_Property_Constraint
ADD CONSTRAINT PkRmPropertyConstraint
PRIMARY KEY (i_property_id, c_constraint_name, c_key);
ALTER TABLE dbo.RM_Property_Ctrl_Hier
ADD CONSTRAINT PkRmPropertyCtrlHier
PRIMARY KEY (i_property_id, i_version_id);
ALTER TABLE dbo.RM_Property_Definition
ADD CONSTRAINT PkRmPropertyDefinition
PRIMARY KEY (i_property_id);
ALTER TABLE dbo.RM_Property_External_Col_Map
ADD CONSTRAINT PkRmPropertyExternalColMap
PRIMARY KEY (i_property_id, i_target_property_id);
ALTER TABLE dbo.RM_Property_External_Param_Map
ADD CONSTRAINT PkRmPropertyExternalParamMap
PRIMARY KEY (i_property_id, c_parameter_name);
ALTER TABLE dbo.RM_Property_List
ADD CONSTRAINT PkRmPropertyList
PRIMARY KEY (i_property_id, i_order);
ALTER TABLE dbo.RM_Property_Lookup
ADD CONSTRAINT PkRmPropertyLookup
PRIMARY KEY (i_property_id, c_lookup_value);
ALTER TABLE dbo.RM_Property_Param
ADD CONSTRAINT PkRmPropertyParam
PRIMARY KEY (i_property_id, i_param_id);
ALTER TABLE dbo.RM_Property_Query
ADD CONSTRAINT PkRmPropertyQuery
PRIMARY KEY (i_query_id);
ALTER TABLE dbo.RM_Query_Criteria
ADD CONSTRAINT PkRmQueryCriteria
PRIMARY KEY (i_query_id, i_criteria_id);
ALTER TABLE dbo.RM_Query_Default_Param
ADD CONSTRAINT PkRmQueryDefaultParam
PRIMARY KEY (i_query_id, c_parameter);
ALTER TABLE dbo.RM_Relationship
ADD CONSTRAINT PkRmRelationship
PRIMARY KEY (i_version_id, i_parent_id, i_child_id);
ALTER TABLE dbo.RM_Request
ADD CONSTRAINT PkRmRequest
PRIMARY KEY (i_request_id);
ALTER TABLE dbo.RM_Request_Item
ADD CONSTRAINT PkRmRequestItem
PRIMARY KEY (i_request_id, i_request_item_id);
ALTER TABLE dbo.RM_Request_Verification
ADD CONSTRAINT PkRmRequestVerification
PRIMARY KEY (i_request_id, i_sequence);
ALTER TABLE dbo.RM_Role
ADD CONSTRAINT PkRmRole
PRIMARY KEY (i_role_id);
ALTER TABLE dbo.RM_Role_Permission
ADD CONSTRAINT PkRmRolePermission
PRIMARY KEY (i_role_id, e_permission);
ALTER TABLE dbo.RM_Scheduled_Tasks
ADD CONSTRAINT PkRmScheduledTasks
PRIMARY KEY (i_task_id);
ALTER TABLE dbo.RM_Session_Info
ADD CONSTRAINT PkRmSessionInfo
PRIMARY KEY (i_session_id);
ALTER TABLE dbo.RM_System_Preference
ADD CONSTRAINT PkRmSystemPreference
PRIMARY KEY (c_keyword);
ALTER TABLE dbo.RM_Transaction_History
ADD CONSTRAINT PkRmTransactionHistory
PRIMARY KEY (i_transaction_id, i_detail_id);
ALTER TABLE dbo.RM_User
ADD CONSTRAINT PkRmUser
PRIMARY KEY (i_user_id);
ALTER TABLE dbo.RM_User_Prop_Hierarchy
ADD CONSTRAINT PkRmUserPropHierarchy
PRIMARY KEY (i_version_id, i_hierarchy_id, i_user_id, i_property_id);
ALTER TABLE dbo.RM_User_Prop_Version
ADD CONSTRAINT PkRmUserPropVersion
PRIMARY KEY (i_version_id, i_user_id, i_property_id);
ALTER TABLE dbo.RM_User_Property_Definition
ADD CONSTRAINT PkRmUserPropertyDefinition
PRIMARY KEY (i_user_property_id);
ALTER TABLE dbo.RM_User_Role
ADD CONSTRAINT PkRmUserRole
PRIMARY KEY (i_user_id, i_role_id);
ALTER TABLE dbo.RM_Validation_Definition
ADD CONSTRAINT PkRmValidationDefinition
PRIMARY KEY (i_validation_id);
ALTER TABLE dbo.RM_Validation_Definition_Templ
ADD CONSTRAINT PkRmValidationDefinitionTempl
PRIMARY KEY (i_valid_def_templ_id);
ALTER TABLE dbo.RM_Validation_Param
ADD CONSTRAINT PkRmValidationParam
PRIMARY KEY (i_validation_id, i_parameter_id);
ALTER TABLE dbo.RM_Validation_Param_Templ
ADD CONSTRAINT PkRmValidationParamTempl
PRIMARY KEY (i_valid_def_templ_id, i_parameter_id);
ALTER TABLE dbo.RM_Validation_Prop_Hierarchy
ADD CONSTRAINT PkRmValidationPropHierarchy
PRIMARY KEY (i_version_id, i_hierarchy_id, i_validation_id);
ALTER TABLE dbo.RM_Validation_Prop_Node
ADD CONSTRAINT PkRmValidationPropNode
PRIMARY KEY (i_version_id, i_hierarchy_id, i_node_id, i_validation_id);
ALTER TABLE dbo.RM_Validation_Prop_Version
ADD CONSTRAINT PkRmValidationPropVersion
PRIMARY KEY (i_version_id, i_validation_id);
ALTER TABLE dbo.RM_Version
ADD CONSTRAINT PkRmVersion
PRIMARY KEY (i_version_id);
ALTER TABLE dbo.RM_Version_Prop
ADD CONSTRAINT PkRmVersionProp
PRIMARY KEY (i_version_id, i_property_id);
ALTER TABLE dbo.RM_WF_Model
ADD CONSTRAINT PkRmWfModel
PRIMARY KEY (i_model_id);
ALTER TABLE dbo.RM_WF_Model_Filter_NodeType
ADD CONSTRAINT PkRmWfModelFilterNodetype
PRIMARY KEY (i_model_id, i_filter_nodetype_id);
ALTER TABLE dbo.RM_WF_Model_Stage
ADD CONSTRAINT PkRmWfModelStage
PRIMARY KEY (i_model_id, i_stage_id);
ALTER TABLE dbo.RM_WF_Model_Stage_Assg_Group
ADD CONSTRAINT PkRmWfModelStageAssgGroup
PRIMARY KEY (i_model_id, i_stage_id, i_group_id);
ALTER TABLE dbo.RM_WF_Model_Stage_Task
ADD CONSTRAINT PkRmWfModelStageTask
PRIMARY KEY (i_model_id, i_stage_id, i_task_id);
ALTER TABLE dbo.RM_WF_Model_Stage_Validation
ADD CONSTRAINT PkRmWfModelStageValidation
PRIMARY KEY (i_model_id, i_stage_id, i_validation_id);
ALTER TABLE dbo.RM_WF_Request
ADD CONSTRAINT PkRmWfRequest
PRIMARY KEY (i_workflow_request_id);
ALTER TABLE dbo.RM_WF_Request_Activity
ADD CONSTRAINT PkRmWfRequestActivity
PRIMARY KEY (i_activity_id);
ALTER TABLE dbo.RM_WF_Request_Assigned_To
ADD CONSTRAINT PkRmWfRequestAssignedTo
PRIMARY KEY (i_workflow_request_id, e_security_principal_type, c_name);
ALTER TABLE dbo.RM_WF_Request_Attachment
ADD CONSTRAINT PkRmWfRequestAttachment
PRIMARY KEY (i_workflow_request_id, i_attachment_id);
ALTER TABLE dbo.RM_WF_Request_Item
ADD CONSTRAINT PkRmWfRequestItem
PRIMARY KEY (i_workflow_request_id, i_workflow_request_item_id);
ALTER TABLE dbo.RM_WF_Request_Item_Fail
ADD CONSTRAINT PkRmWfRequestItemFail
PRIMARY KEY (i_workflow_request_id, i_workflow_request_item_id, i_workflow_req_item_fail_id);
ALTER TABLE dbo.RM_WF_Request_Item_PropVal
ADD CONSTRAINT PkRmWfRequestItemPropval
PRIMARY KEY (i_workflow_request_id, i_workflow_request_item_id, i_workflow_req_item_prop_id);
ALTER TABLE dbo.RM_WF_Request_Stage
ADD CONSTRAINT PkRmWfRequestStage
PRIMARY KEY (i_workflow_request_id, i_stage_id);
ALTER TABLE dbo.RM_WF_Request_Stage_Appr_Group
ADD CONSTRAINT PkRmWfRequestStageApprGroup
PRIMARY KEY (i_workflow_request_id, i_stage_id, i_stage_approval_id, i_stage_approval_group_id);
ALTER TABLE dbo.RM_WF_Request_Stage_Approval
ADD CONSTRAINT PkRmWfRequestStageApproval
PRIMARY KEY (i_workflow_request_id, i_stage_id, i_stage_approval_id);
ALTER TABLE dbo.RM_WF_Request_Stage_Enriched
ADD CONSTRAINT PkRmWfRequestStageEnriched
PRIMARY KEY (i_workflow_request_id, i_stage_id, i_stage_enrich_item_id);
ALTER TABLE dbo.RM_WF_Request_Tag
ADD CONSTRAINT PkRmWfRequestTag
PRIMARY KEY (i_workflow_request_id, c_name);
ALTER TABLE dbo.RM_WF_Task
ADD CONSTRAINT PkRmWfTask
PRIMARY KEY (i_task_id);
ALTER TABLE dbo.RM_WF_Task_Commit_Op_Param
ADD CONSTRAINT PkRmWfTaskCommitOpParam
PRIMARY KEY (i_task_id, i_commit_operation_id, c_parameter_name);
ALTER TABLE dbo.RM_WF_Task_Commit_Operation
ADD CONSTRAINT PkRmWfTaskCommitOperation
PRIMARY KEY (i_task_id, i_commit_operation_id);
ALTER TABLE dbo.RM_WF_Task_Property
ADD CONSTRAINT PkRmWfTaskProperty
PRIMARY KEY (i_task_id, i_task_property_id);
ALTER TABLE dbo.RM_WF_Task_Validation
ADD CONSTRAINT PkRmWfTaskValidation
PRIMARY KEY (i_task_id, i_task_validation_id);
ALTER TABLE dbo.RM_WF_Task_Validation_Property
ADD CONSTRAINT PkRmWfTaskValidationProperty
PRIMARY KEY (i_task_id, i_task_validation_id, i_task_validation_prop_id);
/* Foreign Key Constraints for RM_Access_Group_Ctrl_Hier */
ALTER TABLE dbo.RM_Access_Group_Ctrl_Hier
ADD CONSTRAINT FkRmAccessGroupCtrlHier1
FOREIGN KEY (i_security_id)
REFERENCES RM_Access_Group_Definition (i_security_id);
ALTER TABLE dbo.RM_Access_Group_Ctrl_Hier
ADD CONSTRAINT FkRmAccessGroupCtrlHier2
FOREIGN KEY (i_version_id, i_hierarchy_id)
REFERENCES RM_Hierarchy (i_version_id, i_hierarchy_id);
ALTER TABLE dbo.RM_Access_Group_Ctrl_Hier
ADD CONSTRAINT FkRmAccessGroupCtrlHier3
FOREIGN KEY (i_version_id)
REFERENCES RM_Version (i_version_id);
/* Foreign Key Constraints for RM_Access_Group_Prop_Global */
ALTER TABLE dbo.RM_Access_Group_Prop_Global
ADD CONSTRAINT FkRmAccessGroupPropGlobal1
FOREIGN KEY (i_security_id)
REFERENCES RM_Access_Group_Definition (i_security_id);
ALTER TABLE dbo.RM_Access_Group_Prop_Global
ADD CONSTRAINT FkRmAccessGroupPropGlobal2
FOREIGN KEY (i_version_id, i_node_id)
REFERENCES RM_Node (i_version_id, i_node_id);
/* Foreign Key Constraints for RM_Access_Group_Prop_Local */
ALTER TABLE dbo.RM_Access_Group_Prop_Local
ADD CONSTRAINT FkRmAccessGroupPropLocal1
FOREIGN KEY (i_security_id)
REFERENCES RM_Access_Group_Definition (i_security_id);
ALTER TABLE dbo.RM_Access_Group_Prop_Local
ADD CONSTRAINT FkRmAccessGroupPropLocal2
FOREIGN KEY (i_version_id, i_hierarchy_id)
REFERENCES RM_Hierarchy (i_version_id, i_hierarchy_id);
ALTER TABLE dbo.RM_Access_Group_Prop_Local
ADD CONSTRAINT FkRmAccessGroupPropLocal3
FOREIGN KEY (i_version_id, i_node_id)
REFERENCES RM_Node (i_version_id, i_node_id);
/* Foreign Key Constraints for RM_Access_Group_User */
ALTER TABLE dbo.RM_Access_Group_User
ADD CONSTRAINT FkRmAccessGroupUser1
FOREIGN KEY (i_security_id)
REFERENCES RM_Access_Group_Definition (i_security_id);
ALTER TABLE dbo.RM_Access_Group_User
ADD CONSTRAINT FkRmAccessGroupUser2
FOREIGN KEY (i_user_id)
REFERENCES RM_User (i_user_id);
/* Foreign Key Constraints for RM_Blender */
ALTER TABLE dbo.RM_Blender
ADD CONSTRAINT FkRmBlender1
FOREIGN KEY (i_user_id)
REFERENCES RM_User (i_user_id);
ALTER TABLE dbo.RM_Blender
ADD CONSTRAINT FkRmBlender2
FOREIGN KEY (i_access_group_id)
REFERENCES RM_Object_Access_Group (i_access_group_id);
/* Foreign Key Constraints for RM_Blender_Default_Param */
ALTER TABLE dbo.RM_Blender_Default_Param
ADD CONSTRAINT FkRmBlenderDefaultParam1
FOREIGN KEY (i_blender_id)
REFERENCES RM_Blender (i_blender_id);
/* Foreign Key Constraints for RM_Blender_Hierarchy_Set */
ALTER TABLE dbo.RM_Blender_Hierarchy_Set
ADD CONSTRAINT FkRmBlenderHierarchySet1
FOREIGN KEY (i_blender_id)
REFERENCES RM_Blender (i_blender_id);
ALTER TABLE dbo.RM_Blender_Hierarchy_Set
ADD CONSTRAINT FkRmBlenderHierarchySet2
FOREIGN KEY (i_blender_id, i_blender_property_list_id)
REFERENCES RM_Blender_Property_List (i_blender_id, i_blender_property_list_id);
/* Foreign Key Constraints for RM_Blender_Property_List */
ALTER TABLE dbo.RM_Blender_Property_List
ADD CONSTRAINT FkRmBlenderPropertyList1
FOREIGN KEY (i_blender_id)
REFERENCES RM_Blender (i_blender_id);
/* Foreign Key Constraints for RM_Blender_Property_List_Item */
ALTER TABLE dbo.RM_Blender_Property_List_Item
ADD CONSTRAINT FkRmBlenderPropertyListItem1
FOREIGN KEY (i_blender_id, i_blender_property_list_id)
REFERENCES RM_Blender_Property_List (i_blender_id, i_blender_property_list_id);
/* Foreign Key Constraints for RM_Book */
ALTER TABLE dbo.RM_Book
ADD CONSTRAINT FkRmBook1
FOREIGN KEY (c_pre_file_connection)
REFERENCES RM_Connection (c_name);
ALTER TABLE dbo.RM_Book
ADD CONSTRAINT FkRmBook2
FOREIGN KEY (c_post_file_connection)
REFERENCES RM_Connection (c_name);
ALTER TABLE dbo.RM_Book
ADD CONSTRAINT FkRmBook3
FOREIGN KEY (c_combined_file_connection)
REFERENCES RM_Connection (c_name);
ALTER TABLE dbo.RM_Book
ADD CONSTRAINT FkRmBook4
FOREIGN KEY (i_user_id)
REFERENCES RM_User (i_user_id);
ALTER TABLE dbo.RM_Book
ADD CONSTRAINT FkRmBook5
FOREIGN KEY (i_access_group_id)
REFERENCES RM_Object_Access_Group (i_access_group_id);
/* Foreign Key Constraints for RM_Book_Default_Param */
ALTER TABLE dbo.RM_Book_Default_Param
ADD CONSTRAINT FkRmBookDefaultParam1
FOREIGN KEY (i_book_id)
REFERENCES RM_Book (i_book_id);
/* Foreign Key Constraints for RM_Book_Item */
ALTER TABLE dbo.RM_Book_Item
ADD CONSTRAINT FkRmBookItem1
FOREIGN KEY (i_book_id)
REFERENCES RM_Book (i_book_id);
ALTER TABLE dbo.RM_Book_Item
ADD CONSTRAINT FkRmBookItem2
FOREIGN KEY (i_export_id)
REFERENCES RM_Export (i_export_id);
/* Foreign Key Constraints for RM_Category_User */
ALTER TABLE dbo.RM_Category_User
ADD CONSTRAINT FkRmCategoryUser1
FOREIGN KEY (i_category_id)
REFERENCES RM_Category (i_category_id);
ALTER TABLE dbo.RM_Category_User
ADD CONSTRAINT FkRmCategoryUser2
FOREIGN KEY (i_user_id)
REFERENCES RM_User (i_user_id);
/* Foreign Key Constraints for RM_Compare */
ALTER TABLE dbo.RM_Compare
ADD CONSTRAINT FkRmCompare1
FOREIGN KEY (i_query_id)
REFERENCES RM_Property_Query (i_query_id);
ALTER TABLE dbo.RM_Compare
ADD CONSTRAINT FkRmCompare2
FOREIGN KEY (i_user_id)
REFERENCES RM_User (i_user_id);
ALTER TABLE dbo.RM_Compare
ADD CONSTRAINT FkRmCompare3
FOREIGN KEY (i_access_group_id)
REFERENCES RM_Object_Access_Group (i_access_group_id);
/* Foreign Key Constraints for RM_Compare_Default_Param */
ALTER TABLE dbo.RM_Compare_Default_Param
ADD CONSTRAINT FkRmCompareDefaultParam1
FOREIGN KEY (i_compare_id)
REFERENCES RM_Compare (i_compare_id);
/* Foreign Key Constraints for RM_Compare_Item */
ALTER TABLE dbo.RM_Compare_Item
ADD CONSTRAINT FkRmCompareItem1
FOREIGN KEY (i_compare_id)
REFERENCES RM_Compare (i_compare_id);
/* Foreign Key Constraints for RM_Connection */
ALTER TABLE dbo.RM_Connection
ADD CONSTRAINT FkRmConnection1
FOREIGN KEY (i_user_id)
REFERENCES RM_User (i_user_id);
ALTER TABLE dbo.RM_Connection
ADD CONSTRAINT FkRmConnection2
FOREIGN KEY (i_access_group_id)
REFERENCES RM_Object_Access_Group (i_access_group_id);
/* Foreign Key Constraints for RM_Connection_Allowed_Table */
ALTER TABLE dbo.RM_Connection_Allowed_Table
ADD CONSTRAINT FkRmConnectionAllowedTable1
FOREIGN KEY (i_connection_id)
REFERENCES RM_Connection (i_connection_id);
/* Foreign Key Constraints for RM_Connection_Operation */
ALTER TABLE dbo.RM_Connection_Operation
ADD CONSTRAINT FkRmConnectionOperation1
FOREIGN KEY (i_connection_id)
REFERENCES RM_Connection (i_connection_id);
/* Foreign Key Constraints for RM_Connection_Operation_Column */
ALTER TABLE dbo.RM_Connection_Operation_Column
ADD CONSTRAINT FkRmConnectionOperationColumn1
FOREIGN KEY (i_connection_id, i_operation_id)
REFERENCES RM_Connection_Operation (i_connection_id, i_operation_id);
/* Foreign Key Constraints for RM_Connection_Operation_Param */
ALTER TABLE dbo.RM_Connection_Operation_Param
ADD CONSTRAINT FkRmConnectionOperationParam1
FOREIGN KEY (i_connection_id, i_operation_id)
REFERENCES RM_Connection_Operation (i_connection_id, i_operation_id);
/* Foreign Key Constraints for RM_Derived_Property_Param */
ALTER TABLE dbo.RM_Derived_Property_Param
ADD CONSTRAINT FkRmDerivedPropertyParam1
FOREIGN KEY (c_deriver_class)
REFERENCES RM_Derived_Property (c_deriver_class);
/* Foreign Key Constraints for RM_Domain_Node */
ALTER TABLE dbo.RM_Domain_Node
ADD CONSTRAINT FkRmDomainNode1
FOREIGN KEY (i_domain_id)
REFERENCES RM_Domain (i_domain_id);
/* Foreign Key Constraints for RM_Domain_Validations */
ALTER TABLE dbo.RM_Domain_Validations
ADD CONSTRAINT FkRmDomainValidations1
FOREIGN KEY (i_domain_id)
REFERENCES RM_Domain (i_domain_id);
ALTER TABLE dbo.RM_Domain_Validations
ADD CONSTRAINT FkRmDomainValidations2
FOREIGN KEY (i_validation_id)
REFERENCES RM_Validation_Definition (i_validation_id);
/* Foreign Key Constraints for RM_Domain_Version */
ALTER TABLE dbo.RM_Domain_Version
ADD CONSTRAINT FkRmDomainVersion1
FOREIGN KEY (i_domain_id)
REFERENCES RM_Domain (i_domain_id);
ALTER TABLE dbo.RM_Domain_Version
ADD CONSTRAINT FkRmDomainVersion2
FOREIGN KEY (i_version_id)
REFERENCES RM_Version (i_version_id);
/* Foreign Key Constraints for RM_Export */
ALTER TABLE dbo.RM_Export
ADD CONSTRAINT FkRmExport1
FOREIGN KEY (i_export_type_id)
REFERENCES RM_Export_Type (i_export_type_id);
ALTER TABLE dbo.RM_Export
ADD CONSTRAINT FkRmExport2
FOREIGN KEY (i_query_id)
REFERENCES RM_Property_Query (i_query_id);
ALTER TABLE dbo.RM_Export
ADD CONSTRAINT FkRmExport3
FOREIGN KEY (i_user_id)
REFERENCES RM_User (i_user_id);
ALTER TABLE dbo.RM_Export
ADD CONSTRAINT FkRmExport4
FOREIGN KEY (i_validation_id)
REFERENCES RM_Validation_Definition (i_validation_id);
ALTER TABLE dbo.RM_Export
ADD CONSTRAINT FkRmExport5
FOREIGN KEY (i_access_group_id)
REFERENCES RM_Object_Access_Group (i_access_group_id);
/* Foreign Key Constraints for RM_Export_Column */
ALTER TABLE dbo.RM_Export_Column
ADD CONSTRAINT FkRmExportColumn1
FOREIGN KEY (i_export_id)
REFERENCES RM_Export (i_export_id);
/* Foreign Key Constraints for RM_Export_Default_Param */
ALTER TABLE dbo.RM_Export_Default_Param
ADD CONSTRAINT FkRmExportDefaultParam1
FOREIGN KEY (i_export_id)
REFERENCES RM_Export (i_export_id);
/* Foreign Key Constraints for RM_Export_Node */
ALTER TABLE dbo.RM_Export_Node
ADD CONSTRAINT FkRmExportNode1
FOREIGN KEY (i_export_id)
REFERENCES RM_Export (i_export_id);
/* Foreign Key Constraints for RM_Export_Node_Prop */
ALTER TABLE dbo.RM_Export_Node_Prop
ADD CONSTRAINT FkRmExportNodeProp1
FOREIGN KEY (i_export_id, i_export_node_id)
REFERENCES RM_Export_Node (i_export_id, i_export_node_id);
/* Foreign Key Constraints for RM_Export_Param */
ALTER TABLE dbo.RM_Export_Param
ADD CONSTRAINT FkRmExportParam1
FOREIGN KEY (i_export_id)
REFERENCES RM_Export (i_export_id);
/* Foreign Key Constraints for RM_Hierarchy */
ALTER TABLE dbo.RM_Hierarchy
ADD CONSTRAINT FkRmHierarchy1
FOREIGN KEY (i_hierarchy_group_id)
REFERENCES RM_Hierarchy_Group (i_hierarchy_group_id);
ALTER TABLE dbo.RM_Hierarchy
ADD CONSTRAINT FkRmHierarchy2
FOREIGN KEY (i_user_id)
REFERENCES RM_User (i_user_id);
ALTER TABLE dbo.RM_Hierarchy
ADD CONSTRAINT FkRmHierarchy3
FOREIGN KEY (i_version_id)
REFERENCES RM_Version (i_version_id);
/* Foreign Key Constraints for RM_Hierarchy_Prop */
ALTER TABLE dbo.RM_Hierarchy_Prop
ADD CONSTRAINT FkRmHierarchyProp1
FOREIGN KEY (i_version_id, i_hierarchy_id)
REFERENCES RM_Hierarchy (i_version_id, i_hierarchy_id);
ALTER TABLE dbo.RM_Hierarchy_Prop
ADD CONSTRAINT FkRmHierarchyProp2
FOREIGN KEY (i_property_id)
REFERENCES RM_Property_Definition (i_property_id);
/* Foreign Key Constraints for RM_Import */
ALTER TABLE dbo.RM_Import
ADD CONSTRAINT FkRmImport1
FOREIGN KEY (i_import_type_id)
REFERENCES RM_Import_Type (i_import_type_id);
ALTER TABLE dbo.RM_Import
ADD CONSTRAINT FkRmImport2
FOREIGN KEY (i_user_id)
REFERENCES RM_User (i_user_id);
ALTER TABLE dbo.RM_Import
ADD CONSTRAINT FkRmImport3
FOREIGN KEY (i_access_group_id)
REFERENCES RM_Object_Access_Group (i_access_group_id);
/* Foreign Key Constraints for RM_Import_Default_Param */
ALTER TABLE dbo.RM_Import_Default_Param
ADD CONSTRAINT FkRmImportDefaultParam1
FOREIGN KEY (i_import_id)
REFERENCES RM_Import (i_import_id);
/* Foreign Key Constraints for RM_Import_Param */
ALTER TABLE dbo.RM_Import_Param
ADD CONSTRAINT FkRmImportParam1
FOREIGN KEY (i_import_id)
REFERENCES RM_Import (i_import_id);
/* Foreign Key Constraints for RM_Import_Section */
ALTER TABLE dbo.RM_Import_Section
ADD CONSTRAINT FkRmImportSection1
FOREIGN KEY (i_import_id)
REFERENCES RM_Import (i_import_id);
/* Foreign Key Constraints for RM_Import_Section_Column */
ALTER TABLE dbo.RM_Import_Section_Column
ADD CONSTRAINT FkRmImportSectionColumn1
FOREIGN KEY (i_import_id, i_import_section_id)
REFERENCES RM_Import_Section (i_import_id, i_import_section_id);
/* Foreign Key Constraints for RM_Import_Section_Column_Hier */
ALTER TABLE dbo.RM_Import_Section_Column_Hier
ADD CONSTRAINT FkRmImportSectionColumnHier1
FOREIGN KEY (i_import_id, i_import_section_id, i_import_section_column_id)
REFERENCES RM_Import_Section_Column (i_import_id, i_import_section_id, i_import_section_column_id);
/* Foreign Key Constraints for RM_Import_Section_Column_Param */
ALTER TABLE dbo.RM_Import_Section_Column_Param
ADD CONSTRAINT FkRmImportSectionColumnParam1
FOREIGN KEY (i_import_id, i_import_section_id, i_import_section_column_id)
REFERENCES RM_Import_Section_Column (i_import_id, i_import_section_id, i_import_section_column_id);
/* Foreign Key Constraints for RM_Import_Section_Param */
ALTER TABLE dbo.RM_Import_Section_Param
ADD CONSTRAINT FkRmImportSectionParam1
FOREIGN KEY (i_import_id, i_import_section_id)
REFERENCES RM_Import_Section (i_import_id, i_import_section_id);
/* Foreign Key Constraints for RM_Job_History_Result */
ALTER TABLE dbo.RM_Job_History_Result
ADD CONSTRAINT FkRmJobHistoryResult1
FOREIGN KEY (i_job_id)
REFERENCES RM_Job_History (i_job_id);
/* Foreign Key Constraints for RM_Node */
ALTER TABLE dbo.RM_Node
ADD CONSTRAINT FkRmNode1
FOREIGN KEY (i_domain_id)
REFERENCES RM_Domain (i_domain_id);
ALTER TABLE dbo.RM_Node
ADD CONSTRAINT FkRmNode2
FOREIGN KEY (i_version_id)
REFERENCES RM_Version (i_version_id);
/* Foreign Key Constraints for RM_Node_Merge */
ALTER TABLE dbo.RM_Node_Merge
ADD CONSTRAINT FkRmNodeMerge1
FOREIGN KEY (i_version_id, i_node_id)
REFERENCES RM_Node (i_version_id, i_node_id);
/* Foreign Key Constraints for RM_Node_Prop_Global */
ALTER TABLE dbo.RM_Node_Prop_Global
ADD CONSTRAINT FkRmNodePropGlobal1
FOREIGN KEY (i_version_id, i_node_id)
REFERENCES RM_Node (i_version_id, i_node_id);
ALTER TABLE dbo.RM_Node_Prop_Global
ADD CONSTRAINT FkRmNodePropGlobal2
FOREIGN KEY (i_property_id)
REFERENCES RM_Property_Definition (i_property_id);
/* Foreign Key Constraints for RM_Node_Prop_Local */
ALTER TABLE dbo.RM_Node_Prop_Local
ADD CONSTRAINT FkRmNodePropLocal1
FOREIGN KEY (i_version_id, i_hierarchy_id)
REFERENCES RM_Hierarchy (i_version_id, i_hierarchy_id);
ALTER TABLE dbo.RM_Node_Prop_Local
ADD CONSTRAINT FkRmNodePropLocal2
FOREIGN KEY (i_version_id, i_node_id)
REFERENCES RM_Node (i_version_id, i_node_id);
ALTER TABLE dbo.RM_Node_Prop_Local
ADD CONSTRAINT FkRmNodePropLocal3
FOREIGN KEY (i_property_id)
REFERENCES RM_Property_Definition (i_property_id);
/* Foreign Key Constraints for RM_Node_Type */
ALTER TABLE dbo.RM_Node_Type
ADD CONSTRAINT FkRmNodeType1
FOREIGN KEY (i_glyph_id)
REFERENCES RM_Glyph (i_glyph_id);
/* Foreign Key Constraints for RM_Node_Type_Property */
ALTER TABLE dbo.RM_Node_Type_Property
ADD CONSTRAINT FkRmNodeTypeProperty1
FOREIGN KEY (i_node_type_id)
REFERENCES RM_Node_Type (i_node_type_id);
ALTER TABLE dbo.RM_Node_Type_Property
ADD CONSTRAINT FkRmNodeTypeProperty2
FOREIGN KEY (i_property_id)
REFERENCES RM_Property_Definition (i_property_id);
/* Foreign Key Constraints for RM_Node_Type_Validation */
ALTER TABLE dbo.RM_Node_Type_Validation
ADD CONSTRAINT FkRmNodeTypeValidation1
FOREIGN KEY (i_node_type_id)
REFERENCES RM_Node_Type (i_node_type_id);
ALTER TABLE dbo.RM_Node_Type_Validation
ADD CONSTRAINT FkRmNodeTypeValidation2
FOREIGN KEY (i_validation_id)
REFERENCES RM_Validation_Definition (i_validation_id);
/* Foreign Key Constraints for RM_Notification */
ALTER TABLE dbo.RM_Notification
ADD CONSTRAINT FkRmNotification1
FOREIGN KEY (i_user_id)
REFERENCES RM_User (i_user_id);
/* Foreign Key Constraints for RM_Notification_Detail */
ALTER TABLE dbo.RM_Notification_Detail
ADD CONSTRAINT FkRmNotificationDetail1
FOREIGN KEY (i_notification_id)
REFERENCES RM_Notification (i_notification_id);
/* Foreign Key Constraints for RM_Object_Access_Group_Nag */
ALTER TABLE dbo.RM_Object_Access_Group_Nag
ADD CONSTRAINT FkRmObjectAccessGroupNag1
FOREIGN KEY (i_access_group_id)
REFERENCES RM_Object_Access_Group (i_access_group_id);
ALTER TABLE dbo.RM_Object_Access_Group_Nag
ADD CONSTRAINT FkRmObjectAccessGroupNag2
FOREIGN KEY (i_security_id)
REFERENCES RM_Access_Group_Definition (i_security_id);
/* Foreign Key Constraints for RM_Object_Access_Group_User */
ALTER TABLE dbo.RM_Object_Access_Group_User
ADD CONSTRAINT FkRmObjectAccessGroupUser1
FOREIGN KEY (i_access_group_id)
REFERENCES RM_Object_Access_Group (i_access_group_id);
ALTER TABLE dbo.RM_Object_Access_Group_User
ADD CONSTRAINT FkRmObjectAccessGroupUser2
FOREIGN KEY (i_user_id)
REFERENCES RM_User (i_user_id);
/* Foreign Key Constraints for RM_Property_Category */
ALTER TABLE dbo.RM_Property_Category
ADD CONSTRAINT FkRmPropertyCategory1
FOREIGN KEY (i_category_id)
REFERENCES RM_Category (i_category_id);
ALTER TABLE dbo.RM_Property_Category
ADD CONSTRAINT FkRmPropertyCategory2
FOREIGN KEY (i_property_id)
REFERENCES RM_Property_Definition (i_property_id);
/* Foreign Key Constraints for RM_Property_Constraint */
ALTER TABLE dbo.RM_Property_Constraint
ADD CONSTRAINT FkRmPropertyConstraint1
FOREIGN KEY (i_property_id)
REFERENCES RM_Property_Definition (i_property_id);
/* Foreign Key Constraints for RM_Property_Ctrl_Hier */
ALTER TABLE dbo.RM_Property_Ctrl_Hier
ADD CONSTRAINT FkRmPropertyCtrlHier1
FOREIGN KEY (i_version_id, i_hierarchy_id)
REFERENCES RM_Hierarchy (i_version_id, i_hierarchy_id);
ALTER TABLE dbo.RM_Property_Ctrl_Hier
ADD CONSTRAINT FkRmPropertyCtrlHier2
FOREIGN KEY (i_property_id)
REFERENCES RM_Property_Definition (i_property_id);
ALTER TABLE dbo.RM_Property_Ctrl_Hier
ADD CONSTRAINT FkRmPropertyCtrlHier3
FOREIGN KEY (i_version_id)
REFERENCES RM_Version (i_version_id);
/* Foreign Key Constraints for RM_Property_Definition */
ALTER TABLE dbo.RM_Property_Definition
ADD CONSTRAINT FkRmPropertyDefinition1
FOREIGN KEY (i_assigned_domain_id)
REFERENCES RM_Domain (i_domain_id);
ALTER TABLE dbo.RM_Property_Definition
ADD CONSTRAINT FkRmPropertyDefinition2
FOREIGN KEY (i_connection_id)
REFERENCES RM_Connection (i_connection_id);
/* Foreign Key Constraints for RM_Property_External_Col_Map */
ALTER TABLE dbo.RM_Property_External_Col_Map
ADD CONSTRAINT FkRmPropertyExternalColMap1
FOREIGN KEY (i_property_id)
REFERENCES RM_Property_Definition (i_property_id);
/* Foreign Key Constraints for RM_Property_External_Param_Map */
ALTER TABLE dbo.RM_Property_External_Param_Map
ADD CONSTRAINT FkRmPropertyExternalParamMap1
FOREIGN KEY (i_property_id)
REFERENCES RM_Property_Definition (i_property_id);
/* Foreign Key Constraints for RM_Property_List */
ALTER TABLE dbo.RM_Property_List
ADD CONSTRAINT FkRmPropertyList1
FOREIGN KEY (i_property_id)
REFERENCES RM_Property_Definition (i_property_id);
/* Foreign Key Constraints for RM_Property_Lookup */
ALTER TABLE dbo.RM_Property_Lookup
ADD CONSTRAINT FkRmPropertyLookup1
FOREIGN KEY (i_property_id)
REFERENCES RM_Property_Definition (i_property_id);
/* Foreign Key Constraints for RM_Property_Param */
ALTER TABLE dbo.RM_Property_Param
ADD CONSTRAINT FkRmPropertyParam1
FOREIGN KEY (i_property_id)
REFERENCES RM_Property_Definition (i_property_id);
/* Foreign Key Constraints for RM_Property_Query */
ALTER TABLE dbo.RM_Property_Query
ADD CONSTRAINT FkRmPropertyQuery1
FOREIGN KEY (i_user_id)
REFERENCES RM_User (i_user_id);
ALTER TABLE dbo.RM_Property_Query
ADD CONSTRAINT FkRmPropertyQuery2
FOREIGN KEY (i_access_group_id)
REFERENCES RM_Object_Access_Group (i_access_group_id);
/* Foreign Key Constraints for RM_Query_Criteria */
ALTER TABLE dbo.RM_Query_Criteria
ADD CONSTRAINT FkRmQueryCriteria1
FOREIGN KEY (i_query_id)
REFERENCES RM_Property_Query (i_query_id);
/* Foreign Key Constraints for RM_Query_Default_Param */
ALTER TABLE dbo.RM_Query_Default_Param
ADD CONSTRAINT FkRmQueryDefaultParam1
FOREIGN KEY (i_query_id)
REFERENCES RM_Property_Query (i_query_id);
/* Foreign Key Constraints for RM_Relationship */
ALTER TABLE dbo.RM_Relationship
ADD CONSTRAINT FkRmRelationship1
FOREIGN KEY (i_version_id, i_child_id)
REFERENCES RM_Node (i_version_id, i_node_id);
ALTER TABLE dbo.RM_Relationship
ADD CONSTRAINT FkRmRelationship2
FOREIGN KEY (i_version_id, i_parent_id)
REFERENCES RM_Node (i_version_id, i_node_id);
/* Foreign Key Constraints for RM_Request_Item */
ALTER TABLE dbo.RM_Request_Item
ADD CONSTRAINT FkRmRequestItem1
FOREIGN KEY (i_request_id)
REFERENCES RM_Request (i_request_id);
/* Foreign Key Constraints for RM_Request_Verification */
ALTER TABLE dbo.RM_Request_Verification
ADD CONSTRAINT FkRmRequestVerification1
FOREIGN KEY (i_request_id)
REFERENCES RM_Request (i_request_id);
/* Foreign Key Constraints for RM_Role_Permission */
ALTER TABLE dbo.RM_Role_Permission
ADD CONSTRAINT FkRmRolePermission1
FOREIGN KEY (i_role_id)
REFERENCES RM_Role (i_role_id);
/* Foreign Key Constraints for RM_User_Prop_Hierarchy */
ALTER TABLE dbo.RM_User_Prop_Hierarchy
ADD CONSTRAINT FkRmUserPropHierarchy1
FOREIGN KEY (i_version_id, i_hierarchy_id)
REFERENCES RM_Hierarchy (i_version_id, i_hierarchy_id);
ALTER TABLE dbo.RM_User_Prop_Hierarchy
ADD CONSTRAINT FkRmUserPropHierarchy2
FOREIGN KEY (i_user_id)
REFERENCES RM_User (i_user_id);
ALTER TABLE dbo.RM_User_Prop_Hierarchy
ADD CONSTRAINT FkRmUserPropHierarchy3
FOREIGN KEY (i_property_id)
REFERENCES RM_User_Property_Definition (i_user_property_id);
/* Foreign Key Constraints for RM_User_Prop_Version */
ALTER TABLE dbo.RM_User_Prop_Version
ADD CONSTRAINT FkRmUserPropVersion1
FOREIGN KEY (i_user_id)
REFERENCES RM_User (i_user_id);
ALTER TABLE dbo.RM_User_Prop_Version
ADD CONSTRAINT FkRmUserPropVersion2
FOREIGN KEY (i_property_id)
REFERENCES RM_User_Property_Definition (i_user_property_id);
ALTER TABLE dbo.RM_User_Prop_Version
ADD CONSTRAINT FkRmUserPropVersion3
FOREIGN KEY (i_version_id)
REFERENCES RM_Version (i_version_id);
/* Foreign Key Constraints for RM_User_Role */
ALTER TABLE dbo.RM_User_Role
ADD CONSTRAINT FkRmUserRole1
FOREIGN KEY (i_role_id)
REFERENCES RM_Role (i_role_id);
ALTER TABLE dbo.RM_User_Role
ADD CONSTRAINT FkRmUserRole2
FOREIGN KEY (i_user_id)
REFERENCES RM_User (i_user_id);
/* Foreign Key Constraints for RM_Validation_Param */
ALTER TABLE dbo.RM_Validation_Param
ADD CONSTRAINT FkRmValidationParam1
FOREIGN KEY (i_validation_id)
REFERENCES RM_Validation_Definition (i_validation_id);
/* Foreign Key Constraints for RM_Validation_Param_Templ */
ALTER TABLE dbo.RM_Validation_Param_Templ
ADD CONSTRAINT FkRmValidationParamTempl1
FOREIGN KEY (i_valid_def_templ_id)
REFERENCES RM_Validation_Definition_Templ (i_valid_def_templ_id);
/* Foreign Key Constraints for RM_Validation_Prop_Hierarchy */
ALTER TABLE dbo.RM_Validation_Prop_Hierarchy
ADD CONSTRAINT FkRmValidationPropHierarchy1
FOREIGN KEY (i_version_id, i_hierarchy_id)
REFERENCES RM_Hierarchy (i_version_id, i_hierarchy_id);
ALTER TABLE dbo.RM_Validation_Prop_Hierarchy
ADD CONSTRAINT FkRmValidationPropHierarchy2
FOREIGN KEY (i_validation_id)
REFERENCES RM_Validation_Definition (i_validation_id);
/* Foreign Key Constraints for RM_Validation_Prop_Node */
ALTER TABLE dbo.RM_Validation_Prop_Node
ADD CONSTRAINT FkRmValidationPropNode1
FOREIGN KEY (i_version_id, i_hierarchy_id)
REFERENCES RM_Hierarchy (i_version_id, i_hierarchy_id);
ALTER TABLE dbo.RM_Validation_Prop_Node
ADD CONSTRAINT FkRmValidationPropNode2
FOREIGN KEY (i_version_id, i_node_id)
REFERENCES RM_Node (i_version_id, i_node_id);
ALTER TABLE dbo.RM_Validation_Prop_Node
ADD CONSTRAINT FkRmValidationPropNode3
FOREIGN KEY (i_validation_id)
REFERENCES RM_Validation_Definition (i_validation_id);
/* Foreign Key Constraints for RM_Validation_Prop_Version */
ALTER TABLE dbo.RM_Validation_Prop_Version
ADD CONSTRAINT FkRmValidationPropVersion1
FOREIGN KEY (i_validation_id)
REFERENCES RM_Validation_Definition (i_validation_id);
ALTER TABLE dbo.RM_Validation_Prop_Version
ADD CONSTRAINT FkRmValidationPropVersion2
FOREIGN KEY (i_version_id)
REFERENCES RM_Version (i_version_id);
/* Foreign Key Constraints for RM_Version */
ALTER TABLE dbo.RM_Version
ADD CONSTRAINT FkRmVersion1
FOREIGN KEY (i_user_id)
REFERENCES RM_User (i_user_id);
ALTER TABLE dbo.RM_Version
ADD CONSTRAINT FkRmVersion2
FOREIGN KEY (i_lineage_id)
REFERENCES RM_Version (i_version_id);
/* Foreign Key Constraints for RM_Version_Prop */
ALTER TABLE dbo.RM_Version_Prop
ADD CONSTRAINT FkRmVersionProp1
FOREIGN KEY (i_property_id)
REFERENCES RM_Property_Definition (i_property_id);
ALTER TABLE dbo.RM_Version_Prop
ADD CONSTRAINT FkRmVersionProp2
FOREIGN KEY (i_version_id)
REFERENCES RM_Version (i_version_id);
/* Foreign Key Constraints for RM_WF_Model_Filter_NodeType */
ALTER TABLE dbo.RM_WF_Model_Filter_NodeType
ADD CONSTRAINT FkRmWfModelFilterNodetype1
FOREIGN KEY (i_model_id)
REFERENCES RM_WF_Model (i_model_id);
/* Foreign Key Constraints for RM_WF_Model_Stage */
ALTER TABLE dbo.RM_WF_Model_Stage
ADD CONSTRAINT FkRmWfModelStage1
FOREIGN KEY (i_model_id)
REFERENCES RM_WF_Model (i_model_id);
/* Foreign Key Constraints for RM_WF_Model_Stage_Assg_Group */
ALTER TABLE dbo.RM_WF_Model_Stage_Assg_Group
ADD CONSTRAINT FkRmWfModelStageAssgGroup1
FOREIGN KEY (i_model_id, i_stage_id)
REFERENCES RM_WF_Model_Stage (i_model_id, i_stage_id);
/* Foreign Key Constraints for RM_WF_Model_Stage_Task */
ALTER TABLE dbo.RM_WF_Model_Stage_Task
ADD CONSTRAINT FkRmWfModelStageTask1
FOREIGN KEY (i_model_id, i_stage_id)
REFERENCES RM_WF_Model_Stage (i_model_id, i_stage_id);
/* Foreign Key Constraints for RM_WF_Model_Stage_Validation */
ALTER TABLE dbo.RM_WF_Model_Stage_Validation
ADD CONSTRAINT FkRmWfModelStageValidation1
FOREIGN KEY (i_model_id, i_stage_id)
REFERENCES RM_WF_Model_Stage (i_model_id, i_stage_id);
ALTER TABLE dbo.RM_WF_Model_Stage_Validation
ADD CONSTRAINT FkRmWfModelStageValidation2
FOREIGN KEY (i_validation_id)
REFERENCES RM_Validation_Definition (i_validation_id);
/* Foreign Key Constraints for RM_WF_Request */
ALTER TABLE dbo.RM_WF_Request
ADD CONSTRAINT FkRmWfRequest1
FOREIGN KEY (i_version_id)
REFERENCES RM_Version (i_version_id);
/* Foreign Key Constraints for RM_WF_Request_Activity */
ALTER TABLE dbo.RM_WF_Request_Activity
ADD CONSTRAINT FkRmWfRequestActivity1
FOREIGN KEY (i_workflow_request_id)
REFERENCES RM_WF_Request (i_workflow_request_id);
/* Foreign Key Constraints for RM_WF_Request_Assigned_To */
ALTER TABLE dbo.RM_WF_Request_Assigned_To
ADD CONSTRAINT FkRmWfRequestAssignedTo1
FOREIGN KEY (i_workflow_request_id)
REFERENCES RM_WF_Request (i_workflow_request_id);
/* Foreign Key Constraints for RM_WF_Request_Attachment */
ALTER TABLE dbo.RM_WF_Request_Attachment
ADD CONSTRAINT FkRmWfRequestAttachment1
FOREIGN KEY (i_workflow_request_id)
REFERENCES RM_WF_Request (i_workflow_request_id);
/* Foreign Key Constraints for RM_WF_Request_Item */
ALTER TABLE dbo.RM_WF_Request_Item
ADD CONSTRAINT FkRmWfRequestItem1
FOREIGN KEY (i_workflow_request_id)
REFERENCES RM_WF_Request (i_workflow_request_id);
/* Foreign Key Constraints for RM_WF_Request_Item_Fail */
ALTER TABLE dbo.RM_WF_Request_Item_Fail
ADD CONSTRAINT FkRmWfRequestItemFail1
FOREIGN KEY (i_workflow_request_id, i_workflow_request_item_id)
REFERENCES RM_WF_Request_Item (i_workflow_request_id, i_workflow_request_item_id);
/* Foreign Key Constraints for RM_WF_Request_Item_PropVal */
ALTER TABLE dbo.RM_WF_Request_Item_PropVal
ADD CONSTRAINT FkRmWfRequestItemPropval1
FOREIGN KEY (i_workflow_request_id, i_workflow_request_item_id)
REFERENCES RM_WF_Request_Item (i_workflow_request_id, i_workflow_request_item_id);
/* Foreign Key Constraints for RM_WF_Request_Stage */
ALTER TABLE dbo.RM_WF_Request_Stage
ADD CONSTRAINT FkRmWfRequestStage1
FOREIGN KEY (i_workflow_request_id)
REFERENCES RM_WF_Request (i_workflow_request_id);
/* Foreign Key Constraints for RM_WF_Request_Stage_Appr_Group */
ALTER TABLE dbo.RM_WF_Request_Stage_Appr_Group
ADD CONSTRAINT FkRmWfRequestStageApprGroup1
FOREIGN KEY (i_workflow_request_id, i_stage_id, i_stage_approval_id)
REFERENCES RM_WF_Request_Stage_Approval (i_workflow_request_id, i_stage_id, i_stage_approval_id);
/* Foreign Key Constraints for RM_WF_Request_Stage_Approval */
ALTER TABLE dbo.RM_WF_Request_Stage_Approval
ADD CONSTRAINT FkRmWfRequestStageApproval1
FOREIGN KEY (i_workflow_request_id, i_stage_id)
REFERENCES RM_WF_Request_Stage (i_workflow_request_id, i_stage_id);
/* Foreign Key Constraints for RM_WF_Request_Stage_Enriched */
ALTER TABLE dbo.RM_WF_Request_Stage_Enriched
ADD CONSTRAINT FkRmWfRequestStageEnriched1
FOREIGN KEY (i_workflow_request_id, i_stage_id)
REFERENCES RM_WF_Request_Stage (i_workflow_request_id, i_stage_id);
/* Foreign Key Constraints for RM_WF_Request_Tag */
ALTER TABLE dbo.RM_WF_Request_Tag
ADD CONSTRAINT FkRmWfRequestTag1
FOREIGN KEY (i_workflow_request_id)
REFERENCES RM_WF_Request (i_workflow_request_id);
/* Foreign Key Constraints for RM_WF_Task */
ALTER TABLE dbo.RM_WF_Task
ADD CONSTRAINT FkRmWfTask1
FOREIGN KEY (c_domain_abbrev)
REFERENCES RM_Domain (c_abbrev);
/* Foreign Key Constraints for RM_WF_Task_Commit_Op_Param */
ALTER TABLE dbo.RM_WF_Task_Commit_Op_Param
ADD CONSTRAINT FkRmWfTaskCommitOpParam1
FOREIGN KEY (i_task_id)
REFERENCES RM_WF_Task (i_task_id);
ALTER TABLE dbo.RM_WF_Task_Commit_Op_Param
ADD CONSTRAINT FkRmWfTaskCommitOpParam2
FOREIGN KEY (i_task_id, i_commit_operation_id)
REFERENCES RM_WF_Task_Commit_Operation (i_task_id, i_commit_operation_id);
/* Foreign Key Constraints for RM_WF_Task_Commit_Operation */
ALTER TABLE dbo.RM_WF_Task_Commit_Operation
ADD CONSTRAINT FkRmWfTaskCommitOperation1
FOREIGN KEY (i_task_id)
REFERENCES RM_WF_Task (i_task_id);
ALTER TABLE dbo.RM_WF_Task_Commit_Operation
ADD CONSTRAINT FkRmWfTaskCommitOperation2
FOREIGN KEY (i_connection_id, i_operation_id)
REFERENCES RM_Connection_Operation (i_connection_id, i_operation_id);
ALTER TABLE dbo.RM_WF_Task_Commit_Operation
ADD CONSTRAINT FkRmWfTaskCommitOperation3
FOREIGN KEY (i_status_property_id)
REFERENCES RM_Property_Definition (i_property_id);
/* Foreign Key Constraints for RM_WF_Task_Property */
ALTER TABLE dbo.RM_WF_Task_Property
ADD CONSTRAINT FkRmWfTaskProperty1
FOREIGN KEY (i_task_id)
REFERENCES RM_WF_Task (i_task_id);
/* Foreign Key Constraints for RM_WF_Task_Validation */
ALTER TABLE dbo.RM_WF_Task_Validation
ADD CONSTRAINT FkRmWfTaskValidation1
FOREIGN KEY (i_task_id)
REFERENCES RM_WF_Task (i_task_id);
ALTER TABLE dbo.RM_WF_Task_Validation
ADD CONSTRAINT FkRmWfTaskValidation2
FOREIGN KEY (i_validation_id)
REFERENCES RM_Validation_Definition (i_validation_id);
/* Foreign Key Constraints for RM_WF_Task_Validation_Property */
ALTER TABLE dbo.RM_WF_Task_Validation_Property
ADD CONSTRAINT FkRmWfTaskValidationProperty1
FOREIGN KEY (i_task_id, i_task_validation_id)
REFERENCES RM_WF_Task_Validation (i_task_id, i_task_validation_id);
ALTER TABLE dbo.RM_WF_Task_Validation_Property
ADD CONSTRAINT FkRmWfTaskValidationProperty2
FOREIGN KEY (i_task_id)
REFERENCES RM_WF_Task (i_task_id);
IF OBJECT_ID('dbo.DAL_DUAL') IS NOT NULL
DROP VIEW dbo.DAL_DUAL;
GO
CREATE VIEW dbo.DAL_DUAL AS
SELECT 'x' AS DUMMY;
GO
GO
IF OBJECT_ID('dbo.DAL_VERSION') IS NOT NULL
DROP VIEW dbo.DAL_VERSION;
GO
CREATE VIEW dbo.DAL_VERSION AS
SELECT '11.1.2.4.340.1:0' AS c_version;
GO
GO
IF OBJECT_ID('dbo.RM_Access_Group_Hierarchy') IS NOT NULL
DROP VIEW dbo.RM_Access_Group_Hierarchy;
GO
CREATE VIEW dbo.RM_Access_Group_Hierarchy AS
SELECT DISTINCT
i_security_id,
i_version_id,
i_hierarchy_id
FROM RM_Access_Group_Prop_Local
WHERE COALESCE(e_access_level, N'') != 'None';
GO
GO
IF OBJECT_ID('dbo.RM_Book_Item_Export') IS NOT NULL
DROP VIEW dbo.RM_Book_Item_Export;
GO
CREATE VIEW dbo.RM_Book_Item_Export AS
SELECT
bi.i_book_id,
bi.i_book_item_id,
bi.i_export_id,
ex.c_export_abbrev,
ex.i_user_id
FROM RM_Book_Item bi
JOIN RM_Export ex on bi.i_export_id = ex.i_export_id;
GO
IF OBJECT_ID('dbo.USP_GETNEXTSEQUENCE') IS NOT NULL
DROP PROC dbo.USP_GETNEXTSEQUENCE;
GO
CREATE PROCEDURE dbo.usp_GetNextSequence
(
@p_v_c_key_field varchar(50),
@p_v_i_reserve int = 1,
@p_v_result int = null out
)
AS
BEGIN
SET NOCOUNT ON
BEGIN TRAN
UPDATE DAL_Sequence
WITH (SERIALIZABLE)
SET i_id = i_id + @p_v_i_reserve
WHERE c_key = @p_v_c_key_field
IF @@ROWCOUNT = 0
INSERT INTO DAL_Sequence (c_key, i_id) SELECT @p_v_c_key_field, @p_v_i_reserve
SELECT @p_v_result = i_id - @p_v_i_reserve + 1
FROM DAL_Sequence
WITH (SERIALIZABLE)
WHERE c_key = @p_v_c_key_field
COMMIT TRAN
SET NOCOUNT OFF
END
GO
IF OBJECT_ID('dbo.USP_WFCLAIMREQUEST') IS NOT NULL
DROP PROC dbo.USP_WFCLAIMREQUEST;
GO
CREATE PROCEDURE dbo.usp_WfClaimRequest
(
@p_v_i_workflowRequestId int,
@p_v_c_username nvarchar(255),
@p_v_updatedCount int = null out
)
AS
BEGIN
SET NOCOUNT OFF
BEGIN TRAN
UPDATE RM_WF_Request SET
c_current_claimed_by = @p_v_c_username,
d_current_claimed_on = GETUTCDATE()
WHERE
i_workflow_request_id = @p_v_i_workflowRequestId AND
c_current_claimed_by IS NULL;
SET @p_v_updatedCount = @@ROWCOUNT;
COMMIT TRAN
END
GO
IF OBJECT_ID('dbo.UF_COLUMNEXISTS') IS NOT NULL
DROP FUNCTION dbo.UF_COLUMNEXISTS;
GO
CREATE FUNCTION dbo.uf_ColumnExists (@tbl VARCHAR(40), @col VARCHAR(40))
RETURNS bit
WITH EXECUTE AS CALLER
AS
BEGIN
RETURN (SELECT CASE WHEN EXISTS (
SELECT * FROM sysobjects, syscolumns
WHERE sysobjects.id = syscolumns.id
and sysobjects.name = @tbl
and syscolumns.name = @col
) THEN 1 ELSE 0 END);
END
GO
-- User: <DBAUSER>
DECLARE @viewName AS NVARCHAR(500)
DECLARE viewsCursor CURSOR LOCAL FOR SELECT DISTINCT name from sys.views
OPEN viewsCursor
FETCH NEXT FROM viewsCursor INTO @viewName
WHILE (@@FETCH_STATUS = 0)
BEGIN
BEGIN TRY
EXEC sp_refreshview @viewName;
PRINT @viewName
END TRY
BEGIN CATCH
-- Don't worry about the errors here. The view will refresh when used. We just may not
-- be able to get column information quite yet.
END CATCH;
FETCH NEXT FROM viewsCursor INTO @viewName
END
CLOSE viewsCursor
DEALLOCATE viewsCursor
*******************************************************************************
Thanks,
