This is the show create table statment from MySql Server 5.0.21 shell.
CREATE TABLE `percorso` (
`id` int(11) NOT NULL auto_increment,
`codice` int(3) NOT NULL default '0',
`coddesc` varchar(10) NOT NULL default '',
`id_orario` int(11) default NULL,
`descrizione` varchar(100) NOT NULL default '',
`kmlunghezza` decimal(7,3) NOT NULL default '0.000',
PRIMARY KEY (`id`),
KEY `codice` (`codice`),
KEY `id_orario` (`id_orario`),
CONSTRAINT `0_502` FOREIGN KEY (`id_orario`) REFERENCES `orario` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Decimal Data Type is show correctly.
This is the show create table statment from MySql Developper Tools version 2.00.49 from VS2005.
CREATE TABLE percorso (
id INT(11) AUTO_INCREMENT,
codice INT(3) NOT NULL DEFAULT 0,
coddesc VARCHAR(10) NOT NULL DEFAULT '',
id_orario INT(11) DEFAULT NULL,
descrizione VARCHAR(100) NOT NULL DEFAULT '',
kmlunghezza DECIMAL(7, 0) NOT NULL DEFAULT 0.000,
PRIMARY KEY (id),
INDEX codice USING BTREE (codice),
INDEX id_orario USING BTREE (id_orario),
CONSTRAINT `0_502` FOREIGN KEY (id_orario)
REFERENCES dbmicrotpl.orario(id)
)
ENGINE = INNODB
AUTO_INCREMENT = 3
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
Decimal Data Type is show not correctly.
This is a great problem for work whit this tool.
Thanks Massimo.