if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_area]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_area]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_busimode]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_busimode]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_cl_cxtype]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_cl_cxtype]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_cl_yttype]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_cl_yttype]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_cl_zztype]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_cl_zztype]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_corp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_corp]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_custdoc]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_custdoc]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_custdoc_gmcp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_custdoc_gmcp]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_custdoc_kfyh]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_custdoc_kfyh]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_custdoc_sccp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_custdoc_sccp]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_custdoc_sfdz]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_custdoc_sfdz]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_deprod]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_deprod]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_dept]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_dept]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_deptlead]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_deptlead]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_economy]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_economy]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_func]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_func]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_fytype]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_fytype]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_group]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_group]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_groupqx]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_groupqx]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_httype]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_httype]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_hy_house]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_hy_house]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_hy_lb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_hy_lb]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_idfactory]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_idfactory]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_log]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_log]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_paymode]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_paymode]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_role]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_role]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_rpttype]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_rpttype]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_sc_ccda]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_sc_ccda]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_sc_prdclass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_sc_prdclass]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_sc_product]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_sc_product]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_sec_accident]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_sec_accident]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_sec_charge]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_sec_charge]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_sec_check]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_sec_check]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_sec_state]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_sec_state]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_sec_troble]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_sec_troble]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_sec_trostate]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_sec_trostate]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_swlb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_swlb]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_trade]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_trade]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_uscorp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_uscorp]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_usdept]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_usdept]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_user]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_user]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_usgroup]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_usgroup]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_wjhj]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_wjhj]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_wjmj]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_wjmj]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_wjtype]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_wjtype]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_xxrset]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_xxrset]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_zl_determinant]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_zl_determinant]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_zl_prdclass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_zl_prdclass]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_zl_product]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_zl_product]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bd_zl_standard]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bd_zl_standard]

