DOC/3设计阶段/DB/01_data/im_item_data.sql

INSERT INTO Im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON)
VALUES('00000001','登录','SystemAction/login','0','0',NULL,'1','2','0','#xe60a;');
INSERT INTO Im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON)
VALUES('011001','首页','main.html','2','0',NULL,'1','2','0','#xe612;');
INSERT INTO Im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON)
VALUES('01100101','修改基本信息','PersonManageAction/updatePersonInf','2','0',NULL,'1','2','0','#xe612;');
INSERT INTO Im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON)
VALUES('01100102','修改密码','PersonManageAction/updateUserPwd','2','0',NULL,'1','2','0','#xe612;');


INSERT INTO Im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON)
VALUES('101001','角色管理','roleManage/roleManage.html','2','0',NULL,'1','3','0','#xe6a8;');
INSERT INTO Im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON)
VALUES('10100101','角色新增','RoleManageAction/roleAdd','2','0',NULL,'1','3','0','#xe612;');
INSERT INTO Im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON)
VALUES('10100102','角色修改','RoleManageAction/roleModify','2','0',NULL,'1','3','0','#xe612;');
INSERT INTO Im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON)
VALUES('10100103','角色删除','RoleManageAction/roleDelete','2','0',NULL,'1','3','0','#xe612;');

INSERT INTO Im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON)
VALUES('101002','操作员管理','userManage/userManage.html','3','0',NULL,'1','3','0','#xe689;');
INSERT INTO Im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON)
VALUES('10100201','重置密码','UserManageAction/resetLoginPassword','3','0',NULL,'1','2','0','#xe613;');
INSERT INTO Im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON)
VALUES('10100202','新增操作员','UserManageAction/userAdd','3','0',NULL,'1','3','0','#xe613;');
INSERT INTO Im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON)
VALUES('10100203','修改操作员','UserManageAction/userModify','3','0',NULL,'1','3','0','#xe613;');
INSERT INTO Im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON)
VALUES('10100204','解冻操作员','UserManageAction/userThaw','3','0',NULL,'1','3','0','#xe613;');
INSERT INTO Im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON)
VALUES('10100205','注销','UserManageAction/userDelete','3','0',NULL,'1','3','0','#xe613;');

/**商户管理*/
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('101003','商户管理','departmentManage/departmentManage.html','1','0',NULL,'1','2','0','#xe6a8;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('10100301','添加商户','DepartmentManageAction/addBranch','1','0',NULL,'1','2','0','#xe60a;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('10100302','删除商户','DepartmentManageAction/deleteBranch','1','0',NULL,'1','2','0','#xe60a;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('10100303','修改商户','DepartmentManageAction/modifyBranch','1','0',NULL,'1','2','0','#xe60a;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('101004','日志管理','personManage/logManage.html','1','0',NULL,'1','2','0','#xe6a8;');
/**充值管理*/
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('101005','充值管理','rechargeManage/rechargeRuleManage.html','1','0',NULL,'1','2','0','#xe6a8;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('10100601','新增充值规则','RechargeManageAction/addRechargeRule','1','0',NULL,'1','2','0','#xe6a8;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('10100602','编辑充值规则','RechargeManageAction/modifyRechargeRule','1','0',NULL,'1','2','0','#xe6a8;');
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('10100603','删除充值规则','RechargeManageAction/deleteRechargeRule','1','0',NULL,'1','2','0','#xe6a8;');
/**游戏设置*/
insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('101006','游戏规则','gameSetupManage/gameSetupManage.html','1','0',NULL,'1','2','0','#xe6a8;');

INSERT INTO Im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON)
VALUES('101007','手机端操作员管理','userManage/wxuserManage.html','3','0',NULL,'1','3','0','#xe689;');

insert into im_item (ITM_ID, ITM_NAME, ITM_URL, ITM_SERIALNO, ITM_AUTH, ITM_AUTHTYPE, ITM_AUTHSHAPE, ITM_LEVEL, ITM_STT, ITM_ICON) values
('401005','订单管理','orderManage/orderManage.html','1','0',NULL,'1','2','0','#xe6a8;');