Mercurial > hg > savane-forge
changeset 86:09d27fd2ce8b
Suppress warnings and extra latin1 conversion in savane_old migration script
author | Sylvain Beucler <beuc@beuc.net> |
---|---|
date | Mon, 27 Jul 2009 11:34:09 +0200 |
parents | 2fbfe0cfbd88 |
children | 17623d457b70 |
files | migrate_old_savane.sql |
diffstat | 1 files changed, 6 insertions(+), 4 deletions(-) [+] |
line wrap: on
line diff
--- a/migrate_old_savane.sql +++ b/migrate_old_savane.sql @@ -3,9 +3,11 @@ -- Import all users except for the 'None' user (#100) INSERT INTO auth_user (id, username, first_name, last_name, email, - password, last_login, date_joined, is_active) - SELECT user_id, user_name, trim(convert(realname using latin1)), '', email, - CONCAT('md5$$', user_pw), now(), FROM_UNIXTIME(add_date), status='A' + password, last_login, date_joined, is_active, + is_superuser, is_staff) + SELECT user_id, user_name, realname, '', email, + CONCAT('md5$$', user_pw), now(), FROM_UNIXTIME(add_date), status='A', + 0, 0 FROM savane_old.user WHERE user_id != 100; @@ -16,7 +18,7 @@ timezone, theme, email_hide, gpg_key, gpg_key_count) SELECT user_id, status, spamscore, authorized_keys, authorized_keys_count, people_view_skills, - CONVERT(people_resume USING latin1), timezone, theme, + people_resume, timezone, theme, email_hide, gpg_key, gpg_key_count FROM savane_old.user WHERE user_id != 100;