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


CREATE TABLE `mail` (
  `id` int(11) NOT NULL auto_increment,
  `id_user`
int(11) NOT NULL,
  `id_kont` int(11) NOT NULL,
  `time` int(11) NOT NULL,

 `msg` varchar(10024) NOT NULL,
  `read` set('0','1') NOT NULL default
'0',
  PRIMARY KEY  (`id`),
  KEY `id_user` (`id_user`,`id_kont`),
  KEY
`read` (`read`)
) 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;