metadata description field

[stebjan]

In the table SCENARIO and HARDWARE, there is the description field set as "text" data type. It allows storing longer description. However, in other tables, there is this field set as "character varying". Is it possible to change all description fields as "text" data type?

[bydga]

Sure it is possible. So which all columns should be affected? Only this two mentioned? I will rewrite the hibernate annotations + write sql alter script tomorrow.

[stebjan]

This two mentioned (scenario and hardware) have description field already as "text" data type. I thought, that all description fields in tables: analysis, datafile, disease, license, pharmaceutical, project_type, research_group, software, stimulus, stimulus_type, subject_group, weather should be also redefined as "text" data type.

[jezekp]

may I close it?