12 lines
469 B
SQL
12 lines
469 B
SQL
CREATE TABLE users (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
token VARCHAR(255) NOT NULL,
|
|
username VARCHAR(50) NOT NULL UNIQUE,
|
|
password_hash VARCHAR(255) NOT NULL,
|
|
perms VARCHAR(255) NOT NULL
|
|
);
|
|
|
|
-- Test user with admin permissions
|
|
INSERT INTO users (token, username, password_hash, perms)
|
|
VALUES ('be01e88cc202593292d503e4ed9e51e9eb217093662efbb145030ba51b97c22a','admin', 'ecd71870d1963316a97e3ac3408c9835ad8cf0f3c1bc703527c30265534f75ae', 'admin');
|