git.ucc.asn.au
/
tpg
/
opendispense2.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Big cleanups, reworked CokeBank API
[tpg/opendispense2.git]
/
notes
/
Database Structure.txt
diff --git
a/notes/Database Structure.txt
b/notes/Database Structure.txt
index
ba5ac38
..
2680507
100644
(file)
--- a/
notes/Database Structure.txt
+++ b/
notes/Database Structure.txt
@@
-2,14
+2,14
@@
User
INTEGER UserID PRIMARY_KEY
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
INTEGER Balance
- DATETIME
LastSeen
+ DATETIME LastSeen
BOOL bEnabled
BOOL bCokeMember
BOOL bWheelMember
BOOL bEnabled
BOOL bCokeMember
BOOL bWheelMember
UCC
git Repository :: git.ucc.asn.au