<?php
/**
 * Created by PhpStorm.
 * User: Aleksandar Veljanov
 * Date: 06.11.2016
 * Time: 19:21
 */
$dns = 'mysql:host=127.0.0.1;dbname=praktikum131088';
$username = 'root';
$password = '';
try {
    $pdo = new PDO($dns, $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $str = '-- -----------------------------------------------------
-- Table `news`.`news`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `news` ;

CREATE TABLE IF NOT EXISTS `news` (
  `news_id` INT NOT NULL AUTO_INCREMENT,
  `date` DATETIME NOT NULL,
  `news_title` VARCHAR(45) NOT NULL,
  `full_text` TEXT NOT NULL,
  PRIMARY KEY (`news_id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `news`.`comments`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `comments` ;

CREATE TABLE IF NOT EXISTS `comments` (
  `comment_id` INT NOT NULL AUTO_INCREMENT,
  `news_id` INT NOT NULL,
  `author` VARCHAR(45) NOT NULL,
  `comment` TINYTEXT NOT NULL,
  `approved` TINYINT(1) NULL DEFAULT 0,
  PRIMARY KEY (`comment_id`),
  INDEX `nid_idx` (`news_id` ASC),
  CONSTRAINT `news_id`
    FOREIGN KEY (`news_id`)
    REFERENCES `news` (`news_id`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

';
    $ps = $pdo->query($str);
    $ps->setFetchMode(PDO::FETCH_ASSOC);
}
catch (PDOException $exception){
    die("Could not connect to the database  :" . $exception->getMessage());
}