字段	类型	长度	备注
p_id	int	10	p_id(主键自增)
p_name	varchar	15	省份名称
p_nationid	int	10	所属国家id(外键)

DROP TABLE IF EXISTS `province`;
CREATE TABLE `province` (
  `p_id` int(10) NOT NULL AUTO_INCREMENT,
  `p_name` varchar(15) COLLATE utf8_bin NOT NULL DEFAULT '',
  `p_nationid` int(10) NOT NULL,
  PRIMARY KEY (`p_id`),
  KEY `p_nationid` (`p_nationid`),
  CONSTRAINT `p_nationid` FOREIGN KEY (`p_nationid`) REFERENCES `nation` (`n_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;