#!sql

-- PARTIE 1 - FORUM : INSERTION DES DONNEES

-- #1 Import des données de "mdl_moodecforum" vers "mdl_forumqta"
INSERT INTO mdl_forumqta SELECT * FROM mdl_moodecforum;

-- #2 Import des données de "mdl_moodecforum_blobs" vers "mdl_forumqta_blobs"
INSERT INTO mdl_forumqta_blobs SELECT * FROM mdl_moodecforum_blobs;

-- #3 Import des données de "mdl_moodecforum_cache" vers "mdl_forumqta_cache"
INSERT INTO mdl_forumqta_cache SELECT * FROM mdl_moodecforum_cache;

-- #4 Import des données de "mdl_moodecforum_categories" vers "mdl_forumqta_categories"
ALTER TABLE mdl_moodecforum_categories CHANGE moodecforumid forumqtaid BIGINT(10) NOT NULL;
INSERT INTO mdl_forumqta_categories SELECT * FROM mdl_moodecforum_categories;

-- #5 Import des données de "mdl_moodecforum_categorymetas" vers "mdl_forumqta_categorymetas"
INSERT INTO mdl_forumqta_categorymetas SELECT * FROM mdl_moodecforum_categorymetas;

-- #6 Import des données de "mdl_moodecforum_contentwords" vers "mdl_forumqta_contentwords"
INSERT INTO mdl_forumqta_contentwords SELECT * FROM mdl_moodecforum_contentwords;

-- #7 Import des données de "mdl_moodecforum_cookies" vers "mdl_forumqta_cookies"
INSERT INTO mdl_forumqta_cookies SELECT * FROM mdl_moodecforum_cookies;

-- #8 Import des données de "mdl_moodecforum_iplimits" vers "mdl_forumqta_iplimits"
INSERT INTO mdl_forumqta_iplimits SELECT * FROM mdl_moodecforum_iplimits;

-- #9 Import des données de "mdl_moodecforum_options" vers "mdl_forumqta_options"
DELETE FROM mdl_forumqta_options ;
INSERT INTO mdl_forumqta_options SELECT * FROM mdl_moodecforum_options;

-- #10 Import des données de "mdl_forumqta_pages" vers "mdl_moodecforum_pages"
INSERT INTO mdl_moodecforum_pages SELECT * FROM mdl_forumqta_pages;

-- #11 Import des données de "mdl_moodecforum_postmetas" vers "mdl_forumqta_postmetas"
INSERT INTO mdl_forumqta_postmetas SELECT * FROM mdl_moodecforum_postmetas;

-- #12 Import des données de "mdl_moodecforum_posts" vers "mdl_forumqta_posts"
INSERT INTO mdl_forumqta_posts SELECT * FROM mdl_moodecforum_posts;

-- #13 Import des données de "mdl_moodecforum_posttags" vers "mdl_forumqta_posttags"
INSERT INTO mdl_forumqta_posttags SELECT * FROM mdl_moodecforum_posttags;

-- #14 Import des données de "mdl_moodecforum_sharedevents" vers "mdl_forumqta_sharedevents"
INSERT INTO mdl_forumqta_sharedevents SELECT * FROM mdl_moodecforum_sharedevents;

-- #15 Import des données de "mdl_moodecforum_tagmetas" vers "mdl_forumqta_tagmetas"
INSERT INTO mdl_forumqta_tagmetas SELECT * FROM mdl_moodecforum_tagmetas;

-- #16 Import des données de "mdl_moodecforum_tagwords" vers "mdl_forumqta_tagwords"
INSERT INTO mdl_forumqta_tagwords SELECT * FROM mdl_moodecforum_tagwords;

-- #17 Import des données de "mdl_moodecforum_titlewords" vers "mdl_forumqta_titlewords"
INSERT INTO mdl_forumqta_titlewords SELECT * FROM mdl_moodecforum_titlewords;

