Post
by webycam » Thu 04 Sep 2014 15:19
I delete the tables and then created with schemacompare /sync
A double data type
CREATE TABLE qf.historico (
HST_ID int(11) NOT NULL AUTO_INCREMENT,
HST_CODISIN varchar(50) DEFAULT NULL,
HST_Fecha date NOT NULL,
HST_Cierre float(15, 6) DEFAULT NULL,
HST_CodVisualChart varchar(50) DEFAULT NULL,
PRIMARY KEY (HST_ID, HST_Fecha),
INDEX HST_CodISIN (HST_CODISIN),
INDEX HST_CodVisualChart (HST_CodVisualChart),
INDEX HST_Fecha (HST_Fecha),
INDEX `HST_ID,HST_Fecha` (HST_ID, HST_Fecha),
CONSTRAINT historico_ibfk_1 FOREIGN KEY (HST_CODISIN)
REFERENCES qf.fondos (FON_ISIN) ON DELETE CASCADE ON UPDATE CASCADE
)
ENGINE = INNODB
AUTO_INCREMENT = 60226834
AVG_ROW_LENGTH = 67
CHARACTER SET utf8
COLLATE utf8_general_ci;