19 lines
370 B
MySQL
19 lines
370 B
MySQL
|
PRAGMA foreign_keys=OFF;
|
||
|
|
BEGIN TRANSACTION;
|
||
|
|
|
||
|
|
CREATE TABLE users (
|
||
|
|
username text not null,
|
||
|
|
passwordHash text not null
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE sessions (
|
||
|
|
token text not null,
|
||
|
|
userId int not null,
|
||
|
|
username text not null
|
||
|
|
);
|
||
|
|
|
||
|
|
INSERT INTO USERS (username, passwordHash)
|
||
|
|
VALUES ('sfj', '$2a$10$7lxFF6MWeWzn8PZDpveuD.KFQHWFutLUg9cjHKG6HR7wVo.p81NTG');
|
||
|
|
|
||
|
|
COMMIT;
|