6 lines
321 B
MySQL
6 lines
321 B
MySQL
|
USE vn;
|
||
|
|
ALTER TABLE vn.invoiceOutTaxConfig MODIFY COLUMN expenseFk varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL NULL;
|
||
|
|
|
||
|
|
ALTER TABLE vn.invoiceOutTaxConfig
|
||
|
|
ADD CONSTRAINT invoiceOutTaxConfig_expense_FK FOREIGN KEY (expenseFk) REFERENCES vn.expense(id) ON DELETE RESTRICT ON UPDATE CASCADE;
|