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
9365b45
..
07e290e
100644
(file)
--- a/
notes/Database Structure.txt
+++ b/
notes/Database Structure.txt
@@
-1,19
+1,22
@@
User
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
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
Card -> User
BOOL bInternal
Card -> User
- STRING CardID
+ STRING CardID
UNIQUE
INTEGER UserID
INTEGER UserID
UCC
git Repository :: git.ucc.asn.au