SHOW CREATE TABLE stay_signed_in
... I get back the correct code for my table:
CREATE TABLE `stay_signed_in` (
`id_stay_signed_in` int(11) unsigned NOT NULL auto_increment,
`code` char(32) collate utf8_spanish2_ci NOT NULL COMMENT 'Código único que identifica el acceso guardado',
`id_user` int(11) NOT NULL,
`ipv4` int(10) unsigned NOT NULL COMMENT 'Dirección IP desde la que se ha generado la sesión',
`user_agent` varchar(500) collate utf8_spanish2_ci default NULL COMMENT 'Encabezado User-Agent',
`crt_user` varchar(10) collate utf8_spanish2_ci NOT NULL,
`crt_date` datetime NOT NULL,
`crt_process` varchar(255) collate utf8_spanish2_ci NOT NULL,
`upd_date` datetime default NULL,
`upd_process` varchar(255) collate utf8_spanish2_ci default NULL,
PRIMARY KEY (`id_stay_signed_in`),
UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci
However, the table editor looks like this:
Link to full size: http://img844.imageshack.us/img844/215/heidisqlcommentcommentc.png
See that the column comments are copied to all columns.
The "CREATE code" tab shows this:
CREATE TABLE `stay_signed_in` (
`id_stay_signed_in` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`code` CHAR(32) NOT NULL COMMENT 'Código único que identifica el acceso guardado' COLLATE 'utf8_spanish2_ci',
`id_user` INT(11) NOT NULL COMMENT 'Código único que identifica el acceso guardado',
`ipv4` INT(10) UNSIGNED NOT NULL COMMENT 'Dirección IP desde la que se ha generado la sesión',
`user_agent` VARCHAR(500) NULL DEFAULT NULL COMMENT 'Encabezado User-Agent' COLLATE 'utf8_spanish2_ci',
`crt_user` VARCHAR(10) NOT NULL COMMENT 'Encabezado User-Agent' COLLATE 'utf8_spanish2_ci',
`crt_date` DATETIME NOT NULL COMMENT 'Encabezado User-Agent',
`crt_process` VARCHAR(255) NOT NULL COMMENT 'Encabezado User-Agent' COLLATE 'utf8_spanish2_ci',
`upd_date` DATETIME NULL DEFAULT NULL COMMENT 'Encabezado User-Agent',
`upd_process` VARCHAR(255) NULL DEFAULT NULL COMMENT 'Encabezado User-Agent' COLLATE 'utf8_spanish2_ci',
PRIMARY KEY (`id_stay_signed_in`),
UNIQUE INDEX `code` (`code`)
)
COLLATE='utf8_spanish2_ci'
ENGINE=InnoDB;
It must be an error in the parser routines. This was working fine the other day.