Fixes to sql script and new rollup scripts for version 10

[donker]

trafficstars

This PR adds a few missing objectQualifiers from the v10 SQL script and replaces the old 8.0.4 rollup scripts with a new one for v10.

Methodology for creating the rollup scripts

1. A new/empty DB was created
2. All SqlDataProvider SQL scripts (i.e. not the membership provider scripts) that the current installation process runs were run using a unique schema (not dbo.) and objectqualifier (not empty)
3. In SSMS a schema was generated by selecting all tables, views, procedures and functions (i.e. none of the security objects)
4. Similarly a data script was created.
5. The data script was parsed and changed to conform to the way DNN runs scripts (remove GO statements within IDENTITY_INSERT blocks).
6. With search and replace all databaseOwners and objectQualifiers were put back in place.

Note with item 2: DNN runs "Schema", then "Data" and then all scripts higher than 8.0.4 (starting thus with 08.00.04.01). This process was mimicked using a console app to isolate the exact process.

Note this will probably resolve issue #6028

[mitchelsellers]

@donker This looks awesome, I'll test the build results in Azure in the next few days, very curious to see how much this helps install

[valadas]

/azp run

[azure-pipelines[bot]]

Azure Pipelines successfully started running 1 pipeline(s).