{"table_name":"bslco_offers","full_table_name":"wp_bslco_offers","description":"Stores bslco offers data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_bslco_offers ( id bigint(20) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, product_id bigint(20) NOT NULL, offer_price decimal(10,2) NOT NULL, offer_type varchar(20) DEFAULT 'automatic' NOT NULL, quantity int(11) DEFAULT 1 NOT NULL, shipping_charge decimal(10,2) DEFAULT 0.00 NOT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP NOT NULL, expires_at datetime NOT NULL, status varchar(20) DEFAULT 'active' NOT NULL, order_id bigint(20) DEFAULT 0, PRIMARY KEY (id), KEY user_id (user_id), KEY product_id (product_id) ) {$charset_collate};\"; $sql2 = \"CREATE TABLE wp_bslco_messages ( id bigint(20) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, product_id bigint(20) NOT NULL, sender_type varchar(20) DEFAULT 'customer' NOT NULL, message text NOT NULL, offer_id bigint(20) DEFAULT 0 NOT NULL, offer_ids text NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP NOT NULL, PRIMARY KEY (id), KEY user_id (user_id), KEY product_id (product_id) ) {$charset_collate};\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql1 );","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"offer_price","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"offer_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"quantity","type":"int(11)","nullable":false,"primary_key":false},{"name":"shipping_charge","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"expires_at","type":"datetime","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"sender_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"message","type":"text","nullable":false,"primary_key":false},{"name":"offer_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"offer_ids","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"like-and-custom-offer-for-woocommerce","name":"Like and Custom Offer for WooCommerce","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/like-and-custom-offer-for-woocommerce/"}}