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