The Interesting Installation Integer Problem

[Nick Barnes]

At 2005-03-07 09:32:25+0000, Max Kanat-Alexander writes:
>       I've come across an interesting theoretical problem, today, when
> thinking about our new cross-platform installation.
> 
>       Basically, here's the problem:
> 
>       We have a new Bugzilla::DB::Schema module coming, which is almost
> complete. (See
> <https://bugzilla.mozilla.org/show_bug.cgi?id=bz-dbschema>). It maps
> "generic" types to database-specific types. It's very cool.

Hey, that *is* cool.

Any chance of extending it to custom field type names?  Immediate
benefit: you can say (for instance) "bugs_activity.bug_id is a bug
ID", and the module will do the right thing (i.e. {TYPE => 'INT3',
NOTNULL => 1}, right now, or something else, consistently everywhere,
if that type ever changes).  Subsequent benefit: smarter databases can
say "a bug ID has to be a FOREIGN KEY bugs.bug_id", and that's a
one-time change in this schema management code.

Nick B