From: Ian Jackson <ian@liberator.relativity.greenend.org.uk>
Date: Sun, 26 Jul 2009 11:38:45 +0000 (+0100)
Subject: ids in schema; distances
X-Git-Tag: 3.0~36
X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?p=ypp-sc-tools.web-live.git;a=commitdiff_plain;h=a4acfa76a2d1401e734f8c335718379912a7f5d1

ids in schema; distances
---

diff --git a/pctb/schema-notes.txt b/pctb/schema-notes.txt
index a60f9b0..11a88dd 100644
--- a/pctb/schema-notes.txt
+++ b/pctb/schema-notes.txt
@@ -1,28 +1,39 @@
 
-OFFERS
-	ocean		utf-8
-	island		utf-8
-	commodity	utf-8
-	stall		utf-8
-	buy/sell	buy/sell
-    =>?
+BUY and SELL
+	commodity id	} indexed	} indexed	} unique
+	island id ??	}				} indexed?
+	stall id					}
+	=>?
 	price		integer
-	qty		integer
-	qty>1000?	boolean
+	qty		integer, 1001 means `>1000'
+
+COMMODITIES
+	commodity id
+	=>
+	commodity name
+	unit mass
+	unit volume
+
+ISLANDS
+	island id
+	=>
+	island name
+	archipelago name
+
+STALLS
+	stall id
+	=>
+	island id
+	stall name
 
 UPLOADS
-	ocean
-	island
+	island id
     =>?
 	age		integer time_t
 	clientspec	us-ascii
 	serverspec	us-ascii
 
-COMMODITIES
-	commodity
-
-ISLANDS
-	ocean
-	island
-    =>
-	archipelago	utf-8
+DISTANCES
+	island a id
+	island b id
+	distance	integer leagues