Mercurial > hg > savane-forge
diff migrate_old_savane.sql @ 83:45933e4a5aec
- Clean-up in the login code to reuse Django 'auth' app; if I removed
useful code, please add it back :)
- Renamed 'User' to 'ExtendedUser', and 'savane_user' to 'my';
eventually we could have a 'savane.frontend.my' app
- Fixed issues in SSH/GPG code where ExtendedUser fields were
requested on a User object
- Improved INSTALL documentation
- Added copyright/license notices
- Clarified Savane import script (still need to check why there's a
latin1 conversion)
- Converted trivial views by generic views
| author | Sylvain Beucler <beuc@beuc.net> |
|---|---|
| date | Mon, 27 Jul 2009 00:01:09 +0200 (2009-07-26) |
| parents | b1dc8db5040a |
| children | 09d27fd2ce8b |
line wrap: on
line diff
--- a/migrate_old_savane.sql +++ b/migrate_old_savane.sql @@ -1,3 +1,22 @@ -insert into auth_user (id, username, first_name, email, password, last_login, date_joined) select user_id, user_name, trim(convert(realname using latin1)), email, user_pw, now(), from_unixtime(add_date) from savane_old.user; +-- USE savane; + +-- 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' + FROM savane_old.user + WHERE user_id != 100; -insert into user (user_ptr_id, status,spamscore, confirm_hash, authorized_keys, authorized_keys_count, people_view_skills, people_resume, timezone, theme, email_hide, gpg_key, gpg_key_count) select user_id, status,spamscore, confirm_hash, authorized_keys, authorized_keys_count, people_view_skills, convert(people_resume using latin1), timezone, theme, email_hide, gpg_key, gpg_key_count from savane_old.user; +-- Import all extended information except for the 'None' user (#100) +INSERT INTO my_extendeduser + (user_ptr_id, status, spamscore, authorized_keys, + authorized_keys_count, people_view_skills, people_resume, + 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, + email_hide, gpg_key, gpg_key_count + FROM savane_old.user + WHERE user_id != 100;