salix/db/versions/.archive/10579-aquaRoebelini/00-firstScript.sql

4 lines
194 B
MySQL
Raw Permalink Normal View History

-- Place your SQL code here
ALTER TABLE vn.farming ADD companyFk smallint(5) unsigned NULL;
ALTER TABLE vn.farming ADD CONSTRAINT farming_FK_1 FOREIGN KEY (companyFk) REFERENCES vn.company(id);