Notes

----------------------------------------------------------------------------------------------------------------
GO
print 'Updates On 24 Dec 2016'
GO
----------------------------------------------------------------------------------------------------------------
GO
print 'ARCOS Update 24 Dec 2016 - 4.7.9.1'
GO
-------------------------------------------------------------------------------------------------------
GO

IF OBJECT_ID('sso_arcos_webapi_request_registration') IS NOT NULL
BEGIN
DROP TABLE sso_arcos_webapi_request_registration
END

GO

CREATE TABLE sso_arcos_webapi_request_registration(
wrr_id bigint IDENTITY(1,1) PRIMARY KEY,
wrr_ipaddress varchar(100) NULL,
wrr_mac varchar(100) NULL,
wrr_sls_id bigint NOT NULL,
wrr_service_type_id bigint NOT NULL,
wrr_desc varchar(500) NULL,
wrr_isactive bit NULL,
wrr_freefield1 varchar(1000) NULL,
wrr_freefield2 varchar(1000) NULL,
wrr_created_by varchar(1000) NULL,
wrr_created_on datetime NULL,
wrr_modified_by varchar(1000) NULL,
wrr_modified_on datetime NULL,
) ON [PRIMARY]

GO

----------------------------------------------------------------------------------------------------------------

GO

IF OBJECT_ID('sso_arcos_webapi_request_registration_details') IS NOT NULL
BEGIN
DROP TABLE sso_arcos_webapi_request_registration_details
END

GO

CREATE TABLE sso_arcos_webapi_request_registration_details(
wrd_id bigint IDENTITY(1,1) PRIMARY KEY,
wrd_wrr_id varchar(100) NOT NULL,
wrd_ss_service_id bigint NOT NULL,
wrd_freefield1 varchar(1000) NULL,
wrd_freefield2 varchar(1000) NULL,
wrd_freefield3 varchar(1000) NULL,
wrd_freefield4 varchar(1000) NULL,
wrd_created_by varchar(1000) NULL,
wrd_created_on datetime NULL,
wrd_modified_by varchar(1000) NULL,
wrd_modified_on datetime NULL,
) ON [PRIMARY]
GO

----------------------------------------------------------------------------------------------------------------

GO

delete from sso_arcos_report_master where arm_id in (113)
insert into sso_arcos_report_master values(113 ,8 ,'Scheduled Password Change Services' ,1 ,'~/resources/icons/ARCOSReport/report_child.gif','Scheduled Password Change Services',1,1,1,0,1,0,0,1)

GO
----------------------------------------------------------------------------------------------------------------
GO

DELETE FROM [sso_user_privileges_master] WHERE [upm_id] in (188)
INSERT [sso_user_privileges_master] ([upm_id], [upm_name], [upm_description], [upm_groupname], [upm_isservicegroupadmin], [upm_isserverside]) VALUES (188, N'Scheduled Password Change Services', N'Scheduled Password Change Services', N'REPORT-Service Reports', 0, 0)

GO
----------------------------------------------------------------------------------------------------------------

GO

delete from sso_arcos_report_master where arm_id in (112)
insert into sso_arcos_report_master values(112 ,8 ,'Active Sessions Report' ,1 ,'~/resources/icons/ARCOSReport/report_child.gif','Active Sessions Report',0,0,0,0,0,0,0,0)

GO
----------------------------------------------------------------------------------------------------------------

GO

DELETE FROM [sso_user_privileges_master] WHERE [upm_id] in (187)
INSERT [sso_user_privileges_master] ([upm_id], [upm_name], [upm_description], [upm_groupname], [upm_isservicegroupadmin], [upm_isserverside]) VALUES (187, N'Active Sessions Report', N'Active Sessions Report', N'REPORT-Service Reports', 0, 0)

GO