-- #18 Import des données de "mdl_moodecforum_userevents" vers "mdl_forumqta_userevents"
INSERT INTO mdl_forumqta_userevents SELECT * FROM mdl_moodecforum_userevents;

-- #19 Import des données de "mdl_moodecforum_userfavorites" vers "mdl_forumqta_userfavorites"
INSERT INTO mdl_forumqta_userfavorites SELECT * FROM mdl_moodecforum_userfavorites;

-- #20 Import des données de "mdl_moodecforum_userlevels" vers "mmdl_forumqta_userlevels"
INSERT INTO mdl_forumqta_userlevels SELECT * FROM mdl_moodecforum_userlevels;

-- #21 Import des données de "mdl_moodecforum_userlimits" vers "mdl_forumqta_userlimits"
INSERT INTO mdl_forumqta_userlimits SELECT * FROM mdl_moodecforum_userlimits;

-- #22 Import des données de "mdl_moodecforum_usermetas" vers "mdl_forumqta_usermetas"
INSERT INTO mdl_forumqta_usermetas SELECT * FROM mdl_moodecforum_usermetas;

-- #23 Import des données de "mdl_moodecforum_usernotices" vers "mdl_forumqta_usernotices"
INSERT INTO mdl_forumqta_usernotices SELECT * FROM mdl_moodecforum_usernotices;

-- #24 Import des données de "mdl_moodecforum_userpoints" vers "mdl_forumqta_userpoints"
INSERT INTO mdl_forumqta_userpoints SELECT * FROM mdl_moodecforum_userpoints;

-- #25 Import des données de "mdl_moodecforum_uservotes" vers "mdl_forumqta_uservotes"
INSERT INTO mdl_forumqta_uservotes SELECT * FROM mdl_moodecforum_uservotes;

-- #26 Import des données de "mdl_moodecforum_widgets" vers "mdl_forumqta_widgets"
INSERT INTO mdl_forumqta_widgets SELECT * FROM mdl_moodecforum_widgets;

-- #27 Import des données de "mdl_moodecforum_words" vers "mdl_forumqta_words"
INSERT INTO mdl_forumqta_words SELECT * FROM mdl_moodecforum_words;

-- CHANGE ID /!\ Changer/Vérifier les 'ID', puis décommenter
SET @moodecforumID = (SELECT id FROM mdl_modules WHERE name = 'moodecforum');
SET @tempID = 9999;
UPDATE mdl_modules SET id = @tempID WHERE mdl_modules.id = @moodecforumID AND name = 'moodecforum';
SET @forumqtaID = (SELECT id FROM mdl_modules WHERE name = 'forumqta');
UPDATE mdl_modules SET id = @moodecforumID WHERE mdl_modules.id = @forumqtaID AND name = 'forumqta';
UPDATE mdl_modules SET id = @forumqtaID WHERE mdl_modules.id = @tempID AND name = 'moodecforum';

-- DROP MDL_MOODECFORUM'S TABLES
DROP TABLE mdl_moodecforum,mdl_moodecforum_blobs,mdl_moodecforum_cache,mdl_moodecforum_categories,mdl_moodecforum_categorymetas,mdl_moodecforum_contentwords,mdl_moodecforum_cookies,mdl_moodecforum_iplimits,mdl_moodecforum_options,mdl_moodecforum_pages,mdl_moodecforum_postmetas,mdl_moodecforum_posts,mdl_moodecforum_posttags,mdl_moodecforum_sharedevents,mdl_moodecforum_tagmetas,mdl_moodecforum_tagwords,mdl_moodecforum_titlewords,mdl_moodecforum_userevents,mdl_moodecforum_userfavorites,mdl_moodecforum_userlevels,mdl_moodecforum_userlimits,mdl_moodecforum_usermetas,mdl_moodecforum_usernotices,mdl_moodecforum_userpoints,mdl_moodecforum_uservotes,mdl_moodecforum_widgets,mdl_moodecforum_words;