#1 Allow 1.2.0 to work with sqlite backend

[sdaau]

This patch is done in respect to http://kent.dl.sourceforge.net/sourceforge/homeinv/home_inv-1.2.0.tar.bz2; it should allow that the built-in sqlite 2 engine with PHP 5 can be used as well with Home Inventory (homeinv); since it uses

PDO for PHP 4 (pdo, wordpress) - PHP Classes
http://www.phpclasses.org/browse/package/2572.html

it should also be able to connect to a sqlite3 database via PDO (if PDO is installed). If the Sqlite path definition is commented in environment.php, the homeinv engine should revert back to its old MySQL use.
SQLite specific table creation SQL is included as well; to construct a SQLite database file, use

SQLite Database Browser
https://sourceforge.net/project/showfiles.php?group_id=87946&package_id=91778

and paste the SQL statements therein.. Note that SQLite Database Browser 1.1 works with sqlite2 databases - all versions above deal with sqlite3 databases.

Note also that the SQLite file (if on a Linux server) needs both to be owned by the Apache process, and have chmod 777 - if you have no such access, you can use the upl.php script which the patch will generate, to upload your database file to the server.

A quick view of the patch can be seen on http://pastebin.com/f357a9fec; the one attached also includes all source files of "PDO for PHP 4" too...

[sdaau]

patch to allow Home Inventory (homeinv) to use the built-in PHP5 Sqlite2 as database backend