Problemas com mysql migration tool

0 respostas
dicabeca

pessoal estou tendo um problema estou migrando uma base no oracle 9i para o mysql,e estou usando a ferramenta migration tool da propia mysql,estou tendo um problema em criar uma tabela,a versao do migration é 1.1.12 e o mysql ja tentei no 6.0 e 5.0 ambos o mesmo erro,gostaria de saber oq esta errado nessa sintax,ja quem gera e a propia ferramenta ?

o codigo q ele gera e esse:

DROP TABLE IF EXISTS `cferc`.`inp_str_group_db`;
CREATE TABLE `cferc`.`inp_str_group_db` (
  `oid` DECIMAL(20, 0) NOT NULL,
  `name` VARCHAR(22) BINARY NOT NULL,
  `description` VARCHAR(280) BINARY NULL,
  `type` BIGINT(10) NULL,
  `crossing` BIGINT(10) NULL DEFAULT 0,
  `inp_surf_oid` DECIMAL(20, 0) NULL,
  `eezone_ee_oid` DECIMAL(20, 0) NULL,
  `master_oid` DECIMAL(20, 0) NULL,
  `category` BIGINT(10) NULL DEFAULT 0,
  `wnd_u_min` DECIMAL(10, 4) NULL DEFAULT (0.0),
  `wnd_v_min` DECIMAL(10, 4) NULL DEFAULT (0.0),
  `wnd_u_max` DECIMAL(10, 4) NULL DEFAULT (-1.0),
  `wnd_v_max` DECIMAL(10, 4) NULL DEFAULT (-1.0),
  `wnd_x_min` DECIMAL(10, 4) NULL,
  `wnd_y_min` DECIMAL(10, 4) NULL,
  `wnd_z_min` DECIMAL(10, 4) NULL,
  `wnd_x_max` DECIMAL(10, 4) NULL,
  `wnd_y_max` DECIMAL(10, 4) NULL,
  `wnd_z_max` DECIMAL(10, 4) NULL,
  PRIMARY KEY (`oid`),
  INDEX `inpstrgroupdb_ee_index` (`eezone_ee_oid`),
  INDEX `inpstrgroupdb_master_index` (`master_oid`),
  INDEX `inpstrgroupdb_surf_index` (`inp_surf_oid`),
  UNIQUE INDEX `uk_str_grp_name` (`name`(22)),
  CONSTRAINT `fk_inpstrgroupdb_ee_oid` FOREIGN KEY `fk_inpstrgroupdb_ee_oid` (`eezone_ee_oid`)
    REFERENCES `cferc`.`inp_str_group_db` (`oid`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_inpstrgroupdb_master_oid` FOREIGN KEY `fk_inpstrgroupdb_master_oid` (`master_oid`)
    REFERENCES `cferc`.`inp_str_group_db` (`oid`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_inpstrgroupdb_surf_oid` FOREIGN KEY `fk_inpstrgroupdb_surf_oid` (`inp_surf_oid`)
    REFERENCES `cferc`.`inp_surface_db` (`oid`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION
)
ENGINE = INNODB;

e o erro q ele da é esse :

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(0.0),
  `wnd_v_min` DECIMAL(10, 4) NULL DEFAULT (0.0),
  `wnd_u_max` DECIMAL(' at line 11
Criado 15 de abril de 2008
Respostas 0
Participantes 1