CREATE TABLE `t_city_section` (
`cityquid` mediumint(8) NOT NULL auto_increment,
`cityquname` varchar(20) NOT NULL default '',
`cityid` mediumint(8) NOT NULL default '0',
`flag` tinyint(4) default '2',
PRIMARY KEY (`cityquid`)
) ENGINE=InnoDB AUTO_INCREMENT=2793 DEFAULT CHARSET=utf8
CREATE TABLE `t_university` (
`universityid` mediumint(8) NOT NULL auto_increment,
`universityname` varchar(20) NOT NULL default '',
`provinceid` tinyint(4) NOT NULL default '0',
`oriuniversityid` mediumint(8) NOT NULL default '0',
`note` varchar(20) default NULL,
PRIMARY KEY (`universityid`)
) ENGINE=InnoDB AUTO_INCREMENT=2552 DEFAULT CHARSET=utf8
CREATE TABLE `t_department` (
`departmentid` mediumint(8) NOT NULL auto_increment,
`departmentname` varchar(20) NOT NULL default '',
`oriuniversityid` mediumint(8) NOT NULL default '0',
`note` varchar(20) default NULL,
PRIMARY KEY (`departmentid`),
KEY `oriuniversityid` (`oriuniversityid`)
) ENGINE=InnoDB AUTO_INCREMENT=31293 DEFAULT CHARSET=utf8
相关资源：全国省份城市地区完整数据库
