08-06-25, 02:42 PM
https://www.kost.su
Code:
-- Структура таблицы `admin`
--
CREATE TABLE IF NOT EXISTS `admin` (
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`superadmin` tinyint(1) NOT NULL DEFAULT 0,
`name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
`language` varchar(5) CHARACTER SET utf8 NOT NULL DEFAULT '',
`passwordlastchange` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
`settings` text CHARACTER SET utf8 DEFAULT NULL,
`created` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`modified` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`expired` datetime NOT NULL DEFAULT '9999-12-31 00:00:00',
`active` tinyint(1) NOT NULL DEFAULT 1,
`phone` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '',
`email_other` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
`token` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
`token_validity` datetime NOT NULL DEFAULT '2000-01-01 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Дамп данных таблицы `admin`
--
INSERT INTO `admin` (`username`, `password`, `superadmin`, `name`, `language`, `passwordlastchange`, `settings`, `created`, `modified`, `expired`, `active`, `phone`, `email_other`, `token`, `token_validity`) VALUES
('kost@kost.su', '$1$87ca345f$Gxw3V0NNRnAQXn48e4eis1', 1, '', '', '1970-01-01 01:01:01', NULL, '2019-08-08 12:30:00', '2019-08-15 10:50:16', '9999-12-31 00:00:00', 1, '', '', '', '2019-08-08 12:29:59');
-- --------------------------------------------------------
--
-- Структура таблицы `alias`
--
CREATE TABLE IF NOT EXISTS `alias` (
`address` varchar(255) NOT NULL,
`name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
`accesspolicy` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '',
`domain` varchar(255) NOT NULL,
`created` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`modified` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`expired` datetime NOT NULL DEFAULT '9999-12-31 00:00:00',
`active` tinyint(1) NOT NULL DEFAULT 1,
`goto` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Дамп данных таблицы `alias`
--
INSERT INTO `alias` (`address`, `name`, `accesspolicy`, `domain`, `created`, `modified`, `expired`, `active`, `goto`) VALUES
('abuse@kost.su', '', '', 'kost.su', '2019-08-08 12:32:51', '2019-08-08 12:32:51', '9999-12-31 00:00:00', 1, 'abuse@change-this-to-your.domain.tld'),
('hostmaster@kost.su', '', '', 'kost.su', '2019-08-08 12:32:51', '2019-08-08 12:32:51', '9999-12-31 00:00:00', 1, 'hostmaster@change-this-to-your.domain.tld'),
('kost@kost.su', '', '', 'kost.su', '2019-08-08 12:33:16', '2019-08-08 12:33:16', '9999-12-31 00:00:00', 1, 'kost@kost.su'),
('postmaster@kost.su', '', '', 'kost.su', '2019-08-08 12:32:51', '2019-08-08 12:32:51', '9999-12-31 00:00:00', 1, 'postmaster@change-this-to-your.domain.tld'),
('webmaster@kost.su', '', '', 'kost.su', '2019-08-08 12:32:51', '2019-08-08 12:32:51', '9999-12-31 00:00:00', 1, 'webmaster@change-this-to-your.domain.tld');
-- --------------------------------------------------------
--
-- Структура таблицы `alias_domain`
--
CREATE TABLE IF NOT EXISTS `alias_domain` (
`alias_domain` varchar(255) NOT NULL DEFAULT '',
`target_domain` varchar(255) NOT NULL DEFAULT '',
`created` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`modified` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Структура таблицы `anyone_shares`
--
CREATE TABLE IF NOT EXISTS `anyone_shares` (
`from_user` varchar(255) NOT NULL,
`dummy` char(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `config`
--
CREATE TABLE IF NOT EXISTS `config` (
`id` int(11) NOT NULL,
`name` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
`value` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT ''
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='PostfixAdmin settings';
--
-- Дамп данных таблицы `config`
--
INSERT INTO `config` (`id`, `name`, `value`) VALUES
(1, 'version', '1840');
-- --------------------------------------------------------
--
-- Структура таблицы `deleted_mailboxes`
--
CREATE TABLE IF NOT EXISTS `deleted_mailboxes` (
`id` bigint(20) unsigned NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
`username` varchar(255) NOT NULL DEFAULT '',
`domain` varchar(255) NOT NULL DEFAULT '',
`maildir` varchar(255) NOT NULL DEFAULT '',
`admin` varchar(255) NOT NULL DEFAULT '',
`delete_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `domain`
--
CREATE TABLE IF NOT EXISTS `domain` (
`domain` varchar(255) NOT NULL,
`description` varchar(255) CHARACTER SET utf8 NOT NULL,
`disclaimer` text CHARACTER SET utf8 DEFAULT NULL,
`aliases` int(10) NOT NULL DEFAULT 0,
`mailboxes` int(10) NOT NULL DEFAULT 0,
`maillists` int(10) NOT NULL DEFAULT 0,
`maxquota` bigint(20) NOT NULL DEFAULT 0,
`quota` bigint(20) NOT NULL DEFAULT 0,
`transport` varchar(255) NOT NULL,
`backupmx` tinyint(1) NOT NULL DEFAULT 0,
`settings` text CHARACTER SET utf8 DEFAULT NULL,
`created` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`modified` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`expired` datetime NOT NULL DEFAULT '9999-12-31 00:00:00',
`active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Дамп данных таблицы `domain`
--
INSERT INTO `domain` (`domain`, `description`, `disclaimer`, `aliases`, `mailboxes`, `maillists`, `maxquota`, `quota`, `transport`, `backupmx`, `settings`, `created`, `modified`, `expired`, `active`) VALUES
('ALL', '', NULL, 0, 0, 0, 0, 0, '', 0, NULL, '2018-10-15 16:29:16', '2018-10-15 16:29:16', '9999-12-31 00:00:00', 1),
('kost.su', '', NULL, 0, 0, 0, 10, 2048, 'virtual', 0, NULL, '2019-08-08 12:32:51', '2019-08-08 12:33:00', '9999-12-31 00:00:00', 1);
-- --------------------------------------------------------
--
-- Структура таблицы `domain_admins`
--
CREATE TABLE IF NOT EXISTS `domain_admins` (
`username` varchar(255) NOT NULL,
`domain` varchar(255) NOT NULL,
`created` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`modified` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
`expired` datetime NOT NULL DEFAULT '9999-12-31 00:00:00',
`active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Дамп данных таблицы `domain_admins`
--
INSERT INTO `domain_admins` (`username`, `domain`, `created`, `modified`, `expired`, `active`) VALUES
('kost@kost.su', 'ALL', '2019-08-08 12:30:00', '1970-01-01 01:01:01', '9999-12-31 00:00:00', 1);
-- --------------------------------------------------------
--
-- Структура таблицы `fetchmail`
--
CREATE TABLE IF NOT EXISTS `fetchmail` (
`id` int(11) unsigned NOT NULL,
`domain` varchar(255) DEFAULT '',
`mailbox` varchar(255) NOT NULL,
`src_server` varchar(255) NOT NULL,
`src_auth` enum('password','kerberos_v5','kerberos','kerberos_v4','gssapi','cram-md5','otp','ntlm','msn','ssh','any') CHARACTER SET utf8 DEFAULT NULL,
`src_user` varchar(255) NOT NULL,
`src_password` varchar(255) NOT NULL,
`src_folder` varchar(255) NOT NULL,
`poll_time` int(11) unsigned NOT NULL DEFAULT 10,
`fetchall` tinyint(1) unsigned NOT NULL DEFAULT 0,
`keep` tinyint(1) unsigned NOT NULL DEFAULT 0,
`protocol` enum('POP3','IMAP','POP2','ETRN','AUTO') CHARACTER SET utf8 DEFAULT NULL,
`usessl` tinyint(1) unsigned NOT NULL DEFAULT 0,
`sslcertck` tinyint(1) NOT NULL DEFAULT 0,
`sslcertpath` varchar(255) CHARACTER SET utf8 DEFAULT '',
`sslfingerprint` varchar(255) DEFAULT '',
`extra_options` text DEFAULT NULL,
`returned_text` text DEFAULT NULL,
`mda` varchar(255) NOT NULL,
`date` timestamp NOT NULL DEFAULT '1999-12-31 21:00:00',
`created` timestamp NOT NULL DEFAULT '1999-12-31 21:00:00',
`modified` timestamp NOT NULL DEFAULT current_timestamp(),
`active` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Структура таблицы `forwardings`
--
CREATE TABLE IF NOT EXISTS `forwardings` (
`id` bigint(20) unsigned NOT NULL,
`address` varchar(255) NOT NULL DEFAULT '',
`forwarding` varchar(255) NOT NULL DEFAULT '',
`domain` varchar(255) NOT NULL DEFAULT '',
`dest_domain` varchar(255) NOT NULL DEFAULT '',
`is_maillist` tinyint(1) NOT NULL DEFAULT 0,
`is_list` tinyint(1) NOT NULL DEFAULT 0,
`is_forwarding` tinyint(1) NOT NULL DEFAULT 0,
`is_alias` tinyint(1) NOT NULL DEFAULT 0,
`active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `log`
--
CREATE TABLE IF NOT EXISTS `log` (
`timestamp` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`username` varchar(255) NOT NULL,
`domain` varchar(255) NOT NULL,
`action` varchar(255) NOT NULL,
`data` text NOT NULL,
`id` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=436 DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Log';
--
-- Дамп данных таблицы `log`
--
INSERT INTO `log` (`timestamp`, `username`, `domain`, `action`, `data`, `id`) VALUES
('2019-08-15 10:50:16', 'kost@kost.su (10.101.220.10)', '', 'edit_admin', 'kost@kost.su', 435);
-- --------------------------------------------------------
--
-- Структура таблицы `mailbox`
--
CREATE TABLE IF NOT EXISTS `mailbox` (
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`name` varchar(255) CHARACTER SET utf8 NOT NULL,
`language` varchar(5) CHARACTER SET utf8 NOT NULL DEFAULT '',
`storagebasedirectory` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '/var/vmail',
`storagenode` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT 'vmail1',
`maildir` varchar(255) NOT NULL,
`quota` bigint(20) NOT NULL DEFAULT 0,
`local_part` varchar(255) NOT NULL,
`domain` varchar(255) NOT NULL,
`transport` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
`department` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
`rank` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT 'normal',
`employeeid` varchar(255) CHARACTER SET utf8 DEFAULT '',
`isadmin` tinyint(1) NOT NULL DEFAULT 0,
`isglobaladmin` tinyint(1) NOT NULL DEFAULT 0,
`enablesmtp` tinyint(1) NOT NULL DEFAULT 1,
`enablesmtpsecured` tinyint(1) NOT NULL DEFAULT 1,
`enablepop3` tinyint(1) NOT NULL DEFAULT 1,
`enablepop3secured` tinyint(1) NOT NULL DEFAULT 1,
`enablepop3tls` tinyint(1) NOT NULL DEFAULT 1,
`enableimap` tinyint(1) NOT NULL DEFAULT 1,
`enableimapsecured` tinyint(1) NOT NULL DEFAULT 1,
`enableimaptls` tinyint(1) NOT NULL DEFAULT 1,
`enabledeliver` tinyint(1) NOT NULL DEFAULT 1,
`enablelda` tinyint(1) NOT NULL DEFAULT 1,
`enablemanagesieve` tinyint(1) NOT NULL DEFAULT 1,
`enablemanagesievesecured` tinyint(1) NOT NULL DEFAULT 1,
`enablesieve` tinyint(1) NOT NULL DEFAULT 1,
`enablesievesecured` tinyint(1) NOT NULL DEFAULT 1,
`enablesievetls` tinyint(1) NOT NULL DEFAULT 1,
`enableinternal` tinyint(1) NOT NULL DEFAULT 1,
`enabledoveadm` tinyint(1) NOT NULL DEFAULT 1,
`enablelib-storage` tinyint(1) NOT NULL DEFAULT 1,
`enableindexer-worker` tinyint(1) NOT NULL DEFAULT 1,
`enablelmtp` tinyint(1) NOT NULL DEFAULT 1,
`enabledsync` tinyint(1) NOT NULL DEFAULT 1,
`enablesogo` tinyint(1) NOT NULL DEFAULT 1,
`allow_nets` text CHARACTER SET utf8 DEFAULT NULL,
`lastlogindate` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
`lastloginipv4` int(4) unsigned NOT NULL DEFAULT 0,
`lastloginprotocol` char(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
`disclaimer` text CHARACTER SET utf8 DEFAULT NULL,
`allowedsenders` text CHARACTER SET utf8 DEFAULT NULL,
`rejectedsenders` text CHARACTER SET utf8 DEFAULT NULL,
`allowedrecipients` text CHARACTER SET utf8 DEFAULT NULL,
`rejectedrecipients` text CHARACTER SET utf8 DEFAULT NULL,
`settings` text CHARACTER SET utf8 DEFAULT NULL,
`passwordlastchange` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
`created` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`modified` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`expired` datetime NOT NULL DEFAULT '9999-12-31 00:00:00',
`active` tinyint(1) NOT NULL DEFAULT 1,
`phone` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '',
`email_other` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
`token` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
`token_validity` datetime NOT NULL DEFAULT '2000-01-01 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Дамп данных таблицы `mailbox`
--
INSERT INTO `mailbox` (`username`, `password`, `name`, `language`, `storagebasedirectory`, `storagenode`, `maildir`, `quota`, `local_part`, `domain`, `transport`, `department`, `rank`, `employeeid`, `isadmin`, `isglobaladmin`, `enablesmtp`, `enablesmtpsecured`, `enablepop3`, `enablepop3secured`, `enablepop3tls`, `enableimap`, `enableimapsecured`, `enableimaptls`, `enabledeliver`, `enablelda`, `enablemanagesieve`, `enablemanagesievesecured`, `enablesieve`, `enablesievesecured`, `enablesievetls`, `enableinternal`, `enabledoveadm`, `enablelib-storage`, `enableindexer-worker`, `enablelmtp`, `enabledsync`, `enablesogo`, `allow_nets`, `lastlogindate`, `lastloginipv4`, `lastloginprotocol`, `disclaimer`, `allowedsenders`, `rejectedsenders`, `allowedrecipients`, `rejectedrecipients`, `settings`, `passwordlastchange`, `created`, `modified`, `expired`, `active`, `phone`, `email_other`, `token`, `token_validity`) VALUES
('kost@kost.su', '$1$c76e6255$c326kc/j1faTF17vRHYEK1', 'G7ba9to20', '', '/var/vmail', 'vmail1', 'kost.su/kost/', 0, 'kost', 'kost.su', '', '', 'normal', '', 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, '1970-01-01 01:01:01', 0, '', NULL, NULL, NULL, NULL, NULL, NULL, '1970-01-01 01:01:01', '2019-08-08 12:33:16', '2019-08-08 12:33:16', '9999-12-31 00:00:00', 1, '', '', '', '2019-08-08 12:33:16');
-- --------------------------------------------------------
--
-- Структура таблицы `maillists`
--
CREATE TABLE IF NOT EXISTS `maillists` (
`id` bigint(20) unsigned NOT NULL,
`address` varchar(255) NOT NULL DEFAULT '',
`domain` varchar(255) NOT NULL DEFAULT '',
`transport` varchar(255) NOT NULL DEFAULT '',
`accesspolicy` varchar(30) NOT NULL DEFAULT '',
`maxmsgsize` bigint(20) NOT NULL DEFAULT 0,
`name` varchar(255) NOT NULL DEFAULT '',
`description` text DEFAULT NULL,
`mlid` varchar(36) NOT NULL DEFAULT '',
`is_newsletter` tinyint(1) NOT NULL DEFAULT 0,
`settings` text DEFAULT NULL,
`created` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
`modified` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
`expired` datetime NOT NULL DEFAULT '9999-12-31 00:00:00',
`active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `moderators`
--
CREATE TABLE IF NOT EXISTS `moderators` (
`id` bigint(20) unsigned NOT NULL,
`address` varchar(255) NOT NULL DEFAULT '',
`moderator` varchar(255) NOT NULL DEFAULT '',
`domain` varchar(255) NOT NULL DEFAULT '',
`dest_domain` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `quota`
--
CREATE TABLE IF NOT EXISTS `quota` (
`username` varchar(255) CHARACTER SET latin1 NOT NULL,
`path` varchar(100) CHARACTER SET latin1 NOT NULL,
`current` bigint(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `quota2`
--
CREATE TABLE IF NOT EXISTS `quota2` (
`username` varchar(100) CHARACTER SET latin1 NOT NULL,
`bytes` bigint(20) NOT NULL DEFAULT 0,
`messages` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `recipient_bcc_domain`
--
CREATE TABLE IF NOT EXISTS `recipient_bcc_domain` (
`domain` varchar(255) NOT NULL DEFAULT '',
`bcc_address` varchar(255) NOT NULL DEFAULT '',
`created` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
`modified` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
`expired` datetime NOT NULL DEFAULT '9999-12-31 00:00:00',
`active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `recipient_bcc_user`
--
CREATE TABLE IF NOT EXISTS `recipient_bcc_user` (
`username` varchar(255) NOT NULL DEFAULT '',
`bcc_address` varchar(255) NOT NULL DEFAULT '',
`domain` varchar(255) NOT NULL DEFAULT '',
`created` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
`modified` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
`expired` datetime NOT NULL DEFAULT '9999-12-31 00:00:00',
`active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `sender_bcc_domain`
--
CREATE TABLE IF NOT EXISTS `sender_bcc_domain` (
`domain` varchar(255) NOT NULL DEFAULT '',
`bcc_address` varchar(255) NOT NULL DEFAULT '',
`created` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
`modified` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
`expired` datetime NOT NULL DEFAULT '9999-12-31 00:00:00',
`active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `sender_bcc_user`
--
CREATE TABLE IF NOT EXISTS `sender_bcc_user` (
`username` varchar(255) NOT NULL DEFAULT '',
`bcc_address` varchar(255) NOT NULL DEFAULT '',
`domain` varchar(255) NOT NULL DEFAULT '',
`created` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
`modified` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
`expired` datetime NOT NULL DEFAULT '9999-12-31 00:00:00',
`active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `sender_relayhost`
--
CREATE TABLE IF NOT EXISTS `sender_relayhost` (
`id` bigint(20) unsigned NOT NULL,
`account` varchar(255) NOT NULL DEFAULT '',
`relayhost` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `share_folder`
--
CREATE TABLE IF NOT EXISTS `share_folder` (
`from_user` varchar(255) CHARACTER SET ascii NOT NULL,
`to_user` varchar(255) CHARACTER SET ascii NOT NULL,
`dummy` char(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `used_quota`
--
CREATE TABLE IF NOT EXISTS `used_quota` (
`username` varchar(255) NOT NULL,
`bytes` bigint(20) NOT NULL DEFAULT 0,
`messages` bigint(20) NOT NULL DEFAULT 0,
`domain` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `used_quota`
--
INSERT INTO `used_quota` (`username`, `bytes`, `messages`, `domain`) VALUES
('kost@kost.su', 20038293, 58, 'kost.su');
--
-- Триггеры `used_quota`
--
DELIMITER $$
CREATE TRIGGER `used_quota_before_insert` BEFORE INSERT ON `used_quota`
FOR EACH ROW BEGIN
SET NEW.domain = SUBSTRING_INDEX(NEW.username, '@', -1);
END
$$
DELIMITER ;
-- --------------------------------------------------------
--
-- Структура таблицы `vacation`
--
CREATE TABLE IF NOT EXISTS `vacation` (
`email` varchar(255) NOT NULL,
`subject` varchar(255) NOT NULL,
`body` text NOT NULL,
`activefrom` timestamp NOT NULL DEFAULT '1999-12-31 21:00:00',
`activeuntil` timestamp NOT NULL DEFAULT '2038-01-17 21:00:00',
`cache` text NOT NULL,
`domain` varchar(255) NOT NULL,
`interval_time` int(11) NOT NULL DEFAULT 0,
`created` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`modified` timestamp NOT NULL DEFAULT current_timestamp(),
`active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Vacation';
-- --------------------------------------------------------
--
-- Структура таблицы `vacation_notification`
--
CREATE TABLE IF NOT EXISTS `vacation_notification` (
`on_vacation` varchar(255) CHARACTER SET latin1 NOT NULL,
`notified` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
`notified_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Postfix Admin - Virtual Vacation Notifications';
--
-- Индексы сохранённых таблиц
--
--
-- Индексы таблицы `admin`
--
ALTER TABLE `admin`
ADD PRIMARY KEY (`username`),
ADD KEY `passwordlastchange` (`passwordlastchange`),
ADD KEY `expired` (`expired`),
ADD KEY `active` (`active`);
--
-- Индексы таблицы `alias`
--
ALTER TABLE `alias`
ADD PRIMARY KEY (`address`),
ADD KEY `expired` (`expired`),
ADD KEY `active` (`active`),
ADD KEY `domain` (`domain`);
--
-- Индексы таблицы `alias_domain`
--
ALTER TABLE `alias_domain`
ADD PRIMARY KEY (`alias_domain`),
ADD KEY `target_domain` (`target_domain`),
ADD KEY `active` (`active`);
--
-- Индексы таблицы `anyone_shares`
--
ALTER TABLE `anyone_shares`
ADD PRIMARY KEY (`from_user`);
--
-- Индексы таблицы `config`
--
ALTER TABLE `config`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `name` (`name`);
--
-- Индексы таблицы `deleted_mailboxes`
--
ALTER TABLE `deleted_mailboxes`
ADD KEY `id` (`id`),
ADD KEY `timestamp` (`timestamp`),
ADD KEY `username` (`username`),
ADD KEY `domain` (`domain`),
ADD KEY `admin` (`admin`),
ADD KEY `delete_date` (`delete_date`);
--
-- Индексы таблицы `domain`
--
ALTER TABLE `domain`
ADD PRIMARY KEY (`domain`),
ADD KEY `backupmx` (`backupmx`),
ADD KEY `expired` (`expired`),
ADD KEY `active` (`active`);
--
-- Индексы таблицы `domain_admins`
--
ALTER TABLE `domain_admins`
ADD PRIMARY KEY (`username`,`domain`),
ADD KEY `username` (`username`),
ADD KEY `domain` (`domain`),
ADD KEY `active` (`active`);
--
-- Индексы таблицы `fetchmail`
--
ALTER TABLE `fetchmail`
ADD PRIMARY KEY (`id`);
--
-- Индексы таблицы `forwardings`
--
ALTER TABLE `forwardings`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `address` (`address`,`forwarding`),
ADD KEY `domain` (`domain`),
ADD KEY `dest_domain` (`dest_domain`),
ADD KEY `is_maillist` (`is_maillist`),
ADD KEY `is_list` (`is_list`),
ADD KEY `is_alias` (`is_alias`);
--
-- Индексы таблицы `log`
--
ALTER TABLE `log`
ADD PRIMARY KEY (`id`),
ADD KEY `timestamp` (`timestamp`),
ADD KEY `domain_timestamp` (`domain`,`timestamp`);
--
-- Индексы таблицы `mailbox`
--
ALTER TABLE `mailbox`
ADD PRIMARY KEY (`username`),
ADD KEY `department` (`department`),
ADD KEY `employeeid` (`employeeid`),
ADD KEY `isadmin` (`isadmin`),
ADD KEY `isglobaladmin` (`isglobaladmin`),
ADD KEY `enablesmtp` (`enablesmtp`),
ADD KEY `enablesmtpsecured` (`enablesmtpsecured`),
ADD KEY `enablepop3` (`enablepop3`),
ADD KEY `enablepop3secured` (`enablepop3secured`),
ADD KEY `enableimap` (`enableimap`),
ADD KEY `enableimapsecured` (`enableimapsecured`),
ADD KEY `enableimaptls` (`enableimaptls`),
ADD KEY `enablepop3tls` (`enablepop3tls`),
ADD KEY `enablesievetls` (`enablesievetls`),
ADD KEY `enabledeliver` (`enabledeliver`),
ADD KEY `enablelda` (`enablelda`),
ADD KEY `enablemanagesieve` (`enablemanagesieve`),
ADD KEY `enablemanagesievesecured` (`enablemanagesievesecured`),
ADD KEY `enablesieve` (`enablesieve`),
ADD KEY `enablesievesecured` (`enablesievesecured`),
ADD KEY `enablelmtp` (`enablelmtp`),
ADD KEY `enableinternal` (`enableinternal`),
ADD KEY `enabledoveadm` (`enabledoveadm`),
ADD KEY `enablelib-storage` (`enablelib-storage`),
ADD KEY `enableindexer-worker` (`enableindexer-worker`),
ADD KEY `enabledsync` (`enabledsync`),
ADD KEY `enablesogo` (`enablesogo`),
ADD KEY `passwordlastchange` (`passwordlastchange`),
ADD KEY `expired` (`expired`),
ADD KEY `active` (`active`),
ADD KEY `domain` (`domain`);
--
-- Индексы таблицы `maillists`
--
ALTER TABLE `maillists`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `address` (`address`),
ADD UNIQUE KEY `mlid` (`mlid`),
ADD KEY `is_newsletter` (`is_newsletter`),
ADD KEY `domain` (`domain`),
ADD KEY `active` (`active`);
--
-- Индексы таблицы `moderators`
--
ALTER TABLE `moderators`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `address` (`address`,`moderator`),
ADD KEY `domain` (`domain`),
ADD KEY `dest_domain` (`dest_domain`);
--
-- Индексы таблицы `quota`
--
ALTER TABLE `quota`
ADD PRIMARY KEY (`username`,`path`);
--
-- Индексы таблицы `quota2`
--
ALTER TABLE `quota2`
ADD PRIMARY KEY (`username`);
--
-- Индексы таблицы `recipient_bcc_domain`
--
ALTER TABLE `recipient_bcc_domain`
ADD PRIMARY KEY (`domain`),
ADD KEY `bcc_address` (`bcc_address`),
ADD KEY `expired` (`expired`),
ADD KEY `active` (`active`);
--
-- Индексы таблицы `recipient_bcc_user`
--
ALTER TABLE `recipient_bcc_user`
ADD PRIMARY KEY (`username`),
ADD KEY `bcc_address` (`bcc_address`),
ADD KEY `expired` (`expired`),
ADD KEY `active` (`active`);
--
-- Индексы таблицы `sender_bcc_domain`
--
ALTER TABLE `sender_bcc_domain`
ADD PRIMARY KEY (`domain`),
ADD KEY `bcc_address` (`bcc_address`),
ADD KEY `expired` (`expired`),
ADD KEY `active` (`active`);
--
-- Индексы таблицы `sender_bcc_user`
--
ALTER TABLE `sender_bcc_user`
ADD PRIMARY KEY (`username`),
ADD KEY `bcc_address` (`bcc_address`),
ADD KEY `domain` (`domain`),
ADD KEY `expired` (`expired`),
ADD KEY `active` (`active`);
--
-- Индексы таблицы `sender_relayhost`
--
ALTER TABLE `sender_relayhost`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `account` (`account`);
--
-- Индексы таблицы `share_folder`
--
ALTER TABLE `share_folder`
ADD PRIMARY KEY (`from_user`,`to_user`),
ADD KEY `from_user` (`from_user`),
ADD KEY `to_user` (`to_user`);
--
-- Индексы таблицы `used_quota`
--
ALTER TABLE `used_quota`
ADD PRIMARY KEY (`username`),
ADD KEY `domain` (`domain`);
--
-- Индексы таблицы `vacation`
--
ALTER TABLE `vacation`
ADD PRIMARY KEY (`email`),
ADD KEY `email` (`email`);
--
-- Индексы таблицы `vacation_notification`
--
ALTER TABLE `vacation_notification`
ADD PRIMARY KEY (`on_vacation`,`notified`);
--
-- AUTO_INCREMENT для сохранённых таблиц
--
--
-- AUTO_INCREMENT для таблицы `config`
--
ALTER TABLE `config`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT для таблицы `deleted_mailboxes`
--
ALTER TABLE `deleted_mailboxes`
MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT для таблицы `fetchmail`
--
ALTER TABLE `fetchmail`
MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT для таблицы `forwardings`
--
ALTER TABLE `forwardings`
MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT для таблицы `log`
--
ALTER TABLE `log`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=436;
--
-- AUTO_INCREMENT для таблицы `maillists`
--
ALTER TABLE `maillists`
MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT для таблицы `moderators`
--
ALTER TABLE `moderators`
MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT для таблицы `sender_relayhost`
--
ALTER TABLE `sender_relayhost`
MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
--
-- Ограничения внешнего ключа сохраненных таблиц
--
--
-- Ограничения внешнего ключа таблицы `vacation_notification`
--
ALTER TABLE `vacation_notification`
ADD CONSTRAINT `vacation_notification_pkey` FOREIGN KEY (`on_vacation`) REFERENCES `vacation` (`email`) ON DELETE CASCADE;
