row id: 2730	Update_Archive_2962_20231101_060612.ZIP	2023-11-01 06:07:23.073	--Migration_RCCP_20231101_140537.txt
ALTER TABLE [dbo].[QuerySchedulerEntities] ADD [ConnectionName] [nvarchar](max)
ALTER TABLE [dbo].[QuerySchedulerEntities] ADD [SerializedDataSource] [nvarchar](max)
row id: 2720	Update_Archive_2952_20231019_023804.ZIP	2023-10-19 02:43:34.860	--Migration_RCCP_20231019_103730.txt
DECLARE @var0 nvarchar(128)
SELECT @var0 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.ReportSchedulerSettings')
AND col_name(parent_object_id, parent_column_id) = 'SchedulerEntityType';
IF @var0 IS NOT NULL
    EXECUTE('ALTER TABLE [dbo].[ReportSchedulerSettings] DROP CONSTRAINT [' + @var0 + ']')
ALTER TABLE [dbo].[ReportSchedulerSettings] ALTER COLUMN [SchedulerEntityType] [nvarchar](max) NULL


IF NOT EXISTS (SELECT * FROM sys.views WHERE name = 'AreaCameraLinkageView')
BEGIN
    EXEC('
    CREATE VIEW AreaCameraLinkageView AS
    SELECT
        Company.ID AS CompanyID,
        Company.CompanyName,
        Company.CompanyCode,
        Area.BranchId AS BranchID,
        Branch.BranchName,
        Branch.BranchCode,
        Area.id AS AreaID,
        Area.Name AS AreaName,
        Area.AreaType,
        Camera.ID AS CameraId,
        Camera.Serial AS CameraSerial,
        Camera.CameraName,
        AreaConfLineSettings.RoiId,
        AreaConfLineSettings.LineNumber,
        AreaConfLineSettings.IsInLine,
        location.Name AS Location FROM FFAreas Area   
    INNER JOIN FFBranches Branch ON Branch.ID = Area.BranchId   
    INNER JOIN Companies Company ON Branch.CompanyId = Company.ID   
    LEFT JOIN (   
    select AreaConf.AreaId, 
    AreaConf.IsInLine,
    LineSettings.CameraId,   
    LineSettings.LineNumber,
    LineSettings.RoiId from AreaConfigurationSettings AreaConf   
    inner join CameraLineSettings LineSettings on LineSettings.ID = AreaConf.CameraLineId   
    WHERE AreaConf.IsDeleted = 0 AND LineSettings.IsDeleted = 0   
    group by AreaConf.AreaId, LineSettings.CameraId, LineSettings.RoiId, LineSettings.LineNumber, AreaConf.IsInLine ) AreaConfLineSettings   
    ON Area.ID = AreaConfLineSettings.AreaId   
    LEFT JOIN FFCameras Camera 
    ON Camera.ID = AreaConfLineSettings.CameraId   
    LEFT JOIN LocationAreaLinks lal 
    ON lal.AreaId = Area.ID   
    LEFT JOIN (SELECT ID,Name,CompanyID  
    FROM Locations WHERE IsDeleted = 0) location   
    ON location.CompanyID = Company.ID 
    AND lal.LocationId = location.ID 
    WHERE
    Area.IsDeleted = 0
    AND Branch.IsDeleted = 0
    AND Branch.ID != 0
    AND Company.IsDeleted = 0
    AND Company.ID != 0
    AND Area.ID not in (select distinct parentareaid from areagroupingconfigurations)
    ')
END
ELSE
BEGIN
    EXEC('
    ALTER VIEW AreaCameraLinkageView AS
    SELECT
        Company.ID AS CompanyID,
        Company.CompanyName,
        Company.CompanyCode,
        Area.BranchId AS BranchID,
        Branch.BranchName,
        Branch.BranchCode,
        Area.id AS AreaID,
        Area.Name AS AreaName,
        Area.AreaType,
        Camera.ID AS CameraId,
        Camera.Serial AS CameraSerial,
        Camera.CameraName,
        AreaConfLineSettings.RoiId,
        AreaConfLineSettings.LineNumber,
        AreaConfLineSettings.IsInLine,
        location.Name AS Location FROM FFAreas Area   
    INNER JOIN FFBranches Branch ON Branch.ID = Area.BranchId   
    INNER JOIN Companies Company ON Branch.CompanyId = Company.ID   
    LEFT JOIN (   
    select AreaConf.AreaId, 
    AreaConf.IsInLine,
    LineSettings.CameraId,   
    LineSettings.LineNumber,
    LineSettings.RoiId from AreaConfigurationSettings AreaConf   
    inner join CameraLineSettings LineSettings on LineSettings.ID = AreaConf.CameraLineId   
    WHERE AreaConf.IsDeleted = 0 AND LineSettings.IsDeleted = 0   
    group by AreaConf.AreaId, LineSettings.CameraId, LineSettings.RoiId, LineSettings.LineNumber, AreaConf.IsInLine ) AreaConfLineSettings   
    ON Area.ID = AreaConfLineSettings.AreaId   
    LEFT JOIN FFCameras Camera 
    ON Camera.ID = AreaConfLineSettings.CameraId   
    LEFT JOIN LocationAreaLinks lal 
    ON lal.AreaId = Area.ID   
    LEFT JOIN (SELECT ID,Name,CompanyID  
    FROM Locations WHERE IsDeleted = 0) location   
    ON location.CompanyID = Company.ID 
    AND lal.LocationId = location.ID 
    WHERE
    Area.IsDeleted = 0
    AND Branch.IsDeleted = 0
    AND Branch.ID != 0
    AND Company.IsDeleted = 0
    AND Company.ID != 0
    AND Area.ID not in (select distinct parentareaid from areagroupingconfigurations)
    ')
END
row id: 2718	Update_Archive_2950_20231019_005622.ZIP	2023-10-19 01:02:49.127	--Migration_RCCP_20231019_085546.txt
ALTER TABLE [dbo].[QuerySchedulerEntities] ADD [CompanyId] [bigint] NOT NULL DEFAULT 0
DECLARE @var0 nvarchar(128)
SELECT @var0 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.ReportSchedulerSettings')
AND col_name(parent_object_id, parent_column_id) = 'SchedulerEntityId';
IF @var0 IS NOT NULL
    EXECUTE('ALTER TABLE [dbo].[ReportSchedulerSettings] DROP CONSTRAINT [' + @var0 + ']')
ALTER TABLE [dbo].[ReportSchedulerSettings] ALTER COLUMN [SchedulerEntityId] [nvarchar](max) NULL
row id: 2717	Update_Archive_2949_20231017_034152.ZIP	2023-10-17 03:48:36.553	--Migration_RCCP_20231017_114119.txt
CREATE TABLE [dbo].[QuerySchedulerEntities] (
    [ID] [bigint] NOT NULL IDENTITY,
    [QueryName] [nvarchar](max),
    [QueryString] [nvarchar](max),
    [AccessToken] [nvarchar](max),
    CONSTRAINT [PK_dbo.QuerySchedulerEntities] PRIMARY KEY ([ID])
)
CREATE TABLE [dbo].[ReportSchedulerEntities] (
    [ID] [bigint] NOT NULL IDENTITY,
    [ReportId] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.ReportSchedulerEntities] PRIMARY KEY ([ID])
)
ALTER TABLE [dbo].[ReportSchedulerSettings] ADD [SchedulerEntityType] [int] NOT NULL DEFAULT 0
ALTER TABLE [dbo].[ReportSchedulerSettings] ADD [SchedulerEntityId] [bigint] NOT NULL DEFAULT 0
row id: 2709	Update_Archive_2941_20231009_023115.ZIP	2023-10-09 02:37:36.757	--Migration_RCCP_20231009_103039.txt
DECLARE @var0 nvarchar(128)
SELECT @var0 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.CompanyPageLinks')
AND col_name(parent_object_id, parent_column_id) = 'PageId';
IF @var0 IS NOT NULL
    EXECUTE('ALTER TABLE [dbo].[CompanyPageLinks] DROP CONSTRAINT [' + @var0 + ']')
ALTER TABLE [dbo].[CompanyPageLinks] ALTER COLUMN [PageId] [nvarchar](max) NULL
row id: 2702	Update_Archive_2934_20230928_014824.ZIP	2023-09-28 01:54:39.353	--Migration_RCCP_20230928_094750.txt
ALTER TABLE [dbo].[DevicePathmapStatus] ADD [CollectionStartUtcDateTime] [datetime] NOT NULL DEFAULT '1900-01-01T00:00:00.000'
ALTER TABLE [dbo].[DevicePathmapStatus] ADD [CollectionEndUtcDateTime] [datetime] NOT NULL DEFAULT '1900-01-01T00:00:00.000'
row id: 2696	Update_Archive_2928_20230922_025210.ZIP	2023-09-22 02:57:51.820	--Migration_RCCP_20230922_105136.txt
DECLARE @var0 nvarchar(128)
SELECT @var0 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.EntityAccesses')
AND col_name(parent_object_id, parent_column_id) = 'Privacy';
IF @var0 IS NOT NULL
    EXECUTE('ALTER TABLE [dbo].[EntityAccesses] DROP CONSTRAINT [' + @var0 + ']')
ALTER TABLE [dbo].[EntityAccesses] ALTER COLUMN [Privacy] [nvarchar](max) NULL
row id: 2694	Update_Archive_2926_20230921_024928.ZIP	2023-09-21 02:55:16.657	--Migration_RCCP_20230921_104852.txt
CREATE TABLE [dbo].[EntityAccesses] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [EntityType] [int] NOT NULL,
    [EntityTypeId] [nvarchar](max),
    [Privacy] [int] NOT NULL,
    CONSTRAINT [PK_dbo.EntityAccesses] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[UserEntityAccessLinks] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [EntityAccessId] [uniqueidentifier] NOT NULL,
    [UserId] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.UserEntityAccessLinks] PRIMARY KEY ([Id])
)
row id: 2684	Update_Archive_2916_20230912_102907.ZIP	2023-09-12 10:31:27.270	CREATE TABLE [dbo].[DashboardReportInstanceUserLinks] (
    [ID] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [DashboardInstanceId] [bigint] NOT NULL,
    [UserID] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.DashboardReportInstanceUserLinks] PRIMARY KEY ([ID])
)
row id: 2682	Update_Archive_2914_20230912_035344.ZIP	2023-09-12 03:56:42.400	--Migration_RCCP_20230912_115305.txt
ALTER TABLE [dbo].[Users] ADD [ViewV9Layout] [bit] NOT NULL DEFAULT 0
ALTER TABLE [dbo].[CompanySettings] ADD [ViewV9Layout] [bit] NOT NULL DEFAULT 0


