move a phpBB forum in another server

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Scam Warning
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
tubbadù
Registered User
Posts: 13
Joined: Wed Mar 28, 2018 7:07 pm

move a phpBB forum in another server

Post by tubbadù »

Hi everyone! I have got a phpBB forum in a free hosting service (altervista), but I need to move it in another host that I bought on aruba.it . How can I do it without losing all users and topics? I tried to search on the internet and I found several guides, but they all are so difficult that I can't follow them... for example in this guide https://www.phpbb.com/support/docs/en/3 ... or-domain/ I have done the backup and now I need to restore it, but it says "Extract the contents bigdump.zip file and open bigdump.php in your text editor.", but I don't know what bigdump is, I tryed to understand it on the net but now I'm more confused than before :shock:
what is the simpliest way to do it? Thank you very much!!! Bye!
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72667
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK

Re: move a phpBB forum in another server

Post by KevC »

At the top of that article in the requirements section there is a link to bigdump.

That's a little bit of script that helps you to upload large database backups to a new server. You edit the file to add your own database login info and then when you go to yoursite.com/yourfolder/bigdump.php it will connect to the server and do the importing for you.
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
tubbadù
Registered User
Posts: 13
Joined: Wed Mar 28, 2018 7:07 pm

Re: move a phpBB forum in another server

Post by tubbadù »

KevC wrote: Sat May 12, 2018 3:55 pm At the top of that article in the requirements section there is a link to bigdump.

That's a little bit of script that helps you to upload large database backups to a new server. You edit the file to add your own database login info and then when you go to yoursite.com/yourfolder/bigdump.php it will connect to the server and do the importing for you.
ah ok I understood it! thank you!

perfect, I followed the steps written in that guide, i downloaded the bugdump file, unzipped it, edited where the guide told me to do it, created a new folder and uploaded in this folder bigdump.php and my backup file. than I opened from my browser mywebsite.org/dump/bigdump.php and it showed me this screen:
BigDump: Staggered MySQL Dump Importer v0.36b

Filename Size Date&Time Type
backup_1526130203_aa24872a51468bda.sql.gz 240961 2018-05-12 18:36:06 GZip Start Import into Sql1216597_3 at 89.46.111.66 Delete file
You can now upload your dump file up to 26214400 bytes (25 Mbytes) directly from your browser to the server. Alternatively you can upload your dump files of any size via FTP.

Dump file: [CHOOSE FILE BUTTON]

[UPLOAD BUTTON]

Note: The current mySQL connection charset is utf8. Your dump file must be encoded in utf8 in order to avoid problems with non-latin characters. You can change the connection charset using the $db_connection_charset variable in bigdump.php
© 2003-2015 Alexey Ozerov
what file should I upload after clicking on the choose file button? if I upload bigdump.php or the backup file it says "
BigDump: Staggered MySQL Dump Importer v0.36b
File bigdump.php {or backup_1526130203_aa24872a51468bda.sql.gz} already exist! Delete and upload again!"

what should I upload?
thank you very much :D
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72667
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK

Re: move a phpBB forum in another server

Post by KevC »

You need to upload the database backup you said you had.
I would un gzip it first and just upload the sql file using FTP to the folder the bigdump.php file is in. Then when you launch it, it should find it straight away and take you to the import screen.
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
tubbadù
Registered User
Posts: 13
Joined: Wed Mar 28, 2018 7:07 pm

Re: move a phpBB forum in another server

Post by tubbadù »

KevC wrote: Sat May 12, 2018 5:13 pm You need to upload the database backup you said you had.
I would un gzip it first and just upload the sql file using FTP to the folder the bigdump.php file is in. Then when you launch it, it should find it straight away and take you to the import screen.
ah so the file I already uploaded in the dumb folder? (backup_1526130203_aa24872a51468bda.sql.gz)

PS: I have a doubt: in the new website should I have phpBB installed?
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72667
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK

Re: move a phpBB forum in another server

Post by KevC »

Yes and yes.

The idea is to replace the existing default database with the backup one.
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
User avatar
Lumpy Burgertushie
Registered User
Posts: 69228
Joined: Mon May 02, 2005 3:11 am

Re: move a phpBB forum in another server

Post by Lumpy Burgertushie »

yes the file you uploaded already is what you need. on that page you should see that filename listed and it should be blue so you can click on it.

once you do that, you should see a progress screen that tells you what it is doing.


you do not have to have phpbb installed yet but you do have to have a database created on the new host for phpbb to use.

I assume you already have that since you said you filled out the bigdump file with the database info already.

however, I would suggest that you go ahead and install phpbb using that database that you created.

first, how big is that backup_1526130203_aa24872a51468bda.sql.gz file?

if it is not over 2MB you can restore it from your phpbb admin panel .



using your ftp, upload the backup_1526130203_aa24872a51468bda.sql.gz file to the folder named "store" on the server.

now, in your phpbb admin panel of your new phpbb install, go to the maintenance tab and choose restore from the left menu.

choose that file and start the restore.

robert
Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
tubbadù
Registered User
Posts: 13
Joined: Wed Mar 28, 2018 7:07 pm

Re: move a phpBB forum in another server

Post by tubbadù »

Lumpy Burgertushie wrote: Sat May 12, 2018 6:00 pm yes the file you uploaded already is what you need. on that page you should see that filename listed and it should be blue so you can click on it.

once you do that, you should see a progress screen that tells you what it is doing.
no, it only takes half a second to complete and to show me... maybe I'm making some mistakes...
the screen I can see at mywebsite.org/dump/bigdump.php is something like this:

Filename Size Date&Time Type
backup_1526130203_aa24872a51468bda.sql.gz 240961 2018-05-12 21:04:42 GZip Start Import into Sql1216597_3 at 89.46.111.66 Delete file

I clicked on start import and it gave me this:

BigDump: Staggered MySQL Dump Importer v0.36b
Processing file: backup_1526130203_aa24872a51468bda.sql.gz

Starting from line: 1

Session Done To go Total
Lines 1209 1209 ? ?
Queries 182 182 ? ?
Bytes 240961 240961 ? ?
KB 235.31 235.31 ? ?
MB 0.23 0.23 ? ?
% ? ? ? 100
% bar [ Not available for gzipped files ]

Congratulations: End of file reached, assuming OK

IMPORTANT: REMOVE YOUR DUMP FILE and BIGDUMP SCRIPT FROM SERVER NOW!

Thank you for using this tool! Please rate Bigdump at Hotscripts.com

You can send me some bucks or euros as appreciation via PayPal. Thank you!

Make payments with PayPal - it's fast, free and secure!
Start from the beginning (DROP the old tables before restarting)

© 2003-2015 Alexey Ozerov


is it normal that "[Not available for gzipped files]"?


you do not have to have phpbb installed yet but you do have to have a database created on the new host for phpbb to use.

I assume you already have that since you said you filled out the bigdump file with the database info already.

however, I would suggest that you go ahead and install phpbb using that database that you created.



first, how big is that backup_1526130203_aa24872a51468bda.sql.gz file?
235 KB

if it is not over 2MB you can restore it from your phpbb admin panel .



using your ftp, upload the backup_1526130203_aa24872a51468bda.sql.gz file to the folder named "store" on the server.

now, in your phpbb admin panel of your new phpbb install, go to the maintenance tab and choose restore from the left menu.

choose that file and start the restore.

robert
that's what I tried to do first, but it doesn't works...
I did this:
1) in my old forum, I went to ACP > Maintenace > backup and downloaded the .gz file
2) in my new forum, with filezilla I uploaded the .gz file in the /store folder
3) in my new forum, i went in ACP > Maintenance > restore and clicked on the start restore button
in 2-3 seconds it said something like "all done, your board should be like when you did the backup"
4) i clicked on "forum index" link and nothing was changed :cry:
KevC wrote: Sat May 12, 2018 5:29 pm Yes and yes.

The idea is to replace the existing default database with the backup one.
ok perfect :D

PS: when I upload with filezilla the dumb folder it gives me a strange message "all transfers completed. files 22 can't be transfered" (the message given is in italian so I translated it better than I could)

Thank to both of you very much for trying to help me! :D
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72667
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK

Re: move a phpBB forum in another server

Post by KevC »

tubbadù wrote: Sat May 12, 2018 7:31 pm235 KB
That's not right. Even a brand new installation would be bigger than that.
It's likely to be a few Mb at least. How many users and posts did you have?

Open it in a text editor and post the first 50 lines here.
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
tubbadù
Registered User
Posts: 13
Joined: Wed Mar 28, 2018 7:07 pm

Re: move a phpBB forum in another server

Post by tubbadù »

KevC wrote: Sat May 12, 2018 8:43 pm
tubbadù wrote: Sat May 12, 2018 7:31 pm235 KB
That's not right. Even a brand new installation would be bigger than that.
It's likely to be a few Mb at least. How many users and posts did you have?
that's what I read rightclicking on it and going in property > dimension
the forum isn't big yet, it has got just 5 users and less than 10 topics

Open it in a text editor and post the first 50 lines here.

Code: Select all

