8 lines
418 B
SQL
8 lines
418 B
SQL
|
|
ALTER TABLE `users` ADD COLUMN `department` VARCHAR(255) NULL;
|
|
|
|
ALTER TABLE `ChangeRequests`
|
|
ADD COLUMN `approval_level_pending` ENUM('Dept Manager/GM', 'System Div Admin', 'Planning Dept', 'System GM', 'None') DEFAULT 'Dept Manager/GM',
|
|
ADD COLUMN `rejection_reason` TEXT NULL,
|
|
MODIFY COLUMN `status` ENUM('Draft', 'Pending Approval', 'Approved', 'Rejected', 'In Progress', 'Completed') DEFAULT 'Draft';
|