User Story #8084 (accepted)
Opened 12 years ago
Last modified 8 years ago
Database - Consolidated Changes — at Version 15
Reported by: | ajpatterson | Owned by: | ajpatterson |
---|---|---|---|
Priority: | critical | Milestone: | OMERO-Beta4.4 |
Component: | General | Keywords: | dbmodelcompare, schema |
Cc: | jamoore, jburel | Story Points: | n.a. |
Sprint: | n.a. | Importance: | n.a. |
Total Remaining Time: | 0.0d | Estimated Remaining Time: | n.a. |
Description (last modified by jburel)
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 "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"
- 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
- 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 "oft" table and all associated columns
- Image/Pixels
- Rename "pixelstype" in "pixels" table to "type"
- 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
- Group/Experimenter
- Rename "omename" in "experimenter" table to "username"
- Deprecate logicalchannel in DB (in next release move contents up to channel)
- Deprecate pixels in DB (in next release move contents up to image)
- Delete "partial" in "image" table BUT as it is an fs work around check with Colin
- Add six floats to "shape" "a00","a10","a10","a11","a02","a12", to replace "transform"
Change History (15)
comment:1 Changed 12 years ago by ajpatterson
- Description modified (diff)
comment:2 Changed 12 years ago by ajpatterson
- Description modified (diff)
comment:3 Changed 12 years ago by ajpatterson
- Description modified (diff)
- Keywords dbmodelcompare schema added
comment:4 Changed 12 years ago by jburel
- Sprint set to 2012-03-13 (10)
comment:5 Changed 12 years ago by jburel
- Cc jmoore jburel added
- Sprint 2012-03-13 (10) deleted
comment:6 Changed 12 years ago by ajpatterson
- Description modified (diff)
comment:7 Changed 12 years ago by ajpatterson
- Description modified (diff)
comment:8 Changed 12 years ago by agilo
- Status changed from new to accepted
comment:9 Changed 12 years ago by ajpatterson
- Description modified (diff)
comment:10 Changed 12 years ago by ajpatterson
- Description modified (diff)
comment:11 Changed 12 years ago by ajpatterson
- Description modified (diff)
comment:12 Changed 12 years ago by jburel
- Description modified (diff)
comment:13 Changed 12 years ago by jburel
- Description modified (diff)
comment:14 Changed 12 years ago by jburel
- Description modified (diff)
comment:15 Changed 12 years ago by jburel
- Description modified (diff)
Note: See
TracTickets for help on using
tickets.
You may also have a look at Agilo extensions to the ticket.
Updated status, related task in progress