X-Git-Url: https://git.ucc.asn.au/?a=blobdiff_plain;f=notes%2FDatabase%20Structure.txt;h=07e290eef75a53d885fec50340a583178a47bf43;hb=526601c22bce164193a6290777eee1f9beb79e99;hp=9365b45903233199f024797cc0a41b43a4e7dfe8;hpb=6b194d420f1554ace61a251f2c416712d68ab633;p=tpg%2Fopendispense2.git

diff --git a/notes/Database Structure.txt b/notes/Database Structure.txt
index 9365b45..07e290e 100644
--- a/notes/Database Structure.txt	
+++ b/notes/Database Structure.txt	
@@ -1,19 +1,22 @@
 
 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
-	DATETIME	LastSeen
+	DATETIME LastSeen
 	BOOL	bEnabled
 	BOOL	bCokeMember
-	BOOL	bWheelMember
+	BOOL	bDoorMember
+	BOOL	bAdministrator	; Database admin (create/delete/lock accounts)
 	BOOL	bInternal
 	
 	
 Card -> User
-	STRING	CardID
+	STRING	CardID	UNIQUE
 	INTEGER	UserID