datainit.sql

本系统是一个报表分析查询系统

ALTER TABLE [dbo].[Js_FieldDsec] WITH NOCHECK ADD 
	CONSTRAINT [PK_Js_FieldDsec] PRIMARY KEY  CLUSTERED 
	(
		[Js_FieldDsecID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Js_Filt] WITH NOCHECK ADD 
	CONSTRAINT [PK_Js_Filt] PRIMARY KEY  CLUSTERED 
	(
		[Js_FiltID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Js_HeaderFooter] WITH NOCHECK ADD 
	CONSTRAINT [PK_Js_HeaderFooter] PRIMARY KEY  CLUSTERED 
	(
		[Js_HeaderFooterID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Js_InterID] WITH NOCHECK ADD 
	CONSTRAINT [PK_Js_InterID] PRIMARY KEY  CLUSTERED 
	(
		[FInterID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Js_Log] WITH NOCHECK ADD 
	CONSTRAINT [PK_Js_LogID] PRIMARY KEY  CLUSTERED 
	(
		[Js_LogID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Js_LogonPrecept] WITH NOCHECK ADD 
	CONSTRAINT [PK_Js_LogonPrecept] PRIMARY KEY  CLUSTERED 
	(
		[Js_LogonPreceptID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Js_LogonPreceptClass] WITH NOCHECK ADD 
	CONSTRAINT [PK_Js_LogonPreceptClass] PRIMARY KEY  CLUSTERED 
	(
		[FItemClassID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Js_Right] WITH NOCHECK ADD 
	CONSTRAINT [PK_Js_Right] PRIMARY KEY  CLUSTERED 
	(
		[Js_RightID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Js_RptGroup] WITH NOCHECK ADD 
	CONSTRAINT [PK_Js_RptGroup] PRIMARY KEY  CLUSTERED 
	(
		[Js_GroupID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Js_SysFeildMap] WITH NOCHECK ADD 
	CONSTRAINT [PK_Js_SysFeildMap] PRIMARY KEY  CLUSTERED 
	(
		[Js_Order]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Js_Table] WITH NOCHECK ADD 
	CONSTRAINT [PK_Js_Table] PRIMARY KEY  CLUSTERED 
	(
		[Js_TableID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Js_Title] WITH NOCHECK ADD 
	CONSTRAINT [PK_Js_Title] PRIMARY KEY  CLUSTERED 
	(
		[Js_TitleID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Js_User] WITH NOCHECK ADD 
	CONSTRAINT [PK_Js_User] PRIMARY KEY  CLUSTERED 
	(
		[Js_UserID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Js_UserGroup] WITH NOCHECK ADD 
	CONSTRAINT [PK_Js_UserGroup] PRIMARY KEY  CLUSTERED 
	(
		[Js_GroupID]
	)  ON [PRIMARY] 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

/****** Object:  Stored Procedure dbo.NewRight    Script Date: 2007-06-27 16:15:23 ******/

CREATE procedure NewRight
 @RightID int,
 @RightParentID int,
 @RightNumber nvarchar(16),
 @RightName nvarchar(512),
 @RightDesc nvarchar(512),
 @RightLevel int,
 @RightDetail int,
 @RightUseSign int,
 @RightUserID int,
 @RightDate nvarchar(10),
 @RightTime nvarchar(8)
as
 insert Js_Right(Js_RightID,Js_RightParentID,Js_RightNumber,Js_RightName,Js_RightDesc,Js_RightLevel,Js_RightDetail,Js_RightUseSign,Js_RightUserID,Js_RightDate,Js_RightTime)
 values(@RightID,@RightParentID,@RightNumber,@RightName,@RightDesc,@RightLevel,@RightDetail,@RightUseSign,@RightUserID,@RightDate,@RightTime)

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

/****** Object:  Stored Procedure dbo.Test    Script Date: 2007-06-27 16:15:23 ******/


CREATE procedure Test
 @Js_UserID nvarchar(1024),
 @Js_UserName nvarchar(1024)
as
 select * from js_user where (js_userid like @Js_UserID) and (Js_UserName like @Js_UserName) 


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

/****** Object:  Stored Procedure dbo.NewEvent    Script Date: 2007-06-27 16:15:23 ******/

CREATE procedure NewEvent
 @EventID int,
 @EventDesc nvarchar(1024)
as
 insert Js_Event(Js_EventID,Js_EventDesc)
  values(@EventID,@EventDesc)

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

/****** Object:  Stored Procedure dbo.NewFieldControl    Script Date: 2007-06-27 16:15:23 ******/

CREATE procedure NewFieldControl
 @FieldControlID int,
 @RptID int,
 @FieldName nvarchar(50),
 @FieldDsecID int,
 @FieldDsec nvarchar(50),
 @FieldLen int,
 @FieldWidth int,
 @FieldAlign int,
 @FieldShowSign int,
 @RightID int,
 @FieldOrderID int,
 @FieldOrderSign int
as
 insert Js_FieldControl(Js_FieldControlID,Js_RptID,Js_FieldName,Js_FieldDsecID,Js_FieldDsec,Js_FieldLen,Js_FieldWidth,Js_FieldAlign,Js_FieldShowSign,Js_RightID,Js_FieldOrderID,Js_FieldOrderSign)
  values(@FieldControlID,@RptID,@FieldName,@FieldDsecID,@FieldDsec,@FieldLen,@FieldWidth,@FieldAlign,@FieldShowSign,@RightID,@FieldOrderID,@FieldOrderSign)

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

/****** Object:  Stored Procedure dbo.NewFieldDsec    Script Date: 2007-06-27 16:15:23 ******/

CREATE procedure NewFieldDsec
 @FieldDsecID int,
 @FieldTypeID int,
 @Js_FieldDesc nvarchar(50),
 @FieldDecimal int,
 @FieldDateFormat nvarchar(50),
 @FieldClassID int,
 @FieldSelType int
as
 insert Js_FieldDsec(Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType)
  values(@FieldDsecID,@FieldTypeID,@Js_FieldDesc,@FieldDecimal,@FieldDateFormat,@FieldClassID,@FieldSelType)

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

/****** Object:  Stored Procedure dbo.NewFilt    Script Date: 2007-06-27 16:15:23 ******/

CREATE procedure NewFilt
 @FiltID int,
 @RptID int,
 @FieldControlID int,
 @LinkSign int,
 @Desc nvarchar(50),
 @OrderID int
as
 insert Js_Filt(Js_FiltID,Js_RptID,Js_FieldControlID,Js_LinkSign,Js_Desc,Js_OrderID)
  values(@FiltID,@RptID,@FieldControlID,@LinkSign,@Desc,@OrderID)

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

/****** Object:  Stored Procedure dbo.NewHeaderFooter    Script Date: 2007-06-27 16:15:23 ******/

CREATE procedure NewHeaderFooter
 @HeaderFooterID int,
 @RptID int,
 @hfTypeID int,
 @hfText nvarchar(1024),
 @hfFontName nvarchar(50),
 @hfFontSize int,
 @hfFontBold int,
 @hfFontItalic int,
 @hfFontUnderline int,
 @HeaderFooterOrderID int
as
 insert Js_HeaderFooter(Js_HeaderFooterID,Js_RptID,Js_hfTypeID,Js_hfText,Js_hfFontName,Js_hfFontSize,Js_hfFontBold,Js_hfFontItalic,Js_hfFontUnderline,Js_HeaderFooterOrderID)
  values(@HeaderFooterID,@RptID,@hfTypeID,@hfText,@hfFontName,@hfFontSize,@hfFontBold,@hfFontItalic,@hfFontUnderline,@HeaderFooterOrderID)

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

/****** Object:  Stored Procedure dbo.NewLog    Script Date: 2007-06-27 16:15:23 ******/

CREATE procedure NewLog
 @LogID int,
 @UserID int,
 @Date nvarchar(10),
 @Time nvarchar(8),
 @IP nvarchar(15),		
 @Mac nvarchar(17),
 @EventID int
as
 insert Js_Log(Js_LogID,Js_UserID,Js_Date,Js_Time,Js_IP,Js_Mac,Js_EventID)
 values(@LogID,@UserID,@Date,@Time,@IP,@Mac,@EventID)

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

/****** Object:  Stored Procedure dbo.NewLogonPrecept    Script Date: 2007-06-27 16:15:23 ******/

CREATE procedure NewLogonPrecept
 @LogonPreceptID int,
 @LogonPreceptParentID int,
 @LogonPreceptNumber nvarchar(16),
 @LogonPreceptType int,
 @LogonPreceptValue nvarchar(4000),
 @LogonPreceptDesc nvarchar(128),
 @LogonPreceptLevel int,
 @LogonPreceptDetail int,
 @LogonPreceptUseSign int,
 @LogonPreceptUserID int,
 @LogonPreceptDate nvarchar(10),
 @LogonPreceptTime nvarchar(8)
as
 insert Js_LogonPrecept(Js_LogonPreceptID,Js_LogonPreceptParentID,Js_LogonPreceptNumber,Js_LogonPreceptType,Js_LogonPreceptValue,Js_LogonPreceptDesc,Js_LogonPreceptLevel,Js_LogonPreceptDetail,Js_LogonPreceptUseSign,Js_LogonPreceptUserID,Js_LogonPreceptDate,Js_LogonPreceptTime)
 values(@LogonPreceptID,@LogonPreceptParentID,@LogonPreceptNumber,@LogonPreceptType,@LogonPreceptValue,@LogonPreceptDesc,@LogonPreceptLevel,@LogonPreceptDetail,@LogonPreceptUseSign,@LogonPreceptUserID,@LogonPreceptDate,@LogonPreceptTime)

GO

SET QUOTED_IDENTIFIER OFF