Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
CREATE TABLE [dbo].[snapshots](
[id] [INT] IDENTITY(1,1) NOT NULL,
[status] [NVARCHAR](4) NOT NULL,
[islast] [BIT] NOT NULL,
[version] [NVARCHAR](500) NULL,
[purge_status] [INT] NULL,
[period1_mode] [NVARCHAR](100) NULL,
[period1_param] [NVARCHAR](100) NULL,
[period2_mode] [NVARCHAR](100) NULL,
[period2_param] [NVARCHAR](100) NULL,
[period3_mode] [NVARCHAR](100) NULL,
[period3_param] [NVARCHAR](100) NULL,
[period4_mode] [NVARCHAR](100) NULL,
[period4_param] [NVARCHAR](100) NULL,
[period5_mode] [NVARCHAR](100) NULL,
[period5_param] [NVARCHAR](100) NULL,
[created_at] [BIGINT] NULL,
[build_date] [BIGINT] NULL,
[period1_date] [BIGINT] NULL,
[period2_date] [BIGINT] NULL,
[period3_date] [BIGINT] NULL,
[period4_date] [BIGINT] NULL,
[period5_date] [BIGINT] NULL,
[component_uuid] [NVARCHAR](50) NOT NULL,
[uuid] [NVARCHAR](50) NOT NULL,
CONSTRAINT [pk_snapshots] 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]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment