datainit.sql

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

GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

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

CREATE procedure NewRpt
 @RptID int,
 @GroupID int,
 @RptName nvarchar(512),
 @RptDesc nvarchar(1024),
 @RptCallName nvarchar(512),
 @RptWidth int,
 @RptHeight int,
 @RightID int,
 @FiltrateRightID int,
 @ExportRightID int,
 @PrintRightID int,
 @UserID int,
 @Date nvarchar(10),
 @Time nvarchar(8)
as
 insert Js_Rpt(Js_RptID,Js_GroupID,Js_RptName,Js_RptDesc,Js_RptCallName,Js_RptWidth,Js_RptHeight,Js_RightID,Js_FiltrateRightID,Js_ExportRightID,Js_PrintRightID,Js_UserID,Js_Date,Js_Time)
 values(@RptID,@GroupID,@RptName,@RptDesc,@RptCallName,@RptWidth,@RptHeight,@RightID,@FiltrateRightID,@ExportRightID,@PrintRightID,@UserID,@Date,@Time)
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.NewRptGroup    Script Date: 2007-06-27 16:15:23 ******/

CREATE procedure NewRptGroup
 @GroupID int,
 @ParentID int,
 @Number nvarchar(16),
 @GroupName nvarchar(128),
 @RptList nvarchar(4000),
 @Desc nvarchar(512),
 @Level int,
 @Detail int,
 @UseSign int,
 @UserID int,
 @Date nvarchar(10),
 @Time nvarchar(8),
 @Ico nvarchar(128),
 @Sel nvarchar(128)
as
 insert Js_RptGroup(Js_GroupID,Js_ParentID,Js_Number,Js_GroupName,Js_RptList,Js_Desc,Js_Level,Js_Detail,Js_UseSign,Js_UserID,Js_Date,Js_Time,Js_Ico,Js_Sel)
 values(@GroupID,@ParentID,@Number,@GroupName,@RptList,@Desc,@Level,@Detail,@UseSign,@UserID,@Date,@Time,@Ico,@Sel)

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.NewTitle    Script Date: 2007-06-27 16:15:23 ******/

CREATE procedure NewTitle
 @TitleID int,
 @RptID int,
 @SRow int,
 @ERow int,
 @SCol int,
 @ECol int,
 @Text nvarchar(1024)
as
 insert Js_Title(Js_TitleID,Js_RptID,Js_SRow,Js_ERow,Js_SCol,Js_ECol,Js_Text)
 values(@TitleID,@RptID,@SRow,@ERow,@SCol,@ECol,@Text)

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.NewUser    Script Date: 2007-06-27 16:15:23 ******/

CREATE procedure NewUser
 @UserID int,
 @UserNumber nvarchar(16),
 @UserName nvarchar(128),
 @UserPass nvarchar(64),
 @UserGroupList nvarchar(4000),
 @LogonPreceptID int,
 @RightID int,
 @Desc nvarchar(512),
 @UseSign int,
 @HandsetCode nvarchar(11),
 @EMailAddr nvarchar(128),
 @PhoneCode nvarchar(128),
 @WebAddr nvarchar(512),
 @UserAdrr nvarchar(512),
 @MailCode nvarchar(6),
 @AddUserID int,
 @AddDate nvarchar(10),
 @AddTime nvarchar(8),
 @RightList nvarchar(4000)
as
 insert Js_User(Js_UserID,Js_UserNumber,Js_UserName,Js_UserPass,Js_UserGroupList,Js_LogonPreceptID,Js_RightID,Js_Desc,Js_UseSign,Js_HandsetCode,Js_EMailAddr,Js_PhoneCode,Js_WebAddr,Js_UserAdrr,Js_MailCode,Js_AddUserID,Js_AddDate,Js_AddTime,Js_RightList)
 values(@UserID,@UserNumber,@UserName,@UserPass,@UserGroupList,@LogonPreceptID,@RightID,@Desc,@UseSign,@HandsetCode,@EMailAddr,@PhoneCode,@WebAddr,@UserAdrr,@MailCode,@AddUserID,@AddDate,@AddTime,@RightList)
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.NewUserGroup    Script Date: 2007-06-27 16:15:23 ******/

CREATE procedure NewUserGroup
 @GroupID int,
 @ParentID int,
 @Number nvarchar(16),
 @GroupName nvarchar(128),
 @UserList nvarchar(4000),
 @Admin int,
 @RightID int,
 @Desc nvarchar(512),
 @Level int,
 @Detail int,
 @UseSign int,
 @UserID int,
 @Date nvarchar(10),
 @Time nvarchar(8)
as
 insert Js_UserGroup(Js_GroupID,Js_ParentID,Js_Number,Js_GroupName,Js_UserList,Js_Admin,Js_RightID,Js_Desc,Js_Level,Js_Detail,Js_UseSign,Js_UserID,Js_Date,Js_Time)
 values(@GroupID,@ParentID,@Number,@GroupName,@UserList,@Admin,@RightID,@Desc,@Level,@Detail,@UseSign,@UserID,@Date,@Time)

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Trigger dbo.RptDel    Script Date: 2007-06-27 16:15:24 ******/
CREATE TRIGGER RptDel
ON dbo.Js_Rpt
FOR DELETE
AS 
 declare @FInterID int
BEGIN
 select @FInterID=Js_RptID from DELETED
 delete from Js_Title where Js_RptID=@FInterID
 delete from Js_HeaderFooter where Js_RptID=@FInterID
 delete from Js_Filt where Js_RptID=@FInterID
 delete from Js_FieldControl where Js_RptID=@FInterID
END

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

--插入基本数据
--字段描述
insert into Js_FieldDsec (Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType) values (1,0,'字符串',0,'',0,0)
insert into Js_FieldDsec (Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType) values (2,0,'数值',0,'',0,0)
insert into Js_FieldDsec (Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType) values (3,0,'日期',0,'YYYY-MM-DD',0,0)
insert into Js_FieldDsec (Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType) values (4,0,'系统用户',0,'',12,0)
insert into Js_FieldDsec (Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType) values (5,0,'金蝶客户',0,'',0,1)
insert into Js_FieldDsec (Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType) values (6,0,'金蝶部门',0,'',0,2)
insert into Js_FieldDsec (Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType) values (7,0,'金蝶职员',0,'',0,3)
insert into Js_FieldDsec (Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType) values (8,0,'金蝶物料',0,'',0,4)
insert into Js_FieldDsec (Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType) values (9,0,'金蝶仓库',0,'',0,5)
insert into Js_FieldDsec (Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType) values (10,0,'金蝶备注',0,'',0,6)
insert into Js_FieldDsec (Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType) values (11,0,'金蝶计量单位',0,'',0,7)
insert into Js_FieldDsec (Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType) values (12,0,'金蝶供应商',0,'',0,8)
insert into Js_FieldDsec (Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType) values (13,0,'现金流量项目',0,'',0,9)
insert into Js_FieldDsec (Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType) values (14,0,'金蝶分支机构',0,'',0,10)
insert into Js_FieldDsec (Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType) values (15,0,'金蝶编号',0,'',0,4)

