Просмотр архива DCMS-SPECIAL 4.6

CREATE TABLE IF NOT EXISTS `dnev` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `name` varchar(32) NOT
NULL,
  `msg` varchar(5000) NOT NULL,
  `read` enum('0','1','2') NOT NULL,

 `write` enum('0','1','2') NOT NULL,
  `time` int(11) NOT NULL,
  `komm`
int(11) DEFAULT '0',
  `look` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;



CREATE TABLE IF
NOT EXISTS `dnev_kom` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_dnev`
int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `msg` varchar(1000) NOT
NULL,
  `otv` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `hide`
enum('0','1') DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8 AUTO_INCREMENT=113 ;



CREATE TABLE IF NOT EXISTS `dnev_look`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_dnev` int(11) NOT NULL,
 
`id_user` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=170 ;