V2 Migration Forum : Différence entre versions
(→Liste des tables) |
(→Table phpbb_users) |
||
| Ligne 26 : | Ligne 26 : | ||
* user_email(varchar(100)) => wefrag_users.email(varchar(255)) | * user_email(varchar(100)) => wefrag_users.email(varchar(255)) | ||
vérifier longueur max en table | vérifier longueur max en table | ||
| − | * user_email_hash(bigint(20)) => | + | * user_email_hash(bigint(20)) => |
d'après [https://www.phpbb.com/community/viewtopic.php?f=71&t=570125 ce lien] : crc32(strtolower($user_email)) . strlen($user_email), | d'après [https://www.phpbb.com/community/viewtopic.php?f=71&t=570125 ce lien] : crc32(strtolower($user_email)) . strlen($user_email), | ||
| + | '''à tester''' | ||
* user_birthday(varchar(10)) => wefrag_users.birthdate(date) | * user_birthday(varchar(10)) => wefrag_users.birthdate(date) | ||
* user_lastvisit(int(11) unsigned) => 0 | * user_lastvisit(int(11) unsigned) => 0 | ||
| − | * user_lastmark | + | * user_lastmark(int(11) unsigned) => 0 |
| − | * user_lastpost_time | + | * user_lastpost_time(int(11) unsigned) => |
| − | * user_lastpage | + | Récupérer la date du dernier post. |
| − | * user_last_confirm_key | + | * user_lastpage(varchar(200)) => ''vide'' |
| − | * user_last_search | + | * user_last_confirm_key(varchar(10)) => ''vide'' |
| − | * user_warnings | + | * user_last_search(int(11) unsigned) => ''0'' |
| − | * user_last_warning | + | * user_warnings(tinyint(4)) => ''0'' |
| − | * user_login_attempts | + | * user_last_warning(int(11) unsigned) => ''0'' |
| − | * user_inactive_reason | + | * user_login_attempts(tinyint(4)) => ''0'' |
| − | * user_inactive_time | + | * user_inactive_reason(tinyint(2)) => ''0'' |
| + | * user_inactive_time(int(11) unsigned) => ''0'' | ||
* user_posts | * user_posts | ||
* user_lang | * user_lang | ||
Version du 30 août 2017 à 14:26
Objectif
- Basculer le forum vers phpbb 3.2
Procédure
- Récupérer le dump du forum.
- Installer un xampp ou équivalent
- Installer phpbb sur son poste
- Utiliser DBeaver ou tout autre pour comparer les tables phpbb avec celles du forum (travail manuel)
Liste des tables
Table phpbb_users
- user_id (int(10) unsigned) => wefrag_users.id(int(11))
- user_type(tinyint(2)) => ????
- group_id(mediumint(8) unsigned) => phpbb_groups.group_id
- user_permission(mediumtext) => vide
- user_perm_from(mediumint(8) unsigned) => 0
- user_ip(varchar(40)) => vide
- user_regdate(int(11) unsigned) => vide
- username(varchar(255)) => wefrag_users.login(varchar(255))
- username_clean(varchar(255)) => wefrag_users.login(varchar(255))
- user_password(varchar(255)) => wefrag_users.crypted_password(varchar(40))
Phpbb :techno proprio? Wefrag : sha1 ? voir ligne 220
- user_passch (int(11) unsigned) => wefrag_user_password_resets.?
pas forcément nécessaire
- user_email(varchar(100)) => wefrag_users.email(varchar(255))
vérifier longueur max en table
- user_email_hash(bigint(20)) =>
d'après ce lien : crc32(strtolower($user_email)) . strlen($user_email), à tester
- user_birthday(varchar(10)) => wefrag_users.birthdate(date)
- user_lastvisit(int(11) unsigned) => 0
- user_lastmark(int(11) unsigned) => 0
- user_lastpost_time(int(11) unsigned) =>
Récupérer la date du dernier post.
- user_lastpage(varchar(200)) => vide
- user_last_confirm_key(varchar(10)) => vide
- user_last_search(int(11) unsigned) => 0
- user_warnings(tinyint(4)) => 0
- user_last_warning(int(11) unsigned) => 0
- user_login_attempts(tinyint(4)) => 0
- user_inactive_reason(tinyint(2)) => 0
- user_inactive_time(int(11) unsigned) => 0
- user_posts
- user_lang
- user_timezone
- user_dateformat
- user_style
- user_rank
- user_colour
- user_new_privmsg
- user_unread_privmsg
- user_last_privmsg
- user_message_rules
- user_full_folder
- user_emailtime
- user_topic_show_days
- user_topic_sortby_type
- user_topic_sortby_dir
- user_post_show_days
- user_post_sortby_type
- user_post_sortby_dir
- user_notify
- user_notify_pm
- user_notify_type
- user_allow_pm
- user_allow_viewonline
- user_allow_viewemail
- user_allow_massemail
- user_options
- user_avatar
- user_avatar_type
- user_avatar_width
- user_avatar_height
- user_sig
- user_sig_bbcode_uid
- user_sig_bbcode_bitfield
- user_jabber
- user_actkey
- user_newpasswd
- user_form_salt
- user_new
- user_reminded
- user_reminded_time
