oko-server/V4_user_info.sql at main - oko-server - Gitea: Git with a cup of tea

michal/oko-server

mirror of https://github.com/Cernobor/oko-server.git synced 2025-02-24 08:27:17 +00:00

zegkljan 8440e3b7d7

continuous-integration/drone/push Build is passing

Details

Collecting usage info, change sqlite lib.

* X-User-ID header is processed to get user ID.
* Time of last request for a user is saved into DB.
* Time of last upload and download is stored for a user.
* Added DB migration to add columns into users table to store the times and app version.
* Backward fix of datatype of the deadline column in features table.
* Switched from crawshaw.io/sqlite to zombiezen.com/go/sqlite.
  * Refactored DB handling.
  * Used migration routine from zombiezen in favour of manual one.
  * Runtime DB reinit simply deletes the db file and initializes the db anew.

Fix #6

2023-06-11 18:06:52 +02:00

4 lines

211 B

SQL

Raw Permalink Blame History

 ALTER TABLE users ADD COLUMN app_version text;
 ALTER TABLE users ADD COLUMN last_seen_time integer;
 ALTER TABLE users ADD COLUMN last_upload_time integer;
 ALTER TABLE users ADD COLUMN last_download_time integer;