I've been able to duplicate this under MySQL 5.5 and 5.6 when STRICT_ALL_TABLES is enabled in MySQL (Windows and Linux). The binary compilations (from Oracle) do not enable this mode by default (according to the documentation).
When not enabled, MySQL 5.5 and 5.6 appear to just create the column as if no default was specified. "SHOW CREATE TABLE `admin_activity_log`" shows the following after creation without STRICT_ALL_TABLES enabled:
Code:
CREATE TABLE `admin_activity_log` (
`log_id` bigint(15) NOT NULL AUTO_INCREMENT,
`access_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`admin_id` int(11) NOT NULL DEFAULT '0',
`page_accessed` varchar(80) NOT NULL DEFAULT '',
`page_parameters` text,
`ip_address` varchar(45) NOT NULL DEFAULT '',
`flagged` tinyint(4) NOT NULL DEFAULT '0',
`attention` varchar(255) NOT NULL DEFAULT '',
`gzpost` mediumblob,
`logmessage` mediumtext NOT NULL,
`severity` varchar(9) NOT NULL DEFAULT 'info',
PRIMARY KEY (`log_id`),
KEY `idx_page_accessed_zen` (`page_accessed`),
KEY `idx_access_date_zen` (`access_date`),
KEY `idx_flagged_zen` (`flagged`),
KEY `idx_ip_zen` (`ip_address`),
KEY `idx_severity_zen` (`severity`)
) ENGINE=MyISAM
NOTE: COLLATE, CHARSET, and the current AUTO_INCREMENT values were removed from the above table structure dump.
Bookmarks