Comments
Sort by recent activity
I am not sure if that matters, the offset and uses_appliance_table columns were added after the creation of the tables. IE, when I first run MySQL Compare 1 and MySQL Data Compare 1 on this table, these columns didn't exist. After the columns were added, I re-ran MySQL Compare 1 and it showed identical schema, but when I re-ran MySQL Data Compare 1, I cannot compare the new columns. / comments
I am not sure if that matters, the offset and uses_appliance_table columns were added after the creation of the tables. IE, when I first run MySQL Compare 1 and MySQL Data Compare 1 on this table, ...
Hi Neil,
This is what is being shown from MySQL Compare in both the left (v5.5 DB instance) and right (v5.1 DB instance) side of the screen, they are identical:
CREATE TABLE `ALERT_Engines` (
`id` int(11) unsigned NOT NULL auto_increment,
`name` varchar(256) NOT NULL,
`ALERT_Engines_Categories_id` int(11) NOT NULL,
`alert_title` text NOT NULL,
`alert_title_commercial` text NOT NULL,
`commercial_only` int(11) NOT NULL DEFAULT '0',
`alert_display` tinyint(4) NOT NULL,
`alert_display_order` int(11) NOT NULL,
`alert_description` text NOT NULL,
`alert_description_commercial` text NOT NULL,
`requires_channels` tinyint(4) NOT NULL DEFAULT 0,
`type` varchar(50) NOT NULL,
`admin` tinyint(1) NOT NULL,
`all_users` tinyint(4) NOT NULL DEFAULT 0,
`defaultstate` int(11) NOT NULL,
`sleeplength` int(10) NOT NULL,
`sendfrequency` int(10) NOT NULL,
`lurk` tinyint(1) NOT NULL,
`enabled` tinyint(4) NOT NULL DEFAULT 1,
`offset` int(3) NOT NULL DEFAULT '0' COMMENT 'in days',
`uses_appliance_table` tinyint(2) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 row_format=COMPACT AUTO_INCREMENT=27
From MySQL Data Compare, under the tables tab, in the row "ALERT_Engines" the right column "Columns in Comparison" has "19 of 23 columns". When I click it, there are four ! marks in yellow triangle, it looks like: Int offset !
TinyInt uses_appliance_table !
! offset Int
! uses_appliance_table TinyInt
j[/img] / comments
Hi Neil,
This is what is being shown from MySQL Compare in both the left (v5.5 DB instance) and right (v5.1 DB instance) side of the screen, they are identical:
CREATE TABLE `ALERT_Engines` (
`id` ...