I used the auto generated one from SSMS

USE [DB_CW01_SiHu]

GO

/****** Object: Table [dbo].[shops] Script Date: 01/12/2012 13:00:19 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[shops](

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

[bizName] [nvarchar](255) NULL,

[bizPhone] [nvarchar](15) NULL,

[bizURL] [nvarchar](500) NULL,

[bizLogo] [nvarchar](max) NULL,

[clicks] [int] NULL,

[clickReset] [datetime] NULL,

[clickTotal] [int] NULL,

[bizActive] [bit] NOT NULL,

[bizCreated] [datetime] NULL,

[bizRate] [decimal](18, 0) NULL,

[lastPayment] [datetime] NULL,

[userID] [uniqueidentifier] NULL,

[contactName] [nvarchar](250) NULL,

[contactEmail] [nvarchar](250) NULL,

CONSTRAINT [PK_shops] PRIMARY KEY CLUSTERED

(

[bizID] 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].[shops] ADD CONSTRAINT [DF_shops_bizActive] DEFAULT ('False') FOR [bizActive]

GO