data.sql

一个pb框架,试过

	values ('010501', '工作站维护', 1, 'Y', '0105', 'bmp\fileclose.bmp', 'bmp\fileopen.bmp', 'N', 'Y', '工作站维护', '工作站维护', 'S', 'w_workstation_maint', null, 'Y', 1, 0, 0)
insert into ERPFUNCTION (EFID, EFNAME, EFCLASS, EFLASTFLAG, EFPCID, EFUPPICT, EFDNPICT, EFCHECK, EFVISIBLE, EFHINT, EFMICROHELP, EFRUNHOW, EFRUNWHAT, EFRUNPARA, EFISLOG, EFTBITEMINDEX, EFTBITEMORDER, EFTBITEMSPACE)
	values ('010601', '重复对象遍历', 1, 'Y', '0106', 'bmp\fileclose.bmp', 'bmp\fileopen.bmp', 'N', 'Y', '重复对象遍历', '重复对象遍历', 'S', 'w_library_repeat_or_multi_object', null, 'Y', 1, 0, 0)
insert into ERPFUNCTION (EFID, EFNAME, EFCLASS, EFLASTFLAG, EFPCID, EFUPPICT, EFDNPICT, EFCHECK, EFVISIBLE, EFHINT, EFMICROHELP, EFRUNHOW, EFRUNWHAT, EFRUNPARA, EFISLOG, EFTBITEMINDEX, EFTBITEMORDER, EFTBITEMSPACE)
	values ('020101', '用户报装申请', 1, 'Y', '0201', 'bmp\fileclose.bmp', 'bmp\fileopen.bmp', 'N', 'Y', '用户报装申请', '用户报装申请', 'P', 'w_bill', '101', 'Y', 1, 0, 0)
insert into ERPFUNCTION (EFID, EFNAME, EFCLASS, EFLASTFLAG, EFPCID, EFUPPICT, EFDNPICT, EFCHECK, EFVISIBLE, EFHINT, EFMICROHELP, EFRUNHOW, EFRUNWHAT, EFRUNPARA, EFISLOG, EFTBITEMINDEX, EFTBITEMORDER, EFTBITEMSPACE)
	values ('010402', '管理架构维护', 1, 'Y', '0104', 'bmp\fileclose.bmp', 'bmp\fileopen.bmp', 'N', 'Y', '管理架构维护', '管理架构维护', 'S', 'w_sysmanaframe_maint', null, 'Y', 1, 0, 0)
insert into ERPFUNCTION (EFID, EFNAME, EFCLASS, EFLASTFLAG, EFPCID, EFUPPICT, EFDNPICT, EFCHECK, EFVISIBLE, EFHINT, EFMICROHELP, EFRUNHOW, EFRUNWHAT, EFRUNPARA, EFISLOG, EFTBITEMINDEX, EFTBITEMORDER, EFTBITEMSPACE)
	values ('010602', '系统对象浏览', 1, 'Y', '0106', 'bmp\fileclose.bmp', 'bmp\fileopen.bmp', 'N', 'Y', '系统对象浏览', '系统对象浏览', 'S', 'w_library_list_view', null, 'Y', 1, 0, 0)
insert into ERPFUNCTION (EFID, EFNAME, EFCLASS, EFLASTFLAG, EFPCID, EFUPPICT, EFDNPICT, EFCHECK, EFVISIBLE, EFHINT, EFMICROHELP, EFRUNHOW, EFRUNWHAT, EFRUNPARA, EFISLOG, EFTBITEMINDEX, EFTBITEMORDER, EFTBITEMSPACE)
	values ('020110', '用户需要提交资料', 1, 'Y', '0201', 'bmp\fileclose.bmp', 'bmp\fileopen.bmp', 'N', 'Y', '用户需要提交资料', '用户需要提交资料', 'S', 'w_usertype_stuff_maint', null, 'Y', 1, 0, 0)
insert into ERPFUNCTION (EFID, EFNAME, EFCLASS, EFLASTFLAG, EFPCID, EFUPPICT, EFDNPICT, EFCHECK, EFVISIBLE, EFHINT, EFMICROHELP, EFRUNHOW, EFRUNWHAT, EFRUNPARA, EFISLOG, EFTBITEMINDEX, EFTBITEMORDER, EFTBITEMSPACE)
	values ('020111', '流程定义', 1, 'Y', '0201', 'bmp\fileclose.bmp', 'bmp\fileopen.bmp', 'N', 'Y', '业务流程自定义', '业务流程自定义', 'S', 'w_userflowdefine_wizard', null, 'N', 1, 0, 0)

