Просмотр архива [GlobalCMS] Основа чата

CREATE TABLE `chat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid`
int(11) NOT NULL,
  `tip` int(2) NOT NULL,
  `yasort` int(2) NOT NULL,
 
`name` text NOT NULL,
  `topik` text NOT NULL,
  `time` int(11) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
AUTO_INCREMENT=1;

CREATE TABLE `chat_post` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `room` int(11) NOT NULL,
  `yaid` varchar(12) NOT
NULL,
  `tip` int(2) NOT NULL,
  `text` text NOT NULL,
  `time` int(11)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
AUTO_INCREMENT=1;

ALTER TABLE  `users` ADD  `chat_posts` INT(11) NOT
NULL;