Remove Boxnet plugins from core

Setup

The following steps should be run on a Moodle site without the patch.

1. Login as admin.
2. Go to "Site administration > Advanced features" and "Enable portfolios".
3. Access to "Site administration > Plugins > Portfolios > Manage portfolios".
4. Select "Enable and visible" for "Box". You can use some silly text (such as "xxxx"), for Client ID and Secret.
5. Select "Enable and visible" for "File download".
6. Check the following SQL query return 1 row. Annotate the id.

   SELECT * FROM mdl_portfolio_instance WHERE plugin = 'boxnet'

7. Check the following SQL query return 2 (you'll need to replace the id that you've annotated previously): 

   SELECT count(*) FROM mdl_portfolio_instance_config WHERE instance = <PORTFOLIOID>

8. Go to "Site administration > Plugins > Repositories > Manage repositories".
9. Select "Enable and visible" for the "Box" repository. You'll need to add some silly text (such as "xxxx"), for Client ID and Secret.
10. Check the following SQL query return 1 row. Annotate the id.

    SELECT * FROM mdl_repository WHERE type = 'boxnet'

11. Check the following SQL query return 1 (you'll need to replace the id that you've annotated previously): 

    SELECT count(*) FROM mdl_repository_instances WHERE typeid = <REPOSITORYID>

12. Check the following SQL query is not empty: 

    SELECT * FROM mdl_config_plugins WHERE plugin = 'boxnet'

13. Apply the patch and run the upgrade process.

Testing scenario 1: Portfolio

1. Access to "Site administration > Plugins > Portfolios > Manage portfolios".
2. Check "Box" is no longer displayed there.
3. Check the following SQL query is empty:

   SELECT * FROM mdl_portfolio_instance WHERE plugin = 'boxnet'

4. Check the following SQL query is empty too (you'll need to replace the id that you've annotated previously): 

   SELECT count(*) FROM mdl_portfolio_instance_config WHERE instance = <PORTFOLIOID>

Testing scenario 2: Repository

1. Access to "Site administration > Plugins > Repositories > Manage repositories".
2. Check "Box" is no longer displayed there.
3. Check the following SQL query is empty:

   SELECT * FROM mdl_repository WHERE type = 'boxnet'

4. Check the following SQL query is empty too (you'll need to replace the id that you've annotated previously): 

   SELECT count(*) FROM mdl_repository_instances WHERE typeid = <REPOSITORYID>

5. Check the following SQL query is empty:

   SELECT * FROM mdl_config_plugins WHERE plugin = 'boxnet';

   SELECT * FROM mdl_config_plugins WHERE plugin = 'repository_boxnet';