--- /dev/null
+<?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);
+ }
+