-------------------------------------------------------------------------
POPFile SQLite Database Status Check v0.0.7 (stand-alone) 11 January 2006
-------------------------------------------------------------------------

This utility performs some integrity checks on the SQLite database file
used by POPFile 0.21.0 or later. POPFile should be shut down before this
utility is run (otherwise this utility will not be able to open POPFile's
database file).

The Windows version of POPFile installs a command-line utility which can
be used to examine and modify the SQLite database. One of the most common
uses of this command-line utility is to perform an integrity check to see
if the SQLite database has been "damaged" or corrupted.

Although the POPFile installer creates a shortcut to make it easy to use
the SQLite command-line utility (the "Run SQLite utility" shortcut in the
'User Data' folder), the utility runs in a DOS-box and it is necessary to
type in commands to make the SQLite utility do anything.

NOTE: If a mistake is made when typing these commands into the SQLite
      utility then _serious_ database corruption could occur!

The "POPFile SQLite DB Status Check" utility (pfidbstatus.exe) is a small
Windows program which automatically runs the SQLite utility, supplies the
necessary commands to it and then shows the results. The StatusReport.txt
file contains a typical set of results.

The pfidbstatus.exe file can be run from any folder and it should be able
to find POPFile's SQLite database file itself.

If you have more than one POPFile SQLite database then you can either place
the utility in the same folder as the database (assuming it uses the default
'popfile.db' filename) or you can supply the name or the full path to the
database on the command-line or via a suitable shortcut, e.g.

     pfidbstatus.exe my_data.db
or
     pfidbstatus.exe C:\Data Files\POPFile\database.db
or
     pfidbstatus.exe /registry

(using '/registry' forces the utility to use the user-specific registry data
created by the installer/'Add POPFile User' wizard to find the database file)

Some early versions of POPFile did not store the POPFile schema version in
the database so the following "error" can probably be ignored (it just means
this database belongs to an old version of POPFile - if you upgrade to the
current version the database will be upgraded to include the schema version
number):

     SQLite error detected when extracting POPFile schema version:
     (SQL error: no such table: popfile)

Usually the "POPFile SQLite Database Status Check" utility will use the SQLite
utility from the current POPFile installation but if an incompatible version
is detected then a "built-in" compatible SQLite utility will be used instead.

Although the official POPFile releases only work with SQLite 2.x databases,
this utility is "SQLite 3.x aware" (so it can be used by any Windows users
adventurous enough to be using POPFile with SQLite 3.x).
-------------------------------------------------------------------------
CHANGE HISTORY:

11-Jan-06 (v0.0.7)  When the database size is over 1,000 KB the value is now
                    shown using the current Operating System setting for the
                    "thousand" separator (instead of always using a comma).

11-Jan-06 (v0.0.6)  The report now includes the size of the SQLite database.
                    (v0.0.5 was never released)

21-Jul-05 (v0.0.4)  To make it easier for the installer to use this utility
                    a new '/REGISTRY' option is supported and two variants
                    are now available: this 'stand-alone' one and a smaller
                    'integrated' one which does not include sqlite.exe. The
                    report now includes the current Windows username and if
                    the integrity check is successful it is now much easier
                    to see which database file was examined.

12-Jul-05 (v0.0.3)  sqlite.exe v2.8.12 causes GPFs when pfidbstatus.exe
                    tries to use it to execute SQL commands so a compatible
                    sqlite.exe is now included for use when sqlite v2.8.12
                    is detected on the target system (the Windows version
                    of the current POPFile release uses sqlite.exe v2.8.15).

09-Jul-05 (v0.0.2)  Corrected the typo in the window title bar.

09-Jul-05 (v0.0.1)  First public release.
-------------------------------------------------------------------------
License:

This utility is free software; you can redistribute it and/or modify it
under the terms of version 2 of the GNU General Public License as
published by the Free Software Foundation.

This utility is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with POPFile; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
-------------------------------------------------------------------------
Brian Smith

POPFile (Bleeding Edge - Source Code) Discussion Forum:
http://sourceforge.net/forum/forum.php?forum_id=230652
-------------------------------------------------------------------------
(end)