public function insertInitialData()
{
$insert_sql = "INSERT INTO `restaurants` (`id`,`name`,`description`,`phone`,`lat`,`lng`,`created_at`, `pricegroup`)\r\n\t\t\tVALUES\r\n\t\t\t(1,'Burger Joint','Awesome burgers','8483756',64139078,-21936757,'2009-10-08 10:16:00', 3),\r\n\t\t\t(2,'Pizza Joint','The best Pizza Joint',NULL,64135603,-21954812,'2009-10-08 10:16:20', 2),\r\n\t\t\t(3,'Asian Joint','blabla',NULL,64136603,-21953812,'2009-10-08 10:16:20', 1);";
$this->pdo->exec($insert_sql);
$insert_sql = "INSERT INTO ratings (restaurant_id, rating) VALUES\r\n\t\t\t(1, 5),\r\n\t\t\t(1, 5),\r\n\t\t\t(2, 4),\r\n\t\t\t(3, 3);";
$this->pdo->exec($insert_sql);
}
private function createUserTable()
{
$drop_sql = "DROP TABLE IF EXISTS users";
$sql = "CREATE TABLE `users` (\r\n\t\t\t\t`id` INT(11) NOT NULL AUTO_INCREMENT ,\r\n\t\t\t\t`firstName` VARCHAR(40) NOT NULL,\r\n\t\t\t\t`lastName` VARCHAR(40) NOT NULL,\r\n\t\t\t\t`email` VARCHAR(255) NOT NULL ,\r\n\t\t\t\t`password` VARCHAR(128) NOT NULL ,\r\n\t\t\t\t`apikey` CHAR(40) NOT NULL ,\r\n\t\t\t\tPRIMARY KEY (`id`)\r\n\t\t\t\t) ENGINE = MYISAM";
$this->pdo->exec($drop_sql);
$this->pdo->exec($sql);
}
private function createReviewTable()
{
$drop_sql = "DROP TABLE IF EXISTS reviews";
$sql = "CREATE TABLE `reviews` (\n\t\t\t\t`id` INT(11) NOT NULL AUTO_INCREMENT ,\n\t\t\t\t`restaurant_id` INT(11) NOT NULL ,\n\t\t\t\t`review` TEXT NOT NULL ,\n\t\t\t\t`user_id` INT(11) NOT NULL,\n\t\t\t\t`created_at` TIMESTAMP DEFAULT NOW(),\n\t\t\t\tPRIMARY KEY (`id`)\n\t\t\t\t) ENGINE = MYISAM";
$this->pdo->exec($drop_sql);
$this->pdo->exec($sql);
}
