Просмотр архива Dcms-Social


CREATE TABLE IF NOT EXISTS `gifts_user` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `id_ank` int(11) NOT NULL,

 `id_gift` int(11) NOT NULL,
  `anonim` int(11) NOT NULL,
  `time` int(11)
NOT NULL,
  `coment` varchar(150) NOT NULL,
  `status` int(1) DEFAULT '0',

 PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `gift_categories` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
;

CREATE TABLE IF NOT EXISTS `gift_list` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_category` int(11) NOT NULL,
  `name` varchar(128) NOT
NULL,
  `money` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM 
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;