TomCamin

apt-get update && apt-get upgrade
apt-get install mysql-server mysql-client
apt-get install apache2 apache2-doc
apt-get install php5 php5-mysql libapache2-mod-php5 php5-curl
apt-get install perl libapache2-mod-perl2
apt-get install python libapache2-mod-python
apt-get install phpmyadmin

# Composer
php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"

TomCamin

CREATE DATABASE opendata_bus;

USE opendata_bus;

DROP TABLE IF EXISTS agency;
CREATE TABLE `agency` (
    id INT(12) NOT NULL PRIMARY KEY AUTO_INCREMENT,
    agency_name VARCHAR(255) NOT NULL,
    agency_id VARCHAR(100),
    agency_url VARCHAR(255) NOT NULL,