I need to convert an existing db table to a new db table which adds a new column.
I have the following sql code which set the default value of this column to be -1.

```
// Insert new column for holding appWidgetIds
db.execSQL("ALTER TABLE favorites " +
   "ADD COLUMN appWidgetId INTEGER NOT NULL DEFAULT -1;");

```

But how can i set the default value of the column to increment one by one for each row?