Manticore service crash upon start and keep restarting

Describe the bug
Manticore searchd service crashes upon start when trying to precache existing index and keeps restarting with the same error.

To Reproduce

I delete all existing indexes from /var/lib/manticore/ data dir.
Restart the searchd service.
Create the new index.
Restart the search service. It refuses to start again.

Expected behavior
Should tell me what is wrong with the index or start normally.

Describe the environment:
Manticore 5.0.3 c53b5f13c@220918 dev (columnar 1.16.1 2cc9cbe@220918) (secondary 1.16.1 2cc9cbe@220918)
Linux vicy-ThinkPad-T540p 4.15.0-188-generic #199-Ubuntu SMP Wed Jun 15 20:42:56 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux

Messages from log files:

[Mon Sep 19 12:21:39.517 2022] [1226] watchdog: main process 1260 killed dirtily with signal 6, core dumped, will be restarted  
[Mon Sep 19 12:21:39.517 2022] [1226] watchdog: main process 1278 forked ok  
[Mon Sep 19 12:21:39.517 2022] [1278] starting daemon version '5.0.3 c53b5f13c@220918 dev (columnar 1.16.1 2cc9cbe@220918) (secondary 1.16.1 2cc9cbe@220918)' ...  
[Mon Sep 19 12:21:39.518 2022] [1278] listening on 127.0.0.1:9312 for sphinx and http(s)  
[Mon Sep 19 12:21:39.518 2022] [1278] listening on 127.0.0.1:9306 for mysql  
[Mon Sep 19 12:21:39.518 2022] [1278] listening on 127.0.0.1:9308 for sphinx and http(s)  

--- crashed invalid query ---  

--- request dump end ---  
--- local index:  
Manticore 5.0.3 c53b5f13c@220918 dev (columnar 1.16.1 2cc9cbe@220918) (secondary 1.16.1 2cc9cbe@220918)  
Handling signal 6  
-------------- backtrace begins here ---------------  
Program compiled with Clang 13.0.1  
Configured with flags: Configured with these definitions: -DDISTR_BUILD=bionic -DUSE_SYSLOG=1 -DWITH_GALERA=1 -DWITH_RE2=1 -DWITH_RE2_FORCE_STATIC=1 -DWITH_STEMMER=1 -DWITH_STEMMER_FORCE_STATIC=1 -DWITH_ICU=1 -D  
WITH_ICU_FORCE_STATIC=1 -DWITH_SSL=1 -DWITH_ZLIB=1 -DWITH_ZSTD=1 -DDL_ZSTD=1 -DZSTD_LIB=libzstd.so.1 -DWITH_ODBC=1 -DDL_ODBC=1 -DODBC_LIB=libodbc.so.2 -DWITH_EXPAT=1 -DDL_EXPAT=1 -DEXPAT_LIB=libexpat.so.1 -DWITH  
_ICONV=1 -DWITH_MYSQL=1 -DDL_MYSQL=1 -DMYSQL_LIB=libmysqlclient.so.20 -DWITH_POSTGRESQL=1 -DDL_POSTGRESQL=1 -DPOSTGRESQL_LIB=libpq.so.5 -DLOCALDATADIR=/var/lib/manticore/data -DFULL_SHARE_DIR=/usr/share/manticor  
e  
Built on Linux x86_64 (bionic) (cross-compiled)  
Stack bottom = 0x22417f0, thread stack size = 0x20000  
Trying manual backtrace:  
Something wrong with thread stack, manual backtrace may be incorrect (fp=0x1)  
Wrong stack limit or frame pointer, manual backtrace failed (fp=0x1, stack=0x2240000, stacksize=0x20000)  
Trying system backtrace:  
begin of system symbols:  
/usr/bin/searchd[0x6f1ad1]  
/usr/bin/searchd[0x5c9b1f]  
/lib/x86_64-linux-gnu/libpthread.so.0( 0x12980)[0x7f2e7e41d980]  
/lib/x86_64-linux-gnu/libc.so.6(gsignal 0xc7)[0x7f2e7e058e87]  
/lib/x86_64-linux-gnu/libc.so.6(abort 0x141)[0x7f2e7e05a7f1]  
/lib/x86_64-linux-gnu/libc.so.6( 0x89837)[0x7f2e7e0a3837]  
/lib/x86_64-linux-gnu/libc.so.6( 0x908ba)[0x7f2e7e0aa8ba]  
/lib/x86_64-linux-gnu/libc.so.6(cfree 0x4dc)[0x7f2e7e0b1dec]  
/usr/bin/searchd[0xa5266e]  
/usr/bin/searchd[0x99af47]  
/usr/bin/searchd[0xaa8e39]  
/usr/bin/searchd[0x6186db]  
/usr/bin/searchd[0x6187cc]  
/usr/bin/searchd[0x61ff41]  
/usr/bin/searchd[0x58dd04]  
/usr/bin/searchd[0x58db69]  
/usr/bin/searchd[0x62e890]  
/usr/bin/searchd[0xedb43c]  
/usr/bin/searchd[0xef9d3f]  
Trying boost backtrace:  
 0# 0x00000000006F1B21 in /usr/bin/searchd  
 1# 0x00000000005C9B1F in /usr/bin/searchd  
 2# 0x00007F2E7E41D980 in /lib/x86_64-linux-gnu/libpthread.so.0  
 3# gsignal in /lib/x86_64-linux-gnu/libc.so.6  
 4# abort in /lib/x86_64-linux-gnu/libc.so.6  
 5# 0x00007F2E7E0A3837 in /lib/x86_64-linux-gnu/libc.so.6  
 6# 0x00007F2E7E0AA8BA in /lib/x86_64-linux-gnu/libc.so.6  
 7# cfree in /lib/x86_64-linux-gnu/libc.so.6  
 8# 0x0000000000A5266E in /usr/bin/searchd  
 9# 0x000000000099AF47 in /usr/bin/searchd  
10# 0x0000000000AA8E39 in /usr/bin/searchd  
11# 0x00000000006186DB in /usr/bin/searchd  
12# 0x00000000006187CC in /usr/bin/searchd  
13# 0x000000000061FF41 in /usr/bin/searchd  
14# 0x000000000058DD04 in /usr/bin/searchd  
15# 0x000000000058DB69 in /usr/bin/searchd  
16# 0x000000000062E890 in /usr/bin/searchd  
17# 0x0000000000EDB43C in /usr/bin/searchd  
18# 0x0000000000EF9D3F in /usr/bin/searchd  

