cd /var/www
wget http://downloads.sourceforge.net/project/jcsfog/Pastebin/cccp-pastebin-2.80-prod/cccp-pastebin-2.80-production.zip?use_mirror=transact
mkdir -p html/pb
cd html/pb
unzip ../../cccp*.zip
mv php/* .
 
# Create mysql User
mysql -u root -p mysql << EOF \
create database pb; \
create user 'pb'@'localhost' identified by 'password' \
grant all privileges on pb.* to 'pb'@'localhost'\
EOF
 
# Add the schema
mysql -u pb -p pb < sql/tables.sql
rm -rf sql

Navigate to http://host/pb/