Mercurial > hg > savane-forge

annotate migrate_old_savane.sql @ 86:09d27fd2ce8b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 45933e4a5aec
children beba59837ded
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
83
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
1 -- USE savane;
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
2
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
3 -- Import all users except for the 'None' user (#100)
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
4 INSERT INTO auth_user
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
5 (id, username, first_name, last_name, email,
86
09d27fd2ce8b Suppress warnings and extra latin1 conversion in savane_old migration script
Sylvain Beucler <beuc@beuc.net>
parents: 83
diff changeset
6 password, last_login, date_joined, is_active,
09d27fd2ce8b Suppress warnings and extra latin1 conversion in savane_old migration script
Sylvain Beucler <beuc@beuc.net>
parents: 83
diff changeset
7 is_superuser, is_staff)
09d27fd2ce8b Suppress warnings and extra latin1 conversion in savane_old migration script
Sylvain Beucler <beuc@beuc.net>
parents: 83
diff changeset
8 SELECT user_id, user_name, realname, '', email,
09d27fd2ce8b Suppress warnings and extra latin1 conversion in savane_old migration script
Sylvain Beucler <beuc@beuc.net>
parents: 83
diff changeset
9 CONCAT('md5$$', user_pw), now(), FROM_UNIXTIME(add_date), status='A',
09d27fd2ce8b Suppress warnings and extra latin1 conversion in savane_old migration script
Sylvain Beucler <beuc@beuc.net>
parents: 83
diff changeset
10 0, 0
83
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
11 FROM savane_old.user
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
12 WHERE user_id != 100;
77
b1dc8db5040a Added a sql script to migrate the users from the old savane model to the new one with django
Jonathan Gonzalez V <zeus@gnu.org>
parents:
diff changeset
13
83
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
14 -- Import all extended information except for the 'None' user (#100)
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
15 INSERT INTO my_extendeduser
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
16 (user_ptr_id, status, spamscore, authorized_keys,
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
17 authorized_keys_count, people_view_skills, people_resume,
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
18 timezone, theme, email_hide, gpg_key, gpg_key_count)
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
19 SELECT user_id, status, spamscore, authorized_keys,
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
20 authorized_keys_count, people_view_skills,
86
09d27fd2ce8b Suppress warnings and extra latin1 conversion in savane_old migration script
Sylvain Beucler <beuc@beuc.net>
parents: 83
diff changeset
21 people_resume, timezone, theme,
83
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
22 email_hide, gpg_key, gpg_key_count
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
23 FROM savane_old.user
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
24 WHERE user_id != 100;