--initialize data from here--
insert into Countries (CountryName, CountryShortCode) values ('Argentina','AR');
insert into Countries (CountryName, CountryShortCode) values ('Bahrain','BR');
insert into Countries (CountryName, CountryShortCode) values ('Chile','CL');
insert into Countries (CountryName, CountryShortCode) values ('Colombia','CO');
insert into Countries (CountryName, CountryShortCode) values ('Cyprus','CY');
insert into Countries (CountryName, CountryShortCode) values ('Dominican Republic','DO');
insert into Countries (CountryName, CountryShortCode) values ('Ecuador','EC');
insert into Countries (CountryName, CountryShortCode) values ('Finland','FI');
insert into Countries (CountryName, CountryShortCode) values ('France','FR');
insert into Countries (CountryName, CountryShortCode) values ('India','IN');
insert into Countries (CountryName, CountryShortCode) values ('Ireland','IE');
insert into Countries (CountryName, CountryShortCode) values ('Italy','IT');
insert into Countries (CountryName, CountryShortCode) values ('Lebanon','LB');
insert into Countries (CountryName, CountryShortCode) values ('Malaysia','MY');
insert into Countries (CountryName, CountryShortCode) values ('Mexico','MX');
insert into Countries (CountryName, CountryShortCode) values ('Mongolia','MN');
insert into Countries (CountryName, CountryShortCode) values ('Netherlands','NL');
insert into Countries (CountryName, CountryShortCode) values ('Oman','OM');
insert into Countries (CountryName, CountryShortCode) values ('Saudi Arabia','SA');
insert into Countries (CountryName, CountryShortCode) values ('Singapore','SG');
insert into Countries (CountryName, CountryShortCode) values ('Spain','ES');
insert into Countries (CountryName, CountryShortCode) values ('UK','GB');
insert into Countries (CountryName, CountryShortCode) values ('United Arab Emirates','AE');
insert into Countries (CountryName, CountryShortCode) values ('Uruguay','UY');
insert into Countries (CountryName, CountryShortCode) values ('Nigeria','NG');
insert into Countries (CountryName, CountryShortCode) values ('Thailand','TH');
insert into Countries (CountryName, CountryShortCode) values ('New Zealand','NZ');
insert into Countries (CountryName, CountryShortCode) values ('South Africa','ZA');
insert into Countries (CountryName, CountryShortCode) values ('USA','US');
insert into Countries (CountryName, CountryShortCode) values ('Vietnam','VN');

INSERT INTO [dbo].[Companies]
([CompanyCode],[CompanyName],[NurseryCam],[RetailCam],[MagicMirror],[FootfallCam],[ConnectionString],[ServerName],[DatabaseName],[DatabaseUsername],[DatabasePassword],[UpdatedDateTime],[UserId])
VALUES
('WatsonTw','Watson Taiwan',0,0,0,1,NULL,NULL,NULL,NULL,NULL,0,NULL);

INSERT INTO [dbo].[Users]
([UserName],[Password],[Name],[LastLoginTimestamp],[CompanyCode],[UserRole],[Email])
VALUES
('superuser','p@s5w0rd!z34','admin',0,'footfallcam','superadmin','support@footfallcam.com');

INSERT INTO [dbo].[Users]
([UserName],[Password],[Name],[LastLoginTimestamp],[CompanyCode],[UserRole],[Email])
VALUES('admin','admin','admin',0,'[companyCode]','reseller','[resellerEmail]');

INSERT INTO [dbo].[Users]
([UserName],[Password],[Name],[LastLoginTimestamp],[CompanyCode],[UserRole],[Email])
VALUES
('WatsonTw','password','Watson Taiwan',0,'WatsonTw','admin','AndyChang@watsons.com.tw');

INSERT INTO [dbo].[ServerIdentifications]
([ServerName],[GUID],[ResellerCompanyCode],[CompanyCode])
VALUES
('Watson Taiwan', NEWID(), 'WatsonTw', 'WatsonTw');


USE [RetailCamControlPanel]
GO
SET IDENTITY_INSERT [dbo].[FFBranches] ON

