CREATE TABLE `award_user` (   `issue_id` smallint(5) NOT NULL auto_increment,   `award_id` smallint(5) NOT NULL default '0',   `userid` int(10) NOT NULL default '0',   `issue_reason` text NOT NULL,   `issue_time` int(10) NOT NULL default '0', PRIMARY KEY  (`issue_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 

 
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',   `award_allowrecommend` tinyint(1) NOT NULL default '1',   `award_pointvalue` tinyint(3) NOT NULL default '0', PRIMARY KEY  (`award_id`) ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;  
 

 
CREATE TABLE `award_user` (   `issue_id` smallint(5) NOT NULL auto_increment,   `award_id` smallint(5) NOT NULL default '0',   `userid` int(10) NOT NULL default '0',   `issue_reason` text NOT NULL,   `issue_time` int(10) NOT NULL default '0', PRIMARY KEY  (`issue_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 

 
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=utf8 AUTO_INCREMENT=2 ;