Changes between Version 8 and Version 9 of DatabaseCreation

Timestamp:

06/16/26 10:49:19 (2 days ago)

Author:

231166

Comment:

--

DatabaseCreation

@@ -26 +26 @@
   CONSTRAINT fk_user_subscription
     FOREIGN KEY (SubscriptionSubscriptionID)
-    REFERENCES Subscription (SubscriptionID)
+    REFERENCES Subscription (SubscriptionID) ON UPDATE CASCADE
 );
 
@@ -61 +61 @@
   CONSTRAINT fk_us_user
     FOREIGN KEY (UserUserID)
-    REFERENCES "User" (UserID),
+    REFERENCES "User" (UserID) ON DELETE CASCADE ON UPDATE CASCADE,
 
   CONSTRAINT fk_us_subscription
     FOREIGN KEY (SubscriptionSubscriptionID)
-    REFERENCES Subscription (SubscriptionID),
+    REFERENCES Subscription (SubscriptionID) ON DELETE CASCADE ON UPDATE CASCADE,
 
   CONSTRAINT unique_user_subscription
@@ -92 +92 @@
   CONSTRAINT fk_movie_media
     FOREIGN KEY (MovieID)
-    REFERENCES Media (ContentID)
+    REFERENCES Media (ContentID) ON DELETE CASCADE ON UPDATE CASCADE);
 );
 
@@ -102 +102 @@
   CONSTRAINT fk_series_media
     FOREIGN KEY (SeriesID)
-    REFERENCES Media (ContentID)
+    REFERENCES Media (ContentID) ON DELETE CASCADE ON UPDATE CASCADE
 );
 --------------------------------------------------
@@ -116 +116 @@
   CONSTRAINT fk_season_series
     FOREIGN KEY (SeriesSeriesID)
-    REFERENCES Series (SeriesID)
+    REFERENCES Series (SeriesID) ON DELETE CASCADE ON UPDATE CASCADE
 );
 --------------------------------------------------
@@ -135 +135 @@
   CONSTRAINT fk_episode_season
     FOREIGN KEY (SeasonSeasonID)
-    REFERENCES Season (SeasonID)
+    REFERENCES Season (SeasonID) ON DELETE CASCADE ON UPDATE CASCADE
 );
 
@@ -149 +149 @@
   CONSTRAINT fk_watchable_movie
     FOREIGN KEY (WatchableID)
-    REFERENCES Movie (MovieID),
+    REFERENCES Movie (MovieID) ON DELETE CASCADE ON UPDATE CASCADE,
 
   CONSTRAINT fk_watchable_episode
     FOREIGN KEY (WatchableID)
-    REFERENCES Episode (EpisodeID)
+    REFERENCES Episode (EpisodeID) ON DELETE CASCADE ON UPDATE CASCADE
 );
 
@@ -175 +175 @@
   CONSTRAINT fk_ca_content
     FOREIGN KEY (ContentContentID)
-    REFERENCES Media (ContentID),
+    REFERENCES Media (ContentID) ON DELETE CASCADE ON UPDATE CASCADE,
 
   CONSTRAINT fk_ca_artist
     FOREIGN KEY (ArtistArtistID)
-    REFERENCES Artist (ArtistID)
+    REFERENCES Artist (ArtistID) ON DELETE CASCADE ON UPDATE CASCADE
 );
 
@@ -196 +196 @@
   CONSTRAINT fk_cg_content
     FOREIGN KEY (ContentContentID)
-    REFERENCES Media (ContentID),
+    REFERENCES Media (ContentID) ON DELETE CASCADE ON UPDATE CASCADE,
 
   CONSTRAINT fk_cg_genre
     FOREIGN KEY (GenreGenreID)
-    REFERENCES Genre (GenreID)
+    REFERENCES Genre (GenreID) ON DELETE CASCADE ON UPDATE CASCADE
 );
 
@@ -217 +217 @@
   CONSTRAINT fk_cl_content
     FOREIGN KEY (ContentContentID)
