1. Run `update_schema.sql`
2. Import news [see folder]
3. import A&R. see README in the import folder.

4. Run this sql:
```
UPDATE `news` SET `main_image`= REPLACE(`main_image`,'paradigm-media-library/news/', '')
```
5. install imagemagic:

```
apt-get autoremove
apt-get update
apt-get install imagemagick
apt-get install php-imagick
```