Add primary keys to site_stats
authorEddie Greiner-Petter <git@eddie-sh.de>
Sat, 15 Jul 2017 20:57:06 +0000 (22:57 +0200)
committerEddieGP <wikimedia.org@eddie-sh.de>
Tue, 17 Oct 2017 11:59:20 +0000 (11:59 +0000)
commit49f7be39e1cd3ca89db47a3fe320db5c4b23fa6b
tree62a58a75791ef10156e514e6dd6e124736cb88ec
parenta8f1d9d23ee9f64dca6e925cfb979680ad8e0a46
Add primary keys to site_stats

As discussed in I7d42aae434852a56b6f8dd559d8a5f3bce416021 primary keys
are needed to perform various schema changes on  the site_stats table.
This patch aims to introduce primary keys for all supported dbms.

The respective *.sql patch files were tested locally against Postgres
and SQL Server 2016. Please note that neither the patch file for Oracle
DB nor the mediawiki upgrade through update.php was tested.

Bug: T56888
Change-Id: Id10e221f0dc120bc09afc22596fd1dbecbf6a61d
includes/installer/MssqlUpdater.php
includes/installer/OracleUpdater.php
includes/installer/PostgresUpdater.php
maintenance/mssql/archives/patch-site_stats-pk.sql [new file with mode: 0644]
maintenance/mssql/tables.sql
maintenance/oracle/archives/patch-site_stats-pk.sql [new file with mode: 0644]
maintenance/oracle/tables.sql
maintenance/postgres/archives/patch-site_stats-pk.sql [new file with mode: 0644]
maintenance/postgres/tables.sql