関数
Schema::v110()
戻り値 戻り値
ファイル: src/Schema.php
public static function v110() {
global $wpdb;
$db = DB_NAME;
$cst = self::getComboSetsTable();
// drop wp_usces_item post ID foreign key
$foreignKeyExists = (bool)(int)$wpdb->get_var("SELECT COUNT(*)
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE
CONSTRAINT_SCHEMA = '{$db}' AND
TABLE_NAME = '{$cst}' AND
CONSTRAINT_NAME = '{$cst}_ibfk_1' AND
CONSTRAINT_TYPE = 'FOREIGN KEY'
");
if ($foreignKeyExists === true) {
$wpdb->query("ALTER TABLE {$cst} DROP FOREIGN KEY `{$cst}_ibfk_1`");
}
// drop wp_usces_skus meta ID foreign key
$foreignKeyExists = (bool)(int)$wpdb->get_var("SELECT COUNT(*)
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE
CONSTRAINT_SCHEMA = '{$db}' AND
TABLE_NAME = '{$cst}' AND
CONSTRAINT_NAME = '{$cst}_ibfk_2' AND
CONSTRAINT_TYPE = 'FOREIGN KEY'
");
if ($foreignKeyExists === true) {
$wpdb->query("ALTER TABLE {$cst} DROP FOREIGN KEY `{$cst}_ibfk_2`");
}
}