insert into OPERACCNT (OAID, OAPWD, OAPWDTYPE, OAPWDQUST, OAPWDANSW, OAISLOGIN, OAMAXDATE, OAGH, OANAME, OADEPT, OAIDNO, OAEMAIL, OAROLE, OAACCNTID, OAOPERTYPE)
	values ('seastar', '''', 'Y', null, null, 'Y', 31-12-2009, null, '系统管理员', '0', null, null, '00', '00', null)
insert into OPERACCNT (OAID, OAPWD, OAPWDTYPE, OAPWDQUST, OAPWDANSW, OAISLOGIN, OAMAXDATE, OAGH, OANAME, OADEPT, OAIDNO, OAEMAIL, OAROLE, OAACCNTID, OAOPERTYPE)
	values ('000001', '''', 'Y', null, null, 'Y', 28-04-2005,  null, '周惠莹', '0', null, null, '00', '00', 'CZ')
insert into OPERACCNT (OAID, OAPWD, OAPWDTYPE, OAPWDQUST, OAPWDANSW, OAISLOGIN, OAMAXDATE, OAGH, OANAME, OADEPT, OAIDNO, OAEMAIL, OAROLE, OAACCNTID, OAOPERTYPE)
	values ('000002', '''', 'Y', null, null, 'Y', 28-04-2005, null, '贾峰晓', '104', null, null, '00', '00', 'CZ')
insert into OPERACCNT (OAID, OAPWD, OAPWDTYPE, OAPWDQUST, OAPWDANSW, OAISLOGIN, OAMAXDATE, OAGH, OANAME, OADEPT, OAIDNO, OAEMAIL, OAROLE, OAACCNTID, OAOPERTYPE)
	values ('000003', '''', 'Y', null, null, 'Y', 28-04-2005, null, '韩鹏辉', '202', null, null, '00', '00', 'CZ')
insert into OPERACCNT (OAID, OAPWD, OAPWDTYPE, OAPWDQUST, OAPWDANSW, OAISLOGIN, OAMAXDATE, OAGH, OANAME, OADEPT, OAIDNO, OAEMAIL, OAROLE, OAACCNTID, OAOPERTYPE)
	values ('000004', '''', 'Y', null, null, 'Y', 28-04-2005, null, '测试4', '0', null, null, '00', '00', 'CZ')
insert into OPERACCNT (OAID, OAPWD, OAPWDTYPE, OAPWDQUST, OAPWDANSW, OAISLOGIN, OAMAXDATE, OAGH, OANAME, OADEPT, OAIDNO, OAEMAIL, OAROLE, OAACCNTID, OAOPERTYPE)
	values ('000005', '''', 'Y', null, null, 'Y', 28-04-2005, null, '测试5', '0', null, null, '00', '00', 'CZ')
insert into OPERACCNT (OAID, OAPWD, OAPWDTYPE, OAPWDQUST, OAPWDANSW, OAISLOGIN, OAMAXDATE, OAGH, OANAME, OADEPT, OAIDNO, OAEMAIL, OAROLE, OAACCNTID, OAOPERTYPE)
	values ('000006', '123456', 'Y', null, null, 'Y', 28-04-2005, null, '测试6', '0', null, null, '00', '00', 'CZ')

insert into OPERGROUPFUNC (OGFID, OGFGID, OGFMID, OGFFID)
	values ('0104', '00', 'G01', '010401')
insert into OPERGROUPFUNC (OGFID, OGFGID, OGFMID, OGFFID)
	values ('0105', '00', 'G01', '010501')
insert into OPERGROUPFUNC (OGFID, OGFGID, OGFMID, OGFFID)
	values ('0101', '00', 'G01', '010101')
insert into OPERGROUPFUNC (OGFID, OGFGID, OGFMID, OGFFID)
	values ('0101', '00', 'G01', '010102')
insert into OPERGROUPFUNC (OGFID, OGFGID, OGFMID, OGFFID)
	values ('0103', '00', 'G01', '010301')
insert into OPERGROUPFUNC (OGFID, OGFGID, OGFMID, OGFFID)
	values ('0102', '00', 'G01', '010201')
insert into OPERGROUPFUNC (OGFID, OGFGID, OGFMID, OGFFID)
	values ('0103', '00', 'G01', '010302')
insert into OPERGROUPFUNC (OGFID, OGFGID, OGFMID, OGFFID)
	values ('0102', '00', 'G01', '010202')
insert into OPERGROUPFUNC (OGFID, OGFGID, OGFMID, OGFFID)
	values ('0102', '00', 'G01', '010203')
insert into OPERGROUPFUNC (OGFID, OGFGID, OGFMID, OGFFID)
	values ('0106', '00', 'G01', '010601')
insert into OPERGROUPFUNC (OGFID, OGFGID, OGFMID, OGFFID)
	values ('0104', '00', 'G01', '010402')
insert into OPERGROUPFUNC (OGFID, OGFGID, OGFMID, OGFFID)
	values ('0201', '00', 'G02', '020101')
insert into OPERGROUPFUNC (OGFID, OGFGID, OGFMID, OGFFID)
	values ('0106', '00', 'G01', '010602')
insert into OPERGROUPFUNC (OGFID, OGFGID, OGFMID, OGFFID)
	values ('0201', '00', 'G02', '020110')
insert into OPERGROUPFUNC (OGFID, OGFGID, OGFMID, OGFFID)
	values ('0201', '00', 'G02', '020111')

insert into OPERGROUPMOD (OGMID, OGMNAME, OGMPID, OGMGID, OGMMID, OGMCLASS, OGMFLAG)
	values ('0105', '工作站维护', 'G01', '00', 'G01', 3, 'Y')
insert into OPERGROUPMOD (OGMID, OGMNAME, OGMPID, OGMGID, OGMMID, OGMCLASS, OGMFLAG)
	values ('G01', '系统维护模块', '00', '00', 'G01', 2, 'N')
insert into OPERGROUPMOD (OGMID, OGMNAME, OGMPID, OGMGID, OGMMID, OGMCLASS, OGMFLAG)
	values ('0101', '系统日志管理', 'G01', '00', 'G01', 3, 'Y')
insert into OPERGROUPMOD (OGMID, OGMNAME, OGMPID, OGMGID, OGMMID, OGMCLASS, OGMFLAG)
	values ('0102', '系统模块管理', 'G01', '00', 'G01', 3, 'Y')
insert into OPERGROUPMOD (OGMID, OGMNAME, OGMPID, OGMGID, OGMMID, OGMCLASS, OGMFLAG)
	values ('0103', '系统功能管理', 'G01', '00', 'G01', 3, 'Y')
insert into OPERGROUPMOD (OGMID, OGMNAME, OGMPID, OGMGID, OGMMID, OGMCLASS, OGMFLAG)
	values ('00', '系统管理分组', '0', '00', '0', 1, 'N')
insert into OPERGROUPMOD (OGMID, OGMNAME, OGMPID, OGMGID, OGMMID, OGMCLASS, OGMFLAG)
	values ('0104', '系统架构维护', 'G01', '00', 'G01', 3, 'Y')
insert into OPERGROUPMOD (OGMID, OGMNAME, OGMPID, OGMGID, OGMMID, OGMCLASS, OGMFLAG)
	values ('0106', '开发使用功能', 'G01', '00', 'G01', 3, 'Y')
insert into OPERGROUPMOD (OGMID, OGMNAME, OGMPID, OGMGID, OGMMID, OGMCLASS, OGMFLAG)
	values ('G02', '系统模块', '00', '00', 'G02', 2, 'N')
insert into OPERGROUPMOD (OGMID, OGMNAME, OGMPID, OGMGID, OGMMID, OGMCLASS, OGMFLAG)
	values ('0201', '用户申请', 'G02', '00', 'G02', 3, 'Y')

insert into OPERLOG (OLSEQNO, OLOPERID, OLWORKSTATION, OLDATETIME, OLFUNCID, OLDESC)
	values ('00000050', 'seastar', 'IP:192.168.0.101 名称:coffeeshop', 30-04-2004, '020110', '修改[工业用户]用户需要提交的资料列表。')
insert into OPERLOG (OLSEQNO, OLOPERID, OLWORKSTATION, OLDATETIME, OLFUNCID, OLDESC)
	values ('00000049', 'seastar', 'IP:192.168.0.101 名称:coffeeshop', 29-04-2004, '010102', '系统操作日志由操作员:系统管理员清空。')

insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010101', 'D')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010101', 'M')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010101', 'P')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010101', 'S')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010102', 'D')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010102', 'P')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010102', 'Y')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010201', 'C')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010201', 'D')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010201', 'M')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010201', 'N')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010201', 'S')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010202', 'D')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010202', 'M')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010202', 'N')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010202', 'P')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010202', 'Q')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010202', 'S')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010203', 'C')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010203', 'D')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010203', 'I')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010203', 'M')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010203', 'N')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010203', 'S')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010301', 'D')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010301', 'M')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010301', 'N')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010301', 'S')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010301', 'Y')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010302', 'D')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010302', 'M')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010302', 'N')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010302', 'S')