Gitlab CI - Debugging

[tpg/opendispense2.git] / notes / Database Structure.txt

diff --git a/notes/Database Structure.txt b/notes/Database Structure.txt
index ba5ac38..07e290e 100644 (file)
--- a/notes/Database Structure.txt
+++ b/notes/Database Structure.txt
@@ -2,17 +2,18 @@
 User
        INTEGER UserID  PRIMARY_KEY
        
-       STRING  Username        UNIQUE
+       STRING  Username        NULL, UNIQUE
        
-       STRING  PasswordHash    ; < Hmm... needed?
-       INTEGER UnixUID UNIQUE
-       INTEGER PinCode
+       STRING  PasswordHash    NULL    ; < Hmm... needed? (Nah, PAM only)
+       INTEGER UnixUID         NULL, UNIQUE
+       INTEGER PinCode         NULL
        
        INTEGER Balance
-       DATETIME        LastSeen
+       DATETIME LastSeen
        BOOL    bEnabled
        BOOL    bCokeMember
-       BOOL    bWheelMember
+       BOOL    bDoorMember
+       BOOL    bAdministrator  ; Database admin (create/delete/lock accounts)
        BOOL    bInternal