wp_gts_translated_options

Static

Stores gts translated options data created by this plugin.

Column Definitions

Column	Type	Nullable
🔑id	bigint	NO
local_id	varchar(255)	NO
foreign_id	int	NO
language	char(16)	NO
name	varchar(255)	NO
value	text	NO
created_time	timestamp	YES
modified_time	timestamp	NO
local_id	bigint	NO
foreign_id	int	NO
language	char(16)	NO
post_title	text	NO
post_excerpt	text	NO
post_body	longtext	NO
post_slug	tinytext	NO
created_time	timestamp	YES
modified_time	timestamp	NO
local_name	varchar(255)	NO
foreign_id	int	NO
language	char(16)	NO
name	varchar(255)	NO
slug	varchar(255)	NO
description	text	YES
created_time	timestamp	YES
modified_time	timestamp	NO

CREATE TABLE Statement

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'" );

Safe to delete?

If you have uninstalled GTS Translation Plugin, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_gts_translated_options`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from GTS Translation Plugin

wp_gts_translated_posts