From a4acfa76a2d1401e734f8c335718379912a7f5d1 Mon Sep 17 00:00:00 2001
From: Ian Jackson <ian@liberator.relativity.greenend.org.uk>
Date: Sun, 26 Jul 2009 12:38:45 +0100
Subject: [PATCH] ids in schema; distances

---
 pctb/schema-notes.txt | 49 ++++++++++++++++++++++++++-----------------
 1 file changed, 30 insertions(+), 19 deletions(-)

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