From: John Hodge <tpg@mutabah.net>
Date: Sat, 29 Jan 2011 04:27:21 +0000 (+0800)
Subject: Fiddling with potential database schema
X-Git-Url: https://git.ucc.asn.au/?p=tpg%2Fopendispense2.git;a=commitdiff_plain;h=1fec74c361f83e4d2e3134b5b7df8ec8e8f04778

Fiddling with potential database schema
---

diff --git a/notes/Database Structure.txt b/notes/Database Structure.txt
index 9365b45..ba5ac38 100644
--- a/notes/Database Structure.txt	
+++ b/notes/Database Structure.txt	
@@ -1,9 +1,11 @@
 
 User
-	INTEGER	UserID
-	STRING	Username
+	INTEGER	UserID	PRIMARY_KEY
+	
+	STRING	Username	UNIQUE
 	
 	STRING	PasswordHash	; < Hmm... needed?
+	INTEGER	UnixUID	UNIQUE
 	INTEGER	PinCode
 	
 	INTEGER	Balance
@@ -15,5 +17,5 @@ User
 	
 	
 Card -> User
-	STRING	CardID
+	STRING	CardID	UNIQUE
 	INTEGER	UserID