CREATE TABLE IF NOT EXISTS `nation` ( `id` int(11) NOT NULL AUTO_INCREMENT, `code` varchar(40) NOT NULL, `province` varchar(40) NOT NULL, `city` varchar(40) NOT NULL, `district` varchar(40) NOT NULL, `parent` varchar(40) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf