View file mail/mail.sql

ALTER TABLE `mail` ADD COLUMN `attachments` SET('0','1') NOT NULL DEFAULT '0';
ALTER TABLE `user` ADD COLUMN `vkTypingId` INT(11) DEFAULT NULL;
ALTER TABLE `user` ADD COLUMN `vkTypingLastTime` INT(11) DEFAULT NULL;
CREATE TABLE `mail_files_vk` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`id_user` INT(11) NOT NULL,
	`id_kont` INT(11) NOT NULL,
	`id_mail` INT(11) NULL DEFAULT '0',
	`time` INT(11) NOT NULL,
	`action` SET('sent','prepare') NOT NULL DEFAULT 'prepare',
	`name` VARCHAR(512) NOT NULL,
	`tmp_name` VARCHAR(512) NOT NULL,
	`extension` VARCHAR(36) NOT NULL,
	`folder` VARCHAR(36) NOT NULL,
	`type` VARCHAR(64) NOT NULL,
	`size` INT(11) NOT NULL,
	PRIMARY KEY (`id`),
	INDEX `id_user` (`id_user`),
	INDEX `id_mail` (`id_mail`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
AUTO_INCREMENT=0;
CREATE TABLE `mail_important` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`id_user` INT(11) NULL DEFAULT NULL,
	`id_kont` INT(11) NULL DEFAULT NULL,
	`id_mail` INT(11) NULL DEFAULT '0',
	PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
AUTO_INCREMENT=0;