summaryrefslogtreecommitdiffstats
path: root/Bugzilla/DB
AgeCommit message (Collapse)AuthorFilesLines
2010-07-15Bug 578739: Instead of removing REFERENCES from _bz_real_schema and thenMax Kanat-Alexander3-13/+47
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-14Bug 578587: Make checksetup be way quieter when creating a new installMax Kanat-Alexander1-2/+3
r=mkanat, a=mkanat (module owner)
2010-07-13Bug 578197: [PostgreSQL] When associating sequences with columns, alsoMax Kanat-Alexander1-0/+6
fix the default of the columns so that it's identical to what a new checksetup run would create. r=mkanat, a=mkanat (module owner)
2010-07-13Bug 578197: [PostgreSQL] Properly associate sequences that had noMax Kanat-Alexander1-0/+21
column association r=mkanat, a=mkanat (module owner)
2010-07-10Bug 451219: Allow altering from one SERIAL type to another on PostgreSQL,Max Kanat-Alexander1-1/+2
for people upgrading Testopia from 1.3 to 2.0+. r=mkanat, a=mkanat (module owner)
2010-07-10Bug 577793: Improve the Pg SERIAL-altering code now that we require 8.3Max Kanat-Alexander1-10/+8
r=mkanat, a=mkanat (module owner)
2010-07-09Bug 577569: [PostgreSQL] Make sql_position explicitly cast both its argumentsMax Kanat-Alexander1-1/+1
to text, to avoid an error when searching "longdescs.isprivate" with the "casesubstring" operator in Search.pm. r=mkanat, a=mkanat (module owner)
2010-07-07Bug 552919: Sort group_concat results so that they sort correctly for buglistsMax Kanat-Alexander3-9/+31
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-22The DB::Schema alter_column default fix also needed to be separatelyMax Kanat-Alexander1-2/+5
applied to DB::Schema::Oracle, since it has a full override of get_alter_column_ddl. https://bugzilla.mozilla.org/show_bug.cgi?id=573441
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-22Bug 22353: Automatic duplicate bug detection on enter_bug.cgiMax Kanat-Alexander2-6/+4
r=glob, 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-Alexander2-33/+56
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-27Bug 561322: Make Bugzilla::DB::_connect and related functions take theirMax Kanat-Alexander3-6/+15
parameters as a hashref, to improve the API and to avoid exposing the database password on error. r=mkanat, a=mkanat (module owner)
2010-04-22Bug 560009: Use firstidx from List::MoreUtils instead of lsearchMax Kanat-Alexander1-3/+4
r=timello, a=mkanat
2010-04-22Add a comment above BOOLEAN_MAP to make it crystal clear that it doesMax Kanat-Alexander1-0/+3
not now need to be updated.
2010-04-20Bug 560284: Make all errors that checksetup.pl throws be redMax Kanat-Alexander1-2/+1
r=mkanat, a=mkanat (module owner)
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-03-02Bug 541553: [Oracle] Drop triggers when dropping columns, and drop theXiaoou Wu2-0/+24
left-behind PRODUCTS_MILESTONEURL trigger that currently exists in 3.6/trunk. r=mkanat, 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
2010-02-01Bug 538705: Assure that Bugzilla->dbh doesn't become invalid under MySQL ↵Max Kanat-Alexander1-2/+6
during long jobqueue.pl runs. Patch by Max Kanat-Alexander <mkanat@bugzilla.org> r=LpSolit, a=mkanat
2010-02-01Bug 533363: [PostgreSQL] Using "Bug ID contains foo" in boolean charts or ↵Frédéric Buclin1-2/+14
"Exclude bug numbered" charts crash PostgreSQL 8.3 and newer (non-character data types are no longer automatically cast to TEXT) Patch by Frédéric Buclin <LpSolit@gmail.com> r/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 505826: Allow boolean searches on the Comment field in Oracle.mkanat%bugzilla.org1-0/+4
Patch by Xiaoou Wu <xiaoou.wu@oracle.com> r=mkanat, a=mkanat
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-24Bug 519584: Implement a framework for migrating from other bug-trackers, and ↵mkanat%bugzilla.org3-0/+20
start with a GNATS importer. 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-21Bug 516157: MySQL 6.x/5.2/5.4 uses "ENGINE", not "TYPE", for altering tables ↵mkanat%bugzilla.org1-1/+1
to InnoDB Patch by Gerard J. Cerchio <gjpc@circlesoft.com> r=mkanat, 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-09-03Bug 513585: Don't trigger utf8 conversion just because there are VIEWs ↵justdave%bugzilla.org1-3/+4
present in the database. r=mkanat, a=mkanat
2009-08-18Bug 507969: Speed up checksetup for cases when it's doing nothingmkanat%bugzilla.org1-13/+12
Patch by Max Kanat-Alexander <mkanat@bugzilla.org> r=LpSolit, a=mkanat
2009-08-17Bug 509497: Implement sql_group_concat for all databasesmkanat%bugzilla.org2-0/+112
Patch by Max Kanat-Alexander <mkanat@bugzilla.org> r=LpSolit, a=mkanat Patch by Xiaoou Wu <xiaoou.wu@oracle.com> r=mkanat, a=mkanat
2009-08-07The original patch for bug 508186 actually broke utf-8 conversion--the ↵mkanat%bugzilla.org1-3/+7
tables were converted, but the columns were not. This fixes it.
2009-08-06Bug 508186: Speed up UTF-8 table conversion in checksetupmkanat%bugzilla.org1-32/+28
Patch by Max Kanat-Alexander <mkanat@bugzilla.org> (module owner) a=mkanat
2009-08-06Bug 508181: UTF-8 table conversion was failing when there were FKs on the ↵mkanat%bugzilla.org1-1/+9
column or on related columns Patch by Max Kanat-Alexander <mkanat@bugzilla.org> r=LpSolit, a=mkanat
2009-08-03Additional fix for bug 508023, to make upgrades from 3.1.4 succeed.mkanat%bugzilla.org1-3/+5