Changes between Version 28 and Version 29 of RelationalDesign

Timestamp:

08/30/24 19:09:17 (5 months ago)

Author:

184006

Comment:

--

RelationalDesign

@@ -116 +116 @@
 
 '''Измени во DDL скриптата за креирање на табели'''
+{{{
+ALTER TABLE pets 
+DROP CONSTRAINT IF EXISTS petcares; 
+
+ALTER TABLE pets 
+DROP COLUMN IF EXISTS petcares;
+
+
+
+ALTER TABLE pet_cares 
+ADD COLUMN pet_id BIGINT;
+
+ALTER TABLE pet_cares 
+ADD CONSTRAINT fk_pet_id FOREIGN KEY (pet_id) REFERENCES pets(id) ON DELETE CASCADE; 
+}}}