MAJ phpBB 3.0.x vers 3.1.x : Outil STK

Forum concernant les demandes de support pour tout problème de mise à jour d'un forum phpBB 3.1.x depuis une version antérieure ou d'une conversion de phpBB2 ou phpBB3 vers phpBB 3.1

Modérateur: Equipe

Règles du forum
A lire impérativement : Règlement de phpBB-fr.com

Pensez à effectuer une recherche, la réponse à votre question a de grandes chances d'avoir déjà été donnée.
Partager sur FacebookPartager sur TwitterPartager sur Google+

MAJ phpBB 3.0.x vers 3.1.x : Outil STK

Messagepar tablettechinoise » 18 Avr 2016 à 15:10

Forum http://www.tablette-chinoise.net/forum
Version phpbb : 3.0.12

Bonjour à tous,

Me revoilà enfin pour basculer en phpbb version 3.1.8.

Je suis en cours de tests sur une duplication du forum afin de pouvoir voir les différentes étapes pour arriver à mes fins.

En suivant votre methode : http://forums.phpbb-fr.com/documentation/mise-a-jour/31x-mise-a-niveau-de-phpbb-30x-vers-31x-a209-view.html je commence par utiliser l' Outil de mise à niveau de MySQL de STK

Je me retrouve avec une erreur. Afin de l'isoler, je pris le script et enlever la partie bloquante qui est :

Code: Tout sélectionner
# Table: phpbb_bbcodes
ALTER TABLE phpbb_bbcodes
	MODIFY bbcode_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
	MODIFY bbcode_tag varchar(16) DEFAULT '' NOT NULL COLLATE utf8_bin,
	MODIFY bbcode_helpline varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
	MODIFY display_on_posting tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	MODIFY bbcode_match text NOT NULL COLLATE utf8_bin,
	MODIFY bbcode_tpl mediumtext NOT NULL COLLATE utf8_bin,
	MODIFY first_pass_match mediumtext NOT NULL COLLATE utf8_bin,
	MODIFY first_pass_replace mediumtext NOT NULL COLLATE utf8_bin,
	MODIFY second_pass_match mediumtext NOT NULL COLLATE utf8_bin,
	MODIFY second_pass_replace mediumtext NOT NULL COLLATE utf8_bin,
	DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


Lors de l'execution de ce script ci-dessus, j'ai en retour dans ma base de donnée via phpmyadmin ceci :

Code: Tout sélectionner
 MySQL a répondu: Documentation
#1062 - Duplicate entry '0' for key 'PRIMARY' 


Pour tout le reste du script fourni par l'outil, là pas de souci sauf que la réponse est :

Code: Tout sélectionner
# MySQL a retourné un résultat vide (aucune ligne).


Pour finir, si je lance sous STK le Nettoyeur de base de données, il me propose ceci :
Image

Si je clique sur Continuer, ma base de donnée est explosé et j'ai ceci en message :

Image

Voilou pour un premier bilan et merci pour votre aide

Cdt

Tof
tablettechinoise
Posteur expérimenté
Posteur expérimenté
 
Messages: 343
Enregistré le: 21 Mar 2013 à 21:28

Re: MAJ phpBB 3.0.x vers 3.1.x : Outil STK

Messagepar Skouat » 18 Avr 2016 à 15:51

Bonjour,

tablettechinoise a écrit:je commence par utiliser l' Outil de mise à niveau de MySQL de STK

Je me retrouve avec une erreur. Afin de l'isoler, je pris le script et enlever la partie bloquante qui est :

Code: Tout sélectionner
# Table: phpbb_bbcodes
ALTER TABLE phpbb_bbcodes
	MODIFY bbcode_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
	MODIFY bbcode_tag varchar(16) DEFAULT '' NOT NULL COLLATE utf8_bin,
	MODIFY bbcode_helpline varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
	MODIFY display_on_posting tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	MODIFY bbcode_match text NOT NULL COLLATE utf8_bin,
	MODIFY bbcode_tpl mediumtext NOT NULL COLLATE utf8_bin,
	MODIFY first_pass_match mediumtext NOT NULL COLLATE utf8_bin,
	MODIFY first_pass_replace mediumtext NOT NULL COLLATE utf8_bin,
	MODIFY second_pass_match mediumtext NOT NULL COLLATE utf8_bin,
	MODIFY second_pass_replace mediumtext NOT NULL COLLATE utf8_bin,
	DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


