Addition of New tables to Bugzilla

[Rahul Kumar]

In my earlier mail, the tables were not shown properly here it is again

The tables i want to add to the existing schema are

Vendor
-----------
id
name
priority
status

Vendor Product
------------------------
id
name
vendor_id
contact

additional columns in bug table

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 to be changed
?
Moreover, what is the purpose of the file 'versioncache' ?

--rahul




                                                                                                                                       
                      "Rahul Kumar"                                                                                                    
                      <Rahul.Kumar at nsc.c        To:       developers at bugzilla.org                                                      
                      om>                       cc:                                                                                    
                      Sent by:                  Subject:  Re: Addition of New tables to Bugzilla                                       
                      developers-owner at b                                                                                               
                      ugzilla.org                                                                                                      
                                                                                                                                       
                                                                                                                                       
                      05/15/05 12:59 PM                                                                                                
                      Please respond to                                                                                                
                      developers                                                                                                       
                                                                                                                                       
                                                                                                                                       




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>





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