Changes between Version 6 and Version 7 of ddlScript.sql

Timestamp:

08/24/26 16:23:44 (13 days ago)

Author:

211099

Comment:

--

ddlScript.sql

@@ -2 +2 @@
 
  
+
 -- Delete tables if they exist
 DROP TABLE IF EXISTS NEED_APPROVAL CASCADE;
@@ -119 +120 @@
     link VARCHAR(500),
     user_id INTEGER NOT NULL,
-    story_id INTEGER NOT NULL,
+    story_id INTEGER,
     notification_created_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP,
     FOREIGN KEY (user_id) REFERENCES USERS(user_id)
@@ -125 +126 @@
         ON UPDATE CASCADE,
     FOREIGN KEY (story_id) REFERENCES STORY(story_id)
-        ON DELETE CASCADE
+        ON DELETE SET NULL
         ON UPDATE CASCADE
 );