hPLKbr9R

1-- ----------------------------
2-- Table structure for `kreditcenter_inquiries`
3-- ----------------------------
4DROP TABLE IF EXISTS `kreditcenter_inquiries`;
5CREATE TABLE `kreditcenter_inquiries` (
6  `id` int(11) NOT NULL AUTO_INCREMENT,
7  `status` enum('pending') NOT NULL DEFAULT 'pending',
8  `ticket-id` varchar(255) NOT NULL,
9  PRIMARY KEY (`id`)
10) ENGINE=InnoDB DEFAULT CHARSET=latin1;
11
12-- ----------------------------
13-- Records of kreditcenter_inquiries
14-- ----------------------------
15
16-- ----------------------------
17-- Table structure for `kreditcenter_permissions`
18-- ----------------------------
19DROP TABLE IF EXISTS `kreditcenter_permissions`;
20CREATE TABLE `kreditcenter_permissions` (
21  `id` int(11) NOT NULL AUTO_INCREMENT,
22  `permission` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
23  PRIMARY KEY (`id`)
24) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
25
26-- ----------------------------
27-- Records of kreditcenter_permissions
28-- ----------------------------
29INSERT INTO `kreditcenter_permissions` VALUES ('1', 'ALL_PERMISSIONS');
30INSERT INTO `kreditcenter_permissions` VALUES ('2', 'ACCESS_BY_MAINTENANCE');
31INSERT INTO `kreditcenter_permissions` VALUES ('3', 'ACCESS_ADMIN_PANEL');
32
33-- ----------------------------
34-- Table structure for `kreditcenter_plugins`
35-- ----------------------------
36DROP TABLE IF EXISTS `kreditcenter_plugins`;
37CREATE TABLE `kreditcenter_plugins` (
38  `id` int(11) NOT NULL AUTO_INCREMENT,
39  `package` varchar(255) NOT NULL,
40  `name` varchar(255) NOT NULL,
41  `version` varchar(255) NOT NULL,
42  `author` varchar(255) NOT NULL,
43  `contributors` text NOT NULL,
44  `requiredPlugins` text NOT NULL,
45  `enabled` enum('1','0') NOT NULL DEFAULT '1',
46  PRIMARY KEY (`id`,`package`)
47) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
48
49-- ----------------------------
50-- Records of kreditcenter_plugins
51-- ----------------------------
52INSERT INTO `kreditcenter_plugins` VALUES ('1', 'geograph.gwork.kreditcenter', 'KreditCenter', '1.0.0', 'geograph', '', '', '1');
53
54-- ----------------------------
55-- Table structure for `kreditcenter_plugins_event_listeners`
56-- ----------------------------
57DROP TABLE IF EXISTS `kreditcenter_plugins_event_listeners`;
58CREATE TABLE `kreditcenter_plugins_event_listeners` (
59  `id` int(11) NOT NULL AUTO_INCREMENT,
60  `pluginId` int(11) NOT NULL,
61  `eventName` varchar(255) NOT NULL,
62  `eventClass` text NOT NULL,
63  `listenerClass` text NOT NULL,
64  PRIMARY KEY (`id`)
65) ENGINE=InnoDB DEFAULT CHARSET=latin1;
66
67-- ----------------------------
68-- Records of kreditcenter_plugins_event_listeners
69-- ----------------------------
70
71-- ----------------------------
72-- Table structure for `kreditcenter_plugins_template_listeners`
73-- ----------------------------
74DROP TABLE IF EXISTS `kreditcenter_plugins_template_listeners`;
75CREATE TABLE `kreditcenter_plugins_template_listeners` (
76  `id` int(11) NOT NULL AUTO_INCREMENT,
77  `pluginId` int(11) NOT NULL,
78  `eventName` varchar(255) NOT NULL,
79  `templateName` varchar(255) NOT NULL,
80  `listenerClass` text NOT NULL,
81  PRIMARY KEY (`id`)
82) ENGINE=InnoDB DEFAULT CHARSET=latin1;
83
84-- ----------------------------
85-- Records of kreditcenter_plugins_template_listeners
86-- ----------------------------
87
88-- ----------------------------
89-- Table structure for `kreditcenter_settings`
90-- ----------------------------
91DROP TABLE IF EXISTS `kreditcenter_settings`;
92CREATE TABLE `kreditcenter_settings` (
93  `row` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
94  `value` text COLLATE utf8mb4_unicode_ci
95) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
96
97-- ----------------------------
98-- Records of kreditcenter_settings
99-- ----------------------------
100INSERT INTO `kreditcenter_settings` VALUES ('SitePath', 'http://localhost');
101INSERT INTO `kreditcenter_settings` VALUES ('WebPath', 'http://localhost/Web');
102INSERT INTO `kreditcenter_settings` VALUES ('SiteName', 'KreditCenter');
103INSERT INTO `kreditcenter_settings` VALUES ('Language', 'DE');
104INSERT INTO `kreditcenter_settings` VALUES ('Template', 'Default');
105INSERT INTO `kreditcenter_settings` VALUES ('Style', 'Default');
106INSERT INTO `kreditcenter_settings` VALUES ('Maintenance', '0');
107INSERT INTO `kreditcenter_settings` VALUES ('CountryAutoDetect', '0');
108INSERT INTO `kreditcenter_settings` VALUES ('LanguagesPath', 'Application/Languages');
109INSERT INTO `kreditcenter_settings` VALUES ('SupportMail', 'contact@kreditcenter.de');
110INSERT INTO `kreditcenter_settings` VALUES ('FacebookURL', 'http://facebook.de');
111INSERT INTO `kreditcenter_settings` VALUES ('TwitterURL', 'http://twitter.de');
112INSERT INTO `kreditcenter_settings` VALUES ('Location', '12345 Frankfurt am Main, Maxstraße 123');
113INSERT INTO `kreditcenter_settings` VALUES ('SMTPMail', 'max.heinrich3443@gmail.com');
114INSERT INTO `kreditcenter_settings` VALUES ('SMTPPassword', 'feksi342');
115INSERT INTO `kreditcenter_settings` VALUES ('SMTPHost', 'smtp.googlemail.com');
116INSERT INTO `kreditcenter_settings` VALUES ('SMTPPort', '587');
117INSERT INTO `kreditcenter_settings` VALUES ('SliderValue', '3000');
118INSERT INTO `kreditcenter_settings` VALUES ('SliderMin', '1000');
119INSERT INTO `kreditcenter_settings` VALUES ('SliderMax', '5000');
120
121-- ----------------------------
122-- Table structure for `kreditcenter_users`
123-- ----------------------------
124DROP TABLE IF EXISTS `kreditcenter_users`;
125CREATE TABLE `kreditcenter_users` (
126  `id` int(11) NOT NULL AUTO_INCREMENT,
127  `username` varchar(255) NOT NULL,
128  `mail` varchar(255) NOT NULL,
129  `password` varchar(255) NOT NULL,
130  PRIMARY KEY (`id`)
131) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
132
133-- ----------------------------
134-- Records of kreditcenter_users
135-- ----------------------------
136INSERT INTO `kreditcenter_users` VALUES ('1', 'Administrator', 'admin@example.com', '$2y$10$bdRUaxYP4Sa9GVW1KDWKeuHLxKFCpMfiL2kzo3ahNFq8q9RwqIzNG');
137
138-- ----------------------------
139-- Table structure for `kreditcenter_users_bans`
140-- ----------------------------
141DROP TABLE IF EXISTS `kreditcenter_users_bans`;
142CREATE TABLE `kreditcenter_users_bans` (
143  `id` int(11) NOT NULL AUTO_INCREMENT,
144  `banType` enum('id','ip') NOT NULL DEFAULT 'id',
145  `value` varchar(255) NOT NULL,
146  `reason` text NOT NULL,
147  `expire` varchar(255) NOT NULL DEFAULT '123456789',
148  `addedBy` int(11) NOT NULL DEFAULT '0',
149  `timestamp` varchar(255) NOT NULL DEFAULT '123456789',
150  PRIMARY KEY (`id`),
151  KEY `value` (`value`) USING BTREE,
152  KEY `bantype` (`banType`)
153) ENGINE=InnoDB DEFAULT CHARSET=latin1;
154
155-- ----------------------------
156-- Records of kreditcenter_users_bans
157-- ----------------------------
158
159-- ----------------------------
160-- Table structure for `kreditcenter_users_permissions`
161-- ----------------------------
162DROP TABLE IF EXISTS `kreditcenter_users_permissions`;
163CREATE TABLE `kreditcenter_users_permissions` (
164  `id` int(11) NOT NULL AUTO_INCREMENT,
165  `permission` int(11) NOT NULL DEFAULT '0',
166  `userid` int(11) NOT NULL DEFAULT '0',
167  PRIMARY KEY (`id`)
168) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
169
170-- ----------------------------
171-- Records of kreditcenter_users_permissions
172-- ----------------------------
173INSERT INTO `kreditcenter_users_permissions` VALUES ('1', '1', '1');