--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/models/home.php	Tue Mar 17 10:54:13 2015 +0100
@@ -0,0 +1,41 @@
+<?php
+
+class HomeModel {
+	public function Index() {
+		return array("Index Value 1", "Value 2", "Value 3");
+	}
+    
+    public function Test() {
+
+    	/* uncomment to do the merge
+    	// merge books table with books_info table
+    	$query = "SELECT books_info.volume, books_info.author, books_info.edition, books_info.books_id FROM books INNER JOIN books_info ON books.id=books_info.books_id";
+    	
+    	$result = mysql_query($query);
+        if (!$result) {
+            return json_encode("Failed during selecting books, books_info table.");
+        }
+        $query = "ALTER TABLE books_v1 ADD Column volume VARCHAR(50), ADD Column author VARCHAR(100), ADD Column edition VARCHAR(100);"
+        $result_alter = mysql_query($query);
+
+        while ($row = mysql_fetch_assoc($result)) {
+        	// insert row into books_v1 table
+        	echo $row['volume'].$row['author'].$row['edition'].$row['books_id'];
+            
+            $query_update = "UPDATE books_v1 SET `volume`='".$row['volume']."', `author`='".$row['author']."',`edition`='".$row['edition']."' WHERE `id`='".$row['books_id']."'";
+				      
+            $result_update= mysql_query($query_update);
+            if (!$result_update) {
+                echo json_encode("error");
+
+            }
+        }
+		*/
+        return;
+    }
+    
+}
+
+
+
+?>
\ No newline at end of file