notes/Database Structure.txt

   1
   2 User
   3         INTEGER UserID  PRIMARY_KEY
   4
   5         STRING  Username        NULL, UNIQUE
   6
   7         STRING  PasswordHash    NULL    ; < Hmm... needed? (Nah, PAM only)
   8         INTEGER UnixUID         NULL, UNIQUE
   9         INTEGER PinCode         NULL
  10
  11         INTEGER Balance
  12         DATETIME LastSeen
  13         BOOL    bEnabled
  14         BOOL    bCokeMember
  15         BOOL    bWheelMember
  16         BOOL    bInternal
  17
  18
  19 Card -> User
  20         STRING  CardID  UNIQUE
  21         INTEGER UserID