CREATE TABLE sessions

(

dc_id INTEGER PRIMARY KEY,

test_mode INTEGER,

auth_key BLOB,

date INTEGER NOT NULL,

user_id INTEGER,

is_bot INTEGER

);

CREATE TABLE peers

(

id INTEGER PRIMARY KEY,

access_hash INTEGER,

type INTEGER NOT NULL,

username TEXT,

phone_number TEXT,

last_update_on INTEGER NOT NULL DEFAULT (CAST(STRFTIME('%s', 'now') AS INTEGER))

);

CREATE TABLE version

(

number INTEGER PRIMARY KEY

);

CREATE INDEX idx_peers_id ON peers (id);

CREATE INDEX idx_peers_username ON peers (username);

CREATE INDEX idx_peers_phone_number ON peers (phone_number);

CREATE TRIGGER trg_peers_last_update_on

AFTER UPDATE

ON peers

UPDATE peers

SET last_update_on = CAST(STRFTIME('%s', 'now') AS INTEGER)

WHERE id = NEW.id;

END;