CREATE TABLE province ( id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(50) NOT NULL, code VARCHAR(10) NOT NULL, status TINYINT(1) DEFAULT ‘1’ NOT NULL, PRIMARY KEY (id) );
CREATE TABLE city ( id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(50) NOT NULL, code VARCHAR(10) NOT NULL, province_id INT(11) NOT NULL, status TINYINT(1) DEFAULT ‘1’ NOT NULL, PRIMARY KEY (id), FOREIGN KEY (province_id) REFERENCES province(id) );
CREATE TABLE district ( id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(50) NOT NULL, code VARCHAR(10) NOT NULL, city_id INT(11) NOT NULL, status TINYINT(1) DEFAULT ‘1’ NOT NULL, PRIMARY KEY (id), FOREIGN KEY (city_id) REFERENCES city(id) );
![http://mirrors.163.com/centos/7/os/x86_64/repodata/repomd.xml: [Errno 14] HTTP Error 500 - Internal Server Error
Trying other mirror.](https://linuxcpp.0voice.com/zb_users/upload/2023/05/202305162230567920271.png)
