oscarfonts/mysql-workbench-to-postgres

CREATE INDEX is removed

Closed this issue · 0 comments

CREATE INDEX lines are removed without reason.

Sample code:

CREATE TABLE IF NOT EXISTS `walletkey` (
  `wk` VARCHAR(100) NOT NULL,
  `license_id` VARCHAR(100) NOT NULL,
  PRIMARY KEY (`wk`, `license_id`),
  CONSTRAINT `fk_WalletKeys_LicenseSubscription`
    FOREIGN KEY (`license_id`)
    REFERENCES `license_subscription` (`license_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

CREATE INDEX `fk_WalletKeys_LicenseSubscription_idx` ON `walletkey` (`license_id` ASC);