Lors de l'execution de ce script ci-dessus, j'ai en retour dans ma base de donnée via phpmyadmin ceci :

Code: Tout sélectionner
 MySQL a répondu: Documentation
#1062 - Duplicate entry '0' for key 'PRIMARY' 


Pour tout le reste du script fourni par l'outil, là pas de souci sauf que la réponse est :

Code: Tout sélectionner
# MySQL a retourné un résultat vide (aucune ligne).



De quel script parlez vous ? car il n'est aucunement mentionné d'utiliser un quelconque script dans la documentation que vous citez.

tablettechinoise a écrit:Pour finir, si je lance sous STK le Nettoyeur de base de données, il me propose ceci :
Image

Si je clique sur Continuer, ma base de donnée est explosé et j'ai ceci en message :

Image


J'ai beau avoir des lunettes... les miniatures c'est difficillement exploitable. :wink:

Cordialement.
Mes MODS

Ultima-World Hébergé par phpBB-Services
Code parrainage : 1241646554
Skouat
Traducteur
Traducteur
 
Messages: 13629
Enregistré le: 02 Avr 2008 à 20:47

Re: MAJ phpBB 3.0.x vers 3.1.x : Outil STK

Messagepar tablettechinoise » 18 Avr 2016 à 15:58

Clic droit puis ouvrir l'image dans un nouvel onglet... ;) sous chrome mais ça marche pas à tout les coups...

Toutefois, utilise Firefox et en cliquant sur l'image, elle apparaît en grand . ;)
tablettechinoise
Posteur expérimenté
Posteur expérimenté
 
Messages: 343
Enregistré le: 21 Mar 2013 à 21:28

Re: MAJ phpBB 3.0.x vers 3.1.x : Outil STK

Messagepar cocooncrash » 18 Avr 2016 à 16:17

dsl tablette, on n'y voit rien!!! tu as poster des vignettes!!!
decouvrez l'aide complete : ICI
découvrez les règles : La_bas

Pensez a ajouter le tag [réglé] en modifiant votre premier message s'il est résolu. Merci :wink:
Avatar de l’utilisateur
cocooncrash
Resp. des modérateurs
Resp. des modérateurs
 
Messages: 7619
Enregistré le: 07 Jan 2008 à 09:29
Localisation: dans un bocal en compagnie de nemo!!

Re: MAJ phpBB 3.0.x vers 3.1.x : Outil STK

Messagepar tablettechinoise » 18 Avr 2016 à 19:37

Voici les images :

Image 1 : http://88.181.151.128:8080/BUG_IMAGE/img_1.png

Image 2 : http://88.181.151.128:8080/BUG_IMAGE/img_2.png

En ce qui concerne le script, je parlais de Outil de mise à niveau de MySQL est des requêtes qui sont produit pour mettre à niveau Mysql.

Apparemment, il faut s'occuper uniquement du Nettoyeur de base de données.
tablettechinoise
Posteur expérimenté
Posteur expérimenté
 
Messages: 343
Enregistré le: 21 Mar 2013 à 21:28

Re: MAJ phpBB 3.0.x vers 3.1.x : Outil STK

Messagepar Skouat » 19 Avr 2016 à 19:36

Bonjour,

Les liens vers les images, donnés dans le précédent message, ne sont pas valides. On arrive sur un forum 3.1 fraichement installé.
Mes MODS

Ultima-World Hébergé par phpBB-Services
Code parrainage : 1241646554
Skouat
Traducteur
Traducteur
 
Messages: 13629
Enregistré le: 02 Avr 2008 à 20:47

Re: MAJ phpBB 3.0.x vers 3.1.x : Outil STK

