<?php
error_reporting(E_ALL);

require_once("/etc/gg/config.php");

$INC = dirname(__FILE__) . "/../inc";
require_once($INC . "/xlog.inc.php");
require_once($INC . "/db.inc.php");
require_once($INC . "/repo.inc.php");

$db = sql_open($gg_db);
if ($db === FALSE)
	fatal("Internal error (db)!");

// create repos table
$sql = "CREATE TABLE repos (repo_id INT PRIMARY KEY, uid INT, itime INT)";
$res = sql_query($db, $sql);
if ($res === FALSE)
	echo "WARN: Cannot create 'repo_access' table!\n";

// create repo_access table
$sql = "CREATE TABLE repo_access (repo_id INT, uid INT, perm CHAR(1), itime INT)";
$res = sql_query($db, $sql);
if ($res === FALSE)
	echo "WARN: Cannot create 'repo_access' table!\n";

$sql = "CREATE TABLE state (var TEXT PRIMARY KEY, value TEXT)";
$res = sql_query($db, $sql);
if ($res === FALSE)
	echo "WARN: Cannot create 'state' table!\n";

$sql = "CREATE TABLE keys (key_id INT PRIMARY KEY, itime INT, uid INT, key TEXT)";
$res = sql_query($db, $sql);
if ($res === FALSE)
	echo "WARN: Cannot create 'keys' table!\n";

$sql = "CREATE TABLE users (uid INT PRIMARY KEY, user TEXT, salt TEXT, pass TEXT, itime INT)";
$res = sql_query($db, $sql);
if ($res === FALSE)
	echo "WARN: Cannot create 'keys' table!\n";

echo "Done!\n";
?>