aboutsummaryrefslogtreecommitdiffstats
path: root/maintenance/sqlite/tables-generated.sql
Commit message (Collapse)AuthorAgeFilesLines
* Move SQL schema and schema changes to new sql/ top-level directoryDaimona Eaytoy2024-12-131-871/+0
| | | | | | | | | | | | | | | | | | | | | | | | This is the standard in every extension. DB schema changes are not maintenance scripts, and therefore there's no apparent reason to have the two things together, besides historical reasons. Also, put each DB type in a separate directory, which wasn't the case for MySQL before. For SQLite and Postgres schema changes, we now follow the convention (used everywhere else, including the generateSchemaChangeSql script) of having the DB type as the last part of the path. This lets us generate schema changes for all DB types at once, and without specifying the full file path. Most files are just being renamed, the exceptions being to update references to the old location (sometimes still referencing tables.sql). Note that the old path is still referenced in the autogenerated comment of schema changes SQL files. These will be regenerated in another commit. Instead, the schema files are done now, because they're covered by DatabaseIntegrationTest that would otherwise fail. Bug: T382030 Change-Id: I3b4a614366d0bc629523ac40ce97d001f3b6bcf8
* Searchindex primary key, title length and utf8mb4Derk-Jan Hartman2024-10-231-4/+3
| | | | | | | | | | | | | | | | - Make si_page primary key - Allow si_title to be larger - Switch from utf8 to utf8mb4 - Remove default of empty string for titles Sqlite is not migrated, as it has it's own overrides Postgres is migrated, but is not in actual use This is mostly from I273e3a7715abf97d2889904642c7c375e76de4f6 Bug: T249976 Bug: T231827 Change-Id: I12adff3e6ca6a9986ff207bef16272195c3a6a48
* schema: Drop old pagelinks columnsAmir Sarabadani2024-06-181-11/+2
| | | | | | | It has been dropped in production already. Bug: T299947 Change-Id: I8ec1e7d9224c81d6494c39c78df9e4bdac38d377
* block: Migrate to the new block schema on non-WMF wikisTim Starling2024-05-091-30/+0
| | | | | | | | | | | | Migrate from ipblocks to block/block_target and drop the ipblocks table. Update tests. In PostgresUpdater, change some schema update functions to skip field updates if the table doesn't exist, by analogy with DatabaseUpdater::modifyField. Bug: T346293 Change-Id: Icf91b35f7f729cead7c800429653eb30731762a1
* Make rc_id a bigintAlexander Vorwerk2024-05-041-1/+1
| | | | | | | | | | | | | | | Wikidata is at 51.3% of its maximum value (see [1]), so we still have comfortable time to make this change, but it will inevitably be necessary and there is no point in postponing this change into the future. The autoincrement value will not get smaller. ¯\_(ツ)_/¯ Also since rc only stores stuff for 30 days, the table is not that big. [1] - https://grafana.wikimedia.org/d/79S1Hq9Mz/wikidata-reliability-metrics?viewPanel=29&orgId=1 Bug: T63111 Change-Id: Icf3dc9815814ef73aa6a39f1c221a349e6b76872
* Cleanup revision table schemaAlexander Vorwerk2024-05-041-3/+3
| | | | | | | | | * Drop default value from rev_actor and rev_comment_id * Make rev_id a bigint Bug: T215466 Depends-On: I88318d7bcc063bc86a56eeb5f00048ea6e81964b Change-Id: Id0a3d920e8b2dc8643fa3c0341b34ab3ed5761dc
* Schema: Drop iwl_prefix_from_title from iwlinksAmir Sarabadani2024-02-081-2/+0
| | | | | | | | | | | | After exhuastive research, we concluded that iwl_prefix_from_title is not used and in case it's actually used, other indexes provide enough cardinality. This table is about to grow quite large in Commons, let's avoid making it bigger than it needs to be. Bug: T343131 Change-Id: I89e40dff384291968d2465e4109a3d212ae2f8c7
* Schema: Drop unused and useless indexes of sites tableAmir Sarabadani2024-02-011-14/+0
| | | | | | | | | | | | | This table has eight indexes plus PK. It has around 1000 rows only. Even if it needs these indexes (which it doesn't), they are still useless. Looking at the code, the only potential useful index is the one on site_global_key, they are showing up in the report of unused indexes in the db and I checked with Fandom (which might benefit from an index on this table) and they said they don't use sites table. Bug: T342856 Change-Id: I06b3db0f33bd35bfa68f4b418d8c2f4b9b988409
* Schema: Drop cl_collation_ext indexAmir Sarabadani2024-01-261-4/+0
| | | | | | | Unused since Ie4dd91ee29308c980e Bug: T342854 Change-Id: I3acf563c64ff176ade3e0c6745839a168e92473b
* Add the new block and block_target tablesTim Starling2024-01-081-0/+42
| | | | | Bug: T346293 Change-Id: I3822ad03227405a608dea1d788bcdb8321b95bb3
* Use year in temporary user names and restart index each yearThalia2024-01-051-1/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Why: * Part of a temporary user name is generated from an index that increments, which is stored in the database. * As specified in T345855, the index will be restarted each year. * Also specified in T345855, the year will be included in generated temporary user names. What: * Since the year must be included in the name in order to avoid naming conflicts if the index is restarted each year, both are implemented together and controlled by a single config. * Add a new config option that, when true, restarts the name generation index at the start of each year and add the year into the user name: $wgAutoCreateTempUser['serialProvider']['useYear'] * Add a uas_year column to the user_autocreate_serial table, which is unique in combination with uas_shard, so the index can be stored for each shard/year combination. * The year is added into the username just after the prefix, as specified in T345855. This is based on research that having the year near the start of the name aids understanding that the names are not IP addresses. The position of the year within the name is therefore not configurable (though whether to include it is). See T345855 for the research. Bug: T349494 Bug: T349501 Depends-On: I6b3c640a4e74f52fd4a4f46de5a2cbe80fe3b665 Change-Id: If51acb3f4efa361ce36d919c862a52501a5a7d24
* Store image sizes as 64-bit bigint instead of 32-bit integersBrian Wolff2023-10-041-4/+4
| | | | | | | | This is meant in preparation for MediaWiki supporting files larger than 4gb. Bug: T191805 Change-Id: Ie67dd01aa0a8b28d9afc1805243e711fcadbc0f8
* Schema: Drop old externallinks columns and indexesAmir Sarabadani2023-09-051-10/+0
| | | | | | | | | | Already dropped from production Also dropping FixExtLinksProtocolRelative as it's not useful anymore and it has been run in previous releases so it's not worth fixing. Bug: T312666 Change-Id: I1dd6e704b34e685ada6e316da11243d10827d769
* Schema: Add pl_target_id column to pagelinksAmir Sarabadani2023-07-251-0/+8
| | | | | | | Similar to templatelinks Bug: T342689 Change-Id: I2ed692d7d0cdf756d29618363bec7fc761ff3df1
* Schema: Set default or nullable to three columns of externallinksAmir Sarabadani2023-07-181-2/+3
| | | | | | | | | | | | | We need to drop these columns and we need to make them take default values so we can issue write queries without these columns. Also noting that MySQL prior to 8.0 can't set default values to blob columns making this way more complicated than it should be but MariaDB can set them (https://mariadb.com/kb/en/blob/). We also made these columns nullable to make this work in MySQL. Bug: T341828 Change-Id: I0d60742b6ce7adf642393ee00b66aa539b76dfc1
* Drop revision_comment_tempAlexander Vorwerk2023-06-071-11/+0
| | | | | Bug: T299954 Change-Id: I85d21b1eff70a7d70e8ce14f25d66f7e7c76e5fe
* schema: Add user_is_temp column to the user tableThalia2023-05-101-1/+2
| | | | | | | | | This allows temporary users to be identified from applications external to MediaWiki, by the user table alone (without referring to the $AutoCreateTempUser['matchPattern'] config). Bug: T333223 Change-Id: I83c5ff42654164590fb0361c84e65a5315ddbda8
* schema: Add new fields for externallinks so we can reduce duplicationAmir Sarabadani2022-10-181-2/+5
| | | | | Bug: T318604 Change-Id: I217817bc518eaa86c9952187c6f1a861f480ccaf
* schema: Drop tl_title and tl_namespace fields from templatelinksAmir Sarabadani2022-09-061-9/+0
| | | | | | | | The day has gone. Still keeping the code as the schema changes are not done in production but the data migration has been finished. Bug: T299417 Change-Id: I906e069a63d1dae14924c72318b22b16244371d6
* Add support for write new for templatelinks migrationAmir Sarabadani2022-07-121-3/+3
| | | | | | | | | | - schema change to allow tl_namespace and tl_title being empty This is done by removing them from primary key. They don't need to be nullable as they have default value. - Make sure with WRITE_NEW, updater avoids writing to the old columns Bug: T306674 Change-Id: I2b8a29043e952060e7a79b6a7a3d647d48cd16fb
* schema: Drop legacy page_restrictions in page tableAmir Sarabadani2022-05-261-1/+0
| | | | | Bug: T35334 Change-Id: I17e73d5ef165481a5dd4c210da933b99c65ff79c
* Start clean up of revision_actor_temp tableAmir Sarabadani2022-05-231-19/+0
| | | | | | | It is being dropped in production Bug: T215466 Change-Id: I66b2cb8653252e720c897351065978119f040ba7
* Schema: Updating user_editcount field to unsigneddiesel kapasule2022-05-091-1/+1
| | | | | | | | | | I have updated user_editcount field to unsigned in tables.json This patch doesn't apply to Postgres. Bug: T305340 Change-Id: I07a360944a10be9cc8ed8731c6286412294413a3
* schema: Make ipblocks.ipb_id unsignedUmherirrender2022-04-141-2/+2
| | | | | | | | | | | | | It makes it more consistent with AUTO_INCREMENT PRIMARY KEY columns on other tables. This includes ipblocks.ipb_parent_block_id and ipblocks_restrictions.ir_ipb_id as well This patch doesn't apply to Postgres. Bug: T297208 Change-Id: I950aba63b2b226abbaf4010fbb51415bbff117f4
* TempUser infrastructure and servicesTim Starling2022-04-141-0/+7
| | | | | | | | | | | | | | | | | | Add services and utilities for automatic creation of temporary user accounts on page save, in order to avoid exposing the user's IP address. * Add $wgAutoCreateTempUser, for configuring the system * Add TempUserConfig service, which interprets the config. * Add TempUserCreator service, which creates users during page save as requested by EditPage. With proxy methods to TempUserConfig for convenience. * Add table user_autocreate_serial. Table creation is necessary before the feature is enabled but is not necessary before deployment of this commit. Bug: T300263 Change-Id: Ib14a352490fc42039106523118e8d021844e3dfb
* Add tl_target_id to templatelinksAmir Sarabadani2022-01-281-0/+8
| | | | | | | | Part of normalizing it, note that the field must be nullable now and that will change later. Bug: T299418 Change-Id: Id543dfa20a153312f66d2f45a64ac23e7272dabe
* schema: Make page_id references unsignedUmherirrender2022-01-271-5/+5
| | | | | | | | | | | | | | | This includes: page_props.pp_page page_restrictions.pr_page ipblocks_restrictions.ir_value These columns must hold all possible values from page.page_id, which is an unsigned integer. These patches doesn't apply to Postgres. Bug: T297212 Change-Id: I789f19f4d52daeab08f3090771404d078f86d0b3
* Drop rev_page_id index on revisionAmir Sarabadani2022-01-271-2/+0
| | | | | | | This is already applied in production and known to be safe. Bug: T163532 Change-Id: Ief29372f13b2d7cdb19395dcda6eb15e9a53efca
* Add linktarget tableAmir Sarabadani2022-01-211-0/+8
| | | | | Bug: T299416 Change-Id: Icae4513dd99635335857100d8a0c7102986933e5
* Drop pr_user from page_restrictionsAmir Sarabadani2021-12-061-1/+0
| | | | | | | It's not used for 13 years, safe to say it won't be used anytime soon Bug: T199377 Change-Id: Iecf4fb6046699a1758ad2d1dc55a3ee8eb4b0389
* Rename change_tag indexes to have ct_ prefixAmmar Abdulhamid2021-06-081-4/+4
| | | | | Bug: T270033 Change-Id: I8a429726c99f6cadea0d671fd871f66b5611c856
* Rename name_title index to have page_ prefixAmmarpad2021-06-051-1/+1
| | | | | Bug: T270033 Change-Id: Id70d0e0a37dd0d000079820d51cef2791f5ec42e
* Add index on oldimage.oi_timestampAmir Sarabadani2021-05-291-0/+2
| | | | | | | Mirroring what happens on image table. Bug: T279982 Change-Id: Ib67c32b10d3b88e09514d8fbb5dcb4f977108ba2
* Migrate searchindex to abstract schemaAmir Sarabadani2021-05-271-0/+13
| | | | | | | | | | | | | For MySQL/Sqlite: - Nothing For Postgres: - Introduce the table. It's not used but it'll be used in the future (T220450) Bug: T164898 Bug: T230428 Bug: T220450 Change-Id: I9f33132676344f8cd813f7a438b3a6a078fd281c
* Migrate revision table to abstract schemaAmmarpad2021-05-201-0/+25
| | | | | | | | | | | | | | | | | | | Postgres: - Drop foreign key from rev_page - Make rev_page not nullable - Change rev_comment_id from int to bigint - Change rev_actor from int to bigint - Sync rev_page_id index with MySQL MySQL/SQlite: - Drop default from rev_timestamp Additional changes in the generator script to handle more formatting issues due to use of additional custom table options Bug: T230428 Bug: T164898 Change-Id: Ia07dd52e43123473a1728523a3f863280537db8e
* objectcache: add last-modified token field to objectcache tableAaron Schulz2021-05-181-0/+2
| | | | | | | | | | Also added token and flags fields. The token field can be used as a tie-breaker for modtime and also for faster cas() operations. The flags field makes serialization and compression format changes easier in the future. Bug: T274174 Change-Id: I45731a877b21835652993c2d285165a76eeae3e9
* Make page_is_redirect and page_is_new unsignedAmir Sarabadani2021-05-121-2/+2
| | | | | | | | | Mistake during the abstraction (Ibdaf332ea1d) It doesn't need schema change since 1.36 is not released yet. Bug: T230428 Change-Id: I071c39dfadf185b01e9109085907d6e3deb1f02f
* Migrate user table to abstract schemaAmmarpad2021-04-241-0/+23
| | | | | | | | | | | | | | | | | | | Postgres: - Rename the table from `mwuser` to `user` - Transition user_id from int to serial - Make user_token not nullable and add default - Make user_real_name not nullable and add default - Make user_email not nullable - Make user_newpassword not nullable - Make user_password not nullable - Drop UNIQUE contraint on user_name and add default MySQL/SQLite: * No changes Bug: T164898 Bug: T230428 Change-Id: I746714f7b3ae16f9625f97bcca84280fcd8b61a0
* Migrate page to abstract schemaAmmar Abdulhamid2021-03-211-0/+26
| | | | | | | | | | | | | | | | Postgres: - Change page_namespace from smallint to int - Change page_random from numeric with arbitrary precision to float - Make page_touched not nullable MySQL/SQLite: - Change datatype of page_title from varchar (with binary collation) to varbinary(255) - Drop default empty string from timestamp field of page_touched Bug: T230428 Bug: T164898 Change-Id: Ibdaf332ea1da309d31d35a6ebbc1b8fefced335e
* Migrate archive table to abstract schemaAmir Sarabadani2021-03-131-0/+23
| | | | | | | | | | | | | | | | | | | | One of the last ones left. For MySQL/Sqlite: - Dropping default of ar_timestamp, empty string is not a valid timestamp. - Changing ar_title from "varchar() binary" to varbinary for Postgres: - Set default for ar_namespace and ar_title - Change datatype of ar_comment_id, ar_actor, ar_namespace The indexes were fixed separately. Bug: T230428 Bug: T164898 Bug: T42626 Depends-On: I83cf1cd51ac9cf933c9175cefd6e38a6914f3494 Change-Id: Ic1d13a82b27f7fa39a0f0ea9c5b7b193b007e4ab
* Rename new_name_timestamp on recentchanges to rc_new_name_timestampAmir Sarabadani2021-03-011-1/+1
| | | | | | | To make it have a uniform prefix for index and column names Bug: T270033 Change-Id: I8eb600416913092bd5aeb70389bba6e8a54d1d57
* Migrate recentchanges table to abstract schemaAmir Sarabadani2021-02-261-0/+47
| | | | | | | | | | | | | | | | | | | This table is massive but thankfully we fixed most of its complexities in previous patches. For MySQL/Sqlite: - Change type of rc_title and rc_source from "varchar binary" to "varbinary" - Drop default of rc_timestamp - Change rc_timestamp from varbinary(14) to binary(14) to standardize timestamp datatypes One index doesn't follow the uniform prefix rule but since it's in a maintenance script, will fix that in a follow up. Bug: T230428 Bug: T42626 Change-Id: I13994e02ad3a2293148346ef7be96746578ad854
* Rename site_identifiers indexes to have si_ prefixAmmar Abdulhamid2021-01-301-2/+2
| | | | | Bug: T270033 Change-Id: I6751f0fd992054b61222ece55c83d05d24af9000
* Migrate image table to abstract schemaAmir Sarabadani2021-01-281-0/+30
| | | | | | | | | | | | | | | | | | For MySQL/Sqlite: - Change datatype of img_name from "varchar() binary" to varbinary. - Drop default of img_timestamp For Postgres: - Adding two missing indexes. - Renaming two indexes - Setting default value for five fields - Fix data type of four fields - Drop default of img_metadata - Make three fields not nullable Bug: T230428 Bug: T164898 Change-Id: I237af3558b0e1c1fecd874c3c90ba6780e50aaa4
* Migrate ipblocks to abstract schemaAmir Sarabadani2021-01-231-0/+30
| | | | | | | | | | | | | | | | | For MySQL/Sqlite: - Drop default values of ipb_timestamp and ipb_expiry as part of standardizing timestamp columns For Postgres: - Drop foreign key on two columns as approved by the RFC - Set default of ipb_user - Make three columns not nullable to sync with MySQL - Change data type of two columns to BIGINT to be the same as MySQL Bug: T230428 Bug: T164898 Bug: T42626 Change-Id: I2c5303d76c6ce059d7fef324a4521c6336c5b1f3
* Migrate objectcache to abstract schemaAmmar Abdulhamid2021-01-201-0/+10
| | | | | | | | | | | | | | | | | For Postgres: - Drop Unique constraint on `keyname` and make primary key - Change type of `value` from BYTEA to TEXT and drop its default - Make `value` nullable to sync with MySQL/SQLite MySQL: - Change exptime from DATETIME to TIMESTAMP MySQL/SQLite: - Make 'exptime' not nullable Bug: T230428 Bug: T164898 Change-Id: Iab9de8a1bb2cb01b6e3e69e66f1bbe089d53d0a7
* Migrate oldimage to abstract schemaAmir Sarabadani2021-01-161-0/+24
| | | | | | | | | | | | | | | | | | | For MySQL/Sqlite: - Changing oi_name and oi_archive_name to varbinary instead of "varchar binary" - Dropping default from oi_timestamp For Postgres: - Adding the correct default to seven fields - Removing incorrect default from oi_metadata - Add missing index oi_actor_timestamp - Change four fields to have correct data type - Make oi_major_mime and oi_minor_mime not nullable - Drop foreign key on oi_name Bug: T230428 Bug: T164898 Change-Id: I4dff0e48081a5797a29513f9c8b87f9ffcaadb5d
* Migrate text table to abstract schemaAmir Sarabadani2021-01-091-0/+6
| | | | | | | | | | | | For MySQL/Sqlite, drop the table options, they are for MySQL < 5.0 which was released in 2003 and not any use today. For Postgres, rename pagecontent table to text, approved as part of the RFC. Swap order of creating auto-generated tables and manual tables. Bug: T230428 Bug: T164898 Change-Id: Id7510b80beed7a7297353094a57d5e2d4f12fc64
* Bring back timestamp time of cl_timestamp instead of binary(14)Amir Sarabadani2021-01-011-1/+1
| | | | | | | | | | | | | Fixing this is going to be complicated. We have to first turn this into varbinary(20), write a maintenance script to fix the values, then make sure mediawiki work properly with two value types at the same time and then turning it to binary(14). For now, let's unblock 1.36 release, we will follow up on fixing this for good later. Bug: T270032 Change-Id: Iabbe8f085812acd90536a06fee2ecd4db9b047d5
* Migrate filearchive to abstract schemaAmir Sarabadani2020-12-231-0/+31
| | | | | | | | | | | | | | | | | | | For MySQL: - Drop default from fa_deleted_timestamp and fa_timestamp - Change fa_name and fa_storage_group from varchar() binary to varbinary() For Postgres: - Set default for three fields - Drop foreign key on fa_deleted_user - Change field type for five fields - Rename indexes to make it make in sync with MySQL/Postgres - Rebuild an index to make it in sync MySQL/Postgres Bug: T230428 Bug: T164898 Bug: T42626 Change-Id: Ia2be151c46c73f15592db03540834a6456460cac
generated by cgit v1.2.3 (git 2.25.1) at 2025-04-26 07:10:28 +0000