CREATE TABLE IF NOT EXISTS `mail_konts` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`id_kont` int(11) NOT NULL,
`time` int(11) NOT NULL,
`type` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
UNIQUE KEY `id_user` (`id_user`,`id_kont`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS `mail_msg` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`id_kont` int(11) NOT NULL,
`time` int(11) NOT NULL,
`from` varchar(20) NOT NULL,
`from_out` varchar(20) NOT NULL,
`tema` varchar(100) NOT NULL,
`msg` varchar(1024) NOT NULL,
`count` int(11) NOT NULL,
`timeedit` int(11) NOT NULL,
`read` tinyint(1) NOT NULL DEFAULT '1',
`sys` tinyint(1) NOT NULL DEFAULT '1',
`delete` int(11) NOT NULL,
`file` varchar(100) NOT NULL,
`spam` tinyint(1) NOT NULL DEFAULT '1',
`ip` int(11) NOT NULL,
`ua` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_user` (`id_user`,`id_kont`),
KEY `read` (`read`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;