HEX
Server: LiteSpeed
System: Linux server44.twelveinks.com 5.14.0-570.12.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Tue May 13 06:11:55 EDT 2025 x86_64
User: moda (1338)
PHP: 8.1.33
Disabled: NONE
Upload Files
File: /python/moda/public_html/tech/old/resources/sql/upgrade700beta2.sql
-- editor to tblticketescalations --
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tblticketescalations' and column_name='editor') = 0, 'ALTER TABLE tblticketescalations ADD `editor` enum(\'plain\',\'markdown\') COLLATE utf8_unicode_ci NOT NULL DEFAULT \'plain\'', 'DO 0');
prepare statement from @query;
execute statement;
deallocate prepare statement;