{"slug":"mima-menu-builder","name":"Mima Menu Builder","description":"Build and manage a mobile-friendly digital menu for food, drink, cafe, dessert, and hospitality businesses.","author":"Mohammad Ansari","active_installs":0,"version":"1.6.41","wp_org_url":"https://wordpress.org/plugins/mima-menu-builder/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"easymenu_","full_table_name":"wp_easymenu_","description":"Stores easymenu  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"mimamebu_categories","full_table_name":"wp_mimamebu_categories","description":"Stores mimamebu categories data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"name_en","type":"VARCHAR(191)","nullable":true,"primary_key":false},{"name":"desc_en","type":"TEXT","nullable":true,"primary_key":false},{"name":"image","type":"TEXT","nullable":true,"primary_key":false},{"name":"available","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"category_order","type":"INT","nullable":true,"primary_key":false},{"name":"name_en","type":"VARCHAR(191)","nullable":true,"primary_key":false},{"name":"desc_en","type":"TEXT","nullable":true,"primary_key":false},{"name":"price","type":"TEXT","nullable":true,"primary_key":false},{"name":"currency","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"image","type":"TEXT","nullable":true,"primary_key":false},{"name":"available","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"best_seller","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"item_order","type":"INT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_mimamebu_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_mimamebu_items ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name_en VARCHAR(191) DEFAULT NULL, desc_en TEXT, 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;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta($sql_cat);"},{"table_name":"mimamebu_items","full_table_name":"wp_mimamebu_items","description":"Stores mimamebu items data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"mimamenu_","full_table_name":"wp_mimamenu_","description":"Stores mimamenu  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"mimamenu_addon_groups","full_table_name":"wp_mimamenu_addon_groups","description":"Stores mimamenu addon groups data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"mimamenu_addon_items","full_table_name":"wp_mimamenu_addon_items","description":"Stores mimamenu addon items data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"mimamenu_categories","full_table_name":"wp_mimamenu_categories","description":"Stores mimamenu categories data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"name_en","type":"VARCHAR(191)","nullable":true,"primary_key":false},{"name":"desc_en","type":"TEXT","nullable":true,"primary_key":false},{"name":"image","type":"TEXT","nullable":true,"primary_key":false},{"name":"available","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"category_order","type":"INT","nullable":true,"primary_key":false},{"name":"name_en","type":"VARCHAR(191)","nullable":true,"primary_key":false},{"name":"desc_en","type":"TEXT","nullable":true,"primary_key":false},{"name":"cat_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"price","type":"TEXT","nullable":true,"primary_key":false},{"name":"currency","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"image","type":"TEXT","nullable":true,"primary_key":false},{"name":"available","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"best_seller","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"item_order","type":"INT","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"slug","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"theme_id","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"is_default","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"status","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"sort_order","type":"INT","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"menu_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"item_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"sort_order","type":"INT","nullable":false,"primary_key":false},{"name":"names","type":"TEXT","nullable":false,"primary_key":false},{"name":"min_choice","type":"INT","nullable":true,"primary_key":false},{"name":"max_choice","type":"INT","nullable":true,"primary_key":false},{"name":"available","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"group_order","type":"INT","nullable":true,"primary_key":false},{"name":"group_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"names","type":"TEXT","nullable":false,"primary_key":false},{"name":"price","type":"TEXT","nullable":true,"primary_key":false},{"name":"currency","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"available","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"sort_order","type":"INT","nullable":true,"primary_key":false},{"name":"item_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"addon_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"order_key","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"order_type","type":"VARCHAR(16)","nullable":false,"primary_key":false},{"name":"currency","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"subtotal","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"tax_amount","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"delivery_fee","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"tip_amount","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"total","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"customer_name","type":"VARCHAR(191)","nullable":true,"primary_key":false},{"name":"customer_phone","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"customer_email","type":"VARCHAR(191)","nullable":true,"primary_key":false},{"name":"address_json","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"payment_method","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"payment_status","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"is_preorder","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"scheduled_for","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"order_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"item_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"item_name_snapshot","type":"VARCHAR(191)","nullable":true,"primary_key":false},{"name":"qty","type":"INT","nullable":false,"primary_key":false},{"name":"unit_price","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"line_total","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"addons_json","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"notes","type":"TEXT","nullable":true,"primary_key":false},{"name":"order_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"old_status","type":"VARCHAR(32)","nullable":true,"primary_key":false},{"name":"new_status","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"changed_by","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"note","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"zone_name","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"fee","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"is_active","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"sort_order","type":"INT","nullable":false,"primary_key":false}],"create_sql":"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);"},{"table_name":"mimamenu_delivery_zones","full_table_name":"wp_mimamenu_delivery_zones","description":"Stores mimamenu delivery zones data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"mimamenu_item_addons","full_table_name":"wp_mimamenu_item_addons","description":"Stores mimamenu item addons data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"mimamenu_items","full_table_name":"wp_mimamenu_items","description":"Stores mimamenu items data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"mimamenu_menu_items","full_table_name":"wp_mimamenu_menu_items","description":"Stores mimamenu menu items data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"mimamenu_menus","full_table_name":"wp_mimamenu_menus","description":"Stores mimamenu menus data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"mimamenu_order_items","full_table_name":"wp_mimamenu_order_items","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"mimamenu_order_status_log","full_table_name":"wp_mimamenu_order_status_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"mimamenu_orders","full_table_name":"wp_mimamenu_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":15}