Messagepar tablettechinoise » 20 Avr 2016 à 01:02

Skouat a écrit:Bonjour,

Les liens vers les images, donnés dans le précédent message, ne sont pas valides. On arrive sur un forum 3.1 fraichement installé.



Oups,

Corrigé ;)
tablettechinoise
Posteur expérimenté
Posteur expérimenté
 
Messages: 343
Enregistré le: 21 Mar 2013 à 21:28

Re: MAJ phpBB 3.0.x vers 3.1.x : Outil STK

Messagepar FoFa » 20 Avr 2016 à 15:54

Hello,

tablettechinoise a écrit:je commence par utiliser l' Outil de mise à niveau de MySQL de STK

Je me retrouve avec une erreur

Et quelle est l'erreur ? Car là vous enlevez une portion de code, mais cela génère d'autres erreurs. Donc ce n'est pas la bonne méthode.

Donnez-nous la première erreur et on vous en dira davantage.

Cordialement.
Après l'assassinat de mon ordinateur, je reviens progressivement vers vous...
FoFa
Resp. des supporters
Resp. des supporters
 
Messages: 10565
Enregistré le: 15 Nov 2008 à 19:04
Localisation: Auxonne

Re: MAJ phpBB 3.0.x vers 3.1.x : Outil STK

Messagepar tablettechinoise » 20 Avr 2016 à 16:28

Re,

Voici l'ensemble du code produit par l'outil de mise à niveau de MySQL de STK :

Code: Tout sélectionner
# Table: phpbb_attachments
ALTER TABLE phpbb_attachments
   MODIFY attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY physical_filename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY real_filename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY attach_comment text NOT NULL COLLATE utf8_bin,
   MODIFY extension varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY mimetype varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY filetime int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_acl_groups
ALTER TABLE phpbb_acl_groups
   MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY auth_setting tinyint(2) DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_acl_options
ALTER TABLE phpbb_acl_options
   MODIFY auth_option_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY auth_option varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY is_global tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY is_local tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY founder_only tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_acl_roles
ALTER TABLE phpbb_acl_roles
   MODIFY role_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY role_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY role_description text NOT NULL COLLATE utf8_bin,
   MODIFY role_type varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY role_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_acl_roles_data
ALTER TABLE phpbb_acl_roles_data
   MODIFY role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY auth_setting tinyint(2) DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_acl_users
ALTER TABLE phpbb_acl_users
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY auth_setting tinyint(2) DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_banlist
ALTER TABLE phpbb_banlist
   MODIFY ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY ban_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY ban_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY ban_email varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY ban_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY ban_end int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY ban_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY ban_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY ban_give_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   DROP INDEX ban_email,
   ADD KEY ban_email (ban_email, ban_exclude),
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_bbcodes
ALTER TABLE phpbb_bbcodes
   MODIFY bbcode_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY bbcode_tag varchar(16) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY bbcode_helpline varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY display_on_posting tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY bbcode_match text NOT NULL COLLATE utf8_bin,
   MODIFY bbcode_tpl mediumtext NOT NULL COLLATE utf8_bin,
   MODIFY first_pass_match mediumtext NOT NULL COLLATE utf8_bin,
   MODIFY first_pass_replace mediumtext NOT NULL COLLATE utf8_bin,
   MODIFY second_pass_match mediumtext NOT NULL COLLATE utf8_bin,
   MODIFY second_pass_replace mediumtext NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_bookmarks
ALTER TABLE phpbb_bookmarks
   MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_bots
ALTER TABLE phpbb_bots
   MODIFY bot_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY bot_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY bot_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY bot_agent varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY bot_ip varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_config
ALTER TABLE phpbb_config
   MODIFY config_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY config_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY is_dynamic tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_confirm
ALTER TABLE phpbb_confirm
   MODIFY confirm_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY confirm_type tinyint(3) DEFAULT '0' NOT NULL,
   MODIFY code varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY seed int(10) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY attempts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_disallow
