Changes between Version 4 and Version 5 of DdlScript

Timestamp:

06/14/26 19:41:57 (34 hours ago)

Author:

231141

Comment:

--

DdlScript

@@ -84 +84 @@
         FOREIGN KEY (category_id)
         REFERENCES Category(id)
-        ON DELETE CASCADE
+        ON DELETE RESTRICT
 );
 
@@ -220 +220 @@
         FOREIGN KEY (client_id)
         REFERENCES Client(id)
-        ON DELETE CASCADE,
+        ON DELETE RESTRICT,
 
     CONSTRAINT fk_task_request_category
@@ -264 +264 @@
         FOREIGN KEY (worker_id)
         REFERENCES Worker(id)
-        ON DELETE CASCADE,
+        ON DELETE RESTRICT,
 
     CONSTRAINT fk_offer_task_request
         FOREIGN KEY (task_request_id)
         REFERENCES TaskRequest(id)
-        ON DELETE CASCADE
+        ON DELETE RESTRICT
 );
 CREATE TABLE Task (
@@ -307 +307 @@
         FOREIGN KEY (task_id)
         REFERENCES Task(id)
-        ON DELETE CASCADE,
+        ON DELETE SET NULL,
 
     CONSTRAINT fk_message_sender
@@ -334 +334 @@
         FOREIGN KEY (task_id)
         REFERENCES Task(id)
-        ON DELETE CASCADE,
+        ON DELETE RESTRICT,
 
     CONSTRAINT fk_review_reviewed
         FOREIGN KEY (reviewed_id)
         REFERENCES UserAccount(id)
-        ON DELETE CASCADE,
+        ON DELETE SET NULL,
 
     CONSTRAINT fk_review_reviewer
@@ -374 +374 @@
         FOREIGN KEY (task_id)
         REFERENCES Task(id)
-        ON DELETE CASCADE,
+        ON DELETE RESTRICT,
 
     CONSTRAINT fk_complaint_client
         FOREIGN KEY (client_id)
         REFERENCES Client(id)
-        ON DELETE CASCADE,
+        ON DELETE RESTRICT,
 
     CONSTRAINT fk_complaint_worker
         FOREIGN KEY (worker_id)
         REFERENCES Worker(id)
-        ON DELETE CASCADE
+        ON DELETE RESTRICT
 );
 CREATE TABLE ComplaintAttachment (