CREATE TABLE users (
    id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
    username VARBINARY(50),
    digesta1 VARBINARY(32),
    UNIQUE(username)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO users (username,digesta1) VALUES
('admin','bedc285069d7535a63d1b708211c1e46');

INSERT INTO users (username,digesta1) VALUES
('forrest','f78c2ee82615b636dd6ca7015f9c1e73');

INSERT INTO users (username,digesta1) VALUES
('lee','d4ae82f6d178c1a58016182e2fec8c48');

INSERT INTO users (username,digesta1) VALUES
('elaine','5d5a91a3b979e671f2502a2a2d271657');
