<commit_before>## Upgrade Notes

### [ Future Versions ] 2.2.2 >

* Modify the migrations table:
```
renamed:    database/migrations/2015_12_27_221900_vanilla_mship_v221.php -> database/migrations/2015_01_01_000000_vanilla_mship_v221.php
renamed:    database/migrations/2015_12_27_221901_vanilla_system_v221.php -> database/migrations/2015_01_01_000010_vanilla_system_v221.php
renamed:    database/migrations/2015_12_27_221902_vanilla_sso_v221.php -> database/migrations/2015_01_01_000020_vanilla_sso_v221.php
renamed:    database/migrations/2015_12_27_221903_vanilla_teamspeak_v221.php -> database/migrations/2015_01_01_000030_vanilla_teamspeak_v221.php
renamed:    database/migrations/2015_12_27_221904_vanilla_messages_v221.php -> database/migrations/2015_01_01_000040_vanilla_messages_v221.php
```
* Active the slack:manager cronjob:
* * `php artisan slack:manager` every 2 minutes should suffice for now.

### 2.2.1 > 2.2.2
* Enable the stats tracking cronjobs:
* * `statistics:download`

* Modify the cronjob from `Statistics:daily`
* * Set as `php artisan sys:statistics:daily`

* Modify the migrations table *BEFORE DEPLOYMENT*
* * [Update] `2014_09_12_200312_initial_membership` => `2015_12_27_221900_vanilla_mship_v221`
* * [Update] `2014_09_12_200319_initial_system` => `2015_12_27_221901_vanilla_system_v221`
* * [Update] `2014_09_12_200323_initial_sso` => `2015_12_27_221902_vanilla_sso_v221`
* * [Update] `2014_09_22_203120_system_postmaster_initial` => `2015_12_27_221904_vanilla_messages_v221`
* * [Delete] `2014_09_14_200323_database_security_types`
* * [Delete] `2014_09_14_200325_database_qualifications`
* * [Delete] `2014_09_20_200325_system_tokens`<commit_msg>Added MySQL query for latest vanilla migration changes.<commit_after>## Upgrade Notes

### [ Future Versions ] 2.2.2 >

* Modify the migrations table:
```
renamed:    database/migrations/2015_12_27_221900_vanilla_mship_v221.php -> database/migrations/2015_01_01_000000_vanilla_mship_v221.php
renamed:    database/migrations/2015_12_27_221901_vanilla_system_v221.php -> database/migrations/2015_01_01_000010_vanilla_system_v221.php
renamed:    database/migrations/2015_12_27_221902_vanilla_sso_v221.php -> database/migrations/2015_01_01_000020_vanilla_sso_v221.php
renamed:    database/migrations/2015_12_27_221903_vanilla_teamspeak_v221.php -> database/migrations/2015_01_01_000030_vanilla_teamspeak_v221.php
renamed:    database/migrations/2015_12_27_221904_vanilla_messages_v221.php -> database/migrations/2015_01_01_000040_vanilla_messages_v221.php
```
```mysql
UPDATE `migrations`
SET `migration` = '2015_01_01_000000_vanilla_mship_v221'
WHERE `migration` = '2015_12_27_221900_vanilla_mship_v221';

UPDATE `migrations`
SET `migration` = '2015_01_01_000010_vanilla_system_v221'
WHERE `migration` = '2015_12_27_221901_vanilla_system_v221';

UPDATE `migrations`
SET `migration` = '2015_01_01_000020_vanilla_sso_v221'
WHERE `migration` = '2015_12_27_221902_vanilla_sso_v221';

UPDATE `migrations`
SET `migration` = '2015_01_01_000030_vanilla_teamspeak_v221'
WHERE `migration` = '2015_12_27_221903_vanilla_teamspeak_v221';

UPDATE `migrations`
SET `migration` = '2015_01_01_000040_vanilla_messages_v221'
WHERE `migration` = '2015_12_27_221904_vanilla_messages_v221';
```
* Active the slack:manager cronjob:
* * `php artisan slack:manager` every 2 minutes should suffice for now.

### 2.2.1 > 2.2.2
* Enable the stats tracking cronjobs:
* * `statistics:download`

* Modify the cronjob from `Statistics:daily`
* * Set as `php artisan sys:statistics:daily`

* Modify the migrations table *BEFORE DEPLOYMENT*
* * [Update] `2014_09_12_200312_initial_membership` => `2015_12_27_221900_vanilla_mship_v221`
* * [Update] `2014_09_12_200319_initial_system` => `2015_12_27_221901_vanilla_system_v221`
* * [Update] `2014_09_12_200323_initial_sso` => `2015_12_27_221902_vanilla_sso_v221`
* * [Update] `2014_09_22_203120_system_postmaster_initial` => `2015_12_27_221904_vanilla_messages_v221`
* * [Delete] `2014_09_14_200323_database_security_types`
* * [Delete] `2014_09_14_200325_database_qualifications`
* * [Delete] `2014_09_20_200325_system_tokens`
{'fraction_non_alphanumeric': 0.09563106796116505, 'fraction_numerical': 0.2092233009708738, 'mean_word_length': 8.517321016166282, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 25, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 2, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7402935', 'n_tokens_mistral': 2176, 'n_tokens_neox': 1628, 'n_words': 209}