<?php
try
{
  print ('Now:       '. time() ."\n");
  require_once "helper.php";

  $dbh = db_connect("pineapple");

  $statement = "create schema if not exists pineapple_users";
	$stmt = $dbh->prepare($statement);
	$count = $stmt->execute();

  $db = NULL;

  $dbh = db_connect("pineapple_users");
	
  $statement = <<<END
create table user
(
  email varchar(100) not null default "",
  primary key (email)
)
END;

	$stmt = $dbh->prepare($statement);
	$count = $stmt->execute();

/*	
	$stmt = $dbh->prepare("INSERT INTO REGISTRY (name, value) VALUES (:name, :value)");
	$stmt->bindParam(':name', $name);
	$stmt->bindParam(':value', $value);

	// insert one row
	$name = 'one';
	$value = 1;
	$stmt->execute();
*/
	print ($count);

  $db = NULL;
}
catch (PDOException $e)
{
  print ("$e\n");
}
?>