ALTER TABLE phpbb_disallow
   MODIFY disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY disallow_username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_drafts
ALTER TABLE phpbb_drafts
   MODIFY draft_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY save_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY draft_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY draft_message mediumtext NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_extensions
ALTER TABLE phpbb_extensions
   MODIFY extension_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY extension varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_extension_groups
ALTER TABLE phpbb_extension_groups
   MODIFY group_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY group_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY cat_id tinyint(2) DEFAULT '0' NOT NULL,
   MODIFY allow_group tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY upload_icon varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY max_filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY allowed_forums text NOT NULL COLLATE utf8_bin,
   MODIFY allow_in_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_forums
ALTER TABLE phpbb_forums
   MODIFY forum_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY forum_parents mediumtext NOT NULL COLLATE utf8_bin,
   MODIFY forum_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY forum_desc text NOT NULL COLLATE utf8_bin,
   MODIFY forum_desc_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY forum_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
   MODIFY forum_desc_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY forum_link varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY forum_password varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY forum_style mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY forum_image varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY forum_rules text NOT NULL COLLATE utf8_bin,
   MODIFY forum_rules_link varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY forum_rules_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY forum_rules_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
   MODIFY forum_rules_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY forum_topics_per_page tinyint(4) DEFAULT '0' NOT NULL,
   MODIFY forum_type tinyint(4) DEFAULT '0' NOT NULL,
   MODIFY forum_status tinyint(4) DEFAULT '0' NOT NULL,
   MODIFY forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY forum_topics mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY forum_topics_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY forum_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY forum_last_post_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY forum_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY forum_last_poster_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY forum_flags tinyint(4) DEFAULT '32' NOT NULL,
   MODIFY display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY enable_indexing tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY enable_icons tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY enable_prune tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY prune_next int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY prune_days mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY prune_viewed mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY prune_freq mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY display_subforum_list tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY forum_options int(20) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_forums_access
ALTER TABLE phpbb_forums_access
   MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_forums_track
ALTER TABLE phpbb_forums_track
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_forums_watch
ALTER TABLE phpbb_forums_watch
   MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_groups
ALTER TABLE phpbb_groups
   MODIFY group_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY group_type tinyint(4) DEFAULT '1' NOT NULL,
   MODIFY group_founder_manage tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY group_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY group_desc text NOT NULL COLLATE utf8_bin,
   MODIFY group_desc_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
   MODIFY group_desc_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY group_avatar varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY group_avatar_type tinyint(2) DEFAULT '0' NOT NULL,
   MODIFY group_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY group_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY group_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY group_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY group_sig_chars mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY group_receive_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY group_message_limit mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY group_legend tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY group_max_recipients mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY group_skip_auth tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_icons
ALTER TABLE phpbb_icons
   MODIFY icons_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY icons_url varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY icons_width tinyint(4) DEFAULT '0' NOT NULL,
   MODIFY icons_height tinyint(4) DEFAULT '0' NOT NULL,
   MODIFY icons_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_lang
ALTER TABLE phpbb_lang
   MODIFY lang_id tinyint(4) NOT NULL auto_increment,
   MODIFY lang_iso varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY lang_dir varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY lang_english_name varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY lang_local_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY lang_author varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_log
ALTER TABLE phpbb_log
   MODIFY log_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY log_type tinyint(4) DEFAULT '0' NOT NULL,
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY reportee_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY log_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY log_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY log_operation text NOT NULL COLLATE utf8_bin,
   MODIFY log_data mediumtext NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_moderator_cache
ALTER TABLE phpbb_moderator_cache
   MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY group_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_modules
ALTER TABLE phpbb_modules
   MODIFY module_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY module_enabled tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY module_display tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY module_basename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY module_class varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY module_langname varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY module_mode varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY module_auth varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_poll_options
