X-Git-Url: https://git.ucc.asn.au/?p=tpg%2Fopendispense2.git;a=blobdiff_plain;f=notes%2FDatabase%20Structure.txt;h=07e290eef75a53d885fec50340a583178a47bf43;hp=ba5ac38fd04597096d0c1aaebaebf7ef5b157b9d;hb=HEAD;hpb=1fec74c361f83e4d2e3134b5b7df8ec8e8f04778

diff --git a/notes/Database Structure.txt b/notes/Database Structure.txt
index ba5ac38..07e290e 100644
--- a/notes/Database Structure.txt	
+++ b/notes/Database Structure.txt	
@@ -2,17 +2,18 @@
 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
-	DATETIME	LastSeen
+	DATETIME LastSeen
 	BOOL	bEnabled
 	BOOL	bCokeMember
-	BOOL	bWheelMember
+	BOOL	bDoorMember
+	BOOL	bAdministrator	; Database admin (create/delete/lock accounts)
 	BOOL	bInternal