Mercurial > lbo > hg > analyrics
view config_schema_sqlite.sql @ 25:390a448dc8c7
Support timezones
author | Lewin Bormann <lbo@spheniscida.de> |
---|---|
date | Wed, 13 Jul 2022 21:49:41 -0700 |
parents | acf064f0e934 |
children |
line wrap: on
line source
DROP TABLE IF EXISTS users; CREATE TABLE users ( id INTEGER PRIMARY KEY, username TEXT NOT NULL UNIQUE, name TEXT, salt TEXT, password_hash TEXT, tz_offset INTEGER, ); DROP TABLE IF EXISTS domainpermissions; CREATE TABLE domainpermissions ( id INTEGER PRIMARY KEY, username TEXT NOT NULL, domain TEXT NOT NULL, FOREIGN KEY (username) REFERENCES users (username) );