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_user_notifications

Description de la table

Table contenant la liste des paramètres des notifications définis par les membres.

Schéma de la table en image

Capture d’écran de la tablephpbb_user_notifications

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

CREATE TABLE phpbb_user_notifications (
	item_type varchar(165) COLLATE utf8_bin NOT NULL DEFAULT '',
	item_id int(10) unsigned NOT NULL DEFAULT '0',
	user_id int(10) unsigned NOT NULL DEFAULT '0',
	method varchar(165) COLLATE utf8_bin NOT NULL DEFAULT '',
	notify tinyint(1) unsigned NOT NULL DEFAULT '1',
	UNIQUE KEY itm_usr_mthd (item_type,item_id,user_id,method),
	KEY user_id (user_id),
	KEY uid_itm_id (user_id,item_id),
	KEY usr_itm_tpe (user_id,item_type,item_id)
) CHARSET=utf8 COLLATE=utf8_bin;

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

INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('notification.type.post', 0, 2, 'notification.method.board');
INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('notification.type.post', 0, 2, 'notification.method.email');
INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('notification.type.topic', 0, 2, 'notification.method.board');
INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('notification.type.topic', 0, 2, 'notification.method.email');
INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('notification.type.forum', 0, 2, 'notification.method.board');
INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('notification.type.forum', 0, 2, 'notification.method.email');