create database 3tabelit;

use 3tabelit;

create table kes (
	id int not null auto_increment primary key,
	nick varchar(30),
);

create table kohustused (
	id int not null auto_increment primary key,
	tekst text NOT NULL,
	nick_id int not null
);

create table vastused (
	id int not null auto_increment primary key,
	tekst_id int unsigned DEFAULT '0' NOT NULL,
	vastus text NOT NULL,
	KEY tekst_id (tekst_id)
);