
--Migration_RCCP_20240227_100943.txt
CREATE TABLE [dbo].[AreaDatasets] (
    [Id] [bigint] NOT NULL IDENTITY,
    [AreaId] [bigint] NOT NULL,
    [MetricId] [bigint] NOT NULL,
    [MetricDetails] [nvarchar](max),
    [CreatedDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.AreaDatasets] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[MetricTypes] (
    [Id] [bigint] NOT NULL IDENTITY,
    [Details] [nvarchar](max),
    [CreatedDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.MetricTypes] PRIMARY KEY ([Id])
)
ALTER TABLE [dbo].[CameraLineSettings] ADD [DatasetId] [bigint] NOT NULL DEFAULT 0
