1. UserInfo表的创建

use zhongyi
go
IF OBJECT_ID('UserInfos', 'U') IS NOT NULL
DROP TABLE UserInfos;
print'ok'
go
CREATE TABLE [dbo].[UserInfos]

(
[Id] INT NOT NULL PRIMARY KEY,
[UserName] VARCHAR(50) NOT NULL,
[UserPwd] VARCHAR(50) NULL,
[UserState] BIT NULL DEFAULT 1
)