Просмотр архива DCMS Special 6.1.0 beta

CREATE TABLE IF NOT EXISTS `diary` (
  `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;

CREATE TABLE IF NOT EXISTS
`diary_komm` (
  `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;

CREATE TABLE IF NOT EXISTS `diary_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;