CREATE TABLE `bin_cnarea` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`area_code` CHAR(12) NOT NULL DEFAULT '' COMMENT '区域代码' COLLATE 'utf8_bin',
	`level` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '层级，从0开始',
	`father` CHAR(12) NOT NULL DEFAULT '' COMMENT '父级区域代码' COLLATE 'utf8_bin',
	`name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '区域名称' COLLATE 'utf8_bin',
	`short_name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '简称' COLLATE 'utf8_bin',
	PRIMARY KEY (`id`),
	UNIQUE INDEX `area_code` (`area_code`),
	INDEX `father` (`father`)
)
COMMENT='Binbin **行政区域表'
COLLATE='utf8_bin'
ENGINE=InnoDB
;