Page MenuHomePhabricator
Differential D10627 Diff 25522 src/applications/config/schema/PhabricatorConfigSchemaSpec.php

Changeset View

Standalone View

View Options

src/applications/config/schema/PhabricatorConfigSchemaSpec.php

Show First 20 Lines • Show All 191 Lines • ▼ Show 20 Lines if (preg_match('/\?$/', $data_type)) {
$nullable = true; $nullable = true;
$data_type = substr($data_type, 0, -1); $data_type = substr($data_type, 0, -1);
} }
// NOTE: MySQL allows fragments like "VARCHAR(32) CHARACTER SET binary", // NOTE: MySQL allows fragments like "VARCHAR(32) CHARACTER SET binary",
// but just interprets that to mean "VARBINARY(32)". The fragment is // but just interprets that to mean "VARBINARY(32)". The fragment is
// totally disallowed in a MODIFY statement vs a CREATE TABLE statement. // totally disallowed in a MODIFY statement vs a CREATE TABLE statement.
$is_binary = ($this->getUTF8Charset() == 'binary');
$matches = null;
if (preg_match('/^(fulltext|sort|text)(\d+)?\z/', $data_type, $matches)) {
// Limit the permitted column lengths under the theory that it would
// be nice to eventually reduce this to a small set of standard lengths.
static $valid_types = array(
'text255' => true,
'text160' => true,
'text128' => true,
'text80' => true,
'text64' => true,
'text40' => true,
'text32' => true,
'text20' => true,
'text16' => true,
'text12' => true,
'text8' => true,
'text4' => true,
'text' => true,
'sort255' => true,
'sort128' => true,
'sort64' => true,
'sort32' => true,
'sort' => true,
'fulltext' => true,
);
if (empty($valid_types[$data_type])) {
throw new Exception(pht('Unknown column type "%s"!', $data_type));
}
$type = $matches[1];
$size = idx($matches, 2);
if ($is_binary) {
if ($size) {
$column_type = 'varbinary('.$size.')';
} else {
$column_type = 'longblob';
}
// MySQL (at least, under MyISAM) refuses to create a FULLTEXT index
// on a LONGBLOB column. We'd also lose case insensitivity in search.
// Force this column to utf8 collation. This will truncate results with
// 4-byte UTF characters in their text, but work reasonably in the
// majority of cases.
if ($type == 'fulltext') {
$column_type = 'longtext';
$charset = 'utf8';
$collation = 'utf8_general_ci';
}
} else {
if ($size) {
$column_type = 'varchar('.$size.')';
} else {
$column_type = 'longtext';
}
$charset = $this->getUTF8Charset();
if ($type == 'sort' || $type == 'fulltext') {
$collation = $this->getUTF8SortingCollation();
} else {
$collation = $this->getUTF8BinaryCollation();
}
}
} else {
switch ($data_type) { switch ($data_type) {
case 'auto': case 'auto':
$column_type = 'int(10) unsigned'; $column_type = 'int(10) unsigned';
$auto = true; $auto = true;
break; break;
case 'auto64': case 'auto64':
$column_type = 'bigint(20) unsigned'; $column_type = 'bigint(20) unsigned';
$auto = true; $auto = true;
break; break;
case 'id': case 'id':
case 'epoch': case 'epoch':
case 'uint32': case 'uint32':
$column_type = 'int(10) unsigned'; $column_type = 'int(10) unsigned';
break; break;
case 'sint32': case 'sint32':
$column_type = 'int(10)'; $column_type = 'int(10)';
break; break;
case 'id64': case 'id64':
case 'uint64': case 'uint64':
$column_type = 'bigint(20) unsigned'; $column_type = 'bigint(20) unsigned';
break; break;
case 'sint64': case 'sint64':
$column_type = 'bigint(20)'; $column_type = 'bigint(20)';
break; break;
case 'phid': case 'phid':
case 'policy'; case 'policy';
$column_type = 'varbinary(64)'; $column_type = 'varbinary(64)';
break; break;
case 'bytes64': case 'bytes64':
$column_type = 'binary(64)'; $column_type = 'binary(64)';
break; break;
case 'bytes40': case 'bytes40':
$column_type = 'binary(40)'; $column_type = 'binary(40)';
break; break;
case 'bytes32': case 'bytes32':
$column_type = 'binary(32)'; $column_type = 'binary(32)';
break; break;
case 'bytes20': case 'bytes20':
$column_type = 'binary(20)'; $column_type = 'binary(20)';
break; break;
case 'bytes12': case 'bytes12':
$column_type = 'binary(12)'; $column_type = 'binary(12)';
break; break;
case 'bytes4': case 'bytes4':
$column_type = 'binary(4)'; $column_type = 'binary(4)';
break; break;
case 'bytes': case 'bytes':
$column_type = 'longblob'; $column_type = 'longblob';
break; break;
case 'sort255':
$column_type = 'varchar(255)';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8SortingCollation();
break;
case 'sort128':
$column_type = 'varchar(128)';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8SortingCollation();
break;
case 'sort64':
$column_type = 'varchar(64)';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8SortingCollation();
break;
case 'sort32':
$column_type = 'varchar(32)';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8SortingCollation();
break;
case 'sort':
$column_type = 'longtext';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8SortingCollation();
break;
case 'text255':
$column_type = 'varchar(255)';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8BinaryCollation();
break;
case 'text160':
$column_type = 'varchar(160)';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8BinaryCollation();
break;
case 'text128':
$column_type = 'varchar(128)';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8BinaryCollation();
break;
case 'text80':
$column_type = 'varchar(80)';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8BinaryCollation();
break;
case 'text64':
$column_type = 'varchar(64)';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8BinaryCollation();
break;
case 'text40':
$column_type = 'varchar(40)';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8BinaryCollation();
break;
case 'text32':
$column_type = 'varchar(32)';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8BinaryCollation();
break;
case 'text20':
$column_type = 'varchar(20)';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8BinaryCollation();
break;
case 'text16':
$column_type = 'varchar(16)';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8BinaryCollation();
break;
case 'text12':
$column_type = 'varchar(12)';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8BinaryCollation();
break;
case 'text8':
$column_type = 'varchar(8)';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8BinaryCollation();
break;
case 'text4':
$column_type = 'varchar(4)';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8BinaryCollation();
break;
case 'text':
$column_type = 'longtext';
$charset = $this->getUTF8Charset();
$collation = $this->getUTF8BinaryCollation();
break;
case 'bool': case 'bool':
$column_type = 'tinyint(1)'; $column_type = 'tinyint(1)';
break; break;
case 'double': case 'double':
$column_type = 'double'; $column_type = 'double';
break; break;
case 'date': case 'date':
$column_type = 'date'; $column_type = 'date';
break; break;
default: default:
$column_type = pht('<unknown>'); $column_type = pht('<unknown>');
$charset = pht('<unknown>'); $charset = pht('<unknown>');
$collation = pht('<unknown>'); $collation = pht('<unknown>');
break; break;
} }
}
return array($column_type, $charset, $collation, $nullable, $auto); return array($column_type, $charset, $collation, $nullable, $auto);
} }
} }
Phabricator · Built by Phacility