MySQL create table

create table `table` (

	`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

	`date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

	`post_id` bigint(20) unsigned NOT NULL DEFAULT 0,

	`price` DECIMAL(10,4) null DEFAULT null,

	`desc` varchar(100) NOT NULL DEFAULT '',

	`content` longtext NOT NULL DEFAULT '',

	`binary_field` CHAR(1) DEFAULT '1' NOT NULL,

	PRIMARY KEY (`id`),

	UNIQUE KEY (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;