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
;