Просмотр архива Почта как на Spaces v.2.0

ALTER TABLE mail DROP INDEX id_user;
ALTER TABLE `mail` CHANGE `id_user`
`id_user` VARCHAR( 512 ) NOT NULL;
ALTER TABLE `mail` CHANGE `id_kont`
`id_kont` VARCHAR( 512 ) NOT NULL;
ALTER TABLE `mail` CHANGE `msg` `msg`
VARCHAR( 10240 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT
NULL;
ALTER TABLE `mail` CHANGE `unlink` `deleted` INT( 1 ) NOT NULL
DEFAULT '0';
ALTER TABLE `mail` ADD `type` varchar(512) DEFAULT
'personal';
ALTER TABLE `mail` ADD `attachments` int(1) DEFAULT
'0';
ALTER TABLE `mail` ADD `flaggedTo` varchar(11) DEFAULT 'inbox'
COMMENT 'inbox|deleted|spam|archive|favorite';
ALTER TABLE `mail` ADD
`flaggedFrom` varchar(11) DEFAULT 'inbox' COMMENT
'inbox|deleted|spam|archive|favorite';
alter table `user_set` add
`email_on` int(1) default '1';
alter table `user_set` add `email_spam`
int(1) default '1';

DROP TABLE IF EXISTS  `mail_files`;

CREATE TABLE
IF NOT EXISTS `mail_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`name` varchar(512) NOT NULL,
  `md5` varchar(512) NOT NULL,
  `id_user`
varchar(512) NOT NULL,
  `id_kont` varchar(512) NOT NULL,
  `ras`
varchar(36) NOT NULL,
  `type` varchar(64) NOT NULL,
  `size` int(11) NOT
NULL,
  `email_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE =
MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;