8 lines
406 B
MySQL
8 lines
406 B
MySQL
|
-- Place your SQL code here
|
||
|
|
ALTER TABLE `vn`.`ticketRequest`
|
||
|
|
CHANGE IF EXISTS `buyerCode` `buyerCode__` varchar(3) NOT NULL COMMENT '@deprecated 2024-04-23 refs #6731 field not used';
|
||
|
|
|
||
|
|
ALTER TABLE `vn`.`ticketConfig` ADD COLUMN IF NOT EXISTS `defaultAttenderFk` int unsigned;
|
||
|
|
|
||
|
|
ALTER TABLE vn.ticketConfig ADD CONSTRAINT ticketConfig_worker_FK FOREIGN KEY (defaultAttenderFk) REFERENCES vn.worker(id);
|