Server : LiteSpeed System : Linux premium84.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64 User : claqxcrl ( 523) PHP Version : 8.1.32 Disable Function : NONE Directory :  /home/claqxcrl/anfangola.com/wp-content/plugins/matomo/app/core/Updater/Migration/Db/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

/**
 * Matomo - free/libre analytics platform
 *
 * @link https://matomo.org
 * @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
 */
namespace Piwik\Updater\Migration\Db;

/**
 * @see Factory::addIndex()
 * @ignore
 */
class AddIndex extends \Piwik\Updater\Migration\Db\Sql
{
    protected $indexType = 'INDEX';
    protected $indexNamePrefix = 'index';
    /**
     * AddIndex constructor.
     * @param string $table
     * @param array $columnNames
     * @param string $indexName
     */
    public function __construct($table, $columnNames, $indexName)
    {
        $columns = array();
        $columnNamesOnly = array();
        foreach ($columnNames as $columnName) {
            $columnName = str_replace(' ', '', $columnName);
            // eg "column_name (10)" => "column_name(10)"
            preg_match('/^([\\w]+)(\\(?\\d*\\)?)$/', $columnName, $matches);
            // match "column_name" and "column_name(10)"
            $nameOnly = $matches[1];
            // eg "column_name"
            $columnNamesOnly[] = $nameOnly;
            $column = "`{$nameOnly}`";
            if (!empty($matches[2])) {
                $column .= ' ' . $matches[2];
                // eg "(10)"
            }
            $columns[] = $column;
        }
        if (empty($indexName)) {
            $indexName = $this->indexNamePrefix . '_' . implode('_', $columnNamesOnly);
        }
        $sql = sprintf("ALTER TABLE `%s` ADD %s %s (%s)", $table, $this->indexType, $indexName, implode(', ', $columns));
        parent::__construct($sql, array(static::ERROR_CODE_DUPLICATE_KEY, static::ERROR_CODE_KEY_COLUMN_NOT_EXISTS));
    }
}