Convert numerous UNIQUE INDEX to PRIMARY KEY
authorReedy <reedy@wikimedia.org>
Wed, 4 Jul 2018 19:13:07 +0000 (20:13 +0100)
committerReedy <reedy@wikimedia.org>
Wed, 11 Jul 2018 19:36:33 +0000 (20:36 +0100)
commit267d99fa85434c3f26b7c5223cd46c29dedff4e5
treecf251bd2460169ba1d740059f4b6930cea9e3a9b
parentaaf8866e3f10c92ca1350562d21e3a27dfdbe98a
Convert numerous UNIQUE INDEX to PRIMARY KEY

MySQL, SQLite, PostgreSQL and MSSQL done with transitional patches.

One additional duplicate index removed from PostgreSQL schema.

Having a PK is essential to do maintenance, specially on large tasks.
By not having a PK it is impossible to add it in a safe way if not done
directly on the master.

Having a PK means that we can easily change the PK into another one if
needed in the future. The ones we chose might not be the best ones, but
will allow us to get them changed.

Bug: T198811
Change-Id: I6b96a427687085c6c24bcd759c9739f81288b919
23 files changed:
RELEASE-NOTES-1.32
includes/installer/MssqlUpdater.php
includes/installer/MysqlUpdater.php
includes/installer/PostgresUpdater.php
includes/installer/SqliteUpdater.php
maintenance/archives/patch-interwiki-fix-pk.sql [new file with mode: 0644]
maintenance/archives/patch-page_props-fix-pk.sql [new file with mode: 0644]
maintenance/archives/patch-protected_titles-fix-pk.sql [new file with mode: 0644]
maintenance/archives/patch-site_identifiers-fix-pk.sql [new file with mode: 0644]
maintenance/mssql/archives/patch-interwiki-pk.sql [new file with mode: 0644]
maintenance/mssql/archives/patch-page_props-pk.sql [new file with mode: 0644]
maintenance/mssql/archives/patch-protected_titles-pk.sql [new file with mode: 0644]
maintenance/mssql/archives/patch-site_identifiers-pk.sql [new file with mode: 0644]
maintenance/mssql/tables.sql
maintenance/postgres/archives/patch-interwiki-pk.sql [new file with mode: 0644]
maintenance/postgres/archives/patch-protected_titles-pk.sql [new file with mode: 0644]
maintenance/postgres/archives/patch-site_identifiers-pk.sql [new file with mode: 0644]
maintenance/postgres/tables.sql
maintenance/sqlite/archives/patch-interwiki-fix-pk.sql [new file with mode: 0644]
maintenance/sqlite/archives/patch-page_props-fix-pk.sql [new file with mode: 0644]
maintenance/sqlite/archives/patch-protected_titles-fix-pk.sql [new file with mode: 0644]
maintenance/sqlite/archives/patch-site_identifiers-fix-pk.sql [new file with mode: 0644]
maintenance/tables.sql