Reka bentuk pangkalan data

1, Reka bentuk pangkalan data

BUAT JADUAL `global_region` (

`region_id` smallint(5) unsigned NOT NULL AUTO_INNCREMENT,`unsigned

NULL lalai '0 ',

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

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

KEY `parent_id` (`parent_id`),

KEY `region_type` (`region_type`)

) ENJIN=MyISAM DEFAULT CHARSET=utf8;

Masukkan data:

Pautan: https://pan.baidu.com/s/10P2ueF8JpJ5v2W4HsJtfWQ Kata Laluan: 5q7i