ALTER TABLE phpbb_poll_options
   MODIFY poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
   MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY poll_option_text text NOT NULL COLLATE utf8_bin,
   MODIFY poll_option_total mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_poll_votes
ALTER TABLE phpbb_poll_votes
   MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
   MODIFY vote_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY vote_user_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_posts
ALTER TABLE phpbb_posts
   MODIFY post_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY poster_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY post_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY post_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY post_username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY post_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY post_text mediumtext NOT NULL COLLATE utf8_bin,
   MODIFY post_checksum varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY bbcode_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY post_postcount tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY post_edit_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY post_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY post_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY post_edit_locked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   DROP INDEX post_username,
   ADD KEY post_username (post_username),
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_privmsgs
ALTER TABLE phpbb_privmsgs
   MODIFY msg_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY root_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY author_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY message_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY message_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY message_text mediumtext NOT NULL COLLATE utf8_bin,
   MODIFY message_edit_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY bbcode_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY to_address text NOT NULL COLLATE utf8_bin,
   MODIFY bcc_address text NOT NULL COLLATE utf8_bin,
   MODIFY message_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_privmsgs_folder
ALTER TABLE phpbb_privmsgs_folder
   MODIFY folder_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY folder_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY pm_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_privmsgs_rules
ALTER TABLE phpbb_privmsgs_rules
   MODIFY rule_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY rule_check mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY rule_connection mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY rule_string varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY rule_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY rule_group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY rule_action mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY rule_folder_id int(11) DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_privmsgs_to
ALTER TABLE phpbb_privmsgs_to
   MODIFY msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY pm_deleted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY pm_new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY pm_unread tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY pm_replied tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY pm_marked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY pm_forwarded tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY folder_id int(11) DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_profile_fields
ALTER TABLE phpbb_profile_fields
   MODIFY field_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY field_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY field_type tinyint(4) DEFAULT '0' NOT NULL,
   MODIFY field_ident varchar(20) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY field_length varchar(20) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY field_minlen varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY field_maxlen varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY field_novalue varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY field_default_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY field_validation varchar(20) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY field_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY field_no_view tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY field_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY field_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY field_show_profile tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY field_show_on_vt tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY field_show_novalue tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_profile_fields_data
ALTER TABLE phpbb_profile_fields_data
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_profile_fields_lang
ALTER TABLE phpbb_profile_fields_lang
   MODIFY field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY field_type tinyint(4) DEFAULT '0' NOT NULL,
   MODIFY lang_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_profile_lang
ALTER TABLE phpbb_profile_lang
   MODIFY field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY lang_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY lang_explain text NOT NULL COLLATE utf8_bin,
   MODIFY lang_default_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_ranks
ALTER TABLE phpbb_ranks
   MODIFY rank_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY rank_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY rank_min mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY rank_special tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY rank_image varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_reports
ALTER TABLE phpbb_reports
   MODIFY report_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY reason_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY report_closed tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY report_text mediumtext NOT NULL COLLATE utf8_bin,
   MODIFY pm_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_reports_reasons
ALTER TABLE phpbb_reports_reasons
   MODIFY reason_id smallint(4) UNSIGNED NOT NULL auto_increment,
   MODIFY reason_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY reason_description mediumtext NOT NULL COLLATE utf8_bin,
   MODIFY reason_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_search_results
ALTER TABLE phpbb_search_results
   MODIFY search_key varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY search_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY search_keywords mediumtext NOT NULL COLLATE utf8_bin,
   MODIFY search_authors mediumtext NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_search_wordlist
ALTER TABLE phpbb_search_wordlist
   MODIFY word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY word_text varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY word_common tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY word_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   DROP INDEX wrd_txt,
   ADD UNIQUE wrd_txt (word_text),
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_search_wordmatch
ALTER TABLE phpbb_search_wordmatch
   MODIFY post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY word_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY title_match tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_sessions
