/* *********************************************************************************** */ /* *** NOTE: This script must be run on each individual extracted database as well *** */ /* *** as the consolidated *** */ /* *********************************************************************************** */ INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_Type', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_Enterprise_Config_Header-2', (SELECT db_property( 'GlobalDBId' )), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_Cost_Rule', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bi_SM_Audit_Log', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bu_SM_Audit_Log', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bi_SM_Action_Schedules', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bu_SM_Action_Schedules', (SELECT db_property( 'GlobalDBId' )), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bi_SM_Action_Trigger', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bu_SM_Action_Trigger', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bi_SM_Image_Store', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bu_SM_Image_Store', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bi_SM_System_Log', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bu_SM_System_Log', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bi_SM_Site', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_IsAuthorisedItem', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_IsAuthorisedItem', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bi_SM_Event_Actions', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bu_SM_Event_Actions', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_UC_AssignConnectionUserCode', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_EntCfgGetHeaderNo', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_EntCfgSetItemValue', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_EntCfgDeleteItemGroup', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_EntCfgGetItemValue', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_EntCfgItemValues', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_GetAuthorisingItemsScript', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('au_SM_Operator', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('ad_SM_Site', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PrintService_TemplateDets', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('CKC_FILTER_DATETIME_T_SM_RPT_F', (SELECT db_property( 'GlobalDBId' )), 1);