row id: 2679	Update_Archive_2911_20230905_095543.ZIP	2023-09-05 09:57:38.540	--Migration_RCCP_20230905_175506.txt
ALTER TABLE [dbo].[AllServerCompanies] ADD [IsDeactivatedFromV9] [bit] NOT NULL DEFAULT 0
row id: 2676	Update_Archive_2908_20230828_044017.ZIP	2023-08-28 04:42:35.720	--Migration_RCCP_20230828_123940.txt
CREATE TABLE [dbo].[PublicUrlAccesses] (
    [Guid] [uniqueidentifier] NOT NULL,
    [Type] [int] NOT NULL,
    [Parameters] [nvarchar](max),
    [SessionHelper] [nvarchar](max),
    [CreatedDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.PublicUrlAccesses] PRIMARY KEY ([Guid])
)
row id: 2668	Update_Archive_2900_20230817_034736.ZIP	2023-08-17 03:49:47.777	--Migration_RCCP_20230817_114657.txt
CREATE TABLE [dbo].[DateCommentDetails] (
   [ID] [bigint] NOT NULL IDENTITY,
   [UserCommentId] [bigint] NOT NULL,
   [StartUtcDateTime] [datetime] NOT NULL,
   [EndUtcDateTime] [datetime] NOT NULL,
   CONSTRAINT [PK_dbo.DateCommentDetails] PRIMARY KEY ([ID])
)
CREATE TABLE [dbo].[EntityCommentDetails] (
   [ID] [bigint] NOT NULL IDENTITY,
    [UserCommentId] [bigint] NOT NULL,
    [EntityType] [int] NOT NULL,
    [EntityId] [nvarchar](max),
    CONSTRAINT [PK_dbo.EntityCommentDetails] PRIMARY KEY ([ID])
)
CREATE TABLE [dbo].[UserComments] (
    [Id] [bigint] NOT NULL IDENTITY,
    [Type] [int] NOT NULL,
    [Comment] [nvarchar](max),
    [CreatedDateTime] [datetime] NOT NULL,
    [EntityType] [int] NOT NULL,
    [EntityId] [nvarchar](max),
    CONSTRAINT [PK_dbo.UserComments] PRIMARY KEY ([Id])
)
ALTER TABLE [dbo].[UserComments] ADD [CompanyId] [bigint] NOT NULL DEFAULT 0
ALTER TABLE [dbo].[UserComments] ADD [UserId] [bigint] NOT NULL DEFAULT 0
ALTER TABLE [dbo].[UserComments] ADD [CreatedUtcDateTime] [datetime] NOT NULL DEFAULT '1900-01-01T00:00:00.000'
DECLARE @var0 nvarchar(128)
SELECT @var0 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.UserComments')
AND col_name(parent_object_id, parent_column_id) = 'CreatedDateTime';
IF @var0 IS NOT NULL
    EXECUTE('ALTER TABLE [dbo].[UserComments] DROP CONSTRAINT [' + @var0 + ']')
