aboutsummaryrefslogtreecommitdiffstats
path: root/maintenance/oracle
Commit message (Collapse)AuthorAgeFilesLines
...
* First version of Page Language selectorKunal Grover2014-06-272-1/+5
| | | | | | | | Special page PageLanguage to set the page language of a page. To enable the feature, set $wgPageLanguageUseDB to true and assign the 'pagelang' user right to a user group. Bug: 35489 Change-Id: I0f82b146fbe948f917c1c5d29f7469644d797e80
* Merge "Fix Oracle 1.23 missing patches (rebase)"jenkins-bot2014-05-094-5/+15
|\
| * Fix Oracle 1.23 missing patchesfreakolowsky2014-03-044-5/+15
| | | | | | | | | | | | | | | | | | | | | | (rebase) also fixed wrong definition of password expire filed DEFAULT was unnecessary and faulty (has to be before NULLABLE clause) and changed the null-user insert Change-Id: Ia91ed19bd4e3380f396ef895745dbd2014e1eb8b
* | Update formatting in maintenance/ (3/4)Siebrand Mazeland2014-04-231-11/+11
| | | | | | | | Change-Id: I4390c4ea12a6a626b0e6817b6446635116ca9fe3
* | Pass phpcs-strict on maintenance/oracle/Siebrand Mazeland2014-04-221-8/+12
|/ | | | Change-Id: I27b4de208d8d22f7f52817497e32ef9f008598e0
* Add Updater for Oraclecsteipp2014-03-031-0/+3
| | | | | Bug: 61015 Change-Id: I748d7531be90155d8b99472d3459e46ce4855f07
* Password Expirationcsteipp2014-02-201-1/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Add functionality to expire users' passwords: * Adds column to the user table to keep a password expiration * Adds $wgPasswordExpirationDays, which will force users to reset their passwords after a set number of days. By default, this set to false, so passwords never expire. * Adds a default grace period of 7 days, where if the user's password is expired, they can still login, but are encouraged to reset their password. * Adds hook 'LoginPasswordResetMessage' to update reset message, in case an extension wants to vary the message on a particular reset event. * Adds hook 'ResetPasswordExpiration' to allow extensions to change the expiration date when the user resets their password. E.g., if an extension wants to vary the expiration based on the user's group. If the user is in the grace period, they get a password reset form added to the login successful page. If an extension prevents showing the login successful page (like CentralAuth), it should be updated to show a password change form during the grace period. After the grace period, the user will not be able to login without changing their password. Also prevents a successful reset if the user is "changing" their password to their existing password. No passwords will expire by default. Sites will have to call User->expirePassword() from their own maintenance script to trigger a password reset for a user. Bug: 54997 Change-Id: I92a9fc63b409b182b1d7b48781d73fc7216f8061
* Add index on logging.log_user_textJackmcbarn2013-12-193-0/+10
| | | | | | | | | Fixing bug #54404 requires querying against logging.log_user_text, which is currently unindexed. Add an index, to prevent performance from being adversely affected by the fix. Bug: 54432 Change-Id: I6b2af65c75bbee57377cb1ec2e75ea41a5091f80
* Fixed spacingumherirrender2013-11-192-2/+2
| | | | | | | | | | | - Removed double spaces - Added space after if/switch/foreach - Removed space on elseif - Added space around parentheses - Added newline at end of file - Removed space before semicolon at end of line Change-Id: Id40b87e04786c6111e6686d7f7eea1e588bdf37d
* Fix Oracle installation SQLFreakolowsky2013-10-311-2/+2
| | | | | | | | | | | | | | | | The starting and minimal values of sequences on Oracle are both '1' by default. We want a user with id of 0 (used for anonymous edits), so these were both set to '0' and the user was inserted with its id being the next value in the sequence. However, due to some low level caching settings you can miss the first value in a sequence. It makes no difference to other sequences, but it does with this one, as it must be 0 to maintain foreign key validity. Therefore let's just set the sequence to default starting value of '1' and insert the user with hardcoded id=0. Bug: 38411 Change-Id: Ic9a17b92d6052fbdc24dd431726e4d82dbf48034
* Add archive, externallinks PKtisane2013-10-173-0/+16
| | | | | | | | | * New fields: ar_id, el_id. el_id is presently not used for anything, but will help with online schema changes. Bug: 15441 Bug: 39675 Change-Id: Ib6b0fc3736d173fa4ba7b786ecfc710b2f4711bb
* drop unused fields rc_moved_to_ns/rc_moved_to_titleJesús Martínez Novo2013-09-211-2/+0
| | | | | | | | | | Follow-up I68e8c0bb23f185c0f996a8905f6d437db3080aa1 Deleting those fields also from tables.sql definition for mssql, oracle and postgres Bug: 34960 Change-Id: I1867536c9161abed0b23428d3c840d16a05cba56
* Updated profiling table definition.freakolowsky2013-05-261-4/+5
| | | | Change-Id: I20e92f2bc9b57a9c06cbcdfd30370fedf3c0e2f7
* phpcs: More require/include is not a functionTimo Tijhof2013-05-211-1/+1
| | | | | | | | | | | | | Follows-up I1343872de7, Ia533aedf63 and I2df2f80b81. Also updated usage in text in documentation and the installer LocalSettingsGenerator. Most of them were handled by this regex: - find: (require|include|require_once|include_once)\s*\(\s*(.+?)\s*\)\s*;$ - replace: $1 $2; Change-Id: I6b38aad9a5149c9c43ce18bd8edbab14b8ce43fa
* phpcs: Fix WhiteSpace.LanguageConstructSpacing warningsTimo Tijhof2013-05-091-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | Squiz.WhiteSpace.LanguageConstructSpacing: Language constructs must be followed by a single space; expected "require_once expression" but found "require_once(expression)" It is a keyword (e.g. like `new`, `return` and `print`). As such the parentheses don't make sense. Per our code conventions, we use a space after keywords like these. We appeared to have an unwritten exception for `require` that doesn't make sense. About 60% of require/include usage was missing the space and/or had superfluous parentheses. It is as silly as print("foo") or return("foo"), it works because keywords have no significance for whitespace between it and the expression that follows, and since experessions can be wrapped in parentheses for clarity (e.g. when doing string concatenation or mathematical operations) the parenthesis before and after basiclaly just ignored. Change-Id: I2df2f80b8123714bea7e0771bf94b51ad5bb4b87
* Fixed spacing around parenthesis in languages/tests/maintenanceumherirrender2013-04-281-5/+5
| | | | Change-Id: Idd4299d17f1fcf98ab1d635484cb4e880f35ee24
* Fixed maintenance/tables.sql (typo i guess)freakolowsky2013-04-251-4/+4
| | | | Change-Id: Ib1e90f9bf1bd728d1a263d65f2f869abf2f6c294
* Fixed some spacing in maintenance folderumherirrender2013-04-181-1/+1
| | | | | | | Added spaces before if, foreach Added some braces for one line statements Change-Id: I9657f72996358f8c1c154cea1ea97970d973723c
* Remove ExternalUser authentication codeChad Horohoe2013-04-041-7/+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 11057 - Increase size of ug_group in user_groups tableReedy2013-01-024-5/+5
| | | | Change-Id: I79fd5c6e1566de3145ac39420da4fce77099745a
* * Oracle Schema update to latestfreakolowsky2012-12-316-2/+105
| | | | | | * fixed makeSelectOptions (bug 43533) Change-Id: Ib146a5073de18f2b20a22f34bd60222b230c9514
* Back out config table and related codeReedy2012-10-292-15/+0
| | | | Change-Id: I4fa180d45984a4ec2b2c7b1149015c6dad14c5f0
* Remove a bunch of trailing spaces and unneeded newlinesumherirrender2012-10-201-1/+1
| | | | Change-Id: I52ae3c55044bc8c53698e356bad74969406670bf
* * Oracle schema update: rc_moved, cat_hidden, ss_adminfreakolowsky2012-10-109-7/+37
| | | | | | * tables.sql + updater patches for *_content_(model|format) fieldswq Change-Id: Ifb0dfbcdf3da10cab2d71c2efa437ef4a878a1f8
* Improve documentation of maintenance scripts.Alexandre Emsenhuber2012-09-211-11/+12
| | | | Change-Id: Id86d06d3c22a69f7e378bf6e75b5c78ef8b47c51
* Use __DIR__ instead of dirname( __FILE__ )jeroendedauw2012-08-271-1/+1
| | | | | | We can now do this since we finally switched to PHP 5.3 for MW 1.20 and get rid of the silly dirname(__FILE__) stuff :) Change-Id: Id9b2c9cd2e678197aa81c78adced5d1d31ff57b1
* * oracle DB schema update to current (changes relevant to 1.19 will befreakolowsky2012-07-276-2/+35
| | | | | | | backported) * fixed an updater bug from 1.19 (will be backported) Change-Id: Iccc7a901fcc049656f0338b4a2e6aa3971694099
* (bug 5445) remove autoblocks when user is unblockedMarc A. Pelletier2012-05-031-1/+2
| | | | | | | | | | | | | | | | | Previously, whenever we blocked a user, its IP address would be autoblocked whenever he tries to edit a page. Thus when later unblocking the username, he would be automatically blocked again if we forgot to clean up is IP. This patch introduces a the ipb_parent_block_id column in ipblocks table to track which block triggered the autoblock command. Thus, when deleting the original block we can easily remove all subsequentautoblocks. Schema updaters for MySQL, SQLite and postgres have been added to the patch but not for the other database types such as ibm_db2, mssql and Oracle. Change-Id: I4aa820ae9bbd962a12d0b48b6c638a1b6ff4efc9
* * Oracle schema update to latest (tested with phpunit)Jure Kajzer2012-01-244-0/+15
| | | | | | | * Fixed a message typo in DatabaseUpdater Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/109909
* * removed manual cascading of recentchanges on page deleteJure Kajzer2011-12-202-1/+6
| | | | | | | | | * fixed purgeCache bug in updater * TESTED install/update from 1.18/phpunit Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/106806
* (bug 29475) Remove "trackback" feature entirely from core. This has been ↵Chad Horohoe2011-11-232-13/+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
* * (bug 32470) Increase the length of ug_groupSam Reed2011-11-191-0/+3
| | | | | | | Postgres doesn't need extending... Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/103685
* Global tables diedSam Reed2011-11-194-63/+5
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/103683
* * applyed the patch from bug 26393 (please comment on the bug page)Jure Kajzer2011-11-112-0/+5
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/102785
* * phpunit fixes & optimizations for oracle backendJure Kajzer2011-11-092-8/+13
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/102523
* * fixed ipblocks.ipb_by_text field, removed default blank not null (fixed ↵Jure Kajzer2011-11-042-1/+4
| | | | | | | | | | install&update) * fixed Block->insert; ipblocks.ipb_id is autoincrement field (should use sequences for compatibility) Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/101976
* * fixed a typo in oracle/tables.sqlJure Kajzer2011-11-043-6/+11
| | | | | | | | * readded the sha1 fields (installer & upgrader) Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/101968
* * updated oracle schema to currentJure Kajzer2011-09-018-1/+132
| | | | | | | * updater tested, installer untested(but should work :) ) Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/95986
* * maintenance script to switch FK references if using wgSharedDBJure Kajzer2011-07-151-0/+90
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/92240
* * removed DEFAULT '' NOT NULL constraints as '' is internaly converted to ↵Jure Kajzer2011-06-222-8/+17
| | | | | | | | | | NULL in Oracle and throws an error * fixed tableName handling doSchemaUpgrade17 (must be careful to avoid multiple tableName calls as names don't get taged in DDL mode) * exit/reenter DDL mode on updatelog inserts Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/90585
* * fixed table duplication for unit testsJure Kajzer2011-06-072-4/+59
| | | | | | | | | * fixed sequence handling when using DB prefix * deferring constraints on transaction, switching back to immediate on commit/rollback * hardcoded NLS_NUMERIC_CHARACTERS as it breaks using floats in sql if connection is in a non-US-like NLS_LANG (all vars are bound as chars) Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/89623
* * fixed table duplication for phpunit testingJure Kajzer2011-06-022-17/+153
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/89370
* * upgrade patches for oracle 1.17->1.19Jure Kajzer2011-06-014-1/+25
| | | | | | | | | | * fixed tableExists to handle possible username-dbname difference * added indexExists for updater * fixed a bug in DatabaseUpdater * tried not to produce bugs (may have failed) Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/89250
* Breaking the 'math' table setup out to Math extension. Should be the last ↵Brion Vibber2011-04-221-9/+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
* * begin, commit, rollback functions updatedJure Kajzer2011-04-221-0/+4
| | | | | | | | * using ->execFlags instead of hardcoded OCI_DEFAULT * added dummy page (id=0) to satisfy FK checks Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/86701
* * fixed INDEX change (i missed that one)Jure Kajzer2011-03-012-2/+2
| | | | Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/83005
* * Fixed Oracle new installer support, broken by r80957. This is a minimal ↵Tim Starling2011-01-271-2/+2
| | | | | | | | | | | | | | | | | patch and doesn't address the architectural issues. ** Moved the responsibility for calling setupSchemaVars() on install to the DatabaseInstaller subclass. This allows it to be called after setupDatabase() has completed, as required by Oracle and PostgreSQL. ** Fixed OracleInstaller::getConnection() so that it respects $this->useSysDBA correctly. ** In OracleInstaller, added some more variables to the list of schema vars, which are needed by user.sql and tables.sql ** In SearchOracle, specify the database name when calling ctx_ddl.sync_index(). This fixes a fatal error in the createMainpage step, caused by the schema name not being equal to the current user. * In oracle/tables.sql, fixed a couple of indexes with missing table prefixes. * Improved debugging output in DatabaseInstaller::getConnection() and Installer::createMainpage(). * In DatabaseBase::selectDB(), set $this->mDBname correctly, as in DatabaseMysql. Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/81084
* * fixed oracle code for updater (corrected not null BLOB field adding) Jure Kajzer2011-01-101-1/+2
| | | | | | | | | * added required DB vars in WebInstaller_ExistingWiki * oracle upgrades normally 1.16=>1.17 Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/79954
* * fixed Oracle code for installer and phpunit testsJure Kajzer2011-01-101-1/+0
| | | | | | | | * removed ORABlob class Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/79951
* Moved testRunner[|.ora|.postgres].sql to [|oracle/|postgres/]archives/ so ↵Alexandre Emsenhuber2010-11-091-0/+37
| | | | | | | that they can be called through DatabaseBase::patchPath(), much simplier Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/76397
generated by cgit v1.2.3 (git 2.25.1) at 2025-04-23 07:03:09 +0000