GO
INSERT [dbo].[FFBranches] ([ID], [BranchCode], [BranchName], [Region], [RegionAbbr], [City], [CityAbbr], [Country], [CountryAbbr], [Timezone], [StoreType], [CompanyId], [UpdatedDateTime], [UserId], [Latitude], [Longitude], [FloorSize], [FTPServer], [FTPDirectory], [FTPUsername], [FTPPassword], [Comment], [RegionId], [Offset])
VALUES
(1, N'branchCode', N'Branch 1', NULL, NULL, NULL, NULL, N'United Kingdom', N'GB', N'UTC', N'Outlet', 1, CAST(N'2001-01-01 00:00:00.000' AS DateTime), 3, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, N'tmz+0')
GO
SET IDENTITY_INSERT [dbo].[FFBranches] OFF
GO

USE [RetailCamControlPanel]
GO
SET IDENTITY_INSERT [dbo].[FFBranchOperatingHours] ON

GO
INSERT [dbo].[FFBranchOperatingHours] ([ID], [StartTime], [EndTime], [Day], [BranchId], [isDayOff]) VALUES (1, CAST(N'2016-04-12 00:00:00.000' AS DateTime), CAST(N'2016-04-12 00:00:00.000' AS DateTime), 1, 1, 0)
GO
INSERT [dbo].[FFBranchOperatingHours] ([ID], [StartTime], [EndTime], [Day], [BranchId], [isDayOff]) VALUES (2, CAST(N'2016-04-12 00:00:00.000' AS DateTime), CAST(N'2016-04-12 00:00:00.000' AS DateTime), 2, 1, 0)
GO
INSERT [dbo].[FFBranchOperatingHours] ([ID], [StartTime], [EndTime], [Day], [BranchId], [isDayOff]) VALUES (3, CAST(N'2016-04-12 00:00:00.000' AS DateTime), CAST(N'2016-04-12 00:00:00.000' AS DateTime), 3, 1, 0)
GO
INSERT [dbo].[FFBranchOperatingHours] ([ID], [StartTime], [EndTime], [Day], [BranchId], [isDayOff]) VALUES (4, CAST(N'2016-04-12 00:00:00.000' AS DateTime), CAST(N'2016-04-12 00:00:00.000' AS DateTime), 4, 1, 0)
GO
INSERT [dbo].[FFBranchOperatingHours] ([ID], [StartTime], [EndTime], [Day], [BranchId], [isDayOff]) VALUES (5, CAST(N'2016-04-12 00:00:00.000' AS DateTime), CAST(N'2016-04-12 00:00:00.000' AS DateTime), 5, 1, 0)
GO
INSERT [dbo].[FFBranchOperatingHours] ([ID], [StartTime], [EndTime], [Day], [BranchId], [isDayOff]) VALUES (6, CAST(N'2016-04-12 00:00:00.000' AS DateTime), CAST(N'2016-04-12 00:00:00.000' AS DateTime), 6, 1, 0)
GO
INSERT [dbo].[FFBranchOperatingHours] ([ID], [StartTime], [EndTime], [Day], [BranchId], [isDayOff]) VALUES (7, CAST(N'2016-04-12 00:00:00.000' AS DateTime), CAST(N'2016-04-12 00:00:00.000' AS DateTime), 0, 1, 0)
GO
SET IDENTITY_INSERT [dbo].[FFBranchOperatingHours] OFF
GO

insert into CompanySettings
(CompanyId, FTPServer, FTPDirectory, FTPUsername, FTPPassword,
ExportVisitor, ExportOutsideTraffic, ExportTurnInRate, ExportReturningCustomer, ExportCrossShopping, DwellTimeCategoriesMin, DwellTimeCategoriesMax, ExportDwellTime, SectionSalesConversion, SectionStaffPlanning, SectionZoneAnalytic,
FirstDayOfWeek, DateFormat, FinancialWeekDate, ExportVisitorOut,
WeeklyorDaily, ImportFTPServer, ImportFTPDirectory, ImportFTPUsername, ImportFTPPassword, ImportWeeklyorDaily, autoscheduler,
SMTPServer, SMTPPort, SMTPRequiredAuthentication, SMTPUsername, SMTPPassword, SMTPFrom, SMTPUse, SMTPUseSSL)
VALUES
(1, NULL, NULL, NULL, NULL,
0, 0, 0, 0, 0, 15, 30, 0, 0, 0, 0,
'Monday', 'dateFirst', '29/12/2014', 0,
NULL, NULL, NULL, NULL, NULL, NULL, 0,
NULL, 0, 0, NULL, NULL, NULL, 0, 0)