ALTER TABLE [dbo].[UserComments] DROP COLUMN [CreatedDateTime]
DECLARE @var1 nvarchar(128)
SELECT @var1 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.UserComments')
AND col_name(parent_object_id, parent_column_id) = 'EntityType';
IF @var1 IS NOT NULL
    EXECUTE('ALTER TABLE [dbo].[UserComments] DROP CONSTRAINT [' + @var1 + ']')
ALTER TABLE [dbo].[UserComments] DROP COLUMN [EntityType]
DECLARE @var2 nvarchar(128)
SELECT @var2 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.UserComments')
AND col_name(parent_object_id, parent_column_id) = 'EntityId';
IF @var2 IS NOT NULL
    EXECUTE('ALTER TABLE [dbo].[UserComments] DROP CONSTRAINT [' + @var2 + ']')
ALTER TABLE [dbo].[UserComments] DROP COLUMN [EntityId]
row id: 2663	Update_Archive_2895_20230810_082816.ZIP	2023-08-10 08:29:25.513	--Migration_RCCP_20230810_162740.txt
ALTER TABLE [dbo].[EslTags] ADD [LastUpdatedDateTimeFromESL] [datetime]
ALTER TABLE [dbo].[EslTags] ADD [ESLStatus] [int] NOT NULL DEFAULT 0

