Просмотр архива соц.сеть gefan.ru

CREATE TABLE IF NOT EXISTS `vid` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `refid` int(11) NOT NULL,
  `iduser` int(11) NOT
NULL,
  `login` text NOT NULL,
  `text` text NOT NULL,
  `data` int(11)
NOT NULL,
  `name` text NOT NULL,
  `count` int(11) NOT NULL,
  `opis`
text NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `opis` (`opis`),
 
FULLTEXT KEY `opis_2` (`opis`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `kat` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `refid` int(11) NOT NULL,
  `type`
text NOT NULL,
  `data` int(11) NOT NULL,
  `text` text NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;



CREATE TABLE IF NOT EXISTS `komvid` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `refid` int(11) NOT NULL,
  `iduser` int(11) NOT
NULL,
  `text` varchar(1000) NOT NULL,
  `data` int(11) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS
`viduser` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idvid` int(11) NOT
NULL,
  `iduser` int(11) NOT NULL,
  `do` int(11) NOT NULL,
  `komm`
text NOT NULL,
  `data` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;