prefix . 'aitmt_translations'; $charset_collate = $wpdb->get_charset_collate(); $sql = "CREATE TABLE {$table} ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, source_hash char(64) NOT NULL, source_language varchar(16) NOT NULL, target_language varchar(16) NOT NULL, context varchar(80) NOT NULL DEFAULT 'html', object_id bigint(20) unsigned NOT NULL DEFAULT 0, source_text longtext NOT NULL, translated_text longtext NOT NULL, status varchar(20) NOT NULL DEFAULT 'published', provider varchar(40) NOT NULL DEFAULT 'manual', attempt_count int(10) unsigned NOT NULL DEFAULT 0, last_attempt_at datetime DEFAULT NULL, failed_reason text NOT NULL, batch_id varchar(64) NOT NULL DEFAULT '', source_type varchar(80) NOT NULL DEFAULT 'string', field_key varchar(120) NOT NULL DEFAULT '', created_at datetime NOT NULL, updated_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY aitmt_lookup (source_hash, source_language, target_language, context), KEY target_language (target_language), KEY status (status), KEY status_updated (status, updated_at), KEY batch_id (batch_id), KEY source_type (source_type), KEY object_id (object_id), KEY field_key (field_key) ) {$charset_collate};"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta($sql); } }