DROP TABLE IF EXISTS `award`;
CREATE TABLE IF NOT EXISTS `award` (
  `award_id` smallint(5) unsigned NOT NULL auto_increment,
  `award_cat_id` smallint(5) NOT NULL default '1',
  `award_name` varchar(50) NOT NULL default '',
  `award_desc` text NOT NULL,
  `award_icon_url` varchar(250) NOT NULL default '',
  `award_img_url` varchar(225) NOT NULL default '',
  `award_displayorder` smallint(5) NOT NULL default '0',
  `award_allowrequest` tinyint(1) NOT NULL default '1',
  `award_active` tinyint(1) NOT NULL default '1',
  `award_allowrecommend` tinyint(1) NOT NULL default '1',
  `award_pointvalue` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`award_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=75 ;

INSERT INTO `award` (`award_id`, `award_cat_id`, `award_name`, `award_desc`, `award_icon_url`, `award_img_url`, `award_displayorder`, `award_allowrequest`, `award_active`, `award_allowrecommend`, `award_pointvalue`) VALUES
(10, 2, 'ÇáæÓÇã ÇáÐåÈí', 'ÇáæÓÇã ÇáÐåÈí', 'images/medals/24.gif', 'images/medals/24.gif', 1, 1, 1, 1, 0),
(8, 2, 'ÇáæÓÇã ÇáÈÑæäÒí', 'ÇáæÓÇã ÇáÈÑæäÒí', 'images/medals/23.gif', 'images/medals/23.gif', 1, 1, 1, 1, 0),
(9, 2, 'ÇáæÓÇã ÇáÝÖí', 'ÇáæÓÇã ÇáÝÖí', 'images/medals/22.gif', 'images/medals/22.gif', 1, 1, 1, 1, 0),
(5, 2, 'æÓÇã ÇáÊãíÒ', 'æÓÇã ÇáÊãíÒ', 'images/medals/20.gif', 'images/medals/20.gif', 1, 1, 1, 1, 0),
(6, 2, 'æÓÜÇã ÇáÊãíÒ', 'æÓÜÇã ÇáÊãíÒ', 'images/medals/17.gif', 'images/medals/17.gif', 1, 1, 1, 1, 0),
(7, 2, 'ÏÑÚ ÇáÊãíÒ', 'ÏÑÚ ÇáÊãíÒ', 'images/medals/35.gif', 'images/medals/35.gif', 1, 1, 1, 1, 0),
(11, 2, 'æÓÇã ÇáÊãíÜÒ', 'æÓÇã ÇáÊãíÜÒ', 'images/medals/56.gif', 'images/medals/56.gif', 1, 1, 1, 1, 0),
(12, 2, 'ÇáÊãíÒ ÇáÐåÈí', 'ÇáÊãíÒ ÇáÐåÈí', 'images/medals/45.gif', 'images/medals/45.gif', 1, 1, 1, 1, 0),
(13, 2, 'ÇáÊãíÒ ÇáÝÖí', 'ÇáÊãíÒ ÇáÝÖí', 'images/medals/46.gif', 'images/medals/46.gif', 1, 1, 1, 1, 0),
(14, 2, 'ÇáÊãíÒ ÇáÈÑæäÒí', 'ÇáÊãíÒ ÇáÈÑæäÒí', 'images/medals/47.gif', 'images/medals/47.gif', 1, 1, 1, 1, 0),
(15, 1, 'ÇáÚÖæ ÇáããíÒ', 'ÇáÚÖæ ÇáããíÒ', 'images/medals/3.gif', 'images/medals/3.gif', 1, 1, 1, 1, 0),
(16, 1, 'ÇáÚÖÜæ ÇáããíÒ', 'ÇáÚÖÜæ ÇáããíÒ', 'images/medals/25.gif', 'images/medals/25.gif', 1, 1, 1, 1, 0),
(17, 1, 'ÇáÚÖæ ÇáããíÜÒ', 'ÇáÚÖæ ÇáããíÜÒ', 'images/medals/34.gif', 'images/medals/34.gif', 1, 1, 1, 1, 0),
(18, 1, 'ÇáÚÜÖæ ÇáããíÒ', 'ÇáÚÜÖæ ÇáããíÒ', 'images/medals/50.gif', 'images/medals/50.gif', 1, 1, 1, 1, 0),
(19, 1, 'æÓÇã ÇáÚÖæ ÇáããíÒ', 'æÓÇã ÇáÚÖæ ÇáããíÒ', 'images/medals/54.gif', 'images/medals/54.gif', 1, 1, 1, 1, 0),
(20, 1, 'æÓÇã ÇáÚÖæÉ ÇáããíÒÉ', 'æÓÇã ÇáÚÖæÉ ÇáããíÒÉ', 'images/medals/53.gif', 'images/medals/53.gif', 1, 1, 1, 1, 0),
(21, 1, 'ÇáÜÚÖæ ÇáããíÒ', 'ÇáÜÚÖæ ÇáããíÒ', 'images/medals/64.gif', 'images/medals/64.gif', 1, 1, 1, 1, 0),
(22, 3, 'ÇáãÔÑÝ ÇáããíÒ', 'ÇáãÔÑÝ ÇáããíÒ', 'images/medals/2.gif', 'images/medals/2.gif', 1, 1, 1, 1, 0),
(23, 3, 'ÇáãÔÑÝÉ ÇáããíÒÉ', 'ÇáãÔÑÝÉ ÇáããíÒÉ', 'images/medals/4.gif', 'images/medals/4.gif', 1, 1, 1, 1, 0),
(24, 3, 'ÇáãÔÑÝ ÇáããíÜÒ', 'ÇáãÔÑÝ ÇáããíÜÒ', 'images/medals/26.gif', 'images/medals/26.gif', 1, 1, 1, 1, 0),
(25, 3, 'ÇáãÜÔÑÝ ÇáããíÒ', 'ÇáãÜÔÑÝ ÇáããíÒ', 'images/medals/39.gif', 'images/medals/39.gif', 1, 1, 1, 1, 0),
(26, 3, 'ÇáãÔÑÝ ÇáãÜãíÒ', 'ÇáãÔÑÝ ÇáãÜãíÒ', 'images/medals/42.gif', 'images/medals/42.gif', 1, 1, 1, 1, 0),
(27, 3, 'ÇáãÔÑÝÉ ÇáããíÜÒÉ', 'ÇáãÔÑÝÉ ÇáããíÜÒÉ', 'images/medals/43.gif', 'images/medals/43.gif', 1, 1, 1, 1, 0),
(28, 3, 'ÇáãÔÑÝ ÇáãÜãÜíÒ', 'ÇáãÔÑÝ ÇáãÜãÜíÒ', 'images/medals/66.gif', 'images/medals/66.gif', 1, 1, 1, 1, 0),
(29, 3, 'ÇáãÔÑÝÜÉ ÇáããíÒÉ', 'ÇáãÔÑÝÜÉ ÇáããíÒÉ', 'images/medals/67.gif', 'images/medals/67.gif', 1, 1, 1, 1, 0),
(30, 3, 'ÇáãÔÑÝÜÉ ÇáããíÜÒÉ', 'ÇáãÔÑÝÜÉ ÇáããíÜÒÉ', 'images/medals/59.gif', 'images/medals/59.gif', 1, 1, 1, 1, 0),
(31, 7, 'æÓÇã ÇáÊßÑíã', 'æÓÇã ÇáÊßÑíã', 'images/medals/70.gif', 'images/medals/70.gif', 1, 1, 1, 1, 0),
(32, 7, 'æÓÜÇã ÇáÊßÑíã', 'æÓÜÇã ÇáÊßÑíã', 'images/medals/9.gif', 'images/medals/9.gif', 1, 1, 1, 1, 0),
(33, 7, 'ÇáÊßÑíÜÜã', 'ÇáÊßÑíÜÜã', 'images/medals/16.gif', 'images/medals/16.gif', 1, 1, 1, 1, 0),
(34, 7, 'æÓÜÜÇã ÇáÊßÑíã', 'æÓÜÜÇã ÇáÊßÑíã', 'images/medals/32.gif', 'images/medals/32.gif', 1, 1, 1, 1, 0),
(35, 7, 'æÓÇã ÇáÅÈÏÇÚ', 'æÓÇã ÇáÅÈÏÇÚ', 'images/medals/69.gif', 'images/medals/69.gif', 1, 1, 1, 1, 0),
(37, 3, 'ÇáãÜÔÜÑÝ ÇáããíÒ', 'ÇáãÜÔÜÑÝ ÇáããíÒ', 'images/medals/28.gif', 'images/medals/28.gif', 1, 1, 1, 1, 0),
(38, 3, 'ÇáãÜÔÑÝÜÉ ÇáããíÒÉ', 'ÇáãÜÔÑÝÜÉ ÇáããíÒÉ', 'images/medals/27.gif', 'images/medals/27.gif', 1, 1, 1, 1, 0),
(39, 6, 'æÓÇã ÍæÇÁ', 'æÓÇã ÍæÇÁ', 'images/medals/1.gif', 'images/medals/1.gif', 1, 1, 1, 1, 0),
(40, 6, 'æÓÜÜÇã ÍæÇÁ', 'æÓÜÜÇã ÍæÇÁ', 'images/medals/33.gif', 'images/medals/33.gif', 1, 1, 1, 1, 0),
(41, 6, 'ãáßÉ ÇáÊãíÒ', 'ãáßÉ ÇáÊãíÒ', 'images/medals/36.gif', 'images/medals/36.gif', 1, 1, 1, 1, 0),
(42, 6, 'æÓÜÇã ÍÜæÇÁ', 'æÓÜÇã ÍÜæÇÁ', 'images/medals/52.gif', 'images/medals/52.gif', 1, 1, 1, 1, 0),
(43, 7, 'æÓÜÜÇã ÇáÅÈÏÇÚ', 'æÓÜÜÇã ÇáÅÈÏÇÚ', 'images/medals/11.gif', 'images/medals/11.gif', 1, 1, 1, 1, 0),
(44, 7, 'æÓÜÇã ÇáÅÈÜÏÇÚ', 'æÓÜÇã ÇáÅÈÜÏÇÚ', 'images/medals/10.gif', 'images/medals/10.gif', 1, 1, 1, 1, 0),
(45, 4, 'ÇáÅÏÇÑí ÇáããíÒ', 'ÇáÅÏÇÑí ÇáããíÒ', 'images/medals/8.gif', 'images/medals/8.gif', 1, 1, 1, 1, 0),
(46, 4, 'ÇáãÑÇÞÈ ÇáããíÒ', 'ÇáãÑÇÞÈ ÇáããíÒ', 'images/medals/30.gif', 'images/medals/30.gif', 1, 1, 1, 1, 0),
(47, 4, 'ÇáãÑÇÞÈÉ ÇáããíÒÉ', 'ÇáãÑÇÞÈÉ ÇáããíÒÉ', 'images/medals/29.gif', 'images/medals/29.gif', 1, 1, 1, 1, 0),
(48, 4, 'æÓÇã ÇáÅÏÇÑÉ', 'æÓÇã ÇáÅÏÇÑÉ', 'images/medals/31.gif', 'images/medals/31.gif', 1, 1, 1, 1, 0),
(49, 4, 'ÇáÅÏÇÑÉ', 'ÇáÅÏÇÑÉ', 'images/medals/37.gif', 'images/medals/37.gif', 1, 1, 1, 1, 0),
(50, 4, 'æÓÇã ÇáÅÏÇÑí ÇáããíÒ', 'æÓÇã ÇáÅÏÇÑí ÇáããíÒ', 'images/medals/58.gif', 'images/medals/58.gif', 1, 1, 1, 1, 0),
(51, 4, 'ÇáÅÏÇÑí ÇáããíÜÒ', 'ÇáÅÏÇÑí ÇáããíÜÒ', 'images/medals/41.gif', 'images/medals/41.gif', 1, 1, 1, 1, 0),
(52, 4, 'ÇáÅÏÇÑí ÇáÜããíÒ', 'ÇáÅÏÇÑí ÇáÜããíÒ', 'images/medals/61.gif', 'images/medals/61.gif', 1, 1, 1, 1, 0),
(53, 1, 'ÇáÚÖÜÜæ ÇáããíÒ', 'ÇáÚÖÜÜæ ÇáããíÒ', 'images/medals/40.gif', 'images/medals/40.gif', 1, 1, 1, 1, 0),
(54, 5, 'ÇáÔÇÚÑ ÇáããíÒ', 'ÇáÔÇÚÑ ÇáããíÒ', 'images/medals/5.gif', 'images/medals/5.gif', 1, 1, 1, 1, 0),
(55, 5, 'ÇáãÕãã ÇáããíÒ', 'ÇáãÕãã ÇáããíÒ', 'images/medals/6.gif', 'images/medals/6.gif', 1, 1, 1, 1, 0),
(56, 5, 'ÇáÑíÇÖí ÇáããíÒ', 'ÇáÑíÇÖí ÇáããíÒ', 'images/medals/7.gif', 'images/medals/7.gif', 1, 1, 1, 1, 0),
(57, 5, 'æÓÇã ÇáÅÊÞÇä', 'æÓÇã ÇáÅÊÞÇä', 'images/medals/12.gif', 'images/medals/12.gif', 1, 1, 1, 1, 0),
(58, 5, 'ÇáßÇÊÈ ÇáããíÒ', 'ÇáßÇÊÈ ÇáããíÒ', 'images/medals/13.gif', 'images/medals/13.gif', 1, 1, 1, 1, 0),
(59, 5, 'ãÊãíÒ Ýí Ýä ÇáÚáÇÞÇÊ', 'ãÊãíÒ Ýí Ýä ÇáÚáÇÞÇÊ', 'images/medals/14.gif', 'images/medals/14.gif', 1, 1, 1, 1, 0),
(60, 5, 'ÔÜÇÚÑ ããíÒ', 'ÔÜÇÚÑ ããíÒ', 'images/medals/15.gif', 'images/medals/15.gif', 1, 1, 1, 1, 0),
(61, 5, 'æÓÇã ÇáÊæÇÕá', 'æÓÇã ÇáÊæÇÕá', 'images/medals/18.gif', 'images/medals/18.gif', 1, 1, 1, 1, 0),
(62, 5, 'ÔÇÚÑ ÇáãäÊÏì', 'ÔÇÚÑ ÇáãäÊÏì', 'images/medals/19.gif', 'images/medals/19.gif', 1, 1, 1, 1, 0),
(63, 5, 'ÃÝÖá ãÕãã', 'ÃÝÖá ãÕãã', 'images/medals/21.gif', 'images/medals/21.gif', 1, 1, 1, 1, 0),
(64, 5, 'ßÈÇÑ ÇáÔÎÕíÇÊ', 'ßÈÇÑ ÇáÔÎÕíÇÊ', 'images/medals/44.gif', 'images/medals/44.gif', 1, 1, 1, 1, 0),
(65, 5, 'ÇáÞáã ÇáããíÒ', 'ÇáÞáã ÇáããíÒ', 'images/medals/48.gif', 'images/medals/48.gif', 1, 1, 1, 1, 0),
(66, 5, 'ÇáÍÖæÑ ÇáããíÒ', 'ÇáÍÖæÑ ÇáããíÒ', 'images/medals/49.gif', 'images/medals/49.gif', 1, 1, 1, 1, 0),
(67, 5, 'ÇáãÕãã ÇáããíÒ', 'ÇáãÕãã ÇáããíÒ', 'images/medals/51.gif', 'images/medals/51.gif', 1, 1, 1, 1, 0),
(68, 5, 'æÓÇã ÇáÚØÜÇÁ', 'æÓÇã ÇáÚØÜÇÁ', 'images/medals/55.gif', 'images/medals/55.gif', 1, 1, 1, 1, 0),
(69, 5, 'ÕÍÝí ÇáãäÊÏì', 'ÕÍÝí ÇáãäÊÏì', 'images/medals/57.png', 'images/medals/57.png', 1, 1, 1, 1, 0),
(70, 5, 'ÇáÊãíÒ ÇáÑíÇÖí', 'ÇáÊãíÒ ÇáÑíÇÖí', 'images/medals/60.gif', 'images/medals/60.gif', 1, 1, 1, 1, 0),
(71, 5, 'ÇáÊãíÒ ÇáÃÏÈí', 'ÇáÊãíÒ ÇáÃÏÈí', 'images/medals/62.gif', 'images/medals/62.gif', 1, 1, 1, 1, 0),
(72, 5, 'ÇáÑíÜÇÖí ÇáããíÒ', 'ÇáÑíÜÇÖí ÇáããíÒ', 'images/medals/63.gif', 'images/medals/63.gif', 1, 1, 1, 1, 0),
(73, 5, 'ÇáÞáã ÇááÇãÚ', 'ÇáÞáã ÇááÇãÚ', 'images/medals/65.gif', 'images/medals/65.gif', 1, 1, 1, 1, 0),
(74, 5, 'ÇáãÕÜãã ÇáããíÒ', 'ÇáãÕÜãã ÇáããíÒ', 'images/medals/68.gif', 'images/medals/68.gif', 1, 1, 1, 1, 0);

DROP TABLE IF EXISTS `award_cat`;
CREATE TABLE IF NOT EXISTS `award_cat` (
  `award_cat_id` mediumint(8) unsigned NOT NULL auto_increment,
  `award_cat_title` varchar(100) NOT NULL default '',
  `award_cat_desc` varchar(250) NOT NULL default '',
  `award_cat_displayorder` mediumint(8) unsigned NOT NULL default '0',
  `award_cat_parentid` mediumint(8) NOT NULL default '-1',
  PRIMARY KEY  (`award_cat_id`),
  KEY `award_cat_order` (`award_cat_displayorder`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

INSERT INTO `award_cat` (`award_cat_id`, `award_cat_title`, `award_cat_desc`, `award_cat_displayorder`, `award_cat_parentid`) VALUES
(1, 'ÇáÃÚÖÇÁ', 'ÃæÓãÉ ÇáÃÚÖÇÁ', 1, -1),
(2, 'ÇáÊãíÒ ', 'ÃæÓãÉ ÇáÊãíÒ', 4, -1),
(3, 'ÇáãÔÑÝíä', 'ÃæÓãÉ ÇáãÔÑÝíä', 2, -1),
(4, 'ÇáÅÏÇÑííä æÇáãÑÇÞÈíä', 'ÃæÓãÉ ÇáÅÏÇÑííä æÇáãÑÇÞÈíä', 3, -1),
(5, 'ãäæÚÉ æãÎÊáÝÉ', 'ÃæÓãÉ ãäæÚÉ æãÎÊáÝÉ', 7, -1),
(6, 'äÓÇÆíÉ', 'ÃæÓãÉ äÓÇÆíÉ', 6, -1),
(7, 'ÇáÊßÑíã æÇáÅÈÏÇÚ', 'ÃæÓãÉ ÇáÊßÑíÜã æÇáÅÈÏÇÚ', 5, -1);
