Plesk

[janpio]

@schickling suggested we also look at the Plesk schema

[schickling]

Was more of a joke - but sure 🤷‍♂

[divyenduz]

I could only find the ER Diagram for it: https://docs.plesk.com/en-US/obsidian/api-read-me-first/75240/

Note for future exploration: https://github.com/plesk?utf8=%E2%9C%93&q=&type=&language=php

[divyenduz]

I couldn't find the SQL, @janpio if you are able to, please re-assign me.

[janpio]

Links to https://github.com/plesk/db-schemas

The ERD can be used to export the SQL:

-- MySQL Script generated by MySQL Workbench
-- Sun Feb  9 21:41:04 2020
-- Model: New Model    Version: 1.0
-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Table `APSApplicationItems`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `APSApplicationItems` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `pkg_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `license_type_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `disabled` ENUM('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `license_type_id` (`license_type_id` ASC, `pkg_id` ASC) VISIBLE,
  INDEX `pkg_id` (`pkg_id` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `APSCatalogUpdates`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `APSCatalogUpdates` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `package_name` VARCHAR(255) NULL DEFAULT NULL,
  `package_version` VARCHAR(30) NULL DEFAULT NULL,
  `package_release` VARCHAR(30) NULL DEFAULT NULL,
  `update_name` VARCHAR(255) NULL DEFAULT NULL,
  `update_version` VARCHAR(30) NULL DEFAULT NULL,
  `update_release` VARCHAR(30) NULL DEFAULT NULL,
  `update_vendor` VARCHAR(255) NULL DEFAULT NULL,
  `update_packager` VARCHAR(255) NULL DEFAULT NULL,
  `received` DATETIME NULL DEFAULT '0000-00-00 00:00:00',
  `update_type` ENUM('patch','upgrade') NOT NULL DEFAULT 'patch',
  `recommended` ENUM('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `APSClientApplicationItems`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `APSClientApplicationItems` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `client_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `app_item_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `instances_limit` INT(11) NOT NULL DEFAULT '-1',
  `broadcast` ENUM('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `client_app_item` (`client_id` ASC, `app_item_id` ASC) VISIBLE,
  INDEX `client_id` (`client_id` ASC) VISIBLE,
  INDEX `app_item_id` (`app_item_id` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `APSLicenseTypes`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `APSLicenseTypes` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `application_name` VARCHAR(255) NOT NULL,
  `application_versions` VARCHAR(255) NOT NULL,
  `application_features` VARCHAR(255) NOT NULL,
  `description` VARCHAR(255) NULL DEFAULT NULL,
  `license_type_hash` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `license_type_hash` (`license_type_hash` ASC) VISIBLE,
  UNIQUE INDEX `application_name` (`application_name` ASC, `application_versions` ASC, `application_features` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `APSLicenses`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `APSLicenses` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `license_type_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `key_number` VARCHAR(255) NOT NULL,
  `source` TEXT NULL DEFAULT NULL,
  `ka_url` VARCHAR(255) NOT NULL,
  `expiration_date` DATE NULL DEFAULT NULL,
  `update_date` DATE NULL DEFAULT NULL,
  `personal` ENUM('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `key_number` (`key_number` ASC) VISIBLE,
  INDEX `license_type_id` (`license_type_id` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ApiRpcCallsStat`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ApiRpcCallsStat` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `Version` VARCHAR(7) NOT NULL,
  `Operator` VARCHAR(50) NOT NULL,
  `Command` VARCHAR(50) NOT NULL,
  `Session` VARCHAR(8) NOT NULL DEFAULT '0',
  `FilterName` VARCHAR(50) NOT NULL DEFAULT '0',
  `GroupOperation` INT(11) NOT NULL DEFAULT '0',
  `LastExecutionDate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `LogItem` (`Version` ASC, `Operator` ASC, `Command` ASC, `Session` ASC, `FilterName` ASC, `GroupOperation` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ApsTokens`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ApsTokens` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `subscriptionId` INT(10) UNSIGNED NOT NULL,
  `applicationId` VARCHAR(2000) NOT NULL,
  `instanceId` INT(10) UNSIGNED NULL DEFAULT NULL,
  `token` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `BackendCache`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BackendCache` (
  `key` VARCHAR(128) NOT NULL,
  `data` TEXT NOT NULL,
  PRIMARY KEY (`key`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `BackupExcludeFiles`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BackupExcludeFiles` (
  `id` INT UNSIGNED NOT NULL,
  `files` TEXT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `BackupsScheduled`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BackupsScheduled` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `obj_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `obj_type` ENUM('server','reseller','client','domain') NOT NULL,
  `repository` ENUM('local', 'ftp', 'ext', 'local-and-ext') NOT NULL DEFAULT 'local',
  `last` DATETIME NULL DEFAULT NULL,
  `period` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `active` ENUM('false','true') NOT NULL,
  `processed` ENUM('false','true') NOT NULL,
  `rotation` INT(11) NOT NULL DEFAULT '0',
  `prefix` VARCHAR(255) NULL DEFAULT NULL,
  `email` VARCHAR(255) NULL DEFAULT NULL,
  `split_size` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `suspend` ENUM('false','true') NOT NULL DEFAULT 'false',
  `with_content` ENUM('false','true') NOT NULL DEFAULT 'true',
  `backup_day` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `backup_time` VARCHAR(8) NOT NULL DEFAULT '00:00:00',
  `content_type` ENUM('backup_content_all_at_domain','backup_content_vhost_only','backup_content_mail_only') NOT NULL DEFAULT 'backup_content_all_at_domain',
  `full_backup_period` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `mssql_native_backup` INT(11) NOT NULL DEFAULT '1',
  `backupExcludeFilesId` INT UNSIGNED NULL,
  `backupExcludeLogs` INT(1) NOT NULL DEFAULT 0,
  `remoteStorage` VARCHAR(255) NULL,
  PRIMARY KEY (`id`),
  INDEX `backupExcludeFilesId_idx` (`backupExcludeFilesId` ASC) VISIBLE,
  CONSTRAINT `backupExcludeFilesId`
    FOREIGN KEY (`backupExcludeFilesId`)
    REFERENCES `BackupExcludeFiles` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `BackupsSettings`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BackupsSettings` (
  `id` INT(10) UNSIGNED NULL DEFAULT NULL,
  `type` ENUM('domain','client','server') NOT NULL DEFAULT 'domain',
  `param` VARCHAR(255) NOT NULL,
  `value` VARCHAR(255) NULL DEFAULT NULL,
  UNIQUE INDEX `id` (`id` ASC, `type` ASC, `param` ASC))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `BlUpgradeActions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BlUpgradeActions` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `action` VARCHAR(255) NOT NULL,
  `status` ENUM('new','error','skip','success') NOT NULL DEFAULT 'new',
  `message` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `BlUpgrades`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BlUpgrades` (
  `id` VARCHAR(255) NOT NULL,
  `status` ENUM('new','fatal','optional','success') NOT NULL DEFAULT 'new',
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `Cards`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Cards` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `personalName` VARCHAR(255) NOT NULL,
  `companyName` VARCHAR(255) NULL DEFAULT NULL,
  `phone` VARCHAR(255) NULL DEFAULT NULL,
  `fax` VARCHAR(255) NULL DEFAULT NULL,
  `email` VARCHAR(255) NULL DEFAULT NULL,
  `address` VARCHAR(255) NULL DEFAULT NULL,
  `city` VARCHAR(255) NULL DEFAULT NULL,
  `state` VARCHAR(255) NULL DEFAULT NULL,
  `zip` VARCHAR(10) NULL DEFAULT NULL,
  `country` VARCHAR(2) NULL DEFAULT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `accounts`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `accounts` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` VARCHAR(32) NOT NULL DEFAULT 'plain',
  `password` TEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `Limits`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Limits` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `limit_name` VARCHAR(255) NOT NULL,
  `value` BIGINT(20) NULL DEFAULT NULL,
  PRIMARY KEY (`id`, `limit_name`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `Permissions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Permissions` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `permission` VARCHAR(255) NOT NULL,
  `value` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`, `permission`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `certificates`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `certificates` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `csr` BLOB NULL DEFAULT NULL,
  `pvt_key` BLOB NULL DEFAULT NULL,
  `cert` BLOB NULL DEFAULT NULL,
  `cert_file` VARCHAR(255) NOT NULL,
  `ca_cert` BLOB NULL DEFAULT NULL,
  `ca_file` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `dns_zone`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `dns_zone` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `displayName` VARCHAR(255) NOT NULL,
  `email` VARCHAR(255) NULL DEFAULT NULL,
  `status` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` ENUM('slave','master') NOT NULL DEFAULT 'master',
  `ttl` INT(10) UNSIGNED NOT NULL DEFAULT '86400',
  `ttl_unit` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `refresh` INT(10) UNSIGNED NOT NULL DEFAULT '10800',
  `refresh_unit` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `retry` INT(10) UNSIGNED NOT NULL DEFAULT '3600',
  `retry_unit` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `expire` INT(10) UNSIGNED NOT NULL DEFAULT '604800',
  `expire_unit` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `minimum` INT(10) UNSIGNED NOT NULL DEFAULT '10800',
  `minimum_unit` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `serial_format` ENUM('UNIXTIMESTAMP','YYYYMMDDNN') NOT NULL DEFAULT 'UNIXTIMESTAMP',
  `serial` VARCHAR(12) NOT NULL DEFAULT '0',
  `external_id` VARCHAR(255) NULL DEFAULT NULL,
  `syncSoa` ENUM('true','false','skip') NOT NULL DEFAULT 'skip',
  `syncRecords` ENUM('true','false','skip') NOT NULL DEFAULT 'skip',
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `Repository`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Repository` (
  `rep_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `component_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`rep_id`, `component_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `Parameters`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Parameters` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parameter` VARCHAR(255) NOT NULL,
  `value` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`, `parameter`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `domains`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `domains` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `cr_date` DATE NULL DEFAULT NULL,
  `name` VARCHAR(255) NOT NULL,
  `displayName` VARCHAR(255) NOT NULL,
  `dns_zone_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  `status` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `htype` ENUM('none','vrt_hst','std_fwd','frm_fwd') NOT NULL DEFAULT 'none',
  `real_size` BIGINT(20) UNSIGNED NULL DEFAULT '0',
  `cl_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `cert_rep_id` INT(10) UNSIGNED NULL DEFAULT '0',
  `limits_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `params_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `guid` VARCHAR(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  `overuse` ENUM('false','true') NOT NULL DEFAULT 'false',
  `vendor_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `webspace_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `parentDomainId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `webspace_status` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `permissions_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `external_id` VARCHAR(255) NULL DEFAULT NULL,
  `adminDescription` VARCHAR(255) NULL DEFAULT NULL,
  `resellerDescription` VARCHAR(255) NULL DEFAULT NULL,
  `description` VARCHAR(255) NULL DEFAULT NULL,
  `gl_filter` ENUM('on','off') NOT NULL DEFAULT 'on',
  `icpStatus` INT(1) NOT NULL DEFAULT 0,
  `icpPermit` VARCHAR(255) NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `name` (`name` ASC) VISIBLE,
  INDEX `displayName` (`displayName` ASC) VISIBLE,
  INDEX `cl_id` (`cl_id` ASC) VISIBLE,
  INDEX `dns_zone_id` (`dns_zone_id` ASC) VISIBLE,
  INDEX `vendor_id` (`vendor_id` ASC) VISIBLE,
  INDEX `webspace_id` (`webspace_id` ASC) VISIBLE,
  INDEX `parentDomainId` (`parentDomainId` ASC) VISIBLE,
  INDEX `permissions_id` (`permissions_id` ASC) VISIBLE,
  INDEX `external_id` (`external_id` ASC) VISIBLE,
  INDEX `cert_rep_id` (`cert_rep_id` ASC) VISIBLE,
  INDEX `limits_id` (`limits_id` ASC) VISIBLE,
  INDEX `params_id` (`params_id` ASC) VISIBLE,
  CONSTRAINT `domains_ibfk_1`
    FOREIGN KEY (`dns_zone_id`)
    REFERENCES `dns_zone` (`id`),
  CONSTRAINT `domains_ibfk_2`
    FOREIGN KEY (`cl_id`)
    REFERENCES `clients` (`id`),
  CONSTRAINT `domains_ibfk_3`
    FOREIGN KEY (`cert_rep_id`)
    REFERENCES `Repository` (`rep_id`),
  CONSTRAINT `domains_ibfk_4`
    FOREIGN KEY (`limits_id`)
    REFERENCES `Limits` (`id`),
  CONSTRAINT `domains_ibfk_5`
    FOREIGN KEY (`params_id`)
    REFERENCES `Parameters` (`id`),
  CONSTRAINT `domains_ibfk_6`
    FOREIGN KEY (`vendor_id`)
    REFERENCES `clients` (`id`),
  CONSTRAINT `domains_ibfk_7`
    FOREIGN KEY (`webspace_id`)
    REFERENCES `domains` (`id`),
  CONSTRAINT `domains_ibfk_8`
    FOREIGN KEY (`parentDomainId`)
    REFERENCES `domains` (`id`),
  CONSTRAINT `domains_ibfk_9`
    FOREIGN KEY (`permissions_id`)
    REFERENCES `Permissions` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ServiceNodes`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ServiceNodes` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ipAddress` VARCHAR(255) NOT NULL DEFAULT 'local',
  `description` VARCHAR(255) NOT NULL,
  `type` VARCHAR(255) NOT NULL DEFAULT 'plesk',
  `accessKey` TEXT NULL DEFAULT NULL,
  `externalId` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `ipAddress` (`ipAddress` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `IP_Addresses`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `IP_Addresses` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ip_address` VARCHAR(39) NOT NULL,
  `mask` VARCHAR(15) NOT NULL DEFAULT '255.255.255.0',
  `iface` VARCHAR(255) NOT NULL,
  `ssl_certificate_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `default_domain_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ftps` ENUM('false','true') NOT NULL DEFAULT 'false',
  `status` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `serviceNodeId` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `public_ip_address` VARCHAR(39) NULL DEFAULT NULL,
  `main` ENUM('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `ip_address` (`ip_address` ASC) VISIBLE,
  INDEX `ssl_certificate_id` (`ssl_certificate_id` ASC) VISIBLE,
  INDEX `default_domain_id` (`default_domain_id` ASC) VISIBLE,
  INDEX `serviceNodeId` (`serviceNodeId` ASC) VISIBLE,
  CONSTRAINT `IP_Addresses_ibfk_1`
    FOREIGN KEY (`ssl_certificate_id`)
    REFERENCES `certificates` (`id`),
  CONSTRAINT `IP_Addresses_ibfk_2`
    FOREIGN KEY (`default_domain_id`)
    REFERENCES `domains` (`id`),
  CONSTRAINT `IP_Addresses_ibfk_3`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ip_pool`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ip_pool` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ip_address_id` INT(10) UNSIGNED NOT NULL,
  `type` ENUM('shared','exclusive') NOT NULL DEFAULT 'shared',
  PRIMARY KEY (`id`, `ip_address_id`),
  INDEX `ip_address_id` (`ip_address_id` ASC) VISIBLE,
  CONSTRAINT `ip_pool_ibfk_1`
    FOREIGN KEY (`ip_address_id`)
    REFERENCES `IP_Addresses` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `Logos`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Logos` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NULL DEFAULT NULL,
  `fake` VARCHAR(255) NULL DEFAULT NULL,
  `url` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `Notes`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Notes` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `text` TEXT NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `Templates`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Templates` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `owner_id` INT(10) UNSIGNED NOT NULL,
  `type` ENUM('reseller','client','domain','domain_addon') NOT NULL,
  `uuid` VARCHAR(36) NOT NULL,
  `external_id` VARCHAR(255) NULL DEFAULT NULL,
  `note_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `uuid` (`uuid` ASC) VISIBLE,
  INDEX `owner_id` (`owner_id` ASC) VISIBLE,
  INDEX `note_id` (`note_id` ASC) VISIBLE,
  CONSTRAINT `Templates_ibfk_1`
    FOREIGN KEY (`owner_id`)
    REFERENCES `clients` (`id`),
  CONSTRAINT `Templates_ibfk_2`
    FOREIGN KEY (`note_id`)
    REFERENCES `Notes` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `clients`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `clients` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `cr_date` DATE NULL DEFAULT NULL,
  `cname` VARCHAR(255) NULL DEFAULT NULL,
  `pname` VARCHAR(255) NOT NULL,
  `login` VARCHAR(255) NOT NULL,
  `account_id` INT(10) UNSIGNED NOT NULL,
  `status` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `phone` VARCHAR(255) NULL DEFAULT NULL,
  `fax` VARCHAR(255) NULL DEFAULT NULL,
  `email` VARCHAR(255) NULL DEFAULT NULL,
  `address` VARCHAR(255) NULL DEFAULT NULL,
  `city` VARCHAR(255) NULL DEFAULT NULL,
  `state` VARCHAR(255) NULL DEFAULT NULL,
  `pcode` VARCHAR(10) NULL DEFAULT NULL,
  `country` VARCHAR(2) NULL DEFAULT NULL,
  `locale` VARCHAR(17) NOT NULL DEFAULT 'en-US',
  `description` VARCHAR(255) NULL DEFAULT NULL,
  `limits_id` INT(10) UNSIGNED NULL DEFAULT '0',
  `params_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `perm_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `pool_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `logo_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `tmpl_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `sapp_pool_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ownership` ENUM('false','true') NOT NULL DEFAULT 'true',
  `guid` VARCHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  `parent_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` ENUM('admin','reseller','client') NOT NULL DEFAULT 'client',
  `overuse` ENUM('false','true') NOT NULL DEFAULT 'false',
  `vendor_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  `external_id` VARCHAR(255) NULL DEFAULT NULL,
  `passwd` VARCHAR(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `login` (`login` ASC) VISIBLE,
  INDEX `pname` (`pname` ASC) VISIBLE,
  INDEX `vendor_id` (`vendor_id` ASC) VISIBLE,
  INDEX `type` (`type` ASC) VISIBLE,
  INDEX `parent_id` (`parent_id` ASC) VISIBLE,
  INDEX `account_id` (`account_id` ASC) VISIBLE,
  INDEX `limits_id` (`limits_id` ASC) VISIBLE,
  INDEX `params_id` (`params_id` ASC) VISIBLE,
  INDEX `perm_id` (`perm_id` ASC) VISIBLE,
  INDEX `pool_id` (`pool_id` ASC) VISIBLE,
  INDEX `logo_id` (`logo_id` ASC) VISIBLE,
  INDEX `tmpl_id` (`tmpl_id` ASC) VISIBLE,
  INDEX `sapp_pool_id` (`sapp_pool_id` ASC) VISIBLE,
  CONSTRAINT `clients_ibfk_1`
    FOREIGN KEY (`account_id`)
    REFERENCES `accounts` (`id`),
  CONSTRAINT `clients_ibfk_2`
    FOREIGN KEY (`limits_id`)
    REFERENCES `Limits` (`id`),
  CONSTRAINT `clients_ibfk_3`
    FOREIGN KEY (`perm_id`)
    REFERENCES `Permissions` (`id`),
  CONSTRAINT `clients_ibfk_4`
    FOREIGN KEY (`pool_id`)
    REFERENCES `ip_pool` (`id`),
  CONSTRAINT `clients_ibfk_5`
    FOREIGN KEY (`logo_id`)
    REFERENCES `Logos` (`id`),
  CONSTRAINT `clients_ibfk_6`
    FOREIGN KEY (`tmpl_id`)
    REFERENCES `Templates` (`id`),
  CONSTRAINT `clients_ibfk_7`
    FOREIGN KEY (`parent_id`)
    REFERENCES `clients` (`id`),
  CONSTRAINT `clients_ibfk_8`
    FOREIGN KEY (`vendor_id`)
    REFERENCES `clients` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ClientsTraffic`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ClientsTraffic` (
  `cl_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `date` DATE NOT NULL DEFAULT '0000-00-00',
  `http_in` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `http_out` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `ftp_in` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `ftp_out` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `smtp_in` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `smtp_out` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `pop3_imap_in` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `pop3_imap_out` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`cl_id`, `date`),
  CONSTRAINT `ClientsTraffic_ibfk_1`
    FOREIGN KEY (`cl_id`)
    REFERENCES `clients` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `Configurations`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Configurations` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `serviceNodeId` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `file` BLOB NULL DEFAULT NULL,
  `version` VARCHAR(255) NOT NULL,
  `objectType` VARCHAR(255) NOT NULL,
  `objectId` INT(10) UNSIGNED NULL DEFAULT NULL,
  `status` ENUM('error','generation','ok') NOT NULL DEFAULT 'error',
  `active` ENUM('false','true') NOT NULL DEFAULT 'true',
  `description` BLOB NULL DEFAULT NULL,
  `errorFile` BLOB NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `objectTypeAndId_index` (`objectType` ASC, `objectId` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `DatabaseServers`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `DatabaseServers` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `host` VARCHAR(63) NOT NULL,
  `port` INT(10) UNSIGNED NULL DEFAULT NULL,
  `type` ENUM('mysql','postgresql','mssql') NOT NULL DEFAULT 'mysql',
  `server_version` CHAR(255) NULL DEFAULT NULL,
  `admin_login` CHAR(255) NOT NULL,
  `admin_password` CHAR(255) NOT NULL,
  `parameters_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  `last_error` ENUM('no_error','connection_failed','permission_denied','other_error','credentials_not_set') NOT NULL DEFAULT 'no_error',
  PRIMARY KEY (`id`),
  INDEX `host_port` (`host` ASC, `port` ASC) VISIBLE,
  INDEX `parameters_id` (`parameters_id` ASC) VISIBLE,
  CONSTRAINT `DatabaseServers_ibfk_1`
    FOREIGN KEY (`parameters_id`)
    REFERENCES `Parameters` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `data_bases`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `data_bases` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(64) NOT NULL,
  `type` ENUM('mysql','postgresql','mssql') NOT NULL DEFAULT 'mysql',
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `db_server_id` INT(10) UNSIGNED NOT NULL,
  `default_user_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  `external_id` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `name_and_db_server_id` (`name` ASC, `db_server_id` ASC) VISIBLE,
  INDEX `dom_id` (`dom_id` ASC) VISIBLE,
  INDEX `db_server_id` (`db_server_id` ASC) VISIBLE,
  INDEX `default_user_id` (`default_user_id` ASC) VISIBLE,
  CONSTRAINT `data_bases_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`),
  CONSTRAINT `data_bases_ibfk_2`
    FOREIGN KEY (`db_server_id`)
    REFERENCES `DatabaseServers` (`id`),
  CONSTRAINT `data_bases_ibfk_3`
    FOREIGN KEY (`default_user_id`)
    REFERENCES `db_users` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `db_users`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `db_users` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `login` VARCHAR(128) NOT NULL,
  `account_id` INT(10) UNSIGNED NOT NULL,
  `db_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `status` ENUM('normal','orphaned') NOT NULL DEFAULT 'normal',
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `db_server_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `passwd` VARCHAR(16) NOT NULL,
  `external_id` VARCHAR(255) NULL DEFAULT NULL,
  `role` VARCHAR(255) NOT NULL DEFAULT 'readWrite',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `db_server_id` (`db_server_id` ASC, `db_id` ASC, `login` ASC) VISIBLE,
  INDEX `account_id` (`account_id` ASC) VISIBLE,
  INDEX `db_id` (`db_id` ASC) VISIBLE,
  INDEX `dom_id` (`dom_id` ASC) VISIBLE,
  CONSTRAINT `db_users_ibfk_1`
    FOREIGN KEY (`account_id`)
    REFERENCES `accounts` (`id`),
  CONSTRAINT `db_users_ibfk_2`
    FOREIGN KEY (`db_id`)
    REFERENCES `data_bases` (`id`),
  CONSTRAINT `db_users_ibfk_3`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`),
  CONSTRAINT `db_users_ibfk_4`
    FOREIGN KEY (`db_server_id`)
    REFERENCES `DatabaseServers` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `DatabaseUserRemoteAccessRules`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `DatabaseUserRemoteAccessRules` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ipAddress` VARCHAR(39) NOT NULL,
  `mask` VARCHAR(15) NOT NULL,
  `type` ENUM('allow','deny') NOT NULL,
  `databaseUserId` INT(10) UNSIGNED NOT NULL,
  `firewallRuleId` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `databaseUserId` (`databaseUserId` ASC) VISIBLE,
  INDEX `firewallRuleId` (`firewallRuleId` ASC) VISIBLE,
  CONSTRAINT `DatabaseUserRemoteAccessRules_ibfk_1`
    FOREIGN KEY (`databaseUserId`)
    REFERENCES `db_users` (`id`),
  CONSTRAINT `DatabaseUserRemoteAccessRules_ibfk_2`
    FOREIGN KEY (`firewallRuleId`)
    REFERENCES `module_firewall_rules` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `DomainOutgoingMessagesPeaks`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `DomainOutgoingMessagesPeaks` (
  `domainId` INT(10) UNSIGNED NOT NULL,
  `beginDate` DATETIME NOT NULL,
  `endDate` DATETIME NULL DEFAULT NULL,
  `rejected` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`domainId`, `beginDate`),
  CONSTRAINT `DomainOutgoingMessagesPeaks_ibfk_1`
    FOREIGN KEY (`domainId`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `DomainOutgoingMessagesStats`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `DomainOutgoingMessagesStats` (
  `domainId` INT(10) UNSIGNED NOT NULL,
  `collectDate` DATETIME NOT NULL,
  `limitValue` BIGINT(20) NOT NULL DEFAULT '-1',
  `passed` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `rejected` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`domainId`, `collectDate`),
  CONSTRAINT `DomainOutgoingMessagesStats_ibfk_1`
    FOREIGN KEY (`domainId`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `IpCollections`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `IpCollections` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `DomainServices`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `DomainServices` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` ENUM('mail','tomcat','maillists','web') NULL DEFAULT NULL,
  `status` BIGINT(20) NOT NULL DEFAULT '0',
  `parameters_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ipCollectionId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  INDEX `dom_id` (`dom_id` ASC) VISIBLE,
  INDEX `parameters_id` (`parameters_id` ASC) VISIBLE,
  INDEX `ipCollectionId` (`ipCollectionId` ASC) VISIBLE,
  CONSTRAINT `DomainServices_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`),
  CONSTRAINT `DomainServices_ibfk_2`
    FOREIGN KEY (`parameters_id`)
    REFERENCES `Parameters` (`id`),
  CONSTRAINT `DomainServices_ibfk_3`
    FOREIGN KEY (`ipCollectionId`)
    REFERENCES `IpCollections` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `DomainsTraffic`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `DomainsTraffic` (
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `date` DATE NOT NULL DEFAULT '0000-00-00',
  `http_in` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `http_out` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `ftp_in` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `ftp_out` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `smtp_in` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `smtp_out` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `pop3_imap_in` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `pop3_imap_out` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`dom_id`, `date`),
  CONSTRAINT `DomainsTraffic_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `DynamicIpSecurity`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `DynamicIpSecurity` (
  `dom_id` INT(10) UNSIGNED NOT NULL,
  `isDenyByConcurrentRequests` INT(11) NOT NULL DEFAULT '0',
  `maxConcurrentRequests` INT(10) UNSIGNED NOT NULL DEFAULT '5',
  `isDenyByRequestRate` INT(11) NOT NULL DEFAULT '0',
  `maxRequests` INT(10) UNSIGNED NOT NULL DEFAULT '20',
  `requestInterval` INT(10) UNSIGNED NOT NULL DEFAULT '200',
  PRIMARY KEY (`dom_id`),
  CONSTRAINT `DynamicIpSecurity_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `GL_remote_domains`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `GL_remote_domains` (
  `serviceNodeId` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `domain` VARCHAR(255) NOT NULL,
  `type` ENUM('black','white') NOT NULL DEFAULT 'black',
  PRIMARY KEY (`serviceNodeId`, `domain`),
  CONSTRAINT `GL_remote_domains_ibfk_1`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `GL_settings`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `GL_settings` (
  `serviceNodeId` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `param` VARCHAR(255) NOT NULL,
  `value` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`serviceNodeId`, `param`),
  CONSTRAINT `GL_settings_ibfk_1`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `IisAppPools`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `IisAppPools` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `serviceNodeId` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `ownerType` ENUM('client','domain') NOT NULL DEFAULT 'client',
  `ownerId` INT(10) UNSIGNED NOT NULL,
  `identity` VARCHAR(20) NOT NULL,
  `isStarted` INT(11) NOT NULL DEFAULT '1',
  `cpuLimit` INT(11) NOT NULL DEFAULT '-1',
  `cpuLimitAction` ENUM('NoAction','KillW3wp','Throttle','ThrottleUnderLoad') NOT NULL DEFAULT 'NoAction',
  `cpuLimitInterval` INT(10) UNSIGNED NOT NULL DEFAULT '5',
  `maxProcesses` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `idleTimeout` INT(10) UNSIGNED NOT NULL DEFAULT '5',
  `idleTimeoutAction` ENUM('Terminate','Suspend') NOT NULL DEFAULT 'Terminate',
  `recyclingByTime` INT(11) NOT NULL DEFAULT '1740',
  `recyclingByRequests` INT(11) NOT NULL DEFAULT '-1',
  `recyclingByVirtualMemory` BIGINT(20) NOT NULL DEFAULT '-1',
  `recyclingByPrivateMemory` BIGINT(20) NOT NULL DEFAULT '-1',
  `managedPipelineMode` ENUM('Classic','Integrated') NOT NULL DEFAULT 'Integrated',
  `externalId` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `ownerId` (`serviceNodeId` ASC, `ownerType` ASC, `ownerId` ASC) VISIBLE,
  CONSTRAINT `IisAppPools_ibfk_1`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `IisAppPoolDomains`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `IisAppPoolDomains` (
  `domainId` INT(10) UNSIGNED NOT NULL,
  `poolId` INT(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`domainId`),
  INDEX `poolId` (`poolId` ASC) VISIBLE,
  CONSTRAINT `IisAppPoolDomains_ibfk_1`
    FOREIGN KEY (`domainId`)
    REFERENCES `domains` (`id`),
  CONSTRAINT `IisAppPoolDomains_ibfk_2`
    FOREIGN KEY (`poolId`)
    REFERENCES `IisAppPools` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `IisAppPoolsPolicy`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `IisAppPoolsPolicy` (
  `serviceNodeId` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `mode` ENUM('shared','dedicated','mixed') NOT NULL DEFAULT 'mixed',
  PRIMARY KEY (`serviceNodeId`),
  CONSTRAINT `IisAppPoolsPolicy_ibfk_1`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `IpAddressesCollections`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `IpAddressesCollections` (
  `ipCollectionId` INT(10) UNSIGNED NOT NULL,
  `ipAddressId` INT(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`ipCollectionId`, `ipAddressId`),
  INDEX `ipAddressId` (`ipAddressId` ASC) VISIBLE,
  CONSTRAINT `IpAddressesCollections_ibfk_1`
    FOREIGN KEY (`ipCollectionId`)
    REFERENCES `IpCollections` (`id`),
  CONSTRAINT `IpAddressesCollections_ibfk_2`
    FOREIGN KEY (`ipAddressId`)
    REFERENCES `IP_Addresses` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `LimitsReservation`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `LimitsReservation` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `collectionRef` VARCHAR(128) NOT NULL,
  `limitName` VARCHAR(255) NOT NULL,
  `value` BIGINT(20) NULL DEFAULT NULL,
  `expiration` DATETIME NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `collection` (`collectionRef` ASC, `limitName` ASC) VISIBLE,
  INDEX `expiration` (`expiration` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `MailLists`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `MailLists` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(255) NOT NULL,
  `status` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  INDEX `dom_id` (`dom_id` ASC) VISIBLE,
  CONSTRAINT `MailLists_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `MailMessagesStat`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `MailMessagesStat` (
  `date` DATE NOT NULL DEFAULT '0000-00-00',
  `sent` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`date`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_roles`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_roles` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NULL DEFAULT NULL,
  `isBuiltIn` INT(11) NULL DEFAULT '0',
  `ownerId` INT(10) UNSIGNED NULL DEFAULT NULL,
  `isActivationRequired` INT(1) NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  INDEX `ownerId_idx` (`ownerId` ASC) VISIBLE,
  CONSTRAINT `smb_roles_ibfk_1`
    FOREIGN KEY (`ownerId`)
    REFERENCES `clients` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_users`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_users` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `login` VARCHAR(255) NULL DEFAULT NULL,
  `password` VARCHAR(255) NULL DEFAULT NULL,
  `contactName` VARCHAR(255) NULL DEFAULT NULL,
  `email` VARCHAR(255) NULL DEFAULT NULL,
  `companyName` VARCHAR(255) NULL DEFAULT NULL,
  `phone` VARCHAR(255) NULL DEFAULT NULL,
  `fax` VARCHAR(255) NULL DEFAULT NULL,
  `address` TEXT NULL DEFAULT NULL,
  `city` VARCHAR(255) NULL DEFAULT NULL,
  `state` VARCHAR(255) NULL DEFAULT NULL,
  `zip` VARCHAR(255) NULL DEFAULT NULL,
  `country` VARCHAR(255) NULL DEFAULT NULL,
  `creationDate` VARCHAR(25) NOT NULL,
  `isBuiltIn` INT(11) NULL DEFAULT '0',
  `isDomainAdmin` INT(11) NULL DEFAULT '0',
  `roleId` INT(11) NOT NULL,
  `uuid` VARCHAR(36) NOT NULL,
  `isLocked` INT(11) NULL DEFAULT '0',
  `authCookie` VARCHAR(255) NULL DEFAULT NULL,
  `sessionId` VARCHAR(255) NULL DEFAULT NULL,
  `externalId` VARCHAR(255) NULL DEFAULT NULL,
  `ownerId` INT(10) UNSIGNED NULL DEFAULT NULL,
  `additionalInfo` TEXT NULL DEFAULT NULL,
  `imNumber` VARCHAR(255) NULL DEFAULT NULL,
  `imType` INT(11) NULL DEFAULT NULL,
  `isLegacyUser` INT(11) NULL DEFAULT '0',
  `subscriptionDomainId` INT(10) UNSIGNED NULL DEFAULT '0',
  `locale` VARCHAR(17) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `uuid` (`uuid` ASC) VISIBLE,
  UNIQUE INDEX `login` (`login` ASC) VISIBLE,
  INDEX `subscriptionDomainId_idx` (`subscriptionDomainId` ASC) VISIBLE,
  INDEX `isBuiltIn_idx` (`isBuiltIn` ASC) VISIBLE,
  INDEX `ownerId_idx` (`ownerId` ASC) VISIBLE,
  INDEX `roleId` (`roleId` ASC) VISIBLE,
  CONSTRAINT `smb_users_ibfk_1`
    FOREIGN KEY (`roleId`)
    REFERENCES `smb_roles` (`id`),
  CONSTRAINT `smb_users_ibfk_2`
    FOREIGN KEY (`ownerId`)
    REFERENCES `clients` (`id`),
  CONSTRAINT `smb_users_ibfk_3`
    FOREIGN KEY (`subscriptionDomainId`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_apsPackages`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_apsPackages` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `version` VARCHAR(255) NULL DEFAULT NULL,
  `release` VARCHAR(255) NULL DEFAULT NULL,
  `vendor` VARCHAR(255) NULL DEFAULT NULL,
  `vendorHomePage` VARCHAR(255) NULL DEFAULT NULL,
  `packager` VARCHAR(255) NULL DEFAULT NULL,
  `packagerHomePage` VARCHAR(255) NULL DEFAULT NULL,
  `cacheId` VARCHAR(255) NOT NULL,
  `installed` VARCHAR(26) NULL DEFAULT NULL,
  `isUploaded` INT(11) NULL DEFAULT '0',
  `isVisible` INT(11) NULL DEFAULT '0',
  `globalSettingsNotSet` INT(11) NULL DEFAULT '0',
  `registryUid` VARCHAR(36) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `cacheId` (`cacheId` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_apsContexts`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_apsContexts` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `contextType` INT(11) NULL DEFAULT '0',
  `packageId` INT(11) NOT NULL,
  `requirementContextClass` VARCHAR(255) NULL DEFAULT NULL,
  `requirementContextId` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `packageId` (`packageId` ASC) VISIBLE,
  CONSTRAINT `smb_apsContexts_ibfk_1`
    FOREIGN KEY (`packageId`)
    REFERENCES `smb_apsPackages` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_apsMetas`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_apsMetas` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `serviceId` VARCHAR(255) NULL DEFAULT NULL,
  `xpath` VARCHAR(255) NULL DEFAULT NULL,
  `class` VARCHAR(255) NULL DEFAULT NULL,
  `contextId` INT(11) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `contextId` (`contextId` ASC) VISIBLE,
  CONSTRAINT `smb_apsMetas_ibfk_1`
    FOREIGN KEY (`contextId`)
    REFERENCES `smb_apsContexts` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_apsInstances`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_apsInstances` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `parentContextId` INT(11) NOT NULL,
  `contextId` INT(11) NOT NULL,
  `metaId` INT(11) NOT NULL,
  `uuid` VARCHAR(255) NULL DEFAULT NULL,
  `registryResourceId` VARCHAR(36) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `parentContextId` (`parentContextId` ASC) VISIBLE,
  INDEX `contextId` (`contextId` ASC) VISIBLE,
  INDEX `metaId` (`metaId` ASC) VISIBLE,
  CONSTRAINT `smb_apsInstances_ibfk_1`
    FOREIGN KEY (`parentContextId`)
    REFERENCES `smb_apsContexts` (`id`),
  CONSTRAINT `smb_apsInstances_ibfk_2`
    FOREIGN KEY (`contextId`)
    REFERENCES `smb_apsContexts` (`id`),
  CONSTRAINT `smb_apsInstances_ibfk_3`
    FOREIGN KEY (`metaId`)
    REFERENCES `smb_apsMetas` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `mail`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mail` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `userId` INT(11) NULL DEFAULT NULL,
  `mail_name` VARCHAR(245) NOT NULL,
  `postbox` ENUM('false','true') NOT NULL DEFAULT 'false',
  `account_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `redirect` ENUM('false','true') NOT NULL DEFAULT 'false',
  `redir_addr` VARCHAR(255) NULL DEFAULT NULL,
  `mail_group` ENUM('false','true') NOT NULL DEFAULT 'false',
  `autoresponder` ENUM('false','true') NOT NULL DEFAULT 'false',
  `mbox_quota` BIGINT(20) NOT NULL DEFAULT '-1',
  `description` VARCHAR(255) NULL DEFAULT NULL,
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `disk_usage` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `apsServiceAccountInstanceId` INT(11) NOT NULL DEFAULT '0',
  `perm_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `apsAntispamServiceInstanceId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `apsAntivirusServiceInstanceId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `spamfilter` ENUM('false','true') NOT NULL DEFAULT 'true',
  `virusfilter` ENUM('none','incoming','outgoing','any') NOT NULL DEFAULT 'none',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `dom_id` (`dom_id` ASC, `mail_name` ASC) VISIBLE,
  INDEX `account_id` (`account_id` ASC) VISIBLE,
  INDEX `perm_id` (`perm_id` ASC) VISIBLE,
  INDEX `userId` (`userId` ASC) VISIBLE,
  INDEX `apsServiceAccountInstanceId` (`apsServiceAccountInstanceId` ASC) VISIBLE,
  CONSTRAINT `mail_ibfk_1`
    FOREIGN KEY (`userId`)
    REFERENCES `smb_users` (`id`),
  CONSTRAINT `mail_ibfk_2`
    FOREIGN KEY (`account_id`)
    REFERENCES `accounts` (`id`),
  CONSTRAINT `mail_ibfk_3`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`),
  CONSTRAINT `mail_ibfk_4`
    FOREIGN KEY (`apsServiceAccountInstanceId`)
    REFERENCES `smb_apsInstances` (`id`),
  CONSTRAINT `mail_ibfk_5`
    FOREIGN KEY (`perm_id`)
    REFERENCES `Permissions` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `MailOutgoingMessagesPeaks`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `MailOutgoingMessagesPeaks` (
  `mailId` INT(10) UNSIGNED NOT NULL,
  `beginDate` DATETIME NOT NULL,
  `endDate` DATETIME NULL DEFAULT NULL,
  `rejected` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`mailId`, `beginDate`),
  CONSTRAINT `MailOutgoingMessagesPeaks_ibfk_1`
    FOREIGN KEY (`mailId`)
    REFERENCES `mail` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `MailOutgoingMessagesStats`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `MailOutgoingMessagesStats` (
  `mailId` INT(10) UNSIGNED NOT NULL,
  `collectDate` DATETIME NOT NULL,
  `limitValue` BIGINT(20) NOT NULL DEFAULT '-1',
  `passed` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `rejected` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`mailId`, `collectDate`),
  CONSTRAINT `MailOutgoingMessagesStats_ibfk_1`
    FOREIGN KEY (`mailId`)
    REFERENCES `mail` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `Modules`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Modules` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `packname` VARCHAR(255) NOT NULL,
  `display_name` VARCHAR(255) NOT NULL,
  `version` VARCHAR(30) NOT NULL,
  `release` INT(10) UNSIGNED NOT NULL,
  `description` VARCHAR(255) NULL DEFAULT NULL,
  `icon` VARCHAR(255) NOT NULL,
  `plesk_max_version` VARCHAR(30) NULL,
  `status` ENUM('true', 'false') NOT NULL DEFAULT 'true',
  `hidden` INT(1) NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `name` (`name` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ModuleSettings`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ModuleSettings` (
  `module_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(255) NOT NULL,
  `value` VARCHAR(5000) NOT NULL,
  PRIMARY KEY (`module_id`, `name`),
  CONSTRAINT `ModuleSettings_ibfk_1`
    FOREIGN KEY (`module_id`)
    REFERENCES `Modules` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `Notifications`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Notifications` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `status` VARCHAR(1) NOT NULL,
  `send2admin` VARCHAR(1) NOT NULL,
  `send2reseller` VARCHAR(1) NULL DEFAULT NULL,
  `send2client` VARCHAR(1) NOT NULL,
  `send2dlu` VARCHAR(1) NOT NULL,
  `send2email` VARCHAR(1) NOT NULL,
  `email` VARCHAR(255) NOT NULL,
  `subj` VARCHAR(255) NOT NULL,
  `note_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `note_id` (`note_id` ASC) VISIBLE,
  CONSTRAINT `Notifications_ibfk_1`
    FOREIGN KEY (`note_id`)
    REFERENCES `Notes` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `PersistentCache`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PersistentCache` (
  `key` VARCHAR(128) NOT NULL,
  `uid` VARCHAR(32) NOT NULL,
  `expire` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `events` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`key`, `uid`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `PhpSettings`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PhpSettings` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `noteId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  INDEX `noteId` (`noteId` ASC) VISIBLE,
  CONSTRAINT `PhpSettings_ibfk_1`
    FOREIGN KEY (`noteId`)
    REFERENCES `Notes` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `PhpSettingsCustom`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PhpSettingsCustom` (
  `id` INT(10) UNSIGNED NOT NULL,
  `value` TEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `PhpSettingsCustom_ibfk_1`
    FOREIGN KEY (`id`)
    REFERENCES `PhpSettings` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `PhpSettingsParameters`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PhpSettingsParameters` (
  `id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(255) NOT NULL,
  `value` TEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`, `name`),
  CONSTRAINT `PhpSettingsParameters_ibfk_1`
    FOREIGN KEY (`id`)
    REFERENCES `PhpSettings` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `PlanItems`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PlanItems` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `classname` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `isVisible` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `applicableToSubscription` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `applicableToEmail` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `applicableToSite` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `uuid` VARCHAR(36) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `name` (`name` ASC) VISIBLE,
  UNIQUE INDEX `uuid` (`uuid` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `PlanItemProperties`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PlanItemProperties` (
  `plan_item_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(255) NOT NULL,
  `value` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`plan_item_id`, `name`),
  CONSTRAINT `PlanItemProperties_ibfk_1`
    FOREIGN KEY (`plan_item_id`)
    REFERENCES `PlanItems` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `Subscriptions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Subscriptions` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `object_id` INT(10) UNSIGNED NOT NULL,
  `object_type` ENUM('client','domain') NOT NULL,
  `locked` ENUM('false','true') NOT NULL DEFAULT 'false',
  `synchronized` ENUM('false','true') NOT NULL DEFAULT 'true',
  `custom` ENUM('false','true') NOT NULL DEFAULT 'false',
  `uuid` VARCHAR(36) NULL DEFAULT NULL,
  `external_id` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `object_id_and_type` (`object_id` ASC, `object_type` ASC) VISIBLE,
  UNIQUE INDEX `uuid` (`uuid` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `PlansSubscriptions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PlansSubscriptions` (
  `subscription_id` INT(10) UNSIGNED NOT NULL,
  `plan_id` INT(10) UNSIGNED NOT NULL,
  `quantity` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  PRIMARY KEY (`subscription_id`, `plan_id`),
  INDEX `plan_id` (`plan_id` ASC) VISIBLE,
  CONSTRAINT `PlansSubscriptions_ibfk_1`
    FOREIGN KEY (`subscription_id`)
    REFERENCES `Subscriptions` (`id`),
  CONSTRAINT `PlansSubscriptions_ibfk_2`
    FOREIGN KEY (`plan_id`)
    REFERENCES `Templates` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `PleskPagesStat`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PleskPagesStat` (
  `date` DATE NOT NULL DEFAULT '0000-00-00',
  `url` VARCHAR(255) NOT NULL,
  `hits` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`date`, `url`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `PleskStats`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PleskStats` (
  `param` VARCHAR(255) NOT NULL,
  `value` BLOB NULL DEFAULT NULL,
  PRIMARY KEY (`param`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `RestrictedDomains`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `RestrictedDomains` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `name` (`name` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `SBConfig`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `SBConfig` (
  `param_name` VARCHAR(255) NULL DEFAULT NULL,
  `param_value` VARCHAR(255) NULL DEFAULT NULL,
  UNIQUE INDEX `param_name` (`param_name` ASC))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `SBResellers`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `SBResellers` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `client_id` INT(10) UNSIGNED NOT NULL,
  `sb_client_login` VARCHAR(255) NOT NULL,
  `sb_reseller_id` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `client_id` (`client_id` ASC) VISIBLE,
  UNIQUE INDEX `sb_client_login` (`sb_client_login` ASC) VISIBLE,
  UNIQUE INDEX `sb_reseller_id` (`sb_reseller_id` ASC) VISIBLE,
  CONSTRAINT `SBResellers_ibfk_1`
    FOREIGN KEY (`client_id`)
    REFERENCES `clients` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `sys_users`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sys_users` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `serviceNodeId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `login` VARCHAR(20) NOT NULL,
  `account_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `home` VARCHAR(255) NOT NULL,
  `shell` VARCHAR(255) NOT NULL,
  `quota` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `mapped_to` INT(10) UNSIGNED NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `login` (`serviceNodeId` ASC, `login` ASC) VISIBLE,
  INDEX `account_id` (`account_id` ASC) VISIBLE,
  INDEX `mapped_to` (`mapped_to` ASC) VISIBLE,
  CONSTRAINT `sys_users_ibfk_1`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`),
  CONSTRAINT `sys_users_ibfk_2`
    FOREIGN KEY (`account_id`)
    REFERENCES `accounts` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ScheduledTasks`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ScheduledTasks` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `hash` VARCHAR(255) NOT NULL,
  `serviceNodeId` INT(10) UNSIGNED NOT NULL,
  `sysUserId` INT(10) UNSIGNED NULL DEFAULT NULL,
  `sysUserLogin` VARCHAR(255) NULL DEFAULT NULL,
  `isActive` INT(11) NOT NULL DEFAULT '0',
  `type` ENUM('exec','http','php') NOT NULL DEFAULT 'exec',
  `phpHandlerId` VARCHAR(255) NULL DEFAULT NULL,
  `command` TEXT NOT NULL,
  `arguments` TEXT NULL DEFAULT NULL,
  `description` TEXT NULL DEFAULT NULL,
  `notify` ENUM('ignore','errors','always') NOT NULL DEFAULT 'ignore',
  `emailType` ENUM('default','owner','custom') NOT NULL DEFAULT 'owner',
  `email` TEXT NULL DEFAULT NULL,
  `minute` VARCHAR(255) NOT NULL,
  `hour` VARCHAR(255) NOT NULL,
  `dayOfMonth` VARCHAR(255) NOT NULL,
  `month` VARCHAR(255) NOT NULL,
  `dayOfWeek` VARCHAR(255) NOT NULL,
  `period` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  INDEX `serviceNodeId` (`serviceNodeId` ASC) VISIBLE,
  INDEX `sysUserId` (`sysUserId` ASC) VISIBLE,
  CONSTRAINT `ScheduledTasks_ibfk_1`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`),
  CONSTRAINT `ScheduledTasks_ibfk_2`
    FOREIGN KEY (`sysUserId`)
    REFERENCES `sys_users` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `SchemaVersions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `SchemaVersions` (
  `version` VARCHAR(14) NOT NULL)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ServiceNodeCache`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ServiceNodeCache` (
  `serviceNodeId` INT(10) UNSIGNED NOT NULL,
  `pathId` VARCHAR(255) NOT NULL,
  `path` TEXT NULL DEFAULT NULL,
  `cache` TEXT NULL DEFAULT NULL,
  PRIMARY KEY (`serviceNodeId`, `pathId`),
  CONSTRAINT `ServiceNodeCache_ibfk_1`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ServiceNodeCertificates`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ServiceNodeCertificates` (
  `serviceNodeId` INT(10) UNSIGNED NOT NULL,
  `certificateId` INT(10) UNSIGNED NOT NULL,
  `certFile` VARCHAR(255) NULL DEFAULT NULL,
  `caFile` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`serviceNodeId`, `certificateId`),
  INDEX `certificateId` (`certificateId` ASC) VISIBLE,
  CONSTRAINT `ServiceNodeCertificates_ibfk_1`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`),
  CONSTRAINT `ServiceNodeCertificates_ibfk_2`
    FOREIGN KEY (`certificateId`)
    REFERENCES `certificates` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ServiceNodeConfiguration`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ServiceNodeConfiguration` (
  `serviceNodeId` INT(10) UNSIGNED NOT NULL,
  `section` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `value` TEXT NULL DEFAULT NULL,
  PRIMARY KEY (`serviceNodeId`, `section`, `name`),
  CONSTRAINT `ServiceNodeConfiguration_ibfk_1`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ServiceNodeEnvironment`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ServiceNodeEnvironment` (
  `serviceNodeId` INT(10) UNSIGNED NOT NULL,
  `section` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `value` TEXT NULL DEFAULT NULL,
  PRIMARY KEY (`serviceNodeId`, `section`, `name`),
  CONSTRAINT `ServiceNodeEnvironment_ibfk_1`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `sessions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sessions` (
  `sess_id` VARCHAR(33) NOT NULL,
  `type` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `login` VARCHAR(255) NULL DEFAULT NULL,
  `ip_address` VARCHAR(39) NULL DEFAULT NULL,
  `ip_dual_stack` VARCHAR(39) NULL DEFAULT NULL,
  `login_time` INT(10) UNSIGNED NULL DEFAULT NULL,
  `modified` INT(10) UNSIGNED NULL DEFAULT NULL,
  `lifetime` INT(10) UNSIGNED NULL DEFAULT NULL,
  PRIMARY KEY (`sess_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `SessionContexts`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `SessionContexts` (
  `contextId` VARCHAR(255) NOT NULL,
  `sessionId` VARCHAR(33) NULL DEFAULT NULL,
  `data` MEDIUMTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`contextId`),
  INDEX `sessionId` (`sessionId` ASC) VISIBLE,
  CONSTRAINT `SessionContexts_ibfk_1`
    FOREIGN KEY (`sessionId`)
    REFERENCES `sessions` (`sess_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `SiteAppsHitsStat`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `SiteAppsHitsStat` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `count` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `name` (`name` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `SitePagesStat`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `SitePagesStat` (
  `date` DATE NOT NULL DEFAULT '0000-00-00',
  `hits` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`date`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `Skins`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Skins` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `place` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `name` (`name` ASC) VISIBLE,
  INDEX `place` (`place` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `SubscriptionOutgoingMessagesPeaks`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `SubscriptionOutgoingMessagesPeaks` (
  `subscriptionId` INT(10) UNSIGNED NOT NULL,
  `beginDate` DATETIME NOT NULL,
  `endDate` DATETIME NULL DEFAULT NULL,
  `rejected` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`subscriptionId`, `beginDate`),
  CONSTRAINT `SubscriptionOutgoingMessagesPeaks_ibfk_1`
    FOREIGN KEY (`subscriptionId`)
    REFERENCES `Subscriptions` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `SubscriptionOutgoingMessagesStats`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `SubscriptionOutgoingMessagesStats` (
  `subscriptionId` INT(10) UNSIGNED NOT NULL,
  `collectDate` DATETIME NOT NULL,
  `limitValue` BIGINT(20) NOT NULL DEFAULT '-1',
  `passed` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `rejected` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`subscriptionId`, `collectDate`),
  CONSTRAINT `SubscriptionOutgoingMessagesStats_ibfk_1`
    FOREIGN KEY (`subscriptionId`)
    REFERENCES `Subscriptions` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `SubscriptionProperties`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `SubscriptionProperties` (
  `subscription_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(255) NOT NULL,
  `value` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`subscription_id`, `name`),
  CONSTRAINT `SubscriptionProperties_ibfk_1`
    FOREIGN KEY (`subscription_id`)
    REFERENCES `Subscriptions` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `TmplData`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `TmplData` (
  `tmpl_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `element` VARCHAR(255) NOT NULL,
  `value` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`tmpl_id`, `element`),
  CONSTRAINT `TmplData_ibfk_1`
    FOREIGN KEY (`tmpl_id`)
    REFERENCES `Templates` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `TraceFailedRequestsRules`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `TraceFailedRequestsRules` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `domainId` INT(10) UNSIGNED NOT NULL,
  `statusCodes` VARCHAR(255) NOT NULL,
  `stopDate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `isEnabled` INT(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  INDEX `isEnabled` (`isEnabled` ASC) VISIBLE,
  INDEX `domainId` (`domainId` ASC) VISIBLE,
  CONSTRAINT `TraceFailedRequestsRules_ibfk_1`
    FOREIGN KEY (`domainId`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `TraceFailedRequestsProviders`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `TraceFailedRequestsProviders` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ruleId` INT(10) UNSIGNED NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `name` (`ruleId` ASC, `name` ASC) VISIBLE,
  CONSTRAINT `TraceFailedRequestsProviders_ibfk_1`
    FOREIGN KEY (`ruleId`)
    REFERENCES `TraceFailedRequestsRules` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `TraceFailedRequestsProviderAreas`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `TraceFailedRequestsProviderAreas` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `providerId` INT(10) UNSIGNED NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `name` (`providerId` ASC, `name` ASC) VISIBLE,
  CONSTRAINT `TraceFailedRequestsProviderAreas_ibfk_1`
    FOREIGN KEY (`providerId`)
    REFERENCES `TraceFailedRequestsProviders` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `WebServerSettings`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `WebServerSettings` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `WebServerSettingsParameters`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `WebServerSettingsParameters` (
  `webServerSettingsId` INT(10) UNSIGNED NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `value` TEXT NULL DEFAULT NULL,
  PRIMARY KEY (`webServerSettingsId`, `name`),
  CONSTRAINT `WebServerSettingsParameters_ibfk_1`
    FOREIGN KEY (`webServerSettingsId`)
    REFERENCES `WebServerSettings` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `Webmails`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Webmails` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_id` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `version` VARCHAR(255) NOT NULL,
  `release` VARCHAR(255) NOT NULL,
  `docroot` VARCHAR(255) NOT NULL,
  `enabled` ENUM('false','true') NOT NULL DEFAULT 'false',
  `serviceNodeId` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `product_id` (`product_id` ASC) VISIBLE,
  UNIQUE INDEX `docroot` (`docroot` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `actions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `actions` (
  `name` VARCHAR(255) NOT NULL,
  `enabled` ENUM('false','true') NOT NULL DEFAULT 'true',
  UNIQUE INDEX `name` (`name` ASC) VISIBLE,
  PRIMARY KEY (`name`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `admin_aliases`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `admin_aliases` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `login` VARCHAR(20) NOT NULL,
  `account_id` INT(10) UNSIGNED NOT NULL,
  `arealname` VARCHAR(255) NOT NULL,
  `aemail` VARCHAR(255) NOT NULL,
  `comments` VARCHAR(255) NOT NULL,
  `status` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `login` (`login` ASC) VISIBLE,
  INDEX `account_id` (`account_id` ASC) VISIBLE,
  CONSTRAINT `admin_aliases_ibfk_1`
    FOREIGN KEY (`account_id`)
    REFERENCES `accounts` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `admin_aliases_param`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `admin_aliases_param` (
  `alias_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `param` VARCHAR(245) NOT NULL,
  `val` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`alias_id`, `param`),
  CONSTRAINT `admin_aliases_param_ibfk_1`
    FOREIGN KEY (`alias_id`)
    REFERENCES `admin_aliases` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `anon_ftp`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `anon_ftp` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `max_conn` INT(10) UNSIGNED NULL DEFAULT NULL,
  `bandwidth` INT(10) UNSIGNED NULL DEFAULT NULL,
  `incoming` ENUM('false','true') NOT NULL DEFAULT 'false',
  `incoming_readable` ENUM('false','true') NOT NULL DEFAULT 'false',
  `incoming_subdirs` ENUM('false','true') NOT NULL DEFAULT 'false',
  `status` ENUM('false','true') NOT NULL DEFAULT 'false',
  `quota` BIGINT(20) UNSIGNED NULL DEFAULT '1048576',
  `display_login` ENUM('false','true') NOT NULL DEFAULT 'false',
  `login_text` TEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `dom_id` (`dom_id` ASC) VISIBLE,
  CONSTRAINT `anon_ftp_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `apsContexts`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `apsContexts` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `pleskType` VARCHAR(255) NOT NULL,
  `pleskId` INT(10) UNSIGNED NOT NULL,
  `ssl` ENUM('false','true') NOT NULL DEFAULT 'false',
  `subscriptionId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  INDEX `subscriptionId` (`subscriptionId` ASC) VISIBLE,
  CONSTRAINT `apsContexts_ibfk_1`
    FOREIGN KEY (`subscriptionId`)
    REFERENCES `Subscriptions` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `apsContextsApplications`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `apsContextsApplications` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `apsContextId` INT(10) UNSIGNED NOT NULL,
  `registryApplicationId` VARCHAR(36) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `apsContextId` (`apsContextId` ASC) VISIBLE,
  CONSTRAINT `apsContextsApplications_ibfk_1`
    FOREIGN KEY (`apsContextId`)
    REFERENCES `apsContexts` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `apsInstancesParameters`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `apsInstancesParameters` (
  `instanceId` INT(10) UNSIGNED NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `value` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`instanceId`, `name`),
  CONSTRAINT `apsInstancesParameters_ibfk_1`
    FOREIGN KEY (`instanceId`)
    REFERENCES `apsContextsApplications` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `apsResources`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `apsResources` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `registryId` VARCHAR(36) NOT NULL,
  `pleskType` VARCHAR(255) NOT NULL,
  `pleskId` INT(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `apsResourcesParameters`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `apsResourcesParameters` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `apsResourceId` INT(10) UNSIGNED NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `value` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `apsResourceId` (`apsResourceId` ASC) VISIBLE,
  CONSTRAINT `apsResourcesParameters_ibfk_1`
    FOREIGN KEY (`apsResourceId`)
    REFERENCES `apsResources` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `apscategories`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `apscategories` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `category_name` VARCHAR(255) NULL DEFAULT NULL,
  `parent_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  INDEX `parent_id` (`parent_id` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `avstatistics`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `avstatistics` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` ENUM('summary','viruses','recipients','spam_summary','spam_recipients') NOT NULL DEFAULT 'summary',
  `date` DATE NOT NULL DEFAULT '0000-00-00',
  `name` VARCHAR(255) NOT NULL,
  `val` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `type` (`type` ASC, `date` ASC) VISIBLE,
  INDEX `date_type` (`type` ASC, `date` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `badmailfrom`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `badmailfrom` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `domain` VARCHAR(255) NOT NULL,
  `serviceNodeId` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  INDEX `domain` (`domain` ASC) VISIBLE,
  INDEX `serviceNodeId` (`serviceNodeId` ASC) VISIBLE,
  CONSTRAINT `badmailfrom_ibfk_1`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `cl_param`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `cl_param` (
  `cl_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `param` VARCHAR(245) NOT NULL,
  `val` VARCHAR(5000) NULL DEFAULT NULL,
  PRIMARY KEY (`cl_id`, `param`),
  CONSTRAINT `cl_param_ibfk_1`
    FOREIGN KEY (`cl_id`)
    REFERENCES `clients` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `cp_access`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `cp_access` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` ENUM('allow','deny') NOT NULL DEFAULT 'allow',
  `netaddr` VARCHAR(39) NOT NULL,
  `netmask` VARCHAR(15) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `custom_buttons`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `custom_buttons` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sort_key` INT(10) UNSIGNED NOT NULL DEFAULT '100',
  `level` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `level_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `place` ENUM('domain','domain-properties','client','reseller','reseller-settings','admin','admin-settings','navigation') NOT NULL DEFAULT 'domain',
  `text` VARCHAR(255) NULL DEFAULT NULL,
  `url` VARCHAR(255) NULL DEFAULT NULL,
  `conhelp` TEXT NULL DEFAULT NULL,
  `options` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `file` VARCHAR(245) NOT NULL,
  `plan_item_name` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `disk_usage`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `disk_usage` (
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `httpdocs` BIGINT(20) UNSIGNED NULL DEFAULT '0',
  `httpsdocs` BIGINT(20) UNSIGNED NULL DEFAULT '0',
  `subdomains` BIGINT(20) UNSIGNED NULL DEFAULT '0',
  `web_users` BIGINT(20) UNSIGNED NULL DEFAULT '0',
  `anonftp` BIGINT(20) UNSIGNED NULL DEFAULT '0',
  `logs` BIGINT(20) UNSIGNED NULL DEFAULT '0',
  `mysql_dbases` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `mssql_dbases` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `mailboxes` BIGINT(20) UNSIGNED NULL DEFAULT '0',
  `maillists` BIGINT(20) UNSIGNED NULL DEFAULT '0',
  `domaindumps` BIGINT(20) UNSIGNED NULL DEFAULT '0',
  `www_root` BIGINT(20) UNSIGNED NULL DEFAULT '0',
  `dbases` BIGINT(20) UNSIGNED NULL DEFAULT '0',
  `configs` BIGINT(20) UNSIGNED NULL DEFAULT '0',
  `chroot` BIGINT(20) UNSIGNED NULL DEFAULT '0',
  PRIMARY KEY (`dom_id`),
  CONSTRAINT `disk_usage_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `dns_recs`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `dns_recs` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `dns_zone_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  `type` ENUM('NS', 'A', 'AAAA', 'CNAME', 'MX', 'PTR', 'TXT', 'AXFR', 'SRV', 'DS', 'CAA', 'master', 'none') NOT NULL DEFAULT 'A',
  `host` VARCHAR(255) NOT NULL,
  `displayHost` VARCHAR(255) NOT NULL,
  `val` VARCHAR(255) NOT NULL,
  `displayVal` VARCHAR(255) NOT NULL,
  `opt` VARCHAR(255) NOT NULL,
  `external_id` VARCHAR(255) NULL DEFAULT NULL,
  `time_stamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  INDEX `dns_zone_id` (`dns_zone_id` ASC) VISIBLE,
  INDEX `type` (`type` ASC) VISIBLE,
  INDEX `host` (`host` ASC) VISIBLE,
  CONSTRAINT `dns_recs_ibfk_1`
    FOREIGN KEY (`dns_zone_id`)
    REFERENCES `dns_zone` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `dns_recs_t`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `dns_recs_t` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` ENUM('NS', 'A', 'AAAA', 'CNAME', 'MX', 'PTR', 'SOA', 'TXT', 'AXFR', 'SRV', 'CAA', 'none') NOT NULL DEFAULT 'A',
  `host` VARCHAR(255) NOT NULL,
  `displayHost` VARCHAR(255) NOT NULL,
  `val` VARCHAR(512) NOT NULL,
  `displayVal` VARCHAR(512) NOT NULL,
  `opt` VARCHAR(255) NOT NULL,
  `time_stamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `uid` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `dns_refs`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `dns_refs` (
  `uid` VARCHAR(255) NOT NULL,
  `zoneId` INT(10) UNSIGNED NOT NULL,
  `zoneRecordId` INT(10) UNSIGNED NULL DEFAULT NULL,
  `templateRecordId` INT(10) UNSIGNED NULL DEFAULT NULL,
  `status` ENUM('syn','mod','del') NOT NULL DEFAULT 'syn',
  PRIMARY KEY (`uid`),
  INDEX `zoneId` (`zoneId` ASC) VISIBLE,
  INDEX `zoneRecordId` (`zoneRecordId` ASC) VISIBLE,
  INDEX `templateRecordId` (`templateRecordId` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `dom_level_usrs`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `dom_level_usrs` (
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `state` ENUM('false','true') NOT NULL DEFAULT 'false',
  `passwd` VARCHAR(255) NOT NULL,
  `card_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  `uid` VARCHAR(255) NULL DEFAULT NULL,
  `ownership` ENUM('false','true') NOT NULL DEFAULT 'true',
  `account_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  `perm_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  PRIMARY KEY (`dom_id`),
  INDEX `uid` (`uid` ASC) VISIBLE,
  INDEX `dom_id` (`dom_id` ASC) VISIBLE,
  INDEX `account_id` (`account_id` ASC) VISIBLE,
  INDEX `card_id` (`card_id` ASC) VISIBLE,
  INDEX `perm_id` (`perm_id` ASC) VISIBLE,
  CONSTRAINT `dom_level_usrs_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `dom_param`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `dom_param` (
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `param` VARCHAR(245) NOT NULL,
  `val` VARCHAR(5000) NULL DEFAULT NULL,
  PRIMARY KEY (`dom_id`, `param`),
  CONSTRAINT `dom_param_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `domain_aliases`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `domain_aliases` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(255) NOT NULL,
  `displayName` VARCHAR(255) NOT NULL,
  `dns_zone_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  `status` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `mail` ENUM('true','false') NOT NULL DEFAULT 'false',
  `web` ENUM('true','false') NOT NULL DEFAULT 'false',
  `dns` ENUM('true','false') NOT NULL DEFAULT 'false',
  `tomcat` ENUM('true','false') NOT NULL DEFAULT 'false',
  `seoRedirect` ENUM('false','true') NOT NULL DEFAULT 'false',
  `external_id` VARCHAR(255) NULL DEFAULT NULL,
  `icpStatus` INT(1) NOT NULL DEFAULT 0,
  `icpPermit` VARCHAR(255) NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `name` (`name` ASC) VISIBLE,
  INDEX `displayName` (`displayName` ASC) VISIBLE,
  INDEX `dom_id` (`dom_id` ASC) VISIBLE,
  INDEX `dns_zone_id` (`dns_zone_id` ASC) VISIBLE,
  CONSTRAINT `domain_aliases_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`),
  CONSTRAINT `domain_aliases_ibfk_2`
    FOREIGN KEY (`dns_zone_id`)
    REFERENCES `dns_zone` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `dsn`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `dsn` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `dom_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  `serviceNodeId` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `name` VARCHAR(255) NOT NULL,
  `driver` VARCHAR(255) NOT NULL,
  `description` VARCHAR(255) NULL DEFAULT NULL,
  `configured` ENUM('false','true') NOT NULL DEFAULT 'false',
  `cstring` TEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `name` (`name` ASC, `serviceNodeId` ASC) VISIBLE,
  INDEX `dom_id` (`dom_id` ASC) VISIBLE,
  INDEX `serviceNodeId` (`serviceNodeId` ASC) VISIBLE,
  CONSTRAINT `dsn_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`),
  CONSTRAINT `dsn_ibfk_2`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `event_handlers`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `event_handlers` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `priority` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `user` VARCHAR(255) NOT NULL DEFAULT 'nobody',
  `command` TEXT NULL DEFAULT NULL,
  `actions_name` VARCHAR(255) NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_event_handlers_actions1_idx` (`actions_name` ASC) VISIBLE,
  CONSTRAINT `fk_event_handlers_actions1`
    FOREIGN KEY (`actions_name`)
    REFERENCES `actions` (`name`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `exp_event`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `exp_event` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `source` ENUM('pa','plesk') NULL DEFAULT NULL,
  `event_type` ENUM('started','stopped','created','updated','deleted','status_changed','terminated','flushed','installed','uninstalled','siteapp_added','siteapp_removed','expired','exceeded','guid_changed') NOT NULL DEFAULT 'started',
  `event_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `obj_class` VARCHAR(255) NOT NULL DEFAULT 'license',
  `obj_id` VARCHAR(255) NOT NULL,
  `host` VARCHAR(255) NOT NULL,
  `user` VARCHAR(255) NOT NULL,
  `flushed` ENUM('true','false') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`),
  INDEX `source` (`source` ASC, `event_type` ASC) VISIBLE,
  INDEX `source_2` (`source` ASC, `event_type` ASC, `obj_class` ASC) VISIBLE,
  INDEX `source_3` (`source` ASC, `event_time` ASC, `event_type` ASC, `obj_class` ASC) VISIBLE,
  INDEX `flushed` (`flushed` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `externalWebmails`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `externalWebmails` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NULL DEFAULT NULL,
  `url` VARCHAR(255) NULL DEFAULT NULL,
  `enabled` INT(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `name` (`name` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `fileSharingUsers`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `fileSharingUsers` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `userId` INT(11) NOT NULL,
  `login` VARCHAR(255) NOT NULL,
  `password` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `userId` (`userId` ASC) VISIBLE,
  UNIQUE INDEX `login` (`login` ASC) VISIBLE,
  CONSTRAINT `fileSharingUsers_ibfk_1`
    FOREIGN KEY (`userId`)
    REFERENCES `smb_users` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `forwarding`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `forwarding` (
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `redirect` VARCHAR(255) NULL DEFAULT NULL,
  `http_code` INT(10) UNSIGNED NOT NULL DEFAULT '301',
  PRIMARY KEY (`dom_id`),
  CONSTRAINT `forwarding_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ftp_users`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ftp_users` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `sys_user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `permission` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `external_id` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `sys_user_id` (`sys_user_id` ASC) VISIBLE,
  INDEX `dom_id` (`dom_id` ASC) VISIBLE,
  CONSTRAINT `ftp_users_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`),
  CONSTRAINT `ftp_users_ibfk_2`
    FOREIGN KEY (`sys_user_id`)
    REFERENCES `sys_users` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `hosting`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `hosting` (
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `sys_user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `real_traffic` BIGINT(20) UNSIGNED NULL DEFAULT '0',
  `ssi` ENUM('false','true') NOT NULL DEFAULT 'false',
  `ssi_html` ENUM('false','true') NOT NULL DEFAULT 'false',
  `php` ENUM('false','true') NOT NULL DEFAULT 'false',
  `php_isapi` ENUM('false','true') NOT NULL DEFAULT 'false',
  `php_handler_id` VARCHAR(255) NOT NULL DEFAULT 'fastcgi',
  `cgi` ENUM('false','true') NOT NULL DEFAULT 'false',
  `perl` ENUM('false','true') NOT NULL DEFAULT 'false',
  `python` ENUM('false','true') NOT NULL DEFAULT 'false',
  `asp` ENUM('false','true') NOT NULL DEFAULT 'false',
  `asp_dot_net` ENUM('false','true') NOT NULL DEFAULT 'false',
  `managed_runtime_version` VARCHAR(255) NOT NULL DEFAULT '',
  `ssl` ENUM('false','true') NOT NULL DEFAULT 'false',
  `webstat` VARCHAR(20) NOT NULL DEFAULT 'none',
  `at_domains` ENUM('false','true') NOT NULL DEFAULT 'false',
  `write_modify` VARCHAR(255) NULL DEFAULT NULL,
  `www_root` TEXT NOT NULL,
  `webdeploy` ENUM('false','true') NOT NULL DEFAULT 'false',
  `certificate_id` INT(10) UNSIGNED NULL DEFAULT '0',
  `traffic_bandwidth` INT(11) NULL DEFAULT '-1',
  `max_connection` INT(11) NULL DEFAULT '-1',
  `fastcgi` ENUM('false','true') NOT NULL DEFAULT 'false',
  `same_ssl` ENUM('false','true') NOT NULL DEFAULT 'true',
  `sslRedirect` ENUM('true', 'false') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`dom_id`),
  INDEX `sys_user_id` (`sys_user_id` ASC) VISIBLE,
  INDEX `certificate_id` (`certificate_id` ASC) VISIBLE,
  CONSTRAINT `hosting_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`),
  CONSTRAINT `hosting_ibfk_2`
    FOREIGN KEY (`sys_user_id`)
    REFERENCES `sys_users` (`id`),
  CONSTRAINT `hosting_ibfk_3`
    FOREIGN KEY (`certificate_id`)
    REFERENCES `certificates` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `hotlink_friends`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `hotlink_friends` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `dom_id` INT(10) UNSIGNED NOT NULL,
  `friend_dom` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `dom_id` (`dom_id` ASC) VISIBLE,
  CONSTRAINT `hotlink_friends_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `hotlink_prot`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `hotlink_prot` (
  `dom_id` INT(10) UNSIGNED NOT NULL,
  `enabled` ENUM('false','true') NOT NULL DEFAULT 'false',
  `extensions` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`dom_id`),
  CONSTRAINT `hotlink_prot_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `key_history`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `key_history` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `plesk_key_id` VARCHAR(63) NULL DEFAULT NULL,
  `name` VARCHAR(255) NULL DEFAULT NULL,
  `filename` VARCHAR(255) NULL DEFAULT NULL,
  `register_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_disabled` ENUM('false','true') NOT NULL DEFAULT 'false',
  `options` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `key_history_params`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `key_history_params` (
  `key_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `param` VARCHAR(63) NOT NULL,
  `val` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`key_id`, `param`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `locales`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `locales` (
  `id` VARCHAR(17) NOT NULL,
  `active` ENUM('false','true') NOT NULL DEFAULT 'true',
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `log_actions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `log_actions` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `date` DATETIME NULL DEFAULT NULL,
  `ip_address` VARCHAR(39) NOT NULL,
  `user` VARCHAR(255) NOT NULL,
  `object_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `actions_name` VARCHAR(255) NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_log_actions_actions1_idx` (`actions_name` ASC) VISIBLE,
  CONSTRAINT `fk_log_actions_actions1`
    FOREIGN KEY (`actions_name`)
    REFERENCES `actions` (`name`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `log_components`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `log_components` (
  `action_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `component` VARCHAR(255) NOT NULL,
  `old_value` VARCHAR(255) NOT NULL,
  `new_value` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`action_id`, `component`),
  INDEX `action_id` (`action_id` ASC) VISIBLE,
  CONSTRAINT `log_components_ibfk_1`
    FOREIGN KEY (`action_id`)
    REFERENCES `log_actions` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `log_rotation`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `log_rotation` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `period_type` ENUM('by_time','by_size') NOT NULL DEFAULT 'by_time',
  `period` VARCHAR(50) NULL DEFAULT NULL,
  `max_number_of_logfiles` BIGINT(20) UNSIGNED NULL DEFAULT '0',
  `compress_enable` ENUM('false','true') NOT NULL DEFAULT 'false',
  `email` VARCHAR(255) NULL DEFAULT NULL,
  `turned_on` ENUM('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `longtasks`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `longtasks` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` VARCHAR(255) NOT NULL,
  `status` VARCHAR(255) NOT NULL DEFAULT 'not_started',
  `statusProcessed` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `context` VARCHAR(255) NULL DEFAULT NULL,
  `progressStatus` VARCHAR(255) NOT NULL DEFAULT 'queue',
  `progressParams` BLOB NULL DEFAULT NULL,
  `progressMax` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `progressValue` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `startTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `finishTime` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `pid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `externalId` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `longtaskparams`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `longtaskparams` (
  `task_id` INT(10) UNSIGNED NOT NULL,
  `param` VARCHAR(255) NOT NULL,
  `val` MEDIUMTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`task_id`, `param`),
  CONSTRAINT `longtaskparams_ibfk_1`
    FOREIGN KEY (`task_id`)
    REFERENCES `longtasks` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `mail_aliases`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mail_aliases` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mn_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `alias` VARCHAR(245) NOT NULL,
  `apsServiceInstanceId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `mn_id` (`mn_id` ASC, `alias` ASC) VISIBLE,
  CONSTRAINT `mail_aliases_ibfk_1`
    FOREIGN KEY (`mn_id`)
    REFERENCES `mail` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `mail_redir`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mail_redir` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mn_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `address` VARCHAR(245) NOT NULL,
  `apsServiceInstanceId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  INDEX `mn_id` (`mn_id` ASC) VISIBLE,
  CONSTRAINT `mail_redir_ibfk_1`
    FOREIGN KEY (`mn_id`)
    REFERENCES `mail` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `mail_resp`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mail_resp` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mn_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `resp_name` VARCHAR(245) NOT NULL,
  `keystr` VARCHAR(255) NULL DEFAULT NULL,
  `key_where` ENUM('subj','body','no') NOT NULL DEFAULT 'no',
  `subject` VARCHAR(255) NULL DEFAULT NULL,
  `reply_to` VARCHAR(255) NULL DEFAULT NULL,
  `text` MEDIUMTEXT NULL DEFAULT NULL,
  `resp_on` ENUM('false','true') NOT NULL DEFAULT 'false',
  `ans_freq` INT(11) NULL DEFAULT '10',
  `mem_limit` INT(11) NULL DEFAULT '1000',
  `content_type` VARCHAR(245) NOT NULL DEFAULT 'text/plain',
  `charset` VARCHAR(245) NOT NULL DEFAULT 'UTF-8',
  `apsServiceInstanceId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `endDate` DATE NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `mn_id_resp_name` (`mn_id` ASC, `resp_name` ASC) VISIBLE,
  CONSTRAINT `mail_resp_ibfk_1`
    FOREIGN KEY (`mn_id`)
    REFERENCES `mail` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `mass_mail`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mass_mail` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `from_email` VARCHAR(255) NOT NULL,
  `to_admin` ENUM('false','true') NOT NULL DEFAULT 'false',
  `to_resellers` ENUM('false','true') NOT NULL DEFAULT 'false',
  `to_resellers_mode` ENUM('all','select','except') NOT NULL DEFAULT 'all',
  `to_clients` ENUM('false','true') NOT NULL DEFAULT 'false',
  `to_clients_mode` ENUM('all','select','except') NOT NULL DEFAULT 'all',
  `to_domains` ENUM('false','true') NOT NULL DEFAULT 'false',
  `to_domains_mode` ENUM('all','select','except') NOT NULL DEFAULT 'all',
  `subject` VARCHAR(255) NOT NULL,
  `body` TEXT NOT NULL,
  `cdate` DATE NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `name` (`name` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `mass_mail_clients`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mass_mail_clients` (
  `mm_id` INT(10) UNSIGNED NOT NULL,
  `cl_id` INT(10) UNSIGNED NOT NULL,
  UNIQUE INDEX `mm_cl` (`mm_id` ASC, `cl_id` ASC) VISIBLE,
  INDEX `mm_id` (`mm_id` ASC) VISIBLE,
  INDEX `cl_id` (`cl_id` ASC) VISIBLE,
  CONSTRAINT `mass_mail_clients_ibfk_1`
    FOREIGN KEY (`mm_id`)
    REFERENCES `mass_mail` (`id`),
  CONSTRAINT `mass_mail_clients_ibfk_2`
    FOREIGN KEY (`cl_id`)
    REFERENCES `clients` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `mass_mail_domains`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mass_mail_domains` (
  `mm_id` INT(10) UNSIGNED NOT NULL,
  `dom_id` INT(10) UNSIGNED NOT NULL,
  UNIQUE INDEX `mm_dom` (`mm_id` ASC, `dom_id` ASC) VISIBLE,
  INDEX `mm_id` (`mm_id` ASC) VISIBLE,
  INDEX `dom_id` (`dom_id` ASC) VISIBLE,
  CONSTRAINT `mass_mail_domains_ibfk_1`
    FOREIGN KEY (`mm_id`)
    REFERENCES `mass_mail` (`id`),
  CONSTRAINT `mass_mail_domains_ibfk_2`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `misc`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `misc` (
  `param` VARCHAR(255) NOT NULL,
  `val` VARCHAR(2000) NULL DEFAULT NULL,
  PRIMARY KEY (`param`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `mn_param`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mn_param` (
  `mn_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `param` VARCHAR(245) NOT NULL,
  `val` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`mn_id`, `param`),
  CONSTRAINT `mn_param_ibfk_1`
    FOREIGN KEY (`mn_id`)
    REFERENCES `mail` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `password_secrets`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `password_secrets` (
  `secret` VARCHAR(255) NOT NULL,
  `type` INT(10) UNSIGNED NOT NULL,
  `id` INT(10) UNSIGNED NOT NULL,
  `created` DATETIME NOT NULL,
  PRIMARY KEY (`secret`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `protected_dirs`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `protected_dirs` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `non_ssl` ENUM('false','true') NOT NULL DEFAULT 'false',
  `ssl` ENUM('false','true') NOT NULL DEFAULT 'false',
  `realm` VARCHAR(255) NULL DEFAULT NULL,
  `path` VARCHAR(245) NOT NULL,
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `dom_type` ENUM('domain','subdomain') NOT NULL DEFAULT 'domain',
  `cgi_bin` ENUM('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `dom_id` (`dom_id` ASC, `path` ASC) VISIBLE,
  CONSTRAINT `protected_dirs_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `pd_users`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `pd_users` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `login` VARCHAR(20) NOT NULL,
  `account_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `pd_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `pd_id` (`pd_id` ASC, `login` ASC) VISIBLE,
  INDEX `account_id` (`account_id` ASC) VISIBLE,
  CONSTRAINT `pd_users_ibfk_1`
    FOREIGN KEY (`account_id`)
    REFERENCES `accounts` (`id`),
  CONSTRAINT `pd_users_ibfk_2`
    FOREIGN KEY (`pd_id`)
    REFERENCES `protected_dirs` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `report`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `report` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_type` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(255) NULL DEFAULT NULL,
  `is_default` ENUM('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`),
  INDEX `user_id` (`user_id` ASC) VISIBLE,
  CONSTRAINT `report_ibfk_1`
    FOREIGN KEY (`user_id`)
    REFERENCES `clients` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `report_auto`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `report_auto` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `report_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `auto` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `last` DATETIME NULL DEFAULT NULL,
  `recipient` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `email` VARCHAR(254) NOT NULL,
  `client` INT(10) UNSIGNED NULL DEFAULT '0',
  `domain` INT(10) UNSIGNED NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  INDEX `report_id` (`report_id` ASC) VISIBLE,
  INDEX `client` (`client` ASC) VISIBLE,
  INDEX `domain` (`domain` ASC) VISIBLE,
  CONSTRAINT `report_auto_ibfk_1`
    FOREIGN KEY (`report_id`)
    REFERENCES `report` (`id`),
  CONSTRAINT `report_auto_ibfk_2`
    FOREIGN KEY (`client`)
    REFERENCES `clients` (`id`),
  CONSTRAINT `report_auto_ibfk_3`
    FOREIGN KEY (`domain`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `report_section`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `report_section` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `report_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(255) NOT NULL,
  `type` ENUM('none','summary','full') NOT NULL DEFAULT 'summary',
  PRIMARY KEY (`id`),
  INDEX `report_id` (`report_id` ASC) VISIBLE,
  CONSTRAINT `report_section_ibfk_1`
    FOREIGN KEY (`report_id`)
    REFERENCES `report` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `resp_attach`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `resp_attach` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `rn_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `filename` VARCHAR(245) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `rn_id` (`rn_id` ASC, `filename` ASC) VISIBLE,
  CONSTRAINT `resp_attach_ibfk_1`
    FOREIGN KEY (`rn_id`)
    REFERENCES `mail_resp` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `resp_forward`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `resp_forward` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `rn_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `address` VARCHAR(245) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `rn_id` (`rn_id` ASC) VISIBLE,
  CONSTRAINT `resp_forward_ibfk_1`
    FOREIGN KEY (`rn_id`)
    REFERENCES `mail_resp` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `resp_freq`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `resp_freq` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `rn_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `email` VARCHAR(245) NOT NULL,
  `num` INT(11) NULL DEFAULT '0',
  `time_resp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `rn_id` (`rn_id` ASC, `email` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `secret_keys`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `secret_keys` (
  `key_id` VARCHAR(255) NOT NULL,
  `ip_address` VARCHAR(39) NOT NULL,
  `description` VARCHAR(255) NOT NULL,
  `client_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  `lookup_id` VARCHAR(255) NULL DEFAULT NULL,
  INDEX `key_id` (`key_id` ASC) VISIBLE,
  INDEX `client_id` (`client_id` ASC) VISIBLE,
  INDEX `lookup_id` (`lookup_id` ASC) VISIBLE,
  CONSTRAINT `secret_keys_ibfk_1`
    FOREIGN KEY (`client_id`)
    REFERENCES `clients` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_apsBundleFilters`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_apsBundleFilters` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` ENUM('white','black') NOT NULL DEFAULT 'black',
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_apsBundleFilterItems`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_apsBundleFilterItems` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `filterId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `propertyName` VARCHAR(255) NULL DEFAULT NULL,
  `propertyValue` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `filterId_idx` (`filterId` ASC) VISIBLE,
  CONSTRAINT `smb_apsBundleFilterItems_ibfk_1`
    FOREIGN KEY (`filterId`)
    REFERENCES `smb_apsBundleFilters` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_apsCategories`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_apsCategories` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `name` (`name` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_apsInstanceErrors`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_apsInstanceErrors` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `instanceId` INT(11) NOT NULL,
  `creationDate` VARCHAR(25) NOT NULL,
  `text` TEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `instanceId` (`instanceId` ASC) VISIBLE,
  CONSTRAINT `smb_apsInstanceErrors_ibfk_1`
    FOREIGN KEY (`instanceId`)
    REFERENCES `smb_apsInstances` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_apsPackageUpdates`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_apsPackageUpdates` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `packageId` INT(11) NOT NULL,
  `updatePackageId` INT(11) NULL DEFAULT NULL,
  `catalog` VARCHAR(255) NULL DEFAULT NULL,
  `version` VARCHAR(255) NULL DEFAULT NULL,
  `release` VARCHAR(255) NULL DEFAULT NULL,
  `packager` VARCHAR(255) NULL DEFAULT NULL,
  `severity` VARCHAR(255) NULL DEFAULT NULL,
  `level` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `packageId` (`packageId` ASC) VISIBLE,
  CONSTRAINT `smb_apsPackageUpdates_ibfk_1`
    FOREIGN KEY (`packageId`)
    REFERENCES `smb_apsPackages` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_apsPackagesCategories`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_apsPackagesCategories` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `categoryId` INT(11) NULL DEFAULT NULL,
  `packageId` INT(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `categoryId_idx` (`categoryId` ASC) VISIBLE,
  INDEX `packageId_idx` (`packageId` ASC) VISIBLE,
  CONSTRAINT `smb_apsPackagesCategories_ibfk_1`
    FOREIGN KEY (`categoryId`)
    REFERENCES `smb_apsCategories` (`id`),
  CONSTRAINT `smb_apsPackagesCategories_ibfk_2`
    FOREIGN KEY (`packageId`)
    REFERENCES `smb_apsPackages` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_apsProvisions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_apsProvisions` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `class` VARCHAR(255) NOT NULL,
  `contextId` INT(11) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `contextId` (`contextId` ASC) VISIBLE,
  CONSTRAINT `smb_apsProvisions_ibfk_1`
    FOREIGN KEY (`contextId`)
    REFERENCES `smb_apsContexts` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_apsProvisionEnvironments`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_apsProvisionEnvironments` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `provisionId` INT(11) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `value` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `provisionId` (`provisionId` ASC) VISIBLE,
  CONSTRAINT `smb_apsProvisionEnvironments_ibfk_1`
    FOREIGN KEY (`provisionId`)
    REFERENCES `smb_apsProvisions` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_apsResources`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_apsResources` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `class` VARCHAR(255) NOT NULL,
  `contextId` INT(11) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `contextId` (`contextId` ASC) VISIBLE,
  CONSTRAINT `smb_apsResources_ibfk_1`
    FOREIGN KEY (`contextId`)
    REFERENCES `smb_apsContexts` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_apsResourceParameters`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_apsResourceParameters` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `resourceId` INT(11) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `value` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `resourceId` (`resourceId` ASC) VISIBLE,
  CONSTRAINT `smb_apsResourceParameters_ibfk_1`
    FOREIGN KEY (`resourceId`)
    REFERENCES `smb_apsResources` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_apsSettings`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_apsSettings` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `value` VARCHAR(255) NULL DEFAULT NULL,
  `contextId` INT(11) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_componentUpdates`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_componentUpdates` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `componentName` VARCHAR(255) NULL DEFAULT NULL,
  `version` VARCHAR(255) NULL DEFAULT NULL,
  `build` VARCHAR(255) NULL DEFAULT NULL,
  `shown` INT(11) NULL DEFAULT '0',
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_fileSharingUnlistedFiles`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_fileSharingUnlistedFiles` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `creationDate` VARCHAR(25) NOT NULL,
  `salt` VARCHAR(255) NULL DEFAULT NULL,
  `name` VARCHAR(255) NULL DEFAULT NULL,
  `path` VARCHAR(255) NULL DEFAULT NULL,
  `expiration` INT(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_generalPermissions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_generalPermissions` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `code` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_locales`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_locales` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `code` VARCHAR(255) NULL DEFAULT NULL,
  `title` VARCHAR(255) NULL DEFAULT NULL,
  `isActive` INT(11) NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `code` (`code` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_productUpgrades`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_productUpgrades` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `releaseId` VARCHAR(255) NULL DEFAULT NULL,
  `version` VARCHAR(255) NULL DEFAULT NULL,
  `description` VARCHAR(255) NULL DEFAULT NULL,
  `shown` INT(11) NULL DEFAULT '0',
  `codename` VARCHAR(255) NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_roleGeneralPermissions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_roleGeneralPermissions` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `roleId` INT(11) NOT NULL,
  `generalPermissionId` INT(11) NOT NULL,
  `isAllowed` INT(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `roleId_idx` (`roleId` ASC) VISIBLE,
  INDEX `generalPermissionId` (`generalPermissionId` ASC) VISIBLE,
  CONSTRAINT `smb_roleGeneralPermissions_ibfk_1`
    FOREIGN KEY (`roleId`)
    REFERENCES `smb_roles` (`id`),
  CONSTRAINT `smb_roleGeneralPermissions_ibfk_2`
    FOREIGN KEY (`generalPermissionId`)
    REFERENCES `smb_generalPermissions` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_serviceProviders`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_serviceProviders` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `classname` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_serviceInstances`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_serviceInstances` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `description` VARCHAR(255) NULL DEFAULT NULL,
  `serviceProviderId` INT(11) NOT NULL,
  `externalId` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `serviceProviderId` (`serviceProviderId` ASC) VISIBLE,
  CONSTRAINT `smb_serviceInstances_ibfk_1`
    FOREIGN KEY (`serviceProviderId`)
    REFERENCES `smb_serviceProviders` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_servicePermissions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_servicePermissions` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `serviceInstanceId` INT(11) NOT NULL,
  `serviceProviderId` INT(11) NOT NULL,
  `permissionCode` VARCHAR(255) NULL DEFAULT NULL,
  `class` VARCHAR(255) NULL DEFAULT NULL,
  `status` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `serviceInstanceId` (`serviceInstanceId` ASC) VISIBLE,
  INDEX `serviceProviderId` (`serviceProviderId` ASC) VISIBLE,
  CONSTRAINT `smb_servicePermissions_ibfk_1`
    FOREIGN KEY (`serviceInstanceId`)
    REFERENCES `smb_serviceInstances` (`id`),
  CONSTRAINT `smb_servicePermissions_ibfk_2`
    FOREIGN KEY (`serviceProviderId`)
    REFERENCES `smb_serviceProviders` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_roleServicePermissions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_roleServicePermissions` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `roleId` INT(11) NOT NULL,
  `servicePermissionId` INT(11) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `roleId` (`roleId` ASC) VISIBLE,
  INDEX `servicePermissionId` (`servicePermissionId` ASC) VISIBLE,
  CONSTRAINT `smb_roleServicePermissions_ibfk_1`
    FOREIGN KEY (`roleId`)
    REFERENCES `smb_roles` (`id`),
  CONSTRAINT `smb_roleServicePermissions_ibfk_2`
    FOREIGN KEY (`servicePermissionId`)
    REFERENCES `smb_servicePermissions` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_serviceEntryPoints`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_serviceEntryPoints` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `servicePermissionId` INT(11) NOT NULL,
  `externalId` VARCHAR(255) NULL DEFAULT NULL,
  `label` VARCHAR(255) NULL DEFAULT NULL,
  `description` VARCHAR(255) NULL DEFAULT NULL,
  `icon` VARCHAR(255) NULL DEFAULT NULL,
  `redirectUrl` VARCHAR(255) NULL DEFAULT NULL,
  `hidden` INT(11) NULL DEFAULT '0',
  `http` INT(11) NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  INDEX `servicePermissionId` (`servicePermissionId` ASC) VISIBLE,
  CONSTRAINT `smb_serviceEntryPoints_ibfk_1`
    FOREIGN KEY (`servicePermissionId`)
    REFERENCES `smb_servicePermissions` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_servicePermissionAccounts`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_servicePermissionAccounts` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `userId` INT(11) NOT NULL,
  `servicePermissionId` INT(11) NOT NULL,
  `externalId` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `userId` (`userId` ASC) VISIBLE,
  INDEX `servicePermissionId` (`servicePermissionId` ASC) VISIBLE,
  CONSTRAINT `smb_servicePermissionAccounts_ibfk_1`
    FOREIGN KEY (`userId`)
    REFERENCES `smb_users` (`id`),
  CONSTRAINT `smb_servicePermissionAccounts_ibfk_2`
    FOREIGN KEY (`servicePermissionId`)
    REFERENCES `smb_servicePermissions` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_settings`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_settings` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NULL DEFAULT NULL,
  `value` TEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `name` (`name` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smb_userServicePermissions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smb_userServicePermissions` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `userId` INT(11) NOT NULL,
  `servicePermissionId` INT(11) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `userId` (`userId` ASC) VISIBLE,
  INDEX `servicePermissionId` (`servicePermissionId` ASC) VISIBLE,
  CONSTRAINT `smb_userServicePermissions_ibfk_1`
    FOREIGN KEY (`userId`)
    REFERENCES `smb_users` (`id`),
  CONSTRAINT `smb_userServicePermissions_ibfk_2`
    FOREIGN KEY (`servicePermissionId`)
    REFERENCES `smb_servicePermissions` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `smtp_poplocks`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `smtp_poplocks` (
  `ip_address` VARCHAR(39) NOT NULL,
  `ip_mask` INT(10) UNSIGNED NOT NULL DEFAULT '32',
  `lock_time` DATETIME NULL DEFAULT NULL,
  `serviceNodeId` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  INDEX `ip_address` (`ip_address` ASC) VISIBLE,
  INDEX `serviceNodeId` (`serviceNodeId` ASC) VISIBLE,
  CONSTRAINT `smtp_poplocks_ibfk_1`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `spamfilter`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `spamfilter` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(128) NOT NULL,
  `serviceNodeId` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `preferences` ENUM('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `spamfilter_username_serviceNodeId` (`username` ASC, `serviceNodeId` ASC) VISIBLE,
  INDEX `serviceNodeId` (`serviceNodeId` ASC) VISIBLE,
  CONSTRAINT `spamfilter_ibfk_1`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `spamfilter_preferences`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `spamfilter_preferences` (
  `prefid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `spamfilter_id` INT(10) UNSIGNED NOT NULL,
  `preference` VARCHAR(30) NOT NULL,
  `value` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`prefid`),
  INDEX `spamfilter_id` (`spamfilter_id` ASC, `preference` ASC, `value` ASC) VISIBLE,
  CONSTRAINT `spamfilter_preferences_ibfk_1`
    FOREIGN KEY (`spamfilter_id`)
    REFERENCES `spamfilter` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `stat`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `stat` (
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `date` DATE NOT NULL DEFAULT '0000-00-00',
  `transfer` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
  PRIMARY KEY (`dom_id`, `date`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `subdomains`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `subdomains` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(255) NOT NULL,
  `displayName` VARCHAR(255) NOT NULL,
  `sys_user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ssi` ENUM('false','true') NOT NULL DEFAULT 'false',
  `php` ENUM('false','true') NOT NULL DEFAULT 'false',
  `php_handler_type` ENUM('cgi','fastcgi','module','isapi') NOT NULL DEFAULT 'module',
  `cgi` ENUM('false','true') NOT NULL DEFAULT 'false',
  `perl` ENUM('false','true') NOT NULL DEFAULT 'false',
  `python` ENUM('false','true') NOT NULL DEFAULT 'false',
  `coldfusion` ENUM('false','true') NOT NULL DEFAULT 'false',
  `asp` ENUM('false','true') NOT NULL DEFAULT 'false',
  `asp_dot_net` ENUM('false','true') NOT NULL DEFAULT 'false',
  `ssl` ENUM('false','true') NOT NULL DEFAULT 'false',
  `www_root` VARCHAR(255) NOT NULL DEFAULT 'httpdocs',
  `maintenance_mode` ENUM('false','true') NOT NULL DEFAULT 'false',
  `certificate_id` INT(10) UNSIGNED NULL DEFAULT '0',
  `fastcgi` ENUM('false','true') NOT NULL DEFAULT 'false',
  `same_ssl` ENUM('false','true') NOT NULL DEFAULT 'true',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `dom_id` (`dom_id` ASC, `name` ASC) VISIBLE,
  INDEX `dom_id_displayName` (`dom_id` ASC, `displayName` ASC) VISIBLE,
  INDEX `sys_user_id` (`sys_user_id` ASC) VISIBLE,
  CONSTRAINT `subdomains_ibfk_1`
    FOREIGN KEY (`sys_user_id`)
    REFERENCES `sys_users` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `suspend_handler_history`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `suspend_handler_history` (
  `dom_id` INT(10) UNSIGNED NOT NULL,
  `session_id` VARCHAR(255) NULL DEFAULT NULL,
  INDEX `dom_id` (`dom_id` ASC) VISIBLE,
  CONSTRAINT `suspend_handler_history_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `upgrade_history`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `upgrade_history` (
  `upgrade_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `version_info` VARCHAR(50) NULL DEFAULT NULL,
  `db_version` VARCHAR(50) NULL DEFAULT NULL,
  `os` VARCHAR(255) NULL DEFAULT NULL,
  `mu` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`upgrade_date`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `web_users`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `web_users` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `sys_user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ssi` ENUM('false','true') NOT NULL DEFAULT 'false',
  `ssi_html` ENUM('false','true') NOT NULL DEFAULT 'false',
  `php` ENUM('false','true') NOT NULL DEFAULT 'false',
  `php_isapi` ENUM('false','true') NOT NULL DEFAULT 'false',
  `cgi` ENUM('false','true') NOT NULL DEFAULT 'false',
  `perl` ENUM('false','true') NOT NULL DEFAULT 'false',
  `python` ENUM('false','true') NOT NULL DEFAULT 'false',
  `asp` ENUM('false','true') NOT NULL DEFAULT 'false',
  `asp_dot_net` ENUM('false','true') NOT NULL DEFAULT 'false',
  `managed_runtime_version` VARCHAR(255) NOT NULL DEFAULT '1.1',
  `write_modify` VARCHAR(255) NULL DEFAULT NULL,
  `fastcgi` ENUM('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `sys_user_id` (`sys_user_id` ASC) VISIBLE,
  INDEX `dom_id` (`dom_id` ASC) VISIBLE,
  CONSTRAINT `web_users_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`),
  CONSTRAINT `web_users_ibfk_2`
    FOREIGN KEY (`sys_user_id`)
    REFERENCES `sys_users` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `webalizer_group_referrer`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `webalizer_group_referrer` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `dom_id` INT(10) UNSIGNED NOT NULL,
  `group_name` VARCHAR(255) NOT NULL,
  `referrer` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `dom_id` (`dom_id` ASC) VISIBLE,
  CONSTRAINT `webalizer_group_referrer_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `webalizer_hidden_referrer`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `webalizer_hidden_referrer` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `dom_id` INT(10) UNSIGNED NOT NULL,
  `referrer` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `dom_id` (`dom_id` ASC) VISIBLE,
  CONSTRAINT `webalizer_hidden_referrer_ibfk_1`
    FOREIGN KEY (`dom_id`)
    REFERENCES `domains` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ComposerInstances`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ComposerInstances` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `webspaceId` INT(10) UNSIGNED NOT NULL,
  `path` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255) NULL,
  PRIMARY KEY (`id`),
  INDEX `webspaceId` (`webspaceId` ASC) VISIBLE,
  UNIQUE INDEX `path` (`webspaceId` ASC, `path` ASC) VISIBLE,
  CONSTRAINT `ComposerInstances_ibfk_1`
    FOREIGN KEY (`webspaceId`)
    REFERENCES `domains` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `CliCallsStat`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CliCallsStat` (
  `id` INT(10) UNSIGNED NOT NULL,
  `util` VARCHAR(255) NOT NULL,
  `command` VARCHAR(255) NOT NULL,
  `lasExecutionDateTime` DATETIME NOT NULL DEFAULT 0000-00-00 00:00:00,
  `count` BIGINT(20) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `utilCommand` (`command` ASC, `util` ASC) VISIBLE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `DatabaseCustomHosts`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `DatabaseCustomHosts` (
  `id` INT UNSIGNED NOT NULL,
  `host` VARCHAR(255) NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `idkey`
    FOREIGN KEY (`id`)
    REFERENCES `data_bases` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `PackageUpdateLocks`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PackageUpdateLocks` (
  `id` INT UNSIGNED NOT NULL,
  `serviceNodeId` INT UNSIGNED NOT NULL,
  `package` VARCHAR(255) NULL,
  PRIMARY KEY (`id`),
  INDEX `serviceNodeId_idx` (`serviceNodeId` ASC) VISIBLE,
  CONSTRAINT `serviceNodeId`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `PackageUpdateNotifications`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PackageUpdateNotifications` (
  `id` INT UNSIGNED NOT NULL,
  `serviceNodeId` INT UNSIGNED NOT NULL,
  `eventDate` DATETIME NOT NULL DEFAULT 0000-00-00 00:00:00,
  `notificationSent` INT(1) NOT NULL DEFAULT 0,
  `data` MEDIUMTEXT NULL,
  PRIMARY KEY (`id`),
  INDEX `serviceNodeId_idx` (`serviceNodeId` ASC) VISIBLE,
  UNIQUE INDEX `eventDate_UNIQUE` (`eventDate` ASC, `serviceNodeId` ASC) VISIBLE,
  INDEX `notificationSent` (`notificationSent` ASC) VISIBLE,
  CONSTRAINT `serviceNodeId`
    FOREIGN KEY (`serviceNodeId`)
    REFERENCES `ServiceNodes` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `EmailActivations`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `EmailActivations` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `hash` VARCHAR(255) NOT NULL,
  `created` DATETIME NULL DEFAULT 1970-01-01 00:00:00,
  `clientsId` INT(11) UNSIGNED NULL DEFAULT 0,
  `smbUserId` INT(11) UNSIGNED NULL DEFAULT 0,
  `adminAliasId` INT(11) UNSIGNED NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  INDEX `fk_EmailActivations_clients1_idx` (`clientsId` ASC) VISIBLE,
  INDEX `fk_EmailActivations_smb_users1_idx` (`smbUserId` ASC) VISIBLE,
  INDEX `fk_EmailActivations_admin_aliases1_idx` (`adminAliasId` ASC) VISIBLE,
  CONSTRAINT `fk_EmailActivations_clients1`
    FOREIGN KEY (`clientsId`)
    REFERENCES `clients` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_EmailActivations_smb_users1`
    FOREIGN KEY (`smbUserId`)
    REFERENCES `smb_users` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_EmailActivations_admin_aliases1`
    FOREIGN KEY (`adminAliasId`)
    REFERENCES `admin_aliases` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;