{"slug":"easy-restaurant-manager","name":"Easy Restaurant Manager","description":"Easy Restaurant Manager A restaurant management plugin with table layouts, menu management, and reservations.","author":"Nitesh Das","active_installs":0,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/easy-restaurant-manager/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"erm_branches","full_table_name":"wp_erm_branches","description":"Stores erm branches data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"address","type":"TEXT","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"opening_hours","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erm_branches` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `name` VARCHAR(255) NOT NULL, `address` TEXT NOT NULL, `phone` VARCHAR(255) NOT NULL, `opening_hours` VARCHAR(255) NOT NULL, `status` VARCHAR(255) NOT NULL, `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) $charset_collate;\"; dbDelta($sql);"},{"table_name":"erm_coupons","full_table_name":"wp_erm_coupons","description":"Stores erm coupons data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"name","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"code","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"discount_type","type":"ENUM('percentage', 'fixed')","nullable":false,"primary_key":false},{"name":"discount_value","type":"DECIMAL(10,2)","nullable":false,"primary_key":false},{"name":"added_date","type":"DATE","nullable":false,"primary_key":false},{"name":"expiration_date","type":"DATE","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erm_coupons` ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) NOT NULL, code VARCHAR(50) UNIQUE NOT NULL, discount_type ENUM('percentage', 'fixed') NOT NULL, discount_value DECIMAL(10,2) NOT NULL, added_date DATE NOT NULL, expiration_date DATE NOT NULL, status VARCHAR(50) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) $charset_collate;\"; dbDelta($sql);"},{"table_name":"erm_menu_categories","full_table_name":"wp_erm_menu_categories","description":"Stores erm menu categories data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"branch_id","type":"INT","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"image","type":"TEXT","nullable":true,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erm_menu_categories` ( id INT PRIMARY KEY AUTO_INCREMENT, branch_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, image TEXT DEFAULT NULL, description TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) $charset_collate;\"; dbDelta($sql);"},{"table_name":"erm_menu_items","full_table_name":"wp_erm_menu_items","description":"Stores erm menu items data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"branch_id","type":"INT","nullable":true,"primary_key":false},{"name":"category_id","type":"INT","nullable":false,"primary_key":false},{"name":"post_id","type":"INT","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"base_price","type":"DECIMAL(10,2)","nullable":false,"primary_key":false},{"name":"portion_sizes","type":"JSON","nullable":true,"primary_key":false},{"name":"addons","type":"JSON","nullable":true,"primary_key":false},{"name":"image","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"availability","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erm_menu_items` ( id INT PRIMARY KEY AUTO_INCREMENT, branch_id INT DEFAULT NULL, category_id INT NOT NULL, post_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, description TEXT, base_price DECIMAL(10,2) NOT NULL, portion_sizes JSON DEFAULT NULL, addons JSON DEFAULT NULL, image VARCHAR(255) DEFAULT NULL, availability TEXT DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) $charset_collate;\"; dbDelta($sql);"},{"table_name":"erm_order_items","full_table_name":"wp_erm_order_items","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"order_id","type":"INT","nullable":false,"primary_key":false},{"name":"menu_item_id","type":"INT","nullable":false,"primary_key":false},{"name":"quantity","type":"INT","nullable":false,"primary_key":false},{"name":"price","type":"DECIMAL(10,2)","nullable":false,"primary_key":false},{"name":"selected_size","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"selected_addons","type":"JSON","nullable":true,"primary_key":false},{"name":"special_instructions","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erm_order_items` ( id INT PRIMARY KEY AUTO_INCREMENT, order_id INT NOT NULL, menu_item_id INT NOT NULL, quantity INT NOT NULL, price DECIMAL(10,2) NOT NULL, selected_size VARCHAR(50), selected_addons JSON DEFAULT NULL, special_instructions TEXT DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) $charset_collate;\"; dbDelta($sql);"},{"table_name":"erm_orders","full_table_name":"wp_erm_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"branch_id","type":"INT","nullable":true,"primary_key":false},{"name":"customer_id","type":"INT","nullable":true,"primary_key":false},{"name":"table_id","type":"INT","nullable":true,"primary_key":false},{"name":"customer_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"address","type":"TEXT","nullable":true,"primary_key":false},{"name":"total_price","type":"DECIMAL(10,2)","nullable":false,"primary_key":false},{"name":"discount_id","type":"INT","nullable":true,"primary_key":false},{"name":"tax_amount","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"status","type":"ENUM('pending', 'completed', 'cancelled')","nullable":false,"primary_key":false},{"name":"order_type","type":"ENUM('dine-in', 'takeaway', 'delivery')","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erm_orders` ( id INT PRIMARY KEY AUTO_INCREMENT, branch_id INT DEFAULT NULL, customer_id INT DEFAULT NULL, table_id INT DEFAULT NULL, customer_name VARCHAR(255) NOT NULL, phone VARCHAR(20) NOT NULL, address TEXT DEFAULT NULL, total_price DECIMAL(10,2) NOT NULL, discount_id INT DEFAULT NULL, tax_amount DECIMAL(10,2) DEFAULT 0.00, status ENUM('pending', 'completed', 'cancelled') NOT NULL DEFAULT 'pending', order_type ENUM('dine-in', 'takeaway', 'delivery') NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) $charset_collate;\"; dbDelta($sql);"},{"table_name":"erm_reviews","full_table_name":"wp_erm_reviews","description":"Stores erm reviews data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"customer_id","type":"INT","nullable":false,"primary_key":false},{"name":"menu_item_id","type":"INT","nullable":false,"primary_key":false},{"name":"rating","type":"INT","nullable":true,"primary_key":false},{"name":"review","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erm_reviews` ( id INT PRIMARY KEY AUTO_INCREMENT, customer_id INT NOT NULL, menu_item_id INT NOT NULL, rating INT, review TEXT DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) $charset_collate;\"; dbDelta($sql);"},{"table_name":"erm_table_reservations","full_table_name":"wp_erm_table_reservations","description":"Stores erm table reservations data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"branch_id","type":"INT","nullable":true,"primary_key":false},{"name":"customer_id","type":"INT","nullable":true,"primary_key":false},{"name":"customer_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"table_id","type":"INT","nullable":false,"primary_key":false},{"name":"reservation_date","type":"DATE","nullable":false,"primary_key":false},{"name":"reservation_time","type":"TIME","nullable":false,"primary_key":false},{"name":"num_guests","type":"INT","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('pending', 'confirmed', 'cancelled')","nullable":false,"primary_key":false},{"name":"notes","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erm_table_reservations` ( id INT PRIMARY KEY AUTO_INCREMENT, branch_id INT DEFAULT NULL, customer_id INT DEFAULT NULL, customer_name VARCHAR(255) NOT NULL, phone VARCHAR(20) NOT NULL, email VARCHAR(255) DEFAULT NULL, table_id INT NOT NULL, reservation_date DATE NOT NULL, reservation_time TIME NOT NULL, num_guests INT NOT NULL, status ENUM('pending', 'confirmed', 'cancelled') NOT NULL DEFAULT 'pending', notes text NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) $charset_collate;\"; dbDelta($sql);"},{"table_name":"erm_tables","full_table_name":"wp_erm_tables","description":"Stores erm tables data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"branch_id","type":"INT","nullable":true,"primary_key":false},{"name":"table_number","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"capacity","type":"INT","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('available', 'reserved', 'occupied')","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erm_tables` ( id INT PRIMARY KEY AUTO_INCREMENT, branch_id INT DEFAULT NULL, table_number VARCHAR(20) UNIQUE NOT NULL, capacity INT NOT NULL, status ENUM('available', 'reserved', 'occupied') NOT NULL DEFAULT 'available', created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) $charset_collate;\"; dbDelta($sql);"},{"table_name":"erm_transactions","full_table_name":"wp_erm_transactions","description":"Stores erm transactions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"order_id","type":"INT","nullable":false,"primary_key":false},{"name":"payment_method","type":"ENUM('cash', 'card', 'online')","nullable":false,"primary_key":false},{"name":"transaction_id","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"amount","type":"DECIMAL(10,2)","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('pending', 'successful', 'failed')","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erm_transactions` ( id INT PRIMARY KEY AUTO_INCREMENT, order_id INT NOT NULL, payment_method ENUM('cash', 'card', 'online') NOT NULL, transaction_id VARCHAR(255) DEFAULT NULL, amount DECIMAL(10,2) NOT NULL, status ENUM('pending', 'successful', 'failed') NOT NULL DEFAULT 'pending', created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) $charset_collate;\"; dbDelta($sql);"},{"table_name":"erm_users","full_table_name":"wp_erm_users","description":"Stores erm users data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":true,"primary_key":true},{"name":"branch_id","type":"INT","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"password","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"role","type":"ENUM('customer', 'admin', 'manager')","nullable":false,"primary_key":false},{"name":"loyalty_points","type":"INT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erm_users` ( id INT PRIMARY KEY AUTO_INCREMENT, branch_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, email VARCHAR(255) UNIQUE NOT NULL, phone VARCHAR(20) NOT NULL, password VARCHAR(255) NOT NULL, role ENUM('customer', 'admin', 'manager') NOT NULL DEFAULT 'customer', loyalty_points INT DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) $charset_collate;\"; dbDelta($sql);"}],"table_count":11}