/*
Run this script on:

192.168.3.105\MSSQLSERVER2014.MinovaHR_BANK_MEGA_Production    -  This database will be modified

to synchronize it with:

remote.minovais.com,1458.MinovaHR_BANK_MEGA_Development

You are recommended to back up your database before running this script

Script created by SQL Data Compare version 14.2.9.15508 from Red Gate Software Ltd at 03/09/2025 10.21.32

*/
		
SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
GO
SET DATEFORMAT YMD
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL Serializable
GO
BEGIN TRANSACTION

PRINT(N'Add rows to [dbo].[base_sys_controller_registered]')
SET IDENTITY_INSERT [dbo].[base_sys_controller_registered] ON
INSERT INTO [dbo].[base_sys_controller_registered] ([id], [registered], [controller_type_name], [controller_name_change]) VALUES (60, 1, N'BankMega.MinovaERP.Extended.HR.Web.Core.Ext.Plugin.HR_CoreExtController', N'BankMega_CoreExt')
SET IDENTITY_INSERT [dbo].[base_sys_controller_registered] OFF
PRINT(N'Operation applied to 1 rows out of 2')

PRINT(N'Add rows to [dbo].[devt_object]')
INSERT INTO [dbo].[devt_object] ([landscape], [module], [name], [ver], [active], [seq], [promoted], [promote_id], [systype], [objtype], [objclass], [finput], [content], [url], [create_user], [create_dt], [change_user], [change_dt], [on_the_fly_code]) VALUES (N'100', N'HR_APP', N'fnViolationCategory', 1, N'1', 0, N'1', N'00000000', N'S', N'CODE', N'', N'id, target_id, val', N'var cmb = Ext.getCmp(id);
var target = Ext.getCmp(target_id);

target.setDisabled(true);
target.setValue('''');
target.store.removeAll();
target.store.reload({
     params: {code_viol_category: val}
});
target.setDisabled(false);', NULL, NULL, NULL, NULL, NULL, 0)
PRINT(N'Operation applied to 1 rows out of 45')

PRINT(N'Add rows to [dbo].[hr_md_field]')
INSERT INTO [dbo].[hr_md_field] ([landscape], [code], [seq_no], [field_name], [primary_key], [name_emp], [name_app], [app], [emp], [class], [gridview], [column_no], [read_only], [required], [max_size], [min_value], [max_value], [default_value_emp], [default_value_app], [controller_store_emp], [controller_store_app], [width], [anchor], [popup_func], [select_func], [change_func], [grid_renderer_func], [select_func_target], [change_func_target], [submit_value]) VALUES (N'100', N'0010', 11, N'status', N'0', N'Status', N'', N'0', N'1', N'combobox', N'1', N'1', N'', N'1', N'', N'', N'', N'', N'', N'/UserControl/DataCombo?tableName=hr_md_status&value=code&display=description', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'1')
INSERT INTO [dbo].[hr_md_field] ([landscape], [code], [seq_no], [field_name], [primary_key], [name_emp], [name_app], [app], [emp], [class], [gridview], [column_no], [read_only], [required], [max_size], [min_value], [max_value], [default_value_emp], [default_value_app], [controller_store_emp], [controller_store_app], [width], [anchor], [popup_func], [select_func], [change_func], [grid_renderer_func], [select_func_target], [change_func_target], [submit_value]) VALUES (N'100', N'0010', 12, N'type_of_risk', N'0', N'Type Of Risk', N'', N'0', N'1', N'combobox', N'1', N'1', N'', N'1', N'', N'', N'', N'', N'', N'/UserControl/DataCombo?tableName=type_of_risk&value=risk_code&display=description', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'1')
INSERT INTO [dbo].[hr_md_field] ([landscape], [code], [seq_no], [field_name], [primary_key], [name_emp], [name_app], [app], [emp], [class], [gridview], [column_no], [read_only], [required], [max_size], [min_value], [max_value], [default_value_emp], [default_value_app], [controller_store_emp], [controller_store_app], [width], [anchor], [popup_func], [select_func], [change_func], [grid_renderer_func], [select_func_target], [change_func_target], [submit_value]) VALUES (N'100', N'0010', 13, N'violation_category', N'0', N'Violation Category', N'', N'0', N'1', N'combobox', N'1', N'1', N'', N'1', N'', N'', N'', N'', N'', N'/UserControl/DataCombo?tableName=hr_md_violation_category&value=codeViolation&display=violent_Description', N'', N'', N'', N'', N'fnViolationCategory', N'fnViolationCategory', N'', N'sub_violation_category', N'sub_violation_category', N'1')
INSERT INTO [dbo].[hr_md_field] ([landscape], [code], [seq_no], [field_name], [primary_key], [name_emp], [name_app], [app], [emp], [class], [gridview], [column_no], [read_only], [required], [max_size], [min_value], [max_value], [default_value_emp], [default_value_app], [controller_store_emp], [controller_store_app], [width], [anchor], [popup_func], [select_func], [change_func], [grid_renderer_func], [select_func_target], [change_func_target], [submit_value]) VALUES (N'100', N'0010', 14, N'sub_violation_category', N'0', N'Sub Violation Category', N'', N'0', N'1', N'combobox', N'1', N'1', N'', N'1', N'', N'', N'', N'', N'', N'/BankMega_CoreExt/GetSubViolCatFilter/', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'1')
PRINT(N'Operation applied to 4 rows out of 35')
COMMIT TRANSACTION
GO
