Mine

CREATE TABLE `samosa_elections` (\n  `election_id` mediumint(8) unsigned NOT NULL auto_increment,\n  `description` varchar(255) NOT NULL,\n  `private` tinyint(1) NOT NULL default '0',\n  `open` tinyint(1) NOT NULL default '1',\n  `creation_date` datetime NOT NULL,\n  PRIMARY KEY  (`election_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8