1. Run `update_schema.sql`
2. Import CODA clients_music - see `import_coda` folder.
3. Import "Resources" - see `import_resources` folder.
4. prepend s3 to files table:

```
UPDATE `resources_files` SET `file_path`= CONCAT('paradigm-media-library/resources/shared_documents/', file_path) WHERE 1=1
```

5. import `updates` - see `import_updates` folder.
5. import `news` - see `import_news` folder.
6. import `agency_news` - see `import_agency_news` folder.
7. setup crontab: `* * * * * php /var/www/html/paradigm/intranet/artisan schedule:run >> /dev/null 2>&1`
8. import `avails` - see `import_avails` folder.
9. add rows to the 'configs' table.
10. need to do a `composer install` for `laravel/scout` and `composer update` - may need to update file permissions
- composer require teamtnt/laravel-scout-tntsearch-driver
  - may need to do `sudo apt-get install php7.0-sqlite3` or `sudo apt-get install php5-sqlite`(http://stackoverflow.com/questions/8822209/pdo-sqlite-driver-not-present-what-to-do)
 - after install sqlite need to restart apache.
 -  may need to update permissions of '/storage' - chmod 777 -R storage/
 - then need to `scout:import` everything: `php artisan scout:imager "App\Avail"` etc for all 6-10 items.

11. run `update territories combined` command at least once.
12. create `news_clients_music_v`
13. add `clients_talent_media_pages_v` view
14. Import "sections" (from old backup prolly)

15. Update the `clients_music_agencies` table with the csv that bo sent on 5/1. These queries may be helpful:

```
SELECT
cma.id,
cma.temp_node_id,
cma.agencies_id,
cm.id
cm.name
FROM clients_music_agencies cma
LEFT JOIN clients_music cm ON cma.temp_node_id = cm.old_intranet_id
WHERE cm.name IS NOT NULL;


UPDATE clients_music_agencies cma
LEFT JOIN clients_music cm ON cma.temp_node_id = cm.old_intranet_id
SET cma.clients_music_id = cm.id
WHERE cm.name IS NOT NULL;
```