{"table_name":"ald_posts","full_table_name":"wp_ald_posts","description":"Stores ald posts data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"create table if not exists wp_ald_posts ( ID bigint unsigned auto_increment primary key, post_author bigint unsigned default 0 not null, post_date datetime default '0000-00-00 00:00:00' not null, post_date_gmt datetime default '0000-00-00 00:00:00' not null, post_content longtext not null, post_title text not null, post_excerpt text not null, post_status varchar(20) default 'publish' not null, comment_status varchar(20) default 'open' not null, ping_status varchar(20) default 'open' not null, post_password varchar(255) default '' not null, post_name varchar(200) default '' not null, to_ping text not null, pinged text not null, post_modified datetime default '0000-00-00 00:00:00' not null, post_modified_gmt datetime default '0000-00-00 00:00:00' not null, post_content_filtered longtext not null, post_parent bigint unsigned default 0 not null, guid varchar(255) default '' not null, menu_order int default 0 not null, post_type varchar(20) default 'post' not null, post_mime_type varchar(100) default '' not null, comment_count bigint default 0 not null, KEY post_name (post_name($max_index_length)), KEY type_status_date (post_type,post_status,post_date,ID), KEY post_parent (post_parent), KEY post_author (post_author) ) {$collate}\"; $query_meta = \"create table if not exists wp_ald_postmeta ( meta_id bigint(20) unsigned NOT NULL auto_increment, ald_post_id bigint(20) unsigned NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (meta_id), KEY ald_post_id (ald_post_id), KEY meta_key (meta_key($max_index_length)) ) {$collate}\"; $wpdb->query( $query );","columns":[{"name":"ID","type":"bigint unsigned","nullable":true,"primary_key":true},{"name":"post_author","type":"bigint unsigned","nullable":false,"primary_key":false},{"name":"post_date","type":"datetime","nullable":false,"primary_key":false},{"name":"post_date_gmt","type":"datetime","nullable":false,"primary_key":false},{"name":"post_content","type":"longtext","nullable":false,"primary_key":false},{"name":"post_title","type":"text","nullable":false,"primary_key":false},{"name":"post_excerpt","type":"text","nullable":false,"primary_key":false},{"name":"post_status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"comment_status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"ping_status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"post_password","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"post_name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"to_ping","type":"text","nullable":false,"primary_key":false},{"name":"pinged","type":"text","nullable":false,"primary_key":false},{"name":"post_modified","type":"datetime","nullable":false,"primary_key":false},{"name":"post_modified_gmt","type":"datetime","nullable":false,"primary_key":false},{"name":"post_content_filtered","type":"longtext","nullable":false,"primary_key":false},{"name":"post_parent","type":"bigint unsigned","nullable":false,"primary_key":false},{"name":"guid","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"menu_order","type":"int","nullable":false,"primary_key":false},{"name":"post_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"post_mime_type","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"comment_count","type":"bigint","nullable":false,"primary_key":false},{"name":"ald_post_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false}],"plugin":{"slug":"woo-alidropship","name":"ALD – Dropshipping and Fulfillment for AliExpress and WooCommerce","active_installs":10000,"version":"2.2.1","wp_org_url":"https://wordpress.org/plugins/woo-alidropship/"}}