From 6cc35cde8bfbe5b6212db75a3a61f3813b17023f Mon Sep 17 00:00:00 2001
From: Guillaume Pellerin <guillaume.pellerin@ircam.fr>
Date: Sat, 18 May 2019 11:38:16 +0200
Subject: [PATCH] add MyISAM to InnoDB mysql converter

---
 .gitignore                |  1 -
 bin/sql/myisam2innodb.sql | 84 +++++++++++++++++++++++++++++++++++++++
 2 files changed, 84 insertions(+), 1 deletion(-)
 create mode 100644 bin/sql/myisam2innodb.sql

diff --git a/.gitignore b/.gitignore
index dc5e19ec..d88899c7 100644
--- a/.gitignore
+++ b/.gitignore
@@ -9,7 +9,6 @@
 build
 eggs
 parts
-bin
 var
 data/media
 data/var
diff --git a/bin/sql/myisam2innodb.sql b/bin/sql/myisam2innodb.sql
new file mode 100644
index 00000000..916426ca
--- /dev/null
+++ b/bin/sql/myisam2innodb.sql
@@ -0,0 +1,84 @@
+ALTER TABLE telemeta.acquisition_modes ENGINE=InnoDB;
+ALTER TABLE telemeta.ad_conversions ENGINE=InnoDB;
+ALTER TABLE telemeta.auth_group ENGINE=InnoDB;
+ALTER TABLE telemeta.auth_group_permissions ENGINE=InnoDB;
+ALTER TABLE telemeta.auth_message ENGINE=InnoDB;
+ALTER TABLE telemeta.auth_permission ENGINE=InnoDB;
+ALTER TABLE telemeta.auth_user ENGINE=InnoDB;
+ALTER TABLE telemeta.auth_user_groups ENGINE=InnoDB;
+ALTER TABLE telemeta.auth_user_user_permissions ENGINE=InnoDB;
+ALTER TABLE telemeta.context_keywords ENGINE=InnoDB;
+ALTER TABLE telemeta.copy_type ENGINE=InnoDB;
+ALTER TABLE telemeta.django_admin_log ENGINE=InnoDB;
+ALTER TABLE telemeta.django_content_type ENGINE=InnoDB;
+ALTER TABLE telemeta.django_session ENGINE=InnoDB;
+ALTER TABLE telemeta.django_site ENGINE=InnoDB;
+ALTER TABLE telemeta.ethnic_group_aliases ENGINE=InnoDB;
+ALTER TABLE telemeta.ethnic_groups ENGINE=InnoDB;
+ALTER TABLE telemeta.generic_styles ENGINE=InnoDB;
+ALTER TABLE telemeta.googletools_analyticscode ENGINE=InnoDB;
+ALTER TABLE telemeta.googletools_siteverificationcode ENGINE=InnoDB;
+ALTER TABLE telemeta.identifier_type ENGINE=InnoDB;
+ALTER TABLE telemeta.instrument_alias_relations ENGINE=InnoDB;
+ALTER TABLE telemeta.instrument_aliases ENGINE=InnoDB;
+ALTER TABLE telemeta.instrument_relations ENGINE=InnoDB;
+ALTER TABLE telemeta.instruments ENGINE=InnoDB;
+ALTER TABLE telemeta.ipauth_range ENGINE=InnoDB;
+ALTER TABLE telemeta.jqchat_message ENGINE=InnoDB;
+ALTER TABLE telemeta.jqchat_room ENGINE=InnoDB;
+ALTER TABLE telemeta.languages ENGINE=InnoDB;
+ALTER TABLE telemeta.legal_rights ENGINE=InnoDB;
+ALTER TABLE telemeta.location_aliases ENGINE=InnoDB;
+ALTER TABLE telemeta.location_relations ENGINE=InnoDB;
+ALTER TABLE telemeta.location_types ENGINE=InnoDB;
+ALTER TABLE telemeta.locations ENGINE=InnoDB;
+ALTER TABLE telemeta.media_analysis ENGINE=InnoDB;
+ALTER TABLE telemeta.media_collection_identifier ENGINE=InnoDB;
+ALTER TABLE telemeta.media_collection_related ENGINE=InnoDB;
+ALTER TABLE telemeta.media_collections ENGINE=InnoDB;
+ALTER TABLE telemeta.media_corpus ENGINE=InnoDB;
+ALTER TABLE telemeta.media_corpus_children ENGINE=InnoDB;
+ALTER TABLE telemeta.media_corpus_related ENGINE=InnoDB;
+ALTER TABLE telemeta.media_fonds ENGINE=InnoDB;
+ALTER TABLE telemeta.media_fonds_children ENGINE=InnoDB;
+ALTER TABLE telemeta.media_fonds_related ENGINE=InnoDB;
+ALTER TABLE telemeta.media_formats ENGINE=InnoDB;
+ALTER TABLE telemeta.media_item_identifier ENGINE=InnoDB;
+ALTER TABLE telemeta.media_item_keywords ENGINE=InnoDB;
+ALTER TABLE telemeta.media_item_performances ENGINE=InnoDB;
+ALTER TABLE telemeta.media_item_related ENGINE=InnoDB;
+ALTER TABLE telemeta.media_items ENGINE=InnoDB;
+ALTER TABLE telemeta.media_markers ENGINE=InnoDB;
+ALTER TABLE telemeta.media_parts ENGINE=InnoDB;
+ALTER TABLE telemeta.media_status ENGINE=InnoDB;
+ALTER TABLE telemeta.media_transcoding ENGINE=InnoDB;
+ALTER TABLE telemeta.media_type ENGINE=InnoDB;
+ALTER TABLE telemeta.metadata_authors ENGINE=InnoDB;
+ALTER TABLE telemeta.metadata_writers ENGINE=InnoDB;
+ALTER TABLE telemeta.organization ENGINE=InnoDB;
+ALTER TABLE telemeta.original_channel_number ENGINE=InnoDB;
+ALTER TABLE telemeta.original_format ENGINE=InnoDB;
+ALTER TABLE telemeta.physical_formats ENGINE=InnoDB;
+ALTER TABLE telemeta.playlist_resources ENGINE=InnoDB;
+ALTER TABLE telemeta.playlists ENGINE=InnoDB;
+ALTER TABLE telemeta.profiles ENGINE=InnoDB;
+ALTER TABLE telemeta.publisher_collections ENGINE=InnoDB;
+ALTER TABLE telemeta.publishers ENGINE=InnoDB;
+ALTER TABLE telemeta.publishing_status ENGINE=InnoDB;
+ALTER TABLE telemeta.recording_contexts ENGINE=InnoDB;
+ALTER TABLE telemeta.revisions ENGINE=InnoDB;
+ALTER TABLE telemeta.rights ENGINE=InnoDB;
+ALTER TABLE telemeta.search_criteria ENGINE=InnoDB;
+ALTER TABLE telemeta.searches ENGINE=InnoDB;
+ALTER TABLE telemeta.searches_criteria ENGINE=InnoDB;
+ALTER TABLE telemeta.south_migrationhistory ENGINE=InnoDB;
+ALTER TABLE telemeta.tape_length ENGINE=InnoDB;
+ALTER TABLE telemeta.tape_speed ENGINE=InnoDB;
+ALTER TABLE telemeta.tape_vendor ENGINE=InnoDB;
+ALTER TABLE telemeta.tape_wheel_diameter ENGINE=InnoDB;
+ALTER TABLE telemeta.tape_width ENGINE=InnoDB;
+ALTER TABLE telemeta.telemeta_media_transcoded ENGINE=InnoDB;
+ALTER TABLE telemeta.thumbnail_kvstore ENGINE=InnoDB;
+ALTER TABLE telemeta.topic ENGINE=InnoDB;
+ALTER TABLE telemeta.users ENGINE=InnoDB;
+ALTER TABLE telemeta.vernacular_styles ENGINE=InnoDB;
-- 
2.39.5