Show commod class in voyage plan too

[ypp-sc-tools.db-test.git] / yarrg / devel-notes

diff --git a/yarrg/devel-notes b/yarrg/devel-notes
index f4f6066788c045383e68aac313b237c156e65d85..430523adfd3c9e069b426eebf7c30cf61c70f66d 100644 (file)
--- a/yarrg/devel-notes
+++ b/yarrg/devel-notes
@@ -1,21 +1,4 @@
 
 

-removing an obsolete commodity:
-
-  select * from (select * from sell union select * from buy) left outer join commods using (commodid) where commods.commodname = 'Black dye' limit 10;
-
-if that produces no output then:
-
-  begin;
-  delete from commods where commodname like 'Black dye';
-  select * from (select * from sell union select * from buy) left outer join commods using (commodid) where commods.commodname is null limit 10;
-
-and if that produces no output then:
-  commit;
-otherwise
-  rollback;
-
-=======================================
-

 ceb's example route:
   alpha,byrne,papaya,turtle,jorvik,luthien
 
 ceb's example route:
   alpha,byrne,papaya,turtle,jorvik,luthien