Просмотр архива DCMS Special v 7.3.0

CREATE TABLE IF NOT EXISTS `gifts` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
  `id_kont` int(11)
DEFAULT NULL,
  `id_gift` int(11) DEFAULT NULL,
  `time` int(11) DEFAULT
NULL,
  `read` set('0','1') DEFAULT '0',
  `msg` varchar(1024) DEFAULT
NULL,
  `type` enum('1','2','3') DEFAULT '1',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gift_cat`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(1024) DEFAULT
NULL,
  `show` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gift` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(1024) DEFAULT NULL,

 `image` varchar(1024) DEFAULT NULL,
  `cena` int(11) DEFAULT '0',
 
`id_cat` int(11) DEFAULT '0',
  `balls` int(11) DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;