Addition of New tables to Bugzilla

Scott LaCroix slacroix at vutek.com
Fri May 13 17:25:55 UTC 2005


It's an interesting task... and not simple. 

Make a backup of your existing Bugzilla install ( assuming you have it running already ) so you have something to referr back to. I spent most of a day just changing Bugzilla to report the complete bug descripion ( full and 128 character truncated ) along with the bug summary fields, and that field existed in the DB already. You need to expect that you'll be jumping back and forth between the Schema files, the CGI files, and the template files alot until you understand how they all play together. 

These are the files I ended up touching to do that:
( some of them are in subdirectories so you'll have to poke around )

table.html.tmpl
change-columns.html.tmpl
change-columns.html.tmpl ( there are 2 of these )
colchange.cgi
buglist.cgi
request.cgi
report.cgi
Search.pm
Buzilla.pm

Mind you I didn't ADD any fields, so what you're doing will probably require more work than what I did. 

I'd start with buglist.cgi and report.cgi because those will show you how the tables are read & displayed. Then Search.pm and Buzilla.pm because those will be where you need to make changes to read & write the new fields. I'm not sure where the new fields need to be added, that will require more knowledge than I have.

Good luck!
-
Scott

-----Original Message-----
From: developers-owner at bugzilla.org
[mailto:developers-owner at bugzilla.org]On Behalf Of Zach Lipton
Sent: Friday, May 13, 2005 12:25 PM
To: developers at bugzilla.org
Subject: Re: Addition of New tables to Bugzilla


Joking aside, it is pretty difficult to know what you are referring  
to here. We could help you better if we knew what you are trying  
achieve. What exactly would you like to make Bugzilla do that it  
doesn't do now?

The general idea is that you would edit Bugzilla::DB::Schema to do  
whatever it is you are trying to do with the table schema. You would  
then modify the cgi scripts to set and retrieve values from your new  
table/column. Lastly, you would need to edit the template files to  
add form controls to set/display these new values. Without more  
specific information, it's really impossible to be more helpful with  
this.

--zach

On May 13, 2005, at 8:53 AM, Chris Raplee wrote:

> ...with a text editor?
>
> Chris Raplee
>
>
> -----Original Message-----
> From: developers-owner at bugzilla.org
> [mailto:developers-owner at bugzilla.org] On Behalf Of Rahul Kumar
> Sent: Thursday, May 12, 2005 11:00 PM
> To: developers at bugzilla.org
> Subject: Addition of New tables to Bugzilla
>
>
> Hi,
>
> I am new to Bugzilla. I want to add new tables to the MySQL database,
> and perform operations like addition and retrieving from these tables.
> Can anyone suggest how to go about making changes to the Bugzilla
> source.
>
> Thanks in advance
> --rahul
>
>
> -
> To view or change your list settings, click here:
> <http://bugzilla.org/cgi-bin/mj_wwwusr? 
> user=chris.raplee at portalplayer.co
> m>
>
> -
> To view or change your list settings, click here:
> <http://bugzilla.org/cgi-bin/mj_wwwusr?user=zach@zachlipton.com>
>

-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=slacroix@vutek.com>




More information about the developers mailing list