1. 用户ID
2. 用户名
3. 用户密码
4. iChat积分=社区经验值
5. 性别
6. EMAIL
7. QQ
8. 找回密码问题
9. 找回密码答案
10. 最后登陆IP
11. 注册时间
12. 最后登陆时间

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserInfo]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[UserInfo]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE VIEW dbo.UserInfo
AS
SELECT userid AS UserID, username AS UserName, password AS UserPassword,
sex AS UserSex, point AS UserCredit, UserLevel AS UserLevel,
UserEnable AS UserEnable, UserIcon AS UserIcon, UserArming AS UserArming,
email AS UserEmail, qq AS UserOicq, UserPhoto AS UserPhoto,
UserResume AS UserResume, password_question AS UserQuestion,
password_answer AS UserAnswer, last_login_ip AS UserLastIP,
UserMsgCount AS UserMsgCount, reg_datetime AS CreateDate,
last_login_datetime AS ModifyDate, MemberLevel AS MemberLevel
FROM dbo.user_info

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

User_Info表需要添加几个没有相通到的字段