قرینه از
https://github.com/matomo-org/matomo.git
synced 2025-08-22 06:57:53 +00:00

* Define consistent db settings access * Define reusable table creation options * Create all tables with explicit row format * Define default collation for TiDB tables * Use table create options from schema in migrations * Create TiDB databases with default collation * Update OmniFixture dump to include ROW_FORMAT
47 خطوط
1.2 KiB
PHP
47 خطوط
1.2 KiB
PHP
<?php
|
|
|
|
/**
|
|
* Matomo - free/libre analytics platform
|
|
*
|
|
* @link https://matomo.org
|
|
* @license https://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
|
|
*/
|
|
|
|
namespace Piwik\Updater\Migration\Db;
|
|
|
|
use Piwik\Db\Schema;
|
|
|
|
/**
|
|
* @see Factory::createTable()
|
|
* @ignore
|
|
*/
|
|
class CreateTable extends Sql
|
|
{
|
|
/**
|
|
* Constructor.
|
|
* @param string $table Prefixed table name
|
|
* @param string|string[] $columnNames array(columnName => columnValue)
|
|
* @param string|string[] $primaryKey one or multiple columns that define the primary key
|
|
*/
|
|
public function __construct($table, $columnNames, $primaryKey)
|
|
{
|
|
$columns = array();
|
|
foreach ($columnNames as $column => $type) {
|
|
$columns[] = sprintf('`%s` %s', $column, $type);
|
|
}
|
|
|
|
if (!empty($primaryKey)) {
|
|
$columns[] = sprintf('PRIMARY KEY ( `%s` )', implode('`, `', $primaryKey));
|
|
}
|
|
|
|
$sql = sprintf(
|
|
'CREATE TABLE `%s` (%s) %s',
|
|
$table,
|
|
implode(', ', $columns),
|
|
Schema::getInstance()->getTableCreateOptions()
|
|
);
|
|
|
|
parent::__construct($sql, static::ERROR_CODE_TABLE_EXISTS);
|
|
}
|
|
}
|