Table differences between migrated and non-migrated databases

From IMSMA Wiki
Revision as of 20:29, 1 August 2015 by Alnaucler (talk | contribs)
Jump to: navigation, search

If a database has been migrated from Legacy (at least from 2010) then some columns have been changed.

Table Column Initial 6.0 DB Migrated DB
hazard medicalfacilitylevel1 varchar(50) text
hazardinfoversion medicalfacilitylevel1 varchar(50) text
hazard medicalfacilitylevel2 varchar(50) text
hazardinfoversion medicalfacilitylevel2 varchar(50) text
hazreduc medicalfacilitylevel1 varchar(50) text
hazreducinfoversion medicalfacilitylevel1 varchar(50) text
hazreduc medicalfacilitylevel2 varchar(50) text
hazreducinfoversion medicalfacilitylevel2 varchar(50) text
hazreduc teamid varchar(38) varchar(50)
hazreducinfoversion teamid varchar(38) varchar(50)
hazreduc teamlocation varchar(50) text
hazreducinfoversion teamlocation varchar(50) text
translation translation varchar(250) text

I can see in the migration scripts that previously also the following columns were different.

Table Column
fieldreport reportedby
geopoint pointdescription
hazreduc qacomments
hazreducinfoversion qacomments
hazreduc vistor
hazreducinfoversion vistor
impactsurvey minehistorycomments
impactsurveyversion minehistorycomments