ALTER TABLE `feltet`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `napi_zaras`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `nempizza`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `nyitvatartas`
  ADD PRIMARY KEY (`nap`);

ALTER TABLE `pizza`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pizzaalap.id` (`pizzaalap_id`),
  ADD KEY `vasarlo.id` (`vasarlo_id`);

ALTER TABLE `pizzaalap`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `pizza_feltet`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pizza_id` (`pizza_id`),
  ADD KEY `feltet_id` (`feltet_id`),
  ADD KEY `feltet_id_2` (`feltet_id`),
  ADD KEY `id` (`id`),
  ADD KEY `pizza_id_2` (`pizza_id`);

ALTER TABLE `pizzeria`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cim.id` (`cim_id`);


ALTER TABLE `rendeles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `vasarlo.id` (`vasarlo_id`),
  ADD KEY `szamla.id` (`szamla_id`),
  ADD KEY `cim_id` (`cim_id`),
  ADD KEY `cim_id_2` (`cim_id`);


ALTER TABLE `rendeles_temp`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`),
  ADD KEY `vasarlo_id` (`vasarlo_id`),
  ADD KEY `pizza_id` (`pizza_id`),
  ADD KEY `nempizza_id` (`nempizza_id`),
  ADD KEY `rendeles_id` (`rendeles_id`);


ALTER TABLE `szamla`
  ADD PRIMARY KEY (`id`),
  ADD KEY `vasarlo.id` (`vasarlo_id`),
  ADD KEY `rendeles.id` (`rendeles_id`),
  ADD KEY `pizzeria.id` (`pizzeria_id`);


ALTER TABLE `termekek`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rendeles_id` (`rendeles_id`),
  ADD KEY `pizza_id` (`pizza_id`),
  ADD KEY `nempizza_id` (`nempizza_id`),
  ADD KEY `pizza_id_2` (`pizza_id`),
  ADD KEY `nempizza_id_2` (`nempizza_id`),
  ADD KEY `feltet_id` (`feltet_id`);


ALTER TABLE `vasarlo`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD UNIQUE KEY `felhasznalonev` (`felhasznalonev`),
  ADD KEY `elsodleges_szall_cim` (`elsodleges_szall_cim`),
  ADD KEY `szamlazasi_cim` (`szamlazasi_cim`);


ALTER TABLE `cim`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;


ALTER TABLE `feltet`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;


ALTER TABLE `napi_zaras`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;


ALTER TABLE `nempizza`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;


ALTER TABLE `pizza`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;


ALTER TABLE `pizzaalap`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;


ALTER TABLE `pizza_feltet`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;


ALTER TABLE `pizzeria`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;


ALTER TABLE `rendeles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;


ALTER TABLE `rendeles_temp`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;


ALTER TABLE `szamla`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;


ALTER TABLE `termekek`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=179;


ALTER TABLE `vasarlo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;



ALTER TABLE `cim`
  ADD CONSTRAINT `Cim_ibfk_1` FOREIGN KEY (`vasarlo_id`) REFERENCES `vasarlo` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;


ALTER TABLE `pizza`
  ADD CONSTRAINT `Pizza_ibfk_1` FOREIGN KEY (`pizzaalap_id`) REFERENCES `pizzaalap` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `Pizza_ibfk_3` FOREIGN KEY (`vasarlo_id`) REFERENCES `vasarlo` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;


ALTER TABLE `pizza_feltet`
  ADD CONSTRAINT `Pizza_feltet_ibfk_1` FOREIGN KEY (`pizza_id`) REFERENCES `pizza` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `Pizza_feltet_ibfk_2` FOREIGN KEY (`feltet_id`) REFERENCES `feltet` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;


ALTER TABLE `pizzeria`
  ADD CONSTRAINT `Pizzeria_ibfk_1` FOREIGN KEY (`cim_id`) REFERENCES `cim` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;


ALTER TABLE `rendeles`
  ADD CONSTRAINT `Rendeles_ibfk_1` FOREIGN KEY (`vasarlo_id`) REFERENCES `vasarlo` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `Rendeles_ibfk_3` FOREIGN KEY (`szamla_id`) REFERENCES `szamla` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `Rendeles_ibfk_4` FOREIGN KEY (`cim_id`) REFERENCES `cim` (`id`) ON DELETE SET NULL;


ALTER TABLE `rendeles_temp`
  ADD CONSTRAINT `rendeles_temp_ibfk_1` FOREIGN KEY (`vasarlo_id`) REFERENCES `vasarlo` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  ADD CONSTRAINT `rendeles_temp_ibfk_2` FOREIGN KEY (`pizza_id`) REFERENCES `pizza` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  ADD CONSTRAINT `rendeles_temp_ibfk_3` FOREIGN KEY (`nempizza_id`) REFERENCES `nempizza` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  ADD CONSTRAINT `rendeles_temp_ibfk_4` FOREIGN KEY (`rendeles_id`) REFERENCES `rendeles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE `szamla`
  ADD CONSTRAINT `Szamla_ibfk_1` FOREIGN KEY (`pizzeria_id`) REFERENCES `pizzeria` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `Szamla_ibfk_2` FOREIGN KEY (`rendeles_id`) REFERENCES `rendeles` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `Szamla_ibfk_3` FOREIGN KEY (`vasarlo_id`) REFERENCES `vasarlo` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

ALTER TABLE `termekek`
  ADD CONSTRAINT `Termekek_ibfk_3` FOREIGN KEY (`rendeles_id`) REFERENCES `rendeles` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `Termekek_ibfk_4` FOREIGN KEY (`pizza_id`) REFERENCES `pizza` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `Termekek_ibfk_5` FOREIGN KEY (`nempizza_id`) REFERENCES `nempizza` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `Termekek_ibfk_6` FOREIGN KEY (`feltet_id`) REFERENCES `feltet` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;


ALTER TABLE `vasarlo`
  ADD CONSTRAINT `Vasarlo_ibfk_1` FOREIGN KEY (`szamlazasi_cim`) REFERENCES `cim` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `Vasarlo_ibfk_2` FOREIGN KEY (`elsodleges_szall_cim`) REFERENCES `cim` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
COMMIT;