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