09:51:15 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: /usr/share/mysql-workbench
	plugin path: /usr/lib/mysql-workbench/plugins
	struct path: /usr/share/mysql-workbench/grt
	module path: /usr/lib/mysql-workbench/modules
	library path: /usr/share/mysql-workbench/libraries
	user data dir: /home/joachim/.mysql/workbench
	open at start: 
	open type: 
	run at startup: 
	run type: 
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
09:51:15 [INF][      WBContext]: WbContext::init
09:51:15 [INF][            WBA]: Looking for extension modules for WBA...
09:51:15 [INF][            WBA]: 0 extension modules found
09:51:15 [WRN][            grt]: Duplicate plugin name wb.tools.cmdlineClient	There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
09:51:15 [WRN][            grt]: /home/joachim/.mysql/workbench/connections.xml:25: link '2a7bcffa-f03a-11ec-ad3c-9d9fa9b6f4b5' <object GrtObject> key=owner could not be resolved
09:51:15 [WRN][            grt]: Duplicate plugin name wb.tools.cmdlineClient	There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
09:51:15 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Linux/Unix version 8.0.29 CE build 1751076 (64 bit)
	Configuration Directory: /home/joachim/.mysql/workbench
	Data Directory: /usr/share/mysql-workbench
	Cairo Version: 1.16.0
	OS: Ubuntu 20.04 x86_64
	CPU: 12x AMD Ryzen 5 3600 6-Core Processor (2200.000MHz) - 15.57GiB RAM
No video adapter info available
	Distribution: Ubuntu 20.04.4 LTS

	Fips mode enabled: no

09:51:19 [INF][SSHTunnelManager]: Wakeup socket port created: 33205
09:51:19 [INF][     SSH tunnel]: Starting tunnel
09:51:19 [INF][     SSH tunnel]: Existing SSH tunnel not found, opening new one
09:51:19 [INF][     SSH tunnel]: Opening SSH tunnel to 54.255.224.94:22
09:51:19 [INF][      SSHCommon]: libssh: ssh_connect ssh_connect: libssh 0.9.6 (c) 2003-2021 Aris Adamantiadis, Andreas Schneider and libssh contributors. Distributed under the LGPL, please refer to COPYING file for information about your rights, using threading threads_stdthread
09:51:19 [INF][      SSHCommon]: libssh: ssh_socket_connect ssh_socket_connect: Nonblocking connection socket: 19
09:51:19 [INF][      SSHCommon]: libssh: ssh_connect ssh_connect: Socket connecting, now waiting for the callbacks to work
09:51:19 [INF][      SSHCommon]: libssh: ssh_client_connection_callback ssh_client_connection_callback: SSH server banner: SSH-2.0-OpenSSH_7.4
09:51:19 [INF][      SSHCommon]: libssh: ssh_analyze_banner ssh_analyze_banner: Analyzing banner: SSH-2.0-OpenSSH_7.4
09:51:19 [INF][      SSHCommon]: libssh: ssh_analyze_banner ssh_analyze_banner: We are talking to an OpenSSH client version: 7.4 (70400)
09:51:19 [INF][      SSHCommon]: libssh: ssh_kex_select_methods ssh_kex_select_methods: Negotiated curve25519-sha256,ssh-ed25519,aes256-gcm@openssh.com,aes256-gcm@openssh.com,aead-gcm,aead-gcm,none,none,,
09:51:20 [INF][      SSHCommon]: libssh: ssh_init_rekey_state ssh_init_rekey_state: Set rekey after 4294967296 blocks
09:51:20 [INF][      SSHCommon]: libssh: ssh_init_rekey_state ssh_init_rekey_state: Set rekey after 4294967296 blocks
09:51:20 [INF][      SSHCommon]: libssh: ssh_packet_client_curve25519_reply ssh_packet_client_curve25519_reply: SSH_MSG_NEWKEYS sent
09:51:20 [INF][      SSHCommon]: libssh: ssh_packet_newkeys ssh_packet_newkeys: Received SSH_MSG_NEWKEYS
09:51:20 [INF][      SSHCommon]: libssh: ssh_packet_newkeys ssh_packet_newkeys: Signature verified and valid
09:51:20 [INF][      SSHCommon]: libssh: ssh_packet_userauth_failure ssh_packet_userauth_failure: Access denied for 'none'. Authentication that can continue: publickey
09:51:20 [INF][     SSHSession]: Banner: 
09:51:20 [INF][      SSHCommon]: libssh: ssh_pki_import_privkey_base64 ssh_pki_import_privkey_base64: Trying to decode privkey passphrase=true
09:51:20 [INF][      SSHCommon]: libssh: ssh_pki_openssh_import ssh_pki_openssh_import: Opening OpenSSH private key: ciphername: none, kdf: none, nkeys: 1
09:51:20 [INF][     SSH tunnel]: SSH tunnel opened on port: 35057
09:51:21 [INF][SQL Editor Form]: Opened connection 'Eagle OpenVPN STG' to Source distribution version 10.5.9-MariaDB
09:51:22 [ERR][      WBContext]: Unsupported server version: Source distribution 10.5.9-MariaDB
09:51:47 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
09:51:47 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
09:51:47 [WRN][   mforms.linux]: Unknown column storage type[20]
09:51:47 [WRN][   mforms.linux]: Unknown column storage type[20]
09:59:24 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
10:00:21 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:00:28 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
10:01:24 [WRN][wb_admin_export.py:process_db:268]: Task exited with code -15
10:01:24 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:03:20 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
10:04:16 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:34 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
10:10:35 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:37 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:38 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:39 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:40 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:41 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:42 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:43 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:44 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:45 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:46 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:47 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:48 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:50 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:51 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:52 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:53 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:54 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:55 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:56 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:57 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:58 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:10:59 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:00 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:01 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:02 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:03 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:05 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:06 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:07 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:22 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:23 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:24 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:25 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:26 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:27 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:28 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:29 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:30 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:31 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:32 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:33 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:34 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:35 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:36 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:38 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:39 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:40 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:41 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:42 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:43 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:44 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:45 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:46 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:47 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:48 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:49 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:50 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:51 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:52 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:53 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:54 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:55 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:56 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:57 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:58 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:11:59 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:12:00 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:12:01 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:12:02 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:12:03 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:12:04 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:12:05 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:12:06 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:26:42 [INF][     SSH tunnel]: Existing SSH tunnel not found, opening new one
10:26:42 [INF][     SSH tunnel]: Opening SSH tunnel to 18.140.1.174:22
10:26:42 [INF][      SSHCommon]: libssh: ssh_connect ssh_connect: libssh 0.9.6 (c) 2003-2021 Aris Adamantiadis, Andreas Schneider and libssh contributors. Distributed under the LGPL, please refer to COPYING file for information about your rights, using threading threads_stdthread
10:26:42 [INF][      SSHCommon]: libssh: ssh_socket_connect ssh_socket_connect: Nonblocking connection socket: 22
10:26:42 [INF][      SSHCommon]: libssh: ssh_connect ssh_connect: Socket connecting, now waiting for the callbacks to work
10:26:43 [INF][      SSHCommon]: libssh: ssh_client_connection_callback ssh_client_connection_callback: SSH server banner: SSH-2.0-OpenSSH_7.4
10:26:43 [INF][      SSHCommon]: libssh: ssh_analyze_banner ssh_analyze_banner: Analyzing banner: SSH-2.0-OpenSSH_7.4
10:26:43 [INF][      SSHCommon]: libssh: ssh_analyze_banner ssh_analyze_banner: We are talking to an OpenSSH client version: 7.4 (70400)
10:26:43 [INF][      SSHCommon]: libssh: ssh_kex_select_methods ssh_kex_select_methods: Negotiated curve25519-sha256,ssh-ed25519,aes256-gcm@openssh.com,aes256-gcm@openssh.com,aead-gcm,aead-gcm,none,none,,
10:26:43 [INF][      SSHCommon]: libssh: ssh_init_rekey_state ssh_init_rekey_state: Set rekey after 4294967296 blocks
10:26:43 [INF][      SSHCommon]: libssh: ssh_init_rekey_state ssh_init_rekey_state: Set rekey after 4294967296 blocks
10:26:43 [INF][      SSHCommon]: libssh: ssh_packet_client_curve25519_reply ssh_packet_client_curve25519_reply: SSH_MSG_NEWKEYS sent
10:26:43 [INF][      SSHCommon]: libssh: ssh_packet_newkeys ssh_packet_newkeys: Received SSH_MSG_NEWKEYS
10:26:43 [INF][      SSHCommon]: libssh: ssh_packet_newkeys ssh_packet_newkeys: Signature verified and valid
10:26:43 [INF][      SSHCommon]: libssh: ssh_packet_userauth_failure ssh_packet_userauth_failure: Access denied for 'none'. Authentication that can continue: publickey
10:26:43 [INF][     SSHSession]: Banner: 
10:26:43 [INF][      SSHCommon]: libssh: ssh_pki_import_privkey_base64 ssh_pki_import_privkey_base64: Trying to decode privkey passphrase=true
10:26:43 [INF][      SSHCommon]: libssh: ssh_pki_openssh_import ssh_pki_openssh_import: Opening OpenSSH private key: ciphername: none, kdf: none, nkeys: 1
10:26:43 [INF][     SSH tunnel]: SSH tunnel opened on port: 40095
10:26:45 [INF][SQL Editor Form]: Opened connection 'Eagle PROD' to managed by https://aws.amazon.com/rds/ version 10.5.12-MariaDB-log
10:26:46 [ERR][      WBContext]: Unsupported server version: managed by https://aws.amazon.com/rds/ 10.5.12-MariaDB-log
10:27:35 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
10:27:35 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
10:27:35 [WRN][   mforms.linux]: Unknown column storage type[20]
10:27:35 [WRN][   mforms.linux]: Unknown column storage type[20]
10:29:50 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
10:32:45 [ERR][wb_admin_export.py:process_db:242]: Error from task: mysqldump: Got errno 28 on write

