57,062
社区成员
发帖
与我相关
我的任务
分享
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;