Closed
Bug 3725
Opened 26 years ago
Closed 24 years ago
painful to change project names && table inconsistancies
Categories
(Bugzilla :: Bugzilla-General, defect, P3)
Tracking
()
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.
Comment 1•25 years ago
|
||
Reassigning to dmose@mozilla.org, who now has front-line responsibility for
all Bonsai and Bugzilla bugs.
Comment 2•25 years ago
|
||
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.
Updated•25 years ago
|
Status: NEW → ASSIGNED
Comment 3•24 years ago
|
||
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
Assignee | ||
Comment 4•24 years ago
|
||
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
Assignee | ||
Comment 7•23 years ago
|
||
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
Updated•12 years ago
|
QA Contact: matty_is_a_geek → default-qa
You need to log in
before you can comment on or make changes to this bug.
Description
•