• Home
• io.vertx
• vertx-auth-sql-client
• 5.0.0.CR3
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

x-auth-sql-client.5.0.0.CR3.source-code.sql-auth-ddl.sql Maven / Gradle / Ivy

CREATE TABLE `users`
(
  `username` VARCHAR(255) NOT NULL,
  `password` VARCHAR(255) NOT NULL
);

CREATE TABLE `users_roles`
(
  `username` VARCHAR(255) NOT NULL,
  `role`     VARCHAR(255) NOT NULL
);

CREATE TABLE `roles_perms`
(
  `role` VARCHAR(255) NOT NULL,
  `perm` VARCHAR(255) NOT NULL
);

ALTER TABLE users
  ADD CONSTRAINT `pk_username` PRIMARY KEY (username);
ALTER TABLE users_roles
  ADD CONSTRAINT `pk_users_roles` PRIMARY KEY (username, role);
ALTER TABLE roles_perms
  ADD CONSTRAINT `pk_roles_perms` PRIMARY KEY (role, perm);

ALTER TABLE users_roles
  ADD CONSTRAINT fk_username FOREIGN KEY (username) REFERENCES users (username);