svn sw ^/branches/8.0/dev/austins-8656

svn merge --dry-run -r148770:HEAD ^/branches/8.0/dev/austins-8694

svn resolve --accept working Finance/modules/AccountsPayable/Request.php

svn co svn://focus-sis.com/focus/branches/8.0/dev/sabrinatrunk

svn cp svn://focus-sis.com/focus/branches/8.0/trunk svn://focus-sis.com/focus/branches/8.0/dev/trunk -m "checking out trunk for live dev on the mac"

$profiles = Database::get("Select bla from bla")  // FORMAT
$profiles = [$a, $b, $c] // Auto-indexed 0 based
$profiles index $a = ['PROFILE_ID' = > 123] // format inside the array of array
$profiles index $a['PROFILE_ID'] = 123 // selected value

https://demo.focusschoolsoftware.com/austins/utilities/ResetMemcache.php?reset

delete FROM login_history WHERE username='focus';

update users set password='focus' where username='focus';

psql -h 192.168.122.21 -p 5432 -U martin_focus martin_erptesting

grep ^.Database config.inc.php

svn st | grep '^?' | awk '{print $2}' | xargs rm -rf

scp -P 45678 MetaData.zip austins@demo.focus-sis.com:/mnt/sftp/demo/austins8/Finance/sql/MetaData.zip

svn status | grep '^[I?]' | cut -c 9- | xargs -d"\n" -I{} rm -fr {}

cat ~/.ssh/id_rsa.pub | xclip -sel clip

ssh to server
/home/backups/monroe/monroe/monroe_focus
ls -l (chose a file lets say monroe2.sql)
scp -P 45678 austins@monroe.focusschoolsoftware.com:/home/backups/monroe/monroe/monroe_focus/monroe2.sql /var/www/html/monroe2.sql
cd /usr/psql-10/bin/
./dropdb monroe
./createdb monroe
./pg_restore -d monroe --no-owner /var/www/html/monroe2.sql

select pid,state,query from pg_stat_activity;
SELECT pg_terminate_backend(30612);