1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
<?php
/**
* Piwik - 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;
use Piwik\Db;
/**
* @see Factory::createTable()
* @ignore
*/
class CreateTable extends Sql
{
/**
* Constructor.
* @param Db\Settings $dbSettings
* @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(Db\Settings $dbSettings, $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) ENGINE=%s DEFAULT CHARSET=utf8',
$table, implode(', ' , $columns), $dbSettings->getEngine());
parent::__construct($sql, static::ERROR_CODE_TABLE_EXISTS);
}
}
|