Server - Slight fixes to coke handler to cope with the machine being dodge
[tpg/opendispense2.git] / 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    bDoorMember
16         BOOL    bAdministrator  ; Database admin (create/delete/lock accounts)
17         BOOL    bInternal
18         
19         
20 Card -> User
21         STRING  CardID  UNIQUE
22         INTEGER UserID

UCC git Repository :: git.ucc.asn.au