migration_user_id.sql 409 B

123456789101112131415
  1. BEGIN;
  2. ALTER TABLE "cpr"
  3. ADD COLUMN user_id INTEGER,
  4. ADD COLUMN company_id INTEGER;
  5. ALTER TABLE "cpr"
  6. ADD CONSTRAINT fk_cpr_user
  7. FOREIGN KEY (user_id)
  8. REFERENCES "user"(user_id)
  9. ON DELETE RESTRICT;
  10. ALTER TABLE "cpr"
  11. ADD CONSTRAINT fk_cpr_company
  12. FOREIGN KEY (company_id)
  13. REFERENCES "company"(company_id)
  14. ON DELETE RESTRICT;
  15. COMMIT;