Mercurial > hg > savane-forge

annotate migrate_old_savane.sql @ 117:16016b4fe187

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Clarify how to use the migration script and add a copyright/license notice
author Sylvain Beucler <beuc@beuc.net>
date Sat, 01 Aug 2009 19:19:27 +0200
parents 5ab434821d4e
children 70abe9b6819e
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
117
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
1 -- Convert old Savane data to the new version
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
2 --
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
3 -- Copyright (C) 2009 Sylvain Beucler
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
4 -- Copyright (C) 2009 Jonathan Gonzalez V.
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
5 --
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
6 -- This file is part of Savane.
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
7 --
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
8 -- Savane is free software: you can redistribute it and/or modify it
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
9 -- under the terms of the GNU Affero General Public License as
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
10 -- published by the Free Software Foundation, either version 3 of the
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
11 -- License, or (at your option) any later version.
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
12 --
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
13 -- Savane is distributed in the hope that it will be useful, but
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
14 -- WITHOUT ANY WARRANTY; without even the implied warranty of
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
15 -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
16 -- Affero General Public License for more details.
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
17 --
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
18 -- You should have received a copy of the GNU Affero General Public
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
19 -- License along with this program. If not, see
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
20 -- <http://www.gnu.org/licenses/>.
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
21
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
22 -- This script works on the database from 'savane-cleanup' version
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
23 -- with the LATEST DATABASE UPGRADES (check updates/clean-up/).
16016b4fe187 Clarify how to use the migration script and add a copyright/license notice
Sylvain Beucler <beuc@beuc.net>
parents: 99
diff changeset
24
98
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
25 -- Some clean-up is done on the savane_old database. It may sound
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
26 -- better to leave savane_old read-only, but at the same time this
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
27 -- means we can experiment the clean-ups on live "old savane" installs
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
28 -- before the migration.
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
29
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
30
45933e4a5aec - Clean-up in the login code to reuse Django 'auth' app; if I removed
Sylvain Beucler <beuc@beuc.net>
parents: 77
diff changeset
31 -- Import all users except for the 'None' user (#100)
98
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
32 -- Get rid of duplicates (old mysql/php/savane bug?)
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
33 USE savane_old;
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
34 DELETE FROM user
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
35 WHERE user_id IN (
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
36 SELECT user_id FROM (
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
37 SELECT B.user_id FROM user A, user B
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
38 WHERE A.user_id < B.user_id AND A.user_name = B.user_name
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
39 ) AS temp
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
40 );
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
41 USE savane;
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
42 -- Actual import
99
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
43 -- Using a heuristic to split realname in firstname/lastname; we can't
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
44 -- place all in firstname because it's 30 chars long, while realname
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
45 -- is 32 chars long :/
98
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
46 TRUNCATE auth_user;
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
47 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
48 (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
49 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
50 is_superuser, is_staff)
99
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
51 SELECT user_id, user_name,
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
52 SUBSTRING_INDEX(realname, ' ', 1),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
53 TRIM(REPLACE(realname, SUBSTRING_INDEX(realname, ' ', 1), '')),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
54 email,
86
09d27fd2ce8b Suppress warnings and extra latin1 conversion in savane_old migration script
Sylvain Beucler <beuc@beuc.net>
parents: 83
diff changeset
55 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
56 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
57 FROM savane_old.user
89
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
58 WHERE savane_old.user.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
59
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
60 -- Import all extended information except for the 'None' user (#100)
98
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
61 TRUNCATE svmain_extendeduser;
88
beba59837ded Rename 'main' to 'svmain'; move user/group models to svmain; start implementing admin area
Sylvain Beucler <beuc@beuc.net>
parents: 86
diff changeset
62 INSERT INTO svmain_extendeduser
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
63 (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
64 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
65 timezone, theme, email_hide, gpg_key, gpg_key_count)
99
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
66 SELECT user_id, status, spamscore, IFNULL(authorized_keys, ''),
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
67 authorized_keys_count, people_view_skills,
99
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
68 people_resume, IFNULL(timezone, ''), IFNULL(theme, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
69 IFNULl(email_hide, 0), IFNULL(gpg_key, ''), gpg_key_count
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
70 FROM savane_old.user
89
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
71 WHERE savane_old.user.user_id != 100;
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
72
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
73 -- Import group configurations
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
74 -- type_id -> id
98
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
75 TRUNCATE svmain_groupconfiguration;
89
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
76 INSERT INTO svmain_groupconfiguration
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
77 (id, name, description, base_host,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
78 mailing_list_address, mailing_list_virtual_host, mailing_list_format,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
79 can_use_homepage, can_use_download, can_use_cvs, can_use_arch, can_use_svn, can_use_git, can_use_hg,
91
e470dbd1bc0f Remove forum-related fields (deprecated feature); more admin fixes
Sylvain Beucler <beuc@beuc.net>
parents: 90
diff changeset
80 can_use_bzr, can_use_license, can_use_devel_status, can_use_mailing_list,
89
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
81 can_use_patch, can_use_task, can_use_news, can_use_support, can_use_bug,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
82 is_menu_configurable_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
83 is_menu_configurable_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
84 is_menu_configurable_support,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
85 is_menu_configurable_mail,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
86 is_menu_configurable_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
87 is_menu_configurable_cvs_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
88 is_menu_configurable_cvs_viewcvs_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
89 is_menu_configurable_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
90 is_menu_configurable_arch_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
91 is_menu_configurable_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
92 is_menu_configurable_svn_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
93 is_menu_configurable_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
94 is_menu_configurable_git_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
95 is_menu_configurable_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
96 is_menu_configurable_hg_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
97 is_menu_configurable_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
98 is_menu_configurable_bzr_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
99 is_menu_configurable_bugs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
100 is_menu_configurable_task,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
101 is_menu_configurable_patch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
102 is_menu_configurable_extralink_documentation,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
103 is_configurable_download_dir,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
104 homepage_scm,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
105 dir_type_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
106 dir_type_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
107 dir_type_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
108 dir_type_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
109 dir_type_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
110 dir_type_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
111 dir_type_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
112 dir_type_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
113 dir_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
114 dir_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
115 dir_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
116 dir_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
117 dir_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
118 dir_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
119 dir_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
120 dir_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
121 url_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
122 url_cvs_viewcvs_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
123 url_cvs_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
124 url_arch_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
125 url_svn_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
126 url_git_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
127 url_hg_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
128 url_bzr_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
129 url_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
130 url_mailing_list_listinfo,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
131 url_mailing_list_subscribe,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
132 url_mailing_list_unsubscribe,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
133 url_mailing_list_archives,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
134 url_mailing_list_archives_private,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
135 url_mailing_list_admin,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
136 url_extralink_documentation)
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
137 SELECT type_id, name, description, base_host,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
138 mailing_list_address, mailing_list_virtual_host, mailing_list_format,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
139 can_use_homepage, can_use_download, can_use_cvs, can_use_arch, can_use_svn, can_use_git, can_use_hg,
91
e470dbd1bc0f Remove forum-related fields (deprecated feature); more admin fixes
Sylvain Beucler <beuc@beuc.net>
parents: 90
diff changeset
140 can_use_bzr, can_use_license, can_use_devel_status, can_use_mailing_list,
89
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
141 can_use_patch, can_use_task, can_use_news, can_use_support, can_use_bug,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
142 is_menu_configurable_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
143 is_menu_configurable_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
144 is_menu_configurable_support,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
145 is_menu_configurable_mail,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
146 is_menu_configurable_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
147 is_menu_configurable_cvs_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
148 is_menu_configurable_cvs_viewcvs_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
149 is_menu_configurable_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
150 is_menu_configurable_arch_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
151 is_menu_configurable_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
152 is_menu_configurable_svn_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
153 is_menu_configurable_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
154 is_menu_configurable_git_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
155 is_menu_configurable_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
156 is_menu_configurable_hg_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
157 is_menu_configurable_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
158 is_menu_configurable_bzr_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
159 is_menu_configurable_bugs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
160 is_menu_configurable_task,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
161 is_menu_configurable_patch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
162 is_menu_configurable_extralink_documentation,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
163 is_configurable_download_dir,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
164 homepage_scm,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
165 dir_type_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
166 dir_type_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
167 dir_type_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
168 dir_type_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
169 dir_type_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
170 dir_type_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
171 dir_type_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
172 dir_type_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
173 dir_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
174 dir_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
175 dir_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
176 dir_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
177 dir_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
178 dir_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
179 dir_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
180 dir_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
181 url_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
182 url_cvs_viewcvs_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
183 url_cvs_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
184 url_arch_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
185 url_svn_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
186 url_git_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
187 url_hg_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
188 url_bzr_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
189 url_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
190 url_mailing_list_listinfo,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
191 url_mailing_list_subscribe,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
192 url_mailing_list_unsubscribe,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
193 url_mailing_list_archives,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
194 url_mailing_list_archives_private,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
195 url_mailing_list_admin,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
196 url_extralink_documentation
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
197 FROM savane_old.group_type;
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
198
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
199
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
200 -- Import groups
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
201 -- id <- group_id
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
202 -- name <- unix_group_name
98
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
203 TRUNCATE auth_group;
89
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
204 INSERT INTO auth_group
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
205 (id, name)
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
206 SELECT group_id, unix_group_name
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
207 FROM savane_old.groups
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
208 WHERE savane_old.groups.group_id != 100;
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
209
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
210 -- Import license/devel_status
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
211 -- ./manage.py loaddata savane/svmain/fixtures/license.yaml
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
212 -- ./manage.py loaddata savane/svmain/fixtures/developmentstatus.yaml
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
213
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
214 -- Import groups
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
215 -- group_ptr_id <- group_id
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
216 -- full_name <- group_name
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
217 -- license_id <- license+1 (django counts from 1, not from 0)
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
218 -- devel_status_id <- devel_status+1 (django counts from 1, not from 0)
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
219 -- type_id <- type
90
570667aa9b3a - Properly import register_time
Sylvain Beucler <beuc@beuc.net>
parents: 89
diff changeset
220 -- register_time <- FROM_UNIXTIME(register_time)
89
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
221 --
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
222 -- Using LEFT JOIN so that if the license isn't known, the project is
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
223 -- not ignored (with license_id=NULL).
99
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
224 -- Using X+0 to convert empty string to 0 without warning
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
225 TRUNCATE svmain_extendedgroup;
89
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
226 INSERT INTO svmain_extendedgroup
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
227 (group_ptr_id, full_name, license_id, devel_status_id, type_id,
90
570667aa9b3a - Properly import register_time
Sylvain Beucler <beuc@beuc.net>
parents: 89
diff changeset
228 register_time,
89
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
229 is_public,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
230 status,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
231 short_description,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
232 long_description,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
233 license_other,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
234 register_purpose,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
235 required_software,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
236 other_comments,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
237 registered_gpg_keys,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
238 use_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
239 use_mail,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
240 use_patch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
241 use_task,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
242 use_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
243 use_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
244 use_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
245 use_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
246 use_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
247 use_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
248 use_news,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
249 use_support,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
250 use_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
251 use_bugs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
252 use_extralink_documentation,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
253 url_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
254 url_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
255 url_support,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
256 url_mail,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
257 url_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
258 url_cvs_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
259 url_cvs_viewcvs_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
260 url_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
261 url_arch_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
262 url_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
263 url_svn_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
264 url_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
265 url_git_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
266 url_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
267 url_hg_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
268 url_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
269 url_bzr_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
270 url_bugs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
271 url_task,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
272 url_patch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
273 url_extralink_documentation)
99
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
274 SELECT group_id, group_name, svmain_license.id, IFNULL(devel_status+1, 8), type,
90
570667aa9b3a - Properly import register_time
Sylvain Beucler <beuc@beuc.net>
parents: 89
diff changeset
275 FROM_UNIXTIME(register_time),
89
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
276 is_public,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
277 status,
99
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
278 IFNULL(short_description, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
279 IFNULL(long_description, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
280 IFNULL(license_other, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
281 IFNULL(register_purpose, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
282 IFNULL(required_software, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
283 IFNULL(other_comments, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
284 IFNULL(registered_gpg_keys, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
285 IFNULL(use_homepage+0, 0),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
286 IFNULL(use_mail+0, 0),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
287 IFNULL(use_patch+0, 0),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
288 IFNULL(use_task+0, 0),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
289 IFNULL(use_cvs+0, 0),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
290 IFNULL(use_arch+0, 0),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
291 IFNULL(use_svn+0, 0),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
292 IFNULL(use_git+0, 0),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
293 IFNULL(use_hg+0, 0),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
294 IFNULL(use_bzr+0, 0),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
295 IFNULL(use_news+0, 0),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
296 IFNULL(use_support+0, 0),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
297 IFNULL(use_download+0, 0),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
298 IFNULL(use_bugs+0, 0),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
299 IFNULL(use_extralink_documentation+0, 0),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
300 IFNULL(url_homepage, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
301 IFNULL(url_download, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
302 IFNULL(url_support, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
303 IFNULL(url_mail, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
304 IFNULL(url_cvs, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
305 IFNULL(url_cvs_viewcvs, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
306 IFNULL(url_cvs_viewcvs_homepage, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
307 IFNULL(url_arch, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
308 IFNULL(url_arch_viewcvs, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
309 IFNULL(url_svn, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
310 IFNULL(url_svn_viewcvs, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
311 IFNULL(url_git, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
312 IFNULL(url_git_viewcvs, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
313 IFNULL(url_hg, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
314 IFNULL(url_hg_viewcvs, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
315 IFNULL(url_bzr, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
316 IFNULL(url_bzr_viewcvs, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
317 IFNULL(url_bugs, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
318 IFNULL(url_task, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
319 IFNULL(url_patch, ''),
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
320 IFNULL(url_extralink_documentation, '')
89
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
321 FROM savane_old.groups LEFT JOIN savane.svmain_license ON savane_old.groups.license = savane.svmain_license.slug
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration
Sylvain Beucler <beuc@beuc.net>
parents: 88
diff changeset
322 WHERE savane_old.groups.group_id != 100;
94
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
323
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
324 -- Import users<->groups relationships
98
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
325 -- Get rid of duplicates
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
326 USE savane_old;
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
327 -- Give priority to non-pending memberships
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
328 DELETE FROM user_group
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
329 WHERE user_group_id IN (
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
330 SELECT user_group_id FROM (
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
331 SELECT B.user_group_id FROM user_group A, user_group B
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
332 WHERE A.admin_flags <> 'P' AND B.admin_flags = 'P'
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
333 AND A.user_id = B.user_id AND A.group_id = B.group_id
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
334 ) AS temp
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
335 );
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
336 -- Delete other duplicates, give priority to the first one
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
337 DELETE FROM user_group
94
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
338 WHERE user_group_id IN (
98
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
339 SELECT user_group_id FROM (
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
340 SELECT B.user_group_id FROM user_group A, user_group B
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
341 WHERE A.user_group_id < B.user_group_id
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
342 AND A.user_id = B.user_id AND A.group_id = B.group_id
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
343 ) AS temp
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
344 );
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
345 -- Get rid of ghost relationships (deleted group)
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
346 DELETE FROM user_group
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
347 WHERE group_id IN (
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
348 SELECT group_id FROM (
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
349 SELECT user_group.group_id
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
350 FROM user_group
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
351 LEFT JOIN groups ON user_group.group_id = groups.group_id
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
352 WHERE groups.group_id IS NULL
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
353 ) AS temp
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
354 );
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
355 -- Get rid of ghost relationships (deleted user)
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
356 DELETE FROM user_group WHERE user_id IN (
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
357 SELECT user_id FROM (
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
358 SELECT user_group.user_id
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
359 FROM user_group
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
360 LEFT JOIN user ON user_group.user_id = user.user_id
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
361 WHERE user.user_id IS NULL
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
362 ) AS temp
94
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
363 );
98
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
364 USE savane;
94
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
365 -- Actual import
98
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
366 TRUNCATE auth_user_groups;
94
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
367 INSERT INTO auth_user_groups
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
368 (user_id, group_id)
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
369 SELECT user_id, group_id
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
370 FROM savane_old.user_group;
99
5ab434821d4e Improve migration scripts to get rid of trivial warnings (so only real warnings remain)
Sylvain Beucler <beuc@beuc.net>
parents: 98
diff changeset
371 TRUNCATE svmain_membership;
94
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
372 INSERT INTO svmain_membership
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
373 (user_id, group_id, admin_flags, onduty)
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
374 SELECT user_id, group_id, admin_flags, onduty
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
375 FROM savane_old.user_group;
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
376 -- Set members of 'administration' as superusers
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
377 -- TODO: get the supergroup name from the old Savane configuration
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
378 UPDATE auth_user SET is_staff=1, is_superuser=1
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
379 WHERE id IN (
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
380 SELECT user_id
5c90eef9f2c1 - Import user->group membership
Sylvain Beucler <beuc@beuc.net>
parents: 91
diff changeset
381 FROM auth_user_groups JOIN auth_group ON auth_user_groups.group_id = auth_group.id
98
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
382 WHERE auth_group.name='administration'
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs
Sylvain Beucler <beuc@beuc.net>
parents: 94
diff changeset
383 );