<?php


echo '<p>Creating images table... ';

$images_sql = "
CREATE TABLE `".$_POST["table_prefix"]."images` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `description` varchar(255) default NULL,
  `filename` varchar(255) default NULL,
  `votes_for` int(11) NOT NULL default '0',
  `votes_against` int(11) NOT NULL default '0',
  `rank` int(11) NOT NULL default '1500',
  `approved` int(11) NOT NULL default '0',
  `submitted_by` varchar(32) default NULL,
  PRIMARY KEY  (`id`)
) DEFAULT CHARSET=utf8";

if(query($images_sql)) {
	echo 'done.</p>';
}
else {
	echo 'ERROR '.mysql_error().'</p>';
	die;
}


$votes_sql = "
CREATE TABLE `".$_POST["table_prefix"]."votes` (
  `image1_id` int(11) default NULL,
  `image2_id` int(11) default NULL,
  `winner` tinyint(4) default NULL
) DEFAULT CHARSET=utf8";

echo '<p>Creating votes table... ';
if(query($votes_sql)) {
	echo 'done.</p>';
}
else {
	echo 'ERROR '.mysql_error().'</p>';
	die;
}

$users_sql = "
CREATE TABLE `".$_POST["table_prefix"]."users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `password` varchar(128) default NULL,
  PRIMARY KEY  (`id`)
) DEFAULT CHARSET=utf8";

echo '<p>Creating users table... ';
if(query($users_sql)) {
	echo 'done.</p>';
}
else {
	echo 'ERROR '.mysql_error().'</p>';
	die;
}

echo '<p>Adding admin user '.$_POST["user"].'...';

$password_salt = randomCharString(6);

$data = array(
	'username' => $_POST["user"],
	'password' => passwordHash($password_salt.$_POST["password"])
);

$sql = getInsertSQL($_POST["table_prefix"].'users', $data);

if(query($sql)) {
	echo ' done.</p>';
}
else {
	echo ' ERROR! '.mysql_error().'</p>';
	die;
}

?>