/*
Navicat MySQL Data Transfer

Source Server         : GUH - DEMO - daccord AG 
Source Server Version : 50505
Source Host           : none
Source Database       : HR

Target Server Type    : MYSQL
Target Server Version : 50505
File Encoding         : 65001

Date: 2024-08-06 17:22:13
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `roles`
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (
  `roleid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`roleid`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES ('1', 'Personalverwaltung', 'Anlegen, deaktiveren von Mitarbeiten und Stammdatenpflege');
INSERT INTO `roles` VALUES ('2', 'Reisemanagement User', 'Darf eigene Reisekosten einreichen und sehen');
INSERT INTO `roles` VALUES ('3', 'Lohn und Gehalt User', 'Darf seine eigenen Lohn und Gehaltzettel ansehen');
INSERT INTO `roles` VALUES ('4', 'Lohn und Gehalt Team', 'Darf die Lohn und Gehaltzettel aus seinem Teams ansehen');
INSERT INTO `roles` VALUES ('5', 'Lohn und Gehalt Admin', 'Macht die Lohnabrechnung für alle Mitarbeiter');
INSERT INTO `roles` VALUES ('6', 'Urlaub und Krankheit User', 'Darf eigene Urlaubsanträge stellen, sehen und sich Krank melden');
INSERT INTO `roles` VALUES ('7', 'Urlaub und Krankheit Team', 'Darf Urlaube und Krankmeldungen seines Teams sehen und genehmigen');
INSERT INTO `roles` VALUES ('8', 'Urlaub und Krankheit Admin', 'Darf alle Urlaube und Krankmeldungen sehen und genehmigen');
INSERT INTO `roles` VALUES ('9', 'Administrator', 'Zugriff und Pflege von allen Bereichen und neue Rechte vergeben');
INSERT INTO `roles` VALUES ('10', 'Reisemanagement Team', 'Darf die Reisekosten seines Teams sehen und genehmigen');
INSERT INTO `roles` VALUES ('12', 'Arbeitsmittel User', 'Darf seine eigenen Arbeitsmittel einsehen und beantragen');
INSERT INTO `roles` VALUES ('13', 'Arbeitsmittel Team', 'Darf Arbeitsmittel seines Teams einsehen, zustimmend weitergeben und ablehnen');
INSERT INTO `roles` VALUES ('14', 'Arbeitsmittel Admin', 'Kann alle Arbeitsmittel einsehen, bearbeiten und final genehmigen');
INSERT INTO `roles` VALUES ('15', 'Reisemanagement Admin', 'Darf alle Reiskeosten einsehen, bearbeiten und an die Buchhaltung geben');
INSERT INTO `roles` VALUES ('16', 'Personalverwaltung Personalakte', 'Pflege der digitalen Personalakten');

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `userid` int(11) NOT NULL AUTO_INCREMENT,
  `username` text DEFAULT NULL,
  `givenname` text DEFAULT NULL,
  `surname` text DEFAULT NULL,
  `userdn` text DEFAULT NULL,
  `passwordlastset` datetime DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `logindatetime` datetime DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=10003 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'cpiller', 'Claudia', 'Piller', 'claudia_piller', '2024-05-29 16:34:27', '1', '2024-06-10 17:37:57', null);
INSERT INTO `user` VALUES ('6', 'uboth', 'Ulvi', 'Both', 'ulvi_both', '2024-05-19 07:34:27', '1', '2024-06-10 17:37:57', null);
INSERT INTO `user` VALUES ('25', 'rkirstadt', 'Reinhard', 'Kirstadt', 'reinhard_kirstadt', '2024-05-05 09:32:27', '0', '2024-05-22 11:38:32', null);
INSERT INTO `user` VALUES ('8', 'jmarceau', 'Jean', 'Marceau', 'jean_marceau', '2024-05-14 18:34:27', '1', '2024-06-21 06:37:57', null);
INSERT INTO `user` VALUES ('9', 'sgharis', 'Sabrina', 'Gharis', 'sabrina_gharis', '2024-05-28 16:31:27', '0', '2024-06-21 13:37:57', null);
INSERT INTO `user` VALUES ('2045', 'pwollmann', 'Peter', 'Wollmann', 'peter_wollmann', '2024-05-31 10:34:27', '1', '2024-06-10 12:37:57', null);
INSERT INTO `user` VALUES ('2046', 'jkern', 'Julia', 'Kern', 'julia_kern', '2024-06-01 03:34:27', '1', '2024-06-10 13:37:57', null);
INSERT INTO `user` VALUES ('2047', 'bbrehm', 'Britta', 'Brehm', 'britta_brehm', '2024-05-25 06:34:27', '1', '2024-06-23 09:37:57', null);
INSERT INTO `user` VALUES ('2048', 'snietsch', 'Stefanie', 'Nietsch', 'stefanie_nietsch', '2024-05-31 10:34:27', '1', '2024-06-10 17:37:57', null);
INSERT INTO `user` VALUES ('66', 'rhahn', 'Rainer', 'Hahn', 'rainer_hahn', '2024-05-31 10:34:27', '1', '2024-06-10 17:37:57', null);
INSERT INTO `user` VALUES ('37', 'yklocke', 'Yvonne', 'Klocke', 'yvonne_klocke', '2024-05-31 10:34:27', '1', '2024-06-10 17:37:57', null);
INSERT INTO `user` VALUES ('44', 'iwalk', 'Ingetraut', 'Walk', 'ingetraut_walk', null, '1', null, null);
INSERT INTO `user` VALUES ('2029', 'lkuschalt', 'Lino', 'Kuschalt', 'lino_kuschalt', '2024-05-31 10:34:27', '1', '2024-06-23 16:37:57', null);
INSERT INTO `user` VALUES ('2036', 'hnosfranz', 'Heidi', 'Nosfranz', 'heidi_nosfranz', '2024-05-31 10:34:27', '1', '2024-06-10 17:37:57', null);
INSERT INTO `user` VALUES ('2037', 'jmiller', 'John', 'Miller', 'john_miller', '2024-05-31 10:34:27', '1', '2024-06-10 17:37:57', null);
INSERT INTO `user` VALUES ('2039', 'vbaschtus', 'Vlavius', 'Baschtus', 'vlavius_baschtus', '2024-05-31 10:34:27', '1', '2024-06-10 17:37:57', null);
INSERT INTO `user` VALUES ('2044', 'hschuldtmann', 'Henrietta', 'Schuldtmann', 'henrietta_schuldtmann', '2024-05-31 10:34:27', '1', '2024-06-10 17:37:57', null);
INSERT INTO `user` VALUES ('53', 'aherzog', 'Aline', 'Herzog', 'aline_herzog', '2024-05-31 10:34:27', '1', '2024-06-10 17:37:57', null);
INSERT INTO `user` VALUES ('9999', 'sadmin', 'Super', 'Admin', null, '2021-02-04 10:39:50', '1', '2024-01-02 16:37:12', 'Administrator');
INSERT INTO `user` VALUES ('5000', 'tl_test', 'Teamlead', 'Test', 'temlead_test', '2023-07-05 09:56:34', '1', '2023-07-06 10:43:25', 'Testuser');
INSERT INTO `user` VALUES ('90', 'mschmidt', 'Martin', 'Schmidt', 'martin_schmidt', '2024-05-15 10:45:05', '1', '2024-06-14 10:45:24', null);
INSERT INTO `user` VALUES ('91', 'ychang', 'Yen', 'Chang', 'yen_chang', '2024-06-09 10:46:06', '1', '2024-06-18 10:46:19', null);
INSERT INTO `user` VALUES ('92', 'ayariz', 'Ahmed', 'Yariz', 'ahmed_yariz', '2024-05-17 10:47:00', '1', '2024-06-15 10:47:11', null);
INSERT INTO `user` VALUES ('150', 'vbelinda', 'Belinda', 'Vodel', 'belinda_vodel', '2024-06-06 10:50:57', '1', '2024-06-17 10:51:06', null);
INSERT INTO `user` VALUES ('151', 'sphilipp', 'Philipp', 'Schahn', 'philip_schahn', '2024-06-01 13:52:30', '1', '2024-06-17 18:52:40', null);
INSERT INTO `user` VALUES ('152', 'rklara', 'Klara', 'Rosenkranz', 'klara_rosenkranz', '2024-05-17 10:52:23', '1', '2024-06-18 17:52:48', null);
INSERT INTO `user` VALUES ('26', 'zhans', 'Hans', 'Zimmermann', 'hans_zimmermann', '2024-06-12 10:56:32', '1', '2024-06-18 10:56:47', null);
INSERT INTO `user` VALUES ('27', 'yniti', 'Yildiz', 'Niti', 'yildiz_niti', '2024-05-31 10:58:11', '1', '2024-06-18 10:58:25', null);
INSERT INTO `user` VALUES ('3', 'swinkelmann', 'Sebastian', 'Winkelmann', 'sebastian_winkelmann', '2024-05-30 11:04:08', '0', '2024-06-18 11:04:30', null);
INSERT INTO `user` VALUES ('4', 'jforster', 'Janett', 'Forster', 'janett_forster', '2024-06-15 22:04:13', '1', '2024-06-18 11:04:56', null);
INSERT INTO `user` VALUES ('251', 'gschmidt', 'Gisela', 'Schmidt', 'gisela_schmidt', '2024-05-28 11:07:33', '1', '2024-05-28 12:07:39', null);
INSERT INTO `user` VALUES ('2051', 'cpasch', 'Carina', 'Pasch', 'carina_pasch', '2024-06-07 11:11:51', '1', '2024-06-13 11:12:02', null);
INSERT INTO `user` VALUES ('2052', 'aschmidt', 'Annegret', 'Schmidt', 'annegret_schmidt', '2024-05-27 11:16:23', '1', '2024-06-18 06:16:35', null);
INSERT INTO `user` VALUES ('2053', 'fweimann', 'Freia', 'Weimann', 'freia_weimann', '2024-06-12 11:16:10', '0', '2024-06-18 11:16:17', null);
INSERT INTO `user` VALUES ('333', 'cjunaz', 'Carlos', 'Junaz', 'carlos_junaz', '2024-06-13 09:18:39', '1', '2024-06-15 11:18:55', null);
INSERT INTO `user` VALUES ('334', 'smatsuri', 'Soshi', 'Matsuri', 'soshi_matsuri', '2024-06-14 11:21:06', '1', '2024-06-18 05:21:11', null);
INSERT INTO `user` VALUES ('60', 'mmeier', 'Maximilian', 'Meier', 'maximilian_meier', '2024-06-05 12:01:08', '1', '2024-05-28 12:01:24', null);
INSERT INTO `user` VALUES ('61', 'rdold', 'Richard', 'Dold', 'richard_dold', '2024-06-18 12:01:04', '1', '2024-06-06 12:01:20', null);
INSERT INTO `user` VALUES ('62', 'brieke', 'Bettina', 'Rieke', 'bettina_rieke', '2024-06-09 15:00:25', '1', '2024-05-29 12:01:13', null);
INSERT INTO `user` VALUES ('10000', 'plausenberger', 'Pascal', 'Lausenberger', 'pascal_lausenberger', '2024-06-20 12:50:39', '1', '2024-06-13 16:50:33', null);
INSERT INTO `user` VALUES ('10001', 'pwalk', 'Peter', 'Walk', 'peter_walk', '2024-06-19 16:50:46', '1', '2024-06-13 16:50:28', null);
INSERT INTO `user` VALUES ('10002', 'crocker', 'Camilia', 'Rocker', 'camilia_rocker', '2024-06-15 21:50:54', '1', '2024-06-13 16:50:23', null);
INSERT INTO `user` VALUES ('14', 'eclarendince', 'Elizabeth', 'Clarendince', 'elizabeth_clarendince', '2024-06-20 11:46:23', '1', '2024-06-17 09:46:31', null);

-- ----------------------------
-- Table structure for `user_role_relations`
-- ----------------------------
DROP TABLE IF EXISTS `user_role_relations`;
CREATE TABLE `user_role_relations` (
  `user_role_relationid` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `roleid` int(11) NOT NULL,
  PRIMARY KEY (`user_role_relationid`)
) ENGINE=InnoDB AUTO_INCREMENT=202 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of user_role_relations
-- ----------------------------
INSERT INTO `user_role_relations` VALUES ('1', '2052', '1');
INSERT INTO `user_role_relations` VALUES ('2', '44', '1');
INSERT INTO `user_role_relations` VALUES ('3', '2051', '5');
INSERT INTO `user_role_relations` VALUES ('4', '2048', '5');
INSERT INTO `user_role_relations` VALUES ('5', '2053', '8');
INSERT INTO `user_role_relations` VALUES ('6', '2037', '9');
INSERT INTO `user_role_relations` VALUES ('7', '1', '9');
INSERT INTO `user_role_relations` VALUES ('8', '2048', '14');
INSERT INTO `user_role_relations` VALUES ('9', '90', '14');
INSERT INTO `user_role_relations` VALUES ('10', '91', '14');
INSERT INTO `user_role_relations` VALUES ('11', '2053', '16');
INSERT INTO `user_role_relations` VALUES ('12', '6', '2');
INSERT INTO `user_role_relations` VALUES ('13', '25', '2');
INSERT INTO `user_role_relations` VALUES ('14', '8', '2');
INSERT INTO `user_role_relations` VALUES ('15', '9', '2');
INSERT INTO `user_role_relations` VALUES ('16', '2045', '2');
INSERT INTO `user_role_relations` VALUES ('17', '2046', '2');
INSERT INTO `user_role_relations` VALUES ('18', '2047', '2');
INSERT INTO `user_role_relations` VALUES ('19', '2048', '2');
INSERT INTO `user_role_relations` VALUES ('20', '66', '2');
INSERT INTO `user_role_relations` VALUES ('21', '37', '2');
INSERT INTO `user_role_relations` VALUES ('22', '44', '2');
INSERT INTO `user_role_relations` VALUES ('23', '2036', '2');
INSERT INTO `user_role_relations` VALUES ('24', '2037', '2');
INSERT INTO `user_role_relations` VALUES ('25', '2039', '2');
INSERT INTO `user_role_relations` VALUES ('26', '2044', '2');
INSERT INTO `user_role_relations` VALUES ('27', '53', '2');
INSERT INTO `user_role_relations` VALUES ('28', '90', '2');
INSERT INTO `user_role_relations` VALUES ('29', '91', '2');
INSERT INTO `user_role_relations` VALUES ('30', '150', '2');
INSERT INTO `user_role_relations` VALUES ('31', '151', '2');
INSERT INTO `user_role_relations` VALUES ('32', '26', '2');
INSERT INTO `user_role_relations` VALUES ('33', '27', '2');
INSERT INTO `user_role_relations` VALUES ('34', '3', '2');
INSERT INTO `user_role_relations` VALUES ('35', '251', '2');
INSERT INTO `user_role_relations` VALUES ('36', '2052', '2');
INSERT INTO `user_role_relations` VALUES ('37', '2053', '2');
INSERT INTO `user_role_relations` VALUES ('38', '333', '2');
INSERT INTO `user_role_relations` VALUES ('39', '334', '2');
INSERT INTO `user_role_relations` VALUES ('40', '60', '2');
INSERT INTO `user_role_relations` VALUES ('41', '61', '2');
INSERT INTO `user_role_relations` VALUES ('42', '62', '2');
INSERT INTO `user_role_relations` VALUES ('43', '6', '4');
INSERT INTO `user_role_relations` VALUES ('44', '53', '4');
INSERT INTO `user_role_relations` VALUES ('45', '2036', '4');
INSERT INTO `user_role_relations` VALUES ('46', '2044', '4');
INSERT INTO `user_role_relations` VALUES ('47', '66', '4');
INSERT INTO `user_role_relations` VALUES ('48', '2045', '4');
INSERT INTO `user_role_relations` VALUES ('49', '37', '4');
INSERT INTO `user_role_relations` VALUES ('50', '10000', '4');
INSERT INTO `user_role_relations` VALUES ('51', '10001', '4');
INSERT INTO `user_role_relations` VALUES ('52', '10002', '4');
INSERT INTO `user_role_relations` VALUES ('53', '6', '7');
INSERT INTO `user_role_relations` VALUES ('54', '53', '7');
INSERT INTO `user_role_relations` VALUES ('55', '2036', '7');
INSERT INTO `user_role_relations` VALUES ('56', '2044', '7');
INSERT INTO `user_role_relations` VALUES ('57', '66', '7');
INSERT INTO `user_role_relations` VALUES ('58', '2045', '7');
INSERT INTO `user_role_relations` VALUES ('59', '37', '7');
INSERT INTO `user_role_relations` VALUES ('60', '10000', '7');
INSERT INTO `user_role_relations` VALUES ('61', '10001', '7');
INSERT INTO `user_role_relations` VALUES ('62', '10002', '7');
INSERT INTO `user_role_relations` VALUES ('63', '6', '10');
INSERT INTO `user_role_relations` VALUES ('64', '53', '10');
INSERT INTO `user_role_relations` VALUES ('65', '2036', '10');
INSERT INTO `user_role_relations` VALUES ('66', '2037', '10');
INSERT INTO `user_role_relations` VALUES ('67', '2044', '10');
INSERT INTO `user_role_relations` VALUES ('68', '66', '10');
INSERT INTO `user_role_relations` VALUES ('69', '2045', '10');
INSERT INTO `user_role_relations` VALUES ('70', '37', '10');
INSERT INTO `user_role_relations` VALUES ('71', '10000', '10');
INSERT INTO `user_role_relations` VALUES ('72', '10002', '10');
INSERT INTO `user_role_relations` VALUES ('83', '6', '13');
INSERT INTO `user_role_relations` VALUES ('84', '53', '13');
INSERT INTO `user_role_relations` VALUES ('85', '2036', '13');
INSERT INTO `user_role_relations` VALUES ('86', '2037', '13');
INSERT INTO `user_role_relations` VALUES ('87', '2044', '13');
INSERT INTO `user_role_relations` VALUES ('88', '66', '13');
INSERT INTO `user_role_relations` VALUES ('89', '2045', '13');
INSERT INTO `user_role_relations` VALUES ('90', '37', '13');
INSERT INTO `user_role_relations` VALUES ('91', '10000', '13');
INSERT INTO `user_role_relations` VALUES ('92', '10002', '13');
INSERT INTO `user_role_relations` VALUES ('93', '6', '12');
INSERT INTO `user_role_relations` VALUES ('94', '25', '12');
INSERT INTO `user_role_relations` VALUES ('95', '8', '12');
INSERT INTO `user_role_relations` VALUES ('96', '9', '12');
INSERT INTO `user_role_relations` VALUES ('97', '2045', '12');
INSERT INTO `user_role_relations` VALUES ('98', '2046', '12');
INSERT INTO `user_role_relations` VALUES ('99', '2047', '12');
INSERT INTO `user_role_relations` VALUES ('100', '2048', '12');
INSERT INTO `user_role_relations` VALUES ('101', '66', '12');
INSERT INTO `user_role_relations` VALUES ('102', '37', '12');
INSERT INTO `user_role_relations` VALUES ('103', '44', '12');
INSERT INTO `user_role_relations` VALUES ('104', '2029', '12');
INSERT INTO `user_role_relations` VALUES ('105', '2036', '12');
INSERT INTO `user_role_relations` VALUES ('106', '2037', '12');
INSERT INTO `user_role_relations` VALUES ('107', '2039', '12');
INSERT INTO `user_role_relations` VALUES ('108', '2044', '12');
INSERT INTO `user_role_relations` VALUES ('109', '53', '12');
INSERT INTO `user_role_relations` VALUES ('110', '90', '12');
INSERT INTO `user_role_relations` VALUES ('111', '91', '12');
INSERT INTO `user_role_relations` VALUES ('112', '92', '12');
INSERT INTO `user_role_relations` VALUES ('113', '150', '12');
INSERT INTO `user_role_relations` VALUES ('114', '151', '12');
INSERT INTO `user_role_relations` VALUES ('115', '152', '12');
INSERT INTO `user_role_relations` VALUES ('116', '26', '12');
INSERT INTO `user_role_relations` VALUES ('117', '27', '12');
INSERT INTO `user_role_relations` VALUES ('118', '3', '12');
INSERT INTO `user_role_relations` VALUES ('119', '4', '12');
INSERT INTO `user_role_relations` VALUES ('120', '251', '12');
INSERT INTO `user_role_relations` VALUES ('121', '2051', '12');
INSERT INTO `user_role_relations` VALUES ('122', '2052', '12');
INSERT INTO `user_role_relations` VALUES ('123', '2053', '12');
INSERT INTO `user_role_relations` VALUES ('124', '333', '12');
INSERT INTO `user_role_relations` VALUES ('125', '334', '12');
INSERT INTO `user_role_relations` VALUES ('126', '60', '12');
INSERT INTO `user_role_relations` VALUES ('127', '61', '12');
INSERT INTO `user_role_relations` VALUES ('128', '62', '12');
INSERT INTO `user_role_relations` VALUES ('129', '6', '3');
INSERT INTO `user_role_relations` VALUES ('130', '25', '3');
INSERT INTO `user_role_relations` VALUES ('131', '8', '3');
INSERT INTO `user_role_relations` VALUES ('132', '9', '3');
INSERT INTO `user_role_relations` VALUES ('133', '2045', '3');
INSERT INTO `user_role_relations` VALUES ('134', '2046', '3');
INSERT INTO `user_role_relations` VALUES ('135', '2047', '3');
INSERT INTO `user_role_relations` VALUES ('136', '2048', '3');
INSERT INTO `user_role_relations` VALUES ('137', '66', '3');
INSERT INTO `user_role_relations` VALUES ('138', '37', '3');
INSERT INTO `user_role_relations` VALUES ('139', '44', '3');
INSERT INTO `user_role_relations` VALUES ('140', '2036', '3');
INSERT INTO `user_role_relations` VALUES ('141', '2037', '3');
INSERT INTO `user_role_relations` VALUES ('142', '2039', '3');
INSERT INTO `user_role_relations` VALUES ('143', '2044', '3');
INSERT INTO `user_role_relations` VALUES ('144', '53', '3');
INSERT INTO `user_role_relations` VALUES ('145', '90', '3');
INSERT INTO `user_role_relations` VALUES ('146', '91', '3');
INSERT INTO `user_role_relations` VALUES ('147', '150', '3');
INSERT INTO `user_role_relations` VALUES ('148', '151', '3');
INSERT INTO `user_role_relations` VALUES ('149', '3', '3');
INSERT INTO `user_role_relations` VALUES ('150', '26', '3');
INSERT INTO `user_role_relations` VALUES ('151', '27', '3');
INSERT INTO `user_role_relations` VALUES ('152', '251', '3');
INSERT INTO `user_role_relations` VALUES ('153', '2051', '3');
INSERT INTO `user_role_relations` VALUES ('154', '2052', '3');
INSERT INTO `user_role_relations` VALUES ('155', '2053', '3');
INSERT INTO `user_role_relations` VALUES ('156', '333', '3');
INSERT INTO `user_role_relations` VALUES ('157', '334', '3');
INSERT INTO `user_role_relations` VALUES ('158', '60', '3');
INSERT INTO `user_role_relations` VALUES ('159', '61', '3');
INSERT INTO `user_role_relations` VALUES ('160', '62', '3');
INSERT INTO `user_role_relations` VALUES ('161', '6', '6');
INSERT INTO `user_role_relations` VALUES ('162', '25', '6');
INSERT INTO `user_role_relations` VALUES ('163', '8', '6');
INSERT INTO `user_role_relations` VALUES ('164', '9', '6');
INSERT INTO `user_role_relations` VALUES ('165', '2045', '6');
INSERT INTO `user_role_relations` VALUES ('166', '2046', '6');
INSERT INTO `user_role_relations` VALUES ('167', '2047', '6');
INSERT INTO `user_role_relations` VALUES ('168', '2048', '6');
INSERT INTO `user_role_relations` VALUES ('169', '66', '6');
INSERT INTO `user_role_relations` VALUES ('170', '37', '6');
INSERT INTO `user_role_relations` VALUES ('171', '44', '6');
INSERT INTO `user_role_relations` VALUES ('172', '2029', '6');
INSERT INTO `user_role_relations` VALUES ('173', '2036', '6');
INSERT INTO `user_role_relations` VALUES ('174', '2037', '6');
INSERT INTO `user_role_relations` VALUES ('175', '2039', '6');
INSERT INTO `user_role_relations` VALUES ('176', '2044', '6');
INSERT INTO `user_role_relations` VALUES ('177', '53', '6');
INSERT INTO `user_role_relations` VALUES ('178', '90', '6');
INSERT INTO `user_role_relations` VALUES ('179', '91', '6');
INSERT INTO `user_role_relations` VALUES ('180', '92', '6');
INSERT INTO `user_role_relations` VALUES ('181', '150', '6');
INSERT INTO `user_role_relations` VALUES ('182', '151', '6');
INSERT INTO `user_role_relations` VALUES ('183', '152', '6');
INSERT INTO `user_role_relations` VALUES ('184', '26', '6');
INSERT INTO `user_role_relations` VALUES ('185', '27', '6');
INSERT INTO `user_role_relations` VALUES ('186', '3', '6');
INSERT INTO `user_role_relations` VALUES ('187', '4', '6');
INSERT INTO `user_role_relations` VALUES ('188', '251', '6');
INSERT INTO `user_role_relations` VALUES ('189', '2051', '6');
INSERT INTO `user_role_relations` VALUES ('190', '2052', '6');
INSERT INTO `user_role_relations` VALUES ('191', '2053', '6');
INSERT INTO `user_role_relations` VALUES ('192', '333', '6');
INSERT INTO `user_role_relations` VALUES ('193', '334', '6');
INSERT INTO `user_role_relations` VALUES ('194', '60', '6');
INSERT INTO `user_role_relations` VALUES ('195', '61', '6');
INSERT INTO `user_role_relations` VALUES ('196', '62', '6');
INSERT INTO `user_role_relations` VALUES ('197', '14', '15');
INSERT INTO `user_role_relations` VALUES ('198', '14', '2');
INSERT INTO `user_role_relations` VALUES ('199', '14', '3');
INSERT INTO `user_role_relations` VALUES ('200', '14', '6');
INSERT INTO `user_role_relations` VALUES ('201', '14', '12');