/*
Navicat MySQL Data Transfer

Source Server         : GUH - DEMO - daccord AG - root@172.16.78.41
Source Server Version : 50505
Source Host           : 172.16.78.41:3306
Source Database       : contacts

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

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


-- ----------------------------
-- Table structure for `roles`
-- ----------------------------
CREATE TABLE `roles` (
  `roleid` int(11) NOT NULL AUTO_INCREMENT,
  `name` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  PRIMARY KEY (`roleid`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES ('1', 'Administrator', 'Anlage und Pflege von allen Kontakten und Firmen');
INSERT INTO `roles` VALUES ('2', 'Salesperson', 'Anlage und Pflege von ihm zugewiesenen Kontakten und Firmen');
INSERT INTO `roles` VALUES ('3', 'User', 'Unternehmen und Kontakte einsehen');
INSERT INTO `roles` VALUES ('4', 'Großkunden', 'Erlaubt den schreibenden Zugriff auf Großkunden');
INSERT INTO `roles` VALUES ('5', 'Partner', 'Erlaubt den schreibenden Zugriff auf Partnerinformationen');
INSERT INTO `roles` VALUES ('6', 'Vertragsansprechpartner', 'Erlaubt den schreibenden Zugriff auf die Ansprechpartner von Verträgen');
INSERT INTO `roles` VALUES ('7', 'Interessenten', 'Erlaubt den schreibenden Zugriff auf Interessenten');
INSERT INTO `roles` VALUES ('8', 'Kunden A-D', 'Erlaubt den schreibenden Zugriff auf Kunden von A-D');
INSERT INTO `roles` VALUES ('9', 'Kunden E-H', 'Erlaubt den schreibenden Zugriff auf Kunden von E-H');
INSERT INTO `roles` VALUES ('10', 'Kunden I-L', 'Erlaubt den schreibenden Zugriff auf Kunden von I-L');
INSERT INTO `roles` VALUES ('11', 'Kunden M-P', 'Erlaubt den schreibenden Zugriff auf Kunden von M-P');
INSERT INTO `roles` VALUES ('12', 'Kunden Q-T', 'Erlaubt den schreibenden Zugriff auf Kunden von Q-T');
INSERT INTO `roles` VALUES ('13', 'Kunden U-Z', 'Erlaubt den schreibenden Zugriff auf Kunden von U-Z');

-- ----------------------------
-- Table structure for `user_role_relations`
-- ----------------------------
CREATE TABLE `user_role_relations` (
  `user_role_relationid` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `roleid` int(11) DEFAULT NULL,
  PRIMARY KEY (`user_role_relationid`)
) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_role_relations
-- ----------------------------
INSERT INTO `user_role_relations` VALUES ('1', '44', '1');
INSERT INTO `user_role_relations` VALUES ('2', '2044', '3');
INSERT INTO `user_role_relations` VALUES ('3', '44', '3');
INSERT INTO `user_role_relations` VALUES ('4', '8', '3');
INSERT INTO `user_role_relations` VALUES ('5', '66', '3');
INSERT INTO `user_role_relations` VALUES ('6', '2029', '3');
INSERT INTO `user_role_relations` VALUES ('7', '2039', '3');
INSERT INTO `user_role_relations` VALUES ('8', '2045', '4');
INSERT INTO `user_role_relations` VALUES ('9', '2045', '5');
INSERT INTO `user_role_relations` VALUES ('10', '2045', '6');
INSERT INTO `user_role_relations` VALUES ('11', '2045', '7');
INSERT INTO `user_role_relations` VALUES ('12', '2045', '8');
INSERT INTO `user_role_relations` VALUES ('13', '2045', '9');
INSERT INTO `user_role_relations` VALUES ('14', '2045', '10');
INSERT INTO `user_role_relations` VALUES ('15', '2045', '11');
INSERT INTO `user_role_relations` VALUES ('16', '2045', '12');
INSERT INTO `user_role_relations` VALUES ('17', '2045', '13');
INSERT INTO `user_role_relations` VALUES ('18', '2046', '2');
INSERT INTO `user_role_relations` VALUES ('19', '2046', '8');
INSERT INTO `user_role_relations` VALUES ('20', '2046', '9');
INSERT INTO `user_role_relations` VALUES ('21', '2046', '10');
INSERT INTO `user_role_relations` VALUES ('22', '2037', '1');
INSERT INTO `user_role_relations` VALUES ('23', '2036', '1');
INSERT INTO `user_role_relations` VALUES ('24', '37', '4');
INSERT INTO `user_role_relations` VALUES ('25', '37', '5');
INSERT INTO `user_role_relations` VALUES ('26', '37', '7');
INSERT INTO `user_role_relations` VALUES ('27', '37', '8');
INSERT INTO `user_role_relations` VALUES ('28', '37', '9');
INSERT INTO `user_role_relations` VALUES ('29', '37', '10');
INSERT INTO `user_role_relations` VALUES ('30', '37', '11');
INSERT INTO `user_role_relations` VALUES ('31', '37', '12');
INSERT INTO `user_role_relations` VALUES ('32', '37', '13');
INSERT INTO `user_role_relations` VALUES ('33', '2047', '3');
INSERT INTO `user_role_relations` VALUES ('34', '2047', '4');
INSERT INTO `user_role_relations` VALUES ('35', '2047', '5');
INSERT INTO `user_role_relations` VALUES ('36', '2047', '6');
INSERT INTO `user_role_relations` VALUES ('37', '2048', '3');
INSERT INTO `user_role_relations` VALUES ('38', '2048', '4');
INSERT INTO `user_role_relations` VALUES ('39', '2048', '5');
INSERT INTO `user_role_relations` VALUES ('40', '2048', '6');
INSERT INTO `user_role_relations` VALUES ('41', '53', '3');
INSERT INTO `user_role_relations` VALUES ('42', '53', '4');
INSERT INTO `user_role_relations` VALUES ('43', '53', '5');
INSERT INTO `user_role_relations` VALUES ('44', '53', '6');
INSERT INTO `user_role_relations` VALUES ('45', '53', '8');
INSERT INTO `user_role_relations` VALUES ('46', '53', '9');
INSERT INTO `user_role_relations` VALUES ('47', '53', '10');
INSERT INTO `user_role_relations` VALUES ('48', '53', '11');
INSERT INTO `user_role_relations` VALUES ('49', '53', '12');
INSERT INTO `user_role_relations` VALUES ('50', '53', '13');
INSERT INTO `user_role_relations` VALUES ('51', '1', '1');
INSERT INTO `user_role_relations` VALUES ('52', '6', '4');
INSERT INTO `user_role_relations` VALUES ('53', '6', '5');
INSERT INTO `user_role_relations` VALUES ('54', '6', '6');
INSERT INTO `user_role_relations` VALUES ('55', '6', '7');
INSERT INTO `user_role_relations` VALUES ('56', '6', '8');
INSERT INTO `user_role_relations` VALUES ('57', '6', '9');
INSERT INTO `user_role_relations` VALUES ('58', '6', '10');
INSERT INTO `user_role_relations` VALUES ('59', '6', '11');
INSERT INTO `user_role_relations` VALUES ('60', '6', '12');
INSERT INTO `user_role_relations` VALUES ('61', '6', '13');
INSERT INTO `user_role_relations` VALUES ('62', '90', '3');
INSERT INTO `user_role_relations` VALUES ('63', '91', '3');
INSERT INTO `user_role_relations` VALUES ('64', '92', '3');
INSERT INTO `user_role_relations` VALUES ('65', '150', '3');
INSERT INTO `user_role_relations` VALUES ('66', '151', '3');
INSERT INTO `user_role_relations` VALUES ('67', '152', '3');
INSERT INTO `user_role_relations` VALUES ('68', '26', '3');
INSERT INTO `user_role_relations` VALUES ('69', '27', '3');
INSERT INTO `user_role_relations` VALUES ('70', '3', '3');
INSERT INTO `user_role_relations` VALUES ('71', '4', '3');
INSERT INTO `user_role_relations` VALUES ('72', '251', '2');
INSERT INTO `user_role_relations` VALUES ('73', '251', '11');
INSERT INTO `user_role_relations` VALUES ('74', '251', '12');
INSERT INTO `user_role_relations` VALUES ('75', '251', '13');
INSERT INTO `user_role_relations` VALUES ('76', '2051', '3');
INSERT INTO `user_role_relations` VALUES ('77', '2052', '2');
INSERT INTO `user_role_relations` VALUES ('78', '2053', '2');
INSERT INTO `user_role_relations` VALUES ('79', '333', '3');
INSERT INTO `user_role_relations` VALUES ('80', '333', '7');
INSERT INTO `user_role_relations` VALUES ('81', '334', '3');
INSERT INTO `user_role_relations` VALUES ('82', '334', '7');
