From c5639ee890215e4e8e0f544821ea8d285ca58eb8 Mon Sep 17 00:00:00 2001
From: root
Date: Sat, 13 Sep 2014 22:26:58 +0200
Subject: init

---
 blob/yt_setup.php | 36 ++++++++++++++++++++++++++++++++++++
 1 file changed, 36 insertions(+)
 create mode 100644 blob/yt_setup.php

(limited to 'blob/yt_setup.php')

diff --git a/blob/yt_setup.php b/blob/yt_setup.php
new file mode 100644
index 0000000..263829e
--- /dev/null
+++ b/blob/yt_setup.php
@@ -0,0 +1,36 @@
+<?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!"	;
+	}
+}
-- 
cgit v1.2.3