Просмотр архива DCMS S


CREATE TABLE IF NOT EXISTS `mail` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
  `id_cont` int(11)
DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `msg` varchar(1024) DEFAULT
NULL,
  `read` enum('0','1') DEFAULT '0',
  `type` enum('at','to') DEFAULT
'to',
  `favorite` enum('0','1') DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS
`mail_conts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11)
DEFAULT '0',
  `id_ank` int(11) DEFAULT '0',
  `time` int(11) DEFAULT '0',

 `nick` varchar(1024) DEFAULT NULL,
  `type`
enum('all','favorite','arhive','trash') DEFAULT 'all',
  `time_last`
int(11) DEFAULT '0',
  `count` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS
`mail_to_send` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mail`
varchar(64) NOT NULL,
  `them` varchar(32) NOT NULL,
  `msg` varchar(1000)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;