GO
CREATE TABLE [dbo].[ZL_Author](
[ID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [int] NULL CONSTRAINT [DF_ZL_Author_UserID]  DEFAULT (0),
[Type] [nvarchar](50) NULL,
[Name] [nvarchar](50) NULL,
[Passed] [bit] NULL CONSTRAINT [DF_ZL_Author_Passed]  DEFAULT (0),
[onTop] [bit] NULL CONSTRAINT [DF_ZL_Author_onTop]  DEFAULT (0),
[IsElite] [bit] NULL CONSTRAINT [DF_ZL_Author_IsElite]  DEFAULT (0),
[Hits] [int] NULL CONSTRAINT [DF_ZL_Author_Hits]  DEFAULT (0),
[LastUseTime] [datetime] NULL CONSTRAINT [DF_ZL_Author_LastUseTime]  DEFAULT (getdate()),
[TemplateID] [int] NULL CONSTRAINT [DF_ZL_Author_TemplateID]  DEFAULT (0),
[Photo] [nvarchar](255) NULL,
[Intro] [ntext] NULL,
[Address] [nvarchar](50) NULL,
[Tel] [nvarchar](50) NULL,
[Fax] [nvarchar](50) NULL,
[Mail] [nvarchar](50) NULL,
[Email] [nvarchar](50) NULL,
[ZipCode] [int] NULL,
[HomePage] [nvarchar](50) NULL,
[Im] [nvarchar](50) NULL,
[Sex] [smallint] NULL CONSTRAINT [DF_ZL_Author_Sex]  DEFAULT (0),
[BirthDay] [datetime] NULL,
[Company] [nvarchar](50) NULL,
[Department] [nvarchar](50) NULL,
CONSTRAINT [PK_ZL_Author] PRIMARY KEY CLUSTERED
([ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]