MD VPN Availability Summary 

INSERT INTO msr_service_availability VALUES ('VPN','AMRES',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','BELnet',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','BREN',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','CARnet',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','CESnet',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','DFN',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','FUnet',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','GARR',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','GRnet',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','HEAnet',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','HUNGARnet',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','NORDUnet',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','PIONIER',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','RedIRIS',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','RENATER',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','SUnet',2017,7,'00:00:00',1,'00:00:00',1);

** Pay attention to the year and month values in the SQL statement

MD VPN Availability Detailed

VPN Proxy Availability Summary

INSERT INTO msr_vpn_proxy (year,month,proxy_name,nren_name,internal_lu_access,internal_lu_access_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,proxy_status,proxy_status_maint)
VALUES (2017,7,'Prague','CESnet',100,0,100,0,100,0,100,0);

INSERT INTO msr_vpn_proxy (year,month,proxy_name,nren_name,internal_lu_access,internal_lu_access_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,proxy_status,proxy_status_maint)
VALUES (2017,7,'Geneva','SWITCH',100,0,100,0,100,0,100,0);

INSERT INTO msr_vpn_proxy (year,month,proxy_name,nren_name,internal_lu_access,internal_lu_access_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,proxy_status,proxy_status_maint)
VALUES (2017,7,'Marseille','RedIRIS',100,0,100,0,100,0,100,0);

INSERT INTO msr_vpn_proxy (year,month,proxy_name,nren_name,internal_lu_access,internal_lu_access_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,proxy_status,proxy_status_maint)
VALUES (2017,7,'Amsterdam','SURFnet',100,0,100,0,100,0,100,0);

INSERT INTO msr_vpn_proxy (year,month,proxy_name,nren_name,internal_lu_access,internal_lu_access_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,proxy_status,proxy_status_maint)
VALUES (2017,7,'Vienna','ARNES',100,0,100,0,100,0,100,0);

INSERT INTO msr_vpn_proxy (year,month,proxy_name,nren_name,internal_lu_access,internal_lu_access_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,proxy_status,proxy_status_maint)
VALUES (2017,7,'Frankfurt','CYNET',100,0,100,0,100,0,100,0);

INSERT INTO msr_vpn_proxy (year,month,proxy_name,nren_name,internal_lu_access,internal_lu_access_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,proxy_status,proxy_status_maint)
VALUES (2017,7,'London','CYNET',100,0,100,0,100,0,100,0);

** Pay attention to the year and month values in the SQL statement

VPNRR Availability Summary

Please run the following SQL statment to initialise the data:

insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','AMRES',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','AMRES',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','BREN',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','BREN',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','BELnet',100,0,100,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','BELnet',100,0,100,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','CARnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','CARnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','DFN',100,0,100,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','DFN',100,0,100,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','FCCN',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','FCCN',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','FUnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','FUnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','GRnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','GRnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','HEAnet',100,0,100,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','HEAnet',100,0,100,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','HUNGARnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','HUNGARnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','NORDUnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','NORDUnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','PIONIER',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','PIONIER',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','RENATER',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','RENATER',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','SUnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','SUnet',100,0,0,0,100,100);

** Pay attention to the year and month values in the SQL statement