taula-mysql.sql
author viric <viriketo@gmail.com>
Sun, 13 Feb 2011 07:57:02 +0100
changeset 2 5331bd08a294
parent 0 6371497b4e53
permissions -rw-r--r--
Starting a C++ version of the UI
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;