|
0
|
1 |
drop table if exists vortoj_ru_ca;
|
|
|
2 |
|
|
|
3 |
create table vortoj_ru_ca (
|
|
|
4 |
id int not null auto_increment,
|
|
|
5 |
vorto tinytext not null,
|
|
|
6 |
tipo tinytext not null,
|
|
|
7 |
traduko tinytext default NULL,
|
|
|
8 |
param1 tinytext default NULL,
|
|
|
9 |
param2 tinytext default NULL,
|
|
|
10 |
primary key (id)
|
|
|
11 |
) TYPE=MyISAM;
|
|
|
12 |
|
|
|
13 |
drop table if exists frazoj_ru_ca;
|
|
|
14 |
|
|
|
15 |
create table frazoj_ru_ca (
|
|
|
16 |
id int not null auto_increment,
|
|
|
17 |
vorto tinytext not null,
|
|
|
18 |
frazo tinytext not null,
|
|
|
19 |
korekta integer not null default 0,
|
|
|
20 |
klarigo tinytext default null,
|
|
|
21 |
korektisto tinytext default null,
|
|
|
22 |
-- 0 = nekorektita
|
|
|
23 |
-- 1 = gxusta
|
|
|
24 |
-- 2 = malgxusta
|
|
|
25 |
-- 3 = nekutima
|
|
|
26 |
primary key (id)
|
|
|
27 |
) TYPE=MyISAM;
|