View file sql.txt

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 ;