You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
userid INTEGER PRIMARY KEY AUTOINCREMENT, /* legacy chat id */
uuid TEXT NOT NULL UNIQUE, /* strims id */
nick TEXT NOT NULL,
features TEXT NOT NULL, /* array like "f1,f2" */
firstlogin INTEGER, /* unix epoch */
lastlogin INTEGER, /* unix epoch */
lastip TEXT NOT NULL
);
CREATE TABLE IF NOT EXISTS bans (
userid INTEGER NOT NULL, /*TODO? userid cant be uniq because deleteBan does not delete row, just update expiretime to NOW. on reban we get another ban for same id */