<?php
require '../utils/dbPDO.php';
$dalingk = new dalingkDB();
$db = $dalingk->connect();
$db->beginTransaction();
$db->query("DROP TABLE `MIS314`.`dvdtitles`");
$db->query("CREATE TABLE `dvdtitles` (`asin` varchar(15) NOT NULL, `title` varchar(100) NOT NULL, `price` double(5,2) NOT NULL, PRIMARY KEY (`asin`))");
$db->query("INSERT INTO `MIS314`.`dvdtitles` VALUES ('B003Y5H5B0','21 Jump Street',9.66),('B00SI7GCJK','Interstellar',14.96),('B00NX6WZIS','The Equalizer',14.99),('B00OV3VGP0','John Wick',12.99)");
$db->commit();
$db->beginTransaction();
$db->query("DROP TABLE `MIS314`.`dvdactors`");
$db->query("CREATE TABLE `MIS314`.`dvdactors` (`actorID` int(5) auto_increment NOT NULL, `fname` varchar(20) NOT NULL, `lname` varchar(20) NOT NULL, PRIMARY KEY (`actorID`))");
$db->query("INSERT INTO `dvdactors` VALUES (1,'Matthew','McConaughey'),(2,'Anne','Hathaway'),(3,'Channing','Tatum'),(4,'Ice','Cube'),(5,'Keanu','Reeves'),(6,'Willem','Dafoe'),(7,'Denzel','Washington'),(8,'Marton','Csokas')");
$db->commit();
$db->beginTransaction();
$db->query("DROP TABLE `dvdactorstitles`");
$db->query("CREATE TABLE `MIS314`.`dvdactorstitles` (`asin` VARCHAR(15) NOT NULL, `actorID` INT(5) NOT NULL, PRIMARY KEY (`asin`, `actorID`))");
$db->query("INSERT INTO `MIS314`.`dvdactorstitles` VALUES ('B003Y5H5B0',3),('B003Y5H5B0',4),('B00NX6WZIS',7),('B00NX6WZIS',8),('B00OV3VGP0',5),('B00OV3VGP0',6),('B00SI7GCJK',1),('B00SI7GCJK',2)");
$db->commit();
echo "Initialization of databases sucessful!";
?>