X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?p=ypp-sc-tools.db-test.git;a=blobdiff_plain;f=yarrg%2FTODO;h=ea6b3eb42dfd34c1414fc316f397fff6f2ced0fa;hp=a2e2f34d1af632b2fb186b8fefb2dbcfce4e1136;hb=8aaade51e5904619daf638d496ce1162138d940f;hpb=350953d735019af3c903001bf4974128f0d0ef32

diff --git a/yarrg/TODO b/yarrg/TODO
index a2e2f34..ea6b3eb 100644
--- a/yarrg/TODO
+++ b/yarrg/TODO
@@ -1,54 +1,35 @@
+create index sell_by_islandonly on sell (islandid, commodid, price);
+
+
+
 UPLOADER
 --------
 
-	detect all unexpected mouse movements
+detect all unexpected mouse movements
+
+more flexible installation arrangements
 
-	more flexible installation arrangements
+figure out why pctb.ilk.org isn't working
 
-  W	windows uploader
+windows uploader
 
 DATABASE/DICTIONARY MANAGER
 ---------------------------
 
-	commodity mass/volume in live database
-	eliminate black dye from live database
+eliminate black dye from live database
 
-	when update rejected print better error message including
-	 broken commodity name
+when update rejected print better error message including
+ broken commodity name
 
-	notice commodities deleted from source-info and warn about them
+notice commodities deleted from source-info and warn about them
 
-	support Opal and Jade (currently there are some unicode problems)
+support Opal and Jade (currently there are some unicode problems)
 
 WEBSITE
 -------
 
-	multi-visit routes / circular routes
-
-	adjustable potential cost of losses (rather than fixed
-		1e-BIG per league)
-		use power formula (compound interest)
-		suggest 0.5%
-
-	initial/final stocks feature
-
-	max volume/mass
-
-	max capital
-
-	better documentation
-
-	printable voyage trading plan
-
-
-KEYLETTERS
-----------
-
-P	needed before public release
-O	needed before public release to support multiple oceans
+allow unticking based on minimum margin or minimum profit
 
-C	needs ypp client and network connection
-N	needs network connection
-W	needs to be done by someone with Windows
+initial/final stocks feature
 
-D	dependencies unsatisfied
+printable voyage trading plan