10:08:24 [INF][ Workbench]: Starting up Workbench 10:08:24 [INF][ Workbench]: Current environment: Command line: MySQLWorkbench.exe -log-level=debug3 CurrentDirectory: D:\MySQL\MySQL Workbench 8.0 CE HasShutdownStarted: False OSVersion: Microsoft Windows NT 6.2.9200.0 SystemDirectory: C:\WINDOWS\system32 TickCount: 2191187 UserInteractive: True Version: 4.0.30319.42000 WorkingSet: 41910272 10:08:24 [INF][ Workbench]: Environment variables: SystemDrive = C: ProgramFiles(x86) = C:\Program Files (x86) ProgramW6432 = C:\Program Files PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 158 Stepping 9, GenuineIntel TMP = C:\Users\user\AppData\Local\Temp PROCESSOR_ARCHITECTURE = AMD64 Path = C:\Users\user\AppData\Local\Programs\Python\Python37\Scripts\;C:\Users\user\AppData\Local\Programs\Python\Python37\;D:\Python Compiler\Python3.7.3\Scripts\;D:\Python Compiler\Python3.7.3\;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program Files\Java\jdk1.8.0_191\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\nodejs\;C:\Program Files\Git\cmd;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files\dotnet\;C:\Program Files (x86)\dotnet\;C:\Program Files (x86)\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files\Azure Data Studio\bin;C:\Users\user\AppData\Local\Microsoft\PowerAppsCLI\;C:\Program Files\Java\jdk-11\bin;C:\Users\user\AppData\Local\Microsoft\WindowsApps;D:\1Chrome Downloads\PyCharm\PyCharm Community Edition 2019.1\bin;;C:\Users\user\AppData\Roaming\npm;C:\Users\user\AppData\Local\Programs\Microsoft VS Code\bin;C:\Users\user\.dotnet\tools;C:\Program Files\Azure Data Studio\bin PyCharm Community Edition = D:\1Chrome Downloads\PyCharm\PyCharm Community Edition 2019.1\bin; USERPROFILE = C:\Users\user configsetroot = C:\WINDOWS\ConfigSetRoot PROCESSOR_REVISION = 9e09 TEMP = C:\Users\user\AppData\Local\Temp FPS_BROWSER_APP_PROFILE_STRING = Internet Explorer FPS_BROWSER_USER_PROFILE_STRING = Default LOGONSERVER = \\LENOVO-PC USERNAME = Michel Asmar SystemRoot = C:\WINDOWS OneDrive = C:\Users\user\OneDrive CommonProgramFiles = C:\Program Files\Common Files ProgramData = C:\ProgramData HOMEPATH = \Users\user OneDriveConsumer = C:\Users\user\OneDrive COMPUTERNAME = LENOVO-PC CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files ALLUSERSPROFILE = C:\ProgramData CommonProgramW6432 = C:\Program Files\Common Files SESSIONNAME = Console DriverData = C:\Windows\System32\Drivers\DriverData HOMEDRIVE = C: windir = C:\WINDOWS VS160COMCOMNTOOLS = C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\Tools\ NUMBER_OF_PROCESSORS = 8 OS = Windows_NT ProgramFiles = C:\Program Files ComSpec = C:\WINDOWS\system32\cmd.exe PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.PY;.PYW PSModulePath = C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files (x86)\Microsoft SQL Server\150\Tools\PowerShell\Modules\ JAVA_HOME = C:\Program Files\Java\jdk1.8.0_191 PROMPT = $P$G APPDATA = C:\Users\user\AppData\Roaming USERDOMAIN = LENOVO-PC PROCESSOR_LEVEL = 6 LOCALAPPDATA = C:\Users\user\AppData\Local USERDOMAIN_ROAMINGPROFILE = LENOVO-PC PUBLIC = C:\Users\Public 10:08:24 [INF][ Workbench]: Current version given by meta info is: 8.0.24 10:08:24 [INF][ Workbench]: Setting PATH to: C:\WINDOWS\system32;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program Files\Java\jdk1.8.0_191\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\nodejs\;C:\Program Files\Git\cmd;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files\dotnet\;C:\Program Files (x86)\dotnet\;C:\Program Files (x86)\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files\Azure Data Studio\bin;C:\Users\user\AppData\Local\Microsoft\PowerAppsCLI\;C:\Program Files\Java\jdk-11\bin;C:\Users\user\AppData\Local\Microsoft\WindowsApps;D:\1Chrome Downloads\PyCharm\PyCharm Community Edition 2019.1\bin;;C:\Users\user\AppData\Roaming\npm;C:\Users\user\AppData\Local\Programs\Microsoft VS Code\bin;C:\Users\user\.dotnet\tools;C:\Program Files\Azure Data Studio\bin 10:08:24 [INF][ mforms managed]: Initializing mforms wrapper 10:08:25 [INF][ WBContext UI]: Initializing workbench context UI with these values: base dir: D:\MySQL\MySQL Workbench 8.0 CE plugin path: D:\MySQL\MySQL Workbench 8.0 CE struct path: module path: D:\MySQL\MySQL Workbench 8.0 CE/modules library path: D:\MySQL\MySQL Workbench 8.0 CE user data dir: C:\Users\user\AppData\Roaming\MySQL\Workbench open at start: -log-level=debug3 open type: run at startup: run type: Force SW rendering: No Force OpenGL: No quit when done: No 10:08:25 [INF][ WBContext]: WbContext::init 10:08:25 [INF][ WBA]: Looking for extension modules for WBA... 10:08:25 [INF][ WBA]: 0 extension modules found 10:08:25 [WRN][ grt]: Duplicate plugin name wb.tools.cmdlineClient There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils). 10:08:25 [WRN][ grt]: C:\Users\user\AppData\Roaming\MySQL\Workbench\connections.xml:26: link '{4CFDD6D7-3629-49A0-97D3-C6A32EF969F1}' key=owner could not be resolved 10:08:25 [WRN][ grt]: Duplicate plugin name wb.tools.cmdlineClient There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils). 10:08:25 [INF][ WBContext]: System info: MySQL Workbench Community (GPL) for Windows version 8.0.24 CE build 681332 (64 bit) Configuration Directory: C:\Users\user\AppData\Roaming\MySQL\Workbench Data Directory: D:\MySQL\MySQL Workbench 8.0 CE Cairo Version: 1.17.4 OS: Microsoft Windows 10 Home CPU: 8x Intel(R) Core(TM) i7-7700HQ CPU @ 2.80GHz, 15.9 GiB RAM Active video adapter Intel(R) HD Graphics 630 Installed video RAM: 1024 MB Current video mode: 1920 x 1080 x 4294967296 colors Used bit depth: 32 Driver version: 22.20.16.4836 Installed display drivers: C:\WINDOWS\System32\DriverStore\FileRepository\ki125133.inf_amd64_7a52044300619fc7\igdumdim64.dll,C:\WINDOWS\System32\DriverStore\FileRepository\ki125133.inf_amd64_7a52044300619fc7\igd10iumd64.dll,C:\WINDOWS\System32\DriverStore\FileRepository\ki125133.inf_amd64_7a52044300619fc7\igd10iumd64.dll,C:\WINDOWS\System32\DriverStore\FileRepository\ki125133.inf_amd64_7a52044300619fc7\igd12umd64.dll Current user language: English (United States) 10:08:25 [INF][ Workbench]: UI is up 10:08:25 [ERR][ WBContext]: Unknown file type -log-level=debug3 10:08:25 [INF][ Workbench]: Running the application 10:12:46 [WRN][ mforms]: Resource file not found: migration_win.png 10:12:46 [WRN][ grt]: D:\MySQL\MySQL Workbench 8.0 CE/modules/data\msaccess_rdbms_info.xml:8: link 'com.mysql.rdbms.msaccess.driver.odbc' key=defaultDriver could not be resolved 10:12:46 [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 10:12:46 [WRN][ mforms]: Resource file not found: migration_check_open_win.png 10:12:46 [WRN][ mforms]: Resource file not found: migration_check_open_win.png 10:12:46 [WRN][ mforms]: Resource file not found: migration_check_open_win.png 10:12:46 [WRN][ mforms]: Resource file not found: migration_check_open_win.png 10:12:46 [WRN][ mforms]: Resource file not found: migration_check_open_win.png 10:12:46 [WRN][ mforms]: Resource file not found: migration_check_open_win.png 10:12:46 [WRN][ mforms]: Resource file not found: migration_check_open_win.png 10:12:46 [WRN][ mforms]: Resource file not found: migration_check_open_win.png 10:12:46 [WRN][ mforms]: Resource file not found: migration_check_open_win.png 10:12:46 [WRN][ mforms]: Resource file not found: migration_check_open_win.png 10:12:46 [WRN][ mforms]: Resource file not found: migration_check_open_win.png 10:12:46 [WRN][ mforms]: Resource file not found: migration_check_open_win.png 10:12:46 [WRN][ mforms]: Resource file not found: migration_check_open_win.png 10:12:46 [WRN][ mforms]: Resource file not found: migration_check_open_win.png 10:13:41 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 10:14:00 [INF][ grt]: Connecting to Mssql@MigrationToMySQL... 10:14:00 [INF][ grt]: Opening ODBC connection to DSN=MigrationToMySQL;DATABASE=;UID=michelasmar;PWD=XXXX... 10:14:01 [INF][ grt]: Connected to Mssql@MigrationToMySQL, 15.0.2080.9 10:14:04 [WRN][ mforms]: Resource file not found: migration_check_done_win.png 10:14:04 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 10:14:22 [INF][ grt]: Connecting to Mysql@localhost:3306... 10:14:24 [INF][ grt]: Connecting to Mysql@localhost:3306... 10:14:24 [INF][ grt]: Connected 10:14:27 [WRN][ mforms]: Resource file not found: migration_check_done_win.png 10:14:27 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 10:14:28 [INF][ Wizard]: Execute 'Connect to source DBMS' 10:14:28 [INF][ grt]: Connecting to Mssql@MigrationToMySQL... 10:14:28 [INF][ grt]: Opening ODBC connection to DSN=MigrationToMySQL;DATABASE=;UID=michelasmar;PWD=XXXX... 10:14:28 [INF][ grt]: Connected to Mssql@MigrationToMySQL, 15.0.2080.9 10:14:28 [INF][ Wizard]: Execute 'Check target DBMS connection' 10:14:28 [INF][ grt]: Connecting to Mysql@localhost:3306... 10:14:28 [INF][ grt]: Connecting to Mysql@localhost:3306... 10:14:28 [INF][ grt]: Connected 10:14:28 [INF][ Wizard]: Starting thread for 'Retrieve schema list from source' 10:14:35 [WRN][ mforms]: Resource file not found: migration_check_done_win.png 10:14:35 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 10:14:48 [WRN][ mforms]: Resource file not found: migration_check_done_win.png 10:14:48 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 10:14:48 [INF][ Wizard]: Execute 'Connect to source DBMS' 10:14:48 [INF][ grt]: Connecting to Mssql@MigrationToMySQL... 10:14:48 [INF][ grt]: Opening ODBC connection to DSN=MigrationToMySQL;DATABASE=;UID=michelasmar;PWD=XXXX... 10:14:48 [INF][ grt]: Connected to Mssql@MigrationToMySQL, 15.0.2080.9 10:14:48 [INF][ Wizard]: Starting thread for 'Reverse engineer selected schemas' 10:14:48 [INF][ grt]: Reverse engineering dbo from RealEstate 10:14:49 [INF][ grt]: Reverse engineering 149 tables from dbo 10:14:53 [INF][ grt]: Reverse engineering 14 views from dbo 10:14:54 [INF][ grt]: Reverse engineering 8 routines from dbo 10:14:54 [INF][ grt]: Reverse engineering 0 triggers from dbo 10:14:54 [INF][ grt]: Reverse engineering foreign keys for tables in schema dbo 10:14:55 [INF][ Wizard]: Execute 'Post-processing of reverse engineered schemas' 10:14:55 [INF][ grt]: Merging reverse engineered schema objects into a single schema... 10:14:59 [WRN][ mforms]: Resource file not found: migration_check_done_win.png 10:14:59 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 10:21:13 [WRN][ mforms]: Resource file not found: migration_check_done_win.png 10:21:13 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 10:21:13 [INF][ Wizard]: Starting thread for 'Migrate Selected Objects' 10:21:18 [INF][ Wizard]: Starting thread for 'Generate SQL CREATE Statements' 10:21:59 [WRN][ mforms]: Resource file not found: migration_check_done_win.png 10:21:59 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:00 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:01 [WRN][ mforms]: Resource file not found: folder 10:22:09 [WRN][ mforms]: Resource file not found: migration_check_done_win.png 10:22:09 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 10:22:10 [WRN][ mforms]: Resource file not found: migration_check_done_win.png 10:22:10 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 10:22:11 [INF][ Wizard]: Execute 'Connect to Target Database' 10:22:11 [INF][ Wizard]: Execute 'Perform Checks in Target' 10:22:12 [INF][ Wizard]: Starting thread for 'Create Schemas and Objects' 10:22:13 [INF][ grt]: Execute statement SET FOREIGN_KEY_CHECKS = 0 10:22:13 [INF][ grt]: Execute statement DROP SCHEMA IF EXISTS `RealEstate` 10:22:15 [INF][ grt]: Execute statement CREATE SCHEMA IF NOT EXISTS `RealEstate` 10:22:15 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Quality` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:22:15 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_Users` ( `ApplicationId` VARCHAR(64) NOT NULL, `UserId` VARCHAR(64) NOT NULL, `UserName` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `LoweredUserName` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `MobileAlias` VARCHAR(16) CHARACTER SET 'utf8mb4' NULL DEFAULT NULL, `IsAnonymous` TINYINT(1) NOT NULL DEFAULT 0, `LastActivityDate` DATETIME(6) NOT NULL, UNIQUE INDEX `aspnet_Users_Index` (`ApplicationId` ASC, `LoweredUserName`(255) ASC) VISIBLE, PRIMARY KEY (`UserId`), INDEX `aspnet_Users_Index2` (`ApplicationId` ASC, `LastActivityDate` ASC) VISIBLE, CONSTRAINT `FK__aspnet_Us__Appli__0425A276` FOREIGN KEY (`ApplicationId`) REFERENCES `RealEstate`.`aspnet_Applications` (`ApplicationId`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:15 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Notifications` ( `Id` VARCHAR(64) NOT NULL, `DepartmentId` VARCHAR(64) NULL, `FromName` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `FromEmail` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `ToName` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `ToEmail` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `Subject` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `Body` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Sent` TINYINT(1) NOT NULL DEFAULT 0, `ScheduledDateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `ModuleName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_Notifications_Department` FOREIGN KEY (`DepartmentId`) REFERENCES `RealEstate`.`Department` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:15 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_RequestCategory` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:15 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertyType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:15 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationToExpireProperties` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `PRL` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertyState` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_SchemaVersions` ( `Feature` VARCHAR(128) CHARACTER SET 'utf8mb4' NOT NULL, `CompatibleSchemaVersion` VARCHAR(128) CHARACTER SET 'utf8mb4' NOT NULL, `IsCurrentVersion` TINYINT(1) NOT NULL, PRIMARY KEY (`Feature`, `CompatibleSchemaVersion`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`DetailedInspection` ( `Id` VARCHAR(64) NOT NULL, `Prl` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `ContactId` VARCHAR(64) NULL, `Inspector` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `InspDate` DATETIME(6) NULL, `InspAddress` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `InspCity` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Temperature` INT NULL, `Weather` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `YearBuilt` DATETIME(6) NULL, `BuildingType` CHAR(200) CHARACTER SET 'utf8mb4' NULL, `Remarks` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `HouseOccupied` TINYINT(1) NULL, `ClientPresent` TINYINT(1) NULL, `OthersPresent` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `BuildingName` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertyAvailability` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyOffer` ( `Id` VARCHAR(64) NOT NULL, `Prl` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `PropertyDesc` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `PropertyImages` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `PropertyDocuments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ContactId` VARCHAR(64) NULL, `ContactType` INT NULL, `Subject` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `AdvImage` VARCHAR(64) NULL, PRIMARY KEY (`Id`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ShowingType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ShowingTypeColor` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyCost` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `Date` DATETIME(6) NULL, `DateTo` DATETIME(6) NULL, `Cost` DECIMAL(16,2) NULL, `CostContact` VARCHAR(64) NULL, `CostTypeId` INT NULL, `CostCategoryId` INT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertyCost_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Sur_Questions` ( `ID` INT NOT NULL, `Text` VARCHAR(200) NOT NULL, `QuestionType` VARCHAR(200) NOT NULL, `Options` VARCHAR(2000) NOT NULL, `Disp` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`ID`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ShowingList` ( `Id` VARCHAR(64) NOT NULL, `AgentId` VARCHAR(64) NOT NULL, `ContactId` VARCHAR(64) NOT NULL, `DepartmentId` VARCHAR(64) NOT NULL, `ShowingDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `Showed` TINYINT(1) NOT NULL DEFAULT 0, `Comment` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `NotifyAgainDate` DATETIME(6) NULL, `Notified` TINYINT(1) NULL, `ShowingTypeId` INT NULL, `SentByEmail` TINYINT(1) NULL, `SentByEmailDate` DATETIME(6) NULL, `CreationDate` DATETIME(6) NULL, `CreatedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ModifiedDate` DATETIME(6) NULL, `ModifiedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `AdditionalAgentId` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `RequestRelatedId` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `FeedBack` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ChkOwner` TINYINT(1) NULL, `ChkClient` TINYINT(1) NULL, PRIMARY KEY (`Id`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`TraSub` ( `Id` VARCHAR(64) NOT NULL, `TransactionId` VARCHAR(64) NOT NULL, `TranDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `AmountPaid` DECIMAL(18,3) NULL, `Comment` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Paid` TINYINT(1) NULL, `PaidDate` DATETIME(6) NULL, `RecPay` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ReminderId` VARCHAR(64) NULL, `FollowUp` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `FollowUpDate` DATETIME(6) NULL, `PlusMonth` BIGINT NULL, `Conditions` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Payments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ContractConditions` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SeqNum` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ExpectedPaymentDate` DATETIME(6) NULL, `NewTransactionDate` DATETIME(6) NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_TraSub_Transactions` FOREIGN KEY (`TransactionId`) REFERENCES `RealEstate`.`Transactions` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Sur_Survey_Questions` ( `ID` INT NOT NULL, `SurveyID` INT NOT NULL, `QuestionID` INT NOT NULL, `OrderID` INT NULL, PRIMARY KEY (`ID`), CONSTRAINT `FK_Sur_Survey_Questions_Sur_Questions` FOREIGN KEY (`QuestionID`) REFERENCES `RealEstate`.`Sur_Questions` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Sur_Survey_Questions_Sur_Surveys` FOREIGN KEY (`SurveyID`) REFERENCES `RealEstate`.`Sur_Surveys` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_Membership` ( `ApplicationId` VARCHAR(64) NOT NULL, `UserId` VARCHAR(64) NOT NULL, `Password` VARCHAR(128) CHARACTER SET 'utf8mb4' NOT NULL, `PasswordFormat` INT NOT NULL DEFAULT 0, `PasswordSalt` VARCHAR(128) CHARACTER SET 'utf8mb4' NOT NULL, `MobilePIN` VARCHAR(16) CHARACTER SET 'utf8mb4' NULL, `Email` VARCHAR(256) CHARACTER SET 'utf8mb4' NULL, `LoweredEmail` VARCHAR(256) CHARACTER SET 'utf8mb4' NULL, `PasswordQuestion` VARCHAR(256) CHARACTER SET 'utf8mb4' NULL, `PasswordAnswer` VARCHAR(128) CHARACTER SET 'utf8mb4' NULL, `IsApproved` TINYINT(1) NOT NULL, `IsLockedOut` TINYINT(1) NOT NULL, `CreateDate` DATETIME(6) NOT NULL, `LastLoginDate` DATETIME(6) NOT NULL, `LastPasswordChangedDate` DATETIME(6) NOT NULL, `LastLockoutDate` DATETIME(6) NOT NULL, `FailedPasswordAttemptCount` INT NOT NULL, `FailedPasswordAttemptWindowStart` DATETIME(6) NOT NULL, `FailedPasswordAnswerAttemptCount` INT NOT NULL, `FailedPasswordAnswerAttemptWindowStart` DATETIME(6) NOT NULL, `Comment` LONGTEXT NULL, INDEX `aspnet_Membership_index` (`ApplicationId` ASC, `LoweredEmail`(255) ASC) VISIBLE, PRIMARY KEY (`UserId`), CONSTRAINT `FK__aspnet_Me__Appli__145C0A3F` FOREIGN KEY (`ApplicationId`) REFERENCES `RealEstate`.`aspnet_Applications` (`ApplicationId`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK__aspnet_Me__UserI__15502E78` FOREIGN KEY (`UserId`) REFERENCES `RealEstate`.`aspnet_Users` (`UserId`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ShowingFeatures` ( `ID` VARCHAR(64) NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`ID`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Sur_Surveys` ( `ID` INT NOT NULL, `Title` VARCHAR(200) NULL, `Description` VARCHAR(200) NOT NULL, `CreatedOn` DATETIME(6) NOT NULL, `ExpiresOn` DATETIME(6) NULL, `CreatedBy` VARCHAR(200) NOT NULL, `Publish` TINYINT(1) NULL, `TypeId` INT NULL, PRIMARY KEY (`ID`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyRooms` ( `Id` VARCHAR(64) NOT NULL, `LKUP_PropertyRoomsId` INT NULL, `Count` INT NULL, `Surface` DECIMAL(10,2) NULL, `Length` DECIMAL(10,2) NULL, `Width` DECIMAL(10,2) NULL, `Height` DECIMAL(10,2) NULL, `Unit` VARCHAR(1) CHARACTER SET 'utf8mb4' NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertyRooms_LKUP_PropertyRooms` FOREIGN KEY (`LKUP_PropertyRoomsId`) REFERENCES `RealEstate`.`LKUP_PropertyRooms` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_PropertyRooms_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertyRooms` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`SmsHistory` ( `Id` VARCHAR(64) NOT NULL, `ContactId` VARCHAR(64) NULL, `PhoneNb` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `SmsText` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SmsStatus` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_SurveyType` ( `ID` INT NOT NULL, `Description` CHAR(200) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`ID`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ShowingRelatedFeatures` ( `Id` VARCHAR(64) NOT NULL, `ShowingFeaturesId` VARCHAR(64) NOT NULL, `ShowingListId` VARCHAR(64) NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Signature` ( `Id` VARCHAR(64) NOT NULL, `AgentId` VARCHAR(64) NOT NULL, `ProfImage` LONGBLOB NULL, `SigImage` LONGBLOB NULL, `Extension` VARCHAR(5) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_SalaryRange` ( `Id` VARCHAR(64) NOT NULL, `RangeFrom` INT NOT NULL, `RangeTo` INT NOT NULL, `RangeName` VARCHAR(200) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ClientStatus` ( `Id` INT NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ContactReassignement` ( `Id` VARCHAR(64) NOT NULL, `ReassignementDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `InitiatedBy` VARCHAR(64) NOT NULL, `FromAgentId` VARCHAR(64) NOT NULL, `DestinationAgentId` VARCHAR(64) NOT NULL, `ContactId` VARCHAR(64) NOT NULL, `ApprovedByDestinationAgent` TINYINT(1) NOT NULL DEFAULT 0, `ApprovedDestinationAgentDate` DATETIME(6) NULL, `ApprovedByAdmin` TINYINT(1) NOT NULL DEFAULT 0, `ApprovedAdminDate` DATETIME(6) NULL, `AdminId` VARCHAR(64) NULL, PRIMARY KEY (`Id`)) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyActions` ( `Id` VARCHAR(64) NOT NULL, `ActionDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `InitiatedBy` VARCHAR(64) NOT NULL, `FromAgentId` VARCHAR(64) NOT NULL, `DestinationAgentId` VARCHAR(64) NOT NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `ApprovedByDestinationAgent` TINYINT(1) NOT NULL DEFAULT 0, `ApprovedDestinationAgentDate` DATETIME(6) NULL, `ApprovedByAdmin` TINYINT(1) NOT NULL DEFAULT 0, `ApprovedAdminDate` DATETIME(6) NULL, `AdminId` VARCHAR(64) NULL, `PropertyActionsTypeId` INT NOT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertyActions_LKUP_PorpertyActionsType` FOREIGN KEY (`PropertyActionsTypeId`) REFERENCES `RealEstate`.`LKUP_PorpertyActionsType` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_PropertyActions_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_Profile` ( `UserId` VARCHAR(64) NOT NULL, `PropertyNames` LONGTEXT NOT NULL, `PropertyValuesString` LONGTEXT NOT NULL, `PropertyValuesBinary` LONGBLOB NOT NULL, `LastUpdatedDate` DATETIME(6) NOT NULL, PRIMARY KEY (`UserId`), CONSTRAINT `FK__aspnet_Pr__UserI__29572725` FOREIGN KEY (`UserId`) REFERENCES `RealEstate`.`aspnet_Users` (`UserId`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ContactChildren` ( `Id` VARCHAR(64) NOT NULL, `ContactId` VARCHAR(64) NOT NULL, `Name` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `DateOfBirth` DATETIME(6) NULL, `Occupation` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_ContactChildren_Contacts` FOREIGN KEY (`ContactId`) REFERENCES `RealEstate`.`Contacts` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyFeatures` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(250) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_State` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Zoning` ( `Id` VARCHAR(64) NOT NULL, `ZoneNbr` VARCHAR(10) CHARACTER SET 'utf8mb4' NULL, `Description` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `HorizontalPerc` DECIMAL(5,2) NOT NULL, `Exploitation` DECIMAL(5,2) NOT NULL, `MaxHeight` DECIMAL(5,2) NULL, `NbrOfFloors` TINYINT UNSIGNED NULL, `Details` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`SmsLog` ( `Id` VARCHAR(64) NOT NULL, `ContactId` VARCHAR(64) NULL, `ToName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Phone` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CampaignId` VARCHAR(64) NULL, `ErrorMsg` VARCHAR(300) CHARACTER SET 'utf8mb4' NULL, `Date` DATETIME(6) NULL, PRIMARY KEY (`Id`)) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationReminder` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `IDS` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ReminderNature` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `ReminderNatureColor` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Request` ( `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `OldPRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `DepartmentId` VARCHAR(64) NOT NULL, `PropertyTypeId` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `PropertySizeId` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `ContactId` VARCHAR(64) NOT NULL, `SizeFrom` DECIMAL(9,2) NULL DEFAULT 0, `SizeTo` DECIMAL(9,2) NULL, `SalePriceFrom` INT NULL, `SalePriceTo` INT NULL, `RentPriceFrom` INT NULL, `RentPriceTo` INT NULL, `TotalBedRoomFrom` INT NULL DEFAULT 0, `TotalBedRoomTo` INT NULL, `ReceptionFrom` INT NULL DEFAULT 0, `ReceptionTo` INT NULL, `FloorLevel` INT NULL, `PropertyForId` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `QualityId` INT NULL, `Parking` INT NULL DEFAULT 0, `PostedDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `ExpiryDate` DATETIME(6) NOT NULL, `Active` TINYINT(1) NULL DEFAULT 0, `Closed` TINYINT(1) NULL DEFAULT 0, `PreviousReferedAgentId` VARCHAR(64) NULL, `CurrentReferedAgentId` VARCHAR(64) NULL, `PreviousReassignedAgentId` VARCHAR(64) NULL, `CurrentReassignedAgentId` VARCHAR(64) NULL, `Comments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SearchingFor` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `InvolvedChoosing` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `DecisionMaker` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `OtherSpecFeatures` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `WhyThoseFeatures` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `SearchingTime` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `LimitTimeToGet` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `AnythingYouLike` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `WhyNotPropertyYet` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `PreferredPropertyInfo` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `BuildingAge` INT NULL, `PropertyViewId` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `OtherFeatures` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `OtherFeaturesWhy` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `RegionPriceIdea` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PayMethod` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `BankContact` TINYINT(1) NULL, `BankName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `BankSpecified` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SearchingPropertyMethod` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `OtherAgentContact` TINYINT(1) NULL, `SpecifyAgent` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `SellOwnProperty` TINYINT(1) NULL, `SellingBeforeBuying` TINYINT(1) NULL, `SurfaceAndCharacteristics` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `OwnPropertyPrice` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `WhatAreYouDoingToSell` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `Diagnosis` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ManagerialComments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CustomerRange` INT NULL, `BuyingOrRentingGoodPrice` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CurrentPropertyStatusId` INT NULL, `Satisfied` TINYINT(1) NULL, `CreationDate` DATETIME(6) NULL, `CreatedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ModifiedDate` DATETIME(6) NULL, `ModifiedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PurchaserId` VARCHAR(64) NULL, `FurnishedDescription` VARCHAR(400) CHARACTER SET 'utf8mb4' NULL, `BathroomFrom` INT NULL, `BathroomTo` INT NULL, `TerraceGardenDescription` VARCHAR(400) CHARACTER SET 'utf8mb4' NULL, `Schools` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `Entertainment` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `Activities` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `ChildrenActivity` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `ShoppingFacilities` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `DeliveryServices` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `Hospitals` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `LifeStyleOthers` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `BuildingName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Discount` DECIMAL(12,3) NULL, `ReferencedBy` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `MediaCompanyId` VARCHAR(64) NULL, `StatusReasonId` INT NULL, `CategoryId` VARCHAR(64) NULL, `CallSheetDetails` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `RequestComments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `MasterBedRoomFrom` INT NULL, `MasterBedRoomTo` INT NULL, `ReferralId` INT NULL, `ClientStatusId` INT NULL, `CallSheetTypeId` INT NULL, `ClientNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Pending` TINYINT(1) NULL, `ChkCurrencyPrice` TINYINT(1) NULL, PRIMARY KEY (`PRL`), CONSTRAINT `FK_Request_LKUP_CurrentPropertyStatus` FOREIGN KEY (`CurrentPropertyStatusId`) REFERENCES `RealEstate`.`LKUP_CurrentPropertyStatus` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `FK_Request_Department` FOREIGN KEY (`DepartmentId`) REFERENCES `RealEstate`.`Department` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Request_LKUP_StatusReason` FOREIGN KEY (`StatusReasonId`) REFERENCES `RealEstate`.`LKUP_StatusReason` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Request_LKUP_Quality` FOREIGN KEY (`QualityId`) REFERENCES `RealEstate`.`LKUP_Quality` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Request_Contacts` FOREIGN KEY (`ContactId`) REFERENCES `RealEstate`.`Contacts` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyDocuments` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Documents` LONGBLOB NOT NULL, `DocumentName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Extension` VARCHAR(5) CHARACTER SET 'utf8mb4' NOT NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `DocDate` DATETIME(6) NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertyDocuments_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ManPower` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(64) NULL, `Hour` DOUBLE NULL, `MaintenanceWorkId` VARCHAR(64) NOT NULL, PRIMARY KEY (`Id`)) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_Roles` ( `ApplicationId` VARCHAR(64) NOT NULL, `RoleId` VARCHAR(64) NOT NULL, `RoleName` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `LoweredRoleName` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `Description` VARCHAR(256) CHARACTER SET 'utf8mb4' NULL, UNIQUE INDEX `aspnet_Roles_index1` (`ApplicationId` ASC, `LoweredRoleName`(255) ASC) VISIBLE, PRIMARY KEY (`RoleId`), CONSTRAINT `FK__aspnet_Ro__Appli__32E0915F` FOREIGN KEY (`ApplicationId`) REFERENCES `RealEstate`.`aspnet_Applications` (`ApplicationId`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Transactions` ( `Id` VARCHAR(64) NOT NULL, `PRL` VARCHAR(40) CHARACTER SET 'utf8mb4' NOT NULL, `ClosingAmount` DECIMAL(18,3) NULL, `Comment` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `Closed` TINYINT(1) NOT NULL DEFAULT 0, `ContactId` VARCHAR(64) NULL, `TranHeaderDate` DATETIME(6) NULL, `ContractDate` DATETIME(6) NULL, `ToMofDate` DATETIME(6) NULL, `ToNpDate` DATETIME(6) NULL, `CustomerCopyDate` DATETIME(6) NULL, `ContactDate` DATETIME(6) NULL, `DeliveryDate` DATETIME(6) NULL, `PreparedByAdminDate` DATE NULL, `PreparedByAdminName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `PreparedByAdminUserName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CheckedByAdminDate` DATE NULL, `CheckedByAdminName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CheckedByAdminUserName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CheckedByACDate` DATE NULL, `CheckedByACName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CheckedByACUserName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CRMAuditDate` DATE NULL, `CRMAuditName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CRMAuditUserName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), UNIQUE INDEX `IX_Transactions` (`PRL` ASC, `ContactId` ASC) VISIBLE, CONSTRAINT `FK_Transactions_Contacts` FOREIGN KEY (`ContactId`) REFERENCES `RealEstate`.`Contacts` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `FK_Transactions_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE NO ACTION ON UPDATE CASCADE) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyImages` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Image` LONGBLOB NOT NULL, `Extension` VARCHAR(5) CHARACTER SET 'utf8mb4' NOT NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `ShowOnWebsite` TINYINT(1) NULL, `ShowOnPrint` TINYINT(1) NULL, `ShowAsFirstImage` TINYINT(1) NULL, `ImgDate` DATETIME(6) NULL, `InspCatId` VARCHAR(64) NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertyImages_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Materials` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `Quantity` INT NULL DEFAULT 0, `Price` DOUBLE NULL DEFAULT 0, `MaintenanceWorkId` VARCHAR(64) NOT NULL, PRIMARY KEY (`Id`)) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_UsersInRoles` ( `UserId` VARCHAR(64) NOT NULL, `RoleId` VARCHAR(64) NOT NULL, PRIMARY KEY (`UserId`, `RoleId`), INDEX `aspnet_UsersInRoles_index` (`RoleId` ASC) VISIBLE, CONSTRAINT `FK__aspnet_Us__UserI__36B12243` FOREIGN KEY (`UserId`) REFERENCES `RealEstate`.`aspnet_Users` (`UserId`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK__aspnet_Us__RoleI__37A5467C` FOREIGN KEY (`RoleId`) REFERENCES `RealEstate`.`aspnet_Roles` (`RoleId`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyRelatedFeatures` ( `Id` VARCHAR(64) NOT NULL, `PropertyFeaturesId` VARCHAR(64) NOT NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertyRelatedFeatures_PropertyFeatures` FOREIGN KEY (`PropertyFeaturesId`) REFERENCES `RealEstate`.`PropertyFeatures` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_PropertyRelatedFeatures_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Priority` ( `Id` INT NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`AuditTrail` ( `ID` VARCHAR(64) NOT NULL, `Table` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Column` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `RowID` TEXT(8016) NULL, `ChangeDate` DATETIME(6) NULL, `ChangedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `OldValue` TEXT(8016) NULL, `NewValue` TEXT(8016) NULL, INDEX `ClusteredIndex-20151026-095105` (`Table` ASC, `Column` ASC, `RowID`(255) ASC, `ChangeDate` ASC) VISIBLE) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertySituation` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_CostCategory` ( `Id` INT NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyRent` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `DateFrom` DATETIME(6) NULL, `DateTo` DATETIME(6) NULL, `Price` DECIMAL(16,2) NULL, `ContactId` VARCHAR(64) NULL, `ContractTypeId` INT NULL, `Notice` INT NULL, `TotalPricePerRent` DECIMAL(16,2) NULL, `Paid` TINYINT(1) NULL, `PaidDate` DATETIME(6) NULL, `PaidPrice` DECIMAL(16,2) NULL, `Remaining` DECIMAL(16,2) NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertyRent_LKUP_ContractType` FOREIGN KEY (`ContractTypeId`) REFERENCES `RealEstate`.`LKUP_ContractType` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_PropertyRent_Contacts` FOREIGN KEY (`ContactId`) REFERENCES `RealEstate`.`Contacts` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_PropertyRent_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_TranConditions` ( `Id` INT NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `Project` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `TranConDate` DATETIME(6) NULL, PRIMARY KEY (`Id`)) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`DictionaryTable` ( `Id` VARCHAR(250) CHARACTER SET 'utf8mb4' NOT NULL, `English` VARCHAR(250) CHARACTER SET 'utf8mb4' NULL, `French` VARCHAR(250) CHARACTER SET 'utf8mb4' NULL, `Arabic` VARCHAR(250) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`RequestComments` ( `Id` VARCHAR(64) NOT NULL, `RequestId` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `DateAdd` DATETIME(6) NULL, `DateModified` DATETIME(6) NULL, `AgentId` VARCHAR(64) NOT NULL, `Comments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ContactType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`CallSheet` ( `Id` VARCHAR(64) NOT NULL, `CallerName` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `PhoneNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `Email` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CallDateTime` DATETIME(6) NOT NULL, `AgentId` VARCHAR(64) NULL, `DepartmentId` VARCHAR(64) NOT NULL, `Comments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Answered` TINYINT(1) NOT NULL DEFAULT 0, `ClientTypeId` INT NOT NULL, `CallSheetTypeId` INT NULL, `Priority` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CreationDate` DATETIME(6) NULL, `CreatedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ModifiedDate` DATETIME(6) NULL, `ModifiedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SizeFrom` DECIMAL(9,2) NULL, `SizeTo` DECIMAL(9,2) NULL, `SalePriceFrom` INT NULL, `SalePriceTo` INT NULL, `TotalBedRoomFrom` INT NULL, `TotalBedRoomTo` INT NULL, `RentPriceFrom` INT NULL, `RentPriceTo` INT NULL, `ExportToRequest` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `ContactId` VARCHAR(64) NULL, `PropertyTypeId` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `PropertyForId` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `Address` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ReferencedBy` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `MediaCompanyId` VARCHAR(64) NULL, `BuildingName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `NbrRequests` INT NULL DEFAULT 0, `NbrProperties` INT NULL DEFAULT 0, `NbrCalls` INT NULL DEFAULT 0, `NbrShowings` INT NULL DEFAULT 0, `NbrSurveys` INT NULL, `NbrMeetings` INT NULL, `SmsSent` TINYINT(1) NULL, `IdCardNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `PayMethod` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `MasterBedRoomFrom` INT NULL, `MasterBedRoomTo` INT NULL, `ReferralId` INT NULL, `ClientNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ChkCurrencyPrice` TINYINT(1) NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_CallSheet_Department` FOREIGN KEY (`DepartmentId`) REFERENCES `RealEstate`.`Department` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_CallSheet_LKUP_ClientType` FOREIGN KEY (`ClientTypeId`) REFERENCES `RealEstate`.`LKUP_ClientType` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_CallSheet_LKUP_CallSheetType` FOREIGN KEY (`CallSheetTypeId`) REFERENCES `RealEstate`.`LKUP_CallSheetType` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `FK_CallSheet_Contacts` FOREIGN KEY (`ContactId`) REFERENCES `RealEstate`.`Contacts` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Permissions` ( `PageID` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `UserName` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `Permissions` VARCHAR(6) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`PageID`, `UserName`)) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_RoomStructure` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Country` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_RoomSpecifications` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_MediaCompanyType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyRoomsFeatures` ( `Id` VARCHAR(64) NOT NULL, `RoomStructureId` INT NULL, `PropertyRoomsId` VARCHAR(64) NULL, `RoomSpecificationsId` INT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertyRoomsFeatures_LKUP_RoomSpecificaions` FOREIGN KEY (`RoomSpecificationsId`) REFERENCES `RealEstate`.`LKUP_RoomSpecifications` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_PropertyRoomsFeatures_LKUP_RoomStructure` FOREIGN KEY (`RoomStructureId`) REFERENCES `RealEstate`.`LKUP_RoomStructure` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_PropertyRoomsFeatures_PropertyRooms` FOREIGN KEY (`PropertyRoomsId`) REFERENCES `RealEstate`.`PropertyRooms` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_Paths` ( `ApplicationId` VARCHAR(64) NOT NULL, `PathId` VARCHAR(64) NOT NULL, `Path` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `LoweredPath` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, UNIQUE INDEX `aspnet_Paths_index` (`ApplicationId` ASC, `LoweredPath`(255) ASC) VISIBLE, PRIMARY KEY (`PathId`), CONSTRAINT `FK__aspnet_Pa__Appli__45F365D3` FOREIGN KEY (`ApplicationId`) REFERENCES `RealEstate`.`aspnet_Applications` (`ApplicationId`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_TranFollowUp` ( `Id` INT NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `Project` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `TranFollowUpDate` DATETIME(6) NULL, PRIMARY KEY (`Id`)) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NewsletterTemplates` ( `ID` VARCHAR(64) NOT NULL, `Name` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `HtmlMain` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `HtmlProperty` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `HtmlImage` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `type` INT NULL, PRIMARY KEY (`ID`)) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`CallSheetLocation` ( `Id` VARCHAR(64) NOT NULL, `CallSheetId` VARCHAR(64) NOT NULL, `CountryId` INT NULL, `QadaaId` INT NOT NULL, `DistrictId` INT NULL, `NeighborhoodId` INT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_CallSheetLocation_CallSheet` FOREIGN KEY (`CallSheetId`) REFERENCES `RealEstate`.`CallSheet` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertySizes` ( `Id` VARCHAR(64) NOT NULL, `LKUP_PropertySizesId` INT NULL, `Count` INT NULL, `Surface` DECIMAL(10,2) NULL, `Length` DECIMAL(10,2) NULL, `Width` DECIMAL(10,2) NULL, `Height` DECIMAL(10,2) NULL, `Unit` VARCHAR(1) CHARACTER SET 'utf8mb4' NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `DividePer` SMALLINT NULL, `DoNotApplyDisc` TINYINT(1) NULL, `Price` INT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertySizes_LKUP_PropertySizes` FOREIGN KEY (`LKUP_PropertySizesId`) REFERENCES `RealEstate`.`LKUP_PropertySizes` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`CampaignEmails` ( `Sent` TINYINT(1) NULL DEFAULT 0, `CampaignID` VARCHAR(64) NULL, `Email` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, CONSTRAINT `FK_CampaignEmails_Campaigns` FOREIGN KEY (`CampaignID`) REFERENCES `RealEstate`.`Campaigns` (`ID`) ON DELETE CASCADE ON UPDATE NO ACTION) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ContactDocuments` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Documents` LONGBLOB NOT NULL, `DocumentName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Extension` VARCHAR(5) NOT NULL, `ContactId` VARCHAR(64) NOT NULL, `DateUploaded` DATETIME(6) NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_ContactDocuments_Contacts` FOREIGN KEY (`ContactId`) REFERENCES `RealEstate`.`Contacts` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_PersonalizationAllUsers` ( `PathId` VARCHAR(64) NOT NULL, `PageSettings` LONGBLOB NOT NULL, `LastUpdatedDate` DATETIME(6) NOT NULL, PRIMARY KEY (`PathId`), CONSTRAINT `FK__aspnet_Pe__PathI__4BAC3F29` FOREIGN KEY (`PathId`) REFERENCES `RealEstate`.`aspnet_Paths` (`PathId`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Campaigns` ( `ID` VARCHAR(64) NOT NULL, `Name` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `DateCreated` DATETIME(6) NULL, `DateSent` DATETIME(6) NULL, `TemplateID` VARCHAR(64) NULL, `PRLs` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SentHTML` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Content` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CType` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`ID`)) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Publicities` ( `Id` VARCHAR(64) NOT NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `DateStart` DATETIME(6) NULL, `DateEnd` DATETIME(6) NULL, `MediaCompanyId` VARCHAR(64) NULL, `Reference` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Price` DECIMAL(16,2) NULL, `NumberOfReturnedCalls` INT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_Publicities_MediaCompany` FOREIGN KEY (`MediaCompanyId`) REFERENCES `RealEstate`.`MediaCompany` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_Publicities_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_PersonalizationPerUser` ( `Id` VARCHAR(64) NOT NULL, `PathId` VARCHAR(64) NULL, `UserId` VARCHAR(64) NULL, `PageSettings` LONGBLOB NOT NULL, `LastUpdatedDate` DATETIME(6) NOT NULL, UNIQUE INDEX `aspnet_PersonalizationPerUser_index1` (`PathId` ASC, `UserId` ASC) VISIBLE, PRIMARY KEY (`Id`), UNIQUE INDEX `aspnet_PersonalizationPerUser_ncindex2` (`UserId` ASC, `PathId` ASC) VISIBLE, CONSTRAINT `FK__aspnet_Pe__PathI__4F7CD00D` FOREIGN KEY (`PathId`) REFERENCES `RealEstate`.`aspnet_Paths` (`PathId`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK__aspnet_Pe__UserI__5070F446` FOREIGN KEY (`UserId`) REFERENCES `RealEstate`.`aspnet_Users` (`UserId`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertyGeographic` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Project` ( `Prl` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `Name` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Logo` LONGBLOB NULL, `Footer` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SequenceType` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SequenceNum` INT NULL DEFAULT 0, `ContractTemplate` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Prl`)) 10:22:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`GoogleCalendar` ( `Id` VARCHAR(64) NOT NULL, `DepartmentId` VARCHAR(64) NOT NULL, `CalendarId` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `Agents` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CalendarName` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_InspectionArea` ( `ID` INT NOT NULL, `Area` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `TypeOrder` INT NULL, PRIMARY KEY (`ID`)) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_StatusReason` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_BLOB_TRIGGERS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `BLOB_DATA` LONGBLOB NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Job_Title` ( `ID` VARCHAR(64) NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`ID`)) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_CALENDARS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `CALENDAR_NAME` VARCHAR(200) CHARACTER SET 'utf8mb4' NOT NULL, `CALENDAR` LONGBLOB NOT NULL, PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`)) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_CallSheetType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_LKUP_CallSheetType_LKUP_CallSheetType` FOREIGN KEY (`Id`) REFERENCES `RealEstate`.`LKUP_CallSheetType` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:19 [WRN][ grt]: Error executing 'CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_CallSheetType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_LKUP_CallSheetType_LKUP_CallSheetType` FOREIGN KEY (`Id`) REFERENCES `RealEstate`.`LKUP_CallSheetType` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION)' Failed to add the foreign key constraint. Missing index for constraint 'FK_LKUP_CallSheetType_LKUP_CallSheetType' in the referenced table 'lkup_callsheettype'. SQL Error: 1822 10:22:19 [ERR][ DbMySQLFE]: Exception executing 'CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_CallSheetType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_LKUP_CallSheetType_LKUP_CallSheetType` FOREIGN KEY (`Id`) REFERENCES `RealEstate`.`LKUP_CallSheetType` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION)': Error executing 'CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_CallSheetType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_LKUP_CallSheetType_LKUP_CallSheetType` FOREIGN KEY (`Id`) REFERENCES `RealEstate`.`LKUP_CallSheetType` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION)' Failed to add the foreign key constraint. Missing index for constraint 'FK_LKUP_CallSheetType_LKUP_CallSheetType' in the referenced table 'lkup_callsheettype'. SQL Error: 1822 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PorpertyActionsType` ( `Id` INT NOT NULL, `Description` CHAR(10) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_CRON_TRIGGERS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `CRON_EXPRESSION` VARCHAR(120) CHARACTER SET 'utf8mb4' NOT NULL, `TIME_ZONE_ID` VARCHAR(80) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`), CONSTRAINT `FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS` FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`) REFERENCES `RealEstate`.`QRTZ_TRIGGERS` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`) ON DELETE CASCADE ON UPDATE NO ACTION) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_FIRED_TRIGGERS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `ENTRY_ID` VARCHAR(95) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `INSTANCE_NAME` VARCHAR(200) CHARACTER SET 'utf8mb4' NOT NULL, `FIRED_TIME` BIGINT NOT NULL, `SCHED_TIME` BIGINT NOT NULL, `PRIORITY` INT NOT NULL, `STATE` VARCHAR(16) CHARACTER SET 'utf8mb4' NOT NULL, `JOB_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `JOB_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `IS_NONCONCURRENT` TINYINT(1) NULL, `REQUESTS_RECOVERY` TINYINT(1) NULL, PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`)) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Property` ( `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `OldPRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `CountryId` INT NULL, `QadaaId` INT NULL, `DistrictId` INT NULL, `NeighborhoodId` INT NULL, `ContactId` VARCHAR(64) NULL, `StreetName` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Directions` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Size` DECIMAL(9,2) NULL, `SizeDescription` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Floor` INT NULL, `FloorDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Receptions` INT NULL, `ReceptionsDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `TotalBedrooms` INT NULL, `TotalBedroomsDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Bathrooms` INT NULL, `BathroomsDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `GuestBathroom` INT NULL, `GuestBathroomDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `DriverRoom` INT NULL, `DriverRoomDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `MaidRoom` INT NULL, `MaidRoomDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `StorageRoom` INT NULL, `StorageRoomDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Age` INT NULL, `PropertyForId` INT NULL, `Lot_Unit_Nbr` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Exclusive` TINYINT(1) NULL, `ExclusiveDescription` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `StartDate` DATETIME(6) NULL, `EndDate` DATETIME(6) NULL, `QualityId` INT NULL, `TotalFloor` INT NULL, `TotalFloorDescription` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `FamilyRoom` INT NULL, `FamilyRoomDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `MasterBedRooms` INT NULL, `MasterBedRoomsDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Parkings` INT NULL, `ParkingDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `RentPrice` INT NULL DEFAULT 0, `SalePrice` INT NULL DEFAULT 0, `BldChargesPerMonth` INT NULL, `AdditionalInformation` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Web_GuideDescription` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `PreviousReferedAgentId` VARCHAR(64) NULL, `CurrentReferedAgentId` VARCHAR(64) NULL, `PreviousReassignedAgentId` VARCHAR(64) NULL, `CurrentReassignedAgentId` VARCHAR(64) NULL, `PreviousAgentInformation` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CurrentAgentInformation` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `LegalOwnerId` VARCHAR(64) NULL, `PropertyTypeId` INT NULL, `Active` TINYINT(1) NULL DEFAULT 0, `Pending` TINYINT(1) NULL DEFAULT 1, `Closed` TINYINT(1) NULL DEFAULT 0, `DepartmentId` VARCHAR(64) NOT NULL, `Facades` INT NULL DEFAULT 0, `SurfaceCoefficient` INT NULL DEFAULT 0, `TotalCoefficient` INT NULL DEFAULT 0, `TotalHeight` INT NULL DEFAULT 0, `Zone` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CompletionDate` DATETIME(6) NULL, `Completed` TINYINT(1) NULL, `SellingDate` DATETIME(6) NULL, `SellingPrice` BIGINT NULL, `PropertyStateId` INT NULL, `CreationDate` DATETIME(6) NULL, `CreatedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ModifiedDate` DATETIME(6) NULL, `ModifiedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PercCommission` DECIMAL(5,2) NULL, `FixedCommission` DECIMAL(16,2) NULL, `CommissionDue` DECIMAL(16,2) NULL, `CommissionNotes` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `PropertyViewId` INT NULL, `MinimumPrice` DECIMAL(16,2) NULL, `PropertyDeed` TINYINT(1) NULL, `Zoning` TINYINT(1) NULL, `SiteMap` TINYINT(1) NULL, `BuildingName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `AppartmentFloor` INT NULL, `PropertySituatedId` INT NULL, `PricePer` DECIMAL(16,2) NULL, `PropertyGeographicId` INT NULL, `PropertyAvailabilityId` INT NULL, `MaxHorizontalExp` DECIMAL(5,2) NULL, `MaxTotalExp` DECIMAL(5,2) NULL, `MaxHorizontalAreaPerFloor` DECIMAL(18,2) NULL, `MaxHorizontalAreaForBalconyPerc` DECIMAL(5,2) NULL, `MaxHorizontalAreaForBalconyAmount` DECIMAL(18,2) NULL, `TotalConstructionPerFloor` DECIMAL(18,2) NULL, `TotalConstructionPerFloorAccordingToLaw` DECIMAL(18,2) NULL, `MaxOverGroundExp` DECIMAL(5,2) NULL, `MaxOverGroundExpBalconyPerc` DECIMAL(5,2) NULL, `MaxOverGroundExpBalconyAmount` DECIMAL(18,2) NULL, `MaxOverGroundExpAmount` DECIMAL(18,2) NULL, `BuiltUpArea` DECIMAL(18,2) NULL, `TotalBuiltUpArea` DECIMAL(18,2) NULL, `AccordingToLawPerc` DECIMAL(5,2) NULL, `AccordingToLawAmount` DECIMAL(18,2) NULL, `CostPrice` DECIMAL(18,2) NULL, `BuiltUpPricePer` DECIMAL(16,2) NULL, `CornerPerc` DECIMAL(5,2) NULL, `LandZoningId` VARCHAR(64) NULL, `SoldByOthers` TINYINT(1) NULL, `DiningRoom` INT NULL, `DiningRoomDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Kitchen` INT NULL, `KitchenDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `DressingRoom` INT NULL, `DressingRoomDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `TotalRooms` INT NULL, `TotalRoomsDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `MaidBathRoom` INT NULL, `MaidBathRoomDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `AdditionalPricePerFloor` DECIMAL(16,2) NULL, `KeyDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Promote` TINYINT(1) NULL, `PrintGeneralInfo` TINYINT(1) NULL, `PrintAdditionalInfo` TINYINT(1) NULL, `TruncatedSize` INT NULL, `TenantsCost` DECIMAL(16,2) NULL, `CommercialBUA` TINYINT(1) NULL, `MinResidentialSQMPrice` DECIMAL(16,2) NULL, `MaxResidentialSQMPrice` DECIMAL(16,2) NULL, `ConstructionCostPerSQM` DECIMAL(16,2) NULL, `FolderToBrowse` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Longitude` DECIMAL(18,5) NULL DEFAULT 0, `Latitude` DECIMAL(18,5) NULL DEFAULT 0, `FacebookPostId` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `FacebookAlbumId` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `uploadedtowebsite` TINYINT(1) NULL, `ParentPrl` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `discount` DECIMAL(12,3) NULL, `Rounding` BIGINT NULL, `ReservationDate` DATETIME(6) NULL, `StatusReasonId` INT NULL, `SmsText` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Ordering` INT NULL DEFAULT 0, `Charges` TINYINT(1) NULL, `ChargeInclude` TINYINT(1) NULL, `UploadedToMLS` TINYINT(1) NULL, `ChooseAction` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Amount` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `PropDismiss` TINYINT(1) NULL, `HotDeal` TINYINT(1) NULL, `BankerCheck` TINYINT(1) NULL, `ChkCurrencyPrice` TINYINT(1) NULL, `CadastralSection` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `bankerPercentage` INT NULL, `BankerSale` DECIMAL(16,2) NULL, `CheckOnly` TINYINT(1) NULL, PRIMARY KEY (`PRL`), CONSTRAINT `FK_Property_Department` FOREIGN KEY (`DepartmentId`) REFERENCES `RealEstate`.`Department` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_LKUP_Country` FOREIGN KEY (`CountryId`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_LKUP_PropertyAvailability` FOREIGN KEY (`PropertyAvailabilityId`) REFERENCES `RealEstate`.`LKUP_PropertyAvailability` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_LKUP_PropertyGeographic` FOREIGN KEY (`PropertyGeographicId`) REFERENCES `RealEstate`.`LKUP_PropertyGeographic` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_LKUP_PropertySituation` FOREIGN KEY (`PropertySituatedId`) REFERENCES `RealEstate`.`LKUP_PropertySituation` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_LKUP_PropertyState` FOREIGN KEY (`PropertyStateId`) REFERENCES `RealEstate`.`LKUP_PropertyState` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_LKUP_PropertyView` FOREIGN KEY (`PropertyViewId`) REFERENCES `RealEstate`.`LKUP_PropertyView` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_Zoning` FOREIGN KEY (`LandZoningId`) REFERENCES `RealEstate`.`Zoning` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_LKUP_StatusReason` FOREIGN KEY (`StatusReasonId`) REFERENCES `RealEstate`.`LKUP_StatusReason` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_Contacts_Owner` FOREIGN KEY (`LegalOwnerId`) REFERENCES `RealEstate`.`Contacts` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`MediaCompany` ( `Id` VARCHAR(64) NOT NULL, `Name` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Tel1` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Tel2` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Tel3` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `MediaCompanyTypeId` INT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_MediaCompany_LKUP_MediaCompanyType` FOREIGN KEY (`MediaCompanyTypeId`) REFERENCES `RealEstate`.`LKUP_MediaCompanyType` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`sysdiagrams` ( `name` VARCHAR(160) NOT NULL, `principal_id` INT NOT NULL, `diagram_id` INT NOT NULL, `version` INT NULL, `definition` LONGBLOB NULL, PRIMARY KEY (`diagram_id`), UNIQUE INDEX `UK_principal_name` (`principal_id` ASC, `name` ASC) VISIBLE) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Contacts` ( `Id` VARCHAR(64) NOT NULL, `FName` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `MName` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `LName` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `PreviousAgentId` VARCHAR(64) NULL, `CurrentAgentId` VARCHAR(64) NULL, `ClientTypeId` INT NULL, `MobileNumber` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `HomePhone` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `OfficePhone` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `FaxNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Address` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Email` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ContactPersonName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `ContactPersonEmail` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ContactPersonNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Enabled` TINYINT(1) NULL DEFAULT 1, `DepartmentId` VARCHAR(64) NOT NULL, `EntryDate` DATETIME(6) NULL, `HusbandCompanyName` VARCHAR(400) CHARACTER SET 'utf8mb4' NULL, `HusbandCompanyAddress` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `HusbandCareer` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `HusbandDateOfBirth` DATETIME(6) NULL, `HusbandPlaceOfBirth` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `SpouseCareer` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseCompanyName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseCompanyAddress` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `SpuseCompanyPhone` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseMobile` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseDateOfBirth` DATETIME(6) NULL, `SpousePlaceOfBirth` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `BelongToClub` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CommunityActive` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `FavoritePlaceForLunch` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `FavoritePlaceForDinner` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `EntertainmentSpaces` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `WeddingAnniversary` DATETIME(6) NULL, `IsPlatinum` TINYINT(1) NULL, `ContactTypeId` INT NULL, `Title` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Salutation` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Gender` VARCHAR(1) CHARACTER SET 'utf8mb4' NULL, `ModifiedDate` DATETIME(6) NULL, `ModifiedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CreatedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PassportNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `IdCardNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `NationalityId` INT NULL, `Notes` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ReferencedBy` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Website` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ConId` INT NOT NULL, `MofReg` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Vat` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CompanyCity` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `CompanyPostalCode` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `CompanyIndustry` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `ManagementLevel` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `AppPassword` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CountryOfResidenceID` INT NULL, `CompanyCountryID` INT NULL, `NbrRequests` INT NULL DEFAULT 0, `NbrProperties` INT NULL DEFAULT 0, `NbrCalls` INT NULL DEFAULT 0, `NbrSurveys` INT NULL, `NbrMeetings` INT NULL DEFAULT 0, `NbrShowings` INT NULL DEFAULT 0, `ParentContactId` VARCHAR(64) NULL, `vvip` TINYINT(1) NULL, `SendSms` TINYINT(1) NULL, `ProfilePic` LONGBLOB NULL, `RecNum` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `Meeting` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SalaryRangeId` VARCHAR(64) NULL, `StateId` VARCHAR(64) NULL, `ClientNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ConDismiss` TINYINT(1) NULL, PRIMARY KEY (`Id`), UNIQUE INDEX `IX_Contacts` (`FName` ASC, `MName`(255) ASC, `LName`(255) ASC, `MobileNumber`(255) ASC) VISIBLE, INDEX `IX_Contacts_1` (`EntryDate` ASC) VISIBLE, INDEX `IX_Contacts_2` (`ModifiedDate` ASC) VISIBLE, CONSTRAINT `FK_Contacts_Department` FOREIGN KEY (`DepartmentId`) REFERENCES `RealEstate`.`Department` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Contacts_LKUP_Country1` FOREIGN KEY (`CountryOfResidenceID`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Contacts_LKUP_Country2` FOREIGN KEY (`CompanyCountryID`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Contacts_LKUP_ClientType` FOREIGN KEY (`ClientTypeId`) REFERENCES `RealEstate`.`LKUP_ClientType` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `FK_Contacts_LKUP_ContactType` FOREIGN KEY (`ContactTypeId`) REFERENCES `RealEstate`.`LKUP_ContactType` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `FK_Contacts_LKUP_Country` FOREIGN KEY (`NationalityId`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE) 10:22:19 [WRN][ grt]: Error executing 'CREATE TABLE IF NOT EXISTS `RealEstate`.`Contacts` ( `Id` VARCHAR(64) NOT NULL, `FName` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `MName` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `LName` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `PreviousAgentId` VARCHAR(64) NULL, `CurrentAgentId` VARCHAR(64) NULL, `ClientTypeId` INT NULL, `MobileNumber` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `HomePhone` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `OfficePhone` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `FaxNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Address` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Email` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ContactPersonName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `ContactPersonEmail` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ContactPersonNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Enabled` TINYINT(1) NULL DEFAULT 1, `DepartmentId` VARCHAR(64) NOT NULL, `EntryDate` DATETIME(6) NULL, `HusbandCompanyName` VARCHAR(400) CHARACTER SET 'utf8mb4' NULL, `HusbandCompanyAddress` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `HusbandCareer` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `HusbandDateOfBirth` DATETIME(6) NULL, `HusbandPlaceOfBirth` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `SpouseCareer` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseCompanyName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseCompanyAddress` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `SpuseCompanyPhone` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseMobile` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseDateOfBirth` DATETIME(6) NULL, `SpousePlaceOfBirth` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `BelongToClub` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CommunityActive` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `FavoritePlaceForLunch` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `FavoritePlaceForDinner` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `EntertainmentSpaces` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `WeddingAnniversary` DATETIME(6) NULL, `IsPlatinum` TINYINT(1) NULL, `ContactTypeId` INT NULL, `Title` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Salutation` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Gender` VARCHAR(1) CHARACTER SET 'utf8mb4' NULL, `ModifiedDate` DATETIME(6) NULL, `ModifiedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CreatedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PassportNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `IdCardNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `NationalityId` INT NULL, `Notes` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ReferencedBy` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Website` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ConId` INT NOT NULL, `MofReg` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Vat` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CompanyCity` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `CompanyPostalCode` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `CompanyIndustry` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `ManagementLevel` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `AppPassword` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CountryOfResidenceID` INT NULL, `CompanyCountryID` INT NULL, `NbrRequests` INT NULL DEFAULT 0, `NbrProperties` INT NULL DEFAULT 0, `NbrCalls` INT NULL DEFAULT 0, `NbrSurveys` INT NULL, `NbrMeetings` INT NULL DEFAULT 0, `NbrShowings` INT NULL DEFAULT 0, `ParentContactId` VARCHAR(64) NULL, `vvip` TINYINT(1) NULL, `SendSms` TINYINT(1) NULL, `ProfilePic` LONGBLOB NULL, `RecNum` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `Meeting` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SalaryRangeId` VARCHAR(64) NULL, `StateId` VARCHAR(64) NULL, `ClientNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ConDismiss` TINYINT(1) NULL, PRIMARY KEY (`Id`), UNIQUE INDEX `IX_Contacts` (`FName` ASC, `MName`(255) ASC, `LName`(255) ASC, `MobileNumber`(255) ASC) VISIBLE, INDEX `IX_Contacts_1` (`EntryDate` ASC) VISIBLE, INDEX `IX_Contacts_2` (`ModifiedDate` ASC) VISIBLE, CONSTRAINT `FK_Contacts_Department` FOREIGN KEY (`DepartmentId`) REFERENCES `RealEstate`.`Department` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Contacts_LKUP_Country1` FOREIGN KEY (`CountryOfResidenceID`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Contacts_LKUP_Country2` FOREIGN KEY (`CompanyCountryID`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Contacts_LKUP_ClientType` FOREIGN KEY (`ClientTypeId`) REFERENCES `RealEstate`.`LKUP_ClientType` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `FK_Contacts_LKUP_ContactType` FOREIGN KEY (`ContactTypeId`) REFERENCES `RealEstate`.`LKUP_ContactType` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `FK_Contacts_LKUP_Country` FOREIGN KEY (`NationalityId`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE)' Specified key was too long; max key length is 3072 bytes. SQL Error: 1071 10:22:19 [ERR][ DbMySQLFE]: Exception executing 'CREATE TABLE IF NOT EXISTS `RealEstate`.`Contacts` ( `Id` VARCHAR(64) NOT NULL, `FName` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `MName` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `LName` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `PreviousAgentId` VARCHAR(64) NULL, `CurrentAgentId` VARCHAR(64) NULL, `ClientTypeId` INT NULL, `MobileNumber` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `HomePhone` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `OfficePhone` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `FaxNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Address` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Email` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ContactPersonName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `ContactPersonEmail` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ContactPersonNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Enabled` TINYINT(1) NULL DEFAULT 1, `DepartmentId` VARCHAR(64) NOT NULL, `EntryDate` DATETIME(6) NULL, `HusbandCompanyName` VARCHAR(400) CHARACTER SET 'utf8mb4' NULL, `HusbandCompanyAddress` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `HusbandCareer` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `HusbandDateOfBirth` DATETIME(6) NULL, `HusbandPlaceOfBirth` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `SpouseCareer` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseCompanyName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseCompanyAddress` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `SpuseCompanyPhone` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseMobile` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseDateOfBirth` DATETIME(6) NULL, `SpousePlaceOfBirth` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `BelongToClub` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CommunityActive` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `FavoritePlaceForLunch` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `FavoritePlaceForDinner` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `EntertainmentSpaces` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `WeddingAnniversary` DATETIME(6) NULL, `IsPlatinum` TINYINT(1) NULL, `ContactTypeId` INT NULL, `Title` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Salutation` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Gender` VARCHAR(1) CHARACTER SET 'utf8mb4' NULL, `ModifiedDate` DATETIME(6) NULL, `ModifiedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CreatedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PassportNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `IdCardNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `NationalityId` INT NULL, `Notes` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ReferencedBy` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Website` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ConId` INT NOT NULL, `MofReg` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Vat` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CompanyCity` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `CompanyPostalCode` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `CompanyIndustry` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `ManagementLevel` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `AppPassword` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CountryOfResidenceID` INT NULL, `CompanyCountryID` INT NULL, `NbrRequests` INT NULL DEFAULT 0, `NbrProperties` INT NULL DEFAULT 0, `NbrCalls` INT NULL DEFAULT 0, `NbrSurveys` INT NULL, `NbrMeetings` INT NULL DEFAULT 0, `NbrShowings` INT NULL DEFAULT 0, `ParentContactId` VARCHAR(64) NULL, `vvip` TINYINT(1) NULL, `SendSms` TINYINT(1) NULL, `ProfilePic` LONGBLOB NULL, `RecNum` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `Meeting` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SalaryRangeId` VARCHAR(64) NULL, `StateId` VARCHAR(64) NULL, `ClientNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ConDismiss` TINYINT(1) NULL, PRIMARY KEY (`Id`), UNIQUE INDEX `IX_Contacts` (`FName` ASC, `MName`(255) ASC, `LName`(255) ASC, `MobileNumber`(255) ASC) VISIBLE, INDEX `IX_Contacts_1` (`EntryDate` ASC) VISIBLE, INDEX `IX_Contacts_2` (`ModifiedDate` ASC) VISIBLE, CONSTRAINT `FK_Contacts_Department` FOREIGN KEY (`DepartmentId`) REFERENCES `RealEstate`.`Department` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Contacts_LKUP_Country1` FOREIGN KEY (`CountryOfResidenceID`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Contacts_LKUP_Country2` FOREIGN KEY (`CompanyCountryID`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Contacts_LKUP_ClientType` FOREIGN KEY (`ClientTypeId`) REFERENCES `RealEstate`.`LKUP_ClientType` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `FK_Contacts_LKUP_ContactType` FOREIGN KEY (`ContactTypeId`) REFERENCES `RealEstate`.`LKUP_ContactType` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `FK_Contacts_LKUP_Country` FOREIGN KEY (`NationalityId`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE)': Error executing 'CREATE TABLE IF NOT EXISTS `RealEstate`.`Contacts` ( `Id` VARCHAR(64) NOT NULL, `FName` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `MName` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `LName` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `PreviousAgentId` VARCHAR(64) NULL, `CurrentAgentId` VARCHAR(64) NULL, `ClientTypeId` INT NULL, `MobileNumber` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `HomePhone` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `OfficePhone` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `FaxNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Address` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Email` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ContactPersonName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `ContactPersonEmail` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ContactPersonNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Enabled` TINYINT(1) NULL DEFAULT 1, `DepartmentId` VARCHAR(64) NOT NULL, `EntryDate` DATETIME(6) NULL, `HusbandCompanyName` VARCHAR(400) CHARACTER SET 'utf8mb4' NULL, `HusbandCompanyAddress` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `HusbandCareer` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `HusbandDateOfBirth` DATETIME(6) NULL, `HusbandPlaceOfBirth` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `SpouseCareer` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseCompanyName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseCompanyAddress` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `SpuseCompanyPhone` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseMobile` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseDateOfBirth` DATETIME(6) NULL, `SpousePlaceOfBirth` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `BelongToClub` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CommunityActive` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `FavoritePlaceForLunch` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `FavoritePlaceForDinner` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `EntertainmentSpaces` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `WeddingAnniversary` DATETIME(6) NULL, `IsPlatinum` TINYINT(1) NULL, `ContactTypeId` INT NULL, `Title` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Salutation` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Gender` VARCHAR(1) CHARACTER SET 'utf8mb4' NULL, `ModifiedDate` DATETIME(6) NULL, `ModifiedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CreatedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PassportNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `IdCardNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `NationalityId` INT NULL, `Notes` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ReferencedBy` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Website` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ConId` INT NOT NULL, `MofReg` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Vat` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CompanyCity` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `CompanyPostalCode` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `CompanyIndustry` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `ManagementLevel` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `AppPassword` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CountryOfResidenceID` INT NULL, `CompanyCountryID` INT NULL, `NbrRequests` INT NULL DEFAULT 0, `NbrProperties` INT NULL DEFAULT 0, `NbrCalls` INT NULL DEFAULT 0, `NbrSurveys` INT NULL, `NbrMeetings` INT NULL DEFAULT 0, `NbrShowings` INT NULL DEFAULT 0, `ParentContactId` VARCHAR(64) NULL, `vvip` TINYINT(1) NULL, `SendSms` TINYINT(1) NULL, `ProfilePic` LONGBLOB NULL, `RecNum` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `Meeting` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SalaryRangeId` VARCHAR(64) NULL, `StateId` VARCHAR(64) NULL, `ClientNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ConDismiss` TINYINT(1) NULL, PRIMARY KEY (`Id`), UNIQUE INDEX `IX_Contacts` (`FName` ASC, `MName`(255) ASC, `LName`(255) ASC, `MobileNumber`(255) ASC) VISIBLE, INDEX `IX_Contacts_1` (`EntryDate` ASC) VISIBLE, INDEX `IX_Contacts_2` (`ModifiedDate` ASC) VISIBLE, CONSTRAINT `FK_Contacts_Department` FOREIGN KEY (`DepartmentId`) REFERENCES `RealEstate`.`Department` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Contacts_LKUP_Country1` FOREIGN KEY (`CountryOfResidenceID`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Contacts_LKUP_Country2` FOREIGN KEY (`CompanyCountryID`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Contacts_LKUP_ClientType` FOREIGN KEY (`ClientTypeId`) REFERENCES `RealEstate`.`LKUP_ClientType` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `FK_Contacts_LKUP_ContactType` FOREIGN KEY (`ContactTypeId`) REFERENCES `RealEstate`.`LKUP_ContactType` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `FK_Contacts_LKUP_Country` FOREIGN KEY (`NationalityId`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE)' Specified key was too long; max key length is 3072 bytes. SQL Error: 1071 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_JOB_DETAILS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `JOB_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `JOB_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `DESCRIPTION` VARCHAR(250) CHARACTER SET 'utf8mb4' NULL, `JOB_CLASS_NAME` VARCHAR(250) CHARACTER SET 'utf8mb4' NOT NULL, `IS_DURABLE` TINYINT(1) NOT NULL, `IS_NONCONCURRENT` TINYINT(1) NOT NULL, `IS_UPDATE_DATA` TINYINT(1) NOT NULL, `REQUESTS_RECOVERY` TINYINT(1) NOT NULL, `JOB_DATA` LONGBLOB NULL, PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PermissionJobTitle` ( `PageID` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `JobTitle` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `Permissions` VARCHAR(6) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`PageID`, `JobTitle`)) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_LOCKS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `LOCK_NAME` VARCHAR(40) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`)) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`RequestActions` ( `Id` VARCHAR(64) NOT NULL, `ActionDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `InitiatedBy` VARCHAR(64) NOT NULL, `FromAgentId` VARCHAR(64) NOT NULL, `DestinationAgentId` VARCHAR(64) NOT NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `ApprovedByDestinationAgent` TINYINT(1) NOT NULL DEFAULT 0, `ApprovedDestinationAgentDate` DATETIME(6) NULL, `ApprovedByAdmin` TINYINT(1) NOT NULL DEFAULT 0, `ApprovedAdminDate` DATETIME(6) NULL, `AdminId` VARCHAR(64) NULL, `PropertyActionsTypeId` INT NOT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_RequestActions_Request` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Request` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_RequestActions_LKUP_PorpertyActionsType` FOREIGN KEY (`PropertyActionsTypeId`) REFERENCES `RealEstate`.`LKUP_PorpertyActionsType` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_CostType` ( `Id` INT NOT NULL, `Description` VARCHAR(250) CHARACTER SET 'utf8mb4' NOT NULL, `CostCategoryId` INT NULL, PRIMARY KEY (`Id`)) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_PAUSED_TRIGGER_GRPS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`)) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ContractType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_WebEvent_Events` ( `EventId` CHAR(32) NOT NULL, `EventTimeUtc` DATETIME(6) NOT NULL, `EventTime` DATETIME(6) NOT NULL, `EventType` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `EventSequence` BIGINT NOT NULL, `EventOccurrence` BIGINT NOT NULL, `EventCode` INT NOT NULL, `EventDetailCode` INT NOT NULL, `Message` VARCHAR(1024) CHARACTER SET 'utf8mb4' NULL, `ApplicationPath` VARCHAR(256) CHARACTER SET 'utf8mb4' NULL, `ApplicationVirtualPath` VARCHAR(256) CHARACTER SET 'utf8mb4' NULL, `MachineName` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `RequestUrl` VARCHAR(1024) CHARACTER SET 'utf8mb4' NULL, `ExceptionType` VARCHAR(256) CHARACTER SET 'utf8mb4' NULL, `Details` LONGTEXT NULL, PRIMARY KEY (`EventId`)) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_SCHEDULER_STATE` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `INSTANCE_NAME` VARCHAR(200) CHARACTER SET 'utf8mb4' NOT NULL, `LAST_CHECKIN_TIME` BIGINT NOT NULL, `CHECKIN_INTERVAL` BIGINT NOT NULL, PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`)) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Reminder` ( `Id` VARCHAR(64) NOT NULL, `DepartmentId` VARCHAR(64) NOT NULL, `NatureId` VARCHAR(64) NOT NULL, `StartTime` DATETIME(6) NOT NULL, `EndTime` DATETIME(6) NOT NULL, `Location` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `Comments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Recurrence` VARCHAR(1) NULL, `RecurrenceEnd` DATETIME(6) NULL, `RecurrenceId` VARCHAR(64) NULL, `Agents` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Contacts` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Properties` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Requests` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CallSheets` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Closed` TINYINT(1) NULL, `RelatedId` VARCHAR(64) NULL, `SendReminderSms` TINYINT(1) NULL, `SmsSent` TINYINT(1) NULL, `StatusId` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CloseDate` DATETIME(6) NULL, `SurResponseId` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Feedback` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SyncWithGoogle` TINYINT(1) NULL, `Synced` TINYINT(1) NULL, `SyncDate` DATETIME(6) NULL, `GcId` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Deleted` TINYINT(1) NULL, `Inspection` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Showings` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CreatedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ModifiedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_Reminder_LKUP_ReminderNature` FOREIGN KEY (`NatureId`) REFERENCES `RealEstate`.`LKUP_ReminderNature` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_SIMPLE_TRIGGERS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `REPEAT_COUNT` INT NOT NULL, `REPEAT_INTERVAL` BIGINT NOT NULL, `TIMES_TRIGGERED` INT NOT NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`), CONSTRAINT `FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS` FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`) REFERENCES `RealEstate`.`QRTZ_TRIGGERS` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`) ON DELETE CASCADE ON UPDATE NO ACTION) 10:22:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ExportedProperties` ( `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `ExportedContent` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`PRL`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Grade` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_SIMPROP_TRIGGERS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `STR_PROP_1` VARCHAR(512) CHARACTER SET 'utf8mb4' NULL, `STR_PROP_2` VARCHAR(512) CHARACTER SET 'utf8mb4' NULL, `STR_PROP_3` VARCHAR(512) CHARACTER SET 'utf8mb4' NULL, `INT_PROP_1` INT NULL, `INT_PROP_2` INT NULL, `LONG_PROP_1` BIGINT NULL, `LONG_PROP_2` BIGINT NULL, `DEC_PROP_1` DECIMAL(13,4) NULL, `DEC_PROP_2` DECIMAL(13,4) NULL, `BOOL_PROP_1` TINYINT(1) NULL, `BOOL_PROP_2` TINYINT(1) NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`), CONSTRAINT `FK_QRTZ_SIMPROP_TRIGGERS_QRTZ_TRIGGERS` FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`) REFERENCES `RealEstate`.`QRTZ_TRIGGERS` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`) ON DELETE CASCADE ON UPDATE NO ACTION) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`RequestLocation` ( `Id` VARCHAR(64) NOT NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `CountryId` INT NULL, `QadaaId` INT NOT NULL, `DistrictId` INT NULL, `NeighborhoodId` INT NULL, `LookUpProperty` INT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_RequestLocation_Request` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Request` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ExportToCSV` ( `Id` VARCHAR(64) NOT NULL, `LastImport` DATETIME(6) NULL, `ContactId` VARCHAR(64) NULL, PRIMARY KEY (`Id`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ClientType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Inspection` ( `Id` VARCHAR(64) NOT NULL, `InspectionTypeId` INT NOT NULL, `InspectionLevelId` INT NOT NULL, `Comments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `Date` DATE NOT NULL, `InspectionAreaId` INT NULL, `Deadline` DATE NULL, `EndDate` DATE NULL, PRIMARY KEY (`Id`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_TRIGGERS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `JOB_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `JOB_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `DESCRIPTION` VARCHAR(250) CHARACTER SET 'utf8mb4' NULL, `NEXT_FIRE_TIME` BIGINT NULL, `PREV_FIRE_TIME` BIGINT NULL, `PRIORITY` INT NULL, `TRIGGER_STATE` VARCHAR(16) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_TYPE` VARCHAR(8) CHARACTER SET 'utf8mb4' NOT NULL, `START_TIME` BIGINT NOT NULL, `END_TIME` BIGINT NULL, `CALENDAR_NAME` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `MISFIRE_INSTR` INT NULL, `JOB_DATA` LONGBLOB NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`), CONSTRAINT `FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS` FOREIGN KEY (`SCHED_NAME` , `JOB_NAME` , `JOB_GROUP`) REFERENCES `RealEstate`.`QRTZ_JOB_DETAILS` (`SCHED_NAME` , `JOB_NAME` , `JOB_GROUP`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LogEntries` ( `ID` VARCHAR(64) NOT NULL, `Timestamp` DATETIME(6) NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `Operation` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `AgentID` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`ID`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Level` ( `ID` INT NOT NULL, `Level` CHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `LevelOrder` INT NULL, PRIMARY KEY (`ID`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_District` ( `Id` INT NOT NULL, `QadaaId` INT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_LKUP_District_LKUP_Qadaa` FOREIGN KEY (`QadaaId`) REFERENCES `RealEstate`.`LKUP_Qadaa` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_InspectionType` ( `ID` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `TypeOrder` INT NULL, PRIMARY KEY (`ID`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ViewAgents` ( `UserName` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `Agents` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`UserName`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationCallSheet` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `IDS` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Qadaa` ( `Id` INT NOT NULL, `CountryId` INT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_LKUP_Qadaa_LKUP_Country` FOREIGN KEY (`CountryId`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`GridHead` ( `UserName` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `GridName` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `GridColumns` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`UserName`, `GridName`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Neighborhood` ( `Id` INT NOT NULL, `DistrictId` INT NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_LKUP_Neighborhood_LKUP_District` FOREIGN KEY (`DistrictId`) REFERENCES `RealEstate`.`LKUP_District` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ShowingDocuments` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Documents` LONGBLOB NOT NULL, `DocumentName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Extension` VARCHAR(5) CHARACTER SET 'utf8mb4' NOT NULL, `DocDate` DATETIME(6) NULL, `ShowingId` VARCHAR(64) NULL, PRIMARY KEY (`Id`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationCallSheetMonthly` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `IDS` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `MonthNbr` INT NOT NULL, `Year` INT NOT NULL, PRIMARY KEY (`Id`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`InspectionDetailsCat` ( `id` VARCHAR(64) NOT NULL, `InspId` VARCHAR(64) NOT NULL, `CatId` INT NULL, `Category` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SubCatId` INT NULL, `SubCategory` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `InspectionSubId` INT NULL, `InspectionSubCategory` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `InspOrder` INT NULL, PRIMARY KEY (`id`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Showings` ( `Id` VARCHAR(64) NOT NULL, `ShowingListId` VARCHAR(64) NOT NULL, `PRL` VARCHAR(40) CHARACTER SET 'utf8mb4' NOT NULL, `PropertyDescription` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Price` INT NULL, `BuyerComment` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SmsSent` TINYINT(1) NULL, `OrderPRL` SMALLINT NULL, `ChkHide` TINYINT(1) NULL, PRIMARY KEY (`Id`), UNIQUE INDEX `IX_Showings` (`PRL` ASC, `ShowingListId` ASC) VISIBLE, CONSTRAINT `FK_Showings_ShowingList` FOREIGN KEY (`ShowingListId`) REFERENCES `RealEstate`.`ShowingList` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_Showings_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_InspCategory` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `orderId` INT NULL, PRIMARY KEY (`Id`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationCallSheetWeekly` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `IDS` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `WeekNbr` INT NOT NULL, `Year` INT NOT NULL, PRIMARY KEY (`Id`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_InspectionSub` ( `Id` INT NOT NULL, `SubCatId` INT NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Department` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Location` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PhoneNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `FaxNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CellNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SeqNumber` VARCHAR(2) NULL, `Logo` VARCHAR(400) CHARACTER SET 'utf8mb4' NULL, `Currency` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `AreaUnit` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `TraSubSeqNum` INT NULL, `TraSubSeqType` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `DefaultExtension` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Sur_Survey_Response` ( `ID` INT NOT NULL, `SurveyID` INT NOT NULL, `QuestionID` INT NOT NULL, `Response` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ContactId` VARCHAR(64) NULL, `AgentId` VARCHAR(64) NULL, `RequestId` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `Project` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `ResponseDate` DATETIME(6) NULL, PRIMARY KEY (`ID`), CONSTRAINT `FK_Sur_Survey_Response_Sur_Questions` FOREIGN KEY (`QuestionID`) REFERENCES `RealEstate`.`Sur_Questions` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Sur_Survey_Response_Sur_Surveys` FOREIGN KEY (`SurveyID`) REFERENCES `RealEstate`.`Sur_Surveys` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`SystemVariables` ( `PercentagePerSeniorAgent` TINYINT UNSIGNED NOT NULL DEFAULT 0, `PercentagePerJuniorAgent` TINYINT UNSIGNED NOT NULL DEFAULT 0, `PercentagePerReferral` TINYINT UNSIGNED NOT NULL DEFAULT 0) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Pages` ( `ID` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `Category` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`ID`, `Category`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_InspSubCategory` ( `Id` INT NOT NULL, `CatId` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationExpiredProperties` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `PRL` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationNewRequests` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `PRL` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_CurrentPropertyStatus` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertySizes` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ReminderStatus` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ReminderDocuments` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Documents` LONGBLOB NOT NULL, `DocumentName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Extension` VARCHAR(5) CHARACTER SET 'utf8mb4' NOT NULL, `DocDate` DATETIME(6) NULL, `ReminderId` VARCHAR(64) NULL, PRIMARY KEY (`Id`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Configuration` ( `KeySetting` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `ValueSetting` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Description` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Show` TINYINT(1) NULL, PRIMARY KEY (`KeySetting`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertyView` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertyFor` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`MaintenanceWorkOrder` ( `Id` VARCHAR(64) NOT NULL, `Prl` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `RequestDate` DATETIME(6) NULL, `RequestProjCode` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `RequestById` VARCHAR(64) NULL, `RequestCostCode` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `RequestOrigin` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `RequestClass` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `RequestPriority` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `RequestDestination` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `RequestFacilityLocation` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `RequestFacilityCode` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `RequestWorkDescription` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `RequestSupervisorId` VARCHAR(64) NULL, `RequestProjectManagerId` VARCHAR(64) NULL, `CompletionPlannedStartDate` DATETIME(6) NULL, `CompletionWorkStartDate` DATETIME(6) NULL, `CompletionExpectedDate` DATETIME(6) NULL, `CompletionEndDate` DATETIME(6) NULL, `CompletionDescOfWork` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CompletionWorkPerformedById` VARCHAR(64) NULL, `CompletionSupervisor` VARCHAR(64) NULL, `CompletionProjectManager` VARCHAR(64) NULL, PRIMARY KEY (`Id`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`SmsPack` ( `Id` VARCHAR(64) NOT NULL, `SmsAvailable` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `SmsSent` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `DateFrom` DATE NULL, `DateTo` DATE NULL, PRIMARY KEY (`Id`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationPendingProperties` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `PRL` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ViewState` ( `ViewStateId` VARCHAR(64) NOT NULL, `Value` LONGBLOB NOT NULL, `LastAccessed` DATETIME(6) NOT NULL, `Timeout` INT NOT NULL, PRIMARY KEY (`ViewStateId`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_Applications` ( `ApplicationName` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `LoweredApplicationName` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `ApplicationId` VARCHAR(64) NOT NULL, `Description` VARCHAR(256) CHARACTER SET 'utf8mb4' NULL, INDEX `aspnet_Applications_Index` (`LoweredApplicationName`(255) ASC) VISIBLE, PRIMARY KEY (`ApplicationId`), UNIQUE INDEX `UQ__aspnet_Applicati__7F60ED59` (`LoweredApplicationName`(255) ASC) VISIBLE, UNIQUE INDEX `UQ__aspnet_Applicati__00551192` (`ApplicationName`(255) ASC) VISIBLE) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_SmsText` ( `Id` VARCHAR(64) NOT NULL, `ModuleName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ModuleText` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ShowHideFields` ( `UserName` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `PageId` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `PageFields` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `TypeFields` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `TypeFieldId` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Referral` ( `ID` INT NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`ID`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationPendingRequests` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `PRL` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:22:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`CampaignSMS` ( `Id` VARCHAR(64) NOT NULL, `CampaignID` VARCHAR(64) NULL, `ContactId` VARCHAR(64) NULL, `Phone` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `SmsContent` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Sent` TINYINT(1) NULL DEFAULT 0, `DateSent` DATETIME(6) NULL, `SenderUser` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:22:21 [INF][ grt]: Scripts for 147 tables, 0 views and 0 routines were executed for schema RealEstate 10:22:21 [INF][ grt]: Execute statement SET FOREIGN_KEY_CHECKS = 1 10:23:10 [WRN][ mforms]: Resource file not found: migration_check_done_win.png 10:23:10 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 10:24:41 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 10:25:11 [INF][ Wizard]: Execute 'Connect to Target Database' 10:25:11 [INF][ grt]: Connecting to Mysql@localhost:3306... 10:25:11 [INF][ grt]: Connected 10:25:11 [INF][ Wizard]: Execute 'Perform Checks in Target' 10:25:13 [INF][ Wizard]: Starting thread for 'Create Schemas and Objects' 10:25:13 [INF][ grt]: Execute statement SET FOREIGN_KEY_CHECKS = 0 10:25:13 [INF][ grt]: Execute statement DROP SCHEMA IF EXISTS `RealEstate` 10:25:17 [INF][ grt]: Execute statement CREATE SCHEMA IF NOT EXISTS `RealEstate` 10:25:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Quality` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:25:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_Users` ( `ApplicationId` VARCHAR(64) NOT NULL, `UserId` VARCHAR(64) NOT NULL, `UserName` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `LoweredUserName` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `MobileAlias` VARCHAR(16) CHARACTER SET 'utf8mb4' NULL DEFAULT NULL, `IsAnonymous` TINYINT(1) NOT NULL DEFAULT 0, `LastActivityDate` DATETIME(6) NOT NULL, UNIQUE INDEX `aspnet_Users_Index` (`ApplicationId` ASC, `LoweredUserName`(255) ASC) VISIBLE, PRIMARY KEY (`UserId`), INDEX `aspnet_Users_Index2` (`ApplicationId` ASC, `LastActivityDate` ASC) VISIBLE, CONSTRAINT `FK__aspnet_Us__Appli__0425A276` FOREIGN KEY (`ApplicationId`) REFERENCES `RealEstate`.`aspnet_Applications` (`ApplicationId`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:25:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Notifications` ( `Id` VARCHAR(64) NOT NULL, `DepartmentId` VARCHAR(64) NULL, `FromName` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `FromEmail` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `ToName` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `ToEmail` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `Subject` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `Body` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Sent` TINYINT(1) NOT NULL DEFAULT 0, `ScheduledDateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `ModuleName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_Notifications_Department` FOREIGN KEY (`DepartmentId`) REFERENCES `RealEstate`.`Department` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:25:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_RequestCategory` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertyType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationToExpireProperties` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `PRL` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:25:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertyState` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_SchemaVersions` ( `Feature` VARCHAR(128) CHARACTER SET 'utf8mb4' NOT NULL, `CompatibleSchemaVersion` VARCHAR(128) CHARACTER SET 'utf8mb4' NOT NULL, `IsCurrentVersion` TINYINT(1) NOT NULL, PRIMARY KEY (`Feature`, `CompatibleSchemaVersion`)) 10:25:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`DetailedInspection` ( `Id` VARCHAR(64) NOT NULL, `Prl` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `ContactId` VARCHAR(64) NULL, `Inspector` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `InspDate` DATETIME(6) NULL, `InspAddress` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `InspCity` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Temperature` INT NULL, `Weather` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `YearBuilt` DATETIME(6) NULL, `BuildingType` CHAR(200) CHARACTER SET 'utf8mb4' NULL, `Remarks` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `HouseOccupied` TINYINT(1) NULL, `ClientPresent` TINYINT(1) NULL, `OthersPresent` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `BuildingName` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertyAvailability` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyOffer` ( `Id` VARCHAR(64) NOT NULL, `Prl` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `PropertyDesc` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `PropertyImages` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `PropertyDocuments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ContactId` VARCHAR(64) NULL, `ContactType` INT NULL, `Subject` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `AdvImage` VARCHAR(64) NULL, PRIMARY KEY (`Id`)) 10:25:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ShowingType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ShowingTypeColor` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyCost` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `Date` DATETIME(6) NULL, `DateTo` DATETIME(6) NULL, `Cost` DECIMAL(16,2) NULL, `CostContact` VARCHAR(64) NULL, `CostTypeId` INT NULL, `CostCategoryId` INT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertyCost_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Sur_Questions` ( `ID` INT NOT NULL, `Text` VARCHAR(200) NOT NULL, `QuestionType` VARCHAR(200) NOT NULL, `Options` VARCHAR(2000) NOT NULL, `Disp` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`ID`)) 10:25:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ShowingList` ( `Id` VARCHAR(64) NOT NULL, `AgentId` VARCHAR(64) NOT NULL, `ContactId` VARCHAR(64) NOT NULL, `DepartmentId` VARCHAR(64) NOT NULL, `ShowingDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `Showed` TINYINT(1) NOT NULL DEFAULT 0, `Comment` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `NotifyAgainDate` DATETIME(6) NULL, `Notified` TINYINT(1) NULL, `ShowingTypeId` INT NULL, `SentByEmail` TINYINT(1) NULL, `SentByEmailDate` DATETIME(6) NULL, `CreationDate` DATETIME(6) NULL, `CreatedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ModifiedDate` DATETIME(6) NULL, `ModifiedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `AdditionalAgentId` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `RequestRelatedId` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `FeedBack` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ChkOwner` TINYINT(1) NULL, `ChkClient` TINYINT(1) NULL, PRIMARY KEY (`Id`)) 10:25:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`TraSub` ( `Id` VARCHAR(64) NOT NULL, `TransactionId` VARCHAR(64) NOT NULL, `TranDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `AmountPaid` DECIMAL(18,3) NULL, `Comment` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Paid` TINYINT(1) NULL, `PaidDate` DATETIME(6) NULL, `RecPay` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ReminderId` VARCHAR(64) NULL, `FollowUp` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `FollowUpDate` DATETIME(6) NULL, `PlusMonth` BIGINT NULL, `Conditions` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Payments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ContractConditions` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SeqNum` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ExpectedPaymentDate` DATETIME(6) NULL, `NewTransactionDate` DATETIME(6) NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_TraSub_Transactions` FOREIGN KEY (`TransactionId`) REFERENCES `RealEstate`.`Transactions` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Sur_Survey_Questions` ( `ID` INT NOT NULL, `SurveyID` INT NOT NULL, `QuestionID` INT NOT NULL, `OrderID` INT NULL, PRIMARY KEY (`ID`), CONSTRAINT `FK_Sur_Survey_Questions_Sur_Questions` FOREIGN KEY (`QuestionID`) REFERENCES `RealEstate`.`Sur_Questions` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Sur_Survey_Questions_Sur_Surveys` FOREIGN KEY (`SurveyID`) REFERENCES `RealEstate`.`Sur_Surveys` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:25:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_Membership` ( `ApplicationId` VARCHAR(64) NOT NULL, `UserId` VARCHAR(64) NOT NULL, `Password` VARCHAR(128) CHARACTER SET 'utf8mb4' NOT NULL, `PasswordFormat` INT NOT NULL DEFAULT 0, `PasswordSalt` VARCHAR(128) CHARACTER SET 'utf8mb4' NOT NULL, `MobilePIN` VARCHAR(16) CHARACTER SET 'utf8mb4' NULL, `Email` VARCHAR(256) CHARACTER SET 'utf8mb4' NULL, `LoweredEmail` VARCHAR(256) CHARACTER SET 'utf8mb4' NULL, `PasswordQuestion` VARCHAR(256) CHARACTER SET 'utf8mb4' NULL, `PasswordAnswer` VARCHAR(128) CHARACTER SET 'utf8mb4' NULL, `IsApproved` TINYINT(1) NOT NULL, `IsLockedOut` TINYINT(1) NOT NULL, `CreateDate` DATETIME(6) NOT NULL, `LastLoginDate` DATETIME(6) NOT NULL, `LastPasswordChangedDate` DATETIME(6) NOT NULL, `LastLockoutDate` DATETIME(6) NOT NULL, `FailedPasswordAttemptCount` INT NOT NULL, `FailedPasswordAttemptWindowStart` DATETIME(6) NOT NULL, `FailedPasswordAnswerAttemptCount` INT NOT NULL, `FailedPasswordAnswerAttemptWindowStart` DATETIME(6) NOT NULL, `Comment` LONGTEXT NULL, INDEX `aspnet_Membership_index` (`ApplicationId` ASC, `LoweredEmail`(255) ASC) VISIBLE, PRIMARY KEY (`UserId`), CONSTRAINT `FK__aspnet_Me__Appli__145C0A3F` FOREIGN KEY (`ApplicationId`) REFERENCES `RealEstate`.`aspnet_Applications` (`ApplicationId`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK__aspnet_Me__UserI__15502E78` FOREIGN KEY (`UserId`) REFERENCES `RealEstate`.`aspnet_Users` (`UserId`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:25:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ShowingFeatures` ( `ID` VARCHAR(64) NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`ID`)) 10:25:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Sur_Surveys` ( `ID` INT NOT NULL, `Title` VARCHAR(200) NULL, `Description` VARCHAR(200) NOT NULL, `CreatedOn` DATETIME(6) NOT NULL, `ExpiresOn` DATETIME(6) NULL, `CreatedBy` VARCHAR(200) NOT NULL, `Publish` TINYINT(1) NULL, `TypeId` INT NULL, PRIMARY KEY (`ID`)) 10:25:23 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyRooms` ( `Id` VARCHAR(64) NOT NULL, `LKUP_PropertyRoomsId` INT NULL, `Count` INT NULL, `Surface` DECIMAL(10,2) NULL, `Length` DECIMAL(10,2) NULL, `Width` DECIMAL(10,2) NULL, `Height` DECIMAL(10,2) NULL, `Unit` VARCHAR(1) CHARACTER SET 'utf8mb4' NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertyRooms_LKUP_PropertyRooms` FOREIGN KEY (`LKUP_PropertyRoomsId`) REFERENCES `RealEstate`.`LKUP_PropertyRooms` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_PropertyRooms_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:23 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertyRooms` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:23 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`SmsHistory` ( `Id` VARCHAR(64) NOT NULL, `ContactId` VARCHAR(64) NULL, `PhoneNb` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `SmsText` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SmsStatus` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_SurveyType` ( `ID` INT NOT NULL, `Description` CHAR(200) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`ID`)) 10:25:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ShowingRelatedFeatures` ( `Id` VARCHAR(64) NOT NULL, `ShowingFeaturesId` VARCHAR(64) NOT NULL, `ShowingListId` VARCHAR(64) NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Signature` ( `Id` VARCHAR(64) NOT NULL, `AgentId` VARCHAR(64) NOT NULL, `ProfImage` LONGBLOB NULL, `SigImage` LONGBLOB NULL, `Extension` VARCHAR(5) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_SalaryRange` ( `Id` VARCHAR(64) NOT NULL, `RangeFrom` INT NOT NULL, `RangeTo` INT NOT NULL, `RangeName` VARCHAR(200) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:25:25 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ClientStatus` ( `Id` INT NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:25 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ContactReassignement` ( `Id` VARCHAR(64) NOT NULL, `ReassignementDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `InitiatedBy` VARCHAR(64) NOT NULL, `FromAgentId` VARCHAR(64) NOT NULL, `DestinationAgentId` VARCHAR(64) NOT NULL, `ContactId` VARCHAR(64) NOT NULL, `ApprovedByDestinationAgent` TINYINT(1) NOT NULL DEFAULT 0, `ApprovedDestinationAgentDate` DATETIME(6) NULL, `ApprovedByAdmin` TINYINT(1) NOT NULL DEFAULT 0, `ApprovedAdminDate` DATETIME(6) NULL, `AdminId` VARCHAR(64) NULL, PRIMARY KEY (`Id`)) 10:25:25 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyActions` ( `Id` VARCHAR(64) NOT NULL, `ActionDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `InitiatedBy` VARCHAR(64) NOT NULL, `FromAgentId` VARCHAR(64) NOT NULL, `DestinationAgentId` VARCHAR(64) NOT NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `ApprovedByDestinationAgent` TINYINT(1) NOT NULL DEFAULT 0, `ApprovedDestinationAgentDate` DATETIME(6) NULL, `ApprovedByAdmin` TINYINT(1) NOT NULL DEFAULT 0, `ApprovedAdminDate` DATETIME(6) NULL, `AdminId` VARCHAR(64) NULL, `PropertyActionsTypeId` INT NOT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertyActions_LKUP_PorpertyActionsType` FOREIGN KEY (`PropertyActionsTypeId`) REFERENCES `RealEstate`.`LKUP_PorpertyActionsType` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_PropertyActions_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:27 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_Profile` ( `UserId` VARCHAR(64) NOT NULL, `PropertyNames` LONGTEXT NOT NULL, `PropertyValuesString` LONGTEXT NOT NULL, `PropertyValuesBinary` LONGBLOB NOT NULL, `LastUpdatedDate` DATETIME(6) NOT NULL, PRIMARY KEY (`UserId`), CONSTRAINT `FK__aspnet_Pr__UserI__29572725` FOREIGN KEY (`UserId`) REFERENCES `RealEstate`.`aspnet_Users` (`UserId`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:25:27 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ContactChildren` ( `Id` VARCHAR(64) NOT NULL, `ContactId` VARCHAR(64) NOT NULL, `Name` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `DateOfBirth` DATETIME(6) NULL, `Occupation` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_ContactChildren_Contacts` FOREIGN KEY (`ContactId`) REFERENCES `RealEstate`.`Contacts` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:27 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyFeatures` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(250) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:27 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_State` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL) 10:25:28 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Zoning` ( `Id` VARCHAR(64) NOT NULL, `ZoneNbr` VARCHAR(10) CHARACTER SET 'utf8mb4' NULL, `Description` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `HorizontalPerc` DECIMAL(5,2) NOT NULL, `Exploitation` DECIMAL(5,2) NOT NULL, `MaxHeight` DECIMAL(5,2) NULL, `NbrOfFloors` TINYINT UNSIGNED NULL, `Details` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:28 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`SmsLog` ( `Id` VARCHAR(64) NOT NULL, `ContactId` VARCHAR(64) NULL, `ToName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Phone` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CampaignId` VARCHAR(64) NULL, `ErrorMsg` VARCHAR(300) CHARACTER SET 'utf8mb4' NULL, `Date` DATETIME(6) NULL, PRIMARY KEY (`Id`)) 10:25:28 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationReminder` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `IDS` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:25:28 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ReminderNature` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `ReminderNatureColor` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:28 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Request` ( `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `OldPRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `DepartmentId` VARCHAR(64) NOT NULL, `PropertyTypeId` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `PropertySizeId` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `ContactId` VARCHAR(64) NOT NULL, `SizeFrom` DECIMAL(9,2) NULL DEFAULT 0, `SizeTo` DECIMAL(9,2) NULL, `SalePriceFrom` INT NULL, `SalePriceTo` INT NULL, `RentPriceFrom` INT NULL, `RentPriceTo` INT NULL, `TotalBedRoomFrom` INT NULL DEFAULT 0, `TotalBedRoomTo` INT NULL, `ReceptionFrom` INT NULL DEFAULT 0, `ReceptionTo` INT NULL, `FloorLevel` INT NULL, `PropertyForId` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `QualityId` INT NULL, `Parking` INT NULL DEFAULT 0, `PostedDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `ExpiryDate` DATETIME(6) NOT NULL, `Active` TINYINT(1) NULL DEFAULT 0, `Closed` TINYINT(1) NULL DEFAULT 0, `PreviousReferedAgentId` VARCHAR(64) NULL, `CurrentReferedAgentId` VARCHAR(64) NULL, `PreviousReassignedAgentId` VARCHAR(64) NULL, `CurrentReassignedAgentId` VARCHAR(64) NULL, `Comments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SearchingFor` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `InvolvedChoosing` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `DecisionMaker` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `OtherSpecFeatures` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `WhyThoseFeatures` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `SearchingTime` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `LimitTimeToGet` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `AnythingYouLike` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `WhyNotPropertyYet` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `PreferredPropertyInfo` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `BuildingAge` INT NULL, `PropertyViewId` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `OtherFeatures` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `OtherFeaturesWhy` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `RegionPriceIdea` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PayMethod` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `BankContact` TINYINT(1) NULL, `BankName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `BankSpecified` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SearchingPropertyMethod` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `OtherAgentContact` TINYINT(1) NULL, `SpecifyAgent` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `SellOwnProperty` TINYINT(1) NULL, `SellingBeforeBuying` TINYINT(1) NULL, `SurfaceAndCharacteristics` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `OwnPropertyPrice` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `WhatAreYouDoingToSell` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `Diagnosis` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ManagerialComments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CustomerRange` INT NULL, `BuyingOrRentingGoodPrice` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CurrentPropertyStatusId` INT NULL, `Satisfied` TINYINT(1) NULL, `CreationDate` DATETIME(6) NULL, `CreatedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ModifiedDate` DATETIME(6) NULL, `ModifiedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PurchaserId` VARCHAR(64) NULL, `FurnishedDescription` VARCHAR(400) CHARACTER SET 'utf8mb4' NULL, `BathroomFrom` INT NULL, `BathroomTo` INT NULL, `TerraceGardenDescription` VARCHAR(400) CHARACTER SET 'utf8mb4' NULL, `Schools` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `Entertainment` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `Activities` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `ChildrenActivity` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `ShoppingFacilities` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `DeliveryServices` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `Hospitals` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `LifeStyleOthers` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `BuildingName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Discount` DECIMAL(12,3) NULL, `ReferencedBy` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `MediaCompanyId` VARCHAR(64) NULL, `StatusReasonId` INT NULL, `CategoryId` VARCHAR(64) NULL, `CallSheetDetails` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `RequestComments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `MasterBedRoomFrom` INT NULL, `MasterBedRoomTo` INT NULL, `ReferralId` INT NULL, `ClientStatusId` INT NULL, `CallSheetTypeId` INT NULL, `ClientNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Pending` TINYINT(1) NULL, `ChkCurrencyPrice` TINYINT(1) NULL, PRIMARY KEY (`PRL`), CONSTRAINT `FK_Request_LKUP_CurrentPropertyStatus` FOREIGN KEY (`CurrentPropertyStatusId`) REFERENCES `RealEstate`.`LKUP_CurrentPropertyStatus` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `FK_Request_Department` FOREIGN KEY (`DepartmentId`) REFERENCES `RealEstate`.`Department` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Request_LKUP_StatusReason` FOREIGN KEY (`StatusReasonId`) REFERENCES `RealEstate`.`LKUP_StatusReason` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Request_LKUP_Quality` FOREIGN KEY (`QualityId`) REFERENCES `RealEstate`.`LKUP_Quality` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Request_Contacts` FOREIGN KEY (`ContactId`) REFERENCES `RealEstate`.`Contacts` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:25:29 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyDocuments` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Documents` LONGBLOB NOT NULL, `DocumentName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Extension` VARCHAR(5) CHARACTER SET 'utf8mb4' NOT NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `DocDate` DATETIME(6) NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertyDocuments_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:29 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ManPower` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(64) NULL, `Hour` DOUBLE NULL, `MaintenanceWorkId` VARCHAR(64) NOT NULL, PRIMARY KEY (`Id`)) 10:25:29 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_Roles` ( `ApplicationId` VARCHAR(64) NOT NULL, `RoleId` VARCHAR(64) NOT NULL, `RoleName` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `LoweredRoleName` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `Description` VARCHAR(256) CHARACTER SET 'utf8mb4' NULL, UNIQUE INDEX `aspnet_Roles_index1` (`ApplicationId` ASC, `LoweredRoleName`(255) ASC) VISIBLE, PRIMARY KEY (`RoleId`), CONSTRAINT `FK__aspnet_Ro__Appli__32E0915F` FOREIGN KEY (`ApplicationId`) REFERENCES `RealEstate`.`aspnet_Applications` (`ApplicationId`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:25:30 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Transactions` ( `Id` VARCHAR(64) NOT NULL, `PRL` VARCHAR(40) CHARACTER SET 'utf8mb4' NOT NULL, `ClosingAmount` DECIMAL(18,3) NULL, `Comment` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `Closed` TINYINT(1) NOT NULL DEFAULT 0, `ContactId` VARCHAR(64) NULL, `TranHeaderDate` DATETIME(6) NULL, `ContractDate` DATETIME(6) NULL, `ToMofDate` DATETIME(6) NULL, `ToNpDate` DATETIME(6) NULL, `CustomerCopyDate` DATETIME(6) NULL, `ContactDate` DATETIME(6) NULL, `DeliveryDate` DATETIME(6) NULL, `PreparedByAdminDate` DATE NULL, `PreparedByAdminName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `PreparedByAdminUserName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CheckedByAdminDate` DATE NULL, `CheckedByAdminName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CheckedByAdminUserName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CheckedByACDate` DATE NULL, `CheckedByACName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CheckedByACUserName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CRMAuditDate` DATE NULL, `CRMAuditName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CRMAuditUserName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), UNIQUE INDEX `IX_Transactions` (`PRL` ASC, `ContactId` ASC) VISIBLE, CONSTRAINT `FK_Transactions_Contacts` FOREIGN KEY (`ContactId`) REFERENCES `RealEstate`.`Contacts` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `FK_Transactions_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE NO ACTION ON UPDATE CASCADE) 10:25:30 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyImages` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Image` LONGBLOB NOT NULL, `Extension` VARCHAR(5) CHARACTER SET 'utf8mb4' NOT NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `ShowOnWebsite` TINYINT(1) NULL, `ShowOnPrint` TINYINT(1) NULL, `ShowAsFirstImage` TINYINT(1) NULL, `ImgDate` DATETIME(6) NULL, `InspCatId` VARCHAR(64) NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertyImages_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:30 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Materials` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `Quantity` INT NULL DEFAULT 0, `Price` DOUBLE NULL DEFAULT 0, `MaintenanceWorkId` VARCHAR(64) NOT NULL, PRIMARY KEY (`Id`)) 10:25:30 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_UsersInRoles` ( `UserId` VARCHAR(64) NOT NULL, `RoleId` VARCHAR(64) NOT NULL, PRIMARY KEY (`UserId`, `RoleId`), INDEX `aspnet_UsersInRoles_index` (`RoleId` ASC) VISIBLE, CONSTRAINT `FK__aspnet_Us__UserI__36B12243` FOREIGN KEY (`UserId`) REFERENCES `RealEstate`.`aspnet_Users` (`UserId`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK__aspnet_Us__RoleI__37A5467C` FOREIGN KEY (`RoleId`) REFERENCES `RealEstate`.`aspnet_Roles` (`RoleId`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:25:32 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyRelatedFeatures` ( `Id` VARCHAR(64) NOT NULL, `PropertyFeaturesId` VARCHAR(64) NOT NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertyRelatedFeatures_PropertyFeatures` FOREIGN KEY (`PropertyFeaturesId`) REFERENCES `RealEstate`.`PropertyFeatures` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_PropertyRelatedFeatures_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:32 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Priority` ( `Id` INT NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:25:32 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`AuditTrail` ( `ID` VARCHAR(64) NOT NULL, `Table` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Column` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `RowID` TEXT(8016) NULL, `ChangeDate` DATETIME(6) NULL, `ChangedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `OldValue` TEXT(8016) NULL, `NewValue` TEXT(8016) NULL, INDEX `ClusteredIndex-20151026-095105` (`Table` ASC, `Column` ASC, `RowID`(255) ASC, `ChangeDate` ASC) VISIBLE) 10:25:33 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertySituation` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:33 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_CostCategory` ( `Id` INT NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:33 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyRent` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `DateFrom` DATETIME(6) NULL, `DateTo` DATETIME(6) NULL, `Price` DECIMAL(16,2) NULL, `ContactId` VARCHAR(64) NULL, `ContractTypeId` INT NULL, `Notice` INT NULL, `TotalPricePerRent` DECIMAL(16,2) NULL, `Paid` TINYINT(1) NULL, `PaidDate` DATETIME(6) NULL, `PaidPrice` DECIMAL(16,2) NULL, `Remaining` DECIMAL(16,2) NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertyRent_LKUP_ContractType` FOREIGN KEY (`ContractTypeId`) REFERENCES `RealEstate`.`LKUP_ContractType` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_PropertyRent_Contacts` FOREIGN KEY (`ContactId`) REFERENCES `RealEstate`.`Contacts` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_PropertyRent_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:33 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_TranConditions` ( `Id` INT NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `Project` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `TranConDate` DATETIME(6) NULL, PRIMARY KEY (`Id`)) 10:25:34 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`DictionaryTable` ( `Id` VARCHAR(250) CHARACTER SET 'utf8mb4' NOT NULL, `English` VARCHAR(250) CHARACTER SET 'utf8mb4' NULL, `French` VARCHAR(250) CHARACTER SET 'utf8mb4' NULL, `Arabic` VARCHAR(250) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:34 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`RequestComments` ( `Id` VARCHAR(64) NOT NULL, `RequestId` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `DateAdd` DATETIME(6) NULL, `DateModified` DATETIME(6) NULL, `AgentId` VARCHAR(64) NOT NULL, `Comments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:34 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ContactType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:34 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`CallSheet` ( `Id` VARCHAR(64) NOT NULL, `CallerName` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `PhoneNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `Email` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CallDateTime` DATETIME(6) NOT NULL, `AgentId` VARCHAR(64) NULL, `DepartmentId` VARCHAR(64) NOT NULL, `Comments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Answered` TINYINT(1) NOT NULL DEFAULT 0, `ClientTypeId` INT NOT NULL, `CallSheetTypeId` INT NULL, `Priority` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CreationDate` DATETIME(6) NULL, `CreatedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ModifiedDate` DATETIME(6) NULL, `ModifiedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SizeFrom` DECIMAL(9,2) NULL, `SizeTo` DECIMAL(9,2) NULL, `SalePriceFrom` INT NULL, `SalePriceTo` INT NULL, `TotalBedRoomFrom` INT NULL, `TotalBedRoomTo` INT NULL, `RentPriceFrom` INT NULL, `RentPriceTo` INT NULL, `ExportToRequest` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `ContactId` VARCHAR(64) NULL, `PropertyTypeId` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `PropertyForId` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `Address` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ReferencedBy` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `MediaCompanyId` VARCHAR(64) NULL, `BuildingName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `NbrRequests` INT NULL DEFAULT 0, `NbrProperties` INT NULL DEFAULT 0, `NbrCalls` INT NULL DEFAULT 0, `NbrShowings` INT NULL DEFAULT 0, `NbrSurveys` INT NULL, `NbrMeetings` INT NULL, `SmsSent` TINYINT(1) NULL, `IdCardNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `PayMethod` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `MasterBedRoomFrom` INT NULL, `MasterBedRoomTo` INT NULL, `ReferralId` INT NULL, `ClientNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ChkCurrencyPrice` TINYINT(1) NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_CallSheet_Department` FOREIGN KEY (`DepartmentId`) REFERENCES `RealEstate`.`Department` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_CallSheet_LKUP_ClientType` FOREIGN KEY (`ClientTypeId`) REFERENCES `RealEstate`.`LKUP_ClientType` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_CallSheet_LKUP_CallSheetType` FOREIGN KEY (`CallSheetTypeId`) REFERENCES `RealEstate`.`LKUP_CallSheetType` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `FK_CallSheet_Contacts` FOREIGN KEY (`ContactId`) REFERENCES `RealEstate`.`Contacts` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:35 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Permissions` ( `PageID` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `UserName` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `Permissions` VARCHAR(6) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`PageID`, `UserName`)) 10:25:36 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_RoomStructure` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:36 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Country` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:36 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_RoomSpecifications` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:37 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_MediaCompanyType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:37 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertyRoomsFeatures` ( `Id` VARCHAR(64) NOT NULL, `RoomStructureId` INT NULL, `PropertyRoomsId` VARCHAR(64) NULL, `RoomSpecificationsId` INT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertyRoomsFeatures_LKUP_RoomSpecificaions` FOREIGN KEY (`RoomSpecificationsId`) REFERENCES `RealEstate`.`LKUP_RoomSpecifications` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_PropertyRoomsFeatures_LKUP_RoomStructure` FOREIGN KEY (`RoomStructureId`) REFERENCES `RealEstate`.`LKUP_RoomStructure` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_PropertyRoomsFeatures_PropertyRooms` FOREIGN KEY (`PropertyRoomsId`) REFERENCES `RealEstate`.`PropertyRooms` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:37 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_Paths` ( `ApplicationId` VARCHAR(64) NOT NULL, `PathId` VARCHAR(64) NOT NULL, `Path` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `LoweredPath` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, UNIQUE INDEX `aspnet_Paths_index` (`ApplicationId` ASC, `LoweredPath`(255) ASC) VISIBLE, PRIMARY KEY (`PathId`), CONSTRAINT `FK__aspnet_Pa__Appli__45F365D3` FOREIGN KEY (`ApplicationId`) REFERENCES `RealEstate`.`aspnet_Applications` (`ApplicationId`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:25:38 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_TranFollowUp` ( `Id` INT NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `Project` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `TranFollowUpDate` DATETIME(6) NULL, PRIMARY KEY (`Id`)) 10:25:38 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NewsletterTemplates` ( `ID` VARCHAR(64) NOT NULL, `Name` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `HtmlMain` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `HtmlProperty` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `HtmlImage` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `type` INT NULL, PRIMARY KEY (`ID`)) 10:25:38 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`CallSheetLocation` ( `Id` VARCHAR(64) NOT NULL, `CallSheetId` VARCHAR(64) NOT NULL, `CountryId` INT NULL, `QadaaId` INT NOT NULL, `DistrictId` INT NULL, `NeighborhoodId` INT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_CallSheetLocation_CallSheet` FOREIGN KEY (`CallSheetId`) REFERENCES `RealEstate`.`CallSheet` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:38 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PropertySizes` ( `Id` VARCHAR(64) NOT NULL, `LKUP_PropertySizesId` INT NULL, `Count` INT NULL, `Surface` DECIMAL(10,2) NULL, `Length` DECIMAL(10,2) NULL, `Width` DECIMAL(10,2) NULL, `Height` DECIMAL(10,2) NULL, `Unit` VARCHAR(1) CHARACTER SET 'utf8mb4' NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `DividePer` SMALLINT NULL, `DoNotApplyDisc` TINYINT(1) NULL, `Price` INT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_PropertySizes_LKUP_PropertySizes` FOREIGN KEY (`LKUP_PropertySizesId`) REFERENCES `RealEstate`.`LKUP_PropertySizes` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:39 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`CampaignEmails` ( `Sent` TINYINT(1) NULL DEFAULT 0, `CampaignID` VARCHAR(64) NULL, `Email` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, CONSTRAINT `FK_CampaignEmails_Campaigns` FOREIGN KEY (`CampaignID`) REFERENCES `RealEstate`.`Campaigns` (`ID`) ON DELETE CASCADE ON UPDATE NO ACTION) 10:25:39 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ContactDocuments` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Documents` LONGBLOB NOT NULL, `DocumentName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Extension` VARCHAR(5) NOT NULL, `ContactId` VARCHAR(64) NOT NULL, `DateUploaded` DATETIME(6) NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_ContactDocuments_Contacts` FOREIGN KEY (`ContactId`) REFERENCES `RealEstate`.`Contacts` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:39 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_PersonalizationAllUsers` ( `PathId` VARCHAR(64) NOT NULL, `PageSettings` LONGBLOB NOT NULL, `LastUpdatedDate` DATETIME(6) NOT NULL, PRIMARY KEY (`PathId`), CONSTRAINT `FK__aspnet_Pe__PathI__4BAC3F29` FOREIGN KEY (`PathId`) REFERENCES `RealEstate`.`aspnet_Paths` (`PathId`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:25:40 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Campaigns` ( `ID` VARCHAR(64) NOT NULL, `Name` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `DateCreated` DATETIME(6) NULL, `DateSent` DATETIME(6) NULL, `TemplateID` VARCHAR(64) NULL, `PRLs` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SentHTML` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Content` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CType` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`ID`)) 10:25:41 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Publicities` ( `Id` VARCHAR(64) NOT NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `DateStart` DATETIME(6) NULL, `DateEnd` DATETIME(6) NULL, `MediaCompanyId` VARCHAR(64) NULL, `Reference` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Price` DECIMAL(16,2) NULL, `NumberOfReturnedCalls` INT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_Publicities_MediaCompany` FOREIGN KEY (`MediaCompanyId`) REFERENCES `RealEstate`.`MediaCompany` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_Publicities_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:41 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_PersonalizationPerUser` ( `Id` VARCHAR(64) NOT NULL, `PathId` VARCHAR(64) NULL, `UserId` VARCHAR(64) NULL, `PageSettings` LONGBLOB NOT NULL, `LastUpdatedDate` DATETIME(6) NOT NULL, UNIQUE INDEX `aspnet_PersonalizationPerUser_index1` (`PathId` ASC, `UserId` ASC) VISIBLE, PRIMARY KEY (`Id`), UNIQUE INDEX `aspnet_PersonalizationPerUser_ncindex2` (`UserId` ASC, `PathId` ASC) VISIBLE, CONSTRAINT `FK__aspnet_Pe__PathI__4F7CD00D` FOREIGN KEY (`PathId`) REFERENCES `RealEstate`.`aspnet_Paths` (`PathId`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK__aspnet_Pe__UserI__5070F446` FOREIGN KEY (`UserId`) REFERENCES `RealEstate`.`aspnet_Users` (`UserId`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:25:42 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertyGeographic` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:42 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Project` ( `Prl` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `Name` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Logo` LONGBLOB NULL, `Footer` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SequenceType` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SequenceNum` INT NULL DEFAULT 0, `ContractTemplate` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Prl`)) 10:25:42 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`GoogleCalendar` ( `Id` VARCHAR(64) NOT NULL, `DepartmentId` VARCHAR(64) NOT NULL, `CalendarId` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `Agents` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CalendarName` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:25:42 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_InspectionArea` ( `ID` INT NOT NULL, `Area` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `TypeOrder` INT NULL, PRIMARY KEY (`ID`)) 10:25:42 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_StatusReason` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:43 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_BLOB_TRIGGERS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `BLOB_DATA` LONGBLOB NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)) 10:25:44 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Job_Title` ( `ID` VARCHAR(64) NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`ID`)) 10:25:44 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_CALENDARS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `CALENDAR_NAME` VARCHAR(200) CHARACTER SET 'utf8mb4' NOT NULL, `CALENDAR` LONGBLOB NOT NULL, PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`)) 10:25:44 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_CallSheetType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) -- CONSTRAINT `FK_LKUP_CallSheetType_LKUP_CallSheetType` -- FOREIGN KEY (`Id`) -- REFERENCES `RealEstate`.`LKUP_CallSheetType` (`Id`) -- ON DELETE NO ACTION -- ON UPDATE NO ACTION 10:25:44 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PorpertyActionsType` ( `Id` INT NOT NULL, `Description` CHAR(10) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:25:45 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_CRON_TRIGGERS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `CRON_EXPRESSION` VARCHAR(120) CHARACTER SET 'utf8mb4' NOT NULL, `TIME_ZONE_ID` VARCHAR(80) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`), CONSTRAINT `FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS` FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`) REFERENCES `RealEstate`.`QRTZ_TRIGGERS` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`) ON DELETE CASCADE ON UPDATE NO ACTION) 10:25:45 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_FIRED_TRIGGERS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `ENTRY_ID` VARCHAR(95) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `INSTANCE_NAME` VARCHAR(200) CHARACTER SET 'utf8mb4' NOT NULL, `FIRED_TIME` BIGINT NOT NULL, `SCHED_TIME` BIGINT NOT NULL, `PRIORITY` INT NOT NULL, `STATE` VARCHAR(16) CHARACTER SET 'utf8mb4' NOT NULL, `JOB_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `JOB_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `IS_NONCONCURRENT` TINYINT(1) NULL, `REQUESTS_RECOVERY` TINYINT(1) NULL, PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`)) 10:25:45 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Property` ( `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `OldPRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `CountryId` INT NULL, `QadaaId` INT NULL, `DistrictId` INT NULL, `NeighborhoodId` INT NULL, `ContactId` VARCHAR(64) NULL, `StreetName` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Directions` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Size` DECIMAL(9,2) NULL, `SizeDescription` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Floor` INT NULL, `FloorDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Receptions` INT NULL, `ReceptionsDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `TotalBedrooms` INT NULL, `TotalBedroomsDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Bathrooms` INT NULL, `BathroomsDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `GuestBathroom` INT NULL, `GuestBathroomDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `DriverRoom` INT NULL, `DriverRoomDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `MaidRoom` INT NULL, `MaidRoomDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `StorageRoom` INT NULL, `StorageRoomDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Age` INT NULL, `PropertyForId` INT NULL, `Lot_Unit_Nbr` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Exclusive` TINYINT(1) NULL, `ExclusiveDescription` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `StartDate` DATETIME(6) NULL, `EndDate` DATETIME(6) NULL, `QualityId` INT NULL, `TotalFloor` INT NULL, `TotalFloorDescription` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `FamilyRoom` INT NULL, `FamilyRoomDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `MasterBedRooms` INT NULL, `MasterBedRoomsDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Parkings` INT NULL, `ParkingDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `RentPrice` INT NULL DEFAULT 0, `SalePrice` INT NULL DEFAULT 0, `BldChargesPerMonth` INT NULL, `AdditionalInformation` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Web_GuideDescription` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `PreviousReferedAgentId` VARCHAR(64) NULL, `CurrentReferedAgentId` VARCHAR(64) NULL, `PreviousReassignedAgentId` VARCHAR(64) NULL, `CurrentReassignedAgentId` VARCHAR(64) NULL, `PreviousAgentInformation` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CurrentAgentInformation` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `LegalOwnerId` VARCHAR(64) NULL, `PropertyTypeId` INT NULL, `Active` TINYINT(1) NULL DEFAULT 0, `Pending` TINYINT(1) NULL DEFAULT 1, `Closed` TINYINT(1) NULL DEFAULT 0, `DepartmentId` VARCHAR(64) NOT NULL, `Facades` INT NULL DEFAULT 0, `SurfaceCoefficient` INT NULL DEFAULT 0, `TotalCoefficient` INT NULL DEFAULT 0, `TotalHeight` INT NULL DEFAULT 0, `Zone` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CompletionDate` DATETIME(6) NULL, `Completed` TINYINT(1) NULL, `SellingDate` DATETIME(6) NULL, `SellingPrice` BIGINT NULL, `PropertyStateId` INT NULL, `CreationDate` DATETIME(6) NULL, `CreatedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ModifiedDate` DATETIME(6) NULL, `ModifiedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PercCommission` DECIMAL(5,2) NULL, `FixedCommission` DECIMAL(16,2) NULL, `CommissionDue` DECIMAL(16,2) NULL, `CommissionNotes` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `PropertyViewId` INT NULL, `MinimumPrice` DECIMAL(16,2) NULL, `PropertyDeed` TINYINT(1) NULL, `Zoning` TINYINT(1) NULL, `SiteMap` TINYINT(1) NULL, `BuildingName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `AppartmentFloor` INT NULL, `PropertySituatedId` INT NULL, `PricePer` DECIMAL(16,2) NULL, `PropertyGeographicId` INT NULL, `PropertyAvailabilityId` INT NULL, `MaxHorizontalExp` DECIMAL(5,2) NULL, `MaxTotalExp` DECIMAL(5,2) NULL, `MaxHorizontalAreaPerFloor` DECIMAL(18,2) NULL, `MaxHorizontalAreaForBalconyPerc` DECIMAL(5,2) NULL, `MaxHorizontalAreaForBalconyAmount` DECIMAL(18,2) NULL, `TotalConstructionPerFloor` DECIMAL(18,2) NULL, `TotalConstructionPerFloorAccordingToLaw` DECIMAL(18,2) NULL, `MaxOverGroundExp` DECIMAL(5,2) NULL, `MaxOverGroundExpBalconyPerc` DECIMAL(5,2) NULL, `MaxOverGroundExpBalconyAmount` DECIMAL(18,2) NULL, `MaxOverGroundExpAmount` DECIMAL(18,2) NULL, `BuiltUpArea` DECIMAL(18,2) NULL, `TotalBuiltUpArea` DECIMAL(18,2) NULL, `AccordingToLawPerc` DECIMAL(5,2) NULL, `AccordingToLawAmount` DECIMAL(18,2) NULL, `CostPrice` DECIMAL(18,2) NULL, `BuiltUpPricePer` DECIMAL(16,2) NULL, `CornerPerc` DECIMAL(5,2) NULL, `LandZoningId` VARCHAR(64) NULL, `SoldByOthers` TINYINT(1) NULL, `DiningRoom` INT NULL, `DiningRoomDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Kitchen` INT NULL, `KitchenDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `DressingRoom` INT NULL, `DressingRoomDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `TotalRooms` INT NULL, `TotalRoomsDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `MaidBathRoom` INT NULL, `MaidBathRoomDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `AdditionalPricePerFloor` DECIMAL(16,2) NULL, `KeyDescription` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Promote` TINYINT(1) NULL, `PrintGeneralInfo` TINYINT(1) NULL, `PrintAdditionalInfo` TINYINT(1) NULL, `TruncatedSize` INT NULL, `TenantsCost` DECIMAL(16,2) NULL, `CommercialBUA` TINYINT(1) NULL, `MinResidentialSQMPrice` DECIMAL(16,2) NULL, `MaxResidentialSQMPrice` DECIMAL(16,2) NULL, `ConstructionCostPerSQM` DECIMAL(16,2) NULL, `FolderToBrowse` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Longitude` DECIMAL(18,5) NULL DEFAULT 0, `Latitude` DECIMAL(18,5) NULL DEFAULT 0, `FacebookPostId` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `FacebookAlbumId` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `uploadedtowebsite` TINYINT(1) NULL, `ParentPrl` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `discount` DECIMAL(12,3) NULL, `Rounding` BIGINT NULL, `ReservationDate` DATETIME(6) NULL, `StatusReasonId` INT NULL, `SmsText` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Ordering` INT NULL DEFAULT 0, `Charges` TINYINT(1) NULL, `ChargeInclude` TINYINT(1) NULL, `UploadedToMLS` TINYINT(1) NULL, `ChooseAction` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Amount` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `PropDismiss` TINYINT(1) NULL, `HotDeal` TINYINT(1) NULL, `BankerCheck` TINYINT(1) NULL, `ChkCurrencyPrice` TINYINT(1) NULL, `CadastralSection` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `bankerPercentage` INT NULL, `BankerSale` DECIMAL(16,2) NULL, `CheckOnly` TINYINT(1) NULL, PRIMARY KEY (`PRL`), CONSTRAINT `FK_Property_Department` FOREIGN KEY (`DepartmentId`) REFERENCES `RealEstate`.`Department` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_LKUP_Country` FOREIGN KEY (`CountryId`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_LKUP_PropertyAvailability` FOREIGN KEY (`PropertyAvailabilityId`) REFERENCES `RealEstate`.`LKUP_PropertyAvailability` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_LKUP_PropertyGeographic` FOREIGN KEY (`PropertyGeographicId`) REFERENCES `RealEstate`.`LKUP_PropertyGeographic` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_LKUP_PropertySituation` FOREIGN KEY (`PropertySituatedId`) REFERENCES `RealEstate`.`LKUP_PropertySituation` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_LKUP_PropertyState` FOREIGN KEY (`PropertyStateId`) REFERENCES `RealEstate`.`LKUP_PropertyState` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_LKUP_PropertyView` FOREIGN KEY (`PropertyViewId`) REFERENCES `RealEstate`.`LKUP_PropertyView` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_Zoning` FOREIGN KEY (`LandZoningId`) REFERENCES `RealEstate`.`Zoning` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_LKUP_StatusReason` FOREIGN KEY (`StatusReasonId`) REFERENCES `RealEstate`.`LKUP_StatusReason` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Property_Contacts_Owner` FOREIGN KEY (`LegalOwnerId`) REFERENCES `RealEstate`.`Contacts` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:25:46 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`MediaCompany` ( `Id` VARCHAR(64) NOT NULL, `Name` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Tel1` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Tel2` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Tel3` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `MediaCompanyTypeId` INT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_MediaCompany_LKUP_MediaCompanyType` FOREIGN KEY (`MediaCompanyTypeId`) REFERENCES `RealEstate`.`LKUP_MediaCompanyType` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:46 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`sysdiagrams` ( `name` VARCHAR(160) NOT NULL, `principal_id` INT NOT NULL, `diagram_id` INT NOT NULL, `version` INT NULL, `definition` LONGBLOB NULL, PRIMARY KEY (`diagram_id`), UNIQUE INDEX `UK_principal_name` (`principal_id` ASC, `name` ASC) VISIBLE) 10:25:46 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Contacts` ( `Id` VARCHAR(64) NOT NULL, `FName` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `MName` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `LName` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `PreviousAgentId` VARCHAR(64) NULL, `CurrentAgentId` VARCHAR(64) NULL, `ClientTypeId` INT NULL, `MobileNumber` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `HomePhone` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `OfficePhone` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `FaxNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Address` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Email` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ContactPersonName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `ContactPersonEmail` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ContactPersonNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Enabled` TINYINT(1) NULL DEFAULT 1, `DepartmentId` VARCHAR(64) NOT NULL, `EntryDate` DATETIME(6) NULL, `HusbandCompanyName` VARCHAR(400) CHARACTER SET 'utf8mb4' NULL, `HusbandCompanyAddress` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `HusbandCareer` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `HusbandDateOfBirth` DATETIME(6) NULL, `HusbandPlaceOfBirth` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `SpouseCareer` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseCompanyName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseCompanyAddress` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `SpuseCompanyPhone` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseMobile` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SpouseDateOfBirth` DATETIME(6) NULL, `SpousePlaceOfBirth` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `BelongToClub` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `CommunityActive` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `FavoritePlaceForLunch` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `FavoritePlaceForDinner` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `EntertainmentSpaces` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `WeddingAnniversary` DATETIME(6) NULL, `IsPlatinum` TINYINT(1) NULL, `ContactTypeId` INT NULL, `Title` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `Salutation` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Gender` VARCHAR(1) CHARACTER SET 'utf8mb4' NULL, `ModifiedDate` DATETIME(6) NULL, `ModifiedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CreatedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PassportNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `IdCardNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `NationalityId` INT NULL, `Notes` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ReferencedBy` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Website` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ConId` INT NOT NULL, `MofReg` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Vat` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CompanyCity` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `CompanyPostalCode` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `CompanyIndustry` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `ManagementLevel` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `AppPassword` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CountryOfResidenceID` INT NULL, `CompanyCountryID` INT NULL, `NbrRequests` INT NULL DEFAULT 0, `NbrProperties` INT NULL DEFAULT 0, `NbrCalls` INT NULL DEFAULT 0, `NbrSurveys` INT NULL, `NbrMeetings` INT NULL DEFAULT 0, `NbrShowings` INT NULL DEFAULT 0, `ParentContactId` VARCHAR(64) NULL, `vvip` TINYINT(1) NULL, `SendSms` TINYINT(1) NULL, `ProfilePic` LONGBLOB NULL, `RecNum` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `Meeting` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SalaryRangeId` VARCHAR(64) NULL, `StateId` VARCHAR(64) NULL, `ClientNumber` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ConDismiss` TINYINT(1) NULL, PRIMARY KEY (`Id`), UNIQUE INDEX `IX_Contacts` (`FName` ASC, `MName`(200) ASC, `LName`(200) ASC, `MobileNumber`(200) ASC) VISIBLE, INDEX `IX_Contacts_1` (`EntryDate` ASC) VISIBLE, INDEX `IX_Contacts_2` (`ModifiedDate` ASC) VISIBLE, CONSTRAINT `FK_Contacts_Department` FOREIGN KEY (`DepartmentId`) REFERENCES `RealEstate`.`Department` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Contacts_LKUP_Country1` FOREIGN KEY (`CountryOfResidenceID`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Contacts_LKUP_Country2` FOREIGN KEY (`CompanyCountryID`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Contacts_LKUP_ClientType` FOREIGN KEY (`ClientTypeId`) REFERENCES `RealEstate`.`LKUP_ClientType` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `FK_Contacts_LKUP_ContactType` FOREIGN KEY (`ContactTypeId`) REFERENCES `RealEstate`.`LKUP_ContactType` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT `FK_Contacts_LKUP_Country` FOREIGN KEY (`NationalityId`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE) 10:25:48 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_JOB_DETAILS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `JOB_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `JOB_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `DESCRIPTION` VARCHAR(250) CHARACTER SET 'utf8mb4' NULL, `JOB_CLASS_NAME` VARCHAR(250) CHARACTER SET 'utf8mb4' NOT NULL, `IS_DURABLE` TINYINT(1) NOT NULL, `IS_NONCONCURRENT` TINYINT(1) NOT NULL, `IS_UPDATE_DATA` TINYINT(1) NOT NULL, `REQUESTS_RECOVERY` TINYINT(1) NOT NULL, `JOB_DATA` LONGBLOB NULL, PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)) 10:25:48 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`PermissionJobTitle` ( `PageID` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `JobTitle` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `Permissions` VARCHAR(6) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`PageID`, `JobTitle`)) 10:25:48 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_LOCKS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `LOCK_NAME` VARCHAR(40) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`)) 10:25:48 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`RequestActions` ( `Id` VARCHAR(64) NOT NULL, `ActionDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `InitiatedBy` VARCHAR(64) NOT NULL, `FromAgentId` VARCHAR(64) NOT NULL, `DestinationAgentId` VARCHAR(64) NOT NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `ApprovedByDestinationAgent` TINYINT(1) NOT NULL DEFAULT 0, `ApprovedDestinationAgentDate` DATETIME(6) NULL, `ApprovedByAdmin` TINYINT(1) NOT NULL DEFAULT 0, `ApprovedAdminDate` DATETIME(6) NULL, `AdminId` VARCHAR(64) NULL, `PropertyActionsTypeId` INT NOT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_RequestActions_Request` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Request` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_RequestActions_LKUP_PorpertyActionsType` FOREIGN KEY (`PropertyActionsTypeId`) REFERENCES `RealEstate`.`LKUP_PorpertyActionsType` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:25:49 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_CostType` ( `Id` INT NOT NULL, `Description` VARCHAR(250) CHARACTER SET 'utf8mb4' NOT NULL, `CostCategoryId` INT NULL, PRIMARY KEY (`Id`)) 10:25:49 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_PAUSED_TRIGGER_GRPS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`)) 10:25:50 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ContractType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:50 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_WebEvent_Events` ( `EventId` CHAR(32) NOT NULL, `EventTimeUtc` DATETIME(6) NOT NULL, `EventTime` DATETIME(6) NOT NULL, `EventType` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `EventSequence` BIGINT NOT NULL, `EventOccurrence` BIGINT NOT NULL, `EventCode` INT NOT NULL, `EventDetailCode` INT NOT NULL, `Message` VARCHAR(1024) CHARACTER SET 'utf8mb4' NULL, `ApplicationPath` VARCHAR(256) CHARACTER SET 'utf8mb4' NULL, `ApplicationVirtualPath` VARCHAR(256) CHARACTER SET 'utf8mb4' NULL, `MachineName` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `RequestUrl` VARCHAR(1024) CHARACTER SET 'utf8mb4' NULL, `ExceptionType` VARCHAR(256) CHARACTER SET 'utf8mb4' NULL, `Details` LONGTEXT NULL, PRIMARY KEY (`EventId`)) 10:25:50 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_SCHEDULER_STATE` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `INSTANCE_NAME` VARCHAR(200) CHARACTER SET 'utf8mb4' NOT NULL, `LAST_CHECKIN_TIME` BIGINT NOT NULL, `CHECKIN_INTERVAL` BIGINT NOT NULL, PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`)) 10:25:50 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Reminder` ( `Id` VARCHAR(64) NOT NULL, `DepartmentId` VARCHAR(64) NOT NULL, `NatureId` VARCHAR(64) NOT NULL, `StartTime` DATETIME(6) NOT NULL, `EndTime` DATETIME(6) NOT NULL, `Location` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `Comments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Recurrence` VARCHAR(1) NULL, `RecurrenceEnd` DATETIME(6) NULL, `RecurrenceId` VARCHAR(64) NULL, `Agents` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Contacts` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Properties` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Requests` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CallSheets` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Closed` TINYINT(1) NULL, `RelatedId` VARCHAR(64) NULL, `SendReminderSms` TINYINT(1) NULL, `SmsSent` TINYINT(1) NULL, `StatusId` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CloseDate` DATETIME(6) NULL, `SurResponseId` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Feedback` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SyncWithGoogle` TINYINT(1) NULL, `Synced` TINYINT(1) NULL, `SyncDate` DATETIME(6) NULL, `GcId` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Deleted` TINYINT(1) NULL, `Inspection` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Showings` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CreatedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ModifiedBy` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_Reminder_LKUP_ReminderNature` FOREIGN KEY (`NatureId`) REFERENCES `RealEstate`.`LKUP_ReminderNature` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:25:51 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_SIMPLE_TRIGGERS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `REPEAT_COUNT` INT NOT NULL, `REPEAT_INTERVAL` BIGINT NOT NULL, `TIMES_TRIGGERED` INT NOT NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`), CONSTRAINT `FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS` FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`) REFERENCES `RealEstate`.`QRTZ_TRIGGERS` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`) ON DELETE CASCADE ON UPDATE NO ACTION) 10:25:51 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ExportedProperties` ( `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `ExportedContent` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`PRL`)) 10:25:51 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Grade` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:51 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_SIMPROP_TRIGGERS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `STR_PROP_1` VARCHAR(512) CHARACTER SET 'utf8mb4' NULL, `STR_PROP_2` VARCHAR(512) CHARACTER SET 'utf8mb4' NULL, `STR_PROP_3` VARCHAR(512) CHARACTER SET 'utf8mb4' NULL, `INT_PROP_1` INT NULL, `INT_PROP_2` INT NULL, `LONG_PROP_1` BIGINT NULL, `LONG_PROP_2` BIGINT NULL, `DEC_PROP_1` DECIMAL(13,4) NULL, `DEC_PROP_2` DECIMAL(13,4) NULL, `BOOL_PROP_1` TINYINT(1) NULL, `BOOL_PROP_2` TINYINT(1) NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`), CONSTRAINT `FK_QRTZ_SIMPROP_TRIGGERS_QRTZ_TRIGGERS` FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`) REFERENCES `RealEstate`.`QRTZ_TRIGGERS` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`) ON DELETE CASCADE ON UPDATE NO ACTION) 10:25:51 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`RequestLocation` ( `Id` VARCHAR(64) NOT NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `CountryId` INT NULL, `QadaaId` INT NOT NULL, `DistrictId` INT NULL, `NeighborhoodId` INT NULL, `LookUpProperty` INT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_RequestLocation_Request` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Request` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:53 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ExportToCSV` ( `Id` VARCHAR(64) NOT NULL, `LastImport` DATETIME(6) NULL, `ContactId` VARCHAR(64) NULL, PRIMARY KEY (`Id`)) 10:25:53 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ClientType` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:25:53 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Inspection` ( `Id` VARCHAR(64) NOT NULL, `InspectionTypeId` INT NOT NULL, `InspectionLevelId` INT NOT NULL, `Comments` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `Date` DATE NOT NULL, `InspectionAreaId` INT NULL, `Deadline` DATE NULL, `EndDate` DATE NULL, PRIMARY KEY (`Id`)) 10:25:53 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`QRTZ_TRIGGERS` ( `SCHED_NAME` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `JOB_NAME` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `JOB_GROUP` VARCHAR(150) CHARACTER SET 'utf8mb4' NOT NULL, `DESCRIPTION` VARCHAR(250) CHARACTER SET 'utf8mb4' NULL, `NEXT_FIRE_TIME` BIGINT NULL, `PREV_FIRE_TIME` BIGINT NULL, `PRIORITY` INT NULL, `TRIGGER_STATE` VARCHAR(16) CHARACTER SET 'utf8mb4' NOT NULL, `TRIGGER_TYPE` VARCHAR(8) CHARACTER SET 'utf8mb4' NOT NULL, `START_TIME` BIGINT NOT NULL, `END_TIME` BIGINT NULL, `CALENDAR_NAME` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL, `MISFIRE_INSTR` INT NULL, `JOB_DATA` LONGBLOB NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`), CONSTRAINT `FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS` FOREIGN KEY (`SCHED_NAME` , `JOB_NAME` , `JOB_GROUP`) REFERENCES `RealEstate`.`QRTZ_JOB_DETAILS` (`SCHED_NAME` , `JOB_NAME` , `JOB_GROUP`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:25:54 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LogEntries` ( `ID` VARCHAR(64) NOT NULL, `Timestamp` DATETIME(6) NULL, `PRL` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `Operation` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `AgentID` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`ID`)) 10:25:54 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Level` ( `ID` INT NOT NULL, `Level` CHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `LevelOrder` INT NULL, PRIMARY KEY (`ID`)) 10:25:54 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_District` ( `Id` INT NOT NULL, `QadaaId` INT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_LKUP_District_LKUP_Qadaa` FOREIGN KEY (`QadaaId`) REFERENCES `RealEstate`.`LKUP_Qadaa` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE) 10:25:54 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_InspectionType` ( `ID` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `TypeOrder` INT NULL, PRIMARY KEY (`ID`)) 10:25:56 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ViewAgents` ( `UserName` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `Agents` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`UserName`)) 10:25:56 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationCallSheet` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `IDS` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:25:56 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Qadaa` ( `Id` INT NOT NULL, `CountryId` INT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_LKUP_Qadaa_LKUP_Country` FOREIGN KEY (`CountryId`) REFERENCES `RealEstate`.`LKUP_Country` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE) 10:25:56 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`GridHead` ( `UserName` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `GridName` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `GridColumns` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`UserName`, `GridName`)) 10:25:56 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Neighborhood` ( `Id` INT NOT NULL, `DistrictId` INT NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`), CONSTRAINT `FK_LKUP_Neighborhood_LKUP_District` FOREIGN KEY (`DistrictId`) REFERENCES `RealEstate`.`LKUP_District` (`Id`) ON DELETE NO ACTION ON UPDATE CASCADE) 10:25:58 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ShowingDocuments` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Documents` LONGBLOB NOT NULL, `DocumentName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Extension` VARCHAR(5) CHARACTER SET 'utf8mb4' NOT NULL, `DocDate` DATETIME(6) NULL, `ShowingId` VARCHAR(64) NULL, PRIMARY KEY (`Id`)) 10:25:58 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationCallSheetMonthly` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `IDS` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `MonthNbr` INT NOT NULL, `Year` INT NOT NULL, PRIMARY KEY (`Id`)) 10:25:58 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`InspectionDetailsCat` ( `id` VARCHAR(64) NOT NULL, `InspId` VARCHAR(64) NOT NULL, `CatId` INT NULL, `Category` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SubCatId` INT NULL, `SubCategory` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `InspectionSubId` INT NULL, `InspectionSubCategory` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `InspOrder` INT NULL, PRIMARY KEY (`id`)) 10:25:58 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Showings` ( `Id` VARCHAR(64) NOT NULL, `ShowingListId` VARCHAR(64) NOT NULL, `PRL` VARCHAR(40) CHARACTER SET 'utf8mb4' NOT NULL, `PropertyDescription` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Price` INT NULL, `BuyerComment` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `SmsSent` TINYINT(1) NULL, `OrderPRL` SMALLINT NULL, `ChkHide` TINYINT(1) NULL, PRIMARY KEY (`Id`), UNIQUE INDEX `IX_Showings` (`PRL` ASC, `ShowingListId` ASC) VISIBLE, CONSTRAINT `FK_Showings_ShowingList` FOREIGN KEY (`ShowingListId`) REFERENCES `RealEstate`.`ShowingList` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_Showings_Property` FOREIGN KEY (`PRL`) REFERENCES `RealEstate`.`Property` (`PRL`) ON DELETE CASCADE ON UPDATE CASCADE) 10:25:59 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_InspCategory` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `orderId` INT NULL, PRIMARY KEY (`Id`)) 10:25:59 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationCallSheetWeekly` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `IDS` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, `WeekNbr` INT NOT NULL, `Year` INT NOT NULL, PRIMARY KEY (`Id`)) 10:25:59 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_InspectionSub` ( `Id` INT NOT NULL, `SubCatId` INT NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:25:59 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Department` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `Location` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `PhoneNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `FaxNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `CellNumber` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `SeqNumber` VARCHAR(2) NULL, `Logo` VARCHAR(400) CHARACTER SET 'utf8mb4' NULL, `Currency` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `AreaUnit` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `TraSubSeqNum` INT NULL, `TraSubSeqType` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `DefaultExtension` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:26:01 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Sur_Survey_Response` ( `ID` INT NOT NULL, `SurveyID` INT NOT NULL, `QuestionID` INT NOT NULL, `Response` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `ContactId` VARCHAR(64) NULL, `AgentId` VARCHAR(64) NULL, `RequestId` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `Project` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `ResponseDate` DATETIME(6) NULL, PRIMARY KEY (`ID`), CONSTRAINT `FK_Sur_Survey_Response_Sur_Questions` FOREIGN KEY (`QuestionID`) REFERENCES `RealEstate`.`Sur_Questions` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_Sur_Survey_Response_Sur_Surveys` FOREIGN KEY (`SurveyID`) REFERENCES `RealEstate`.`Sur_Surveys` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION) 10:26:01 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`SystemVariables` ( `PercentagePerSeniorAgent` TINYINT UNSIGNED NOT NULL DEFAULT 0, `PercentagePerJuniorAgent` TINYINT UNSIGNED NOT NULL DEFAULT 0, `PercentagePerReferral` TINYINT UNSIGNED NOT NULL DEFAULT 0) 10:26:03 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Pages` ( `ID` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `Category` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`ID`, `Category`)) 10:26:03 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_InspSubCategory` ( `Id` INT NOT NULL, `CatId` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:26:03 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationExpiredProperties` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `PRL` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:26:03 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationNewRequests` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `PRL` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:26:04 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_CurrentPropertyStatus` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:26:04 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertySizes` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:26:04 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_ReminderStatus` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:26:04 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ReminderDocuments` ( `Id` VARCHAR(64) NOT NULL, `Description` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Documents` LONGBLOB NOT NULL, `DocumentName` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Extension` VARCHAR(5) CHARACTER SET 'utf8mb4' NOT NULL, `DocDate` DATETIME(6) NULL, `ReminderId` VARCHAR(64) NULL, PRIMARY KEY (`Id`)) 10:26:04 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`Configuration` ( `KeySetting` VARCHAR(50) CHARACTER SET 'utf8mb4' NOT NULL, `ValueSetting` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Description` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL, `Show` TINYINT(1) NULL, PRIMARY KEY (`KeySetting`)) 10:26:06 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertyView` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:26:06 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_PropertyFor` ( `Id` INT NOT NULL, `Description` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:26:06 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`MaintenanceWorkOrder` ( `Id` VARCHAR(64) NOT NULL, `Prl` VARCHAR(20) CHARACTER SET 'utf8mb4' NOT NULL, `RequestDate` DATETIME(6) NULL, `RequestProjCode` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `RequestById` VARCHAR(64) NULL, `RequestCostCode` VARCHAR(20) CHARACTER SET 'utf8mb4' NULL, `RequestOrigin` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `RequestClass` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `RequestPriority` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `RequestDestination` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `RequestFacilityLocation` VARCHAR(500) CHARACTER SET 'utf8mb4' NULL, `RequestFacilityCode` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `RequestWorkDescription` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `RequestSupervisorId` VARCHAR(64) NULL, `RequestProjectManagerId` VARCHAR(64) NULL, `CompletionPlannedStartDate` DATETIME(6) NULL, `CompletionWorkStartDate` DATETIME(6) NULL, `CompletionExpectedDate` DATETIME(6) NULL, `CompletionEndDate` DATETIME(6) NULL, `CompletionDescOfWork` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `CompletionWorkPerformedById` VARCHAR(64) NULL, `CompletionSupervisor` VARCHAR(64) NULL, `CompletionProjectManager` VARCHAR(64) NULL, PRIMARY KEY (`Id`)) 10:26:08 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`SmsPack` ( `Id` VARCHAR(64) NOT NULL, `SmsAvailable` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `SmsSent` VARCHAR(1000) CHARACTER SET 'utf8mb4' NULL, `DateFrom` DATE NULL, `DateTo` DATE NULL, PRIMARY KEY (`Id`)) 10:26:08 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationPendingProperties` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `PRL` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:26:08 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ViewState` ( `ViewStateId` VARCHAR(64) NOT NULL, `Value` LONGBLOB NOT NULL, `LastAccessed` DATETIME(6) NOT NULL, `Timeout` INT NOT NULL, PRIMARY KEY (`ViewStateId`)) 10:26:08 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`aspnet_Applications` ( `ApplicationName` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `LoweredApplicationName` VARCHAR(256) CHARACTER SET 'utf8mb4' NOT NULL, `ApplicationId` VARCHAR(64) NOT NULL, `Description` VARCHAR(256) CHARACTER SET 'utf8mb4' NULL, INDEX `aspnet_Applications_Index` (`LoweredApplicationName`(255) ASC) VISIBLE, PRIMARY KEY (`ApplicationId`), UNIQUE INDEX `UQ__aspnet_Applicati__7F60ED59` (`LoweredApplicationName`(255) ASC) VISIBLE, UNIQUE INDEX `UQ__aspnet_Applicati__00551192` (`ApplicationName`(255) ASC) VISIBLE) 10:26:10 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_SmsText` ( `Id` VARCHAR(64) NOT NULL, `ModuleName` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, `ModuleText` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:26:10 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`ShowHideFields` ( `UserName` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `PageId` VARCHAR(100) CHARACTER SET 'utf8mb4' NOT NULL, `PageFields` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `TypeFields` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `TypeFieldId` VARCHAR(100) CHARACTER SET 'utf8mb4' NULL) 10:26:10 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`LKUP_Referral` ( `ID` INT NOT NULL, `Description` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`ID`)) 10:26:10 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`NotificationPendingRequests` ( `Id` VARCHAR(64) NOT NULL, `NotificationSent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `PRL` VARCHAR(0) CHARACTER SET 'utf8mb4' NOT NULL, PRIMARY KEY (`Id`)) 10:26:10 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `RealEstate`.`CampaignSMS` ( `Id` VARCHAR(64) NOT NULL, `CampaignID` VARCHAR(64) NULL, `ContactId` VARCHAR(64) NULL, `Phone` VARCHAR(150) CHARACTER SET 'utf8mb4' NULL, `SmsContent` VARCHAR(0) CHARACTER SET 'utf8mb4' NULL, `Sent` TINYINT(1) NULL DEFAULT 0, `DateSent` DATETIME(6) NULL, `SenderUser` VARCHAR(50) CHARACTER SET 'utf8mb4' NULL, PRIMARY KEY (`Id`)) 10:26:12 [INF][ grt]: Scripts for 149 tables, 0 views and 0 routines were executed for schema RealEstate 10:26:12 [INF][ grt]: Execute statement SET FOREIGN_KEY_CHECKS = 1 10:26:43 [WRN][ mforms]: Resource file not found: migration_check_done_win.png 10:26:43 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 10:26:48 [WRN][ mforms]: Resource file not found: migration_check_done_win.png 10:26:48 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 10:26:52 [WRN][ mforms]: Resource file not found: migration_check_done_win.png 10:26:52 [WRN][ mforms]: Resource file not found: migration_check_current_win.png 10:26:52 [INF][ Wizard]: Execute 'Prepare information for data copy' 10:26:52 [INF][ Wizard]: Starting thread for 'Determine number of rows to copy' 10:26:56 [INF][ Wizard]: Starting thread for 'Copy data to target RDBMS' 10:26:57 [ERR][ Migration]: `RealEstate`.`DetailedInspection`:Inserting Data: Data too long for column 'InspAddress' at row 1 10:26:57 [ERR][ Migration]: `RealEstate`.`DetailedInspection`:Failed copying 6 rows 10:26:57 [ERR][ Migration]: `RealEstate`.`PropertyOffer`:Inserting Data: Data too long for column 'PropertyDesc' at row 1 10:26:57 [ERR][ Migration]: `RealEstate`.`PropertyOffer`:Failed copying 13 rows 10:26:57 [ERR][ Migration]: `RealEstate`.`ShowingList`:Inserting Data: Data too long for column 'Comment' at row 1 10:26:57 [ERR][ Migration]: `RealEstate`.`ShowingList`:Failed copying 666 rows 10:26:57 [ERR][ Migration]: `RealEstate`.`TraSub`:Inserting Data: Data too long for column 'Payments' at row 1 10:26:57 [ERR][ Migration]: `RealEstate`.`TraSub`:Failed copying 830 rows 10:26:58 [ERR][ Migration]: `RealEstate`.`LKUP_ShowingFeatures`:Inserting Data: Data too long for column 'Description' at row 1 10:26:58 [ERR][ Migration]: `RealEstate`.`LKUP_ShowingFeatures`:Failed copying 3 rows 10:26:58 [ERR][ Migration]: `RealEstate`.`ShowingRelatedFeatures`:Inserting Data: Data too long for column 'Description' at row 1 10:26:58 [ERR][ Migration]: `RealEstate`.`ShowingRelatedFeatures`:Failed copying 7 rows 10:26:58 [ERR][ Migration]: `RealEstate`.`LKUP_ClientStatus`:Inserting Data: Data too long for column 'Description' at row 1 10:26:58 [ERR][ Migration]: `RealEstate`.`LKUP_ClientStatus`:Failed copying 2 rows 10:26:58 [ERR][ Migration]: `RealEstate`.`Notifications`:Inserting Data: Data too long for column 'ToName' at row 1 10:26:58 [ERR][ Migration]: `RealEstate`.`Notifications`:Failed copying 7870 rows 10:26:58 [ERR][ Migration]: `RealEstate`.`NotificationReminder`:Inserting Data: Data too long for column 'IDS' at row 1 10:26:58 [ERR][ Migration]: `RealEstate`.`NotificationReminder`:Failed copying 2 rows 10:27:17 [ERR][ Migration]: `RealEstate`.`Request`:Inserting Data: Data too long for column 'ReferencedBy' at row 4 10:27:17 [ERR][ Migration]: `RealEstate`.`Request`:Failed copying 221 rows 10:27:17 [ERR][ Migration]: `RealEstate`.`Transactions`:Inserting Data: Data too long for column 'Comment' at row 1 10:27:17 [ERR][ Migration]: `RealEstate`.`Transactions`:Failed copying 97 rows 10:27:17 [ERR][ Migration]: `RealEstate`.`PropertyRelatedFeatures`:Inserting Data: Data too long for column 'Description' at row 1 10:27:17 [ERR][ Migration]: `RealEstate`.`PropertyRelatedFeatures`:Failed copying 8906 rows 10:27:17 [ERR][ Migration]: `RealEstate`.`LKUP_Priority`:Inserting Data: Data too long for column 'Description' at row 1 10:27:17 [ERR][ Migration]: `RealEstate`.`LKUP_Priority`:Failed copying 3 rows 10:27:19 [ERR][ Migration]: `RealEstate`.`PropertyImages`:Found record bigger than max_allowed_packet 10:27:20 [ERR][ Migration]: `RealEstate`.`PropertyImages`:Failed copying 217 rows 10:27:20 [ERR][ Migration]: `RealEstate`.`LKUP_CostCategory`:Inserting Data: Data too long for column 'Description' at row 1 10:27:20 [ERR][ Migration]: `RealEstate`.`LKUP_CostCategory`:Failed copying 4 rows 10:27:20 [ERR][ Migration]: `RealEstate`.`LKUP_TranConditions`:Inserting Data: Data too long for column 'Description' at row 1 10:27:20 [ERR][ Migration]: `RealEstate`.`LKUP_TranConditions`:Failed copying 12 rows 10:27:20 [ERR][ Migration]: `RealEstate`.`RequestComments`:Inserting Data: Data too long for column 'Comments' at row 1 10:27:20 [ERR][ Migration]: `RealEstate`.`RequestComments`:Failed copying 49 rows 10:27:21 [ERR][ Migration]: `RealEstate`.`CallSheet`:Inserting Data: Data too long for column 'CallerName' at row 1 10:27:21 [ERR][ Migration]: `RealEstate`.`CallSheet`:Failed copying 144 rows 10:27:21 [ERR][ Migration]: `RealEstate`.`LKUP_TranFollowUp`:Inserting Data: Data too long for column 'Description' at row 1 10:27:21 [ERR][ Migration]: `RealEstate`.`LKUP_TranFollowUp`:Failed copying 2 rows 10:27:25 [ERR][ Wizard]: Thread 'Copy data to target RDBMS' failed: list index out of range