-------------- backtrace ends here ---------------  
Please, create a bug report in our bug tracker (https://github.com/manticoresoftware/manticore/issues)  
and attach there:  
a) searchd log, b) searchd binary, c) searchd symbols.  
Look into the chapter 'Reporting bugs' in the manual  
(https://manual.manticoresearch.com/Reporting_bugs)  
Dump with GDB via watchdog  
--- active threads ---  
--- Totally 0 threads, and 0 client-working threads ---  
------- CRASH DUMP END -------

searchd output

/usr/bin/searchd -c /etc/manticoresearch/manticore.conf --coredump  
Manticore 5.0.3 c53b5f13c@220918 dev (columnar 1.16.1 2cc9cbe@220918) (secondary 1.16.1 2cc9cbe@220918)  
Copyright (c) 2001-2016, Andrew Aksyonoff  
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)  
Copyright (c) 2017-2022, Manticore Software LTD (https://manticoresearch.com)  

[21:27.344] [1224] using config file '/etc/manticoresearch/manticore.conf' (378 chars)...  
starting daemon version '5.0.3 c53b5f13c@220918 dev (columnar 1.16.1 2cc9cbe@220918) (secondary 1.16.1 2cc9cbe@220918)' ...  
listening on 127.0.0.1:9312 for sphinx and http(s)  
listening on 127.0.0.1:9306 for mysql  
listening on 127.0.0.1:9308 for sphinx and http(s)  
precaching index 'tiki_main_6328288826daf'  
free(): invalid pointer  
Crash!!! Handling signal 6

gdb output of the core dump

gdb /usr/bin/searchd /var/crash/core.work_1.1227.vicy-ThinkPad-T540p.1663579290   
GNU gdb (Ubuntu 8.1.1-0ubuntu1) 8.1.1  
Copyright (C) 2018 Free Software Foundation, Inc.  
License GPLv3 : GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>  
This is free software: you are free to change and redistribute it.  
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"  
and "show warranty" for details.  
This GDB was configured as "x86_64-linux-gnu".  
Type "show configuration" for configuration details.  
For bug reporting instructions, please see:  
<http://www.gnu.org/software/gdb/bugs/>.  
Find the GDB manual and other documentation resources online at:  
<http://www.gnu.org/software/gdb/documentation/>.  
For help, type "help".  
Type "apropos word" to search for commands related to "word"...  
Reading symbols from /usr/bin/searchd...(no debugging symbols found)...done.  
[New LWP 1229]  
[New LWP 1227]  
[New LWP 1228]  
[New LWP 1232]  
[New LWP 1234]  
[New LWP 1231]  
[New LWP 1233]  
[New LWP 1236]  
[New LWP 1235]  
[New LWP 1237]  
[Thread debugging using libthread_db enabled]  
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".  
Core was generated by `/usr/bin/searchd -c /etc/manticoresearch/manticore.conf --coredump'.  
Program terminated with signal SIGABRT, Aborted.  
#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51  
51../sysdeps/unix/sysv/linux/raise.c: No such file or directory.  
[Current thread is 1 (Thread 0x7f2e7fdba700 (LWP 1229))]  
(gdb) set pagination off  
(gdb) info threads  
  Id   Target Id         Frame   
* 1    Thread 0x7f2e7fdba700 (LWP 1229) __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51  
  2    Thread 0x7f2e7fee1800 (LWP 1227) 0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x7ffcdaa025d0) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
  3    Thread 0x7f2e7ff13700 (LWP 1228) 0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x21ea864) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
  4    Thread 0x7f2e7fd78700 (LWP 1232) 0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x21ea864) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
  5    Thread 0x7f2e7fd36700 (LWP 1234) 0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x21ea860) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
  6    Thread 0x7f2e7fd99700 (LWP 1231) 0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x21ea864) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
  7    Thread 0x7f2e7fd57700 (LWP 1233) 0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x21ea860) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
  8    Thread 0x7f2e7dba9700 (LWP 1236) 0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x21ea860) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
  9    Thread 0x7f2e7dbca700 (LWP 1235) 0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x21ea860) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
  10   Thread 0x7f2e7db88700 (LWP 1237) 0x00007f2e7e419065 in futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f2e7db87da8, expected=0, futex_word=0xf13e28) at ../sysdeps/unix/sysv/linux/futex-internal.h:205  
(gdb) thread apply all bt  

Thread 10 (Thread 0x7f2e7db88700 (LWP 1237)):  
#0  0x00007f2e7e419065 in futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f2e7db87da8, expected=0, futex_word=0xf13e28) at ../sysdeps/unix/sysv/linux/futex-internal.h:205  
#1  __pthread_cond_wait_common (abstime=0x7f2e7db87da8, mutex=0xf13e30, cond=0xf13e00) at pthread_cond_wait.c:539  
#2  __pthread_cond_timedwait (cond=0xf13e00, mutex=0xf13e30, abstime=0x7f2e7db87da8) at pthread_cond_wait.c:667  
#3  0x000000000064781e in ?? ()  
#4  0x0000000000ab5e10 in ?? ()  
#5  0x0000000000a8dbf5 in ?? ()  
#6  0x0000000000a8dc97 in ?? ()  
#7  0x00007f2e7e4126db in start_thread (arg=0x7f2e7db88700) at pthread_create.c:463  
#8  0x00007f2e7e13b61f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95  

Thread 9 (Thread 0x7f2e7dbca700 (LWP 1235)):  
#0  0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x21ea860) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
#1  __pthread_cond_wait_common (abstime=0x0, mutex=0x21ea808, cond=0x21ea838) at pthread_cond_wait.c:502  
#2  __pthread_cond_wait (cond=0x21ea838, mutex=0x21ea808) at pthread_cond_wait.c:655  
#3  0x0000000000a90781 in ?? ()  
#4  0x0000000000a9063e in ?? ()  
#5  0x0000000000a90425 in ?? ()  
#6  0x0000000000a8ee57 in ?? ()  
#7  0x0000000000a8dbf5 in ?? ()  
#8  0x0000000000a8dc97 in ?? ()  
#9  0x00007f2e7e4126db in start_thread (arg=0x7f2e7dbca700) at pthread_create.c:463  
#10 0x00007f2e7e13b61f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95  

Thread 8 (Thread 0x7f2e7dba9700 (LWP 1236)):  
#0  0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x21ea860) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
#1  __pthread_cond_wait_common (abstime=0x0, mutex=0x21ea808, cond=0x21ea838) at pthread_cond_wait.c:502  
#2  __pthread_cond_wait (cond=0x21ea838, mutex=0x21ea808) at pthread_cond_wait.c:655  
#3  0x0000000000a90781 in ?? ()  
#4  0x0000000000a9063e in ?? ()  
#5  0x0000000000a90425 in ?? ()  
#6  0x0000000000a8ee57 in ?? ()  
#7  0x0000000000a8dbf5 in ?? ()  
#8  0x0000000000a8dc97 in ?? ()  
#9  0x00007f2e7e4126db in start_thread (arg=0x7f2e7dba9700) at pthread_create.c:463  
#10 0x00007f2e7e13b61f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95  

Thread 7 (Thread 0x7f2e7fd57700 (LWP 1233)):  
#0  0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x21ea860) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
#1  __pthread_cond_wait_common (abstime=0x0, mutex=0x21ea808, cond=0x21ea838) at pthread_cond_wait.c:502  
#2  __pthread_cond_wait (cond=0x21ea838, mutex=0x21ea808) at pthread_cond_wait.c:655  
#3  0x0000000000a90781 in ?? ()  
#4  0x0000000000a9063e in ?? ()  
#5  0x0000000000a90425 in ?? ()  
#6  0x0000000000a8ee57 in ?? ()  
#7  0x0000000000a8dbf5 in ?? ()  
#8  0x0000000000a8dc97 in ?? ()  
#9  0x00007f2e7e4126db in start_thread (arg=0x7f2e7fd57700) at pthread_create.c:463  
#10 0x00007f2e7e13b61f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95  

Thread 6 (Thread 0x7f2e7fd99700 (LWP 1231)):  
#0  0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x21ea864) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
#1  __pthread_cond_wait_common (abstime=0x0, mutex=0x21ea808, cond=0x21ea838) at pthread_cond_wait.c:502  
#2  __pthread_cond_wait (cond=0x21ea838, mutex=0x21ea808) at pthread_cond_wait.c:655  
#3  0x0000000000a90781 in ?? ()  
#4  0x0000000000a9063e in ?? ()  
#5  0x0000000000a90425 in ?? ()  
#6  0x0000000000a8ee57 in ?? ()  
#7  0x0000000000a8dbf5 in ?? ()  
#8  0x0000000000a8dc97 in ?? ()  
#9  0x00007f2e7e4126db in start_thread (arg=0x7f2e7fd99700) at pthread_create.c:463  
#10 0x00007f2e7e13b61f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95  

Thread 5 (Thread 0x7f2e7fd36700 (LWP 1234)):  
#0  0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x21ea860) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
#1  __pthread_cond_wait_common (abstime=0x0, mutex=0x21ea808, cond=0x21ea838) at pthread_cond_wait.c:502  
#2  __pthread_cond_wait (cond=0x21ea838, mutex=0x21ea808) at pthread_cond_wait.c:655  
#3  0x0000000000a90781 in ?? ()  
#4  0x0000000000a9063e in ?? ()  
#5  0x0000000000a90425 in ?? ()  
#6  0x0000000000a8ee57 in ?? ()  
#7  0x0000000000a8dbf5 in ?? ()  
#8  0x0000000000a8dc97 in ?? ()  
#9  0x00007f2e7e4126db in start_thread (arg=0x7f2e7fd36700) at pthread_create.c:463  
#10 0x00007f2e7e13b61f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95  

Thread 4 (Thread 0x7f2e7fd78700 (LWP 1232)):  
#0  0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x21ea864) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
#1  __pthread_cond_wait_common (abstime=0x0, mutex=0x21ea808, cond=0x21ea838) at pthread_cond_wait.c:502  
#2  __pthread_cond_wait (cond=0x21ea838, mutex=0x21ea808) at pthread_cond_wait.c:655  
#3  0x0000000000a90781 in ?? ()  
#4  0x0000000000a9063e in ?? ()  
#5  0x0000000000a90425 in ?? ()  
#6  0x0000000000a8ee57 in ?? ()  
#7  0x0000000000a8dbf5 in ?? ()  
#8  0x0000000000a8dc97 in ?? ()  
#9  0x00007f2e7e4126db in start_thread (arg=0x7f2e7fd78700) at pthread_create.c:463  
#10 0x00007f2e7e13b61f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95  

Thread 3 (Thread 0x7f2e7ff13700 (LWP 1228)):  
#0  0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x21ea864) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
#1  __pthread_cond_wait_common (abstime=0x0, mutex=0x21ea808, cond=0x21ea838) at pthread_cond_wait.c:502  
#2  __pthread_cond_wait (cond=0x21ea838, mutex=0x21ea808) at pthread_cond_wait.c:655  
#3  0x0000000000a90781 in ?? ()  
#4  0x0000000000a9063e in ?? ()  
#5  0x0000000000a90425 in ?? ()  
#6  0x0000000000a8ee57 in ?? ()  
#7  0x0000000000a8dbf5 in ?? ()  
#8  0x0000000000a8dc97 in ?? ()  
#9  0x00007f2e7e4126db in start_thread (arg=0x7f2e7ff13700) at pthread_create.c:463  
#10 0x00007f2e7e13b61f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95  

Thread 2 (Thread 0x7f2e7fee1800 (LWP 1227)):  
#0  0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x7ffcdaa025d0) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
#1  __pthread_cond_wait_common (abstime=0x0, mutex=0x7ffcdaa025d8, cond=0x7ffcdaa025a8) at pthread_cond_wait.c:502  
#2  __pthread_cond_wait (cond=0x7ffcdaa025a8, mutex=0x7ffcdaa025d8) at pthread_cond_wait.c:655  
#3  0x000000000064773b in ?? ()  
#4  0x0000000000ed808d in ?? ()  
#5  0x0000000000622ba2 in ?? ()  
#6  0x0000000000624616 in ?? ()  
#7  0x00007f2e7e03bc87 in __libc_start_main (main=0x6245d0, argc=4, argv=0x7ffcdaa031e8, init=<optimized out>, fini=<optimized out>, rtld_fini=<optimized out>, stack_end=0x7ffcdaa031d8) at ../csu/libc-start.c:310  
#8  0x000000000055703a in ?? ()  

Thread 1 (Thread 0x7f2e7fdba700 (LWP 1229)):  
#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51  
#1  0x00007f2e7e05a7f1 in __GI_abort () at abort.c:79  
#2  0x00007f2e7e0a3837 in __libc_message (action=action@entry=do_abort, fmt=fmt@entry=0x7f2e7e1d0a7b "%s\n") at ../sysdeps/posix/libc_fatal.c:181  
#3  0x00007f2e7e0aa8ba in malloc_printerr (str=str@entry=0x7f2e7e1cec76 "free(): invalid pointer") at malloc.c:5342  
#4  0x00007f2e7e0b1dec in _int_free (have_lock=0, p=0x7f2e70005b00, av=0x7f2e7e405c40 <main_arena>) at malloc.c:4167  
#5  __GI___libc_free (mem=0x7f2e70005b10) at malloc.c:3134  
#6  0x0000000000a5266e in ?? ()  
#7  0x000000000099af47 in ?? ()  
#8  0x0000000000aa8e39 in ?? ()  
#9  0x00000000006186db in ?? ()  
#10 0x00000000006187cc in ?? ()  
#11 0x000000000061ff41 in ?? ()  
#12 0x000000000058dd04 in ?? ()  
#13 0x000000000058db69 in ?? ()  
#14 0x000000000062e890 in ?? ()  
#15 0x0000000000edb43c in ?? ()  
#16 0x0000000000ef9d3f in ?? ()  
#17 0x0000000000000000 in ?? ()  
(gdb) thread 2  
[Switching to thread 2 (Thread 0x7f2e7fee1800 (LWP 1227))]  
#0  0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x7ffcdaa025d0) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
88../sysdeps/unix/sysv/linux/futex-internal.h: No such file or directory.  
(gdb) bt full  
#0  0x00007f2e7e418ad3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x7ffcdaa025d0) at ../sysdeps/unix/sysv/linux/futex-internal.h:88  
        __ret = -512  
        oldtype = 0  
        err = <optimized out>  
        oldtype = <optimized out>  
        err = <optimized out>  
        __ret = <optimized out>  
        resultvar = <optimized out>  
        __arg4 = <optimized out>  
        __arg3 = <optimized out>  
        __arg2 = <optimized out>  
        __arg1 = <optimized out>  
        _a4 = <optimized out>  
        _a3 = <optimized out>  
        _a2 = <optimized out>  
        _a1 = <optimized out>  
#1  __pthread_cond_wait_common (abstime=0x0, mutex=0x7ffcdaa025d8, cond=0x7ffcdaa025a8) at pthread_cond_wait.c:502  
        spin = 0  
        buffer = {__routine = 0x7f2e7e418770 <__condvar_cleanup_waiting>, __arg = 0x7ffcdaa02480, __canceltype = 35580944, __prev = 0x0}  
        cbuffer = {wseq = 0, cond = 0x7ffcdaa025a8, mutex = 0x7ffcdaa025d8, private = 0}  
        rt = <optimized out>  
        err = <optimized out>  
        g = 0  
        flags = <optimized out>  
        g1_start = <optimized out>  
        signals = <optimized out>  
        result = 0  
        wseq = <optimized out>  
        seq = 0  
        private = <optimized out>  
        maxspin = <optimized out>  
        err = <optimized out>  
        result = <optimized out>  
        wseq = <optimized out>  
        g = <optimized out>  
        seq = <optimized out>  
        flags = <optimized out>  
        private = <optimized out>  
        signals = <optimized out>  
        g1_start = <optimized out>  
        spin = <optimized out>  
        buffer = <optimized out>  
        cbuffer = <optimized out>  
        rt = <optimized out>  
        s = <optimized out>  
#2  __pthread_cond_wait (cond=0x7ffcdaa025a8, mutex=0x7ffcdaa025d8) at pthread_cond_wait.c:655  
No locals.  
#3  0x000000000064773b in ?? ()  
No symbol table info available.  
#4  0x0000000000ed808d in ?? ()  
No symbol table info available.  
#5  0x0000000000622ba2 in ?? ()  
No symbol table info available.  
#6  0x0000000000624616 in ?? ()  
No symbol table info available.  
#7  0x00007f2e7e03bc87 in __libc_start_main (main=0x6245d0, argc=4, argv=0x7ffcdaa031e8, init=<optimized out>, fini=<optimized out>, rtld_fini=<optimized out>, stack_end=0x7ffcdaa031d8) at ../csu/libc-start.c:310  
        self = <optimized out>  
        __self = <optimized out>  
        result = <optimized out>  
        unwind_buf = {cancel_jmp_buf = {{jmp_buf = {0, -4523500099052898356, 5599248, 140723976417760, 0, 0, 4521886976927987660, 4568252527134373836}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x7f2e7fcfc8d3 <_dl_init 259>, 0x7f2e7fcdf618}, data = {prev = 0x0, cleanup = 0x0, canceltype = 2144323795}}}  
        not_first_call = <optimized out>  
#8  0x000000000055703a in ?? ()  
No symbol table info available.  
(gdb) info locals  
self = <optimized out>  
__self = <optimized out>  
result = <optimized out>  
unwind_buf = {cancel_jmp_buf = {{jmp_buf = {0, -4523500099052898356, 5599248, 140723976417760, 0, 0, 4521886976927987660, 4568252527134373836}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x7f2e7fcfc8d3 <_dl_init 259>, 0x7f2e7fcdf618}, data = {prev = 0x0, cleanup = 0x0, canceltype = 2144323795}}}  
not_first_call = <optimized out>

Will upload searchd binary and existing index it fails on via FTP.

could you provide you create table statement?

As from crash log I see that index that you uploaded has 594 full-text field however the hard-coded upper limit for fields is 256

I don't have the create statement but here is the describe statement:

mysql> desc tiki_main_63295a1e8e0ea;
+-----------------------------------------------------------------------+-----------+----------------+
| Field                                                                 | Type      | Properties     |
+-----------------------------------------------------------------------+-----------+----------------+
| id                                                                    | bigint    |                |
| title                                                                 | text      | indexed        |
| contributors                                                          | text      | indexed        |
| field_permissions                                                     | text      | indexed        |
| tracker_field_bug_tracker_summary                                     | text      | indexed        |
| tracker_field_bug_tracker_priority_text                               | text      | indexed        |
| tracker_field_bug_tracker_description                                 | text      | indexed        |
| tracker_field_bug_tracker_assignee                                    | text      | indexed        |
| tracker_field_bug_tracker_assignee_text                               | text      | indexed        |
| tracker_field_bug_tracker_assignee_unstemmed                          | text      | indexed        |
| tracker_field_category                                                | text      | indexed        |
| tracker_field_category_text                                           | text      | indexed        |
| tracker_field_category_names                                          | text      | indexed        |
| tracker_field_category_paths                                          | text      | indexed        |
| tracker_field_urgent                                                  | text      | indexed        |
| tracker_field_autosyncusers                                           | text      | indexed        |
| tracker_field_singleuser_text                                         | text      | indexed        |
| tracker_field_singleuser_unstemmed                                    | text      | indexed        |
| tracker_field_group_text                                              | text      | indexed        |
| tracker_field_country_text                                            | text      | indexed        |
| tracker_field_related                                                 | text      | indexed        |
| tracker_field_related_multi                                           | text      | indexed        |
| tracker_field_related_plain                                           | text      | indexed        |
| tracker_field_related_text                                            | text      | indexed        |
| tracker_field_confi                                                   | text      | indexed        |
| tracker_field_confi_text                                              | text      | indexed        |
| tracker_field_confi_names                                             | text      | indexed        |
| tracker_field_confi_paths                                             | text      | indexed        |
| tracker_field_bug_tracker_file                                        | text      | indexed        |
| tracker_field_bug_tracker_file_names                                  | text      | indexed        |
| tracker_field_bug_tracker_file_filenames                              | text      | indexed        |
| tracker_field_bug_tracker_file_filetypes                              | text      | indexed        |
| tracker_field_bug_tracker_file_text                                   | text      | indexed        |
| tracker_field_assigneegroups                                          | text      | indexed        |
| tracker_field_assigneegroups_text                                     | text      | indexed        |
| tracker_field_itemlink_text                                           | text      | indexed        |
| tracker_field_relatedtimesheetentries                                 | text      | indexed        |
| tracker_field_relatedtimesheetentries_multi                           | text      | indexed        |
| tracker_field_relatedtimesheetentries_plain                           | text      | indexed        |
| tracker_field_relatedtimesheetentries_text                            | text      | indexed        |
| tracker_field_timespent                                               | text      | indexed        |
| attachments                                                           | text      | indexed        |
| categories                                                            | text      | indexed        |
| deep_categories                                                       | text      | indexed        |
| allowed_groups                                                        | text      | indexed        |
| allowed_users                                                         | text      | indexed        |
| relations                                                             | text      | indexed        |
| relation_types                                                        | text      | indexed        |
| relation_count                                                        | text      | indexed        |
| contents                                                              | text      | indexed        |
| tracker_field_test_id_text                                            | text      | indexed stored |
| tracker_field_test_name                                               | text      | indexed stored |
| tracker_field_filefield                                               | text      | indexed stored |
| tracker_field_filefield_names                                         | text      | indexed stored |
| tracker_field_filefield_filenames                                     | text      | indexed stored |
| tracker_field_filefield_filetypes                                     | text      | indexed stored |
| tracker_field_filefield_text                                          | text      | indexed stored |
| tracker_field_self                                                    | text      | indexed stored |
| tracker_field_self_multi                                              | text      | indexed stored |
| tracker_field_self_plain                                              | text      | indexed stored |
| tracker_field_self_text                                               | text      | indexed stored |
| tracker_field_email                                                   | text      | indexed stored |
| tracker_field_test                                                    | text      | indexed stored |
| tracker_field_testdate                                                | text      | indexed stored |
| tracker_field_documentpage                                            | text      | indexed stored |
| tracker_field_user                                                    | text      | indexed stored |
| tracker_field_user_text                                               | text      | indexed stored |
| tracker_field_user_unstemmed                                          | text      | indexed stored |
| tracker_field_statuso_text                                            | text      | indexed stored |
| tracker_field_testmultipleitemlink                                    | text      | indexed stored |
| tracker_field_testmultipleitemlink_text                               | text      | indexed stored |
| tracker_field_downloadarchive                                         | text      | indexed stored |
| tracker_field_bugslistbycategory                                      | text      | indexed stored |
| tracker_field_bugslistbycategory_text                                 | text      | indexed stored |
| tracker_field_currency                                                | text      | indexed stored |
| tracker_field_language                                                | text      | indexed stored |
| tracker_field_location                                                | text      | indexed stored |
| tracker_field_multiselect_text                                        | text      | indexed stored |
| tracker_field_radio_text                                              | text      | indexed stored |
| tracker_field_url                                                     | text      | indexed stored |
| tracker_field_usergroups                                              | text      | indexed stored |
| tracker_field_usergroups_text                                         | text      | indexed stored |
| tracker_field_duration_text                                           | text      | indexed stored |
| tracker_field_mathmirroringitemlink                                   | text      | indexed stored |
| tracker_field_mathmirroringitemlink_text                              | text      | indexed stored |
| tracker_field_emailthread_subjects                                    | text      | indexed stored |
| tracker_field_emailthread_dates                                       | text      | indexed stored |
| tracker_field_emailthread_senders                                     | text      | indexed stored |
| tracker_field_emailthread_recipients                                  | text      | indexed stored |
| tracker_field_anotheremailfield_subjects                              | text      | indexed stored |
| tracker_field_anotheremailfield_dates                                 | text      | indexed stored |
| tracker_field_anotheremailfield_senders                               | text      | indexed stored |
| tracker_field_anotheremailfield_recipients                            | text      | indexed stored |
| tracker_field_testmath                                                | text      | indexed stored |
| tracker_field_woname                                                  | text      | indexed stored |
| tracker_field_priceguide_text                                         | text      | indexed stored |
| tracker_field_finalprice                                              | text      | indexed stored |
| tracker_field_finalprice_2                                            | text      | indexed stored |
| tracker_field_testname                                                | text      | indexed stored |
| tracker_field_timestamp                                               | text      | indexed stored |
| tracker_field_date2                                                   | text      | indexed stored |
| tracker_field_datetext                                                | text      | indexed stored |
| tracker_field_workdescription_text                                    | text      | indexed stored |
| tracker_field_contractorpriceperunit_text                             | text      | indexed stored |
| tracker_field_overrideprice                                           | text      | indexed stored |
| tracker_field_workcategory_text                                       | text      | indexed stored |
| tracker_field_um_text                                                 | text      | indexed stored |
| tracker_field_tasktask                                                | text      | indexed stored |
| tracker_field_taskassignedto                                          | text      | indexed stored |
| tracker_field_taskassignedto_text                                     | text      | indexed stored |
| tracker_field_taskassignedto_unstemmed                                | text      | indexed stored |
| tracker_field_taskdescription                                         | text      | indexed stored |
| tracker_field_taskpriority_text                                       | text      | indexed stored |
| tracker_field_taskjob                                                 | text      | indexed stored |
| tracker_field_taskjob_text                                            | text      | indexed stored |
| tracker_field_taskjob_names                                           | text      | indexed stored |
| tracker_field_taskjob_paths                                           | text      | indexed stored |
| tracker_field_taskresolutionstatus_text                               | text      | indexed stored |
| tracker_field_trac_as_cal_summary                                     | text      | indexed stored |
| tracker_field_trac_as_cal_location_text                               | text      | indexed stored |
| tracker_field_trac_as_cal_priority_text                               | text      | indexed stored |
| tracker_field_trac_as_cal_description                                 | text      | indexed stored |
| tracker_field_hospital                                                | text      | indexed stored |
| tracker_field_hospitalregion_text                                     | text      | indexed stored |
| tracker_field_hospitalarea                                            | text      | indexed stored |
| tracker_field_hospitalarea_text                                       | text      | indexed stored |
| tracker_field_laboratory                                              | text      | indexed stored |
| tracker_field_laboratoryregion_text                                   | text      | indexed stored |
| tracker_field_laboratoryhospital_text                                 | text      | indexed stored |
| tracker_field_laboratoryarea                                          | text      | indexed stored |
| tracker_field_laboratoryarea_text                                     | text      | indexed stored |
| tracker_field_mathcalctest                                            | text      | indexed stored |
| tracker_field_regioncalculated_text                                   | text      | indexed stored |
| tracker_field_areacalculated                                          | text      | indexed stored |
| tracker_field_areacalculated_text                                     | text      | indexed stored |
| tracker_field_labresultid_text                                        | text      | indexed stored |
| tracker_field_labresultregion_text                                    | text      | indexed stored |
| tracker_field_labresultregion_area                                    | text      | indexed stored |
| tracker_field_labresulthospital_text                                  | text      | indexed stored |
| tracker_field_labresultlaboratory_text                                | text      | indexed stored |
| tracker_field_labresultvalue                                          | text      | indexed stored |
| tracker_field_labresultpersonincharge_text                            | text      | indexed stored |
| tracker_field_labresultpersonincharge_unstemmed                       | text      | indexed stored |
| tracker_field_labresultrelatedlabs                                    | text      | indexed stored |
| tracker_field_labresultrelatedlabs_text                               | text      | indexed stored |
| tracker_field_linkedfield_text                                        | text      | indexed stored |
| tracker_field_realname                                                | text      | indexed stored |
| tracker_field_regionname                                              | text      | indexed stored |
| tracker_field_area                                                    | text      | indexed stored |
| tracker_field_timesheetworkdescription                                | text      | indexed stored |
| tracker_field_timesheetapprovedbymanager_text                         | text      | indexed stored |
| tracker_field_timesheetworkerusername_text                            | text      | indexed stored |
| tracker_field_timesheetworkerusername_unstemmed                       | text      | indexed stored |
| tracker_field_timesheettreatment_text                                 | text      | indexed stored |
| tracker_field_timesheetjob                                            | text      | indexed stored |
| tracker_field_timesheetjob_text                                       | text      | indexed stored |
| tracker_field_timesheetjob_names                                      | text      | indexed stored |
| tracker_field_timesheetjob_paths                                      | text      | indexed stored |
| tracker_field_priority_text                                           | text      | indexed stored |
| tracker_field_timesheetnotenotvisiblebycustomer                       | text      | indexed stored |
| tracker_field_timesheetinvoicetocustomer                              | text      | indexed stored |
| tracker_field_timesheetinvoicefromfreelancer                          | text      | indexed stored |
| tracker_field_timesheetrelatedtask                                    | text      | indexed stored |
| tracker_field_timesheetrelatedtask_multi                              | text      | indexed stored |
| tracker_field_timesheetrelatedtask_plain                              | text      | indexed stored |
| tracker_field_timesheetrelatedtask_text                               | text      | indexed stored |
| tracker_field_lateness                                                | text      | indexed stored |
| tracker_field_timesheetjobrate                                        | text      | indexed stored |
| tracker_field_timesheetjobrate_text                                   | text      | indexed stored |
| tracker_field_timesheettimerevenue                                    | text      | indexed stored |
| tracker_field_timesheettimeexpense                                    | text      | indexed stored |
| tracker_field_timesheetinvoiceratefromworker                          | text      | indexed stored |
| tracker_field_timesheetinvoiceratefromworker_text                     | text      | indexed stored |
| tracker_field_tm_text                                                 | text      | indexed stored |
| tracker_field_firstname                                               | text      | indexed stored |
| tracker_field_firstname_text                                          | text      | indexed stored |
| tracker_field_lastname                                                | text      | indexed stored |
| tracker_field_lastname_text                                           | text      | indexed stored |
| tracker_field_commonname                                              | text      | indexed stored |
| tracker_field_commonname_text                                         | text      | indexed stored |
| tracker_field_entity                                                  | text      | indexed stored |
| tracker_field_entity_text                                             | text      | indexed stored |
| tracker_field_companycode                                             | text      | indexed stored |
| tracker_field_companycode_text                                        | text      | indexed stored |
| tracker_field_grantdateandgrantprice                                  | text      | indexed stored |
| tracker_field_declinedwithdrawndatelist                               | text      | indexed stored |
| tracker_field_declinedwithdrawndatelist_text                          | text      | indexed stored |
| tracker_field_declinedwithdrawndate                                   | text      | indexed stored |
| tracker_field_declinedwithdrawnreasonlist                             | text      | indexed stored |
| tracker_field_declinedwithdrawnreasonlist_text                        | text      | indexed stored |
| tracker_field_declinedwithdrawnreason                                 | text      | indexed stored |
| tracker_field_declinedwithdrawnoptions                                | text      | indexed stored |
| tracker_field_terminationdatelist                                     | text      | indexed stored |
| tracker_field_terminationdatelist_text                                | text      | indexed stored |
| tracker_field_terminationdate                                         | text      | indexed stored |
| tracker_field_terminationreasonlist                                   | text      | indexed stored |
| tracker_field_terminationreasonlist_text                              | text      | indexed stored |
| tracker_field_terminationreason                                       | text      | indexed stored |
| tracker_field_opstatus                                                | text      | indexed stored |
| tracker_field_reportdate                                              | text      | indexed stored |
| tracker_field_vestingschedule                                         | text      | indexed stored |
| tracker_field_vestingschedule_text                                    | text      | indexed stored |
| tracker_field_pervesting                                              | text      | indexed stored |
| tracker_field_startvestingdate                                        | text      | indexed stored |
| tracker_field_noofvestedtranche                                       | text      | indexed stored |
| tracker_field_expirydateofthegrant                                    | text      | indexed stored |
| tracker_field_exercisedetails                                         | text      | indexed stored |
| tracker_field_exercisedetails_text                                    | text      | indexed stored |
| tracker_field_exercisedetailsformatted                                | text      | indexed stored |
| tracker_field_totalexercisedshares                                    | text      | indexed stored |
| tracker_field_unvestedoptionslapsed                                   | text      | indexed stored |
| tracker_field_exercisableperiodaftertermination                       | text      | indexed stored |
| tracker_field_lapseddate                                              | text      | indexed stored |
| tracker_field_sharestobeissuedbeforelapseddate                        | text      | indexed stored |
| tracker_field_vestedoptionslapsed                                     | text      | indexed stored |
| tracker_field_totallapsedoptions                                      | text      | indexed stored |
| tracker_field_sharestobeissuedasatperiodend                           | text      | indexed stored |
| tracker_field_tmid                                                    | text      | indexed stored |
| tracker_field_startvestingdateauto                                    | text      | indexed stored |
| tracker_field_exercisefirstname                                       | text      | indexed stored |
| tracker_field_exercisefirstname_text                                  | text      | indexed stored |
| tracker_field_exerciselastname                                        | text      | indexed stored |
| tracker_field_exerciselastname_text                                   | text      | indexed stored |
| tracker_field_exercisegrantdate_text                                  | text      | indexed stored |
| tracker_field_exercisegrantprice                                      | text      | indexed stored |
| tracker_field_exercisegrantprice_text                                 | text      | indexed stored |
| tracker_field_exercisegrantedoptions                                  | text      | indexed stored |
| tracker_field_exercisegrantedoptions_text                             | text      | indexed stored |
| tracker_field_fundsraised                                             | text      | indexed stored |
| tracker_field_taxwithholding                                          | text      | indexed stored |
| tracker_field_exercisetype_text                                       | text      | indexed stored |
| tracker_field_comments                                                | text      | indexed stored |
| tracker_field_dwtm_text                                               | text      | indexed stored |
| tracker_field_dwfirstname                                             | text      | indexed stored |
| tracker_field_dwfirstname_text                                        | text      | indexed stored |
| tracker_field_dwlastname                                              | text      | indexed stored |
| tracker_field_dwlastname_text                                         | text      | indexed stored |
| tracker_field_dwgrantdate_text                                        | text      | indexed stored |
| tracker_field_dwgrantprice                                            | text      | indexed stored |
| tracker_field_dwgrantprice_text                                       | text      | indexed stored |
| tracker_field_dwdeclinedwithdrawnreason_text                          | text      | indexed stored |
| tracker_field_tmnumber                                                | text      | indexed stored |
| tracker_field_tmfirstname                                             | text      | indexed stored |
| tracker_field_tmlastname                                              | text      | indexed stored |
| tracker_field_tmcommonname                                            | text      | indexed stored |
| tracker_field_tmentity                                                | text      | indexed stored |
| tracker_field_tmcompanycode                                           | text      | indexed stored |
| tracker_field_termtm_text                                             | text      | indexed stored |
| tracker_field_termfirstname                                           | text      | indexed stored |
| tracker_field_termfirstname_text                                      | text      | indexed stored |
| tracker_field_termlastname                                            | text      | indexed stored |
| tracker_field_termlastname_text                                       | text      | indexed stored |
| tracker_field_termterminationreason_text                              | text      | indexed stored |
| tracker_field_termtmid                                                | text      | indexed stored |
| tracker_field_commo                                                   | text      | indexed stored |
| tracker_field_department                                              | text      | indexed stored |
| tracker_field_position                                                | text      | indexed stored |
| tracker_field_grade                                                   | text      | indexed stored |
| tracker_field_statuscode                                              | text      | indexed stored |
| tracker_field_emailaddress                                            | text      | indexed stored |
| tracker_field_remarks                                                 | text      | indexed stored |
| tracker_field_optionholder_text                                       | text      | indexed stored |
| tracker_field_vstm_text                                               | text      | indexed stored |
| tracker_field_vsgrantdate_text                                        | text      | indexed stored |
| tracker_field_vsgrantedoptions                                        | text      | indexed stored |
| tracker_field_vsgrantedoptions_text                                   | text      | indexed stored |
| tracker_field_crinid_text                                             | text      | indexed stored |
| tracker_field_crinsender                                              | text      | indexed stored |
| tracker_field_crinrelated                                             | text      | indexed stored |
| tracker_field_crinrelated_multi                                       | text      | indexed stored |
| tracker_field_crinrelated_plain                                       | text      | indexed stored |
| tracker_field_crinrelated_text                                        | text      | indexed stored |
| tracker_field_crouid_text                                             | text      | indexed stored |
| tracker_field_crourecipient                                           | text      | indexed stored |
| tracker_field_crourelated                                             | text      | indexed stored |
| tracker_field_crourelated_multi                                       | text      | indexed stored |
| tracker_field_crourelated_plain                                       | text      | indexed stored |
| tracker_field_crourelated_text                                        | text      | indexed stored |
| tracker_field_matterid_text                                           | text      | indexed stored |
| tracker_field_matterdescription                                       | text      | indexed stored |
| tracker_field_matterrelated                                           | text      | indexed stored |
| tracker_field_matterrelated_multi                                     | text      | indexed stored |
| tracker_field_matterrelated_plain                                     | text      | indexed stored |
| tracker_field_matterrelated_text                                      | text      | indexed stored |
| tracker_field_litigationname                                          | text      | indexed stored |
| tracker_field_litigationrelate                                        | text      | indexed stored |
| tracker_field_litigationrelate_multi                                  | text      | indexed stored |
| tracker_field_litigationrelate_plain                                  | text      | indexed stored |
| tracker_field_litigationrelate_text                                   | text      | indexed stored |
| tracker_field_litigationfiles                                         | text      | indexed stored |
| tracker_field_litigationfiles_names                                   | text      | indexed stored |
| tracker_field_litigationfiles_filenames                               | text      | indexed stored |
| tracker_field_litigationfiles_filetypes                               | text      | indexed stored |
| tracker_field_litigationfiles_text                                    | text      | indexed stored |
| tracker_field_creditagreementchecklistname                            | text      | indexed stored |
| tracker_field_creditagreementchecklistdescription                     | text      | indexed stored |
| tracker_field_creditagreementchecklistcomments                        | text      | indexed stored |
| tracker_field_poaname                                                 | text      | indexed stored |
| tracker_field_poacategory                                             | text      | indexed stored |
| tracker_field_poacategory_text                                        | text      | indexed stored |
| tracker_field_poacategory_names                                       | text      | indexed stored |
| tracker_field_poacategory_paths                                       | text      | indexed stored |
| tracker_field_trcurrency_text                                         | text      | indexed stored |
| tracker_field_user_tracker_user_text                                  | text      | indexed stored |
| tracker_field_user_tracker_user_unstemmed                             | text      | indexed stored |
| tracker_field_user_tracker_signature                                  | text      | indexed stored |
| tracker_field_user_tracker_from                                       | text      | indexed stored |
| tracker_field_user_tracker_status                                     | text      | indexed stored |
| tracker_field_group_tracker_group_text                                | text      | indexed stored |
| tracker_field_group_tracker_signature                                 | text      | indexed stored |
| tracker_field_group_tracker_from                                      | text      | indexed stored |
| tracker_field_group_tracker_webmail                                   | text      | indexed stored |
| tracker_field_groupmail_tickets_from                                  | text      | indexed stored |
| tracker_field_groupmail_tickets_operator_text                         | text      | indexed stored |
| tracker_field_groupmail_tickets_operator_unstemmed                    | text      | indexed stored |
| tracker_field_groupmail_tickets_subject                               | text      | indexed stored |
| tracker_field_groupmail_tickets_messageid                             | text      | indexed stored |
| tracker_field_groupmail_tickets_content                               | text      | indexed stored |
| tracker_field_groupmail_tickets_account                               | text      | indexed stored |
| tracker_field_evoludataexpensesubmitter_text                          | text      | indexed stored |
| tracker_field_evoludataexpensesubmitter_unstemmed                     | text      | indexed stored |
| tracker_field_evoludataexpenselifecyclestatus_text                    | text      | indexed stored |
| tracker_field_evoludataexpensesupplier                                | text      | indexed stored |
| tracker_field_evoludataexpenseid                                      | text      | indexed stored |
| tracker_field_evoludataexpensehoursworked                             | text      | indexed stored |
| tracker_field_evoludataexpensesupportingdocument                      | text      | indexed stored |
| tracker_field_evoludataexpensesupportingdocument_names                | text      | indexed stored |
| tracker_field_evoludataexpensesupportingdocument_filenames            | text      | indexed stored |
| tracker_field_evoludataexpensesupportingdocument_filetypes            | text      | indexed stored |
| tracker_field_evoludataexpensesupportingdocument_text                 | text      | indexed stored |
| tracker_field_evoludataexpensetype_text                               | text      | indexed stored |
| tracker_field_evoludataexpensestatementstatuslifecycle_text           | text      | indexed stored |
| tracker_field_evoludataexpensedetails                                 | text      | indexed stored |
| tracker_field_evoludataexpenseamountheader                            | text      | indexed stored |
| tracker_field_evoludataexpensecurrency_text                           | text      | indexed stored |
| tracker_field_evoludataexpensehourlyratecurrency                      | text      | indexed stored |
| tracker_field_evoludataexpenseamountcurrency                          | text      | indexed stored |
| tracker_field_evoludataexpensetaxinterpretationstatus_text            | text      | indexed stored |
| tracker_field_evoludataexpensetotalincludinganytaxes                  | text      | indexed stored |
| tracker_field_evoludataexpensecurrencytotalincludinganytaxes          | text      | indexed stored |
| tracker_field_evoludataexpensevalidationheader                        | text      | indexed stored |
| tracker_field_evoludataexpensetimesheetsvsinvoice_text                | text      | indexed stored |
| tracker_field_evoludataexpensevalidationnotes                         | text      | indexed stored |
| tracker_field_evoludataexpensepaymentheader                           | text      | indexed stored |
| tracker_field_evoludataexpensepaymentmethod_text                      | text      | indexed stored |
| tracker_field_evoludataexpensereferencenumber                         | text      | indexed stored |
| tracker_field_evoludataexpensepaymentcurrency_text                    | text      | indexed stored |
| tracker_field_evoludataexpensetotalamountcurrencypaid                 | text      | indexed stored |
| tracker_field_evoludataexpensepaymentdetails                          | text      | indexed stored |
| tracker_field_evoludataexpensepaymentreceiptdocument                  | text      | indexed stored |
| tracker_field_evoludataexpensepaymentreceiptdocument_names            | text      | indexed stored |
| tracker_field_evoludataexpensepaymentreceiptdocument_filenames        | text      | indexed stored |
| tracker_field_evoludataexpensepaymentreceiptdocument_filetypes        | text      | indexed stored |
| tracker_field_evoludataexpensepaymentreceiptdocument_text             | text      | indexed stored |
| tracker_field_evoludataexpenseinternalnotebookkeeper                  | text      | indexed stored |
| tracker_field_evoludataexpenseotherheader                             | text      | indexed stored |
| tracker_field_evoludataexpensevisibleto                               | text      | indexed stored |
| tracker_field_evoludataexpensevisibleto_text                          | text      | indexed stored |
| tracker_field_evoludataexpensevisibleto_unstemmed                     | text      | indexed stored |
| tracker_field_evoludataexpenseaccountingyear_text                     | text      | indexed stored |
| tracker_field_evoludataexpensestatus_text                             | text      | indexed stored |
| tracker_field_evoludataexpensetobereimbursed_text                     | text      | indexed stored |
| tracker_field_evoludataexpenserelatedexpense                          | text      | indexed stored |
| tracker_field_evoludataexpenserelatedexpense_multi                    | text      | indexed stored |
| tracker_field_evoludataexpenserelatedexpense_plain                    | text      | indexed stored |
| tracker_field_evoludataexpenserelatedexpense_text                     | text      | indexed stored |
| tracker_field_evoludataexpensebusinessportion                         | text      | indexed stored |
| tracker_field_evoludataexpensebusinessgstpaid                         | text      | indexed stored |
| tracker_field_evoludataexpensebusinessqstpaid                         | text      | indexed stored |
| tracker_field_evoludataexpensebusinessamountpaid                      | text      | indexed stored |
| tracker_field_evoludataexpenseequivalentcad                           | text      | indexed stored |
| tracker_field_evoludataexpensesystemid_text                           | text      | indexed stored |
| tracker_field_evoludataexpensechecksums                               | text      | indexed stored |
| tracker_field_nearest_100                                             | text      | indexed stored |
| tracker_field_numberrange                                             | text      | indexed stored |
| tracker_field_agegroup                                                | text      | indexed stored |
| tracker_field_checksum                                                | text      | indexed stored |
| tracker_field_evoludataexpensechecksumminutesrateinvoice              | text      | indexed stored |
| tracker_field_currencyamountofextracosttotransferfunds_nsferfees      | text      | indexed stored |
| tracker_field_evoludataexpenseduplicatecheck_text                     | text      | indexed stored |
| tracker_field_evoludatatimesheetlist                                  | text      | indexed stored |
| tracker_field_evoludatatimesheetlist_text                             | text      | indexed stored |
| tracker_field_evoludataexpensebyassessment                            | text      | indexed stored |
| tracker_field_exchangeratecurrency                                    | text      | indexed stored |
| tracker_field_currencytestamount_1                                    | text      | indexed stored |
| tracker_field_currencytestamount_2                                    | text      | indexed stored |
| tracker_field_currencytestcalc                                        | text      | indexed stored |
| tracker_field_currencytestcalc2                                       | text      | indexed stored |
| tracker_field_evoludatarevenueid                                      | text      | indexed stored |
| tracker_field_evoludatarevenueaccountingyear_text                     | text      | indexed stored |
| tracker_field_evoludatarevenuelifecyclestatus_text                    | text      | indexed stored |
| tracker_field_evoludatarevenuecoordination                            | text      | indexed stored |
| tracker_field_evoludatarevenueclientname                              | text      | indexed stored |
| tracker_field_evoludatarevenuesource                                  | text      | indexed stored |
| tracker_field_evoludatarevenuejob                                     | text      | indexed stored |
| tracker_field_evoludatarevenuejob_text                                | text      | indexed stored |
| tracker_field_evoludatarevenuejob_names                               | text      | indexed stored |
| tracker_field_evoludatarevenuejob_paths                               | text      | indexed stored |
| tracker_field_evoludatarevenuedescription                             | text      | indexed stored |
| tracker_field_evoludatarevenuesupportingdocuments                     | text      | indexed stored |
| tracker_field_evoludatarevenuesupportingdocuments_names               | text      | indexed stored |
| tracker_field_evoludatarevenuesupportingdocuments_filenames           | text      | indexed stored |
| tracker_field_evoludatarevenuesupportingdocuments_filetypes           | text      | indexed stored |
| tracker_field_evoludatarevenuesupportingdocuments_text                | text      | indexed stored |
| tracker_field_evoludatarevenuefilesenttoclient                        | text      | indexed stored |
| tracker_field_evoludatarevenuefilesenttoclient_names                  | text      | indexed stored |
| tracker_field_evoludatarevenuefilesenttoclient_filenames              | text      | indexed stored |
| tracker_field_evoludatarevenuefilesenttoclient_filetypes              | text      | indexed stored |
| tracker_field_evoludatarevenuefilesenttoclient_text                   | text      | indexed stored |
| tracker_field_evoludatarevenuetemplate_text                           | text      | indexed stored |
| tracker_field_evoludatarevenuesubmitter                               | text      | indexed stored |
| tracker_field_evoludatarevenuesubmitter_text                          | text      | indexed stored |
| tracker_field_evoludatarevenuesubmitter_unstemmed                     | text      | indexed stored |
| tracker_field_evoludatarevenueamountheader                            | text      | indexed stored |
| tracker_field_evoludatarevenueamountbeforetaxes                       | text      | indexed stored |
| tracker_field_evoludatarevenuetotalgstamount                          | text      | indexed stored |
| tracker_field_evoludatarevenuetotalqstamount                          | text      | indexed stored |
| tracker_field_evoludatarevenuetotalhstamount                          | text      | indexed stored |
| tracker_field_evoludatarevenuetotalamounttax                          | text      | indexed stored |
| tracker_field_evoludatarevenuetotalamountincludingtaxes               | text      | indexed stored |
| tracker_field_evoludatarevenuenote                                    | text      | indexed stored |
| tracker_field_evoludatarevenuepaymentheader                           | text      | indexed stored |
| tracker_field_evoludatarevenuepaymentmethod_text                      | text      | indexed stored |
| tracker_field_evoludatarevenuetotalamountrcvdincfees                  | text      | indexed stored |
| tracker_field_evoludatarevenuebalancedue                              | text      | indexed stored |
| tracker_field_evoludatarevenuereferencenumber                         | text      | indexed stored |
| tracker_field_evoludatarevenueproofofpayment                          | text      | indexed stored |
| tracker_field_evoludatarevenueproofofpayment_names                    | text      | indexed stored |
| tracker_field_evoludatarevenueproofofpayment_filenames                | text      | indexed stored |
| tracker_field_evoludatarevenueproofofpayment_filetypes                | text      | indexed stored |
| tracker_field_evoludatarevenueproofofpayment_text                     | text      | indexed stored |
| tracker_field_evoludatarevenueotherheader                             | text      | indexed stored |
| tracker_field_evoludatarevenuevisibleto                               | text      | indexed stored |
| tracker_field_evoludatarevenuevisibleto_text                          | text      | indexed stored |
| tracker_field_evoludatarevenuevisibleto_unstemmed                     | text      | indexed stored |
| tracker_field_evoludatarevenueprojectionsheader                       | text      | indexed stored |
| tracker_field_evoludatarevenueprojectedsale                           | text      | indexed stored |
| tracker_field_ownershiptrackerid_text                                 | text      | indexed stored |
| tracker_field_ownershiptrackerowneruser_text                          | text      | indexed stored |
| tracker_field_ownershiptrackerowneruser_unstemmed                     | text      | indexed stored |
| tracker_field_ownershiptrackerownergroup_text                         | text      | indexed stored |
| tracker_field_ownershiptrackercreatoruser_text                        | text      | indexed stored |
| tracker_field_ownershiptrackercreatoruser_unstemmed                   | text      | indexed stored |
| tracker_field_ownershiptrackercreatorgroup_text                       | text      | indexed stored |
| tracker_field_odbctestfirstname                                       | text      | indexed stored |
| tracker_field_odbctestlastname                                        | text      | indexed stored |
| tracker_field_odbctestemail                                           | text      | indexed stored |
| tracker_field_odbctestnickname                                        | text      | indexed stored |
| tracker_field_odbctestuser                                            | text      | indexed stored |
| tracker_field_odbctesturi                                             | text      | indexed stored |
| tracker_field_jobjob                                                  | text      | indexed stored |
| tracker_field_jobjob_text                                             | text      | indexed stored |
| tracker_field_jobjob_names                                            | text      | indexed stored |
| tracker_field_jobjob_paths                                            | text      | indexed stored |
| tracker_field_jobrate                                                 | text      | indexed stored |
| tracker_field_jobtimesheets                                           | text      | indexed stored |
| tracker_field_jobtimesheets_text                                      | text      | indexed stored |
| tracker_field_jobrevenuetotalviahours                                 | text      | indexed stored |
| tracker_field_crrid_text                                              | text      | indexed stored |
| tracker_field_crrcrrid_text                                           | text      | indexed stored |
| tracker_field_crrcompany_text                                         | text      | indexed stored |
| tracker_field_crrrequestor                                            | text      | indexed stored |
| tracker_field_crrrequestingtitle                                      | text      | indexed stored |
| tracker_field_crrrequestingdept                                       | text      | indexed stored |
| tracker_field_crrrequestingdivision                                   | text      | indexed stored |
| tracker_field_crrcontractamount                                       | text      | indexed stored |
| tracker_field_crrcontractamountmop                                    | text      | indexed stored |
| tracker_field_crrcontractlength                                       | text      | indexed stored |
| tracker_field_crroutline                                              | text      | indexed stored |
| tracker_field_crroutline2                                             | text      | indexed stored |
| tracker_field_crrdepartmentcharged                                    | text      | indexed stored |
| tracker_field_crrdraftcontract                                        | text      | indexed stored |
| tracker_field_crrpaymentterms                                         | text      | indexed stored |
| tracker_field_crrvendorname                                           | text      | indexed stored |
| tracker_field_crrvendorname_text                                      | text      | indexed stored |
| tracker_field_crrvendoraddress                                        | text      | indexed stored |
| tracker_field_crrvendoraddress_text                                   | text      | indexed stored |
| tracker_field_crrvendorcontact                                        | text      | indexed stored |
| tracker_field_crrvendorphone                                          | text      | indexed stored |
| tracker_field_crradditionalscope                                      | text      | indexed stored |
| tracker_field_crrothercontracts                                       | text      | indexed stored |
| tracker_field_crrcis_ref                                              | text      | indexed stored |
| tracker_field_crrcontracttobemonitored                                | text      | indexed stored |
| tracker_field_crrdeptresponsible                                      | text      | indexed stored |
| tracker_field_crrprocurement                                          | text      | indexed stored |
| tracker_field_crrreviewingattorney                                    | text      | indexed stored |
| tracker_field_crragreementtype                                        | text      | indexed stored |
| tracker_field_crragreementtypedesc                                    | text      | indexed stored |
| tracker_field_crrattorneyoutline                                      | text      | indexed stored |
| tracker_field_crrattorneycomments                                     | text      | indexed stored |
| tracker_field_crrattorneycomments2                                    | text      | indexed stored |
| tracker_field_crrcrr_ref                                              | text      | indexed stored |
| tracker_field_crrreceivedby                                           | text      | indexed stored |
| tracker_field_crrremarks                                              | text      | indexed stored |
| tracker_field_crrlegalreceivedby                                      | text      | indexed stored |
| tracker_field_crrexecutedby                                           | text      | indexed stored |
| tracker_field_crrstatus_text                                          | text      | indexed stored |
| tracker_field_crrcompanyheader                                        | text      | indexed stored |
| tracker_field_crrcisheader                                            | text      | indexed stored |
| tracker_field_crrmonitoredemail                                       | text      | indexed stored |
| tracker_field_crrjcc                                                  | text      | indexed stored |
| tracker_field_crraribaid                                              | text      | indexed stored |
| tracker_field_crrl_pep_tx                                             | text      | indexed stored |
| tracker_field_crrl_comm                                               | text      | indexed stored |
| tracker_field_crrl_subc_type_tx                                       | text      | indexed stored |
| tracker_field_crrattattachmentid_text                                 | text      | indexed stored |
| tracker_field_crrattcrrid                                             | text      | indexed stored |
| tracker_field_crrattatttype                                           | text      | indexed stored |
| tracker_field_crrattdesc                                              | text      | indexed stored |
| tracker_field_crrattattachment                                        | text      | indexed stored |
| tracker_field_crrattattachmentpath                                    | text      | indexed stored |
| tracker_field_crrcompanysclcompanyvendor_text                         | text      | indexed stored |
| tracker_field_crrcompanycompanyenglishname                            | text      | indexed stored |
| tracker_field_crrcompanycompanyportugesename                          | text      | indexed stored |
| tracker_field_crrcompanycompanychinesename                            | text      | indexed stored |
| tracker_field_crrcompanycompanyaddress                                | text      | indexed stored |
| tracker_field_sampletobeclonedname                                    | text      | indexed stored |
| tracker_field_sampletobeclonedlanguage                                | text      | indexed stored |
| tracker_field_sampletobeclonedlinkeditems_text                        | text      | indexed stored |
| tracker_field_sampletobecloneduser_text                               | text      | indexed stored |
| tracker_field_sampletobecloneduser_unstemmed                          | text      | indexed stored |
| tracker_field_sampletobeclonedcategory                                | text      | indexed stored |
| tracker_field_sampletobeclonedcategory_text                           | text      | indexed stored |
| tracker_field_sampletobeclonedcategory_names                          | text      | indexed stored |
| tracker_field_sampletobeclonedcategory_paths                          | text      | indexed stored |
| tracker_field_apifield                                                | text      | indexed stored |
| tracker_field_showtotestid_text                                       | text      | indexed stored |
| tracker_field_showtotestshowinstance                                  | text      | indexed stored |
| tracker_field_showtotesttikimanager                                   | text      | indexed stored |
| tracker_field_showtotesttikivirtualminmanager                         | text      | indexed stored |
| tracker_field_tsuser_text                                             | text      | indexed stored |
| tracker_field_tsuser_unstemmed                                        | text      | indexed stored |
| tracker_field_tsproject                                               | text      | indexed stored |
| tracker_field_tstask                                                  | text      | indexed stored |
| tracker_field_tsdescription                                           | text      | indexed stored |
| tracker_field_tsduration_text                                         | text      | indexed stored |
| tracker_field_tsminutescalculated                                     | text      | indexed stored |
| tracker_field_tshourscalculated                                       | text      | indexed stored |
| tracker_field_tsuri                                                   | text      | indexed stored |
| tracker_field_tssource                                                | text      | indexed stored |
| tracker_field_tsprejournalid                                          | text      | indexed stored |
| tracker_field_tstimeldid                                              | text      | indexed stored |
| tracker_field_tsscoroid                                               | text      | indexed stored |
| description                                                           | text      | indexed stored |
| tracker_name                                                          | text      | indexed stored |
| forum_title                                                           | text      | indexed stored |
| post_author                                                           | text      | indexed stored |
| post_snippet                                                          | text      | indexed stored |
| parent_contributors                                                   | text      | indexed stored |
| lastpost_title                                                        | text      | indexed stored |
| lastpost_contributors                                                 | text      | indexed stored |
| lastpost_post_content                                                 | text      | indexed stored |
| lastpost_post_snippet                                                 | text      | indexed stored |
| sitetitle                                                             | text      | indexed stored |
| siteurl                                                               | text      | indexed stored |
| topic_name                                                            | text      | indexed stored |
| article_linkto                                                        | text      | indexed stored |
| title_unstemmed                                                       | text      | indexed stored |
| filetype                                                              | text      | indexed stored |
| filesize                                                              | text      | indexed stored |
| ocr_content                                                           | text      | indexed stored |
| email_subject                                                         | text      | indexed stored |
| email_from                                                            | text      | indexed stored |
| email_sender                                                          | text      | indexed stored |
| email_recipient                                                       | text      | indexed stored |
| email_content_type                                                    | text      | indexed stored |
| email_body                                                            | text      | indexed stored |
| email_plaintext                                                       | text      | indexed stored |
| email_html                                                            | text      | indexed stored |
| comment_content                                                       | text      | indexed stored |
| user_country                                                          | text      | indexed stored |
| user_gender                                                           | text      | indexed stored |
| user_homepage                                                         | text      | indexed stored |
| user_realname                                                         | text      | indexed stored |
| user_allowmsgs                                                        | text      | indexed stored |
| user_language                                                         | text      | indexed stored |
| user_style                                                            | text      | indexed stored |
| user_page                                                             | text      | indexed stored |
| groups                                                                | text      | indexed stored |
| trackeritems                                                          | text      | indexed stored |
| namespace                                                             | text      | indexed stored |
| reply_action                                                          | text      | indexed stored |
| old_version                                                           | text      | indexed stored |
| data                                                                  | text      | indexed stored |
| old_data                                                              | text      | indexed stored |
| edit_comment                                                          | text      | indexed stored |
| event_id                                                              | text      | indexed stored |
| stream                                                                | text      | indexed stored |
| clear_list                                                            | text      | indexed stored |
| supplied                                                              | text      | indexed stored |
| bulk_import                                                           | text      | indexed stored |
| skip_sync                                                             | text      | indexed stored |
| aggregate                                                             | text      | indexed stored |
| wiki_keywords                                                         | text      | indexed stored |
| path                                                                  | text      | indexed stored |
| modification_date                                                     | timestamp |                |
| creation_date                                                         | timestamp |                |
| date                                                                  | timestamp |                |
| tracker_field_assignment_last_update                                  | timestamp |                |
| tracker_field_bugstartdate                                            | timestamp |                |
| tracker_field_number                                                  | float     |                |
| comment_count                                                         | float     |                |
| title                                                                 | string    |                |
| contributors                                                          | string    |                |
| tracker_status                                                        | string    |                |
| tracker_id                                                            | string    |                |
| view_permission                                                       | string    |                |
| parent_object_id                                                      | string    |                |
| parent_object_type                                                    | string    |                |
| field_permissions                                                     | string    |                |
| tracker_field_bug_tracker_summary                                     | string    |                |
| tracker_field_bug_tracker_priority                                    | string    |                |
| tracker_field_bug_tracker_priority_text                               | string    |                |
| tracker_field_bug_tracker_description                                 | string    |                |
| tracker_field_bug_tracker_description_raw                             | string    |                |
| tracker_field_bug_tracker_assignee                                    | string    |                |
| tracker_field_bug_tracker_assignee_text                               | string    |                |
| tracker_field_bug_tracker_assignee_unstemmed                          | string    |                |
| tracker_field_category                                                | string    |                |
| tracker_field_category_text                                           | string    |                |
| tracker_field_category_names                                          | string    |                |
| tracker_field_category_paths                                          | string    |                |
| tracker_field_urgent                                                  | string    |                |
| tracker_field_autosyncusers                                           | string    |                |
| tracker_field_singleuser                                              | string    |                |
| tracker_field_singleuser_text                                         | string    |                |
| tracker_field_singleuser_unstemmed                                    | string    |                |
| tracker_field_group                                                   | string    |                |
| tracker_field_group_text                                              | string    |                |
| tracker_field_checkbox                                                | string    |                |
| tracker_field_country                                                 | string    |                |
| tracker_field_country_text                                            | string    |                |
| tracker_field_related                                                 | string    |                |
| tracker_field_related_multi                                           | string    |                |
| tracker_field_related_plain                                           | string    |                |
| tracker_field_related_text                                            | string    |                |
| tracker_field_confi                                                   | string    |                |
| tracker_field_confi_text                                              | string    |                |
| tracker_field_confi_names                                             | string    |                |
| tracker_field_confi_paths                                             | string    |                |
| tracker_field_bug_tracker_file                                        | string    |                |
| tracker_field_bug_tracker_file_names                                  | string    |                |
| tracker_field_bug_tracker_file_filenames                              | string    |                |
| tracker_field_bug_tracker_file_filetypes                              | string    |                |
| tracker_field_bug_tracker_file_text                                   | string    |                |
| tracker_field_assigneegroups                                          | string    |                |
| tracker_field_assigneegroups_text                                     | string    |                |
| tracker_field_itemlink                                                | string    |                |
| tracker_field_itemlink_text                                           | string    |                |
| tracker_field_relatedtimesheetentries                                 | string    |                |
| tracker_field_relatedtimesheetentries_multi                           | string    |                |
| tracker_field_relatedtimesheetentries_plain                           | string    |                |
| tracker_field_relatedtimesheetentries_text                            | string    |                |
| tracker_field_timespent                                               | string    |                |
| language                                                              | string    |                |
| attachments                                                           | string    |                |
| primary_image                                                         | string    |                |
| categories                                                            | string    |                |
| deep_categories                                                       | string    |                |
| geo_located                                                           | string    |                |
| geo_location                                                          | string    |                |
| geo_point                                                             | string    |                |
| allowed_groups                                                        | string    |                |
| allowed_users                                                         | string    |                |
| relations                                                             | string    |                |
| relation_types                                                        | string    |                |
| relation_count                                                        | string    |                |
| title_initial                                                         | string    |                |
| title_firstword                                                       | string    |                |
| searchable                                                            | string    |                |
| url                                                                   | string    |                |
| object_type                                                           | string    |                |
| object_id                                                             | string    |                |
| contents                                                              | string    |                |
| relation_objects                                                      | json      |                |
| tracker_field_test_id                                                 | float     |                |
| tracker_field_pdate                                                   | timestamp |                |
| tracker_field_time                                                    | timestamp |                |
| tracker_field_email_text                                              | string    |                |
| tracker_field_test_raw                                                | string    |                |
| tracker_field_statuso                                                 | string    |                |
| tracker_field_currency_base                                           | float     |                |
| tracker_field_icon                                                    | string    |                |
| tracker_field_multiselect                                             | string    |                |
| tracker_field_numeric                                                 | float     |                |
| tracker_field_radio                                                   | string    |                |
| tracker_field_duration                                                | float     |                |
| tracker_field_emailthread                                             | string    |                |
| tracker_field_anotheremailfield                                       | string    |                |
| tracker_field_priceguide                                              | string    |                |
| tracker_field_testdatetime                                            | timestamp |                |
| tracker_field_workdescription                                         | string    |                |
| tracker_field_contractorpriceperunit                                  | string    |                |
| tracker_field_overrideprice_base                                      | float     |                |
| tracker_field_workcategory                                            | string    |                |
| tracker_field_um                                                      | string    |                |
| tracker_field_contractorpriceperunit_base                             | float     |                |
| tracker_field_taskdescription_raw                                     | string    |                |
| tracker_field_taskpriority                                            | string    |                |
| tracker_field_taskresolutionstatus                                    | string    |                |
| tracker_field_trac_as_cal_location                                    | string    |                |
| tracker_field_trac_as_cal_priority                                    | string    |                |
| tracker_field_trac_as_cal_description_raw                             | string    |                |
| tracker_field_trac_as_cal_start_date                                  | timestamp |                |
| tracker_field_trac_as_cal_end_date                                    | timestamp |                |
| tracker_field_dropdowndate                                            | timestamp |                |
| tracker_field_hospitalregion                                          | string    |                |
| tracker_field_laboratoryregion                                        | string    |                |
| tracker_field_laboratoryhospital                                      | string    |                |
| tracker_field_regioncalculated                                        | string    |                |
| tracker_field_labresultid                                             | float     |                |
| tracker_field_labresultregion                                         | string    |                |
| tracker_field_labresulthospital                                       | string    |                |
| tracker_field_labresultlaboratory                                     | string    |                |
| tracker_field_labresultpersonincharge                                 | string    |                |
| tracker_field_labresultdate                                           | timestamp |                |
| tracker_field_linkedfield                                             | string    |                |
| tracker_field_timesheetworkdescription_raw                            | string    |                |
| tracker_field_timesheetminutesworked                                  | float     |                |
| tracker_field_timesheetapprovedbymanager                              | string    |                |
| tracker_field_timesheetworkerusername                                 | string    |                |
| tracker_field_timesheettreatment                                      | string    |                |
| tracker_field_timesheetdate                                           | timestamp |                |
| tracker_field_priority                                                | string    |                |
| tracker_field_timesheetnotenotvisiblebycustomer_raw                   | string    |                |
| tracker_field_timesheettimerevenue_base                               | float     |                |
| tracker_field_timesheettimeexpense_base                               | float     |                |
| tracker_field_tm                                                      | string    |                |
| tracker_field_grantdate                                               | timestamp |                |
| tracker_field_grantprice                                              | float     |                |
| tracker_field_grantedoptions                                          | float     |                |
| tracker_field_adjustedgrantprice                                      | float     |                |
| tracker_field_effectivedateofadjustment                               | timestamp |                |
| tracker_field_exercisegrantdate                                       | string    |                |
| tracker_field_exercisedate                                            | timestamp |                |
| tracker_field_exercisedoptions                                        | float     |                |
| tracker_field_exercisedprice                                          | float     |                |
| tracker_field_exercisetype                                            | string    |                |
| tracker_field_comments_raw                                            | string    |                |
| tracker_field_dwtm                                                    | string    |                |
| tracker_field_dwgrantdate                                             | string    |                |
| tracker_field_dwdeclinedwithdrawndate                                 | timestamp |                |
| tracker_field_dwdeclinedwithdrawnreason                               | string    |                |
| tracker_field_termtm                                                  | string    |                |
| tracker_field_termterminationdate                                     | timestamp |                |
| tracker_field_termterminationreason                                   | string    |                |
| tracker_field_emailaddress_text                                       | string    |                |
| tracker_field_remarks_raw                                             | string    |                |
| tracker_field_optionholder                                            | string    |                |
| tracker_field_vstm                                                    | string    |                |
| tracker_field_vsgrantdate                                             | string    |                |
| tracker_field_vestedoptions                                           | float     |                |
| tracker_field_vesteddate                                              | timestamp |                |
| tracker_field_crinid                                                  | float     |                |
| tracker_field_crouid                                                  | float     |                |
| tracker_field_matterid                                                | float     |                |
| tracker_field_creditagreementchecklistdescription_raw                 | string    |                |
| tracker_field_creditagreementchecklistcomments_raw                    | string    |                |
| tracker_field_tramount                                                | float     |                |
| tracker_field_trcurrency                                              | string    |                |
| tracker_field_user_tracker_user                                       | string    |                |
| tracker_field_user_tracker_signature_raw                              | string    |                |
| tracker_field_group_tracker_group                                     | string    |                |
| tracker_field_group_tracker_signature_raw                             | string    |                |
| tracker_field_groupmail_tickets_operator                              | string    |                |
| tracker_field_groupmail_tickets_content_raw                           | string    |                |
| tracker_field_groupmail_tickets_datetime                              | timestamp |                |
| tracker_field_evoludataexpensesubmitter                               | string    |                |
| tracker_field_evoludataexpenselifecyclestatus                         | string    |                |
| tracker_field_evoludataexpensedate                                    | timestamp |                |
| tracker_field_evoludataexpenseminutesworked                           | float     |                |
| tracker_field_evoludataexpensetype                                    | string    |                |
| tracker_field_evoludataexpensestatementstatuslifecycle                | string    |                |
| tracker_field_evoludataexpensedetails_raw                             | string    |                |
| tracker_field_evoludataexpensecurrency                                | string    |                |
| tracker_field_evoludataexpensehourlyrate                              | float     |                |
| tracker_field_evoludataexpensehourlyratecurrency_base                 | float     |                |
| tracker_field_evoludataexpenseamount                                  | float     |                |
| tracker_field_evoludataexpenseamountcurrency_base                     | float     |                |
| tracker_field_evoludataexpensetaxinterpretationstatus                 | string    |                |
| tracker_field_evoludataexpensegst                                     | float     |                |
| tracker_field_evoludataexpenseqst                                     | float     |                |
| tracker_field_evoludataexpensecurrencytotalincludinganytaxes_base     | float     |                |
| tracker_field_evoludataexpensetimesheetsvsinvoice                     | string    |                |
| tracker_field_evoludataexpensevalidationnotes_raw                     | string    |                |
| tracker_field_evoludataexpensedatepaid                                | timestamp |                |
| tracker_field_evoludataexpensepaymentmethod                           | string    |                |
| tracker_field_evoludataexpensetotalamountpaid                         | float     |                |
| tracker_field_evoludataexpensepaymentcurrency                         | string    |                |
| tracker_field_evoludataexpensetotalamountcurrencypaid_base            | float     |                |
| tracker_field_evoludataexpensepaymentdetails_raw                      | string    |                |
| tracker_field_evoludataexpenseinternalnotebookkeeper_raw              | string    |                |
| tracker_field_evoludataexpenseaccountingyear                          | string    |                |
| tracker_field_evoludataexpensestatus                                  | string    |                |
| tracker_field_evoludataexpensetobereimbursed                          | string    |                |
| tracker_field_evoludataexpensepersonaluse                             | float     |                |
| tracker_field_evoludataexpensesystemid                                | float     |                |
| tracker_field_currencyamountofextracosttotransferfunds_nsferfees_base | float     |                |
| tracker_field_evoludataexpenseduplicatecheck                          | string    |                |
| tracker_field_exchangeratedate                                        | timestamp |                |
| tracker_field_exchangeraterate                                        | float     |                |
| tracker_field_currencytestdate                                        | timestamp |                |
| tracker_field_currencytestamount_1_base                               | float     |                |
| tracker_field_currencytestamount_2_base                               | float     |                |
| tracker_field_currencytestcalc_base                                   | float     |                |
| tracker_field_currencytestcalc2_base                                  | float     |                |
| tracker_field_evoludatarevenuedate                                    | timestamp |                |
| tracker_field_evoludatarevenueaccountingyear                          | string    |                |
| tracker_field_evoludatarevenuelifecyclestatus                         | string    |                |
| tracker_field_evoludatarevenuecoordination_raw                        | string    |                |
| tracker_field_evoludatarevenuesource_raw                              | string    |                |
| tracker_field_evoludatarevenuedescription_raw                         | string    |                |
| tracker_field_evoludatarevenuetemplate                                | string    |                |
| tracker_field_evoludatarevenueamountbeforetaxes_base                  | float     |                |
| tracker_field_evoludatarevenuegst                                     | float     |                |
| tracker_field_evoludatarevenueqst                                     | float     |                |
| tracker_field_evoludatarevenuehstrate                                 | float     |                |
| tracker_field_evoludatarevenuetotalgstamount_base                     | float     |                |
| tracker_field_evoludatarevenuetotalqstamount_base                     | float     |                |
| tracker_field_evoludatarevenuetotalhstamount_base                     | float     |                |
| tracker_field_evoludatarevenuetotalamountincludingtaxes_base          | float     |                |
| tracker_field_evoludatarevenuenote_raw                                | string    |                |
| tracker_field_evoludatarevenuedatepaid                                | timestamp |                |
| tracker_field_evoludatarevenuepaymentmethod                           | string    |                |
| tracker_field_evoludatarevenuetotalamountrcvdincfees_base             | float     |                |
| tracker_field_evoludatarevenueprobabilityofsale                       | float     |                |
| tracker_field_ownershiptrackerid                                      | float     |                |
| tracker_field_ownershiptrackerowneruser                               | string    |                |
| tracker_field_ownershiptrackerownergroup                              | string    |                |
| tracker_field_ownershiptrackercreatoruser                             | string    |                |
| tracker_field_ownershiptrackercreatorgroup                            | string    |                |
| tracker_field_odbctestcontactid                                       | float     |                |
| tracker_field_jobrate_base                                            | float     |                |
| tracker_field_jobrevenuetotalviahours_base                            | float     |                |
| tracker_field_crrid                                                   | float     |                |
| tracker_field_crrcrrid                                                | float     |                |
| tracker_field_crrcompany                                              | string    |                |
| tracker_field_crrdatereceived                                         | timestamp |                |
| tracker_field_crrcontractamount_base                                  | float     |                |
| tracker_field_crrcontracteffective                                    | timestamp |                |
| tracker_field_crrcontractexpires                                      | timestamp |                |
| tracker_field_crrpaymentterms_raw                                     | string    |                |
| tracker_field_crrcis_date                                             | timestamp |                |
| tracker_field_crrattorneyoutline_raw                                  | string    |                |
| tracker_field_crrattorneycomments_raw                                 | string    |                |
| tracker_field_crrcrr_revised                                          | float     |                |
| tracker_field_crrautorenewal                                          | float     |                |
| tracker_field_crrcontractlastrevision                                 | timestamp |                |
| tracker_field_crrsignedcismailed                                      | timestamp |                |
| tracker_field_crrcrrdatereceived                                      | timestamp |                |
| tracker_field_crrdatepasstoattorney                                   | timestamp |                |
| tracker_field_crrremarks_raw                                          | string    |                |
| tracker_field_crrlegalreceiveddate                                    | timestamp |                |
| tracker_field_crrstatus                                               | string    |                |
| tracker_field_crrconfidential                                         | float     |                |
| tracker_field_crrconsultant                                           | float     |                |
| tracker_field_crrl_pep                                                | float     |                |
| tracker_field_crrl_subc                                               | float     |                |
| tracker_field_crrl_subc_type                                          | float     |                |
| tracker_field_crrl_sh                                                 | float     |                |
| tracker_field_crrattattachmentid                                      | float     |                |
| tracker_field_crrattdate                                              | timestamp |                |
| tracker_field_crratttoview                                            | float     |                |
| tracker_field_crrcompanysclcompanyvendor                              | string    |                |
| tracker_field_sampletobeclonedlinkeditems                             | string    |                |
| tracker_field_sampletobecloneduser                                    | string    |                |
| tracker_field_showtotestid                                            | float     |                |
| tracker_field_tsuser                                                  | string    |                |
| tracker_field_tsdescription_raw                                       | string    |                |
| tracker_field_tsstarttime                                             | timestamp |                |
| tracker_field_tsendtime                                               | timestamp |                |
| tracker_field_tsdate                                                  | timestamp |                |
| tracker_field_tsduration                                              | float     |                |
| tracker_field_tsmiteid                                                | float     |                |
| position                                                              | float     |                |
| forum_id                                                              | string    |                |
| forum_section                                                         | string    |                |
| parent_thread_id                                                      | string    |                |
| hits                                                                  | float     |                |
| root_thread_id                                                        | string    |                |
| thread_type                                                           | string    |                |
| reply_count                                                           | float     |                |
| locked                                                                | string    |                |
| lastpost_modification_date                                            | timestamp |                |
| lastpost_hits                                                         | float     |                |
| lastpost_thread_id                                                    | string    |                |
| blog_id                                                               | string    |                |
| topic_id                                                              | string    |                |
| article_type                                                          | string    |                |
| published                                                             | string    |                |
| filename                                                              | string    |                |
| gallery_id                                                            | string    |                |
| email_date                                                            | timestamp |                |
| global_view_permission                                                | string    |                |
| lastlogin_date                                                        | timestamp |                |
| currentlogin_date                                                     | timestamp |                |
| tracker_item_id                                                       | string    |                |
| tracker_item_status                                                   | string    |                |
| calendar_id                                                           | string    |                |
| start_date                                                            | timestamp |                |
| end_date                                                              | timestamp |                |
| priority                                                              | float     |                |
| status                                                                | float     |                |
| status_text                                                           | string    |                |
| recurrence_id                                                         | string    |                |
| personal                                                              | string    |                |
| user                                                                  | string    |                |
| event_type                                                            | string    |                |
| type                                                                  | string    |                |
| object                                                                | string    |                |
| page_id                                                               | string    |                |
| version                                                               | string    |                |
| trackerid                                                             | string    |                |
| hash                                                                  | string    |                |
+-----------------------------------------------------------------------+-----------+----------------+
914 rows in set (0.00 sec)

You have 594 full-text fields while the limit is 256. Consider using JSON attribute instead.

Is there a place I can read more about these hard-limits of manticoresearch? Also, is it possible to show an error instead of crash when this situation is reached?

https://manual.manticoresearch.com/Creating_an_index/Data_types#Text

Also, is it possible to show an error instead of crash when this situation is reached?

Yes, it makes sense. We'll check when we can prioritize it.

Ok, I think that works, so we can close the issue. Just one last question - if there is a limit of 256 text fields per index is there another way to search for a substring of a string attribute besides regex function on attribute filter?

regex is the only way of checking for substring during attribute fullscan but that will be scan of whole index without any shortcuts or speedups

@kroky how did you create a table with so many full-text fields? I can't reproduce it neither in RT mode:

snikolaev@dev:~$ fields=`echo -n "f1 text"; for n in \`seq 2 257\`; do echo -n ",f$n text"; done;`; mysql -P9306 -h0 -e "drop table if exists t; create table t($fields)"

ERROR 1064 (42000) at line 1: error adding index 't': too many fields (fields=257, max=256)

nor in plain mode:

snikolaev@dev:~$ searchd -c min_rt_too_many_fields.conf
Manticore 5.0.2 348514c@220530 dev (columnar 1.15.4 2fef34e@220522)
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2022, Manticore Software LTD (https://manticoresearch.com)

[39:18.603] [919234] using config file 'min_rt_too_many_fields.conf' (8119 chars)...
starting daemon version '5.0.2 348514c@220530 dev (columnar 1.15.4 2fef34e@220522)' ...
listening on all interfaces for mysql, port=9315
listening on all interfaces for VIP mysql, port=9316
WARNING: index 'table': too many fields (fields=257, max=256) - NOT SERVING

It is a RT index that I create initially using PHP PDO connection to the mysql port with a few fields and it is incrementally extended via ALTER TABLE ... ADD COLUMN syntax. I guess it just doesn't return an error in that case as the index is actually operating fine until I try to restart manticore service.

I can't reproduce a crash even after searchd restart in this case:

snikolaev@dev:~$ fields=`echo -n "f1 text"; for n in \`seq 2 256\`; do echo -n ",f$n text"; done;`; mysql -P9306 -h0 -e "drop table if exists t; create table t($fields)"; for m in `seq 257 500`; do mysql -P9306 -h0 -e "alter table t add column f$m text"; done; s="insert into t values(0`for n in \`seq 1 500\`; do echo -n ",'a'"; done`);"; for n in `seq 1 1000`; do mysql -P9306 -h0 -e "$s"; done; mysql -P9306 -h0 -e "flush ramchunk t; select count(*) from t where match('@f500 a')"
+----------+
| count(*) |
+----------+
|        0 |
+----------+
snikolaev@dev:~$ sudo systemctl restart manticore
snikolaev@dev:~$

but at least I can reproduce the situation when there are more than 256 full-text fields in the index and the fields > 256 are not usable (as can be seen above). This should be fixed.

Maybe this will help? This is the full query log of the way I create the index:

CREATE TABLE tiki_main_632aaafdb2ed2 (title text indexed attribute,modification_date timestamp,creation_date timestamp,contributors text indexed attribute,date timestamp,tracker_status string,tracker_id string,view_permission string,parent_object_id string,parent_object_type string,field_permissions text indexed attribute,tracker_field_bug_tracker_summary text indexed attribute,tracker_field_bug_tracker_priority string,tracker_field_bug_tracker_priority_text text indexed attribute,tracker_field_bug_tracker_description text indexed attribute,tracker_field_bug_tracker_description_raw string,tracker_field_bug_tracker_assignee text indexed attribute,tracker_field_bug_tracker_assignee_text text indexed attribute,tracker_field_bug_tracker_assignee_unstemmed text indexed attribute,tracker_field_assignment_last_update timestamp,tracker_field_category text indexed attribute,tracker_field_category_text text indexed attribute,tracker_field_category_names text indexed attribute,tracker_field_category_paths text indexed attribute,tracker_field_urgent text indexed attribute,tracker_field_autoSyncUsers text indexed attribute,tracker_field_number float,tracker_field_singleUser string,tracker_field_singleUser_text text indexed attribute,tracker_field_singleUser_unstemmed text indexed attribute,tracker_field_group string,tracker_field_group_text text indexed attribute,tracker_field_checkbox string,tracker_field_country string,tracker_field_country_text text indexed attribute,tracker_field_related text indexed attribute,tracker_field_related_multi text indexed attribute,tracker_field_related_plain text indexed attribute,tracker_field_related_text text indexed attribute,tracker_field_confi text indexed attribute,tracker_field_confi_text text indexed attribute,tracker_field_confi_names text indexed attribute,tracker_field_confi_paths text indexed attribute,tracker_field_bug_tracker_file text indexed attribute,tracker_field_bug_tracker_file_names text indexed attribute,tracker_field_bug_tracker_file_filenames text indexed attribute,tracker_field_bug_tracker_file_filetypes text indexed attribute,tracker_field_bug_tracker_file_text text indexed attribute,tracker_field_assigneeGroups text indexed attribute,tracker_field_assigneeGroups_text text indexed attribute,tracker_field_itemLink string,tracker_field_itemLink_text text indexed attribute,tracker_field_relatedTimesheetEntries text indexed attribute,tracker_field_relatedTimesheetEntries_multi text indexed attribute,tracker_field_relatedTimesheetEntries_plain text indexed attribute,tracker_field_relatedTimesheetEntries_text text indexed attribute,tracker_field_timeSpent text indexed attribute,tracker_field_bugStartDate timestamp,language string,attachments text indexed attribute,primary_image string,comment_count float,categories text indexed attribute,deep_categories text indexed attribute,geo_located string,geo_location string,geo_point string,allowed_groups text indexed attribute,allowed_users text indexed attribute,relations text indexed attribute,relation_objects json,relation_types text indexed attribute,relation_count text indexed attribute,title_initial string,title_firstword string,searchable string,url string,object_type string,object_id string,contents text indexed attribute) stopwords='/tmp/manticore-stopwords-tiki_main_632aaafdb2ed2' morphology='';
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_test_id` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_test_id_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_test_name` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_pdate` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_time` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_fileField` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_fileField_names` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_fileField_filenames` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_fileField_filetypes` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_fileField_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_self` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_self_multi` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_self_plain` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_self_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_email` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_email_text` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_test` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_test_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_testDate` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_documentPage` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_user` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_user_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_user_unstemmed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_statuso` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_statuso_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_testMultipleItemLink` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_testMultipleItemLink_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_downloadArchive` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_bugsListByCategory` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_bugsListByCategory_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_currency` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_currency_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_icon` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_language` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_location` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_multiselect` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_multiselect_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_numeric` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_radio` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_radio_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_uRL` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_userGroups` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_userGroups_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_duration` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_duration_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_mathMirroringItemLink` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_mathMirroringItemLink_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_emailThread` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_emailThread_subjects` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_emailThread_dates` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_emailThread_senders` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_emailThread_recipients` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_anotherEmailField` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_anotherEmailField_subjects` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_anotherEmailField_dates` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_anotherEmailField_senders` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_anotherEmailField_recipients` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_testMath` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_woName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_priceGuide` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_priceGuide_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_finalPrice` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_finalPrice_2` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_testName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_testDateTime` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_timestamp` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_date2` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_dateText` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_workDescription` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_workDescription_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_contractorPricePerUnit_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_contractorPricePerUnit` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_overridePrice` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_overridePrice_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_workCategory` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_workCategory_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_uM` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_uM_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_contractorPricePerUnit_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_taskTask` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_taskAssignedTo` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_taskAssignedTo_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_taskAssignedTo_unstemmed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_taskDescription` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_taskDescription_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_taskPriority` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_taskPriority_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_taskJob` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_taskJob_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_taskJob_names` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_taskJob_paths` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_taskResolutionStatus` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_taskResolutionStatus_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_trac_as_cal_summary` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_trac_as_cal_location` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_trac_as_cal_location_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_trac_as_cal_priority` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_trac_as_cal_priority_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_trac_as_cal_description` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_trac_as_cal_description_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_trac_as_cal_start_date` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_trac_as_cal_end_date` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_dropdownDate` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_hospital` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_hospitalRegion` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_hospitalRegion_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_hospitalArea` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_hospitalArea_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_laboratory` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_laboratoryRegion` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_laboratoryRegion_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_laboratoryHospital_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_laboratoryHospital` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_laboratoryArea` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_laboratoryArea_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_mathCalcTest` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_regionCalculated` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_regionCalculated_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_areaCalculated` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_areaCalculated_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_labResultID` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_labResultID_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_labResultRegion` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_labResultRegion_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_labResultRegion_area` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_labResultHospital_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_labResultHospital` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_labResultLaboratory_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_labResultLaboratory` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_labResultValue` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_labResultPersonInCharge` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_labResultPersonInCharge_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_labResultPersonInCharge_unstemmed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_labResultRelatedLabs` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_labResultRelatedLabs_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_labResultDate` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_linkedField` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_linkedField_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_realName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_regionName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_area` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetWorkDescription` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetWorkDescription_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetMinutesWorked` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetApprovedByManager` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetApprovedByManager_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetWorkerUsername` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetWorkerUsername_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetWorkerUsername_unstemmed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetTreatment` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetTreatment_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetJob` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetJob_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetJob_names` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetJob_paths` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetDate` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_priority` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_priority_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetNoteNotVisibleByCustomer` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetNoteNotVisibleByCustomer_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetInvoiceToCustomer` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimeSheetInvoiceFromFreelancer` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimesheetRelatedTask` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimesheetRelatedTask_multi` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimesheetRelatedTask_plain` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimesheetRelatedTask_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_lateness` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimesheetJobRate` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimesheetJobRate_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimesheetTimeRevenue` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimesheetTimeRevenue_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimesheetTimeExpense` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimesheetTimeExpense_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimesheetInvoiceRateFromWorker` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_TimesheetInvoiceRateFromWorker_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tM` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tM_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_firstName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_firstName_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_lastName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_lastName_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_commonName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_commonName_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_entity` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_entity_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_companyCode` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_companyCode_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_grantDate` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_grantPrice` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_grantDateAndGrantPrice` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_grantedOptions` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_adjustedGrantPrice` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_effectiveDateOfAdjustment` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_declinedWithdrawnDateList` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_declinedWithdrawnDateList_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_declinedWithdrawnDate` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_declinedWithdrawnReasonList` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_declinedWithdrawnReasonList_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_declinedWithdrawnReason` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_declinedWithdrawnOptions` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_terminationDateList` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_terminationDateList_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_terminationDate` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_terminationReasonList` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_terminationReasonList_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_terminationReason` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_opStatus` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_reportDate` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_vestingSchedule` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_vestingSchedule_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_perVesting` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_startVestingDate` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_noOfVestedTranche` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_expiryDateOfTheGrant` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exerciseDetails` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exerciseDetails_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exerciseDetailsFormatted` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_totalExercisedShares` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_unvestedOptionsLapsed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exercisablePeriodAfterTermination` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_lapsedDate` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_sharesToBeIssuedBeforeLapsedDate` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_vestedOptionsLapsed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_totalLapsedOptions` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_sharesToBeIssuedAsAtPeriodEnd` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tMID` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_startVestingDateAuto` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exerciseFirstName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exerciseFirstName_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exerciseLastName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exerciseLastName_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exerciseGrantDate_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exerciseGrantDate` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exerciseGrantPrice` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exerciseGrantPrice_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exerciseGrantedOptions` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exerciseGrantedOptions_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exerciseDate` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exercisedOptions` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exercisedPrice` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_fundsRaised` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_taxWithholding` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exerciseType` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exerciseType_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_comments` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_comments_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_dwTM` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_dwTM_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_dwFirstName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_dwFirstName_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_dwLastName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_dwLastName_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_dwGrantDate_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_dwGrantDate` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_dwGrantPrice` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_dwGrantPrice_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_dwDeclinedWithdrawnDate` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_dwDeclinedWithdrawnReason` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_dwDeclinedWithdrawnReason_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tmNumber` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tmFirstName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tmLastName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tmCommonName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tmEntity` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tmCompanyCode` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_termTM` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_termTM_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_termFirstName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_termFirstName_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_termLastName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_termLastName_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_termTerminationDate` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_termTerminationReason` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_termTerminationReason_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_termTMID` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_commo` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_department` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_position` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_grade` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_statusCode` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_emailAddress` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_emailAddress_text` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_remarks` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_remarks_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_optionHolder` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_optionHolder_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_vsTM` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_vsTM_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_vsGrantDate_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_vsGrantDate` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_vsGrantedOptions` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_vsGrantedOptions_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_vestedOptions` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_vestedDate` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crinID` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crinID_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crinSender` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crinRelated` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crinRelated_multi` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crinRelated_plain` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crinRelated_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crouID` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crouID_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crouRecipient` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crouRelated` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crouRelated_multi` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crouRelated_plain` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crouRelated_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_matterID` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_matterID_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_matterDescription` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_matterRelated` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_matterRelated_multi` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_matterRelated_plain` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_matterRelated_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_litigationName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_litigationRelate` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_litigationRelate_multi` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_litigationRelate_plain` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_litigationRelate_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_litigationFiles` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_litigationFiles_names` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_litigationFiles_filenames` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_litigationFiles_filetypes` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_litigationFiles_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_creditagreementChecklistName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_creditagreementChecklistDescription` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_creditagreementChecklistDescription_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_creditagreementChecklistComments` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_creditagreementChecklistComments_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_poaName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_poaCategory` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_poaCategory_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_poaCategory_names` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_poaCategory_paths` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_trAmount` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_trCurrency` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_trCurrency_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_user_tracker_user` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_user_tracker_user_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_user_tracker_user_unstemmed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_user_tracker_signature` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_user_tracker_signature_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_user_tracker_from` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_user_tracker_status` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_group_tracker_group` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_group_tracker_group_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_group_tracker_signature` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_group_tracker_signature_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_group_tracker_from` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_group_tracker_webmail` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_groupmail_tickets_from` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_groupmail_tickets_operator` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_groupmail_tickets_operator_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_groupmail_tickets_operator_unstemmed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_groupmail_tickets_subject` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_groupmail_tickets_messageid` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_groupmail_tickets_content` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_groupmail_tickets_content_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_groupmail_tickets_account` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_groupmail_tickets_datetime` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseSubmitter` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseSubmitter_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseSubmitter_unstemmed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseLifecycleStatus` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseLifecycleStatus_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseSupplier` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseID` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseDate` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseMinutesWorked` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseHoursWorked` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseSupportingDocument` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseSupportingDocument_names` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseSupportingDocument_filenames` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseSupportingDocument_filetypes` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseSupportingDocument_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseType` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseType_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseStatementStatusLifecycle` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseStatementStatusLifecycle_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseDetails` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseDetails_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseAmountHeader` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseCurrency` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseCurrency_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseHourlyRate` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseHourlyRateCurrency` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseHourlyRateCurrency_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseAmount` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseAmountCurrency` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseAmountCurrency_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseTaxInterpretationStatus` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseTaxInterpretationStatus_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseGST` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseQST` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseTotalIncludingAnyTaxes` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseCurrencyTotalIncludingAnyTaxes` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseCurrencyTotalIncludingAnyTaxes_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseValidationHeader` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseTimesheetsVsInvoice` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseTimesheetsVsInvoice_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseValidationNotes` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseValidationNotes_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpensePaymentHeader` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseDatePaid` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpensePaymentMethod` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpensePaymentMethod_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseReferenceNumber` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseTotalAmountPaid` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpensePaymentCurrency` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpensePaymentCurrency_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseTotalAmountCurrencyPaid` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseTotalAmountCurrencyPaid_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpensePaymentDetails` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpensePaymentDetails_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpensePaymentReceiptDocument` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpensePaymentReceiptDocument_names` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpensePaymentReceiptDocument_filenames` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpensePaymentReceiptDocument_filetypes` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpensePaymentReceiptDocument_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseInternalNoteBookkeeper` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseInternalNoteBookkeeper_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseOtherHeader` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseVisibleTo` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseVisibleTo_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseVisibleTo_unstemmed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseAccountingYear` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseAccountingYear_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseStatus` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseStatus_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseToBeReimbursed` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseToBeReimbursed_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseRelatedExpense` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseRelatedExpense_multi` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseRelatedExpense_plain` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseRelatedExpense_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseBusinessPortion` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpensePersonalUse` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseBusinessGSTPaid` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseBusinessQSTPaid` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseBusinessAmountPaid` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoludataExpenseEquivalentCAD` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_evoludataexpenseSystemID` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_evoludataexpenseSystemID_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseChecksums` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_nearest_100` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_numberRange` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ageGroup` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_checksum` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseChecksumminutesrateinvoice` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_currencyAmountOfExtraCostToTransferFunds_nsferFees` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_currencyAmountOfExtraCostToTransferFunds_nsferFees_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseDuplicateCheck` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseDuplicateCheck_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataTimesheetList` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataTimesheetList_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataExpenseByAssessment` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exchangerateCurrency` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exchangerateDate` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_exchangerateRate` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_currencytestDate` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_currencytestAmount_1` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_currencytestAmount_1_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_currencytestAmount_2` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_currencytestAmount_2_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_currencytestCalc` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_currencytestCalc_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_currencytestCalc2` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_currencytestCalc2_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueID` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueDate` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueAccountingYear` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueAccountingYear_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueLifecycleStatus` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueLifecycleStatus_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueCoordination` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueCoordination_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueClientName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueSource` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueSource_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueJob` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueJob_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueJob_names` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueJob_paths` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueDescription` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueDescription_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueSupportingDocuments` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueSupportingDocuments_names` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueSupportingDocuments_filenames` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueSupportingDocuments_filetypes` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueSupportingDocuments_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueFileSentToClient` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueFileSentToClient_names` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueFileSentToClient_filenames` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueFileSentToClient_filetypes` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueFileSentToClient_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueTemplate` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueTemplate_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueSubmitter` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueSubmitter_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueSubmitter_unstemmed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueAmountHeader` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueAmountBeforeTaxes` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueAmountBeforeTaxes_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueGST` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueQST` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueHSTRate` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueTotalGSTAmount` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueTotalGSTAmount_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueTotalQSTAmount` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueTotalQSTAmount_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueTotalHSTAmount` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueTotalHSTAmount_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueTotalAmountTax` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueTotalAmountIncludingTaxes` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueTotalAmountIncludingTaxes_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueNote` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueNote_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenuePaymentHeader` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueDatePaid` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenuePaymentMethod` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenuePaymentMethod_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueTotalAmountRcvdIncFees` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueTotalAmountRcvdIncFees_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueBalanceDue` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueReferenceNumber` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueProofOfPayment` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueProofOfPayment_names` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueProofOfPayment_filenames` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueProofOfPayment_filetypes` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueProofOfPayment_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueOtherHeader` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueVisibleTo` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueVisibleTo_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueVisibleTo_unstemmed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueProjectionsHeader` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueProbabilityofSale` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_EvoluDataRevenueProjectedSale` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ownershiptrackerID` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ownershiptrackerID_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ownershiptrackerOwnerUser` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ownershiptrackerOwnerUser_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ownershiptrackerOwnerUser_unstemmed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ownershiptrackerOwnerGroup` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ownershiptrackerOwnerGroup_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ownershiptrackerCreatorUser` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ownershiptrackerCreatorUser_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ownershiptrackerCreatorUser_unstemmed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ownershiptrackerCreatorGroup` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ownershiptrackerCreatorGroup_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ODBCtestcontactId` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ODBCtestfirstName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ODBCtestlastName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ODBCtestemail` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ODBCtestnickname` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ODBCtestuser` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_ODBCtesturi` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_jobJob` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_jobJob_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_jobJob_names` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_jobJob_paths` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_jobRate` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_jobRate_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_jobTimesheets` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_jobTimesheets_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_jobRevenueTotalViaHours` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_jobRevenueTotalViaHours_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrID` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrID_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCRRID` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCRRID_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCompany` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCompany_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrRequestor` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrRequestingTitle` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrRequestingDept` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrRequestingDivision` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrDateReceived` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrContractAmount` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrContractAmount_base` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrContractAmountMOP` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrContractLength` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrContractEffective` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrContractExpires` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrOutline` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrOutline2` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrDepartmentCharged` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrDraftContract` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrPaymentTerms` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrPaymentTerms_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrVendorName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrVendorName_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrVendorAddress` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrVendorAddress_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrVendorContact` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrVendorPhone` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAdditionalScope` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrOtherContracts` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCIS_Ref` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrContractToBeMonitored` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrDeptResponsible` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrProcurement` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCIS_Date` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrReviewingAttorney` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAgreementType` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAgreementTypeDesc` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAttorneyOutline` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAttorneyOutline_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAttorneyComments` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAttorneyComments_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAttorneyComments2` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCRR_Ref` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCRR_Revised` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAutoRenewal` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrContractLastRevision` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrSignedCISMailed` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCRRDateReceived` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrReceivedBy` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrDatePassToAttorney` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrRemarks` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrRemarks_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrLegalReceivedBy` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrLegalReceivedDate` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrExecutedBy` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrStatus` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrStatus_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCompanyHeader` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCISHeader` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrMonitoredEmail` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrConfidential` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrConsultant` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrJCC` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAribaID` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrL_PEP` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrL_PEP_Tx` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrL_Comm` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrL_SubC` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrL_SubC_Type` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrL_SubC_Type_Tx` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrL_SH` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAttAttachmentID` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAttAttachmentID_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAttCRRID` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAttDate` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAttAttType` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAttDesc` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAttAttachment` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAttToView` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrAttAttachmentPath` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCompanySCLCompanyVendor` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCompanySCLCompanyVendor_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCompanyCompanyEnglishName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCompanyCompanyPortugeseName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCompanyCompanyChineseName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_crrCompanyCompanyAddress` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_sampletobeclonedName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_sampletobeclonedLanguage` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_sampletobeclonedLinkedItems` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_sampletobeclonedLinkedItems_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_sampletobeclonedUser` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_sampletobeclonedUser_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_sampletobeclonedUser_unstemmed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_sampletobeclonedCategory` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_sampletobeclonedCategory_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_sampletobeclonedCategory_names` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_sampletobeclonedCategory_paths` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_apiField` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_showtotestID` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_showtotestID_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_showtotestShowInstance` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_showtotestTikiManager` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_showtotestTikiVirtualminManager` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsUser` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsUser_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsUser_unstemmed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsProject` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsTask` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsDescription` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsDescription_raw` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsStartTime` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsEndTime` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsDate` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsDuration` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsDuration_text` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsMinutesCalculated` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsHoursCalculated` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsURI` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsMiteID` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsSource` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsPrejournalID` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsTimeldID` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_field_tsScoroID` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `description` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_name` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `position` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `forum_id` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `forum_section` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `forum_title` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `post_author` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `post_snippet` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `parent_thread_id` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `parent_contributors` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `hits` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `root_thread_id` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `thread_type` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `reply_count` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `locked` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `lastpost_title` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `lastpost_modification_date` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `lastpost_contributors` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `lastpost_post_content` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `lastpost_post_snippet` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `lastpost_hits` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `lastpost_thread_id` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `blog_id` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `sitetitle` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `siteurl` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `topic_id` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `topic_name` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `article_type` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `article_linkto` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `published` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `title_unstemmed` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `filename` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `filetype` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `filesize` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `gallery_id` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `ocr_content` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `email_subject` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `email_from` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `email_sender` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `email_recipient` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `email_date` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `email_content_type` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `email_body` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `email_plaintext` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `email_html` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `comment_content` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `global_view_permission` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `lastlogin_date` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `currentlogin_date` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `user_country` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `user_gender` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `user_homepage` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `user_realName` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `user_allowmsgs` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `user_language` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `user_style` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `user_page` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `groups` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_item_id` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `tracker_item_status` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `calendar_id` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `start_date` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `end_date` timestamp;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `priority` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `status` float;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `status_text` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `recurrence_id` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `trackeritems` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `personal` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `user` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `event_type` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `type` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `object` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `namespace` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `reply_action` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `page_id` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `version` string;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `old_version` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `data` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `old_data` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `edit_comment` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `EVENT_ID` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `stream` text;
ALTER TABLE tiki_main_632aaafdb2ed2 ADD COLUMN `clear_list` text;

I uploaded the whole index that crashes manticore upon start on your ftp server. Can you use that for testing? Do you need also the insert statements in this index I sent above?

➤ Sergey Nikolaev commented:

Can you use that for testing? Do you need also the insert statements in this index I sent above?

I think there's no need in that, thanks. It's enough that we know that you can create 257th full-text field with ALTER. It needs to be fixed.

manticoresoftware / manticoresearch

Manticore service crash upon start and keep restarting #897