ALTER TABLE phpbb_sessions
   MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY session_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY session_last_visit int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY session_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY session_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY session_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY session_browser varchar(150) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY session_forwarded_for varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY session_page varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY session_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY session_autologin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY session_admin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY session_forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_sessions_keys
ALTER TABLE phpbb_sessions_keys
   MODIFY key_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY last_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY last_login int(11) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_sitelist
ALTER TABLE phpbb_sitelist
   MODIFY site_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY site_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY site_hostname varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY ip_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_smilies
ALTER TABLE phpbb_smilies
   MODIFY smiley_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY code varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY emotion varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY smiley_url varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY smiley_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY smiley_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY smiley_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_styles
ALTER TABLE phpbb_styles
   MODIFY style_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY style_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY style_copyright varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY style_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY template_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY theme_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY imageset_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   DROP INDEX style_name,
   ADD UNIQUE style_name (style_name),
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_styles_template
ALTER TABLE phpbb_styles_template
   MODIFY template_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY template_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY template_copyright varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY template_path varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY bbcode_bitfield varchar(255) DEFAULT 'kNg=' NOT NULL COLLATE utf8_bin,
   MODIFY template_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY template_inherits_id int(4) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY template_inherit_path varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   DROP INDEX tmplte_nm,
   ADD UNIQUE tmplte_nm (template_name),
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_styles_template_data
ALTER TABLE phpbb_styles_template_data
   MODIFY template_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY template_filename varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY template_included text NOT NULL COLLATE utf8_bin,
   MODIFY template_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY template_data mediumtext NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_styles_theme
ALTER TABLE phpbb_styles_theme
   MODIFY theme_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY theme_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY theme_copyright varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY theme_path varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY theme_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY theme_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY theme_data mediumtext NOT NULL COLLATE utf8_bin,
   DROP INDEX theme_name,
   ADD UNIQUE theme_name (theme_name),
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_styles_imageset
ALTER TABLE phpbb_styles_imageset
   MODIFY imageset_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY imageset_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY imageset_copyright varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY imageset_path varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
   DROP INDEX imgset_nm,
   ADD UNIQUE imgset_nm (imageset_name),
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_styles_imageset_data
ALTER TABLE phpbb_styles_imageset_data
   MODIFY image_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY image_name varchar(200) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY image_filename varchar(200) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY image_lang varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY image_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY image_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY imageset_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_topics
ALTER TABLE phpbb_topics
   MODIFY topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY topic_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY topic_poster mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_time_limit int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_replies_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_status tinyint(3) DEFAULT '0' NOT NULL,
   MODIFY topic_type tinyint(3) DEFAULT '0' NOT NULL,
   MODIFY topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_first_poster_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY topic_first_poster_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_last_poster_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY topic_last_poster_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY topic_last_post_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY topic_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_last_view_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_bumped tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_bumper mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY poll_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY poll_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY poll_length int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY poll_max_options tinyint(4) DEFAULT '1' NOT NULL,
   MODIFY poll_last_vote int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY poll_vote_change tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_topics_track
ALTER TABLE phpbb_topics_track
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_topics_posted
ALTER TABLE phpbb_topics_posted
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY topic_posted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_topics_watch
ALTER TABLE phpbb_topics_watch
   MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_user_group
ALTER TABLE phpbb_user_group
   MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY group_leader tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_pending tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_users
