When update database from model, for MS SQL generated script include update code only for changed/added/droped table.
But for MySQL generate for all table. For unchanged table generate code, like this:
Code: Select all
--
-- Altering a table meterlimits
--
ALTER TABLE meterlimits
DROP FOREIGN KEY FK_MeterLimits_Meter,
DROP FOREIGN KEY FK_MeterLimits_RefWriteState,
DROP FOREIGN KEY FK_MeterLimits_Limit;
--
-- Altering a table meterlimits
--
ALTER TABLE meterlimits
DROP PRIMARY KEY,
CHANGE COLUMN MeterId MeterId INT(9) NOT NULL,
CHANGE COLUMN LimitId LimitId INT(9) NOT NULL,
CHANGE COLUMN WriteStateId WriteStateId INT(9) NOT NULL,
ADD CONSTRAINT FK_MeterLimits_Meter FOREIGN KEY (MeterId) REFERENCES Meters (MeterId) ON DELETE CASCADE,
ADD CONSTRAINT FK_MeterLimits_RefWriteState FOREIGN KEY (WriteStateId) REFERENCES RefWriteStates (WriteStateId) ON DELETE CASCADE,
ADD CONSTRAINT FK_MeterLimits_Limit FOREIGN KEY (LimitId) REFERENCES Limits (LimitId) ON DELETE CASCADE,
ADD PRIMARY KEY (MeterId, LimitId);
Delete all foreign key and alter table. But this table don`t change.
Please fix it.
