taula-mysql.sql
author viric <viriketo@gmail.com>
Sun, 13 Feb 2011 08:43:06 +0100
changeset 5 f2a2f64eb682
parent 0 6371497b4e53
permissions -rw-r--r--
Events don't work as I expect. tab makes save sentence, while enter should be doing that.

drop table if exists vortoj_ru_ca;

create table vortoj_ru_ca (
	id int not null auto_increment,
	vorto tinytext not null,
	tipo tinytext not null,
	traduko tinytext default NULL,
	param1 tinytext default NULL,
	param2 tinytext default NULL,
	primary key (id)
) TYPE=MyISAM;

drop table if exists frazoj_ru_ca;

create table frazoj_ru_ca (
	id int not null auto_increment,
	vorto tinytext not null,
	frazo tinytext not null,
	korekta integer not null default 0,
	klarigo tinytext default null,
	korektisto tinytext default null,
	-- 0 = nekorektita
	-- 1 = gxusta
	-- 2 = malgxusta
	-- 3 = nekutima
	primary key (id)
) TYPE=MyISAM;