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
(bugfix) Insufficient warning level to catch that bug
[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
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 bEnabled
BOOL bCokeMember
- BOOL bWheelMember
+ BOOL bDoorMember
+ BOOL bAdministrator ; Database admin (create/delete/lock accounts)
BOOL bInternal
BOOL bInternal
UCC
git Repository :: git.ucc.asn.au