see
this articleexemples of xoops_avatar table :
le="color: #000000"><?php 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
