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;