/* this cannot be executed by sqlite3, everything after 1st statement is ignored */

CREATE TABLE IF NOT EXISTS library (
  id  INTEGER PRIMARY KEY AUTOINCREMENT,
  title TEXT,
  keywords TEXT,
  content TEXT,
  time DATETIME DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    username VARCHAR NOT NULL UNIQUE,
    password VARCHAR NOT NULL
);

/* password generated by
	perl -MCrypt::Passphrase -E  \
   'my $auth=Crypt::Passphrase->new(encoder=>"Argon2"); \
   say $auth->hash_password("$pwd")'
*/

INSERT OR IGNORE INTO users (username, password) VALUES
	('raj',
	'$argon2id$v=19$m=262144,t=3,p=1$A9XGCiy4/FhyQcYz9Ef5oA$d8nnPhDhS6AtDG6L1EAXHUx/vr0qOzGJsRoOyOaw5is'),
  ('test', /* t3st */
  '$argon2id$v=19$m=262144,t=3,p=1$qh2PEMMDRgIoDDrYhbF9sA$rp4HWtiOKdcq42q7pPRlxhDa7MZrGOAhKyvl0rxK0xg')
;