· 7 years ago · Nov 13, 2018, 03:14 AM
1Starting...
2Reverse Engineering....
3Reverse engineering erp_api_authentication from def
4- Preparing...
5- Preparing...
6Reverse engineering tables from erp_api_authentication
7Reverse engineering triggers from erp_api_authentication
8Reverse engineering stored procedures from erp_api_authentication
9Reverse engineering functions from erp_api_authentication
10- Reverse engineered 0 objects
11Reverse Engineering finished
12Migrating...
13- Migrating...
14- Migrating schema erp_api_authentication...
15- Migrating schema contents for schema erp_api_authentication
16- Finalizing foreign key migration...
17- Migration finished
18Migrating done
19Generating Code...
20Generating Code done
21Creating target schema....
22- Creating schema in target MySQL server at Mysql@mjp-msc01-common-aurora-20181110-rdscluster-xkgb67a7c9dm.cluster-cmlhkki32r54.us-west-2.rds.amazonaws.com:3306...
23- Executing preamble script...
24Execute statement: SET FOREIGN_KEY_CHECKS = 0
25- Creating schema erp_api_authentication...
26Execute statement: DROP SCHEMA IF EXISTS `erp_api_authentication`
27Execute statement:
28
29 CREATE SCHEMA IF NOT EXISTS `erp_api_authentication`
30Scripts for 0 tables, 0 views and 0 routines were executed for schema erp_api_authentication
31- Executing postamble script...
32Execute statement: SET FOREIGN_KEY_CHECKS = 1
33- Schema created
34Creating target schema finished
35Selecting tables to copy...
36Selecting tables to copy done
37Counting table rows to copy....
38Counting table rows to copy finished
39Copying table data....
40Copying table data finished
41Reverse Engineering....
42Reverse engineering erp_core from def
43- Preparing...
44- Preparing...
45Reverse engineering tables from erp_core
46- Retrieving table erp_core.applications...
47- Reverse engineering erp_core.applications...
48- Retrieving table erp_core.cache...
49- Reverse engineering erp_core.cache...
50- Retrieving table erp_core.countries...
51- Reverse engineering erp_core.countries...
52- Retrieving table erp_core.events...
53- Reverse engineering erp_core.events...
54- Retrieving table erp_core.facilities...
55- Reverse engineering erp_core.facilities...
56- Retrieving table erp_core.facility_group_members...
57- Reverse engineering erp_core.facility_group_members...
58- Retrieving table erp_core.facility_group_settings...
59- Reverse engineering erp_core.facility_group_settings...
60- Retrieving table erp_core.facility_groups...
61- Reverse engineering erp_core.facility_groups...
62- Retrieving table erp_core.facility_modules...
63- Reverse engineering erp_core.facility_modules...
64- Retrieving table erp_core.failed_jobs...
65- Reverse engineering erp_core.failed_jobs...
66- Retrieving table erp_core.jobs...
67- Reverse engineering erp_core.jobs...
68- Retrieving table erp_core.licensing...
69- Reverse engineering erp_core.licensing...
70- Retrieving table erp_core.message_subscribers...
71- Reverse engineering erp_core.message_subscribers...
72- Retrieving table erp_core.migrations...
73- Reverse engineering erp_core.migrations...
74- Retrieving table erp_core.modules...
75- Reverse engineering erp_core.modules...
76- Retrieving table erp_core.object_files...
77- Reverse engineering erp_core.object_files...
78- Retrieving table erp_core.online_users...
79- Reverse engineering erp_core.online_users...
80- Retrieving table erp_core.organization_app_storage...
81- Reverse engineering erp_core.organization_app_storage...
82- Retrieving table erp_core.organization_master_users...
83- Reverse engineering erp_core.organization_master_users...
84- Retrieving table erp_core.organization_role_permission...
85- Reverse engineering erp_core.organization_role_permission...
86- Retrieving table erp_core.organization_roles...
87- Reverse engineering erp_core.organization_roles...
88- Retrieving table erp_core.organizations...
89- Reverse engineering erp_core.organizations...
90- Retrieving table erp_core.password_reset_log...
91- Reverse engineering erp_core.password_reset_log...
92- Retrieving table erp_core.password_resets...
93- Reverse engineering erp_core.password_resets...
94- Retrieving table erp_core.permissions...
95- Reverse engineering erp_core.permissions...
96- Retrieving table erp_core.provinces...
97- Reverse engineering erp_core.provinces...
98- Retrieving table erp_core.qlikAttributes...
99- Reverse engineering erp_core.qlikAttributes...
100- Retrieving table erp_core.qlikSACombi...
101- Reverse engineering erp_core.qlikSACombi...
102- Retrieving table erp_core.qlikSATest...
103- Reverse engineering erp_core.qlikSATest...
104- Retrieving table erp_core.qlikSATestUsers...
105- Reverse engineering erp_core.qlikSATestUsers...
106- Retrieving table erp_core.qlikSectionAccess...
107- Reverse engineering erp_core.qlikSectionAccess...
108- Retrieving table erp_core.qlikUsers...
109- Reverse engineering erp_core.qlikUsers...
110- Retrieving table erp_core.qlik_timezone_mappings...
111- Reverse engineering erp_core.qlik_timezone_mappings...
112- Retrieving table erp_core.reporting_access_levels...
113- Reverse engineering erp_core.reporting_access_levels...
114- Retrieving table erp_core.services...
115- Reverse engineering erp_core.services...
116- Retrieving table erp_core.setting_values...
117- Reverse engineering erp_core.setting_values...
118- Retrieving table erp_core.settings...
119- Reverse engineering erp_core.settings...
120- Retrieving table erp_core.storage...
121- Reverse engineering erp_core.storage...
122- Retrieving table erp_core.token_requests...
123- Reverse engineering erp_core.token_requests...
124- Retrieving table erp_core.user_addresses...
125- Reverse engineering erp_core.user_addresses...
126- Retrieving table erp_core.user_facilities...
127- Reverse engineering erp_core.user_facilities...
128- Retrieving table erp_core.user_facility_roles...
129- Reverse engineering erp_core.user_facility_roles...
130- Retrieving table erp_core.user_ids...
131- Reverse engineering erp_core.user_ids...
132- Retrieving table erp_core.user_integration_ids...
133- Reverse engineering erp_core.user_integration_ids...
134- Retrieving table erp_core.user_notes...
135- Reverse engineering erp_core.user_notes...
136- Retrieving table erp_core.user_phones...
137- Reverse engineering erp_core.user_phones...
138- Retrieving table erp_core.user_settings...
139- Reverse engineering erp_core.user_settings...
140- Retrieving table erp_core.users...
141- Reverse engineering erp_core.users...
142Reverse engineering triggers from erp_core
143Reverse engineering stored procedures from erp_core
144Reverse engineering functions from erp_core
145- Reverse engineered 48 objects
146Reverse Engineering finished
147Migrating...
148- Migrating...
149- Migrating schema erp_core...
150- Migrating schema contents for schema erp_core
151- Table erp_core.applications migrated
152- Table erp_core.cache migrated
153- Table erp_core.countries migrated
154- Table erp_core.events migrated
155- Table erp_core.facilities migrated
156- Table erp_core.facility_group_members migrated
157- Table erp_core.facility_group_settings migrated
158- Table erp_core.facility_groups migrated
159- Table erp_core.facility_modules migrated
160- Table erp_core.failed_jobs migrated
161- Table erp_core.jobs migrated
162- Table erp_core.licensing migrated
163- Table erp_core.message_subscribers migrated
164- Table erp_core.migrations migrated
165- Table erp_core.modules migrated
166- Table erp_core.object_files migrated
167- Table erp_core.online_users migrated
168- Table erp_core.organization_app_storage migrated
169- Table erp_core.organization_master_users migrated
170- Table erp_core.organization_role_permission migrated
171- Table erp_core.organization_roles migrated
172- Table erp_core.organizations migrated
173- Table erp_core.password_reset_log migrated
174- Table erp_core.password_resets migrated
175- Table erp_core.permissions migrated
176- Table erp_core.provinces migrated
177- Table erp_core.qlik_timezone_mappings migrated
178- Table erp_core.reporting_access_levels migrated
179- Table erp_core.services migrated
180- Table erp_core.setting_values migrated
181- Table erp_core.settings migrated
182- Table erp_core.storage migrated
183- Table erp_core.token_requests migrated
184- Table erp_core.user_addresses migrated
185- Table erp_core.user_facilities migrated
186- Table erp_core.user_facility_roles migrated
187- Table erp_core.user_ids migrated
188- Table erp_core.user_integration_ids migrated
189- Table erp_core.user_notes migrated
190- Table erp_core.user_phones migrated
191- Table erp_core.user_settings migrated
192- Table erp_core.users migrated
193- View erp_core.qlikAttributes migrated
194- View erp_core.qlikSATest migrated
195- View erp_core.qlikSectionAccess migrated
196- View erp_core.qlikUsers migrated
197- Finalizing foreign key migration...
198- Migration finished
199Migrating done
200Generating Code...
201Generating Code done
202Creating target schema....
203- Creating schema in target MySQL server at Mysql@mjp-msc01-common-aurora-20181110-rdscluster-xkgb67a7c9dm.cluster-cmlhkki32r54.us-west-2.rds.amazonaws.com:3306...
204- Executing preamble script...
205Execute statement: SET FOREIGN_KEY_CHECKS = 0
206- Creating schema erp_core...
207Execute statement: DROP SCHEMA IF EXISTS `erp_core`
208Execute statement:
209
210 CREATE SCHEMA IF NOT EXISTS `erp_core`
211- Creating table erp_core.applications
212Execute statement:
213 CREATE TABLE IF NOT EXISTS `erp_core`.`applications` (
214 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
215 `app_key` VARCHAR(20) NOT NULL,
216 `app_name` VARCHAR(255) NOT NULL,
217 `app_address` VARCHAR(255) NOT NULL,
218 `created_at` TIMESTAMP NULL DEFAULT NULL,
219 `updated_at` TIMESTAMP NULL DEFAULT NULL,
220 PRIMARY KEY (`id`))
221 ENGINE = InnoDB
222 AUTO_INCREMENT = 24
223 DEFAULT CHARACTER SET = utf8
224 COLLATE = utf8_unicode_ci
225- Creating table erp_core.cache
226Execute statement:
227 CREATE TABLE IF NOT EXISTS `erp_core`.`cache` (
228 `key` VARCHAR(255) NOT NULL,
229 `value` TEXT NOT NULL,
230 `expiration` INT(11) NOT NULL,
231 UNIQUE INDEX `cache_key_unique` (`key` ASC))
232 ENGINE = InnoDB
233 DEFAULT CHARACTER SET = utf8
234 COLLATE = utf8_unicode_ci
235- Creating table erp_core.countries
236Execute statement:
237 CREATE TABLE IF NOT EXISTS `erp_core`.`countries` (
238 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
239 `name` VARCHAR(255) NOT NULL,
240 `country_code` VARCHAR(255) NOT NULL,
241 PRIMARY KEY (`id`))
242 ENGINE = InnoDB
243 AUTO_INCREMENT = 5
244 DEFAULT CHARACTER SET = utf8
245 COLLATE = utf8_unicode_ci
246- Creating table erp_core.events
247Execute statement:
248 CREATE TABLE IF NOT EXISTS `erp_core`.`events` (
249 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
250 `event_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
251 `entity_type` VARCHAR(255) NOT NULL,
252 `entity_id` INT(11) NOT NULL,
253 `event_type` VARCHAR(255) NOT NULL,
254 `message` LONGTEXT NOT NULL,
255 `data_update` TINYINT(1) NOT NULL,
256 `model` LONGTEXT NOT NULL,
257 `user_id` INT(11) NOT NULL,
258 `user_name` VARCHAR(255) NOT NULL,
259 `organization_id` INT(11) NOT NULL,
260 `facility_id` INT(11) NOT NULL,
261 `reference_id` INT(11) NOT NULL,
262 `notes` LONGTEXT NULL DEFAULT NULL,
263 `created_at` TIMESTAMP NULL DEFAULT NULL,
264 `updated_at` TIMESTAMP NULL DEFAULT NULL,
265 PRIMARY KEY (`id`),
266 INDEX `events_organization_id_index` (`organization_id` ASC) VISIBLE,
267 INDEX `events_facility_id_index` (`facility_id` ASC) VISIBLE,
268 INDEX `events_entity_type_index` (`entity_type` ASC) VISIBLE,
269 INDEX `events_entity_id_index` (`entity_id` ASC) VISIBLE)
270 ENGINE = InnoDB
271 AUTO_INCREMENT = 4339
272 DEFAULT CHARACTER SET = utf8
273 COLLATE = utf8_unicode_ci
274WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`events` (
275 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
276 `event_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
277 `entity_type` VARCHAR(255) NOT NULL,
278 `entity_id` INT(11) NOT NULL,
279 `event_type` VARCHAR(255) NOT NULL,
280 `message` LONGTEXT NOT NULL,
281 `data_update` TINYINT(1) NOT NULL,
282 `model` LONGTEXT NOT NULL,
283 `user_id` INT(11) NOT NULL,
284 `user_name` VARCHAR(255) NOT NULL,
285 `organization_id` INT(11) NOT NULL,
286 `facility_id` INT(11) NOT NULL,
287 `reference_id` INT(11) NOT NULL,
288 `notes` LONGTEXT NULL DEFAULT NULL,
289 `created_at` TIMESTAMP NULL DEFAULT NULL,
290 `updated_at` TIMESTAMP NULL DEFAULT NULL,
291 PRIMARY KEY (`id`),
292 INDEX `events_organization_id_index` (`organization_id` ASC) VISIBLE,
293 INDEX `events_facility_id_index` (`facility_id` ASC) VISIBLE,
294 INDEX `events_entity_type_index` (`entity_type` ASC) VISIBLE,
295 INDEX `events_entity_id_index` (`entity_id` ASC) VISIBLE)
296ENGINE = InnoDB
297AUTO_INCREMENT = 4339
298DEFAULT CHARACTER SET = utf8
299COLLATE = utf8_unicode_ci'
300You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
301 INDEX `events_facility_id_index` (`facility_id` ASC) VISIBLE,
302 INDEX' at line 19.
303SQL Error: 1064
304- Creating table erp_core.facilities
305Execute statement:
306 CREATE TABLE IF NOT EXISTS `erp_core`.`facilities` (
307 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
308 `name` VARCHAR(255) NOT NULL,
309 `dba` VARCHAR(255) NULL DEFAULT NULL,
310 `facility_key` VARCHAR(25) NOT NULL,
311 `facility_code` VARCHAR(5) NOT NULL,
312 `type` VARCHAR(50) NOT NULL,
313 `timezone` VARCHAR(255) NULL DEFAULT NULL,
314 `street_address_1` VARCHAR(255) NULL DEFAULT NULL,
315 `street_address_2` VARCHAR(255) NULL DEFAULT NULL,
316 `city` VARCHAR(255) NULL DEFAULT NULL,
317 `province_code` VARCHAR(4) NULL DEFAULT NULL,
318 `postal_code` VARCHAR(15) NULL DEFAULT NULL,
319 `country_code` VARCHAR(4) NULL DEFAULT NULL,
320 `phone_number` VARCHAR(50) NOT NULL,
321 `organization_id` INT(10) UNSIGNED NOT NULL,
322 `contact_user_id` INT(11) NOT NULL,
323 `created_at` TIMESTAMP NULL DEFAULT NULL,
324 `updated_at` TIMESTAMP NULL DEFAULT NULL,
325 `retail_type` VARCHAR(255) NULL DEFAULT 'medical',
326 `leaf_organization_id` VARCHAR(255) NULL DEFAULT NULL,
327 `reporting_access_id` INT(10) UNSIGNED NOT NULL DEFAULT '1',
328 `last_active_date` TIMESTAMP NULL DEFAULT NULL,
329 PRIMARY KEY (`id`),
330 INDEX `facilities_name_index` (`name` ASC) VISIBLE,
331 INDEX `facilities_organization_id_index` (`organization_id` ASC) VISIBLE,
332 INDEX `facilities_facility_key_index` (`facility_key` ASC) VISIBLE)
333 ENGINE = InnoDB
334 AUTO_INCREMENT = 2548
335 DEFAULT CHARACTER SET = utf8
336 COLLATE = utf8_unicode_ci
337WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`facilities` (
338 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
339 `name` VARCHAR(255) NOT NULL,
340 `dba` VARCHAR(255) NULL DEFAULT NULL,
341 `facility_key` VARCHAR(25) NOT NULL,
342 `facility_code` VARCHAR(5) NOT NULL,
343 `type` VARCHAR(50) NOT NULL,
344 `timezone` VARCHAR(255) NULL DEFAULT NULL,
345 `street_address_1` VARCHAR(255) NULL DEFAULT NULL,
346 `street_address_2` VARCHAR(255) NULL DEFAULT NULL,
347 `city` VARCHAR(255) NULL DEFAULT NULL,
348 `province_code` VARCHAR(4) NULL DEFAULT NULL,
349 `postal_code` VARCHAR(15) NULL DEFAULT NULL,
350 `country_code` VARCHAR(4) NULL DEFAULT NULL,
351 `phone_number` VARCHAR(50) NOT NULL,
352 `organization_id` INT(10) UNSIGNED NOT NULL,
353 `contact_user_id` INT(11) NOT NULL,
354 `created_at` TIMESTAMP NULL DEFAULT NULL,
355 `updated_at` TIMESTAMP NULL DEFAULT NULL,
356 `retail_type` VARCHAR(255) NULL DEFAULT 'medical',
357 `leaf_organization_id` VARCHAR(255) NULL DEFAULT NULL,
358 `reporting_access_id` INT(10) UNSIGNED NOT NULL DEFAULT '1',
359 `last_active_date` TIMESTAMP NULL DEFAULT NULL,
360 PRIMARY KEY (`id`),
361 INDEX `facilities_name_index` (`name` ASC) VISIBLE,
362 INDEX `facilities_organization_id_index` (`organization_id` ASC) VISIBLE,
363 INDEX `facilities_facility_key_index` (`facility_key` ASC) VISIBLE)
364ENGINE = InnoDB
365AUTO_INCREMENT = 2548
366DEFAULT CHARACTER SET = utf8
367COLLATE = utf8_unicode_ci'
368You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
369 INDEX `facilities_organization_id_index` (`organization_id` ASC) VISI' at line 25.
370SQL Error: 1064
371- Creating table erp_core.facility_group_members
372Execute statement:
373 CREATE TABLE IF NOT EXISTS `erp_core`.`facility_group_members` (
374 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
375 `facility_group_id` INT(10) UNSIGNED NOT NULL,
376 `facility_id` INT(10) UNSIGNED NOT NULL,
377 `deleted_at` TIMESTAMP NULL DEFAULT NULL,
378 `created_at` TIMESTAMP NULL DEFAULT NULL,
379 `updated_at` TIMESTAMP NULL DEFAULT NULL,
380 PRIMARY KEY (`id`),
381 INDEX `facility_group_members_facility_group_id_index` (`facility_group_id` ASC) VISIBLE,
382 INDEX `facility_group_members_facility_id_index` (`facility_id` ASC) VISIBLE,
383 CONSTRAINT `facility_group_members_facility_group_id_foreign`
384 FOREIGN KEY (`facility_group_id`)
385 REFERENCES `erp_core`.`facility_groups` (`id`),
386 CONSTRAINT `facility_group_members_facility_id_foreign`
387 FOREIGN KEY (`facility_id`)
388 REFERENCES `erp_core`.`facilities` (`id`))
389 ENGINE = InnoDB
390 AUTO_INCREMENT = 161
391 DEFAULT CHARACTER SET = utf8
392 COLLATE = utf8_unicode_ci
393WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`facility_group_members` (
394 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
395 `facility_group_id` INT(10) UNSIGNED NOT NULL,
396 `facility_id` INT(10) UNSIGNED NOT NULL,
397 `deleted_at` TIMESTAMP NULL DEFAULT NULL,
398 `created_at` TIMESTAMP NULL DEFAULT NULL,
399 `updated_at` TIMESTAMP NULL DEFAULT NULL,
400 PRIMARY KEY (`id`),
401 INDEX `facility_group_members_facility_group_id_index` (`facility_group_id` ASC) VISIBLE,
402 INDEX `facility_group_members_facility_id_index` (`facility_id` ASC) VISIBLE,
403 CONSTRAINT `facility_group_members_facility_group_id_foreign`
404 FOREIGN KEY (`facility_group_id`)
405 REFERENCES `erp_core`.`facility_groups` (`id`),
406 CONSTRAINT `facility_group_members_facility_id_foreign`
407 FOREIGN KEY (`facility_id`)
408 REFERENCES `erp_core`.`facilities` (`id`))
409ENGINE = InnoDB
410AUTO_INCREMENT = 161
411DEFAULT CHARACTER SET = utf8
412COLLATE = utf8_unicode_ci'
413You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
414 INDEX `facility_group_members_facility_id_index` (`facility_id` ASC) ' at line 9.
415SQL Error: 1064
416- Creating table erp_core.facility_group_settings
417Execute statement:
418 CREATE TABLE IF NOT EXISTS `erp_core`.`facility_group_settings` (
419 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
420 `facility_group_id` INT(10) UNSIGNED NOT NULL,
421 `setting_value_id` INT(10) UNSIGNED NOT NULL,
422 `is_locked` TINYINT(1) NOT NULL DEFAULT '0',
423 `created_at` TIMESTAMP NULL DEFAULT NULL,
424 `updated_at` TIMESTAMP NULL DEFAULT NULL,
425 PRIMARY KEY (`id`),
426 INDEX `facility_group_settings_setting_value_id_foreign` (`setting_value_id` ASC) VISIBLE,
427 INDEX `facility_group_settings_facility_group_id_index` (`facility_group_id` ASC) VISIBLE,
428 CONSTRAINT `facility_group_settings_facility_group_id_foreign`
429 FOREIGN KEY (`facility_group_id`)
430 REFERENCES `erp_core`.`facility_groups` (`id`),
431 CONSTRAINT `facility_group_settings_setting_value_id_foreign`
432 FOREIGN KEY (`setting_value_id`)
433 REFERENCES `erp_core`.`setting_values` (`id`)
434 ON DELETE CASCADE)
435 ENGINE = InnoDB
436 AUTO_INCREMENT = 807
437 DEFAULT CHARACTER SET = utf8
438 COLLATE = utf8_unicode_ci
439WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`facility_group_settings` (
440 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
441 `facility_group_id` INT(10) UNSIGNED NOT NULL,
442 `setting_value_id` INT(10) UNSIGNED NOT NULL,
443 `is_locked` TINYINT(1) NOT NULL DEFAULT '0',
444 `created_at` TIMESTAMP NULL DEFAULT NULL,
445 `updated_at` TIMESTAMP NULL DEFAULT NULL,
446 PRIMARY KEY (`id`),
447 INDEX `facility_group_settings_setting_value_id_foreign` (`setting_value_id` ASC) VISIBLE,
448 INDEX `facility_group_settings_facility_group_id_index` (`facility_group_id` ASC) VISIBLE,
449 CONSTRAINT `facility_group_settings_facility_group_id_foreign`
450 FOREIGN KEY (`facility_group_id`)
451 REFERENCES `erp_core`.`facility_groups` (`id`),
452 CONSTRAINT `facility_group_settings_setting_value_id_foreign`
453 FOREIGN KEY (`setting_value_id`)
454 REFERENCES `erp_core`.`setting_values` (`id`)
455 ON DELETE CASCADE)
456ENGINE = InnoDB
457AUTO_INCREMENT = 807
458DEFAULT CHARACTER SET = utf8
459COLLATE = utf8_unicode_ci'
460You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
461 INDEX `facility_group_settings_facility_group_id_index` (`facility_gr' at line 9.
462SQL Error: 1064
463- Creating table erp_core.facility_groups
464Execute statement:
465 CREATE TABLE IF NOT EXISTS `erp_core`.`facility_groups` (
466 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
467 `organization_id` INT(10) UNSIGNED NOT NULL,
468 `name` VARCHAR(255) NOT NULL,
469 `deleted_at` TIMESTAMP NULL DEFAULT NULL,
470 `created_at` TIMESTAMP NULL DEFAULT NULL,
471 `updated_at` TIMESTAMP NULL DEFAULT NULL,
472 PRIMARY KEY (`id`),
473 INDEX `facility_groups_organization_id_index` (`organization_id` ASC) VISIBLE,
474 CONSTRAINT `facility_groups_organization_id_foreign`
475 FOREIGN KEY (`organization_id`)
476 REFERENCES `erp_core`.`organizations` (`id`))
477 ENGINE = InnoDB
478 AUTO_INCREMENT = 82
479 DEFAULT CHARACTER SET = utf8
480 COLLATE = utf8_unicode_ci
481WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`facility_groups` (
482 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
483 `organization_id` INT(10) UNSIGNED NOT NULL,
484 `name` VARCHAR(255) NOT NULL,
485 `deleted_at` TIMESTAMP NULL DEFAULT NULL,
486 `created_at` TIMESTAMP NULL DEFAULT NULL,
487 `updated_at` TIMESTAMP NULL DEFAULT NULL,
488 PRIMARY KEY (`id`),
489 INDEX `facility_groups_organization_id_index` (`organization_id` ASC) VISIBLE,
490 CONSTRAINT `facility_groups_organization_id_foreign`
491 FOREIGN KEY (`organization_id`)
492 REFERENCES `erp_core`.`organizations` (`id`))
493ENGINE = InnoDB
494AUTO_INCREMENT = 82
495DEFAULT CHARACTER SET = utf8
496COLLATE = utf8_unicode_ci'
497You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
498 CONSTRAINT `facility_groups_organization_id_foreign`
499 FOREIGN KEY ' at line 9.
500SQL Error: 1064
501- Creating table erp_core.facility_modules
502Execute statement:
503 CREATE TABLE IF NOT EXISTS `erp_core`.`facility_modules` (
504 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
505 `facility_id` INT(10) UNSIGNED NOT NULL,
506 `module_id` INT(10) UNSIGNED NOT NULL,
507 `enabled` TINYINT(4) NOT NULL,
508 `created_at` TIMESTAMP NULL DEFAULT NULL,
509 `updated_at` TIMESTAMP NULL DEFAULT NULL,
510 PRIMARY KEY (`id`),
511 INDEX `facility_modules_facility_id_index` (`facility_id` ASC) VISIBLE,
512 INDEX `facility_modules_module_id_index` (`module_id` ASC) VISIBLE)
513 ENGINE = InnoDB
514 AUTO_INCREMENT = 171479
515 DEFAULT CHARACTER SET = utf8
516 COLLATE = utf8_unicode_ci
517WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`facility_modules` (
518 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
519 `facility_id` INT(10) UNSIGNED NOT NULL,
520 `module_id` INT(10) UNSIGNED NOT NULL,
521 `enabled` TINYINT(4) NOT NULL,
522 `created_at` TIMESTAMP NULL DEFAULT NULL,
523 `updated_at` TIMESTAMP NULL DEFAULT NULL,
524 PRIMARY KEY (`id`),
525 INDEX `facility_modules_facility_id_index` (`facility_id` ASC) VISIBLE,
526 INDEX `facility_modules_module_id_index` (`module_id` ASC) VISIBLE)
527ENGINE = InnoDB
528AUTO_INCREMENT = 171479
529DEFAULT CHARACTER SET = utf8
530COLLATE = utf8_unicode_ci'
531You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
532 INDEX `facility_modules_module_id_index` (`module_id` ASC) VISIBLE)
533E' at line 9.
534SQL Error: 1064
535- Creating table erp_core.failed_jobs
536Execute statement:
537 CREATE TABLE IF NOT EXISTS `erp_core`.`failed_jobs` (
538 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
539 `connection` TEXT NOT NULL,
540 `queue` TEXT NOT NULL,
541 `payload` LONGTEXT NOT NULL,
542 `failed_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
543 PRIMARY KEY (`id`))
544 ENGINE = InnoDB
545 DEFAULT CHARACTER SET = utf8
546 COLLATE = utf8_unicode_ci
547- Creating table erp_core.jobs
548Execute statement:
549 CREATE TABLE IF NOT EXISTS `erp_core`.`jobs` (
550 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
551 `queue` VARCHAR(255) NOT NULL,
552 `payload` LONGTEXT NOT NULL,
553 `attempts` TINYINT(3) UNSIGNED NOT NULL,
554 `reserved` TINYINT(3) UNSIGNED NOT NULL,
555 `reserved_at` INT(10) UNSIGNED NULL DEFAULT NULL,
556 `available_at` INT(10) UNSIGNED NOT NULL,
557 `created_at` INT(10) UNSIGNED NOT NULL,
558 PRIMARY KEY (`id`),
559 INDEX `jobs_queue_reserved_reserved_at_index` (`queue` ASC, `reserved` ASC, `reserved_at` ASC) VISIBLE)
560 ENGINE = InnoDB
561 DEFAULT CHARACTER SET = utf8
562 COLLATE = utf8_unicode_ci
563WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`jobs` (
564 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
565 `queue` VARCHAR(255) NOT NULL,
566 `payload` LONGTEXT NOT NULL,
567 `attempts` TINYINT(3) UNSIGNED NOT NULL,
568 `reserved` TINYINT(3) UNSIGNED NOT NULL,
569 `reserved_at` INT(10) UNSIGNED NULL DEFAULT NULL,
570 `available_at` INT(10) UNSIGNED NOT NULL,
571 `created_at` INT(10) UNSIGNED NOT NULL,
572 PRIMARY KEY (`id`),
573 INDEX `jobs_queue_reserved_reserved_at_index` (`queue` ASC, `reserved` ASC, `reserved_at` ASC) VISIBLE)
574ENGINE = InnoDB
575DEFAULT CHARACTER SET = utf8
576COLLATE = utf8_unicode_ci'
577You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE)
578ENGINE = InnoDB
579DEFAULT CHARACTER SET = utf8
580COLLATE = utf8_unicode_ci' at line 11.
581SQL Error: 1064
582- Creating table erp_core.licensing
583Execute statement:
584 CREATE TABLE IF NOT EXISTS `erp_core`.`licensing` (
585 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
586 `license_code` VARCHAR(255) NOT NULL,
587 `license_type` VARCHAR(255) NOT NULL,
588 `facility_id` INT(11) NOT NULL,
589 `module_id` INT(11) NOT NULL,
590 `expiration_date` DATETIME NULL DEFAULT NULL,
591 `created_at` TIMESTAMP NULL DEFAULT NULL,
592 `updated_at` TIMESTAMP NULL DEFAULT NULL,
593 PRIMARY KEY (`id`),
594 INDEX `licensing_license_code_index` (`license_code` ASC) VISIBLE,
595 INDEX `licensing_facility_id_index` (`facility_id` ASC) VISIBLE,
596 INDEX `licensing_module_id_index` (`module_id` ASC) VISIBLE)
597 ENGINE = InnoDB
598 DEFAULT CHARACTER SET = utf8
599 COLLATE = utf8_unicode_ci
600WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`licensing` (
601 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
602 `license_code` VARCHAR(255) NOT NULL,
603 `license_type` VARCHAR(255) NOT NULL,
604 `facility_id` INT(11) NOT NULL,
605 `module_id` INT(11) NOT NULL,
606 `expiration_date` DATETIME NULL DEFAULT NULL,
607 `created_at` TIMESTAMP NULL DEFAULT NULL,
608 `updated_at` TIMESTAMP NULL DEFAULT NULL,
609 PRIMARY KEY (`id`),
610 INDEX `licensing_license_code_index` (`license_code` ASC) VISIBLE,
611 INDEX `licensing_facility_id_index` (`facility_id` ASC) VISIBLE,
612 INDEX `licensing_module_id_index` (`module_id` ASC) VISIBLE)
613ENGINE = InnoDB
614DEFAULT CHARACTER SET = utf8
615COLLATE = utf8_unicode_ci'
616You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
617 INDEX `licensing_facility_id_index` (`facility_id` ASC) VISIBLE,
618 IN' at line 11.
619SQL Error: 1064
620- Creating table erp_core.message_subscribers
621Execute statement:
622 CREATE TABLE IF NOT EXISTS `erp_core`.`message_subscribers` (
623 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
624 `message_key` TEXT NOT NULL,
625 `subscribed_app` TEXT NOT NULL,
626 `subscribed_service` TEXT NOT NULL,
627 `created_at` TIMESTAMP NULL DEFAULT NULL,
628 `updated_at` TIMESTAMP NULL DEFAULT NULL,
629 PRIMARY KEY (`id`))
630 ENGINE = InnoDB
631 AUTO_INCREMENT = 108
632 DEFAULT CHARACTER SET = utf8
633 COLLATE = utf8_unicode_ci
634- Creating table erp_core.migrations
635Execute statement:
636 CREATE TABLE IF NOT EXISTS `erp_core`.`migrations` (
637 `migration` VARCHAR(255) NOT NULL,
638 `batch` INT(11) NOT NULL)
639 ENGINE = InnoDB
640 DEFAULT CHARACTER SET = utf8
641 COLLATE = utf8_unicode_ci
642- Creating table erp_core.modules
643Execute statement:
644 CREATE TABLE IF NOT EXISTS `erp_core`.`modules` (
645 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
646 `module_key` VARCHAR(50) NOT NULL,
647 `module_name` VARCHAR(255) NOT NULL,
648 `created_at` TIMESTAMP NULL DEFAULT NULL,
649 `updated_at` TIMESTAMP NULL DEFAULT NULL,
650 PRIMARY KEY (`id`))
651 ENGINE = InnoDB
652 AUTO_INCREMENT = 109
653 DEFAULT CHARACTER SET = utf8
654 COLLATE = utf8_unicode_ci
655- Creating table erp_core.object_files
656Execute statement:
657 CREATE TABLE IF NOT EXISTS `erp_core`.`object_files` (
658 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
659 `organization_id` INT(10) UNSIGNED NOT NULL,
660 `file_type` ENUM('document', 'image') NULL DEFAULT NULL,
661 `file_id` INT(10) UNSIGNED NULL DEFAULT NULL,
662 `entity_type` VARCHAR(255) NOT NULL,
663 `entity_id` INT(10) UNSIGNED NOT NULL,
664 `name` VARCHAR(255) NOT NULL,
665 `type` VARCHAR(255) NOT NULL,
666 `expires_on` DATE NULL DEFAULT NULL,
667 `created_at` TIMESTAMP NULL DEFAULT NULL,
668 `updated_at` TIMESTAMP NULL DEFAULT NULL,
669 PRIMARY KEY (`id`),
670 INDEX `object_files_organization_id_index` (`organization_id` ASC) VISIBLE,
671 INDEX `object_files_file_type_index` (`file_type` ASC) VISIBLE,
672 INDEX `object_files_entity_type_index` (`entity_type` ASC) VISIBLE,
673 INDEX `object_files_entity_id_index` (`entity_id` ASC) VISIBLE)
674 ENGINE = InnoDB
675 AUTO_INCREMENT = 3803
676 DEFAULT CHARACTER SET = utf8
677 COLLATE = utf8_unicode_ci
678WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`object_files` (
679 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
680 `organization_id` INT(10) UNSIGNED NOT NULL,
681 `file_type` ENUM('document', 'image') NULL DEFAULT NULL,
682 `file_id` INT(10) UNSIGNED NULL DEFAULT NULL,
683 `entity_type` VARCHAR(255) NOT NULL,
684 `entity_id` INT(10) UNSIGNED NOT NULL,
685 `name` VARCHAR(255) NOT NULL,
686 `type` VARCHAR(255) NOT NULL,
687 `expires_on` DATE NULL DEFAULT NULL,
688 `created_at` TIMESTAMP NULL DEFAULT NULL,
689 `updated_at` TIMESTAMP NULL DEFAULT NULL,
690 PRIMARY KEY (`id`),
691 INDEX `object_files_organization_id_index` (`organization_id` ASC) VISIBLE,
692 INDEX `object_files_file_type_index` (`file_type` ASC) VISIBLE,
693 INDEX `object_files_entity_type_index` (`entity_type` ASC) VISIBLE,
694 INDEX `object_files_entity_id_index` (`entity_id` ASC) VISIBLE)
695ENGINE = InnoDB
696AUTO_INCREMENT = 3803
697DEFAULT CHARACTER SET = utf8
698COLLATE = utf8_unicode_ci'
699You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
700 INDEX `object_files_file_type_index` (`file_type` ASC) VISIBLE,
701 IND' at line 14.
702SQL Error: 1064
703- Creating table erp_core.online_users
704Execute statement:
705 CREATE TABLE IF NOT EXISTS `erp_core`.`online_users` (
706 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
707 `organization_id` INT(11) NOT NULL,
708 `email` VARCHAR(255) NOT NULL,
709 `password` VARCHAR(255) NOT NULL,
710 `is_active` TINYINT(1) NOT NULL DEFAULT '0',
711 `created_at` TIMESTAMP NULL DEFAULT NULL,
712 `updated_at` TIMESTAMP NULL DEFAULT NULL,
713 PRIMARY KEY (`id`),
714 INDEX `online_users_organization_id_index` (`organization_id` ASC) VISIBLE,
715 INDEX `online_users_email_index` (`email` ASC) VISIBLE,
716 INDEX `online_users_is_active_index` (`is_active` ASC) VISIBLE)
717 ENGINE = InnoDB
718 DEFAULT CHARACTER SET = utf8
719 COLLATE = utf8_unicode_ci
720WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`online_users` (
721 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
722 `organization_id` INT(11) NOT NULL,
723 `email` VARCHAR(255) NOT NULL,
724 `password` VARCHAR(255) NOT NULL,
725 `is_active` TINYINT(1) NOT NULL DEFAULT '0',
726 `created_at` TIMESTAMP NULL DEFAULT NULL,
727 `updated_at` TIMESTAMP NULL DEFAULT NULL,
728 PRIMARY KEY (`id`),
729 INDEX `online_users_organization_id_index` (`organization_id` ASC) VISIBLE,
730 INDEX `online_users_email_index` (`email` ASC) VISIBLE,
731 INDEX `online_users_is_active_index` (`is_active` ASC) VISIBLE)
732ENGINE = InnoDB
733DEFAULT CHARACTER SET = utf8
734COLLATE = utf8_unicode_ci'
735You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
736 INDEX `online_users_email_index` (`email` ASC) VISIBLE,
737 INDEX `onli' at line 10.
738SQL Error: 1064
739- Creating table erp_core.organization_app_storage
740Execute statement:
741 CREATE TABLE IF NOT EXISTS `erp_core`.`organization_app_storage` (
742 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
743 `organization_id` INT(10) UNSIGNED NOT NULL,
744 `application_id` INT(10) UNSIGNED NOT NULL,
745 `read_storage_id` INT(10) UNSIGNED NOT NULL,
746 `write_storage_id` INT(10) UNSIGNED NOT NULL,
747 `report_storage_id` INT(10) UNSIGNED NOT NULL,
748 `created_at` TIMESTAMP NULL DEFAULT NULL,
749 `updated_at` TIMESTAMP NULL DEFAULT NULL,
750 PRIMARY KEY (`id`),
751 INDEX `organization_app_storage_organization_id_application_id_index` (`organization_id` ASC, `application_id` ASC) VISIBLE,
752 INDEX `organization_app_storage_application_id_foreign` (`application_id` ASC) VISIBLE,
753 INDEX `organization_app_storage_read_storage_id_foreign` (`read_storage_id` ASC) VISIBLE,
754 INDEX `organization_app_storage_write_storage_id_foreign` (`write_storage_id` ASC) VISIBLE,
755 INDEX `organization_app_storage_report_storage_id_foreign` (`report_storage_id` ASC) VISIBLE)
756 ENGINE = InnoDB
757 DEFAULT CHARACTER SET = utf8
758 COLLATE = utf8_unicode_ci
759WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`organization_app_storage` (
760 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
761 `organization_id` INT(10) UNSIGNED NOT NULL,
762 `application_id` INT(10) UNSIGNED NOT NULL,
763 `read_storage_id` INT(10) UNSIGNED NOT NULL,
764 `write_storage_id` INT(10) UNSIGNED NOT NULL,
765 `report_storage_id` INT(10) UNSIGNED NOT NULL,
766 `created_at` TIMESTAMP NULL DEFAULT NULL,
767 `updated_at` TIMESTAMP NULL DEFAULT NULL,
768 PRIMARY KEY (`id`),
769 INDEX `organization_app_storage_organization_id_application_id_index` (`organization_id` ASC, `application_id` ASC) VISIBLE,
770 INDEX `organization_app_storage_application_id_foreign` (`application_id` ASC) VISIBLE,
771 INDEX `organization_app_storage_read_storage_id_foreign` (`read_storage_id` ASC) VISIBLE,
772 INDEX `organization_app_storage_write_storage_id_foreign` (`write_storage_id` ASC) VISIBLE,
773 INDEX `organization_app_storage_report_storage_id_foreign` (`report_storage_id` ASC) VISIBLE)
774ENGINE = InnoDB
775DEFAULT CHARACTER SET = utf8
776COLLATE = utf8_unicode_ci'
777You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
778 INDEX `organization_app_storage_application_id_foreign` (`application' at line 11.
779SQL Error: 1064
780- Creating table erp_core.organization_master_users
781Execute statement:
782 CREATE TABLE IF NOT EXISTS `erp_core`.`organization_master_users` (
783 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
784 `organization_id` INT(10) UNSIGNED NOT NULL,
785 `user_id` INT(10) UNSIGNED NOT NULL,
786 `created_at` TIMESTAMP NULL DEFAULT NULL,
787 `updated_at` TIMESTAMP NULL DEFAULT NULL,
788 PRIMARY KEY (`id`),
789 INDEX `organization_master_users_organization_id_index` (`organization_id` ASC) VISIBLE,
790 INDEX `organization_master_users_user_id_index` (`user_id` ASC) VISIBLE)
791 ENGINE = InnoDB
792 AUTO_INCREMENT = 4705
793 DEFAULT CHARACTER SET = utf8
794 COLLATE = utf8_unicode_ci
795WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`organization_master_users` (
796 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
797 `organization_id` INT(10) UNSIGNED NOT NULL,
798 `user_id` INT(10) UNSIGNED NOT NULL,
799 `created_at` TIMESTAMP NULL DEFAULT NULL,
800 `updated_at` TIMESTAMP NULL DEFAULT NULL,
801 PRIMARY KEY (`id`),
802 INDEX `organization_master_users_organization_id_index` (`organization_id` ASC) VISIBLE,
803 INDEX `organization_master_users_user_id_index` (`user_id` ASC) VISIBLE)
804ENGINE = InnoDB
805AUTO_INCREMENT = 4705
806DEFAULT CHARACTER SET = utf8
807COLLATE = utf8_unicode_ci'
808You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
809 INDEX `organization_master_users_user_id_index` (`user_id` ASC) VISIB' at line 8.
810SQL Error: 1064
811- Creating table erp_core.organization_role_permission
812Execute statement:
813 CREATE TABLE IF NOT EXISTS `erp_core`.`organization_role_permission` (
814 `organization_role_id` INT(10) UNSIGNED NOT NULL,
815 `permission_id` INT(10) UNSIGNED NOT NULL,
816 PRIMARY KEY (`organization_role_id`, `permission_id`),
817 INDEX `organization_role_permission_permission_id_foreign` (`permission_id` ASC) VISIBLE)
818 ENGINE = InnoDB
819 DEFAULT CHARACTER SET = utf8
820 COLLATE = utf8_unicode_ci
821WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`organization_role_permission` (
822 `organization_role_id` INT(10) UNSIGNED NOT NULL,
823 `permission_id` INT(10) UNSIGNED NOT NULL,
824 PRIMARY KEY (`organization_role_id`, `permission_id`),
825 INDEX `organization_role_permission_permission_id_foreign` (`permission_id` ASC) VISIBLE)
826ENGINE = InnoDB
827DEFAULT CHARACTER SET = utf8
828COLLATE = utf8_unicode_ci'
829You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE)
830ENGINE = InnoDB
831DEFAULT CHARACTER SET = utf8
832COLLATE = utf8_unicode_ci' at line 5.
833SQL Error: 1064
834- Creating table erp_core.organization_roles
835Execute statement:
836 CREATE TABLE IF NOT EXISTS `erp_core`.`organization_roles` (
837 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
838 `role_name` VARCHAR(100) NOT NULL,
839 `role_display_name` VARCHAR(255) NULL DEFAULT NULL,
840 `module_id` INT(10) UNSIGNED NOT NULL,
841 `organization_id` INT(10) UNSIGNED NOT NULL,
842 `created_by_user` INT(10) UNSIGNED NOT NULL,
843 `is_default_role` TINYINT(1) NOT NULL DEFAULT '0',
844 `created_at` TIMESTAMP NULL DEFAULT NULL,
845 `updated_at` TIMESTAMP NULL DEFAULT NULL,
846 `deleted_at` TIMESTAMP NULL DEFAULT NULL,
847 PRIMARY KEY (`id`),
848 INDEX `organization_roles_organization_id_index` (`organization_id` ASC) VISIBLE,
849 INDEX `organization_roles_module_id_foreign` (`module_id` ASC) VISIBLE)
850 ENGINE = InnoDB
851 AUTO_INCREMENT = 96515
852 DEFAULT CHARACTER SET = utf8
853 COLLATE = utf8_unicode_ci
854WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`organization_roles` (
855 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
856 `role_name` VARCHAR(100) NOT NULL,
857 `role_display_name` VARCHAR(255) NULL DEFAULT NULL,
858 `module_id` INT(10) UNSIGNED NOT NULL,
859 `organization_id` INT(10) UNSIGNED NOT NULL,
860 `created_by_user` INT(10) UNSIGNED NOT NULL,
861 `is_default_role` TINYINT(1) NOT NULL DEFAULT '0',
862 `created_at` TIMESTAMP NULL DEFAULT NULL,
863 `updated_at` TIMESTAMP NULL DEFAULT NULL,
864 `deleted_at` TIMESTAMP NULL DEFAULT NULL,
865 PRIMARY KEY (`id`),
866 INDEX `organization_roles_organization_id_index` (`organization_id` ASC) VISIBLE,
867 INDEX `organization_roles_module_id_foreign` (`module_id` ASC) VISIBLE)
868ENGINE = InnoDB
869AUTO_INCREMENT = 96515
870DEFAULT CHARACTER SET = utf8
871COLLATE = utf8_unicode_ci'
872You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
873 INDEX `organization_roles_module_id_foreign` (`module_id` ASC) VISIBL' at line 13.
874SQL Error: 1064
875- Creating table erp_core.organizations
876Execute statement:
877 CREATE TABLE IF NOT EXISTS `erp_core`.`organizations` (
878 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
879 `name` VARCHAR(255) NOT NULL,
880 `organization_key` VARCHAR(25) NOT NULL,
881 `organization_code` VARCHAR(5) NOT NULL,
882 `client_id` VARCHAR(50) NOT NULL,
883 `parent_organization_id` INT(11) NULL DEFAULT NULL,
884 `partner_code` VARCHAR(255) NOT NULL,
885 `image_file_id` INT(11) NULL DEFAULT NULL,
886 `created_at` TIMESTAMP NULL DEFAULT NULL,
887 `updated_at` TIMESTAMP NULL DEFAULT NULL,
888 `is_testing_site` TINYINT(1) NOT NULL DEFAULT '0',
889 `is_data_loaded` TINYINT(1) NOT NULL DEFAULT '1',
890 `active` TINYINT(1) NOT NULL DEFAULT '1',
891 PRIMARY KEY (`id`),
892 UNIQUE INDEX `organizations_organization_key_unique` (`organization_key` ASC) VISIBLE,
893 INDEX `organizations_organization_key_index` (`organization_key` ASC) VISIBLE,
894 INDEX `organizations_parent_organization_id_index` (`parent_organization_id` ASC) VISIBLE)
895 ENGINE = InnoDB
896 AUTO_INCREMENT = 1169
897 DEFAULT CHARACTER SET = utf8
898 COLLATE = utf8_unicode_ci
899WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`organizations` (
900 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
901 `name` VARCHAR(255) NOT NULL,
902 `organization_key` VARCHAR(25) NOT NULL,
903 `organization_code` VARCHAR(5) NOT NULL,
904 `client_id` VARCHAR(50) NOT NULL,
905 `parent_organization_id` INT(11) NULL DEFAULT NULL,
906 `partner_code` VARCHAR(255) NOT NULL,
907 `image_file_id` INT(11) NULL DEFAULT NULL,
908 `created_at` TIMESTAMP NULL DEFAULT NULL,
909 `updated_at` TIMESTAMP NULL DEFAULT NULL,
910 `is_testing_site` TINYINT(1) NOT NULL DEFAULT '0',
911 `is_data_loaded` TINYINT(1) NOT NULL DEFAULT '1',
912 `active` TINYINT(1) NOT NULL DEFAULT '1',
913 PRIMARY KEY (`id`),
914 UNIQUE INDEX `organizations_organization_key_unique` (`organization_key` ASC) VISIBLE,
915 INDEX `organizations_organization_key_index` (`organization_key` ASC) VISIBLE,
916 INDEX `organizations_parent_organization_id_index` (`parent_organization_id` ASC) VISIBLE)
917ENGINE = InnoDB
918AUTO_INCREMENT = 1169
919DEFAULT CHARACTER SET = utf8
920COLLATE = utf8_unicode_ci'
921You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
922 INDEX `organizations_organization_key_index` (`organization_key` ASC)' at line 16.
923SQL Error: 1064
924- Creating table erp_core.password_reset_log
925Execute statement:
926 CREATE TABLE IF NOT EXISTS `erp_core`.`password_reset_log` (
927 `email` VARCHAR(255) NOT NULL,
928 `username` VARCHAR(255) NOT NULL,
929 `email_sent` TINYINT(1) NOT NULL DEFAULT '0',
930 `valid_lookup` TINYINT(1) NOT NULL DEFAULT '0',
931 `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
932 INDEX `password_reset_log_email_index` (`email` ASC) VISIBLE,
933 INDEX `password_reset_log_username_index` (`username` ASC) VISIBLE)
934 ENGINE = InnoDB
935 DEFAULT CHARACTER SET = utf8
936 COLLATE = utf8_unicode_ci
937WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`password_reset_log` (
938 `email` VARCHAR(255) NOT NULL,
939 `username` VARCHAR(255) NOT NULL,
940 `email_sent` TINYINT(1) NOT NULL DEFAULT '0',
941 `valid_lookup` TINYINT(1) NOT NULL DEFAULT '0',
942 `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
943 INDEX `password_reset_log_email_index` (`email` ASC) VISIBLE,
944 INDEX `password_reset_log_username_index` (`username` ASC) VISIBLE)
945ENGINE = InnoDB
946DEFAULT CHARACTER SET = utf8
947COLLATE = utf8_unicode_ci'
948You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
949 INDEX `password_reset_log_username_index` (`username` ASC) VISIBLE)
950E' at line 7.
951SQL Error: 1064
952- Creating table erp_core.password_resets
953Execute statement:
954 CREATE TABLE IF NOT EXISTS `erp_core`.`password_resets` (
955 `email` VARCHAR(255) NOT NULL,
956 `token` VARCHAR(255) NOT NULL,
957 `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
958 INDEX `password_resets_email_index` (`email` ASC) VISIBLE,
959 INDEX `password_resets_token_index` (`token` ASC) VISIBLE)
960 ENGINE = InnoDB
961 DEFAULT CHARACTER SET = utf8
962 COLLATE = utf8_unicode_ci
963WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`password_resets` (
964 `email` VARCHAR(255) NOT NULL,
965 `token` VARCHAR(255) NOT NULL,
966 `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
967 INDEX `password_resets_email_index` (`email` ASC) VISIBLE,
968 INDEX `password_resets_token_index` (`token` ASC) VISIBLE)
969ENGINE = InnoDB
970DEFAULT CHARACTER SET = utf8
971COLLATE = utf8_unicode_ci'
972You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
973 INDEX `password_resets_token_index` (`token` ASC) VISIBLE)
974ENGINE = I' at line 5.
975SQL Error: 1064
976- Creating table erp_core.permissions
977Execute statement:
978 CREATE TABLE IF NOT EXISTS `erp_core`.`permissions` (
979 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
980 `permission_key` VARCHAR(100) NOT NULL,
981 `permission_name` VARCHAR(255) NOT NULL,
982 `description` VARCHAR(255) NOT NULL,
983 `module_id` INT(10) UNSIGNED NOT NULL,
984 `created_at` TIMESTAMP NULL DEFAULT NULL,
985 `updated_at` TIMESTAMP NULL DEFAULT NULL,
986 PRIMARY KEY (`id`),
987 INDEX `permissions_module_id_index` (`module_id` ASC) VISIBLE)
988 ENGINE = InnoDB
989 AUTO_INCREMENT = 1762
990 DEFAULT CHARACTER SET = utf8
991 COLLATE = utf8_unicode_ci
992WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`permissions` (
993 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
994 `permission_key` VARCHAR(100) NOT NULL,
995 `permission_name` VARCHAR(255) NOT NULL,
996 `description` VARCHAR(255) NOT NULL,
997 `module_id` INT(10) UNSIGNED NOT NULL,
998 `created_at` TIMESTAMP NULL DEFAULT NULL,
999 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1000 PRIMARY KEY (`id`),
1001 INDEX `permissions_module_id_index` (`module_id` ASC) VISIBLE)
1002ENGINE = InnoDB
1003AUTO_INCREMENT = 1762
1004DEFAULT CHARACTER SET = utf8
1005COLLATE = utf8_unicode_ci'
1006You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE)
1007ENGINE = InnoDB
1008AUTO_INCREMENT = 1762
1009DEFAULT CHARACTER SET = utf8
1010COLL' at line 10.
1011SQL Error: 1064
1012- Creating table erp_core.provinces
1013Execute statement:
1014 CREATE TABLE IF NOT EXISTS `erp_core`.`provinces` (
1015 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1016 `name` VARCHAR(255) NOT NULL,
1017 `province_code` VARCHAR(255) NOT NULL,
1018 `country_code` VARCHAR(255) NOT NULL,
1019 PRIMARY KEY (`id`))
1020 ENGINE = InnoDB
1021 AUTO_INCREMENT = 89
1022 DEFAULT CHARACTER SET = utf8
1023 COLLATE = utf8_unicode_ci
1024- Creating table erp_core.qlik_timezone_mappings
1025Execute statement:
1026 CREATE TABLE IF NOT EXISTS `erp_core`.`qlik_timezone_mappings` (
1027 `mjp_timezone` VARCHAR(255) NOT NULL,
1028 `qlik_timezone` VARCHAR(255) NOT NULL,
1029 INDEX `qlik_timezone_mappings_mjp_timezone_index` (`mjp_timezone` ASC) VISIBLE)
1030 ENGINE = InnoDB
1031 DEFAULT CHARACTER SET = utf8
1032 COLLATE = utf8_unicode_ci
1033WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`qlik_timezone_mappings` (
1034 `mjp_timezone` VARCHAR(255) NOT NULL,
1035 `qlik_timezone` VARCHAR(255) NOT NULL,
1036 INDEX `qlik_timezone_mappings_mjp_timezone_index` (`mjp_timezone` ASC) VISIBLE)
1037ENGINE = InnoDB
1038DEFAULT CHARACTER SET = utf8
1039COLLATE = utf8_unicode_ci'
1040You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE)
1041ENGINE = InnoDB
1042DEFAULT CHARACTER SET = utf8
1043COLLATE = utf8_unicode_ci' at line 4.
1044SQL Error: 1064
1045- Creating table erp_core.reporting_access_levels
1046Execute statement:
1047 CREATE TABLE IF NOT EXISTS `erp_core`.`reporting_access_levels` (
1048 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1049 `name` VARCHAR(255) NOT NULL,
1050 PRIMARY KEY (`id`))
1051 ENGINE = InnoDB
1052 AUTO_INCREMENT = 5
1053 DEFAULT CHARACTER SET = utf8
1054 COLLATE = utf8_unicode_ci
1055- Creating table erp_core.services
1056Execute statement:
1057 CREATE TABLE IF NOT EXISTS `erp_core`.`services` (
1058 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1059 `application_id` INT(10) UNSIGNED NOT NULL,
1060 `service_key` VARCHAR(255) CHARACTER SET 'utf8' NOT NULL,
1061 `description` VARCHAR(255) NULL DEFAULT NULL,
1062 `address` VARCHAR(255) NOT NULL,
1063 `route` VARCHAR(50) NOT NULL,
1064 `request_type` VARCHAR(50) NOT NULL,
1065 `request_definition` VARCHAR(255) NOT NULL,
1066 `response_definition` VARCHAR(255) NOT NULL,
1067 `created_at` TIMESTAMP NULL DEFAULT NULL,
1068 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1069 PRIMARY KEY (`id`),
1070 UNIQUE INDEX `services_service_key_unique` (`service_key` ASC) VISIBLE,
1071 INDEX `services_application_id_foreign` (`application_id` ASC) VISIBLE)
1072 ENGINE = InnoDB
1073 AUTO_INCREMENT = 1013
1074 DEFAULT CHARACTER SET = utf8
1075 COLLATE = utf8_unicode_ci
1076WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`services` (
1077 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1078 `application_id` INT(10) UNSIGNED NOT NULL,
1079 `service_key` VARCHAR(255) CHARACTER SET 'utf8' NOT NULL,
1080 `description` VARCHAR(255) NULL DEFAULT NULL,
1081 `address` VARCHAR(255) NOT NULL,
1082 `route` VARCHAR(50) NOT NULL,
1083 `request_type` VARCHAR(50) NOT NULL,
1084 `request_definition` VARCHAR(255) NOT NULL,
1085 `response_definition` VARCHAR(255) NOT NULL,
1086 `created_at` TIMESTAMP NULL DEFAULT NULL,
1087 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1088 PRIMARY KEY (`id`),
1089 UNIQUE INDEX `services_service_key_unique` (`service_key` ASC) VISIBLE,
1090 INDEX `services_application_id_foreign` (`application_id` ASC) VISIBLE)
1091ENGINE = InnoDB
1092AUTO_INCREMENT = 1013
1093DEFAULT CHARACTER SET = utf8
1094COLLATE = utf8_unicode_ci'
1095You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
1096 INDEX `services_application_id_foreign` (`application_id` ASC) VISIBL' at line 14.
1097SQL Error: 1064
1098- Creating table erp_core.setting_values
1099Execute statement:
1100 CREATE TABLE IF NOT EXISTS `erp_core`.`setting_values` (
1101 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1102 `organization_id` INT(10) UNSIGNED NOT NULL,
1103 `setting_id` INT(10) UNSIGNED NOT NULL,
1104 `setting_key` TEXT NOT NULL,
1105 `configuration_level` TEXT NOT NULL,
1106 `entity_id` INT(10) UNSIGNED NOT NULL,
1107 `value` TEXT NOT NULL,
1108 `created_at` TIMESTAMP NULL DEFAULT NULL,
1109 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1110 PRIMARY KEY (`id`),
1111 INDEX `setting_values_organization_id_index` (`organization_id` ASC) VISIBLE,
1112 INDEX `setting_values_entity_id_index` (`entity_id` ASC) VISIBLE,
1113 INDEX `setting_key` (`setting_key`(100) ASC) VISIBLE)
1114 ENGINE = InnoDB
1115 AUTO_INCREMENT = 17974
1116 DEFAULT CHARACTER SET = utf8
1117 COLLATE = utf8_unicode_ci
1118WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`setting_values` (
1119 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1120 `organization_id` INT(10) UNSIGNED NOT NULL,
1121 `setting_id` INT(10) UNSIGNED NOT NULL,
1122 `setting_key` TEXT NOT NULL,
1123 `configuration_level` TEXT NOT NULL,
1124 `entity_id` INT(10) UNSIGNED NOT NULL,
1125 `value` TEXT NOT NULL,
1126 `created_at` TIMESTAMP NULL DEFAULT NULL,
1127 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1128 PRIMARY KEY (`id`),
1129 INDEX `setting_values_organization_id_index` (`organization_id` ASC) VISIBLE,
1130 INDEX `setting_values_entity_id_index` (`entity_id` ASC) VISIBLE,
1131 INDEX `setting_key` (`setting_key`(100) ASC) VISIBLE)
1132ENGINE = InnoDB
1133AUTO_INCREMENT = 17974
1134DEFAULT CHARACTER SET = utf8
1135COLLATE = utf8_unicode_ci'
1136You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
1137 INDEX `setting_values_entity_id_index` (`entity_id` ASC) VISIBLE,
1138 I' at line 12.
1139SQL Error: 1064
1140- Creating table erp_core.settings
1141Execute statement:
1142 CREATE TABLE IF NOT EXISTS `erp_core`.`settings` (
1143 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1144 `application_id` INT(10) UNSIGNED NOT NULL,
1145 `setting_key` TEXT NOT NULL,
1146 `data_type` TEXT NOT NULL,
1147 `title` TEXT NOT NULL,
1148 `description` TEXT NOT NULL,
1149 `organization_level` TINYINT(1) NOT NULL,
1150 `facility_level` TINYINT(1) NOT NULL,
1151 `default_value` TEXT NOT NULL,
1152 `encrypt_value` TINYINT(1) NOT NULL DEFAULT '0',
1153 `created_at` TIMESTAMP NULL DEFAULT NULL,
1154 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1155 PRIMARY KEY (`id`),
1156 INDEX `setting_key` (`setting_key`(100) ASC) VISIBLE)
1157 ENGINE = InnoDB
1158 AUTO_INCREMENT = 90
1159 DEFAULT CHARACTER SET = utf8
1160 COLLATE = utf8_unicode_ci
1161WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`settings` (
1162 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1163 `application_id` INT(10) UNSIGNED NOT NULL,
1164 `setting_key` TEXT NOT NULL,
1165 `data_type` TEXT NOT NULL,
1166 `title` TEXT NOT NULL,
1167 `description` TEXT NOT NULL,
1168 `organization_level` TINYINT(1) NOT NULL,
1169 `facility_level` TINYINT(1) NOT NULL,
1170 `default_value` TEXT NOT NULL,
1171 `encrypt_value` TINYINT(1) NOT NULL DEFAULT '0',
1172 `created_at` TIMESTAMP NULL DEFAULT NULL,
1173 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1174 PRIMARY KEY (`id`),
1175 INDEX `setting_key` (`setting_key`(100) ASC) VISIBLE)
1176ENGINE = InnoDB
1177AUTO_INCREMENT = 90
1178DEFAULT CHARACTER SET = utf8
1179COLLATE = utf8_unicode_ci'
1180You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE)
1181ENGINE = InnoDB
1182AUTO_INCREMENT = 90
1183DEFAULT CHARACTER SET = utf8
1184COLLAT' at line 15.
1185SQL Error: 1064
1186- Creating table erp_core.storage
1187Execute statement:
1188 CREATE TABLE IF NOT EXISTS `erp_core`.`storage` (
1189 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1190 `name` VARCHAR(255) NOT NULL,
1191 `hostname` VARCHAR(100) NOT NULL,
1192 `username` VARCHAR(100) NOT NULL,
1193 `password` VARCHAR(100) NOT NULL,
1194 `database` VARCHAR(100) NOT NULL,
1195 `created_at` TIMESTAMP NULL DEFAULT NULL,
1196 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1197 PRIMARY KEY (`id`))
1198 ENGINE = InnoDB
1199 AUTO_INCREMENT = 8
1200 DEFAULT CHARACTER SET = utf8
1201 COLLATE = utf8_unicode_ci
1202- Creating table erp_core.token_requests
1203Execute statement:
1204 CREATE TABLE IF NOT EXISTS `erp_core`.`token_requests` (
1205 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1206 `user_id` VARCHAR(255) NOT NULL,
1207 `token` VARCHAR(255) NOT NULL,
1208 `requested_by_id` VARCHAR(255) NULL DEFAULT NULL,
1209 `expired_at` DATETIME NOT NULL,
1210 `used_at` DATETIME NULL DEFAULT NULL,
1211 `created_at` TIMESTAMP NULL DEFAULT NULL,
1212 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1213 PRIMARY KEY (`id`),
1214 INDEX `token_requests_user_id_index` (`user_id` ASC) VISIBLE,
1215 INDEX `token_requests_token_index` (`token` ASC) VISIBLE,
1216 INDEX `token_requests_requested_by_id_index` (`requested_by_id` ASC) VISIBLE)
1217 ENGINE = InnoDB
1218 AUTO_INCREMENT = 1303
1219 DEFAULT CHARACTER SET = utf8
1220 COLLATE = utf8_unicode_ci
1221WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`token_requests` (
1222 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1223 `user_id` VARCHAR(255) NOT NULL,
1224 `token` VARCHAR(255) NOT NULL,
1225 `requested_by_id` VARCHAR(255) NULL DEFAULT NULL,
1226 `expired_at` DATETIME NOT NULL,
1227 `used_at` DATETIME NULL DEFAULT NULL,
1228 `created_at` TIMESTAMP NULL DEFAULT NULL,
1229 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1230 PRIMARY KEY (`id`),
1231 INDEX `token_requests_user_id_index` (`user_id` ASC) VISIBLE,
1232 INDEX `token_requests_token_index` (`token` ASC) VISIBLE,
1233 INDEX `token_requests_requested_by_id_index` (`requested_by_id` ASC) VISIBLE)
1234ENGINE = InnoDB
1235AUTO_INCREMENT = 1303
1236DEFAULT CHARACTER SET = utf8
1237COLLATE = utf8_unicode_ci'
1238You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
1239 INDEX `token_requests_token_index` (`token` ASC) VISIBLE,
1240 INDEX `to' at line 11.
1241SQL Error: 1064
1242- Creating table erp_core.user_addresses
1243Execute statement:
1244 CREATE TABLE IF NOT EXISTS `erp_core`.`user_addresses` (
1245 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1246 `organization_id` INT(11) NOT NULL,
1247 `user_id` INT(10) UNSIGNED NOT NULL,
1248 `street_address_1` VARCHAR(255) NULL DEFAULT NULL,
1249 `street_address_2` VARCHAR(255) NULL DEFAULT NULL,
1250 `city` VARCHAR(255) NULL DEFAULT NULL,
1251 `province_code` VARCHAR(4) NULL DEFAULT NULL,
1252 `postal_code` VARCHAR(15) NULL DEFAULT NULL,
1253 `country_code` VARCHAR(4) NULL DEFAULT NULL,
1254 `primary` TINYINT(1) NOT NULL,
1255 `active` TINYINT(1) NOT NULL DEFAULT '1',
1256 `created_at` TIMESTAMP NULL DEFAULT NULL,
1257 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1258 `deleted_at` TIMESTAMP NULL DEFAULT NULL,
1259 PRIMARY KEY (`id`),
1260 INDEX `user_addresses_user_id_index` (`user_id` ASC) VISIBLE,
1261 INDEX `user_addresses_organization_id_index` (`organization_id` ASC) VISIBLE)
1262 ENGINE = InnoDB
1263 AUTO_INCREMENT = 8886
1264 DEFAULT CHARACTER SET = utf8
1265 COLLATE = utf8_unicode_ci
1266WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`user_addresses` (
1267 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1268 `organization_id` INT(11) NOT NULL,
1269 `user_id` INT(10) UNSIGNED NOT NULL,
1270 `street_address_1` VARCHAR(255) NULL DEFAULT NULL,
1271 `street_address_2` VARCHAR(255) NULL DEFAULT NULL,
1272 `city` VARCHAR(255) NULL DEFAULT NULL,
1273 `province_code` VARCHAR(4) NULL DEFAULT NULL,
1274 `postal_code` VARCHAR(15) NULL DEFAULT NULL,
1275 `country_code` VARCHAR(4) NULL DEFAULT NULL,
1276 `primary` TINYINT(1) NOT NULL,
1277 `active` TINYINT(1) NOT NULL DEFAULT '1',
1278 `created_at` TIMESTAMP NULL DEFAULT NULL,
1279 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1280 `deleted_at` TIMESTAMP NULL DEFAULT NULL,
1281 PRIMARY KEY (`id`),
1282 INDEX `user_addresses_user_id_index` (`user_id` ASC) VISIBLE,
1283 INDEX `user_addresses_organization_id_index` (`organization_id` ASC) VISIBLE)
1284ENGINE = InnoDB
1285AUTO_INCREMENT = 8886
1286DEFAULT CHARACTER SET = utf8
1287COLLATE = utf8_unicode_ci'
1288You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
1289 INDEX `user_addresses_organization_id_index` (`organization_id` ASC) ' at line 17.
1290SQL Error: 1064
1291- Creating table erp_core.user_facilities
1292Execute statement:
1293 CREATE TABLE IF NOT EXISTS `erp_core`.`user_facilities` (
1294 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1295 `facility_id` INT(10) UNSIGNED NOT NULL,
1296 `user_id` INT(10) UNSIGNED NOT NULL,
1297 `created_at` TIMESTAMP NULL DEFAULT NULL,
1298 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1299 PRIMARY KEY (`id`),
1300 INDEX `user_facilities_user_id_index` (`user_id` ASC) VISIBLE,
1301 INDEX `user_facilities_facility_id_index` (`facility_id` ASC) VISIBLE)
1302 ENGINE = InnoDB
1303 AUTO_INCREMENT = 31631
1304 DEFAULT CHARACTER SET = utf8
1305 COLLATE = utf8_unicode_ci
1306WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`user_facilities` (
1307 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1308 `facility_id` INT(10) UNSIGNED NOT NULL,
1309 `user_id` INT(10) UNSIGNED NOT NULL,
1310 `created_at` TIMESTAMP NULL DEFAULT NULL,
1311 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1312 PRIMARY KEY (`id`),
1313 INDEX `user_facilities_user_id_index` (`user_id` ASC) VISIBLE,
1314 INDEX `user_facilities_facility_id_index` (`facility_id` ASC) VISIBLE)
1315ENGINE = InnoDB
1316AUTO_INCREMENT = 31631
1317DEFAULT CHARACTER SET = utf8
1318COLLATE = utf8_unicode_ci'
1319You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
1320 INDEX `user_facilities_facility_id_index` (`facility_id` ASC) VISIBLE' at line 8.
1321SQL Error: 1064
1322- Creating table erp_core.user_facility_roles
1323Execute statement:
1324 CREATE TABLE IF NOT EXISTS `erp_core`.`user_facility_roles` (
1325 `user_facility_id` INT(10) UNSIGNED NOT NULL,
1326 `organization_role_id` INT(10) UNSIGNED NOT NULL,
1327 INDEX `user_facility_roles_user_facility_id_index` (`user_facility_id` ASC) VISIBLE,
1328 INDEX `user_facility_roles_organization_role_id_index` (`organization_role_id` ASC) VISIBLE)
1329 ENGINE = InnoDB
1330 DEFAULT CHARACTER SET = utf8
1331 COLLATE = utf8_unicode_ci
1332WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`user_facility_roles` (
1333 `user_facility_id` INT(10) UNSIGNED NOT NULL,
1334 `organization_role_id` INT(10) UNSIGNED NOT NULL,
1335 INDEX `user_facility_roles_user_facility_id_index` (`user_facility_id` ASC) VISIBLE,
1336 INDEX `user_facility_roles_organization_role_id_index` (`organization_role_id` ASC) VISIBLE)
1337ENGINE = InnoDB
1338DEFAULT CHARACTER SET = utf8
1339COLLATE = utf8_unicode_ci'
1340You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
1341 INDEX `user_facility_roles_organization_role_id_index` (`organization' at line 4.
1342SQL Error: 1064
1343- Creating table erp_core.user_ids
1344Execute statement:
1345 CREATE TABLE IF NOT EXISTS `erp_core`.`user_ids` (
1346 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1347 `organization_id` INT(11) NOT NULL,
1348 `user_id` INT(10) UNSIGNED NOT NULL,
1349 `type` VARCHAR(255) NOT NULL,
1350 `identification_number` VARCHAR(255) NOT NULL,
1351 `state` VARCHAR(255) NOT NULL,
1352 `active` TINYINT(1) NOT NULL DEFAULT '1',
1353 `expired_at` DATETIME NULL DEFAULT NULL,
1354 `created_at` TIMESTAMP NULL DEFAULT NULL,
1355 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1356 `deleted_at` TIMESTAMP NULL DEFAULT NULL,
1357 PRIMARY KEY (`id`),
1358 INDEX `user_ids_user_id_index` (`user_id` ASC) VISIBLE,
1359 INDEX `user_ids_organization_id_index` (`organization_id` ASC) VISIBLE)
1360 ENGINE = InnoDB
1361 AUTO_INCREMENT = 17778
1362 DEFAULT CHARACTER SET = utf8
1363 COLLATE = utf8_unicode_ci
1364WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`user_ids` (
1365 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1366 `organization_id` INT(11) NOT NULL,
1367 `user_id` INT(10) UNSIGNED NOT NULL,
1368 `type` VARCHAR(255) NOT NULL,
1369 `identification_number` VARCHAR(255) NOT NULL,
1370 `state` VARCHAR(255) NOT NULL,
1371 `active` TINYINT(1) NOT NULL DEFAULT '1',
1372 `expired_at` DATETIME NULL DEFAULT NULL,
1373 `created_at` TIMESTAMP NULL DEFAULT NULL,
1374 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1375 `deleted_at` TIMESTAMP NULL DEFAULT NULL,
1376 PRIMARY KEY (`id`),
1377 INDEX `user_ids_user_id_index` (`user_id` ASC) VISIBLE,
1378 INDEX `user_ids_organization_id_index` (`organization_id` ASC) VISIBLE)
1379ENGINE = InnoDB
1380AUTO_INCREMENT = 17778
1381DEFAULT CHARACTER SET = utf8
1382COLLATE = utf8_unicode_ci'
1383You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
1384 INDEX `user_ids_organization_id_index` (`organization_id` ASC) VISIBL' at line 14.
1385SQL Error: 1064
1386- Creating table erp_core.user_integration_ids
1387Execute statement:
1388 CREATE TABLE IF NOT EXISTS `erp_core`.`user_integration_ids` (
1389 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1390 `organization_id` INT(11) NOT NULL,
1391 `facility_id` INT(11) NOT NULL,
1392 `user_id` INT(10) UNSIGNED NOT NULL,
1393 `type` VARCHAR(255) NOT NULL,
1394 `identification_number` VARCHAR(255) NOT NULL,
1395 `state` VARCHAR(255) NOT NULL,
1396 `active` TINYINT(1) NOT NULL DEFAULT '1',
1397 `expired_at` TIMESTAMP NULL DEFAULT NULL,
1398 `created_at` TIMESTAMP NULL DEFAULT NULL,
1399 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1400 `deleted_at` TIMESTAMP NULL DEFAULT NULL,
1401 `access_level` VARCHAR(255) NOT NULL DEFAULT 'none',
1402 PRIMARY KEY (`id`),
1403 INDEX `user_integration_ids_user_id_index` (`user_id` ASC) VISIBLE,
1404 INDEX `user_integration_ids_organization_id_index` (`organization_id` ASC) VISIBLE,
1405 INDEX `user_integration_ids_facility_id_index` (`facility_id` ASC) VISIBLE,
1406 CONSTRAINT `user_integration_ids_user_id_foreign`
1407 FOREIGN KEY (`user_id`)
1408 REFERENCES `erp_core`.`users` (`id`)
1409 ON DELETE CASCADE)
1410 ENGINE = InnoDB
1411 AUTO_INCREMENT = 12543
1412 DEFAULT CHARACTER SET = utf8
1413 COLLATE = utf8_unicode_ci
1414WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`user_integration_ids` (
1415 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1416 `organization_id` INT(11) NOT NULL,
1417 `facility_id` INT(11) NOT NULL,
1418 `user_id` INT(10) UNSIGNED NOT NULL,
1419 `type` VARCHAR(255) NOT NULL,
1420 `identification_number` VARCHAR(255) NOT NULL,
1421 `state` VARCHAR(255) NOT NULL,
1422 `active` TINYINT(1) NOT NULL DEFAULT '1',
1423 `expired_at` TIMESTAMP NULL DEFAULT NULL,
1424 `created_at` TIMESTAMP NULL DEFAULT NULL,
1425 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1426 `deleted_at` TIMESTAMP NULL DEFAULT NULL,
1427 `access_level` VARCHAR(255) NOT NULL DEFAULT 'none',
1428 PRIMARY KEY (`id`),
1429 INDEX `user_integration_ids_user_id_index` (`user_id` ASC) VISIBLE,
1430 INDEX `user_integration_ids_organization_id_index` (`organization_id` ASC) VISIBLE,
1431 INDEX `user_integration_ids_facility_id_index` (`facility_id` ASC) VISIBLE,
1432 CONSTRAINT `user_integration_ids_user_id_foreign`
1433 FOREIGN KEY (`user_id`)
1434 REFERENCES `erp_core`.`users` (`id`)
1435 ON DELETE CASCADE)
1436ENGINE = InnoDB
1437AUTO_INCREMENT = 12543
1438DEFAULT CHARACTER SET = utf8
1439COLLATE = utf8_unicode_ci'
1440You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
1441 INDEX `user_integration_ids_organization_id_index` (`organization_id`' at line 16.
1442SQL Error: 1064
1443- Creating table erp_core.user_notes
1444Execute statement:
1445 CREATE TABLE IF NOT EXISTS `erp_core`.`user_notes` (
1446 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1447 `organization_id` INT(11) NOT NULL,
1448 `user_id` INT(10) UNSIGNED NOT NULL,
1449 `title` VARCHAR(255) NOT NULL,
1450 `note` LONGTEXT NOT NULL,
1451 `active` TINYINT(1) NOT NULL DEFAULT '1',
1452 `created_at` TIMESTAMP NULL DEFAULT NULL,
1453 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1454 `deleted_at` TIMESTAMP NULL DEFAULT NULL,
1455 PRIMARY KEY (`id`),
1456 INDEX `user_notes_user_id_index` (`user_id` ASC) VISIBLE,
1457 INDEX `user_notes_organization_id_index` (`organization_id` ASC) VISIBLE)
1458 ENGINE = InnoDB
1459 DEFAULT CHARACTER SET = utf8
1460 COLLATE = utf8_unicode_ci
1461WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`user_notes` (
1462 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1463 `organization_id` INT(11) NOT NULL,
1464 `user_id` INT(10) UNSIGNED NOT NULL,
1465 `title` VARCHAR(255) NOT NULL,
1466 `note` LONGTEXT NOT NULL,
1467 `active` TINYINT(1) NOT NULL DEFAULT '1',
1468 `created_at` TIMESTAMP NULL DEFAULT NULL,
1469 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1470 `deleted_at` TIMESTAMP NULL DEFAULT NULL,
1471 PRIMARY KEY (`id`),
1472 INDEX `user_notes_user_id_index` (`user_id` ASC) VISIBLE,
1473 INDEX `user_notes_organization_id_index` (`organization_id` ASC) VISIBLE)
1474ENGINE = InnoDB
1475DEFAULT CHARACTER SET = utf8
1476COLLATE = utf8_unicode_ci'
1477You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
1478 INDEX `user_notes_organization_id_index` (`organization_id` ASC) VISI' at line 12.
1479SQL Error: 1064
1480- Creating table erp_core.user_phones
1481Execute statement:
1482 CREATE TABLE IF NOT EXISTS `erp_core`.`user_phones` (
1483 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1484 `organization_id` INT(11) NOT NULL,
1485 `user_id` INT(10) UNSIGNED NOT NULL,
1486 `type` VARCHAR(255) NOT NULL,
1487 `number` VARCHAR(255) NOT NULL,
1488 `active` TINYINT(1) NOT NULL DEFAULT '1',
1489 `sms` TINYINT(1) NOT NULL DEFAULT '0',
1490 `primary` TINYINT(1) NOT NULL DEFAULT '0',
1491 `created_at` TIMESTAMP NULL DEFAULT NULL,
1492 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1493 `deleted_at` TIMESTAMP NULL DEFAULT NULL,
1494 PRIMARY KEY (`id`),
1495 INDEX `user_phones_user_id_index` (`user_id` ASC) VISIBLE,
1496 INDEX `user_phones_organization_id_index` (`organization_id` ASC) VISIBLE)
1497 ENGINE = InnoDB
1498 AUTO_INCREMENT = 7855
1499 DEFAULT CHARACTER SET = utf8
1500 COLLATE = utf8_unicode_ci
1501WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`user_phones` (
1502 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1503 `organization_id` INT(11) NOT NULL,
1504 `user_id` INT(10) UNSIGNED NOT NULL,
1505 `type` VARCHAR(255) NOT NULL,
1506 `number` VARCHAR(255) NOT NULL,
1507 `active` TINYINT(1) NOT NULL DEFAULT '1',
1508 `sms` TINYINT(1) NOT NULL DEFAULT '0',
1509 `primary` TINYINT(1) NOT NULL DEFAULT '0',
1510 `created_at` TIMESTAMP NULL DEFAULT NULL,
1511 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1512 `deleted_at` TIMESTAMP NULL DEFAULT NULL,
1513 PRIMARY KEY (`id`),
1514 INDEX `user_phones_user_id_index` (`user_id` ASC) VISIBLE,
1515 INDEX `user_phones_organization_id_index` (`organization_id` ASC) VISIBLE)
1516ENGINE = InnoDB
1517AUTO_INCREMENT = 7855
1518DEFAULT CHARACTER SET = utf8
1519COLLATE = utf8_unicode_ci'
1520You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
1521 INDEX `user_phones_organization_id_index` (`organization_id` ASC) VIS' at line 14.
1522SQL Error: 1064
1523- Creating table erp_core.user_settings
1524Execute statement:
1525 CREATE TABLE IF NOT EXISTS `erp_core`.`user_settings` (
1526 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1527 `user_id` INT(10) UNSIGNED NOT NULL,
1528 `column_visibility` TEXT NOT NULL,
1529 `created_at` TIMESTAMP NULL DEFAULT NULL,
1530 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1531 PRIMARY KEY (`id`),
1532 INDEX `user_settings_user_id_index` (`user_id` ASC) VISIBLE,
1533 CONSTRAINT `user_settings_user_id_foreign`
1534 FOREIGN KEY (`user_id`)
1535 REFERENCES `erp_core`.`users` (`id`)
1536 ON DELETE CASCADE)
1537 ENGINE = InnoDB
1538 AUTO_INCREMENT = 2193
1539 DEFAULT CHARACTER SET = utf8
1540 COLLATE = utf8_unicode_ci
1541WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`user_settings` (
1542 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1543 `user_id` INT(10) UNSIGNED NOT NULL,
1544 `column_visibility` TEXT NOT NULL,
1545 `created_at` TIMESTAMP NULL DEFAULT NULL,
1546 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1547 PRIMARY KEY (`id`),
1548 INDEX `user_settings_user_id_index` (`user_id` ASC) VISIBLE,
1549 CONSTRAINT `user_settings_user_id_foreign`
1550 FOREIGN KEY (`user_id`)
1551 REFERENCES `erp_core`.`users` (`id`)
1552 ON DELETE CASCADE)
1553ENGINE = InnoDB
1554AUTO_INCREMENT = 2193
1555DEFAULT CHARACTER SET = utf8
1556COLLATE = utf8_unicode_ci'
1557You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
1558 CONSTRAINT `user_settings_user_id_foreign`
1559 FOREIGN KEY (`user_id`' at line 8.
1560SQL Error: 1064
1561- Creating table erp_core.users
1562Execute statement:
1563 CREATE TABLE IF NOT EXISTS `erp_core`.`users` (
1564 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1565 `name` VARCHAR(100) NOT NULL,
1566 `email` VARCHAR(255) NOT NULL,
1567 `password` VARCHAR(255) NOT NULL,
1568 `card_swipe_id` VARCHAR(255) NULL DEFAULT NULL,
1569 `first_name` VARCHAR(255) NOT NULL,
1570 `last_name` VARCHAR(255) NOT NULL,
1571 `middle_name` VARCHAR(255) NOT NULL,
1572 `birth_date` DATETIME NULL DEFAULT NULL,
1573 `job_title` VARCHAR(255) NOT NULL,
1574 `vehicle_make` VARCHAR(255) NULL DEFAULT NULL,
1575 `vehicle_model` VARCHAR(255) NULL DEFAULT NULL,
1576 `vehicle_license` VARCHAR(255) NULL DEFAULT NULL,
1577 `state_id` VARCHAR(100) NOT NULL,
1578 `language` VARCHAR(20) NOT NULL,
1579 `status` TINYINT(4) NOT NULL,
1580 `locked` TINYINT(1) NOT NULL DEFAULT '0',
1581 `locked_until_date` DATETIME NULL DEFAULT NULL,
1582 `active` TINYINT(1) NOT NULL DEFAULT '1',
1583 `hire_date` DATETIME NULL DEFAULT NULL,
1584 `termination_date` DATETIME NULL DEFAULT NULL,
1585 `created_at` TIMESTAMP NULL DEFAULT NULL,
1586 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1587 `password_updated_at` TIMESTAMP NULL DEFAULT NULL,
1588 `password_expired_at` TIMESTAMP NULL DEFAULT NULL,
1589 `image_file_id` INT(11) NULL DEFAULT NULL,
1590 `state_integration_id` VARCHAR(255) NULL DEFAULT NULL,
1591 PRIMARY KEY (`id`),
1592 UNIQUE INDEX `users_name_unique` (`name` ASC) VISIBLE,
1593 INDEX `users_name_index` (`name` ASC) VISIBLE,
1594 INDEX `users_email_index` (`email` ASC) VISIBLE,
1595 INDEX `users_state_id_index` (`state_id` ASC) VISIBLE)
1596 ENGINE = InnoDB
1597 AUTO_INCREMENT = 10257
1598 DEFAULT CHARACTER SET = utf8
1599 COLLATE = utf8_unicode_ci
1600WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_core`.`users` (
1601 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
1602 `name` VARCHAR(100) NOT NULL,
1603 `email` VARCHAR(255) NOT NULL,
1604 `password` VARCHAR(255) NOT NULL,
1605 `card_swipe_id` VARCHAR(255) NULL DEFAULT NULL,
1606 `first_name` VARCHAR(255) NOT NULL,
1607 `last_name` VARCHAR(255) NOT NULL,
1608 `middle_name` VARCHAR(255) NOT NULL,
1609 `birth_date` DATETIME NULL DEFAULT NULL,
1610 `job_title` VARCHAR(255) NOT NULL,
1611 `vehicle_make` VARCHAR(255) NULL DEFAULT NULL,
1612 `vehicle_model` VARCHAR(255) NULL DEFAULT NULL,
1613 `vehicle_license` VARCHAR(255) NULL DEFAULT NULL,
1614 `state_id` VARCHAR(100) NOT NULL,
1615 `language` VARCHAR(20) NOT NULL,
1616 `status` TINYINT(4) NOT NULL,
1617 `locked` TINYINT(1) NOT NULL DEFAULT '0',
1618 `locked_until_date` DATETIME NULL DEFAULT NULL,
1619 `active` TINYINT(1) NOT NULL DEFAULT '1',
1620 `hire_date` DATETIME NULL DEFAULT NULL,
1621 `termination_date` DATETIME NULL DEFAULT NULL,
1622 `created_at` TIMESTAMP NULL DEFAULT NULL,
1623 `updated_at` TIMESTAMP NULL DEFAULT NULL,
1624 `password_updated_at` TIMESTAMP NULL DEFAULT NULL,
1625 `password_expired_at` TIMESTAMP NULL DEFAULT NULL,
1626 `image_file_id` INT(11) NULL DEFAULT NULL,
1627 `state_integration_id` VARCHAR(255) NULL DEFAULT NULL,
1628 PRIMARY KEY (`id`),
1629 UNIQUE INDEX `users_name_unique` (`name` ASC) VISIBLE,
1630 INDEX `users_name_index` (`name` ASC) VISIBLE,
1631 INDEX `users_email_index` (`email` ASC) VISIBLE,
1632 INDEX `users_state_id_index` (`state_id` ASC) VISIBLE)
1633ENGINE = InnoDB
1634AUTO_INCREMENT = 10257
1635DEFAULT CHARACTER SET = utf8
1636COLLATE = utf8_unicode_ci'
1637You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
1638 INDEX `users_name_index` (`name` ASC) VISIBLE,
1639 INDEX `users_email_i' at line 30.
1640SQL Error: 1064
1641- Creating view erp_core.qlikAttributes
1642Execute statement: USE `erp_core`
1643Execute statement:
1644
1645 CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `erp_core`.`qlikAttributes` AS select `f`.`facility_key` AS `value`,`u`.`id` AS `userid`,'group' AS `type` from ((`erp_core`.`facilities` `f` join `erp_core`.`user_facilities` `uf` on((`f`.`id` = `uf`.`facility_id`))) join `erp_core`.`users` `u` on((`uf`.`user_id` = `u`.`id`))) group by `f`.`facility_key`,`u`.`id` union all select `f`.`facility_code` AS `value`,`u`.`id` AS `userid`,'location' AS `type` from ((`erp_core`.`facilities` `f` join `erp_core`.`user_facilities` `uf` on((`f`.`id` = `uf`.`facility_id`))) join `erp_core`.`users` `u` on((`uf`.`user_id` = `u`.`id`))) union all select 'Consumer' AS `value`,`erp_core`.`users`.`id` AS `userid`,'role' AS `type` from `erp_core`.`users` where (`erp_core`.`users`.`id` not in (33,55,56,39,47)) union all select 'Developer' AS `value`,`erp_core`.`users`.`id` AS `userid`,'role' AS `type` from `erp_core`.`users` where (`erp_core`.`users`.`id` in (33,55,56,39,47))
1646WARNING: Error executing '
1647CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `erp_core`.`qlikAttributes` AS select `f`.`facility_key` AS `value`,`u`.`id` AS `userid`,'group' AS `type` from ((`erp_core`.`facilities` `f` join `erp_core`.`user_facilities` `uf` on((`f`.`id` = `uf`.`facility_id`))) join `erp_core`.`users` `u` on((`uf`.`user_id` = `u`.`id`))) group by `f`.`facility_key`,`u`.`id` union all select `f`.`facility_code` AS `value`,`u`.`id` AS `userid`,'location' AS `type` from ((`erp_core`.`facilities` `f` join `erp_core`.`user_facilities` `uf` on((`f`.`id` = `uf`.`facility_id`))) join `erp_core`.`users` `u` on((`uf`.`user_id` = `u`.`id`))) union all select 'Consumer' AS `value`,`erp_core`.`users`.`id` AS `userid`,'role' AS `type` from `erp_core`.`users` where (`erp_core`.`users`.`id` not in (33,55,56,39,47)) union all select 'Developer' AS `value`,`erp_core`.`users`.`id` AS `userid`,'role' AS `type` from `erp_core`.`users` where (`erp_core`.`users`.`id` in (33,55,56,39,47))'
1648Table 'erp_core.facilities' doesn't exist.
1649SQL Error: 1146
1650- Creating view erp_core.qlikSATest
1651Execute statement: USE `erp_core`
1652Execute statement:
1653
1654 CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `erp_core`.`qlikSATest` AS select 'USER' AS `ACCESS`,'*' AS `USERID`,trim(ucase(`f`.`facility_key`)) AS `GROUP`,`f`.`organization_id` AS `ORGANIZATION_ID`,'*' AS `FACILITY_ID` from `erp_core`.`facilities` `f`
1655WARNING: Error executing '
1656CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `erp_core`.`qlikSATest` AS select 'USER' AS `ACCESS`,'*' AS `USERID`,trim(ucase(`f`.`facility_key`)) AS `GROUP`,`f`.`organization_id` AS `ORGANIZATION_ID`,'*' AS `FACILITY_ID` from `erp_core`.`facilities` `f`'
1657Table 'erp_core.facilities' doesn't exist.
1658SQL Error: 1146
1659- Creating view erp_core.qlikSectionAccess
1660Execute statement: USE `erp_core`
1661Execute statement:
1662
1663 CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `erp_core`.`qlikSectionAccess` AS select 'USER' AS `ACCESS`,'*' AS `USERID`,trim(ucase(`f`.`facility_key`)) AS `GROUP`,`f`.`organization_id` AS `ORGANIZATION_ID` from `erp_core`.`facilities` `f`
1664WARNING: Error executing '
1665CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `erp_core`.`qlikSectionAccess` AS select 'USER' AS `ACCESS`,'*' AS `USERID`,trim(ucase(`f`.`facility_key`)) AS `GROUP`,`f`.`organization_id` AS `ORGANIZATION_ID` from `erp_core`.`facilities` `f`'
1666Table 'erp_core.facilities' doesn't exist.
1667SQL Error: 1146
1668- Creating view erp_core.qlikUsers
1669Execute statement: USE `erp_core`
1670Execute statement:
1671
1672 CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `erp_core`.`qlikUsers` AS select `erp_core`.`users`.`id` AS `userid`,`erp_core`.`users`.`name` AS `name` from `erp_core`.`users`
1673WARNING: Error executing '
1674CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `erp_core`.`qlikUsers` AS select `erp_core`.`users`.`id` AS `userid`,`erp_core`.`users`.`name` AS `name` from `erp_core`.`users`'
1675Table 'erp_core.users' doesn't exist.
1676SQL Error: 1146
1677Scripts for 10 tables, 0 views and 0 routines were executed for schema erp_core
1678- Executing postamble script...
1679Execute statement: SET FOREIGN_KEY_CHECKS = 1
1680- Schema created
1681Creating target schema finished
1682Selecting tables to copy...
1683Selecting tables to copy done
1684Counting table rows to copy....
1685wbcopytables.exe --count-only --passwords-from-stdin --mysql-source="root@mrwcakibc0k11y.cmlhkki32r54.us-west-2.rds.amazonaws.com:3306" --source-rdbms-type=Mysql --table-file=c:\users\mixma\appdata\local\temp\tmpfsfsxg
1686--table `erp_core` `organizations`
168720:02:58 [INF][ copytable]: --table `erp_core` `online_users`
168820:02:58 [INF][ copytable]: --table `erp_core` `user_facilities`
168920:02:58 [INF][ copytable]: --table `erp_core` `facility_group_members`
169020:02:58 [INF][ copytable]: --table `erp_core` `facility_group_settings`
169120:02:58 [INF][ copytable]: --table `erp_core` `licensing`
169220:02:58 [INF][ copytable]: --table `erp_core` `user_addresses`
169320:02:58 [INF][ copytable]: --table `erp_core` `events`
169420:02:58 [INF][ copytable]: --table `erp_core` `applications`
169520:02:58 [INF][ copytable]: --table `erp_core` `organization_master_users`
169620:02:58 [INF][ copytable]: --table `erp_core` `user_notes`
169720:02:58 [INF][ copytable]: --table `erp_core` `cache`
169820:02:58 [INF][ copytable]: --table `erp_core` `organization_roles`
169920:02:58 [INF][ copytable]: --table `erp_core` `organization_app_storage`
170020:02:58 [INF][ copytable]: --table `erp_core` `storage`
170120:02:58 [INF][ copytable]: --table `erp_core` `reporting_access_levels`
170220:02:58 [INF][ copytable]: --table `erp_core` `token_requests`
170320:02:58 [INF][ copytable]: --table `erp_core` `facilities`
170420:02:58 [INF][ copytable]: --table `erp_core` `jobs`
170520:02:58 [INF][ copytable]: --table `erp_core` `modules`
170620:02:58 [INF][ copytable]: --table `erp_core` `user_settings`
170720:02:58 [INF][ copytable]: --table `erp_core` `qlik_timezone_mappings`
170820:02:58 [INF][ copytable]: --table `erp_core` `message_subscribers`
170920:02:58 [INF][ copytable]: --table `erp_core` `facility_modules`
171020:02:58 [INF][ copytable]: --table `erp_core` `object_files`
171120:02:58 [INF][ copytable]: --table `erp_core` `users`
171220:02:58 [INF][ copytable]: --table `erp_core` `user_integration_ids`
171320:02:58 [INF][ copytable]: --table `erp_core` `provinces`
171420:02:58 [INF][ copytable]: --table `erp_core` `user_facility_roles`
171520:02:58 [INF][ copytable]: --table `erp_core` `failed_jobs`
171620:02:58 [INF][ copytable]: --table `erp_core` `organization_role_permission`
171720:02:58 [INF][ copytable]: --table `erp_core` `migrations`
171820:02:58 [INF][ copytable]: --table `erp_core` `services`
171920:02:58 [INF][ copytable]: --table `erp_core` `permissions`
172020:02:58 [INF][ copytable]: --table `erp_core` `facility_groups`
172120:02:58 [INF][ copytable]: --table `erp_core` `setting_values`
172220:02:58 [INF][ copytable]: --table `erp_core` `user_phones`
172320:02:58 [INF][ copytable]: --table `erp_core` `settings`
172420:02:58 [INF][ copytable]: --table `erp_core` `password_resets`
172520:02:58 [INF][ copytable]: --table `erp_core` `password_reset_log`
172620:02:58 [INF][ copytable]: --table `erp_core` `countries`
172720:02:58 [INF][ copytable]: --table `erp_core` `user_ids`
172820:02:58 [INF][ copytable]: Connecting to MySQL server at mrwcakibc0k11y.cmlhkki32r54.us-west-2.rds.amazonaws.com:3306 with user root
172920:02:59 [INF][ copytable]: Connection to MySQL opened
1730
17311445135 total rows in 42 tables need to be copied:
1732Counting table rows to copy finished
1733Copying table data....
1734- Data copy starting
1735
1736Migrating data...
1737wbcopytables.exe --mysql-source="root@mrwcakibc0k11y.cmlhkki32r54.us-west-2.rds.amazonaws.com:3306" --source-rdbms-type=Mysql --target="root@mjp-msc01-common-aurora-20181110-rdscluster-xkgb67a7c9dm.cluster-cmlhkki32r54.us-west-2.rds.amazonaws.com:3306" --progress --passwords-from-stdin --thread-count=2 --table-file=c:\users\mixma\appdata\local\temp\tmpxhifkx
1738--table `erp_core` `organizations` `erp_core` `organizations` `id` `id` `id`, `name`, `organization_key`, `organization_code`, `client_id`, `parent_organization_id`, `partner_code`, `image_file_id`, `created_at`, `updated_at`, `is_testing_site`, `is_data_loaded`, `active`
1739
174020:03:09 [INF][ copytable]: --table `erp_core` `online_users` `erp_core` `online_users` `id` `id` `id`, `organization_id`, `email`, `password`, `is_active`, `created_at`, `updated_at`
1741
174220:03:09 [INF][ copytable]: --table `erp_core` `user_facilities` `erp_core` `user_facilities` `id` `id` `id`, `facility_id`, `user_id`, `created_at`, `updated_at`
1743
174420:03:09 [INF][ copytable]: --table `erp_core` `facility_group_members` `erp_core` `facility_group_members` `id` `id` `id`, `facility_group_id`, `facility_id`, `deleted_at`, `created_at`, `updated_at`
1745
174620:03:09 [INF][ copytable]: --table `erp_core` `facility_group_settings` `erp_core` `facility_group_settings` `id` `id` `id`, `facility_group_id`, `setting_value_id`, `is_locked`, `created_at`, `updated_at`
1747
174820:03:09 [INF][ copytable]: --table `erp_core` `licensing` `erp_core` `licensing` `id` `id` `id`, `license_code`, `license_type`, `facility_id`, `module_id`, `expiration_date`, `created_at`, `updated_at`
1749
175020:03:09 [INF][ copytable]: --table `erp_core` `user_addresses` `erp_core` `user_addresses` `id` `id` `id`, `organization_id`, `user_id`, `street_address_1`, `street_address_2`, `city`, `province_code`, `postal_code`, `country_code`, `primary`, `active`, `created_at`, `updated_at`, `deleted_at`
1751
175220:03:09 [INF][ copytable]: --table `erp_core` `events` `erp_core` `events` `id` `id` `id`, `event_date`, `entity_type`, `entity_id`, `event_type`, `message`, `data_update`, `model`, `user_id`, `user_name`, `organization_id`, `facility_id`, `reference_id`, `notes`, `created_at`, `updated_at`
1753
175420:03:09 [INF][ copytable]: --table `erp_core` `applications` `erp_core` `applications` `id` `id` `id`, `app_key`, `app_name`, `app_address`, `created_at`, `updated_at`
1755
175620:03:09 [INF][ copytable]: --table `erp_core` `organization_master_users` `erp_core` `organization_master_users` `id` `id` `id`, `organization_id`, `user_id`, `created_at`, `updated_at`
1757
175820:03:09 [INF][ copytable]: --table `erp_core` `user_notes` `erp_core` `user_notes` `id` `id` `id`, `organization_id`, `user_id`, `title`, `note`, `active`, `created_at`, `updated_at`, `deleted_at`
1759
176020:03:09 [INF][ copytable]: --table `erp_core` `cache` `erp_core` `cache` `key`, `value`, `expiration`
1761
176220:03:09 [INF][ copytable]: --table `erp_core` `organization_roles` `erp_core` `organization_roles` `id` `id` `id`, `role_name`, `role_display_name`, `module_id`, `organization_id`, `created_by_user`, `is_default_role`, `created_at`, `updated_at`, `deleted_at`
1763
176420:03:09 [INF][ copytable]: --table `erp_core` `organization_app_storage` `erp_core` `organization_app_storage` `id` `id` `id`, `organization_id`, `application_id`, `read_storage_id`, `write_storage_id`, `report_storage_id`, `created_at`, `updated_at`
1765
176620:03:09 [INF][ copytable]: --table `erp_core` `storage` `erp_core` `storage` `id` `id` `id`, `name`, `hostname`, `username`, `password`, `database`, `created_at`, `updated_at`
1767
176820:03:09 [INF][ copytable]: --table `erp_core` `reporting_access_levels` `erp_core` `reporting_access_levels` `id` `id` `id`, `name`
1769
177020:03:09 [INF][ copytable]: --table `erp_core` `token_requests` `erp_core` `token_requests` `id` `id` `id`, `user_id`, `token`, `requested_by_id`, `expired_at`, `used_at`, `created_at`, `updated_at`
1771
177220:03:09 [INF][ copytable]: --table `erp_core` `facilities` `erp_core` `facilities` `id` `id` `id`, `name`, `dba`, `facility_key`, `facility_code`, `type`, `timezone`, `street_address_1`, `street_address_2`, `city`, `province_code`, `postal_code`, `country_code`, `phone_number`, `organization_id`, `contact_user_id`, `created_at`, `updated_at`, `retail_type`, `leaf_organization_id`, `reporting_access_id`, `last_active_date`
1773
177420:03:09 [INF][ copytable]: --table `erp_core` `jobs` `erp_core` `jobs` `id` `id` `id`, `queue`, `payload`, `attempts`, `reserved`, `reserved_at`, `available_at`, `created_at`
1775
177620:03:09 [INF][ copytable]: --table `erp_core` `modules` `erp_core` `modules` `id` `id` `id`, `module_key`, `module_name`, `created_at`, `updated_at`
1777
177820:03:09 [INF][ copytable]: --table `erp_core` `user_settings` `erp_core` `user_settings` `id` `id` `id`, `user_id`, `column_visibility`, `created_at`, `updated_at`
1779
178020:03:09 [INF][ copytable]: --table `erp_core` `qlik_timezone_mappings` `erp_core` `qlik_timezone_mappings` `mjp_timezone`, `qlik_timezone`
1781
178220:03:09 [INF][ copytable]: --table `erp_core` `message_subscribers` `erp_core` `message_subscribers` `id` `id` `id`, `message_key`, `subscribed_app`, `subscribed_service`, `created_at`, `updated_at`
1783
178420:03:09 [INF][ copytable]: --table `erp_core` `facility_modules` `erp_core` `facility_modules` `id` `id` `id`, `facility_id`, `module_id`, `enabled`, `created_at`, `updated_at`
1785
178620:03:09 [INF][ copytable]: --table `erp_core` `object_files` `erp_core` `object_files` `id` `id` `id`, `organization_id`, `file_type`, `file_id`, `entity_type`, `entity_id`, `name`, `type`, `expires_on`, `created_at`, `updated_at`
1787
178820:03:09 [INF][ copytable]: --table `erp_core` `users` `erp_core` `users` `id` `id` `id`, `name`, `email`, `password`, `card_swipe_id`, `first_name`, `last_name`, `middle_name`, `birth_date`, `job_title`, `vehicle_make`, `vehicle_model`, `vehicle_license`, `state_id`, `language`, `status`, `locked`, `locked_until_date`, `active`, `hire_date`, `termination_date`, `created_at`, `updated_at`, `password_updated_at`, `password_expired_at`, `image_file_id`, `state_integration_id`
1789
179020:03:09 [INF][ copytable]: --table `erp_core` `user_integration_ids` `erp_core` `user_integration_ids` `id` `id` `id`, `organization_id`, `facility_id`, `user_id`, `type`, `identification_number`, `state`, `active`, `expired_at`, `created_at`, `updated_at`, `deleted_at`, `access_level`
1791
179220:03:09 [INF][ copytable]: --table `erp_core` `provinces` `erp_core` `provinces` `id` `id` `id`, `name`, `province_code`, `country_code`
1793
179420:03:09 [INF][ copytable]: --table `erp_core` `user_facility_roles` `erp_core` `user_facility_roles` `user_facility_id`, `organization_role_id`
1795
179620:03:09 [INF][ copytable]: --table `erp_core` `failed_jobs` `erp_core` `failed_jobs` `id` `id` `id`, `connection`, `queue`, `payload`, `failed_at`
1797
179820:03:09 [INF][ copytable]: --table `erp_core` `organization_role_permission` `erp_core` `organization_role_permission` `organization_role_id`,`permission_id` `organization_role_id`,`permission_id` `organization_role_id`, `permission_id`
1799
180020:03:09 [INF][ copytable]: --table `erp_core` `migrations` `erp_core` `migrations` `migration`, `batch`
1801
180220:03:09 [INF][ copytable]: --table `erp_core` `services` `erp_core` `services` `id` `id` `id`, `application_id`, `service_key`, `description`, `address`, `route`, `request_type`, `request_definition`, `response_definition`, `created_at`, `updated_at`
1803
180420:03:09 [INF][ copytable]: --table `erp_core` `permissions` `erp_core` `permissions` `id` `id` `id`, `permission_key`, `permission_name`, `description`, `module_id`, `created_at`, `updated_at`
1805
180620:03:09 [INF][ copytable]: --table `erp_core` `facility_groups` `erp_core` `facility_groups` `id` `id` `id`, `organization_id`, `name`, `deleted_at`, `created_at`, `updated_at`
1807
180820:03:09 [INF][ copytable]: --table `erp_core` `setting_values` `erp_core` `setting_values` `id` `id` `id`, `organization_id`, `setting_id`, `setting_key`, `configuration_level`, `entity_id`, `value`, `created_at`, `updated_at`
1809
181020:03:09 [INF][ copytable]: --table `erp_core` `user_phones` `erp_core` `user_phones` `id` `id` `id`, `organization_id`, `user_id`, `type`, `number`, `active`, `sms`, `primary`, `created_at`, `updated_at`, `deleted_at`
1811
181220:03:09 [INF][ copytable]: --table `erp_core` `settings` `erp_core` `settings` `id` `id` `id`, `application_id`, `setting_key`, `data_type`, `title`, `description`, `organization_level`, `facility_level`, `default_value`, `encrypt_value`, `created_at`, `updated_at`
1813
181420:03:09 [INF][ copytable]: --table `erp_core` `password_resets` `erp_core` `password_resets` `email`, `token`, `created_at`
1815
181620:03:09 [INF][ copytable]: --table `erp_core` `password_reset_log` `erp_core` `password_reset_log` `email`, `username`, `email_sent`, `valid_lookup`, `created_at`
1817
181820:03:09 [INF][ copytable]: --table `erp_core` `countries` `erp_core` `countries` `id` `id` `id`, `name`, `country_code`
1819
182020:03:09 [INF][ copytable]: --table `erp_core` `user_ids` `erp_core` `user_ids` `id` `id` `id`, `organization_id`, `user_id`, `type`, `identification_number`, `state`, `active`, `expired_at`, `created_at`, `updated_at`, `deleted_at`
1821
182220:03:09 [INF][ copytable]: Connecting to MySQL server at mjp-msc01-common-aurora-20181110-rdscluster-xkgb67a7c9dm.cluster-cmlhkki32r54.us-west-2.rds.amazonaws.com:3306 with user root
1823
182420:03:10 [INF][ copytable]: Connection to MySQL opened
1825
182620:03:11 [INF][ copytable]: Connecting to MySQL server at mrwcakibc0k11y.cmlhkki32r54.us-west-2.rds.amazonaws.com:3306 with user root
1827
182820:03:12 [INF][ copytable]: Connection to MySQL opened
1829
183020:03:12 [INF][ copytable]: Connecting to MySQL server at mjp-msc01-common-aurora-20181110-rdscluster-xkgb67a7c9dm.cluster-cmlhkki32r54.us-west-2.rds.amazonaws.com:3306 with user root
1831
183220:03:12 [INF][ copytable]: Connection to MySQL opened
1833
183420:03:13 [INF][ copytable]: Connecting to MySQL server at mrwcakibc0k11y.cmlhkki32r54.us-west-2.rds.amazonaws.com:3306 with user root
1835
1836Loading table information from file c:\users\mixma\appdata\local\temp\tmpxhifkx
1837
1838`erp_core`.`organizations`:Copying 13 columns of 995 rows from table `erp_core`.`organizations`
183920:03:13 [INF][ copytable]: Connection to MySQL opened
1840
1841ERROR: `erp_core`.`organizations`:mysql_stmt_prepare: Table 'erp_core.organizations' doesn't exist
184220:03:13 [INF][ copytable]: Connecting to MySQL server at mjp-msc01-common-aurora-20181110-rdscluster-xkgb67a7c9dm.cluster-cmlhkki32r54.us-west-2.rds.amazonaws.com:3306 with user root
1843
1844ERROR: `erp_core`.`organizations`:Failed copying 995 rows
1845`erp_core`.`online_users`:Copying 7 columns of 0 rows from table `erp_core`.`online_users`
1846ERROR: `erp_core`.`online_users`:mysql_stmt_prepare: Table 'erp_core.online_users' doesn't exist
184720:03:14 [IEND:`erp_core`.`online_users`:Finished copying 0 rows in 0m01s
1848
1849NF][ copytable]: Connection to MySQL opened
1850
1851`erp_core`.`user_facilities`:Copying 5 columns of 26003 rows from table `erp_core`.`user_facilities`
1852ERROR: `erp_core`.`user_facilities`:mysql_stmt_prepare: Table 'erp_core.user_facilities' doesn't exist
1853ERROR: `erp_core`.`user_facilities`:Failed copying 26003 rows
1854`erp_core`.`facility_group_members`:Copying 6 columns of 115 rows from table `erp_core`.`facility_group_members`
1855ERROR: `erp_core`.`facility_group_members`:mysql_stmt_prepare: Table 'erp_core.facility_group_members' doesn't exist
1856ERROR: `erp_core`.`facility_group_members`:Failed copying 115 rows
1857`erp_core`.`facility_group_settings`:Copying 6 columns of 340 rows from table `erp_core`.`facility_group_settings`
1858ERROR: `erp_core`.`facility_group_settings`:mysql_stmt_prepare: Table 'erp_core.facility_group_settings' doesn't exist
1859ERROR: `erp_core`.`facility_group_settings`:Failed copying 340 rows
1860`erp_core`.`licensing`:Copying 8 columns of 0 rows from table `erp_core`.`licensing`
1861ERROR: `erp_core`.`licensing`:mysql_stmt_prepare: Table 'erp_core.licensing' doesn't exist
1862`erp_core`.`licensing`:Finished copying 0 rows in 0m01s
1863`erp_core`.`user_addresses`:Copying 14 columns of 8877 rows from table `erp_core`.`user_addresses`
1864ERROR: `erp_core`.`user_addresses`:mysql_stmt_prepare: Table 'erp_core.user_addresses' doesn't exist
1865ERROR: `erp_core`.`user_addresses`:Failed copying 8877 rows
1866`erp_core`.`events`:Copying 16 columns of 4338 rows from table `erp_core`.`events`
1867ERROR: `erp_core`.`events`:mysql_stmt_prepare: Table 'erp_core.events' doesn't exist
1868`erp_core`.`applications`:Copying 6 columns of 23 rows from table `erp_core`.`applications`
1869`erp_core`.`applications`:Finished copying 23 rows in 0m01s
1870ERROR: `erp_core`.`events`:Failed copying 4338 rows
1871`erp_core`.`organization_master_users`:Copying 5 columns of 2820 rows from table `erp_core`.`organization_master_users`
1872ERROR: `erp_core`.`organization_master_users`:mysql_stmt_prepare: Table 'erp_core.organization_master_users' doesn't exist
1873ERROR: `erp_core`.`organization_master_users`:Failed copying 2820 rows
1874`erp_core`.`user_notes`:Copying 9 columns of 0 rows from table `erp_core`.`user_notes`
1875ERROR: `erp_core`.`user_notes`:mysql_stmt_prepare: Table 'erp_core.user_notes' doesn't exist
1876`erp_core`.`user_notes`:Finished copying 0 rows in 0m01s
1877`erp_core`.`cache`:Copying 3 columns of 98874 rows from table `erp_core`.`cache`
1878`erp_core`.`organization_roles`:Copying 10 columns of 48276 rows from table `erp_core`.`organization_roles`
1879ERROR: `erp_core`.`organization_roles`:mysql_stmt_prepare: Table 'erp_core.organization_roles' doesn't exist
1880ERROR: `erp_core`.`organization_roles`:Failed copying 48276 rows
1881`erp_core`.`organization_app_storage`:Copying 8 columns of 0 rows from table `erp_core`.`organization_app_storage`
1882ERROR: `erp_core`.`organization_app_storage`:mysql_stmt_prepare: Table 'erp_core.organization_app_storage' doesn't exist
1883`erp_core`.`organization_app_storage`:Finished copying 0 rows in 0m00s
1884`erp_core`.`storage`:Copying 8 columns of 7 rows from table `erp_core`.`storage`
1885`erp_core`.`storage`:Finished copying 7 rows in 0m01s
1886`erp_core`.`reporting_access_levels`:Copying 2 columns of 4 rows from table `erp_core`.`reporting_access_levels`
1887`erp_core`.`reporting_access_levels`:Finished copying 4 rows in 0m00s
1888`erp_core`.`token_requests`:Copying 8 columns of 1302 rows from table `erp_core`.`token_requests`
1889ERROR: `erp_core`.`token_requests`:mysql_stmt_prepare: Table 'erp_core.token_requests' doesn't exist
1890ERROR: `erp_core`.`token_requests`:Failed copying 1302 rows
1891`erp_core`.`facilities`:Copying 22 columns of 2138 rows from table `erp_core`.`facilities`
1892ERROR: `erp_core`.`facilities`:mysql_stmt_prepare: Table 'erp_core.facilities' doesn't exist
1893ERROR: `erp_core`.`facilities`:Failed copying 2138 rows
1894`erp_core`.`jobs`:Copying 8 columns of 0 rows from table `erp_core`.`jobs`
1895ERROR: `erp_core`.`jobs`:mysql_stmt_prepare: Table 'erp_core.jobs' doesn't exist
1896`erp_core`.`jobs`:Finished copying 0 rows in 0m00s
1897`erp_core`.`modules`:Copying 5 columns of 16 rows from table `erp_core`.`modules`
1898`erp_core`.`modules`:Finished copying 16 rows in 0m01s
1899`erp_core`.`user_settings`:Copying 5 columns of 2185 rows from table `erp_core`.`user_settings`
1900ERROR: `erp_core`.`user_settings`:mysql_stmt_prepare: Table 'erp_core.user_settings' doesn't exist
1901ERROR: `erp_core`.`user_settings`:Failed copying 2185 rows
1902`erp_core`.`qlik_timezone_mappings`:Copying 2 columns of 52 rows from table `erp_core`.`qlik_timezone_mappings`
1903ERROR: `erp_core`.`qlik_timezone_mappings`:mysql_stmt_prepare: Table 'erp_core.qlik_timezone_mappings' doesn't exist
1904ERROR: `erp_core`.`qlik_timezone_mappings`:Failed copying 52 rows
1905`erp_core`.`message_subscribers`:Copying 6 columns of 107 rows from table `erp_core`.`message_subscribers`
1906`erp_core`.`message_subscribers`:Finished copying 107 rows in 0m01s
1907`erp_core`.`facility_modules`:Copying 6 columns of 19404 rows from table `erp_core`.`facility_modules`
1908ERROR: `erp_core`.`facility_modules`:mysql_stmt_prepare: Table 'erp_core.facility_modules' doesn't exist
1909ERROR: `erp_core`.`facility_modules`:Failed copying 19404 rows
1910`erp_core`.`object_files`:Copying 11 columns of 3362 rows from table `erp_core`.`object_files`
1911ERROR: `erp_core`.`object_files`:mysql_stmt_prepare: Table 'erp_core.object_files' doesn't exist
1912ERROR: `erp_core`.`object_files`:Failed copying 3362 rows
1913`erp_core`.`users`:Copying 27 columns of 9663 rows from table `erp_core`.`users`
1914ERROR: `erp_core`.`users`:mysql_stmt_prepare: Table 'erp_core.users' doesn't exist
1915ERROR: `erp_core`.`users`:Failed copying 9663 rows
1916`erp_core`.`user_integration_ids`:Copying 13 columns of 8062 rows from table `erp_core`.`user_integration_ids`
1917ERROR: `erp_core`.`user_integration_ids`:mysql_stmt_prepare: Table 'erp_core.user_integration_ids' doesn't exist
1918ERROR: `erp_core`.`user_integration_ids`:Failed copying 8062 rows
1919`erp_core`.`provinces`:Copying 4 columns of 88 rows from table `erp_core`.`provinces`
1920`erp_core`.`provinces`:Finished copying 88 rows in 0m01s
1921`erp_core`.`user_facility_roles`:Copying 2 columns of 34602 rows from table `erp_core`.`user_facility_roles`
1922ERROR: `erp_core`.`user_facility_roles`:mysql_stmt_prepare: Table 'erp_core.user_facility_roles' doesn't exist
1923ERROR: `erp_core`.`user_facility_roles`:Failed copying 34602 rows
1924`erp_core`.`failed_jobs`:Copying 5 columns of 0 rows from table `erp_core`.`failed_jobs`
1925`erp_core`.`failed_jobs`:Finished copying 0 rows in 0m00s
1926`erp_core`.`organization_role_permission`:Copying 2 columns of 1117315 rows from table `erp_core`.`organization_role_permission`
1927ERROR: `erp_core`.`organization_role_permission`:mysql_stmt_prepare: Table 'erp_core.organization_role_permission' doesn't exist
1928ERROR: `erp_core`.`organization_role_permission`:Failed copying 1117315 rows
1929`erp_core`.`migrations`:Copying 2 columns of 180 rows from table `erp_core`.`migrations`
1930`erp_core`.`migrations`:Finished copying 180 rows in 0m01s
1931`erp_core`.`services`:Copying 11 columns of 1012 rows from table `erp_core`.`services`
1932ERROR: `erp_core`.`services`:mysql_stmt_prepare: Table 'erp_core.services' doesn't exist
1933ERROR: `erp_core`.`services`:Failed copying 1012 rows
1934`erp_core`.`permissions`:Copying 7 columns of 92 rows from table `erp_core`.`permissions`
1935ERROR: `erp_core`.`permissions`:mysql_stmt_prepare: Table 'erp_core.permissions' doesn't exist
1936ERROR: `erp_core`.`permissions`:Failed copying 92 rows
1937`erp_core`.`facility_groups`:Copying 6 columns of 81 rows from table `erp_core`.`facility_groups`
1938ERROR: `erp_core`.`facility_groups`:mysql_stmt_prepare: Table 'erp_core.facility_groups' doesn't exist
1939ERROR: `erp_core`.`facility_groups`:Failed copying 81 rows
1940`erp_core`.`setting_values`:Copying 9 columns of 17397 rows from table `erp_core`.`setting_values`
1941ERROR: `erp_core`.`setting_values`:mysql_stmt_prepare: Table 'erp_core.setting_values' doesn't exist
1942ERROR: `erp_core`.`setting_values`:Failed copying 17397 rows
1943`erp_core`.`user_phones`:Copying 11 columns of 7848 rows from table `erp_core`.`user_phones`
1944ERROR: `erp_core`.`user_phones`:mysql_stmt_prepare: Table 'erp_core.user_phones' doesn't exist
1945ERROR: `erp_core`.`user_phones`:Failed copying 7848 rows
1946`erp_core`.`settings`:Copying 12 columns of 89 rows from table `erp_core`.`settings`
1947ERROR: `erp_core`.`settings`:mysql_stmt_prepare: Table 'erp_core.settings' doesn't exist
1948ERROR: `erp_core`.`settings`:Failed copying 89 rows
1949`erp_core`.`password_resets`:Copying 3 columns of 1942 rows from table `erp_core`.`password_resets`
1950ERROR: `erp_core`.`password_resets`:mysql_stmt_prepare: Table 'erp_core.password_resets' doesn't exist
1951ERROR: `erp_core`.`password_resets`:Failed copying 1942 rows
1952`erp_core`.`password_reset_log`:Copying 5 columns of 9761 rows from table `erp_core`.`password_reset_log`
1953ERROR: `erp_core`.`password_reset_log`:mysql_stmt_prepare: Table 'erp_core.password_reset_log' doesn't exist
1954ERROR: `erp_core`.`password_reset_log`:Failed copying 9761 rows
1955`erp_core`.`countries`:Copying 3 columns of 4 rows from table `erp_core`.`countries`
1956`erp_core`.`countries`:Finished copying 4 rows in 0m01s
1957`erp_core`.`user_ids`:Copying 11 columns of 17761 rows from table `erp_core`.`user_ids`
1958ERROR: `erp_core`.`user_ids`:mysql_stmt_prepare: Table 'erp_core.user_ids' doesn't exist
1959ERROR: `erp_core`.`user_ids`:Failed copying 17761 rows
1960`erp_core`.`cache`:Finished copying 98874 rows in 2m22s
196120:05:40 [INF][ copytable]: Re-enabling triggers for schema 'erp_core'
1962
196320:05:40 [ERR][ copytable]: Exception: Querying Trigger Definitions: Lost connection to MySQL server during query
1964
1965
1966
1967
1968
1969
1970
1971
1972
1973
1974
1975
1976
1977
1978
1979ERROR: Copy helper exited with an error: Worker exited with status 1
1980
1981Data copy results:
1982- `erp_core`.`organizations` has FAILED (0 of 995 rows copied)
1983- `erp_core`.`online_users` has FAILED (0 of 0 rows copied)
1984- `erp_core`.`user_facilities` has FAILED (0 of 26003 rows copied)
1985- `erp_core`.`facility_group_members` has FAILED (0 of 115 rows copied)
1986- `erp_core`.`facility_group_settings` has FAILED (0 of 340 rows copied)
1987- `erp_core`.`licensing` has succeeded (0 of 0 rows copied)
1988- `erp_core`.`user_addresses` has FAILED (0 of 8877 rows copied)
1989- `erp_core`.`events` has FAILED (0 of 4338 rows copied)
1990- `erp_core`.`applications` has succeeded (23 of 23 rows copied)
1991- `erp_core`.`organization_master_users` has FAILED (0 of 2820 rows copied)
1992- `erp_core`.`user_notes` has succeeded (0 of 0 rows copied)
1993- `erp_core`.`cache` has succeeded (98874 of 98874 rows copied)
1994- `erp_core`.`organization_roles` has FAILED (0 of 48276 rows copied)
1995- `erp_core`.`organization_app_storage` has succeeded (0 of 0 rows copied)
1996- `erp_core`.`storage` has succeeded (7 of 7 rows copied)
1997- `erp_core`.`reporting_access_levels` has succeeded (4 of 4 rows copied)
1998- `erp_core`.`token_requests` has FAILED (0 of 1302 rows copied)
1999- `erp_core`.`facilities` has FAILED (0 of 2138 rows copied)
2000- `erp_core`.`jobs` has succeeded (0 of 0 rows copied)
2001- `erp_core`.`modules` has succeeded (16 of 16 rows copied)
2002- `erp_core`.`user_settings` has FAILED (0 of 2185 rows copied)
2003- `erp_core`.`qlik_timezone_mappings` has FAILED (0 of 52 rows copied)
2004- `erp_core`.`message_subscribers` has succeeded (107 of 107 rows copied)
2005- `erp_core`.`facility_modules` has FAILED (0 of 19404 rows copied)
2006- `erp_core`.`object_files` has FAILED (0 of 3362 rows copied)
2007- `erp_core`.`users` has FAILED (0 of 9663 rows copied)
2008- `erp_core`.`user_integration_ids` has FAILED (0 of 8062 rows copied)
2009- `erp_core`.`provinces` has succeeded (88 of 88 rows copied)
2010- `erp_core`.`user_facility_roles` has FAILED (0 of 34602 rows copied)
2011- `erp_core`.`failed_jobs` has succeeded (0 of 0 rows copied)
2012- `erp_core`.`organization_role_permission` has FAILED (0 of 1117315 rows copied)
2013- `erp_core`.`migrations` has succeeded (180 of 180 rows copied)
2014- `erp_core`.`services` has FAILED (0 of 1012 rows copied)
2015- `erp_core`.`permissions` has FAILED (0 of 92 rows copied)
2016- `erp_core`.`facility_groups` has FAILED (0 of 81 rows copied)
2017- `erp_core`.`setting_values` has FAILED (0 of 17397 rows copied)
2018- `erp_core`.`user_phones` has FAILED (0 of 7848 rows copied)
2019- `erp_core`.`settings` has FAILED (0 of 89 rows copied)
2020- `erp_core`.`password_resets` has FAILED (0 of 1942 rows copied)
2021- `erp_core`.`password_reset_log` has FAILED (0 of 9761 rows copied)
2022- `erp_core`.`countries` has succeeded (4 of 4 rows copied)
2023- `erp_core`.`user_ids` has FAILED (0 of 17761 rows copied)
202414 tables of 42 were fully copied
2025Copying table data finished
2026Reverse Engineering....
2027Reconnecting to Mysql@mrwcakibc0k11y.cmlhkki32r54.us-west-2.rds.amazonaws.com:3306...
2028Connection restablished
2029Reverse engineering erp_log from def
2030- Preparing...
2031- Preparing...
2032Reverse engineering tables from erp_log
2033- Retrieving table erp_log.failed_jobs...
2034- Reverse engineering erp_log.failed_jobs...
2035- Retrieving table erp_log.jobs...
2036- Reverse engineering erp_log.jobs...
2037- Retrieving table erp_log.migrations...
2038- Reverse engineering erp_log.migrations...
2039- Retrieving table erp_log.system_log...
2040- Reverse engineering erp_log.system_log...
2041- Retrieving table erp_log.user_log...
2042- Reverse engineering erp_log.user_log...
2043Reverse engineering triggers from erp_log
2044Reverse engineering stored procedures from erp_log
2045Reverse engineering functions from erp_log
2046- Reverse engineered 5 objects
2047Reverse Engineering finished
2048Migrating...
2049- Migrating...
2050- Migrating schema erp_log...
2051- Migrating schema contents for schema erp_log
2052- Table erp_log.failed_jobs migrated
2053- Table erp_log.jobs migrated
2054- Table erp_log.migrations migrated
2055- Table erp_log.system_log migrated
2056- Table erp_log.user_log migrated
2057- Finalizing foreign key migration...
2058- Migration finished
2059Migrating done
2060Generating Code...
2061Generating Code done
2062Creating target schema....
2063Reconnecting to Mysql@mjp-msc01-common-aurora-20181110-rdscluster-xkgb67a7c9dm.cluster-cmlhkki32r54.us-west-2.rds.amazonaws.com:3306...
2064Connection reestablished
2065- Creating schema in target MySQL server at Mysql@mjp-msc01-common-aurora-20181110-rdscluster-xkgb67a7c9dm.cluster-cmlhkki32r54.us-west-2.rds.amazonaws.com:3306...
2066- Executing preamble script...
2067Execute statement: SET FOREIGN_KEY_CHECKS = 0
2068- Creating schema erp_log...
2069Execute statement: DROP SCHEMA IF EXISTS `erp_log`
2070Execute statement:
2071
2072 CREATE SCHEMA IF NOT EXISTS `erp_log`
2073- Creating table erp_log.failed_jobs
2074Execute statement:
2075 CREATE TABLE IF NOT EXISTS `erp_log`.`failed_jobs` (
2076 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
2077 `connection` TEXT NOT NULL,
2078 `queue` TEXT NOT NULL,
2079 `payload` LONGTEXT NOT NULL,
2080 `exception` LONGTEXT NOT NULL,
2081 `failed_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
2082 PRIMARY KEY (`id`))
2083 ENGINE = InnoDB
2084 AUTO_INCREMENT = 60660
2085 DEFAULT CHARACTER SET = utf8
2086 COLLATE = utf8_unicode_ci
2087- Creating table erp_log.jobs
2088Execute statement:
2089 CREATE TABLE IF NOT EXISTS `erp_log`.`jobs` (
2090 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
2091 `queue` VARCHAR(255) NOT NULL,
2092 `payload` LONGTEXT NOT NULL,
2093 `attempts` TINYINT(3) UNSIGNED NOT NULL,
2094 `reserved` TINYINT(3) UNSIGNED NOT NULL,
2095 `reserved_at` INT(10) UNSIGNED NULL DEFAULT NULL,
2096 `available_at` INT(10) UNSIGNED NOT NULL,
2097 `created_at` INT(10) UNSIGNED NOT NULL,
2098 PRIMARY KEY (`id`),
2099 INDEX `jobs_id_queue_reserved_reserved_at_index` (`id` ASC, `queue` ASC, `reserved` ASC, `reserved_at` ASC) VISIBLE)
2100 ENGINE = InnoDB
2101 AUTO_INCREMENT = 663843
2102 DEFAULT CHARACTER SET = utf8
2103 COLLATE = utf8_unicode_ci
2104WARNING: Error executing 'CREATE TABLE IF NOT EXISTS `erp_log`.`jobs` (
2105 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
2106 `queue` VARCHAR(255) NOT NULL,
2107 `payload` LONGTEXT NOT NULL,
2108 `attempts` TINYINT(3) UNSIGNED NOT NULL,
2109 `reserved` TINYINT(3) UNSIGNED NOT NULL,
2110 `reserved_at` INT(10) UNSIGNED NULL DEFAULT NULL,
2111 `available_at` INT(10) UNSIGNED NOT NULL,
2112 `created_at` INT(10) UNSIGNED NOT NULL,
2113 PRIMARY KEY (`id`),
2114 INDEX `jobs_id_queue_reserved_reserved_at_index` (`id` ASC, `queue` ASC, `reserved` ASC, `reserved_at` ASC) VISIBLE)
2115ENGINE = InnoDB
2116AUTO_INCREMENT = 663843
2117DEFAULT CHARACTER SET = utf8
2118COLLATE = utf8_unicode_ci'
2119You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE)
2120ENGINE = InnoDB
2121AUTO_INCREMENT = 663843
2122DEFAULT CHARACTER SET = utf8
2123CO' at line 11.
2124SQL Error: 1064
2125- Creating table erp_log.migrations
2126Execute statement:
2127 CREATE TABLE IF NOT EXISTS `erp_log`.`migrations` (
2128 `migration` VARCHAR(255) NOT NULL,
2129 `batch` INT(11) NOT NULL)
2130 ENGINE = InnoDB
2131 DEFAULT CHARACTER SET = utf8
2132 COLLATE = utf8_unicode_ci
2133- Creating table erp_log.system_log
2134Execute statement:
2135 CREATE TABLE IF NOT EXISTS `erp_log`.`system_log` (
2136 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
2137 `name` VARCHAR(255) NOT NULL,
2138 `type` VARCHAR(255) NOT NULL,
2139 `application` VARCHAR(255) NULL DEFAULT NULL,
2140 `organization_id` INT(11) NULL DEFAULT NULL,
2141 `facility_id` INT(11) NULL DEFAULT NULL,
2142 `user_id` INT(11) NULL DEFAULT NULL,
2143 `message` LONGTEXT NOT NULL,
2144 `additional_details` LONGTEXT NULL DEFAULT NULL,
2145 `created_at` TIMESTAMP NULL DEFAULT NULL,
2146 `updated_at` TIMESTAMP NULL DEFAULT NULL,
2147 PRIMARY KEY (`id`))
2148 ENGINE = InnoDB
2149 AUTO_INCREMENT = 956678
2150 DEFAULT CHARACTER SET = utf8
2151 COLLATE = utf8_unicode_ci
2152- Creating table erp_log.user_log
2153Execute statement:
2154 CREATE TABLE IF NOT EXISTS `erp_log`.`user_log` (
2155 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
2156 `name` VARCHAR(255) NOT NULL,
2157 `type` VARCHAR(255) NOT NULL,
2158 `application` VARCHAR(255) NULL DEFAULT NULL,
2159 `organization_id` INT(11) NULL DEFAULT NULL,
2160 `facility_id` INT(11) NULL DEFAULT NULL,
2161 `user_id` INT(11) NULL DEFAULT NULL,
2162 `message` LONGTEXT NOT NULL,
2163 `additional_details` LONGTEXT NULL DEFAULT NULL,
2164 `created_at` TIMESTAMP NULL DEFAULT NULL,
2165 `updated_at` TIMESTAMP NULL DEFAULT NULL,
2166 PRIMARY KEY (`id`))
2167 ENGINE = InnoDB
2168 DEFAULT CHARACTER SET = utf8
2169 COLLATE = utf8_unicode_ci
2170Scripts for 4 tables, 0 views and 0 routines were executed for schema erp_log
2171- Executing postamble script...
2172Execute statement: SET FOREIGN_KEY_CHECKS = 1
2173- Schema created
2174Creating target schema finished
2175Selecting tables to copy...
2176Selecting tables to copy done
2177Counting table rows to copy....
2178wbcopytables.exe --count-only --passwords-from-stdin --mysql-source="root@mrwcakibc0k11y.cmlhkki32r54.us-west-2.rds.amazonaws.com:3306" --source-rdbms-type=Mysql --target="root@mjp-msc01-common-aurora-20181110-rdscluster-xkgb67a7c9dm.cluster-cmlhkki32r54.us-west-2.rds.amazonaws.com:3306" --resume --table-file=c:\users\mixma\appdata\local\temp\tmpoemgdy
2179--table `erp_log` `system_log` `erp_log` `system_log` `id` `id` `id`, `name`, `type`, `application`, `organization_id`, `facility_id`, `user_id`, `message`, `additional_details`, `created_at`, `updated_at`
218020:05:47 [INF][ copytable]: --table `erp_log` `user_log` `erp_log` `user_log` `id` `id` `id`, `name`, `type`, `application`, `organization_id`, `facility_id`, `user_id`, `message`, `additional_details`, `created_at`, `updated_at`
218120:05:47 [INF][ copytable]: --table `erp_log` `jobs` `erp_log` `jobs` `id` `id` `id`, `queue`, `payload`, `attempts`, `reserved`, `reserved_at`, `available_at`, `created_at`
218220:05:47 [INF][ copytable]: --table `erp_log` `failed_jobs` `erp_log` `failed_jobs` `id` `id` `id`, `connection`, `queue`, `payload`, `exception`, `failed_at`
218320:05:47 [INF][ copytable]: --table `erp_log` `migrations` `erp_log` `migrations` `migration`, `batch`
218420:05:47 [INF][ copytable]: Connecting to MySQL server at mrwcakibc0k11y.cmlhkki32r54.us-west-2.rds.amazonaws.com:3306 with user root
218520:05:48 [INF][ copytable]: Connection to MySQL opened
218620:05:48 [INF][ copytable]: Connecting to MySQL server at mjp-msc01-common-aurora-20181110-rdscluster-xkgb67a7c9dm.cluster-cmlhkki32r54.us-west-2.rds.amazonaws.com:3306 with user root
218720:05:48 [INF][ copytable]: Connection to MySQL opened
218820:05:49 [INF][ copytable]: Resuming copy of table `erp_log`.`system_log`. Starting on record with keys:
218920:05:57 [INF][ copytable]: Resuming copy of table `erp_log`.`user_log`. Starting on record with keys:
219020:05:57 [ERR][ copytable]: Exception: mysql_query(SELECT `id` FROM `erp_log`.`jobs` ORDER BY `id` DESC LIMIT 0,1): Table 'erp_log.jobs' doesn't exist
2191
2192Loading table information from file c:\users\mixma\appdata\local\temp\tmpoemgdy
2193ROW_COUNT:`erp_log`:`system_log`: 956677
2194ROW_COUNT:`erp_log`:`user_log`: 0
2195
2196
2197Traceback (most recent call last):
2198 File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_copy_progress.py", line 155, in thread_work
2199 self.func()
2200 File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_copy_progress.py", line 641, in _row_count
2201 total = self._transferer.count_table_rows(self._working_set)
2202 File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\DataMigrator.py", line 285, in count_table_rows
2203 raise Exception("Error getting row count from source tables, wbcopytables exited with code %s" % out.returncode)
2204Exception: Error getting row count from source tables, wbcopytables exited with code 1
2205ERROR: Counting table rows to copy: Error getting row count from source tables, wbcopytables exited with code 1
2206Failed