10:32:45 [WRN][wb_admin_export.py:process_db:268]: Task exited with code 5
10:32:45 [ERR][SSHTunnelHandler]: Error during data transfer: unable to write, client disconnected
10:33:33 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
10:36:38 [ERR][wb_admin_export.py:process_db:242]: Error from task: mysqldump: Got errno 28 on write

10:36:38 [WRN][wb_admin_export.py:process_db:268]: Task exited with code 5
10:36:38 [ERR][SSHTunnelHandler]: Error during data transfer: unable to write, client disconnected
10:54:29 [INF][     SSH tunnel]: Existing SSH tunnel not found, opening new one
10:54:29 [INF][     SSH tunnel]: Opening SSH tunnel to 54.255.224.94:22
10:54:29 [INF][      SSHCommon]: libssh: ssh_connect ssh_connect: libssh 0.9.6 (c) 2003-2021 Aris Adamantiadis, Andreas Schneider and libssh contributors. Distributed under the LGPL, please refer to COPYING file for information about your rights, using threading threads_stdthread
10:54:29 [INF][      SSHCommon]: libssh: ssh_socket_connect ssh_socket_connect: Nonblocking connection socket: 25
10:54:29 [INF][      SSHCommon]: libssh: ssh_connect ssh_connect: Socket connecting, now waiting for the callbacks to work
10:54:29 [INF][      SSHCommon]: libssh: ssh_client_connection_callback ssh_client_connection_callback: SSH server banner: SSH-2.0-OpenSSH_7.4
10:54:29 [INF][      SSHCommon]: libssh: ssh_analyze_banner ssh_analyze_banner: Analyzing banner: SSH-2.0-OpenSSH_7.4
10:54:29 [INF][      SSHCommon]: libssh: ssh_analyze_banner ssh_analyze_banner: We are talking to an OpenSSH client version: 7.4 (70400)
10:54:29 [INF][      SSHCommon]: libssh: ssh_kex_select_methods ssh_kex_select_methods: Negotiated curve25519-sha256,ssh-ed25519,aes256-gcm@openssh.com,aes256-gcm@openssh.com,aead-gcm,aead-gcm,none,none,,
10:54:29 [INF][      SSHCommon]: libssh: ssh_init_rekey_state ssh_init_rekey_state: Set rekey after 4294967296 blocks
10:54:29 [INF][      SSHCommon]: libssh: ssh_init_rekey_state ssh_init_rekey_state: Set rekey after 4294967296 blocks
10:54:29 [INF][      SSHCommon]: libssh: ssh_packet_client_curve25519_reply ssh_packet_client_curve25519_reply: SSH_MSG_NEWKEYS sent
10:54:29 [INF][      SSHCommon]: libssh: ssh_packet_newkeys ssh_packet_newkeys: Received SSH_MSG_NEWKEYS
10:54:29 [INF][      SSHCommon]: libssh: ssh_packet_newkeys ssh_packet_newkeys: Signature verified and valid
10:54:29 [INF][      SSHCommon]: libssh: ssh_packet_userauth_failure ssh_packet_userauth_failure: Access denied for 'none'. Authentication that can continue: publickey
10:54:29 [INF][     SSHSession]: Banner: 
10:54:29 [INF][      SSHCommon]: libssh: ssh_pki_import_privkey_base64 ssh_pki_import_privkey_base64: Trying to decode privkey passphrase=true
10:54:29 [INF][      SSHCommon]: libssh: ssh_pki_openssh_import ssh_pki_openssh_import: Opening OpenSSH private key: ciphername: none, kdf: none, nkeys: 1
10:54:29 [INF][     SSH tunnel]: SSH tunnel opened on port: 37317
10:54:31 [INF][SQL Editor Form]: Opened connection 'Eagle OpenVPN STG' to Source distribution version 10.5.9-MariaDB
10:54:32 [ERR][      WBContext]: Unsupported server version: Source distribution 10.5.9-MariaDB
10:55:23 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
10:55:23 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
10:55:23 [WRN][   mforms.linux]: Unknown column storage type[20]
10:55:23 [WRN][   mforms.linux]: Unknown column storage type[20]
10:56:09 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
10:57:25 [ERR][wb_admin_export.py:process_db:242]: Error from task: mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ `VARIABLE_NAME`, `SESSION_VALUE`, `GLOBAL_VALUE`, `GLOBAL_VALUE_ORIGIN`, `DEFAULT_VALUE`, `VARIABLE_SCOPE`, `VARIABLE_TYPE`, `VARIABLE_COMMENT`, `NUMERIC_MIN_VALUE`, `NUMERIC_MAX_VALUE`, `NUMERIC_BLOCK_SIZE`, `ENUM_VALUE_LIST`, `READ_ONLY`, `COMMAND_LINE_ARGUMENT`, `GLOBAL_VALUE_PATH` FROM `SYSTEM_VARIABLES`': Access denied for user 'eagledbuser'@'%' (using password: YES) (1045)

