Projet

Général

Profil

US #1195 » add_author_column.sql

ahlem belgacem, 05/11/2025 10:52

 
1
ALTER TABLE salarymarket.company_reports
2
ADD COLUMN createdBy INT  NULL,
3
ADD CONSTRAINT fk_createdBy
4
    FOREIGN KEY (createdBy) REFERENCES salarymarket.company_users(id)
5
    ON DELETE CASCADE
6
    ON UPDATE CASCADE;
(3-3/3)