Umbraco Forms Records Setup

CREATE TABLE [dbo].[UFRecords]
(
    [Id]            INT              IDENTITY (1, 1) NOT NULL,
    [Form]          UNIQUEIDENTIFIER NOT NULL,
    [Created]       DATETIME         NOT NULL,
    [Updated]       DATETIME         NOT NULL,
    [CurrentPage]   UNIQUEIDENTIFIER NULL,
    [UmbracoPageId] INT              NULL,
    [IP]            NVARCHAR (255)   NULL,
    [MemberKey]     NVARCHAR (255)   NULL,
    [UniqueId]      UNIQUEIDENTIFIER NOT NULL,
    [State]         NVARCHAR (50)    NULL,
    [RecordData]    NTEXT            NOT NULL,
    CONSTRAINT [PK_UFRecords] 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
CREATE TABLE [dbo].[UFRecordFields]
(
    [Key]      UNIQUEIDENTIFIER NOT NULL,
    [FieldId]  UNIQUEIDENTIFIER NOT NULL,
    [Record]   INT              NOT NULL,
    [Alias]    NVARCHAR (255)   NOT NULL,
    [DataType] NVARCHAR (255)   NOT NULL,
    CONSTRAINT [PK_UFRecordFields] PRIMARY KEY CLUSTERED ([Key] 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
CREATE TABLE [dbo].[UFRecordDataBit]
(
    [Id]    INT              IDENTITY (1, 1) NOT NULL,
    [Key]   UNIQUEIDENTIFIER NOT NULL,
    [Value] BIT              NULL,
    CONSTRAINT [PK_UFRecordDataBit] 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
ALTER TABLE [dbo].[UFRecordDataBit] WITH CHECK
    ADD CONSTRAINT [FK_UFRecordDataBit_UFRecordFields_Key] FOREIGN KEY ([Key]) REFERENCES [dbo].[UFRecordFields] ([Key]) ON DELETE NO ACTION ON UPDATE NO ACTION;


GO
ALTER TABLE [dbo].[UFRecordDataBit] CHECK CONSTRAINT [FK_UFRecordDataBit_UFRecordFields_Key];


GO
CREATE TABLE [dbo].[UFRecordDataDateTime]
(
    [Id]    INT              IDENTITY (1, 1) NOT NULL,
    [Key]   UNIQUEIDENTIFIER NOT NULL,
    [Value] DATETIME         NULL,
    CONSTRAINT [PK_UFRecordDataDateTime] 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
ALTER TABLE [dbo].[UFRecordDataDateTime] WITH CHECK
    ADD CONSTRAINT [FK_UFRecordDataDateTime_UFRecordFields_Key] FOREIGN KEY ([Key]) REFERENCES [dbo].[UFRecordFields] ([Key]) ON DELETE NO ACTION ON UPDATE NO ACTION;


GO
ALTER TABLE [dbo].[UFRecordDataDateTime] CHECK CONSTRAINT [FK_UFRecordDataDateTime_UFRecordFields_Key];


GO
CREATE TABLE [dbo].[UFRecordDataInteger]
(
    [Id]    INT              IDENTITY (1, 1) NOT NULL,
    [Key]   UNIQUEIDENTIFIER NOT NULL,
    [Value] INT              NULL,
    CONSTRAINT [PK_UFRecordDataInteger] 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
ALTER TABLE [dbo].[UFRecordDataInteger] WITH CHECK
    ADD CONSTRAINT [FK_UFRecordDataInteger_UFRecordFields_Key] FOREIGN KEY ([Key]) REFERENCES [dbo].[UFRecordFields] ([Key]) ON DELETE NO ACTION ON UPDATE NO ACTION;


GO
ALTER TABLE [dbo].[UFRecordDataInteger] CHECK CONSTRAINT [FK_UFRecordDataInteger_UFRecordFields_Key];


GO
CREATE TABLE [dbo].[UFRecordDataLongString]
(
    [Id]    INT              IDENTITY (1, 1) NOT NULL,
    [Key]   UNIQUEIDENTIFIER NOT NULL,
    [Value] NTEXT            NULL,
    CONSTRAINT [PK_UFRecordDataLongString] 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].[UFRecordDataLongString] WITH CHECK
    ADD CONSTRAINT [FK_UFRecordDataLongString_UFRecordFields_Key] FOREIGN KEY ([Key]) REFERENCES [dbo].[UFRecordFields] ([Key]) ON DELETE NO ACTION ON UPDATE NO ACTION;


GO
ALTER TABLE [dbo].[UFRecordDataLongString] CHECK CONSTRAINT [FK_UFRecordDataLongString_UFRecordFields_Key];


GO
CREATE TABLE [dbo].[UFRecordDataString]
(
    [Id]    INT              IDENTITY (1, 1) NOT NULL,
    [Key]   UNIQUEIDENTIFIER NOT NULL,
    [Value] NVARCHAR (255)   NOT NULL,
    CONSTRAINT [PK_UFRecordDataString] 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
ALTER TABLE [dbo].[UFRecordDataString] WITH CHECK
    ADD CONSTRAINT [FK_UFRecordDataString_UFRecordFields_Key] FOREIGN KEY ([Key]) REFERENCES [dbo].[UFRecordFields] ([Key]) ON DELETE NO ACTION ON UPDATE NO ACTION;


GO
ALTER TABLE [dbo].[UFRecordDataString] CHECK CONSTRAINT [FK_UFRecordDataString_UFRecordFields_Key];