Просмотр архива vipp

ALTER TABLE `user` ADD `present_p` int(11) NOT NULL DEFAULT '0';
ALTER
TABLE `user` ADD `present_pp` int(11) NOT NULL DEFAULT '0';
ALTER TABLE
`user` ADD `present_p_d` int(11) NOT NULL DEFAULT '0';


CREATE TABLE IF
NOT EXISTS `presents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel`
int(11) NOT NULL default '0',
  `name` varchar(128) NOT NULL,
  `money`
int(11) NOT NULL,
  `money_yes` int(11) NOT NULL default '0',
  `balls`
int(11) NOT NULL,
  `balls_yes` int(11) NOT NULL default '0',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


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


CREATE TABLE IF NOT
EXISTS `user_presents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`id_user` int(11) NOT NULL default '0',
  `id_ank` int(11) NOT NULL default
'0',
  `prezent` int(11) NOT NULL default '0',
  `razdel` int(11) NOT NULL
default '0',
  `privat` int(11) NOT NULL default '0',
  `komment`
varchar(128) NOT NULL,
  `do` int(11) NOT NULL,
  `time` int(11) NOT NULL,

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