summaryrefslogtreecommitdiffstats
path: root/Bugzilla/DB/Schema.pm
AgeCommit message (Collapse)AuthorFilesLines
2010-07-15Bug 578739: Instead of removing REFERENCES from _bz_real_schema and thenMax Kanat-Alexander1-5/+43
populating FKs from _bz_schema at the end of checksetup, store REFERENCES in _bz_real_schema with a special "created => 0" key that tells us that we still need to create the FK. r=mkanat, a=mkanat (module owner)
2010-07-06Bug 486292: Change the default workflow to UNCONFIRMED, CONFIRMED,Max Kanat-Alexander1-1/+1
IN_PROGRESS, RESOLVED, VERIFIED. r=LpSolit, a=mkanat
2010-06-22When doing bz_alter_column, if Max Kanat-Alexander1-2/+5
https://bugzilla.mozilla.org/show_bug.cgi?id=573441
2010-06-22Bug 573454: Make the products.description field be NOT NULL in theMax Kanat-Alexander1-1/+1
database r=timello, a=mkanat
2010-06-22Bug 573450: Make the keyworddefs.description column be NOT NULL in theMax Kanat-Alexander1-1/+1
database r=timello, a=mkanat
2010-06-22Bug 573441: Add a DEFAULT and NOTNULL to the attachments.ispatch columnMax Kanat-Alexander1-1/+2
r=timello, a=mkanat
2010-06-16Bug 24896: Make the First/Last/Prev/Next navigation on bugs work withMax Kanat-Alexander1-0/+12
multiple buglists at once r=glob, a=mkanat
2010-06-01Bug 569312: Speed up the adding of many FKs to the same table for MySQLMax Kanat-Alexander1-4/+22
and PostgreSQL, by adding them all in one ALTER statement r=mkanat, a=mkanat (module owner)
2010-05-19Bug 494395: Implement the ability to mark custom fields as mandatory whenTiago Mello1-0/+3
creating/changing bugs r=mkanat, a=mkanat
2010-05-07Bug 463945: Add default values for membercontrol and othercontrolEdmund Wong1-2/+4
in group_control_map, and fix their DB type to be correct r=mkanat, a=mkanat
2010-04-22Bug 560009: Use firstidx from List::MoreUtils instead of lsearchMax Kanat-Alexander1-3/+4
r=timello, a=mkanat
2010-04-08Bug 69621: Remove the keyword cache (which is not updated on keyword ↵Frédéric Buclin1-4/+0
rename/delete) r/a=mkanat
2010-02-20Bug 519035: Make the FK for series.creator have ON DELETE CASCADE insteadMax Kanat-Alexander1-1/+1
of ON DELETE SET NULL r=LpSolit, a=LpSolit
2010-02-16Bug 372979: Make voting into an extensionMax Kanat-Alexander1-27/+0
r=mkanat, a=mkanat, a=LpSolit
2010-02-10Bug 310450 - Bugzilla should send an email when a comment becomes private ↵Dave Lawrence1-0/+4
or un-private r=mkanat, a=mkanat
2010-02-08Bug 251556: Allow "Bug ID" fields to have one-way mutual relationships (like ↵Jesse Clark1-0/+1
blocks/dependson) r=mkanat, a=mkanat
2009-12-31Bug 531841: Change all hour-related database fields to decimal(7,3) so that ↵mkanat%bugzilla.org1-3/+3
they can store numbers greater than 999.99 in modern versions of MySQL. Patch by Max Kanat-Alexander <mkanat@bugzilla.org> r=dkl, a=mkanat
2009-12-31Bug 520318: Add remove_from_db to Bugzilla:Group and use it to delete groups ↵mkanat%bugzilla.org1-2/+4
in editgroups.cgi Patch by Max Kanat-Alexander <mkanat@bugzilla.org> r=dkl, a=LpSolit
2009-12-18Bug 162060: Remove the relationship between "votestoconfirm" and whether or ↵mkanat%bugzilla.org1-0/+2
not the UNCONFIRMED status is available, by adding a checkbox to enable the UNCONFIRMED status in editproducts.cgi. Patch by Max Kanat-Alexander <mkanat@bugzilla.org> r=LpSolit, a=LpSolit
2009-12-13Bug 369489: Remove the milestoneurl feature and link "Target Milestone" to ↵mkanat%bugzilla.org1-2/+0
the fields.html page Patch by Max Kanat-Alexander <mkanat@bugzilla.org> r=LpSolit, a=LpSolit
2009-12-13Bug 355283: Lock out a user account on a particular IP for 30 minutes if ↵mkanat%bugzilla.org1-0/+20
they fail to log in 5 times from that IP. Patch by Max Kanat-Alexander <mkanat@bugzilla.org> r=LpSolit, a=LpSolit
2009-11-24Bug 430014: Re-write the code hooks system so that it uses modules instead ↵mkanat%bugzilla.org1-1/+1
of individual .pl files Patch by Max Kanat-Alexander <mkanat@bugzilla.org> (module owner) a=mkanat
2009-10-19Bug 399073: Remove the 'loginnetmask' parameter - Patch by Frédéric ↵lpsolit%gmail.com1-1/+1
Buclin <LpSolit@gmail.com> r/a=mkanat
2009-09-28Bug 519032: Remove the unused "last_viewed" column from the "series" DB ↵lpsolit%gmail.com1-1/+0
table - Patch by Frédéric Buclin <LpSolit@gmail.com> r/a=mkanat
2009-09-07Bug 176002: Move duplicate statistics into the dbmkanat%bugzilla.org1-1/+2
Patch by Max Kanat-Alexander <mkanat@bugzilla.org> r=LpSolit, a=LpSolit
2009-05-30Bug 462073: Add FK constraints to the profile_setting table - Patch by ↵lpsolit%gmail.com1-1/+4
Nitish Bezzala <nbezzala@yahoo.com> r/a=mkanat
2009-05-30Bug 462072: Add FK constraints to the products table - Patch by Nitish ↵lpsolit%gmail.com1-1/+4
Bezzala <nbezzala@yahoo.com> r/a=mkanat
2009-05-30Bug 462070: Add FK constraints to the status_workflow table - Patch by ↵lpsolit%gmail.com1-2/+8
Nitish Bezzala <nbezzala@yahoo.com> r/a=mkanat
2009-05-26Bug 462067 - Add FK constraints to the bugs table for user, product, and ↵dkl%redhat.com1-5/+15
component int fields Patch by David Lawrence <dkl@redhat.com> - r=mkanat a=LpSolit
2009-05-21 Bug 493090 - Product disallownew should be converted to isactiveghendricks%novell.com1-2/+2
patch by ghendricks r=mkanat a=mkanat
2009-04-06Bug 302420: Allow whining messages to be sent even without any results - ↵wicked%sci.fi1-0/+2
Patch by Micheal J. Tosh <michael.j.tosh@lmco.com> r=wicked a=mkanat
2009-04-04Bug 486239: [Oracle] Missing keyword RESTRICT on fk creation (DB::Schema ↵mkanat%bugzilla.org1-2/+1
explicitly specified DELETE => 'RESTRICT') Patch by Xiaoou Wu <xiaoou.wu@oracle.com> and Max Kanat-Alexander <mkanat@bugzilla.org> r=mkanat
2009-03-31Bug 462068: Add FK constraints to the longdescs table - Patch by Vipin Hegde ↵lpsolit%gmail.com1-2/+8
<vipinhegde@gmail.com> r/a=mkanat
2009-03-31Bug 478972: Remove the 'useentrygroupdefault' parameter - Patch by ↵lpsolit%gmail.com1-2/+4
Frédéric Buclin <LpSolit@gmail.com> r/a=mkanat
2009-03-31Bug 423613: Make profiles.extern_id actually UNIQUE in the DB schema.mkanat%bugzilla.org1-0/+2
Patch by arbingersys@gmail.com r=mkanat, a=mkanat
2009-01-22Bug 472872: Add a field where people can put the URLs to Bugzilla bugs (from ↵mkanat%bugzilla.org1-1/+11
any Bugzilla installation) Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=dkl, a=mkanat
2009-01-15Bug 344878: Automatically generate list of acceptable columns for ↵lpsolit%gmail.com1-0/+2
buglist.cgi from the database - Patch by Teemu Mannermaa <wicked@sci.fi> r/a=mkanat
2008-12-24Bug 284184: Allow Bugzilla to use an asynchronous job queue for sending mail.mkanat%bugzilla.org1-0/+87
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> and Mark Smith <mark@plogs.net> r=glob, a=mkanat
2008-11-07Bug 308253: Ability to add select (enum) fields to a bug whose list of ↵mkanat%bugzilla.org1-63/+37
values depends on the value of another field Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=bbaetz, a=mkanat
2008-11-06Bug 458390: Foreign Key names can be too long as currently designedmkanat%bugzilla.org1-1/+18
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=ghendricks
2008-10-29Bug 427455: Add foreign key constraints for group_control_map, ↵lpsolit%gmail.com1-6/+24
user_group_map and group_group_map tables - Patch by Tony Fu <tfu@redhat.com> r/a=mkanat
2008-10-25Bug 291433: Ability to have custom fields whose visibility depends on the ↵mkanat%bugzilla.org1-0/+4
values of other fields Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=bbaetz, a=mkanat
2008-07-29Bug 431669: The "product_id" column is incorrectly defined in the ↵lpsolit%gmail.com1-1/+1
"group_control_map" DB table - Patch by Tony Fu <tfu@redhat.com> r=LpSolit a=mkanat
2008-06-29Bug 429804: Add Foreign Keys to Multiselect fieldsmkanat%bugzilla.org1-0/+1
Patch By Alex Eiser <aeiser@arc.nasa.gov> r=mkanat, a=mkanat
2008-06-29Bugs 427449, 427452, 427461, 427471, 427477, and 427478:mkanat%bugzilla.org1-16/+64
Add foreign keys to the versions, milestones, component_cc, bug_group_map, namedquery_group_map, category_group_map, components, series, series_data, quips, and setting_value tables Patches By Tony Fu <tfu@redhat.com> r=mkanat (r=gerv for series stuff), a=mkanat
2008-06-26Bug 423598: Add foreign key constraints for keywords tablemkanat%bugzilla.org1-2/+9
Patch By Tony Fu <tfu@redhat.com> r=mkanat, a=mkanat
2008-05-21Bug 414779, Bug 419782, Bug 422037, Bug 423363, Bug 423369, Bug 423372, Bug ↵mkanat%bugzilla.org1-24/+91
423593, Bug 426688, and Bug 427445: Add foreign key constraints to various tables: bugs_activity, cc, dependencies, votes, attachments, attach_data, duplicates, flags, flagtypes, flagexclusions, flaginclusions Patches By Tony Fu <tfu@redhat.com> r=mkanat, a=mkanat
2008-05-08Bug 414292: [Oracle] Change series.query back to MEDIUMTEXTmkanat%bugzilla.org1-1/+1
Patch By Xiaoou Wu <xiaoou.wu@oracle.com> r=mkanat, a=mkanat
2008-03-25Bug 399370: Fulltext search with a LIKE on bugs.short_desc is too slow (make ↵mkanat%bugzilla.org1-2/+23
Bugzilla use a separate fulltext table) Patch By Max Kanat-Alexander <mkanat@bugzilla.org> (module owner) a=mkanat
2008-01-09Bug 411486: Oracle fails to add a new custom field - Patch by Xiaoou ↵lpsolit%gmail.com1-1/+1
<xiaoou.wu@oracle.com> r/a=mkanat