- use ECC_USER;
- if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WV_UserInfo]') and OBJECTPROPERTY(id, N'IsView') = 1)
- drop view [dbo].[WV_UserInfo]
- GO
- SET QUOTED_IDENTIFIER OFF
- GO
- SET ANSI_NULLS ON
- GO
- CREATE VIEW dbo.WV_UserInfo
- AS
- SELECT t1.AccountID AS RID, t1.*, t2.Balance AS Balance, t2.LockBal AS LockBal,
- t3.LoginID AS LoginID, t3.LoginPwd AS LoginPwd, t3.Country AS Country,
- t3.City AS City, t3.SeatPhone AS SeatPhone, t3.DefaultPhone AS DefaultPhone,
- t3.SMSTransType AS SMSTransType, t3.SMSPhone AS SMSPhone,
- t3.SMSKeepDay AS SMSKeepDay, t3.HandleNum AS HandleNum,
- t3.IsReject AS IsReject, t3.FaxTransType AS FaxTransType,
- t3.FaxEmail AS FaxEmail, t3.FaxKeepDay AS FaxKeepDay, t3.Name AS Name,
- t3.Description AS Description, t3.SavePWD AS SavePWD, t3.AutoLogin AS AutoLogin,
- t3.MsgAwake AS MsgAwake, t3.AutoCall AS AutoCall, t3.HitMode AS HitMode,
- t3.LoadSMSLog AS LoadSMSLog, t3.LoadCallLog AS LoadCallLog,
- t3.LoadConfLog AS LoadConfLog, t3.LoadLW AS LoadLW,
- t3.LoadOralMsg AS LoadOralMsg, t3.OralMsgSMS AS OralMsgSMS,
- t3.OralMsgPhone AS OralMsgPhone, t3.OralMsgKeepDay AS OralMsgKeepDay,
- t3.NoAnswerLW AS NoAnswerLW, t3.BusyLW AS BusyLW, t3.AllLW AS AllLW,
- t3.LWSize AS LWSize, t3.LWSMS AS LWSMS, t3.LWPhone AS LWPhone,
- t3.LWWelMode AS LWWelMode, t3.SECNumber AS SECNumber,t3.FirstPlayType as FirstPlayType,t3.CallInWake as CallInWake
- FROM dbo.UserInfo t1 INNER JOIN
- dbo.UserBalance t2 ON t1.AccountID = t2.AccountID INNER JOIN
- dbo.UserSetting t3 ON t2.AccountID = t3.AccountID
- GO
- SET QUOTED_IDENTIFIER OFF
- GO
- SET ANSI_NULLS ON
- GO
- GRANT SELECT ON [dbo].[WV_UserInfo] TO [public]
- GO
转载于:https://blog.51cto.com/wen5566/635005