|
|
本帖最后由 shary 于 2011-12-27 13:21 编辑
系统数据库位于sql server 2005下的obpm,另有系统数据库SCDT_DEV.
SCDT_DEV中有用户表SYS_USER,结构如下:
USE [SCDT_DEV]
GO
/****** 对象: Table [dbo].[SYS_USER] 脚本日期: 12/23/2011 11:39:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SYS_USER](
[USER_ID] [nvarchar](12) COLLATE Chinese_PRC_CI_AS NOT NULL,
[USER_NAME] [nvarchar](30) COLLATE Chinese_PRC_CI_AS NULL,
[USER_DESC] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[USER_PASS] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[USER_EMAIL] [nvarchar](64) COLLATE Chinese_PRC_CI_AS NULL,
[ID] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NOT NULL,
[CALENDAR] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[LEVELS] [int] NULL,
[REMARKS] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[SUPERIOR] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[PROXYUSER] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[DEFAULTDEPARTMENT] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[DEFAULTAPPLICATION] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[TELEPHONE] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[STATUS] [int] NULL,
[DOMAINID] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[ISDOMAINUSER] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[STARTPROXYTIME] [datetime] NULL,
[ENDPROXYTIME] [datetime] NULL,
[USEIM] [tinyint] NULL,
[FIELD1] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[FIELD2] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[FIELD3] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[FIELD4] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[FIELD5] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[FIELD6] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[FIELD7] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[FIELD8] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[FIELD9] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[FIELD10] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_SYS_USER] PRIMARY KEY CLUSTERED
(
[USER_ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'User Data' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'SYS_USER'
我在obpm下将T_USER改名为T_USER_BACK, 建VIEW基于以上表:
CREATE VIEW [dbo].[T_USER]
AS
SELECT USER_ID AS LOGINNO, USER_NAME AS NAME, USER_DESC, USER_PASS AS LOGINPWD, USER_EMAIL AS EMAIL, ID, CALENDAR, LEVELS,
REMARKS, SUPERIOR, PROXYUSER, DEFAULTDEPARTMENT, DEFAULTAPPLICATION, TELEPHONE, STATUS, DOMAINID, ISDOMAINUSER,
STARTPROXYTIME, ENDPROXYTIME, USEIM, FIELD1, FIELD2, FIELD3, FIELD4, FIELD5, FIELD6, FIELD7, FIELD8, FIELD9, FIELD10
FROM SCDT_DEV.dbo.SYS_USER
问题是obpm中一些表依赖于T_USER,应该如何处理? |
|