Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

User Story #8084 (accepted)

Opened 8 years ago

Last modified 4 years ago

Database - Consolidated Changes

Reported by: ajpatterson Owned by: jamoore
Priority: critical Milestone: GatherReqs
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 "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)

Change History (33)

comment:1 Changed 8 years ago by ajpatterson

  • Description modified (diff)

comment:2 Changed 8 years ago by ajpatterson

  • Description modified (diff)

comment:3 Changed 8 years ago by ajpatterson

  • Description modified (diff)
  • Keywords dbmodelcompare schema added

comment:4 Changed 8 years ago by jburel

  • Sprint set to 2012-03-13 (10)

comment:5 Changed 8 years ago by jburel

  • Cc jmoore jburel added
  • Sprint 2012-03-13 (10) deleted

comment:6 Changed 8 years ago by ajpatterson

  • Description modified (diff)

comment:7 Changed 8 years ago by ajpatterson

  • Description modified (diff)

comment:8 Changed 8 years ago by agilo

  • Status changed from new to accepted

Updated status, related task in progress

comment:9 Changed 8 years ago by ajpatterson

  • Description modified (diff)

comment:10 Changed 8 years ago by ajpatterson

  • Description modified (diff)

comment:11 Changed 8 years ago by ajpatterson

  • Description modified (diff)

comment:12 Changed 8 years ago by jburel

  • Description modified (diff)

comment:13 Changed 8 years ago by jburel

  • Description modified (diff)

comment:14 Changed 8 years ago by jburel

  • Description modified (diff)

comment:15 Changed 8 years ago by jburel

  • Description modified (diff)

comment:16 Changed 8 years ago by jburel

  • Description modified (diff)

comment:17 Changed 8 years ago by jburel

  • Description modified (diff)

comment:18 Changed 8 years ago by jburel

  • Description modified (diff)

comment:19 Changed 8 years ago by ajpatterson

  • Description modified (diff)

comment:20 Changed 8 years ago by jburel

  • Description modified (diff)

comment:21 Changed 8 years ago by jburel

  • Description modified (diff)

comment:22 Changed 8 years ago by ajpatterson

  • Description modified (diff)

comment:23 Changed 8 years ago by ajpatterson

  • Description modified (diff)

comment:24 Changed 8 years ago by ajpatterson

  • Description modified (diff)

comment:25 Changed 8 years ago by ajpatterson

  • Description modified (diff)

comment:26 Changed 8 years ago by ajpatterson

  • Description modified (diff)

comment:27 Changed 8 years ago by jburel

  • Description modified (diff)

comment:28 Changed 8 years ago by ajpatterson

  • Description modified (diff)

comment:29 Changed 8 years ago by jburel

  • Description modified (diff)

comment:30 Changed 8 years ago by jburel

  • Milestone changed from OMERO-Beta4.4 to OMERO-Beta4.5

comment:31 Changed 7 years ago by ajpatterson

  • Milestone changed from OMERO-5 to Future

comment:32 Changed 5 years ago by ajpatterson

  • Owner changed from ajpatterson to jamoore

comment:33 Changed 4 years ago by jamoore

  • Milestone changed from Future to GatherReqs
Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.402384 sec.)

We're Hiring!