[Core-lan-org-devel] MySQL integrated into main CVS

[Andrew S. <and...@pa...>]

Hi all,

I've ported across the org-mysql files into the main CVS.  For most of
the code this was done by merging the two code bases.  I'm confident
this will be reasonably bug free, because I've been stress testing
org-mysql for a few weeks now.

The /tasks directory was a bit harder.  I've done a rough merge, then
lots and lots of patching up, because the two code bases are a long way
apart. There will be some bugs here!  However, I've done some limited
testing of both MySQL and PostgreSQL, and all seems to be working
flawlessly.

I'll start thoroughly testing, debugging and cleaning up now. 
Practically every file has been altered...

Also, I've added an extra column to the tasks table as per org-mysql. 
The extra column is projectid, and contains the taskid of the mother
project.  This starts to work well when the tasks are nested more than
one layer deep.  No longer does project_list have to recursively search
every task for children - on a slow machine the time savings are very
noticeable.  In task_edit, task_add and emails, we also now show the
project and parent of a task (without recursively searching).

There is a file /includes/update.php to populate the projectid column
for existing pgsql data. 

A few more things are in the Changelog.

Andrew