+CREATE TABLE `mytable` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `flag` tinyint(4) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `date` (`date`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+