******************************
*
* Notes for trees database.
*
******************************

1..  Assumes that tree_id is unique.
Not sure if I have checked that or if I prevent it.


2.. Kerbos Probably need to tighten up check of count of records returned.
Need one and only one record
... probably should ensure that name id unique also 
(Need to add user maintanence stuff.

3... I would like to move the kerbos.php into a sub-directory (with all the user  maintanence
There are probably other "admin " functions that could reside there.

4.. The default query ("SELECT * FROM trees AS a LEFT OUTER JOIN photos AS b ON a.tree_id = b.tree_id" ) 
This returns a record for every photo ..
.. the current filter by php is not satisfactory.
i) should be able to select what we want using SQL only
ii) The current php filter will drop a tree if it has photos, but they are all set to "0" (not current).
iii) Maybe need to re-visit the whole "current photo" thing.

5.. Photo_add.php : Need to handle adding a comment attached to the photo (add field to form; clean up input (just like kerbos) & save).

6.. Investigate how to add fields to a table so taht trees table can have more information.

7.. report from trial: export a list (everytree to have an observation?) in csv format.
select * from observations by tree_id by date.  
?with some data from trees table.

8 .. Check what's happening with photo to display following photo upload.