migration_user_id.sql 370 B

123456789101112
  1. BEGIN;
  2. ALTER TABLE "cpr" ADD COLUMN user_id UUID;
  3. ALTER TABLE "cpr" ADD CONSTRAINT fk_user
  4. FOREIGN KEY (user_id)
  5. REFERENCES "user"(user_id)
  6. ON DELETE RESTRICT;
  7. ALTER TABLE "cpr" ADD COLUMN company_id UUID;
  8. ALTER TABLE "cpr" ADD CONSTRAINT fk_company
  9. FOREIGN KEY (company_id)
  10. REFERENCES "company"(company_id)
  11. ON DELETE RESTRICT;
  12. COMMIT;