summaryrefslogtreecommitdiffstats
path: root/Bugzilla/DB
AgeCommit message (Collapse)AuthorFilesLines
2011-07-31Bug 673702: Undefined get_add_fk_sql in Bugzilla/DB/Schema.pmBodo-Merle Sandor1-2/+2
r/a=mkanat
2011-07-05Bug 658929 - User autocomplete is very slow when there are lots of users in ↵David Lawrence1-0/+2
the profiles table r/a=mkanat
2011-06-07Bug 662406: Add the "id" column for bug_see_also to Schema.pm.Max Kanat-Alexander1-0/+2
r=mkanat, a=mkanat (module owner)
2011-03-14Bug 622943: Simple auditing of changes to Bugzilla::Object subclass objectsMax Kanat-Alexander1-0/+17
r=dkl, a=mkanat
2011-02-14Remove tabs and fix some formatting in Bugzilla::DB::Pg.Max Kanat-Alexander1-4/+4
https://bugzilla.mozilla.org/show_bug.cgi?id=616981
2011-02-14Bug 616981: Make whine.pl work with PostgreSQL 8.4+ by fixing sql_string_untilSam Morris1-0/+12
r=mkanat, a=mkanat
2011-02-14Bug 603127: Make checksetup.pl require DBD::Pg 2.17.2 when using Pg 9.0 orMax Kanat-Alexander2-0/+25
later. r=dkl, a=mkanat
2011-02-11Bug 620827: Refactor remove see also to use remove_from_db instead.Tiago Mello1-0/+1
r/a=mkanat
2011-02-02Bug 630681: Implement a MOD function for SQLite so collectstats.pl can runMax Kanat-Alexander1-0/+3
r=mkanat, a=mkanat (module owner)
2011-01-30Bug 616185: Move tags (aka lists of bugs) to their own DB tablesFrédéric Buclin1-1/+30
r/a=mkanat
2011-01-15Bug 625190: Typo and Missing FK in Bugzilla::DB::SchemaDavid Marshall1-3/+6
r/a=mkanat
2010-12-16Bug 619581: Make contrib/bzdbcopy.pl work again, and also make it work withMax Kanat-Alexander1-1/+15
SQLite. r=mkanat, a=mkanat
2010-12-16Checkin fix for bug 619016: "DEFAULT TRUE" and "DEFAULT FALSE" were no longerMax Kanat-Alexander1-7/+11
getting properly translated to 1 and 0 inside of _set_nulls_sql in Bugzilla::DB::Schema.
2010-12-15Additional fix for bug 619016: The FK adding/removing code for SQLite didn'tMax Kanat-Alexander1-9/+26
work when it was modifying tables to have their first FK or removing all the FKs on a table. r=mkanat, a=mkanat (module owner)
2010-12-15Bug 619016: Make SQLite installations able to alter an existing schema,Max Kanat-Alexander2-20/+218
meaning that SQLite installations can now upgrade and add custom fields. r=mkanat, a=mkanat (module owner)
2010-11-14Bug 611974: collectstats.pl --regenerate fails with PostgreSQL 8.4.x ↵Sam Morris1-1/+1
(sql_from_days() doesn't accept integers as argument) r/a=LpSolit
2010-11-03The changes to bz_create_database done by the SQLite patch broke theMax Kanat-Alexander1-0/+9
creation of databases on other systems. This restores the original behavior while still retaining the correct error-throwing behavior for systems that can't create a SQLite database. https://bugzilla.mozilla.org/show_bug.cgi?id=337776
2010-10-29Bug 602456: Make Search.pm not quote numeric input for numeric fieldsMax Kanat-Alexander1-0/+2
when generating SQL. r=glob, a=mkanat
2010-10-27Bug 337776: Basic SQLite Support for BugzillaMax Kanat-Alexander3-13/+363
r=LpSolit, a=mkanat
2010-10-20Bug 605663: For MySQL, use information_schema instead of SHOW TABLE STATUSMax Kanat-Alexander1-53/+23
to get table information during checksetup, because it's much faster. This also bumps our MySQL requirement to 5.0.15. r=mkanat, a=mkanat (module owner)
2010-10-16Minor improvement for bug 451735Frédéric Buclin1-1/+1
r=mkanat
2010-10-15Bug 451735 part2: fix bz_drop_index() so that it first drops related FKs ↵Frédéric Buclin1-0/+16
before deleting the index itself r/a=mkanat
2010-10-14Bug 451735: Wrong index for the series tableFrédéric Buclin1-3/+3
r/a=mkanat
2010-10-14Bug 505165: The flags.setter_id DB column cannot be NULLFrédéric Buclin1-1/+1
r/a=mkanat
2010-10-07Bug 602165: Change sql_interval to sql_date_math, in preparation forMax Kanat-Alexander3-10/+12
MS-SQL and SQLite support.
2010-08-31Bug 77193 - Add the ability to retire (disable) old versions, components and ↵Dave Lawrence1-0/+6
milestones r/a=mkanat
2010-08-27Bug 479400: Add the ability to show or hide particular custom fieldsTiago Mello1-1/+19
based on multiple values of another field (visibility controllers) r/a=mkanat
2010-08-11Bug 586210: Make every important string printed by checksetup.pl localizable,Max Kanat-Alexander1-46/+8
including the localconfig parameter descriptions r=mkanat, a=mkanat (module owner)
2010-07-18Bug 119703: Create an attachment by pasting it into a text fieldFrédéric Buclin1-2/+0
r/a=mkanat
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