From PHPBB用户手册

# Table: 'phpbb_smilies'
CREATE TABLE phpbb_smilies (
	smiley_id mediumint(8) UNSIGNED NOT NULL auto_increment, ID
	code varchar(50) DEFAULT '' NOT NULL, 图标对应的代码
	emotion varchar(50) DEFAULT '' NOT NULL, 表情说明
	smiley_url varchar(50) DEFAULT '' NOT NULL, 图标的文件位置
	smiley_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL, 图标宽度
	smiley_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL, 图标高度
	smiley_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, 图标顺序
	display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, 是否在发表文章时显示
	PRIMARY KEY (smiley_id),
	KEY display_on_post (display_on_posting)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;