[Treebase-devel] FYI: Upcoming (minor) schema changes

[Vladimir G. <vla...@du...>]

I am going to set up the schema patching workflow and test-run it to  
create indexes and a couple more changes.  Let me know if there are  
any concerns.

The two minor changes are

* Drop geospot_id_sequence -- there is no corresponding table
* Correct PK name in stepmatrixelement and create  
stepmatrixelement_id_sequence

As for the indexes, Bill has suggested these lately:

         Table				Field
         --------			-------
         taxon				name
         taxonvariant			fullname
         taxonlabel			taxonlabel
         citation			title
         citation			abstract
         person				lastname"
         phylotreenode    		taxonlabel_id, phylotree_id

Bill suggested explicitly specifying btree indexes -- I'll go with  
that (rather than Pg default, whatever it is), unless someone suggests  
otherwise.

--VG