aboutsummaryrefslogtreecommitdiffstats
path: root/maintenance/postgres/archives/patch-templatelinks-drop-tl_title.sql
Commit message (Collapse)AuthorAgeFilesLines
* Move SQL schema and schema changes to new sql/ top-level directoryDaimona Eaytoy2024-12-131-6/+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
* postgres: Make the upgrade ignore dropping indexes that might not existAmir Sarabadani2023-02-271-7/+3
| | | | | | | | | Due to drifts, 1.35 didn't have tl_namespace nor tl_backlinks_namespace but that was fixed in 1.36 which the drop of tl_title tries to drop leading to errors. Bug: T330382 Change-Id: I555e855b3c0e97e5df1f0fab1de104301d40eae4
* schema: Drop tl_title and tl_namespace fields from templatelinksAmir Sarabadani2022-09-061-0/+10
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