File size: 614B
CREATE TABLE IF NOT EXISTS `gifts` (
`gift_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`image` text,
`sms_prefix` varchar(50) NOT NULL,
`info` text NOT NULL,
PRIMARY KEY (`gift_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
CREATE TABLE IF NOT EXISTS `gifts_user` (
`gift_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`gift_ot` int(11) NOT NULL,
`gift_to` int(11) NOT NULL,
`gift_time` int(11) unsigned NOT NULL,
PRIMARY KEY (`gift_id`),
KEY `gift_time` (`gift_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;