DROP TABLE IF EXISTS `award`;
CREATE TABLE `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',
PRIMARY KEY (`award_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;
INSERT INTO `award` VALUES (1, 4, 'ãÔÑÝ ããíÒ', 'ãÔÑÝ ããíÒ', 'awards/0.gif', 'awards/1.gif', 1, 1, 1);
INSERT INTO `award` VALUES (2, 5, 'ÚÖæ ããíÒ', 'ÚÖæ ããíÒ', 'awards/0.gif', 'awards/2.gif', 1, 1, 1);
INSERT INTO `award` VALUES (3, 1, 'ÇáÊßÑíã', 'ÇáÊßÑíã', 'awards/0.gif', 'awards/3.gif', 1, 1, 1);
INSERT INTO `award` VALUES (4, 1, 'ÇáÅÈÏÇÚ', 'ÇáÅÈÏÇÚ', 'awards/0.gif', 'awards/4.gif', 1, 1, 1);
INSERT INTO `award` VALUES (5, 1, 'ÇáÅÈÏÇÚ', 'ÇáÅÈÏÇÚ', 'awards/0.gif', 'awards/5.gif', 1, 1, 1);
INSERT INTO `award` VALUES (6, 1, 'ÇáÅÊÞÇä', 'ÇáÅÊÞÇä', 'awards/0.gif', 'awards/6.gif', 1, 1, 1);
INSERT INTO `award` VALUES (7, 1, 'ÇáßÇÊÈ ÇáããíÒ', 'ÇáßÇÊÈ ÇáããíÒ', 'awards/0.gif', 'awards/7.gif', 1, 1, 1);
INSERT INTO `award` VALUES (8, 1, 'ãÊãíÒ Ýí Ýä ÇáÚáÇÞÇÊ', 'ãÊãíÒ Ýí Ýä ÇáÚáÇÞÇÊ', 'awards/0.gif', 'awards/8.gif', 1, 1, 1);
INSERT INTO `award` VALUES (9, 1, 'ÔÇÚÑ ããíÒ', 'ÔÇÚÑ ããíÒ', 'awards/0.gif', 'awards/9.gif', 1, 1, 1);
INSERT INTO `award` VALUES (10, 1, 'ÇáÊßÑíã', 'ÇáÊßÑíã', 'awards/0.gif', 'awards/10.gif', 1, 1, 1);
INSERT INTO `award` VALUES (11, 1, 'ÇáÊãíÒ', 'ÇáÊãíÒ', 'awards/0.gif', 'awards/11.gif', 1, 1, 1);
INSERT INTO `award` VALUES (12, 1, 'ÇáÊæÇÕá', 'ÇáÊæÇÕá', 'awards/0.gif', 'awards/20.gif', 1, 1, 1);
INSERT INTO `award` VALUES (13, 2, 'ÇáÅÏÇÑí ÇáããíÒ', 'ÇáÅÏÇÑí ÇáããíÒ', 'awards/0.gif', 'awards/13.gif', 1, 1, 1);
INSERT INTO `award` VALUES (14, 4, 'ÇáãÔÑÝ ÇáããíÒ', 'ÇáãÔÑÝ ÇáããíÒ', 'awards/0.gif', 'awards/14.gif', 1, 1, 1);
INSERT INTO `award` VALUES (15, 4, 'ÇáãÔÑÝÉ ÇáããíÒÉ', 'ÇáãÔÑÝÉ ÇáããíÒÉ', 'awards/0.gif', 'awards/15.gif', 1, 1, 1);
INSERT INTO `award` VALUES (16, 1, 'ßÈÇÑ ÇáÔÎÕíÇÊ', 'ßÈÇÑ ÇáÔÎÕíÇÊ', 'awards/0.gif', 'awards/16.gif', 1, 1, 1);
INSERT INTO `award` VALUES (17, 5, 'ÇáÊãíÒ ÇáÐåÈí', 'ÇáÊãíÒ ÇáÐåÈí', 'awards/0.gif', 'awards/17.gif', 1, 1, 1);
INSERT INTO `award` VALUES (18, 5, 'ÇáÊãíÒ ÇáÝÖí', 'ÇáÊãíÒ ÇáÝÖí', 'awards/0.gif', 'awards/18.gif', 1, 1, 1);
INSERT INTO `award` VALUES (19, 5, 'ÇáÊãíÒ ÇáÈÑæäÒí', 'ÇáÊãíÒ ÇáÈÑæäÒí', 'awards/0.gif', 'awards/19.gif', 1, 1, 1);
INSERT INTO `award` VALUES (20, 1, 'ÇáÞáã ÇáããíÒ', 'ÇáÞáã ÇáããíÒ', 'awards/0.gif', 'awards/20.gif', 1, 1, 1);
INSERT INTO `award` VALUES (21, 3, 'ÇáÍÖæÑ ÇáããíÒ', 'ÇáÍÖæÑ ÇáããíÒ', 'awards/0.gif', 'awards/21.gif', 1, 1, 1);
INSERT INTO `award` VALUES (22, 1, 'ÇáÊãíÒ ÇáÑíÇÖí', 'ÇáÊãíÒ ÇáÑíÇÖí', 'awards/0.gif', 'awards/22.gif', 1, 1, 1);
INSERT INTO `award` VALUES (23, 5, 'ÇáÚÖæ ÇáããíÒ', 'ÇáÚÖæ ÇáããíÒ', 'awards/0.gif', 'awards/23.gif', 1, 1, 1);
INSERT INTO `award` VALUES (24, 1, 'ÇáãÕãã ÇáããíÒ', 'ÇáãÕãã ÇáããíÒ', 'awards/0.gif', 'awards/24.gif', 1, 1, 1);
INSERT INTO `award` VALUES (25, 1, 'ÍæÇÁ', 'ÍæÇÁ', 'awards/0.gif', 'awards/25.gif', 1, 1, 1);
INSERT INTO `award` VALUES (26, 1, 'ãÕãã ãÈÏÚ', 'ãÕãã ãÈÏÚ', 'awards/0.gif', 'awards/26.gif', 1, 1, 1);
INSERT INTO `award` VALUES (27, 5, 'ÚÖæ ÐåÈí', 'ÚÖæ ÐåÈí', 'awards/0.gif', 'awards/27.gif', 1, 1, 1);
INSERT INTO `award` VALUES (28, 1, 'äÌãÉ ÇáãäÊÏì', 'äÌãÉ ÇáãäÊÏì', 'awards/0.gif', 'awards/28.gif', 1, 1, 1);
INSERT INTO `award` VALUES (29, 5, 'ÚÖæ ãÍÊÑÝ', 'ÚÖæ ãÍÊÑÝ', 'awards/0.gif', 'awards/29.gif', 1, 1, 1);
INSERT INTO `award` VALUES (30, 3, 'ÇáæÓÇã ÇáÐåÈí', 'ÇáæÓÇã ÇáÐåÈí', 'awards/0.gif', 'awards/30.gif', 1, 1, 1);
INSERT INTO `award` VALUES (31, 3, 'ÇáæÓÇã ÇáÝÖí', 'ÇáæÓÇã ÇáÝÖí', 'awards/0.gif', 'awards/31.gif', 1, 1, 1);
INSERT INTO `award` VALUES (32, 3, 'ÇáæÓÇã ÇáÈÑæäÒí', 'ÇáæÓÇã ÇáÈÑæäÒí', 'awards/0.gif', 'awards/32.gif', 1, 1, 1);
INSERT INTO `award` VALUES (33, 4, 'ÇáÞÓã ÇáããíÒ', 'ÇáÞÓã ÇáããíÒ', 'awards/0.gif', 'awards/33.gif', 1, 1, 1);
INSERT INTO `award` VALUES (34, 4, 'ÇáãÔÑÝ ÇáããíÒ', 'ÇáãÔÑÝ ÇáããíÒ', 'awards/0.gif', 'awards/34.gif', 1, 1, 1);
INSERT INTO `award` VALUES (35, 5, 'ÇáÚÖæ ÇáããíÒ', 'ÇáÚÖæ ÇáããíÒ', 'awards/0.gif', 'awards/35.gif', 1, 1, 1);
INSERT INTO `award` VALUES (36, 2, 'æÓÇã ÇáÊãíÒ', 'æÓÇã ÇáÊãíÒ', 'awards/0.gif', 'awards/36.gif', 1, 1, 1);
INSERT INTO `award` VALUES (37, 5, 'ÇáÚÖæ ÇáããíÒ', 'ÇáÚÖæ ÇáããíÒ', 'awards/0.gif', 'awards/37.gif', 1, 1, 1);
INSERT INTO `award` VALUES (38, 4, 'ÇáãÔÑÝ ÇáããíÒ', 'ÇáãÔÑÝ ÇáããíÒ', 'awards/0.gif', 'awards/38.gif', 1, 1, 1);
INSERT INTO `award` VALUES (39, 5, 'ÇáæÓÇã ÇáÐåÈí', 'ÇáæÓÇã ÇáÐåÈí', 'awards/0.gif', 'awards/30.gif', 1, 1, 1);
INSERT INTO `award` VALUES (40, 5, 'ÇáæÓÇã ÇáÝÖí', 'ÇáæÓÇã ÇáÝÖí', 'awards/0.gif', 'awards/31.gif', 1, 1, 1);
INSERT INTO `award` VALUES (41, 5, 'ÇáÊãíÒ ÇáÈÑæäÒí', 'ÇáÊãíÒ ÇáÈÑæäÒí', 'awards/0.gif', 'awards/32.gif', 1, 1, 1);
DROP TABLE IF EXISTS `award_cat`;
CREATE TABLE `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=6 ;
INSERT INTO `award_cat` VALUES (1, 'ãäæÚÉ', 'ÃæÓãÉ ãäæÚÉ', 1, -1);
INSERT INTO `award_cat` VALUES (2, 'ÇáÅÏÇÑííä', 'ÃæÓãÉ ÇáÅÏÇÑííä', 2, -1);
INSERT INTO `award_cat` VALUES (3, 'ÇáãÑÇÞÈíä', 'ÃæÓãÉ ÇáãÑÇÞÈíä', 3, -1);
INSERT INTO `award_cat` VALUES (4, 'ÇáãÔÑÝíä', 'ÃæÓãÉ ÇáãÔÑÝíä', 4, -1);
INSERT INTO `award_cat` VALUES (5, 'ÇáÃÚÖÇÁ', 'ÃæÓãÉ ÇáÃÚÖÇÁ', 5, -1);