📄 datainit.sql
字号:
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
/****** 对象: 用户定义的函数 dbo.getUserList 脚本日期: 2007-06-27 16:15:24 ******/
create function getUserList(@RightID int)
returns varchar(8000)
as
begin
declare @UserName varchar(128)
declare @UserNameList varchar(8000)
declare @UserIDList varchar(8000)
declare @UserIDStr varchar(128)
declare @UserIDInt int
set @UserNameList=''
select @UserIDList=substring(replace(js_rightdesc,'^',','),2,len(replace(js_rightdesc,'^',','))-2) from js_right where js_rightid=@RightID
--定义游标
declare UserIDs cursor for
select * from dbo.DefSplit(@UserIDList,',')
open UserIDs
fetch next from UserIDs into @UserIDStr
while @@fetch_status=0
begin
set @UserIDInt=convert(int,@UserIDStr)
set @UserName=''
select @UserName=js_UserName from js_user where js_userid=@UserIDInt
if @UserName<>''
begin
set @UserNameList=@UserNameList+@UserName+']['
end
fetch next from UserIDs into @UserIDStr
end
if(len(ltrim(rtrim(@UserNameList)))>1)
set @UserNameList='['+substring(@UserNameList,1,len(@UserNameList)-1)
return @UserNameList
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
/****** Object: Table [dbo].[Js_EditTest] Script Date: 2007-06-27 16:15:21 ******/
CREATE TABLE [dbo].[Js_EditTest] (
[Js_ID] [int] NOT NULL ,
[Js_Number] [int] NOT NULL ,
[Js_Dec] [decimal](18, 6) NULL ,
[Js_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Js_Date] [datetime] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_Event] Script Date: 2007-06-27 16:15:21 ******/
CREATE TABLE [dbo].[Js_Event] (
[Js_EventID] [int] NOT NULL ,
[Js_EventDesc] [nvarchar] (1024) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_FieldControl] Script Date: 2007-06-27 16:15:21 ******/
CREATE TABLE [dbo].[Js_FieldControl] (
[Js_FieldControlID] [int] NOT NULL ,
[Js_RptID] [int] NOT NULL ,
[Js_FieldName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_FieldDsecID] [int] NOT NULL ,
[Js_FieldDsec] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_FieldLen] [int] NOT NULL ,
[Js_FieldWidth] [int] NOT NULL ,
[Js_FieldAlign] [int] NOT NULL ,
[Js_FieldShowSign] [int] NOT NULL ,
[Js_RightID] [int] NOT NULL ,
[Js_FieldOrderID] [int] NOT NULL ,
[Js_FieldOrderSign] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_FieldDsec] Script Date: 2007-06-27 16:15:22 ******/
CREATE TABLE [dbo].[Js_FieldDsec] (
[Js_FieldDsecID] [int] NOT NULL ,
[Js_FieldTypeID] [int] NOT NULL ,
[Js_FieldDesc] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_FieldDecimal] [int] NOT NULL ,
[Js_FieldDateFormat] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_FieldClassID] [int] NOT NULL ,
[Js_FieldSelType] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_Filt] Script Date: 2007-06-27 16:15:22 ******/
CREATE TABLE [dbo].[Js_Filt] (
[Js_FiltID] [int] NOT NULL ,
[Js_RptID] [int] NOT NULL ,
[Js_FieldControlID] [int] NOT NULL ,
[Js_LinkSign] [int] NOT NULL ,
[Js_Desc] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_OrderID] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_HeaderFooter] Script Date: 2007-06-27 16:15:22 ******/
CREATE TABLE [dbo].[Js_HeaderFooter] (
[Js_HeaderFooterID] [int] NOT NULL ,
[Js_RptID] [int] NOT NULL ,
[Js_hfTypeID] [int] NOT NULL ,
[Js_hfText] [nvarchar] (1024) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_hfFontName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_hfFontSize] [int] NOT NULL ,
[Js_hfFontBold] [int] NOT NULL ,
[Js_hfFontItalic] [int] NOT NULL ,
[Js_hfFontUnderline] [int] NOT NULL ,
[Js_HeaderFooterOrderID] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_InterID] Script Date: 2007-06-27 16:15:22 ******/
CREATE TABLE [dbo].[Js_InterID] (
[FInterID] [int] NOT NULL ,
[FFieldName] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FFieldText] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NULL ,
[FTableName] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FDesc] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_Log] Script Date: 2007-06-27 16:15:22 ******/
CREATE TABLE [dbo].[Js_Log] (
[Js_LogID] [int] NOT NULL ,
[Js_UserID] [int] NOT NULL ,
[Js_Date] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_Time] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_IP] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_Mac] [nvarchar] (17) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_EventID] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_LogonPrecept] Script Date: 2007-06-27 16:15:22 ******/
CREATE TABLE [dbo].[Js_LogonPrecept] (
[Js_LogonPreceptID] [int] NOT NULL ,
[Js_LogonPreceptParentID] [int] NOT NULL ,
[Js_LogonPreceptNumber] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_LogonPreceptType] [int] NOT NULL ,
[Js_LogonPreceptValue] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_LogonPreceptDesc] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_LogonPreceptLevel] [int] NOT NULL ,
[Js_LogonPreceptDetail] [int] NOT NULL ,
[Js_LogonPreceptUseSign] [int] NOT NULL ,
[Js_LogonPreceptUserID] [int] NOT NULL ,
[Js_LogonPreceptDate] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_LogonPreceptTime] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_LogonPreceptClass] Script Date: 2007-06-27 16:15:22 ******/
CREATE TABLE [dbo].[Js_LogonPreceptClass] (
[FItemClassID] [int] NOT NULL ,
[FItemClassName] [nvarchar] (1024) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_Right] Script Date: 2007-06-27 16:15:22 ******/
CREATE TABLE [dbo].[Js_Right] (
[Js_RightID] [int] NOT NULL ,
[Js_RightParentID] [int] NOT NULL ,
[Js_RightNumber] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_RightName] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_RightDesc] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_RightLevel] [int] NOT NULL ,
[Js_RightDetail] [int] NOT NULL ,
[Js_RightUseSign] [int] NOT NULL ,
[Js_RightUserID] [int] NOT NULL ,
[Js_RightDate] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_RightTime] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_RightData] Script Date: 2007-06-27 16:15:22 ******/
CREATE TABLE [dbo].[Js_RightData] (
[FPos] [int] NOT NULL ,
[FParentID] [int] NOT NULL ,
[FParKey] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FNodeType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FKey] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FDesc] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FImg] [int] NOT NULL ,
[FSelImg] [int] NOT NULL ,
[FDisPose] [int] NOT NULL ,
[FIndex] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_Rpt] Script Date: 2007-06-27 16:15:22 ******/
CREATE TABLE [dbo].[Js_Rpt] (
[Js_RptID] [int] NOT NULL ,
[Js_GroupID] [int] NOT NULL ,
[Js_RptName] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_RptDesc] [nvarchar] (1024) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_RptCallName] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_RptWidth] [int] NOT NULL ,
[Js_RptHeight] [int] NOT NULL ,
[Js_RightID] [int] NOT NULL ,
[Js_FiltrateRightID] [int] NOT NULL ,
[Js_ExportRightID] [int] NOT NULL ,
[Js_PrintRightID] [int] NOT NULL ,
[Js_UserID] [int] NOT NULL ,
[Js_Date] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_Time] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_RptGroup] Script Date: 2007-06-27 16:15:23 ******/
CREATE TABLE [dbo].[Js_RptGroup] (
[Js_GroupID] [int] NOT NULL ,
[Js_ParentID] [int] NOT NULL ,
[Js_Number] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_GroupName] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_RptList] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_Desc] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_Level] [int] NOT NULL ,
[Js_Detail] [int] NOT NULL ,
[Js_UseSign] [int] NOT NULL ,
[Js_UserID] [int] NOT NULL ,
[Js_Date] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_Time] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_Ico] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_Sel] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_SysFeildMap] Script Date: 2007-06-27 16:15:23 ******/
CREATE TABLE [dbo].[Js_SysFeildMap] (
[Js_Order] [int] NOT NULL ,
[Js_TypeID] [int] NOT NULL ,
[Js_TypeName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_Table] Script Date: 2007-06-27 16:15:23 ******/
CREATE TABLE [dbo].[Js_Table] (
[Js_TableID] [int] NOT NULL ,
[Js_TableName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_TableDesc] [nvarchar] (1024) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_Title] Script Date: 2007-06-27 16:15:23 ******/
CREATE TABLE [dbo].[Js_Title] (
[Js_TitleID] [int] NOT NULL ,
[Js_RptID] [int] NOT NULL ,
[Js_SRow] [int] NOT NULL ,
[Js_ERow] [int] NOT NULL ,
[Js_SCol] [int] NOT NULL ,
[Js_ECol] [int] NOT NULL ,
[Js_Text] [nvarchar] (1024) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_User] Script Date: 2007-06-27 16:15:23 ******/
CREATE TABLE [dbo].[Js_User] (
[Js_UserID] [int] NOT NULL ,
[Js_UserNumber] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_UserName] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_UserPass] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_UserGroupList] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_LogonPreceptID] [int] NOT NULL ,
[Js_RightID] [int] NOT NULL ,
[Js_Desc] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_UseSign] [int] NOT NULL ,
[Js_HandsetCode] [nvarchar] (11) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_EMailAddr] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_PhoneCode] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_WebAddr] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_UserAdrr] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_MailCode] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_AddUserID] [int] NOT NULL ,
[Js_AddDate] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_AddTime] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_RightList] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Js_UserGroup] Script Date: 2007-06-27 16:15:23 ******/
CREATE TABLE [dbo].[Js_UserGroup] (
[Js_GroupID] [int] NOT NULL ,
[Js_ParentID] [int] NOT NULL ,
[Js_Number] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_GroupName] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_UserList] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_Admin] [int] NOT NULL ,
[Js_RightID] [int] NOT NULL ,
[Js_Desc] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_Level] [int] NOT NULL ,
[Js_Detail] [int] NOT NULL ,
[Js_UseSign] [int] NOT NULL ,
[Js_UserID] [int] NOT NULL ,
[Js_Date] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Js_Time] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Js_EditTest] WITH NOCHECK ADD
CONSTRAINT [PK_Js_EditTest] PRIMARY KEY CLUSTERED
(
[Js_ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Js_Event] WITH NOCHECK ADD
CONSTRAINT [PK_Js_Event] PRIMARY KEY CLUSTERED
(
[Js_EventID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Js_FieldControl] WITH NOCHECK ADD
CONSTRAINT [PK_Js_FieldControl] PRIMARY KEY CLUSTERED
(
[Js_FieldControlID]
) ON [PRIMARY]
GO
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -