aboutsummaryrefslogtreecommitdiffstats
path: root/Bugzilla/DB
Commit message (Collapse)AuthorAgeFilesLines
* Bug 683644: Foreign keys aren't renamed correctly when DB tables are renamedFrédéric Buclin2011-12-264-28/+100
| | | | r=wicked a=LpSolit
* Bug 711925: Update from 4.0 or older to 4.2 or trunk fails when bug_see_also ↵Frédéric Buclin2011-12-191-1/+1
| | | | | | field is populated r=wicked a=LpSolit
* Bug 685611 - delta_ts is updated even when no changes are made to bugs ↵Dave Lawrence2011-12-161-1/+2
| | | | | | created via WebServices r/a=LpSolit
* Expand max length of attachment filename from 100 to 255 characters. r=glob, ↵Gervase Markham2011-12-081-1/+1
| | | | | a=LpSolit. https://bugzilla.mozilla.org/show_bug.cgi?id=705078
* Bug 550299: User fields are left blank in buglists and whines when local ↵Frédéric Buclin2011-12-053-25/+0
| | | | | | user accounts are used (i.e. they have no @company.com suffix) r/a=mkanat
* Bug 701350: Oracle crashes if the 'maxattachmentsize' parameter is set to a ↵Frédéric Buclin2011-12-051-2/+6
| | | | | | too small value r/a=mkanat
* Bug 690173: Cannot delete user accounts due to FK on audit_logmiketosh2011-10-231-1/+2
| | | | r/a=mkanat
* Bug 629529: Make SQLite installs able to use jobqueue.plMax Kanat-Alexander2011-08-292-0/+58
| | | | r=glob, a=mkanat
* Bug 637648 - Rename the "tags" table to "tag"Stephanie Daugherty2011-08-292-3/+7
| | | | r=LpSolit, a=LpSolit
* Bug 675603: Remove obsolete code from Bugzilla/DB/Oracle.pmFrédéric Buclin2011-08-171-11/+1
| | | | r=mkanat a=LpSolit
* Bug 654496: Duplicate bug detection doesn't work when using OracleFrédéric Buclin2011-08-161-1/+1
| | | | r/a=mkanat
* Bug 582209: Bugzilla::DB::Oracle::adjust_statement() LIMIT code corrupts ↵Frédéric Buclin2011-08-161-14/+11
| | | | | | sub-selects r/a=mkanat
* Bug 673702: Undefined get_add_fk_sql in Bugzilla/DB/Schema.pmBodo-Merle Sandor2011-07-311-2/+2
| | | | r/a=mkanat
* Bug 658929 - User autocomplete is very slow when there are lots of users in ↵David Lawrence2011-07-051-0/+2
| | | | | | the profiles table r/a=mkanat
* Bug 662406: Add the "id" column for bug_see_also to Schema.pm.Max Kanat-Alexander2011-06-061-0/+2
| | | | r=mkanat, a=mkanat (module owner)
* Bug 622943: Simple auditing of changes to Bugzilla::Object subclass objectsMax Kanat-Alexander2011-03-131-0/+17
| | | | r=dkl, a=mkanat
* Remove tabs and fix some formatting in Bugzilla::DB::Pg.Max Kanat-Alexander2011-02-141-4/+4
| | | https://bugzilla.mozilla.org/show_bug.cgi?id=616981
* Bug 616981: Make whine.pl work with PostgreSQL 8.4+ by fixing sql_string_untilSam Morris2011-02-141-0/+12
| | | | r=mkanat, a=mkanat
* Bug 603127: Make checksetup.pl require DBD::Pg 2.17.2 when using Pg 9.0 orMax Kanat-Alexander2011-02-142-0/+25
| | | | | later. r=dkl, a=mkanat
* Bug 620827: Refactor remove see also to use remove_from_db instead.Tiago Mello2011-02-101-0/+1
| | | | r/a=mkanat
* Bug 630681: Implement a MOD function for SQLite so collectstats.pl can runMax Kanat-Alexander2011-02-021-0/+3
| | | | r=mkanat, a=mkanat (module owner)
* Bug 616185: Move tags (aka lists of bugs) to their own DB tablesFrédéric Buclin2011-01-301-1/+30
| | | | r/a=mkanat
* Bug 625190: Typo and Missing FK in Bugzilla::DB::SchemaDavid Marshall2011-01-151-3/+6
| | | | r/a=mkanat
* Bug 619581: Make contrib/bzdbcopy.pl work again, and also make it work withMax Kanat-Alexander2010-12-151-1/+15
| | | | | SQLite. r=mkanat, a=mkanat
* Checkin fix for bug 619016: "DEFAULT TRUE" and "DEFAULT FALSE" were no longerMax Kanat-Alexander2010-12-151-7/+11
| | | | | getting properly translated to 1 and 0 inside of _set_nulls_sql in Bugzilla::DB::Schema.
* Additional fix for bug 619016: The FK adding/removing code for SQLite didn'tMax Kanat-Alexander2010-12-151-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)
* Bug 619016: Make SQLite installations able to alter an existing schema,Max Kanat-Alexander2010-12-152-20/+218
| | | | | meaning that SQLite installations can now upgrade and add custom fields. r=mkanat, a=mkanat (module owner)
* Bug 611974: collectstats.pl --regenerate fails with PostgreSQL 8.4.x ↵Sam Morris2010-11-141-1/+1
| | | | | | (sql_from_days() doesn't accept integers as argument) r/a=LpSolit
* The changes to bz_create_database done by the SQLite patch broke theMax Kanat-Alexander2010-11-021-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
* Bug 602456: Make Search.pm not quote numeric input for numeric fieldsMax Kanat-Alexander2010-10-281-0/+2
| | | | | when generating SQL. r=glob, a=mkanat
* Bug 337776: Basic SQLite Support for BugzillaMax Kanat-Alexander2010-10-273-13/+363
| | | | r=LpSolit, a=mkanat
* Bug 605663: For MySQL, use information_schema instead of SHOW TABLE STATUSMax Kanat-Alexander2010-10-191-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)
* Minor improvement for bug 451735Frédéric Buclin2010-10-161-1/+1
| | | | r=mkanat
* Bug 451735 part2: fix bz_drop_index() so that it first drops related FKs ↵Frédéric Buclin2010-10-151-0/+16
| | | | | | before deleting the index itself r/a=mkanat
* Bug 451735: Wrong index for the series tableFrédéric Buclin2010-10-141-3/+3
| | | | r/a=mkanat
* Bug 505165: The flags.setter_id DB column cannot be NULLFrédéric Buclin2010-10-141-1/+1
| | | | r/a=mkanat
* Bug 602165: Change sql_interval to sql_date_math, in preparation forMax Kanat-Alexander2010-10-073-10/+12
| | | | MS-SQL and SQLite support.
* Bug 77193 - Add the ability to retire (disable) old versions, components and ↵Dave Lawrence2010-08-311-0/+6
| | | | | | milestones r/a=mkanat
* Bug 479400: Add the ability to show or hide particular custom fieldsTiago Mello2010-08-271-1/+19
| | | | | based on multiple values of another field (visibility controllers) r/a=mkanat
* Bug 586210: Make every important string printed by checksetup.pl localizable,Max Kanat-Alexander2010-08-111-46/+8
| | | | | including the localconfig parameter descriptions r=mkanat, a=mkanat (module owner)
* Bug 119703: Create an attachment by pasting it into a text fieldFrédéric Buclin2010-07-181-2/+0
| | | | r/a=mkanat
* Bug 578739: Instead of removing REFERENCES from _bz_real_schema and thenMax Kanat-Alexander2010-07-143-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)
* Bug 578587: Make checksetup be way quieter when creating a new installMax Kanat-Alexander2010-07-141-2/+3
| | | | r=mkanat, a=mkanat (module owner)
* Bug 578197: [PostgreSQL] When associating sequences with columns, alsoMax Kanat-Alexander2010-07-121-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)
* Bug 578197: [PostgreSQL] Properly associate sequences that had noMax Kanat-Alexander2010-07-121-0/+21
| | | | | column association r=mkanat, a=mkanat (module owner)
* Bug 451219: Allow altering from one SERIAL type to another on PostgreSQL,Max Kanat-Alexander2010-07-091-1/+2
| | | | | for people upgrading Testopia from 1.3 to 2.0+. r=mkanat, a=mkanat (module owner)
* Bug 577793: Improve the Pg SERIAL-altering code now that we require 8.3Max Kanat-Alexander2010-07-091-10/+8
| | | | r=mkanat, a=mkanat (module owner)
* Bug 577569: [PostgreSQL] Make sql_position explicitly cast both its argumentsMax Kanat-Alexander2010-07-081-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)
* Bug 552919: Sort group_concat results so that they sort correctly for buglistsMax Kanat-Alexander2010-07-063-9/+31
| | | | r=mkanat, a=mkanat (module owner)
* Bug 486292: Change the default workflow to UNCONFIRMED, CONFIRMED,Max Kanat-Alexander2010-07-051-1/+1
| | | | | IN_PROGRESS, RESOLVED, VERIFIED. r=LpSolit, a=mkanat