aboutsummaryrefslogtreecommitdiffstats
path: root/sql
Commit message (Collapse)AuthorAgeFilesLines
* In .htaccess deny files, use "Satisfy All"Tim Starling2025-04-041-0/+1
| | | | | | | | | | | | | | | These .htaccess files are intended to prohibit all web access. But if the user sets "Satisfy Any" on a parent directory, in conjunction with any permissive require directive like "Require all granted", access will be allowed despite "Require all denied" in .htaccess. So, override Satisfy so that the "Require all denied" will reliably take effect. Note that "Satisfy All" is the default. This only affects non-default installations. Change-Id: Ia5862fb69e439b7ea2ed7af011e1ebf8f1b1f6d6
* ResourceLoader: Remove module_deps tableHannah Okwelum2025-02-135-53/+0
| | | | | | | No longer used. see T343492 Bug: T379661 Change-Id: I6b3d51995452f77b5da86b0cf32a23b12c7c669c
* schema: Add cl_target_id and cl_collation_id to categorylinksAmir Sarabadani2025-01-2111-0/+343
| | | | | | | To normalize cl_to and cl_collation Bug: T299951 Change-Id: If58190f3cc912ffa99c623dc9f51d530d5c87186
* schema: Introduce file tableAmir Sarabadani2025-01-037-0/+561
| | | | | | | First step in reworking storage of files metadata in the database Bug: T368113 Change-Id: I6e79c47f9b6a191a3599db5f0a1a44e73b89be22
* Drop orphaned JSON schema change filesDaimona Eaytoy2024-12-132-205/+0
| | | | | | | | | | | The SQL files and wiring for patch-drop-ct_tag.json have been dropped in I5ff9630a6539a5. The SQL file and wiring for patch-extend-iwlinks-iwl_prefix.json have been dropped in I8fb08e226c1a3. Bug: T381981 Change-Id: I998264c4b14b8b6f0a18c84e165af048cfa2dfe0
* Re-generate all schema change filesDaimona Eaytoy2024-12-13109-785/+2053
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This gives us a solid baseline to use for automated tests. Whitespace differences will be ignored by the test, but regenerate these anyway because they're much more readable now, and it's generally nice to have a clean baseline. Differences are due to: - JSON files being moved in T382030 - JSON paths in the autogenerated comment are now standardized (I358cc24798f518d7) - Whitespace changes from Ib2f60b492ced8ff - Actual SQL changes from newer versions of doctrine/dbal There's also one important exception: the SQLite schema change for patch-page-rename-name_title-index no longer matches the JSON file since I17e73d5ef1. There doesn't seem to be a super-simple way around this, because we don't know the state of the database pre-update. On top of that, I believe that removing the field from the .sql file as done in I17e73d5ef1 could've caused data loss when upgrading from old versions: the column could be silently dropped before running the DB update that correctly migrates and drop the column. This is something to keep in mind going forwards, and T381981 will prevent it from happening that easily. But for the update in question, it's probably too late, so just update the JSON file to match the .sql files. Bug: T381981 Bug: T382030 Change-Id: I3a3acc0935409d4601eb172664580b13d5fe2340
* Move SQL schema and schema changes to new sql/ top-level directoryDaimona Eaytoy2024-12-13247-0/+18658
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