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_notifications

CREATE TABLE phpbb_notifications (
	notification_id int(10) unsigned NOT NULL AUTO_INCREMENT,
	notification_type_id smallint(4) unsigned NOT NULL DEFAULT '0',
	item_id mediumint(8) unsigned NOT NULL DEFAULT '0',
	item_parent_id mediumint(8) unsigned NOT NULL DEFAULT '0',
	user_id int(10) unsigned NOT NULL DEFAULT '0',
	notification_read tinyint(1) unsigned NOT NULL DEFAULT '0',
	notification_time int(11) unsigned NOT NULL DEFAULT '1',
	notification_data text COLLATE utf8_bin NOT NULL,
	PRIMARY KEY (notification_id),
	KEY item_ident (notification_type_id,item_id),
	KEY user (user_id,notification_read)
) CHARSET=utf8 COLLATE=utf8_bin;