view database/schema/TODO @ 25:813a27f32072

create installation directories
author David A. Holland
date Sun, 26 May 2013 21:58:46 -0400
parents ae420ef170e4
children 233dcc4d80e1
line wrap: on
line source

-- Does not handle:
--
-- * The Description, How-To-Repeat, and Fix fields from gnats are
--   supposed to just be the initial entries in the message log, but
--   they're currently also in the bugs table. Also "unformatted".
--
-- * There is no administrative queue yet.
--      - comments on locked PRs
--      - comments on nonexistent PRs
--      - bounced mail from feedback requests
--      - other bounced mail
--      - unreocgnized/junk/malformed mail?
--      - action requests in commit messages like Christos wants
--
-- * "Category" is just a classification scheme, but we need to know
--   (based on the category) what default subscriptions to create.
--   There's currently no way to do this. Since the script for
--   accepting incoming PRs needs to know about the gnats schema
--   anyway, perhaps there should just be a table in the database to
--   tell it what to do.
--
-- * There also needs to be a hook to deduce the package name for
--   pkgsrc PRs by scanning the synopsis. This is going to be netbsd-
--   specific; making it table-driven isn't feasible and probably it's
--   not worth (at least at first) setting up a whole scheme for
--   site-specific extensions. So probably it'll be hard-coded in at
--   least to begin with.
--
-- * There should be an incoming queue for stuff submitted via the web
--   interface, because a lot of it will be spam.
--
-- * There should be a whitelist/blacklist for that queue, by IP
--   address or netblock.
--
-- * Should support automatic feedback timeout.
--
-- (the stuff below this point probably isn't getting done before the
-- initial deployment)
--
-- * Should be able to merge duplicates.
-- * Should allow recording dependencies between bugs.
-- * Should store pullup numbers
--