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/upgrade810alpha1.sql
-- Add new field to tblticketdepartments for mail_auth_config
set @query = if ((select count(*) from information_schema.columns where table_schema=database() and table_name='tblticketdepartments' and column_name='mail_auth_config') = 0, 'ALTER TABLE `tblticketdepartments` ADD `mail_auth_config` TEXT AFTER `password`', 'DO 0');
prepare statement from @query;
execute statement;
deallocate prepare statement;