{"slug":"bingocar","name":"Bingo Car Rental","description":"Car rental booking system for WordPress. Manage your fleet, reservations and pricing from your own WordPress admin.","author":"Adrian D","active_installs":0,"version":"1.0.59","wp_org_url":"https://wordpress.org/plugins/bingocar/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"bingocr_cars","full_table_name":"wp_bingocr_cars","description":"Stores bingocr cars data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"brand","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"model","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"year","type":"smallint(4)","nullable":true,"primary_key":false},{"name":"category","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"transmission","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"fuel_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"seats","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"price_per_day","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"deposit_type","type":"enum('default','percentage','flat')","nullable":false,"primary_key":false},{"name":"deposit_value","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"image_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"image_url","type":"varchar(500)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"features","type":"longtext","nullable":true,"primary_key":false},{"name":"quantity","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"status","type":"enum('available','unavailable','maintenance')","nullable":false,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_bingocr_cars ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, brand varchar(100) NOT NULL DEFAULT '', model varchar(100) NOT NULL DEFAULT '', year smallint(4) DEFAULT NULL, category varchar(50) NOT NULL DEFAULT '', transmission varchar(20) NOT NULL DEFAULT 'manual', fuel_type varchar(20) NOT NULL DEFAULT 'petrol', seats tinyint(3) unsigned NOT NULL DEFAULT 5, price_per_day decimal(10,2) NOT NULL DEFAULT 0.00, deposit_type enum('default','percentage','flat') NOT NULL DEFAULT 'default', deposit_value decimal(10,2) NOT NULL DEFAULT 0.00, image_id bigint(20) unsigned DEFAULT NULL, image_url varchar(500) DEFAULT NULL, description text DEFAULT NULL, features longtext DEFAULT NULL, quantity tinyint(3) unsigned NOT NULL DEFAULT 1, status enum('available','unavailable','maintenance') NOT NULL DEFAULT 'available', sort_order int(11) NOT NULL DEFAULT 0, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY category (category), KEY status (status) ) $c;\" );"},{"table_name":"bingocr_discounts","full_table_name":"wp_bingocr_discounts","description":"Stores bingocr discounts data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"code","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"type","type":"enum('percentage','flat')","nullable":false,"primary_key":false},{"name":"value","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"min_days","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"max_uses","type":"int(11)","nullable":true,"primary_key":false},{"name":"used_count","type":"int(11)","nullable":false,"primary_key":false},{"name":"expires_at","type":"date","nullable":true,"primary_key":false},{"name":"status","type":"enum('active','inactive')","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_bingocr_discounts ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, code varchar(50) NOT NULL DEFAULT '', type enum('percentage','flat') NOT NULL DEFAULT 'percentage', value decimal(10,2) NOT NULL DEFAULT 0.00, min_days tinyint(3) unsigned NOT NULL DEFAULT 1, max_uses int(11) DEFAULT NULL, used_count int(11) NOT NULL DEFAULT 0, expires_at date DEFAULT NULL, status enum('active','inactive') NOT NULL DEFAULT 'active', PRIMARY KEY (id), UNIQUE KEY code (code) ) $c;\" );"},{"table_name":"bingocr_extras","full_table_name":"wp_bingocr_extras","description":"Stores bingocr extras data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"price","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"price_type","type":"enum('per_day','flat')","nullable":false,"primary_key":false},{"name":"status","type":"enum('active','inactive')","nullable":false,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_bingocr_extras ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(200) NOT NULL DEFAULT '', description text DEFAULT NULL, price decimal(10,2) NOT NULL DEFAULT 0.00, price_type enum('per_day','flat') NOT NULL DEFAULT 'per_day', status enum('active','inactive') NOT NULL DEFAULT 'active', sort_order int(11) NOT NULL DEFAULT 0, PRIMARY KEY (id) ) $c;\" );"},{"table_name":"bingocr_locations","full_table_name":"wp_bingocr_locations","description":"Stores bingocr locations data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"address","type":"text","nullable":true,"primary_key":false},{"name":"city","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"opening_hours","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"status","type":"enum('active','inactive')","nullable":false,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_bingocr_locations ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(200) NOT NULL DEFAULT '', address text DEFAULT NULL, city varchar(100) DEFAULT NULL, phone varchar(50) DEFAULT NULL, email varchar(200) DEFAULT NULL, opening_hours varchar(100) DEFAULT NULL, status enum('active','inactive') NOT NULL DEFAULT 'active', sort_order int(11) NOT NULL DEFAULT 0, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY status (status) ) $c;\" );"},{"table_name":"bingocr_payments","full_table_name":"wp_bingocr_payments","description":"Stores bingocr payments data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"reservation_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"method","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"paypal_order_id","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"paypal_capture_id","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"payer_email","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"gateway_response","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"completed_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_bingocr_payments ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, reservation_id bigint(20) unsigned NOT NULL, method varchar(20) NOT NULL DEFAULT 'paypal', amount decimal(10,2) NOT NULL DEFAULT 0.00, currency varchar(10) NOT NULL DEFAULT 'EUR', status varchar(20) NOT NULL DEFAULT 'pending', paypal_order_id varchar(64) DEFAULT NULL, paypal_capture_id varchar(64) DEFAULT NULL, payer_email varchar(200) DEFAULT NULL, gateway_response longtext DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, completed_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY reservation_id (reservation_id), KEY paypal_order_id (paypal_order_id) ) $c;\" );"},{"table_name":"bingocr_period_pricing","full_table_name":"wp_bingocr_period_pricing","description":"Stores bingocr period pricing data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"pricing_type","type":"enum('fixed_total','rate_per_day')","nullable":false,"primary_key":false},{"name":"min_days","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"max_days","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"fixed_price","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"price_per_day","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"applies_to","type":"enum('all','category','car')","nullable":false,"primary_key":false},{"name":"category","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"car_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"priority","type":"tinyint(3)","nullable":false,"primary_key":false},{"name":"status","type":"enum('active','inactive')","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_bingocr_period_pricing ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(200) NOT NULL DEFAULT '', pricing_type enum('fixed_total','rate_per_day') NOT NULL DEFAULT 'rate_per_day', min_days tinyint(3) unsigned NOT NULL DEFAULT 1, max_days tinyint(3) unsigned NOT NULL DEFAULT 30, fixed_price decimal(10,2) NOT NULL DEFAULT 0.00, price_per_day decimal(10,2) NOT NULL DEFAULT 0.00, applies_to enum('all','category','car') NOT NULL DEFAULT 'all', category varchar(50) NOT NULL DEFAULT '', car_id bigint(20) unsigned DEFAULT NULL, priority tinyint(3) NOT NULL DEFAULT 0, status enum('active','inactive') NOT NULL DEFAULT 'active', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY status (status), KEY min_days (min_days), KEY max_days (max_days) ) $c;\" );"},{"table_name":"bingocr_reservations","full_table_name":"wp_bingocr_reservations","description":"Stores bingocr reservations data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"reservation_number","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"car_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"customer_name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"customer_email","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"customer_phone","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"pickup_date","type":"date","nullable":false,"primary_key":false},{"name":"return_date","type":"date","nullable":false,"primary_key":false},{"name":"pickup_time","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"return_time","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"pickup_location_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"dropoff_location_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"status","type":"enum('pending','confirmed','active','cancelled','completed')","nullable":false,"primary_key":false},{"name":"total_price","type":"decimal(10,2)","nullable":true,"primary_key":false},{"name":"deposit_amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"discount_code","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"discount_amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"extras","type":"longtext","nullable":true,"primary_key":false},{"name":"notes","type":"text","nullable":true,"primary_key":false},{"name":"payment_method","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"payment_status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"paid_amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"language","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_bingocr_reservations ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, reservation_number varchar(20) NOT NULL DEFAULT '', car_id bigint(20) unsigned NOT NULL, customer_name varchar(200) NOT NULL DEFAULT '', customer_email varchar(200) NOT NULL DEFAULT '', customer_phone varchar(50) DEFAULT NULL, pickup_date date NOT NULL, return_date date NOT NULL, pickup_time varchar(10) NOT NULL DEFAULT '10:00', return_time varchar(10) NOT NULL DEFAULT '10:00', pickup_location_id bigint(20) unsigned DEFAULT NULL, dropoff_location_id bigint(20) unsigned DEFAULT NULL, status enum('pending','confirmed','active','cancelled','completed') NOT NULL DEFAULT 'pending', total_price decimal(10,2) DEFAULT NULL, deposit_amount decimal(10,2) NOT NULL DEFAULT 0.00, discount_code varchar(50) DEFAULT NULL, discount_amount decimal(10,2) NOT NULL DEFAULT 0.00, extras longtext DEFAULT NULL, notes text DEFAULT NULL, payment_method varchar(50) NOT NULL DEFAULT 'cash', payment_status varchar(20) NOT NULL DEFAULT 'unpaid', paid_amount decimal(10,2) NOT NULL DEFAULT 0.00, language varchar(10) NOT NULL DEFAULT 'en', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY reservation_number (reservation_number), KEY car_id (car_id), KEY status (status), KEY pickup_date (pickup_date), KEY customer_email (customer_email) ) $c;\" );"},{"table_name":"bingocr_seasonal_prices","full_table_name":"wp_bingocr_seasonal_prices","description":"Stores bingocr seasonal prices data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"start_date","type":"date","nullable":false,"primary_key":false},{"name":"end_date","type":"date","nullable":false,"primary_key":false},{"name":"modifier","type":"decimal(6,2)","nullable":false,"primary_key":false},{"name":"applies_to","type":"enum('all','category')","nullable":false,"primary_key":false},{"name":"category","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"priority","type":"tinyint(3)","nullable":false,"primary_key":false},{"name":"status","type":"enum('active','inactive')","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_bingocr_seasonal_prices ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(200) NOT NULL DEFAULT '', start_date date NOT NULL, end_date date NOT NULL, modifier decimal(6,2) NOT NULL DEFAULT 0.00, applies_to enum('all','category') NOT NULL DEFAULT 'all', category varchar(50) NOT NULL DEFAULT '', priority tinyint(3) NOT NULL DEFAULT 0, status enum('active','inactive') NOT NULL DEFAULT 'active', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY status (status), KEY start_date (start_date), KEY end_date (end_date) ) $c;\" );"}],"table_count":8}