{"table_name":"control_listings_bookmarks","full_table_name":"wp_control_listings_bookmarks","description":"Stores control listings bookmarks data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_control_listings_bookmarks ( id bigint(20) NOT NULL auto_increment, user_id bigint(20) NOT NULL, post_id bigint(20) NOT NULL, bookmark_note longtext NULL, date_created datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id) ) $collate; \"; dbDelta( $sql );","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"post_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"bookmark_note","type":"longtext","nullable":true,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"control-listings","name":"Control Listings – Classifieds Ads Directory Portal Manager","active_installs":30,"version":"1.0.7","wp_org_url":"https://wordpress.org/plugins/control-listings/"}}