Forum PHP.pl

[SQL] pobierz, plaintext 
 ALTER TABLE zdjecia ADD FOREIGN KEY (id_Format) REFERENCES format(id_Format); 
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
CREATE TABLE zdjecia(
id_Zdjecie int UNSIGNED AUTO_INCREMENT NOT NULL ,
id_Format int UNSIGNED NOT NULL,
Nazwa_zdjecie varchar(30),
PRIMARY KEY (id_Zdjecie)
);
CREATE TABLE format(
id_Format int UNSIGNED AUTO_INCREMENT NOT NULL,
wymiar varchar(10),
Rodzaj_papieru varchar(10),
Cena Decimal(4,2),
PRIMARY KEY (id_Format)
);
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
ALTER TABLE `zdjecia` ADD CONSTRAINT `fk` FOREIGN KEY (`id_Format`) REFERENCES `format` (`id_Format`) ON DELETE CASCADE ON UPDATE CASCADE;;
[SQL] pobierz, plaintext