savane-forge: migrate_old_savane.sql annotate

annotate migrate_old_savane.sql @ 328:91a6a6c540d4

Static fields definition won't be interesting in the long run

author	Sylvain Beucler <beuc@beuc.net>
date	Sun, 22 Aug 2010 08:41:38 +0200
parents	f34eba406e57
children	e29de6a47cc1

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
275 752ae7463b2d Migration: handle dates as UTC timezone Sylvain Beucler <beuc@beuc.net> parents: 262 diff changeset	30 -- Handle dates correctly: FROM_UNIXTIME is mistakenly _timezone-
752ae7463b2d Migration: handle dates as UTC timezone Sylvain Beucler <beuc@beuc.net> parents: 262 diff changeset	31 -- dependent_, so currently the migration script produces valid dates
752ae7463b2d Migration: handle dates as UTC timezone Sylvain Beucler <beuc@beuc.net> parents: 262 diff changeset	32 -- only if it's run in the UTC timezone...
752ae7463b2d Migration: handle dates as UTC timezone Sylvain Beucler <beuc@beuc.net> parents: 262 diff changeset	33 SET time_zone = '+00:00';
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	34
296 6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	35
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	36 ----
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	37 -- USERS
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	38 ----
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	39
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	40 -- 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	41 -- 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	42 USE savane_old;
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	43 DELETE FROM user
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	44 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	45 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	46 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	47 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	48 ) AS temp
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	49 );
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	50 USE savane;
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	51 -- 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	52 -- 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	53 -- 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	54 -- 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	55 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	56 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	57 (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	58 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	59 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	60 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	61 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	62 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	63 email,
86 09d27fd2ce8b Suppress warnings and extra latin1 conversion in savane_old migration script Sylvain Beucler <beuc@beuc.net> parents: 83 diff changeset	64 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	65 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	66 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	67 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	68
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	69 -- 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	70 TRUNCATE svmain_svuserinfo;
5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	71 INSERT INTO svmain_svuserinfo
5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	72 (user_id, status, spamscore,
289 c25fbbaae541 Move user skills data in the svpeople module Sylvain Beucler <beuc@beuc.net> parents: 283 diff changeset	73 timezone, email_hide, gpg_key, gpg_key_count)
128 70abe9b6819e - Update/precise TODO roadmap Sylvain Beucler <beuc@beuc.net> parents: 117 diff changeset	74 SELECT user_id, status, spamscore,
289 c25fbbaae541 Move user skills data in the svpeople module Sylvain Beucler <beuc@beuc.net> parents: 283 diff changeset	75 IFNULL(timezone, ''), IFNULL(email_hide, 0), IFNULL(gpg_key, ''), gpg_key_count
c25fbbaae541 Move user skills data in the svpeople module Sylvain Beucler <beuc@beuc.net> parents: 283 diff changeset	76 FROM savane_old.user
c25fbbaae541 Move user skills data in the svpeople module Sylvain Beucler <beuc@beuc.net> parents: 283 diff changeset	77 WHERE savane_old.user.user_id != 100;
c25fbbaae541 Move user skills data in the svpeople module Sylvain Beucler <beuc@beuc.net> parents: 283 diff changeset	78
c25fbbaae541 Move user skills data in the svpeople module Sylvain Beucler <beuc@beuc.net> parents: 283 diff changeset	79 -- view_skills <- people_view_skills
c25fbbaae541 Move user skills data in the svpeople module Sylvain Beucler <beuc@beuc.net> parents: 283 diff changeset	80 -- resume <- people_resume
c25fbbaae541 Move user skills data in the svpeople module Sylvain Beucler <beuc@beuc.net> parents: 283 diff changeset	81 TRUNCATE svpeople_userinfo;
c25fbbaae541 Move user skills data in the svpeople module Sylvain Beucler <beuc@beuc.net> parents: 283 diff changeset	82 INSERT INTO svpeople_userinfo
c25fbbaae541 Move user skills data in the svpeople module Sylvain Beucler <beuc@beuc.net> parents: 283 diff changeset	83 (user_id, view_skills, resume)
c25fbbaae541 Move user skills data in the svpeople module Sylvain Beucler <beuc@beuc.net> parents: 283 diff changeset	84 SELECT user_id, 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	85 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	86 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	87
138 342772515b88 Migrate the old authorized_keys cols to one row in svmain_sshkey Jonathan Gonzalez V <zeus@gnu.org> parents: 128 diff changeset	88 -- 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	89 -- 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	90 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	91 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	92 (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	93 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	94 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	95 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	96 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	97
296 6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	98
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	99 ----
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	100 -- GROUPS
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	101 ----
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	102
89 f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	103 -- Import group configurations
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	104 -- 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	105 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	106 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	107 (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	108 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	109 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	110 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	111 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	112 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	113 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	114 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	115 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	116 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	117 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	118 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	119 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	120 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	121 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	122 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	123 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	124 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	125 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	126 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	127 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	128 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	129 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	130 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	131 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	132 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	133 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	134 homepage_scm,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	135 dir_type_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	136 dir_type_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	137 dir_type_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	138 dir_type_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	139 dir_type_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	140 dir_type_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	141 dir_type_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	142 dir_type_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	143 dir_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	144 dir_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	145 dir_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	146 dir_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	147 dir_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	148 dir_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	149 dir_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	150 dir_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	151 url_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	152 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	153 url_cvs_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	154 url_arch_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	155 url_svn_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	156 url_git_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	157 url_hg_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	158 url_bzr_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	159 url_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	160 url_mailing_list_listinfo,
248 5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	161 -- url_mailing_list_subscribe,
5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	162 -- 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	163 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	164 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	165 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	166 url_extralink_documentation)
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	167 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	168 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	169 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	170 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	171 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	172 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	173 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	174 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	175 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	176 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	177 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	178 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	179 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	180 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	181 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	182 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	183 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	184 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	185 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	186 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	187 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	188 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	189 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	190 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	191 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	192 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	193 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	194 homepage_scm,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	195 dir_type_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	196 dir_type_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	197 dir_type_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	198 dir_type_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	199 dir_type_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	200 dir_type_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	201 dir_type_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	202 dir_type_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	203 dir_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	204 dir_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	205 dir_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	206 dir_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	207 dir_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	208 dir_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	209 dir_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	210 dir_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	211 url_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	212 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	213 url_cvs_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	214 url_arch_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	215 url_svn_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	216 url_git_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	217 url_hg_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	218 url_bzr_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	219 url_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	220 url_mailing_list_listinfo,
248 5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	221 -- url_mailing_list_subscribe,
5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	222 -- 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	223 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	224 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	225 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	226 url_extralink_documentation
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	227 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	228
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	229
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	230 -- Import groups
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	231 -- id <- group_id
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	232 -- 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	233 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	234 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	235 (id, name)
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	236 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	237 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	238 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	239
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	240 -- 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	241 -- ./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	242 -- ./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	243
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	244 -- Import groups
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	245 -- 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	246 -- 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	247 -- 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	248 -- type_id <- type
90 570667aa9b3a - Properly import register_time Sylvain Beucler <beuc@beuc.net> parents: 89 diff changeset	249 -- 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	250 --
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	251 -- 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	252 -- 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	253 -- 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	254 TRUNCATE svmain_svgroupinfo;
5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	255 INSERT INTO svmain_svgroupinfo
5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	256 (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	257 register_time,
89 f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	258 is_public,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	259 status,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	260 short_description,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	261 long_description,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	262 license_other,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	263 register_purpose,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	264 required_software,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	265 other_comments,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	266 registered_gpg_keys,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	267 use_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	268 use_mail,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	269 use_patch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	270 use_task,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	271 use_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	272 use_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	273 use_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	274 use_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	275 use_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	276 use_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	277 use_news,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	278 use_support,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	279 use_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	280 use_bugs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	281 use_extralink_documentation,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	282 url_homepage,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	283 url_download,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	284 url_support,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	285 url_mail,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	286 url_cvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	287 url_cvs_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	288 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	289 url_arch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	290 url_arch_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	291 url_svn,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	292 url_svn_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	293 url_git,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	294 url_git_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	295 url_hg,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	296 url_hg_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	297 url_bzr,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	298 url_bzr_viewcvs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	299 url_bugs,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	300 url_task,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	301 url_patch,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	302 url_extralink_documentation)
248 5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	303 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	304 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	305 is_public,
f38539942743 Import script for groups->svmain_extendedgroup and group_type->svmain_groupconfiguration Sylvain Beucler <beuc@beuc.net> parents: 88 diff changeset	306 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	307 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	308 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	309 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	310 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	311 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	312 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	313 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	314 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	315 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	316 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	317 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	318 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	319 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	320 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	321 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	322 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	323 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	324 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	325 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	326 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	327 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	328 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	329 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	330 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	331 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	332 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	333 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	334 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	335 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	336 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	337 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	338 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	339 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	340 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	341 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	342 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	343 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	344 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	345 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	346 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	347 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	348 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	349 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	350 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	351 WHERE savane_old.groups.group_id != 100;
94 5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	352
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	353 -- 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	354 -- 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	355 USE savane_old;
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	356 -- 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	357 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	358 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	359 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	360 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	361 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	362 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	363 ) AS temp
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	364 );
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	365 -- 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	366 DELETE FROM user_group
94 5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	367 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	368 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	369 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	370 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	371 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	372 ) AS temp
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	373 );
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	374 -- 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	375 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	376 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	377 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	378 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	379 FROM user_group
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	380 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	381 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	382 ) AS temp
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	383 );
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	384 -- 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	385 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	386 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	387 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	388 FROM user_group
ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	389 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	390 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	391 ) AS temp
94 5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	392 );
98 ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	393 USE savane;
94 5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	394 -- Actual import
98 ea40990b202a Improve migration script, takes better care of duplicates and dangling FKs Sylvain Beucler <beuc@beuc.net> parents: 94 diff changeset	395 TRUNCATE auth_user_groups;
94 5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	396 INSERT INTO auth_user_groups
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	397 (user_id, group_id)
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	398 SELECT user_id, group_id
248 5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	399 FROM savane_old.user_group
5e7ba81027a4 Update import from savane-cleanup Sylvain Beucler <beuc@beuc.net> parents: 138 diff changeset	400 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	401 TRUNCATE svmain_membership;
94 5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	402 INSERT INTO svmain_membership
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	403 (user_id, group_id, admin_flags, onduty)
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	404 SELECT user_id, group_id, admin_flags, onduty
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	405 FROM savane_old.user_group;
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	406 -- Set members of 'administration' as superusers
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	407 -- TODO: get the supergroup name from the old Savane configuration
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	408 UPDATE auth_user SET is_staff=1, is_superuser=1
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	409 WHERE id IN (
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	410 SELECT user_id
5c90eef9f2c1 - Import user->group membership Sylvain Beucler <beuc@beuc.net> parents: 91 diff changeset	411 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	412 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	413 );
262 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
296 6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	416 ----
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	417 -- JOBS
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	418 ----
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	419
262 00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	420 TRUNCATE svpeople_job;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	421 -- id <- job_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	422 -- created_by_id <- created_by
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	423 -- status <- status_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	424 INSERT INTO svpeople_job
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	425 (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	426 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	427 FROM savane_old.people_job;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	428
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	429 TRUNCATE svpeople_category;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	430 -- id <- category_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	431 -- label <- name
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	432 -- active <- '1'
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	433 INSERT INTO svpeople_category
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	434 (id, label, active)
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	435 SELECT category_id, name, '1'
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	436 FROM savane_old.people_job_category;
283 4006e8d335f6 i18n fixes Sylvain Beucler <beuc@beuc.net> parents: 275 diff changeset	437 # Decapitalize, used in translations
4006e8d335f6 i18n fixes Sylvain Beucler <beuc@beuc.net> parents: 275 diff changeset	438 UPDATE svpeople_category SET label='Project manager' WHERE label='Project Manager';
4006e8d335f6 i18n fixes Sylvain Beucler <beuc@beuc.net> parents: 275 diff changeset	439 UPDATE svpeople_category SET label='Unix admin' WHERE label='Unix Admin';
4006e8d335f6 i18n fixes Sylvain Beucler <beuc@beuc.net> parents: 275 diff changeset	440 UPDATE svpeople_category SET label='Doc writer' WHERE label='Doc Writer';
4006e8d335f6 i18n fixes Sylvain Beucler <beuc@beuc.net> parents: 275 diff changeset	441 UPDATE svpeople_category SET label='Support manager' WHERE label='Support Manager';
4006e8d335f6 i18n fixes Sylvain Beucler <beuc@beuc.net> parents: 275 diff changeset	442 UPDATE svpeople_category SET label='Graphic/other designer' WHERE label='Graphic/Other Designer';
262 00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	443
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	444 TRUNCATE svpeople_skill;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	445 -- id <- skill_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	446 -- label <- name
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	447 -- active <- '1'
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	448 INSERT INTO svpeople_skill
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	449 (id, label, active)
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	450 SELECT skill_id, name, '1'
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	451 FROM savane_old.people_skill;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	452 TRUNCATE svpeople_skilllevel;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	453 -- id <- skill_level_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	454 -- label <- name
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	455 -- active <- '1'
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	456 INSERT INTO svpeople_skilllevel
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	457 (id, label, active)
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	458 SELECT skill_level_id, name, '1'
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	459 FROM savane_old.people_skill_level;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	460 TRUNCATE svpeople_skillyear;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	461 -- id <- skill_year_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	462 -- label <- name
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	463 -- active <- '1'
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	464 INSERT INTO svpeople_skillyear
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	465 (id, label, active)
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	466 SELECT skill_year_id, name, '1'
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	467 FROM savane_old.people_skill_year;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	468
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	469 TRUNCATE svpeople_jobinventory;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	470 -- id <- job_inventory_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	471 INSERT INTO svpeople_jobinventory
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	472 (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	473 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	474 FROM savane_old.people_job_inventory;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	475 TRUNCATE svpeople_skillinventory;
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	476 -- id <- skill_inventory_id
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	477 INSERT INTO svpeople_skillinventory
00ab06c9fd1d Migrate Job data from Savane3 Sylvain Beucler <beuc@beuc.net> parents: 255 diff changeset	478 (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	479 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	480 FROM savane_old.people_skill_inventory;
296 6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	481
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	482
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	483 ----
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	484 -- TRACKERS
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	485 ----
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	486
316 e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	487 TRUNCATE tracker_tracker;
300 a07974912f41 Import trackers fields definition Sylvain Beucler <beuc@beuc.net> parents: 296 diff changeset	488 INSERT INTO tracker_tracker (`name`) VALUES ('bugs');
a07974912f41 Import trackers fields definition Sylvain Beucler <beuc@beuc.net> parents: 296 diff changeset	489 INSERT INTO tracker_tracker (`name`) VALUES ('patch');
a07974912f41 Import trackers fields definition Sylvain Beucler <beuc@beuc.net> parents: 296 diff changeset	490 INSERT INTO tracker_tracker (`name`) VALUES ('support');
a07974912f41 Import trackers fields definition Sylvain Beucler <beuc@beuc.net> parents: 296 diff changeset	491 INSERT INTO tracker_tracker (`name`) VALUES ('task');
a07974912f41 Import trackers fields definition Sylvain Beucler <beuc@beuc.net> parents: 296 diff changeset	492
296 6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	493 TRUNCATE tracker_item;
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	494 INSERT INTO tracker_item
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	495 (tracker_id, public_bugs_id, group_id, status_id, severity, privacy,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	496 discussion_lock,
326 f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	497 vote, spamscore, ip, category_id, submitted_by_id, assigned_to_id,
296 6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	498 date, summary, details, close_date, bug_group_id, resolution_id,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	499 category_version_id, platform_version_id, reproducibility_id,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	500 size_id, fix_release_id, plan_release_id, hours, component_version,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	501 fix_release, plan_release, priority,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	502 planned_starting_date, planned_close_date,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	503 percent_complete, keywords, release_id, `release`,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	504 originator_name, originator_email, originator_phone,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	505 custom_tf1, custom_tf2, custom_tf3, custom_tf4, custom_tf5,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	506 custom_tf6, custom_tf7, custom_tf8, custom_tf9, custom_tf10,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	507 custom_ta1, custom_ta2, custom_ta3, custom_ta4, custom_ta5,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	508 custom_ta6, custom_ta7, custom_ta8, custom_ta9, custom_ta10,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	509 custom_sb1, custom_sb2, custom_sb3, custom_sb4, custom_sb5,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	510 custom_sb6, custom_sb7, custom_sb8, custom_sb9, custom_sb10,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	511 custom_df1, custom_df2, custom_df3, custom_df4, custom_df5)
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	512 SELECT
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	513 'bugs', bug_id, group_id, status_id, severity, privacy, discussion_lock,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	514 vote, spamscore, ip, category_id, submitted_by, assigned_to,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	515 FROM_UNIXTIME(date), IFNULL(summary, ''), IFNULL(details, ''), FROM_UNIXTIME(close_date), bug_group_id, resolution_id,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	516 category_version_id, platform_version_id, reproducibility_id,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	517 size_id, fix_release_id, plan_release_id, hours, component_version,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	518 fix_release, plan_release, priority,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	519 FROM_UNIXTIME(planned_starting_date),
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	520 FROM_UNIXTIME(planned_close_date),
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	521 percent_complete, keywords, release_id, `release`,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	522 originator_name, originator_email, originator_phone,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	523 custom_tf1, custom_tf2, custom_tf3, custom_tf4, custom_tf5,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	524 custom_tf6, custom_tf7, custom_tf8, custom_tf9, custom_tf10,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	525 custom_ta1, custom_ta2, custom_ta3, custom_ta4, custom_ta5,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	526 custom_ta6, custom_ta7, custom_ta8, custom_ta9, custom_ta10,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	527 custom_sb1, custom_sb2, custom_sb3, custom_sb4, custom_sb5,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	528 custom_sb6, custom_sb7, custom_sb8, custom_sb9, custom_sb10,
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	529 FROM_UNIXTIME(IF(custom_df1<0,0,custom_df1)),
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	530 FROM_UNIXTIME(IF(custom_df2<0,0,custom_df2)),
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	531 FROM_UNIXTIME(IF(custom_df3<0,0,custom_df3)),
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	532 FROM_UNIXTIME(IF(custom_df4<0,0,custom_df4)),
6070e8187f39 Start trackers import Sylvain Beucler <beuc@beuc.net> parents: 289 diff changeset	533 FROM_UNIXTIME(IF(custom_df5<0,0,custom_df5))
322 3f005a413dfc Trackers: prepare static fields definition Sylvain Beucler <beuc@beuc.net> parents: 316 diff changeset	534 FROM savane_old.bugs;
3f005a413dfc Trackers: prepare static fields definition Sylvain Beucler <beuc@beuc.net> parents: 316 diff changeset	535 -- Specify "default" differently
326 f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	536 UPDATE tracker_item SET assigned_to_id=NULL WHERE assigned_to_id=100;
f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	537 UPDATE tracker_item SET submitted_by_id=NULL WHERE submitted_by_id=100;
307 b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	538
328 91a6a6c540d4 Static fields definition won't be interesting in the long run Sylvain Beucler <beuc@beuc.net> parents: 326 diff changeset	539 -- Get rid of field_usage duplicates (old mysql/php/savane bug?)
307 b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	540 -- It only affected group_id=100, maybe the installation was done
b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	541 -- twice or something.
b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	542 -- Give priority to the last one.
b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	543 -- Need to create a real table - a temporary one has issues with being "reopened" in joins
326 f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	544 DROP TABLE IF EXISTS temp_bugs_field_usage;
307 b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	545 CREATE TABLE temp_bugs_field_usage AS SELECT * FROM savane_old.bugs_field_usage;
b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	546 ALTER TABLE temp_bugs_field_usage ADD (id INT auto_increment PRIMARY KEY);
b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	547 DELETE FROM temp_bugs_field_usage
b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	548 WHERE id IN (
b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	549 SELECT id FROM (
b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	550 SELECT B.id FROM temp_bugs_field_usage A, temp_bugs_field_usage B
b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	551 WHERE A.id > B.id
b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	552 AND A.bug_field_id = B.bug_field_id AND A.group_id = B.group_id
b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	553 ) AS temp
b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	554 );
b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	555 -- id <- <auto>
b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	556 -- field_id <- bug_field_id
326 f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	557 -- Don't import default values, they are now defined statically in
f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	558 -- tracker.defs.
f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	559 TRUNCATE tracker_fieldoverlay;
f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	560 INSERT INTO tracker_fieldoverlay
f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	561 (group_id, field_name, use_it, show_on_add_anonymous, show_on_add_connected, show_on_add_members, rank,
f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	562 label, description, display_size, empty_ok,
f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	563 keep_history, transition_default_auth)
307 b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	564 SELECT
326 f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	565 group_id, field_name, use_it, IF(show_on_add<2,0,1), IF(show_on_add%2=0,0,1), show_on_add_members, place,
307 b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	566 custom_label, custom_description, custom_display_size, custom_empty_ok,
b503430e963a Import bugs_field_usage and remove duplicates Sylvain Beucler <beuc@beuc.net> parents: 300 diff changeset	567 IFNULL(custom_keep_history, 0), transition_default_auth
326 f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	568 FROM temp_bugs_field_usage JOIN savane_old.bugs_field
f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	569 USING (bug_field_id)
f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	570 WHERE group_id != 100;
316 e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	571 DROP TABLE temp_bugs_field_usage;
308 006f6c019bc8 Field usage admin Sylvain Beucler <beuc@beuc.net> parents: 307 diff changeset	572 -- Specify "default" differently
326 f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	573 -- UPDATE tracker_fieldoverlay SET group_id=NULL WHERE group_id=100;
316 e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	574
328 91a6a6c540d4 Static fields definition won't be interesting in the long run Sylvain Beucler <beuc@beuc.net> parents: 326 diff changeset	575 -- Get rid of field_value duplicates (old mysql/php/savane bug?)
316 e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	576 -- Apparently this affects 'None' values.
e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	577 -- Give priority to the last one (arbitrarily).
e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	578 DELETE FROM savane_old.bugs_field_value
e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	579 WHERE bug_fv_id IN (
e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	580 SELECT bug_fv_id FROM (
e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	581 SELECT B.bug_fv_id FROM savane_old.bugs_field_value A, savane_old.bugs_field_value B
e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	582 WHERE A.bug_fv_id > B.bug_fv_id
e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	583 AND A.bug_field_id = B.bug_field_id AND A.group_id = B.group_id AND A.value_id = B.value_id
e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	584 ) AS temp
326 f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	585 );
316 e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	586 -- id <- <auto>
e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	587 -- field_id <- bug_field_id
e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	588 TRUNCATE tracker_fieldvalue;
e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	589 INSERT INTO tracker_fieldvalue
326 f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	590 (group_id, field_name, value_id, `value`, description,
316 e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	591 order_id, status, email_ad, send_all_flag)
e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	592 SELECT
326 f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	593 group_id, field_name, value_id, `value`, savane_old.bugs_field_value.description,
316 e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	594 order_id, status, email_ad, send_all_flag
326 f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	595 FROM savane_old.bugs_field_value JOIN savane_old.bugs_field
f34eba406e57 More model refinement + update migration script Sylvain Beucler <beuc@beuc.net> parents: 322 diff changeset	596 USING (bug_field_id);
316 e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	597 -- Specify "default" differently
e80f63d8ddc3 Migrate FieldValue + other docs on trackers Sylvain Beucler <beuc@beuc.net> parents: 308 diff changeset	598 UPDATE tracker_fieldvalue SET group_id=NULL WHERE group_id=100;

Mercurial > hg > savane-forge

annotate migrate_old_savane.sql @ 328:91a6a6c540d4