Closed Bug 3725 Opened 25 years ago Closed 24 years ago

painful to change project names && table inconsistancies

Categories

(Bugzilla :: Bugzilla-General, defect, P3)

Other
Other

Tracking

()

VERIFIED DUPLICATE of bug 43600

People

(Reporter: jay, Assigned: justdave)

Details

i was recently asked to change the name of one of our projects.  to do this, i
issued a great deal of SQL update commands directly.  you must update:

bugs.product - products.product - versions.program -  components.program

we have an equal number of inconsistant names.  also, i discovered (the hard
way), that you cannot have a product name longer than 16 characters.  the
bugs.product field has that limitation.

so, could the bugs.product field be made a tinytext like all of the other
product/program fields?  could we have one consistant name (i like "project"
myself)?

as a better solution, you can convert each product/program field into a
"project_id".  then in the products table, create an auto incrementing integer
called "project_id" and change "product" to "name".  now, each
bug/component/version table would refer only to the project number and we can
change the name in only one place.
Reassigning to dmose@mozilla.org, who now has front-line responsibility for
all Bonsai and Bugzilla bugs.
Reassigning back to me.  That stuff about me no longer being the front-line
person responsible for Bugzilla and Bonsai turned out to be short-lived.
Please pardon our confusion, and I'm very sorry about the spam.
Status: NEW → ASSIGNED
tara@tequilarista.org is the new owner of Bugzilla and Bonsai.  (For details,
see my posting in netscape.public.mozilla.webtools,
news://news.mozilla.org/38F5D90D.F40E8C1A%40geocast.com .)
Assignee: terry → tara
Status: ASSIGNED → NEW
Bug 43600 is a duplicate of this bug, but since it already has a patch attached 
and more thorough discussion, I'd suggest marking this one as the the duplicate, 
and leaving bug 43600 open.
marking as dup, something to think about when we thrash the schema

*** This bug has been marked as a duplicate of 43600 ***
Status: NEW → RESOLVED
Closed: 24 years ago
Resolution: --- → DUPLICATE
Verified dupe.
Status: RESOLVED → VERIFIED
moving all closed Bugzilla bugs to the new Bugzilla product.
This batch is DUPLICATE/INVALID/WORKSFORME/WONTFIX
reassigning to default owner and QA in case of the bug being reopened.
Clearing milestones, since we really shouldn't have them on these types of
resolutions.  Sorry for the spam everyone...
Assignee: tara → justdave
Status: VERIFIED → NEW
Component: Bugzilla → Bugzilla-General
Product: Webtools → Bugzilla
QA Contact: matty
Version: other → unspecified
Verification got lost.
Status: RESOLVED → VERIFIED
QA Contact: matty_is_a_geek → default-qa
You need to log in before you can comment on or make changes to this bug.