From f4c30ebad16c0b72aaf122dab4fb193c780e2ac9 Mon Sep 17 00:00:00 2001 From: root Date: Wed, 26 Feb 2014 17:27:15 +0100 Subject: finished build, now it's time for the front end --- blob/setup.php | 36 ++++++++++++++++++++++++++++++++++++ www/setup.php | 36 ------------------------------------ 2 files changed, 36 insertions(+), 36 deletions(-) create mode 100644 blob/setup.php delete mode 100644 www/setup.php diff --git a/blob/setup.php b/blob/setup.php new file mode 100644 index 0000000..79a7fdd --- /dev/null +++ b/blob/setup.php @@ -0,0 +1,36 @@ + $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!" ; + } +} diff --git a/www/setup.php b/www/setup.php deleted file mode 100644 index 79a7fdd..0000000 --- a/www/setup.php +++ /dev/null @@ -1,36 +0,0 @@ - $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