関数
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`"); } }