
if not exists(select 1 from [dbo].[SystemParameters])
BEGIN
	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'90dbcfdf-4365-4218-b4c8-01b328d3eab8', N'BL.Reports', N'Default', N'DailyCaregiverReport_ToSendSms', N'Send SMS in daily report', N'Yes', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'23dedbe3-4a3e-4f4e-b855-0c84f459e1cd', N'CoxSystemParameters', N'default', N'GetNotificationsQuantity', N'The number of last notifications returned if none are specified', N'20', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'3b3ad120-1b93-4b0d-94ef-12890e10cb65', N'MedicalGuardianAuthorizationParameters', N'default', N'TokenAuthorizationRequestBody', N'The request body used to call the MG server for the token authorize call', N'code={0}&grant_type=authorization_code&client_id={1}&client_secret={2}', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'41a29aa6-6e68-4ea5-8128-1a2deab6bb6c', N'AuthenticationProviderDeviceAuthorizationParameters', N'default', N'TokenExpiration', N'The token expiration time in minutes. 0 Means never expires', N'0', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'80355511-6021-47d6-988d-1fc17e54ee2b', N'PasswordPolicy', N'DefaultPolicy', N'PasswordMinimumLength', N'Minimum length of a password', N'6', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'0aa1083e-336c-4594-a9f7-2010b4307d25', N'EUP', N'Main', N'WatcherPath', N'WatcherPath Parameter', N'C:\Program Files\Essence Connect Server\Maximus\EventUploaderCommandTriggers', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'1c1ed48c-49de-4a31-a0c3-2107cc2e0d45', N'ArmingExitDelay', N'1', N'Time', N'Default value of panel exit delay time', N'30', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'f248215d-021d-46d4-8638-223b12db6557', N'MedicalGuardianAuthorizationParameters', N'default', N'ErrorRedirectUrl', N'The url to redirect to, after user gets an error- used by client', N'https://www.medicalguardian.com/client-services-portal', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'f00c4b3e-f17a-4167-9fe1-2390443d115a', N'AdlAuthorizationPolicy', N'default', N'SessionTokenExpirationDays', N'The span of days for the token expiration', N'180', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'261a2d30-e22e-4341-8f0e-25a2c574210b', N'AdlRulePolicyFamily', N'default', N'Wandering_Maximum', N'Maximum number of rules of type Wandering allowed', N'1', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'51925b30-b53d-417b-9330-271cbf839aa2', N'default', N'default', N'NumOfCyclesForGetExistingVideo', N'', N'15', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'70c38adf-f9ad-49cd-a2ca-29be300c41cf', N'MedicalGuardianAuthorizationParameters', N'default', N'TokenAuthorizationUrl', N'The url used to call the MG server for the token authorize call', N'https://www.medicalguardian.com/oauth2/token?grant_type=authorization_code', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'6b3f1262-9c58-40b0-9b85-2b089b28da6e', N'MedicalGuardianAuthorizationParameters', N'default', N'ClientSecret', N'The client Secret in MG server', N'26886221-2676-46d3-8d4f-1819271ff6dd', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'13eb099f-376f-402e-b1c0-2fa36ec2819c', N'PasswordPolicyValidation', N'default', N'CharGroupsMinimum', N'Minimum char groups that must be used when defining a password', N'3', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'f8d573e9-e586-499a-9959-30be89460ff7', N'HeartBeat', N'TimerEngineHeartBeat', N'Interval', N'The interval for the heart beat in seconds', N'15', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'3f500d5c-2dca-4c7d-a4b2-317e1375268d', N'AdlRulePolicyFamily', N'default', N'MaximumNumberOfPeriods', N'Maximum Number Of Periods Allowed', N'16', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'438b50f9-7938-43cb-9cc7-3327c2645303', N'AlertMailTemplate', N'default', N'AppLink', N'The url to redirect to our app', N'http://adl.wersystem.com:8080/ADL/login', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'44535e02-9f57-407c-8315-37901742b092', N'default', N'default', N'TemperatureUnit', N'The default way temperature shall be represented in the system (0 - Celsius, 1 - Fahrenheit)', N'0', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'254c0ac1-176b-4bf3-baf2-39abf98633cc', N'EpaParameters', N'default', N'EpaNotWornDurationTriggerEventInHours', N'The number of non worn hours that trigger EPA non compliance event', N'6', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'58b9ce18-1c59-4406-a138-3be9d2f45a0a', N'PasswordPolicy', N'DefaultPolicy', N'PasswordHistoryGenerations', N'Number of password generations to validate against when changing a password', N'1', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'925dcca8-ac8c-49d8-8d37-41a4b25fdf13', N'default', N'default', N'ThermostatFanSupportedModes', N'The default fan modes supported by a thermostat (eg: 3 = Auto-Low + Low)', N'3', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'3551210e-3593-4efb-8b08-428e9eaa6bec', N'default', N'default', N'TimeZone', N'The default time zone of hubs in the system (the internal ID from the dbo.CD_TimeZone table)', N'0', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'dce4cab7-00c8-47c7-9c1d-478625e53533', N'AdlFamilyInstallDefaults', N'default', N'NumberOfUsersInPanelLimited', N'Is there a limit to the numer of users that can be defined for a panel', N'True', N'System.Boolean', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'9d9059c6-8bf1-4d8c-8fb9-49036174905c', N'UserManagementPolicy', N'default', N'UpdateRequiredPermissionType', N'Who has the permission to perform CRUD operation on users', N'CareGiverOrAdministrator', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'0bb35691-92ea-4a45-9476-4fa4e05d54e9', N'IPCamera', N'default', N'Password', N'Default password for IPCamera', N'admin', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'3cf56c63-0e8f-4012-b8f1-514fd61e0b95', N'IPCamera', N'default', N'Settings', N'Default settings for IPCamera', N'{"rtsp": { "port": 554, "authentication": 2,"rtcp":0 }, "profiles": { "index": 1, "name": "Day", "brightness": 0, "contrast": 2, "sharpness": 3, "colorSaturation": -1, "deNoise": 3, "exposureMode": 0, "mirror": 0, "flip": 0, "effectMode": 1, "colorMode": 0, "frequency": 1, "whiteBalance": 1, "envMode": 0, "AESensitivity": 2, "EV": 0 }, "channels": [ { "channelId": 1, "name": "HD", "enableStream": true, "codecType": "H264", "resolutionWidth": 1280, "resolutionHeight": 800, "frameRate": 30, "isConstantBitRate": false, "quality": 60, "transportType": 0, "audioEnable": true, "audioCodecType": "G711", "audioCodecSubType": "PCMU" }, { "channelId": 2, "name": "LD", "enableStream": true, "codecType": "H264", "resolutionWidth": 640, "resolutionHeight": 400, "frameRate": 20, "isConstantBitRate": false, "quality": 30, "transportType": 0, "audioEnable": true, "audioCodecType": "G711", "audioCodecSubType": "PCMU" } ]}', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'18a3a82c-46f8-4d3e-acbc-56705c9cc15a', N'ActivityProcessMaintenance', N'default', N'IntervalMinutes', N'Interval in minutes to consider a job to long running', N'180', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'9d5ec84e-34f5-458d-a5f6-568eaf627e1a', N'PasswordPolicyValidation', N'default', N'PasswordHistoryGenerationsMaximum', N'The maximum number of password generations', N'10', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'b489e7da-ec67-4b7f-a98b-5d21117c79d5', N'PasswordPolicyValidation', N'default', N'PasswordExpirationDaysMinimum', N'Minimum number of days for password expiration', N'1', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'3d66a23c-fa4c-4b93-83d4-61e8b1ee7bed', N'Phase1FixedCnfig', N'Default', N'XML', N'XML', N'<?xml version="1.0" encoding="ISO-8859-1"?>
	<fixed_cnfig>
	  <cd config_set="1">
		<id>1</id>
		<clr_data>0</clr_data>
		<steady_pattern_dbg_log>0</steady_pattern_dbg_log>
		<steady_pattern_hist_val>5</steady_pattern_hist_val>
		<steady_pattern_trshhld>50</steady_pattern_trshhld>
		<steady_prsnce_trshhld>50</steady_prsnce_trshhld>
		<use_bulk>1</use_bulk>
		<cluster_spn_th>25</cluster_spn_th>
		<prsence_th>2</prsence_th>
		<grp_min_ratio>20</grp_min_ratio>
		<grp_top_percent>90</grp_top_percent>
		<hist_grade_th>160</hist_grade_th>
		<max_grp_span>90</max_grp_span>
		<opt_grd_th>90</opt_grd_th>
		<low_activity_const_weight>10</low_activity_const_weight>
		<low_activity_standard_score_weight>30</low_activity_standard_score_weight>
		<low_activity_day_count_weight>30</low_activity_day_count_weight>
		<possible_fall_const_weight>80</possible_fall_const_weight>
		<possible_fall_standard_score_weight>40</possible_fall_standard_score_weight>
		<possible_fall_day_count_weight>30</possible_fall_day_count_weight>
		<actvt_inf_const_weight>5</actvt_inf_const_weight>
		<actvt_inf_standard_score_weight>25</actvt_inf_standard_score_weight>
		<actvt_inf_day_count_weight>15</actvt_inf_day_count_weight>
		<possible_fall_relative_val_weight>30</possible_fall_relative_val_weight>
		<possible_fall_heuristic_val_fridgedoor>120</possible_fall_heuristic_val_fridgedoor>
		<possible_fall_heuristic_val_frontdoor>45</possible_fall_heuristic_val_frontdoor>
		<possible_fall_heuristic_val_bedroom>120</possible_fall_heuristic_val_bedroom>
		<possible_fall_heuristic_val_toilet>75</possible_fall_heuristic_val_toilet>
		<possible_fall_heuristic_val_bathroom>75</possible_fall_heuristic_val_bathroom>
		<possible_fall_heuristic_val_livingroom>120</possible_fall_heuristic_val_livingroom>
		<possible_fall_heuristic_val_diningroom>120</possible_fall_heuristic_val_diningroom>
		<possible_fall_heuristic_val_otherroom>120</possible_fall_heuristic_val_otherroom>
	  </cd>
	  <cd config_set="2">
		<id>2</id>
		<clr_data>0</clr_data>
		<steady_pattern_dbg_log>0</steady_pattern_dbg_log>
		<steady_pattern_hist_val>1</steady_pattern_hist_val>
		<steady_pattern_trshhld>70</steady_pattern_trshhld>
		<steady_prsnce_trshhld>70</steady_prsnce_trshhld>
		<use_bulk>1</use_bulk>
		<cluster_spn_th>20</cluster_spn_th>
		<prsence_th>1</prsence_th>
		<grp_min_ratio>5</grp_min_ratio>
		<grp_top_percent>20</grp_top_percent>
		<hist_grade_th>80</hist_grade_th>
		<max_grp_span>90</max_grp_span>
		<opt_grd_th>90</opt_grd_th>
		<low_activity_const_weight>5</low_activity_const_weight>
		<low_activity_standard_score_weight>20</low_activity_standard_score_weight>
		<low_activity_day_count_weight>20</low_activity_day_count_weight>
		<possible_fall_const_weight>5</possible_fall_const_weight>
		<possible_fall_standard_score_weight>20</possible_fall_standard_score_weight>
		<possible_fall_day_count_weight>20</possible_fall_day_count_weight>
		<actvt_inf_const_weight>5</actvt_inf_const_weight>
		<actvt_inf_standard_score_weight>20</actvt_inf_standard_score_weight>
		<actvt_inf_day_count_weight>20</actvt_inf_day_count_weight>
		<possible_fall_relative_val_weight>30</possible_fall_relative_val_weight>
		<possible_fall_heuristic_val_fridgedoor>120</possible_fall_heuristic_val_fridgedoor>
		<possible_fall_heuristic_val_frontdoor>45</possible_fall_heuristic_val_frontdoor>
		<possible_fall_heuristic_val_bedroom>120</possible_fall_heuristic_val_bedroom>
		<possible_fall_heuristic_val_toilet>75</possible_fall_heuristic_val_toilet>
		<possible_fall_heuristic_val_bathroom>75</possible_fall_heuristic_val_bathroom>
		<possible_fall_heuristic_val_livingroom>120</possible_fall_heuristic_val_livingroom>
		<possible_fall_heuristic_val_diningroom>120</possible_fall_heuristic_val_diningroom>
		<possible_fall_heuristic_val_otherroom>120</possible_fall_heuristic_val_otherroom>
	  </cd>
	</fixed_cnfig>', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'f223a35c-64dc-4346-a701-62dd37b2f925', N'AdlFamilyInstallDefaults', N'default', N'MaxNumberOfStandardUsersInPanel', N'The max standard users that can be defined for a ADL family account', N'8', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'e494ace6-e441-479a-adb9-636158727f04', N'PasswordPolicy', N'DefaultPolicy', N'UserLockTimeMinutes', N'The number of minutes to consider the user locked', N'3', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'ab2b86b2-a90f-4b17-82fc-685655d83fb3', N'AlertMailTemplate', N'Default', N'SmtpServer', N'Smtp Server', N'email-smtp.us-west-2.amazonaws.com', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'67e38ca9-c4ce-4ef7-82e1-6b57647ad2a3', N'EUP', N'Main', N'DllPath', N'DllPath Parameters', N'C:\Program Files\Essence Connect Server\Maximus\EventUploaderExtensionsDlls', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'9ed5d675-34a2-4f1f-b1bc-6cee8522c748', N'AlertMailTemplate', N'Default', N'MailFormat', N'Mail Format', N'Html', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'b54ca387-48e4-44fd-884a-6e7ef10aee2b', N'RegisterDeviceParameters', N'default', N'RegistrationWindowTime', N'The device registration open window time in seconds', N'120', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'17218171-508e-4a09-822f-6fd8f62eb507', N'PasswordPolicyValidation', N'default', N'PasswordMaximumLength', N'Maximum possible length of a password', N'20', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'c87dccfe-ad7d-492b-9d8e-71de9fed56db', N'ArmingExitDelay', N'0', N'Time', N'Default value of panel exit delay time', N'30', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'12e6d9f2-2330-4261-99df-734146807967', N'AlertMailTemplate', N'Default', N'User', N'User', N'AKIAJYUJKMRZQCZAC5JA', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'c4460bf7-c35b-4499-b352-7ddb08bffe3f', N'MedicalGuardianAuthorizationParameters', N'default', N'PostLogoutRedirectUrl', N'The url to redirect to, after user log out- used by client', N'https://www.medicalguardian.com/client-services-portal', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'24571733-a955-4c26-9f3d-7ff552aac7f4', N'TimeZone', N'default', N'Interval', N'TimeZone thread delay time in ms', N'600000', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'5aaaae2b-1161-475c-9e22-8110e259bb98', N'AdlRulePolicyFamily', N'default', N'UnexpectedEntryExit_Maximum', N'Maximum number of rules of type UnexpectedEntryExit allowed', N'1', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'71a5c92d-d8d5-4a31-ba47-853b56469da1', N'AdlPanelParameters', N'default', N'AdlPanelOfflineInterval', N'Adl Panel Offline Interval in minutes', N'360', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'7a53b8be-001f-4473-95c5-86e94e341c3c', N'default', N'default', N'RulesLogicsJson', N'json object that holds all the validation directives for the triggers and actions in the rule object', N'{"RuleLogicsCollection": [{"Triggers": ["0"],"Actions": ["0","2","3","4","5","6","7","8","10","11","13"]},{"Triggers": ["0"],"Actions": ["0","2","3","4","5","7","8","10","11","12","13"]},{"Triggers": ["2"],"Actions": ["0","2","3","4","5","6","7","8","10","11","13"]},{"Triggers": ["2"],"Actions": ["0","2","3","4","5","7","8","10","11","12","13"]},{"Triggers": ["0"],"Actions": ["1","2","3","4","5","6","7","8","10","11","13"]},{"Triggers": ["0"],"Actions": ["1","2","3","4","5","7","8","10","11","12","13"]},{"Triggers": ["2"],"Actions": ["1","2","3","4","5","6","7","8","10","11","13"]},{"Triggers": ["2"],"Actions": ["1","2","3","4","5","7","8","10","11","12","13"]},{"Triggers": ["4"],"Actions": ["2","3","4","5","6","7","8","10","11"]},{"Triggers": ["5"],"Actions": ["1","2","3","4","5","6","7","8","10","11"]},{"Triggers": ["6"],"Actions": ["2","3","4","5","6","7","8","10","11"]},{"Triggers": ["7"],"Actions": ["0","2","3","4","5","6","7","8","10","11"]},{"Triggers": ["7"],"Actions": ["1","2","3","4","5","6","7","8","10","11"]},{"Triggers": ["8"],"Actions": ["2","3","4","5","6","7","8","10","11"]},{"Triggers": ["9"],"Actions": ["3","4","5","6","7","8","10","11"]},{"Triggers": ["10"],"Actions": ["2","3","4","5","6","7","8","10","11"]},{"Triggers": ["11"],"Actions": ["3","4","5","6","7","8","10","11"]},{"Triggers": ["12"],"Actions": ["3","4","5","6","7","8"]},{"Triggers": ["1"],"Actions": ["9"]},{"Triggers": ["3"],"Actions": ["9"]},{"Triggers": ["1","4"],"Actions": ["2","3","4","5","6","7","8","10","11"]},{"Triggers": ["1","5"],"Actions": ["1","2","3","4","5","6","7","8","10","11"]},{"Triggers": ["1","6"],"Actions": ["2","3","4","5","6","7","8","10","11"]},{"Triggers": ["1","7"],"Actions": ["0","2","3","4","5","6","7","8","10","11"]},{"Triggers": ["1","7"],"Actions": ["1","2","3","4","5","6","7","8","10","11"]},{"Triggers": ["1","8"],"Actions": ["2","3","4","5","6","7","8","10","11"]},{"Triggers": ["1","9"],"Actions": ["3","4","5","6","7","8","10","11"]},{"Triggers": ["1","10"],"Actions": ["2","3","4","5","6","7","8","10","11"]},{"Triggers": ["1","11"],"Actions": ["3","4","5","6","7","8","10","11"]},{"Triggers": ["1","12"],"Actions": ["3","4","5","6","7","8"]},{"Triggers": ["3","4"],"Actions": ["2","3","4","5","6","7","8","10","11"]},{"Triggers": ["3","5"],"Actions": ["1","2","3","4","5","6","7","8","10","11"]},{"Triggers": ["3","6"],"Actions": ["2","3","4","5","6","7","8","10","11"]},{"Triggers": ["3","7"],"Actions": ["0","2","3","4","5","6","7","8","10","11"]},{"Triggers": ["3","7"],"Actions": ["1","2","3","4","5","6","7","8","10","11"]},{"Triggers": ["3","8"],"Actions": ["2","3","4","5","6","7","8","10","11"]},{"Triggers": ["3","9"],"Actions": ["3","4","5","6","7","8","10","11"]},{"Triggers": ["3","10"],"Actions": ["2","3","4","5","6","7","8","10","11"]},{"Triggers": ["3","11"],"Actions": ["3","4","5","6","7","8","10","11"]},{"Triggers": ["3","12"],"Actions": ["3","4","5","6","7","8"]},{"Triggers": ["1","6"],"Actions": ["12"]},{"Triggers": ["1","9"],"Actions": ["12"]},{"Triggers": ["3","6"],"Actions": ["12"]},{"Triggers": ["3","9"],"Actions": ["12"]}]}', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'acb4d786-b823-4235-ad98-87bc716ebe8c', N'HeartBeat', N'TimerEngineHeartBeat', N'LongIntervalMultiplier', N'The interval multiplier. used for the long heart beat period when no active', N'3', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'bf868e4f-2566-43f0-b64e-884ad648584d', N'AlertMailTemplate', N'default', N'LocationLink', N'The url to location on google maps', N'https://www.google.com/maps/search/?api=1&query={0},{1}', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'db83bee6-ca08-4701-bfd6-8a45472a8d4d', N'EUP', N'Main', N'PanelCacheMode', N'PanelCache type for data access', N'HcPanelCacheDataAccess', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'e8eacca1-5faa-4b8a-969b-8d96845e427e', N'ArmingExitDelay', N'0', N'Enabled', N'Default value of panel exit delay enabled', N'true', N'System.Boolean', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'4a17bbbc-2a13-46cb-81e1-9728e909c45d', N'AlertMailTemplate', N'Default', N'EnableSsl', N'Enable Ssl', N'true', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'5a39b5b9-1d4f-4453-bac6-977eeae590f3', N'default', N'default', N'ThermostatSupportedModes', N'The default modes supported by a thermostat (eg: 7 = Off + Heat + Cool + Auto)', N'7', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'8e56b59f-9789-4614-84fa-978457a6b6af', N'HeartBeat', N'default', N'Interval', N'The interval for the heart beat in seconds', N'15', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'1bbe2864-937f-471b-bf51-983c6c71800e', N'PasswordPolicy', N'DefaultPolicy', N'MaximumFailedLogin', N'Maximum number of failed logins attempts to consider valid', N'4', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'243770e7-e309-4a02-bce6-98bf0a11c869', N'MedicalGuardianAuthorizationParameters', N'default', N'ClientId', N'The client Id in MG server', N'1.test.mg.essence-grp.com', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'7f871d6d-2a32-487c-a3b0-99e8e040ec7f', N'TimeZone', N'default', N'Test', N'Dummy Timezone for tests', N'', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'747f7519-c940-449c-a6ae-9b9efadd34ff', N'default', N'default', N'NumOfCyclesForGetVideo', N'', N'10', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'c7eb10b0-c3e2-4ad8-9395-9d46fdd1c567', N'ArmingExitDelay', N'0', N'AvailableTimes', N'Available delay times', N'15,30,45,60,75,90,105,120', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'71da5da1-0906-4cd7-9682-a23c1b620edb', N'TimeZone', N'default', N'Version', N'TimeZone Db Version', N'1', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'd7808964-d738-4f35-a0cd-a62c075263d1', N'default', N'default', N'TimeToSleepForGetVideoStream', N'', N'1000', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'1f59e3fc-fa32-48cc-943d-acfd2a15fd0d', N'PasswordPolicyValidation', N'default', N'PasswordExpirationDaysMaximum', N'Maxnimum number of days for password expiration', N'180', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'1611b329-c27c-411a-8937-ad872d1d827e', N'HeartBeat', N'default', N'LongIntervalMultiplier', N'The interval multiplier. used for the long heart beat period when no active', N'3', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'2b14abc3-bc28-4729-96ca-afd79e2beb0f', N'ArmingExitDelay', N'1', N'AvailableTimes', N'Available delay times', N'15,30,45,60,75,90,105,120', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'0ed23e10-3a0c-435f-92ef-b1256e4f6c86', N'PasswordPolicy', N'DefaultPolicy', N'PasswordExpirationDays', N'The time period after which the user must to change password, In days', N'-1', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'daedba81-5946-4a86-a5ef-b2e511ff9e08', N'AlertMailTemplate', N'Default', N'MailSenderAddress', N'Mail Sender Address', N'securityservices2@essencesecurity.com', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'68b85475-7833-44b2-80fc-b8f09d094be1', N'PasswordPolicy', N'DefaultPolicy', N'CharGroupsActive', N'Is char groups use active', N'False', N'System.Boolean', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'5ac83883-6012-4a35-8aa4-bb5e9c4ab780', N'IPCamera', N'default', N'PathValues', N'Path (ie HD,LD) values for IPCamera', N'{"HdChannel":"channel1","LdChannel":"channel2"}', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'59e3e585-ad9f-4b71-ae6c-bbac50febc58', N'PasswordPolicyValidation', N'default', N'PasswordMinimumLength', N'Minimum possible length of a password', N'6', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'baf2c906-17c1-44fc-b8fd-c04bb63cee46', N'ArmingExitDelay', N'1', N'Enabled', N'Default value of panel exit delay enabled', N'true', N'System.Boolean', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'bfdc6b16-e432-4fc7-b0fe-c29d080d72dc', N'TimeZone', N'2', N'PanelTimeZoneChangeInterval', N'defines for the panel the interval of time between each TZC event request (days)', N'10', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'6d5bc5f7-d8c6-4f76-8b67-c6d38ac46a34', N'EventUploader', N'default', N'DllPath', N'', N'E:\TestReflactionDll', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'450964e4-be10-4507-94cb-c8e50244ab1c', N'AlertMailTemplate', N'Default', N'Passwd', N'Password', N'AtORpLXILKEAQn72wKCPZfmJ0OlBWV8Q+vp4OoA7x/IO', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'de09165a-267c-42b3-8884-c93f21002bab', N'PasswordPolicy', N'DefaultPolicy', N'PasswordHistoryActive', N'Is password history active', N'True', N'System.Boolean', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'e5a43f27-e83f-4603-9e71-ccce9cb6a593', N'PanelVersionStepCountInitializer', N'default', N'PanelVersion', N'panel version from which all step count data should be deleted by function major*10000 + minor*100 + micro*1', N'20700', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'9a4568b6-e22d-4975-925b-d20d608afd17', N'AdlVendorSettingsDefaults', N'default', N'SmsEnabled', N'Indicator whether is SMS allowed', N'True', N'System.Boolean', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'f05f7ed5-f843-41d9-a594-db76547431c6', N'PasswordPolicy', N'DefaultPolicy', N'PasswordMaximumLength', N'Maximum length of a password', N'20', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'b8883ae1-c20a-4ad6-a0ef-e19869c1da06', N'AdlRulePolicyFamily', N'default', N'Inactivity_Maximum', N'Maximum number of rules of type Inactivity allowed', N'10', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'55cb77d0-e46b-495f-bf57-e62ef780f5ef', N'AdlFamilyInstallDefaults', N'default', N'MaxNumberOfMasterUsersInPanel', N'The max master users that can be defined for a ADL family account', N'2', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'8d351e48-d799-4782-bcda-e7a65e70ab91', N'AdlRulePolicyFamily', N'default', N'OutOfHome_Maximum', N'Maximum number of rules of type OutOfHome allowed', N'1', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'53b62c73-412d-45d2-b8c5-e7b185c3ebf0', N'BL.Reports', N'Default', N'DailyCaregiverReport_DefaultLanguage', N'Default Language for daily report', N'1', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'bc282adf-c2d0-4ced-95da-e852c4f89c4e', N'AlertMailTemplate', N'Default', N'SmtpPort', N'Smtp Port', N'587', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'7797931b-624e-4255-bbd0-e9cf3e750bc9', N'AdlRulePolicyFamily', N'default', N'MaximumNumberOfRules', N'Maximum Number Of Rules Allowed', N'128', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'70ee3f7f-24ed-4aef-a966-ec13ab5ece57', N'IPCamera', N'default', N'UserName', N'Default userName for IPCamera', N'admin', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'ae6afcca-d5ab-4bd7-b9d0-ed31e2b64721', N'BL.Reports', N'Default', N'DailyCaregiverReport_AdminEmailAddress', N'Admin Email Address for daily report', N'admin@care.com', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'63017a92-0560-493c-b163-efc47655a8ae', N'TimeZone', N'default', N'PanelTimeZoneChangeInterval', N'defines for the panel the interval of time between each TZC event request (days)', N'10', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'5110a898-4369-44f7-9c82-f2a0945295e7', N'default', N'default', N'PanelUserNotificationSettingsDefault', N'', N'4:1,3;5:1,3;6:3', N'System.String', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'f80cbf47-1794-489d-9a9b-f6429cf7eb10', N'default', N'default', N'TimeToSleepForGetExistingVideoStream', N'', N'1000', N'System.Int', 0)

	INSERT [dbo].[SystemParameters] ([Id], [InstanceName], [InstanceIdentifier], [ParameterKey], [ParameterDesc], [Value], [DataType], [AllowDelete]) VALUES (N'abdce0d7-279a-4df8-859b-fab8f24ab302', N'TimeZone', N'default', N'LatestTzDbFile', N'path for the time zone database file', N'C:\Program Files\Essence Connect Server\TimeZoneDB\output_2016h.nzd', N'System.String', 0)
END


