9 lines
293 B
MySQL
9 lines
293 B
MySQL
|
|
||
|
|
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;
|