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_icons

Description de la table

Table contenant les informations des icônes du forum.

Schéma de la table en image

Capture d’écran de la tablephpbb_icons

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

CREATE TABLE phpbb_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_alt varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	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)
) CHARSET=utf8 COLLATE=utf8_bin;

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

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