Server IP : 213.176.29.180  /  Your IP : 18.190.219.200
Web Server : Apache
System : Linux 213.176.29.180.hostiran.name 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
User : webtaragh ( 1001)
PHP Version : 7.4.33
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON
Directory (0755) :  /home/webtaragh/public_html/whmcs/resources/test/../sql/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home/webtaragh/public_html/whmcs/resources/test/../sql/upgrade830release1.sql
-- Create indices to improve cart performance
set @query = if ((SELECT count(*) FROM (SELECT GROUP_CONCAT(COLUMN_NAME ORDER BY SEQ_IN_INDEX) idx_cols FROM information_schema.statistics WHERE table_schema=database() AND TABLE_NAME='tblpricing' GROUP BY INDEX_NAME) i WHERE idx_cols = 'relid') = 0, 'ALTER TABLE `tblpricing` ADD INDEX `pricing_relid_idx` (`relid`);', 'DO 0');
prepare statement from @query;
execute statement;
deallocate prepare statement;

set @query = if ((SELECT count(*) FROM (SELECT GROUP_CONCAT(COLUMN_NAME ORDER BY SEQ_IN_INDEX) idx_cols FROM information_schema.statistics WHERE table_schema=database() AND TABLE_NAME='tblpricing' GROUP BY INDEX_NAME) i WHERE idx_cols = 'currency') = 0, 'ALTER TABLE `tblpricing` ADD INDEX `pricing_currency_idx` (`currency`);', 'DO 0');
prepare statement from @query;
execute statement;
deallocate prepare statement;

set @query = if ((SELECT count(*) FROM (SELECT GROUP_CONCAT(COLUMN_NAME ORDER BY SEQ_IN_INDEX) idx_cols FROM information_schema.statistics WHERE table_schema=database() AND TABLE_NAME='tblpricing' GROUP BY INDEX_NAME) i WHERE idx_cols = 'type') = 0, 'ALTER TABLE `tblpricing` ADD INDEX `pricing_type_idx` (`type`);', 'DO 0');
prepare statement from @query;
execute statement;
deallocate prepare statement;