

<? 

	try 
{
  //create or open the database
  $database = new SQLiteDatabase('DatabaseSocial.sqlite', 0666, $error);
}
catch(Exception $e) 
{

  die($error);
}

//add Movie table to database
$query = 'CREATE TABLE Admin ' .
         '(id_test INTEGER PRIMARY KEY, Test_Question CLOB NOT NULL);'.
		 
		 'CREATE TABLE RispostaUtente ' .
		 '(id_testUtente INTEGER, NickNameRisposta CHAR(20), Data Date(11), Answer VarChar(100), 
		 FOREIGN KEY(id_testUtente) REFERENCES Admin(id_test) );'.
		 
		 'CREATE TABLE Opzioni'.
		 '(Modalita char(10));'.
		 
		 'CREATE TABLE logAdmin'.
		 ' ( name CHAR(20) );'.
		 
	
		 
		 'CREATE TABLE Utente ' .
		 '(IdUtente INTEGER PRIMARY KEY, NickName CHAR(20), DataIscrizione Date(11))';
		 
if(!$database->queryExec($query, $error))
{ 
  die($error);
}else{Print("DATABASE CREATO");}

    ?>