[RESOURCE] SQL command set to migrate from identity in TG 0.9a4 (and before) to 0.9a5

[godoy]

Since the identity model was changed and to avoid having to recreate all tables, this script will help with the migration of a PostgreSQL database with the standard tables at the public schema (if you don't know if this is your case, then it probably is ;-) -- if you did nothing to change identity and uses SQLObject, then run this).

Please, also note that all changes in code that you might need for your own customized user creation routines / checks will need to be updated by you. If you're using the commands shown in the wiki, you might be lucky and need no change at all.

This has been tested on two development databases and one production database (yep, running SVN code as of today ;-)).

I believe this could be included somehow in the "UPDATE" notices or in an auxiliary directory and mentioned in the docs.

[godoy]

Table migration SQL script for PostgreSQL. Updates tables from identity in 0.9a4 (and before) to 0.9a5

[godoy]

Forgot the install instructions:

psql -f identity-migrate-09a4-to-09a5.sql your_database

[max]

sql script for MySQL

[max]

added MySQL script

[kevin]

A note of this has been made in the CHANGELOG and the upgrading guide. Thanks!

[bobkuehne@…]

Table migration SQL script for SQLite. Updates tables from identity in 0.9a4 (and before) to 0.9a5