ALTER TABLE phpbb_users
   MODIFY user_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY user_type tinyint(2) DEFAULT '0' NOT NULL,
   MODIFY group_id mediumint(8) UNSIGNED DEFAULT '3' NOT NULL,
   MODIFY user_permissions mediumtext NOT NULL COLLATE utf8_bin,
   MODIFY user_perm_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_regdate int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY username_clean varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_password varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_passchg int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_pass_convert tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_email varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_email_hash bigint(20) DEFAULT '0' NOT NULL,
   MODIFY user_birthday varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_lastvisit int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_lastmark int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_lastpost_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_lastpage varchar(200) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_last_confirm_key varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_last_search int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_warnings tinyint(4) DEFAULT '0' NOT NULL,
   MODIFY user_last_warning int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_login_attempts tinyint(4) DEFAULT '0' NOT NULL,
   MODIFY user_inactive_reason tinyint(2) DEFAULT '0' NOT NULL,
   MODIFY user_inactive_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_lang varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_timezone decimal(5,2) DEFAULT '0' NOT NULL,
   MODIFY user_dst tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_dateformat varchar(30) DEFAULT 'd M Y H:i' NOT NULL COLLATE utf8_bin,
   MODIFY user_style mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_new_privmsg int(4) DEFAULT '0' NOT NULL,
   MODIFY user_unread_privmsg int(4) DEFAULT '0' NOT NULL,
   MODIFY user_last_privmsg int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_message_rules tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_full_folder int(11) DEFAULT '-3' NOT NULL,
   MODIFY user_emailtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_topic_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_topic_sortby_type varchar(1) DEFAULT 't' NOT NULL COLLATE utf8_bin,
   MODIFY user_topic_sortby_dir varchar(1) DEFAULT 'd' NOT NULL COLLATE utf8_bin,
   MODIFY user_post_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_post_sortby_type varchar(1) DEFAULT 't' NOT NULL COLLATE utf8_bin,
   MODIFY user_post_sortby_dir varchar(1) DEFAULT 'a' NOT NULL COLLATE utf8_bin,
   MODIFY user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_notify_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY user_notify_type tinyint(4) DEFAULT '0' NOT NULL,
   MODIFY user_allow_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY user_allow_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY user_allow_viewemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY user_allow_massemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY user_options int(11) UNSIGNED DEFAULT '230271' NOT NULL,
   MODIFY user_avatar varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_avatar_type tinyint(2) DEFAULT '0' NOT NULL,
   MODIFY user_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_sig mediumtext NOT NULL COLLATE utf8_bin,
   MODIFY user_sig_bbcode_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_sig_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_from varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_icq varchar(15) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_aim varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_yim varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_msnm varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_jabber varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_website varchar(200) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_occ text NOT NULL COLLATE utf8_bin,
   MODIFY user_interests text NOT NULL COLLATE utf8_bin,
   MODIFY user_actkey varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_newpasswd varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_form_salt varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY user_new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
   MODIFY user_reminded tinyint(4) DEFAULT '0' NOT NULL,
   MODIFY user_reminded_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   DROP INDEX username_clean,
   ADD UNIQUE username_clean (username_clean),
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_warnings
ALTER TABLE phpbb_warnings
   MODIFY warning_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY log_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY warning_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_words
ALTER TABLE phpbb_words
   MODIFY word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY word varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY replacement varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_zebra
ALTER TABLE phpbb_zebra
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY zebra_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY friend tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY foe tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_captcha_answers
ALTER TABLE phpbb_captcha_answers
   MODIFY question_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY answer_text varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_captcha_questions
ALTER TABLE phpbb_captcha_questions
   MODIFY question_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   MODIFY strict tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY lang_iso varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY question_text text NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_qa_confirm
ALTER TABLE phpbb_qa_confirm
   MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY confirm_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY lang_iso varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY question_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY attempts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY confirm_type smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: phpbb_login_attempts
ALTER TABLE phpbb_login_attempts
   MODIFY attempt_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY attempt_browser varchar(150) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY attempt_forwarded_for varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
   MODIFY attempt_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   MODIFY username varchar(255) DEFAULT '0' NOT NULL COLLATE utf8_bin,
   MODIFY username_clean varchar(255) DEFAULT '0' NOT NULL COLLATE utf8_bin,
   DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


Si je clique sur Exécuter dans l'option de l'outil de mise à niveau de MySQL de STK, voici le résultat :