row id: 2661	Update_Archive_2893_20230807_033437.ZIP	2023-08-07 03:36:32.590	--Migration_RCCP_20230807_113358.txt
CREATE TABLE [dbo].[DevicePathmapStatus] (
    [Id] [bigint] NOT NULL IDENTITY,
    [DeviceSerial] [nvarchar](max) NOT NULL,
    [CreatedUtcDateTime] [datetime] NOT NULL,
    [UpdatedUtcDateTime] [datetime] NOT NULL,
    [State] [int] NOT NULL,
    [Remark] [nvarchar](max),
    CONSTRAINT [PK_dbo.DevicePathmapStatus] PRIMARY KEY ([Id])
)


row id: 2659	Update_Archive_2891_20230803_110710.ZIP	2023-08-03 11:09:07.437	--Migration_RCCP_20230803_190632.txt
CREATE TABLE [dbo].[CompanyPageLinks] (
    [Id] [bigint] NOT NULL IDENTITY,
    [CompanyId] [bigint] NOT NULL,
    [PageId] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.CompanyPageLinks] PRIMARY KEY ([Id])
)


row id: 2658	Update_Archive_2890_20230803_012233.ZIP	2023-08-03 01:24:00.240	--Migration_RCCP_20230802_164941.txt
ALTER TABLE [dbo].[AllServerCompanies] ADD [ModifiedIsDeactivated] [bit] NOT NULL DEFAULT 0

row id: 2655	Update_Archive_2887_20230731_062008.ZIP	2023-07-31 06:21:46.890	--Migration_RCCP_20230731_141931.txt
ALTER TABLE [dbo].[DataGridFilterPanelFavourites] ADD [CompanyId] [bigint] NOT NULL DEFAULT 0


row id: 2653	Update_Archive_2885_20230727_105749.ZIP	2023-07-27 10:59:36.457	--Migration_RCCP_20230727_185713.txt
DECLARE @var0 nvarchar(128)
SELECT @var0 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.Vehicles')
AND col_name(parent_object_id, parent_column_id) = 'BranchId';
IF @var0 IS NOT NULL
    EXECUTE('ALTER TABLE [dbo].[Vehicles] DROP CONSTRAINT [' + @var0 + ']')
ALTER TABLE [dbo].[Vehicles] ALTER COLUMN [BranchId] [bigint] NOT NULL
DECLARE @var1 nvarchar(128)
SELECT @var1 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.Vehicles')
AND col_name(parent_object_id, parent_column_id) = 'DriverId';
IF @var1 IS NOT NULL
    EXECUTE('ALTER TABLE [dbo].[Vehicles] DROP CONSTRAINT [' + @var1 + ']')
ALTER TABLE [dbo].[Vehicles] ALTER COLUMN [DriverId] [bigint] NOT NULL


