diff options
Diffstat (limited to 'www')
| -rw-r--r-- | www/setup.php | 36 |
1 files changed, 0 insertions, 36 deletions
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 @@ -<? - -$db = new SQLite3("../database/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!" ; - } -} |
