wp_mimamenu_categories

Column Definitions

CREATE TABLE Statement

CREATE TABLE wp_mimamenu_categories ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name_en VARCHAR(191) DEFAULT NULL, desc_en TEXT, image TEXT, available TINYINT(1) DEFAULT 1, category_order INT DEFAULT 0, PRIMARY KEY (id) ) $cc;"; // items $sql_items = "CREATE TABLE wp_mimamenu_items ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name_en VARCHAR(191) DEFAULT NULL, desc_en TEXT, cat_id BIGINT UNSIGNED NOT NULL DEFAULT 0, price TEXT, currency VARCHAR(10) DEFAULT 'USD', image TEXT, available TINYINT(1) DEFAULT 1, best_seller TINYINT(1) DEFAULT 0, item_order INT DEFAULT 0, PRIMARY KEY (id) ) $cc;"; // menus $sql_menus = "CREATE TABLE wp_mimamenu_menus ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(191) NOT NULL, slug VARCHAR(191) NOT NULL, theme_id VARCHAR(80) NOT NULL DEFAULT 'theme1', description TEXT, is_default TINYINT(1) NOT NULL DEFAULT 0, status TINYINT(1) NOT NULL DEFAULT 1, sort_order INT NOT NULL DEFAULT 0, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY slug (slug), KEY status (status), KEY is_default (is_default) ) $cc;"; // menu<->item link $sql_menu_items = "CREATE TABLE wp_mimamenu_menu_items ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, menu_id BIGINT UNSIGNED NOT NULL, item_id BIGINT UNSIGNED NOT NULL, sort_order INT NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY menu_item (menu_id,item_id), KEY menu_id (menu_id), KEY item_id (item_id) ) $cc;"; // addon groups $sql1 = "CREATE TABLE wp_mimamenu_addon_groups ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, names TEXT NOT NULL, min_choice INT DEFAULT 0, max_choice INT DEFAULT 1, available TINYINT(1) DEFAULT 1, group_order INT DEFAULT 0, PRIMARY KEY (id) ) $cc;"; // addon items $sql2 = "CREATE TABLE wp_mimamenu_addon_items ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, group_id BIGINT UNSIGNED NOT NULL, names TEXT NOT NULL, price TEXT, currency VARCHAR(10) DEFAULT 'USD', available TINYINT(1) DEFAULT 1, sort_order INT DEFAULT 0, PRIMARY KEY (id), KEY group_id (group_id) ) $cc;"; // item<->addon link $sql3 = "CREATE TABLE wp_mimamenu_item_addons ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, item_id BIGINT UNSIGNED NOT NULL, addon_id BIGINT UNSIGNED NOT NULL, PRIMARY KEY (id), KEY item_id (item_id), KEY addon_id (addon_id) ) $cc;"; // orders $sql_orders = "CREATE TABLE wp_mimamenu_orders ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, order_key VARCHAR(64) NOT NULL, status VARCHAR(32) NOT NULL DEFAULT 'pending', order_type VARCHAR(16) NOT NULL DEFAULT 'delivery', currency VARCHAR(10) NOT NULL DEFAULT 'USD', subtotal DECIMAL(12,2) NOT NULL DEFAULT 0, tax_amount DECIMAL(12,2) NOT NULL DEFAULT 0, delivery_fee DECIMAL(12,2) NOT NULL DEFAULT 0, tip_amount DECIMAL(12,2) NOT NULL DEFAULT 0, total DECIMAL(12,2) NOT NULL DEFAULT 0, customer_name VARCHAR(191) DEFAULT NULL, customer_phone VARCHAR(64) DEFAULT NULL, customer_email VARCHAR(191) DEFAULT NULL, address_json LONGTEXT, checkout_fields_json LONGTEXT, payment_method VARCHAR(32) NOT NULL DEFAULT 'cod', payment_status VARCHAR(32) NOT NULL DEFAULT 'unpaid', is_preorder TINYINT(1) NOT NULL DEFAULT 0, scheduled_for DATETIME DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), KEY status (status), KEY created_at (created_at) ) $cc;"; $sql_order_items = "CREATE TABLE wp_mimamenu_order_items ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT UNSIGNED NOT NULL, item_id BIGINT UNSIGNED NOT NULL DEFAULT 0, item_name_snapshot VARCHAR(191) DEFAULT NULL, qty INT NOT NULL DEFAULT 1, unit_price DECIMAL(12,2) NOT NULL DEFAULT 0, line_total DECIMAL(12,2) NOT NULL DEFAULT 0, addons_json LONGTEXT, notes TEXT, PRIMARY KEY (id), KEY order_id (order_id) ) $cc;"; $sql_order_log = "CREATE TABLE wp_mimamenu_order_status_log ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT UNSIGNED NOT NULL, old_status VARCHAR(32) DEFAULT NULL, new_status VARCHAR(32) NOT NULL, changed_by BIGINT UNSIGNED DEFAULT 0, note TEXT, created_at DATETIME NOT NULL, PRIMARY KEY (id), KEY order_id (order_id) ) $cc;"; $sql_zones = "CREATE TABLE wp_mimamenu_delivery_zones ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, zone_name VARCHAR(191) NOT NULL, fee DECIMAL(12,2) NOT NULL DEFAULT 0, is_active TINYINT(1) NOT NULL DEFAULT 1, sort_order INT NOT NULL DEFAULT 0, PRIMARY KEY (id) ) $cc;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta($sql_cat);

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_mimamenu_categories`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Mima Menu Builder