19 lines
370 B
SQL
19 lines
370 B
SQL
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;
|