savane-forge: migrate_old_savane.sql annotate

annotate migrate_old_savane.sql @ 262:00ab06c9fd1d

Migrate Job data from Savane3

author	Sylvain Beucler <beuc@beuc.net>
date	Wed, 11 Aug 2010 23:09:55 +0200
parents	741ce8152e94
children	752ae7463b2d

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 --
255 741ce8152e94 Update copyright notices Sylvain Beucler <beuc@beuc.net> parents: 248 diff changeset	3 -- Copyright (C) 2009, 2010 Sylvain Beucler
117 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)
248 5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	61 TRUNCATE svmain_svuserinfo;
5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	62 INSERT INTO svmain_svuserinfo
5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	63 (user_id, status, spamscore,
128 70abe9b6819e - Update/precise TODO roadmap Sylvain Beucler <beuc@beuc.net> parents: 117 diff changeset	64 people_view_skills, people_resume,
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	65 timezone, theme, email_hide, gpg_key, gpg_key_count)
128 70abe9b6819e - Update/precise TODO roadmap Sylvain Beucler <beuc@beuc.net> parents: 117 diff changeset	66 SELECT user_id, status, spamscore,
70abe9b6819e - Update/precise TODO roadmap Sylvain Beucler <beuc@beuc.net> parents: 117 diff changeset	67 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
138 342772515b88 Migrate the old authorized_keys cols to one row in svmain_sshkey Jonathan Gonzalez V <zeus@gnu.org> parents: 128 diff changeset	73 -- Import the ssh into the new model, the python code should care about make
342772515b88 Migrate the old authorized_keys cols to one row in svmain_sshkey Jonathan Gonzalez V <zeus@gnu.org> parents: 128 diff changeset	74 -- the proper migration after a login or with a python code
342772515b88 Migrate the old authorized_keys cols to one row in svmain_sshkey Jonathan Gonzalez V <zeus@gnu.org> parents: 128 diff changeset	75 TRUNCATE svmain_sshkey;
342772515b88 Migrate the old authorized_keys cols to one row in svmain_sshkey Jonathan Gonzalez V <zeus@gnu.org> parents: 128 diff changeset	76 INSERT INTO svmain_sshkey
342772515b88 Migrate the old authorized_keys cols to one row in svmain_sshkey Jonathan Gonzalez V <zeus@gnu.org> parents: 128 diff changeset	77 (user_id, ssh_key)
342772515b88 Migrate the old authorized_keys cols to one row in svmain_sshkey Jonathan Gonzalez V <zeus@gnu.org> parents: 128 diff changeset	78 SELECT user_id, authorized_keys
342772515b88 Migrate the old authorized_keys cols to one row in svmain_sshkey Jonathan Gonzalez V <zeus@gnu.org> parents: 128 diff changeset	79 FROM savane_old.user
342772515b88 Migrate the old authorized_keys cols to one row in svmain_sshkey Jonathan Gonzalez V <zeus@gnu.org> parents: 128 diff changeset	80 WHERE authorized_keys != ''
342772515b88 Migrate the old authorized_keys cols to one row in svmain_sshkey Jonathan Gonzalez V <zeus@gnu.org> parents: 128 diff changeset	81 and savane_old.user.user_id != 100;
342772515b88 Migrate the old authorized_keys cols to one row in svmain_sshkey Jonathan Gonzalez V <zeus@gnu.org> parents: 128 diff changeset	82
89 f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	83 -- Import group configurations
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	84 -- 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	85 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	86 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	87 (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	88 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	89 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	90 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	91 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	92 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	93 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	94 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	95 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	96 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	97 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	98 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	99 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	100 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	101 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	102 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	103 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	104 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	105 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	106 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	107 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	108 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	109 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	110 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	111 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	112 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	113 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	114 homepage_scm,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	115 dir_type_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	116 dir_type_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	117 dir_type_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	118 dir_type_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	119 dir_type_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	120 dir_type_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	121 dir_type_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	122 dir_type_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	123 dir_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	124 dir_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	125 dir_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	126 dir_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	127 dir_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	128 dir_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	129 dir_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	130 dir_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	131 url_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	132 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	133 url_cvs_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	134 url_arch_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	135 url_svn_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	136 url_git_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	137 url_hg_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	138 url_bzr_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	139 url_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	140 url_mailing_list_listinfo,
248 5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	141 -- url_mailing_list_subscribe,
5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	142 -- url_mailing_list_unsubscribe,
89 f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	143 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	144 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	145 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	146 url_extralink_documentation)
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	147 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	148 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	149 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	150 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	151 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	152 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	153 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	154 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	155 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	156 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	157 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	158 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	159 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	160 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	161 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	162 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	163 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	164 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	165 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	166 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	167 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	168 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	169 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	170 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	171 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	172 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	173 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	174 homepage_scm,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	175 dir_type_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	176 dir_type_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	177 dir_type_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	178 dir_type_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	179 dir_type_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	180 dir_type_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	181 dir_type_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	182 dir_type_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	183 dir_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	184 dir_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	185 dir_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	186 dir_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	187 dir_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	188 dir_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	189 dir_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	190 dir_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	191 url_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	192 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	193 url_cvs_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	194 url_arch_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	195 url_svn_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	196 url_git_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	197 url_hg_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	198 url_bzr_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	199 url_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	200 url_mailing_list_listinfo,
248 5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	201 -- url_mailing_list_subscribe,
5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	202 -- url_mailing_list_unsubscribe,
89 f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	203 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	204 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	205 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	206 url_extralink_documentation
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.group_type;
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	208
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 groups
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	211 -- id <- group_id
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	212 -- 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	213 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	214 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	215 (id, name)
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	216 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	217 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	218 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	219
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	220 -- 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	221 -- ./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	222 -- ./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	223
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	224 -- Import groups
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	225 -- 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	226 -- 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	227 -- 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	228 -- type_id <- type
90 570667aa9b3a - Properly import register_time Sylvain Beucler <beuc@beuc.net> parents: 89 diff changeset	229 -- 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	230 --
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	231 -- 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	232 -- 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	233 -- Using X+0 to convert empty string to 0 without warning
248 5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	234 TRUNCATE svmain_svgroupinfo;
5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	235 INSERT INTO svmain_svgroupinfo
5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	236 (group_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	237 register_time,
89 f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	238 is_public,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	239 status,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	240 short_description,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	241 long_description,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	242 license_other,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	243 register_purpose,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	244 required_software,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	245 other_comments,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	246 registered_gpg_keys,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	247 use_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	248 use_mail,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	249 use_patch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	250 use_task,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	251 use_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	252 use_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	253 use_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	254 use_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	255 use_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	256 use_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	257 use_news,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	258 use_support,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	259 use_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	260 use_bugs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	261 use_extralink_documentation,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	262 url_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	263 url_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	264 url_support,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	265 url_mail,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	266 url_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	267 url_cvs_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	268 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	269 url_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	270 url_arch_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	271 url_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	272 url_svn_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	273 url_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	274 url_git_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	275 url_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	276 url_hg_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	277 url_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	278 url_bzr_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	279 url_bugs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	280 url_task,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	281 url_patch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	282 url_extralink_documentation)
248 5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	283 SELECT group_id, group_name, svmain_license.id, IFNULL(IF(devel_status=0,9,devel_status), 7), type,
90 570667aa9b3a - Properly import register_time Sylvain Beucler <beuc@beuc.net> parents: 89 diff changeset	284 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	285 is_public,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	286 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	287 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	288 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	289 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	290 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	291 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	292 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	293 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	294 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	295 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	296 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	297 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	298 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	299 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	300 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	301 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	302 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	303 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	304 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	305 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	306 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	307 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	308 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	309 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	310 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	311 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	312 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	313 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	314 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	315 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	316 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	317 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	318 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	319 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	320 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	321 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	322 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	323 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	324 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	325 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	326 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	327 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	328 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	329 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	330 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	331 WHERE savane_old.groups.group_id != 100;
94 5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	332
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	333 -- 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	334 -- 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	335 USE savane_old;
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	336 -- 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	337 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	338 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	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.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	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 -- 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	346 DELETE FROM user_group
94 5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	347 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	348 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	349 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	350 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	351 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	352 ) AS temp
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	353 );
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	354 -- 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	355 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	356 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	357 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	358 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	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 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	361 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	362 ) AS temp
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	363 );
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	364 -- 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	365 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	366 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	367 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	368 FROM user_group
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	369 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	370 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	371 ) AS temp
94 5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	372 );
98 ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	373 USE savane;
94 5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	374 -- Actual import
98 ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	375 TRUNCATE auth_user_groups;
94 5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	376 INSERT INTO auth_user_groups
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	377 (user_id, group_id)
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	378 SELECT user_id, group_id
248 5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	379 FROM savane_old.user_group
5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	380 WHERE admin_flags <> 'P';
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	381 TRUNCATE svmain_membership;
94 5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	382 INSERT INTO svmain_membership
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	383 (user_id, group_id, admin_flags, onduty)
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	384 SELECT user_id, group_id, admin_flags, onduty
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	385 FROM savane_old.user_group;
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	386 -- Set members of 'administration' as superusers
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	387 -- TODO: get the supergroup name from the old Savane configuration
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	388 UPDATE auth_user SET is_staff=1, is_superuser=1
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	389 WHERE id IN (
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	390 SELECT user_id
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	391 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	392 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	393 );
262 00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	394
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	395
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	396 -- Import jobs & skills
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	397 TRUNCATE svpeople_job;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	398 -- id <- job_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	399 -- created_by_id <- created_by
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	400 -- status <- status_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	401 INSERT INTO svpeople_job
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	402 (id, group_id, created_by_id, title, description, date, status, category_id)
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	403 SELECT job_id, group_id, created_by, title, description, FROM_UNIXTIME(date), status_id, category_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	404 FROM savane_old.people_job;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	405
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	406 TRUNCATE svpeople_category;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	407 -- id <- category_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	408 -- label <- name
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	409 -- active <- '1'
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	410 INSERT INTO svpeople_category
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	411 (id, label, active)
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	412 SELECT category_id, name, '1'
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	413 FROM savane_old.people_job_category;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	414
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	415 TRUNCATE svpeople_skill;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	416 -- id <- skill_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	417 -- label <- name
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	418 -- active <- '1'
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	419 INSERT INTO svpeople_skill
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	420 (id, label, active)
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	421 SELECT skill_id, name, '1'
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	422 FROM savane_old.people_skill;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	423 TRUNCATE svpeople_skilllevel;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	424 -- id <- skill_level_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	425 -- label <- name
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	426 -- active <- '1'
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	427 INSERT INTO svpeople_skilllevel
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	428 (id, label, active)
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	429 SELECT skill_level_id, name, '1'
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	430 FROM savane_old.people_skill_level;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	431 TRUNCATE svpeople_skillyear;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	432 -- id <- skill_year_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	433 -- label <- name
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	434 -- active <- '1'
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	435 INSERT INTO svpeople_skillyear
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	436 (id, label, active)
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	437 SELECT skill_year_id, name, '1'
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	438 FROM savane_old.people_skill_year;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	439
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	440 TRUNCATE svpeople_jobinventory;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	441 -- id <- job_inventory_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	442 INSERT INTO svpeople_jobinventory
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	443 (id, job_id, skill_id, skill_level_id, skill_year_id)
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	444 SELECT job_inventory_id, job_id, skill_id, skill_level_id, skill_year_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	445 FROM savane_old.people_job_inventory;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	446 TRUNCATE svpeople_skillinventory;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	447 -- id <- skill_inventory_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	448 INSERT INTO svpeople_skillinventory
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	449 (id, user_id, skill_id, skill_level_id, skill_year_id)
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	450 SELECT skill_inventory_id, user_id, skill_id, skill_level_id, skill_year_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	451 FROM savane_old.people_skill_inventory;

Mercurial > hg > savane-forge

annotate migrate_old_savane.sql @ 262:00ab06c9fd1d