Table differences between migrated and non-migrated databases

Depending on if a database is originally created with 5.x or 6.0 there are also differences in Foreign keys' CASCADE on delete.

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