From 1fec74c361f83e4d2e3134b5b7df8ec8e8f04778 Mon Sep 17 00:00:00 2001
From: John Hodge <tpg@mutabah.net>
Date: Sat, 29 Jan 2011 12:27:21 +0800
Subject: [PATCH] Fiddling with potential database schema

---
 notes/Database Structure.txt | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

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
-- 
2.20.1