USE [StrataFrameSample]

GO

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[NetFlix](

[nf_id] [int] IDENTITY(1,1) NOT NULL,

[nf_title] [nvarchar](50) NOT NULL,

[nf_link] [nvarchar](300) NOT NULL,

[nf_description] [nvarchar](4000) NOT NULL,

[nf_item_id] [int] NOT NULL,

[nf_download_date] [datetime] NOT NULL,

[nf_favorite] [bit] NOT NULL,

[nf_atag] [nvarchar](200) NOT NULL,

[nf_ratedby] [int] NOT NULL CONSTRAINT [DF_NetFlix_ng_ratedby] DEFAULT ((0)),

[nf_score] [float] NOT NULL CONSTRAINT [DF_NetFlix_nf_score] DEFAULT ((0)),

CONSTRAINT [PK_NetFlix] PRIMARY KEY CLUSTERED

[nf_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]

USE [StrataFrameSample]

GO

CREATE UNIQUE NONCLUSTERED INDEX [AK_NetFlix] ON [dbo].[NetFlix]

[nf_title] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

USE [StrataFrameSample]

GO

ALTER TABLE [dbo].[NetFlix] ADD CONSTRAINT [PK_NetFlix] PRIMARY KEY CLUSTERED

[nf_id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]