Addition of New tables to Bugzilla

[Rahul Kumar]

The tables i want to add to the existing schema are

----------------------------
-----------------------------------
|    Vendor                 |                               |  Vendor Product
|
----------------------------
-----------------------------------
| id            |                   | id              |
| name                |                   | name                  |
| Priority            |                   | vendor_id       |
| status              |                   | contact         |
----------------------------
------------------------------------

Changes to bug table are, only additional columns are shown

---------------------------------------
| bug                 |
---------------------------------------
| vendor_request_number |
| action owner              |
| tracking_note             |
| vendorproduct_id          |
---------------------------------------

I have already made changes to the checksetup.pl file to add the new tables to
the bugs database. What are the additional perl scripts that need ?
Moreover, what is the purpose of the file 'versioncache' ?

--rahul



                                                                                                
                      "Zach Lipton"                                                             
                      <zach at zachlipton.c        To:       developers at bugzilla.org               
                      om>                       cc:                                             
                      Sent by:                  Subject:  Re: Addition of New tables to         
                      developers-owner at b         Bugzilla                                       
                      ugzilla.org                                                               
                                                                                                
                                                                                                
                      05/13/05 09:54 PM                                                         
                      Please respond to                                                         
                      developers                                                                
                                                                                                
                                                                                                




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=rahul.kumar@nsc.com>