Description de la table
Table contenant les groupes du forum.
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_groups
Schéma de la table en image
Requête SQL de la structure de la table lors de l’installation
CREATE TABLE phpbb_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_skip_auth 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', PRIMARY KEY (group_id), KEY group_legend_name (group_legend,group_name) ) CHARSET=utf8 COLLATE=utf8_bin;
Requête SQL des données insérées dans la table
INSERT INTO phpbb_groups (group_name, group_type, group_founder_manage, group_colour, group_legend, group_avatar, group_desc, group_desc_uid, group_max_recipients) VALUES ('GUESTS', 3, 0, '', 0, '', '', '', 5);
INSERT INTO phpbb_groups (group_name, group_type, group_founder_manage, group_colour, group_legend, group_avatar, group_desc, group_desc_uid, group_max_recipients) VALUES ('REGISTERED', 3, 0, '', 0, '', '', '', 5);
INSERT INTO phpbb_groups (group_name, group_type, group_founder_manage, group_colour, group_legend, group_avatar, group_desc, group_desc_uid, group_max_recipients) VALUES ('REGISTERED_COPPA', 3, 0, '', 0, '', '', '', 5);
INSERT INTO phpbb_groups (group_name, group_type, group_founder_manage, group_colour, group_legend, group_avatar, group_desc, group_desc_uid, group_max_recipients) VALUES ('GLOBAL_MODERATORS', 3, 0, '00AA00', 2, '', '', '', 0);
INSERT INTO phpbb_groups (group_name, group_type, group_founder_manage, group_colour, group_legend, group_avatar, group_desc, group_desc_uid, group_max_recipients) VALUES ('ADMINISTRATORS', 3, 1, 'AA0000', 1, '', '', '', 0);
INSERT INTO phpbb_groups (group_name, group_type, group_founder_manage, group_colour, group_legend, group_avatar, group_desc, group_desc_uid, group_max_recipients) VALUES ('BOTS', 3, 0, '9E8DA7', 0, '', '', '', 5);
INSERT INTO phpbb_groups (group_name, group_type, group_founder_manage, group_colour, group_legend, group_avatar, group_desc, group_desc_uid, group_max_recipients) VALUES ('NEWLY_REGISTERED', 3, 0, '', 0, '', '', '', 5);