slork/sqlite.php

<?php

$pdo = null;
try {
	$pdo = new PDO("sqlite:" . './slork.sqlite');
} catch (PDOException $e) {
	// handle the exception here
}
if ( !$pdo ) {
	exit( "Cannot connect to database" );
}

// Create maintainer database
$pdo->exec("DROP TABLE IF EXISTS maintainer;");
$query = <<<QUERY
CREATE TABLE IF NOT EXISTS maintainer (
		id INTEGER PRIMARY KEY, maintainer INTEGER, api TEXT, 
		properties TEXT DEFAULT '["name"]',
		UNIQUE( maintainer ));
QUERY;
$stmt = $pdo->exec( $query );
//$stmt->execute();

// Create user/player database
$pdo->exec("DROP TABLE IF EXISTS player;");
$query = <<<QUERY
CREATE TABLE IF NOT EXISTS player (
		id INTEGER PRIMARY KEY, maintainer INTEGER,
		player INTEGER, property TEXT, value TEXT,
		FOREIGN KEY (maintainer) REFERENCES maintainer(maintainer));
QUERY;
$stmt = $pdo->exec( $query );
//$stmt->execute();