SHOW:
|
|
- or go back to the newest paste.
| 1 | ALTER TABLE "BILETI" ADD CONSTRAINT "BILETI_TEATAR_FK" FOREIGN KEY ("T") REFERENCES "TEATRI" ("T")
| |
| 2 | ON DELETE SET NULL; | |
| 3 | ALTER TABLE "BILETI" ADD CONSTRAINT "BILETI_PRETSTAVA_FK" FOREIGN KEY ("P") REFERENCES "PRETSTAVI" ("P")
| |
| 4 | ON DELETE SET NULL; | |
| 5 | ||
| 6 | ALTER TABLE "ULOGI" ADD CONSTRAINT "ULOGI_VRABOTEN_FK" FOREIGN KEY ("V") REFERENCES "VRABOTENI" ("V")
| |
| 7 | ON DELETE SET NULL; | |
| 8 | ALTER TABLE "ULOGI" ADD CONSTRAINT "ULOGI_PRETSTAVA_FK" FOREIGN KEY ("P") REFERENCES "PRETSTAVI" ("P")
| |
| 9 | ON DELETE SET NULL; | |
| 10 | ||
| 11 | ALTER TABLE "ZARABOTUVA" ADD CONSTRAINT "ZARABOTUVA_VRABOTEN_FK" FOREIGN KEY ("V") REFERENCES "VRABOTENI" ("V")
| |
| 12 | ON DELETE SET NULL; | |
| 13 | ALTER TABLE "ZARABOTUVA" ADD CONSTRAINT "ZARABOTUVA_TEATAR_FK" FOREIGN KEY ("T") REFERENCES "TEATRI" ("T")
| |
| 14 | ON DELETE SET NULL; | |
| 15 | ||
| 16 | /* | |
| 17 | bidejki pretstava so id=500 ne postoi vo tabelata PRETSTAVI, za da moze da se | |
| 18 | dodade foreign key moze ili da dodademe takva prestava, ili da go izbriseme | |
| 19 | soodvetniot red od tabelata ZARABOTUVA | |
| 20 | */ | |
| 21 | DELETE FROM "ZARABOTUVA" WHERE P = 500; | |
| 22 | ||
| 23 | ALTER TABLE "ZARABOTUVA" ADD CONSTRAINT "ZARABOTUVA_PRETSTAVA_FK" FOREIGN KEY ("P") REFERENCES "PRETSTAVI" ("P")
| |
| 24 | ON DELETE SET NULL; |
