{"slug":"ever-checkout","name":"Ever Checkout – Sell Digital Products & Downloads","description":"Put a buy button on any page and sell digital products from WordPress. Your customer pays, then downloads the file from their receipt.","author":"ByteEver","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/ever-checkout/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"ecout_customers","full_table_name":"wp_ecout_customers","description":"Stores ecout customers data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"ecout_download_logs","full_table_name":"wp_ecout_download_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"ecout_downloads","full_table_name":"wp_ecout_downloads","description":"Stores ecout downloads data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"ecout_order_items","full_table_name":"wp_ecout_order_items","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"ecout_orders","full_table_name":"wp_ecout_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"ecout_products","full_table_name":"wp_ecout_products","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"description","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"image_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"price","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"download_limit","type":"INT(11)","nullable":false,"primary_key":false},{"name":"download_expiry_days","type":"INT(11)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"product_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"file_path","type":"VARCHAR(2000)","nullable":false,"primary_key":false},{"name":"file_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"file_size","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"mime_type","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"enabled","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"position","type":"INT(11)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"country","type":"CHAR(2)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"order_key","type":"CHAR(32)","nullable":false,"primary_key":false},{"name":"parent_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"customer_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"currency","type":"CHAR(3)","nullable":false,"primary_key":false},{"name":"mode","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"subtotal","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"discount","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"total","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"discount_code","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"gateway","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"transaction_id","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"payment_method","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"paid_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"completed_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"order_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"product_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"product_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"price","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"quantity","type":"INT(11)","nullable":false,"primary_key":false},{"name":"subtotal","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"total","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"position","type":"INT(11)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"order_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"product_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"download_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"customer_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"user_agent","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_ecout_products ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL DEFAULT '', type VARCHAR(20) NOT NULL DEFAULT 'simple', status VARCHAR(20) NOT NULL DEFAULT 'active', description LONGTEXT NULL, image_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, price BIGINT(20) NOT NULL DEFAULT 0, download_limit INT(11) NOT NULL DEFAULT 0, download_expiry_days INT(11) NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NULL DEFAULT NULL, PRIMARY KEY (id), KEY status (status) ) $collate; CREATE TABLE wp_ecout_downloads ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, product_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', file_path VARCHAR(2000) NOT NULL DEFAULT '', file_name VARCHAR(255) NOT NULL DEFAULT '', file_size BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, mime_type VARCHAR(100) NOT NULL DEFAULT '', enabled TINYINT(1) NOT NULL DEFAULT 1, position INT(11) NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NULL DEFAULT NULL, PRIMARY KEY (id), KEY product_id (product_id), KEY enabled (enabled) ) $collate; CREATE TABLE wp_ecout_customers ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, email VARCHAR(100) NOT NULL DEFAULT '', name VARCHAR(255) NOT NULL DEFAULT '', country CHAR(2) NOT NULL DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NULL DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY email (email), KEY user_id (user_id) ) $collate; CREATE TABLE wp_ecout_orders ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, order_key CHAR(32) NOT NULL DEFAULT '', parent_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, type VARCHAR(20) NOT NULL DEFAULT 'sale', status VARCHAR(20) NOT NULL DEFAULT 'pending', customer_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, email VARCHAR(100) NOT NULL DEFAULT '', name VARCHAR(255) NOT NULL DEFAULT '', currency CHAR(3) NOT NULL DEFAULT '', mode VARCHAR(10) NOT NULL DEFAULT 'live', subtotal BIGINT(20) NOT NULL DEFAULT 0, discount BIGINT(20) NOT NULL DEFAULT 0, total BIGINT(20) NOT NULL DEFAULT 0, discount_code VARCHAR(50) NOT NULL DEFAULT '', ip_address VARCHAR(45) NOT NULL DEFAULT '', gateway VARCHAR(50) NOT NULL DEFAULT '', transaction_id VARCHAR(255) NOT NULL DEFAULT '', payment_method VARCHAR(100) NOT NULL DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NULL DEFAULT NULL, paid_at DATETIME NULL DEFAULT NULL, completed_at DATETIME NULL DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY order_key (order_key), KEY parent_id (parent_id), KEY customer_id (customer_id), KEY type_status_created (type, status, created_at), KEY created_at (created_at), KEY transaction_id (transaction_id(191)) ) $collate; CREATE TABLE wp_ecout_order_items ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, product_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, product_name VARCHAR(255) NOT NULL DEFAULT '', price BIGINT(20) NOT NULL DEFAULT 0, quantity INT(11) NOT NULL DEFAULT 1, subtotal BIGINT(20) NOT NULL DEFAULT 0, total BIGINT(20) NOT NULL DEFAULT 0, position INT(11) NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NULL DEFAULT NULL, PRIMARY KEY (id), KEY order_id (order_id), KEY product_id (product_id) ) $collate; CREATE TABLE wp_ecout_download_logs ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, product_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, download_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, customer_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, ip_address VARCHAR(45) NOT NULL DEFAULT '', user_agent VARCHAR(255) NOT NULL DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY order_download (order_id, download_id), KEY download_id (download_id), KEY customer_id (customer_id), KEY created_at (created_at) ) $collate; \"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $tables );"}],"table_count":6}