diff options
Diffstat (limited to 'labs/2/run.sql')
| -rw-r--r-- | labs/2/run.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/labs/2/run.sql b/labs/2/run.sql index 1a501bc..0b3f09c 100644 --- a/labs/2/run.sql +++ b/labs/2/run.sql @@ -11,7 +11,6 @@ CREATE TABLE employees ( dno integer ); - DROP TABLE IF EXISTS departments CASCADE; CREATE TABLE departments ( dname varchar(255), @@ -59,4 +58,5 @@ INSERT INTO locations VALUES (12, 'Montreal'); ALTER TABLE departments ADD CONSTRAINT employees_fk FOREIGN KEY (mgrsin) REFERENCES employees (sin); ALTER TABLE employees ADD CONSTRAINT departments_fk FOREIGN KEY (dno) REFERENCES departments (dnumber); +ALTER TABLE locations ADD CONSTRAINT departments_fk FOREIGN KEY (dnbr) REFERENCES departments(dnumber); ALTER TABLE projects ADD CONSTRAINT departments_fk FOREIGN KEY (dnum) REFERENCES departments (dnumber); |