see
this articleexemples of xoops_avatar table :
DROP TABLE IF EXISTS `xoops_avatar`;
CREATE TABLE `xoops_avatar` (
`avatar_id` mediumint(8) unsigned NOT NULL auto_increment,
`avatar_file` varchar(30) NOT NULL default '',
`avatar_name` varchar(100) NOT NULL default '',
`avatar_mimetype` varchar(30) NOT NULL default '',
`avatar_created` int(10) NOT NULL default '0',
`avatar_display` tinyint(1) unsigned NOT NULL default '0',
`avatar_weight` smallint(5) unsigned NOT NULL default '0',
`avatar_type` char(1) NOT NULL default '',
PRIMARY KEY (`avatar_id`),
KEY `avatar_type` (`avatar_type`,`avatar_display`)
) TYPE=MyISAM AUTO_INCREMENT=204 ;
#
# Contenu de la table `xoops_avatar`
#
INSERT INTO `xoops_avatar` (`avatar_id`, `avatar_file`, `avatar_name`, `avatar_mimetype`, `avatar_created`, `avatar_display`, `avatar_weight`, `avatar_type`) VALUES
(1, 'savtavatar001.gif', 'avatar', 'image/gif', 1083460026, 1, 0, 'S'),
(2, 'savtavatar002.gif', 'avatar', 'image/gif', 1083460029, 1, 0, 'S'),
...
...
(202, 'savtavatar202.gif', 'avatar', 'image/gif', 1083460629, 1, 0, 'S'),
(203, 'savtavatar203.gif', 'avatar', 'image/gif', 1083460632, 1, 0, 'S');
";" for the last, not ","
for 203 avatars
