Changes between Version 11 and Version 12 of DatabaseCreation


Ignore:
Timestamp:
06/16/26 11:53:24 (45 hours ago)
Author:
231166
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DatabaseCreation

    v11 v12  
    1212#!sql
    1313CREATE TABLE User (
    14   UserID SERIAL PRIMARY KEY,
     14  UserID SERIAL PRIMARY KEY DEFALUT -1,
    1515  FirstName varchar(255),
    1616  LastName varchar(255),
    … …  
    240240  CONSTRAINT fk_rating_user
    241241    FOREIGN KEY (UserUserID)
    242     REFERENCES "User" (UserID) ON DELETE CASCADE ON UPDATE CASCADE,
     242    REFERENCES "User" (UserID) ON DELETE SET DEFAULT ON UPDATE CASCADE,
    243243
    244244  CONSTRAINT fk_rating_content
    … …  
    257257  CONSTRAINT fk_review_user
    258258    FOREIGN KEY (UserUserID)
    259     REFERENCES "User" (UserID) ON DELETE CASCADE ON UPDATE CASCADE,
     259    REFERENCES "User" (UserID) ON DELETE SET DEFAULT ON UPDATE CASCADE,
    260260
    261261  CONSTRAINT fk_review_content
    … …  
    292292  CONSTRAINT fk_wh_user
    293293    FOREIGN KEY (UserUserID)
    294     REFERENCES "User" (UserID) ON DELETE CASCADE ON UPDATE CASCADE,
     294    REFERENCES "User" (UserID) ON DELETE SET DEFAULT ON UPDATE CASCADE,
    295295
    296296  CONSTRAINT fk_wh_content
    … …  
    317317  CONSTRAINT fk_wl_user
    318318    FOREIGN KEY (UserUserID)
    319     REFERENCES "User" (UserID) ON DELETE CASCADE ON UPDATE CASCADE,
     319    REFERENCES "User" (UserID) ON DELETE SET DEFAULT ON UPDATE CASCADE,
    320320
    321321  CONSTRAINT fk_wl_content