public function create()
{
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
$sql_1 = "CREATE TABLE IF NOT EXISTS " . $this->table_name . " (\n\t\t\t id int(11) NOT NULL AUTO_INCREMENT,\n\t\t\t title varchar(225) NOT NULL,\n\t\t\t description text DEFAULT NULL,\n\t\t\t src varchar(225) NOT NULL,\n\t\t\t href varchar(225) DEFAULT NULL,\n\t\t\t date_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,\n\t\t\t status tinyint(1) NOT NULL DEFAULT '1',\n\t\t\t slider_id int(11) NOT NULL,\n\t\t\t PRIMARY KEY (id),\n\t\t\t CONSTRAINT `foreign_slider` FOREIGN KEY (`slider_id`) REFERENCES " . $this->ref_table . "(`id`) \n \t\t\t)" . $this->chaset_collate . ";";
dbdelta($sql_1);
}
public function create()
{
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
$sql_2 = "CREATE TABLE IF NOT EXISTS " . $this->table_name . " (\n\t\t\t\t id int(11) NOT NULL AUTO_INCREMENT,\n\t\t\t\t name varchar(225) NOT NULL,\n\t\t\t\t status tinyint(1) NOT NULL DEFAULT '1',\n\t\t\t\t PRIMARY KEY (id)\n\t\t\t\t)" . $this->chaset_collate . ";";
dbdelta($sql_2);
}
private function alterMMTables()
{
global $wpdb;
$filename = "install_sql";
require_once MM_PLUGIN_ABSPATH . "/data/{$filename}.php";
if (isset($sql) && count($sql) > 0) {
dbdelta($sql);
}
// Since DBDelta doesn't handle dropping column, here's where we can do it manually & safely. We first
// check to see if the column even exists. This could happen if a client has deactivated the
// plugin for some reason and then decides to reactivate.
$droppedColumns = array();
$droppedColumns[MM_TABLE_USER_DATA][] = "password";
foreach ($droppedColumns as $table => $columns) {
foreach ($columns as $column) {
if ($this->hasColumn($table, $column)) {
$wpdb->query("ALTER TABLE {$table} DROP COLUMN {$column}");
}
}
}
return true;
}