web-profile

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;

Leave a Reply

Your email address will not be published.