0sk9CPU2

1CREATE USER IF NOT EXISTS 'testUser'@'localhost';
2SET PASSWORD FOR 'testUser'@'localhost' = PASSWORD('test123');
3CREATE DATABASE IF NOT EXISTS portal;
4GRANT ALL PRIVILEGES ON portal.* TO 'testUser'@'localhost' WITH GRANT OPTION;
5USE portal;
6DROP TABLE IF EXISTS users;
7CREATE TABLE users(
8    id INT NOT NULL AUTO_INCREMENT,
9    name VARCHAR(255),
10    password VARCHAR(255),
11    email VARCHAR(255),
12    PRIMARY KEY(id)
13);
14INSERT INTO users (name, password, email) VALUES ('drake', '123456', 'drake@test.com');
15INSERT INTO users (name, password, email) VALUES ('tester', 'test123', 'tester@test.com');
16INSERT INTO users (name, password, email) VALUES ('pentester', 'test456', 'pentester@test.com');
17INSERT INTO users (name, password, email) VALUES ('admin', 'trudne_do_odgadniecia_haslo1234567890', 'admin@test.com');