* @return Schema the (single) Schema object
*/
- static function get()
+ static function get($conn = null)
{
if (empty(self::$_single)) {
- self::$_single = new Schema();
+ self::$_single = new Schema($conn);
}
return self::$_single;
}
* @param array $def
* @return string;
*
- * @fixme ENGINE may need to be set differently in some cases,
- * such as to support fulltext index.
*/
function endCreateTable($name, array $def)
{
$engine = $this->preferredEngine($def);
- return ") ENGINE=$engine CHARACTER SET utf8 COLLATE utf8_bin";
+ return ") ENGINE=$engine CHARACTER SET utf8mb4 COLLATE utf8mb4_bin";
}
-
+
function preferredEngine($def)
{
+ /* MyISAM is no longer required for fulltext indexes, fortunately
if (!empty($def['fulltext indexes'])) {
return 'MyISAM';
}
+ */
return 'InnoDB';
}
return "{$tableName}_{$columnName}_idx";
}
+ /**
+ * MySQL doesn't take 'DROP CONSTRAINT', need to treat primary keys as
+ * if they were indexes here, but can use 'PRIMARY KEY' special name.
+ *
+ * @param array $phrase
+ */
+ function appendAlterDropPrimary(array &$phrase)
+ {
+ $phrase[] = 'DROP PRIMARY KEY';
+ }
/**
* MySQL doesn't take 'DROP CONSTRAINT', need to treat unique keys as
if (strtolower($oldProps['ENGINE']) != strtolower($engine)) {
$phrase[] = "ENGINE=$engine";
}
- if (strtolower($oldProps['TABLE_COLLATION']) != 'utf8_bin') {
- $phrase[] = 'DEFAULT CHARSET=utf8';
- $phrase[] = 'COLLATE=utf8_bin';
+ if (strtolower($oldProps['TABLE_COLLATION']) != 'utf8mb4_bin') {
+ $phrase[] = 'CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin';
+ $phrase[] = 'DEFAULT CHARACTER SET = utf8mb4';
+ $phrase[] = 'DEFAULT COLLATE = utf8mb4_bin';
}
}
$map = array('serial' => 'int',
'integer' => 'int',
'numeric' => 'decimal');
-
+
$type = $column['type'];
if (isset($map[$type])) {
$type = $map[$type];
*/
function filterDef(array $tableDef)
{
+ $version = $this->conn->getVersion();
foreach ($tableDef['fields'] as $name => &$col) {
if ($col['type'] == 'serial') {
$col['type'] = 'int';
$col['auto_increment'] = true;
}
- if ($col['type'] == 'datetime' && isset($col['default']) && $col['default'] == 'CURRENT_TIMESTAMP') {
- $col['type'] = 'timestamp';
+
+ // Avoid invalid date errors in MySQL 5.7+
+ if ($col['type'] == 'timestamp' && !isset($col['default'])
+ && $version >= 50605) {
+ $col['default'] = 'CURRENT_TIMESTAMP';
+ }
+ if ($col['type'] == 'datetime') {
+ // Avoid invalid date errors in MySQL 5.7+
+ if (!isset($col['default']) && $version >= 50605) {
+ $col['default'] = 'CURRENT_TIMESTAMP';
+ }
+
+ // If we are using MySQL 5.5, convert datetime to timestamp if
+ // default value is CURRENT_TIMESTAMP. Not needed for MySQL 5.6+
+ // and MariaDB 10.0+
+ if (isset($col['default'])
+ && $col['default'] == 'CURRENT_TIMESTAMP'
+ && $version < 50605) {
+ $col['type'] = 'timestamp';
+ }
}
$col['type'] = $this->mapType($col);
unset($col['size']);