Changes between Version 17 and Version 19 of Ticket #1591


Ignore:
Timestamp:
Sep 12, 2011, 2:40:45 PM (13 years ago)
Author:
Nicklas Nordborg
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #1591 – Description

    v17 v19  
    1212 * '''Done [5703]'''. Convert `Hybridization` to `PhysicalBioAssay`. Copy information from the `Hybridizations` table to `PhysicalBioAssays`. Set new id on `BioMaterialEvents.physicalbioassay_id` column. Remove `BioMaterialEvents.hybridization_id` column. All "soft" relations (eg. item_type+item_id pairs) need to update the item_type column (261->267). Set the subtype on all existing hybridizations.
    1313 * '''Done [5703], [5730]'''. Convert `Scan` to `DerivedBioAssay`. Copy information from the `Scans` table to `DerivedBioAssays`. Copy information from `Images` table to `FileSetMember`. All "soft" relations (eg. item_type+item_id pairs) need to update the item_type column (262->268). Set the subtype on all existing scans.
    14  * Update `RawBioAssay` to point to the derived bioassay instead of the scan. Remove `scan_id` column. Populate `extract_id` column based on information in the `array_num` and the positions of biomaterials on the linked hybridization.
     14 * '''Done [5733]'''. Update `RawBioAssay` to point to the derived bioassay instead of the scan. Remove `scan_id` column. Populate `extract_id` column based on information in the `array_num` and the positions of biomaterials on the linked hybridization.
    1515 * '''Done [5730]'''. Drop unique contraint on `FileSetMember` table for `fileset_id` and `datafiletype_id` columns.
     16 * '''Done [5733]'''. Set `allow_multiple=false` for all existing platform file types.
    1617 * '''Done [5703], [5730]'''. Convert `ProtocolType`, `HardwareType`, `SoftwareType` and `FileType` to `ItemSubtype` and make sure all hard and soft references are updated. Drop tables and columns that are no longer used.