Open janpio opened 4 years ago
Was more of a joke :trollface: - but sure 🤷♂
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
I couldn't find the SQL, @janpio if you are able to, please re-assign me.
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;
@schickling suggested we also look at the Plesk schema