WIP schema

diff --git a/pctb/schema-notes.txt b/pctb/schema-notes.txt
new file mode 100644 (file)
index 0000000..a60f9b0
--- /dev/null
+++ b/pctb/schema-notes.txt
@@ -0,0 +1,28 @@
+
+OFFERS
+       ocean           utf-8
+       island          utf-8
+       commodity       utf-8
+       stall           utf-8
+       buy/sell        buy/sell
+    =>?
+       price           integer
+       qty             integer
+       qty>1000?       boolean
+
+UPLOADS
+       ocean
+       island
+    =>?
+       age             integer time_t
+       clientspec      us-ascii
+       serverspec      us-ascii
+
+COMMODITIES
+       commodity
+
+ISLANDS
+       ocean
+       island
+    =>
+       archipelago     utf-8