/*
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
*/


-- ----------------------------
-- Table structure for `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_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');
