salix/db/versions/.archive/10482-blueMastic/00-firstScript.sql

5 lines
285 B
SQL

CREATE INDEX ekt_sub_IDX USING BTREE ON edi.ekt (sub);
CREATE INDEX buy_itemFk_IDX USING BTREE ON vn.buy (itemFk);
ALTER TABLE edi.ekt MODIFY COLUMN putOrderFk bigint(20) DEFAULT NULL NULL COMMENT 'RFF+ON';
ALTER TABLE edi.putOrder MODIFY COLUMN id bigint(20) auto_increment NOT NULL;