function build_word_categories_sql() { $table_name = get_word_categories_table_name(); $sql = 'CREATE TABLE `' . $table_name . '` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` char(50) NOT NULL, PRIMARY KEY(`id`) )ENGINE=MyISAM DEFAULT CHARSET=latin1;'; return $sql; }
function wordpleh_uninstall() { global $wpdb; // Get all the table names $deck_word_table_name = get_deck_words_table_name(); $dictionary_table_name = get_dictionary_table_name(); $deck_table_name = get_decks_table_name(); $word_category_table_name = get_word_categories_table_name(); // Drop all the tables $wpdb->query("DROP TABLE IF EXISTS {$deck_word_table_name}"); $wpdb->query("DROP TABLE IF EXISTS {$dictionary_table_name}"); $wpdb->query("DROP TABLE IF EXISTS {$deck_table_name}"); $wpdb->query("DROP TABLE IF EXISTS {$word_category_table_name}"); // Update the db version to 0 so the next time the plugin is run it will reinstall update_option("panno_db_version", PANO_DB_VERSION); }
function delete_word_category($word_category_id) { global $wpdb; $word_category_table_name = get_word_categories_table_name(); $wpdb->delete($word_category_table_name, array('id' => $word_category_id)); }