Correct recent schema changes for MSSQL, Oracle
authorBrad Jorsch <bjorsch@wikimedia.org>
Tue, 13 Mar 2018 20:43:33 +0000 (16:43 -0400)
committerDaniel Kinzler <daniel.kinzler@wikimedia.de>
Tue, 10 Jul 2018 13:41:25 +0000 (13:41 +0000)
commitf87d0b961c7245822bfce425d252f8ac16a7a6cb
tree6396e9187d1c0475452f7dd1c20799fffc8f140c
parent023a1ab36ec0bf3c2fa35f8b6b6e213b556f50a3
Correct recent schema changes for MSSQL, Oracle

For MSSQL, several schema changes got merged trying to declare various
columns as "unsigned". MSSQL, like PostgreSQL, does not support unsigned
integer types (although its tinyint type is unsigned and cannot be made
signed).

Also for MSSQL, we need to rearrange the MCR tables so the targets of
foreign key references are defined before the FKs themselves.

And the MSSQL had a few naming errors.

For Oracle, two schema changes were merged using incorrect syntax for
adding and modifying columns. And there was a typo.

Bug: T183486
Change-Id: I0511fb7fc9a59ab5a5eae7db810b3a52ddc8376b
includes/installer/MssqlUpdater.php
maintenance/mssql/archives/patch-actor-table.sql
maintenance/mssql/archives/patch-comment-table.sql
maintenance/mssql/archives/patch-content.sql
maintenance/mssql/archives/patch-slots.sql
maintenance/mssql/tables.sql
maintenance/oracle/archives/patch-actor-table.sql
maintenance/oracle/archives/patch-comment-table.sql
maintenance/oracle/tables.sql