ids in schema; distances

diff --git a/pctb/schema-notes.txt b/pctb/schema-notes.txt
index a60f9b050766450548334b75cb7c56c66fef77eb..11a88dd58b3b800b93f9a56b6f44b02a32186e0d 100644 (file)
--- 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