diff options
| author | mo khan <mo.khan@gmail.com> | 2020-01-01 11:59:07 -0700 |
|---|---|---|
| committer | mo khan <mo.khan@gmail.com> | 2020-01-01 11:59:07 -0700 |
| commit | 46b6e13bd230a0fcbd167cdfdc47c5c7d2d3755c (patch) | |
| tree | 144868749e2870240ddcf95e7ca21ac1feba979e /labs/2/run.sql | |
| parent | a4fe01d592aafa73a04284a085a4e52da66b787e (diff) | |
Add foreign key from locations to departments
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); |