marky

Lightweight bookmarking + plaintext archive
Log | Files | Refs | README | LICENSE

0001_users.sql (422B)

      1 -- Users table
      2 CREATE TABLE IF NOT EXISTS users (
      3   id INTEGER PRIMARY KEY AUTOINCREMENT,
      4   username TEXT NOT NULL UNIQUE CHECK (username <> '' AND username GLOB '[a-z0-9]*'),
      5   encrypted_password TEXT NOT NULL,
      6   api_token TEXT NOT NULL,
      7   created_at TEXT NOT NULL,
      8   updated_at TEXT NOT NULL
      9 );
     10 
     11 -- API token is always present and unique
     12 CREATE UNIQUE INDEX IF NOT EXISTS idx_users_api_token_unique
     13 ON users(api_token);