We're using SQLite 2 instead of SQLite3

I'm not sure what needs to be done to switch, but apparently one of the
reasons we've been having issues with SQLite is we're using 2.1 format
instead of 3.

For example, 2.1 doesn't support DISTINCT, which we are using in reports,
but 3 does

It was pretty straightforward to convert the database using the commandline
utilities:

sqlite2 drydock.sqlite .dump > drydockdump
sqlite3 drydock.db3 < drydockdump

This could be pushed back to 032 since I wanted to rewrite SQLite anyway,
but I'm not sure what exactly we even need to do to use SQLite3 with php
(and I don't really have time right now to look into it).

Original issue reported on code.google.com by TaQS...@gmail.com on 11 Aug 2009 at 6:56

smellyrat / drydock

We're using SQLite 2 instead of SQLite3 #80