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

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` 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`
-- ----------------------------
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=10000 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'cpiller', 'Claudia', 'Piller', 'claudia_piller', '2024-05-31 10:34:27', '1', '2024-06-10 17:37:57', null);
INSERT INTO `user` VALUES ('6', 'uboth', 'Ulvi', 'Both', 'ulvi_both', '2024-05-30 12:34:27', '1', '2024-06-10 17:37:57', null);
INSERT INTO `user` VALUES ('25', 'rkirstadt', 'Reinhard', 'Kirstadt', 'reinhard_kirstadt', '2024-05-22 07:32:27', '0', '2024-05-22 11:38:32', null);
INSERT INTO `user` VALUES ('8', 'jmarceau', 'Jean', 'Marceau', 'jean_marceau', '2024-05-23 09:34:27', '1', '2024-06-10 17:37:57', null);
INSERT INTO `user` VALUES ('9', 'sgharis', 'Sabrina', 'Gharis', 'sabrina_gharis', '2024-05-28 18:31:27', '0', '2024-06-10 17:37:57', null);
INSERT INTO `user` VALUES ('2045', 'pwollmann', 'Peter', 'Wollmann', 'peter_wollmann', '2024-05-31 10:34:27', '1', '2024-06-10 17:37:57', null);
INSERT INTO `user` VALUES ('2046', 'jkern', 'Julia', 'Kern', 'julia_kern', '2024-05-31 10:34:27', '1', '2024-06-10 17:37:57', null);
INSERT INTO `user` VALUES ('2047', 'bbrehm', 'Britta', 'Brehm', 'britta_brehm', '2024-05-31 10:34:27', '1', '2024-06-10 17: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-10 17: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);

-- ----------------------------
-- 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) 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');