Просмотр архива Опросы пользователей v1.0


  alter table `frends` add `lenta_poll` int(1) DEFAULT '1';
  alter table
`frends` add `lenta_poll_like` int(1) DEFAULT '1';
  alter table `frends`
add `lenta_poll_vote` int(1) DEFAULT '1';
 
  alter table `tape_set` add
`lenta_poll` int(1) DEFAULT '1';
  alter table `tape_set` add
`lenta_poll_like` int(1) DEFAULT '1';
  alter table `tape_set` add
`lenta_poll_vote` int(1) DEFAULT '1';
 
CREATE TABLE IF NOT EXISTS `poll`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg` mediumtext,
  `time`
int(11) NOT NULL,
  `id_user` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
 
KEY `time` (`time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `poll_like` (
  `id_poll`
int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `like` int(11) DEFAULT
'0',
  KEY `id_notes` (`id_poll`,`id_user`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `poll_variant` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `id_poll` int(11) NOT NULL,
  `num` int(11) NOT
NULL,
  `otvet` varchar(125) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS
`poll_votes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11)
NOT NULL,
  `id_poll` int(11) NOT NULL,
  `id_otvet` int(11) NOT NULL,
 
`time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1;