USE [RetailCamControlPanel]
GO
/****** Object:  StoredProcedure [dbo].[DailyAggregation]    Script Date: 02/09/2016 9:56:32 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================                        
-- Author:  <Author,,Name>                        
-- Create date: <Create Date,,>                        
-- Description: <Description,,>                        
-- =============================================                        
CREATE PROCEDURE [dbo].[DailyAggregation]                        
 -- Add the parameters for the stored procedure here                        
 @CompanyCode VARCHAR(MAX) = NULL,                        
 @StartDate DateTime = NULL,                        
 @EndDate DateTime = NULL                        
AS                        
BEGIN                        
 SET NOCOUNT ON;                        
 DECLARE @Date BIGINT, @CameraId BIGINT, @OutsideTraffic INT,                        
  @ValueDateTime DateTime, @MinDwell INT, @MaxDwell INT,                        
  @Dwell1 INT, @Dwell2 INT, @Dwell3 INT, @NewCust INT, @RetCust INT, @AvgDwell float,            
          @CrossShopper1 int,          
          @CrossShopper2 int,          
          @CrossShopper3 int,          
          @TopCrossShop1 bigint,          
          @TopCrossShop2 bigint,          
          @TopCrossShop3 bigint,                      
  @TempCameraId BIGINT , @starthour INT,@endhour INT,@hourcount INT                       
                         
select @starthour = DATEPART(HOUR,DATEADD(HOUR,-4,GETUTCDATE())),@endhour = DATEPART(HOUR,DATEADD(HOUR,-5,GETUTCDATE()))                    
select @starthour=CASE WHEN @starthour<=12 THEN 0-@starthour ELSE 24-@starthour END,@endhour = CASE WHEN @endhour<=12 THEN 0-@endhour ELSE 24-@endhour END                    
                
 CREATE TABLE #TempCamera                        
 (                        
  ID BIGINT,                        
  CameraName VARCHAR(MAX),                        
  CompanyCode VARCHAR(MAX),                        
  CompanyId BIGINT,                        
  BranchId BIGINT,                        
  MaxDwell INT,                        
  MinDwell INT,                        
  Timezone VARCHAR(MAX),                    
  DateValue Date                    
 );                        
                         
 CREATE TABLE #TempResult                        
 (                        
  [ValueDateTime] DateTime,                        
  [Date] [bigint],                        
  [CameraId] [bigint],                        
  [CameraName] [nvarchar](max),                        
  [ValueIn] [int],                        
  [ValueOut] [int],                        
  [OutsideTraffic] [int],                        
  [TurnInRate] [float],                        
  [FifteenMinWifiCount] [int],                        
  [ThirteenMinWifiCount] [int],                        
  [OverWifiCount] [int],                        
  [NewCustomer] [int],                        
  [WeeklyCustomer] [int],                        
  [MonthlyCustomer] [int],                        
  [BranchId] [bigint],                        
  [CompanyId] [bigint],                        
  [AverageDwellTime] [float],                        
  Status INT                        
 );                        
                           
 IF (@StartDate IS NULL)                        
 BEGIN                        
  SET @StartDate = CAST(DATEADD(DAY,-1,GETUTCDATE()) AS DATE);                        
 END                        
                         
 IF (@EndDate IS NULL)                        
 BEGIN                        
  SET @EndDate = CAST( GETUTCDATE() AS DATE);                        
 END                        
 ELSE                        
 BEGIN                        
  SET @EndDate = CAST(DATEADD(DAY,1,@EndDate) AS DATE);                        
 END                        
                         
 IF (@CompanyCode IS NULL)                        
 BEGIN                        
  INSERT INTO #TempCamera(ID,CameraName,CompanyCode,CompanyId,BranchId,MaxDwell,MinDwell,Timezone,DateValue)                        
  SELECT FFCameras.ID,CameraName,FFCameras.CompanyCode,Companies.ID AS CompanyId,BranchId,COALESCE(DwellTimeCategoriesMax,30) AS MaxDwell,COALESCE(DwellTimeCategoriesMin,15) AS MinDwell                        
,COALESCE(CTZ.LatestTimeZone, 0) AS LatestTimeZone, CASE WHEN CTZ.LatestTimeZone <>0 THEN CAST(DATEADD(HOUR,LatestTimeZone,GETUTCDATE()) AS DATE) ELSE @EndDate END                    
  FROM FFCameras                        
  JOIN Companies ON FFCameras.CompanyCode = Companies.CompanyCode                        
  LEFT OUTER JOIN CompanySettings ON Companies.ID = CompanySettings.CompanyId                        
  LEFT JOIN                         
  ----get latest timezone of company (short version) Jack                 
  (SELECT Companies.CompanyCode, Companies.ID AS CompanyId, LatestTimeZone FROM Companies                        
                        
  ----------------                        
  --use line below  original timezone value haven't move to new column (Offset) in ffbranch table                        
  --JOIN (SELECT CONVERT(FLOAT, REPLACE(REPLACE(REPLACE(MAX(FFBranches.Timezone), '0', '12'), 'tmz+12', 'tmz+0'), 'tmz', '')) AS LatestTimeZone, FFCameras.CompanyCode FROM FFCameras                         
  ----------------                        
                        
  ----------------                  
  --use line below after original timezone value move to new column (Offset) in ffbranch table                        
  JOIN (SELECT CONVERT(FLOAT, REPLACE(REPLACE(REPLACE(MAX(FFBranches.Offset), '0', '12'), 'tmz+12', 'tmz+0'), 'tmz', '')) AS LatestTimeZone, FFCameras.CompanyCode FROM FFCameras                         
  ----------------                        
                        
  JOIN FFBranches ON FFCameras.BranchId = FFBranches.ID                        
  AND FFCameras.CompanyCode != 'New' AND FFCameras.CompanyCode IS NOT NULL AND FFCameras.BranchId != 0 GROUP BY FFCameras.CompanyCode                        
  ) CompanyTimezone ON Companies.Companycode = CompanyTimezone.CompanyCode) CTZ                        
  ON CTZ.CompanyCode = FFCameras.CompanyCode                        
  --order by companycode                        
  --original code                      
  --WHERE LatestTimeZone >= (CONVERT(INT, SUBSTRING(CAST(SYSDATETIMEOFFSET() AS NVARCHAR(50)), 30, 2)) - CONVERT(INT, SUBSTRING(CAST(SYSDATETIME() AS NVARCHAR(50)), 12, 2))) + 1                         
  --AND LatestTimeZone < ((CONVERT(INT, SUBSTRING(CAST(SYSDATETIMEOFFSET() AS NVARCHAR(50)), 30, 2)) - CONVERT(INT, SUBSTRING(CAST(SYSDATETIME() AS NVARCHAR(50)), 12, 2))) + 2) + 1                        
                      
  WHERE LatestTimeZone >= @starthour                     
  AND LatestTimeZone < @endhour                    
  ----the end of get latest timezone of company (short version)                        
                        
  --line below to check the timezone to be aggregated, for debug purpose, please leave it here                        
  --SELECT (CONVERT(INT, SUBSTRING(CAST(SYSDATETIMEOFFSET() AS NVARCHAR(50)), 30, 2)) - CONVERT(INT, SUBSTRING(CAST(SYSDATETIME() AS NVARCHAR(50)), 12, 2))) + 1                      
  --SELECT ((CONVERT(INT, SUBSTRING(CAST(SYSDATETIMEOFFSET() AS NVARCHAR(50)), 30, 2)) - CONVERT(INT, SUBSTRING(CAST(SYSDATETIME() AS NVARCHAR(50)), 12, 2))) + 2) + 1                        
 END                        
 ELSE                        
 BEGIN                        
  INSERT INTO #TempCamera(ID,CameraName,CompanyCode,CompanyId,BranchId,MaxDwell,MinDwell,Timezone,DateValue)                        
  SELECT FFCameras.ID,CameraName,FFCameras.CompanyCode,Companies.ID,BranchId,COALESCE(DwellTimeCategoriesMax,30) AS MaxDwell,                        
  COALESCE(DwellTimeCategoriesMin,15) AS MinDwell,0, @EndDate                    
  FROM FFCameras                        
  JOIN Companies ON FFCameras.CompanyCode = Companies.CompanyCode                        
  LEFT OUTER JOIN CompanySettings ON Companies.ID = CompanySettings.CompanyId                        
  WHERE FFCameras.CompanyCode = @CompanyCode                        
 END                        
                         
 SELECT * FROM #TempCamera                        
                     
 INSERT INTO #TempResult(ValueDateTime,Date,CameraId,CameraName,CompanyId,BranchId,ValueIn,ValueOut,OutsideTraffic,TurnInRate,[FifteenMinWifiCount],                        
  [ThirteenMinWifiCount],                        
  [OverWifiCount],                        
  [NewCustomer],                        
  [WeeklyCustomer],                        
  [MonthlyCustomer],                        
  [AverageDwellTime],                        
  Status)                        
 SELECT COALESCE(Wifi.ValueDateTime,Counting.ValueDateTime) AS ValueDateTime,DATEDIFF(SECOND,'1970-01-01',COALESCE(Wifi.ValueDateTime,Counting.ValueDateTime)) AS Date,                       
 COALESCE(Counting.CameraId,Wifi.CameraId) AS CameraId,CameraName,CompanyId,BranchId,COALESCE(ValueIn,0) AS ValueIn,                        
 COALESCE(ValueOut,0) AS ValueOut,COALESCE(OutsideTraffic,0) AS OutsideTraffic,                        
 0,0,0,0,0,0,0,0,1                        
 FROM                        
 (SELECT CameraId,CAST(ValueDateTime AS DATE) AS ValueDateTime,SUM(ValueIn) AS ValueIn,SUM(ValueOut) AS ValueOut                         
 FROM FFCameraHourlyValues WHERE CameraId IN                         
 (SELECT ID FROM #TempCamera) AND ValueDateTime >= @StartDate AND ValueDateTime< (SELECT MAX(DateValue) FROM #TempCamera)                    
 GROUP BY CameraId,CAST(ValueDateTime AS DATE)) AS Counting                        
  LEFT OUTER JOIN                        
 (SELECT COUNT(1) AS OutsideTraffic,CameraId,CAST(ValueDateTime AS DATE) AS ValueDateTime FROM FFShopperHourlyValues WHERE CameraId IN                        
 (SELECT ID FROM #TempCamera) AND ValueDateTime >= @StartDate AND ValueDateTime< (SELECT MAX(DateValue) FROM #TempCamera)                        
 GROUP BY CameraId,CAST(ValueDateTime AS DATE)                        
  ) AS Wifi                        
  ON Counting.CameraID = Wifi.CameraId AND Counting.ValueDateTime = Wifi.ValueDateTime                        
  JOIN #TempCamera ON Wifi.CameraId = #TempCamera.ID OR Counting.CameraId = #TempCamera.ID                        
  ORDER BY CameraId,Date DESC                        
                
                 
                                        
  MERGE FFReportSummaryDailies a                        
  USING #TempResult b                        
  ON (a.cameraid = b.cameraid AND a.date = b.date)                        
  WHEN MATCHED THEN                        
  UPDATE                        
  SET a.ValueIn = b.ValueIn, a.ValueOut = b.ValueOut, a.PatchStatus = NULL                        
  WHEN NOT MATCHED THEN                       
  INSERT(Date,CameraId,CameraName,CompanyId,BranchId,ValueIn,ValueOut,OutsideTraffic,TurnInRate,[FifteenMinWifiCount],                        
  [ThirteenMinWifiCount],                        
  [OverWifiCount],                        
  [NewCustomer],                        
  [WeeklyCustomer],                        
  [MonthlyCustomer],                        
  [AverageDwellTime],PatchStatus)                        
  VALUES(b.Date,b.CameraId,b.CameraName,b.CompanyId,b.BranchId,b.ValueIn,b.ValueOut,0,0,0,0,0,0,0,0,0,NULL);                        
                          
  SELECT * FROM #TempResult ORDER BY BranchId ASC, Date DESC                        
                          
  WHILE EXISTS (SELECT 1 FROM #TempResult WHERE Status = 1)                        
  BEGIN                        
  SELECT @OutsideTraffic=MAX(OutsideTraffic), @ValueDateTime=ValueDateTime,@Date=Date,@CameraId=CameraId FROM #TempResult WHERE Status = 1 GROUP BY Date,ValueDateTime,CameraId ORDER BY CameraId ASC, Date DESC                        
                          
  CREATE TABLE #TempMac(                        
   Mac VARCHAR(MAX),                        
   DwellTime INT                        
  );                        
      
  IF (@OutsideTraffic>0)                        
  BEGIN                        
   INSERT INTO #TempMac(Mac,DwellTime)                        
   SELECT Mac, Max(last_seen - first_seen) AS dwell_time FROM FFShopperHourlyValues
   WHERE ValueDateTime>=@ValueDateTime AND ValueDateTime<DATEADD(DAY,1,@ValueDateTime)                         
   AND CameraId =@CameraId group by Mac
                        
   --IF @TempCameraId is NULL OR @TempCameraId <> @CameraId                        
   --BEGIN                        
    --SET @TempCameraId = @CameraId                        
    IF EXISTS(SELECT [name] FROM tempdb.sys.tables WHERE [name] like '#HistoryMac%') BEGIN                        
        DROP TABLE #HistoryMac;                        
    END;                
    CREATE TABLE #HistoryMac(                        
     Mac VARCHAR(MAX),                        
     LastSeen DateTime,                        
    );                        
    INSERT INTO #HistoryMac(Mac,LastSeen)                        
    SELECT Mac,MAX(ValueDateTime) FROM FFCameraCustomerValues                         
    WHERE ValueDateTime<@ValueDateTime AND ValueDateTime>=DATEADD(MONTH,-6,@ValueDateTime)                         
    AND CameraId =@CameraId                    
    GROUP BY MAC                        
   --END                        
   --ELSE                        
   --BEGIN                        
   -- DELETE FROM #HistoryMac WHERE LastSeen > @ValueDateTime                        
   --END                        
                           
   SELECT @MaxDwell = MAX(MaxDwell*60), @MinDwell = MAX(MinDwell*60) FROM #TempCamera WHERE ID = @CameraId GROUP BY ID                    
                           
   SELECT @Dwell1 = COUNT(1) FROM #TempMac WHERE DwellTime < @MinDwell                        
   SELECT @Dwell2 = COUNT(1) FROM #TempMac WHERE DwellTime >= @MinDwell AND DwellTime < @MaxDwell                        
   SELECT @Dwell3 = COUNT(1) FROM #TempMac WHERE DwellTime >= @MaxDwell AND DwellTime <= 60*60                        
               
   SELECT @AvgDwell = CAST(COALESCE(AVG(DwellTime*1.0),0) AS NUMERIC(6,2)) FROM #TempMac WHERE DwellTime>0 AND DwellTime <= 60*60            
                           
   SELECT @RetCust = COUNT(1) FROM #TempMac JOIN #HistoryMac ON #TempMac.Mac = #HistoryMac.Mac                        
   SELECT @NewCust = COUNT(1) - @RetCust FROM #TempMac                        
                           
   --UPDATE #TempResult SET OutsideTraffic=@OutsideTraffic,FifteenMinWifiCount=@Dwell1, ThirteenMinWifiCount=@Dwell2,                        
   UPDATE #TempResult SET FifteenMinWifiCount=@Dwell1, ThirteenMinWifiCount=@Dwell2,                        
   OverWifiCount=@Dwell3,NewCustomer=@NewCust,MonthlyCustomer=0,WeeklyCustomer=@RetCust,                         
   --AverageDwellTime = CAST((@MinDwell * 60.0 * @Dwell1 + 60.0*(@MaxDwell - @MinDwell)/2.0 * @Dwell2 + @MaxDwell * @Dwell3 * 60.0 )/(@Dwell1+@Dwell2+@Dwell3) AS Numeric(6,2))                        
   AverageDwellTime = @AvgDwell            
   WHERE CameraId=@CameraId AND Date = @Date                        
                       
 ---TRY CROSSSHOP--          
    CREATE TABLE #BranchMac (          
      mac varchar(max),          
      branchId bigint          
    )             
    INSERT INTO #BranchMac          
      SELECT          
        MAC,          
        (SELECT branchId FROM FFCameras WHERE ID=v.CameraId)          
      FROM FFCameraCustomerValues AS v          
      WHERE CameraId IN (SELECT          
        ID          
      FROM FFCameras          
      WHERE CompanyCode = (SELECT          
        CompanyCode          
      FROM FFCameras          
      WHERE ID = @CameraId)          
      AND BranchId <> (SELECT          
        BranchId          
      FROM FFCameras          
      WHERE ID = @CameraId))          
      AND ValueDateTime < @ValueDateTime          
      AND ValueDateTime > DATEADD(MONTH,-1,@ValueDateTime)                   
                
      DELETE FROM #BranchMac          
   WHERE mac NOT IN (SELECT          
  mac          
   FROM #TempMac)          
             
   SELECT          
      @CrossShopper1 = COUNT(1)          
    FROM (SELECT          
      Mac          
    FROM #BranchMac          
    GROUP BY mac          
    HAVING COUNT(1) = 1) AS c          
          
    SELECT          
      @CrossShopper2 = COUNT(1)          
    FROM (SELECT          
      Mac          
    FROM #BranchMac          
    GROUP BY mac          
    HAVING COUNT(1) = 2) AS c          
          
    SELECT      
      @CrossShopper3 = COUNT(1)          
    FROM (SELECT          
      Mac          
    FROM #BranchMac          
    GROUP BY mac          
    HAVING COUNT(1) >= 3) AS c          
          
 select @TopCrossShop1=0,@TopCrossShop2=0,@TopCrossShop3=0          
          
    SELECT          
      @TopCrossShop1 = COALESCE(branchId,0)          
    FROM (SELECT          
      ROW_NUMBER() OVER (ORDER BY COUNT(1) DESC) AS No,          
      branchId          
    FROM #BranchMac          
    GROUP BY branchId) AS temp          
    WHERE temp.No = 1          
          
    SELECT          
      @TopCrossShop2 = COALESCE(branchId,0)          
    FROM (SELECT          
      ROW_NUMBER() OVER (ORDER BY COUNT(1) DESC) AS No,          
      branchId          
    FROM #BranchMac          
    GROUP BY branchId) AS temp          
    WHERE temp.No = 2          
          
    SELECT          
      @TopCrossShop3 = COALESCE(branchId,0)          
    FROM (SELECT          
      ROW_NUMBER() OVER (ORDER BY COUNT(1) DESC) AS No,          
      branchId          
    FROM #BranchMac          
    GROUP BY branchId) AS temp          
    WHERE temp.No = 3          
              
    DROP TABLE #BranchMac          
 ---TRY CROSSSHOP--                       
                            
   UPDATE FFReportSummaryDailies SET                     
   --TurnInRate = CASE WHEN @OutsideTraffic=0 THEN 0.0 WHEN ValueIn>@OutsideTraffic THEN 100.0                         
   --ELSE CAST(ValueIn*100.0 / @OutsideTraffic AS NUMERIC(6,2)) END, OutsideTraffic=@OutsideTraffic,                    
   FifteenMinWifiCount=@Dwell1, ThirteenMinWifiCount=@Dwell2,                        
   OverWifiCount=@Dwell3,NewCustomer=@NewCust,MonthlyCustomer=0,WeeklyCustomer=@RetCust,                         
   --AverageDwellTime = CAST((@MinDwell * 60.0 * @Dwell1 + 60.0*(@MaxDwell - @MinDwell)/2.0 * @Dwell2 + @MaxDwell * @Dwell3 * 60.0 )/(@Dwell1+@Dwell2+@Dwell3) AS Numeric(6,2))                        
   AverageDwellTime = @AvgDwell,TopCrossShop1=@TopCrossShop1,TopCrossShop2=@TopCrossShop2,TopCrossShop3=@TopCrossShop3,CrossShopper1=@CrossShopper1,CrossShopper2=@CrossShopper2,CrossShopper3=@CrossShopper3            
   WHERE Date = @Date AND CameraId = @CameraId                        
  END                        
                           
  DROP TABLE #TempMac                        
                      
  UPDATE #TempResult SET Status = 0 WHERE Date = @Date AND CameraId = @CameraId                    
  --UPDATE #TempResult SET Status = 0, TurnInRate =                         
--CASE WHEN OutsideTraffic=0 THEN 0.0 WHEN ValueIn>OutsideTraffic THEN 100.0                         
  --ELSE CAST(ValueIn*100.0 / OutsideTraffic AS NUMERIC(6,2)) END                         
  --WHERE Date = @Date AND BranchId = @BranchId                        
                   
  SELECT @hourcount=COUNT(1) FROM FFCameraHourlyValues WHERE CameraId = @CameraId AND CAST(ValueDateTime AS DATE) = CAST(@ValueDateTime AS DATE)              
  IF @hourcount < 20                
  BEGIN                
 UPDATE FFReportSummaryDailies SET PatchStatus = 'EXCLUDED' WHERE CameraId=@CameraId AND Date = @Date                
  END                
  ELSE IF @hourcount < 24                
  BEGIN                
 UPDATE FFReportSummaryDailies SET PatchStatus = 'INCOMPLETE' WHERE CameraId=@CameraId AND Date = @Date                
  END                
                          
  SELECT * FROM #TempResult WHERE Date = @Date AND CameraId = @CameraId                        
  END                        
                          
  SELECT * FROM #TempResult                      
                     
END 
GO
/****** Object:  Table [dbo].[__MigrationHistory]    Script Date: 02/09/2016 9:56:33 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[__MigrationHistory](
	[MigrationId] [nvarchar](150) NOT NULL,
	[ContextKey] [nvarchar](300) NOT NULL,
	[Model] [varbinary](max) NOT NULL,
	[ProductVersion] [nvarchar](32) NOT NULL,
 CONSTRAINT [PK_dbo.__MigrationHistory] PRIMARY KEY CLUSTERED 
(
	[MigrationId] ASC,
	[ContextKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ApiActions]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ApiActions](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[FFVideoScheduleId] [bigint] NULL,
	[isRead] [bit] NOT NULL,
	[Timestamp] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.ApiActions] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Companies]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Companies](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[CompanyName] [nvarchar](max) NULL,
	[NurseryCam] [bit] NOT NULL,
	[RetailCam] [bit] NOT NULL,
	[MagicMirror] [bit] NOT NULL,
	[FootfallCam] [bit] NOT NULL,
	[ConnectionString] [nvarchar](max) NULL,
	[ServerName] [nvarchar](max) NULL,
	[DatabaseName] [nvarchar](max) NULL,
	[DatabaseUsername] [nvarchar](max) NULL,
	[DatabasePassword] [nvarchar](max) NULL,
	[UpdatedDateTime] [datetime] NOT NULL,
	[UserId] [bigint] NULL,
	[ShowOutValue] [bit] NOT NULL,
	[ResellerCompanyCode] [nvarchar](max) NULL,
	[ExportCount] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.Companies] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[CompanyCards]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CompanyCards](
	[CompanyId] [bigint] NOT NULL,
	[CardId] [int] NOT NULL,
	[SortOrder] [int] NOT NULL,
	[RoleAccess] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.CompanyCards] PRIMARY KEY CLUSTERED 
(
	[CompanyId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[CompanySettings]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CompanySettings](
	[CompanyId] [bigint] NOT NULL,
	[FTPServer] [nvarchar](max) NULL,
	[FTPDirectory] [nvarchar](max) NULL,
	[FTPUsername] [nvarchar](max) NULL,
	[FTPPassword] [nvarchar](max) NULL,
	[ExportVisitor] [bit] NOT NULL,
	[ExportOutsideTraffic] [bit] NOT NULL,
	[ExportTurnInRate] [bit] NOT NULL,
	[ExportReturningCustomer] [bit] NOT NULL,
	[ExportCrossShopping] [bit] NOT NULL,
	[DwellTimeCategoriesMin] [int] NOT NULL,
	[DwellTimeCategoriesMax] [int] NOT NULL,
	[ExportDwellTime] [bit] NOT NULL,
	[SectionSalesConversion] [bit] NOT NULL,
	[SectionStaffPlanning] [bit] NOT NULL,
	[SectionZoneAnalytic] [bit] NOT NULL,
	[FirstDayOfWeek] [nvarchar](max) NULL,
	[DateFormat] [nvarchar](max) NULL,
	[FinancialWeekDate] [nvarchar](max) NULL,
	[ExportVisitorOut] [bit] NOT NULL,
	[WeeklyorDaily] [nvarchar](max) NULL,
	[ImportFTPServer] [nvarchar](max) NULL,
	[ImportFTPDirectory] [nvarchar](max) NULL,
	[ImportFTPUsername] [nvarchar](max) NULL,
	[ImportFTPPassword] [nvarchar](max) NULL,
	[ImportWeeklyorDaily] [nvarchar](max) NULL,
	[autoscheduler] [bit] NOT NULL,
	[SMTPServer] [nvarchar](max) NULL,
	[SMTPPort] [int] NOT NULL,
	[SMTPRequiredAuthentication] [bit] NOT NULL,
	[SMTPUsername] [nvarchar](max) NULL,
	[SMTPPassword] [nvarchar](max) NULL,
	[SMTPFrom] [nvarchar](max) NULL,
	[SMTPUse] [bit] NOT NULL,
	[SMTPUseSSL] [int] NOT NULL,
 CONSTRAINT [PK_dbo.CompanySettings] PRIMARY KEY CLUSTERED 
(
	[CompanyId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Countries]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Countries](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CountryName] [nvarchar](max) NULL,
	[CountryShortCode] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.Countries] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[CountryPrices]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CountryPrices](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CountryId] [nvarchar](max) NULL,
	[CountryName] [nvarchar](max) NULL,
	[EndUserPrice] [nvarchar](max) NULL,
	[ResellerPrice] [nvarchar](max) NULL,
	[DisplayPrice] [nvarchar](max) NULL,
	[CountryCurrency] [nvarchar](max) NULL,
	[AllowRequestCallBack] [bit] NOT NULL,
	[CallBackCondition] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.CountryPrices] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[DatabaseUsages]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DatabaseUsages](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[TableName] [nvarchar](max) NULL,
	[Reserved] [float] NOT NULL,
	[Used] [float] NOT NULL,
	[Diff] [float] NOT NULL,
	[DateString] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.DatabaseUsages] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFBranchDailyPredictions]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFBranchDailyPredictions](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[PredictionDate] [datetime] NOT NULL,
	[BranchId] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFBranchDailyPredictions] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFBranches]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFBranches](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[BranchCode] [nvarchar](max) NULL,
	[BranchName] [nvarchar](max) NULL,
	[Region] [nvarchar](max) NULL,
	[RegionAbbr] [nvarchar](max) NULL,
	[City] [nvarchar](max) NULL,
	[CityAbbr] [nvarchar](max) NULL,
	[Country] [nvarchar](max) NULL,
	[CountryAbbr] [nvarchar](max) NULL,
	[Timezone] [nvarchar](max) NULL,
	[StoreType] [nvarchar](max) NULL,
	[CompanyId] [bigint] NOT NULL,
	[UpdatedDateTime] [datetime] NOT NULL,
	[UserId] [bigint] NOT NULL,
	[Latitude] [float] NOT NULL,
	[Longitude] [float] NOT NULL,
	[FloorSize] [float] NOT NULL,
	[FTPServer] [nvarchar](max) NULL,
	[FTPDirectory] [nvarchar](max) NULL,
	[FTPUsername] [nvarchar](max) NULL,
	[FTPPassword] [nvarchar](max) NULL,
	[Comment] [nvarchar](max) NULL,
	[RegionId] [bigint] NULL,
	[Offset] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFBranches] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFBranchFloors]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFBranchFloors](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](max) NULL,
	[Abbreviation] [nvarchar](max) NULL,
	[LayoutURL] [nvarchar](max) NULL,
	[Ratio] [float] NOT NULL,
	[Order] [int] NOT NULL,
	[BranchId] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFBranchFloors] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFBranchOperatingHours]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFBranchOperatingHours](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[StartTime] [datetime] NOT NULL,
	[EndTime] [datetime] NOT NULL,
	[Day] [int] NOT NULL,
	[BranchId] [bigint] NOT NULL,
	[isDayOff] [bit] NOT NULL,
 CONSTRAINT [PK_dbo.FFBranchOperatingHours] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFBranchSpecialOperatingHours]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFBranchSpecialOperatingHours](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Date] [datetime] NOT NULL,
	[StartTime] [datetime] NOT NULL,
	[EndTime] [datetime] NOT NULL,
	[isDayOff] [bit] NOT NULL,
	[isRecurrence] [bit] NOT NULL,
	[RecurrenceType] [int] NOT NULL,
	[BranchId] [bigint] NOT NULL,
	[Comment] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFBranchSpecialOperatingHours] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameraCheckLogs]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameraCheckLogs](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[IP] [nvarchar](max) NULL,
	[Serial] [nvarchar](max) NULL,
	[TimeLogged] [datetime] NOT NULL,
	[InternalIP] [nvarchar](max) NULL,
	[vpnIP] [nvarchar](max) NULL,
	[Reason] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFCameraCheckLogs] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameraCountingRecords]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameraCountingRecords](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[StartDateTime] [datetime] NOT NULL,
	[StartDateTimeInt] [bigint] NOT NULL,
	[Day] [int] NOT NULL,
	[CameraId] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFCameraCountingRecords] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameraCountingValues]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameraCountingValues](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Counter] [int] NOT NULL,
	[ValueDateTime] [datetime] NOT NULL,
	[ValueIn] [int] NOT NULL,
	[ValueOut] [int] NOT NULL,
	[ValueTimestamp] [datetime] NOT NULL,
	[Day] [int] NOT NULL,
	[CameraId] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFCameraCountingValues] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameraCustomerValueArchives]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameraCustomerValueArchives](
	[MAC] [nvarchar](128) NOT NULL,
	[CameraId] [bigint] NOT NULL,
	[HashMac] [nvarchar](max) NULL,
	[first_seen] [bigint] NOT NULL,
	[last_seen] [bigint] NOT NULL,
	[count] [int] NOT NULL,
	[monthlycount] [int] NOT NULL,
	[weeklycount] [int] NOT NULL,
	[lastmonthcount] [int] NOT NULL,
	[lastweekcount] [int] NOT NULL,
	[lowest] [int] NOT NULL,
	[highest] [int] NOT NULL,
	[average] [real] NOT NULL,
	[ValueTimestamp] [datetime] NOT NULL,
 CONSTRAINT [PK_dbo.FFCameraCustomerValueArchives] PRIMARY KEY CLUSTERED 
(
	[MAC] ASC,
	[CameraId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameraCustomerValues]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameraCustomerValues](
	[MAC] [nvarchar](128) NOT NULL,
	[ValueTimestamp] [datetime] NOT NULL,
	[ValueDateTime] [datetime] NOT NULL,
	[Day] [int] NOT NULL,
	[CameraId] [bigint] NOT NULL,
	[HashMac] [nvarchar](max) NULL,
	[first_seen] [bigint] NOT NULL,
	[last_seen] [bigint] NOT NULL,
	[count] [int] NOT NULL,
	[dwell_time] [int] NOT NULL,
	[lowest] [int] NOT NULL,
	[highest] [int] NOT NULL,
	[average] [real] NOT NULL,
 CONSTRAINT [PK_dbo.FFCameraCustomerValues] PRIMARY KEY CLUSTERED 
(
	[MAC] ASC,
	[ValueDateTime] ASC,
	[CameraId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameraHourlyValues]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameraHourlyValues](
	[ValueDateTime] [datetime] NOT NULL,
	[OutsideTraffic] [int] NOT NULL,
	[ValueIn] [int] NOT NULL,
	[ValueOut] [int] NOT NULL,
	[ValueTimestamp] [datetime] NOT NULL,
	[Timestamp] [bigint] NOT NULL,
	[Day] [int] NOT NULL,
	[CameraId] [bigint] NOT NULL,
	[PatchStatus] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFCameraHourlyValues] PRIMARY KEY CLUSTERED 
(
	[ValueDateTime] ASC,
	[CameraId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameraInstallations]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameraInstallations](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Serial] [nvarchar](max) NULL,
	[Remark] [nvarchar](max) NULL,
	[CreatedDateTime] [datetime] NOT NULL,
 CONSTRAINT [PK_dbo.FFCameraInstallations] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameraOperatingHours]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameraOperatingHours](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[StartTime] [datetime] NOT NULL,
	[EndTime] [datetime] NOT NULL,
	[Day] [int] NOT NULL,
	[CameraId] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFCameraOperatingHours] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameraPhotoes]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameraPhotoes](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Serial] [nvarchar](max) NULL,
	[Type] [nvarchar](max) NULL,
	[PhotoPath] [nvarchar](max) NULL,
	[CreatedDateTime] [datetime] NOT NULL,
 CONSTRAINT [PK_dbo.FFCameraPhotoes] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameras]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameras](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[BranchId] [bigint] NOT NULL,
	[BranchCode] [nvarchar](max) NULL,
	[BranchName] [nvarchar](max) NULL,
	[IP] [nvarchar](max) NULL,
	[Port] [nvarchar](max) NULL,
	[ExternalIP] [nvarchar](max) NULL,
	[ExternalPort] [nvarchar](max) NULL,
	[CameraId] [int] NOT NULL,
	[CameraName] [nvarchar](max) NULL,
	[Username] [nvarchar](max) NULL,
	[Password] [nvarchar](max) NULL,
	[CameraFirmwareVersion] [nvarchar](max) NULL,
	[CameraStatus] [int] NOT NULL,
	[HTTPS] [bit] NOT NULL,
	[CameraModel] [int] NOT NULL,
	[DSTValue] [int] NOT NULL,
	[DateUpdated] [datetime] NOT NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[CounterCameraType] [nvarchar](max) NULL,
	[systemCountJson] [nvarchar](max) NULL,
	[isCountInAllowUp] [bit] NOT NULL,
	[Serial] [nvarchar](max) NULL,
	[UpdatedDateTime] [datetime] NOT NULL,
	[UserId] [bigint] NULL,
	[CompanySerial] [nvarchar](max) NULL,
	[UserRemarks] [nvarchar](max) NULL,
	[Comment] [nvarchar](max) NULL,
	[Server] [nvarchar](max) NULL,
	[ZoneId] [bigint] NOT NULL,
	[HealthCheckStatus] [int] NOT NULL,
	[LastHeartBeat] [bigint] NOT NULL,
	[ResellerCompanyCode] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFCameras] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameraSettings]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameraSettings](
	[CameraId] [bigint] NOT NULL,
	[InvertIn] [bit] NOT NULL,
	[LineIn] [int] NOT NULL,
	[LineOut] [int] NOT NULL,
	[IgnoreLeft] [int] NOT NULL,
	[IgnoreRight] [int] NOT NULL,
	[Sensitivity] [int] NOT NULL,
	[Radius] [int] NOT NULL,
	[MinSize] [int] NOT NULL,
	[Watershed] [bit] NOT NULL,
	[ConvexHull] [bit] NOT NULL,
	[Morph] [nvarchar](max) NULL,
	[SecondMorph] [nvarchar](max) NULL,
	[Recording] [bit] NOT NULL,
	[RoiX] [float] NOT NULL,
	[RoiY] [float] NOT NULL,
	[RoiW] [float] NOT NULL,
	[RoiH] [float] NOT NULL,
	[Enable] [bit] NOT NULL,
	[AutoUpdate] [bit] NOT NULL,
	[TopLine1Y] [int] NOT NULL,
	[BottomLine1Y] [int] NOT NULL,
	[LastUpdatedTimestamp] [bigint] NOT NULL,
	[ShoulderWidth] [int] NOT NULL,
	[UpdateSource] [int] NOT NULL,
	[TimeZone] [nvarchar](max) NULL,
	[NtpFlag] [nvarchar](max) NULL,
	[NetNtp] [nvarchar](max) NULL,
	[LocalNtp] [nvarchar](max) NULL,
	[HeartBeat] [bit] NOT NULL,
	[LiveView] [bit] NOT NULL,
	[SoftEther] [bit] NOT NULL,
	[DataAdjustment] [float] NOT NULL,
	[WhiteOptions] [nvarchar](max) NULL,
	[ResolutionOption] [nvarchar](max) NULL,
	[FPS] [int] NOT NULL,
	[CustomLine] [bit] NOT NULL,
	[InLine] [nvarchar](max) NULL,
	[OutLine] [nvarchar](max) NULL,
	[RebootFlag] [bit] NOT NULL,
	[EngineeringLog] [bit] NOT NULL,
	[Offset] [nvarchar](max) NULL,
	[wifithreshold] [int] NOT NULL,
	[shopperthreshold] [int] NOT NULL,
	[noiseFilter] [int] NOT NULL,
	[ceilingHeight] [float] NOT NULL,
	[humanMinHeight] [float] NOT NULL,
	[humanMaxHeight] [float] NOT NULL,
	[floorSpace] [nvarchar](max) NULL,
	[customFloorSpace] [bit] NOT NULL,
	[StartingZone] [nvarchar](max) NULL,
	[Model] [nvarchar](max) NULL,
	[Ratio] [nvarchar](max) NULL,
	[Mode] [nvarchar](max) NULL,
	[PrevZoomX] [nvarchar](max) NULL,
	[PrevZoomY] [nvarchar](max) NULL,
	[PrevZoomW] [nvarchar](max) NULL,
	[PrevZoomH] [nvarchar](max) NULL,
	[maxarea] [nvarchar](max) NULL,
	[Rotation] [nvarchar](max) NULL,
	[Contrast] [nvarchar](max) NULL,
	[Brightness] [nvarchar](max) NULL,
	[threshold] [nvarchar](max) NULL,
	[Gaussian] [nvarchar](max) NULL,
	[Morphy] [nvarchar](max) NULL,
	[SGBMSADWindow] [nvarchar](max) NULL,
	[OffShiftY] [nvarchar](max) NULL,
	[OffShiftX] [nvarchar](max) NULL,
	[Resolution] [nvarchar](max) NULL,
	[RotateLeft] [nvarchar](max) NULL,
	[RotateRight] [nvarchar](max) NULL,
	[LeftUp] [nvarchar](max) NULL,
	[DualScreen] [nvarchar](max) NULL,
	[FloorCreation] [nvarchar](max) NULL,
	[PersonRecording] [nvarchar](max) NULL,
	[BlobRecording] [nvarchar](max) NULL,
	[LineCreation] [nvarchar](max) NULL,
	[FloorThes] [nvarchar](max) NULL,
	[WriteFloor] [nvarchar](max) NULL,
	[Zone] [nvarchar](max) NULL,
	[iszone] [nvarchar](max) NULL,
	[GreenNoise] [nvarchar](max) NULL,
	[DebugMode] [nvarchar](max) NULL,
	[floorUndefPerc] [nvarchar](max) NULL,
	[floorUndefStatus] [nvarchar](max) NULL,
	[floorUndefPercRef] [nvarchar](max) NULL,
	[floorUndefPercThresh] [nvarchar](max) NULL,
	[floorUndefPercThreshMaj] [nvarchar](max) NULL,
	[floorUndefCountEnable] [nvarchar](max) NULL,
	[floorUndefEnable] [nvarchar](max) NULL,
	[doorAvgEnable] [nvarchar](max) NULL,
	[doorAvgRef] [nvarchar](max) NULL,
	[doorAvgThresh] [nvarchar](max) NULL,
	[doorZone] [nvarchar](max) NULL,
	[drawFlag] [nvarchar](max) NULL,
	[idealSetting] [nvarchar](max) NULL,
	[cameraDegree] [nvarchar](max) NULL,
	[leftIntrinsic] [nvarchar](max) NULL,
	[rightIntrinsic] [nvarchar](max) NULL,
	[leftDistortion] [nvarchar](max) NULL,
	[rightDistortion] [nvarchar](max) NULL,
	[scaledLeftRrect] [nvarchar](max) NULL,
	[scaledLeftIntrinsicRect] [nvarchar](max) NULL,
	[scaledRightRrect] [nvarchar](max) NULL,
	[scaledRightIntrinsicRect] [nvarchar](max) NULL,
	[Q] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFCameraSettings] PRIMARY KEY CLUSTERED 
(
	[CameraId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameraSimulatorSettings]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameraSimulatorSettings](
	[CameraId] [bigint] NOT NULL,
	[InvertIn] [bit] NOT NULL,
	[LineIn] [int] NOT NULL,
	[LineOut] [int] NOT NULL,
	[TopLine1Y] [int] NOT NULL,
	[BottomLine1Y] [int] NOT NULL,
	[IgnoreLeft] [int] NOT NULL,
	[IgnoreRight] [int] NOT NULL,
	[Sensitivity] [int] NOT NULL,
	[ShoulderWidth] [int] NOT NULL,
	[Radius] [int] NOT NULL,
	[MinSize] [int] NOT NULL,
	[Watershed] [bit] NOT NULL,
	[ConvexHull] [bit] NOT NULL,
	[Morph] [nvarchar](max) NULL,
	[SecondMorph] [nvarchar](max) NULL,
	[Recording] [bit] NOT NULL,
	[RoiX] [float] NOT NULL,
	[RoiY] [float] NOT NULL,
	[RoiW] [float] NOT NULL,
	[RoiH] [float] NOT NULL,
	[WhiteOptions] [nvarchar](max) NULL,
	[InLine] [nvarchar](max) NULL,
	[OutLine] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFCameraSimulatorSettings] PRIMARY KEY CLUSTERED 
(
	[CameraId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameraValues]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameraValues](
	[ValueDateTime] [datetime] NOT NULL,
	[CameraId] [bigint] NOT NULL,
	[OutsideTraffic] [int] NOT NULL,
	[ValueIn] [int] NOT NULL,
	[ValueOut] [int] NOT NULL,
	[ValueTimestamp] [datetime] NOT NULL,
	[Timestamp] [bigint] NOT NULL,
	[Day] [int] NOT NULL,
	[PatchStatus] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFCameraValues] PRIMARY KEY CLUSTERED 
(
	[ValueDateTime] ASC,
	[CameraId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameraVersions]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameraVersions](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Version] [nvarchar](max) NULL,
	[FileLocation] [nvarchar](max) NULL,
	[FileName] [nvarchar](max) NULL,
	[MD5] [nvarchar](max) NULL,
	[ReleaseDate] [datetime] NOT NULL,
	[Active] [bit] NOT NULL,
	[Downgrade] [bit] NOT NULL,
	[Description] [nvarchar](max) NULL,
	[Password] [nvarchar](max) NULL,
	[CameraType] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFCameraVersions] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameraWifiThresValues]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameraWifiThresValues](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[ValueTimestamp] [datetime] NOT NULL,
	[ValueDateTime] [datetime] NOT NULL,
	[Fifteen] [int] NOT NULL,
	[Thirty] [int] NOT NULL,
	[Over] [int] NOT NULL,
	[Day] [int] NOT NULL,
	[CameraId] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFCameraWifiThresValues] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameraWifiValues]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameraWifiValues](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Counter] [int] NOT NULL,
	[ValueDateTime] [datetime] NOT NULL,
	[Value] [int] NOT NULL,
	[ValueTimestamp] [datetime] NOT NULL,
	[Day] [int] NOT NULL,
	[CameraId] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFCameraWifiValues] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCameraZones]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCameraZones](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[ZoneName] [nvarchar](max) NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Radius] [float] NOT NULL,
	[FloorId] [bigint] NOT NULL,
	[FFBranchFloor_ID] [bigint] NULL,
 CONSTRAINT [PK_dbo.FFCameraZones] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFChatMessages]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFChatMessages](
	[FFChatMessageId] [bigint] IDENTITY(1,1) NOT NULL,
	[FFChatUserId] [bigint] NOT NULL,
	[FFChatRoomId] [bigint] NOT NULL,
	[Message] [nvarchar](max) NULL,
	[Time] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFChatMessages] PRIMARY KEY CLUSTERED 
(
	[FFChatMessageId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFChatRoomMembers]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFChatRoomMembers](
	[FFChatRoomMemberId] [bigint] IDENTITY(1,1) NOT NULL,
	[FFChatRoomId] [bigint] NOT NULL,
	[FFChatUserId] [bigint] NOT NULL,
	[JoinTime] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFChatRoomMembers] PRIMARY KEY CLUSTERED 
(
	[FFChatRoomMemberId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFChatRooms]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFChatRooms](
	[FFChatRoomId] [bigint] IDENTITY(1,1) NOT NULL,
	[RoomName] [nvarchar](max) NULL,
	[CreatedTime] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFChatRooms] PRIMARY KEY CLUSTERED 
(
	[FFChatRoomId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFChatUsers]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFChatUsers](
	[FFChatUserId] [bigint] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](max) NULL,
	[UserId] [nvarchar](max) NULL,
	[DeviceId] [nvarchar](max) NULL,
	[DeviceType] [int] NOT NULL,
	[RegistrationTime] [bigint] NOT NULL,
	[IsAdmin] [bit] NOT NULL,
 CONSTRAINT [PK_dbo.FFChatUsers] PRIMARY KEY CLUSTERED 
(
	[FFChatUserId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCounterCameraHCs]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCounterCameraHCs](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Code] [nvarchar](max) NULL,
	[Name] [nvarchar](max) NULL,
	[ExternalIP] [nvarchar](max) NULL,
	[ExternalPort] [nvarchar](max) NULL,
	[Message] [nvarchar](max) NULL,
	[ErrorType] [int] NOT NULL,
	[Timestamp] [bigint] NOT NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[BranchName] [nvarchar](max) NULL,
	[InternalIP] [nvarchar](max) NULL,
	[Gateway] [nvarchar](max) NULL,
	[Mac] [nvarchar](max) NULL,
	[Temp] [nvarchar](max) NULL,
	[DateTime] [nvarchar](max) NULL,
	[Raspicam] [bit] NOT NULL,
	[Memory] [bigint] NOT NULL,
	[Storage] [bigint] NOT NULL,
	[CountingData] [bit] NOT NULL,
	[WifiData] [bit] NOT NULL,
	[NTP] [bit] NOT NULL,
	[Softether] [nvarchar](max) NULL,
	[LastBoot] [nvarchar](max) NULL,
	[Version] [nvarchar](max) NULL,
	[DHCP] [bit] NOT NULL,
	[IsVideoUploaded] [bit] NOT NULL,
	[Serial] [nvarchar](max) NULL,
	[DatabaseStatus] [nvarchar](max) NULL,
	[NetworkStatus] [nvarchar](max) NULL,
	[VoltageStatus] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFCounterCameraHCs] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFCrossShoppers]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFCrossShoppers](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Week] [int] NOT NULL,
	[ValueDateTime] [datetime] NOT NULL,
	[ValueTimeStamp] [bigint] NOT NULL,
	[NoCrossShop] [int] NOT NULL,
	[CrossOneShop] [int] NOT NULL,
	[CrossMultipleShop] [int] NOT NULL,
	[BranchId] [bigint] NOT NULL,
	[CompanyId] [bigint] NOT NULL,
	[CrossTwoShop] [int] NOT NULL,
	[CrossThreeShop] [int] NOT NULL,
	[CrossFourShop] [int] NOT NULL,
	[TotalCrossShop] [int] NOT NULL,
	[TotalValueIn] [int] NOT NULL,
	[TotalValueOut] [int] NOT NULL,
 CONSTRAINT [PK_dbo.FFCrossShoppers] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFDailyPredictions]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFDailyPredictions](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Date] [datetime] NOT NULL,
	[LastYearFF] [int] NOT NULL,
	[ThisYearFF] [int] NOT NULL,
	[LastYearTransactionCount] [int] NOT NULL,
	[ThisYearTransactionCount] [int] NOT NULL,
	[PercentageChangeFF] [float] NOT NULL,
	[PercentageChangeTransactionCount] [float] NOT NULL,
	[Weather] [nvarchar](max) NULL,
	[BranchDailyPredictionId] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFDailyPredictions] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFDashboardDetails]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFDashboardDetails](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[DashboardId] [bigint] NOT NULL,
	[DashboardTitle] [nvarchar](max) NULL,
	[FromDate] [nvarchar](max) NULL,
	[ToDate] [nvarchar](max) NULL,
	[BranchCode] [nvarchar](max) NULL,
	[Parameter1] [bigint] NOT NULL,
	[Parameter2] [bigint] NOT NULL,
	[Parameter3] [bigint] NOT NULL,
	[DateTimeCreated] [datetime] NOT NULL,
	[DateTimeLastUpdated] [datetime] NOT NULL,
	[SortOrder] [int] NOT NULL,
 CONSTRAINT [PK_dbo.FFDashboardDetails] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFDashboards]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFDashboards](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[UserId] [bigint] NOT NULL,
	[DateTimeCreated] [datetime] NOT NULL,
	[DateTimeLastUpdated] [datetime] NOT NULL,
	[SortOrder] [int] NOT NULL,
	[DashboardName] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFDashboards] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFDVRHCs]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFDVRHCs](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Code] [nvarchar](max) NULL,
	[Name] [nvarchar](max) NULL,
	[ExternalIP] [nvarchar](max) NULL,
	[ExternalPort] [nvarchar](max) NULL,
	[Message] [nvarchar](max) NULL,
	[ErrorType] [int] NOT NULL,
	[Timestamp] [bigint] NOT NULL,
	[CompanyCode] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFDVRHCs] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFEmailReports]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFEmailReports](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[ReportId] [bigint] NOT NULL,
	[CreatedDateTime] [datetime] NOT NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[BranchId] [bigint] NOT NULL,
	[UserId] [int] NOT NULL,
	[Email] [nvarchar](max) NULL,
	[BranchName] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFEmailReports] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFEPosStaffHours]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFEPosStaffHours](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Serial] [nvarchar](max) NULL,
	[CameraId] [bigint] NOT NULL,
	[Timestamp] [bigint] NOT NULL,
	[StaffCount] [int] NOT NULL,
 CONSTRAINT [PK_dbo.FFEPosStaffHours] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFEPosTransactionDatas]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFEPosTransactionDatas](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Timestamp] [bigint] NOT NULL,
	[TransactionCount] [int] NOT NULL,
	[AverageAmount] [float] NOT NULL,
	[SalesAmount] [float] NOT NULL,
	[BranchCode] [nvarchar](max) NULL,
	[BranchId] [bigint] NOT NULL,
	[PatchStatus] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFEPosTransactionDatas] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFOutsideTraffics]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFOutsideTraffics](
	[ValueDateTime] [datetime] NOT NULL,
	[CameraId] [bigint] NOT NULL,
	[MAC] [nvarchar](128) NOT NULL,
	[HashMac] [nvarchar](max) NULL,
	[status] [int] NOT NULL,
	[Day] [int] NOT NULL,
 CONSTRAINT [PK_dbo.FFOutsideTraffics] PRIMARY KEY CLUSTERED 
(
	[ValueDateTime] ASC,
	[CameraId] ASC,
	[MAC] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFPageAccessCompanies]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFPageAccessCompanies](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CompanyId] [bigint] NOT NULL,
	[Page] [int] NOT NULL,
	[DefaultUserAccess] [bit] NOT NULL,
	[DefaultAdminAccess] [bit] NOT NULL,
 CONSTRAINT [PK_dbo.FFPageAccessCompanies] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFPageAccesses]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFPageAccesses](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[UserId] [bigint] NOT NULL,
	[Page] [int] NOT NULL,
 CONSTRAINT [PK_dbo.FFPageAccesses] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFRecentViews]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFRecentViews](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[UserId] [bigint] NOT NULL,
	[LastView] [datetime] NOT NULL,
	[ReportType] [nvarchar](max) NULL,
	[ReportLink] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFRecentViews] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFRegions]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFRegions](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CompanyId] [bigint] NOT NULL,
	[Name] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFRegions] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFReports]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFReports](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[ReportName] [nvarchar](max) NULL,
	[SortOrder] [int] NOT NULL,
	[Description] [nvarchar](max) NULL,
	[Link] [nvarchar](max) NULL,
	[RoleAccess] [nvarchar](max) NULL,
	[Status] [bit] NOT NULL,
	[Frequency] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFReports] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFReportSummaryDailies]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFReportSummaryDailies](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Date] [bigint] NOT NULL,
	[CameraId] [bigint] NOT NULL,
	[CameraName] [nvarchar](max) NULL,
	[ValueIn] [int] NOT NULL,
	[ValueOut] [int] NOT NULL,
	[OutsideTraffic] [int] NOT NULL,
	[TurnInRate] [float] NOT NULL,
	[FifteenMinWifiCount] [int] NOT NULL,
	[ThirteenMinWifiCount] [int] NOT NULL,
	[OverWifiCount] [int] NOT NULL,
	[NewCustomer] [int] NOT NULL,
	[WeeklyCustomer] [int] NOT NULL,
	[MonthlyCustomer] [int] NOT NULL,
	[CustomerMacs] [nvarchar](max) NULL,
	[WeeklyCustomerMacs] [nvarchar](max) NULL,
	[MonthlyCustomerMacs] [nvarchar](max) NULL,
	[BranchId] [bigint] NOT NULL,
	[CompanyId] [bigint] NOT NULL,
	[AverageDwellTime] [float] NOT NULL,
	[PatchStatus] [nvarchar](max) NULL,
	[CrossShopper1] [int] NOT NULL,
	[CrossShopper2] [int] NOT NULL,
	[CrossShopper3] [int] NOT NULL,
	[TopCrossShop1] [bigint] NOT NULL,
	[TopCrossShop2] [bigint] NOT NULL,
	[TopCrossShop3] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFReportSummaryDailies] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFServers]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFServers](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[ServerName] [nvarchar](max) NULL,
	[FFServerIP] [nvarchar](max) NULL,
	[ServerGUID] [nvarchar](max) NULL,
	[ResellerCompanyCode] [nvarchar](max) NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[LastHeartBeat] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFServers] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFShopperHourlyValues]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFShopperHourlyValues](
	[ValueDateTime] [datetime] NOT NULL,
	[MAC] [nvarchar](128) NOT NULL,
	[HashMac] [nvarchar](max) NULL,
	[first_seen] [bigint] NOT NULL,
	[last_seen] [bigint] NOT NULL,
	[Day] [int] NOT NULL,
	[status] [int] NOT NULL,
	[CameraId] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFShopperHourlyValues] PRIMARY KEY CLUSTERED 
(
	[ValueDateTime] ASC,
	[CameraId] ASC,
	[MAC] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFUserAccesses]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFUserAccesses](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[UserId] [bigint] NOT NULL,
	[BranchId] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFUserAccesses] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFVerificationStudyReports]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFVerificationStudyReports](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[FFCameraId] [bigint] NOT NULL,
	[Summary] [nvarchar](max) NULL,
	[CreatedBy] [nvarchar](max) NULL,
	[Timestamp] [bigint] NOT NULL,
	[NoOfLog] [int] NOT NULL,
	[OverallAccuracyIn] [decimal](18, 2) NOT NULL,
	[OverallAccuracyOut] [decimal](18, 2) NOT NULL,
	[OverallSampleSizeIn] [int] NOT NULL,
	[OverallSampleSizeOut] [int] NOT NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[ReportType] [int] NOT NULL,
	[ReportDataType] [int] NOT NULL,
	[VerifiedBy] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFVerificationStudyReports] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFVerificationStudyReportVideos]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFVerificationStudyReportVideos](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[FFVideoScheduleId] [bigint] NOT NULL,
	[FFVerificationStudyReportId] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFVerificationStudyReportVideos] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFVideoScheduleLogRemarks]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFVideoScheduleLogRemarks](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[FFVideoScheduleId] [bigint] NOT NULL,
	[LogRemarkDateTime] [datetime] NOT NULL,
	[CountIn] [int] NOT NULL,
	[CountOut] [int] NOT NULL,
	[Remark] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFVideoScheduleLogRemarks] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFVideoSchedules]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFVideoSchedules](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[FFCameraId] [bigint] NOT NULL,
	[ScheduleDateTime] [datetime] NOT NULL,
	[Duration] [int] NOT NULL,
	[SessionKey] [uniqueidentifier] NOT NULL,
	[Timestamp] [bigint] NOT NULL,
	[Progress] [int] NOT NULL,
	[Status] [int] NOT NULL,
	[VerificationStudyTimestamp] [bigint] NOT NULL,
	[SystemCountIn] [int] NULL,
	[SystemCountOut] [int] NULL,
	[ManualCountIn] [int] NULL,
	[ManualCountOut] [int] NULL,
	[AccuracyIn] [decimal](18, 2) NULL,
	[AccuracyOut] [decimal](18, 2) NULL,
	[VerifyBy] [nvarchar](max) NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[OverallComment] [nvarchar](max) NULL,
	[FileName] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.FFVideoSchedules] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFWifiFootfallCountings]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFWifiFootfallCountings](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Counter] [int] NOT NULL,
	[ValueDateTime] [datetime] NOT NULL,
	[ValueIn] [int] NOT NULL,
	[ValueOut] [int] NOT NULL,
	[OutsideTraffic] [int] NOT NULL,
	[Day] [int] NOT NULL,
	[CameraId] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.FFWifiFootfallCountings] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFZoneDailies]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFZoneDailies](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[ZoneID] [bigint] NOT NULL,
	[ValueDateTime] [datetime] NOT NULL,
	[OutsideTraffic] [int] NOT NULL,
	[CompanyID] [bigint] NOT NULL,
	[Status] [int] NOT NULL,
 CONSTRAINT [PK_dbo.FFZoneDailies] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FFZoneHourlies]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FFZoneHourlies](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[ZoneID] [bigint] NOT NULL,
	[ValueDateTime] [datetime] NOT NULL,
	[ValueTimeStamp] [datetime] NOT NULL,
	[OutsideTraffic] [int] NOT NULL,
	[Status] [int] NOT NULL,
 CONSTRAINT [PK_dbo.FFZoneHourlies] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMBranches]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMBranches](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[BranchID] [int] NOT NULL,
	[BranchCode] [nvarchar](max) NULL,
	[BranchName] [nvarchar](max) NULL,
	[EmailTitle] [nvarchar](max) NULL,
	[EmailDescription] [nvarchar](max) NULL,
	[EmailLocation] [nvarchar](max) NULL,
	[Status] [bit] NOT NULL,
	[EmailFbAlbumName] [nvarchar](max) NULL,
	[EmailFbAlbumDescription] [nvarchar](max) NULL,
	[EmailFbAlbumLocation] [nvarchar](max) NULL,
	[BranchEmail] [nvarchar](max) NULL,
	[EmailImageFolderName] [nvarchar](max) NULL,
	[EmailHTMLTemplateFolderName] [nvarchar](max) NULL,
	[EmailHTMLTemplateName] [nvarchar](max) NULL,
	[UpdatedDate] [datetime] NOT NULL,
	[BranchWebsite] [nvarchar](max) NULL,
	[IsFacebook] [bit] NOT NULL,
	[IsTwitter] [bit] NOT NULL,
	[IsPinterest] [bit] NOT NULL,
	[IsWeiBo] [bit] NOT NULL,
	[MMLogFileName] [nvarchar](max) NULL,
	[SocialMediaVersion] [int] NOT NULL,
	[TwitterDescription] [nvarchar](max) NULL,
	[MagicMirrorVersion] [nvarchar](max) NULL,
	[MagicMirrorConfigFile] [nvarchar](max) NULL,
	[Logo] [nvarchar](max) NULL,
	[Watermark] [nvarchar](max) NULL,
	[PromotionalText1] [nvarchar](max) NULL,
	[PromotionalImage1] [nvarchar](max) NULL,
	[PromotionalURL1] [nvarchar](max) NULL,
	[PromotionalText2] [nvarchar](max) NULL,
	[PromotionalImage2] [nvarchar](max) NULL,
	[PromotionalURL2] [nvarchar](max) NULL,
	[PromotionalText3] [nvarchar](max) NULL,
	[PromotionalImage3] [nvarchar](max) NULL,
	[PromotionalURL3] [nvarchar](max) NULL,
	[PromotionalText4] [nvarchar](max) NULL,
	[PromotionalImage4] [nvarchar](max) NULL,
	[PromotionalURL4] [nvarchar](max) NULL,
	[EmailCustomizationVersion] [nvarchar](max) NULL,
	[EmailCustomizationStatus] [nvarchar](max) NULL,
	[EmailCustomizationLastUpdate] [bigint] NOT NULL,
	[SocialMediaCustomizationVersion] [nvarchar](max) NULL,
	[SocialMediaCustomizationStatus] [nvarchar](max) NULL,
	[SocialMediaCustomizationLastUpdate] [bigint] NOT NULL,
	[PhotoFrameCSVVersion] [nvarchar](max) NULL,
	[PhotoFrameCSVStatus] [nvarchar](max) NULL,
	[PhotoFrameCSVLastUpdate] [bigint] NOT NULL,
	[PhotoFrameCSVLocation] [bigint] NOT NULL,
	[PhotoFrameImageVersion] [nvarchar](max) NULL,
	[PhotoFrameImageStatus] [nvarchar](max) NULL,
	[PhotoFrameImageLastUpdate] [bigint] NOT NULL,
	[PhotoFrameImageLocation] [bigint] NOT NULL,
	[VideoVersion] [nvarchar](max) NULL,
	[VideoStatus] [nvarchar](max) NULL,
	[VideoLastUpdate] [bigint] NOT NULL,
	[VideoLocation] [bigint] NOT NULL,
	[ProductCSVVersion] [nvarchar](max) NULL,
	[ProductCSVStatus] [nvarchar](max) NULL,
	[ProductCSVLastUpdate] [bigint] NOT NULL,
	[ProductCSVLocation] [bigint] NOT NULL,
	[ProductImageVersion] [nvarchar](max) NULL,
	[ProductImageStatus] [nvarchar](max) NULL,
	[ProductImageLastUpdate] [bigint] NOT NULL,
	[ProductImageLocation] [bigint] NOT NULL,
	[VoucherVersion] [nvarchar](max) NULL,
	[VoucherStatus] [nvarchar](max) NULL,
	[VoucherLastUpdate] [bigint] NOT NULL,
	[VoucherLocation] [bigint] NOT NULL,
	[SoftwareName] [nvarchar](max) NULL,
	[MagicMirrorVersionStatus] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.MMBranches] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMCameraSettingAEModes]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMCameraSettingAEModes](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[AEModeValue] [nvarchar](max) NULL,
	[AEModeText] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.MMCameraSettingAEModes] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMCameraSettingAVs]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMCameraSettingAVs](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[AVValue] [nvarchar](max) NULL,
	[AVText] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.MMCameraSettingAVs] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMCameraSettingISOes]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMCameraSettingISOes](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[ISOValue] [nvarchar](max) NULL,
	[ISOText] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.MMCameraSettingISOes] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMCameraSettings]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMCameraSettings](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[BranchId] [nvarchar](max) NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[Mode] [nvarchar](max) NULL,
	[ISO] [nvarchar](max) NULL,
	[AV] [nvarchar](max) NULL,
	[TV] [nvarchar](max) NULL,
	[UpdatedDateTime] [datetime] NOT NULL,
 CONSTRAINT [PK_dbo.MMCameraSettings] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMCameraSettingTVs]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMCameraSettingTVs](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[TVValue] [nvarchar](max) NULL,
	[TVText] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.MMCameraSettingTVs] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMCustomizationSettings]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMCustomizationSettings](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[EmailCustomizationVersion] [nvarchar](max) NULL,
	[SocialMediaCustomizationVersion] [nvarchar](max) NULL,
	[PhotoFrameCSVVersion] [nvarchar](max) NULL,
	[PhotoFrameImageVersion] [nvarchar](max) NULL,
	[VideoVersion] [nvarchar](max) NULL,
	[ProductCSVVersion] [nvarchar](max) NULL,
	[ProductImageVersion] [nvarchar](max) NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[VoucherVersion] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.MMCustomizationSettings] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMFacebookPhotoGalleries]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMFacebookPhotoGalleries](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[BranchId] [nvarchar](max) NULL,
	[BranchName] [nvarchar](max) NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[ImageLocation] [nvarchar](max) NULL,
	[ImageURL] [nvarchar](max) NULL,
	[UserId] [uniqueidentifier] NOT NULL,
	[CreatedDateTime] [datetime] NOT NULL,
	[OriginalImageLocation] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.MMFacebookPhotoGalleries] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMHealthChecks]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMHealthChecks](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[BranchId] [nvarchar](max) NULL,
	[BranchName] [nvarchar](max) NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[Message] [nvarchar](max) NULL,
	[Timestamp] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.MMHealthChecks] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMLogs]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMLogs](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[UserId] [uniqueidentifier] NOT NULL,
	[BranchId] [int] NOT NULL,
	[BranchCode] [nvarchar](max) NULL,
	[BranchName] [nvarchar](max) NULL,
	[MMVersionId] [int] NOT NULL,
	[MMVersionType] [nvarchar](max) NULL,
	[MMVersionName] [nvarchar](max) NULL,
	[TakePhoto] [bit] NOT NULL,
	[EmailAddress] [nvarchar](max) NULL,
	[CustomerName] [nvarchar](max) NULL,
	[PhoneNumber] [nvarchar](max) NULL,
	[YearOfBirth] [int] NOT NULL,
	[MonthOfBirth] [int] NOT NULL,
	[DayOfBirth] [int] NOT NULL,
	[CreatedDateTime] [datetime] NOT NULL,
	[City] [nvarchar](max) NULL,
	[Country] [nvarchar](max) NULL,
	[PreferredCommunicationFrequency] [nvarchar](max) NULL,
	[PreferredCommunicationTypes] [nvarchar](max) NULL,
	[PreferredCommunicationLanguage] [nvarchar](max) NULL,
	[DataSource] [nvarchar](max) NULL,
	[Other] [nvarchar](max) NULL,
	[Score] [int] NOT NULL,
	[Rank] [int] NOT NULL,
	[PostToFacebook] [bit] NOT NULL,
	[FacebookId] [nvarchar](max) NULL,
	[PostToTwitter] [bit] NOT NULL,
	[TwitterId] [nvarchar](max) NULL,
	[PrintVoucher] [bit] NOT NULL,
	[ItemBrowse] [nvarchar](max) NULL,
	[KinectInterpretation] [nvarchar](max) NULL,
	[CompanyId] [int] NOT NULL,
	[CompanyName] [nvarchar](max) NULL,
	[SendEmail] [bit] NOT NULL,
	[FacebookUsername] [nvarchar](max) NULL,
	[TwitterUsername] [nvarchar](max) NULL,
	[PhotoFiles] [nvarchar](max) NULL,
	[Disclaimer] [bit] NOT NULL,
	[CustomerIdentifier] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.MMLogs] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMModuleCompanies]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMModuleCompanies](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[ModuleTypeId] [bigint] NOT NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[Description] [nvarchar](max) NULL,
	[AppId] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.MMModuleCompanies] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMModules]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMModules](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[ModuleName] [nvarchar](max) NULL,
	[BranchId] [int] NOT NULL,
 CONSTRAINT [PK_dbo.MMModules] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMModuleTypes]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMModuleTypes](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[ModuleName] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.MMModuleTypes] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMPhotoGalleryDeletedImages]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMPhotoGalleryDeletedImages](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[BranchId] [nvarchar](max) NULL,
	[BranchName] [nvarchar](max) NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[FileName] [nvarchar](max) NULL,
	[UserId] [uniqueidentifier] NOT NULL,
 CONSTRAINT [PK_dbo.MMPhotoGalleryDeletedImages] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMUploadTasks]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMUploadTasks](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[Version] [float] NOT NULL,
	[Data] [nvarchar](max) NULL,
	[Description] [nvarchar](max) NULL,
	[CreatedDateTime] [datetime] NOT NULL,
	[DeployDateTime] [datetime] NOT NULL,
	[AppId] [nvarchar](max) NULL,
	[Status] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.MMUploadTasks] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMVersions]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMVersions](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[BranchID] [int] NOT NULL,
	[BranchCode] [nvarchar](max) NULL,
	[BranchName] [nvarchar](max) NULL,
	[SoftwareName] [nvarchar](max) NULL,
	[Version] [float] NOT NULL,
	[Status] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.MMVersions] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[MMWebPhotoGalleries]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MMWebPhotoGalleries](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[BranchId] [nvarchar](max) NULL,
	[BranchName] [nvarchar](max) NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[CreatedDateTime] [datetime] NOT NULL,
	[ImageLocation] [nvarchar](max) NULL,
	[ImageURL] [nvarchar](max) NULL,
	[UserId] [uniqueidentifier] NOT NULL,
	[OriginalImageLocation] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.MMWebPhotoGalleries] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Moods]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Moods](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[index] [int] NOT NULL,
	[Name] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.Moods] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[NCDVRHCs]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NCDVRHCs](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Code] [nvarchar](max) NULL,
	[Name] [nvarchar](max) NULL,
	[ExternalIP] [nvarchar](max) NULL,
	[ExternalPort] [nvarchar](max) NULL,
	[Message] [nvarchar](max) NULL,
	[ErrorType] [int] NOT NULL,
	[Timestamp] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.NCDVRHCs] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[ProductLineManagements]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProductLineManagements](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[featureRequestSubject] [nvarchar](max) NULL,
	[featureRequestMessage] [nvarchar](max) NULL,
	[featureRequestImage] [nvarchar](max) NULL,
	[footfallCamComment] [nvarchar](max) NULL,
	[requestStatus] [nvarchar](max) NULL,
	[featureRequestVersion] [nvarchar](max) NULL,
	[companyID] [bigint] NOT NULL,
	[createdDate] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.ProductLineManagements] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[ProjectTrackers]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProjectTrackers](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[IssueDate] [nvarchar](max) NULL,
	[IssueDetails] [nvarchar](max) NULL,
	[IssueRemarks] [nvarchar](max) NULL,
	[IssueStatus] [nvarchar](max) NULL,
	[ResellerID] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.ProjectTrackers] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Resellers]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Resellers](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CountryId] [nvarchar](max) NULL,
	[ResellerCompanyName] [nvarchar](max) NULL,
	[ContactPerson] [nvarchar](max) NULL,
	[Address] [nvarchar](max) NULL,
	[EmailAddress] [nvarchar](max) NULL,
	[ContactNumber] [nvarchar](max) NULL,
	[CountryName] [nvarchar](max) NULL,
	[Description] [nvarchar](max) NULL,
	[Url] [nvarchar](max) NULL,
	[MSRP] [nvarchar](max) NULL,
	[ResellerPrice] [nvarchar](max) NULL,
	[Priority] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.Resellers] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[ReturnMerchandiseAuthorisations]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ReturnMerchandiseAuthorisations](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CounterSerial] [nvarchar](max) NULL,
	[RMAIssue] [nvarchar](max) NULL,
	[RMADate] [nvarchar](max) NULL,
	[FootfallCamRemarks] [nvarchar](max) NULL,
	[RMAStatus] [nvarchar](max) NULL,
	[ResellerID] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.ReturnMerchandiseAuthorisations] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[SalesLeads]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SalesLeads](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CustomerCompanyName] [nvarchar](max) NULL,
	[PotentialRemarks] [nvarchar](max) NULL,
	[Country] [nvarchar](max) NULL,
	[ExpiryDate] [nvarchar](max) NULL,
	[SalesLeadStatus] [nvarchar](max) NULL,
	[FootfallCamRemarks] [nvarchar](max) NULL,
	[ResellerID] [bigint] NOT NULL,
 CONSTRAINT [PK_dbo.SalesLeads] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[ServerIdentifications]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ServerIdentifications](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[ServerName] [nvarchar](max) NULL,
	[GUID] [nvarchar](max) NULL,
	[ResellerCompanyCode] [nvarchar](max) NULL,
	[CompanyCode] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.ServerIdentifications] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[SiteTags]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SiteTags](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[branchID] [bigint] NOT NULL,
	[tagName] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.SiteTags] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[StaffHours]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StaffHours](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[BranchCode] [nvarchar](max) NULL,
	[Timestamp] [bigint] NOT NULL,
	[StaffCount] [float] NOT NULL,
	[branchId] [bigint] NOT NULL,
	[PatchStatus] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.StaffHours] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TempMac]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TempMac](
	[MAC] [nvarchar](128) NOT NULL,
	[ValueTimestamp] [datetime2](3) NOT NULL,
	[ValueDateTime] [datetime2](3) NOT NULL,
	[Day] [int] NOT NULL,
	[CameraId] [bigint] NOT NULL,
	[HashMac] [ntext] NULL,
	[first_seen] [bigint] NOT NULL,
	[last_seen] [bigint] NOT NULL,
	[count] [int] NOT NULL,
	[dwell_time] [int] NOT NULL,
	[lowest] [int] NOT NULL,
	[highest] [int] NOT NULL,
	[average] [real] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Users]    Script Date: 02/09/2016 9:56:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Users](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[UserName] [nvarchar](max) NOT NULL,
	[Password] [nvarchar](max) NOT NULL,
	[Name] [nvarchar](max) NOT NULL,
	[LastLoginTimestamp] [bigint] NOT NULL,
	[CompanyCode] [nvarchar](max) NULL,
	[UserRole] [nvarchar](max) NULL,
	[Email] [nvarchar](max) NOT NULL,
	[Language] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.Users] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Companies] ADD  DEFAULT ((0)) FOR [NurseryCam]
GO
ALTER TABLE [dbo].[Companies] ADD  DEFAULT ((0)) FOR [RetailCam]
GO
ALTER TABLE [dbo].[Companies] ADD  DEFAULT ((0)) FOR [MagicMirror]
GO
ALTER TABLE [dbo].[Companies] ADD  DEFAULT ((0)) FOR [FootfallCam]
GO
ALTER TABLE [dbo].[Companies] ADD  DEFAULT ('1900-01-01T00:00:00.000') FOR [UpdatedDateTime]
GO
ALTER TABLE [dbo].[Companies] ADD  DEFAULT ((0)) FOR [ShowOutValue]
GO
ALTER TABLE [dbo].[CompanySettings] ADD  DEFAULT ((0)) FOR [ExportDwellTime]
GO
ALTER TABLE [dbo].[CompanySettings] ADD  DEFAULT ((0)) FOR [SectionSalesConversion]
GO
ALTER TABLE [dbo].[CompanySettings] ADD  DEFAULT ((0)) FOR [SectionStaffPlanning]
GO
ALTER TABLE [dbo].[CompanySettings] ADD  DEFAULT ((0)) FOR [SectionZoneAnalytic]
GO
ALTER TABLE [dbo].[CompanySettings] ADD  DEFAULT ((0)) FOR [ExportVisitorOut]
GO
ALTER TABLE [dbo].[CompanySettings] ADD  DEFAULT ((0)) FOR [autoscheduler]
GO
ALTER TABLE [dbo].[CompanySettings] ADD  DEFAULT ((0)) FOR [SMTPRequiredAuthentication]
GO
ALTER TABLE [dbo].[CompanySettings] ADD  DEFAULT ((0)) FOR [SMTPUse]
GO
ALTER TABLE [dbo].[CompanySettings] ADD  DEFAULT ((0)) FOR [SMTPUseSSL]
GO
ALTER TABLE [dbo].[CountryPrices] ADD  DEFAULT ((0)) FOR [AllowRequestCallBack]
GO
ALTER TABLE [dbo].[FFBranches] ADD  DEFAULT ((0)) FOR [CompanyId]
GO
ALTER TABLE [dbo].[FFBranches] ADD  DEFAULT ('1900-01-01T00:00:00.000') FOR [UpdatedDateTime]
GO
ALTER TABLE [dbo].[FFBranches] ADD  DEFAULT ((0)) FOR [UserId]
GO
ALTER TABLE [dbo].[FFBranches] ADD  DEFAULT ((0)) FOR [Latitude]
GO
ALTER TABLE [dbo].[FFBranches] ADD  DEFAULT ((0)) FOR [Longitude]
GO
ALTER TABLE [dbo].[FFBranches] ADD  DEFAULT ((0)) FOR [FloorSize]
GO
ALTER TABLE [dbo].[FFBranchOperatingHours] ADD  DEFAULT ((0)) FOR [isDayOff]
GO
ALTER TABLE [dbo].[FFCameraCustomerValues] ADD  DEFAULT ((0)) FOR [first_seen]
GO
ALTER TABLE [dbo].[FFCameraCustomerValues] ADD  DEFAULT ((0)) FOR [last_seen]
GO
ALTER TABLE [dbo].[FFCameraCustomerValues] ADD  DEFAULT ((0)) FOR [count]
GO
ALTER TABLE [dbo].[FFCameraCustomerValues] ADD  DEFAULT ((0)) FOR [dwell_time]
GO
ALTER TABLE [dbo].[FFCameraCustomerValues] ADD  DEFAULT ((0)) FOR [lowest]
GO
ALTER TABLE [dbo].[FFCameraCustomerValues] ADD  DEFAULT ((0)) FOR [highest]
GO
ALTER TABLE [dbo].[FFCameraCustomerValues] ADD  DEFAULT ((0)) FOR [average]
GO
ALTER TABLE [dbo].[FFCameras] ADD  DEFAULT ((0)) FOR [isCountInAllowUp]
GO
ALTER TABLE [dbo].[FFCameras] ADD  DEFAULT ('1900-01-01T00:00:00.000') FOR [UpdatedDateTime]
GO
ALTER TABLE [dbo].[FFCameras] ADD  DEFAULT ((0)) FOR [ZoneId]
GO
ALTER TABLE [dbo].[FFCameras] ADD  DEFAULT ((0)) FOR [HealthCheckStatus]
GO
ALTER TABLE [dbo].[FFCameras] ADD  DEFAULT ((0)) FOR [LastHeartBeat]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [Enable]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [AutoUpdate]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [TopLine1Y]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [BottomLine1Y]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [LastUpdatedTimestamp]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [ShoulderWidth]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [UpdateSource]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [HeartBeat]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [LiveView]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [SoftEther]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [DataAdjustment]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [FPS]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [CustomLine]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [RebootFlag]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [EngineeringLog]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [wifithreshold]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [shopperthreshold]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [noiseFilter]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [ceilingHeight]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [humanMinHeight]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [humanMaxHeight]
GO
ALTER TABLE [dbo].[FFCameraSettings] ADD  DEFAULT ((0)) FOR [customFloorSpace]
GO
ALTER TABLE [dbo].[FFCounterCameraHCs] ADD  DEFAULT ((0)) FOR [Raspicam]
GO
ALTER TABLE [dbo].[FFCounterCameraHCs] ADD  DEFAULT ((0)) FOR [Memory]
GO
ALTER TABLE [dbo].[FFCounterCameraHCs] ADD  DEFAULT ((0)) FOR [Storage]
GO
ALTER TABLE [dbo].[FFCounterCameraHCs] ADD  DEFAULT ((0)) FOR [CountingData]
GO
ALTER TABLE [dbo].[FFCounterCameraHCs] ADD  DEFAULT ((0)) FOR [WifiData]
GO
ALTER TABLE [dbo].[FFCounterCameraHCs] ADD  DEFAULT ((0)) FOR [NTP]
GO
ALTER TABLE [dbo].[FFCounterCameraHCs] ADD  DEFAULT ((0)) FOR [DHCP]
GO
ALTER TABLE [dbo].[FFCounterCameraHCs] ADD  DEFAULT ((0)) FOR [IsVideoUploaded]
GO
ALTER TABLE [dbo].[FFCrossShoppers] ADD  DEFAULT ((0)) FOR [CrossTwoShop]
GO
ALTER TABLE [dbo].[FFCrossShoppers] ADD  DEFAULT ((0)) FOR [CrossThreeShop]
GO
ALTER TABLE [dbo].[FFCrossShoppers] ADD  DEFAULT ((0)) FOR [CrossFourShop]
GO
ALTER TABLE [dbo].[FFCrossShoppers] ADD  DEFAULT ((0)) FOR [TotalCrossShop]
GO
ALTER TABLE [dbo].[FFCrossShoppers] ADD  DEFAULT ((0)) FOR [TotalValueIn]
GO
ALTER TABLE [dbo].[FFCrossShoppers] ADD  DEFAULT ((0)) FOR [TotalValueOut]
GO
ALTER TABLE [dbo].[FFEmailReports] ADD  DEFAULT ('1900-01-01T00:00:00.000') FOR [CreatedDateTime]
GO
ALTER TABLE [dbo].[FFEmailReports] ADD  DEFAULT ((0)) FOR [BranchId]
GO
ALTER TABLE [dbo].[FFEmailReports] ADD  DEFAULT ((0)) FOR [UserId]
GO
ALTER TABLE [dbo].[FFEPosTransactionDatas] ADD  DEFAULT ((0)) FOR [SalesAmount]
GO
ALTER TABLE [dbo].[FFEPosTransactionDatas] ADD  DEFAULT ((0)) FOR [BranchId]
GO
ALTER TABLE [dbo].[FFReportSummaryDailies] ADD  DEFAULT ((0)) FOR [BranchId]
GO
ALTER TABLE [dbo].[FFReportSummaryDailies] ADD  DEFAULT ((0)) FOR [CompanyId]
GO
ALTER TABLE [dbo].[FFReportSummaryDailies] ADD  DEFAULT ((0)) FOR [AverageDwellTime]
GO
ALTER TABLE [dbo].[FFReportSummaryDailies] ADD  DEFAULT ((0)) FOR [CrossShopper1]
GO
ALTER TABLE [dbo].[FFReportSummaryDailies] ADD  DEFAULT ((0)) FOR [CrossShopper2]
GO
ALTER TABLE [dbo].[FFReportSummaryDailies] ADD  DEFAULT ((0)) FOR [CrossShopper3]
GO
ALTER TABLE [dbo].[FFReportSummaryDailies] ADD  DEFAULT ((0)) FOR [TopCrossShop1]
GO
ALTER TABLE [dbo].[FFReportSummaryDailies] ADD  DEFAULT ((0)) FOR [TopCrossShop2]
GO
ALTER TABLE [dbo].[FFReportSummaryDailies] ADD  DEFAULT ((0)) FOR [TopCrossShop3]
GO
ALTER TABLE [dbo].[FFShopperHourlyValues] ADD  DEFAULT ((0)) FOR [status]
GO
ALTER TABLE [dbo].[FFShopperHourlyValues] ADD  DEFAULT ((0)) FOR [CameraId]
GO
ALTER TABLE [dbo].[FFVerificationStudyReports] ADD  DEFAULT ((0)) FOR [OverallAccuracyIn]
GO
ALTER TABLE [dbo].[FFVerificationStudyReports] ADD  DEFAULT ((0)) FOR [OverallAccuracyOut]
GO
ALTER TABLE [dbo].[FFVerificationStudyReports] ADD  DEFAULT ((0)) FOR [OverallSampleSizeIn]
GO
ALTER TABLE [dbo].[FFVerificationStudyReports] ADD  DEFAULT ((0)) FOR [OverallSampleSizeOut]
GO
ALTER TABLE [dbo].[FFVerificationStudyReports] ADD  DEFAULT ((0)) FOR [ReportType]
GO
ALTER TABLE [dbo].[FFVerificationStudyReports] ADD  DEFAULT ((0)) FOR [ReportDataType]
GO
ALTER TABLE [dbo].[FFVideoSchedules] ADD  DEFAULT ((0)) FOR [VerificationStudyTimestamp]
GO
ALTER TABLE [dbo].[FFZoneDailies] ADD  DEFAULT ((0)) FOR [Status]
GO
ALTER TABLE [dbo].[MMBranches] ADD  DEFAULT ((0)) FOR [EmailCustomizationLastUpdate]
GO
ALTER TABLE [dbo].[MMBranches] ADD  DEFAULT ((0)) FOR [SocialMediaCustomizationLastUpdate]
GO
ALTER TABLE [dbo].[MMBranches] ADD  DEFAULT ((0)) FOR [PhotoFrameCSVLastUpdate]
GO
ALTER TABLE [dbo].[MMBranches] ADD  DEFAULT ((0)) FOR [PhotoFrameCSVLocation]
GO
ALTER TABLE [dbo].[MMBranches] ADD  DEFAULT ((0)) FOR [PhotoFrameImageLastUpdate]
GO
ALTER TABLE [dbo].[MMBranches] ADD  DEFAULT ((0)) FOR [PhotoFrameImageLocation]
GO
ALTER TABLE [dbo].[MMBranches] ADD  DEFAULT ((0)) FOR [VideoLastUpdate]
GO
ALTER TABLE [dbo].[MMBranches] ADD  DEFAULT ((0)) FOR [VideoLocation]
GO
ALTER TABLE [dbo].[MMBranches] ADD  DEFAULT ((0)) FOR [ProductCSVLastUpdate]
GO
ALTER TABLE [dbo].[MMBranches] ADD  DEFAULT ((0)) FOR [ProductCSVLocation]
GO
ALTER TABLE [dbo].[MMBranches] ADD  DEFAULT ((0)) FOR [ProductImageLastUpdate]
GO
ALTER TABLE [dbo].[MMBranches] ADD  DEFAULT ((0)) FOR [ProductImageLocation]
GO
ALTER TABLE [dbo].[MMBranches] ADD  DEFAULT ((0)) FOR [VoucherLastUpdate]
GO
ALTER TABLE [dbo].[MMBranches] ADD  DEFAULT ((0)) FOR [VoucherLocation]
GO
ALTER TABLE [dbo].[MMLogs] ADD  DEFAULT ((0)) FOR [CompanyId]
GO
ALTER TABLE [dbo].[MMLogs] ADD  DEFAULT ((0)) FOR [SendEmail]
GO
ALTER TABLE [dbo].[MMLogs] ADD  DEFAULT ((0)) FOR [Disclaimer]
GO
ALTER TABLE [dbo].[MMPhotoGalleryDeletedImages] ADD  DEFAULT ('00000000-0000-0000-0000-000000000000') FOR [UserId]
GO
ALTER TABLE [dbo].[MMWebPhotoGalleries] ADD  DEFAULT ('1900-01-01T00:00:00.000') FOR [CreatedDateTime]
GO
ALTER TABLE [dbo].[MMWebPhotoGalleries] ADD  DEFAULT ('00000000-0000-0000-0000-000000000000') FOR [UserId]
GO
ALTER TABLE [dbo].[StaffHours] ADD  DEFAULT ((0)) FOR [branchId]
GO
ALTER TABLE [dbo].[ApiActions]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.ApiActions_dbo.FFVideoSchedules_FFVideoScheduleId] FOREIGN KEY([FFVideoScheduleId])
REFERENCES [dbo].[FFVideoSchedules] ([ID])
GO
ALTER TABLE [dbo].[ApiActions] NOCHECK CONSTRAINT [FK_dbo.ApiActions_dbo.FFVideoSchedules_FFVideoScheduleId]
GO
ALTER TABLE [dbo].[Companies]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.Companies_dbo.Users_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[Users] ([ID])
GO
ALTER TABLE [dbo].[Companies] NOCHECK CONSTRAINT [FK_dbo.Companies_dbo.Users_UserId]
GO
ALTER TABLE [dbo].[CompanyCards]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.CompanyCards_dbo.Companies_CompanyId] FOREIGN KEY([CompanyId])
REFERENCES [dbo].[Companies] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[CompanyCards] NOCHECK CONSTRAINT [FK_dbo.CompanyCards_dbo.Companies_CompanyId]
GO
ALTER TABLE [dbo].[CompanySettings]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.CompanySettings_dbo.Companies_CompanyId] FOREIGN KEY([CompanyId])
REFERENCES [dbo].[Companies] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[CompanySettings] NOCHECK CONSTRAINT [FK_dbo.CompanySettings_dbo.Companies_CompanyId]
GO
ALTER TABLE [dbo].[FFBranches]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFBranches_dbo.Companies_CompanyId] FOREIGN KEY([CompanyId])
REFERENCES [dbo].[Companies] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFBranches] NOCHECK CONSTRAINT [FK_dbo.FFBranches_dbo.Companies_CompanyId]
GO
ALTER TABLE [dbo].[FFBranches]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFBranches_dbo.FFRegions_RegionId] FOREIGN KEY([RegionId])
REFERENCES [dbo].[FFRegions] ([ID])
GO
ALTER TABLE [dbo].[FFBranches] NOCHECK CONSTRAINT [FK_dbo.FFBranches_dbo.FFRegions_RegionId]
GO
ALTER TABLE [dbo].[FFBranches]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFBranches_dbo.Users_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[Users] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFBranches] NOCHECK CONSTRAINT [FK_dbo.FFBranches_dbo.Users_UserId]
GO
ALTER TABLE [dbo].[FFBranchFloors]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFBranchFloors_dbo.FFBranches_BranchId] FOREIGN KEY([BranchId])
REFERENCES [dbo].[FFBranches] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFBranchFloors] NOCHECK CONSTRAINT [FK_dbo.FFBranchFloors_dbo.FFBranches_BranchId]
GO
ALTER TABLE [dbo].[FFBranchOperatingHours]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFBranchOperatingHours_dbo.FFBranches_BranchId] FOREIGN KEY([BranchId])
REFERENCES [dbo].[FFBranches] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFBranchOperatingHours] NOCHECK CONSTRAINT [FK_dbo.FFBranchOperatingHours_dbo.FFBranches_BranchId]
GO
ALTER TABLE [dbo].[FFBranchSpecialOperatingHours]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFBranchSpecialOperatingHours_dbo.FFBranches_BranchId] FOREIGN KEY([BranchId])
REFERENCES [dbo].[FFBranches] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFBranchSpecialOperatingHours] NOCHECK CONSTRAINT [FK_dbo.FFBranchSpecialOperatingHours_dbo.FFBranches_BranchId]
GO
ALTER TABLE [dbo].[FFCameraCountingRecords]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFCameraCountingRecords_dbo.FFCameras_CameraId] FOREIGN KEY([CameraId])
REFERENCES [dbo].[FFCameras] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFCameraCountingRecords] NOCHECK CONSTRAINT [FK_dbo.FFCameraCountingRecords_dbo.FFCameras_CameraId]
GO
ALTER TABLE [dbo].[FFCameraCountingValues]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFCameraCountingValues_dbo.FFCameras_CameraId] FOREIGN KEY([CameraId])
REFERENCES [dbo].[FFCameras] ([ID])
GO
ALTER TABLE [dbo].[FFCameraCountingValues] NOCHECK CONSTRAINT [FK_dbo.FFCameraCountingValues_dbo.FFCameras_CameraId]
GO
ALTER TABLE [dbo].[FFCameraCustomerValueArchives]  WITH CHECK ADD  CONSTRAINT [FK_dbo.FFCameraCustomerValueArchives_dbo.FFCameras_CameraId] FOREIGN KEY([CameraId])
REFERENCES [dbo].[FFCameras] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFCameraCustomerValueArchives] CHECK CONSTRAINT [FK_dbo.FFCameraCustomerValueArchives_dbo.FFCameras_CameraId]
GO
ALTER TABLE [dbo].[FFCameraCustomerValues]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFCameraCustomerValues_dbo.FFCameras_CameraId] FOREIGN KEY([CameraId])
REFERENCES [dbo].[FFCameras] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFCameraCustomerValues] NOCHECK CONSTRAINT [FK_dbo.FFCameraCustomerValues_dbo.FFCameras_CameraId]
GO
ALTER TABLE [dbo].[FFCameraHourlyValues]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFCameraHourlyValues_dbo.FFCameras_CameraId] FOREIGN KEY([CameraId])
REFERENCES [dbo].[FFCameras] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFCameraHourlyValues] NOCHECK CONSTRAINT [FK_dbo.FFCameraHourlyValues_dbo.FFCameras_CameraId]
GO
ALTER TABLE [dbo].[FFCameraOperatingHours]  WITH CHECK ADD  CONSTRAINT [FK_dbo.FFCameraOperatingHours_dbo.FFCameras_CameraId] FOREIGN KEY([CameraId])
REFERENCES [dbo].[FFCameras] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFCameraOperatingHours] CHECK CONSTRAINT [FK_dbo.FFCameraOperatingHours_dbo.FFCameras_CameraId]
GO
ALTER TABLE [dbo].[FFCameras]  WITH CHECK ADD  CONSTRAINT [FK_dbo.FFCameras_dbo.Users_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[Users] ([ID])
GO
ALTER TABLE [dbo].[FFCameras] CHECK CONSTRAINT [FK_dbo.FFCameras_dbo.Users_UserId]
GO
ALTER TABLE [dbo].[FFCameraSettings]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFCameraSettings_dbo.FFCameras_CameraId] FOREIGN KEY([CameraId])
REFERENCES [dbo].[FFCameras] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFCameraSettings] NOCHECK CONSTRAINT [FK_dbo.FFCameraSettings_dbo.FFCameras_CameraId]
GO
ALTER TABLE [dbo].[FFCameraSimulatorSettings]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFCameraSimulatorSettings_dbo.FFCameras_CameraId] FOREIGN KEY([CameraId])
REFERENCES [dbo].[FFCameras] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFCameraSimulatorSettings] NOCHECK CONSTRAINT [FK_dbo.FFCameraSimulatorSettings_dbo.FFCameras_CameraId]
GO
ALTER TABLE [dbo].[FFCameraValues]  WITH CHECK ADD  CONSTRAINT [FK_dbo.FFCameraValues_dbo.FFCameras_CameraId] FOREIGN KEY([CameraId])
REFERENCES [dbo].[FFCameras] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFCameraValues] CHECK CONSTRAINT [FK_dbo.FFCameraValues_dbo.FFCameras_CameraId]
GO
ALTER TABLE [dbo].[FFCameraWifiThresValues]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFCameraWifiThresValues_dbo.FFCameras_CameraId] FOREIGN KEY([CameraId])
REFERENCES [dbo].[FFCameras] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFCameraWifiThresValues] NOCHECK CONSTRAINT [FK_dbo.FFCameraWifiThresValues_dbo.FFCameras_CameraId]
GO
ALTER TABLE [dbo].[FFCameraWifiValues]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFCameraWifiValues_dbo.FFCameras_CameraId] FOREIGN KEY([CameraId])
REFERENCES [dbo].[FFCameras] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFCameraWifiValues] NOCHECK CONSTRAINT [FK_dbo.FFCameraWifiValues_dbo.FFCameras_CameraId]
GO
ALTER TABLE [dbo].[FFCameraZones]  WITH CHECK ADD  CONSTRAINT [FK_dbo.FFCameraZones_dbo.FFBranchFloors_FFBranchFloor_ID] FOREIGN KEY([FFBranchFloor_ID])
REFERENCES [dbo].[FFBranchFloors] ([ID])
GO
ALTER TABLE [dbo].[FFCameraZones] CHECK CONSTRAINT [FK_dbo.FFCameraZones_dbo.FFBranchFloors_FFBranchFloor_ID]
GO
ALTER TABLE [dbo].[FFCrossShoppers]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFCrossShoppers_dbo.FFBranches_BranchId] FOREIGN KEY([BranchId])
REFERENCES [dbo].[FFBranches] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFCrossShoppers] NOCHECK CONSTRAINT [FK_dbo.FFCrossShoppers_dbo.FFBranches_BranchId]
GO
ALTER TABLE [dbo].[FFEmailReports]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFEmailReports_dbo.FFReports_ReportId] FOREIGN KEY([ReportId])
REFERENCES [dbo].[FFReports] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFEmailReports] NOCHECK CONSTRAINT [FK_dbo.FFEmailReports_dbo.FFReports_ReportId]
GO
ALTER TABLE [dbo].[FFOutsideTraffics]  WITH CHECK ADD  CONSTRAINT [FK_dbo.FFOutsideTraffics_dbo.FFCameras_CameraId] FOREIGN KEY([CameraId])
REFERENCES [dbo].[FFCameras] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFOutsideTraffics] CHECK CONSTRAINT [FK_dbo.FFOutsideTraffics_dbo.FFCameras_CameraId]
GO
ALTER TABLE [dbo].[FFPageAccessCompanies]  WITH CHECK ADD  CONSTRAINT [FK_dbo.FFPageAccessCompanies_dbo.Companies_CompanyId] FOREIGN KEY([CompanyId])
REFERENCES [dbo].[Companies] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFPageAccessCompanies] CHECK CONSTRAINT [FK_dbo.FFPageAccessCompanies_dbo.Companies_CompanyId]
GO
ALTER TABLE [dbo].[FFPageAccesses]  WITH CHECK ADD  CONSTRAINT [FK_dbo.FFPageAccesses_dbo.Users_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[Users] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFPageAccesses] CHECK CONSTRAINT [FK_dbo.FFPageAccesses_dbo.Users_UserId]
GO
ALTER TABLE [dbo].[FFRegions]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFRegions_dbo.Companies_CompanyId] FOREIGN KEY([CompanyId])
REFERENCES [dbo].[Companies] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFRegions] NOCHECK CONSTRAINT [FK_dbo.FFRegions_dbo.Companies_CompanyId]
GO
ALTER TABLE [dbo].[FFUserAccesses]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFUserAccesses_dbo.FFBranches_BranchId] FOREIGN KEY([BranchId])
REFERENCES [dbo].[FFBranches] ([ID])
GO
ALTER TABLE [dbo].[FFUserAccesses] NOCHECK CONSTRAINT [FK_dbo.FFUserAccesses_dbo.FFBranches_BranchId]
GO
ALTER TABLE [dbo].[FFUserAccesses]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFUserAccesses_dbo.Users_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[Users] ([ID])
GO
ALTER TABLE [dbo].[FFUserAccesses] NOCHECK CONSTRAINT [FK_dbo.FFUserAccesses_dbo.Users_UserId]
GO
ALTER TABLE [dbo].[FFVerificationStudyReports]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFVerificationStudyReports_dbo.FFCameras_FFCameraId] FOREIGN KEY([FFCameraId])
REFERENCES [dbo].[FFCameras] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFVerificationStudyReports] NOCHECK CONSTRAINT [FK_dbo.FFVerificationStudyReports_dbo.FFCameras_FFCameraId]
GO
ALTER TABLE [dbo].[FFVerificationStudyReportVideos]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFVerificationStudyReportVideos_dbo.FFVerificationStudyReports_FFVerificationStudyReportId] FOREIGN KEY([FFVerificationStudyReportId])
REFERENCES [dbo].[FFVerificationStudyReports] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFVerificationStudyReportVideos] NOCHECK CONSTRAINT [FK_dbo.FFVerificationStudyReportVideos_dbo.FFVerificationStudyReports_FFVerificationStudyReportId]
GO
ALTER TABLE [dbo].[FFVerificationStudyReportVideos]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFVerificationStudyReportVideos_dbo.FFVideoSchedules_FFVideoScheduleId] FOREIGN KEY([FFVideoScheduleId])
REFERENCES [dbo].[FFVideoSchedules] ([ID])
GO
ALTER TABLE [dbo].[FFVerificationStudyReportVideos] NOCHECK CONSTRAINT [FK_dbo.FFVerificationStudyReportVideos_dbo.FFVideoSchedules_FFVideoScheduleId]
GO
ALTER TABLE [dbo].[FFVideoScheduleLogRemarks]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFVideoScheduleLogRemarks_dbo.FFVideoSchedules_FFVideoScheduleId] FOREIGN KEY([FFVideoScheduleId])
REFERENCES [dbo].[FFVideoSchedules] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFVideoScheduleLogRemarks] NOCHECK CONSTRAINT [FK_dbo.FFVideoScheduleLogRemarks_dbo.FFVideoSchedules_FFVideoScheduleId]
GO
ALTER TABLE [dbo].[FFVideoSchedules]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFVideoSchedules_dbo.FFCameras_FFCameraId] FOREIGN KEY([FFCameraId])
REFERENCES [dbo].[FFCameras] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFVideoSchedules] NOCHECK CONSTRAINT [FK_dbo.FFVideoSchedules_dbo.FFCameras_FFCameraId]
GO
ALTER TABLE [dbo].[FFWifiFootfallCountings]  WITH NOCHECK ADD  CONSTRAINT [FK_dbo.FFWifiFootfallCountings_dbo.FFCameras_CameraId] FOREIGN KEY([CameraId])
REFERENCES [dbo].[FFCameras] ([ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FFWifiFootfallCountings] NOCHECK CONSTRAINT [FK_dbo.FFWifiFootfallCountings_dbo.FFCameras_CameraId]
GO