CREATE TABLE smiley (
   id int(3) NOT NULL auto_increment,
   smiley char(8),
   codeHTML char(30),
   PRIMARY KEY (id)
);

insert into smiley(smiley,codeHTML) VALUES (':)','smile.gif');
 
insert into smiley(smiley,codeHTML) VALUES ('8)','sol.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':-o',' titprem.gif');
 
insert into smiley(smiley,codeHTML) VALUES (';)','wink.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':yes','yaisse.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':(','sad.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':pfff','pitoyable.gif');
 
insert into smiley(smiley,codeHTML) VALUES ('8o<','phenos.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':+D','shooter.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':ox','calin.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':D','biggrin.gif');
 
insert into smiley(smiley,codeHTML) VALUES ('<-(','cry2.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':love','love.gif');
 
insert into smiley(smiley,codeHTML) VALUES ('>-(','cry3.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':cry','cry.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':calin','calin.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':mdr','mdr.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':jap','jap.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':kiss','kiss.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':fuck','fuck.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':oups','derange.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':-/','heink.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':lol','lol.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':fou','mad.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':pitie','pitie.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':non','nono.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':hello','hello.gif');
 
 
insert into smiley(smiley,codeHTML) VALUES (':-\','mlc.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':o','redface.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':buvons','trink.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':vomi','vomi.gif');
 
insert into smiley(smiley,codeHTML) VALUES ('<->','spamafote.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':val','val.gif');
 
insert into smiley(smiley,codeHTML) VALUES ('8-x','8-x.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':-p','koala.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':barbie','barbie.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':???','confused.gif');
 
insert into smiley(smiley,codeHTML) VALUES (':\','ohwell.gif');