X-Git-Url: http://gitweb.michael.orlitzky.com/?a=blobdiff_plain;f=doc%2FTODO;h=6bce0fbf735b17d894ae5eb72bb1aa22277c25af;hb=cf1b07edbb1a3013a3e0d49a070c74e87655e01a;hp=ade7b4a23042ad41015bb0bba4ab4b876d5b84b9;hpb=6582d0664af4a86919ce6d080dade6f81688d427;p=dead%2Fhtsn-import.git

diff --git a/doc/TODO b/doc/TODO
index ade7b4a..6bce0fb 100644
--- a/doc/TODO
+++ b/doc/TODO
@@ -4,5 +4,12 @@
 2. Write a test for test/xml/Odds_XML-long-import.xml once it no
    longer takes 10 minutes to import (Postgres only?).
 
-3. Write a test for the ON DELETE CASCADE behavior which is supposed
-   to be default but does not seem to work at the moment.
+3. Write a test for the ON DELETE CASCADE behavior.
+
+4. Add top-level message tables for all types so that we can link all
+   records to a message and use the message's time stamp to (cascade)
+   delete old data.
+
+5. Drop the many-to-many relation between at least odds and
+   odds_games, since duplicate games are highly unlikely and the table
+   will grow without bound.