1create table nt_trans_strings ( 2 string_id integer not null primary key auto_increment, 3 string text, 4 5 index(string(150)) 6); 7 8create table nt_trans_locs ( 9 loc_id integer not null primary key auto_increment, 10 string_id integer not null, 11 version integer default 0, 12 filename varchar(255), 13 location varchar(255), 14 15 index(string_id), 16 index(filename) 17) TYPE=INNODB; 18 19create table nt_trans_maps ( 20 map_id integer not null primary key auto_increment, 21 string_id integer not null, 22 lang char(2), 23 string text, 24 25 index(string_id) 26) TYPE=INNODB; 27