[ome-devel] List of DB updates

[Ilya Goldberg]

This is an attempt to finalize a list of DB changes we would like to 
see in the forthcoming 2.4.1 release.
Please consider these, prioritize them, suggest which should be 
implemented in a later release, etc.
Probably only the first five are seriously needed in 2.4.1.

* Change CONFIGURATION.VALUE to type text (bug 460).
* Change ST FilenamePattern.Basename to text to allow storing comma 
separated values rather than integer (to get the full basename from 
several RE 'parts').  Requested by Nico Stuurman to support his 
filename naming scheme from a Beckman screening scope (Bug 484)
* Add group owner to MODULE_EXECUTIONS, fix bug 469 (attribute 
ownership inherits from MEX)
* Not NULL constraint on attribute's MEX column (bug 485).
* Not NULL constraint on MEX experimenter column (bug 468).
* ST foreign key constraints for references (PKs already declared) (Bug 
486).
* ST constraints (not NULL, specifically) (Bug 393)
* Normalize "Plane" and "Stack" STs (i.e. finalize data model).  Use a 
reference to it for PlaneStatistics.  Do the same for "Stack" ST.  When 
this is done, convert plane/stack stats to class-per-table.  Clean up 
back-end code that deals with non-class-per-table.  Consider 
eliminating table/column specification from STs by adopting a 
table/column naming convention.
* USER_STATE => key-value (like CONFIGURATION).  New table with 
session_id referring to OME_SESSIONS?  If so, remove extra columns from 
OME_SESSIONS.


-Ilya