急求解数据库模型图中这两个箭头表示什么意思? 贴出箭头2和3包括的三个表的建表语句show create table XX 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 箭头2:CREATE TABLE `authority` ( `AUTHORITY_ID` bigint(20) NOT NULL AUTO_INCREMENT, `OBJ_VERSION` int(11) NOT NULL, `USER_ID` bigint(20) NOT NULL, `ROLE` varchar(32) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`AUTHORITY_ID`), UNIQUE KEY `USER_ID` (`USER_ID`,`ROLE`), KEY `ALLAUTHORITIES` (`USER_ID`), CONSTRAINT `ALLAUTHORITIES` FOREIGN KEY (`USER_ID`) REFERENCES `user` (`USER_ID`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE `user` ( `USER_ID` bigint(20) NOT NULL AUTO_INCREMENT, `OBJ_VERSION` int(11) NOT NULL, `NAME` varchar(50) COLLATE utf8_bin NOT NULL, `PASSWORD` varchar(50) COLLATE utf8_bin NOT NULL, `GROUP_ID` bigint(20) NOT NULL, `EMAIL` varchar(64) COLLATE utf8_bin NOT NULL, `LOCKED` bit(1) NOT NULL, `ENABLED` bit(1) NOT NULL, `EXPIRATION` datetime NOT NULL, PRIMARY KEY (`USER_ID`), UNIQUE KEY `NAME` (`NAME`), KEY `ALLUSERS` (`GROUP_ID`), CONSTRAINT `ALLUSERS` FOREIGN KEY (`GROUP_ID`) REFERENCES `m_group` (`GROUP_ID`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE `m_group` ( `GROUP_ID` bigint(20) NOT NULL AUTO_INCREMENT, `OBJ_VERSION` int(11) NOT NULL, `NAME` varchar(50) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`GROUP_ID`), UNIQUE KEY `NAME` (`NAME`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 两条sql語句, 有什么不同 mysql的中文噩梦 MYSQL 配置问题<急>!!! 求一句查询语句,我想了半天想不出来,都失眠了? 求教一个 想了几天的问题 谢谢 请问在win2000下如何启动mysql? mysql的一个奇怪的表插入问题 按月统计的sql的写法问题 求助!修改了tmpdir的问题 mysql 多字段多关键词根据匹配度排序查找,2千万数据。如何优化sql mysql存储过程异常问题 MySQL 递归查询
CREATE TABLE `authority` (
`AUTHORITY_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`OBJ_VERSION` int(11) NOT NULL,
`USER_ID` bigint(20) NOT NULL,
`ROLE` varchar(32) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`AUTHORITY_ID`),
UNIQUE KEY `USER_ID` (`USER_ID`,`ROLE`),
KEY `ALLAUTHORITIES` (`USER_ID`),
CONSTRAINT `ALLAUTHORITIES` FOREIGN KEY (`USER_ID`) REFERENCES `user` (`USER_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE `user` (
`USER_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`OBJ_VERSION` int(11) NOT NULL,
`NAME` varchar(50) COLLATE utf8_bin NOT NULL,
`PASSWORD` varchar(50) COLLATE utf8_bin NOT NULL,
`GROUP_ID` bigint(20) NOT NULL,
`EMAIL` varchar(64) COLLATE utf8_bin NOT NULL,
`LOCKED` bit(1) NOT NULL,
`ENABLED` bit(1) NOT NULL,
`EXPIRATION` datetime NOT NULL,
PRIMARY KEY (`USER_ID`),
UNIQUE KEY `NAME` (`NAME`),
KEY `ALLUSERS` (`GROUP_ID`),
CONSTRAINT `ALLUSERS` FOREIGN KEY (`GROUP_ID`) REFERENCES `m_group` (`GROUP_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE `m_group` (
`GROUP_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`OBJ_VERSION` int(11) NOT NULL,
`NAME` varchar(50) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`GROUP_ID`),
UNIQUE KEY `NAME` (`NAME`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;