USE Wish
go
IF exists (SELECT 1 FROM sys.objects WHERE name = 'Users' AND type = 'U')
DROP TABLE [dbo].[Users]
go
CREATE TABLE [dbo].[Users] (
[UserID] INT IDENTITY
CONSTRAINT [PK_Users_UserID] PRIMARY KEY CLUSTERED,
[UserName] [varchar](16) NOT NULL
CONSTRAINT [UK_Users_UserName] UNIQUE ,
[Nickname] [varchar](16) ,
[Password] [varchar] (60) NOT NULL,
[Email] [varchar] (255) ,
[Question] [varchar] (40) NOT NULL,
[Answer] [varchar](40) NOT NULL,
[Sex] [varchar](1)
CONSTRAINT [DF_Users_Sex] DEFAULT 'M',
[ShowEmail] [bit] NOT NULL
CONSTRAINT [DF_Users_ShowEmail] DEFAULT (1),
[Signature] [varchar] (300) NULL ,
[ImageUrl] [varchar] (100) NULL
CONSTRAINT [DF_Users_ImageUrl] DEFAULT ('') ,
[AddedDate] [datetime] NOT NULL
CONSTRAINT [DF_Users_AddedDate] DEFAULT (getdate())
) ON [PRIMARY]
GO