DELETE FROM PQApplications
GO
DELETE FROM PQApplicationCategory
GO

INSERT INTO PQApplicationsCategory (Name,SortOrder) VALUES ('Configure',1)
GO
INSERT INTO PQApplicationCategory (Name, SortOrder) VALUES ('Visualize',3)
GO
INSERT INTO PQApplicationCategory (Name, SortOrder) VALUES ('Interval Data',4)
GO
INSERT INTO PQApplicationsCategory (Name, SortOrder) VALUES ('Collection',2)
GO

INSERT INTO PQApplications (Name,URL,Image,CategoryID,SortOrder) VALUES ('System Center', 'http://localhost:8987','./Images/Tiles/SystemCenter.png',(SELECT ID FROM PQApplicationCategory WHERE Name LIKE 'Configure'),0)
GO
INSERT INTO PQApplications (Name,URL,Image,CategoryID,SortOrder) VALUES ('PQ Dashboard', 'http://localhost/PQDashboard','./Images/Tiles/PQDashboard.png',(SELECT ID FROM PQApplicationCategory WHERE Name LIKE 'Visualize'),1)
GO
INSERT INTO PQApplications (Name,URL,Image,CategoryID,SortOrder) VALUES ('PQ Browser', 'http://localhost/PQBrowser','./Images/Tiles/PQBrowser.png',(SELECT ID FROM PQApplicationCategory WHERE Name LIKE 'Visualize'),2)
GO
INSERT INTO PQApplications (Name,URL,Image,CategoryID,SortOrder) VALUES ('SPCTools', 'SPCTools/index.cshtml','./Images/Tiles/SPCTools.png',(SELECT ID FROM PQApplicationCategory WHERE Name LIKE 'Interval Data'),0)
GO
INSERT INTO PQApplications (Name,URL,Image,CategoryID,SortOrder) VALUES ('openMIC', 'http://localhost:8089','./Images/Tiles/openMIC.png',(SELECT ID FROM PQApplicationCategory WHERE Name LIKE 'Collection'),0)
GO
INSERT INTO PQApplications (Name,URL,Image,CategoryID,SortOrder) VALUES ('Notification Pages', 'http://localhost/NotificationPages','./Images/Tiles/NotificationPages.png',(SELECT ID FROM PQApplicationCategory WHERE Name LIKE 'Configure'),1)
GO