PHP CS252

bash.sh

sudo apt-get install apache2
netstat -an | more
cd /var/www
sudo apt-get install libapache2-mod-php5
sudo apt-get install php5-mysql

db.sql

CREATE DATABASE `cs252`;
CREATE USER 'cs252_admin'@'localhost' IDENTIFIED BY 'adminuser';
GRANT ALL PRIVILEGES ON `cs252`.* TO 'cs252_admin'@'localhost';
CREATE TABLE `cs252`.`users` (
    `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `username` VARCHAR(50) NOT NULL UNIQUE,
    `password` CHAR(128) NOT NULL
);
CREATE TABLE `cs252`.`files` (
    `username` VARCHAR(50) NOT NULL,
    `filename` VARCHAR(50) NOT NULL
);