Просмотр архива CooL socka

CREATE TABLE IF NOT EXISTS `status` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `msg` varchar(1024) NOT NULL,
  `id_user` int(11) NOT
NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `status_komm` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `msg` varchar(1024) NOT NULL,
 
`id_user` int(11) NOT NULL,
  `id_status` int(11) NOT NULL,
  `time`
int(11) NOT NULL,
  `act` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT
EXISTS `status_rating` (
  `id_user` int(11) NOT NULL,
  `id_status`
int(11) NOT NULL,
  `rating` int(11) NOT NULL DEFAULT '0',
  KEY
`id_user` (`id_user`,`id_status`),
  KEY `rating` (`rating`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;