Database - Consolidated Changes

[ajpatterson]

These changes are a combination of those from meeting notes, tickets, and the page OmeModel/DatabaseComparison

• ROI:
  • Add "markerstart" to "shape" table
  • Add "markerend" to "shape" table
  • Add "name" to "roi" table
  • Rename "textvalue" in "shape" table to "text"
  • Rename "visibility" in "shape" table to "visible"
  • Rename "rx" in "shape" table to "radiusx"
  • Rename "ry" in "shape" table to "radiusy"
  • Delete "cx" in "shape" (now use "x")
  • Delete "cy" in "shape" (now use "y")
  • Delete "g" in "shape" table
  • Delete "fontWeight" in shape table (value needs to be merged with "fontStyle" see #8119)
  • Delete "fontStretch" in "shape" table
  • Delete "fontVariant" in "shape" table
  • Delete "strokeDashOffset" in "shape" table
  • Delete "strokeLineJoin" in "shape" table
  • Delete "strokeMiterLimit" in "shape" table
  • Delete "vectorEffect" in "shape" table
  • Delete "keywords" in "roi" table
  • Delete "pixels" in "roi" table
  • Change "namespaces" in "roi" table, which is currently a list of namespaces to be a single namespace called "namespace"
  • Add six floats to "shape" "a00","a10","a10","a11","a02","a12", to replace "transform"

• SPW:
  • Rename "posX" in "wellsample" table to "x"
  • Rename "posY" in "wellsample" table to "y"
  • Keep "type" and merge in values from "status" in "well" table
  • Delete "status" in "well" table
  • Add "UNIQUE" to "wellsample" child - see #2577
  • Change "image" in "wellsample" to be optional - see #8048
  • Rename "defaultSample" in "plate" to "FieldIndex?"

• Acquisition:
  • Rename "mode" in "channel" table to "acquisitionmode"
  • Rename "emissionWave" in "channel" table to "emissionwavelength"
  • Rename "excitationWave" in "channel" table to "excitationwavelength"
  • Rename "illumination" in "channel" table to "illuminationtype"
  • Rename "offsetvalue" in "detector" table to "offset"
  • Rename "offsetvalue" in "detectorsettings" table to "offset"
  • Rename "positionX" in "stagelabel" table to "x"
  • Rename "positionY" in "stagelabel" table to "y"
  • Rename "positionZ" in "stagelabel" table to "z"
  • Delete "otf" table and all associated columns
  • "pinHoleSize" to "pinholeSize"

• Image/Pixels
  • Rename "pixelstype" in "pixels" table to "type"
  • Delete "relatedto" in "pixels" table
  • Delete "methodology" in "pixels" table
  • Delete "waveIncrement" in "pixels" table
  • Delete "waveStart" in "pixels" table
  • Remove "archived" in "image"
  • Delete "partial" in "image"
  • Add the link table between image and microbeammanipulation - see #7954

• Group/Experimenter
  • Rename "omename" in "experimenter" table to "username"
• Channel/LogicalChannel merge photometric interpretation has been removed from the model in 2008. Removed entry from DB when merging LogicalChannel into Channel.

• ExperimentType/MicrobeamManipulationType
  • Add storage for lists of types to Experiment and MicrobeamManipulation - see #2883

---

• Deprecate pixels in DB (in next release move contents up to image)

[agilo]

Updated status, related task in progress