mahendrabagul/neova-base-project

Java Technology Base Project with multiple technologies integrated

Configurations

1. Create database 'neova'

2. Create tables as:

   CREATE TABLE roles (
   id int(6) NOT NULL AUTO_INCREMENT,
   role varchar(20) NOT NULL,
   PRIMARY KEY (id)
   ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

   CREATE TABLE users (
   id int(6) NOT NULL AUTO_INCREMENT,
   login varchar(20) NOT NULL,
   password varchar(20) NOT NULL,
   PRIMARY KEY (id)
   ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

   CREATE TABLE user_roles (
   user_id int(6) NOT NULL,
   role_id int(6) NOT NULL,
   KEY user (user_id),
   KEY role (role_id)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

3. Insert sample data as:

INSERT INTO neova.roles (role) VALUES ('admin'), ('moderator');

INSERT INTO neova.users (login, password) VALUES ('user', 'user'), ('admin', 'admin');

INSERT INTO neova.user_roles (user_id, role_id) VALUES (1, 2), (2, 1);