Documentation contenant le détail des tables de la base de données d’un forum phpBB 3.3.10

Détails de la table phpbb_extension_groups

Description de la table

Table contenant la liste des groupes des extensions de fichiers joints du forum.

Schéma de la table en image

Capture d’écran de la tablephpbb_extension_groups

Requête SQL de la structure de la table lors de l’installation

CREATE TABLE phpbb_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)
) CHARSET=utf8 COLLATE=utf8_bin;

Requête SQL des données insérées dans la table

INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('IMAGES', 1, 1, 1, '', 0, '');
INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('ARCHIVES', 0, 1, 1, '', 0, '');
INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('PLAIN_TEXT', 0, 0, 1, '', 0, '');
INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('DOCUMENTS', 0, 0, 1, '', 0, '');
INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('DOWNLOADABLE_FILES', 0, 0, 1, '', 0, '');