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