GO
--内码对照表
insert into Js_InterID (FInterID,FFieldName,FFieldText,FTableName,FDesc) values (1,'Js_EventID','Js_EventDesc','Js_Event','事件描述表')
insert into Js_InterID (FInterID,FFieldName,FFieldText,FTableName,FDesc) values (2,'Js_FieldControlID','Js_FieldName','Js_FieldControl','字段控制表')
insert into Js_InterID (FInterID,FFieldName,FFieldText,FTableName,FDesc) values (3,'Js_FieldDsecID','Js_FieldDesc','Js_FieldDsec','字段类型表')
insert into Js_InterID (FInterID,FFieldName,FFieldText,FTableName,FDesc) values (4,'Js_FiltID','Js_Desc','Js_Filt','搜索条件表')
insert into Js_InterID (FInterID,FFieldName,FFieldText,FTableName,FDesc) values (5,'Js_HeaderFooterID','Js_hfText','Js_HeaderFooter','页眉页脚表')
insert into Js_InterID (FInterID,FFieldName,FFieldText,FTableName,FDesc) values (6,'Js_LogID','','Js_Log','系统日志表')
insert into Js_InterID (FInterID,FFieldName,FFieldText,FTableName,FDesc) values (7,'Js_LogonPreceptID','Js_LogonPreceptDesc','Js_LogonPrecept','登录方案表')
insert into Js_InterID (FInterID,FFieldName,FFieldText,FTableName,FDesc) values (8,'Js_RightID','Js_RightName','Js_Right','权限方案表')
insert into Js_InterID (FInterID,FFieldName,FFieldText,FTableName,FDesc) values (9,'Js_RptID','Js_RptName','Js_Rpt','系统报表表')
insert into Js_InterID (FInterID,FFieldName,FFieldText,FTableName,FDesc) values (10,'Js_GroupID','Js_GroupName','Js_RptGroup','报表组列表')
insert into Js_InterID (FInterID,FFieldName,FFieldText,FTableName,FDesc) values (11,'Js_TitleID','Js_Text','Js_Title','报表标题表')
insert into Js_InterID (FInterID,FFieldName,FFieldText,FTableName,FDesc) values (12,'Js_UserID','Js_UserName','Js_User','用户记录表')
insert into Js_InterID (FInterID,FFieldName,FFieldText,FTableName,FDesc) values (13,'Js_GroupID','Js_GroupName','Js_UserGroup','用户组列表')

GO
--默认登录方案
insert into 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 (1,0,'0x',0,'2007-06-28','默认登录',1,1,1,1,'2007-06-27','15:44:12')

GO
--用户登录方式
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (0,'不受限制')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (1,'指定日期列表')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (2,'每周指定日期')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (3,'每月指定日期')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (4,'每年指定日期')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (5,'指定时间段')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (6,'指定日期和时间')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (7,'每周日期和时间')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (8,'每月日期和时间')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (9,'每年日期和时间')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (10,'除开指定的日期')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (11,'每周除开指定的日期')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (12,'每月除开指定的日前')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (13,'每年除开指定的日期')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (14,'除开指定的时间段')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (15,'除开指定的日期和时间')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (16,'每周除开指定日期和时间')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (17,'每月除开指定日期和时间')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (18,'每年除开指定日期和时间')
insert into Js_LogonPreceptClass (FItemClassID,FItemClassName) values (19,'禁止登录')

GO
--默认登录权限
insert into 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 (1,0,'0x','默认权限','^1^',1,1,1,1,'2007-06-27','15:43:27')