Code: Tout sélectionner
Erreur générale
SQL ERROR [ mysqli ]

Out of range value for column 'bbcode_id' at row 2 [1264]

SQL

ALTER TABLE phpbb_bbcodes MODIFY bbcode_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL, MODIFY bbcode_tag varchar(16) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY bbcode_helpline varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY display_on_posting tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY bbcode_match text NOT NULL COLLATE utf8_bin, MODIFY bbcode_tpl mediumtext NOT NULL COLLATE utf8_bin, MODIFY first_pass_match mediumtext NOT NULL COLLATE utf8_bin, MODIFY first_pass_replace mediumtext NOT NULL COLLATE utf8_bin, MODIFY second_pass_match mediumtext NOT NULL COLLATE utf8_bin, MODIFY second_pass_replace mediumtext NOT NULL COLLATE utf8_bin, DEFAULT CHARSET=utf8 COLLATE=utf8_bin

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: stk_msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 189
CALL: dbal->sql_error()

FILE: [ROOT]/stk/tools/support/mysql_upgrader.php
LINE: 337
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/stk/tools/support/mysql_upgrader.php
LINE: 70
CALL: mysql_upgrader->_run_result()

FILE: [ROOT]/stk/index.php
LINE: 293
CALL: mysql_upgrader->display_options()


Apparemment, ça plante aprés la requête étape 7
tablettechinoise
Posteur expérimenté
Posteur expérimenté
 
Messages: 343
Enregistré le: 21 Mar 2013 à 21:28

Re: MAJ phpBB 3.0.x vers 3.1.x : Outil STK

Messagepar tablettechinoise » 21 Avr 2016 à 19:12

Re tous,

Bien après investigation, j'ai trouvé que c’était ABBC 3.0 qui posait problème et notamment la colonne bbcode_id

Si je supprime cette ligne (ligne 87) :

Code: Tout sélectionner
MODIFY bbcode_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,


du code qui est généré par l'outil de mise à niveau de MySQL de STK , le code s’exécute dans ma base de donnée et la réponse est :
Code: Tout sélectionner
# MySQL a retourné un résultat vide (aucune ligne).


Donc à vrai dire, pas grand chose de modifié. Toutefois, je m’interroge sur l'erreur provoqué la bbcode_id

Je passe à l'autre erreur en ouvrant un nouveau topic
tablettechinoise
Posteur expérimenté
Posteur expérimenté
 
Messages: 343
Enregistré le: 21 Mar 2013 à 21:28

Re: MAJ phpBB 3.0.x vers 3.1.x : Outil STK

Messagepar Skouat » 22 Avr 2016 à 20:54

Bonjour,

tablettechinoise a écrit:
Code: Tout sélectionner
# MySQL a retourné un résultat vide (aucune ligne).

Donc à vrai dire, pas grand chose de modifié. Toutefois, je m’interroge sur l'erreur provoqué la bbcode_id

Où ca signifie que l'upgrade MySQL n'était pas nécessaire.
Mes MODS

Ultima-World Hébergé par phpBB-Services
Code parrainage : 1241646554
Skouat
Traducteur
Traducteur
 
Messages: 13629
Enregistré le: 02 Avr 2008 à 20:47

Re: MAJ phpBB 3.0.x vers 3.1.x : Outil STK

Messagepar tablettechinoise » 29 Avr 2016 à 19:53

Ché pas, j'y connais rien... DU coup, j'attends plus des retours de personnes qui peuvent m'aider sur ma question et réflexion ;)
Modifié en dernier par Steph le 29 Avr 2016 à 20:17, modifié 1 fois.
Raison: Suppression de la citation inutile du précedent message en entier
tablettechinoise
Posteur expérimenté
Posteur expérimenté
 
Messages: 343
Enregistré le: 21 Mar 2013 à 21:28


Retourner vers Mises à jour/Conversions

 


  • Articles en relation
    Réponses
    Vues
    Dernier message

Qui est en ligne

Utilisateurs parcourant ce forum : Aucun utilisateur enregistré et 1 invité