summaryrefslogtreecommitdiffstats
path: root/Bugzilla/DB/Schema.pm
AgeCommit message (Collapse)AuthorFilesLines
2013-02-18Bug 824346 - The flaginclusions and flagexclusions DB tables have no UNIQUE ↵Dave Lawrence1-4/+4
index r/a=LpSolit
2012-10-09merged with bugzilla/4.2Dave Lawrence1-0/+5
2012-09-14Update POD to fix bustage in Perl 5.16.1Frédéric Buclin1-0/+5
r=runtests.pl
2012-08-03Bug 756953 - Dependencies table should have unique index so that duplicate ↵Dave Lawrence1-1/+2
entries are blocked r/a=LpSolit
2012-07-25Bug 776972 - Increase bugs_activity primary key size to INTSERIAL for future ↵Dave Lawrence1-3/+3
growth r/a=LpSolit
2012-07-23Bug 764466 - Add a primary key to the profiles_activity tableDave Lawrence1-0/+2
r=glob, a=LpSolit
2012-07-23Bug 764457 - Add a primary key to the bugs_activity tableDave Lawrence1-0/+2
r=glob, a=LpSolit
2012-06-26Bug 762288 - Change bugs_activity.removed to match data type of ↵Dave Lawrence1-1/+2
bugs_activity.added r/a=LpSolit
2012-04-18Bug 746547: SMALLSERIAL is of type INT2, not INT1Frédéric Buclin1-1/+1
r=timello a=LpSolit
2012-02-15Bug 722113: The profile_search table has a wrong index nameFrédéric Buclin1-1/+1
r=glob a=LpSolit
2012-01-12Bug 715731 - profile_search.user_id should have a FK pointing to profiles.useridDave Lawrence1-1/+4
r/a=LpSolit
2011-12-19Bug 711925: Update from 4.0 or older to 4.2 or trunk fails when bug_see_also ↵Frédéric Buclin1-1/+1
field is populated r=wicked a=LpSolit
2011-12-16Last Comment Bug 685611 - delta_ts is updated even when no changes are made ↵Dave Lawrence1-1/+2
to bugs created via WebServices r/a=LpSolit
2011-10-23Bug 690173: Cannot delete user accounts due to FK on audit_logmiketosh1-1/+2
r/a=mkanat
2011-08-29Bug 637648 - Rename the "tags" table to "tag"Stephanie Daugherty1-3/+3
r=LpSolit, a=LpSolit
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-11Bug 620827: Refactor remove see also to use remove_from_db instead.Tiago Mello1-0/+1
r/a=mkanat
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-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-15Bug 619016: Make SQLite installations able to alter an existing schema,Max Kanat-Alexander1-19/+34
meaning that SQLite installations can now upgrade and add custom fields. r=mkanat, a=mkanat (module owner)
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-Alexander1-13/+22
r=LpSolit, 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-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-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-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