4 * Check TODO.old and move still-valid/useful entries over here.
7 * database table "binaries" contains a column 'type TEXT NOT
8 NULL'. This should be made a FK on override_type, as it only contains
11 - sql query to do the db work for it:
12 ALTER TABLE binaries ADD COLUMN new_type INT4 REFERENCES override_type(id);
13 UPDATE BINARIES SET new_type = 7 WHERE type = 'deb';
14 UPDATE BINARIES SET new_type = 8 WHERE type = 'udeb';
15 ALTER TABLE binaries DROP COLUMN type;
16 ALTER TABLE binaries RENAME COLUMN new_type TO type;
18 - needs updateX.py written and then the rest of the code changed to deal
21 * Checkout SQL Alchemy and probably use that for our database layer.