{"slug":"getpaid-item-inventory","name":"GetPaid > Item Inventory","description":"Set the inventory amount and never sell anything you don't have in stock.","author":"Stiofan","active_installs":400,"version":"2.0.3","wp_org_url":"https://wordpress.org/plugins/getpaid-item-inventory/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"getpaid_reserved_stock","full_table_name":"wp_getpaid_reserved_stock","description":"Stores getpaid reserved stock data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"invoice_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"item_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"stock_quantity","type":"double","nullable":false,"primary_key":false},{"name":"timestamp","type":"datetime","nullable":false,"primary_key":false},{"name":"expires","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_getpaid_reserved_stock ( `invoice_id` bigint(20) NOT NULL, `item_id` bigint(20) NOT NULL, `stock_quantity` double NOT NULL DEFAULT 0, `timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `expires` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`invoice_id`, `item_id`) ) $charset_collate;\"; dbDelta( $sql );"}],"table_count":1}