Hi,
I was comparing the schema of two MySQL 5.5 databases using
Toad for MySQL 6.4.0.642 and it seems the DDL script generated is not
complete.
Example:
With MySQL Workbench 5.2.44 CE, I get the following CREATE
script for the table:
CREATE
TABLE `georevenue` (
`Stamp` datetime NOT NULL COMMENT 'Date',
`CampaignID` int(11) NOT NULL DEFAULT '0',
`Country` varchar(100) NOT NULL DEFAULT '',
`Region` varchar(100) NOT NULL DEFAULT '',
`City` varchar(100) NOT NULL DEFAULT '',
<other columns and indexes
suppressed to make the example shorter >
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Geo Revenue By Hour';
But using Toad for MySQL, I get:
CREATE TABLE
`acuityads_dev`.`georevenue` (
`Stamp` datetime
NOT NULL,
`CampaignID` int(11) NOT NULL DEFAULT '0',
`Country` varchar(100) NOT NULL,
`Region` varchar(100) NOT NULL,
`City` varchar(100) NOT NULL,
<other columns and indexes
suppressed to make the example shorter >
)
ENGINE = InnoDB
CHARACTER SET = utf8
ROW_FORMAT = COMPACT
COMMENT = 'Geo Revenue By Hour';
Why is the DEFAULT '' missing in Toad? (By the way, why is the first
column?s comment missing, too?)
Thank you,
Marcio
