US #1198 » add_author_column.sql
| 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; |