taula-mysql.sql
author viric <viriketo@gmail.com>
Sun, 13 Feb 2011 08:27:44 +0100
changeset 4 a3d29fb016c3
parent 0 6371497b4e53
permissions -rw-r--r--
Adding handling of tab and enter
viric@0
     1
drop table if exists vortoj_ru_ca;
viric@0
     2
viric@0
     3
create table vortoj_ru_ca (
viric@0
     4
	id int not null auto_increment,
viric@0
     5
	vorto tinytext not null,
viric@0
     6
	tipo tinytext not null,
viric@0
     7
	traduko tinytext default NULL,
viric@0
     8
	param1 tinytext default NULL,
viric@0
     9
	param2 tinytext default NULL,
viric@0
    10
	primary key (id)
viric@0
    11
) TYPE=MyISAM;
viric@0
    12
viric@0
    13
drop table if exists frazoj_ru_ca;
viric@0
    14
viric@0
    15
create table frazoj_ru_ca (
viric@0
    16
	id int not null auto_increment,
viric@0
    17
	vorto tinytext not null,
viric@0
    18
	frazo tinytext not null,
viric@0
    19
	korekta integer not null default 0,
viric@0
    20
	klarigo tinytext default null,
viric@0
    21
	korektisto tinytext default null,
viric@0
    22
	-- 0 = nekorektita
viric@0
    23
	-- 1 = gxusta
viric@0
    24
	-- 2 = malgxusta
viric@0
    25
	-- 3 = nekutima
viric@0
    26
	primary key (id)
viric@0
    27
) TYPE=MyISAM;