Changes between Version 2 and Version 3 of ddlScript.sql

Timestamp:

01/20/25 18:27:25 (10 days ago)

Author:

221028

Comment:

--

ddlScript.sql

@@ -5 +5 @@
 DROP TABLE IF EXISTS Elements CASCADE;
 DROP TABLE IF EXISTS LabEquipment CASCADE;
-DROP TABLE IF EXISTS USER CASCADE;
+DROP TABLE IF EXISTS "User" CASCADE;
 
 
-CREATE TABLE USER (
+CREATE TABLE "User" (
     user_id SERIAL PRIMARY KEY,
     user_name VARCHAR(30) NOT NULL,
@@ -50 +50 @@
 CREATE TABLE Experiment (
     experiment_id SERIAL PRIMARY KEY,
-    user_id INT NOT NULL REFERENCES USER (user_id) ON DELETE CASCADE,
+    user_id INT NOT NULL REFERENCES "User" (user_id) ON DELETE CASCADE,
     reaction_id INT NOT NULL REFERENCES Reaction(reaction_id) ON DELETE CASCADE,
     result TEXT,