1234567891011121314151617181920 |
- CREATE TABLE IF NOT EXISTS user (
- id INTEGER PRIMARY KEY AUTOINCREMENT,
- name TEXT NOT NULL UNIQUE,
- salt TEXT NOT NULL,
- hash TEXT NOT NULL
- );
- CREATE TABLE IF NOT EXISTS session (
- id TEXT PRIMARY KEY UNIQUE,
- user_id INTEGER NOT NULL UNIQUE REFERENCES user(id) ON DELETE CASCADE
- );
- CREATE INDEX IF NOT EXISTS username_idx ON user(name);
- CREATE VIEW IF NOT EXISTS sess_user AS SELECT user.name AS name, user.id AS id, session.id AS session FROM user JOIN session ON session.user_id=user.id;
- CREATE TABLE IF NOT EXISTS user_acl (
- user_id INTEGER NOT NULL UNIQUE REFERENCES user(id) ON DELETE CASCADE,
- acl TEXT NOT NULL
- );
|