#
# phpBB Backup Script
# Dump of tables for avphpbb_
# DATE : 12-05-2018 13:03:23 GMT
#
# Table: avphpbb_acl_groups
DROP TABLE IF EXISTS avphpbb_acl_groups;
CREATE TABLE `avphpbb_acl_groups` (
  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `auth_option_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `auth_role_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `auth_setting` tinyint(2) NOT NULL DEFAULT '0',
  KEY `group_id` (`group_id`),
  KEY `auth_opt_id` (`auth_option_id`),
  KEY `auth_role_id` (`auth_role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (1, 0, 85, 0, 1),(1, 0, 93, 0, 1),(1, 0, 110, 0, 1),(5, 0, 0, 5, 0),(5, 0, 0, 1, 0),(2, 0, 0, 6, 0),(3, 0, 0, 6, 0),(4, 0, 0, 5, 0),(4, 0, 0, 10, 0),(2, 6, 0, 15, 0),(5, 5, 0, 14, 0),(6, 5, 0, 19, 0),(4, 5, 0, 20, 0),(1, 5, 0, 16, 0),(7, 5, 0, 18, 0),(2, 5, 22, 0, 1),(2, 4, 2, 0, 1),(7, 4, 0, 18, 0),(1, 4, 0, 16, 0),(4, 4, 0, 20, 0),(7, 0, 0, 23, 0),(6, 4, 0, 19, 0),(5, 4, 0, 14, 0),(2, 14, 0, 16, 0),(8, 14, 0, 16, 0),(1, 13, 0, 15, 0),(5, 13, 0, 16, 0),(4, 13, 0, 16, 0),(7, 13, 0, 16, 0),(7, 6, 0, 18, 0),(1, 6, 0, 16, 0),(4, 6, 0, 20, 0),(6, 6, 0, 19, 0),(5, 6, 0, 14, 0),(2, 5, 20, 0, 1),(2, 5, 19, 0, 1),(2, 5, 14, 0, 1),(2, 5, 9, 0, 1),(2, 5, 7, 0, 1),(2, 5, 5, 0, 1),(8, 11, 0, 15, 0),(5, 11, 0, 14, 0),(6, 11, 0, 19, 0),(4, 11, 0, 20, 0),(1, 11, 0, 16, 0),(7, 11, 0, 18, 0),(2, 5, 25, 0, 1),(2, 5, 24, 0, 1),(2, 5, 13, 0, 1),(2, 5, 11, 0, 1),(2, 5, 4, 0, 1),(2, 5, 3, 0, 1),(8, 0, 0, 6, 0),(8, 6, 0, 15, 0),(8, 5, 0, 15, 0),(8, 4, 0, 15, 0),(2, 13, 0, 16, 0),(2, 5, 26, 0, 1),(2, 11, 0, 15, 0),(2, 5, 21, 0, 1),(2, 4, 6, 0, 1),(2, 4, 8, 0, 1),(2, 4, 12, 0, 1),(2, 4, 15, 0, 1),(2, 4, 17, 0, 1),(2, 4, 18, 0, 1),(2, 4, 21, 0, 1),(2, 4, 3, 0, 1),(2, 4, 4, 0, 1),(2, 4, 11, 0, 1),(2, 4, 13, 0, 1),(2, 4, 24, 0, 1),(2, 4, 25, 0, 1),(2, 4, 5, 0, 1),(2, 4, 7, 0, 1),(2, 4, 9, 0, 1),(2, 4, 14, 0, 1),(2, 4, 19, 0, 1),(2, 4, 20, 0, 1),(2, 4, 22, 0, 1),(2, 4, 23, 0, 1),(2, 4, 27, 0, 1),(2, 4, 29, 0, 1),(2, 4, 30, 0, 1),(2, 4, 1, 0, 1),(2, 5, 18, 0, 1),(2, 5, 15, 0, 1),(2, 5, 8, 0, 1),(2, 5, 2, 0, 1),(2, 5, 23, 0, 1),(2, 5, 27, 0, 1),(2, 5, 29, 0, 1),(2, 5, 30, 0, 1),(2, 5, 1, 0, 1),(8, 13, 0, 16, 0),(8, 12, 0, 16, 0),(2, 12, 0, 16, 0),(7, 12, 0, 16, 0),(4, 12, 0, 16, 0),(5, 12, 0, 16, 0),(1, 12, 0, 15, 0),(7, 14, 0, 16, 0),(4, 14, 0, 16, 0),(5, 14, 0, 16, 0),(1, 14, 0, 15, 0);

# Table: avphpbb_acl_options
DROP TABLE IF EXISTS avphpbb_acl_options;
CREATE TABLE `avphpbb_acl_options` (
  `auth_option_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `auth_option` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
  `is_global` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_local` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `founder_only` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`auth_option_id`),
  UNIQUE KEY `auth_option` (`auth_option`)
) ENGINE=MyISAM AUTO_INCREMENT=123 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_acl_options (auth_option_id, auth_option, is_global, is_local, founder_only) VALUES (1, 'f_', 0, 1, 0),(2, 'f_announce', 0, 1, 0),(3, 'f_attach', 0, 1, 0),(4, 'f_bbcode', 0, 1, 0),(5, 'f_bump', 0, 1, 0),(6, 'f_delete', 0, 1, 0),(7, 'f_download', 0, 1, 0),(8, 'f_edit', 0, 1, 0),(9, 'f_email', 0, 1, 0),(10, 'f_flash', 0, 1, 0),(11, 'f_icons', 0, 1, 0),(12, 'f_ignoreflood', 0, 1, 0),(13, 'f_img', 0, 1, 0),(14, 'f_list', 0, 1, 0),(15, 'f_noapprove', 0, 1, 0),(16, 'f_poll', 0, 1, 0),(17, 'f_post', 0, 1, 0),(18, 'f_postcount', 0, 1, 0),(19, 'f_print', 0, 1, 0),(20, 'f_read', 0, 1, 0),(21, 'f_reply', 0, 1, 0),(22, 'f_report', 0, 1, 0),(23, 'f_search', 0, 1, 0),(24, 'f_sigs', 0, 1, 0),(25, 'f_smilies', 0, 1, 0),(26, 'f_sticky', 0, 1, 0),(27, 'f_subscribe', 0, 1, 0),(28, 'f_user_lock', 0, 1, 0),(29, 'f_vote', 0, 1, 0),(30, 'f_votechg', 0, 1, 0),(31, 'm_', 1, 1, 0),(32, 'm_approve', 1, 1, 0),(33, 'm_chgposter', 1, 1, 0),(34, 'm_delete', 1, 1, 0),(35, 'm_edit', 1, 1, 0),(36, 'm_info', 1, 1, 0),(37, 'm_lock', 1, 1, 0),(38, 'm_merge', 1, 1, 0),(39, 'm_move', 1, 1, 0),(40, 'm_report', 1, 1, 0),(41, 'm_split', 1, 1, 0),(42, 'm_ban', 1, 0, 0),(43, 'm_warn', 1, 0, 0),(44, 'a_', 1, 0, 0),(45, 'a_aauth', 1, 0, 0),(46, 'a_attach', 1, 0, 0),(47, 'a_authgroups', 1, 0, 0),(48, 'a_authusers', 1, 0, 0),(49, 'a_backup', 1, 0, 0),(50, 'a_ban', 1, 0, 0),(51, 'a_bbcode', 1, 0, 0),(52, 'a_board', 1, 0, 0),(53, 'a_bots', 1, 0, 0),(54, 'a_clearlogs', 1, 0, 0),(55, 'a_email', 1, 0, 0),(56, 'a_fauth', 1, 0, 0),(57, 'a_forum', 1, 0, 0),(58, 'a_forumadd', 1, 0, 0),(59, 'a_forumdel', 1, 0, 0),(60, 'a_group', 1, 0, 0),(61, 'a_groupadd', 1, 0, 0),(62, 'a_groupdel', 1, 0, 0),(63, 'a_icons', 1, 0, 0),(64, 'a_jabber', 1, 0, 0),(65, 'a_language', 1, 0, 0),(66, 'a_mauth', 1, 0, 0),(67, 'a_modules', 1, 0, 0),(68, 'a_names', 1, 0, 0),(69, 'a_phpinfo', 1, 0, 0),(70, 'a_profile', 1, 0, 0),(71, 'a_prune', 1, 0, 0),(72, 'a_ranks', 1, 0, 0),(73, 'a_reasons', 1, 0, 0),(74, 'a_roles', 1, 0, 0),(75, 'a_search', 1, 0, 0),(76, 'a_server', 1, 0, 0),(77, 'a_styles', 1, 0, 0),(78, 'a_switchperm', 1, 0, 0),(79, 'a_uauth', 1, 0, 0),(80, 'a_user', 1, 0, 0),(81, 'a_userdel', 1, 0, 0),(82, 'a_viewauth', 1, 0, 0),(83, 'a_viewlogs', 1, 0, 0),(84, 'a_words', 1, 0, 0),(85, 'u_', 1, 0, 0),(86, 'u_attach', 1, 0, 0),(87, 'u_chgavatar', 1, 0, 0),(88, 'u_chgcensors', 1, 0, 0),(89, 'u_chgemail', 1, 0, 0),(90, 'u_chggrp', 1, 0, 0),(91, 'u_chgname', 1, 0, 0),(92, 'u_chgpasswd', 1, 0, 0),(93, 'u_download', 1, 0, 0),(94, 'u_hideonline', 1, 0, 0),(95, 'u_ignoreflood', 1, 0, 0),(96, 'u_masspm', 1, 0, 0),(97, 'u_pm_attach', 1, 0, 0),(98, 'u_pm_bbcode', 1, 0, 0),(99, 'u_pm_delete', 1, 0, 0),(100, 'u_pm_download', 1, 0, 0),(101, 'u_pm_edit', 1, 0, 0),(102, 'u_pm_emailpm', 1, 0, 0),(103, 'u_pm_flash', 1, 0, 0),(104, 'u_pm_forward', 1, 0, 0),(105, 'u_pm_img', 1, 0, 0),(106, 'u_pm_printpm', 1, 0, 0),(107, 'u_pm_smilies', 1, 0, 0),(108, 'u_readpm', 1, 0, 0),(109, 'u_savedrafts', 1, 0, 0),(110, 'u_search', 1, 0, 0),(111, 'u_sendemail', 1, 0, 0),(112, 'u_sendim', 1, 0, 0),(113, 'u_sendpm', 1, 0, 0),(114, 'u_sig', 1, 0, 0),(115, 'u_viewonline', 1, 0, 0),(116, 'u_viewprofile', 1, 0, 0),(117, 'u_masspm_group', 1, 0, 0),(118, 'a_extensions', 1, 0, 0),(119, 'u_chgprofileinfo', 1, 0, 0),(120, 'f_softdelete', 0, 1, 0),(121, 'm_softdelete', 1, 1, 0),(122, 'm_pm_report', 1, 0, 0);

# Table: avphpbb_acl_roles
DROP TABLE IF EXISTS avphpbb_acl_roles;
CREATE TABLE `avphpbb_acl_roles` (
  `role_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `role_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `role_description` text COLLATE utf8_bin NOT NULL,
  `role_type` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `role_order` smallint(4) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`role_id`),
  KEY `role_type` (`role_type`),
  KEY `role_order` (`role_order`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (1, 'ROLE_ADMIN_STANDARD', 'ROLE_DESCRIPTION_ADMIN_STANDARD', 'a_', 1),(2, 'ROLE_ADMIN_FORUM', 'ROLE_DESCRIPTION_ADMIN_FORUM', 'a_', 3),(3, 'ROLE_ADMIN_USERGROUP', 'ROLE_DESCRIPTION_ADMIN_USERGROUP', 'a_', 4),(4, 'ROLE_ADMIN_FULL', 'ROLE_DESCRIPTION_ADMIN_FULL', 'a_', 2),(5, 'ROLE_USER_FULL', 'ROLE_DESCRIPTION_USER_FULL', 'u_', 3),(6, 'ROLE_USER_STANDARD', 'ROLE_DESCRIPTION_USER_STANDARD', 'u_', 1),(7, 'ROLE_USER_LIMITED', 'ROLE_DESCRIPTION_USER_LIMITED', 'u_', 2),(8, 'ROLE_USER_NOPM', 'ROLE_DESCRIPTION_USER_NOPM', 'u_', 4),(9, 'ROLE_USER_NOAVATAR', 'ROLE_DESCRIPTION_USER_NOAVATAR', 'u_', 5),(10, 'ROLE_MOD_FULL', 'ROLE_DESCRIPTION_MOD_FULL', 'm_', 3),(11, 'ROLE_MOD_STANDARD', 'ROLE_DESCRIPTION_MOD_STANDARD', 'm_', 1),(12, 'ROLE_MOD_SIMPLE', 'ROLE_DESCRIPTION_MOD_SIMPLE', 'm_', 2),(13, 'ROLE_MOD_QUEUE', 'ROLE_DESCRIPTION_MOD_QUEUE', 'm_', 4),(14, 'ROLE_FORUM_FULL', 'ROLE_DESCRIPTION_FORUM_FULL', 'f_', 7),(15, 'ROLE_FORUM_STANDARD', 'ROLE_DESCRIPTION_FORUM_STANDARD', 'f_', 5),(16, 'ROLE_FORUM_NOACCESS', 'ROLE_DESCRIPTION_FORUM_NOACCESS', 'f_', 1),(17, 'ROLE_FORUM_READONLY', 'ROLE_DESCRIPTION_FORUM_READONLY', 'f_', 2),(18, 'ROLE_FORUM_LIMITED', 'ROLE_DESCRIPTION_FORUM_LIMITED', 'f_', 3),(19, 'ROLE_FORUM_BOT', 'ROLE_DESCRIPTION_FORUM_BOT', 'f_', 9),(20, 'ROLE_FORUM_ONQUEUE', 'ROLE_DESCRIPTION_FORUM_ONQUEUE', 'f_', 8),(21, 'ROLE_FORUM_POLLS', 'ROLE_DESCRIPTION_FORUM_POLLS', 'f_', 6),(22, 'ROLE_FORUM_LIMITED_POLLS', 'ROLE_DESCRIPTION_FORUM_LIMITED_POLLS', 'f_', 4),(23, 'ROLE_USER_NEW_MEMBER', 'ROLE_DESCRIPTION_USER_NEW_MEMBER', 'u_', 6),(24, 'ROLE_FORUM_NEW_MEMBER', 'ROLE_DESCRIPTION_FORUM_NEW_MEMBER', 'f_', 10);

# Table: avphpbb_acl_roles_data
DROP TABLE IF EXISTS avphpbb_acl_roles_data;
CREATE TABLE `avphpbb_acl_roles_data` (
  `role_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `auth_option_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `auth_setting` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`role_id`,`auth_option_id`),
  KEY `ath_op_id` (`auth_option_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_acl_roles_data (role_id, auth_option_id, auth_setting) VALUES (1, 44, 1),(1, 46, 1),(1, 47, 1),(1, 48, 1),(1, 50, 1),(1, 51, 1),(1, 52, 1),(1, 56, 1),(1, 57, 1),(1, 58, 1),(1, 59, 1),(1, 60, 1),(1, 61, 1),(1, 62, 1),(1, 63, 1),(1, 66, 1),(1, 68, 1),(1, 70, 1),(1, 71, 1),(1, 72, 1),(1, 73, 1),(1, 79, 1),(1, 80, 1),(1, 81, 1),(1, 82, 1),(1, 83, 1),(1, 84, 1),(2, 44, 1),(2, 47, 1),(2, 48, 1),(2, 56, 1),(2, 57, 1),(2, 58, 1),(2, 59, 1),(2, 66, 1),(2, 71, 1),(2, 79, 1),(2, 82, 1),(2, 83, 1),(3, 44, 1),(3, 47, 1),(3, 48, 1),(3, 50, 1),(3, 60, 1),(3, 61, 1),(3, 62, 1),(3, 72, 1),(3, 79, 1),(3, 80, 1),(3, 82, 1),(3, 83, 1),(4, 44, 1),(4, 45, 1),(4, 46, 1),(4, 47, 1),(4, 48, 1),(4, 49, 1),(4, 50, 1),(4, 51, 1),(4, 52, 1),(4, 53, 1),(4, 54, 1),(4, 55, 1),(4, 56, 1),(4, 57, 1),(4, 58, 1),(4, 59, 1),(4, 60, 1),(4, 61, 1),(4, 62, 1),(4, 63, 1),(4, 64, 1),(4, 65, 1),(4, 66, 1),(4, 67, 1),(4, 68, 1),(4, 69, 1),(4, 70, 1),(4, 71, 1),(4, 72, 1),(4, 73, 1),(4, 74, 1),(4, 75, 1),(4, 76, 1),(4, 77, 1),(4, 78, 1),(4, 79, 1),(4, 80, 1),(4, 81, 1),(4, 82, 1),(4, 83, 1),(4, 84, 1),(5, 85, 1),(5, 86, 1),(5, 87, 1),(5, 88, 1),(5, 89, 1),(5, 90, 1),(5, 91, 1),(5, 92, 1),(5, 93, 1),(5, 94, 1),(5, 95, 1),(5, 96, 1),(5, 97, 1),(5, 98, 1),(5, 99, 1),(5, 100, 1),(5, 101, 1),(5, 102, 1),(5, 103, 1),(5, 104, 1),(5, 105, 1),(5, 106, 1),(5, 107, 1),(5, 108, 1),(5, 109, 1),(5, 110, 1),(5, 111, 1),(5, 112, 1),(5, 113, 1),(5, 114, 1),(5, 115, 1),(5, 116, 1),(6, 85, 1),(6, 86, 1),(6, 87, 1),(6, 88, 1),(6, 89, 1),(6, 92, 1),(6, 93, 1),(6, 94, 1),(6, 96, 1),(6, 97, 1),(6, 98, 1),(6, 99, 1),(6, 100, 1),(6, 101, 1),(6, 102, 1),(6, 105, 1),(6, 106, 1),(6, 107, 1),(6, 108, 1),(6, 109, 1),(6, 110, 1),(6, 111, 1),(6, 112, 1),(6, 113, 1),(6, 114, 1),(6, 116, 1),(7, 85, 1),(7, 87, 1),(7, 88, 1),(7, 89, 1),(7, 92, 1),(7, 93, 1),(7, 94, 1),(7, 96, 1),(7, 98, 1),(7, 99, 1),(7, 100, 1),(7, 101, 1),(7, 104, 1),(7, 105, 1),(7, 106, 1),(7, 107, 1),(7, 108, 1),(7, 113, 1),(7, 114, 1),(7, 116, 1),(8, 85, 1),(8, 87, 1),(8, 88, 1),(8, 89, 1),(8, 92, 1),(8, 93, 1),(8, 94, 1),(8, 114, 1),(8, 116, 1),(8, 96, 0),(8, 108, 0),(8, 113, 0),(9, 85, 1),(9, 88, 1),(9, 89, 1),(9, 92, 1),(9, 93, 1),(9, 94, 1),(9, 96, 1),(9, 98, 1),(9, 99, 1),(9, 100, 1),(9, 101, 1),(9, 104, 1),(9, 105, 1),(9, 106, 1),(9, 107, 1),(9, 108, 1),(9, 113, 1),(9, 114, 1),(9, 116, 1),(9, 87, 0),(10, 31, 1),(10, 32, 1),(10, 42, 1),(10, 33, 1),(10, 34, 1),(10, 35, 1),(10, 36, 1),(10, 37, 1),(10, 38, 1),(10, 39, 1),(10, 40, 1),(10, 41, 1),(10, 43, 1),(11, 31, 1),(11, 32, 1),(11, 34, 1),(11, 35, 1),(11, 36, 1),(11, 37, 1),(11, 38, 1),(11, 39, 1),(11, 40, 1),(11, 41, 1),(11, 43, 1),(12, 31, 1),(12, 34, 1),(12, 35, 1),(12, 36, 1),(12, 40, 1),(13, 31, 1),(13, 32, 1),(13, 35, 1),(14, 1, 1),(14, 2, 1),(14, 3, 1),(14, 4, 1),(14, 5, 1),(14, 6, 1),(14, 7, 1),(14, 8, 1),(14, 9, 1),(14, 10, 1),(14, 11, 1),(14, 12, 1),(14, 13, 1),(14, 14, 1),(14, 15, 1),(14, 16, 1),(14, 17, 1),(14, 18, 1),(14, 19, 1),(14, 20, 1),(14, 21, 1),(14, 22, 1),(14, 23, 1),(14, 24, 1),(14, 25, 1),(14, 26, 1),(14, 27, 1),(14, 28, 1),(14, 29, 1),(14, 30, 1),(15, 1, 1),(15, 3, 1),(15, 4, 1),(15, 5, 1),(15, 6, 1),(15, 7, 1),(15, 8, 1),(15, 9, 1),(15, 11, 1),(15, 13, 1),(15, 14, 1),(15, 15, 1),(15, 17, 1),(15, 18, 1),(15, 19, 1),(15, 20, 1),(15, 21, 1),(15, 22, 1),(15, 23, 1),(15, 24, 1),(15, 25, 1),(15, 27, 1),(15, 29, 1),(15, 30, 1),(16, 1, 0),(17, 1, 1),(17, 7, 1),(17, 14, 1),(17, 19, 1),(17, 20, 1),(17, 23, 1),(17, 27, 1),(18, 1, 1),(18, 4, 1),(18, 7, 1),(18, 8, 1),(18, 9, 1),(18, 13, 1),(18, 14, 1),(18, 15, 1),(18, 17, 1),(18, 18, 1),(18, 19, 1),(18, 20, 1),(18, 21, 1),(18, 22, 1),(18, 23, 1),(18, 24, 1),(18, 25, 1),(18, 27, 1),(18, 29, 1),(19, 1, 1),(19, 7, 1),(19, 14, 1),(19, 19, 1),(19, 20, 1),(20, 1, 1),(20, 3, 1),(20, 4, 1),(20, 7, 1),(20, 8, 1),(20, 9, 1),(20, 13, 1),(20, 14, 1),(20, 17, 1),(20, 18, 1),(20, 19, 1),(20, 20, 1),(20, 21, 1),(20, 22, 1),(20, 23, 1),(20, 24, 1),(20, 25, 1),(20, 27, 1),(20, 29, 1),(20, 15, 0),(21, 1, 1),(21, 3, 1),(21, 4, 1),(21, 5, 1),(21, 6, 1),(21, 7, 1),(21, 8, 1),(21, 9, 1),(21, 11, 1),(21, 13, 1),(21, 14, 1),(21, 15, 1),(21, 16, 1),(21, 17, 1),(21, 18, 1),(21, 19, 1),(21, 20, 1),(21, 21, 1),(21, 22, 1),(21, 23, 1),(21, 24, 1),(21, 25, 1),(21, 27, 1),(21, 29, 1),(21, 30, 1),(22, 1, 1),(22, 4, 1),(22, 7, 1),(22, 8, 1),(22, 9, 1),(22, 13, 1),(22, 14, 1),(22, 15, 1),(22, 16, 1),(22, 17, 1),(22, 18, 1),(22, 19, 1),(22, 20, 1),(22, 21, 1),(22, 22, 1),(22, 23, 1),(22, 24, 1),(22, 25, 1),(22, 27, 1),(22, 29, 1),(5, 117, 1),(6, 117, 1),(7, 117, 1),(8, 117, 0),(9, 117, 1),(23, 96, 0),(23, 117, 0),(23, 113, 0),(24, 15, 0),(4, 118, 1),(5, 119, 1),(6, 119, 1),(7, 119, 1),(8, 119, 1),(9, 119, 1),(10, 122, 1),(11, 122, 1),(12, 122, 1);

# Table: avphpbb_acl_users
DROP TABLE IF EXISTS avphpbb_acl_users;
CREATE TABLE `avphpbb_acl_users` (
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `auth_option_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `auth_role_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `auth_setting` tinyint(2) NOT NULL DEFAULT '0',
  KEY `user_id` (`user_id`),
  KEY `auth_option_id` (`auth_option_id`),
  KEY `auth_role_id` (`auth_role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_acl_users (user_id, forum_id, auth_option_id, auth_role_id, auth_setting) VALUES (2, 0, 0, 5, 0),(54, 11, 0, 10, 0),(54, 4, 0, 10, 0),(54, 5, 0, 10, 0),(54, 6, 0, 10, 0),(2, 11, 0, 10, 0),(2, 4, 0, 10, 0),(2, 5, 0, 10, 0),(2, 6, 0, 10, 0),(54, 0, 0, 10, 0),(2, 0, 0, 10, 0),(58, 6, 0, 10, 0),(58, 5, 0, 10, 0),(58, 4, 0, 10, 0),(58, 11, 0, 10, 0);

# Table: avphpbb_attachments
DROP TABLE IF EXISTS avphpbb_attachments;
CREATE TABLE `avphpbb_attachments` (
  `attach_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `post_msg_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `in_message` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `poster_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `is_orphan` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `physical_filename` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `real_filename` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `download_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `attach_comment` text COLLATE utf8_bin NOT NULL,
  `extension` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `mimetype` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `filesize` int(20) unsigned NOT NULL DEFAULT '0',
  `filetime` int(11) unsigned NOT NULL DEFAULT '0',
  `thumbnail` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`attach_id`),
  KEY `filetime` (`filetime`),
  KEY `post_msg_id` (`post_msg_id`),
  KEY `topic_id` (`topic_id`),
  KEY `poster_id` (`poster_id`),
  KEY `is_orphan` (`is_orphan`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

# Table: avphpbb_banlist
DROP TABLE IF EXISTS avphpbb_banlist;
CREATE TABLE `avphpbb_banlist` (
  `ban_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `ban_userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `ban_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ban_email` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ban_start` int(11) unsigned NOT NULL DEFAULT '0',
  `ban_end` int(11) unsigned NOT NULL DEFAULT '0',
  `ban_exclude` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `ban_reason` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ban_give_reason` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`ban_id`),
  KEY `ban_end` (`ban_end`),
  KEY `ban_user` (`ban_userid`,`ban_exclude`),
  KEY `ban_email` (`ban_email`,`ban_exclude`),
  KEY `ban_ip` (`ban_ip`,`ban_exclude`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

# Table: avphpbb_bbcodes
DROP TABLE IF EXISTS avphpbb_bbcodes;
CREATE TABLE `avphpbb_bbcodes` (
  `bbcode_id` smallint(4) unsigned NOT NULL DEFAULT '0',
  `bbcode_tag` varchar(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `bbcode_helpline` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `display_on_posting` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `bbcode_match` text COLLATE utf8_bin NOT NULL,
  `bbcode_tpl` mediumtext COLLATE utf8_bin NOT NULL,
  `first_pass_match` mediumtext COLLATE utf8_bin NOT NULL,
  `first_pass_replace` mediumtext COLLATE utf8_bin NOT NULL,
  `second_pass_match` mediumtext COLLATE utf8_bin NOT NULL,
  `second_pass_replace` mediumtext COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`bbcode_id`),
  KEY `display_on_post` (`display_on_posting`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

# Table: avphpbb_bookmarks
DROP TABLE IF EXISTS avphpbb_bookmarks;
CREATE TABLE `avphpbb_bookmarks` (
  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`topic_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

# Table: avphpbb_bots
DROP TABLE IF EXISTS avphpbb_bots;
CREATE TABLE `avphpbb_bots` (
  `bot_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `bot_active` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `bot_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `bot_agent` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `bot_ip` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`bot_id`),
  KEY `bot_active` (`bot_active`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_bots (bot_id, bot_active, bot_name, user_id, bot_agent, bot_ip) VALUES (1, 1, 'AdsBot [Google]', 3, 'AdsBot-Google', ''),(2, 1, 'Alexa [Bot]', 4, 'ia_archiver', ''),(3, 1, 'Alta Vista [Bot]', 5, 'Scooter/', ''),(4, 1, 'Ask Jeeves [Bot]', 6, 'Ask Jeeves', ''),(5, 1, 'Baidu [Spider]', 7, 'Baiduspider', ''),(6, 1, 'Exabot [Bot]', 8, 'Exabot', ''),(7, 1, 'FAST Enterprise [Crawler]', 9, 'FAST Enterprise Crawler', ''),(8, 1, 'FAST WebCrawler [Crawler]', 10, 'FAST-WebCrawler/', ''),(9, 1, 'Francis [Bot]', 11, 'http://www.neomo.de/', ''),(10, 1, 'Gigabot [Bot]', 12, 'Gigabot/', ''),(11, 1, 'Google Adsense [Bot]', 13, 'Mediapartners-Google', ''),(12, 1, 'Google Desktop', 14, 'Google Desktop', ''),(13, 1, 'Google Feedfetcher', 15, 'Feedfetcher-Google', ''),(14, 1, 'Google [Bot]', 16, 'Googlebot', ''),(15, 1, 'Heise IT-Markt [Crawler]', 17, 'heise-IT-Markt-Crawler', ''),(16, 1, 'Heritrix [Crawler]', 18, 'heritrix/1.', ''),(17, 1, 'IBM Research [Bot]', 19, 'ibm.com/cs/crawler', ''),(18, 1, 'ICCrawler - ICjobs', 20, 'ICCrawler - ICjobs', ''),(19, 1, 'ichiro [Crawler]', 21, 'ichiro/', ''),(20, 1, 'Majestic-12 [Bot]', 22, 'MJ12bot/', ''),(21, 1, 'Metager [Bot]', 23, 'MetagerBot/', ''),(22, 1, 'MSN NewsBlogs', 24, 'msnbot-NewsBlogs/', ''),(23, 1, 'MSN [Bot]', 25, 'msnbot/', ''),(24, 1, 'MSNbot Media', 26, 'msnbot-media/', ''),(26, 1, 'Nutch [Bot]', 28, 'http://lucene.apache.org/nutch/', ''),(29, 1, 'Online link [Validator]', 31, 'online link validator', ''),(30, 1, 'psbot [Picsearch]', 32, 'psbot/0', ''),(32, 1, 'Sensis [Crawler]', 34, 'Sensis Web Crawler', ''),(33, 1, 'SEO Crawler', 35, 'SEO search Crawler/', ''),(34, 1, 'Seoma [Crawler]', 36, 'Seoma [SEO Crawler]', ''),(35, 1, 'SEOSearch [Crawler]', 37, 'SEOsearch/', ''),(36, 1, 'Snappy [Bot]', 38, 'Snappy/1.1 ( http://www.urltrends.com/ )', ''),(37, 1, 'Steeler [Crawler]', 39, 'http://www.tkl.iis.u-tokyo.ac.jp/~crawler/', ''),(39, 1, 'Telekom [Bot]', 41, '[email protected]', ''),(40, 1, 'TurnitinBot [Bot]', 42, 'TurnitinBot/', ''),(41, 1, 'Voyager [Bot]', 43, 'voyager/', ''),(42, 1, 'W3 [Sitesearch]', 44, 'W3 SiteSearch Crawler', ''),(43, 1, 'W3C [Linkcheck]', 45, 'W3C-checklink/', ''),(44, 1, 'W3C [Validator]', 46, 'W3C_Validator', ''),(46, 1, 'YaCy [Bot]', 48, 'yacybot', ''),(47, 1, 'Yahoo MMCrawler [Bot]', 49, 'Yahoo-MMCrawler/', ''),(48, 1, 'Yahoo Slurp [Bot]', 50, 'Yahoo! DE Slurp', ''),(49, 1, 'Yahoo [Bot]', 51, 'Yahoo! Slurp', ''),(50, 1, 'YahooSeeker [Bot]', 52, 'YahooSeeker/', ''),(51, 1, 'Bing [Bot]', 53, 'bingbot/', '');

# Table: avphpbb_captcha_answers
DROP TABLE IF EXISTS avphpbb_captcha_answers;
CREATE TABLE `avphpbb_captcha_answers` (
  `question_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `answer_text` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  KEY `question_id` (`question_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

# Table: avphpbb_captcha_questions
DROP TABLE IF EXISTS avphpbb_captcha_questions;
CREATE TABLE `avphpbb_captcha_questions` (
  `question_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `strict` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `lang_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `lang_iso` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
  `question_text` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`question_id`),
  KEY `lang_iso` (`lang_iso`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

# Table: avphpbb_config
DROP TABLE IF EXISTS avphpbb_config;
CREATE TABLE `avphpbb_config` (
  `config_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `config_value` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `is_dynamic` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`config_name`),
  KEY `is_dynamic` (`is_dynamic`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_config (config_name, config_value, is_dynamic) VALUES ('active_sessions', '0', 0),('allow_attachments', '1', 0),('allow_autologin', '1', 0),('allow_avatar_local', '0', 0),('allow_avatar_remote', '0', 0),('allow_avatar_upload', '0', 0),('allow_bbcode', '1', 0),('allow_birthdays', '1', 0),('allow_bookmarks', '1', 0),('allow_emailreuse', '0', 0),('allow_forum_notify', '1', 0),('allow_mass_pm', '1', 0),('allow_name_chars', 'USERNAME_CHARS_ANY', 0),('allow_namechange', '1', 0),('allow_nocensors', '0', 0),('allow_pm_attach', '0', 0),('allow_post_flash', '1', 0),('allow_post_links', '1', 0),('allow_privmsg', '1', 0),('allow_sig', '1', 0),('allow_sig_bbcode', '1', 0),('allow_sig_flash', '0', 0),('allow_sig_img', '1', 0),('allow_sig_links', '1', 0),('allow_sig_pm', '1', 0),('allow_sig_smilies', '1', 0),('allow_smilies', '1', 0),('allow_topic_notify', '1', 0),('attachment_quota', '52428800', 0),('auth_bbcode_pm', '1', 0),('auth_flash_pm', '0', 0),('auth_img_pm', '1', 0),('auth_method', 'db', 0),('auth_smilies_pm', '1', 0),('avatar_filesize', '6144', 0),('avatar_gallery_path', 'images/avatars/gallery', 0),('avatar_max_height', '90', 0),('avatar_max_width', '90', 0),('avatar_min_height', '20', 0),('avatar_min_width', '20', 0),('avatar_path', 'images/avatars/upload', 0),('avatar_salt', 'caa6f5290b3b19b59dd476326a2d7d14', 0),('board_contact', '[email protected]', 0),('board_disable', '0', 0),('board_disable_msg', '', 0),('board_dst', '0', 0),('board_email', '[email protected]', 0),('board_email_form', '0', 0),('board_email_sig', 'Grazie, L\'amministrazione', 0),('board_hide_emails', '1', 0),('board_timezone', 'Etc/GMT-1', 0),('browser_check', '1', 0),('bump_interval', '10', 0),('bump_type', 'd', 0),('cache_gc', '7200', 0),('captcha_gd', '1', 0),('captcha_gd_foreground_noise', '0', 0),('captcha_gd_x_grid', '25', 0),('captcha_gd_y_grid', '25', 0),('check_dnsbl', '0', 0),('chg_passforce', '0', 0),('cookie_domain', 'mayourja.altervista.org', 0),('cookie_name', 'phpbb_8cb72', 0),('cookie_path', '/', 0),('cookie_secure', '0', 0),('coppa_enable', '0', 0),('coppa_fax', '', 0),('coppa_mail', '', 0),('database_gc', '604800', 0),('default_dateformat', '|d/m/Y|, G:i', 0),('default_style', '2', 0),('display_last_edited', '1', 0),('display_order', '0', 0),('edit_time', '0', 0),('email_check_mx', '1', 0),('email_enable', '1', 0),('email_function_name', 'mail', 0),('email_package_size', '20', 0),('enable_confirm', '0', 0),('enable_pm_icons', '1', 0),('enable_post_confirm', '0', 0),('flood_interval', '15', 0),('force_server_vars', '0', 0),('form_token_lifetime', '7200', 0),('form_token_mintime', '0', 0),('form_token_sid_guests', '1', 0),('forward_pm', '1', 0),('forwarded_for_check', '0', 0),('full_folder_action', '2', 0),('fulltext_mysql_max_word_len', '254', 0),('fulltext_mysql_min_word_len', '4', 0),('fulltext_native_common_thres', '5', 0),('fulltext_native_load_upd', '1', 0),('fulltext_native_max_chars', '14', 0),('fulltext_native_min_chars', '3', 0),('gzip_compress', '0', 0),('hot_threshold', '25', 0),('icons_path', 'images/icons', 0),('img_create_thumbnail', '0', 0),('img_display_inlined', '1', 0),('img_imagick', '', 0),('img_link_height', '0', 0),('img_link_width', '0', 0),('img_max_height', '0', 0),('img_max_thumb_width', '400', 0),('img_max_width', '0', 0),('img_min_thumb_filesize', '12000', 0),('ip_check', '0', 0),('jab_enable', '0', 0),('jab_host', '', 0),('jab_password', '', 0),('jab_package_size', '20', 0),('jab_port', '5222', 0),('jab_use_ssl', '0', 0),('jab_username', '', 0),('ldap_base_dn', '', 0),('ldap_email', '', 0),('ldap_password', '', 0),('ldap_port', '', 0),('ldap_server', '', 0),('ldap_uid', '', 0),('ldap_user', '', 0),('ldap_user_filter', '', 0),('limit_load', '0', 0),('limit_search_load', '0', 0),('load_anon_lastread', '0', 0),('load_birthdays', '1', 0),('load_cpf_memberlist', '1', 0),('load_cpf_viewprofile', '1', 0),('load_cpf_viewtopic', '1', 0),('load_db_lastread', '1', 0),('load_db_track', '1', 0),('load_jumpbox', '1', 0),('load_moderators', '1', 0),('load_online', '1', 0),('load_online_guests', '1', 0),('load_online_time', '5', 0),('load_onlinetrack', '1', 0),('load_search', '1', 0),('load_tplcompile', '0', 0),('load_user_activity', '1', 0),('max_attachments', '3', 0),('max_attachments_pm', '1', 0),('max_autologin_time', '0', 0),('max_filesize', '262144', 0),('max_filesize_pm', '262144', 0),('max_login_attempts', '5', 0),('max_name_chars', '20', 0),('max_pass_chars', '30', 0),('max_poll_options', '20', 0),('max_post_chars', '60000', 0),('max_post_font_size', '200', 0),('max_post_img_height', '0', 0),('max_post_img_width', '0', 0),('max_post_smilies', '0', 0),('max_post_urls', '0', 0),('max_quote_depth', '3', 0),('max_reg_attempts', '5', 0),('max_sig_chars', '255', 0),('max_sig_font_size', '200', 0),('max_sig_img_height', '0', 0),('max_sig_img_width', '0', 0),('max_sig_smilies', '0', 0),('max_sig_urls', '5', 0),('min_name_chars', '3', 0),('min_pass_chars', '6', 0),('min_search_author_chars', '3', 0),('min_time_reg', '0', 0),('min_time_terms', '0', 0),('override_user_style', '0', 0),('pass_complex', 'PASS_TYPE_ANY', 0),('pm_edit_time', '0', 0),('pm_max_boxes', '4', 0),('pm_max_msgs', '50', 0),('posts_per_page', '10', 0),('print_pm', '1', 0),('queue_interval', '60', 0),('ranks_path', 'images/ranks', 0),('require_activation', '0', 0),('script_path', '/phpbb', 0),('search_block_size', '250', 0),('search_gc', '7200', 0),('search_indexing_state', '', 1),('search_interval', '0', 0),('search_anonymous_interval', '0', 0),('search_type', '\\phpbb\\search\\fulltext_native', 0),('search_store_results', '1800', 0),('secure_allow_deny', '1', 0),('secure_allow_empty_referer', '1', 0),('secure_downloads', '0', 0),('server_name', 'mayourja.altervista.org', 0),('server_port', '80', 0),('server_protocol', 'http://', 0),('session_gc', '3600', 0),('session_length', '3600', 0),('site_desc', 'Il forum di Alternanza Scuola-Lavoro', 0),('sitename', 'Schoolwork', 0),('smilies_path', 'images/smilies', 0),('smtp_auth_method', 'PLAIN', 0),('smtp_delivery', '0', 0),('smtp_host', '', 0),('smtp_password', '', 0),('smtp_port', '25', 0),('smtp_username', '', 0),('topics_per_page', '25', 0),('tpl_allow_php', '0', 0),('upload_icons_path', 'images/upload_icons', 0),('upload_path', 'files', 0),('version', '3.1.8', 0),('warnings_expire_days', '90', 0),('warnings_gc', '14400', 0),('cache_last_gc', '1526050688', 1),('cron_lock', '0', 1),('database_last_gc', '1525958804', 1),('last_queue_run', '0', 1),('newest_user_colour', '000000', 1),('newest_user_id', '59', 1),('newest_username', 'federica', 1),('num_files', '0', 1),('num_posts', '3', 1),('num_topics', '3', 1),('num_users', '6', 1),('rand_seed', 'a42e876a763f30c051fbd97877aa6861', 1),('rand_seed_last_update', '1526130203', 1),('record_online_date', '1523291835', 1),('record_online_users', '4', 1),('search_last_gc', '1526127715', 1),('session_last_gc', '1526130191', 1),('upload_dir_size', '0', 1),('warnings_last_gc', '1526050742', 1),('board_startdate', '1521366832', 0),('default_lang', 'it', 0),('referer_validation', '1', 0),('check_attachment_content', '1', 0),('mime_triggers', 'body|head|html|img|plaintext|a href|pre|script|table|title', 0),('enable_queue_trigger', '0', 0),('queue_trigger_posts', '3', 0),('pm_max_recipients', '0', 0),('dbms_version', '5.1.71-community-log', 0),('captcha_gd_wave', '0', 0),('captcha_gd_3d_noise', '1', 0),('captcha_gd_fonts', '1', 0),('confirm_refresh', '1', 0),('max_num_search_keywords', '10', 0),('captcha_plugin', 'core.captcha.plugins.gd', 0),('feed_enable', '0', 0),('feed_limit', '10', 0),('feed_overall_forums', '1', 0),('feed_overall_forums_limit', '15', 0),('feed_overall_topics', '0', 0),('feed_overall_topics_limit', '15', 0),('feed_forum', '1', 0),('feed_topic', '1', 0),('feed_item_statistics', '1', 0),('smilies_per_page', '50', 0),('allow_pm_report', '1', 0),('new_member_post_limit', '0', 0),('new_member_group_default', '0', 0),('allow_avatar', '0', 0),('allow_avatar_remote_upload', '0', 0),('min_post_chars', '1', 0),('allow_quick_reply', '1', 0),('delete_time', '0', 0),('feed_overall', '1', 0),('feed_http_auth', '0', 0),('feed_limit_post', '10', 0),('feed_limit_topic', '15', 0),('feed_topics_new', '0', 0),('feed_topics_active', '0', 0),('load_unreads_search', '1', 0),('ip_login_limit_max', '50', 0),('ip_login_limit_time', '21600', 0),('ip_login_limit_use_forwarded', '0', 0),('email_max_chunk_size', '50', 0),('fulltext_postgres_ts_name', 'simple', 0),('fulltext_postgres_min_word_len', '4', 0),('fulltext_postgres_max_word_len', '254', 0),('fulltext_sphinx_stopwords', '0', 0),('fulltext_sphinx_indexer_mem_limit', '512', 0),('allow_avatar_gravatar', '0', 0),('load_jquery_url', '//ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js', 0),('use_system_cron', '0', 0),('legend_sort_groupname', '0', 0),('teampage_forums', '1', 0),('teampage_memberships', '1', 0),('load_cpf_pm', '1', 0),('display_last_subject', '1', 0),('assets_version', '5', 0),('site_home_url', '', 0),('site_home_text', '', 0),('allow_cdn', '0', 0),('board_index_text', '', 0),('allow_password_reset', '1', 0),('enable_mod_rewrite', '0', 0),('load_notifications', '1', 0),('read_notification_expire_days', '30', 0),('read_notification_last_gc', '1526031419', 1),('read_notification_gc', '86400', 0),('plupload_last_gc', '0', 1),('plupload_salt', '4e51a3511b666167', 0),('board_contact_name', '', 0),('allow_live_searches', '1', 0),('extension_force_unstable', '1', 0),('contact_admin_form_enable', '1', 0),('auth_oauth_facebook_key', '', 0),('auth_oauth_bitly_key', '', 0),('auth_oauth_bitly_secret', '', 0),('auth_oauth_facebook_secret', '', 0),('auth_oauth_google_key', '', 0),('auth_oauth_google_secret', '', 0),('topic_preview_limit', '150', 0),('topic_preview_strip_bbcodes', '', 0),('topic_preview_last_post', '0', 0),('topic_preview_avatars', '1', 0),('topic_preview_delay', '1', 0),('topic_preview_drift', '15', 0),('topic_preview_width', '500', 0);

# Table: avphpbb_config_text
DROP TABLE IF EXISTS avphpbb_config_text;
CREATE TABLE `avphpbb_config_text` (
  `config_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `config_value` mediumtext COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`config_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_config_text (config_name, config_value) VALUES ('contact_admin_info', ''),('contact_admin_info_uid', ''),('contact_admin_info_bitfield', ''),('contact_admin_info_flags', '7'),('marttiphpbb_postingtemplate_forum[6]', '[b]Scuola:[/b]\n\n[b]Classe:[/b]\n\n[b]Luogo:[/b]\n\n[b]Orario:[/b]\n\n[b]Materie:[/b]\n\n[b]Contatti:[/b]\n\n[b]Altro [opzionale]:[/b]'),('marttiphpbb_postingtemplate_forum[5]', '[b]Luogo:[/b]\n\n[b]Periodo:[/b]\n\n[b]Settore:[/b]\n\n[b]N° di persone richieste:[/b]\n\n[b]Attività da svolgere:[/b]\n\n[b]Contatti:[/b]\n\n[b]Altro [opzionale]:[/b]');

# Table: avphpbb_confirm
DROP TABLE IF EXISTS avphpbb_confirm;
CREATE TABLE `avphpbb_confirm` (
  `confirm_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `session_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `confirm_type` tinyint(3) NOT NULL DEFAULT '0',
  `code` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
  `seed` int(10) unsigned NOT NULL DEFAULT '0',
  `attempts` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`session_id`,`confirm_id`),
  KEY `confirm_type` (`confirm_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

# Table: avphpbb_disallow
DROP TABLE IF EXISTS avphpbb_disallow;
CREATE TABLE `avphpbb_disallow` (
  `disallow_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `disallow_username` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`disallow_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

# Table: avphpbb_drafts
DROP TABLE IF EXISTS avphpbb_drafts;
CREATE TABLE `avphpbb_drafts` (
  `draft_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `save_time` int(11) unsigned NOT NULL DEFAULT '0',
  `draft_subject` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `draft_message` mediumtext COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`draft_id`),
  KEY `save_time` (`save_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

# Table: avphpbb_ext
DROP TABLE IF EXISTS avphpbb_ext;
CREATE TABLE `avphpbb_ext` (
  `ext_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ext_active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `ext_state` text COLLATE utf8_bin NOT NULL,
  UNIQUE KEY `ext_name` (`ext_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_ext (ext_name, ext_active, ext_state) VALUES ('altervista/stats', 1, 'b:0;'),('marttiphpbb/postingtemplate', 1, 'b:0;'),('vse/topicpreview', 1, 'b:0;');

# Table: avphpbb_extension_groups
DROP TABLE IF EXISTS avphpbb_extension_groups;
CREATE TABLE `avphpbb_extension_groups` (
  `group_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `group_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `cat_id` tinyint(2) NOT NULL DEFAULT '0',
  `allow_group` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `download_mode` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `upload_icon` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `max_filesize` int(20) unsigned NOT NULL DEFAULT '0',
  `allowed_forums` text COLLATE utf8_bin NOT NULL,
  `allow_in_pm` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums, allow_in_pm) VALUES (1, 'IMAGES', 1, 1, 1, '', 0, '', 0),(2, 'ARCHIVES', 0, 1, 1, '', 0, '', 0),(3, 'PLAIN_TEXT', 0, 0, 1, '', 0, '', 0),(4, 'DOCUMENTS', 0, 0, 1, '', 0, '', 0),(5, 'REAL_MEDIA', 3, 0, 1, '', 0, '', 0),(6, 'WINDOWS_MEDIA', 2, 0, 1, '', 0, '', 0),(7, 'File flash', 5, 0, 1, '', 0, '', 0),(8, 'QUICKTIME_MEDIA', 6, 0, 1, '', 0, '', 0),(9, 'DOWNLOADABLE_FILES', 0, 0, 1, '', 0, '', 0);

# Table: avphpbb_extensions
DROP TABLE IF EXISTS avphpbb_extensions;
CREATE TABLE `avphpbb_extensions` (
  `extension_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `extension` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`extension_id`)
) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_extensions (extension_id, group_id, extension) VALUES (1, 1, 'gif'),(2, 1, 'png'),(3, 1, 'jpeg'),(4, 1, 'jpg'),(5, 1, 'tif'),(6, 1, 'tiff'),(7, 1, 'tga'),(8, 2, 'gtar'),(9, 2, 'gz'),(10, 2, 'tar'),(11, 2, 'zip'),(12, 2, 'rar'),(13, 2, 'ace'),(14, 2, 'torrent'),(15, 2, 'tgz'),(16, 2, 'bz2'),(17, 2, '7z'),(18, 3, 'txt'),(19, 3, 'c'),(20, 3, 'h'),(21, 3, 'cpp'),(22, 3, 'hpp'),(23, 3, 'diz'),(24, 3, 'csv'),(25, 3, 'ini'),(26, 3, 'log'),(27, 3, 'js'),(28, 3, 'xml'),(29, 4, 'xls'),(30, 4, 'xlsx'),(31, 4, 'xlsm'),(32, 4, 'xlsb'),(33, 4, 'doc'),(34, 4, 'docx'),(35, 4, 'docm'),(36, 4, 'dot'),(37, 4, 'dotx'),(38, 4, 'dotm'),(39, 4, 'pdf'),(40, 4, 'ai'),(41, 4, 'ps'),(42, 4, 'ppt'),(43, 4, 'pptx'),(44, 4, 'pptm'),(45, 4, 'odg'),(46, 4, 'odp'),(47, 4, 'ods'),(48, 4, 'odt'),(49, 4, 'rtf'),(50, 5, 'rm'),(51, 5, 'ram'),(52, 6, 'wma'),(53, 6, 'wmv'),(54, 7, 'swf'),(55, 8, 'mov'),(56, 8, 'm4v'),(57, 8, 'm4a'),(58, 8, 'mp4'),(59, 8, '3gp'),(60, 8, '3g2'),(61, 8, 'qt'),(62, 9, 'mpeg'),(63, 9, 'mpg'),(64, 9, 'mp3'),(65, 9, 'ogg'),(66, 9, 'ogm');

# Table: avphpbb_forums
DROP TABLE IF EXISTS avphpbb_forums;
CREATE TABLE `avphpbb_forums` (
  `forum_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `left_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `right_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `forum_parents` mediumtext COLLATE utf8_bin NOT NULL,
  `forum_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `forum_desc` text COLLATE utf8_bin NOT NULL,
  `forum_desc_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `forum_desc_options` int(11) unsigned NOT NULL DEFAULT '7',
  `forum_desc_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
  `forum_link` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `forum_password` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `forum_style` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `forum_image` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `forum_rules` text COLLATE utf8_bin NOT NULL,
  `forum_rules_link` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `forum_rules_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `forum_rules_options` int(11) unsigned NOT NULL DEFAULT '7',
  `forum_rules_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
  `forum_topics_per_page` tinyint(4) NOT NULL DEFAULT '0',
  `forum_type` tinyint(4) NOT NULL DEFAULT '0',
  `forum_status` tinyint(4) NOT NULL DEFAULT '0',
  `forum_last_post_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `forum_last_poster_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `forum_last_post_subject` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `forum_last_post_time` int(11) unsigned NOT NULL DEFAULT '0',
  `forum_last_poster_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `forum_last_poster_colour` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
  `forum_flags` tinyint(4) NOT NULL DEFAULT '32',
  `display_on_index` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `enable_indexing` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `enable_icons` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `enable_prune` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `prune_next` int(11) unsigned NOT NULL DEFAULT '0',
  `prune_days` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `prune_viewed` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `prune_freq` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `display_subforum_list` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `forum_options` int(20) unsigned NOT NULL DEFAULT '0',
  `forum_posts_approved` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `forum_posts_unapproved` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `forum_posts_softdeleted` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `forum_topics_approved` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `forum_topics_unapproved` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `forum_topics_softdeleted` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `enable_shadow_prune` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `prune_shadow_days` mediumint(8) unsigned NOT NULL DEFAULT '7',
  `prune_shadow_freq` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `prune_shadow_next` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`forum_id`),
  KEY `left_right_id` (`left_id`,`right_id`),
  KEY `forum_lastpost_id` (`forum_last_post_id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_forums (forum_id, parent_id, left_id, right_id, forum_parents, forum_name, forum_desc, forum_desc_bitfield, forum_desc_options, forum_desc_uid, forum_link, forum_password, forum_style, forum_image, forum_rules, forum_rules_link, forum_rules_bitfield, forum_rules_options, forum_rules_uid, forum_topics_per_page, forum_type, forum_status, forum_last_post_id, forum_last_poster_id, forum_last_post_subject, forum_last_post_time, forum_last_poster_name, forum_last_poster_colour, forum_flags, display_on_index, enable_indexing, enable_icons, enable_prune, prune_next, prune_days, prune_viewed, prune_freq, display_subforum_list, forum_options, forum_posts_approved, forum_posts_unapproved, forum_posts_softdeleted, forum_topics_approved, forum_topics_unapproved, forum_topics_softdeleted, enable_shadow_prune, prune_shadow_days, prune_shadow_freq, prune_shadow_next) VALUES (4, 0, 3, 8, '', ' ', '', '', 7, '', '', '', 0, '', 'Prima di utilizzare questa piattaforma leggi attentamente il [url=http://mayourja.altervista.org/wordpress/regolamento/:lsoipoa6]regolamento del forum[/url:lsoipoa6].', '', 'EA==', 7, 'lsoipoa6', 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 7, 1, 0),(5, 4, 4, 5, 'a:1:{i:4;a:2:{i:0;s:2:\" \";i:1;i:0;}}', 'Alternanza scuola-lavoro', '', '', 7, '', '', '', 0, '', 'Prima di utilizzare questa piattaforma leggi attentamente il [url=http://mayourja.altervista.org/wordpress/regolamento/:3la14hie]regolamento del forum[/url:3la14hie].', '', 'EA==', 7, '3la14hie', 0, 1, 0, 10, 2, 'studio Rossi - commercialista', 1525962682, 'Mayour JA', 'AA0000', 48, 0, 1, 0, 0, 0, 7, 7, 1, 1, 0, 3, 0, 0, 3, 0, 0, 0, 7, 1, 0),(6, 4, 6, 7, 'a:1:{i:4;a:2:{i:0;s:2:\" \";i:1;i:0;}}', 'Tutoraggio & Ripetizioni', '', '', 7, '', '', '', 0, '', 'Prima di utilizzare questa piattaforma leggi attentamente il [url=http://mayourja.altervista.org/wordpress/regolamento/:2g7r87rd]regolamento del forum[/url:2g7r87rd].', '', 'EA==', 7, '2g7r87rd', 0, 1, 0, 9, 2, 'ho bisogno di aiuto con fisica', 1525962198, 'Mayour JA', 'AA0000', 48, 0, 1, 0, 0, 0, 7, 7, 1, 1, 0, 4, 0, 0, 4, 0, 0, 0, 7, 1, 0),(12, 0, 9, 14, '', 'Prima di utilizzare il sito blablabla devi effettuare il login oppure registrarti!', '', '', 7, '', 'http://mayourja.altervista.org/forum/ucp.php?mode=register', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 7, 1, 0),(11, 0, 1, 2, '', 'Questions & Answers', '', '', 7, '', '', '', 0, '', 'Prima di utilizzare questa piattaforma leggi attentamente il [url=http://mayourja.altervista.org/wordpress/regolamento/:1caqrq1j]regolamento del forum[/url:1caqrq1j].', '', 'EA==', 7, '1caqrq1j', 0, 1, 0, 0, 0, '', 0, '', '', 48, 0, 1, 0, 0, 0, 7, 7, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 7, 1, 0),(13, 12, 10, 11, '', 'Login', '', '', 7, '', 'http://mayourja.altervista.org/forum/ucp.php?mode=login', '', 0, '', '', '', '', 7, '', 0, 2, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 7, 1, 0),(14, 12, 12, 13, '', 'Registrati', '', '', 7, '', 'http://mayourja.altervista.org/forum/ucp.php?mode=register', '', 0, '', '', '', '', 7, '', 0, 2, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 7, 1, 0);

# Table: avphpbb_forums_access
DROP TABLE IF EXISTS avphpbb_forums_access;
CREATE TABLE `avphpbb_forums_access` (
  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `session_id` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`forum_id`,`user_id`,`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

# Table: avphpbb_forums_track
DROP TABLE IF EXISTS avphpbb_forums_track;
CREATE TABLE `avphpbb_forums_track` (
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `mark_time` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_forums_track (user_id, forum_id, mark_time) VALUES (55, 5, 1523292267),(54, 5, 1526050846),(2, 6, 1525962213),(2, 5, 1525962878);

# Table: avphpbb_forums_watch
DROP TABLE IF EXISTS avphpbb_forums_watch;
CREATE TABLE `avphpbb_forums_watch` (
  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `notify_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  KEY `forum_id` (`forum_id`),
  KEY `user_id` (`user_id`),
  KEY `notify_stat` (`notify_status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

# Table: avphpbb_groups
DROP TABLE IF EXISTS avphpbb_groups;
CREATE TABLE `avphpbb_groups` (
  `group_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `group_type` tinyint(4) NOT NULL DEFAULT '1',
  `group_founder_manage` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `group_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `group_desc` text COLLATE utf8_bin NOT NULL,
  `group_desc_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `group_desc_options` int(11) unsigned NOT NULL DEFAULT '7',
  `group_desc_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
  `group_display` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `group_avatar` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `group_avatar_type` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `group_avatar_width` smallint(4) unsigned NOT NULL DEFAULT '0',
  `group_avatar_height` smallint(4) unsigned NOT NULL DEFAULT '0',
  `group_rank` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `group_colour` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
  `group_sig_chars` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `group_receive_pm` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `group_message_limit` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `group_legend` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `group_max_recipients` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `group_skip_auth` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`group_id`),
  KEY `group_legend_name` (`group_legend`,`group_name`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_groups (group_id, group_type, group_founder_manage, group_name, group_desc, group_desc_bitfield, group_desc_options, group_desc_uid, group_display, group_avatar, group_avatar_type, group_avatar_width, group_avatar_height, group_rank, group_colour, group_sig_chars, group_receive_pm, group_message_limit, group_legend, group_max_recipients, group_skip_auth) VALUES (1, 3, 0, 'GUESTS', '', '', 7, '', 0, '', '0', 0, 0, 0, '', 0, 0, 0, 0, 5, 0),(2, 3, 0, 'REGISTERED', '', '', 7, '', 0, '', '0', 0, 0, 0, '000000', 0, 0, 0, 0, 5, 0),(3, 3, 0, 'REGISTERED_COPPA', '', '', 7, '', 0, '', '0', 0, 0, 0, '', 0, 0, 0, 0, 5, 0),(4, 3, 0, 'GLOBAL_MODERATORS', '', '', 7, '', 0, '', '0', 0, 0, 0, '00AA00', 0, 0, 0, 2, 0, 0),(5, 3, 1, 'ADMINISTRATORS', '', '', 7, '', 0, '', '0', 0, 0, 0, 'AA0000', 0, 0, 0, 1, 0, 0),(6, 3, 0, 'BOTS', '', '', 7, '', 0, '', '0', 0, 0, 0, '9E8DA7', 0, 0, 0, 0, 5, 0),(7, 3, 0, 'NEWLY_REGISTERED', '', '', 7, '', 0, '', '0', 0, 0, 0, '', 0, 0, 0, 0, 5, 0),(8, 0, 0, 'Aziende', '', '', 7, '', 0, '', '', 0, 0, 0, '0040FF', 0, 0, 0, 3, 0, 0);

# Table: avphpbb_icons
DROP TABLE IF EXISTS avphpbb_icons;
CREATE TABLE `avphpbb_icons` (
  `icons_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `icons_url` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `icons_width` tinyint(4) NOT NULL DEFAULT '0',
  `icons_height` tinyint(4) NOT NULL DEFAULT '0',
  `icons_order` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `display_on_posting` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`icons_id`),
  KEY `display_on_posting` (`display_on_posting`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_icons (icons_id, icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES (1, 'misc/fire.gif', 16, 16, 1, 1),(2, 'smile/redface.gif', 16, 16, 9, 1),(3, 'smile/mrgreen.gif', 16, 16, 10, 1),(4, 'misc/heart.gif', 16, 16, 4, 1),(5, 'misc/star.gif', 16, 16, 2, 1),(6, 'misc/radioactive.gif', 16, 16, 3, 1),(7, 'misc/thinking.gif', 16, 16, 5, 1),(8, 'smile/info.gif', 16, 16, 8, 1),(9, 'smile/question.gif', 16, 16, 6, 1),(10, 'smile/alert.gif', 16, 16, 7, 1);

# Table: avphpbb_lang
DROP TABLE IF EXISTS avphpbb_lang;
CREATE TABLE `avphpbb_lang` (
  `lang_id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `lang_iso` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
  `lang_dir` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
  `lang_english_name` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `lang_local_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `lang_author` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`lang_id`),
  KEY `lang_iso` (`lang_iso`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_lang (lang_id, lang_iso, lang_dir, lang_english_name, lang_local_name, lang_author) VALUES (1, 'it', 'it', 'Italian', 'Italiano', 'phpbb.it'),(2, 'en', 'en', 'British English', 'British English', 'phpBB Group');

# Table: avphpbb_log
DROP TABLE IF EXISTS avphpbb_log;
CREATE TABLE `avphpbb_log` (
  `log_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `log_type` tinyint(4) NOT NULL DEFAULT '0',
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `reportee_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `log_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
  `log_time` int(11) unsigned NOT NULL DEFAULT '0',
  `log_operation` text COLLATE utf8_bin NOT NULL,
  `log_data` mediumtext COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`log_id`),
  KEY `log_type` (`log_type`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_id` (`topic_id`),
  KEY `reportee_id` (`reportee_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=303 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO avphpbb_log (log_id, log_type, user_id, forum_id, topic_id, reportee_id, log_ip, log_time, log_operation, log_data) VALUES (1, 3, 1, 0, 0, 2, '62.11.176.34', 1521368607, 'LOG_USER_NEW_PASSWORD', 'a:1:{i:0;s:8:\"mayourja\";}'),(2, 3, 2, 0, 0, 2, '62.11.176.34', 1521368658, 'LOG_USER_NEW_PASSWORD', 'a:1:{i:0;s:8:\"mayourja\";}'),(3, 0, 2, 0, 0, 0, '62.11.176.34', 1521369034, 'LOG_ADMIN_AUTH_SUCCESS', ''),(4, 0, 2, 0, 0, 0, '62.11.176.34', 1521369176,
Last edited by Mick on Sun May 13, 2018 7:28 am, edited 1 time in total.
Reason: Added [code] tags for readability.
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72667
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK

Re: move a phpBB forum in another server

Post by KevC »

tubbadù wrote: Sun May 13, 2018 6:48 am the forum isn't big yet, it has got just 5 users and less than 10 topics
Oh jeez you might as well just start from scratch :)

Database looks ok.
Move on to the next step of the article you're following.
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 6606
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.

Re: move a phpBB forum in another server

Post by thecoalman »

Check the last lines, there should be line starting with:

Code: Select all

INSERT INTO avphpbb_zebra
If you have that it should be complete backup.
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison

Return to “[3.1.x] Support Forum”