| 67 | |
| 68 | But, we also need to address the fact that the file types of the members in the file set must match the new item type. We can either change the file types to new types or we can change the item type on the existing file types. In the first case we update the !FileSetMembers table: |
| 69 | |
| 70 | || **!FileSetMembers** || **Comment** || |
| 71 | || id || Keep || |
| 72 | || version || +1 || |
| 73 | || fileset_id || Keep || |
| 74 | || datafiletype_id || Update to new type || |
| 75 | || ''other columns'' || Keep || |
| 76 | |
| 77 | If there are any remaining file types for raw bioassays that has been migrated we need to update them to derived bioassays instead. This is in the !DataFileTypes table: |
| 78 | |
| 79 | || **!DataFileTypes** || **Comment** || |
| 80 | || id || Keep || |
| 81 | || version || +1 || |
| 82 | || item_type || Change 264 (=RAWBIOASSAY) to 268 (=DERIVEDBIOASSAY) || |
| 83 | || ''other columns'' || Keep || |
| 84 | |
| 85 | Note that we don't do this for all file types, but only for the types that are used by the migrated raw bioassays. |