CREATE TABLE `REGION` (
`id` int(11) NOT NULL auto_increment,
`regionid` varchar(32) NOT NULL COMMENT '区域ID',
`regionname` varchar(32) DEFAULT NULL COMMENT '区域名称',
`pregionid` varchar(32) DEFAULT NULL COMMENT '上级区域ID ',
`orgid` varchar(32) DEFAULT NULL COMMENT '上级组织机构ID ',
PRIMARY KEY (`id`),
foreign key(`orgid`) references zzjg(`orgid`) on delete cascade on update cascade
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='区域表';
=========================
参考:http://hi.baidu.com/jsjok/blog/item/7699668deb954bf4f11f3642.html