row id: 2652	Update_Archive_2884_20230727_102105.ZIP	2023-07-27 10:23:44.707	--Migration_RCCP_20230727_182028.txt
CREATE TABLE [dbo].[Vehicles] (
    [Id] [nvarchar](128) NOT NULL,
    [LicensePlate] [nvarchar](max),
    [BranchId] [nvarchar](max),
    [DriverId] [nvarchar](max),
    [VehicleName] [nvarchar](max),
    [IsDeleted] [bit] NOT NULL,
    CONSTRAINT [PK_dbo.Vehicles] PRIMARY KEY ([Id])
)


row id: 2651	Update_Archive_2883_20230727_085748.ZIP	2023-07-27 09:00:20.760	--Migration_RCCP_20230727_165705.txt
CREATE TABLE [dbo].[GtfsAgencies] (
    [id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [agency_id] [nvarchar](max),
    [agency_name] [nvarchar](max) NOT NULL,
    [agency_url] [nvarchar](max) NOT NULL,
    [agency_timezone] [nvarchar](max) NOT NULL,
    [agency_lang] [nvarchar](max),
    [agency_phone] [nvarchar](max),
    [agency_fare_url] [nvarchar](max),
    [company_id] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.GtfsAgencies] PRIMARY KEY ([id])
)
CREATE TABLE [dbo].[GtfsCalendars] (
    [id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [service_id] [nvarchar](max) NOT NULL,
    [monday] [int] NOT NULL,
    [tuesday] [int] NOT NULL,
    [wednesday] [int] NOT NULL,
    [thursday] [int] NOT NULL,
    [friday] [int] NOT NULL,
    [saturday] [int] NOT NULL,
    [sunday] [int] NOT NULL,
    [start_date] [datetime] NOT NULL,
    [end_date] [datetime] NOT NULL,
    [company_id] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.GtfsCalendars] PRIMARY KEY ([id])
)
CREATE TABLE [dbo].[GtfsCalendarDates] (
    [id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [service_id] [nvarchar](max) NOT NULL,
    [date] [datetime] NOT NULL,
    [exception_type] [int] NOT NULL,
    [company_id] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.GtfsCalendarDates] PRIMARY KEY ([id])
)
CREATE TABLE [dbo].[GtfsRoutes] (
    [id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [route_id] [nvarchar](max) NOT NULL,
    [agency_id] [nvarchar](max),
    [route_short_name] [nvarchar](max),
    [route_long_name] [nvarchar](max),
    [route_desc] [nvarchar](max),
    [route_type] [int] NOT NULL,
    [route_url] [nvarchar](max),
    [route_color] [nvarchar](max),
    [route_text_color] [nvarchar](max),
    [company_id] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.GtfsRoutes] PRIMARY KEY ([id])
)
CREATE TABLE [dbo].[GtfsShapes] (
    [id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [shape_id] [nvarchar](max) NOT NULL,
    [shape_pt_lat] [float] NOT NULL,
    [shape_pt_lon] [float] NOT NULL,
    [shape_pt_sequence] [int] NOT NULL,
    [shape_dist_traveled] [real] NOT NULL,
    [company_id] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.GtfsShapes] PRIMARY KEY ([id])
)
CREATE TABLE [dbo].[GtfsStops] (
    [id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [stop_id] [nvarchar](max) NOT NULL,
    [stop_code] [nvarchar](max),
    [stop_name] [nvarchar](max),
    [stop_desc] [nvarchar](max),
    [stop_lat] [float] NOT NULL,
    [stop_lon] [float] NOT NULL,
    [zone_id] [nvarchar](max),
    [stop_url] [nvarchar](max),
    [location_type] [int] NOT NULL,
    [parent_station] [nvarchar](max),
    [company_id] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.GtfsStops] PRIMARY KEY ([id])
)
CREATE TABLE [dbo].[GtfsStopTimes] (
    [id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [trip_id] [nvarchar](max),
    [arrival_time] [nvarchar](max),
    [departure_time] [nvarchar](max),
    [stop_id] [nvarchar](max),
    [stop_sequence] [int] NOT NULL,
    [stop_headsign] [nvarchar](max),
    [pickup_type] [int] NOT NULL,
    [drop_off_type] [int] NOT NULL,
    [shape_dist_traveled] [real] NOT NULL,
    [company_id] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.GtfsStopTimes] PRIMARY KEY ([id])
)
CREATE TABLE [dbo].[GtfsTrips] (
    [id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [route_id] [nvarchar](max),
    [service_id] [nvarchar](max),
    [trip_id] [nvarchar](max) NOT NULL,
    [trip_headsign] [nvarchar](max),
    [trip_short_name] [nvarchar](max),
    [direction_id] [int] NOT NULL,
    [block_id] [nvarchar](max),
    [shape_id] [nvarchar](max),
    [wheelchair_accessible] [int] NOT NULL,
    [company_id] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.GtfsTrips] PRIMARY KEY ([id])
)
CREATE INDEX [IX_company_id] ON [dbo].[GtfsAgencies]([company_id])
CREATE INDEX [IX_company_id] ON [dbo].[GtfsCalendars]([company_id])
CREATE INDEX [IX_company_id] ON [dbo].[GtfsCalendarDates]([company_id])
CREATE INDEX [IX_company_id] ON [dbo].[GtfsRoutes]([company_id])
CREATE INDEX [IX_company_id] ON [dbo].[GtfsShapes]([company_id])
CREATE INDEX [IX_company_id] ON [dbo].[GtfsStops]([company_id])
CREATE INDEX [IX_company_id] ON [dbo].[GtfsStopTimes]([company_id])
CREATE INDEX [IX_company_id] ON [dbo].[GtfsTrips]([company_id])
ALTER TABLE [dbo].[GtfsAgencies] ADD CONSTRAINT [FK_dbo.GtfsAgencies_dbo.Companies_company_id] FOREIGN KEY ([company_id]) REFERENCES [dbo].[Companies] ([ID]) ON DELETE CASCADE
ALTER TABLE [dbo].[GtfsCalendars] ADD CONSTRAINT [FK_dbo.GtfsCalendars_dbo.Companies_company_id] FOREIGN KEY ([company_id]) REFERENCES [dbo].[Companies] ([ID]) ON DELETE CASCADE
ALTER TABLE [dbo].[GtfsCalendarDates] ADD CONSTRAINT [FK_dbo.GtfsCalendarDates_dbo.Companies_company_id] FOREIGN KEY ([company_id]) REFERENCES [dbo].[Companies] ([ID]) ON DELETE CASCADE
ALTER TABLE [dbo].[GtfsRoutes] ADD CONSTRAINT [FK_dbo.GtfsRoutes_dbo.Companies_company_id] FOREIGN KEY ([company_id]) REFERENCES [dbo].[Companies] ([ID]) ON DELETE CASCADE
ALTER TABLE [dbo].[GtfsShapes] ADD CONSTRAINT [FK_dbo.GtfsShapes_dbo.Companies_company_id] FOREIGN KEY ([company_id]) REFERENCES [dbo].[Companies] ([ID]) ON DELETE CASCADE
ALTER TABLE [dbo].[GtfsStops] ADD CONSTRAINT [FK_dbo.GtfsStops_dbo.Companies_company_id] FOREIGN KEY ([company_id]) REFERENCES [dbo].[Companies] ([ID]) ON DELETE CASCADE
ALTER TABLE [dbo].[GtfsStopTimes] ADD CONSTRAINT [FK_dbo.GtfsStopTimes_dbo.Companies_company_id] FOREIGN KEY ([company_id]) REFERENCES [dbo].[Companies] ([ID]) ON DELETE CASCADE
ALTER TABLE [dbo].[GtfsTrips] ADD CONSTRAINT [FK_dbo.GtfsTrips_dbo.Companies_company_id] FOREIGN KEY ([company_id]) REFERENCES [dbo].[Companies] ([ID]) ON DELETE CASCADE


row id: 2649	Update_Archive_2881_20230725_044255.ZIP	2023-07-25 04:45:32.537	--Migration_RCCP_20230725_124214.txt
ALTER TABLE [dbo].[Companies] ADD [IsDeactivated] [bit] NOT NULL DEFAULT 0


row id: 2648	Update_Archive_2880_20230725_031441.ZIP	2023-07-25 03:17:38.793	--Migration_RCCP_20230725_111341.txt
CREATE TABLE [dbo].[WidgetInstances] (
    [Id] [bigint] NOT NULL IDENTITY,
    [TemplateId] [bigint] NOT NULL,
    [Name] [nvarchar](max),
    [Configuration] [nvarchar](max),
    [WidgetType] [int] NOT NULL,
    [CompanyId] [bigint] NOT NULL,
    [Parameters] [nvarchar](max),
    CONSTRAINT [PK_dbo.WidgetInstances] PRIMARY KEY ([Id])
)