create database gaz;
use gaz;
create table szemely (sz_id char(3),veznev char(20),utonev char(15));
create table utca (U_id char(2), nev char(15));
create table lakcim (l_id char(4),sz_id char(3),u_id char(2),hsz smallint,em smallint,ajto smallint);
create table gazora (efa char(10),l_id char(4),allas char(6));
insert into utca values('01','Ag utca');
insert into utca values('02','Aranyhal utca');
insert into utca values('03','Bem rakpart');
insert into utca values('04','Balta koz');
insert into utca values('05','Fo utca');
insert into utca values('06','Iskola utca');
insert into utca values('07','Hunfalvy utca');
insert into utca values('08','Naphegy utca');
insert into utca values('09','Piroska utca');
insert into utca values('10','Ponty utca');
insert into utca values('11','Orom utca');
insert into utca values('12','Roham utca');
insert into szemely values ('001','Sukusd','Balazs');
insert into szemely values ('002','Nagy','Attila');
insert into szemely values ('003','Szoke','Gyula');
insert into szemely values ('004','Sallai','Rozalia');
insert into szemely values ('005','Negro','Erno');
insert into szemely values ('006','Csorba','Kinga');
insert into szemely values ('007','Kemer','Imre');
insert into szemely values ('008','Kovacs','Lajos');
insert into szemely values ('009','Madai','Lajos');
insert into szemely values ('010','Antal','Krisztina');
insert into szemely values ('011','Szabo','Krisztina');
insert into szemely values ('012','Bula','Anna');
insert into szemely values ('013','Csemez','Edina');
insert into szemely values ('014','Felek','Zsolt');
insert into szemely values ('015','Funtek','Anita');
insert into szemely values ('016','Fitos','Gabor');
insert into szemely values ('017','Vas','Gyula');
insert into szemely values ('018','Uvek','Balazs');
insert into szemely values ('019','Ottoway','Laszlo');
insert into szemely values ('020','Gecse','Istvan');
insert into szemely values ('021','Hanzel','Dora');
insert into lakcim values ('0331','008','03',22,8,3);
insert into lakcim values ('0601','009','03',32,9,3);
insert into lakcim values ('0221','010','03',42,10,3);
insert into lakcim values ('0331','011','03',52,11,3);
insert into lakcim values ('0001','012','03',52,1,31);
insert into lakcim values ('0341','013','04',52,2,31);
insert into lakcim values ('0061','014','05',12,3,31);
insert into lakcim values ('0231','015','05',82,4,31);
insert into lakcim values ('0002','016','05',82,5,32);
insert into lakcim values ('0003','017','11',15,6,23);
insert into lakcim values ('0004','018','11',34,7,23);
insert into lakcim values ('0005','019','11',134,1,33);
insert into lakcim values ('0006','020','06',14,1,3);
insert into lakcim values ('0007','021','06',142,1,3);
insert into lakcim values ('0201','001','06',144,1,43);
insert into lakcim values ('0301','002','08',14,1,34);
insert into lakcim values ('0401','003','08',17,1,34);
insert into lakcim values ('0501','004','12',13,1,32);
insert into lakcim values ('0701','005','12',13,1,3);
insert into lakcim values ('0801','006','07',45,1,13);
insert into lakcim values ('0901','007','07',45,1,32);
insert into lakcim values ('2001','008','07',76,3,3);
insert into lakcim values ('3001','001','09',23,3,2);
insert into lakcim values ('4001','002','09',44,3,1);
insert into lakcim values ('5001','003','09',66,2,3);
insert into lakcim values ('6001','004','09',88,2,3);
insert into lakcim values ('7001','011','10',12,2,3);
insert into lakcim values ('8001','021','10',12,0,3);
insert into lakcim values ('0241','013','10',14,0,1);
insert into lakcim values ('0461','016','10',12,0,32);
insert into lakcim values ('0681','018','01',19,1,3);
insert into lakcim values ('8888','015','10',21,1,23);
insert into lakcim values ('1111','020','04',22,1,36);
insert into lakcim values ('2222','021','04',35,1,23);
insert into lakcim values ('3333','011','03',45,2,3);
insert into lakcim values ('4444','014','03',16,2,3);
insert into lakcim values ('9999','017','07',99,2,32);
insert into lakcim values ('7777','016','07',28,2,32);
insert into lakcim values ('5555','005','08',32,2,3);
insert into lakcim values ('6666','006','08',68,1,3);
insert into lakcim values ('9801','007','09',12,1,13);
insert into lakcim values ('7601','011','11',33,1,13);
insert into lakcim values ('5401','010','11',53,10,3);
insert into lakcim values ('3101','009','12',12,11,3);
insert into gazora values ('0000000001','0331','11212');
insert into gazora values ('0000000111','0601','009');
insert into gazora values ('0000000222','0221','010');
insert into gazora values ('0000000333','0331','011');
insert into gazora values ('0000000444','0001','012');
insert into gazora values ('0000000555','0341','013');
insert into gazora values ('0000000666','0061','014');
insert into gazora values ('0000000777','0231','015');
insert into gazora values ('0000000888','0002','016');
insert into gazora values ('0000000999','0003','017');
insert into gazora values ('0000001111','0004','018');
insert into gazora values ('0000002222','0005','019');
insert into gazora values ('0000003333','0006','020');
insert into gazora values ('0000004444','0007','021');
insert into gazora values ('0000005555','0201','001');
insert into gazora values ('0000006666','0301','002');
insert into gazora values ('0000007777','0401','003');
insert into gazora values ('0000008888','0501','004');
insert into gazora values ('0000009999','0701','005');
insert into gazora values ('0000000101','0801','006');
insert into gazora values ('0000000202','0901','007');
insert into gazora values ('0000001212','2001','008');
insert into gazora values ('0000002323','3001','001');
insert into gazora values ('0000003434','4001','002');
insert into gazora values ('0000004545','5001','003');
insert into gazora values ('0000004646','6001','004');
insert into gazora values ('0000005656','7001','011');
insert into gazora values ('0000006767','8001','021');
insert into gazora values ('0000007878','0241','013');
insert into gazora values ('0000008989','0461','016');
insert into gazora values ('0000002424','0681','018');
insert into gazora values ('0000002525','8888','015');
insert into gazora values ('0000002121','1111','020');
insert into gazora values ('0000003232','2222','021');
insert into gazora values ('0000004343','3333','011');
insert into gazora values ('0000005454','4444','014');
insert into gazora values ('0000006565','9999','017');
insert into gazora values ('0000007676','7777','016');
insert into gazora values ('0000008787','5555','005');
insert into gazora values ('0000009898','6666','006');
insert into gazora values ('0000006212','9801','007');
insert into gazora values ('0000001234','7601','011');
insert into gazora values ('0000002345','5401','010');
insert into gazora values ('0000003456','3101','009');