10:57:25 [WRN][wb_admin_export.py:process_db:268]: Task exited with code 2
10:57:25 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
10:57:50 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
10:57:50 [ERR][       pymforms]: Unhandled exception in Python code: 
10:57:50 [ERR][         python]: Error forwarding notification to Python
Traceback:
  File "/usr/share/mysql-workbench/libraries/workbench/notifications.py", line 35, in _the_observer
            for obs, nam, obj in self.observers:
  File "/usr/lib/python3.8/traceback.py", line 120, in format_exception
        return list(TracebackException(
  File "/usr/lib/python3.8/traceback.py", line 479, in __init__
            if (exc_value and exc_value.__cause__ is not None
NameError: 'str' object has no attribute '__cause__'
11:00:21 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:00:21 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:00:25 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:00:25 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:00:25 [WRN][   mforms.linux]: Unknown column storage type[20]
11:00:25 [WRN][   mforms.linux]: Unknown column storage type[20]
11:10:57 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:12:10 [ERR][wb_admin_export.py:process_db:242]: Error from task: mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ `VARIABLE_NAME`, `SESSION_VALUE`, `GLOBAL_VALUE`, `GLOBAL_VALUE_ORIGIN`, `DEFAULT_VALUE`, `VARIABLE_SCOPE`, `VARIABLE_TYPE`, `VARIABLE_COMMENT`, `NUMERIC_MIN_VALUE`, `NUMERIC_MAX_VALUE`, `NUMERIC_BLOCK_SIZE`, `ENUM_VALUE_LIST`, `READ_ONLY`, `COMMAND_LINE_ARGUMENT`, `GLOBAL_VALUE_PATH` FROM `SYSTEM_VARIABLES`': Access denied for user 'eagledbuser'@'%' (using password: YES) (1045)

11:12:10 [WRN][wb_admin_export.py:process_db:268]: Task exited with code 2
11:12:10 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:12:22 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:12:22 [ERR][       pymforms]: Unhandled exception in Python code: 
11:12:22 [ERR][         python]: Error forwarding notification to Python
Traceback:
  File "/usr/share/mysql-workbench/libraries/workbench/notifications.py", line 35, in _the_observer
            for obs, nam, obj in self.observers:
  File "/usr/lib/python3.8/traceback.py", line 120, in format_exception
        return list(TracebackException(
  File "/usr/lib/python3.8/traceback.py", line 479, in __init__
            if (exc_value and exc_value.__cause__ is not None
NameError: 'str' object has no attribute '__cause__'
11:13:55 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:13:55 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:13:56 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:13:57 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:13:57 [WRN][   mforms.linux]: Unknown column storage type[20]
11:13:57 [WRN][   mforms.linux]: Unknown column storage type[20]
11:18:56 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:18:56 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:19:01 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:19:02 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:19:02 [WRN][   mforms.linux]: Unknown column storage type[20]
11:19:02 [WRN][   mforms.linux]: Unknown column storage type[20]
11:19:42 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:21:35 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:23:49 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:24:05 [ERR][wb_admin_export.py:process_db:242]: Error from task: mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ `VARIABLE_NAME`, `SESSION_VALUE`, `GLOBAL_VALUE`, `GLOBAL_VALUE_ORIGIN`, `DEFAULT_VALUE`, `VARIABLE_SCOPE`, `VARIABLE_TYPE`, `VARIABLE_COMMENT`, `NUMERIC_MIN_VALUE`, `NUMERIC_MAX_VALUE`, `NUMERIC_BLOCK_SIZE`, `ENUM_VALUE_LIST`, `READ_ONLY`, `COMMAND_LINE_ARGUMENT`, `GLOBAL_VALUE_PATH` FROM `SYSTEM_VARIABLES`': Access denied for user 'eagledbuser'@'%' (using password: YES) (1045)

11:24:05 [WRN][wb_admin_export.py:process_db:268]: Task exited with code 2
11:24:05 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:24:08 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:24:08 [ERR][       pymforms]: Unhandled exception in Python code: 
11:24:08 [ERR][         python]: Error forwarding notification to Python
Traceback:
  File "/usr/share/mysql-workbench/libraries/workbench/notifications.py", line 35, in _the_observer
            for obs, nam, obj in self.observers:
  File "/usr/lib/python3.8/traceback.py", line 120, in format_exception
        return list(TracebackException(
  File "/usr/lib/python3.8/traceback.py", line 479, in __init__
            if (exc_value and exc_value.__cause__ is not None
NameError: 'str' object has no attribute '__cause__'
11:25:16 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:25:16 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:32:09 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:32:09 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:32:10 [INF][     SSH tunnel]: Existing SSH tunnel not found, opening new one
11:32:10 [INF][     SSH tunnel]: Opening SSH tunnel to 18.140.1.174:22
11:32:10 [INF][      SSHCommon]: libssh: ssh_connect ssh_connect: libssh 0.9.6 (c) 2003-2021 Aris Adamantiadis, Andreas Schneider and libssh contributors. Distributed under the LGPL, please refer to COPYING file for information about your rights, using threading threads_stdthread
11:32:10 [INF][      SSHCommon]: libssh: ssh_socket_connect ssh_socket_connect: Nonblocking connection socket: 30
11:32:10 [INF][      SSHCommon]: libssh: ssh_connect ssh_connect: Socket connecting, now waiting for the callbacks to work
11:32:11 [INF][      SSHCommon]: libssh: ssh_client_connection_callback ssh_client_connection_callback: SSH server banner: SSH-2.0-OpenSSH_7.4
11:32:11 [INF][      SSHCommon]: libssh: ssh_analyze_banner ssh_analyze_banner: Analyzing banner: SSH-2.0-OpenSSH_7.4
11:32:11 [INF][      SSHCommon]: libssh: ssh_analyze_banner ssh_analyze_banner: We are talking to an OpenSSH client version: 7.4 (70400)
11:32:11 [INF][      SSHCommon]: libssh: ssh_kex_select_methods ssh_kex_select_methods: Negotiated curve25519-sha256,ssh-ed25519,aes256-gcm@openssh.com,aes256-gcm@openssh.com,aead-gcm,aead-gcm,none,none,,
11:32:11 [INF][      SSHCommon]: libssh: ssh_init_rekey_state ssh_init_rekey_state: Set rekey after 4294967296 blocks
11:32:11 [INF][      SSHCommon]: libssh: ssh_init_rekey_state ssh_init_rekey_state: Set rekey after 4294967296 blocks
11:32:11 [INF][      SSHCommon]: libssh: ssh_packet_client_curve25519_reply ssh_packet_client_curve25519_reply: SSH_MSG_NEWKEYS sent
11:32:11 [INF][      SSHCommon]: libssh: ssh_packet_newkeys ssh_packet_newkeys: Received SSH_MSG_NEWKEYS
11:32:11 [INF][      SSHCommon]: libssh: ssh_packet_newkeys ssh_packet_newkeys: Signature verified and valid
11:32:11 [INF][      SSHCommon]: libssh: ssh_packet_userauth_failure ssh_packet_userauth_failure: Access denied for 'none'. Authentication that can continue: publickey
11:32:11 [INF][     SSHSession]: Banner: 
11:32:11 [INF][      SSHCommon]: libssh: ssh_pki_import_privkey_base64 ssh_pki_import_privkey_base64: Trying to decode privkey passphrase=true
11:32:11 [INF][      SSHCommon]: libssh: ssh_pki_openssh_import ssh_pki_openssh_import: Opening OpenSSH private key: ciphername: none, kdf: none, nkeys: 1
11:32:11 [INF][     SSH tunnel]: SSH tunnel opened on port: 40087
11:32:13 [INF][SQL Editor Form]: Opened connection 'Eagle PROD' to managed by https://aws.amazon.com/rds/ version 10.5.12-MariaDB-log
11:32:14 [ERR][      WBContext]: Unsupported server version: managed by https://aws.amazon.com/rds/ 10.5.12-MariaDB-log
11:32:34 [WRN][         mforms]: Resource file not found: migration_win.png
11:32:34 [WRN][            grt]: in com.mysql.rdbms.sql92.driver.odbc_dsn: unserialized XML contains invalid member db.mgmt.PythonDBAPIDriver::accessibilityNameLoaded 0/0 new non-MySQL connections
11:32:34 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
11:32:34 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
11:32:34 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
11:32:34 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
11:32:34 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
11:32:34 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
11:32:34 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
11:32:34 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
11:32:34 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
11:32:34 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
11:32:34 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
11:32:34 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
11:32:34 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
11:32:34 [WRN][         mforms]: Resource file not found: migration_check_open_win.png
11:32:37 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
11:33:14 [WRN][         mforms]: Resource file not found: migration_check_done_win.png
11:33:14 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
11:33:25 [WRN][         mforms]: Resource file not found: migration_check_done_win.png
11:33:25 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
11:33:25 [INF][         Wizard]: Execute 'Connect to source DBMS'
11:33:25 [INF][            grt]: Connecting to Mysql@ccdprdmallappdb.c0tnf5rrz5yw.ap-southeast-1.rds.amazonaws.com:3306@18.140.1.174...	
11:33:25 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:33:25 [INF][            grt]: Connecting to Mysql@ccdprdmallappdb.c0tnf5rrz5yw.ap-southeast-1.rds.amazonaws.com:3306@18.140.1.174...	
11:33:25 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:33:26 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:33:26 [INF][            grt]: Connected to Mysql@ccdprdmallappdb.c0tnf5rrz5yw.ap-southeast-1.rds.amazonaws.com:3306@18.140.1.174, 10.5.12-MariaDB-log	
11:33:26 [INF][         Wizard]: Execute 'Check target DBMS connection'
11:33:26 [INF][            grt]: Connecting to Mysql@eagledb.cnkngvzefonw.ap-southeast-1.rds.amazonaws.com:3306@54.255.224.94...	
11:33:26 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:33:26 [INF][            grt]: Connecting to Mysql@eagledb.cnkngvzefonw.ap-southeast-1.rds.amazonaws.com:3306@54.255.224.94...	
11:33:26 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:33:27 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:33:27 [INF][            grt]: Connected	
11:33:27 [INF][         Wizard]: Starting thread for 'Retrieve schema list from source'
11:33:27 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:33:34 [WRN][         mforms]: Resource file not found: migration_check_done_win.png
11:33:34 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
11:33:55 [WRN][         mforms]: Resource file not found: migration_check_done_win.png
11:33:55 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
11:33:55 [INF][         Wizard]: Execute 'Connect to source DBMS'
11:33:55 [INF][            grt]: Connecting to Mysql@ccdprdmallappdb.c0tnf5rrz5yw.ap-southeast-1.rds.amazonaws.com:3306@18.140.1.174...	
11:33:55 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:33:55 [INF][            grt]: Connected to Mysql@ccdprdmallappdb.c0tnf5rrz5yw.ap-southeast-1.rds.amazonaws.com:3306@18.140.1.174, 10.5.12-MariaDB-log	
11:33:55 [INF][         Wizard]: Starting thread for 'Reverse engineer selected schemas'
11:33:55 [INF][            grt]: Reverse engineering ccdprdmallappdb1 from def	
11:33:56 [INF][            grt]: Reverse engineering tables from ccdprdmallappdb1	
11:33:59 [INF][            grt]: Reverse engineering triggers from ccdprdmallappdb1	
11:33:59 [INF][            grt]: Reverse engineering stored procedures from ccdprdmallappdb1	
11:33:59 [INF][            grt]: Reverse engineering functions from ccdprdmallappdb1	
11:33:59 [INF][         Wizard]: Execute 'Post-processing of reverse engineered schemas'
11:34:02 [WRN][         mforms]: Resource file not found: migration_check_done_win.png
11:34:02 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
11:34:07 [WRN][         mforms]: Resource file not found: migration_check_done_win.png
11:34:07 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
11:34:07 [INF][         Wizard]: Starting thread for 'Migrate Selected Objects'
11:34:08 [INF][         Wizard]: Starting thread for 'Generate SQL CREATE Statements'
11:34:13 [WRN][         mforms]: Resource file not found: migration_check_done_win.png
11:34:13 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
11:34:13 [WRN][   mforms.linux]: Unknown column storage type[20]
11:34:13 [WRN][   mforms.linux]: Unknown column storage type[20]
11:34:13 [WRN][   mforms.linux]: Unknown column storage type[20]
11:34:44 [WRN][         mforms]: Resource file not found: migration_check_done_win.png
11:34:44 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
11:35:10 [WRN][         mforms]: Resource file not found: migration_check_done_win.png
11:35:10 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
11:35:10 [INF][         Wizard]: Execute 'Connect to Target Database'
11:35:10 [INF][         Wizard]: Execute 'Perform Checks in Target'
11:35:10 [INF][         Wizard]: Starting thread for 'Create Schemas and Objects'
11:35:10 [INF][            grt]: Execute statement	SET FOREIGN_KEY_CHECKS = 0
11:35:10 [INF][            grt]: Execute statement	CREATE SCHEMA IF NOT EXISTS `ccdprdmallappdb1` 
11:35:10 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`app_logo` (
  `id` VARCHAR(36) NOT NULL,
  `name` VARCHAR(128) NOT NULL,
  `value` VARCHAR(128) NOT NULL,
  `imageUrl` VARCHAR(255) NOT NULL,
  `default` TINYINT(4) NOT NULL DEFAULT 0,
  `activationDate` DATETIME NULL DEFAULT NULL,
  `deactivationDate` DATETIME NULL DEFAULT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:10 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`app_version` (
  `id` VARCHAR(36) NOT NULL,
  `version` VARCHAR(255) NOT NULL,
  `platform` SET('Ios', 'Android') NOT NULL,
  `message` VARCHAR(255) NOT NULL,
  `isForced` TINYINT(4) NOT NULL DEFAULT 1,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE INDEX `IDX_c570aedd3131b74fd3ca74b5e6` (`version` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:10 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`app_voucher_status` (
  `id` VARCHAR(36) NOT NULL,
  `name` VARCHAR(128) NOT NULL,
  `status` TINYINT(4) NOT NULL DEFAULT 0,
  `label` VARCHAR(128) NOT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:10 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`audit_trail` (
  `id` VARCHAR(36) NOT NULL,
  `userType` VARCHAR(255) NOT NULL,
  `rmallsFeature` VARCHAR(255) NOT NULL,
  `email` VARCHAR(255) NULL DEFAULT NULL,
  `firstName` VARCHAR(255) NOT NULL,
  `lastName` VARCHAR(255) NOT NULL,
  `action` VARCHAR(255) NOT NULL,
  `oldValue` LONGTEXT NULL DEFAULT NULL,
  `newValue` LONGTEXT NULL DEFAULT NULL,
  `searchResult` LONGTEXT NULL DEFAULT NULL,
  `membershipNumber` VARCHAR(255) NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:10 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`back_office_user` (
  `id` VARCHAR(36) NOT NULL,
  `user_id` VARCHAR(255) NULL DEFAULT NULL,
  `email` VARCHAR(255) NULL DEFAULT NULL,
  `picture` VARCHAR(255) NULL DEFAULT NULL,
  `given_name` VARCHAR(255) NULL DEFAULT NULL,
  `family_name` VARCHAR(255) NULL DEFAULT NULL,
  `middle_name` VARCHAR(255) NULL DEFAULT NULL,
  `suffix` VARCHAR(255) NULL DEFAULT NULL,
  `verification_secret` VARCHAR(255) NULL DEFAULT NULL,
  `status` ENUM('active', 'inactive', 'pending') NULL DEFAULT 'pending',
  `verification_token` VARCHAR(255) NULL DEFAULT NULL,
  `verification_send_date` DATETIME NULL DEFAULT NULL,
  `created_at` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updated_at` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `created_by_id` VARCHAR(255) NULL DEFAULT NULL,
  `role` ENUM('admin', 'super_admin') NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `IDX_eec381383d69639cc37a123888` (`email` ASC) VISIBLE,
  INDEX `user_id` (`user_id` ASC) VISIBLE,
  INDEX `FK_9b76488c82478f2ad5f6bd31ce3` (`created_by_id` ASC) VISIBLE,
  CONSTRAINT `FK_9b76488c82478f2ad5f6bd31ce3`
    FOREIGN KEY (`created_by_id`)
    REFERENCES `ccdprdmallappdb1`.`back_office_user` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:10 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`check_in` (
  `id` VARCHAR(36) NOT NULL,
  `name` VARCHAR(128) NOT NULL,
  `status` TINYINT(4) NOT NULL DEFAULT 0,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:10 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`cities` (
  `id` INT(11) NOT NULL,
  `psgcCode` VARCHAR(255) NOT NULL,
  `citymunDesc` VARCHAR(255) NOT NULL,
  `provCode` VARCHAR(255) NOT NULL,
  `citymunCode` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`citymunCode`),
  INDEX `FK_1e58a3b250f2d9170c04dbe7a87` (`provCode` ASC) VISIBLE,
  CONSTRAINT `FK_1e58a3b250f2d9170c04dbe7a87`
    FOREIGN KEY (`provCode`)
    REFERENCES `ccdprdmallappdb1`.`provinces` (`provCode`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:10 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`csat` (
  `id` VARCHAR(36) NOT NULL,
  `rating` INT(11) NULL DEFAULT NULL,
  `feedback` VARCHAR(255) NULL DEFAULT NULL,
  `customerUserId` VARCHAR(255) NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  INDEX `FK_16f1bfab047f007ec0051352813` (`customerUserId` ASC) VISIBLE,
  CONSTRAINT `FK_16f1bfab047f007ec0051352813`
    FOREIGN KEY (`customerUserId`)
    REFERENCES `ccdprdmallappdb1`.`customer` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`customer` (
  `id` VARCHAR(36) NOT NULL,
  `user_id` VARCHAR(255) NULL DEFAULT NULL,
  `email` VARCHAR(255) NULL DEFAULT NULL,
  `name` VARCHAR(255) NULL DEFAULT NULL,
  `nickname` VARCHAR(255) NULL DEFAULT NULL,
  `given_name` VARCHAR(255) NULL DEFAULT NULL,
  `family_name` VARCHAR(255) NULL DEFAULT NULL,
  `gender` VARCHAR(255) NULL DEFAULT NULL,
  `birthday` VARCHAR(255) NULL DEFAULT NULL,
  `mobile_number_prefix` VARCHAR(255) NULL DEFAULT NULL,
  `mobile_number` VARCHAR(255) NULL DEFAULT NULL,
  `province` VARCHAR(255) NULL DEFAULT NULL,
  `city` VARCHAR(255) NULL DEFAULT NULL,
  `referral_code` VARCHAR(255) NULL DEFAULT NULL,
  `my_referral_code` VARCHAR(255) NULL DEFAULT NULL,
  `preferences` SET('Health & Wellness', 'Government Services', 'Entertainment', 'Dining', 'Kids', 'Sports & Fitness', 'Fashion', 'Home & Living', 'Services', 'Gadgets & Connectivity', 'Pets', 'Groceries', 'Movies', 'Parking', 'Hobbies') NULL DEFAULT NULL,
  `check_in` TEXT NULL DEFAULT NULL,
  `role` VARCHAR(255) NULL DEFAULT NULL,
  `status` VARCHAR(255) NULL DEFAULT NULL,
  `last_confirmation_code` VARCHAR(255) NULL DEFAULT NULL,
  `confirmation_code` INT(11) NULL DEFAULT NULL,
  `activeBiometrics` TINYINT(4) NOT NULL DEFAULT 0,
  `created_at` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updated_at` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `picture` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `user_id` (`user_id` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`customer_movie_world_booking_inquiry` (
  `id` VARCHAR(36) NOT NULL,
  `fullName` VARCHAR(255) NOT NULL,
  `mobileNumber` VARCHAR(255) NOT NULL,
  `email` VARCHAR(255) NOT NULL,
  `mallName` VARCHAR(255) NOT NULL,
  `inquiryType` VARCHAR(255) NOT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`customer_movie_world_ticket` (
  `id` VARCHAR(36) NOT NULL,
  `referenceId` VARCHAR(255) NOT NULL,
  `movieImage` VARCHAR(255) NULL DEFAULT NULL,
  `movieName` VARCHAR(255) NOT NULL,
  `date` VARCHAR(255) NOT NULL,
  `time` VARCHAR(255) NOT NULL,
  `seat` VARCHAR(255) NULL DEFAULT NULL,
  `price` INT(11) NULL DEFAULT NULL,
  `branchName` VARCHAR(255) NOT NULL,
  `cinema` VARCHAR(255) NOT NULL,
  `seatType` VARCHAR(255) NOT NULL,
  `customerName` VARCHAR(255) NOT NULL,
  `receiptId` VARCHAR(255) NOT NULL,
  `snacks` TEXT NULL DEFAULT NULL,
  `hasSnacks` TINYINT(4) NOT NULL DEFAULT 0,
  `snacksClaimed` TINYINT(4) NOT NULL DEFAULT 0,
  `transactionReference` VARCHAR(255) NOT NULL,
  `customerId` VARCHAR(255) NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `customerUserId` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_4e2bc1f7aa66ddc746fa7532ed4` (`customerUserId` ASC) VISIBLE,
  CONSTRAINT `FK_4e2bc1f7aa66ddc746fa7532ed4`
    FOREIGN KEY (`customerUserId`)
    REFERENCES `ccdprdmallappdb1`.`customer` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`customer_notification` (
  `id` VARCHAR(36) NOT NULL,
  `seen` TINYINT(4) NOT NULL DEFAULT 0,
  `read` TINYINT(4) NOT NULL DEFAULT 0,
  `notificationId` VARCHAR(255) NULL DEFAULT NULL,
  `snapAndWinEntryNotification` TEXT NULL DEFAULT NULL,
  `isSnapAndWin` TINYINT(4) NOT NULL DEFAULT 0,
  `customerId` VARCHAR(255) NOT NULL,
  `created_at` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  INDEX `FK_d5102582812579ae8035baf2d3c` (`notificationId` ASC) VISIBLE,
  INDEX `idx_customer_notification_customerId` (`customerId` ASC) VISIBLE,
  CONSTRAINT `FK_d5102582812579ae8035baf2d3c`
    FOREIGN KEY (`notificationId`)
    REFERENCES `ccdprdmallappdb1`.`notification` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`customer_referrals_customer` (
  `customerId_1` VARCHAR(36) NOT NULL,
  `customerId_2` VARCHAR(36) NOT NULL,
  PRIMARY KEY (`customerId_1`, `customerId_2`),
  INDEX `IDX_e2d5e51ecd9b52c6706628dcf8` (`customerId_1` ASC) VISIBLE,
  INDEX `IDX_85cc00859fa1bc96a1c08ea1a2` (`customerId_2` ASC) VISIBLE,
  CONSTRAINT `FK_85cc00859fa1bc96a1c08ea1a21`
    FOREIGN KEY (`customerId_2`)
    REFERENCES `ccdprdmallappdb1`.`customer` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_e2d5e51ecd9b52c6706628dcf84`
    FOREIGN KEY (`customerId_1`)
    REFERENCES `ccdprdmallappdb1`.`customer` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`customer_used_voucher` (
  `id` VARCHAR(36) NOT NULL,
  `customerVoucherId` VARCHAR(255) NOT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  INDEX `idx_customer_used_voucher_customerVoucherId` (`customerVoucherId` ASC) VISIBLE,
  CONSTRAINT `FK_893cb4355d5c405c818d5e91043`
    FOREIGN KEY (`customerVoucherId`)
    REFERENCES `ccdprdmallappdb1`.`customer_voucher` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`customer_voucher` (
  `id` VARCHAR(36) NOT NULL,
  `voucherId` VARCHAR(255) NOT NULL,
  `customerId` VARCHAR(255) NOT NULL,
  `voucherCount` INT(11) NULL DEFAULT NULL,
  `status` ENUM('Available', 'Expired', 'Limit') NULL DEFAULT 'Available',
  `validityEndDate` DATETIME NOT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  INDEX `FK_cd7d2f5f365f9c202ebea88f454` (`voucherId` ASC) VISIBLE,
  INDEX `idx_customer_voucher_customerId` (`customerId` ASC) VISIBLE,
  CONSTRAINT `FK_cd7d2f5f365f9c202ebea88f454`
    FOREIGN KEY (`voucherId`)
    REFERENCES `ccdprdmallappdb1`.`voucher` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`dashboard_tile` (
  `id` VARCHAR(36) NOT NULL,
  `title` VARCHAR(50) NOT NULL,
  `order` INT(11) NULL DEFAULT NULL,
  `imageUrl` VARCHAR(255) NOT NULL,
  `link` VARCHAR(255) NULL DEFAULT NULL,
  `value` VARCHAR(128) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`device` (
  `id` VARCHAR(36) NOT NULL,
  `customerUserId` VARCHAR(255) NULL DEFAULT NULL,
  `deviceId` VARCHAR(255) NOT NULL,
  `notificationToken` VARCHAR(255) NOT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  INDEX `idx_device_customerUserId` (`customerUserId` ASC) VISIBLE,
  INDEX `idx_device_deviceId` (`deviceId` ASC) VISIBLE,
  CONSTRAINT `FK_737bb5c89eebf4e38534fedfb7f`
    FOREIGN KEY (`customerUserId`)
    REFERENCES `ccdprdmallappdb1`.`customer` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`event_promotion` (
  `id` VARCHAR(36) NOT NULL,
  `text` VARCHAR(255) NOT NULL,
  `imageUrl` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`faqs` (
  `id` VARCHAR(36) NOT NULL,
  `label` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`faqs_category` (
  `id` VARCHAR(36) NOT NULL,
  `category` VARCHAR(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_bin' NOT NULL,
  `order` INT(11) NOT NULL,
  `faqsId` VARCHAR(36) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_2c1ef35c582eadaa0e32ad1bec0` (`faqsId` ASC) VISIBLE,
  CONSTRAINT `FK_2c1ef35c582eadaa0e32ad1bec0`
    FOREIGN KEY (`faqsId`)
    REFERENCES `ccdprdmallappdb1`.`faqs` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`faqs_questions_answers` (
  `id` VARCHAR(36) NOT NULL,
  `question` VARCHAR(550) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_bin' NOT NULL,
  `order` INT(11) NOT NULL,
  `answer` VARCHAR(550) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_bin' NOT NULL,
  `answerPlainText` VARCHAR(550) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_bin' NOT NULL,
  `faqsCategoryId` VARCHAR(36) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_9bfd1d8bbe8c7c2489130e9da15` (`faqsCategoryId` ASC) VISIBLE,
  CONSTRAINT `FK_9bfd1d8bbe8c7c2489130e9da15`
    FOREIGN KEY (`faqsCategoryId`)
    REFERENCES `ccdprdmallappdb1`.`faqs_category` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`featured_store` (
  `id` VARCHAR(36) NOT NULL,
  `store_id` INT(11) NULL DEFAULT NULL,
  `publishDate` DATETIME NOT NULL,
  `unpublishDate` DATETIME NOT NULL,
  `featuredIcon` VARCHAR(255) NOT NULL,
  `duration` INT(11) NULL DEFAULT NULL,
  `status` VARCHAR(255) NOT NULL,
  `uploads` TEXT NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `back_office_user_id` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_7bb6ff727b19aea9d74ac7b50d4` (`back_office_user_id` ASC) VISIBLE,
  INDEX `FK_12c05bdc6a4c6d31f96c3f33f94` (`store_id` ASC) VISIBLE,
  CONSTRAINT `FK_12c05bdc6a4c6d31f96c3f33f94`
    FOREIGN KEY (`store_id`)
    REFERENCES `ccdprdmallappdb1`.`store` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_7bb6ff727b19aea9d74ac7b50d4`
    FOREIGN KEY (`back_office_user_id`)
    REFERENCES `ccdprdmallappdb1`.`back_office_user` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`highlights` (
  `id` VARCHAR(36) NOT NULL,
  `title` VARCHAR(100) NOT NULL,
  `subtitle` VARCHAR(100) NOT NULL,
  `publishDate` DATETIME NOT NULL,
  `unpublishDate` DATETIME NOT NULL,
  `startDate` DATETIME NULL DEFAULT NULL,
  `endDate` DATETIME NULL DEFAULT NULL,
  `imageUrl` VARCHAR(255) NULL DEFAULT NULL,
  `link` VARCHAR(255) NULL DEFAULT NULL,
  `enabledLink` TINYINT(4) NOT NULL DEFAULT 0,
  `status` VARCHAR(255) NOT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `back_office_user_id` VARCHAR(255) NULL DEFAULT NULL,
  `category` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_2e712c61eac4dace4decb8e1117` (`back_office_user_id` ASC) VISIBLE,
  CONSTRAINT `FK_2e712c61eac4dace4decb8e1117`
    FOREIGN KEY (`back_office_user_id`)
    REFERENCES `ccdprdmallappdb1`.`back_office_user` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`highlights_template` (
  `id` VARCHAR(36) NOT NULL,
  `highlightsId` VARCHAR(36) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_423a454354e95c4dd6355f1b064` (`highlightsId` ASC) VISIBLE,
  CONSTRAINT `FK_423a454354e95c4dd6355f1b064`
    FOREIGN KEY (`highlightsId`)
    REFERENCES `ccdprdmallappdb1`.`highlights` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`highlights_template_collection` (
  `id` VARCHAR(36) NOT NULL,
  `type` VARCHAR(255) NOT NULL,
  `order` INT(11) NOT NULL,
  `templateId` VARCHAR(36) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_2d57eaa59a3e30767d2669c6907` (`templateId` ASC) VISIBLE,
  CONSTRAINT `FK_2d57eaa59a3e30767d2669c6907`
    FOREIGN KEY (`templateId`)
    REFERENCES `ccdprdmallappdb1`.`highlights_template` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`highlights_template_fields` (
  `id` VARCHAR(36) NOT NULL,
  `name` VARCHAR(128) NOT NULL,
  `value` VARCHAR(10000) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_bin' NOT NULL,
  `templateId` VARCHAR(36) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_ee606d5421468380c5ba65c23d9` (`templateId` ASC) VISIBLE,
  CONSTRAINT `FK_ee606d5421468380c5ba65c23d9`
    FOREIGN KEY (`templateId`)
    REFERENCES `ccdprdmallappdb1`.`highlights_template_collection` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`home` (
  `id` VARCHAR(36) NOT NULL,
  `title` VARCHAR(100) NOT NULL,
  `subtitle` VARCHAR(100) NOT NULL,
  `publishDate` DATETIME NOT NULL,
  `unpublishDate` DATETIME NOT NULL,
  `startDate` DATETIME NULL DEFAULT NULL,
  `endDate` DATETIME NULL DEFAULT NULL,
  `imageUrl` VARCHAR(255) NOT NULL,
  `link` VARCHAR(255) NULL DEFAULT NULL,
  `enabledLink` TINYINT(4) NOT NULL DEFAULT 0,
  `category` VARCHAR(255) NOT NULL,
  `status` VARCHAR(255) NOT NULL,
  `mallIds` TEXT NULL DEFAULT NULL,
  `homeDashboard` TINYINT(4) NULL DEFAULT NULL,
  `mallDashboard` TINYINT(4) NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` DATETIME(6) NULL DEFAULT NULL,
  `back_office_user_id` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_dabc3a5de75d2a4d9473828b2d5` (`back_office_user_id` ASC) VISIBLE,
  CONSTRAINT `FK_dabc3a5de75d2a4d9473828b2d5`
    FOREIGN KEY (`back_office_user_id`)
    REFERENCES `ccdprdmallappdb1`.`back_office_user` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`home_management_template` (
  `id` VARCHAR(36) NOT NULL,
  `homeId` VARCHAR(36) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_70f3ce7b0065b5fa93b4e17ba79` (`homeId` ASC) VISIBLE,
  CONSTRAINT `FK_70f3ce7b0065b5fa93b4e17ba79`
    FOREIGN KEY (`homeId`)
    REFERENCES `ccdprdmallappdb1`.`home` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:11 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`home_management_template_collection` (
  `id` VARCHAR(36) NOT NULL,
  `type` VARCHAR(255) NOT NULL,
  `order` INT(11) NOT NULL,
  `templateId` VARCHAR(36) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_9ff026ce637a233e35369195da4` (`templateId` ASC) VISIBLE,
  CONSTRAINT `FK_9ff026ce637a233e35369195da4`
    FOREIGN KEY (`templateId`)
    REFERENCES `ccdprdmallappdb1`.`home_management_template` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`home_management_template_fields` (
  `id` VARCHAR(36) NOT NULL,
  `name` VARCHAR(128) NOT NULL,
  `value` VARCHAR(10000) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_bin' NOT NULL,
  `templateId` VARCHAR(36) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_7a22f47bd896ac9300851609946` (`templateId` ASC) VISIBLE,
  CONSTRAINT `FK_7a22f47bd896ac9300851609946`
    FOREIGN KEY (`templateId`)
    REFERENCES `ccdprdmallappdb1`.`home_management_template_collection` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`job_scheduler` (
  `name` VARCHAR(255) NOT NULL,
  `pattern` VARCHAR(255) NOT NULL,
  `schedule` DATETIME NOT NULL,
  `data` TEXT NULL DEFAULT NULL,
  `errorLog` LONGTEXT NULL DEFAULT NULL,
  `status` ENUM('Done', 'Pending', 'Error') NOT NULL DEFAULT 'Pending',
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`name`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`lingkod_pinoy` (
  `id` VARCHAR(36) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `imageUrl` VARCHAR(255) NOT NULL,
  `order` INT(11) NOT NULL,
  `mallStoreIds` TEXT NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `back_office_user_id` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_016468c81acacdffb988bda1cc4` (`back_office_user_id` ASC) VISIBLE,
  CONSTRAINT `FK_016468c81acacdffb988bda1cc4`
    FOREIGN KEY (`back_office_user_id`)
    REFERENCES `ccdprdmallappdb1`.`back_office_user` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`lingkod_pinoy_background` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `imageUrl` VARCHAR(255) NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`))
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`mall` (
  `id` VARCHAR(36) NOT NULL,
  `mallIdString` VARCHAR(255) NOT NULL,
  `name` VARCHAR(80) NOT NULL,
  `region` ENUM('Metro Manila', 'North Luzon', 'South Luzon', 'Visayas', 'Mindanao') NULL DEFAULT NULL,
  `address` VARCHAR(500) NOT NULL,
  `vmdLink` VARCHAR(255) NULL DEFAULT NULL,
  `imageUrl` VARCHAR(255) NULL DEFAULT NULL,
  `description` LONGTEXT NULL DEFAULT NULL,
  `contactDetails` VARCHAR(100) NULL DEFAULT NULL,
  `latitude` DECIMAL(8,6) NOT NULL,
  `longitude` DECIMAL(9,6) NOT NULL,
  `informationBadge` TEXT NULL DEFAULT NULL,
  `mallHours` TEXT NULL DEFAULT NULL,
  `superMarketHours` TEXT NULL DEFAULT NULL,
  `socialMediaLinks` TEXT NULL DEFAULT NULL,
  `personalShopper` TEXT NULL DEFAULT NULL,
  `reminders` VARCHAR(500) NULL DEFAULT NULL,
  `mallProfile` TEXT NULL DEFAULT NULL,
  `status` ENUM('Active', 'Inactive', 'Draft', 'Deleted') NULL DEFAULT 'Draft',
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `back_office_user_id` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_5dc56f96acc2e0de8cc599dc5d3` (`back_office_user_id` ASC) VISIBLE,
  CONSTRAINT `FK_5dc56f96acc2e0de8cc599dc5d3`
    FOREIGN KEY (`back_office_user_id`)
    REFERENCES `ccdprdmallappdb1`.`back_office_user` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`mall_happenings` (
  `home` VARCHAR(36) NOT NULL,
  `mall` VARCHAR(36) NOT NULL,
  PRIMARY KEY (`home`, `mall`),
  INDEX `IDX_93d321f2fc80c35bec92d921b7` (`home` ASC) VISIBLE,
  INDEX `IDX_baf0672d4d9205fde0be9ff7f4` (`mall` ASC) VISIBLE,
  CONSTRAINT `FK_93d321f2fc80c35bec92d921b7d`
    FOREIGN KEY (`home`)
    REFERENCES `ccdprdmallappdb1`.`home` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_baf0672d4d9205fde0be9ff7f4e`
    FOREIGN KEY (`mall`)
    REFERENCES `ccdprdmallappdb1`.`mall` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`mall_shop_for_me` (
  `shop_for_me` VARCHAR(36) NOT NULL,
  `mall` VARCHAR(36) NOT NULL,
  PRIMARY KEY (`shop_for_me`, `mall`),
  INDEX `IDX_1a2111ab4b75782fae990cfee8` (`shop_for_me` ASC) VISIBLE,
  INDEX `IDX_ecc43941fc0c8c67fd2154a8b0` (`mall` ASC) VISIBLE,
  CONSTRAINT `FK_1a2111ab4b75782fae990cfee80`
    FOREIGN KEY (`shop_for_me`)
    REFERENCES `ccdprdmallappdb1`.`shop_for_me` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_ecc43941fc0c8c67fd2154a8b03`
    FOREIGN KEY (`mall`)
    REFERENCES `ccdprdmallappdb1`.`mall` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`mall_store` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `mallId` VARCHAR(255) NOT NULL,
  `mallStoreHours` TEXT NULL DEFAULT NULL,
  `storeId` INT(11) NOT NULL,
  `location` VARCHAR(255) NULL DEFAULT NULL,
  `services` TEXT NULL DEFAULT NULL,
  `otherInformation` VARCHAR(255) NULL DEFAULT NULL,
  `contactNumbers` TEXT NULL DEFAULT NULL,
  `additionalContacts` TEXT NULL DEFAULT NULL,
  `heroBannerUrl` VARCHAR(255) NULL DEFAULT NULL,
  `mallStorePhotoUrls` TEXT NULL DEFAULT NULL,
  `mallStoreLogoUrl` VARCHAR(255) NULL DEFAULT NULL,
  `categoryTabId` VARCHAR(255) NULL DEFAULT NULL,
  `back_office_user_id` VARCHAR(255) NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `buttonName` VARCHAR(255) NULL DEFAULT NULL,
  `buttonLink` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_1121247c92fe4947d93a6b915a8` (`mallId` ASC) VISIBLE,
  INDEX `FK_28606df8c7cbe0a403bb0a7bc65` (`storeId` ASC) VISIBLE,
  INDEX `FK_d146eb6678710a943e1725a22ff` (`back_office_user_id` ASC) VISIBLE,
  CONSTRAINT `FK_1121247c92fe4947d93a6b915a8`
    FOREIGN KEY (`mallId`)
    REFERENCES `ccdprdmallappdb1`.`mall` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_28606df8c7cbe0a403bb0a7bc65`
    FOREIGN KEY (`storeId`)
    REFERENCES `ccdprdmallappdb1`.`store` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_d146eb6678710a943e1725a22ff`
    FOREIGN KEY (`back_office_user_id`)
    REFERENCES `ccdprdmallappdb1`.`back_office_user` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 12082
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`mall_store_categories` (
  `mall_store` INT(11) NOT NULL,
  `store_category` INT(11) NOT NULL,
  PRIMARY KEY (`mall_store`, `store_category`),
  INDEX `IDX_6dc0f4f9746e818f24c1cdebf6` (`mall_store` ASC) VISIBLE,
  INDEX `IDX_49da5a271ec7ed949980a1098b` (`store_category` ASC) VISIBLE,
  CONSTRAINT `FK_49da5a271ec7ed949980a1098b7`
    FOREIGN KEY (`store_category`)
    REFERENCES `ccdprdmallappdb1`.`store_category` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_6dc0f4f9746e818f24c1cdebf66`
    FOREIGN KEY (`mall_store`)
    REFERENCES `ccdprdmallappdb1`.`mall_store` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`mall_store_category_tab` (
  `id` VARCHAR(36) NOT NULL,
  `name` VARCHAR(255) NULL DEFAULT NULL,
  `order` INT(11) NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`mall_store_lingkod_pinoy` (
  `lingkod_pinoy` VARCHAR(36) NOT NULL,
  `mall_store` INT(11) NOT NULL,
  PRIMARY KEY (`lingkod_pinoy`, `mall_store`),
  INDEX `IDX_07289e129d206cccc7eaeda9a8` (`lingkod_pinoy` ASC) VISIBLE,
  INDEX `IDX_25b4f2d14be33db17395184640` (`mall_store` ASC) VISIBLE,
  CONSTRAINT `FK_07289e129d206cccc7eaeda9a84`
    FOREIGN KEY (`lingkod_pinoy`)
    REFERENCES `ccdprdmallappdb1`.`lingkod_pinoy` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_25b4f2d14be33db173951846407`
    FOREIGN KEY (`mall_store`)
    REFERENCES `ccdprdmallappdb1`.`mall_store` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`mall_vouchers` (
  `voucher` VARCHAR(36) NOT NULL,
  `mall` VARCHAR(36) NOT NULL,
  PRIMARY KEY (`voucher`, `mall`),
  INDEX `IDX_b25efb9d402f432c60a0f77dd2` (`voucher` ASC) VISIBLE,
  INDEX `IDX_e3e1fcf9f41e1a767a6e609f7a` (`mall` ASC) VISIBLE,
  CONSTRAINT `FK_b25efb9d402f432c60a0f77dd20`
    FOREIGN KEY (`voucher`)
    REFERENCES `ccdprdmallappdb1`.`voucher` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_e3e1fcf9f41e1a767a6e609f7a1`
    FOREIGN KEY (`mall`)
    REFERENCES `ccdprdmallappdb1`.`mall` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`movie_world_booking_inquiry_form` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `imageUrl` VARCHAR(255) NOT NULL,
  `headerSubtitle` VARCHAR(255) NOT NULL,
  `branches` TEXT NOT NULL,
  `inquiries` TEXT NOT NULL,
  `emails` TEXT NOT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`))
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`my_saved_mall` (
  `id` VARCHAR(36) NOT NULL,
  `mallId` VARCHAR(255) NULL DEFAULT NULL,
  `customerUserId` VARCHAR(255) NULL DEFAULT NULL,
  `favoriteR` TINYINT(4) NOT NULL DEFAULT 0,
  `saved` TINYINT(4) NOT NULL DEFAULT 0,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`notification` (
  `id` VARCHAR(36) NOT NULL,
  `title` VARCHAR(128) NOT NULL,
  `delivery` VARCHAR(255) NOT NULL,
  `publishDate` DATETIME NOT NULL,
  `category` VARCHAR(255) NOT NULL,
  `status` VARCHAR(255) NOT NULL,
  `interestCircle` SET('Health & Wellness', 'Government Services', 'Entertainment', 'Dining', 'Kids', 'Sports & Fitness', 'Fashion', 'Home & Living', 'Services', 'Gadgets & Connectivity', 'Pets', 'Groceries', 'Movies', 'Parking', 'Hobbies') NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `back_office_user_id` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_b6b92c8f08502a989198d5929ae` (`back_office_user_id` ASC) VISIBLE,
  CONSTRAINT `FK_b6b92c8f08502a989198d5929ae`
    FOREIGN KEY (`back_office_user_id`)
    REFERENCES `ccdprdmallappdb1`.`back_office_user` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`otp_logs` (
  `id` VARCHAR(36) NOT NULL,
  `user_id` VARCHAR(255) NULL DEFAULT NULL,
  `email` VARCHAR(255) NULL DEFAULT NULL,
  `given_name` VARCHAR(255) NULL DEFAULT NULL,
  `code` VARCHAR(255) NULL DEFAULT NULL,
  `method` SET('EMAIL', 'SMS') NULL DEFAULT NULL,
  `status` SET('VERIFIED', 'PENDING') NULL DEFAULT NULL,
  `type` SET('REGISTER', 'RESET_PASSWORD', 'CHANGE_EMAIL', 'CHANGE_PASSWORD', 'RESET_PASSWORD_LINK') NULL DEFAULT NULL,
  `count` INT(11) NULL DEFAULT NULL,
  `created_at` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `expires_in` DATETIME NULL DEFAULT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`otp_method` (
  `id` VARCHAR(36) NOT NULL,
  `method` VARCHAR(128) NOT NULL,
  `status` TINYINT(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`promo` (
  `id` VARCHAR(36) NOT NULL,
  `title` VARCHAR(100) NOT NULL,
  `imageUrl` VARCHAR(255) NOT NULL,
  `body` VARCHAR(1000) NOT NULL,
  `publishDate` DATETIME NOT NULL,
  `unpublishDate` DATETIME NOT NULL,
  `promoScheduleFrom` DATETIME NOT NULL,
  `promoScheduleTo` DATETIME NOT NULL,
  `status` VARCHAR(255) NOT NULL,
  `storeId` INT(11) NOT NULL,
  `mallIds` TEXT NOT NULL,
  `back_office_user_id` VARCHAR(255) NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `deletedAt` TIMESTAMP(6) NULL DEFAULT NULL,
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  INDEX `FK_fd9b961c08316175cf344499269` (`storeId` ASC) VISIBLE,
  INDEX `FK_7ad62cd7b8395e3d26e13251fcb` (`back_office_user_id` ASC) VISIBLE,
  CONSTRAINT `FK_7ad62cd7b8395e3d26e13251fcb`
    FOREIGN KEY (`back_office_user_id`)
    REFERENCES `ccdprdmallappdb1`.`back_office_user` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_fd9b961c08316175cf344499269`
    FOREIGN KEY (`storeId`)
    REFERENCES `ccdprdmallappdb1`.`store` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`promo_form` (
  `id` VARCHAR(36) NOT NULL,
  `name` VARCHAR(255) NULL DEFAULT NULL,
  `publishDate` DATETIME NOT NULL,
  `unpublishDate` DATETIME NOT NULL,
  `startDate` DATETIME NOT NULL,
  `endDate` DATETIME NOT NULL,
  `imageUrl` VARCHAR(255) NULL DEFAULT NULL,
  `status` VARCHAR(255) NOT NULL,
  `back_office_user_id` VARCHAR(255) NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `partnerNameId` INT(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_6ba8968125020145fd6c72fd203` (`partnerNameId` ASC) VISIBLE,
  INDEX `FK_51674c1506e4f1a71e75d93cd73` (`back_office_user_id` ASC) VISIBLE,
  CONSTRAINT `FK_51674c1506e4f1a71e75d93cd73`
    FOREIGN KEY (`back_office_user_id`)
    REFERENCES `ccdprdmallappdb1`.`back_office_user` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_6ba8968125020145fd6c72fd203`
    FOREIGN KEY (`partnerNameId`)
    REFERENCES `ccdprdmallappdb1`.`promo_form_partner` (`id`)
    ON DELETE NO ACTION
    ON UPDATE CASCADE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:12 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`promo_form_entry` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NULL DEFAULT NULL,
  `partnerName` VARCHAR(255) NULL DEFAULT NULL,
  `cardNumber` INT(11) NULL DEFAULT NULL,
  `customerUserId` VARCHAR(255) NULL DEFAULT NULL,
  `promoFormId` VARCHAR(255) NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  INDEX `FK_2a002b47d443f933e627ea725c9` (`customerUserId` ASC) VISIBLE,
  INDEX `FK_af42ff9e64d1dd86b81545bde23` (`promoFormId` ASC) VISIBLE,
  CONSTRAINT `FK_2a002b47d443f933e627ea725c9`
    FOREIGN KEY (`customerUserId`)
    REFERENCES `ccdprdmallappdb1`.`customer` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_af42ff9e64d1dd86b81545bde23`
    FOREIGN KEY (`promoFormId`)
    REFERENCES `ccdprdmallappdb1`.`promo_form` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`promo_form_partner` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`provinces` (
  `id` INT(11) NOT NULL,
  `psgcCode` VARCHAR(255) NOT NULL,
  `provDesc` VARCHAR(255) NOT NULL,
  `provCode` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`provCode`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`raffle` (
  `id` VARCHAR(36) NOT NULL,
  `title` VARCHAR(100) NOT NULL,
  `publishDate` DATETIME NOT NULL,
  `unpublishDate` DATETIME NOT NULL,
  `raffleScheduleFrom` DATETIME NULL DEFAULT NULL,
  `raffleScheduleTo` DATETIME NULL DEFAULT NULL,
  `imageUrl` VARCHAR(255) NOT NULL,
  `description` VARCHAR(1000) NOT NULL,
  `websiteUrl` VARCHAR(1000) NULL DEFAULT NULL,
  `status` VARCHAR(255) NOT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `back_office_user_id` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_430f8e354b42e9f12f98475ec3b` (`back_office_user_id` ASC) VISIBLE,
  CONSTRAINT `FK_430f8e354b42e9f12f98475ec3b`
    FOREIGN KEY (`back_office_user_id`)
    REFERENCES `ccdprdmallappdb1`.`back_office_user` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`recipient_category` (
  `id` VARCHAR(36) NOT NULL,
  `type` VARCHAR(255) NOT NULL,
  `notificationId` VARCHAR(36) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_2f112d74dbb138fd631b2cea647` (`notificationId` ASC) VISIBLE,
  CONSTRAINT `FK_2f112d74dbb138fd631b2cea647`
    FOREIGN KEY (`notificationId`)
    REFERENCES `ccdprdmallappdb1`.`notification` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`recipient_fields` (
  `id` VARCHAR(36) NOT NULL,
  `name` VARCHAR(128) NOT NULL,
  `value` TEXT NULL DEFAULT NULL,
  `recipientCategoryId` VARCHAR(36) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_fc08bd270b4432fa285c65dd8f6` (`recipientCategoryId` ASC) VISIBLE,
  CONSTRAINT `FK_fc08bd270b4432fa285c65dd8f6`
    FOREIGN KEY (`recipientCategoryId`)
    REFERENCES `ccdprdmallappdb1`.`recipient_category` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`referral` (
  `id` VARCHAR(36) NOT NULL,
  `title` VARCHAR(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_bin' NOT NULL,
  `subtitle` VARCHAR(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_bin' NOT NULL,
  `imageUrl` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`referral_instructions` (
  `id` VARCHAR(36) NOT NULL,
  `instruction` VARCHAR(255) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_bin' NOT NULL,
  `imageUrl` VARCHAR(255) NOT NULL,
  `order` INT(11) NOT NULL,
  `referralId` VARCHAR(36) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_e792716c564d8dd1a5e8a9f3264` (`referralId` ASC) VISIBLE,
  CONSTRAINT `FK_e792716c564d8dd1a5e8a9f3264`
    FOREIGN KEY (`referralId`)
    REFERENCES `ccdprdmallappdb1`.`referral` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`role` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `roleIdString` VARCHAR(255) NULL DEFAULT NULL,
  `authRoleId` VARCHAR(255) NULL DEFAULT NULL,
  `name` VARCHAR(255) NULL DEFAULT NULL,
  `description` LONGTEXT NULL DEFAULT NULL,
  `permissions` TEXT NULL DEFAULT NULL,
  `status` VARCHAR(255) NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `back_office_user_id` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_836b755f52ca13606cc513c2560` (`back_office_user_id` ASC) VISIBLE,
  CONSTRAINT `FK_836b755f52ca13606cc513c2560`
    FOREIGN KEY (`back_office_user_id`)
    REFERENCES `ccdprdmallappdb1`.`back_office_user` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`saved_mall_store` (
  `id` VARCHAR(36) NOT NULL,
  `mallStoreId` INT(11) NOT NULL,
  `customerUserId` VARCHAR(255) NOT NULL,
  `saved` TINYINT(4) NOT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`seeders` (
  `id` VARCHAR(36) NOT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` TIMESTAMP(6) NULL DEFAULT NULL,
  `name` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`shop_for_me` (
  `id` VARCHAR(36) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `logoUrl` VARCHAR(255) NULL DEFAULT NULL,
  `imageBannerUrl` VARCHAR(255) NULL DEFAULT NULL,
  `description` LONGTEXT NULL DEFAULT NULL,
  `shopperInfo` VARCHAR(255) NULL DEFAULT NULL,
  `operatingHours` LONGTEXT NULL DEFAULT NULL,
  `contactNumber` TEXT NULL DEFAULT NULL,
  `instructions` LONGTEXT NULL DEFAULT NULL,
  `instructionImageUrls` TEXT NULL DEFAULT NULL,
  `link` VARCHAR(255) NULL DEFAULT NULL,
  `category` VARCHAR(255) NOT NULL,
  `status` VARCHAR(255) NOT NULL,
  `mallIds` TEXT NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `back_office_user_id` VARCHAR(255) NULL DEFAULT NULL,
  `buttonName` VARCHAR(255) NULL DEFAULT NULL,
  `buttonLink` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_c980b4863172962a54fa1627957` (`back_office_user_id` ASC) VISIBLE,
  CONSTRAINT `FK_c980b4863172962a54fa1627957`
    FOREIGN KEY (`back_office_user_id`)
    REFERENCES `ccdprdmallappdb1`.`back_office_user` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`snap_and_win` (
  `id` VARCHAR(36) NOT NULL,
  `title` VARCHAR(100) NULL DEFAULT NULL,
  `publishDate` DATETIME NOT NULL,
  `unpublishDate` DATETIME NOT NULL,
  `promoScheduleFrom` DATETIME NOT NULL,
  `promoScheduleTo` DATETIME NOT NULL,
  `imageUrl` VARCHAR(255) NULL DEFAULT NULL,
  `modalImageUrl` VARCHAR(255) NULL DEFAULT NULL,
  `termsAndConditions` VARCHAR(10000) NOT NULL,
  `status` ENUM('Active', 'Inactive', 'Scheduled', 'Cancelled', 'Deleted', 'Draft') NULL DEFAULT 'Scheduled',
  `back_office_user_id` VARCHAR(255) NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  INDEX `FK_66e34696278db9cb92b31f6fd60` (`back_office_user_id` ASC) VISIBLE,
  CONSTRAINT `FK_66e34696278db9cb92b31f6fd60`
    FOREIGN KEY (`back_office_user_id`)
    REFERENCES `ccdprdmallappdb1`.`back_office_user` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`snap_and_win_entry` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `imageUrl` VARCHAR(255) NULL DEFAULT NULL,
  `receiptLastFourDigits` VARCHAR(4) NULL DEFAULT NULL,
  `mallName` VARCHAR(255) NULL DEFAULT NULL,
  `rejectionMessage` LONGTEXT NULL DEFAULT NULL,
  `storeName` VARCHAR(255) NULL DEFAULT NULL,
  `amount` VARCHAR(255) NULL DEFAULT NULL,
  `status` ENUM('Approved', 'Pending', 'Rejected') NULL DEFAULT 'Pending',
  `customerUserId` VARCHAR(255) NULL DEFAULT NULL,
  `snapAndWinId` VARCHAR(255) NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  INDEX `FK_6716a0721f8e55d9d8b31b91eb1` (`customerUserId` ASC) VISIBLE,
  INDEX `FK_d06c79ace70bcd73e58dc15b94f` (`snapAndWinId` ASC) VISIBLE,
  CONSTRAINT `FK_6716a0721f8e55d9d8b31b91eb1`
    FOREIGN KEY (`customerUserId`)
    REFERENCES `ccdprdmallappdb1`.`customer` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_d06c79ace70bcd73e58dc15b94f`
    FOREIGN KEY (`snapAndWinId`)
    REFERENCES `ccdprdmallappdb1`.`snap_and_win` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`snap_and_win_entry_rejection_message` (
  `id` VARCHAR(36) NOT NULL,
  `message` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`social_media` (
  `id` VARCHAR(36) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `imageUrl` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`splash_screen` (
  `id` VARCHAR(36) NOT NULL,
  `name` VARCHAR(128) NOT NULL,
  `value` VARCHAR(128) NOT NULL,
  `imageUrl` VARCHAR(255) NOT NULL,
  `default` TINYINT(4) NOT NULL DEFAULT 0,
  `activationDate` DATETIME NULL DEFAULT NULL,
  `deactivationDate` DATETIME NULL DEFAULT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`store` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `description` LONGTEXT NULL DEFAULT NULL,
  `storeLogoUrl` VARCHAR(255) NULL DEFAULT NULL,
  `heroBannerUrl` VARCHAR(255) NULL DEFAULT NULL,
  `photoUrls` TEXT NULL DEFAULT NULL,
  `back_office_user_id` VARCHAR(255) NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `buttonName` VARCHAR(255) NULL DEFAULT NULL,
  `buttonLink` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_818167d02ec1d746640bfae8fc1` (`back_office_user_id` ASC) VISIBLE,
  INDEX `idx_store_name` (`name` ASC) VISIBLE,
  CONSTRAINT `FK_818167d02ec1d746640bfae8fc1`
    FOREIGN KEY (`back_office_user_id`)
    REFERENCES `ccdprdmallappdb1`.`back_office_user` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 5754
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`store_categories` (
  `store` INT(11) NOT NULL,
  `store_category` INT(11) NOT NULL,
  PRIMARY KEY (`store`, `store_category`),
  INDEX `IDX_75e934818ed8e0a39e0b6abce9` (`store` ASC) VISIBLE,
  INDEX `IDX_298c82de30a91acc3d0860966a` (`store_category` ASC) VISIBLE,
  CONSTRAINT `FK_298c82de30a91acc3d0860966ae`
    FOREIGN KEY (`store_category`)
    REFERENCES `ccdprdmallappdb1`.`store_category` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_75e934818ed8e0a39e0b6abce97`
    FOREIGN KEY (`store`)
    REFERENCES `ccdprdmallappdb1`.`store` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`store_category` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  INDEX `idx_store_category_name` (`name` ASC) VISIBLE)
ENGINE = InnoDB
AUTO_INCREMENT = 3340
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:13 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`template` (
  `id` VARCHAR(36) NOT NULL,
  `notificationId` VARCHAR(36) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_4ef39c5f0b093811ef870bb3d61` (`notificationId` ASC) VISIBLE,
  CONSTRAINT `FK_4ef39c5f0b093811ef870bb3d61`
    FOREIGN KEY (`notificationId`)
    REFERENCES `ccdprdmallappdb1`.`notification` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:14 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`template_collection` (
  `id` VARCHAR(36) NOT NULL,
  `type` VARCHAR(255) NOT NULL,
  `order` INT(11) NOT NULL,
  `templateId` VARCHAR(36) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_f6b28779d0e612004c779d1c2be` (`templateId` ASC) VISIBLE,
  CONSTRAINT `FK_f6b28779d0e612004c779d1c2be`
    FOREIGN KEY (`templateId`)
    REFERENCES `ccdprdmallappdb1`.`template` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:14 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`template_fields` (
  `id` VARCHAR(36) NOT NULL,
  `name` VARCHAR(128) NOT NULL,
  `templateId` VARCHAR(36) NULL DEFAULT NULL,
  `value` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_d2764d0abd160479fc65ca8c10c` (`templateId` ASC) VISIBLE,
  CONSTRAINT `FK_d2764d0abd160479fc65ca8c10c`
    FOREIGN KEY (`templateId`)
    REFERENCES `ccdprdmallappdb1`.`template_collection` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:14 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`voucher` (
  `id` VARCHAR(36) NOT NULL,
  `title` VARCHAR(255) NOT NULL,
  `subtitle` VARCHAR(255) NULL DEFAULT NULL,
  `brandName` VARCHAR(255) NOT NULL,
  `imageUrl` VARCHAR(255) NOT NULL,
  `voucherDetailsTitle` VARCHAR(255) NULL DEFAULT NULL,
  `voucherDetailsSubtitle` VARCHAR(255) NULL DEFAULT NULL,
  `voucherDetailsImageUrl` VARCHAR(255) NULL DEFAULT NULL,
  `redemptionCategory` VARCHAR(255) NOT NULL,
  `code` VARCHAR(255) NULL DEFAULT NULL,
  `partnerVoucherLink` VARCHAR(255) NULL DEFAULT NULL,
  `isPartnerVoucherLink` TINYINT(4) NOT NULL DEFAULT 0,
  `voucherDetailsRedeemInstruction` LONGTEXT NULL DEFAULT NULL,
  `voucherDetailsModalInstruction` LONGTEXT NULL DEFAULT NULL,
  `voucherDetailsTermsAndConditions` LONGTEXT NULL DEFAULT NULL,
  `voucherSetupCampaignFrom` DATETIME NOT NULL,
  `voucherSetupCampaignTo` DATETIME NOT NULL,
  `voucherSetupDiscountType` VARCHAR(255) NULL DEFAULT NULL,
  `voucherSetupDiscountValue` INT(11) NULL DEFAULT NULL,
  `voucherSetupLimit` INT(11) NULL DEFAULT NULL,
  `voucherSetupUsesPerPerson` INT(11) NULL DEFAULT NULL,
  `voucherCollected` INT(11) NOT NULL DEFAULT 0,
  `voucherUsed` INT(11) NOT NULL DEFAULT 0,
  `featured` TINYINT(4) NOT NULL DEFAULT 0,
  `voucherStatus` VARCHAR(255) NOT NULL,
  `voucherCategory` VARCHAR(255) NOT NULL,
  `appVoucherCategory` VARCHAR(255) NULL DEFAULT NULL,
  `appVoucherType` VARCHAR(255) NULL DEFAULT NULL,
  `validityDays` INT(11) NULL DEFAULT NULL,
  `validityHours` INT(11) NULL DEFAULT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `back_office_user_id` VARCHAR(255) NULL DEFAULT NULL,
  `mallIds` TEXT NULL DEFAULT NULL,
  `store_id` INT(11) NULL DEFAULT NULL,
  `uniqueCodeList` TEXT NULL DEFAULT NULL,
  `pinCode` VARCHAR(4) NULL DEFAULT NULL,
  `pinCodeQR` TINYINT(4) NOT NULL DEFAULT 0,
  `uniqueVoucherCategory` VARCHAR(255) NULL DEFAULT NULL,
  `recipientList` TEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_9e6e37b9e3955ba23990405d77f` (`back_office_user_id` ASC) VISIBLE,
  INDEX `FK_c8b326e3b3dc5d380cda10f3e95` (`store_id` ASC) VISIBLE,
  CONSTRAINT `FK_9e6e37b9e3955ba23990405d77f`
    FOREIGN KEY (`back_office_user_id`)
    REFERENCES `ccdprdmallappdb1`.`back_office_user` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_c8b326e3b3dc5d380cda10f3e95`
    FOREIGN KEY (`store_id`)
    REFERENCES `ccdprdmallappdb1`.`store` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:14 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`voucher_unique_code` (
  `id` VARCHAR(36) NOT NULL,
  `voucherId` VARCHAR(255) NULL DEFAULT NULL,
  `customerId` VARCHAR(255) NULL DEFAULT NULL,
  `voucherUniqueCode` VARCHAR(255) NULL DEFAULT NULL,
  `available` TINYINT(4) NOT NULL DEFAULT 1,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `usedDate` DATETIME NULL DEFAULT NULL,
  `updatedAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  INDEX `idx_voucher_unique_code_voucherId` (`voucherId` ASC) VISIBLE,
  INDEX `idx_voucher_unique_code_customerId` (`customerId` ASC) VISIBLE,
  CONSTRAINT `FK_3dc81bab9a71b4adc1c4e94203e`
    FOREIGN KEY (`voucherId`)
    REFERENCES `ccdprdmallappdb1`.`voucher` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:14 [INF][            grt]: Execute statement	CREATE TABLE IF NOT EXISTS `ccdprdmallappdb1`.`walkthrough` (
  `id` VARCHAR(36) NOT NULL,
  `title` VARCHAR(50) NOT NULL,
  `description` VARCHAR(150) NOT NULL,
  `order` INT(11) NULL DEFAULT NULL,
  `imageUrl` VARCHAR(255) NOT NULL,
  `createdAt` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci
11:35:14 [INF][            grt]: Scripts for 74 tables, 0 views and 0 routines were executed for schema ccdprdmallappdb1	
11:35:14 [INF][            grt]: Execute statement	SET FOREIGN_KEY_CHECKS = 1
11:35:14 [ERR][SSHTunnelHandler]: Error during data transfer: unable to read, remote end disconnected
11:35:16 [WRN][         mforms]: Resource file not found: migration_check_done_win.png
11:35:16 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
11:35:50 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
11:35:52 [WRN][         mforms]: Resource file not found: migration_check_done_win.png
11:35:52 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
11:36:05 [WRN][         mforms]: Resource file not found: migration_check_done_win.png
11:36:05 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
11:37:00 [WRN][         mforms]: Resource file not found: migration_check_done_win.png
11:37:00 [WRN][         mforms]: Resource file not found: migration_check_current_win.png
11:37:00 [INF][         Wizard]: Execute 'Prepare information for data copy'
11:37:00 [INF][         Wizard]: Starting thread for 'Determine number of rows to copy'
11:37:00 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
11:39:11 [ERR][         Wizard]: Thread 'Determine number of rows to copy' failed: Error getting row count from source tables, wbcopytables exited with code 1
11:40:13 [WRN][         mforms]: Resource file not found: migration_check_current_win.png