X-Git-Url: http://git.ithinksw.org/extjs.git/blobdiff_plain/0494b8d9b9bb03ab6c22b34dae81261e3cd7e3e6..7a654f8d43fdb43d78b63d90528bed6e86b608cc:/examples/image-organizer/php/sql/setup.php

diff --git a/examples/image-organizer/php/sql/setup.php b/examples/image-organizer/php/sql/setup.php
deleted file mode 100644
index a26fe3cd..00000000
--- a/examples/image-organizer/php/sql/setup.php
+++ /dev/null
@@ -1,72 +0,0 @@
-<?php
-/* The SQLite extension is enabled by default as of PHP 5.
- * Before that time the SQLite library is needed.
- *
- * For more info on setting up SQLite See:
- * http://www.php.net/manual/en/sqlite.installation.php
- *
- */
-    if ($db = new SQLiteDatabase('imgorg.db')) {
-        // Albums
-//        $db->queryExec('DROP TABLE Albums');
-        $db->queryExec('CREATE TABLE Albums (
-            id INTEGER PRIMARY KEY,
-            text STRING,
-            created STRING,
-            description TEXT
-        );
-        INSERT INTO Albums (text) VALUES ("Test");
-        INSERT INTO Albums (text) VALUES ("Album2");');
-
-        // Albums_Images
-//        $db->queryExec('DROP TABLE Albums_Images');
-        $db->queryExec('CREATE TABLE Albums_Images (
-            album_id INTEGER,
-            image_id INTEGER
-        )');
-
-        // Images_Tags
-        $db->queryExec('CREATE TABLE Images_Tags (
-            tag_id INTEGER,
-            image_id INTEGER
-        )');
-
-        // Tags
-//        $db->queryExec('DROP Table Tags');
-        $db->queryExec('CREATE TABLE Tags (
-            id INTEGER PRIMARY KEY,
-            text STRING
-        );
-        INSERT INTO Tags (text) VALUES("Family");
-        INSERT INTO Tags (text) VALUES("Friends");
-        INSERT INTO Tags (text) VALUES("Other")');
-
-        // Images
-//        $db->queryExec('DROP TABLE Images');
-        $db->queryExec('CREATE TABLE Images (
-            id INTEGER PRIMARY KEY,
-            filename STRING,
-            url STRING,
-            album_id INTEGER,
-            description TEXT
-        )');
-
-//        $dir = "../../images/thumbs/";
-//        $images = array();
-//        $d = dir($dir);
-//        $i = 0;
-//        while($name = $d->read()){
-//            if(!preg_match('/\.(jpg|gif|png)$/', $name)) continue;
-//            $size = filesize($dir.$name);
-//            $lastmod = filemtime($dir.$name)*1000;
-//            $db->queryExec('INSERT INTO Images (filename, url) VALUES
-//                ("'.$name.'","images/thumbs/'.$name.'")');
-//        }
-//        $d->close();
-
-
-        echo json_encode($db->query('select * from Images')->fetchAll());
-    } else {
-        die($err);
-    }
-