1,數(shù)據(jù)庫設(shè)計

CREATE TABLE `global_region` (

? `region_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,

? `parent_id` smallint(5) unsigned NOT NULL DEFAULT '0',

? `region_name` varchar(120) NOT NULL DEFAULT '',

? `region_type` tinyint(1) NOT NULL DEFAULT '2',

? PRIMARY KEY (`region_id`),

? KEY `parent_id` (`parent_id`),

? KEY `region_type` (`region_type`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

數(shù)據(jù)表如下所示:

插入數(shù)據(jù):

鏈接：https://pan.baidu.com/s/10P2ueF8JpJ5v2W4HsJtfWQ 密碼：5q7i

下載執(zhí)行即可