SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for dict_area
-- ----------------------------
DROP TABLE IF EXISTS `dict_area`;
CREATE TABLE `dict_area` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`area_id` int(10) unsigned NOT NULL DEFAULT ‘0‘,
`name` char(24) NOT NULL DEFAULT ‘‘,
`name_en` char(32) NOT NULL DEFAULT ‘‘,
`letter` char(2) NOT NULL DEFAULT ‘‘,
`parent_id` int(10) unsigned NOT NULL DEFAULT ‘0‘,
`level` tinyint(1) unsigned NOT NULL DEFAULT ‘0‘,
`sequence` smallint(5) unsigned NOT NULL DEFAULT ‘0‘ COMMENT ‘排序‘,
PRIMARY KEY (`id`),
KEY `area_id` (`area_id`) USING BTREE,
KEY `parent_id` (`parent_id`) USING BTREE,
KEY `letter` (`letter`) USING BTREE,
KEY `level` (`level`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3519 DEFAULT CHARSET=utf8 COMMENT=‘地区字典表‘;
原文：http://jinliang.blog.51cto.com/8981814/1877890