+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;