Cleaning up warnings in client

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

diff --git a/notes/Database Structure.txt b/notes/Database Structure.txt
index 9365b45..07e290e 100644 (file)
--- a/notes/Database Structure.txt
+++ b/notes/Database Structure.txt
@@ -1,19 +1,22 @@
 
 User
-       INTEGER UserID
-       STRING  Username
+       INTEGER UserID  PRIMARY_KEY
+       
+       STRING  Username        NULL, UNIQUE
        
-       STRING  PasswordHash    ; < Hmm... needed?
-       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
        
        
 Card -> User
-       STRING  CardID
+       STRING  CardID  UNIQUE
        INTEGER UserID