-    REFERENCES Media (ContentID),
+    REFERENCES Media (ContentID)ON DELETE CASCADE ON UPDATE CASCADE,
 
   CONSTRAINT fk_cl_language
     FOREIGN KEY (LanguageLanguageID)
-    REFERENCES Language (LanguageID)
+    REFERENCES Language (LanguageID)ON DELETE CASCADE ON UPDATE CASCADE
 );
 
@@ -240 +240 @@
   CONSTRAINT fk_rating_user
     FOREIGN KEY (UserUserID)
-    REFERENCES "User" (UserID),
+    REFERENCES "User" (UserID) ON DELETE CASCADE ON UPDATE CASCADE,
 
   CONSTRAINT fk_rating_content
     FOREIGN KEY (ContentContentID)
-    REFERENCES Media (ContentID)
+    REFERENCES Media (ContentID) ON DELETE CASCADE ON UPDATE CASCADE
 );
 --------------------------------------------------
@@ -257 +257 @@
   CONSTRAINT fk_review_user
     FOREIGN KEY (UserUserID)
-    REFERENCES "User" (UserID),
+    REFERENCES "User" (UserID) ON DELETE CASCADE ON UPDATE CASCADE,
 
   CONSTRAINT fk_review_content
     FOREIGN KEY (ContentContentID)
-    REFERENCES Media (ContentID)
+    REFERENCES Media (ContentID) ON DELETE CASCADE ON UPDATE CASCADE
 );
 
@@ -274 +274 @@
   CONSTRAINT fk_device_subscription
     FOREIGN KEY (UserSubscriptionID)
-    REFERENCES User_Subscription (UserSubscriptionID)
+    REFERENCES User_Subscription (UserSubscriptionID) ON DELETE CASCADE ON UPDATE CASCADE
 );
 
@@ -292 +292 @@
   CONSTRAINT fk_wh_user
     FOREIGN KEY (UserUserID)
-    REFERENCES "User" (UserID),
+    REFERENCES "User" (UserID) ON DELETE CASCADE ON UPDATE CASCADE,
 
   CONSTRAINT fk_wh_content
     FOREIGN KEY (ContentContentID)
-    REFERENCES Media (ContentID),
+    REFERENCES Media (ContentID) ON DELETE CASCADE ON UPDATE CASCADE,
 
   CONSTRAINT fk_wh_watchable
     FOREIGN KEY (WatchableWatchableID)
-    REFERENCES Watchable (WatchableID),
+    REFERENCES Watchable (WatchableID) ON DELETE CASCADE ON UPDATE CASCADE,
 
   CONSTRAINT fk_wh_device
     FOREIGN KEY (DevicesDeviceID)
-    REFERENCES Devices (DeviceID)
+    REFERENCES Devices (DeviceID) ON DELETE CASCADE ON UPDATE CASCADE
 );
 --------------------------------------------------
@@ -317 +317 @@
   CONSTRAINT fk_wl_user
     FOREIGN KEY (UserUserID)
-    REFERENCES "User" (UserID),
+    REFERENCES "User" (UserID) ON DELETE CASCADE ON UPDATE CASCADE,
 
   CONSTRAINT fk_wl_content
     FOREIGN KEY (ContentContentID)
-    REFERENCES Media (ContentID),
+    REFERENCES Media (ContentID) ON DELETE CASCADE ON UPDATE CASCADE,
 
   CONSTRAINT fk_wl_watchable
     FOREIGN KEY (WatchableWatchableID)
-    REFERENCES Watchable (WatchableID)
+    REFERENCES Watchable (WatchableID) ON DELETE CASCADE ON UPDATE CASCADE
 );
 
@@ -337 +337 @@
   CONSTRAINT fk_ud_user
     FOREIGN KEY (UserUserID)
-    REFERENCES "User" (UserID),
+    REFERENCES "User" (UserID) ON DELETE CASCADE ON UPDATE CASCADE,
 
   CONSTRAINT fk_ud_device
     FOREIGN KEY (DevicesDeviceID)
-    REFERENCES Devices (DeviceID)
+    REFERENCES Devices (DeviceID) ON DELETE CASCADE ON UPDATE CASCADE
 );
 }}}