viric@0: drop table if exists vortoj_ru_ca; viric@0: viric@0: create table vortoj_ru_ca ( viric@0: id int not null auto_increment, viric@0: vorto tinytext not null, viric@0: tipo tinytext not null, viric@0: traduko tinytext default NULL, viric@0: param1 tinytext default NULL, viric@0: param2 tinytext default NULL, viric@0: primary key (id) viric@0: ) TYPE=MyISAM; viric@0: viric@0: drop table if exists frazoj_ru_ca; viric@0: viric@0: create table frazoj_ru_ca ( viric@0: id int not null auto_increment, viric@0: vorto tinytext not null, viric@0: frazo tinytext not null, viric@0: korekta integer not null default 0, viric@0: klarigo tinytext default null, viric@0: korektisto tinytext default null, viric@0: -- 0 = nekorektita viric@0: -- 1 = gxusta viric@0: -- 2 = malgxusta viric@0: -- 3 = nekutima viric@0: primary key (id) viric@0: ) TYPE=MyISAM;