BW Rox to Drupal database migration: Difference between revisions
(→todo) |
|||
Line 30: | Line 30: | ||
====todo==== | ====todo==== | ||
* members_roles | * <strike>members_roles</strike>? | ||
* members_updating_status? | * members_updating_status? |
Revision as of 02:17, 28 August 2011
- See also Set up BW Drupal
Trying to get an idea of what needs to be migrated and how...
mysql bwroxdb -e 'show tables\G'|grep Table|awk '{ print $2 }' was used as a starting point.
For now this is only about the data migration, not about the presentation of the data.
Work in progress
- ewiki => bw_wikipage
Users
- user => Drupal users
- members => Drupal profile
- addresses
- cryptedfields
Passwords
SOLVED D6 user password import to D7doesn't work- we need a Rox authentication module that will upgrade passwords to D7 user_hash_password when a user logs in
User Relationships
tables:
- comments (started)
- feedbacks
- feedbackcategories
- verifiedmembers
need to be exportable
todo
members_roles?
- members_updating_status?
- donations?
To import
Geo
Maybe this can actually be done through a Drupal module + some service, instead of importing.
geo_hierarchy geo_location geo_type geo_usage geonames_admincodes geonames_alternate_names geonames_cache geonames_cache_backup geonames_countries geonames_timezones
Groups
Nice but not essential:
- groups
- groups_locations
- groupshierarchy
- members_groups_subscribed
- membersgroups
- members_tags_subscribed
- members_threads_subscribed
Possibly optional?
Kinda done
- faq
- faqcategories
Used for translations
- words
Not needed
user_friends
Not clear yet
NbMembersByCities addresses blog blog_categories blog_categories_seq blog_comments blog_comments_seq blog_data blog_seq blog_tags blog_tags_seq blog_to_category blog_to_tag broadcast broadcastmessages cal_event_to_tag cal_eventdata cal_events cal_tags chat_messages chat_room_moderators chat_rooms chat_rooms_members cities comments comments_ofthemomment_votes core_session_expiry core_sessions counters_cities_nbmembers counters_regions_nbcities counters_regions_nbmembers countries dbversion donations feedbackcategories feedbacks flags flagsmembers forum_trads forums_posts forums_posts_votes forums_tags forums_threads forums_threads_votes func gallery gallery_comments gallery_comments_seq gallery_items gallery_items_seq gallery_items_to_gallery gallery_seq groups groups_locations groupshierarchy groupsmessages guestsonline hcvol_config intermembertranslations languages linklist localvolmessages localvolmessages_location logs meetings members_groups_subscribed members_roles members_tags_subscribed members_threads_subscribed members_updating_status membersgroups memberslanguageslevel membersmeetings membersphotos memberspreferences memberspublicprofiles memberstrads message messages mod_user_apps mod_user_apps_seq mod_user_auth mod_user_auth_seq mod_user_authgroups mod_user_authrights mod_user_groupauth mod_user_grouprights mod_user_implications mod_user_rights mod_user_rights_seq mycontacts notes old_t_cities_old_BW old_t_regions oldvisits online params pendingmandatory plannedtrips polls polls_choices polls_choices_hierachy polls_contributions polls_list_allowed_countries polls_list_allowed_groups polls_list_allowed_locations polls_record_of_choices posts_notificationqueue preferences previousversion privileges privilegescopes proc profilesvisits recentvisits recorded_usernames_of_left_members regions reports_to_moderators rights rightsvolunteers roles roles_privileges shouts shouts_seq specialrelations sqlforgroupsmembers sqlforvolunteers stats tags_threads translations trip trip_data trip_seq trip_to_gallery urlheader_languages user_inbox user_outbox user_seq user_settings v_cities volunteer_boards volunteers_reports_schedule wEnglish words_use
Useful info
- This page is written in the context of BeWelcome.