GO
CREATE TABLE [dbo].[ZL_Advertisement](
[ADID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [int] NULL,
[ADType] [int] NULL,
[ADName] [nvarchar](100) NULL,
[ImgUrl] [nvarchar](255) NULL,
[ImgWidth] [int] NULL,
[ImgHeight] [int] NULL,
[FlashWmode] [int] NULL,
[ADIntro] [ntext] NULL,
[LinkUrl] [nvarchar](255) NULL,
[LinkTarget] [int] NULL,
[LinkAlt] [nvarchar](255) NULL,
[Priority] [int] NULL,
[Setting] [ntext] NULL,
[CountView] [bit] NOT NULL,
[Views] [int] NULL,
[CountClick] [bit] NOT NULL,
[Clicks] [int] NULL,
[Passed] [bit] NOT NULL,
[OverdueDate] [datetime] NULL,
[ImgUrl1] [nvarchar](255) NULL,
[ImgHeight1] [int] NULL,
[ImgWidth1] [int] NULL,
[LinkUrl1] [nvarchar](255) NULL,
[LinkTarget1] [int] NULL,
[LinkAlt1] [nvarchar](255) NULL,
[ADIntro1] [ntext] NULL,
[FlashWmode1] [int] NULL,
CONSTRAINT [PK_ZL_Advertisement] PRIMARY KEY CLUSTERED
([ADID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]