Android Ormlite change model field type
<p>I want to change model field types from double to BigDecimal and from String to BigDecimal ( see below ). </p>

<p>Old model:</p>

<pre><code>@DatabaseField
private double val1;
@DatabaseField
private String val2;
@DatabaseField
private double val3;
</code></pre>

<p>New model : </p>

<pre><code>@DatabaseField
private BigDecimal val1;
@DatabaseField
private BigDecimal val2;
@DatabaseField
private BigDecimal val3;
</code></pre>

<p>Should I make any changes in onUpgrade method and increase database version ? What approach should I choose to do it correct ? </p>

<p>For example: </p>

<ol>
<li>copy val1 column to copy_val1</li>
<li>remove val1 column, and create new one ( correct column type )</li>
<li>copy data from copy_val1 to val1 column with casting</li>
<li>remove copy_val1 column</li>
</ol>