
what is the simpliest way to do it? Thank you very much!!! Bye!
ah ok I understood it! thank you!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.
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
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
ah so the file I already uploaded in the dumb folder? (backup_1526130203_aa24872a51468bda.sql.gz)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.
no, it only takes half a second to complete and to show me... maybe I'm making some mistakes...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.
235 KB
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?
that's what I tried to do first, but it doesn't works...
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
ok perfectKevC wrote: Sat May 12, 2018 5:29 pm Yes and yes.
The idea is to replace the existing default database with the backup one.
That's not right. Even a brand new installation would be bigger than that.
that's what I read rightclicking on it and going in property > dimension
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,
Oh jeez you might as well just start from scratchtubbadù 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
Code: Select all
INSERT INTO avphpbb_zebra