
DROP TABLE IF EXISTS `bd_area`;
CREATE TABLE `bd_area` (
  `areaid` char(20) NOT NULL,
  `ar_code` char(20) DEFAULT NULL,
  `ar_name` char(30) DEFAULT NULL,
  `ar_end` smallint(6) DEFAULT NULL,
  `ar_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`areaid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `bd_area` VALUES ('area001','01','北京',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area013','13','湖南',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area014','14','湖北',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area015','15','江西',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area016','16','福建',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area018','18','浙江',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area02','02','上海',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area020','20','江苏',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area021','21','安徽',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area022','22','陕西',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area023','23','河南',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area024','24','河北',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area025','25','山东',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area026','26','山西',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area027','27','宁夏',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area03','03','重庆',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area030','30','甘肃',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area031','31','青海',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area032','32','西藏',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area033','33','新疆',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area034','34','内蒙古',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area035','35','天津',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area036','36','辽宁',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area037','37','吉林',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area038','38','黑龙江',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area039','39','海南',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area06','06','云南',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area07','07','广西',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area08','08','贵州',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area10','10','广东',1,1,0,0,'2010-01-01');
INSERT INTO `bd_area` VALUES ('area12','12','四川',1,1,0,0,'2010-01-01');
DROP TABLE IF EXISTS `bd_busimode`;
CREATE TABLE `bd_busimode` (
  `busimodeid` char(20) NOT NULL,
  `bu_code` char(20) DEFAULT NULL,
  `bu_name` char(30) DEFAULT NULL,
  `bu_end` smallint(6) DEFAULT NULL,
  `bu_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`busimodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `bd_busimode` VALUES ('01','01','收款类',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO `bd_busimode` VALUES ('02','02','付款类',1,1,0,0,'2010-05-11 14:31:55');
DROP TABLE IF EXISTS `bd_cl_cxtype`;
CREATE TABLE `bd_cl_cxtype` (
  `cxtypeid` char(20) NOT NULL,
  `cxtype_code` char(20) DEFAULT NULL,
  `cxtype_name` char(40) DEFAULT NULL,
  `cxtype_end` smallint(6) DEFAULT NULL,
  `cxtype_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`cxtypeid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_cl_yttype`;
CREATE TABLE `bd_cl_yttype` (
  `yttypeid` char(20) NOT NULL,
  `yttype_code` char(20) DEFAULT NULL,
  `yttype_name` char(40) DEFAULT NULL,
  `yttype_end` smallint(6) DEFAULT NULL,
  `yttype_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`yttypeid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_cl_zztype`;
CREATE TABLE `bd_cl_zztype` (
  `zztypeid` char(20) NOT NULL,
  `zztype_code` char(20) DEFAULT NULL,
  `zztype_name` char(40) DEFAULT NULL,
  `zztype_end` smallint(6) DEFAULT NULL,
  `zztype_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`zztypeid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_corp`;
CREATE TABLE `bd_corp` (
  `corpid` char(20) NOT NULL,
  `co_code` char(20) DEFAULT NULL,
  `co_name` char(30) DEFAULT NULL,
  `co_add` varchar(50) DEFAULT NULL,
  `co_post` char(10) DEFAULT NULL,
  `co_dh` char(20) DEFAULT NULL,
  `co_cz` char(20) DEFAULT NULL,
  `gd_sw` smallint(6) DEFAULT NULL,
  `gd_fw` smallint(6) DEFAULT NULL,
  `co_end` smallint(6) DEFAULT NULL,
  `co_level` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `co_jgdm` varchar(60) DEFAULT NULL,
  `basecode` char(20) DEFAULT NULL,
  `co_pro` smallint(6) DEFAULT NULL,
  `co_real` smallint(6) DEFAULT NULL,
  `pk_erp` char(50) DEFAULT NULL,
  `leaderid` char(20) DEFAULT NULL,
  PRIMARY KEY (`corpid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `bd_corp` VALUES ('1001','01','昆明优文','','','','',0,0,1,1,0,0,'2011-07-15 11:42:24','','',1,0,'',NULL);
DROP TABLE IF EXISTS `bd_custdoc`;
CREATE TABLE `bd_custdoc` (
  `custdocid` char(20) NOT NULL,
  `cu_code` char(20) DEFAULT NULL,
  `cu_name` varchar(30) DEFAULT NULL,
  `cu_jc` varchar(30) DEFAULT NULL,
  `tradeid` char(20) DEFAULT NULL,
  `areaid` char(20) DEFAULT NULL,
  `economyid` char(20) DEFAULT NULL,
  `cu_nsdjh` char(30) DEFAULT NULL,
  `cu_zczj` decimal(19,4) DEFAULT NULL,
  `cu_addr` varchar(30) DEFAULT NULL,
  `cu_frdb` char(20) DEFAULT NULL,
  `cu_lxr` char(20) DEFAULT NULL,
  `cu_phone` char(30) DEFAULT NULL,
  `cu_zz` char(30) DEFAULT NULL,
  `cu_sms` char(30) DEFAULT NULL,
  `cu_post` char(10) DEFAULT NULL,
  `cu_jyfw` varchar(100) DEFAULT NULL,
  `corpid` char(20) DEFAULT NULL,
  `cu_bz` varchar(100) DEFAULT NULL,
  `cu_type` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `erpid` char(20) DEFAULT NULL,
  `erpcode` char(30) DEFAULT NULL,
  `erpname` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`custdocid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_custdoc_gmcp`;
CREATE TABLE `bd_custdoc_gmcp` (
  `gmcpid` char(20) NOT NULL,
  `custdocid` char(20) DEFAULT NULL,
  `gm_name` char(30) DEFAULT NULL,
  `gm_ggxh` char(30) DEFAULT NULL,
  `gm_dw` char(10) DEFAULT NULL,
  `gm_gml` decimal(19,4) DEFAULT NULL,
  `gm_yt` char(30) DEFAULT NULL,
  `gm_bz` varchar(100) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`gmcpid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_custdoc_kfyh`;
CREATE TABLE `bd_custdoc_kfyh` (
  `kfyhid` char(20) NOT NULL,
  `custdocid` char(20) DEFAULT NULL,
  `kf_name` char(30) DEFAULT NULL,
  `kf_addr` varchar(30) DEFAULT NULL,
  `kf_yhzh` char(30) DEFAULT NULL,
  `kf_bz` varchar(100) DEFAULT NULL,
  `kf_default` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`kfyhid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_custdoc_sccp`;
CREATE TABLE `bd_custdoc_sccp` (
  `sccpid` char(20) NOT NULL,
  `custdocid` char(20) DEFAULT NULL,
  `sc_name` char(30) DEFAULT NULL,
  `sc_ggxh` char(30) DEFAULT NULL,
  `sc_dw` char(10) DEFAULT NULL,
  `sc_scl` decimal(19,4) DEFAULT NULL,
  `sc_bz` varchar(100) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`sccpid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_custdoc_sfdz`;
CREATE TABLE `bd_custdoc_sfdz` (
  `sfdzid` char(20) NOT NULL,
  `custdocid` char(20) DEFAULT NULL,
  `dz_name` char(30) DEFAULT NULL,
  `dz_addr` varchar(30) DEFAULT NULL,
  `dz_lxr` char(30) DEFAULT NULL,
  `dz_phone` char(30) DEFAULT NULL,
  `dz_lc` decimal(19,4) DEFAULT NULL,
  `dz_yl` decimal(19,4) DEFAULT NULL,
  `dz_default` smallint(6) DEFAULT NULL,
  `dz_bz` varchar(100) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`sfdzid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_deprod`;
CREATE TABLE `bd_deprod` (
  `deprodid` varchar(40) NOT NULL,
  `productid` char(20) DEFAULT NULL,
  `deptid` char(20) DEFAULT NULL,
  PRIMARY KEY (`deprodid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_dept`;
CREATE TABLE `bd_dept` (
  `deptid` varchar(20) NOT NULL,
  `corpid` varchar(20) NOT NULL,
  `de_code` varchar(50) DEFAULT NULL,
  `de_name` varchar(50) DEFAULT NULL,
  `de_add` varchar(50) DEFAULT NULL,
  `de_post` char(10) DEFAULT NULL,
  `de_tsdh` char(20) DEFAULT NULL,
  `de_fwdh` char(20) DEFAULT NULL,
  `de_zn` smallint(6) DEFAULT NULL,
  `de_swright` smallint(6) DEFAULT NULL,
  `gd_sw` smallint(6) DEFAULT NULL,
  `gd_fw` smallint(6) DEFAULT NULL,
  `de_end` smallint(6) DEFAULT NULL,
  `de_level` smallint(6) DEFAULT NULL,
  `de_zzsm` mediumtext,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `dispname1` varchar(100) DEFAULT NULL,
  `dispname2` varchar(100) DEFAULT NULL,
  `basecode` char(6) DEFAULT NULL,
  `de_type` smallint(6) DEFAULT NULL,
  `de_real` smallint(6) DEFAULT NULL,
  `pk_erp` char(50) DEFAULT NULL,
  `leaderid` char(20) DEFAULT NULL,
  `fzrid` char(20) DEFAULT NULL,
  PRIMARY KEY (`deptid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `bd_dept` 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` 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` 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` 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` VALUES ('100114','1001','04','营销部','昆明市','650011','','',NULL,0,0,0,1,1,NULL,0,0,'2009-07-22 12:01:01','营销部','昆明优文/营销部','',1,0,'',NULL,NULL);
DROP TABLE IF EXISTS `bd_deptlead`;
CREATE TABLE `bd_deptlead` (
  `id` varchar(40) NOT NULL,
  `userid` char(20) DEFAULT NULL,
  `deptid` char(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_economy`;
CREATE TABLE `bd_economy` (
  `economyid` char(20) NOT NULL,
  `ec_code` char(20) DEFAULT NULL,
  `ec_name` char(30) DEFAULT NULL,
  `ec_end` smallint(6) DEFAULT NULL,
  `ec_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`economyid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;


DROP TABLE IF EXISTS `bd_func`;
CREATE TABLE `bd_func` (
  `funcid` char(20) NOT NULL,
  `FU_CODE` char(20) NOT NULL,
  `FU_NAME` varchar(50) DEFAULT NULL,
  `deptid` char(20) DEFAULT NULL,
  `userid` char(20) DEFAULT NULL,
  `FU_TYPE` smallint(6) DEFAULT NULL,
  `FU_TYPE2` smallint(6) DEFAULT NULL,
  `FU_system` smallint(6) DEFAULT NULL,
  `fu_prog` varchar(100) NOT NULL,
  `fu_gif` varchar(100) NOT NULL,
  `fu_end` smallint(6) DEFAULT NULL,
  `fu_level` smallint(6) DEFAULT NULL,
  `fu_width` int(11) DEFAULT NULL,
  `fu_height` int(11) DEFAULT NULL,
  `fu_win` smallint(6) DEFAULT NULL,
  `fu_litgif` varchar(100) DEFAULT NULL,
  `mis` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `fu_authorize` smallint(6) DEFAULT NULL,
  `fu_topmenu` smallint(6) DEFAULT NULL,
  `fu_flowbz` smallint(6) DEFAULT NULL,
  `fu_tops` smallint(6) DEFAULT NULL,
  `fu_pnbz` smallint(6) DEFAULT NULL,
  `displayname` varchar(200) DEFAULT NULL,
  `fu_ctledit` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`funcid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `bd_func` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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);
DROP TABLE IF EXISTS `bd_fytype`;
CREATE TABLE `bd_fytype` (
  `fytypeid` char(20) NOT NULL,
  `fytype_code` char(20) DEFAULT NULL,
  `fytype_name` char(40) DEFAULT NULL,
  `fytype_end` smallint(6) DEFAULT NULL,
  `fytype_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_group`;
CREATE TABLE `bd_group` (
  `groupid` char(20) NOT NULL,
  `grp_code` char(10) DEFAULT NULL,
  `grp_name` char(30) DEFAULT NULL,
  `grp_own` smallint(6) DEFAULT NULL,
  `corpid` char(20) DEFAULT NULL,
  `mis` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`groupid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `bd_group` VALUES ('GROU25310000000107','HT012','部门合同跟踪管理人员',2,'',2,0,0,'2010-10-21 11:18:23');
INSERT INTO `bd_group` VALUES ('GROU33660000000105','HT010','单位合同管理员',2,'',2,0,0,'2010-10-21 11:15:17');
INSERT INTO `bd_group` VALUES ('GROU360000000104','HT002','部门中层领导',2,'',2,0,0,'2010-10-21 11:13:35');
INSERT INTO `bd_group` VALUES ('GROU69590000000106','HT011','部门合同管理员',2,'',2,0,0,'2010-10-21 11:16:11');
INSERT INTO `bd_group` VALUES ('GROU71320000000001','HT099','系统管理员',9,'',2,0,0,'2011-11-14 11:51:20');
INSERT INTO `bd_group` VALUES ('GROU75710000000091','HT001','单位高层领导',2,'',2,0,0,'2010-10-07 16:21:31');
INSERT INTO `bd_group` VALUES ('GROU9550000000108','HT090','合同信息查询用户',2,'',2,0,0,'2010-10-21 11:19:07');
DROP TABLE IF EXISTS `bd_groupqx`;
CREATE TABLE `bd_groupqx` (
  `groupqxid` varchar(40) NOT NULL,
  `groupid` char(20) NOT NULL,
  `funcid` char(20) DEFAULT NULL,
  `qxread` int(11) DEFAULT NULL,
  `qxwrite` int(11) DEFAULT NULL,
  `qxprint` int(11) DEFAULT NULL,
  `qxdownload` int(11) DEFAULT NULL,
  `qxman` int(11) DEFAULT NULL,
  `mis` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`groupqxid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

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

DROP TABLE IF EXISTS `bd_httype`;
CREATE TABLE `bd_httype` (
  `httypeid` char(20) NOT NULL,
  `ty_code` char(20) DEFAULT NULL,
  `ty_name` char(20) DEFAULT NULL,
  `ty_end` smallint(6) DEFAULT NULL,
  `ty_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`httypeid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `bd_httype` VALUES ('01','01','采购合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO `bd_httype` VALUES ('02','02','销售合同',1,1,0,0,'2010-05-11 12:59:23');
INSERT INTO `bd_httype` VALUES ('03','18','供电水气热力合同',1,1,0,0,'2010-10-07 22:02:17');
INSERT INTO `bd_httype` VALUES ('04','19','赠与合同',1,1,0,0,'2010-10-07 22:02:24');
INSERT INTO `bd_httype` VALUES ('05','05','借款合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO `bd_httype` VALUES ('06','06','租赁合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO `bd_httype` VALUES ('07','07','融资租赁合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO `bd_httype` VALUES ('08','08','承揽合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO `bd_httype` VALUES ('09','04','建设工程合同',1,1,0,0,'2010-10-07 22:01:59');
INSERT INTO `bd_httype` VALUES ('10','03','运输合同',1,1,0,0,'2010-10-07 22:01:32');
INSERT INTO `bd_httype` VALUES ('11','11','技术合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO `bd_httype` VALUES ('12','12','保管合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO `bd_httype` VALUES ('13','13','仓管合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO `bd_httype` VALUES ('14','14','委托合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO `bd_httype` VALUES ('15','15','行纪合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO `bd_httype` VALUES ('16','16','居间合同',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO `bd_httype` VALUES ('90','90','其他合同',1,1,0,0,'2009-07-22 12:01:01');
DROP TABLE IF EXISTS `bd_hy_house`;
CREATE TABLE `bd_hy_house` (
  `houseid` char(20) NOT NULL,
  `corpid` char(20) DEFAULT NULL,
  `house_code` char(20) DEFAULT NULL,
  `house_name` char(40) DEFAULT NULL,
  `house_addr` varchar(30) DEFAULT NULL,
  `house_src` varchar(100) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `bd_hy_house` VALUES ('DEPT86340000000069','1001','01','一号会议室','综合楼3楼301','音响，投影',0,0,'2010-10-08 12:36:58');
INSERT INTO `bd_hy_house` VALUES ('DEPT79930000000070','1001','02','2号会议室','综合楼2楼203室','桌椅50套，圆桌',0,0,'2010-10-08 12:37:46');
DROP TABLE IF EXISTS `bd_hy_lb`;
CREATE TABLE `bd_hy_lb` (
  `lbid` char(20) NOT NULL,
  `lb_code` char(20) DEFAULT NULL,
  `lb_name` char(40) DEFAULT NULL,
  `lb_end` smallint(6) DEFAULT NULL,
  `lb_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `bd_hy_lb` VALUES ('BASE14660000000201','01','公司会议',1,1,0,0,'2010-10-06 19:09:00');
INSERT INTO `bd_hy_lb` VALUES ('BASE76560000000202','03','部门会议',1,1,0,0,'2010-10-06 19:09:12');
INSERT INTO `bd_hy_lb` VALUES ('BASE3370000000205','04','集团会议',1,1,0,0,'2010-10-06 19:09:35');
INSERT INTO `bd_hy_lb` VALUES ('BASE60800000000206','05','专题会议',1,1,0,0,'2010-10-06 19:10:01');
DROP TABLE IF EXISTS `bd_idfactory`;
CREATE TABLE `bd_idfactory` (
  `factoryid` varchar(40) NOT NULL,
  `factorycode` char(6) DEFAULT NULL,
  `factoryvalue` int(11) DEFAULT NULL,
  PRIMARY KEY (`factoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `bd_idfactory` VALUES ('1','CORP',62);
DROP TABLE IF EXISTS `bd_log`;
CREATE TABLE `bd_log` (
  `logid` varchar(40) NOT NULL,
  `userid` char(20) DEFAULT NULL,
  `username` varchar(30) DEFAULT NULL,
  `funcid` char(20) DEFAULT NULL,
  `log_text` varchar(200) DEFAULT NULL,
  `log_date` datetime DEFAULT NULL,
  `log_ip` char(20) DEFAULT NULL,
  `log_mac` char(30) DEFAULT NULL,
  `newsid` char(20) DEFAULT NULL,
  PRIMARY KEY (`logid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_paymode`;
CREATE TABLE `bd_paymode` (
  `paymodeid` char(20) NOT NULL,
  `pa_code` char(20) DEFAULT NULL,
  `pa_name` char(30) DEFAULT NULL,
  `pa_end` smallint(6) DEFAULT NULL,
  `pa_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`paymodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `bd_paymode` VALUES ('01','01','现金',1,1,0,0,'2010-10-07 22:00:38');
INSERT INTO `bd_paymode` VALUES ('02','02','支票',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO `bd_paymode` VALUES ('03','03','汇票',1,1,0,0,'2009-07-22 12:01:01');
INSERT INTO `bd_paymode` VALUES ('04','04','本票',1,1,0,0,'2009-07-22 12:01:01');
DROP TABLE IF EXISTS `bd_role`;
CREATE TABLE `bd_role` (
  `roleid` char(20) NOT NULL,
  `ro_code` char(20) DEFAULT NULL,
  `ro_name` char(30) DEFAULT NULL,
  `ro_smsdisplay` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `bd_role` VALUES ('00','01','高层领导',1,0,0,'2010-10-21 13:18:56');
INSERT INTO `bd_role` VALUES ('001','02','部门中层领导',1,0,0,'2010-10-21 13:19:02');
INSERT INTO `bd_role` VALUES ('200','06','协理、助理',1,0,0,'2010-10-21 13:19:09');
INSERT INTO `bd_role` VALUES ('999','999','员工',1,0,0,'2010-10-21 13:19:15');
DROP TABLE IF EXISTS `bd_rpttype`;
CREATE TABLE `bd_rpttype` (
  `rpttypeid` char(20) NOT NULL,
  `rpt_code` char(20) DEFAULT NULL,
  `rpt_name` char(40) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`rpttypeid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_sc_ccda`;
CREATE TABLE `bd_sc_ccda` (
  `ccdaid` char(20) NOT NULL,
  `ccda_code` char(20) DEFAULT NULL,
  `ccda_lb` smallint(6) DEFAULT NULL,
  `ccda_ysfs` smallint(6) DEFAULT NULL,
  `ccda_rl` decimal(19,4) DEFAULT NULL,
  `ccda_sywl` decimal(19,4) DEFAULT NULL,
  `ccda_scbyl` decimal(19,4) DEFAULT NULL,
  `productid` char(20) DEFAULT NULL,
  `pk_bm` smallint(6) DEFAULT NULL,
  `corpid` char(20) DEFAULT NULL,
  `deptid` char(20) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`ccdaid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_sc_prdclass`;
CREATE TABLE `bd_sc_prdclass` (
  `prdclassid` char(20) NOT NULL,
  `prdclass_name` char(60) DEFAULT NULL,
  `prdclass_code` char(20) DEFAULT NULL,
  `prdclass_dw` char(10) DEFAULT NULL,
  `prdclass_end` smallint(6) DEFAULT NULL,
  `prdclass_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`prdclassid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_sc_product`;
CREATE TABLE `bd_sc_product` (
  `productid` char(20) NOT NULL,
  `product_code` char(20) DEFAULT NULL,
  `product_name` char(30) DEFAULT NULL,
  `erpid` char(20) DEFAULT NULL,
  `erpcode` char(20) DEFAULT NULL,
  `prdclassid` char(20) DEFAULT NULL,
  `product_dw` char(10) DEFAULT NULL,
  `product_type` smallint(6) DEFAULT NULL,
  `product_hsl` decimal(18,6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) NOT NULL,
  `ts` datetime DEFAULT NULL,
  `dispflag` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`productid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_sec_accident`;
CREATE TABLE `bd_sec_accident` (
  `accidentid` char(20) NOT NULL,
  `acc_code` char(20) DEFAULT NULL,
  `acc_name` char(40) DEFAULT NULL,
  `acc_end` smallint(6) DEFAULT NULL,
  `acc_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`accidentid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_sec_charge`;
CREATE TABLE `bd_sec_charge` (
  `chargeid` char(20) NOT NULL,
  `charge_code` char(20) DEFAULT NULL,
  `charge_name` char(40) DEFAULT NULL,
  `charge_end` smallint(6) DEFAULT NULL,
  `charge_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`chargeid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_sec_check`;
CREATE TABLE `bd_sec_check` (
  `checkid` char(20) NOT NULL,
  `check_code` char(20) DEFAULT NULL,
  `check_name` char(40) DEFAULT NULL,
  `check_end` smallint(6) DEFAULT NULL,
  `check_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`checkid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_sec_state`;
CREATE TABLE `bd_sec_state` (
  `stateid` char(20) NOT NULL,
  `st_code` char(20) DEFAULT NULL,
  `st_name` char(40) DEFAULT NULL,
  `st_end` smallint(6) DEFAULT NULL,
  `st_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`stateid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_sec_troble`;
CREATE TABLE `bd_sec_troble` (
  `trobleid` char(20) NOT NULL,
  `tro_code` char(20) DEFAULT NULL,
  `tro_name` char(40) DEFAULT NULL,
  `tro_end` smallint(6) DEFAULT NULL,
  `tro_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`trobleid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_sec_trostate`;
CREATE TABLE `bd_sec_trostate` (
  `stateid` char(20) NOT NULL,
  `st_code` char(20) DEFAULT NULL,
  `st_name` char(40) DEFAULT NULL,
  `st_end` smallint(6) DEFAULT NULL,
  `st_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`stateid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_swlb`;
CREATE TABLE `bd_swlb` (
  `swlbid` char(20) NOT NULL,
  `lb_code` char(20) DEFAULT NULL,
  `lb_name` varchar(50) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `basecode` char(10) DEFAULT NULL,
  `billroleid` char(20) DEFAULT NULL,
  PRIMARY KEY (`swlbid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `bd_swlb` VALUES ('BM','BM','部门收文',0,0,'2010-10-21 11:53:17','BM','SYS000000000456');
INSERT INTO `bd_swlb` VALUES ('DW','DW','党委类',0,0,'2009-11-30 22:50:47','DW','SYS000000000456');
INSERT INTO `bd_swlb` VALUES ('GH','GH','工会类',0,0,'2009-11-30 22:51:03','GH','SYS000000000456');
INSERT INTO `bd_swlb` VALUES ('JW','JW','纪委类',0,0,'2009-11-30 22:51:20','JW','SYS000000000456');
INSERT INTO `bd_swlb` VALUES ('JY','JY','经营类',0,0,'2009-11-30 22:51:39','JY','SYS000000000456');
INSERT INTO `bd_swlb` VALUES ('SC','SC','生产类',0,0,'2009-11-30 22:51:57','SC','SYS000000000456');
INSERT INTO `bd_swlb` VALUES ('TW','TW','团委类',0,0,'2009-11-30 22:52:12','TW','SYS000000000456');
INSERT INTO `bd_swlb` VALUES ('XZ','XZ','行政类',0,0,'2009-11-30 22:52:34','XZ','SYS000000000456');
DROP TABLE IF EXISTS `bd_trade`;
CREATE TABLE `bd_trade` (
  `tradeid` char(20) NOT NULL,
  `tr_code` char(20) DEFAULT NULL,
  `tr_name` char(30) DEFAULT NULL,
  `tr_end` smallint(6) DEFAULT NULL,
  `tr_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `tr_oldcode` char(20) DEFAULT NULL,
  PRIMARY KEY (`tradeid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `bd_trade` VALUES ('trade01','01','农、林、牧、渔业',1,1,0,0,'2009-01-01','01');
INSERT INTO `bd_trade` VALUES ('trade02','02','采掘业',1,1,0,0,'2009-01-01','02');
INSERT INTO `bd_trade` VALUES ('trade03','03','制造业',1,1,0,0,'2009-01-01','03');
INSERT INTO `bd_trade` VALUES ('trade04','04','电力煤气水的生产和供应业',1,1,0,0,'2009-01-01','04');
INSERT INTO `bd_trade` VALUES ('trade05','05','建筑业',1,1,0,0,'2009-01-01','05');
INSERT INTO `bd_trade` VALUES ('trade06','06','地质勘查业、水利管理业',1,1,0,0,'2009-01-01','06');
INSERT INTO `bd_trade` VALUES ('trade07','07','交通运输仓储及邮电通信业',1,1,0,0,'2009-01-01','07');
INSERT INTO `bd_trade` VALUES ('trade08','08','批发和零售贸易、餐饮业',1,1,0,0,'2009-01-01','08');
INSERT INTO `bd_trade` VALUES ('trade09','09','金融、保险业',1,1,0,0,'2009-01-01','09');
INSERT INTO `bd_trade` VALUES ('trade10','10','房地产业',1,1,0,0,'2009-01-01','10');
INSERT INTO `bd_trade` VALUES ('trade11','11','社会服务业',1,1,0,0,'2009-01-01','11');
INSERT INTO `bd_trade` VALUES ('trade12','12','卫生、体育和社会福利业',1,1,0,0,'2009-01-01','12');
INSERT INTO `bd_trade` VALUES ('trade13','13','教育文化艺术广播电影电视',1,1,0,0,'2009-01-01','13');
INSERT INTO `bd_trade` VALUES ('trade14','14','科学研究和综合技术服务业',1,1,0,0,'2009-01-01','14');
INSERT INTO `bd_trade` VALUES ('trade15','15','国家机关政党机关社会团体',1,1,0,0,'2009-01-01','15');
INSERT INTO `bd_trade` VALUES ('trade16','16','其他行业',1,1,0,0,'2009-01-01','16');
DROP TABLE IF EXISTS `bd_uscorp`;
CREATE TABLE `bd_uscorp` (
  `uscorpid` varchar(40) NOT NULL,
  `userid` char(20) DEFAULT NULL,
  `corpid` char(20) DEFAULT NULL,
  `mis` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`uscorpid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_usdept`;
CREATE TABLE `bd_usdept` (
  `usdeptid` varchar(40) NOT NULL,
  `userid` char(20) DEFAULT NULL,
  `deptid` char(20) DEFAULT NULL,
  `mis` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`usdeptid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_user`;
CREATE TABLE `bd_user` (
  `userid` char(20) NOT NULL,
  `deptid` char(20) DEFAULT NULL,
  `us_code` char(20) DEFAULT NULL,
  `us_name` char(60) DEFAULT NULL,
  `us_dh` char(30) DEFAULT NULL,
  `roleid` char(20) DEFAULT NULL,
  `us_pass` char(50) DEFAULT NULL,
  `us_psn` smallint(6) DEFAULT NULL,
  `us_sms` char(20) DEFAULT NULL,
  `us_xb` char(4) DEFAULT NULL,
  `us_zzdh` char(20) DEFAULT NULL,
  `us_sfzh` char(20) DEFAULT NULL,
  `us_email` char(30) DEFAULT NULL,
  `us_add` varchar(60) DEFAULT NULL,
  `us_post` char(10) DEFAULT NULL,
  `us_css` char(10) DEFAULT NULL,
  `us_menuform` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `us_mailsize` smallint(6) DEFAULT NULL,
  `pop3_zh` char(30) DEFAULT NULL,
  `pop3_passwd` varchar(128) DEFAULT NULL,
  `us_oldmis` char(10) DEFAULT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `bd_user` 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);
DROP TABLE IF EXISTS `bd_usgroup`;
CREATE TABLE `bd_usgroup` (
  `usgroupid` varchar(40) NOT NULL,
  `userid` char(20) DEFAULT NULL,
  `groupid` char(20) DEFAULT NULL,
  PRIMARY KEY (`usgroupid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `bd_usgroup` VALUES ('ff8080812fa6e09f012fa6f9ef3a00fa','admin','GROU69590000000106');
INSERT INTO `bd_usgroup` VALUES ('ff8080812fa6e09f012fa6f9ef3a00fb','admin','GROU33660000000105');
INSERT INTO `bd_usgroup` VALUES ('sys000000001','admin','GROU71320000000001');
DROP TABLE IF EXISTS `bd_wjhj`;
CREATE TABLE `bd_wjhj` (
  `wjhjid` char(20) NOT NULL,
  `hj_code` char(20) DEFAULT NULL,
  `hj_name` char(40) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`wjhjid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_wjmj`;
CREATE TABLE `bd_wjmj` (
  `wjmjid` char(20) NOT NULL,
  `mj_code` char(20) DEFAULT NULL,
  `mj_name` char(40) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`wjmjid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_wjtype`;
CREATE TABLE `bd_wjtype` (
  `wjtypeid` char(20) NOT NULL,
  `type_code` char(20) DEFAULT NULL,
  `type_name` char(40) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`wjtypeid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_xxrset`;
CREATE TABLE `bd_xxrset` (
  `xxrsetid` char(20) NOT NULL,
  `xxr_startdate` datetime DEFAULT NULL,
  `xxr_enddate` datetime NOT NULL,
  `xxr_type` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`xxrsetid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_zl_determinant`;
CREATE TABLE `bd_zl_determinant` (
  `determinantid` char(20) NOT NULL,
  `de_code` char(20) DEFAULT NULL,
  `de_name` char(30) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`determinantid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_zl_prdclass`;
CREATE TABLE `bd_zl_prdclass` (
  `prdclassid` char(20) NOT NULL,
  `prdclass_name` char(60) DEFAULT NULL,
  `prdclass_code` char(20) DEFAULT NULL,
  `prdclass_dw` char(10) DEFAULT NULL,
  `prdclass_end` smallint(6) DEFAULT NULL,
  `prdclass_level` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`prdclassid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `bd_zl_product`;
CREATE TABLE `bd_zl_product` (
  `productid` char(20) NOT NULL,
  `product_code` char(20) DEFAULT NULL,
  `product_name` char(30) DEFAULT NULL,
  `product_ggxh` char(30) DEFAULT NULL,
  `product_rule` varchar(100) DEFAULT NULL,
  `erpid` char(20) DEFAULT NULL,
  `erpcode` char(20) DEFAULT NULL,
  `prdclassid` char(20) DEFAULT NULL,
  `product_dw` char(10) DEFAULT NULL,
  `product_type` smallint(6) DEFAULT NULL,
  `product_hsl` decimal(18,6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) NOT NULL,
  `ts` datetime DEFAULT NULL,
  `dispflag` smallint(6) DEFAULT NULL,
  `templateid` char(20) DEFAULT NULL,
  PRIMARY KEY (`productid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;


DROP TABLE IF EXISTS `bd_zl_standard`;
CREATE TABLE `bd_zl_standard` (
  `standardid` char(20) NOT NULL,
  `productid` char(20) DEFAULT NULL,
  `st_code` char(20) DEFAULT NULL,
  `st_name` char(30) DEFAULT NULL,
  `st_type` smallint(6) DEFAULT NULL,
  `st_top` decimal(18,6) DEFAULT NULL,
  `st_bottom` decimal(18,6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`standardid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;


DROP TABLE IF EXISTS `ht_dhys`;
CREATE TABLE `ht_dhys` (
  `pk_htbasedoc` char(20) DEFAULT NULL,
  `pk_dhys` char(20) NOT NULL,
  `dh_date` datetime DEFAULT NULL,
  `pk_htbd` char(20) DEFAULT NULL,
  `dh_note` varchar(100) DEFAULT NULL,
  `dh_sl` decimal(19,4) DEFAULT NULL,
  `dh_dj` decimal(19,4) DEFAULT NULL,
  `dh_je` decimal(19,4) DEFAULT NULL,
  `nrow` smallint(6) DEFAULT NULL,
  `locked` smallint(6) DEFAULT NULL,
  `dh_sfr` varchar(20) DEFAULT NULL,
  `dh_mc` varchar(30) DEFAULT NULL,
  `dh_gg` varchar(30) DEFAULT NULL,
  `dh_xh` varchar(30) DEFAULT NULL,
  `dh_dfdw` varchar(30) DEFAULT NULL,
  `dh_dfsfr` varchar(20) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `dh_dw` char(10) DEFAULT NULL,
  PRIMARY KEY (`pk_dhys`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `ht_fj`;
CREATE TABLE `ht_fj` (
  `mainid` char(20) DEFAULT NULL,
  `fjid` char(20) NOT NULL,
  `fj_type` char(10) DEFAULT NULL,
  `fj_rowpk` char(20) DEFAULT NULL,
  `fj_name` varchar(100) DEFAULT NULL,
  `fj_path` varchar(200) DEFAULT NULL,
  `fj_size` int(11) DEFAULT NULL,
  `fj_flag` smallint(6) DEFAULT NULL,
  `nrow` smallint(6) DEFAULT NULL,
  `locked` smallint(6) DEFAULT NULL,
  `pwd` char(50) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `fj_sourceid` char(20) DEFAULT NULL,
  `fj_sourcetype` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`fjid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `ht_gzr`;
CREATE TABLE `ht_gzr` (
  `pk_htgzr` varchar(40) NOT NULL,
  `pk_htbasedoc` char(20) DEFAULT NULL,
  `userid` char(20) DEFAULT NULL,
  PRIMARY KEY (`pk_htgzr`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `ht_htbasedoc`;
CREATE TABLE `ht_htbasedoc` (
  `pk_htbasedoc` char(20) NOT NULL,
  `httypeid` char(20) DEFAULT NULL,
  `busimodeid` char(20) DEFAULT NULL,
  `paymodeid` char(20) DEFAULT NULL,
  `custdocid` char(20) DEFAULT NULL,
  `ht_code` char(40) DEFAULT NULL,
  `ht_name` varchar(60) DEFAULT NULL,
  `ht_money` decimal(19,4) DEFAULT NULL,
  `ht_dfdsr` char(20) DEFAULT NULL,
  `ht_dfjzr` char(20) DEFAULT NULL,
  `ht_cbbm` char(20) DEFAULT NULL,
  `ht_cbr` char(20) DEFAULT NULL,
  `ht_jzr` char(20) DEFAULT NULL,
  `ht_start_date` datetime DEFAULT NULL,
  `ht_end_date` datetime DEFAULT NULL,
  `ht_jd_date` datetime DEFAULT NULL,
  `ht_jd_addr` varchar(40) DEFAULT NULL,
  `ht_property` smallint(6) DEFAULT NULL,
  `ht_mainpk` char(20) DEFAULT NULL,
  `ht_mainname` varchar(60) DEFAULT NULL,
  `ht_end` smallint(6) DEFAULT NULL,
  `ht_lrr` char(20) DEFAULT NULL,
  `locked` smallint(6) DEFAULT NULL,
  `ht_lxqx` char(20) DEFAULT NULL,
  `ht_sj_enddate` datetime DEFAULT NULL,
  `ht_gzr` char(200) DEFAULT NULL,
  `ht_jsr` char(20) DEFAULT NULL,
  `ht_yjgdflag` smallint(6) DEFAULT NULL,
  `ht_yjgdr` char(20) DEFAULT NULL,
  `ht_yjgdsj` datetime DEFAULT NULL,
  `ht_yjgdbz` varchar(30) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `source_id` char(20) DEFAULT NULL,
  `source_code` char(30) DEFAULT NULL,
  `corpid` char(20) DEFAULT NULL,
  `deptid` char(20) DEFAULT NULL,
  `userid` char(20) DEFAULT NULL,
  `ht_jsmoney` decimal(19,4) DEFAULT NULL,
  `ht_wjsmoney` decimal(19,4) DEFAULT NULL,
  `ht_yjfs` smallint(6) DEFAULT NULL,
  `ht_jetype` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`pk_htbasedoc`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `ht_htbd`;
CREATE TABLE `ht_htbd` (
  `pk_htbasedoc` char(20) DEFAULT NULL,
  `pk_htbd` char(20) NOT NULL,
  `bd_jhrq` datetime DEFAULT NULL,
  `bd_cpmc` varchar(30) DEFAULT NULL,
  `bd_cpgg` varchar(30) DEFAULT NULL,
  `bd_cpxh` varchar(30) DEFAULT NULL,
  `bd_cpdw` char(20) DEFAULT NULL,
  `bd_cpsl` decimal(19,4) DEFAULT NULL,
  `bd_cpdj` decimal(19,4) DEFAULT NULL,
  `bd_cpje` decimal(19,4) DEFAULT NULL,
  `nrow` smallint(6) DEFAULT NULL,
  `locked` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `bd_note` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`pk_htbd`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `ht_htbg`;
CREATE TABLE `ht_htbg` (
  `pk_htbasedoc` char(20) DEFAULT NULL,
  `pk_htbg` char(20) NOT NULL,
  `bg_date` datetime DEFAULT NULL,
  `bg_yy` longtext,
  `bg_note` longtext,
  `bg_yj` longtext,
  `bg_lx` char(1) DEFAULT NULL,
  `bg_cbr` char(20) DEFAULT NULL,
  `bg_pzr` char(20) DEFAULT NULL,
  `nrow` smallint(6) DEFAULT NULL,
  `locked` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`pk_htbg`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `ht_jsjh`;
CREATE TABLE `ht_jsjh` (
  `pk_htbasedoc` char(20) NOT NULL,
  `pk_jsjh` char(20) NOT NULL,
  `jh_date` datetime DEFAULT NULL,
  `jh_note` longtext,
  `jh_jsje` decimal(19,4) DEFAULT NULL,
  `jh_jsbl` decimal(19,4) DEFAULT NULL,
  `paymodeid` char(20) DEFAULT NULL,
  `nrow` smallint(6) DEFAULT NULL,
  `locked` smallint(6) DEFAULT NULL,
  `jh_sjjsje` decimal(19,4) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`pk_jsjh`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `ht_jsqk`;
CREATE TABLE `ht_jsqk` (
  `pk_htbasedoc` char(20) DEFAULT NULL,
  `pk_jsqk` char(20) NOT NULL,
  `js_date` datetime DEFAULT NULL,
  `js_note` longtext,
  `js_cbr` char(20) DEFAULT NULL,
  `js_dfcbr` char(20) DEFAULT NULL,
  `js_money` decimal(19,4) DEFAULT NULL,
  `pk_jsjh` char(20) DEFAULT NULL,
  `nrow` smallint(6) DEFAULT NULL,
  `locked` smallint(6) DEFAULT NULL,
  `paymodeid` char(20) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`pk_jsqk`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `ht_zxqk`;
CREATE TABLE `ht_zxqk` (
  `pk_htbasedoc` char(20) DEFAULT NULL,
  `pk_zxqk` char(20) NOT NULL,
  `zx_date` datetime DEFAULT NULL,
  `zx_note` longtext,
  `zx_sfyc` char(2) DEFAULT NULL,
  `zx_ycsm` longtext,
  `zx_wcjt` decimal(19,4) DEFAULT NULL,
  `nrow` smallint(6) DEFAULT NULL,
  `locked` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `zx_htend` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`pk_zxqk`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `mail_b`;
CREATE TABLE `mail_b` (
  `pk_mail` char(20) DEFAULT NULL,
  `pk_mailb` char(20) NOT NULL,
  `mail_getopr` char(40) DEFAULT NULL,
  `mail_read` smallint(6) DEFAULT NULL,
  `mail_dele` smallint(6) DEFAULT NULL,
  `mail_readdate` datetime DEFAULT NULL,
  PRIMARY KEY (`pk_mailb`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `mail_fj`;
CREATE TABLE `mail_fj` (
  `pk_mail` char(20) DEFAULT NULL,
  `pk_fj` char(30) NOT NULL,
  `fj_type` char(10) DEFAULT NULL,
  `fj_name` varchar(100) DEFAULT NULL,
  `fj_path` varchar(200) DEFAULT NULL,
  `fj_size` int(11) DEFAULT NULL,
  `nrow` smallint(6) DEFAULT NULL,
  `pwd` varchar(50) DEFAULT NULL,
  `fj_sourceid` char(20) DEFAULT NULL,
  PRIMARY KEY (`pk_fj`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `mail_h`;
CREATE TABLE `mail_h` (
  `pk_mail` char(20) NOT NULL,
  `mail_head` text,
  `mail_note` mediumtext,
  `mail_sendopr` char(20) DEFAULT NULL,
  `mail_date` datetime DEFAULT NULL,
  `mail_ip` char(20) DEFAULT NULL,
  `mail_dele` smallint(6) DEFAULT NULL,
  `mail_size` int(11) DEFAULT NULL,
  PRIMARY KEY (`pk_mail`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `oa_flow_file`;
CREATE TABLE `oa_flow_file` (
  `fileid` char(32) NOT NULL,
  `templateid` char(20) DEFAULT NULL,
  `flowdirid` char(20) DEFAULT NULL,
  `wj_name` varchar(100) DEFAULT NULL,
  `wj_size` int(11) DEFAULT NULL,
  `userid` char(20) DEFAULT NULL,
  `deptid` char(20) DEFAULT NULL,
  `corpid` char(20) DEFAULT NULL,
  `oprflag` smallint(6) DEFAULT NULL,
  `wj_date` datetime DEFAULT NULL,
  `curr_spr` char(20) DEFAULT NULL,
  `curr_date` datetime DEFAULT NULL,
  `print_num` int(11) DEFAULT NULL,
  `sourceid` char(20) DEFAULT NULL,
  `pf_spr` char(20) DEFAULT NULL,
  `pf_js` smallint(6) DEFAULT NULL,
  `sj_date` datetime DEFAULT NULL,
  `sj_flag` smallint(6) DEFAULT NULL,
  `sj_ry` char(20) DEFAULT NULL,
  `sj_yj` longtext,
  `wjhjid` char(20) DEFAULT NULL,
  `wj_wh` varchar(50) DEFAULT NULL,
  `wjmjid` char(20) DEFAULT NULL,
  `wjtypeid` char(20) DEFAULT NULL,
  `wj_key` varchar(100) DEFAULT NULL,
  `wj_fwdw` varchar(60) DEFAULT NULL,
  `wj_fwbm` varchar(60) DEFAULT NULL,
  `wj_ngr` char(20) DEFAULT NULL,
  `wj_qfr` char(20) DEFAULT NULL,
  `wj_shdate` datetime DEFAULT NULL,
  `wj_bjsx` datetime DEFAULT NULL,
  `wj_dyfs` smallint(6) DEFAULT NULL,
  `wj_sourcetype` smallint(6) DEFAULT NULL,
  `wj_gdnote` varchar(100) DEFAULT NULL,
  `wj_gdr` char(20) DEFAULT NULL,
  `wj_gdrid` char(20) DEFAULT NULL,
  `wj_gddate` datetime DEFAULT NULL,
  `wj_swbh` char(20) DEFAULT NULL,
  `swlbid` char(20) DEFAULT NULL,
  `wj_gdajh` char(30) DEFAULT NULL,
  `wj_lfdw` varchar(200) DEFAULT NULL,
  `wj_zsdw` varchar(200) DEFAULT NULL,
  `wj_csdw` varchar(200) DEFAULT NULL,
  `wj_fsdw` varchar(200) DEFAULT NULL,
  `wj_bz` varchar(200) DEFAULT NULL,
  `wj_fwh` char(30) DEFAULT NULL,
  `file_path` varchar(200) DEFAULT NULL,
  `file_key` char(40) DEFAULT NULL,
  `wj_oldflag` smallint(6) DEFAULT NULL,
  `wj_bjdate` datetime DEFAULT NULL,
  `wj_useddays` smallint(6) DEFAULT NULL,
  `wj_dbflag` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`fileid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `oa_news`;
CREATE TABLE `oa_news` (
  `newsid` char(20) NOT NULL,
  `news_date` datetime DEFAULT NULL,
  `news_head` varchar(100) DEFAULT NULL,
  `news_text` mediumtext,
  `news_ip` char(20) DEFAULT NULL,
  `userid` char(20) DEFAULT NULL,
  `deptid` char(20) DEFAULT NULL,
  `corpid` char(20) DEFAULT NULL,
  `funcid` char(20) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `news_reads` int(11) DEFAULT NULL,
  `istop` smallint(6) DEFAULT NULL,
  `fileid` char(20) DEFAULT NULL,
  `oprflag` smallint(6) DEFAULT NULL,
  `news_key` varchar(100) DEFAULT NULL,
  `news_zy` mediumtext,
  `fbflag` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`newsid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `oa_news_fj`;
CREATE TABLE `oa_news_fj` (
  `fjid` char(20) NOT NULL,
  `newsid` char(20) DEFAULT NULL,
  `fj_type` char(10) DEFAULT NULL,
  `fj_name` varchar(200) DEFAULT NULL,
  `fj_path` varchar(200) DEFAULT NULL,
  `nrow` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `fj_size` int(11) DEFAULT NULL,
  `pwd` varchar(50) DEFAULT NULL,
  `fj_sourceid` char(20) DEFAULT NULL,
  PRIMARY KEY (`fjid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `oa_news_pn`;
CREATE TABLE `oa_news_pn` (
  `pnid` char(20) NOT NULL,
  `newsid` char(20) DEFAULT NULL,
  `userid` char(20) DEFAULT NULL,
  `pn_text` mediumtext,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`pnid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `oa_xfwj`;
CREATE TABLE `oa_xfwj` (
  `xfwjid` char(20) NOT NULL,
  `wjtypeid` char(20) DEFAULT NULL,
  `wjhjid` char(20) DEFAULT NULL,
  `wjmjid` char(20) DEFAULT NULL,
  `wj_name` varchar(100) DEFAULT NULL,
  `wj_wh` varchar(50) DEFAULT NULL,
  `wj_key` varchar(100) DEFAULT NULL,
  `wj_fwdw` varchar(100) DEFAULT NULL,
  `wj_fwbm` varchar(100) DEFAULT NULL,
  `wj_ngr` char(30) DEFAULT NULL,
  `wj_qfr` char(30) DEFAULT NULL,
  `wj_sourcetype` smallint(6) DEFAULT NULL,
  `wj_sourceid` char(20) DEFAULT NULL,
  `oprflag` smallint(6) DEFAULT NULL,
  `wj_gddate` datetime DEFAULT NULL,
  `wj_gdrid` char(20) DEFAULT NULL,
  `wj_gdr` char(20) DEFAULT NULL,
  `wj_date` datetime DEFAULT NULL,
  `userid` char(20) DEFAULT NULL,
  `deptid` char(20) DEFAULT NULL,
  `wj_zfbz` smallint(6) DEFAULT NULL,
  `wj_zfzs` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `wj_xwlb` smallint(6) DEFAULT NULL,
  `fwdeptid` char(20) DEFAULT NULL,
  `wj_gdajh` char(30) DEFAULT NULL,
  `wj_gdnote` varchar(100) DEFAULT NULL,
  `wj_lfdw` varchar(200) DEFAULT NULL,
  `wj_zsdw` varchar(200) DEFAULT NULL,
  `wj_csdw` varchar(200) DEFAULT NULL,
  `wj_fsdw` varchar(200) DEFAULT NULL,
  `wj_bz` varchar(30) DEFAULT NULL,
  `wj_oldflag` smallint(6) DEFAULT NULL,
  `hzflag` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`xfwjid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `sys_billfree`;
CREATE TABLE `sys_billfree` (
  `billfreeid` char(20) NOT NULL,
  `billcode` char(30) DEFAULT NULL,
  `billfree` char(40) DEFAULT NULL,
  PRIMARY KEY (`billfreeid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `sys_billnum`;
CREATE TABLE `sys_billnum` (
  `billnumid` varchar(40) NOT NULL,
  `billcode` char(30) DEFAULT NULL,
  `deptid` char(20) DEFAULT NULL,
  `billvalue` int(11) DEFAULT NULL,
  `nyear` int(11) DEFAULT NULL,
  `billroleid` char(20) DEFAULT NULL,
  PRIMARY KEY (`billnumid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `sys_billnum` VALUES ('1','2010','100101',3,2010,'TEMP92480000000051');
INSERT INTO `sys_billnum` VALUES ('2','2010','100101',1,2010,'TEMP21340000000059');
INSERT INTO `sys_billnum` VALUES ('3','2010','100101',2,2010,'TEMP620000000053');
INSERT INTO `sys_billnum` VALUES ('4','2010','100101',2,2010,'6');
INSERT INTO `sys_billnum` VALUES ('5','BM2010','100101',6,2010,'16');
INSERT INTO `sys_billnum` VALUES ('6','2010','100101',2,2010,'15');
INSERT INTO `sys_billnum` VALUES ('7','2010','100101',2,2010,'TEMP96060000000043');
INSERT INTO `sys_billnum` VALUES ('8a9881102cbf3102012cbfaa62110010','2010','100101',2,2010,'TEMP3010000000040');
INSERT INTO `sys_billnum` VALUES ('ff8080812cc125ee012cc129420f0002','2010','100101',2,2010,'TEMP69020000000052');
DROP TABLE IF EXISTS `sys_billrole`;
CREATE TABLE `sys_billrole` (
  `billroleid` char(20) NOT NULL,
  `bi_code` char(20) DEFAULT NULL,
  `bi_name` char(30) DEFAULT NULL,
  `bi_example` varchar(200) DEFAULT NULL,
  `bi_levels` smallint(6) DEFAULT NULL,
  `bi_no1_type` smallint(6) DEFAULT NULL,
  `bi_no1_len` smallint(6) DEFAULT NULL,
  `bi_no1_sep` char(2) DEFAULT NULL,
  `bi_no2_type` smallint(6) DEFAULT NULL,
  `bi_no2_len` smallint(6) DEFAULT NULL,
  `bi_no2_sep` char(2) DEFAULT NULL,
  `bi_no3_type` smallint(6) DEFAULT NULL,
  `bi_no3_len` smallint(6) DEFAULT NULL,
  `bi_no3_sep` char(2) DEFAULT NULL,
  `bi_no4_type` smallint(6) DEFAULT NULL,
  `bi_no4_len` smallint(6) DEFAULT NULL,
  `bi_no4_sep` char(2) DEFAULT NULL,
  `bi_no5_type` smallint(6) DEFAULT NULL,
  `bi_no5_len` smallint(6) DEFAULT NULL,
  `bi_no5_sep` char(2) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`billroleid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `sys_billrole` VALUES ('SYS000000000060','02','合同编号','[单位代码]-[部门代码]-[流水号]',3,2,4,'-',3,4,'-',90,4,'',1,1,'',1,1,'',0,0,'2010-10-21 11:36:10');
INSERT INTO `sys_billrole` VALUES ('SYS000000000456','03','收文编号规则','[单据代码][年（4位）][流水号]',3,1,4,'',4,4,'',90,4,'',90,4,'',1,1,'',0,0,'2010-10-21 11:52:53');
INSERT INTO `sys_billrole` VALUES ('SYS99420000003005','01','审批单编号','[单据代码][部门代码][年月（4位）][流水号]',4,1,4,'',3,2,'',6,4,'',90,3,'',1,1,'',0,0,'2010-11-14 13:53:34');
DROP TABLE IF EXISTS `sys_def_dir`;
CREATE TABLE `sys_def_dir` (
  `defdirid` char(20) NOT NULL,
  `dir_code` char(10) DEFAULT NULL,
  `dir_name` char(20) DEFAULT NULL,
  `dir_type` smallint(6) DEFAULT NULL,
  `dir_jsname` char(30) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`defdirid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `sys_def_dir` VALUES ('BAS001','BAS001','单位档案',9,'refCorp','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS002','BAS002','部门档案',9,'refDept','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS003','BAS003','操作用户档案',9,'refUser','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS004','BAS004','收文类别档案',9,'refSwlb','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS005','BAS005','文件类别档案',9,'refWjtype','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS006','BAS006','文件缓急档案',9,'refWjhj','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS007','BAS007','文件密级档案',9,'refWjmj','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS008','BAS008','合同类型',9,'refHttype','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS009','BAS009','业务类型档案',9,'refBusimode','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS010','BAS010','支付方式档案',9,'refPaymode','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS011','BAS011','地区分类档案',9,'refArea','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS012','BAS012','客商档案',9,'refCustdoc','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS013','BAS013','经济类型档案',9,'refEconomy','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS014','BAS014','行业分类',9,'refTrade','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS015','BAS015','工作报告分类',9,'refRpttype','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS016','BAS016','会议类别',9,'refHylb','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS017','BAS017','费用类别',9,'refFytype','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('BAS018','BAS018','会议室',9,'refHyhouse','2009-01-01',0,0);
INSERT INTO `sys_def_dir` VALUES ('SYS000000000001','BASE20','合同起草',1,NULL,'2010-10-12 11:11:17',0,0);
INSERT INTO `sys_def_dir` VALUES ('SYS40690000002731','BASE05','民族',1,'','2010-10-12 10:53:40',0,0);
INSERT INTO `sys_def_dir` VALUES ('SYS80650000001709','BASE03','性别',1,'','2010-10-12 10:53:07',0,0);
INSERT INTO `sys_def_dir` VALUES ('SYS8460000002089','BASE01','时',1,'','2010-10-07 22:52:46',0,0);
INSERT INTO `sys_def_dir` VALUES ('SYS93070000002090','BASE02','分',1,'','2010-10-07 22:53:03',0,0);
DROP TABLE IF EXISTS `sys_def_doc`;
CREATE TABLE `sys_def_doc` (
  `docid` char(20) NOT NULL,
  `defdirid` char(20) DEFAULT NULL,
  `doc_code` char(20) DEFAULT NULL,
  `doc_name` varchar(200) DEFAULT NULL,
  `doc_end` smallint(6) DEFAULT NULL,
  `doc_level` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`docid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `sys_errrpt`;
CREATE TABLE `sys_errrpt` (
  `errrptid` char(20) NOT NULL,
  `userid` char(20) DEFAULT NULL,
  `username` varchar(30) DEFAULT NULL,
  `err_type` smallint(6) DEFAULT NULL,
  `err_head` varchar(60) DEFAULT NULL,
  `err_text` mediumtext,
  `err_date` datetime DEFAULT NULL,
  `mis` smallint(6) DEFAULT NULL,
  `misname` varchar(30) DEFAULT NULL,
  `funcid` char(20) DEFAULT NULL,
  `funcname` varchar(30) DEFAULT NULL,
  `work_userid` char(20) DEFAULT NULL,
  `work_username` varchar(30) DEFAULT NULL,
  `work_date` datetime DEFAULT NULL,
  `work_text` mediumtext,
  `work_flag` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`errrptid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `sys_errrpt_fj`;
CREATE TABLE `sys_errrpt_fj` (
  `mainid` char(20) DEFAULT NULL,
  `fjid` char(20) NOT NULL,
  `fj_type` char(10) DEFAULT NULL,
  `fj_rowpk` char(20) DEFAULT NULL,
  `fj_name` varchar(100) DEFAULT NULL,
  `fj_path` varchar(200) DEFAULT NULL,
  `fj_size` int(11) DEFAULT NULL,
  `fj_flag` smallint(6) DEFAULT NULL,
  `nrow` smallint(6) DEFAULT NULL,
  `locked` smallint(6) DEFAULT NULL,
  `pwd` char(50) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `fj_sourceid` char(20) DEFAULT NULL,
  `fj_sourcetype` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`fjid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `sys_field`;
CREATE TABLE `sys_field` (
  `fieldid` char(20) NOT NULL,
  `tableid` char(20) DEFAULT NULL,
  `fd_name` char(20) DEFAULT NULL,
  `fd_note` varchar(40) DEFAULT NULL,
  `fd_type` char(1) DEFAULT NULL,
  `defdirid` char(20) DEFAULT NULL,
  `fd_len` smallint(6) DEFAULT NULL,
  `fd_dec` smallint(6) DEFAULT NULL,
  `fd_bz` varchar(40) DEFAULT NULL,
  `fd_system` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `fd_crefs` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`fieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `sys_form_act`;
CREATE TABLE `sys_form_act` (
  `actid` char(20) NOT NULL,
  `formid` char(20) DEFAULT NULL,
  `fd_name` char(30) DEFAULT NULL,
  `act_onblur` mediumtext,
  `act_onchange` mediumtext,
  `act_onclick` mediumtext,
  `act_ondblclick` mediumtext,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`actid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `sys_form_colwidth`;
CREATE TABLE `sys_form_colwidth` (
  `colid` char(20) NOT NULL,
  `formid` char(20) DEFAULT NULL,
  `cols` smallint(6) DEFAULT NULL,
  `ntype` smallint(6) DEFAULT NULL,
  `nwidth` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`colid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `sys_form_dir`;
CREATE TABLE `sys_form_dir` (
  `formid` char(20) NOT NULL,
  `tableid` char(20) DEFAULT NULL,
  `childid` char(20) DEFAULT NULL,
  `ta_table` char(30) DEFAULT NULL,
  `dir_code` char(10) DEFAULT NULL,
  `dir_name` char(30) DEFAULT NULL,
  `dir_cols` smallint(6) DEFAULT NULL,
  `displine` smallint(6) DEFAULT NULL,
  `rowheight` smallint(6) DEFAULT NULL,
  `cellpadding` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `rpt_fmt` mediumblob,
  `dir_type` smallint(6) DEFAULT NULL,
  `rpt_text` mediumtext,
  `dir_startrow` smallint(6) DEFAULT NULL,
  `dir_endrow` smallint(6) DEFAULT NULL,
  `dir_lb` smallint(6) DEFAULT NULL,
  `dir_share` smallint(6) DEFAULT NULL,
  `userid` char(20) DEFAULT NULL,
  `dir_system` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`formid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `sys_form_field`;
CREATE TABLE `sys_form_field` (
  `fieldid` char(20) NOT NULL,
  `formid` char(20) DEFAULT NULL,
  `tab_fieldid` char(20) DEFAULT NULL,
  `fd_name` varchar(200) DEFAULT NULL,
  `fd_null` smallint(6) DEFAULT NULL,
  `fd_row` smallint(6) DEFAULT NULL,
  `fd_col` smallint(6) DEFAULT NULL,
  `fd_colspan` smallint(6) DEFAULT NULL,
  `fd_size` smallint(6) DEFAULT NULL,
  `fd_inputbz` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `fd_coldisp` smallint(6) DEFAULT NULL,
  `fd_dec` smallint(6) DEFAULT NULL,
  `fd_align` char(10) DEFAULT NULL,
  `fd_width` smallint(6) DEFAULT NULL,
  `fd_height` smallint(6) DEFAULT NULL,
  `fd_ctrtype` char(10) DEFAULT NULL,
  `fd_color` char(10) DEFAULT NULL,
  `fd_bgcolor` char(10) DEFAULT NULL,
  `fd_fontname` varchar(20) DEFAULT NULL,
  `fd_fontsize` smallint(6) DEFAULT NULL,
  `fd_default` varchar(200) DEFAULT NULL,
  `fd_ref` smallint(6) DEFAULT NULL,
  `fd_own` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`fieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `sys_joinmis`;
CREATE TABLE `sys_joinmis` (
  `joinmisid` varchar(40) NOT NULL,
  `mis_id` char(20) DEFAULT NULL,
  `userid` char(20) DEFAULT NULL,
  `join_userid` char(50) DEFAULT NULL,
  `join_passwd` longtext,
  `join_pro1` longtext,
  `join_pro2` longtext,
  `ts` datetime DEFAULT NULL,
  PRIMARY KEY (`joinmisid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `sys_jzr`;
CREATE TABLE `sys_jzr` (
  `jzrid` varchar(40) NOT NULL,
  `mis` smallint(6) NOT NULL,
  `jzr_year` smallint(6) DEFAULT NULL,
  `jzr_month` smallint(6) DEFAULT NULL,
  `jzr_start` datetime DEFAULT NULL,
  `jzr_end` datetime DEFAULT NULL,
  `jzr_flag` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`jzrid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `sys_mis`;
CREATE TABLE `sys_mis` (
  `mis` smallint(6) NOT NULL,
  `mis_name` char(30) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`mis`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `sys_mis` VALUES (2,'合同管理',0);
DROP TABLE IF EXISTS `sys_table`;
CREATE TABLE `sys_table` (
  `tableid` char(20) NOT NULL,
  `ta_name` char(60) DEFAULT NULL,
  `ta_code` char(10) DEFAULT NULL,
  `ta_table` char(20) DEFAULT NULL,
  `ta_bz` varchar(60) DEFAULT NULL,
  `ismain` smallint(6) DEFAULT NULL,
  `main_tableid` char(20) DEFAULT NULL,
  `ta_system` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `ta_lb` smallint(6) DEFAULT NULL,
  `userid` char(20) DEFAULT NULL,
  PRIMARY KEY (`tableid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `sys_ui`;
CREATE TABLE `sys_ui` (
  `pk_ui` char(20) NOT NULL,
  `ui_type` smallint(6) DEFAULT NULL,
  `ui_code` char(20) DEFAULT NULL,
  `ui_name` varchar(30) DEFAULT NULL,
  `ui_xml` mediumtext,
  `ui_jsppath` varchar(200) DEFAULT NULL,
  `ui_own` char(20) DEFAULT NULL,
  `userid` char(20) DEFAULT NULL,
  `ui_width` smallint(6) DEFAULT NULL,
  `ui_bg` varchar(200) DEFAULT NULL,
  `ui_style` mediumtext,
  `ui_default` smallint(6) DEFAULT NULL,
  `dr` smallint(6) DEFAULT NULL,
  `fc` smallint(6) DEFAULT NULL,
  `ui_system` smallint(6) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `ui_autosize` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`pk_ui`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `sys_ui` VALUES ('SYS75070000004570',0,'sys001','系统首页_1','<?xml version=\"1.0\" encoding=\"GBK\"?><myui><div id=\"uiBackground\" divType=\"undefined\" zIndex=\"10\" left=\"0px\" top=\"\" color=\"\" className=\"\" width=\"100%\" height=\"650px\" background=\"url(/images/bgimg/0013.gif)\" borderRight=\"\" paddingRight=\"\" borderTop=\"\" paddingTop=\"\" borderLeft=\"\" paddingLeft=\"\" borderBottom=\"\" paddingBottom=\"\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"uiWorkbench\" divType=\"uiNormal\" zIndex=\"12\" left=\"236px\" top=\"\" color=\"\" className=\"\" width=\"800px\" height=\"3000px\" background=\"#ffffff\" borderRight=\"#000000 1px\" paddingRight=\"\" borderTop=\"#000000\" paddingTop=\"\" borderLeft=\"#000000 1px\" paddingLeft=\"\" borderBottom=\"#000000\" paddingBottom=\"\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_1\" divType=\"uiNormal\" zIndex=\"13\" left=\"2px\" top=\"1px\" color=\"\" className=\"\" width=\"530px\" height=\"186px\" background=\"\" borderRight=\"#000000 1px\" paddingRight=\"0px\" borderTop=\"#000000 1px\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 1px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 1px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_38\" divType=\"uiNormal\" zIndex=\"14\" left=\"1px\" top=\"0px\" color=\"\" className=\"\" width=\"527px\" height=\"32px\" background=\"\" borderRight=\"#000000 1px\" paddingRight=\"0px\" borderTop=\"#000000 1px\" paddingTop=\"0px\" borderLeft=\"#000000 1px\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 1px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_85\" divType=\"uiGif\" laUrl=\"\" gifUrl=\"/wj/2011_07/uigif/PATH78940000031172.gif\" zIndex=\"15\" left=\"0px\" top=\"3px\" color=\"\" className=\"\" width=\"185px\" height=\"32px\" background=\"\" borderRight=\"#909090 0px solid\" paddingRight=\"0px\" borderTop=\"#909090 0px solid\" paddingTop=\"0px\" borderLeft=\"#909090 0px solid\" paddingLeft=\"0px\" borderBottom=\"#909090 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div><div id=\"div_86\" divType=\"uiLabel\" laUrl=\"\" laText=\"新闻、简讯\" zIndex=\"15\" left=\"43px\" top=\"9px\" color=\"\" className=\"\" width=\"104px\" height=\"16px\" background=\"\" borderRight=\"#909090 0px solid\" paddingRight=\"0px\" borderTop=\"#909090 0px solid\" paddingTop=\"0px\" borderLeft=\"#909090 0px solid\" paddingLeft=\"0px\" borderBottom=\"#909090 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div><div id=\"div_11\" divType=\"uiNormal\" zIndex=\"15\" left=\"427px\" top=\"1px\" color=\"\" className=\"\" width=\"99px\" height=\"30px\" background=\"\" borderRight=\"#000000 1px\" paddingRight=\"0px\" borderTop=\"#000000 1px\" paddingTop=\"0px\" borderLeft=\"#000000 1px\" paddingLeft=\"0px\" borderBottom=\"#000000 1px\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_59\" divType=\"uiLabel\" laUrl=\"javaScript:dispMessAll(&quot;206021&quot;);\" laText=\"&gt;&gt;更多\" zIndex=\"16\" left=\"47px\" top=\"9px\" color=\"#000000\" className=\"\" width=\"51px\" height=\"19px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_87\" divType=\"uiForm\" zIndex=\"14\" left=\"0px\" top=\"32px\" color=\"#000000\" className=\"\" width=\"195px\" height=\"153px\" background=\"\" borderRight=\"#000000 1px\" paddingRight=\"0px\" borderTop=\"#000000 1px\" paddingTop=\"0px\" borderLeft=\"#000000 1px\" paddingLeft=\"0px\" borderBottom=\"#000000 1px\" paddingBottom=\"0px\" fontWeight=\"normal\" fontStyle=\"normal\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_89\" divType=\"uiBody\" zIndex=\"15\" left=\"0px\" top=\"0px\" color=\"\" className=\"\" width=\"193px\" height=\"152px\" background=\"\" borderRight=\"#909090 0px solid\" paddingRight=\"0px\" borderTop=\"#909090 0px solid\" paddingTop=\"0px\" borderLeft=\"#909090 0px solid\" paddingLeft=\"0px\" borderBottom=\"#909090 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_97\" divType=\"uiMessExp\" sMessType=\"0\" sFuncCode=\"206021\" nMessCount=\"3\" sItemType=\"99\" sIcoNo=\"1\" sHeadText=\"新闻、简讯\" sItemTitleSize=\"16\" sColorType=\"sys\" sScroll=\"0\" zIndex=\"16\" left=\"2px\" top=\"2px\" color=\"\" className=\"\" width=\"189px\" height=\"148px\" background=\"\" borderRight=\"#909090 0px solid\" paddingRight=\"0px\" borderTop=\"#909090 0px solid\" paddingTop=\"0px\" borderLeft=\"#909090 0px solid\" paddingLeft=\"0px\" borderBottom=\"#909090 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_98\" divType=\"uiForm\" zIndex=\"14\" left=\"185px\" top=\"33px\" color=\"#000000\" className=\"\" width=\"340px\" height=\"152px\" background=\"\" borderRight=\"#000000 1px\" paddingRight=\"0px\" borderTop=\"#000000 1px\" paddingTop=\"0px\" borderLeft=\"#000000 1px\" paddingLeft=\"0px\" borderBottom=\"#000000 1px\" paddingBottom=\"0px\" fontWeight=\"normal\" fontStyle=\"normal\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_100\" divType=\"uiBody\" zIndex=\"15\" left=\"0px\" top=\"0px\" color=\"\" className=\"\" width=\"338px\" height=\"151px\" background=\"\" borderRight=\"#909090 0px solid\" paddingRight=\"0px\" borderTop=\"#909090 0px solid\" paddingTop=\"0px\" borderLeft=\"#909090 0px solid\" paddingLeft=\"0px\" borderBottom=\"#909090 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_108\" divType=\"uiMessExp\" sMessType=\"0\" sFuncCode=\"206020\" nMessCount=\"6\" sItemType=\"20\" sIcoNo=\"9\" sHeadText=\"通知、公告\" sItemTitleSize=\"16\" sColorType=\"sys\" sScroll=\"0\" zIndex=\"16\" left=\"2px\" top=\"2px\" color=\"\" className=\"\" width=\"334px\" height=\"147px\" background=\"\" borderRight=\"#909090 0px solid\" paddingRight=\"0px\" borderTop=\"#909090 0px solid\" paddingTop=\"0px\" borderLeft=\"#909090 0px solid\" paddingLeft=\"0px\" borderBottom=\"#909090 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div></div><div id=\"div_30\" divType=\"uiForm\" zIndex=\"13\" left=\"2px\" top=\"190px\" color=\"#000000\" className=\"\" width=\"536px\" height=\"263px\" background=\"\" borderRight=\"#e7e4e4 1px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 1px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 1px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 1px solid\" paddingBottom=\"0px\" fontWeight=\"normal\" fontStyle=\"normal\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_32\" divType=\"uiHeader\" zIndex=\"14\" left=\"0px\" top=\"0px\" color=\"#000000\" className=\"th_own\" width=\"534px\" height=\"33px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_50\" divType=\"uiItem\" zIndex=\"15\" left=\"0px\" top=\"0px\" color=\"\" className=\"\" width=\"38px\" height=\"31px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_56\" divType=\"uiGif\" laUrl=\"\" gifUrl=\"/images/system.gif\" zIndex=\"16\" left=\"10px\" top=\"4px\" color=\"\" className=\"\" width=\"20px\" height=\"20px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_51\" divType=\"uiItem\" zIndex=\"15\" left=\"38px\" top=\"0px\" color=\"\" className=\"\" width=\"494px\" height=\"31px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_57\" divType=\"uiLabel\" laUrl=\"\" laText=\"分业务类型统计合同金额[饼图]\" zIndex=\"16\" left=\"0px\" top=\"6px\" color=\"\" className=\"\" width=\"177px\" height=\"20px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_33\" divType=\"uiBody\" zIndex=\"14\" left=\"0px\" top=\"33px\" color=\"\" className=\"\" width=\"534px\" height=\"228px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_60\" divType=\"uiMessExp\" sMessType=\"401\" sFuncCode=\"\" nMessCount=\"10\" sItemType=\"ywje01\" sIcoNo=\"1\" sHeadText=\"分业务类型统计合同金额[饼图]\" sItemTitleSize=\"16\" sColorType=\"sys\" sScroll=\"0\" zIndex=\"15\" left=\"2px\" top=\"2px\" color=\"\" className=\"\" width=\"530px\" height=\"224px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_36\" divType=\"uiForm\" zIndex=\"13\" left=\"547px\" top=\"192px\" color=\"#000000\" className=\"\" width=\"235px\" height=\"261px\" background=\"\" borderRight=\"#e7e4e4 1px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 1px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 1px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 1px solid\" paddingBottom=\"0px\" fontWeight=\"normal\" fontStyle=\"normal\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_52\" divType=\"uiHeader\" zIndex=\"14\" left=\"0px\" top=\"0px\" color=\"#000000\" className=\"th_own\" width=\"233px\" height=\"24px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_55\" divType=\"uiItem\" zIndex=\"15\" left=\"0px\" top=\"0px\" color=\"\" className=\"\" width=\"34px\" height=\"22px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_65\" divType=\"uiGif\" laUrl=\"\" gifUrl=\"/images/system.gif\" zIndex=\"16\" left=\"10px\" top=\"4px\" color=\"\" className=\"\" width=\"20px\" height=\"20px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_58\" divType=\"uiItem\" zIndex=\"15\" left=\"34px\" top=\"0px\" color=\"\" className=\"\" width=\"163px\" height=\"22px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_66\" divType=\"uiLabel\" laUrl=\"\" laText=\"合同签订、履行概况\" zIndex=\"16\" left=\"0px\" top=\"6px\" color=\"\" className=\"\" width=\"161px\" height=\"12px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_61\" divType=\"uiItem\" zIndex=\"15\" left=\"197px\" top=\"0px\" color=\"\" className=\"\" width=\"34px\" height=\"22px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_67\" divType=\"uiLabel\" laUrl=\"/jsp/htgl/htTjfx_waring.jsp\" laText=\"&gt;&gt;更多\" zIndex=\"16\" left=\"0px\" top=\"6px\" color=\"#000000\" className=\"\" width=\"36px\" height=\"21px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_53\" divType=\"uiBody\" zIndex=\"14\" left=\"0px\" top=\"24px\" color=\"\" className=\"\" width=\"233px\" height=\"235px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_68\" divType=\"uiMessExp\" sMessType=\"400\" sFuncCode=\"\" nMessCount=\"7\" sItemType=\"\" sIcoNo=\"\" sHeadText=\"合同签订、履行概况\" sItemTitleSize=\"16\" sColorType=\"sys\" sScroll=\"0\" zIndex=\"15\" left=\"2px\" top=\"2px\" color=\"\" className=\"\" width=\"229px\" height=\"231px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_69\" divType=\"uiForm\" zIndex=\"13\" left=\"2px\" top=\"458px\" color=\"#000000\" className=\"\" width=\"538px\" height=\"173px\" background=\"\" borderRight=\"#e7e4e4 1px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 1px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 1px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 1px solid\" paddingBottom=\"0px\" fontWeight=\"normal\" fontStyle=\"normal\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_70\" divType=\"uiHeader\" zIndex=\"14\" left=\"0px\" top=\"0px\" color=\"#000000\" className=\"th_own\" width=\"536px\" height=\"24px\" background=\"#cccccc\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_73\" divType=\"uiItem\" zIndex=\"15\" left=\"0px\" top=\"0px\" color=\"\" className=\"\" width=\"32px\" height=\"22px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_79\" divType=\"uiGif\" laUrl=\"\" gifUrl=\"/images/a9.gif\" zIndex=\"16\" left=\"10px\" top=\"4px\" color=\"\" className=\"\" width=\"21px\" height=\"17px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_74\" divType=\"uiItem\" zIndex=\"15\" left=\"32px\" top=\"0px\" color=\"\" className=\"\" width=\"408px\" height=\"22px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_80\" divType=\"uiLabel\" laUrl=\"\" laText=\"内部邮件\" zIndex=\"16\" left=\"4px\" top=\"5px\" color=\"\" className=\"\" width=\"217px\" height=\"16px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_75\" divType=\"uiItem\" zIndex=\"15\" left=\"440px\" top=\"0px\" color=\"\" className=\"\" width=\"94px\" height=\"22px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_81\" divType=\"uiLabel\" laUrl=\"/jsp/mail/mail_main.jsp\" laText=\"&gt;&gt;更多\" zIndex=\"16\" left=\"0px\" top=\"6px\" color=\"#000000\" className=\"\" width=\"40px\" height=\"14px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_71\" divType=\"uiBody\" zIndex=\"14\" left=\"0px\" top=\"24px\" color=\"\" className=\"\" width=\"536px\" height=\"147px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_82\" divType=\"uiMessExp\" sMessType=\"300\" sFuncCode=\"\" nMessCount=\"6\" sItemType=\"\" sIcoNo=\"\" sHeadText=\"电子邮件\" sItemTitleSize=\"16\" sColorType=\"sys\" sScroll=\"0\" zIndex=\"15\" left=\"2px\" top=\"2px\" color=\"\" className=\"\" width=\"532px\" height=\"143px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_2\" divType=\"uiForm\" zIndex=\"13\" left=\"546px\" top=\"0px\" color=\"#000000\" className=\"\" width=\"237px\" height=\"185px\" background=\"\" borderRight=\"#e7e4e4 1px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 1px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 1px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 1px solid\" paddingBottom=\"0px\" fontWeight=\"normal\" fontStyle=\"normal\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_3\" divType=\"uiHeader\" zIndex=\"14\" left=\"0px\" top=\"0px\" color=\"#000000\" className=\"th_own\" width=\"235px\" height=\"34px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_6\" divType=\"uiItem\" zIndex=\"15\" left=\"0px\" top=\"0px\" color=\"\" className=\"\" width=\"35px\" height=\"32px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_13\" divType=\"uiGif\" laUrl=\"\" gifUrl=\"/images/system.gif\" zIndex=\"16\" left=\"10px\" top=\"4px\" color=\"\" className=\"\" width=\"20px\" height=\"20px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_7\" divType=\"uiItem\" zIndex=\"15\" left=\"35px\" top=\"0px\" color=\"\" className=\"\" width=\"163px\" height=\"32px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_14\" divType=\"uiLabel\" laUrl=\"\" laText=\"通知、公告\" zIndex=\"16\" left=\"0px\" top=\"6px\" color=\"\" className=\"\" width=\"176px\" height=\"16px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_8\" divType=\"uiItem\" zIndex=\"15\" left=\"198px\" top=\"0px\" color=\"\" className=\"\" width=\"35px\" height=\"32px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_15\" divType=\"uiLabel\" laUrl=\"javaScript:dispMessAll(&quot;206020&quot;);\" laText=\"&gt;&gt;更多\" zIndex=\"16\" left=\"0px\" top=\"6px\" color=\"#000000\" className=\"\" width=\"35px\" height=\"16px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_4\" divType=\"uiBody\" zIndex=\"14\" left=\"0px\" top=\"34px\" color=\"\" className=\"\" width=\"235px\" height=\"149px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_16\" divType=\"uiMessExp\" sMessType=\"0\" sFuncCode=\"206020\" nMessCount=\"6\" sItemType=\"00\" sIcoNo=\"1\" sHeadText=\"通知、公告\" sItemTitleSize=\"16\" sColorType=\"sys\" sScroll=\"0\" zIndex=\"15\" left=\"2px\" top=\"2px\" color=\"\" className=\"\" width=\"231px\" height=\"145px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_5\" divType=\"uiForm\" zIndex=\"13\" left=\"547px\" top=\"457px\" color=\"#000000\" className=\"\" width=\"235px\" height=\"174px\" background=\"\" borderRight=\"#e7e4e4 1px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 1px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 1px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 1px solid\" paddingBottom=\"0px\" fontWeight=\"normal\" fontStyle=\"normal\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_9\" divType=\"uiHeader\" zIndex=\"14\" left=\"0px\" top=\"0px\" color=\"#000000\" className=\"th_own\" width=\"233px\" height=\"23px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_17\" divType=\"uiItem\" zIndex=\"15\" left=\"0px\" top=\"0px\" color=\"\" className=\"\" width=\"35px\" height=\"21px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_23\" divType=\"uiGif\" laUrl=\"\" gifUrl=\"/images/system.gif\" zIndex=\"16\" left=\"10px\" top=\"4px\" color=\"\" className=\"\" width=\"20px\" height=\"20px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_18\" divType=\"uiItem\" zIndex=\"15\" left=\"35px\" top=\"0px\" color=\"\" className=\"\" width=\"161px\" height=\"21px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_24\" divType=\"uiLabel\" laUrl=\"\" laText=\"法律法规\" zIndex=\"16\" left=\"0px\" top=\"6px\" color=\"\" className=\"\" width=\"160px\" height=\"9px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_19\" divType=\"uiItem\" zIndex=\"15\" left=\"196px\" top=\"0px\" color=\"\" className=\"\" width=\"35px\" height=\"21px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_25\" divType=\"uiLabel\" laUrl=\"javaScript:dispMessAll(&quot;206030&quot;);\" laText=\"&gt;&gt;更多\" zIndex=\"16\" left=\"0px\" top=\"6px\" color=\"#000000\" className=\"\" width=\"40px\" height=\"16px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_10\" divType=\"uiBody\" zIndex=\"14\" left=\"0px\" top=\"23px\" color=\"\" className=\"\" width=\"233px\" height=\"149px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_26\" divType=\"uiMessExp\" sMessType=\"0\" sFuncCode=\"206030\" nMessCount=\"6\" sItemType=\"00\" sIcoNo=\"1\" sHeadText=\"法律法规\" sItemTitleSize=\"16\" sColorType=\"sys\" sScroll=\"0\" zIndex=\"15\" left=\"2px\" top=\"2px\" color=\"\" className=\"\" width=\"229px\" height=\"145px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div></div></div></myui>','/jsp/ui/SYS75070000004570.jsp','sys','admin',800,'url(/images/bgimg/0013.gif)','',1,NULL,NULL,0,NULL,1);
INSERT INTO `sys_ui` VALUES ('SYS78090000004571',0,'sys002','系统首页_2','<?xml version=\"1.0\" encoding=\"GBK\"?><myui><div id=\"uiBackground\" divType=\"undefined\" zIndex=\"10\" left=\"0px\" top=\"\" color=\"\" className=\"\" width=\"100%\" height=\"650px\" background=\"url(/images/bgimg/0013.gif)\" borderRight=\"\" paddingRight=\"\" borderTop=\"\" paddingTop=\"\" borderLeft=\"\" paddingLeft=\"\" borderBottom=\"\" paddingBottom=\"\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"uiWorkbench\" divType=\"uiNormal\" zIndex=\"12\" left=\"236px\" top=\"\" color=\"\" className=\"\" width=\"800px\" height=\"3000px\" background=\"#ffffff\" borderRight=\"#000000 1px\" paddingRight=\"\" borderTop=\"#000000\" paddingTop=\"\" borderLeft=\"#000000 1px\" paddingLeft=\"\" borderBottom=\"#000000\" paddingBottom=\"\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_30\" divType=\"uiForm\" zIndex=\"13\" left=\"0px\" top=\"4px\" color=\"#000000\" className=\"\" width=\"536px\" height=\"297px\" background=\"\" borderRight=\"#e7e4e4 1px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 1px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 1px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 1px solid\" paddingBottom=\"0px\" fontWeight=\"normal\" fontStyle=\"normal\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_32\" divType=\"uiHeader\" zIndex=\"14\" left=\"0px\" top=\"0px\" color=\"#000000\" className=\"th_own\" width=\"534px\" height=\"30px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_50\" divType=\"uiItem\" zIndex=\"15\" left=\"0px\" top=\"0px\" color=\"\" className=\"\" width=\"38px\" height=\"28px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_56\" divType=\"uiGif\" laUrl=\"\" gifUrl=\"/images/system.gif\" zIndex=\"16\" left=\"10px\" top=\"4px\" color=\"\" className=\"\" width=\"20px\" height=\"20px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_51\" divType=\"uiItem\" zIndex=\"15\" left=\"38px\" top=\"0px\" color=\"\" className=\"\" width=\"494px\" height=\"28px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_57\" divType=\"uiLabel\" laUrl=\"\" laText=\"分业务类型统计合同金额[饼图]\" zIndex=\"16\" left=\"0px\" top=\"6px\" color=\"\" className=\"\" width=\"177px\" height=\"20px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_33\" divType=\"uiBody\" zIndex=\"14\" left=\"0px\" top=\"30px\" color=\"\" className=\"\" width=\"534px\" height=\"265px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_60\" divType=\"uiMessExp\" sMessType=\"401\" sFuncCode=\"\" nMessCount=\"10\" sItemType=\"ywje01\" sIcoNo=\"1\" sHeadText=\"分业务类型统计合同金额[饼图]\" sItemTitleSize=\"16\" sColorType=\"sys\" sScroll=\"0\" zIndex=\"15\" left=\"2px\" top=\"2px\" color=\"\" className=\"\" width=\"530px\" height=\"224px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_36\" divType=\"uiForm\" zIndex=\"13\" left=\"0px\" top=\"314px\" color=\"#000000\" className=\"\" width=\"232px\" height=\"303px\" background=\"\" borderRight=\"#e7e4e4 1px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 1px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 1px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 1px solid\" paddingBottom=\"0px\" fontWeight=\"normal\" fontStyle=\"normal\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_52\" divType=\"uiHeader\" zIndex=\"14\" left=\"0px\" top=\"0px\" color=\"#000000\" className=\"th_own\" width=\"230px\" height=\"27px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_55\" divType=\"uiItem\" zIndex=\"15\" left=\"0px\" top=\"0px\" color=\"\" className=\"\" width=\"34px\" height=\"25px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_65\" divType=\"uiGif\" laUrl=\"\" gifUrl=\"/images/system.gif\" zIndex=\"16\" left=\"10px\" top=\"4px\" color=\"\" className=\"\" width=\"20px\" height=\"20px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_58\" divType=\"uiItem\" zIndex=\"15\" left=\"34px\" top=\"0px\" color=\"\" className=\"\" width=\"160px\" height=\"25px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_66\" divType=\"uiLabel\" laUrl=\"\" laText=\"合同签订、履行概况\" zIndex=\"16\" left=\"0px\" top=\"6px\" color=\"\" className=\"\" width=\"153px\" height=\"12px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_61\" divType=\"uiItem\" zIndex=\"15\" left=\"194px\" top=\"0px\" color=\"\" className=\"\" width=\"34px\" height=\"25px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_67\" divType=\"uiLabel\" laUrl=\"/jsp/htgl/htTjfx_waring.jsp\" laText=\"&gt;&gt;更多\" zIndex=\"16\" left=\"0px\" top=\"6px\" color=\"#000000\" className=\"\" width=\"36px\" height=\"21px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_53\" divType=\"uiBody\" zIndex=\"14\" left=\"0px\" top=\"27px\" color=\"\" className=\"\" width=\"230px\" height=\"274px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_68\" divType=\"uiMessExp\" sMessType=\"400\" sFuncCode=\"\" nMessCount=\"7\" sItemType=\"\" sIcoNo=\"\" sHeadText=\"合同签订、履行概况\" sItemTitleSize=\"16\" sColorType=\"sys\" sScroll=\"0\" zIndex=\"15\" left=\"2px\" top=\"2px\" color=\"\" className=\"\" width=\"227px\" height=\"268px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_69\" divType=\"uiForm\" zIndex=\"13\" left=\"245px\" top=\"314px\" color=\"#000000\" className=\"\" width=\"287px\" height=\"303px\" background=\"\" borderRight=\"#e7e4e4 1px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 1px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 1px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 1px solid\" paddingBottom=\"0px\" fontWeight=\"normal\" fontStyle=\"normal\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_70\" divType=\"uiHeader\" zIndex=\"14\" left=\"0px\" top=\"0px\" color=\"#000000\" className=\"th_own\" width=\"285px\" height=\"30px\" background=\"#cccccc\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_73\" divType=\"uiItem\" zIndex=\"15\" left=\"0px\" top=\"0px\" color=\"\" className=\"\" width=\"37px\" height=\"28px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_79\" divType=\"uiGif\" laUrl=\"\" gifUrl=\"/images/a9.gif\" zIndex=\"16\" left=\"10px\" top=\"4px\" color=\"\" className=\"\" width=\"21px\" height=\"17px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_74\" divType=\"uiItem\" zIndex=\"15\" left=\"37px\" top=\"0px\" color=\"\" className=\"\" width=\"191px\" height=\"28px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_80\" divType=\"uiLabel\" laUrl=\"\" laText=\"电子邮件\" zIndex=\"16\" left=\"4px\" top=\"5px\" color=\"\" className=\"\" width=\"204px\" height=\"16px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_75\" divType=\"uiItem\" zIndex=\"15\" left=\"228px\" top=\"0px\" color=\"\" className=\"\" width=\"55px\" height=\"28px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_81\" divType=\"uiLabel\" laUrl=\"/jsp/mail/mail_main.jsp\" laText=\"&gt;&gt;更多\" zIndex=\"16\" left=\"0px\" top=\"6px\" color=\"#000000\" className=\"\" width=\"40px\" height=\"14px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_71\" divType=\"uiBody\" zIndex=\"14\" left=\"0px\" top=\"30px\" color=\"\" className=\"\" width=\"285px\" height=\"271px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_82\" divType=\"uiMessExp\" sMessType=\"300\" sFuncCode=\"\" nMessCount=\"12\" sItemType=\"\" sIcoNo=\"\" sHeadText=\"电子邮件\" sItemTitleSize=\"16\" sColorType=\"sys\" sScroll=\"0\" zIndex=\"15\" left=\"2px\" top=\"2px\" color=\"\" className=\"\" width=\"271px\" height=\"267px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_2\" divType=\"uiForm\" zIndex=\"13\" left=\"544px\" top=\"5px\" color=\"#000000\" className=\"\" width=\"241px\" height=\"298px\" background=\"\" borderRight=\"#e7e4e4 1px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 1px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 1px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 1px solid\" paddingBottom=\"0px\" fontWeight=\"normal\" fontStyle=\"normal\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_3\" divType=\"uiHeader\" zIndex=\"14\" left=\"0px\" top=\"0px\" color=\"#000000\" className=\"th_own\" width=\"239px\" height=\"32px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_6\" divType=\"uiItem\" zIndex=\"15\" left=\"0px\" top=\"0px\" color=\"\" className=\"\" width=\"44px\" height=\"30px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_13\" divType=\"uiGif\" laUrl=\"\" gifUrl=\"/images/system.gif\" zIndex=\"16\" left=\"10px\" top=\"4px\" color=\"\" className=\"\" width=\"20px\" height=\"20px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_7\" divType=\"uiItem\" zIndex=\"15\" left=\"44px\" top=\"0px\" color=\"\" className=\"\" width=\"149px\" height=\"30px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_14\" divType=\"uiLabel\" laUrl=\"\" laText=\"通知、公告\" zIndex=\"16\" left=\"0px\" top=\"6px\" color=\"\" className=\"\" width=\"148px\" height=\"20px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_8\" divType=\"uiItem\" zIndex=\"15\" left=\"193px\" top=\"0px\" color=\"\" className=\"\" width=\"44px\" height=\"30px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_15\" divType=\"uiLabel\" laUrl=\"javaScript:dispMessAll(&quot;206020&quot;);\" laText=\"&gt;&gt;更多\" zIndex=\"16\" left=\"0px\" top=\"6px\" color=\"#000000\" className=\"\" width=\"43px\" height=\"23px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_4\" divType=\"uiBody\" zIndex=\"14\" left=\"0px\" top=\"32px\" color=\"\" className=\"\" width=\"239px\" height=\"264px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_16\" divType=\"uiMessExp\" sMessType=\"0\" sFuncCode=\"206020\" nMessCount=\"10\" sItemType=\"00\" sIcoNo=\"1\" sHeadText=\"通知、公告\" sItemTitleSize=\"16\" sColorType=\"sys\" sScroll=\"1\" zIndex=\"15\" left=\"2px\" top=\"2px\" color=\"\" className=\"\" width=\"231px\" height=\"254px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_31\" divType=\"uiForm\" zIndex=\"13\" left=\"542px\" top=\"315px\" color=\"#000000\" className=\"\" width=\"242px\" height=\"303px\" background=\"\" borderRight=\"#e7e4e4 1px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 1px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 1px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 1px solid\" paddingBottom=\"0px\" fontWeight=\"normal\" fontStyle=\"normal\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_72\" divType=\"uiHeader\" zIndex=\"14\" left=\"0px\" top=\"0px\" color=\"#000000\" className=\"th_own\" width=\"240px\" height=\"28px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_88\" divType=\"uiItem\" zIndex=\"15\" left=\"0px\" top=\"0px\" color=\"\" className=\"\" width=\"36px\" height=\"26px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_95\" divType=\"uiGif\" laUrl=\"\" gifUrl=\"/images/system.gif\" zIndex=\"16\" left=\"10px\" top=\"4px\" color=\"\" className=\"\" width=\"20px\" height=\"20px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_90\" divType=\"uiItem\" zIndex=\"15\" left=\"36px\" top=\"0px\" color=\"\" className=\"\" width=\"166px\" height=\"26px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_96\" divType=\"uiLabel\" laUrl=\"\" laText=\"新闻、简讯\" zIndex=\"16\" left=\"0px\" top=\"6px\" color=\"\" className=\"\" width=\"165px\" height=\"16px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div><div id=\"div_91\" divType=\"uiItem\" zIndex=\"15\" left=\"202px\" top=\"0px\" color=\"\" className=\"\" width=\"36px\" height=\"26px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_99\" divType=\"uiLabel\" laUrl=\"javaScript:dispMessAll(&quot;206021&quot;);\" laText=\"&gt;&gt;更多\" zIndex=\"16\" left=\"0px\" top=\"6px\" color=\"#000000\" className=\"\" width=\"40px\" height=\"16px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div><div id=\"div_83\" divType=\"uiBody\" zIndex=\"14\" left=\"0px\" top=\"28px\" color=\"\" className=\"\" width=\"240px\" height=\"273px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"><div id=\"div_101\" divType=\"uiMessExp\" sMessType=\"0\" sFuncCode=\"206021\" nMessCount=\"12\" sItemType=\"00\" sIcoNo=\"4\" sHeadText=\"新闻、简讯\" sItemTitleSize=\"16\" sColorType=\"sys\" sScroll=\"0\" zIndex=\"15\" left=\"2px\" top=\"2px\" color=\"\" className=\"\" width=\"161px\" height=\"246px\" background=\"\" borderRight=\"#e7e4e4 0px solid\" paddingRight=\"0px\" borderTop=\"#e7e4e4 0px solid\" paddingTop=\"0px\" borderLeft=\"#e7e4e4 0px solid\" paddingLeft=\"0px\" borderBottom=\"#e7e4e4 0px solid\" paddingBottom=\"0px\" fontWeight=\"\" fontStyle=\"\" textDecoration=\"\" whiteSpace=\"\"></div></div></div></div></div></myui>','/jsp/ui/SYS78090000004571.jsp','sys','admin',800,'url(/images/bgimg/0013.gif)','',0,NULL,NULL,0,NULL,1);
DROP TABLE IF EXISTS `sys_uifj`;
CREATE TABLE `sys_uifj` (
  `mainid` char(20) DEFAULT NULL,
  `fjid` char(20) NOT NULL,
  `fj_type` char(10) DEFAULT NULL,
  `fj_rowpk` char(20) DEFAULT NULL,
  `fj_name` varchar(100) DEFAULT NULL,
  `fj_path` varchar(200) DEFAULT NULL,
  `fj_size` int(11) DEFAULT NULL,
  `fj_flag` smallint(6) DEFAULT NULL,
  `nrow` smallint(6) DEFAULT NULL,
  `locked` smallint(6) DEFAULT NULL,
  `pwd` char(50) DEFAULT NULL,
  `ts` datetime DEFAULT NULL,
  `fj_sourceid` char(20) DEFAULT NULL,
  `fj_sourcetype` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`fjid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

INSERT INTO `sys_uifj` VALUES ('admin','HTFJ8660000014790','GIF','admin','分隔条','/wj/2011_07/uigif/PATH78940000031172.gif',2802,1,1,NULL,'DF5CA10190087BF63861FA987A627328','2011-07-15 10:31:14','',0);


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);


