aboutsummaryrefslogtreecommitdiffstats
path: root/maintenance/postgres/archives
Commit message (Collapse)AuthorAgeFilesLines
...
* Remove ExternalUser authentication codeChad Horohoe2013-04-041-6/+0
| | | | | | | | | | | | | This was an experimental authentication system intoduced a couple of years ago with a pretty narrow use-case. It's been pretty much ignored since introduction, and makes login more complicated than it needs to be. I didn't drop the external_user table on the off-chance someone out there actually has data in it, but they should use AuthPlugin for their external authentication needs. Change-Id: I794338dbb75961ee033d41fa44bb7aa22e54f447
* (bug 36400) API: Fix sorting for iwlinks, langlinksBrad Jorsch2013-04-032-8/+1
| | | | | | | | | | | | | | | | | The iwlinks and langlinks modules continue parameters imply ordering by page then prefix then title. But in certain modes, the actual queries use a different ordering, which may result in skipped or repeated results. This changeset fixes that. To do so, it needs to re-add an index iwl_prefix_from_title which was mistakenly removed in 2010 (r69721). And while it's doing that, it cleans up errors in the sqlite and postgresql handling of the iwlinks indexes too. Also, per Asher, make the iwl_prefix_from_title and iwl_prefix_title_from indexes non-UNIQUE. Change-Id: I607e8bf9183a2d8152a6127a81c83a0b5bba0c61
* Include Postgres tables and maintenance scripts for Change I23c47c2cBrent Garber2013-02-011-0/+31
| | | | Change-Id: I1b2fe2b80700678935bf6d28c3a48538d044d3f4
* Bug 42039 - Fix some file-related issues in the distributionMarkAHershberger2012-11-121-0/+0
| | | | | | | | | | Minor issues. Tested the removal of maintenance/postgres/archives/patch-ipb_address_unique.sql in a new installation but haven't tested it on an upgrade. Change-Id: I58aa11c5acab5de427cbc000e6786a208fc6b26f
* Back out config table and related codeReedy2012-10-291-5/+0
| | | | Change-Id: I4fa180d45984a4ec2b2c7b1149015c6dad14c5f0
* Remove a bunch of trailing spaces and unneeded newlinesumherirrender2012-10-201-1/+1
| | | | Change-Id: I52ae3c55044bc8c53698e356bad74969406670bf
* Fix broken merge by 0a792a1dcba26dd70d64e307b301c6saper2012-04-131-8/+0
| | | | | | | | | | | | | | | | | | | | Changeset 1 of https://gerrit.wikimedia.org/r/#change,3365: 763b57f9f2af131a2d8e65f520a23c00109be0e1 got mis-merged in changeset 2: f752cf80423615b380cf5612a3f1f68a6b9d0173 And introduced into master wth 0a792a1dcba26dd70d64e307b301c6773279cfc9 Also, marking all new functions as @since 1.19 since we want to have them there later. Patchset 2: whitespace fixes Patchset 3: Fix <?php Patchset 4: rebase to current master Change-Id: Ic7d940dfec8890de20197128505962375fac4f06
* Fix PostgreSQL updater to produce 1.19 schemasaper2012-04-108-7/+34
| | | | | | | | | | | | | | | | | | | | * PostgresField now reports column default value * DatabasePostgres::indexAttributes reports index details * Perform schema update in one transaction With this change we can sucessfully update MediaWiki 1.7.3 schema to trunk^Wmaster Patch set 2: Rebased against master. PLEASE check carefully to make sure I got those conflicted files right. Conflicts: includes/db/DatabasePostgres.php includes/installer/PostgresUpdater.php Change-Id: Iebb6855e8f6f44470bbb1dc5ab9ac1abb513adfe
* Postgres updater: add config table, adjust us_image_bits typeDemon2012-04-041-0/+5
| | | | | | This is a followup to I18e67bcb, that I failed to notice before merging Change-Id: Ia96f831f279b0f6a348f1db80ecf30298ecf064c
* Followup to r103365, actually include said patch fileOverlordQ2011-11-161-0/+2
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/103367
* Followup to r100640, use correct name scheme for sequence, correct ↵OverlordQ2011-11-161-2/+2
| | | | | | | references to sequence and add optional patch file for sites following trunk Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/103365
* Update Postgres with missing uploadstash tablesOverlordQ2011-10-241-0/+24
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/100640
* Follow-up r90749:Aaron Schulz2011-06-251-1/+1
| | | | | | | | * Removed useless ufg_group index from user_former_groups * Index name consistency Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/90753
* Added one-time promote support via Autopromote::autopromoteOnceHook ↵Aaron Schulz2011-06-251-0/+5
| | | | | | | function. This is still a bit rough on the edges. This uses a hook since extension may want to control when it's called for performance reasons. Patch by lampak. (for bug 24948) Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/90749
* Don't put multiple tables in the same file.Greg Sabino Mullane2010-12-303-22/+17
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/79283
* * Commit changes to PG new-installer I thought I had done last week.Mark A. Hershberger2010-12-012-2/+0
| | | | | | | | | * Set up and use function for renaming tables * Use $conn instead of $this when it is called for * remove protection from commitChanges so the installer can use it Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/77533
* Moved testRunner[|.ora|.postgres].sql to [|oracle/|postgres/]archives/ so ↵Alexandre Emsenhuber2010-11-091-0/+30
| | | | | | | that they can be called through DatabaseBase::patchPath(), much simplier Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/76397
* Add the "page" table back in when upgrading from really old MW versions ↵Greg Sabino Mullane2010-09-131-0/+24
| | | | | | | using Postgres Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/72898
* Followup to r72349, PG table def + updater for module_depsOverlordQ2010-09-041-0/+7
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/72351
* Followup to r72349, PG tables + updaterOverlordQ2010-09-042-0/+14
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/72350
* Fix sequence renaming to be backwards-compat with older versions of PG. ↵OverlordQ2010-09-031-7/+7
| | | | | | | Needs merged with 1.16 Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/72314
* Followup to r69961, update PG schemaOverlordQ2010-07-281-1/+1
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/70065
* Followup to r69817, r69810 add PG patch file, defaults to cl_type of PAGE.OverlordQ2010-07-241-0/+8
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/69852
* Rename the iwl_prefix_from_title index (again) to iwl_prefix_title_from and ↵Roan Kattouw2010-07-224-2/+16
| | | | | | | change the field order accordingly. Fixed r66892 which inserted iwl_from into the index (which was a good thing) but put it in the wrong place. I went out of my way to make sure the index isn't dropped and recreated needlessly, but since I don't know how to do the drop-index-if-exists thing in the Postgres updater, I left that out. The Postgres updater will now create the new index without dropping any old incarnations if present. I did create the patch files with the DROP INDEX statements to make it easier to add this behavior. Also tweak ApiQueryIWBacklinks to use this index properly. Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/69721
* Attempt at changing postgres as per r66892Sam Reed2010-05-251-0/+2
| | | | | | | OverlordQ or someone, can you review please? Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/66898
* Kill last vestiges of mediawiki_version. Nobody actually uses it anymore, it ↵Chad Horohoe2010-04-261-18/+0
| | | | | | | just gets silently updated (and only for Postgres at that) Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/65542
* Followup to r65104, PG updater/table defOverlordQ2010-04-161-0/+8
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/65105
* Some reason had each each update in there twiceOverlordQ2009-12-211-20/+0
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/60262
* Followup to r58263: forgot patch fileOverlordQ2009-10-281-0/+40
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/58268
* (bug 19428) PG and MySQL followups to r52503. Patch by OverlordQChad Horohoe2009-07-011-0/+8
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/52618
* Follow-up r50567: also update PostgreSQL and SQLite schemaAlexandre Emsenhuber2009-05-151-0/+9
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/50625
* Follow-up to r49803: use proper type and add an explicit foreign key ↵Brion Vibber2009-04-281-1/+1
| | | | | | | reference for up_user->user_id as we have for other tables in the postgresql schema Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/50011
* Follow-up r49790: update the PostgreSQL schemaAlexandre Emsenhuber2009-04-241-0/+8
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/49803
* Update Postgres schema per r46460Alexandre Emsenhuber2009-02-051-0/+28
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/46875
* Quick fix to index dropping, without using IF EXISTS clause, per bug #15896Greg Sabino Mullane2008-10-101-1/+0
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/41944
* Fixed bug 15148, total breakage of Special:BlockIP on PostgreSQL:Tim Starling2008-09-061-0/+2
| | | | | | | | | | | | * Migrated to a unique index for IP block conflict detection, like we did for MySQL some aeons ago. * Modified DatabasePostgres to return a correct affected row count for INSERT IGNORE. Tested for single and multi. * Fixed an unrelated bug: duplicate index rc_timestamp in tables.sql * Tested for install and upgrade on PG 8.3. No changelog because I'll backport it to 1.13. Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/40515
* Hold back $wgTrackLinkChanges for a little bit; reverting r37322, 37430, ↵Brion Vibber2008-07-101-12/+0
| | | | | | | | | 37432, 37435. Even disabled, it's started interfering with regular tasks like running the parser tests. Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/37542
* Add recentlinkchanges table for PostgresGreg Sabino Mullane2008-07-091-0/+12
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/37432
* Wrong index, should be unique. Thanks Simmetrical.Greg Sabino Mullane2008-03-191-1/+2
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/32177
* Add 'category' table to Postgres schema.Greg Sabino Mullane2008-03-191-0/+14
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/32171
* Add updatelog table.Greg Sabino Mullane2008-03-181-0/+4
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/32087
* Add table page_props to Postgres schema.Greg Sabino Mullane2008-02-211-0/+9
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/31163
* Remove no longer used patch files.Greg Sabino Mullane2008-02-194-27/+0
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/31084
* Have update.php change the functions to their new builtin tsearch2 versions ↵Greg Sabino Mullane2008-02-191-0/+29
| | | | | | | if Postgres >= 8.3 Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/31083
* Yet more cleanup of the protected_titles stuff.Greg Sabino Mullane2007-12-161-3/+2
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/28574
* Add protected_titles table.Greg Sabino Mullane2007-12-161-0/+11
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/28541
* Add the Postgres slash search fix to existing installations.Greg Sabino Mullane2007-09-061-0/+13
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/25593
* Various updates to Postgres schema and updater.Greg Sabino Mullane2007-07-271-1/+0
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/24405
* Postgres: make sure ar_len is added when updating, alpha stuff in updaters.incGreg Sabino Mullane2007-03-181-0/+1
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/20549
* drop obsolete archive2 table; it doesn't work and Special:Delete/Undelete ↵River Tarnell2007-03-103-17/+3
| | | | | | | work fine without it Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/20314
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-02 13:27:22 +0000