/* *********************************************************************************** */ /* *** 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('Gold_Coast_Export_View', (SELECT db_property( 'GlobalDBId' )), 4); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PROC_Reverse_Tran', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_0206', (SELECT db_property( 'GlobalDBId' )), 4); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_0211', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('ai_WM_Payment', (SELECT db_property( 'GlobalDBId' )), 4); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('au_WM_Payment', (SELECT db_property( 'GlobalDBId' )), 10); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_0160', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_0153', (SELECT db_property( 'GlobalDBId' )), 5); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES ('au_WM_Transaction_Header', (SELECT db_property( 'GlobalDBId' )), 4); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES ('bu_WM_Transaction_Header', (SELECT db_property( 'GlobalDBId' )), 8); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES ('bu_WM_Payment', (SELECT db_property( 'GlobalDBId' )), 5); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES ('bu_WM_Transaction_Header_A', (SELECT db_property( 'GlobalDBId' )), 4); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('ai_WM_Transaction_Header', 2, (SELECT db_property( 'GlobalDBId' ))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('bd_WM_Transaction_Header', 12, (SELECT db_property( 'GlobalDBId' ))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('ai_WM_Transaction_Payment', 3, (SELECT db_property( 'GlobalDBId' ))); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('System_Log_Event_Desc', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Audit_Log_Event_Desc', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bi_WM_Customer', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bu_WM_Customer', (SELECT db_property('GlobalDBId')), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bi_WM_Transaction_Header', (SELECT db_property('GlobalDBId')), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bi_WM_Payment', (SELECT db_property('GlobalDBId')), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('BaseFrame_PrintDockRate', (SELECT db_property('GlobalDbID')), 4); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('VisualFrame_PaymentGrid', (SELECT db_property('GlobalDbID')), 6); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('AddSQLRemoteSystemLog', (SELECT db_property('GlobalDBId')), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('AddSQLRemoteAuditLog', (SELECT db_property('GlobalDbID')), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('ru_WM_Area', 1, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('ru_WM_Attachment', 1, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('ru_WM_Customer', 1, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('ru_WM_Job_Auth_Product', 1, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('ru_WM_Vehicle', 1, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('ad_WM_Transaction_Payment', 2, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('Default_View_0205', 1, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('Default_View_0212', 1, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('BaseFrame_UnallocatedPayments', (SELECT db_property('GlobalDbID')), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('sp_hook_dbremote_begin', 3, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('sp_hook_dbremote_end', 4, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('Payment_Allocation_Errors', 1, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('FixPaymentAllocError', 2, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('FixPaymentAllocationErrors', 4, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('Transaction_Allocation_Errors', 1, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('GCCC_Pay_Off_Transactions', 3, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('SM_Image_Store', 1, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('au_WM_Transaction_Item', 5, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('ai_WM_Transaction_Item', 4, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('BaseFrame_PrintDockHdr', 7, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('WM_Customer', 1, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('bu_WM_Vehicle', 2, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_0141', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('FixDuplicateVehicles', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('FixTransactionAllocationErrors', (SELECT db_property( 'GlobalDBId' )), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_Actions_Input_Event_ID', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_Actions_Input_Event_State', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_Actions_Enable_IO_Registration', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_Exceptions', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_Payment', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('VisualFrame_OpenChequeGrid', (SELECT db_property( 'GlobalDBId' )), 4); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('DumpPaymentsNotFullyAllocated', (SELECT db_property( 'GlobalDBId' )), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('TranExceptionCodes', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('TranExceptionNames', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_Enterprise_Config_Header', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_Enterprise_Config_Item', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_IdCard_Header', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_IdCard_Reader', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_IdCard_Action_Params', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_1041', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_1042', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-SM_Actions', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-SM_Action_Item_Params', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-SM_Default_View_Type', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-SM_DuplicateAction', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-SM_Operator', (SELECT db_property( 'GlobalDBId' )), 4); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Accounts_Tran_Import_View', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-Dom_Authorisation_Class_ID', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-Dom_Authorisation_Class_Key', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-Dom_Authorisation_Process', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-SM_Authorisation_Config', (SELECT db_property( 'GlobalDBId' )), 4); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-SM_Authorisation_Detail', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Proc_AuthorisedCustomers', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Proc_IsAuthorisedCustomer', (SELECT db_property('GlobalDBId')), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_0107', (SELECT db_property('GlobalDBId')), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-SM_Site', (SELECT db_property('GlobalDBId')), 8); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('BaseFrame_PrintOCHdr', 3, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('WM_Product_Rate', 1, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('Passthrough-SM_Enterprise_Config_Header', 5, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_0186', (SELECT db_property( 'GlobalDBId' )), 5); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-SM_Rpt_Report', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Prepare_CBA_Export_Data', (SELECT db_property('GlobalDBId')), 4); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Set_CBA_Export_Batch_No', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bd_WM_Transaction_Exception', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-SM_Cost_Rule', (SELECT db_property('GlobalDBId')), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-ai_SM_Cost_Rule_Item', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-au_SM_Cost_Rule_Item', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-ad_SM_Cost_Rule_Item', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('ru_WM_Payment', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-bi_SM_Site', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Cash_Drawer_Detail_View', (SELECT db_property('GlobalDBId')), 4); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-IDX_Auth_Config_Relationship', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-SM_Authorisation_Item', (SELECT db_property('GlobalDBId')), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-SM_IsAuthorisedItem', (SELECT db_property('GlobalDBId')), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-SM_ReplicationInProgress', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-SM_Site_Connect_Command', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-Site_Connect_Command_Type', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-MasterDBSiteNo', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Waste_Stream_Transfer', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_Accounts_Pay_Import_Data', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_Save_Accounts_Pay_Import_Data', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bd_WM_Transaction_Item', (SELECT db_property('GlobalDBId')), 4); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bi_WM_Tran_Prod_Component', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bu_WM_Tran_Prod_Component', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('EPA_SMA_Tran_Items', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('EPA_ERA_Tran_Items', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('EPA_NSW_Tran_Items', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Passthrough-SM_SecurityUpdate', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_UC_AssignConnectionUserCode', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_UC_AssignConnectionUserCode', (SELECT db_property('GlobalDBId')), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_UC_RemoveConnectionUserCode', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_UC_UpdateProcessUserCode', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_UC_GetConnectionAppUserID', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_Date_Domains', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_Unit_Of_Measure', (SELECT db_property('GlobalDBId')), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_Created_Modified', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-bi_SM_Event_Actions', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-bu_SM_Event_Actions', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-bu_SM_Action_Schedules', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_Object_Class', (SELECT db_property( 'GlobalDBId' )), 10); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_Incident_Log', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_Email_Queue', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_RPT_FILTER', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Pub_WM_Transaction_Image', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_Site_Workstation', (SELECT db_property('GlobalDBId')), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_EntCfgCreateHeaderRec', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_EntCfgCreateItemRec', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_EntCfgGetHeaderNo', (SELECT db_property('GlobalDBId')), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_EntCfgGetItemNo', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_EntCfgGetItemValue', (SELECT db_property('GlobalDBId')), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_EntCfgDeleteItemGroup', (SELECT db_property('GlobalDBId')), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_EntCfgHeaderNames', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_EntCfgItemValues', (SELECT db_property('GlobalDBId')), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_EntCfgSetItemValue', (SELECT db_property('GlobalDBId')), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-IDX_Header_Name', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_0214', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-IDX_SecurityAccess', (SELECT db_property('GlobalDBId')), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SiteCustRefFields', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-IDX_AuthingKey', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-IDX_AuthedKey', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('VisualFrame_JobProgressGrid', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_Action_Schedules', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('ad_WM_Transaction_Item', (SELECT db_property( 'GlobalDBId' )), 5); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_User_Connection', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_UC_ValidateUserConnections', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Proc_WM_AuthorisedList', (SELECT db_property( 'GlobalDBId' )), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT_SM_List_Form_View', (SELECT db_property( 'GlobalDBId' )), 4); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('BaseFrame_VideoHdr', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('GetDatabaseSiteNo', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_BaseFrame_CashSummaryQuery', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Round_By', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_0170', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_GetProductCharges', (SELECT db_property( 'GlobalDBId' )), 8); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_0159', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_GetAppName', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_GetHostName', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_GetLocalSiteNo', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_SetDefaultLocalSite', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_SetLocalSite', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_Note', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_Vehicle_Note', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_GetAuthorisedItemsScript', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_GetAuthorisingItemsScript', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_AuthLookupList', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_ObjectClassForName', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_0215', (SELECT db_property( 'GlobalDBId' )), 5); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_0216', (SELECT db_property( 'GlobalDBId' )), 5); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_0217', (SELECT db_property( 'GlobalDBId' )), 5); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_BuildTranLookupList', (SELECT db_property( 'GlobalDBId' )), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_0113', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-au_SM_Operator', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_Group_Definition', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_Group_Code_Definition', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-FK_SM_GROUP_REFERENCE_SM_GROUP', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-FK_SM_GRPDEF_REF_SM_GRPCODE', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-au_SM_Group_Definition', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-bi_SM_Group_Definition', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-bu_SM_Group_Definition', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-bi_SM_Group_Code_Definition', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-bu_SM_Group_Code_Definition', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_IdCard_Header', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_Vehicle_Type', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('BaseFrame_PrintOCItem', 2, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Version_No, Database_ID) VALUES('BaseFrame_PrintOCTotals', 2, (SELECT db_property('GlobalDBId'))); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_0149', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_System_Log', (SELECT db_property( 'GlobalDBId' )), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_Audit_Log', (SELECT db_property( 'GlobalDBId' )), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_Image_Store', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_MD_Product_Rate_Component', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('ad_WM_Customer', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-ad_SM_Operator', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-au_SM_Operator_2', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-ad_SM_Security_Object', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-au_SM_Security_Object', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-ad_SM_Site', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-au_SM_Site', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_PurgeInvalidAuthItems', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('BaseFrame_PrintDockItem', (SELECT db_property('GlobalDbID')), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_IsReplicating', (SELECT db_property('GlobalDbID')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_GetProductChargesAuth', (SELECT db_property( 'GlobalDBId' )), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_DuplicateProductRate', (SELECT db_property( 'GlobalDBId' )), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_MD_GetRatesForExport', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_ListViewTestStart', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_ListViewTestEnd', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_Print_Template_Item', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-PrintService_TemplateDets', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('BaseFrame_PrintDockJob', (SELECT db_property('GlobalDbID')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('CKT_WM_PAYMENT', (SELECT db_property('GlobalDbID')), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('CKC_PAYMENT_TYPE_WM_PAYME', (SELECT db_property('GlobalDbID')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('CKC_CASH_DRAWER_LOG_T_WM_CASH_', (SELECT db_property('GlobalDbID')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_CreateTranReversal', (SELECT db_property('GlobalDbID')), 5); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_GetNextEftposRef', (SELECT db_property('GlobalDbID')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_BaseFrame_CompletedTran', (SELECT db_property('GlobalDbID')), 3); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-WM_Accounts_Tran_Import_Data', (SELECT db_property('GlobalDbID')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-WM_Save_Accounts_Tran_Import_Data', (SELECT db_property('GlobalDbID')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Clear_EPA_RPTM_Tables', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_VisualFrame_TempAccountGrid', (SELECT db_property('GlobalDBId')), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_BaseFrame_PrintTempAccItem', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_BaseFrame_PrintTempAccTotals', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('Default_View_0019', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_LinkRefundPayment', (SELECT db_property('GlobalDBId')), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('CKT_WM_CASH_DRAWER_LOG', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_Site_Group', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-SM_Site_Group_FK', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('PT-CKC_FILTER_DATETIME_T_SM_RPT_F', (SELECT db_property('GlobalDbID')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('BaseFrame_VideoItem', (SELECT db_property('GlobalDbID')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_Accounts_Tran_Import_Data', (SELECT db_property('GlobalDbID')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_Save_Accounts_Tran_Import_Data', (SELECT db_property('GlobalDbID')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('SM_Email_Queue-1', (SELECT db_property( 'GlobalDBId' )), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bi_WM_Vehicle_Note', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('bu_WM_Vehicle_Note', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_UpdateVehicleDefaults', (SELECT db_property('GlobalDBId')), 2); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('CKT_WM_TRANSACTION_HEADER', (SELECT db_property('GlobalDbID')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_BaseFrame_IncompleteTran', (SELECT db_property('GlobalDbID')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('CKT_WM_TRANSACTION_ITEM', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('CKT_WM_TRANSACTION_ITEM_A', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_CreatePaymentReversal', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_AvailablePayments', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_RefundablePayments', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_BaseFrame_CashSummShortPayList', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_BaseFrame_CashSummUnallocPayList', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_Underpayment_List_2', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('VisualFrame_UnderpaymentGrid', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_EPA_LGA-DROP Region CHECK', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_EPA_RPTM_Source', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_EPA_RPTQ_Source', (SELECT db_property('GlobalDBId')), 1); INSERT "DBA".SM_Version_Control(Entity_Name, Database_ID, Version_No) VALUES('WM_EPAExport_NSW', (SELECT db_property('GlobalDBId')), 1);