create tables users and admins

SET NAMES utf8;
SET
CHARACTER SET utf8;
SET
character_set_client = utf8;
SET
character_set_connection = utf8;
SET
character_set_results = utf8;

USE
scareme;

CREATE TABLE users
(
    id          INT PRIMARY KEY AUTO_INCREMENT,
    login        VARCHAR(16),
    passHash        VARCHAR(32)
);

INSERT INTO users (login, passHash) VALUES ("admin", "21232f297a57a5a743894a0e4a801fc3"), ("user", "ee11cbb19052e40b07aac0ca060c23ee");

CREATE TABLE admins
(
    user_id INT NOT NULL REFERENCES users (id)
);

INSERT INTO admins (user_id) VALUES (1);