Projet

Général

Profil

US #1198 » add_author_column.sql

ahlem belgacem, 05/11/2025 15:03

 
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;
7
    
8
ALTER TABLE company_reports
9
ADD COLUMN createdFrom ENUM('admin', 'client') 
10
DEFAULT 'admin' NOT NULL;
    (1-1/1)