From 6b194d420f1554ace61a251f2c416712d68ab633 Mon Sep 17 00:00:00 2001 From: John Hodge Date: Sun, 16 Jan 2011 17:04:14 +0800 Subject: [PATCH] Added database structure, moved planning to notes/ --- .../Coke machine log.txt | 0 notes/Database Structure.txt | 19 +++++++++++++++++++ plan.txt => notes/plan.txt | 2 ++ proto.txt => notes/proto.txt | 0 ui.txt => notes/ui.txt | 0 5 files changed, 21 insertions(+) rename Coke machine log.txt => notes/Coke machine log.txt (100%) create mode 100644 notes/Database Structure.txt rename plan.txt => notes/plan.txt (87%) rename proto.txt => notes/proto.txt (100%) rename ui.txt => notes/ui.txt (100%) diff --git a/Coke machine log.txt b/notes/Coke machine log.txt similarity index 100% rename from Coke machine log.txt rename to notes/Coke machine log.txt diff --git a/notes/Database Structure.txt b/notes/Database Structure.txt new file mode 100644 index 0000000..9365b45 --- /dev/null +++ b/notes/Database Structure.txt @@ -0,0 +1,19 @@ + +User + INTEGER UserID + STRING Username + + STRING PasswordHash ; < Hmm... needed? + INTEGER PinCode + + INTEGER Balance + DATETIME LastSeen + BOOL bEnabled + BOOL bCokeMember + BOOL bWheelMember + BOOL bInternal + + +Card -> User + STRING CardID + INTEGER UserID diff --git a/plan.txt b/notes/plan.txt similarity index 87% rename from plan.txt rename to notes/plan.txt index cc67aba..ec1d543 100644 --- a/plan.txt +++ b/notes/plan.txt @@ -13,3 +13,5 @@ Central "dispense" server > Accepts commands from dispense app. - See `proto.txt` + +Extra notes, see http://wiki.ucc.asn.au/OpenDispense2 diff --git a/proto.txt b/notes/proto.txt similarity index 100% rename from proto.txt rename to notes/proto.txt diff --git a/ui.txt b/notes/ui.txt similarity index 100% rename from ui.txt rename to notes/ui.txt -- 2.20.1