salix/db/versions/10789-whiteSalal/00-firstScript.sql

6 lines
327 B
MySQL
Raw Permalink Normal View History

-- Place your SQL code here
ALTER TABLE vn.productionConfig ADD clientSelfConsumptionFk int(11) NULL COMMENT 'Cliente para crear el ticket de autoconsumo';
ALTER TABLE vn.productionConfig ADD CONSTRAINT productionConfig_FK_1 FOREIGN KEY (clientSelfConsumptionFk) REFERENCES vn.client(id) ON DELETE CASCADE ON UPDATE CASCADE;