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'
);