On 14 April 2011 18:26, howesc <[email protected]> wrote:
> Johann,
>
> the steps as i see it:
> - add new uuid field for your new primary key, don't drop old one yet
> - fill in the uuid field
> - add a new foreign key field that will store UUID
> - use the old foreign key to lookup the uuid of the reference
> - store that uuid
> - alter tables to make the uuid fields the primary and foreign keys from
> the database's perspective
> - drop the old id columns
>
> you'll have to do that with some sql scripting, and then update your web2py
> model files accordingly.
>
>
Thanks Christian. That sounds doable.
Regards
Johann
--
May grace and peace be yours in abundance through the full knowledge of God
and of Jesus our Lord! His divine power has given us everything we need for
life and godliness through the full knowledge of the one who called us by
his own glory and excellence.
2 Pet. 1:2b,3a
