SQL:
====

CREATE TABLE hirdetesek (
azon INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
hirdetes TEXT NOT NULL,
lejarat DATE NOT NULL,
tipus VARCHAR(1) NOT NULL,
rang INT NOT NULL
) TYPE=INNODB DEFAULT CHARSET=UTF8;

CREATE TABLE cegek (
azon INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
nev VARCHAR(100) NOT NULL,
irsz VARCHAR(8) NOT NULL,
varos VARCHAR(50) NOT NULL,
utca VARCHAR(50) NOT NULL,
tel VARCHAR(30) NOT NULL,
fax VARCHAR(30) NOT NULL,
mobil VARCHAR(15) NOT NULL,
kapcsolattarto VARCHAR(40) NOT NULL,
email VARCHAR(50) NOT NULL,
weblap VARCHAR(120) NOT NULL,
tevekenyseg TEXT NOT NULL,
start DATE NOT NULL,
end DATE NOT NULL
) TYPE=INNODB DEFAULT CHARSET=UTF8;

CREATE TABLE ceg_kulcsszavak (
azon INT NOT NULL,
kulcsszo VARCHAR(120) NOT NULL,
FOREIGN KEY (azon) REFERENCES cegek(azon) ON DELETE CASCADE
) TYPE=INNODB DEFAULT CHARSET=UTF8;

CREATE TABLE mv (
azon INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
megye VARCHAR (50),
varos VARCHAR (50) UNIQUE
) TYPE=INNODB DEFAULT CHARSET=UTF8;