|
|
|
ALTER TABLE vn.department
|
|
ADD COLUMN pbxQueue varchar(128) CHARACTER
|
|
SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL NULL;
|
|
|
|
ALTER TABLE vn.department
|
|
ADD CONSTRAINT department_queue_FK
|
|
FOREIGN KEY (pbxQueue) REFERENCES pbx.queue(name) ON DELETE RESTRICT ON UPDATE CASCADE;
|