{"slug":"delicious-digital-product-manager","name":"Delicious Digital Product Manager","description":"Sell and securely deliver digital products in WordPress with bank transfer orders, protected downloads and customer accounts.","author":"Shakir Pichler","active_installs":0,"version":"2.3.7","wp_org_url":"https://wordpress.org/plugins/delicious-digital-product-manager/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"dwdpm_downloads","full_table_name":"wp_dwdpm_downloads","description":"Stores dwdpm downloads data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"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_limit","type":"int unsigned","nullable":false,"primary_key":false},{"name":"download_count","type":"int unsigned","nullable":false,"primary_key":false},{"name":"expires_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_dwdpm_downloads ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL, order_id bigint(20) unsigned NOT NULL DEFAULT 0, product_id bigint(20) unsigned NOT NULL, download_limit int unsigned NOT NULL DEFAULT 0, download_count int unsigned NOT NULL DEFAULT 0, expires_at datetime NULL, created_at datetime NOT NULL, PRIMARY KEY (id), KEY user_id (user_id), KEY product_id (product_id), KEY order_id (order_id) ) $c;\");"},{"table_name":"dwdpm_order_items","full_table_name":"wp_dwdpm_order_items","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"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":"qty","type":"int unsigned","nullable":false,"primary_key":false},{"name":"price","type":"decimal(12,2)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_dwdpm_order_items ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, order_id bigint(20) unsigned NOT NULL, product_id bigint(20) unsigned NOT NULL, qty int unsigned NOT NULL DEFAULT 1, price decimal(12,2) NOT NULL DEFAULT 0.00, PRIMARY KEY (id), KEY order_id (order_id), KEY product_id (product_id) ) $c;\");"},{"table_name":"dwdpm_orders","full_table_name":"wp_dwdpm_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"order_key","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"email","type":"varchar(190)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(30)","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":"discount_code","type":"varchar(80)","nullable":false,"primary_key":false},{"name":"discount_amount","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"total","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"payment_provider","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"payment_reference","type":"varchar(190)","nullable":false,"primary_key":false},{"name":"fulfilled_at","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}],"create_sql":"CREATE TABLE wp_dwdpm_orders ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, order_key varchar(64) NOT NULL, user_id bigint(20) unsigned NOT NULL DEFAULT 0, email varchar(190) NOT NULL DEFAULT '', status varchar(30) NOT NULL DEFAULT 'pending', currency varchar(10) NOT NULL DEFAULT 'AUD', subtotal decimal(12,2) NOT NULL DEFAULT 0.00, discount_code varchar(80) NOT NULL DEFAULT '', discount_amount decimal(12,2) NOT NULL DEFAULT 0.00, total decimal(12,2) NOT NULL DEFAULT 0.00, payment_provider varchar(30) NOT NULL DEFAULT '', payment_reference varchar(190) NOT NULL DEFAULT '', fulfilled_at datetime NULL, created_at datetime NOT NULL, updated_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY order_key (order_key), KEY user_id (user_id), KEY email (email), KEY status (status) ) $c;\");"}],"table_count":3}