كود:
--
-- بنية الجدول `smilie`
--
CREATE TABLE IF NOT EXISTS `smilie` (
`smilieid` smallint(5) unsigned NOT NULL auto_increment,
`title` char(100) NOT NULL default '',
`smilietext` char(20) NOT NULL default '',
`smiliepath` char(100) NOT NULL default '',
`imagecategoryid` smallint(5) unsigned NOT NULL default '0',
`displayorder` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`smilieid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
--
-- إرجاع أو إستيراد بيانات الجدول `smilie`
--
INSERT INTO `smilie` (`smilieid`, `title`, `smilietext`, `smiliepath`, `imagecategoryid`, `displayorder`) VALUES
(1, 'Smile', ':)', 'images/smilies/smile.gif', 1, 1),
(2, 'Embarrassment', ':o', 'images/smilies/redface.gif', 1, 1),
(3, 'Big Grin', ':D', 'images/smilies/biggrin.gif', 1, 1),
(4, 'Wink', ';)', 'images/smilies/wink.gif', 1, 1),
(5, 'Stick Out Tongue', ':p', 'images/smilies/tongue.gif', 1, 1),
(6, 'Cool', ':cool:', 'images/smilies/cool.gif', 1, 5),
(7, 'Roll Eyes (Sarcastic)', ':rolleyes:', 'images/smilies/rolleyes.gif', 1, 3),
(8, 'Mad', ':mad:', 'images/smilies/mad.gif', 1, 1),
(9, 'EEK!', ':eek:', 'images/smilies/eek.gif', 1, 7),
(10, 'Confused', ':confused:', 'images/smilies/confused.gif', 1, 1),
(11, 'Frown', ':(', 'images/smilies/frown.gif', 1, 1);