get_charset_collate(); $strings = Translation_Memory::table(); $slugs = Slugs::table(); $pages = Pages::table(); // dbDelta is whitespace-sensitive: two spaces after PRIMARY KEY. dbDelta( "CREATE TABLE {$strings} ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, source_hash char(40) NOT NULL, lang varchar(12) NOT NULL, source longtext NOT NULL, translation longtext NULL, status varchar(10) NOT NULL DEFAULT 'machine', url varchar(255) NOT NULL DEFAULT '', created_at datetime NOT NULL, updated_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY hash_lang (source_hash,lang), KEY lang_status (lang,status) ) {$charset};" ); dbDelta( "CREATE TABLE {$slugs} ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, lang varchar(12) NOT NULL, source_slug varchar(190) NOT NULL, translated_slug varchar(190) NOT NULL, status varchar(10) NOT NULL DEFAULT 'machine', created_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY lang_source (lang,source_slug), UNIQUE KEY lang_translated (lang,translated_slug) ) {$charset};" ); // How complete each page is in each language (Pages): public paths and counts, no text. dbDelta( "CREATE TABLE {$pages} ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, path_hash char(40) NOT NULL, path varchar(2048) NOT NULL, lang varchar(12) NOT NULL, chars int(10) unsigned NOT NULL DEFAULT 0, translated_chars int(10) unsigned NOT NULL DEFAULT 0, pending int(10) unsigned NOT NULL DEFAULT 0, asked_at datetime NULL, attempts tinyint(3) unsigned NOT NULL DEFAULT 0, set_aside_until datetime NULL, reason varchar(16) NOT NULL DEFAULT '', updated_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY path_lang (path_hash,lang), KEY lang (lang), KEY asked_at (asked_at) ) {$charset};" ); update_option( 'langferry_db_version', LANGFERRY_DB_VERSION, true ); } }