The Road to 2.18 - Customfields

Sean McAfee etzwane at schwag.org
Mon Mar 15 20:24:55 UTC 2004


Joel Peshkin <bugreport at peshkin.net> wrote:
>Additionally, it is not clear to me which approach is better from a 
>standpoint of seperating the DBA functions from the web administrator 
>functions and providing a migration path that permits existing 1-per-bug 
>fields (like URL and Whiteboard) to collapse into customfields.  What 
>would that look like?

Something like this, supposing 42 is the ID of the custom field created for
the bug_file_loc field to collapse into:

INSERT INTO cf_longstring (bug_id, field_id, value)
SELECT bug_id, 42, bug_file_loc
FROM bugs;

Real easy.


--Sean



More information about the developers mailing list