data-schemas merge requestshttps://gitlab.akamu.de/akamu/data-schemas/-/merge_requests2020-12-31T14:43:00+01:00https://gitlab.akamu.de/akamu/data-schemas/-/merge_requests/13Resolve "User university issue"2020-12-31T14:43:00+01:00Julien SchröterResolve "User university issue"Prepared database schema for enabling players from different universities. Won't work with current game server's implementation of user registration (notify @niklas.fix when deployed to dev database)
Unrelated to that issue: Players mus...Prepared database schema for enabling players from different universities. Won't work with current game server's implementation of user registration (notify @niklas.fix when deployed to dev database)
Unrelated to that issue: Players must have a valid selected title and a valid selected avatar. Furthermore, as described in https://www.rfc-editor.org/errata/eid1690 email addresses can have a maximum length of 254 characters in practice. Since verification isn't optional and unverified users are deleted regularly, we are protected from spam.
Closes #3Frederik WegnerFrederik Wegnerhttps://gitlab.akamu.de/akamu/data-schemas/-/merge_requests/12Halved the leveling speed2020-12-30T14:01:09+01:00Frederik WegnerHalved the leveling speedJulien SchröterJulien Schröterhttps://gitlab.akamu.de/akamu/data-schemas/-/merge_requests/11Unique roundquestion2020-12-30T13:59:06+01:00Frederik WegnerUnique roundquestionThe answer to a roundquestion should be unique. A user should not be able to answer the same roundquestion twice. (Though, he may very well be able to answer the same question twice.
**IMPORTANT**
After merging this request, the databas...The answer to a roundquestion should be unique. A user should not be able to answer the same roundquestion twice. (Though, he may very well be able to answer the same question twice.
**IMPORTANT**
After merging this request, the database has to be updated.
`ALTER IGNORE TABLE useranswer ADD CONSTRAINT UNIQUE (name, roundquestion);`
`IGNORE` results in the removal of duplicates with random preference.
It may be preferable to manually resolve duplicates first.Julien SchröterJulien Schröterhttps://gitlab.akamu.de/akamu/data-schemas/-/merge_requests/10Let func isAnswered return true if >2 qs answered2020-07-01T18:37:04+02:00Julien SchröterLet func isAnswered return true if >2 qs answeredThis will fix the erroneous update of the next-user or running. Won't prevent users to answer even tough they are not supposed to and receiving experience points for thatThis will fix the erroneous update of the next-user or running. Won't prevent users to answer even tough they are not supposed to and receiving experience points for thatFrederik WegnerFrederik Wegnerhttps://gitlab.akamu.de/akamu/data-schemas/-/merge_requests/9Development2020-04-21T19:05:31+02:00Simon MetzlerDevelopmenthttps://gitlab.akamu.de/akamu/data-schemas/-/merge_requests/8Increase user's initial level to 12020-02-12T12:12:58+01:00Julien SchröterIncrease user's initial level to 1Fixes GSG-85Fixes GSG-85Simon MetzlerSimon Metzlerhttps://gitlab.akamu.de/akamu/data-schemas/-/merge_requests/7Bugfix/table order2019-11-12T16:54:58+01:00Ghost UserBugfix/table orderhttps://gitlab.akamu.de/akamu/data-schemas/-/merge_requests/6Make firebase-token optional2019-10-15T17:53:01+02:00Ghost UserMake firebase-token optionalPreviously, firebase-tokens must have been provided when creating a session. Discussing the task, we decided to make firebase, including firebase-tokens optional.Previously, firebase-tokens must have been provided when creating a session. Discussing the task, we decided to make firebase, including firebase-tokens optional.https://gitlab.akamu.de/akamu/data-schemas/-/merge_requests/5Add field for firebase-token to session table2019-10-15T15:14:41+02:00Ghost UserAdd field for firebase-token to session tableRequired to send push notifications to other users (e.g. when answering a duel)Required to send push notifications to other users (e.g. when answering a duel)https://gitlab.akamu.de/akamu/data-schemas/-/merge_requests/4TG-169 Fix computed column in schema definition2019-04-15T19:27:19+02:00Ghost UserTG-169 Fix computed column in schema definitionhttps://gitlab.akamu.de/akamu/data-schemas/-/merge_requests/3Set NULL as idmongo default2019-02-11T18:56:01+01:00Ghost UserSet NULL as idmongo defaultMakes the POST /pool sql query for us simpler since we don't have to explicitly mention idmongo.
I believe setting this "NOT NULL" here was just an oversight.Makes the POST /pool sql query for us simpler since we don't have to explicitly mention idmongo.
I believe setting this "NOT NULL" here was just an oversight.https://gitlab.akamu.de/akamu/data-schemas/-/merge_requests/2removes invalid references to tables answer and resources2018-12-17T12:37:17+01:00Ghost Userremoves invalid references to tables answer and resourceshttps://gitlab.akamu.de/akamu/data-schemas/-/merge_requests/1Adds cross table maintainer_subject as needed by BP team2018-12-17T12:31:13+01:00Ghost UserAdds cross table maintainer_subject as needed by BP team