BW Rox to Drupal database migration: Difference between revisions
(→Geo) |
|||
| Line 84: | Line 84: | ||
== Not clear yet == | == Not clear yet == | ||
<pre> | <pre> | ||
NbMembersByCities | NbMembersByCities - not needed ~~~ | ||
addresses | addresses | ||
blog | blog | ||
| Line 99: | Line 99: | ||
broadcast | broadcast | ||
broadcastmessages | broadcastmessages | ||
cal_event_to_tag | cal_event_to_tag - not needed ~~~ | ||
cal_eventdata | cal_eventdata - not needed ~~~ | ||
cal_events | cal_events - not needed ~~~ | ||
cal_tags | cal_tags - not needed ~~~ | ||
chat_messages | chat_messages - not needed ~~~ | ||
chat_room_moderators | chat_room_moderators - not needed ~~~ | ||
chat_rooms | chat_rooms - not needed ~~~ | ||
chat_rooms_members | chat_rooms_members - not needed ~~~ | ||
cities | cities - not needed ~~~ | ||
comments | comments | ||
comments_ofthemomment_votes | comments_ofthemomment_votes | ||
core_session_expiry | core_session_expiry | ||
core_sessions | core_sessions | ||
counters_cities_nbmembers | counters_cities_nbmembers - not needed ~~~ | ||
counters_regions_nbcities | counters_regions_nbcities - not needed ~~~ | ||
counters_regions_nbmembers | counters_regions_nbmembers - not needed ~~~ | ||
countries | countries | ||
| Line 180: | Line 180: | ||
mycontacts | mycontacts | ||
notes | notes | ||
old_t_cities_old_BW | old_t_cities_old_BW - not needed ~~~ | ||
old_t_regions | old_t_regions - not needed ~~~ | ||
oldvisits | oldvisits - not needed ~~~ | ||
online | online - not needed ~~~ | ||
params | params | ||
pendingmandatory | pendingmandatory | ||
| Line 213: | Line 213: | ||
shouts_seq | shouts_seq | ||
specialrelations | specialrelations | ||
sqlforgroupsmembers | sqlforgroupsmembers - not needed ~~~ | ||
sqlforvolunteers | sqlforvolunteers - not needed ~~~ | ||
stats | stats | ||
tags_threads | tags_threads | ||
| Line 233: | Line 233: | ||
wEnglish | wEnglish | ||
words_use | words_use - not needed ~~~ | ||
</pre> | </pre> | ||
== Useful info == | == Useful info == | ||
Revision as of 02:26, 16 September 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
- imho passwords are secondary. It will be super easy for the users to request a new password once we do the final change - not worth the time Philipp 00:21, 16 September 2011 (UTC)
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
yes, do not import
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 - not needed ~~~ 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 - not needed ~~~ cal_eventdata - not needed ~~~ cal_events - not needed ~~~ cal_tags - not needed ~~~ chat_messages - not needed ~~~ chat_room_moderators - not needed ~~~ chat_rooms - not needed ~~~ chat_rooms_members - not needed ~~~ cities - not needed ~~~ comments comments_ofthemomment_votes core_session_expiry core_sessions counters_cities_nbmembers - not needed ~~~ counters_regions_nbcities - not needed ~~~ counters_regions_nbmembers - not needed ~~~ 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 - not needed ~~~ old_t_regions - not needed ~~~ oldvisits - not needed ~~~ online - not needed ~~~ 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 - not needed ~~~ sqlforvolunteers - not needed ~~~ 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 - not needed ~~~
Useful info
- This page is written in the context of BeWelcome.