GO
--系统权限
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (1,0,'','','rptSystem','系统设置',1,2,0,'')
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (2,1,'rptSystem','tvwChild','rptAdmin','超级用户',1,2,1,1)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (3,1,'rptSystem','tvwChild','rptPass','修改密码',1,2,1,2)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (4,1,'rptSystem','tvwChild','rptUserGroup','用_户_组',1,2,1,3)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (5,1,'rptSystem','tvwChild','rptUser','用户管理',1,2,1,4)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (6,1,'rptSystem','tvwChild','rptUserImport','用户导入',1,2,1,5)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (7,1,'rptSystem','tvwChild','rptRptGroup','报_表_组',1,2,1,6)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (8,1,'rptSystem','tvwChild','rptLogin','登录方案',1,2,1,7)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (9,1,'rptSystem','tvwChild','rptRight','权限方案',1,2,1,8)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (10,1,'rptSystem','tvwChild','rptCfgRight','权限配置',1,2,1,9)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (11,1,'rptSystem','tvwChild','rptDataImport','数据导入',1,2,1,10)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (12,1,'rptSystem','tvwChild','rptDataExp','数据导出',1,2,1,11)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (13,1,'rptSystem','tvwChild','rptDataUpdate','数据升级',1,2,1,12)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (14,0,'','','rptDev','报表设计',1,2,0,'')
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (15,1,'rptDev','tvwChild','rptMxDev','报表设计',1,2,1,13)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (16,1,'rptDev','tvwChild','rptList','报表列表',1,2,1,14)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (17,0,'','','rptDataEdit','数据编辑',1,2,0,'')
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (18,1,'rptDataEdit','tvwChild','rptMxDataEdit','数据编辑',1,2,1,15)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (19,0,'','','rptListFunc','列表功能',1,2,0,'')
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (20,1,'rptListFunc','tvwChild','rptExec','执行报表',1,2,1,16)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (21,1,'rptListFunc','tvwChild','rptEditFunc','编辑报表',1,2,1,17)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (22,1,'rptListFunc','tvwChild','rptDel','删除报表',1,2,1,18)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (23,0,'','','rptTEdit','数据编辑',1,2,0,'')
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (24,1,'rptTEdit','tvwChild','rptDataPrint','数据打印',1,2,1,19)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (25,1,'rptTEdit','tvwChild','rptDataFnd','数据搜索',1,2,1,20)
insert into Js_RightData (FPos,FParentID,FParKey,FNodeType,FKey,FDesc,FImg,FSelImg,FDisPose,FIndex) values (26,1,'rptTEdit','tvwChild','rptDataSave','数据保存',1,2,1,21)

GO
--默认报表组
insert into Js_RptGroup (Js_GroupID,Js_ParentID,Js_Number,Js_GroupName,Js_RptList,Js_Desc,Js_Level,Js_Detail,Js_UseSign,Js_UserID,Js_Date,Js_Time,Js_Ico,Js_Sel) values (1,0,'0x','默认报表组','','系统默认报表组',1,1,1,1,'2007-06-27','15:45:06',0,0)

GO
--字段映射表
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (1,3,'int')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (2,6,'money')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (3,131,'decimal')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (4,135,'datetime')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (5,202,'nvarchar')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (6,131,'numeric')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (7,2,'smallint')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (8,11,'bit')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (9,20,'bigint')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (10,129,'char')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (11,128,'binary')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (12,5,'float')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (13,203,'ntext')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (14,200,'varchar')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (15,204,'varbinary')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (16,72,'uniqueidentifier')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (17,17,'tinyint')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (18,128,'timestamp')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (19,201,'text')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (20,12,'sql_variant')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (21,6,'smallmoney')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (22,135,'smalldatetime')
insert into Js_SysFeildMap (Js_Order,Js_TypeID,Js_TypeName) values (23,4,'real')

GO
--数据库编辑表
insert into Js_Table (Js_TableID,Js_TableName,Js_TableDesc) values (1,'Js_Log','系统日值')

GO
--默认用户表
insert into Js_User (Js_UserID,Js_UserNumber,Js_UserName,Js_UserPass,Js_UserGroupList,Js_LogonPreceptID,Js_RightID,Js_Desc,Js_UseSign,Js_HandsetCode,Js_EMailAddr,Js_PhoneCode,Js_WebAddr,Js_UserAdrr,Js_MailCode,Js_AddUserID,Js_AddDate,Js_AddTime,Js_RightList) values (1,'0x','Admin','449083efd7e26af1ea572812cc111157','^1^',1,1,'系统管理人员',1,'13990029080','[e-mail]','8884545','http://www.NewSoft.com','四川省自贡市沿滩区','643000',1,'2007-06-28','16:45:00','1000000011110000001')

GO
--默认用户组表
insert into Js_UserGroup (Js_GroupID,Js_ParentID,Js_Number,Js_GroupName,Js_UserList,Js_Admin,Js_RightID,Js_Desc,Js_Level,Js_Detail,Js_UseSign,Js_UserID,Js_Date,Js_Time) values (1,0,'0x','基础报表','^1^',1,1,'公司基本报表',1,1,1,1,'2007-06-14','09:30:23')

GO