{"table_name":"gts_translated_options","full_table_name":"wp_gts_translated_options","description":"Stores gts translated options data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE gts_translated_options ( id bigint not null primary key auto_increment, local_id varchar(255) not null, foreign_id int not null, language char(16) not null, name varchar(255) not null, value text not null, created_time timestamp null default null, modified_time timestamp not null default now(), UNIQUE KEY (local_id, language) ) CHARACTER SET 'utf8'\", \"CREATE TABLE gts_translated_posts ( id bigint not null primary key auto_increment, local_id bigint not null, foreign_id int not null, language char(16) not null, post_title text not null, post_excerpt text not null, post_body longtext not null, post_slug tinytext not null, created_time timestamp null default null, modified_time timestamp not null default now(), UNIQUE KEY (local_id, language), INDEX (post_slug(255), language) ) CHARACTER SET 'utf8'\", \"CREATE TABLE gts_translated_terms ( id bigint not null primary key auto_increment, local_name varchar(255) not null, foreign_id int not null, language char(16) not null, name varchar(255) not null, slug varchar(255) not null, description text, created_time timestamp null default null, modified_time timestamp not null default now(), UNIQUE KEY (local_name, language), UNIQUE KEY (slug, language) ) CHARACTER SET 'utf8'\" );","columns":[{"name":"id","type":"bigint","nullable":false,"primary_key":true},{"name":"local_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"foreign_id","type":"int","nullable":false,"primary_key":false},{"name":"language","type":"char(16)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"value","type":"text","nullable":false,"primary_key":false},{"name":"created_time","type":"timestamp","nullable":true,"primary_key":false},{"name":"modified_time","type":"timestamp","nullable":false,"primary_key":false},{"name":"local_id","type":"bigint","nullable":false,"primary_key":false},{"name":"foreign_id","type":"int","nullable":false,"primary_key":false},{"name":"language","type":"char(16)","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_body","type":"longtext","nullable":false,"primary_key":false},{"name":"post_slug","type":"tinytext","nullable":false,"primary_key":false},{"name":"created_time","type":"timestamp","nullable":true,"primary_key":false},{"name":"modified_time","type":"timestamp","nullable":false,"primary_key":false},{"name":"local_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"foreign_id","type":"int","nullable":false,"primary_key":false},{"name":"language","type":"char(16)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"created_time","type":"timestamp","nullable":true,"primary_key":false},{"name":"modified_time","type":"timestamp","nullable":false,"primary_key":false}],"plugin":{"slug":"gts-translation","name":"GTS Translation Plugin","active_installs":10,"version":"1.4.0","wp_org_url":"https://wordpress.org/plugins/gts-translation/"}}