<?php
require_once('config.php');

try {
  $dbh = new PDO( 
    'mysql:host='.MYSQL_HOST.';dbname='.MYSQL_BASE.'', MYSQL_USER, MYSQL_PASS, 
    array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8") 
  );
}

catch (PDOException $pe)
{
  die ("Hiba: ".$pe->getMessage());
}

$instab="CREATE TABLE IF NOT EXISTS ". MYSQL_PREFIX."nj (
`Nev` VARCHAR ( 255 ) NOT NULL PRIMARY KEY,
`Email` VARCHAR ( 255 ) NOT NULL UNIQUE
) CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB";

//  Létrehozzuk a táblát, ha nincs.
try {
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    /*** begin the transaction ***/
     $dbh->beginTransaction();
 }

 catch (PDOException $pe) {
  $dbh = null;
   die ("Hiba: ".$pe->getMessage());
 }
try {
    $dbh->exec($instab);
     $dbh->commit();
    $dbh = null;
}
catch (PDOException $pe)
{
   $dbh->rollBack();
  die ("Hiba: ".$pe->getMessage());
}


?>