<?php

$db = new SQLite3("db/dict.db");
$bool = false;

foreach ($_GET as $name => $value) {
	if(preg_match("/drop(ped)?/i",$name)){
		$bool=true;
	}
}

if($bool){
	if($db->exec("
		BEGIN TRANSACTION;
		PRAGMA writable_schema = 1;
		DELETE FROM sqlite_master WHERE type = 'table';
		PRAGMA writable_schema = 0;
		COMMIT;
		VACUUM;")
	){
		echo "dropped everything";
	} else {
		echo "error with database";
	}
} else {
	if($db->exec("
	BEGIN TRANSACTION;
	CREATE TABLE IF NOT EXISTS english (id INTEGER PRIMARY KEY, word TEXT UIQUE);
	CREATE TABLE IF NOT EXISTS german (id INTEGER PRIMARY KEY, word TEXT UIQUE);
	COMMIT;")
	) {
		echo "Success!";
	} else {
		echo "Failure!"	;
	}
}