simple-web-app

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs | README

0004_sessions.sql (299B)

      1 BEGIN IMMEDIATE;
      2 
      3 CREATE TABLE session (
      4     token TEXT PRIMARY KEY NOT NULL,
      5     user_id INTEGER NOT NULL REFERENCES user(id),
      6     created_at TEXT NOT NULL DEFAULT (datetime('now'))
      7 ) STRICT;
      8 
      9 CREATE INDEX idx_session_user_id ON session(user_id);
     10 
     11 UPDATE migration_version SET version = 4;
     12 COMMIT;