aboutsummaryrefslogtreecommitdiffstats
path: root/maintenance/postgres
Commit message (Collapse)AuthorAgeFilesLines
...
* 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
* PostgreSQL schema: datatype updates, remove unused column, add tableGreg Sabino Mullane2012-04-042-8/+36
| | | | | | | | | | * More allowed data type conversions from MySQL to PostgreSQL * Allow for data type SMALLINT: seen for first time! * Handle CREATE TYPE: check for dupes, and allow the name as a valid data type. * Remove the now-deprecated user_options column. * Add new table "config" Change-Id: I18e67bcb131b88bfaea7e736f302dd79ebfc9b82
* Followup to r107866, add in new job_timestamp field which was likely ↵OverlordQ2012-01-121-0/+2
| | | | | | | completely breaking anything related to the job queue, should fix failing TemplateCategoriesTest.testTemplateCategories on PG Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/108769
* Followup to whatever revision added us_chunk_inxOverlordQ2012-01-121-0/+1
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/108730
* (bug 29475) Remove "trackback" feature entirely from core. This has been ↵Chad Horohoe2011-11-232-14/+0
| | | | | | | | | | | disabled-by-default since its inception and nobody uses it. If someone really really wants this, they can write an extension. Language files need rebuilding, but I took care of En and messages.inc. Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/104051
* 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-162-4/+4
| | | | | | | references to sequence and add optional patch file for sites following trunk Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/103365
* Followup to r101021, add back to Pg schema so we can install mediawikiOverlordQ2011-10-311-1/+3
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/101397
* Update Postgres with missing uploadstash tablesOverlordQ2011-10-242-0/+49
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/100640
* Follow-up r90749:Aaron Schulz2011-06-252-2/+2
| | | | | | | | * 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-252-0/+11
| | | | | | | 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
* Breaking the 'math' table setup out to Math extension. Should be the last ↵Brion Vibber2011-04-221-8/+0
| | | | | | | | | | | | | | main step in extension-ification of the math options! The 'math' table will no longer be created on a default install unless you've explicitly enabled the Math plugin at install time; the usual update.php procedure will add it in. Postgres, Oracle, MSSQL, and DB2 variants are included -- broken out from the core files -- but have not been tested. I know there has been some code duplication in parser test infrastructure but could only find one instance of the parser test temporary table setup to remove the 'math' table from (the extension adds it back via the hook). If the phpunit-based runner breaks, please track it down and fix it there too. Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/86741
* Apply patch from Karsten Düsterloh in Bug #28103.Mark A. Hershberger2011-04-221-11/+11
| | | | | | | | | | | | | | | | | Karsten writes: If the $table_prefix is not empty, several table renamings will happen, including for 'pagecontent' and 'mwuser'. This breaks the import into postgres, because - 'pagecontent' doesn't exist (temporarily renamed to 'text') - 'mwuser' won't exist later (temporarily renamed to 'mw_mwuser') Also, some sequence names are wrong. Furthermore, some of the generated ALTER statements lack the final semicolon The attached patch contains the changes I had to do to make this run. Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/86721
* Not sure I like the DROP stuff here, but let's exclude it from this script.Greg Sabino Mullane2011-02-141-1/+5
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/82097
* followup r13884 add CASCADE so that if the tables are created a secondMark A. Hershberger2011-02-051-14/+14
| | | | | | | time, errors aren't given. Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/81574
* Results of my work on new-installer and Pg.Mark A. Hershberger2011-02-031-5/+20
| | | | | | | | | * NOTE: this commit removes any semblence of tsearch compatibility with pre-8.3 PostgreSQL * Make new-installer work against PostgreSQL * Remove SearchPostgres.php's call to pg_fetch_result. I think this is the only one outside of the vestigtial old installer code. Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/81439
* Use text_pattern_ops for page_title, as some code uses 'anchor%' matching.Greg Sabino Mullane2011-01-191-6/+6
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/80571
* 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
* cl_sortkey now back down to varbinary(230). Glad PG doesn't have this issue.Greg Sabino Mullane2010-10-151-1/+1
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/74806
* Remove parserTests.inc checks, as testing is now done quite differently.Greg Sabino Mullane2010-10-051-44/+0
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/74307
* Add new index on pagelinkes(pl_title) per suggestion from bug 25111Greg Sabino Mullane2010-09-131-0/+1
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/72903
* 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
* Adjustments for new tables.Greg Sabino Mullane2010-09-081-0/+5
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/72572
* Add new tables.Greg Sabino Mullane2010-09-081-0/+21
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/72571
* 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
* Bump cl_collation from smallint to a textGreg Sabino Mullane2010-09-031-1/+1
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/72310
* Add in new categorylinks columns.Greg Sabino Mullane2010-08-311-4/+7
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/72026
* CREATE LANGUAGE belongs as part of the installer, not here.Greg Sabino Mullane2010-08-241-1/+0
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/71572
* Allow both single and double quotes for ENUM values (even though we should ↵Greg Sabino Mullane2010-08-241-1/+1
| | | | | | | standardize on one or the other) Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/71571
* OverloardQ or other PG person, please reviewMark A. Hershberger2010-08-171-0/+1
| | | | | | | These patches were necessary to get new-installer working on PG for me. I'm not sure about the ‘create lang' bits — they should maybe be in another step? Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/71189
* Add new partial index for PostgresGreg Sabino Mullane2010-08-041-0/+1
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/70459
* Minor adjustments for schema comparisonGreg Sabino Mullane2010-08-041-1/+2
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/70456
* Remove invalid commaGreg Sabino Mullane2010-08-041-1/+1
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/70455
* 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-225-3/+17
| | | | | | | 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
* Followup to r69580, did I mention MySQL sucks?OverlordQ2010-07-201-2/+2
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/69581
* Followup to r69542, since the new installer doesn't support PG, this is ↵OverlordQ2010-07-201-1/+3
| | | | | | | going into updaters.inc Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/69580
* Add ul_value to Postgres schema.Greg Sabino Mullane2010-07-082-1/+3
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/69189
* Add exception for iwl_prefixGreg Sabino Mullane2010-05-281-0/+1
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/67031
* Standardize the formatting.Greg Sabino Mullane2010-05-281-6/+6
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/67030
* Attempt at changing postgres as per r66892Sam Reed2010-05-252-1/+3
| | | | | | | 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-264-47/+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-162-0/+16
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/65105
* Make foreign key constraints DEFERRABLE INITIALLY DEFERRED when using ↵Greg Sabino Mullane2010-03-221-28/+28
| | | | | | | Postgres as the database backend Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/64032
* Adjust for minor_mimes now being 100 chars long in mysql schemaGreg Sabino Mullane2010-03-221-3/+3
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/64017
generated by cgit v1.2.3 (git 2.25.1) at 2025-04-24 16:40:57 +0000