CREATE TABLE [bd_area] (
	[areaid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ar_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ar_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ar_end] [smallint] NULL ,
	[ar_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_area] PRIMARY KEY  CLUSTERED 
	(
		[areaid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_busimode] (
	[busimodeid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[bu_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[bu_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[bu_end] [smallint] NULL ,
	[bu_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_busimode] PRIMARY KEY  CLUSTERED 
	(
		[busimodeid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_cl_cxtype] (
	[cxtypeid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cxtype_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cxtype_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[cxtype_end] [smallint] NULL ,
	[cxtype_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_cl_cxtype] PRIMARY KEY  CLUSTERED 
	(
		[cxtypeid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_cl_yttype] (
	[yttypeid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[yttype_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[yttype_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[yttype_end] [smallint] NULL ,
	[yttype_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_cl_yttype] PRIMARY KEY  CLUSTERED 
	(
		[yttypeid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_cl_zztype] (
	[zztypeid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[zztype_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[zztype_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[zztype_end] [smallint] NULL ,
	[zztype_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_cl_zztype] PRIMARY KEY  CLUSTERED 
	(
		[zztypeid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_corp] (
	[corpid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[co_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[co_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[co_add] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[co_post] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[co_dh] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[co_cz] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[gd_sw] [smallint] NULL ,
	[gd_fw] [smallint] NULL ,
	[co_end] [smallint] NULL ,
	[co_level] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[ts] [datetime] NULL ,
	[co_jgdm] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[basecode] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[co_pro] [smallint] NULL ,
	[co_real] [smallint] NULL ,
	[pk_erp] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[leaderid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_bd_corp] PRIMARY KEY  CLUSTERED 
	(
		[corpid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_custdoc] (
	[custdocid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cu_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cu_name] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cu_jc] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[tradeid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[areaid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[economyid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cu_nsdjh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cu_zczj] [money] NULL ,
	[cu_addr] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cu_frdb] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cu_lxr] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cu_phone] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cu_zz] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cu_sms] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cu_post] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[cu_jyfw] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[corpid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cu_bz] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[cu_type] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	[erpid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[erpcode] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[erpname] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_bd_custdoc] PRIMARY KEY  CLUSTERED 
	(
		[custdocid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_custdoc_gmcp] (
	[gmcpid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[custdocid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[gm_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[gm_ggxh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[gm_dw] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[gm_gml] [money] NULL ,
	[gm_yt] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[gm_bz] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_custdoc_gmcp] PRIMARY KEY  CLUSTERED 
	(
		[gmcpid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_custdoc_kfyh] (
	[kfyhid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[custdocid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[kf_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[kf_addr] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[kf_yhzh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[kf_bz] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[kf_default] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[ts] [datetime] NULL ,
	[dr] [smallint] NULL ,
	CONSTRAINT [PK_bd_custdoc_kfyh] PRIMARY KEY  CLUSTERED 
	(
		[kfyhid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_custdoc_sccp] (
	[sccpid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[custdocid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[sc_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[sc_ggxh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[sc_dw] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[sc_scl] [money] NULL ,
	[sc_bz] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_custdoc_sccp] PRIMARY KEY  CLUSTERED 
	(
		[sccpid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_custdoc_sfdz] (
	[sfdzid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[custdocid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dz_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[dz_addr] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[dz_lxr] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[dz_phone] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[dz_lc] [money] NULL ,
	[dz_yl] [money] NULL ,
	[dz_default] [smallint] NULL ,
	[dz_bz] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[fc] [smallint] NULL ,
	[ts] [datetime] NULL ,
	[dr] [smallint] NULL ,
	CONSTRAINT [PK_bd_custdoc_sfdz] PRIMARY KEY  CLUSTERED 
	(
		[sfdzid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_deprod] (
	[deprodid] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[productid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[deptid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_bd_deprod] PRIMARY KEY  CLUSTERED 
	(
		[deprodid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_dept] (
	[deptid] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[corpid] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[de_code] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[de_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[de_add] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[de_post] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[de_tsdh] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[de_fwdh] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[de_zn] [smallint] NULL ,
	[de_swright] [smallint] NULL ,
	[gd_sw] [smallint] NULL ,
	[gd_fw] [smallint] NULL ,
	[de_end] [smallint] NULL ,
	[de_level] [smallint] NULL ,
	[de_zzsm] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	[dispname1] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[dispname2] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[basecode] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[de_type] [smallint] NULL ,
	[de_real] [smallint] NULL ,
	[pk_erp] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[leaderid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[fzrid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_bd_dept] PRIMARY KEY  CLUSTERED 
	(
		[deptid]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]



CREATE TABLE [bd_deptlead] (
	[id] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[userid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[deptid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_bd_deptlead] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_economy] (
	[economyid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ec_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ec_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ec_end] [smallint] NULL ,
	[ec_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_economy] PRIMARY KEY  CLUSTERED 
	(
		[economyid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_func] (
	[funcid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FU_CODE] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FU_NAME] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[deptid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[userid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[FU_TYPE] [smallint] NULL ,
	[FU_TYPE2] [smallint] NULL ,
	[FU_system] [smallint] NULL ,
	[fu_prog] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[fu_gif] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[fu_end] [smallint] NULL ,
	[fu_level] [smallint] NULL ,
	[fu_width] [int] NULL ,
	[fu_height] [int] NULL ,
	[fu_win] [smallint] NULL ,
	[fu_litgif] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[mis] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	[fu_authorize] [smallint] NULL ,
	[fu_topmenu] [smallint] NULL ,
	[fu_flowbz] [smallint] NULL ,
	[fu_tops] [smallint] NULL ,
	[fu_pnbz] [smallint] NULL ,
	[displayname] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[fu_ctledit] [smallint] NULL ,
	CONSTRAINT [PK_bd_func] PRIMARY KEY  CLUSTERED 
	(
		[funcid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_fytype] (
	[fytypeid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[fytype_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[fytype_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[fytype_end] [smallint] NULL ,
	[fytype_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL 
) ON [PRIMARY]



CREATE TABLE [bd_group] (
	[groupid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[grp_code] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[grp_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[grp_own] [smallint] NULL ,
	[corpid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[mis] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_group] PRIMARY KEY  CLUSTERED 
	(
		[groupid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_groupqx] (
	[groupqxid] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[groupid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[funcid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[qxread] [int] NULL ,
	[qxwrite] [int] NULL ,
	[qxprint] [int] NULL ,
	[qxdownload] [int] NULL ,
	[qxman] [int] NULL ,
	[mis] [smallint] NULL ,
	CONSTRAINT [PK_bd_groupqx] PRIMARY KEY  CLUSTERED 
	(
		[groupqxid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_httype] (
	[httypeid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ty_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ty_name] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ty_end] [smallint] NULL ,
	[ty_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_httype] PRIMARY KEY  CLUSTERED 
	(
		[httypeid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_hy_house] (
	[houseid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[corpid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[house_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[house_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[house_addr] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[house_src] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL 
) ON [PRIMARY]



CREATE TABLE [bd_hy_lb] (
	[lbid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[lb_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[lb_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[lb_end] [smallint] NULL ,
	[lb_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL 
) ON [PRIMARY]



CREATE TABLE [bd_idfactory] (
	[factoryid] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[factorycode] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[factoryvalue] [int] NULL ,
	CONSTRAINT [PK_bdIdfactory] PRIMARY KEY  CLUSTERED 
	(
		[factoryid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_log] (
	[logid] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[userid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[username] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[funcid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[log_text] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[log_date] [datetime] NULL ,
	[log_ip] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[log_mac] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[newsid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_bd_log] PRIMARY KEY  CLUSTERED 
	(
		[logid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_paymode] (
	[paymodeid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pa_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[pa_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[pa_end] [smallint] NULL ,
	[pa_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_paymode] PRIMARY KEY  CLUSTERED 
	(
		[paymodeid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_role] (
	[roleid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ro_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ro_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ro_smsdisplay] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_role] PRIMARY KEY  CLUSTERED 
	(
		[roleid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_rpttype] (
	[rpttypeid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[rpt_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[rpt_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_rpttype] PRIMARY KEY  CLUSTERED 
	(
		[rpttypeid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_sc_ccda] (
	[ccdaid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ccda_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ccda_lb] [smallint] NULL ,
	[ccda_ysfs] [smallint] NULL ,
	[ccda_rl] [money] NULL ,
	[ccda_sywl] [money] NULL ,
	[ccda_scbyl] [money] NULL ,
	[productid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[pk_bm] [smallint] NULL ,
	[corpid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[deptid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_sc_ccda] PRIMARY KEY  CLUSTERED 
	(
		[ccdaid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_sc_prdclass] (
	[prdclassid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[prdclass_name] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[prdclass_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[prdclass_dw] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[prdclass_end] [smallint] NULL ,
	[prdclass_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_sc_prdclass] PRIMARY KEY  CLUSTERED 
	(
		[prdclassid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_sc_product] (
	[productid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[product_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[product_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[erpid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[erpcode] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[prdclassid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[product_dw] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[product_type] [smallint] NULL ,
	[product_hsl] [decimal](18, 6) NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NOT NULL ,
	[ts] [datetime] NULL ,
	[dispflag] [smallint] NULL ,
	CONSTRAINT [PK_bd_sc_product] PRIMARY KEY  CLUSTERED 
	(
		[productid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_sec_accident] (
	[accidentid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[acc_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[acc_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[acc_end] [smallint] NULL ,
	[acc_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_sec_accident] PRIMARY KEY  CLUSTERED 
	(
		[accidentid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_sec_charge] (
	[chargeid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[charge_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[charge_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[charge_end] [smallint] NULL ,
	[charge_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_sec_charge] PRIMARY KEY  CLUSTERED 
	(
		[chargeid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_sec_check] (
	[checkid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[check_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[check_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[check_end] [smallint] NULL ,
	[check_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_sec_check] PRIMARY KEY  CLUSTERED 
	(
		[checkid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_sec_state] (
	[stateid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[st_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[st_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[st_end] [smallint] NULL ,
	[st_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_sec_state] PRIMARY KEY  CLUSTERED 
	(
		[stateid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_sec_troble] (
	[trobleid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[tro_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[tro_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[tro_end] [smallint] NULL ,
	[tro_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_sec_troble] PRIMARY KEY  CLUSTERED 
	(
		[trobleid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_sec_trostate] (
	[stateid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[st_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[st_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[st_end] [smallint] NULL ,
	[st_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_sec_trostate] PRIMARY KEY  CLUSTERED 
	(
		[stateid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_swlb] (
	[swlbid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[lb_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[lb_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	[basecode] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[billroleid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_bd_swlb] PRIMARY KEY  CLUSTERED 
	(
		[swlbid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_trade] (
	[tradeid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[tr_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[tr_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[tr_end] [smallint] NULL ,
	[tr_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	[tr_oldcode] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_bd_trade] PRIMARY KEY  CLUSTERED 
	(
		[tradeid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_uscorp] (
	[uscorpid] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[userid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[corpid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[mis] [smallint] NULL ,
	CONSTRAINT [PK_bd_uscorp] PRIMARY KEY  CLUSTERED 
	(
		[uscorpid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_usdept] (
	[usdeptid] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[userid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[deptid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[mis] [smallint] NULL ,
	CONSTRAINT [PK_bd_usdept] PRIMARY KEY  CLUSTERED 
	(
		[usdeptid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_user] (
	[userid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[deptid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[us_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[us_name] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[us_dh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[roleid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[us_pass] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[us_psn] [smallint] NULL ,
	[us_sms] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[us_xb] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[us_zzdh] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[us_sfzh] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[us_email] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[us_add] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[us_post] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[us_css] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[us_menuform] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	[us_mailsize] [smallint] NULL ,
	[pop3_zh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[pop3_passwd] [varchar] (128) COLLATE Chinese_PRC_CI_AS NULL ,
	[us_oldmis] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_bd_user] PRIMARY KEY  CLUSTERED 
	(
		[userid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_usgroup] (
	[usgroupid] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[userid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[groupid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_bd_usgroup] PRIMARY KEY  CLUSTERED 
	(
		[usgroupid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_wjhj] (
	[wjhjid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[hj_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[hj_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_wjhj] PRIMARY KEY  CLUSTERED 
	(
		[wjhjid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_wjmj] (
	[wjmjid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[mj_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[mj_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_wjmj] PRIMARY KEY  CLUSTERED 
	(
		[wjmjid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_wjtype] (
	[wjtypeid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[type_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[type_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_wjtype] PRIMARY KEY  CLUSTERED 
	(
		[wjtypeid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_xxrset] (
	[xxrsetid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[xxr_startdate] [datetime] NULL ,
	[xxr_enddate] [datetime] NOT NULL ,
	[xxr_type] [smallint] NULL ,
	CONSTRAINT [PK_sp_xxrset] PRIMARY KEY  CLUSTERED 
	(
		[xxrsetid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_zl_determinant] (
	[determinantid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[de_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[de_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_zl_determinant] PRIMARY KEY  CLUSTERED 
	(
		[determinantid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_zl_prdclass] (
	[prdclassid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[prdclass_name] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[prdclass_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[prdclass_dw] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[prdclass_end] [smallint] NULL ,
	[prdclass_level] [smallint] NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_zl_prdclass] PRIMARY KEY  CLUSTERED 
	(
		[prdclassid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_zl_product] (
	[productid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[product_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[product_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[product_ggxh] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[product_rule] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[erpid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[erpcode] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[prdclassid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[product_dw] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[product_type] [smallint] NULL ,
	[product_hsl] [decimal](18, 6) NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NOT NULL ,
	[ts] [datetime] NULL ,
	[dispflag] [smallint] NULL ,
	[templateid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_bd_zl_product] PRIMARY KEY  CLUSTERED 
	(
		[productid]
	)  ON [PRIMARY] 
) ON [PRIMARY]



CREATE TABLE [bd_zl_standard] (
	[standardid] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[productid] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[st_code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[st_name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[st_type] [smallint] NULL ,
	[st_top] [decimal](18, 6) NULL ,
	[st_bottom] [decimal](18, 6) NULL ,
	[fc] [smallint] NULL ,
	[dr] [smallint] NULL ,
	[ts] [datetime] NULL ,
	CONSTRAINT [PK_bd_zl_standard] PRIMARY KEY  CLUSTERED 
	(
		[standardid]
	)  ON [PRIMARY] 
) ON [PRIMARY]


INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area001 ','01','北京',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area013 ','13','湖南',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area014 ','14','湖北',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area015 ','15','江西',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area016 ','16','福建',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area018 ','18','浙江',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area02','02','上海',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area020 ','20','江苏',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area021 ','21','安徽',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area022 ','22','陕西',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area023 ','23','河南',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area024 ','24','河北',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area025 ','25','山东',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area026 ','26','山西',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area027 ','27','宁夏',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area03','03','重庆',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area030 ','30','甘肃',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area031 ','31','青海',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area032 ','32','西藏',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area033 ','33','新疆',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area034 ','34','内蒙古',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area035 ','35','天津',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area036 ','36','辽宁',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area037 ','37','吉林',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area038 ','38','黑龙江',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area039 ','39','海南',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area06','06','云南',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area07','07','广西',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area08','08','贵州',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area10','10','广东',1,1,0,0,'2010-01-01');
INSERT INTO bd_area (areaid,ar_code,ar_name,ar_end,ar_level,fc,dr,ts) VALUES ('area12','12','四川',1,1,0,0,'2010-01-01');

INSERT INTO bd_busimode (busimodeid,bu_code,bu_name,bu_end,bu_level,fc,dr,ts) VALUES ('01','01','收款类',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO bd_busimode (busimodeid,bu_code,bu_name,bu_end,bu_level,fc,dr,ts) VALUES ('02','02','付款类',1,1,0,0,'2010-05-11 14:31:55');
 

INSERT INTO bd_corp (corpid,co_code,co_name,co_add,co_post,co_dh,co_cz,gd_sw,gd_fw,co_end,co_level,dr,fc,ts,co_jgdm,basecode,co_pro,co_real,pk_erp,leaderid) VALUES ('1001','01','昆明优文','','','','',0,0,1,1,0,0,'2011-07-15 11:42:24','','',1,0,'',NULL);

INSERT INTO bd_dept (deptid,corpid,de_code,de_name,de_add,de_post,de_tsdh,de_fwdh,de_zn,de_swright,gd_sw,gd_fw,de_end,de_level,de_zzsm,fc,dr,ts,dispname1,dispname2,basecode,de_type,de_real,pk_erp,leaderid,fzrid) VALUES ('100101','1001','01','综合办','昆明市','650011','','',NULL,0,0,0,1,1,NULL,0,0,'2009-07-22 12:01:01','综合办','昆明优文/综合办','',1,0,'',NULL,NULL);
INSERT INTO bd_dept (deptid,corpid,de_code,de_name,de_add,de_post,de_tsdh,de_fwdh,de_zn,de_swright,gd_sw,gd_fw,de_end,de_level,de_zzsm,fc,dr,ts,dispname1,dispname2,basecode,de_type,de_real,pk_erp,leaderid,fzrid) VALUES ('100102','1001','02','财务部','昆明市','650011','','',NULL,0,0,0,1,1,NULL,0,0,'2009-07-22 12:01:01','财务部','昆明优文/财务部','',1,0,'',NULL,NULL);
INSERT INTO bd_dept (deptid,corpid,de_code,de_name,de_add,de_post,de_tsdh,de_fwdh,de_zn,de_swright,gd_sw,gd_fw,de_end,de_level,de_zzsm,fc,dr,ts,dispname1,dispname2,basecode,de_type,de_real,pk_erp,leaderid,fzrid) VALUES ('100105','1001','05','研发中心','昆明市','650011','','',NULL,0,0,0,1,1,NULL,0,0,'2009-07-22 12:01:01','研发中心','昆明优文/研发中心','',1,0,'',NULL,NULL);
INSERT INTO bd_dept (deptid,corpid,de_code,de_name,de_add,de_post,de_tsdh,de_fwdh,de_zn,de_swright,gd_sw,gd_fw,de_end,de_level,de_zzsm,fc,dr,ts,dispname1,dispname2,basecode,de_type,de_real,pk_erp,leaderid,fzrid) VALUES ('100110','1001','10','市场部','昆明市','650011','','',NULL,1,0,0,1,1,NULL,0,0,'2009-07-22 12:01:01','市场部','昆明优文/市场部','',1,0,'100110',NULL,NULL);
INSERT INTO bd_dept (deptid,corpid,de_code,de_name,de_add,de_post,de_tsdh,de_fwdh,de_zn,de_swright,gd_sw,gd_fw,de_end,de_level,de_zzsm,fc,dr,ts,dispname1,dispname2,basecode,de_type,de_real,pk_erp,leaderid,fzrid) VALUES ('100114','1001','04','营销部','昆明市','650011','','',NULL,0,0,0,1,1,NULL,0,0,'2009-07-22 12:01:01','营销部','昆明优文/营销部','',1,0,'',NULL,NULL);


INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy01 ','01','国有全资',1,1,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy02 ','02','集体全资',1,1,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy03 ','03','股份合作',1,1,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy04 ','04','联营',0,1,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy0401 ','0401','国有联营',1,2,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy0402 ','0402','集体联营',1,2,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy05 ','05','有限责任（公司）',1,1,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy06 ','06','国有独资（公司）',1,1,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy07 ','07','其他有限责任（公司）',1,1,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy08 ','08','股份有限（公司）',1,1,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy09 ','09','私有',0,1,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy0901 ','0901','私有独资',1,2,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy0902 ','0902','私有合伙',1,2,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy0903 ','0903','私营有限责任（公司）',1,2,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy0904 ','0904','私营股份有限（公司）',1,2,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy0905 ','0905','个体经营',1,2,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy0906 ','0906','其他私有',1,2,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy10 ','10','港、澳、台投资',1,1,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy11 ','11','国外投资',1,1,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy13 ','13','中外合资',1,1,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy14 ','14','中外合作',1,1,0,0,'2009-01-01');
INSERT INTO bd_economy (economyid,ec_code,ec_name,ec_end,ec_level,fc,dr,ts) VALUES ('economy15 ','15','外资',1,1,0,0,'2009-01-01');

     
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('01','01','采购合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('02','02','销售合同',1,1,0,0,'2010-05-11 12:59:23');
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('03','18','供电水气热力合同',1,1,0,0,'2010-10-07 22:02:17');
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('04','19','赠与合同',1,1,0,0,'2010-10-07 22:02:24');
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('05','05','借款合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('06','06','租赁合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('07','07','融资租赁合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('08','08','承揽合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('09','04','建设工程合同',1,1,0,0,'2010-10-07 22:01:59');
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('10','03','运输合同',1,1,0,0,'2010-10-07 22:01:32');
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('11','11','技术合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('12','12','保管合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('13','13','仓管合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('14','14','委托合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('15','15','行纪合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('16','16','居间合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO bd_httype (httypeid,ty_code,ty_name,ty_end,ty_level,fc,dr,ts) VALUES ('90','90','其他合同',1,1,0,0,'2009-07-22 12:01:01');

INSERT INTO bd_hy_house (houseid,corpid,house_code,house_name,house_addr,house_src,fc,dr,ts) VALUES ('DEPT86340000000069','1001','01','一号会议室','综合楼3楼301','音响，投影',0,0,'2010-10-08 12:36:58');
INSERT INTO bd_hy_house (houseid,corpid,house_code,house_name,house_addr,house_src,fc,dr,ts) VALUES ('DEPT79930000000070','1001','02','2号会议室 ','综合楼2楼203室','桌椅50套，圆桌',0,0,'2010-10-08 12:37:46');

INSERT INTO bd_hy_lb (lbid,lb_code,lb_name,lb_end,lb_level,fc,dr,ts) VALUES ('BASE14660000000201','01','公司会议',1,1,0,0,'2010-10-06 19:09:00');
INSERT INTO bd_hy_lb (lbid,lb_code,lb_name,lb_end,lb_level,fc,dr,ts) VALUES ('BASE76560000000202','03','部门会议',1,1,0,0,'2010-10-06 19:09:12');
INSERT INTO bd_hy_lb (lbid,lb_code,lb_name,lb_end,lb_level,fc,dr,ts) VALUES ('BASE3370000000205 ','04','集团会议',1,1,0,0,'2010-10-06 19:09:35');
INSERT INTO bd_hy_lb (lbid,lb_code,lb_name,lb_end,lb_level,fc,dr,ts) VALUES ('BASE60800000000206','05','专题会议',1,1,0,0,'2010-10-06 19:10:01');

INSERT INTO bd_idfactory (factoryid,factorycode,factoryvalue) VALUES ('1','CORP',62);

 
INSERT INTO bd_paymode (paymodeid,pa_code,pa_name,pa_end,pa_level,fc,dr,ts) VALUES ('01','01','现金',1,1,0,0,'2010-10-07 22:00:38');
INSERT INTO bd_paymode (paymodeid,pa_code,pa_name,pa_end,pa_level,fc,dr,ts) VALUES ('02','02','支票',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO bd_paymode (paymodeid,pa_code,pa_name,pa_end,pa_level,fc,dr,ts) VALUES ('03','03','汇票',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO bd_paymode (paymodeid,pa_code,pa_name,pa_end,pa_level,fc,dr,ts) VALUES ('04','04','本票',1,1,0,0,'2009-07-22 12:01:01');

INSERT INTO bd_role (roleid,ro_code,ro_name,ro_smsdisplay,fc,dr,ts) VALUES ('00','01','高层领导',1,0,0,'2010-10-21 13:18:56');
INSERT INTO bd_role (roleid,ro_code,ro_name,ro_smsdisplay,fc,dr,ts) VALUES ('001 ','02','部门中层领导',1,0,0,'2010-10-21 13:19:02');
INSERT INTO bd_role (roleid,ro_code,ro_name,ro_smsdisplay,fc,dr,ts) VALUES ('200 ','06','协理、助理',1,0,0,'2010-10-21 13:19:09');
INSERT INTO bd_role (roleid,ro_code,ro_name,ro_smsdisplay,fc,dr,ts) VALUES ('999 ','999 ','员工',1,0,0,'2010-10-21 13:19:15');

 
INSERT INTO bd_swlb (swlbid,lb_code,lb_name,fc,dr,ts,basecode,billroleid) VALUES ('BM','BM','部门收文',0,0,'2010-10-21 11:53:17','BM','SYS000000000456 ');
INSERT INTO bd_swlb (swlbid,lb_code,lb_name,fc,dr,ts,basecode,billroleid) VALUES ('DW','DW','党委类',0,0,'2009-11-30 22:50:47','DW','SYS000000000456 ');
INSERT INTO bd_swlb (swlbid,lb_code,lb_name,fc,dr,ts,basecode,billroleid) VALUES ('GH','GH','工会类',0,0,'2009-11-30 22:51:03','GH','SYS000000000456 ');
INSERT INTO bd_swlb (swlbid,lb_code,lb_name,fc,dr,ts,basecode,billroleid) VALUES ('JW','JW','纪委类',0,0,'2009-11-30 22:51:20','JW','SYS000000000456 ');
INSERT INTO bd_swlb (swlbid,lb_code,lb_name,fc,dr,ts,basecode,billroleid) VALUES ('JY','JY','经营类',0,0,'2009-11-30 22:51:39','JY','SYS000000000456 ');
INSERT INTO bd_swlb (swlbid,lb_code,lb_name,fc,dr,ts,basecode,billroleid) VALUES ('SC','SC','生产类',0,0,'2009-11-30 22:51:57','SC','SYS000000000456 ');
INSERT INTO bd_swlb (swlbid,lb_code,lb_name,fc,dr,ts,basecode,billroleid) VALUES ('TW','TW','团委类',0,0,'2009-11-30 22:52:12','TW','SYS000000000456 ');
INSERT INTO bd_swlb (swlbid,lb_code,lb_name,fc,dr,ts,basecode,billroleid) VALUES ('XZ','XZ','行政类',0,0,'2009-11-30 22:52:34','XZ','SYS000000000456 ');

INSERT INTO bd_trade (tradeid,tr_code,tr_name,tr_end,tr_level,fc,dr,ts,tr_oldcode) VALUES ('trade01 ','01','农、林、牧、渔业',1,1,0,0,'2009-01-01','01');
INSERT INTO bd_trade (tradeid,tr_code,tr_name,tr_end,tr_level,fc,dr,ts,tr_oldcode) VALUES ('trade02 ','02','采掘业',1,1,0,0,'2009-01-01','02');
INSERT INTO bd_trade (tradeid,tr_code,tr_name,tr_end,tr_level,fc,dr,ts,tr_oldcode) VALUES ('trade03 ','03','制造业',1,1,0,0,'2009-01-01','03');
INSERT INTO bd_trade (tradeid,tr_code,tr_name,tr_end,tr_level,fc,dr,ts,tr_oldcode) VALUES ('trade04 ','04','电力煤气水的生产和供应业',1,1,0,0,'2009-01-01','04');
INSERT INTO bd_trade (tradeid,tr_code,tr_name,tr_end,tr_level,fc,dr,ts,tr_oldcode) VALUES ('trade05 ','05','建筑业',1,1,0,0,'2009-01-01','05');
INSERT INTO bd_trade (tradeid,tr_code,tr_name,tr_end,tr_level,fc,dr,ts,tr_oldcode) VALUES ('trade06 ','06','地质勘查业、水利管理业',1,1,0,0,'2009-01-01','06');
INSERT INTO bd_trade (tradeid,tr_code,tr_name,tr_end,tr_level,fc,dr,ts,tr_oldcode) VALUES ('trade07 ','07','交通运输仓储及邮电通信业',1,1,0,0,'2009-01-01','07');
INSERT INTO bd_trade (tradeid,tr_code,tr_name,tr_end,tr_level,fc,dr,ts,tr_oldcode) VALUES ('trade08 ','08','批发和零售贸易、餐饮业',1,1,0,0,'2009-01-01','08');
INSERT INTO bd_trade (tradeid,tr_code,tr_name,tr_end,tr_level,fc,dr,ts,tr_oldcode) VALUES ('trade09 ','09','金融、保险业',1,1,0,0,'2009-01-01','09');
INSERT INTO bd_trade (tradeid,tr_code,tr_name,tr_end,tr_level,fc,dr,ts,tr_oldcode) VALUES ('trade10 ','10','房地产业',1,1,0,0,'2009-01-01','10');
INSERT INTO bd_trade (tradeid,tr_code,tr_name,tr_end,tr_level,fc,dr,ts,tr_oldcode) VALUES ('trade11 ','11','社会服务业',1,1,0,0,'2009-01-01','11');
INSERT INTO bd_trade (tradeid,tr_code,tr_name,tr_end,tr_level,fc,dr,ts,tr_oldcode) VALUES ('trade12 ','12','卫生、体育和社会福利业',1,1,0,0,'2009-01-01','12');
INSERT INTO bd_trade (tradeid,tr_code,tr_name,tr_end,tr_level,fc,dr,ts,tr_oldcode) VALUES ('trade13 ','13','教育文化艺术广播电影电视',1,1,0,0,'2009-01-01','13');
INSERT INTO bd_trade (tradeid,tr_code,tr_name,tr_end,tr_level,fc,dr,ts,tr_oldcode) VALUES ('trade14 ','14','科学研究和综合技术服务业',1,1,0,0,'2009-01-01','14');
INSERT INTO bd_trade (tradeid,tr_code,tr_name,tr_end,tr_level,fc,dr,ts,tr_oldcode) VALUES ('trade15 ','15','国家机关政党机关社会团体',1,1,0,0,'2009-01-01','15');
INSERT INTO bd_trade (tradeid,tr_code,tr_name,tr_end,tr_level,fc,dr,ts,tr_oldcode) VALUES ('trade16 ','16','其他行业',1,1,0,0,'2009-01-01','16');

 
INSERT INTO bd_user (userid,deptid,us_code,us_name,us_dh,roleid,us_pass,us_psn,us_sms,us_xb,us_zzdh,us_sfzh,us_email,us_add,us_post,us_css,us_menuform,fc,dr,ts,us_mailsize,pop3_zh,pop3_passwd,us_oldmis) VALUES ('admin ','100101','admin ','系统管理员','','999 ','6846860684F05029ABCCC09A53CD66F1',9,'',NULL,NULL,NULL,NULL,NULL,NULL,'gree',1,0,0,'2011-07-15 11:40:10',50,'','31a5de18ba7f4e25',NULL);
 

INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC0000000000000002','2090','系统管理','100101','admin',0,1,1,'/jsp/blank.jsp','/images/garrow.gif',0,2,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:51:55',1,1,0,0,0,'合同管理/系统管理',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC0000000000000003','209010','权限管理','100101','admin',0,1,1,'','/images/garrow.gif',0,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 17:22:37',1,1,0,0,0,'合同管理/系统管理/权限管理',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC0000000000000005','209003','基础档案','100101','admin',0,1,1,'','/images/popen.gif',0,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:52:15',1,1,0,0,0,'合同管理/系统管理/基础档案',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC0000000000000023','206010','信息发布','100101','admin',0,1,1,'/oaNews.do?method=whown','/images/gr_fjx.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:51:34',1,1,0,0,0,'合同管理/信息沟通/信息发布',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC0000000000000030','20901002','用户组管理','100101','admin',0,1,1,'/jsp/base/bdGroup_main.jsp','/images/gr_bmgl.gif',1,4,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:53:14',1,1,0,0,0,'合同管理/系统管理/权限管理/用户组管理',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC0000000000000031','20901003','职务档案','100101','admin',0,1,1,'/bdRole.do','/images/gr_rcap.gif',1,4,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:53:19',1,1,0,0,0,'合同管理/系统管理/权限管理/职务档案',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC0000000000000034','20900106','功能节点注册','100101','admin',0,1,1,'/bdFunc.do?mis=2','/images/gr_dbgz.gif',1,4,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:52:10',1,1,0,0,0,'合同管理/系统管理/系统设置/功能节点注册',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC0000000000000051','206011','栏目内容管理','100101','admin',0,1,1,'/jsp/oa/newsWhMain.jsp','/images/gr_rcap.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:51:39',1,1,0,0,0,'合同管理/信息沟通/栏目内容管理',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC0000000000000058','20901010','系统日志','100101','admin',0,1,1,'/bdLog.do?method=seeall','/images/gr_dbgz.gif',1,4,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:53:25',1,1,0,0,0,'合同管理/系统管理/权限管理/系统日志',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000186','209001','系统设置','100101','admin',0,1,1,'','/images/garrow.gif',0,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:52:00',1,1,0,0,0,'合同管理/系统管理/系统设置',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000193','20900311','业务类型','100101','admin',0,1,1,'/bdBusimode.do','/images/gr_4.gif',1,4,0,0,0,'/images/garrow.gif',2,0,0,'2011-11-14 16:52:30',1,1,0,0,0,'合同管理/系统管理/基础档案/业务类型',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000194','20900312','支付方式类别','100101','admin',0,1,1,'/bdPaymode.do','/images/gr_5.gif',1,4,0,0,0,'/images/garrow.gif',2,0,0,'2011-11-14 16:52:35',1,1,0,0,0,'合同管理/系统管理/基础档案/支付方式类别',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000195','20900313','合同类型','100101','admin',0,1,1,'/bdHttype.do','/images/gr_2.gif',1,4,0,0,0,'/images/garrow.gif',2,0,0,'2011-11-14 16:52:41',1,1,0,0,0,'合同管理/系统管理/基础档案/合同类型',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000197','20900314','地区分类','100101','admin',0,1,1,'/bdArea.do','/images/gr_7.gif',1,4,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:52:46',1,1,0,0,0,'合同管理/系统管理/基础档案/地区分类',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000199','20900315','行业分类','100101','admin',0,1,1,'/bdTrade.do','/images/gr_14.gif',1,4,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:52:52',1,1,0,0,0,'合同管理/系统管理/基础档案/行业分类',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000200','20900316','经济类型','100101','admin',0,1,1,'/bdEconomy.do','/images/gr_15.gif',1,4,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:52:57',1,1,0,0,0,'合同管理/系统管理/基础档案/经济类型',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000201','20','合同管理','100101','admin',0,1,1,'/jsp/htgl/htTjfx_waring.jsp','/images/garrow.gif',0,1,0,0,0,'/images/nm_tb7.gif',2,0,0,'2010-10-21 11:10:04',1,1,0,0,0,'合同管理',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000202','2010','台帐管理','100101','admin',0,1,1,'/jsp/ui/SYS75070000004570.jsp','/images/garrow.gif',0,2,0,0,0,'/images/nm_tb7.gif',2,0,0,'2010-10-21 11:10:09',1,1,0,0,0,'合同管理/台帐管理',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000203','201005','合同台帐维护','100101','admin',0,1,1,'/htHtbasedoc.do?method=tzwh','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2008-05-15 13:57:06',1,1,0,0,0,'合同台帐维护',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000204','201006','到货/发货登记','100101','admin',0,1,1,'/htHtbasedoc.do?method=dhys','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2009-06-02 00:01:18',1,1,0,0,0,'到货/发货登记',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000205','201007','收付结算管理','100101','admin',0,1,1,'/htHtbasedoc.do?method=jsqk','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2009-06-02 00:01:13',1,1,0,0,0,'收付结算管理',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000207','201012','合同跟踪授权','100101','admin',0,1,1,'/htHtbasedoc.do?method=gzsq','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2009-06-02 00:00:41',1,1,0,0,0,'合同跟踪授权',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000208','2015','合同查询','100101','admin',0,1,1,'','/images/garrow.gif',0,2,0,0,0,'/images/nm_tb7.gif',2,0,0,'2010-10-21 11:10:19',1,1,0,0,0,'合同管理/合同查询',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000209','201501','合同台帐查询','100101','admin',0,1,1,'/htHtbasedoc.do?method=query','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2010-10-21 11:10:24',1,1,0,0,0,'合同管理/合同查询/合同台帐查询',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000210','201505','执行异常合同查询','100101','admin',0,1,1,'/htHtbasedoc.do?method=ychtcx','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2010-10-21 11:10:30',1,1,0,0,0,'合同管理/合同查询/执行异常合同查询',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000212','201512','合同签订履行概况','100101','admin',0,1,1,'/jsp/htgl/htTjfx_waring.jsp','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2010-10-21 11:10:36',1,1,0,0,0,'合同管理/合同查询/合同签订履行概况',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000215','2020','合同统计','100101','admin',0,1,1,'','/images/garrow.gif',0,2,0,0,0,'/images/nm_tb7.gif',2,0,0,'2010-10-21 11:10:42',1,1,0,0,0,'合同管理/合同统计',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000218','202010','按部门统计','100101','admin',0,1,1,'/htHtbasedoc.do?method=tjhz&tjfs=bm','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2010-10-21 11:11:06',1,1,0,0,0,'合同管理/合同统计/按部门统计',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000219','202011','按部门、业务类型统计','100101','admin',0,1,1,'/htHtbasedoc.do?method=tjhz&tjfs=fl_bm_busi','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2010-10-21 11:11:11',1,1,0,0,0,'合同管理/合同统计/按部门、业务类型统计',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000220','202020','按业务类型统计','100101','admin',0,1,1,'/htHtbasedoc.do?method=tjhz&tjfs=busi','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2010-10-21 11:11:23',1,1,0,0,0,'合同管理/合同统计/按业务类型统计',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000221','202021','按合同类型统计','100101','admin',0,1,1,'/htHtbasedoc.do?method=tjhz&tjfs=httype','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2010-10-21 11:11:29',1,1,0,0,0,'合同管理/合同统计/按合同类型统计',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000222','202024','按合同状态统计','100101','admin',0,1,1,'/htHtbasedoc.do?method=tjhz&tjfs=htend','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2010-10-21 11:11:35',1,1,0,0,0,'合同管理/合同统计/按合同状态统计',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000224','202012','按部门、合同类型统计','100101','admin',0,1,1,'/htHtbasedoc.do?method=tjhz&tjfs=fl_bm_httype','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2010-10-21 11:11:17',1,1,0,0,0,'合同管理/合同统计/按部门、合同类型统计',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000227','202040','合同信息完整性检查','100101','admin',0,1,1,'/htHtbasedoc.do?method=tjhz&tjfs=jc_bm','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2010-10-30 10:42:02',1,1,0,0,0,'合同管理/合同统计/合同信息完整性检查',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000435','20901012','在线用户','100101','admin',0,1,1,'/jsp/pub/onLineUser.jsp','/images/garrow.gif',1,4,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:53:29',1,1,0,0,0,'合同管理/系统管理/权限管理/在线用户',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC000000000441','201001','客商档案管理','100101','admin',0,1,1,'/jsp/base/bdCustdocMain.jsp','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2010-10-20 15:50:10',1,1,0,0,0,'合同管理/合同管理/台帐管理/客商档案管理',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC10370000000468','206001','内部邮件','100101','admin',0,1,1,'/jsp/mail/mail_main.jsp','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:51:29',1,1,0,0,0,'合同管理/信息沟通/内部邮件',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC22780000000465','206020','通知、公告','100101','admin',0,0,0,'','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:51:43',0,1,0,2,0,'合同管理/信息沟通/通知、公告',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC27860000000464','206021','新闻、简讯','100101','admin',0,0,0,'','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 17:29:25',0,1,0,2,1,'合同管理/信息沟通/新闻、简讯',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC31230000000001','206030','法律法规','100101','admin',0,0,0,'','/images/garrow.gif',1,3,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 17:29:34',0,1,0,2,1,'合同管理/信息沟通/法律法规',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC67950000000571','20900301','单位信息注册','100101','admin',0,1,1,'/bdCorp.do?method=txfswh&opertype=dwda','/images/garrow.gif',1,4,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:52:20',1,1,0,0,0,'合同管理/系统管理/基础档案/单位信息注册',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC69110000000572','20901001','用户管理','100101','admin',0,1,1,'/jsp/base/bdUserBas_Main.jsp','/images/garrow.gif',1,4,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:53:08',1,1,0,0,0,'合同管理/系统管理/权限管理/用户管理',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC75420000000534','20900302','部门档案','100101','admin',0,1,1,'/jsp/base/bdDept_win.jsp','/images/garrow.gif',1,4,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:52:26',1,1,0,0,0,'合同管理/系统管理/基础档案/部门档案',1);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC76760000000463','2060','信息沟通','100101','admin',0,1,1,'','/images/garrow.gif',0,2,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:51:24',1,1,0,0,0,'合同管理/信息沟通',0);
INSERT INTO bd_func (funcid,FU_CODE,FU_NAME,deptid,userid,FU_TYPE,FU_TYPE2,FU_system,fu_prog,fu_gif,fu_end,fu_level,fu_width,fu_height,fu_win,fu_litgif,mis,fc,dr,ts,fu_authorize,fu_topmenu,fu_flowbz,fu_tops,fu_pnbz,displayname,fu_ctledit) VALUES ('FUNC86760000000630','20900101','自定义页面设计','100101','admin',0,1,1,'/sysUi.do?method=list&uiType=0','/images/garrow.gif',1,4,0,0,0,'/images/nm_tb7.gif',2,0,0,'2011-11-14 16:52:05',1,1,0,0,0,'合同管理/系统管理/系统设置/自定义页面设计',1);

INSERT INTO bd_group (groupid,grp_code,grp_name,grp_own,corpid,mis,fc,dr,ts) VALUES ('GROU25310000000107','HT012','部门合同跟踪管理人员',2,'',2,0,0,'2010-10-21 11:18:23');
INSERT INTO bd_group (groupid,grp_code,grp_name,grp_own,corpid,mis,fc,dr,ts) VALUES ('GROU33660000000105','HT010','单位合同管理员',2,'',2,0,0,'2010-10-21 11:15:17');
INSERT INTO bd_group (groupid,grp_code,grp_name,grp_own,corpid,mis,fc,dr,ts) VALUES ('GROU360000000104','HT002','部门中层领导',2,'',2,0,0,'2010-10-21 11:13:35');
INSERT INTO bd_group (groupid,grp_code,grp_name,grp_own,corpid,mis,fc,dr,ts) VALUES ('GROU69590000000106','HT011','部门合同管理员',2,'',2,0,0,'2010-10-21 11:16:11');
INSERT INTO bd_group (groupid,grp_code,grp_name,grp_own,corpid,mis,fc,dr,ts) VALUES ('GROU71320000000001','HT099','系统管理员',9,'',2,0,0,'2011-11-14 11:51:20');
INSERT INTO bd_group (groupid,grp_code,grp_name,grp_own,corpid,mis,fc,dr,ts) VALUES ('GROU75710000000091','HT001','单位高层领导',2,'',2,0,0,'2010-10-07 16:21:31');
INSERT INTO bd_group (groupid,grp_code,grp_name,grp_own,corpid,mis,fc,dr,ts) VALUES ('GROU9550000000108','HT090','合同信息查询用户',2,'',2,0,0,'2010-10-21 11:19:07');

INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d6e0042','GROU71320000000001','FUNC000000000201',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d6e0043','GROU71320000000001','FUNC000000000202',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d6e0044','GROU71320000000001','FUNC000000000441',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d6e0045','GROU71320000000001','FUNC000000000203',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d6e0046','GROU71320000000001','FUNC000000000204',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d6e0047','GROU71320000000001','FUNC000000000205',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d6e0048','GROU71320000000001','FUNC000000000207',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d6e0049','GROU71320000000001','FUNC000000000208',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d6e004a','GROU71320000000001','FUNC000000000209',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d6e004b','GROU71320000000001','FUNC000000000210',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d004c','GROU71320000000001','FUNC000000000212',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d004d','GROU71320000000001','FUNC000000000215',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d004e','GROU71320000000001','FUNC000000000218',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d004f','GROU71320000000001','FUNC000000000219',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0050','GROU71320000000001','FUNC000000000224',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0051','GROU71320000000001','FUNC000000000220',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0052','GROU71320000000001','FUNC000000000221',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0053','GROU71320000000001','FUNC000000000222',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0054','GROU71320000000001','FUNC000000000227',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0055','GROU71320000000001','FUNC76760000000463',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0056','GROU71320000000001','FUNC10370000000468',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0057','GROU71320000000001','FUNC0000000000000023',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0058','GROU71320000000001','FUNC0000000000000051',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0059','GROU71320000000001','FUNC22780000000465',1,1,1,1,1,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d005a','GROU71320000000001','FUNC27860000000464',1,1,1,1,1,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d005b','GROU71320000000001','FUNC31230000000001',1,1,1,1,1,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d005c','GROU71320000000001','FUNC0000000000000002',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d005d','GROU71320000000001','FUNC000000000186',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d005e','GROU71320000000001','FUNC86760000000630',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d005f','GROU71320000000001','FUNC0000000000000034',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0060','GROU71320000000001','FUNC0000000000000005',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0061','GROU71320000000001','FUNC67950000000571',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0062','GROU71320000000001','FUNC75420000000534',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0063','GROU71320000000001','FUNC0000000000000003',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0064','GROU71320000000001','FUNC69110000000572',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0065','GROU71320000000001','FUNC0000000000000030',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0066','GROU71320000000001','FUNC0000000000000031',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0067','GROU71320000000001','FUNC0000000000000058',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('8a98811033a13a490133a1686d7d0068','GROU71320000000001','FUNC000000000435',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a005c','GROU75710000000091','FUNC000000000201',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a005d','GROU75710000000091','FUNC000000000208',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a005e','GROU75710000000091','FUNC000000000209',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a005f','GROU75710000000091','FUNC000000000210',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a0060','GROU75710000000091','FUNC000000000212',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a0061','GROU75710000000091','FUNC000000000215',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a0062','GROU75710000000091','FUNC000000000218',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a0063','GROU75710000000091','FUNC000000000219',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a0064','GROU75710000000091','FUNC000000000224',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a0065','GROU75710000000091','FUNC000000000220',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a0066','GROU75710000000091','FUNC000000000221',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a0067','GROU75710000000091','FUNC000000000222',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a0068','GROU75710000000091','FUNC000000000227',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a0069','GROU75710000000091','FUNC76760000000463',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a006a','GROU75710000000091','FUNC10370000000468',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a006b','GROU75710000000091','FUNC0000000000000023',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a006c','GROU75710000000091','FUNC0000000000000051',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a006d','GROU75710000000091','FUNC22780000000465',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06ebc3a006e','GROU75710000000091','FUNC27860000000464',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edadd0070','GROU360000000104','FUNC000000000201',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edadd0071','GROU360000000104','FUNC000000000202',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edadd0072','GROU360000000104','FUNC000000000207',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edadd0073','GROU360000000104','FUNC000000000208',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edadd0074','GROU360000000104','FUNC000000000209',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edaed0075','GROU360000000104','FUNC000000000210',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edaed0076','GROU360000000104','FUNC000000000212',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edaed0077','GROU360000000104','FUNC000000000215',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edaed0078','GROU360000000104','FUNC000000000218',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edaed0079','GROU360000000104','FUNC000000000219',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edaed007a','GROU360000000104','FUNC000000000224',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edaed007b','GROU360000000104','FUNC000000000220',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edaed007c','GROU360000000104','FUNC000000000221',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edaed007d','GROU360000000104','FUNC000000000222',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edaed007e','GROU360000000104','FUNC000000000227',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edaed007f','GROU360000000104','FUNC76760000000463',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edaed0080','GROU360000000104','FUNC10370000000468',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edaed0081','GROU360000000104','FUNC0000000000000023',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edaed0082','GROU360000000104','FUNC0000000000000051',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edaed0083','GROU360000000104','FUNC22780000000465',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06edaed0084','GROU360000000104','FUNC27860000000464',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f0086','GROU33660000000105','FUNC000000000201',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f0087','GROU33660000000105','FUNC000000000208',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f0088','GROU33660000000105','FUNC000000000209',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f0089','GROU33660000000105','FUNC000000000210',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f008a','GROU33660000000105','FUNC000000000212',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f008b','GROU33660000000105','FUNC000000000215',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f008c','GROU33660000000105','FUNC000000000218',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f008d','GROU33660000000105','FUNC000000000219',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f008e','GROU33660000000105','FUNC000000000224',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f008f','GROU33660000000105','FUNC000000000220',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f0090','GROU33660000000105','FUNC000000000221',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f0091','GROU33660000000105','FUNC000000000222',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f0092','GROU33660000000105','FUNC000000000227',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f0093','GROU33660000000105','FUNC76760000000463',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f0094','GROU33660000000105','FUNC10370000000468',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f0095','GROU33660000000105','FUNC0000000000000023',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f0096','GROU33660000000105','FUNC0000000000000051',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f0097','GROU33660000000105','FUNC22780000000465',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f019f0098','GROU33660000000105','FUNC27860000000464',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c7009a','GROU69590000000106','FUNC000000000201',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c7009b','GROU69590000000106','FUNC000000000202',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c7009c','GROU69590000000106','FUNC000000000441',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c7009d','GROU69590000000106','FUNC000000000203',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c7009e','GROU69590000000106','FUNC000000000204',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c7009f','GROU69590000000106','FUNC000000000205',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c700a0','GROU69590000000106','FUNC000000000207',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c700a1','GROU69590000000106','FUNC000000000208',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c700a2','GROU69590000000106','FUNC000000000209',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c700a3','GROU69590000000106','FUNC000000000210',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c700a4','GROU69590000000106','FUNC000000000212',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c700a5','GROU69590000000106','FUNC000000000215',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c700a6','GROU69590000000106','FUNC000000000218',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c700a7','GROU69590000000106','FUNC000000000219',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c700a8','GROU69590000000106','FUNC000000000224',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c700a9','GROU69590000000106','FUNC000000000220',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c700aa','GROU69590000000106','FUNC000000000221',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c700ab','GROU69590000000106','FUNC000000000222',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c700ac','GROU69590000000106','FUNC000000000227',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c700ad','GROU69590000000106','FUNC76760000000463',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c700ae','GROU69590000000106','FUNC10370000000468',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17c700af','GROU69590000000106','FUNC0000000000000023',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17d700b0','GROU69590000000106','FUNC0000000000000051',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17d700b1','GROU69590000000106','FUNC22780000000465',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f17d700b2','GROU69590000000106','FUNC27860000000464',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f333e00b4','GROU25310000000107','FUNC000000000201',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f333e00b5','GROU25310000000107','FUNC000000000202',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f333e00b6','GROU25310000000107','FUNC000000000441',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f333e00b7','GROU25310000000107','FUNC000000000203',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00b8','GROU25310000000107','FUNC000000000204',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00b9','GROU25310000000107','FUNC000000000205',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00ba','GROU25310000000107','FUNC000000000208',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00bb','GROU25310000000107','FUNC000000000209',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00bc','GROU25310000000107','FUNC000000000210',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00bd','GROU25310000000107','FUNC000000000212',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00be','GROU25310000000107','FUNC000000000215',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00bf','GROU25310000000107','FUNC000000000218',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00c0','GROU25310000000107','FUNC000000000219',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00c1','GROU25310000000107','FUNC000000000224',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00c2','GROU25310000000107','FUNC000000000220',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00c3','GROU25310000000107','FUNC000000000221',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00c4','GROU25310000000107','FUNC000000000222',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00c5','GROU25310000000107','FUNC000000000227',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00c6','GROU25310000000107','FUNC76760000000463',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00c7','GROU25310000000107','FUNC10370000000468',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00c8','GROU25310000000107','FUNC0000000000000023',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00c9','GROU25310000000107','FUNC0000000000000051',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00ca','GROU25310000000107','FUNC22780000000465',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f334e00cb','GROU25310000000107','FUNC27860000000464',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f6db700cd','GROU9550000000108','FUNC000000000201',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f6db700ce','GROU9550000000108','FUNC000000000208',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f6db700cf','GROU9550000000108','FUNC000000000209',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f6db700d0','GROU9550000000108','FUNC000000000210',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f6db700d1','GROU9550000000108','FUNC000000000212',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f6db700d2','GROU9550000000108','FUNC76760000000463',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f6db700d3','GROU9550000000108','FUNC10370000000468',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f6db700d4','GROU9550000000108','FUNC0000000000000023',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f6db700d5','GROU9550000000108','FUNC0000000000000051',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f6db700d6','GROU9550000000108','FUNC22780000000465',1,0,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e30133a06f6db700d7','GROU9550000000108','FUNC27860000000464',1,0,0,0,0,2);

INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e301300193','GROU71320000000001','FUNC000000000193',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e301300194','GROU71320000000001','FUNC000000000194',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e301300195','GROU71320000000001','FUNC000000000195',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e301300197','GROU71320000000001','FUNC000000000197',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e301300199','GROU71320000000001','FUNC000000000199',1,1,0,0,0,2);
INSERT INTO bd_groupqx (groupqxid,groupid,funcid,qxread,qxwrite,qxprint,qxdownload,qxman,mis) VALUES ('ff80808133a026e3013001920','GROU71320000000001','FUNC000000000200',1,1,0,0,0,2);

INSERT INTO bd_usgroup (usgroupid,userid,groupid) VALUES ('ff8080812fa6e09f012fa6f9ef3a00fa','admin','GROU69590000000106');
INSERT INTO bd_usgroup (usgroupid,userid,groupid) VALUES ('ff8080812fa6e09f012fa6f9ef3a00fb','admin','GROU33660000000105');
INSERT INTO bd_usgroup (usgroupid,userid,groupid) VALUES ('sys000000001','admin','GROU71320000000001');

INSERT INTO bd_uscorp (uscorpid,userid,corpid,mis) VALUES ('1111','admin','1001',2);

INSERT INTO bd_usdept (usdeptid,userid,deptid,mis) VALUES ('8a98811033e8b4de0133e8f1ba0501c4','sys001','100110',2);
INSERT INTO bd_usdept (usdeptid,userid,deptid,mis) VALUES ('8a98811033e8b4de0133e8f1ba0501c5','sys001','100105',2);
INSERT INTO bd_usdept (usdeptid,userid,deptid,mis) VALUES ('8a98811033e8b4de0133e8f1ba0501c6','sys001','100114',2);
INSERT INTO bd_usdept (usdeptid,userid,deptid,mis) VALUES ('8a98811033e8b4de0133e8f1ba0501c7','sys001','100102',2);
INSERT INTO bd_usdept (usdeptid,userid,deptid,mis) VALUES ('8a98811033e8b4de0133e8f1ba0501c9','sys001','100101',2);

