custom field: change type from integer to currency?

[wivaku]

I have a custom field in the Opportunities module (Sugar 5.1b Professional Onsite running on Linux with MySQL 4.1), would like to change it from type "integer" to type "currency".

I can not change the type using the Sugar Studio, but perhaps there are other -more manual- ways to achieve it? Any suggestions?

Current settings:
- data type: integer
- field name: mix_sw_c
- default value: 0
- max size: 11

[kuske]

The real best way ist to create a new field and copy the old values to the new column in database.

But you can change it by hand too - it is risky, do not try it without a actual backup of your system.

STOP the webserver !

In mySQL table fields_meta_data you must change values :
- type from int to currency
- len from 11 to 255

In your custom table xxx_cstm you must change definition
of mix_sw_c from integer to varchar(255).

Start the Webserver but disable any user login (e.g. change entry address)

Login as admin and run admin - repair -quick repair !

Test the correct values.... if diffenences - fallback

[wivaku]

Good suggestions, thanks, will try them!