apache shiro database

来源：互联网发布：数据储存编辑：程序博客网时间：2024/05/19 06:49

mysql version:

CREATE TABLE `roles_permissions` (
`roleper` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`role_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`roleper`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=COMPACT
;

CREATE TABLE `users` (
`username` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`password` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`username`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=COMPACT
;

CREATE TABLE `user_roles` (
`role_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`username` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`role_name`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=COMPACT
;