summaryrefslogtreecommitdiffstats
path: root/Bugzilla/DB/Schema
AgeCommit message (Collapse)AuthorFilesLines
2012-08-30Bug 731156: [Oracle] Adding or removing a DB column does not handle SERIAL ↵Frédéric Buclin1-16/+48
correctly r=dkl a=LpSolit
2012-08-21Bug 783786: PostgreSQL databases can be created with the wrong encodingFrédéric Buclin1-0/+10
r=dkl a=LpSolit
2012-01-24Bug 715870: [Oracle] Related sequences and triggers must be removed when ↵Frédéric Buclin1-1/+19
dropping a table r=mkanat a=LpSolit
2011-12-26Bug 683644: Foreign keys aren't renamed correctly when DB tables are renamedFrédéric Buclin2-20/+70
r=wicked a=LpSolit
2011-08-30Bug 629529: Make SQLite installs able to use jobqueue.plMax Kanat-Alexander1-0/+17
r=glob, a=mkanat
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-Alexander1-1/+184
meaning that SQLite installations can now upgrade and add custom fields. r=mkanat, a=mkanat (module owner)
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-27Bug 337776: Basic SQLite Support for BugzillaMax Kanat-Alexander1-0/+86
r=LpSolit, a=mkanat
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-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-01Bug 569312: Speed up the adding of many FKs to the same table for MySQLMax Kanat-Alexander1-29/+34
and PostgreSQL, by adding them all in one ALTER statement r=mkanat, a=mkanat (module owner)
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-03-02Bug 541553: [Oracle] Drop triggers when dropping columns, and drop theXiaoou Wu1-0/+16
left-behind PRODUCTS_MILESTONEURL trigger that currently exists in 3.6/trunk. r=mkanat, 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-08-03Additional fix for bug 508023, to make upgrades from 3.1.4 succeed.mkanat%bugzilla.org1-3/+5
2009-08-03Bug 508023: Speed up MySQL's bz_alter_column for when we're just adding or ↵mkanat%bugzilla.org1-2/+22
removing a DEFAULT Patch by Max Kanat-Alexander <mkanat@bugzilla.org> (module owner) a=mkanat
2009-06-29Bug 500350: [Oracle] Use of uninitialized value in pattern match (m//) at ↵lpsolit%gmail.com1-1/+1
Bugzilla/DB/Schema/Oracle.pm line 149 - Patch by Xiaoou <xiaoou.wu@oracle.com> r/a=mkanat
2009-04-04Bug 486239: [Oracle] Missing keyword RESTRICT on fk creation (DB::Schema ↵mkanat%bugzilla.org1-0/+3
explicitly specified DELETE => 'RESTRICT') Patch by Xiaoou Wu <xiaoou.wu@oracle.com> and Max Kanat-Alexander <mkanat@bugzilla.org> r=mkanat
2009-01-05Bug 472013: [Oracle] checksetup.pl fails with ORA-04091 and you can't change ↵lpsolit%gmail.com1-1/+1
the properties of custom fields - Patch by Xiaoou <xiaoou.wu@oracle.com> r/a=mkanat
2008-11-06Bug 458390: Foreign Key names can be too long as currently designedmkanat%bugzilla.org1-9/+8
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=ghendricks
2008-08-01Bug 448241: [Oracle] Foreign keys: UPDATE CASCADE trigger updates wrong ↵mkanat%bugzilla.org1-4/+4
tables and fields Patch By Xiaoou Wu <xiaoou.wu@oracle.com> r=mkanat, a=mkanat
2008-08-01Bug 448614: [Oracle] Logic error in _get_alter_type_sqlmkanat%bugzilla.org1-1/+1
Patch By Xiaoou Wu <xiaoou.wu@oracle.com> r=mkanat, a=mkanat
2008-05-08Bug 432726: [Oracle] DROP INDEX doesn't hash the index namemkanat%bugzilla.org1-3/+15
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> (module owner) a=mkanat
2008-05-08Bug 419581: [Oracle] Enable ALTER COLUMN for Oraclemkanat%bugzilla.org1-0/+169
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-1/+1
Bugzilla use a separate fulltext table) Patch By Max Kanat-Alexander <mkanat@bugzilla.org> (module owner) a=mkanat
2007-12-13Bug 408032: [Oracle] Make bzdbcopy.pl work with Oraclemkanat%bugzilla.org2-11/+24
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> (module owner) a=mkanat
2007-12-11Fix Perl tinderbox bustage from Oracle checkin.mkanat%bugzilla.org1-1/+1
2007-12-11Bug 310717: [Oracle] Bugzilla::DB::Oracle modulemkanat%bugzilla.org1-0/+210
Bug 310718: [Oracle] Bugzilla::DB::Schema::Oracle module Patch By Xiaoou Wu <xiaoou.wu@oracle.com> r=mkanat, a=mkanat
2007-12-11Bug 153129: Bugzilla uses "mediumtext" as a DB data type when it's not necessarymkanat%bugzilla.org2-2/+3
Patch By Xiaoou Wu <xiaoou.wu@oracle.com> and Max Kanat-Alexander <mkanat@bugzilla.org> r=mkanat, a=mkanat
2007-04-15Bug 373869: Custom field names must be all lowercase or buglist.cgi sorting ↵justdave%bugzilla.org1-0/+15
throws an error Patch by mkanat and justdave r=LpSolit,mkanat; a=mkanat
2007-03-11Bug 373442: Add referential integrity against the profiles table in some ↵mkanat%bugzilla.org1-11/+0
more simple places Patch By Max Kanat-Alexander <mkanat@bugzilla.org> (module owner) a=mkanat
2007-03-10Bug 347439: Implement support for referential integrity in ↵mkanat%bugzilla.org1-0/+29
Bugzilla::DB::Schema and implement it on profiles_activity Patch By Max Kanat-Alexander <mkanat@bugzilla.org> (module owner) a=mkanat
2007-03-09Bug 347475: [MySQL] Use InnoDB for most tablesmkanat%bugzilla.org1-1/+4
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> (module owner) a=mkanat
2006-11-19Bug 304550: Bugzilla should always store data in MySQL as UTF-8mkanat%bugzilla.org1-1/+13
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=LpSolit, a=justdave
2006-11-01Bug 358956: [PostgreSQL] Sequences need to be renamed when their field is ↵mkanat%bugzilla.org1-2/+10
renamed Patch By Max Kanat-Alexander <mkanat@bugzilla.org> (module owner) a=myk
2006-09-18Bug 352967: [PostgreSQL] Changing a DB column type to "serial" is broken on ↵lpsolit%gmail.com1-1/+2
PostgreSQL 8.1 - Patch by Rémi Zara <remi_zara@mac.com> r=mkanat a=myk
2006-06-19Spelling in code comments patch: 'ddatetime' -> 'datetime'; patch by Vlad ↵vladd%bugzilla.org1-1/+1
Dascalu <vladd@bugzilla.org>.
2006-04-15Bug 329537: [PostgreSQL] Bugzilla::DB::Pg can't alter a column to be SERIAL ↵lpsolit%gmail.com1-49/+32
- Patch by Max Kanat-Alexander <mkanat@bugzilla.org> r=LpSolit a=justdave
2006-02-22Bug 328063: [PostgreSQL] Bugzilla::DB::Pg does not support adding a new ↵mkanat%kerio.com1-7/+23
SERIAL-type column to a table Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=LpSolit, a=justdave
2005-12-19Bug 310231: MySQL-specific get_alter_column_ddl will not drop primary keymkanat%kerio.com1-1/+14
Patch By Olav Vitters <bugzilla-mozilla@bkor.dhs.org> r=mkanat, a=justdave
2005-08-01Bug 301901: Index rename failure when renaming an index called PRIMARYmkanat%kerio.com1-0/+3
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=justdave, a=justdave
2005-06-15Bug 293501: Add me to files where I belong and fix kerio.com emailsmkanat%kerio.com2-0/+2
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=colin, a=myk
2005-05-17Bug 290677: Index rename time estimate is too short on large sitesmkanat%kerio.com1-0/+24
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=jouni, a=justdave
2005-04-23Bug 285722: Updates From 2.18- to 2.20+ will not workmkanat%kerio.com1-2/+9
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=Tomas.Kopal, a=justdave
2005-04-17Bug 290402: Functions to support reading-in a Schema object from the databasemkanat%kerio.com1-0/+168
Patch by Max Kanat-Alexander <mkanat@bugzilla.org> r=Tomas.Kopal, a=justdave
2005-04-15Bug 290405: bz_add_column needs a way to specify an initial valuemkanat%kerio.com1-3/+7
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=Tomas.Kopal, a=justdave
2005-04-15Bug 78276: change name of "when" index on bugs_activity.bug_when columnmkanat%kerio.com1-2/+2
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=myk, a=myk
2005-04-05Bug 286527: Cross-DB bz_rename_column and bz_drop_column (Part of Bug 285111)mkanat%kerio.com2-5/+21
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=Tomas.Kopal, a=myk