# required apps
jpegoptim, optipng, pngquant, gifsicle

# required php extensions
php-gd, php-xml, php-json, php-mbstring, php-mysqli, php-zip, php-simplexml, php-curl, php-exif, php-bz2, php-imagick

# cache repositories(optional)
redis, php-redis
memchached, php-memcached
APCu
couchbase

# data storage
MySQL or MariaDB or Percona MySQL

# get the files
git clone https://github.com/darkalchemy/Pu-239.git

# install dependancies
cd Pu-239
composer install
npm install

# set ownership
sudo chown -R www-data:www-data ../Pu-239

# set webroot to path Pu-239/public

# add charset to [mysqld] section of mysqld.cnf
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci

# add/modify these in [mysqld] to increase max size for index(required)
innodb_file_format = Barracuda
innodb_large_prefix = 1
innodb_file_per_table = 1

# add/modify this in [mysqld] to stop autoincrement on insert ignore(optional)
innodb_autoinc_lock_mode = 0

# restart mysql
sudo service mysql restart

# create database
CREATE DATABASE Pu-239;

# goto website and complete install, all fields must be completed and each fields includes an example and tooltip explanation when hovered

# set permissions and create necessary files
sudo php bin/uglify.php
sudo php bin/set_perms.php

# set ownership
sudo chown -R www-data:www-data ../Pu-239

# delete public/install folder once directed to
sudo rm -r public/install/

# insert trivia questions if desired
mysql database < database/trivia.php.sql

# insert tvmaze ids
mysql database < database/tvmaze.php.sql

# create your first user and login

# goto admin and create your bot/system user

# goto admin cleanup and activate/deactivate scripts, they are initially set to yesterday midnight

# add cron job to root cron for running cleanup, please change path as needed
sudo crontab -e

# runs cron_controller.php every minute, if not already running, as user www-data
* * * * * su www-data -s /bin/bash -c "/usr/bin/php /var/www/Pu-239/include/cron_controller.php" >/dev/null 2>&1

# get the files
# how you do this step will depend how you did it initially, I personally use rsync to overwrite files from git to my webpath, then remove the install folder
cd Pu-239
git pull

# update dependancies:
composer install
composer dump-autoload -o
npm install
sudo php bin/uglify.php
sudo php bin/set_perms.php

# set ownership
sudo chown -R www-data:www-data ../Pu-239

# update trivia questions if desired
mysql database < database/trivia.php.sql

# insert tvmaze ids 
mysql database < database/tvmaze.php.sql

# update database:
goto admin/upgrade_database to check/update the database
note: if that does exist, check the changelog for 6 Dec, 2017