SQL] Query jsh_erp start
[ERR] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
[ERR]

-- Table structure for jsh_userbusiness

DROP TABLE IF EXISTS jsh_userbusiness;
CREATE TABLE jsh_userbusiness (
Id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
Type varchar(50) DEFAULT NULL COMMENT '类别',
KeyId varchar(50) DEFAULT NULL COMMENT '主 ID',
Value varchar(10000) DEFAULT NULL COMMENT '值',
BtnStr varchar(2000) DEFAULT NULL COMMENT '按钮权限',
PRIMARY KEY (Id)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COMMENT='用户 / 角色 / 模块关系表';

-- Records of jsh_userbusiness

INSERT INTO jsh_userbusiness VALUES ('1', 'RoleAPP', '4', '[23][24][25][27][8][26][22][7][3][6]', null);
INSERT INTO jsh_userbusiness VALUES ('2', 'RoleAPP', '5', '[8][7][6]', null);
INSERT INTO jsh_userbusiness VALUES ('3', 'RoleAPP', '6', '[21][1][8]', null);
INSERT INTO jsh_userbusiness VALUES ('4', 'RoleAPP', '7', '[21][1][8][11]', null);
INSERT INTO jsh_userbusiness VALUES ('5', 'RoleFunctions', '4', '[13][12][16][14][15][234][236][22][23][220][25][217][218][26][194][195][31][213][232][233][59][207][208][209][216][226][227][228][229][235][237][210][211][214][215][33][200][201][41][199][202][40][197][203][204][205][206][212]', '[{"funId":"25","btnStr":"1"},{"funId":"217","btnStr":"1"},{"funId":"218","btnStr":"1"},{"funId":"232","btnStr":"3"},{"funId":"233","btnStr":"3"},{"funId":"33","btnStr":"3"},{"funId":"200","btnStr":"3"},{"funId":"201","btnStr":"3"},{"funId":"210","btnStr":"3"},{"funId":"211","btnStr":"3"},{"funId":"214","btnStr":"3"},{"funId":"215","btnStr":"3"},{"funId":"41","btnStr":"3"},{"funId":"199","btnStr":"3"},{"funId":"202","btnStr":"3"},{"funId":"40","btnStr":"3"}]');
INSERT INTO jsh_userbusiness VALUES ('6', 'RoleFunctions', '5', '[22][23][25][26][194][195][31][33][200][201][41][199][202]', null);
INSERT INTO jsh_userbusiness VALUES ('7', 'RoleFunctions', '6', '[13][12][16][33]', '[{"funId":"33","btnStr":"4"}]');
INSERT INTO jsh_userbusiness VALUES ('8', 'RoleAPP', '8', '[21][1][8][11][10]', null);
INSERT INTO jsh_userbusiness VALUES ('9', 'RoleFunctions', '7', '[168][13][12][16][14][15][189][18][19][132]', null);
INSERT INTO jsh_userbusiness VALUES ('10', 'RoleFunctions', '8', '[168][13][12][16][14][15][189][18][19][132][22][23][25][26][27][157][158][155][156][125][31][127][126][128][33][34][35][36][37][39][40][41][42][43][46][47][48][49][50][51][52][53][54][55][56][57][192][59][60][61][62][63][65][66][68][69][70][71][73][74][76][77][79][191][81][82][83][85][89][161][86][176][165][160][28][134][91][92][29][94][95][97][104][99][100][101][102][105][107][108][110][111][113][114][116][117][118][120][121][131][135][123][122][20][130][146][147][138][148][149][153][140][145][184][152][143][170][171][169][166][167][163][164][172][173][179][178][181][182][183][186][187]', null);
INSERT INTO jsh_userbusiness VALUES ('11', 'RoleFunctions', '9', '[168][13][12][16][14][15][189][18][19][132][22][23][25][26][27][157][158][155][156][125][31][127][126][128][33][34][35][36][37][39][40][41][42][43][46][47][48][49][50][51][52][53][54][55][56][57][192][59][60][61][62][63][65][66][68][69][70][71][73][74][76][77][79][191][81][82][83][85][89][161][86][176][165][160][28][134][91][92][29][94][95][97][104][99][100][101][102][105][107][108][110][111][113][114][116][117][118][120][121][131][135][123][122][20][130][146][147][138][148][149][153][140][145][184][152][143][170][171][169][166][167][163][164][172][173][179][178][181][182][183][186][187][188]', null);
INSERT INTO jsh_userbusiness VALUES ('12', 'UserRole', '1', '[5]', null);
INSERT INTO jsh_userbusiness VALUES ('13', 'UserRole', '2', '[6][7]', null);
INSERT INTO jsh_userbusiness VALUES ('14', 'UserDepot', '2', '[1][2][6][7]', null);
INSERT INTO jsh_userbusiness VALUES ('15', 'UserDepot', '1', '[1][2][5][6][7][10][12][14][15][17]', null);
INSERT INTO jsh_userbusiness VALUES
[SQL] Finished with error