Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
dns_refs Table zoneId INT UNSIGNED 10 null
SiteAppsHitsStat Table count BIGINT UNSIGNED 20 0
Subscriptions Table synchronized enum('false', 'true') 6 true
report_section Table report_id INT UNSIGNED 10 0
Limits Table value BIGINT 19 √ null
key_history Table plesk_key_id VARCHAR 63 √ null
ServiceInstanceResources Table serviceResourceType VARCHAR 255 null
dom_param Table dom_id INT UNSIGNED 10 0
domains Table limits_id INT UNSIGNED 10 0
sessions Table ip_address VARCHAR 39 √ null
log_actions Table id INT UNSIGNED 10 √ null
clients Table account_id INT UNSIGNED 10 null
smb_servicePermissionAccounts Table servicePermissionId INT 10 null
subdomains Table perl enum('false', 'true') 6 false
dns_zone Table status INT UNSIGNED 10 0
admin_aliases Table id INT UNSIGNED 10 √ null
dns_recs_t Table displayHost VARCHAR 255 null
ServiceInstallationProperties Table serviceInstallationId INT UNSIGNED 10 null
suspend_handler_history Table session_id VARCHAR 255 √ null
apsContextsApplications Table registryApplicationId VARCHAR 36 null
report Table id INT UNSIGNED 10 √ null
ServiceLimits Table limitName VARCHAR 255 null
Cards Table fax VARCHAR 255 √ null
dns_zone Table name VARCHAR 255 null
PlanServiceInstallations Table serviceInstallationId INT UNSIGNED 10 null
disk_usage Table httpsdocs BIGINT UNSIGNED 20 √ 0
SubscriptionOutgoingMessagesStats Table collectDate DATETIME 19 null
PlanServiceProperties Table value TEXT 65535 √ null
IisAppPools Table recyclingByTime INT 10 1740
ftp_users Table permission BIGINT UNSIGNED 20 0
IpAddressesCollections Table ipCollectionId INT UNSIGNED 10 null
smb_apsPackagesCategories Table packageId INT 10 √ null
ServiceInstanceResources Table serviceInstanceId INT UNSIGNED 10 null
hotlink_prot Table extensions VARCHAR 255 null
clients Table pname VARCHAR 255 null
disk_usage Table web_users BIGINT UNSIGNED 20 √ 0
smb_apsPackages Table registryUid VARCHAR 36 √ null
dns_zone Table refresh INT UNSIGNED 10 10800
log_components Table action_id INT UNSIGNED 10 0
avstatistics Table id INT UNSIGNED 10 √ null
ftp_users Table external_id VARCHAR 255 √ null
ServiceNodeConfiguration Table section VARCHAR 255 null
domains Table icpPermit VARCHAR 255 √ null
mail_resp Table content_type VARCHAR 245 text/plain
ScheduledTasks Table minute VARCHAR 255 null
admin_aliases_param Table alias_id INT UNSIGNED 10 0
hotlink_friends Table dom_id INT UNSIGNED 10 null
APSApplicationItems Table pkg_id INT UNSIGNED 10 0
smb_settings Table id INT 10 √ null
DatabaseUserRemoteAccessRules Table mask VARCHAR 15 null
BackupsSettings Table value VARCHAR 255 √ null
smb_serviceInstances Table serviceProviderId INT 10 null
disk_usage Table maillists BIGINT UNSIGNED 20 √ 0
smb_apsPackageUpdates Table severity VARCHAR 255 √ null
TraceFailedRequestsProviders Table name VARCHAR 255 null
ServiceInstallations Table serviceNodeId INT UNSIGNED 10 null
GL_remote_domains Table serviceNodeId INT UNSIGNED 10 1
ScheduledTasks Table emailType enum('default', 'owner', 'custom') 8 owner
smb_apsInstanceErrors Table creationDate VARCHAR 25 null
apsResourcesParameters Table id INT UNSIGNED 10 √ null
actions Table id INT UNSIGNED 10 √ null
domain_aliases Table tomcat enum('true', 'false') 5 false
SubscriptionOutgoingMessagesStats Table subscriptionId INT UNSIGNED 10 null
ServiceInstances Table reference VARCHAR 255 √ null
TraceFailedRequestsProviderAreas Table id INT UNSIGNED 10 √ null
disk_usage Table httpdocs BIGINT UNSIGNED 20 √ 0
dns_refs Table templateRecordId INT UNSIGNED 10 √ null
PackageUpdateNotifications Table serviceNodeId INT UNSIGNED 10 null
smb_apsInstances Table contextId INT 10 null
hosting Table webdeploy enum('false', 'true') 6 false
CliCallsStat Table util VARCHAR 255 null
BackupExcludeFiles Table id INT UNSIGNED 10 null
Modules Table icon VARCHAR 255 null
WebApps Table status INT 10 0
IisAppPoolsPolicy Table serviceNodeId INT UNSIGNED 10 1
smb_users Table city VARCHAR 255 √ null
PackageUpdateLocks Table package VARCHAR 255 √ null
secret_keys Table lookup_id VARCHAR 255 √ null
PlanServiceInstallations Table planId INT UNSIGNED 10 null
ScheduledTasks Table serviceNodeId INT UNSIGNED 10 null
password_secrets Table type INT UNSIGNED 10 null
smb_apsMetas Table serviceId VARCHAR 255 √ null
Parameters Table parameter VARCHAR 255 null
smb_serviceProviders Table id INT 10 √ null
smb_serviceEntryPoints Table http INT 10 √ 0
data_bases Table default_user_id INT UNSIGNED 10 √ null
spamfilter_preferences Table spamfilter_id INT UNSIGNED 10 null
smb_users Table isDomainAdmin INT 10 √ 0
IisAppPoolsPolicy Table mode enum('shared', 'dedicated', 'mixed') 9 mixed
spamfilter Table preferences enum('false', 'true') 6 false
log_rotation Table period VARCHAR 50 √ null
password_secrets Table id INT UNSIGNED 10 null
smb_users Table roleId INT 10 null
anon_ftp Table status enum('false', 'true') 6 false
dns_zone Table retry INT UNSIGNED 10 3600
smb_users Table sessionId VARCHAR 255 √ null
IP_Addresses Table public_ip_address VARCHAR 39 √ null
LimitsReservation Table id INT UNSIGNED 10 √ null
IisAppPools Table cpuLimitInterval INT UNSIGNED 10 5
smb_userServicePermissions Table servicePermissionId INT 10 null
domains Table status BIGINT UNSIGNED 20 0
PleskStats Table value BLOB 65535 √ null
SubscriptionProperties Table name VARCHAR 255 null
RestrictedDomains Table id INT UNSIGNED 10 √ null
SBResellers Table client_id INT UNSIGNED 10 null
DomainsTraffic Table http_out BIGINT UNSIGNED 20 0
smtp_poplocks Table serviceNodeId INT UNSIGNED 10 1
hosting Table at_domains enum('false', 'true') 6 false
web_users Table php_isapi enum('false', 'true') 6 false
mass_mail Table id INT UNSIGNED 10 √ null
Logos Table url VARCHAR 255 √ null
DomainOutgoingMessagesStats Table collectDate DATETIME 19 null
domain_aliases Table dom_id INT UNSIGNED 10 0
dsn Table serviceNodeId INT UNSIGNED 10 1
CliCallsStat Table count BIGINT UNSIGNED 20 null
dns_recs_t Table val VARCHAR 255 null
IisAppPools Table maxProcesses INT UNSIGNED 10 1
dns_zone Table email VARCHAR 255 √ null
SSOBranding Table idp_url VARCHAR 255 null
clients Table cr_date DATE 10 √ null
smb_generalPermissions Table code VARCHAR 255 √ null
mail Table apsAntispamServiceInstanceId INT UNSIGNED 10 0
domains Table dns_zone_id INT UNSIGNED 10 √ null
APSCatalogUpdates Table package_name VARCHAR 255 √ null
mn_param Table val VARCHAR 255 √ null
smb_generalPermissions Table id INT 10 √ null
apsContextsApplications Table id INT UNSIGNED 10 √ null
longtasks Table id INT UNSIGNED 10 √ null
upgrade_history Table upgrade_date DATETIME 19 0000-00-00 00:00:00
ServiceInstanceDepends Table requiredInstanceId INT UNSIGNED 10 null
smb_apsPackageUpdates Table level VARCHAR 255 √ null
domain_aliases Table id INT UNSIGNED 10 √ null
mass_mail_clients Table cl_id INT UNSIGNED 10 null
web_users Table fastcgi enum('false', 'true') 6 false
BackupsScheduled Table rotation INT 10 0
MailOutgoingMessagesStats Table collectDate DATETIME 19 null
ServiceInstanceProperties Table serviceInstanceId INT UNSIGNED 10 null
domains Table cl_id INT UNSIGNED 10 0
Webmails Table serviceNodeId INT UNSIGNED 10 1
IpCollections Table id INT UNSIGNED 10 √ null
smb_apsPackageUpdates Table catalog VARCHAR 255 √ null
mass_mail Table to_admin enum('false', 'true') 6 false
report_auto Table auto INT UNSIGNED 10 0
forwarding Table dom_id INT UNSIGNED 10 0
PhpSettingsCustom Table id INT UNSIGNED 10 null
stat Table date DATE 10 0000-00-00
log_actions Table object_id INT UNSIGNED 10 0
TraceFailedRequestsRules Table isEnabled INT 10 0
log_actions Table date DATETIME 19 √ null
DynamicIpSecurity Table isDenyByRequestRate INT 10 0
smb_apsResources Table contextId INT 10 null
mail_redir Table id INT UNSIGNED 10 √ null
clients Table passwd VARCHAR 20 null
APSClientApplicationItems Table client_id INT UNSIGNED 10 0
mail_resp Table endDate DATE 10 √ null
smb_apsMetas Table class VARCHAR 255 √ null
PlanItems Table applicableToSite INT UNSIGNED 10 0
smtp_poplocks Table ip_address VARCHAR 39 null
dns_zone Table expire_unit INT UNSIGNED 10 1
PackageUpdateNotifications Table notificationSent INT 10 0
domain_aliases Table icpStatus INT 10 0
cp_access Table netmask VARCHAR 15 null
externalWebmails Table id INT UNSIGNED 10 √ null
subdomains Table name VARCHAR 255 null
MailLists Table status BIGINT UNSIGNED 20 0
ServiceNodeConfiguration Table value TEXT 65535 √ null
smb_servicePermissions Table serviceProviderId INT 10 null
web_users Table dom_id INT UNSIGNED 10 0
Webmails Table version VARCHAR 255 null
IisAppPools Table cpuLimit INT 10 -1
dns_recs_t Table type enum('NS', 'A', 'AAAA', 'CNAME', 'MX', 'PTR', 'TXT', 'SRV') 5 A
ServiceInstanceProperties Table name VARCHAR 255 null
IisAppPools Table ownerId INT UNSIGNED 10 null
apsResourcesParameters Table value VARCHAR 255 √ null
report_section Table type enum('none', 'summary', 'full') 7 summary
PlanServiceInstallations Table assigned INT UNSIGNED 10 1
smb_users Table imNumber VARCHAR 255 √ null
DatabaseServers Table admin_login CHAR 255 null
subdomains Table same_ssl enum('false', 'true') 6 true
smtp_poplocks Table lock_time DATETIME 19 √ null
event_handlers Table user VARCHAR 255 nobody
sessions Table lifetime INT UNSIGNED 10 √ null
dsn Table dom_id INT UNSIGNED 10 √ null
protected_dirs Table dom_id INT UNSIGNED 10 0
Notifications Table status VARCHAR 1 null
Configurations Table description BLOB 65535 √ null
LimitsReservation Table value BIGINT 19 √ null
admin_aliases Table comments VARCHAR 255 null
certificates Table name VARCHAR 255 null
exp_event Table source enum('pa', 'plesk') 5 √ null
WebApps Table id INT UNSIGNED 10 √ null
BlUpgradeActions Table id INT UNSIGNED 10 √ null
Skins Table place VARCHAR 255 null
ScheduledTasks Table command TEXT 65535 null
forwarding Table http_code INT UNSIGNED 10 301
clients Table pool_id INT UNSIGNED 10 0
Configurations Table version VARCHAR 255 null
ServiceNodeCertificates Table certFile VARCHAR 255 √ null
DomainOutgoingMessagesPeaks Table domainId INT UNSIGNED 10 null
smb_users Table address TEXT 65535 √ null
SiteAppsHitsStat Table id INT UNSIGNED 10 √ null
misc Table param VARCHAR 255 null
IP_Addresses Table serviceNodeId INT UNSIGNED 10 1
BackupsScheduled Table processed enum('false', 'true') 6 null
BackupsScheduled Table backupExcludeLogs INT 10 0
ScheduledTasks Table period INT UNSIGNED 10 0
web_users Table ssi_html enum('false', 'true') 6 false
PackageUpdateLocks Table serviceNodeId INT UNSIGNED 10 null
webalizer_hidden_referrer Table dom_id INT UNSIGNED 10 null
WebServerSettingsParameters Table webServerSettingsId INT UNSIGNED 10 null
Repository Table rep_id INT UNSIGNED 10 √ null
MailMessagesStat Table date DATE 10 0000-00-00
mail Table userId INT 10 √ null
dsn Table cstring TEXT 65535 √ null
PhpSettingsParameters Table id INT UNSIGNED 10 0
Webmails Table docroot VARCHAR 255 null
apsInstancesParameters Table instanceId INT UNSIGNED 10 null
PhpSettingsCustom Table value TEXT 65535 √ null
mass_mail Table cdate DATE 10 √ null
disk_usage Table mysql_dbases BIGINT UNSIGNED 20 0
ScheduledTasks Table hash VARCHAR 255 null
DatabaseServers Table id INT UNSIGNED 10 √ null
ServiceNodeEnvironment Table value TEXT 65535 √ null
event_handlers Table id INT UNSIGNED 10 √ null
APSLicenseTypes Table application_versions VARCHAR 255 null
dom_param Table val VARCHAR 255 √ null
smb_locales Table isActive INT 10 √ 1
log_rotation Table period_type enum('by_time', 'by_size') 8 by_time
dns_recs Table displayVal VARCHAR 255 null
mail_resp Table resp_on enum('false', 'true') 6 false
mail Table disk_usage BIGINT UNSIGNED 20 0
SchemaVersions Table version VARCHAR 14 null
ServiceInstances Table servicePackageId INT UNSIGNED 10 null
exp_event Table obj_id VARCHAR 255 null
Subscriptions Table object_id INT UNSIGNED 10 null
APSLicenseTypes Table application_features VARCHAR 255 null
ServiceNodes Table type VARCHAR 255 plesk
smb_servicePermissions Table class VARCHAR 255 √ null
TraceFailedRequestsProviders Table id INT UNSIGNED 10 √ null
custom_buttons Table url VARCHAR 255 √ null
disk_usage Table domaindumps BIGINT UNSIGNED 20 √ 0
BackupsScheduled Table repository enum('local', 'ftp') 6 local
hosting Table same_ssl enum('false', 'true') 6 true
longtasks Table startTime TIMESTAMP 19 CURRENT_TIMESTAMP
certificates Table csr BLOB 65535 √ null
dom_level_usrs Table account_id INT UNSIGNED 10 √ null
hosting Table www_root TEXT 65535 null
mail Table postbox enum('false', 'true') 6 false
sessions Table type SMALLINT UNSIGNED 5 0
ComposerInstances Table webspaceId INT UNSIGNED 10 null
badmailfrom Table id INT UNSIGNED 10 √ null
Modules Table release INT UNSIGNED 10 null
ServiceInstanceProperties Table value TEXT 65535 √ null
externalWebmails Table name VARCHAR 255 √ null
Subscriptions Table uuid VARCHAR 36 √ null
smb_apsContexts Table id INT 10 √ null
ComposerInstances Table name VARCHAR 255 √ null
clients Table params_id INT UNSIGNED 10 0
TraceFailedRequestsRules Table stopDate DATETIME 19 0000-00-00 00:00:00
ScheduledTasks Table type enum('exec', 'http', 'php') 5 exec
smb_apsResourceParameters Table name VARCHAR 255 null
ip_pool Table type enum('shared', 'exclusive') 9 shared
ClientsTraffic Table cl_id INT UNSIGNED 10 0
smb_apsPackages Table cacheId VARCHAR 255 null
mail_redir Table apsServiceInstanceId INT UNSIGNED 10 0
db_users Table id INT UNSIGNED 10 √ null
domains Table permissions_id INT UNSIGNED 10 0
mail_resp Table mn_id INT UNSIGNED 10 0
key_history Table name VARCHAR 255 √ null
clients Table limits_id INT UNSIGNED 10 √ 0
disk_usage Table dbases BIGINT UNSIGNED 20 √ 0
DomainOutgoingMessagesPeaks Table endDate DATETIME 19 √ null
ServiceInstanceResources Table reference VARCHAR 255 null
webalizer_group_referrer Table id INT UNSIGNED 10 √ null
longtasks Table externalId VARCHAR 255 √ null
Templates Table id INT UNSIGNED 10 √ null
hosting Table asp_dot_net enum('false', 'true') 6 false
Notifications Table send2dlu VARCHAR 1 null
Permissions Table value VARCHAR 255 √ null
BlUpgradeActions Table message VARCHAR 255 √ null
DynamicIpSecurity Table isDenyByConcurrentRequests INT 10 0
APSClientApplicationItems Table id INT UNSIGNED 10 √ null
TraceFailedRequestsProviderAreas Table providerId INT UNSIGNED 10 null
dom_level_usrs Table perm_id INT UNSIGNED 10 √ null
PlanItems Table uuid VARCHAR 36 null
apscategories Table parent_id INT UNSIGNED 10 0
smb_productUpgrades Table codename VARCHAR 255 √ null
smb_apsMetas Table xpath VARCHAR 255 √ null
pd_users Table id INT UNSIGNED 10 √ null
IisAppPools Table serviceNodeId INT UNSIGNED 10 1
domains Table vendor_id INT UNSIGNED 10 0
disk_usage Table chroot BIGINT UNSIGNED 20 √ 0
DomainOutgoingMessagesStats Table domainId INT UNSIGNED 10 null
resp_freq Table time_resp TIMESTAMP 19 CURRENT_TIMESTAMP
DatabaseUserRemoteAccessRules Table firewallRuleId VARCHAR 255 √ null
ApsTokens Table subscriptionId INT UNSIGNED 10 null
Cards Table personalName VARCHAR 255 null
BackupsSettings Table type enum('domain', 'client', 'server') 7 domain
report_auto Table report_id INT UNSIGNED 10 0
hosting Table sslRedirect enum('true', 'false') 5 false
smb_componentUpdates Table version VARCHAR 255 √ null
log_actions Table user VARCHAR 255 null
smb_apsPackageUpdates Table id INT 10 √ null
IisAppPools Table id INT UNSIGNED 10 √ null
dns_recs Table host VARCHAR 255 null
smb_users Table password VARCHAR 255 √ null
longtasks Table statusProcessed INT UNSIGNED 10 0
disk_usage Table www_root BIGINT UNSIGNED 20 √ 0
mail Table apsAntivirusServiceInstanceId INT UNSIGNED 10 0
DomainsTraffic Table smtp_in BIGINT UNSIGNED 20 0
Logos Table fake VARCHAR 255 √ null
upgrade_history Table os VARCHAR 255 √ null
PlanServiceInstallations Table id INT UNSIGNED 10 √ null
smb_apsSettings Table contextId INT 10 null
APSLicenseTypes Table id INT UNSIGNED 10 √ null
IP_Addresses Table mask VARCHAR 15 255.255.255.0
APSCatalogUpdates Table id INT UNSIGNED 10 √ null
Parameters Table id INT UNSIGNED 10 √ null
domain_aliases Table dns enum('true', 'false') 5 false
hosting Table fastcgi enum('false', 'true') 6 false
web_users Table managed_runtime_version VARCHAR 255 1.1
mail Table description VARCHAR 255 √ null
ApsTokens Table instanceId INT UNSIGNED 10 √ null
domain_aliases Table name VARCHAR 255 null
log_actions Table ip_address VARCHAR 39 null
spamfilter Table id INT UNSIGNED 10 √ null
hosting Table cgi enum('false', 'true') 6 false
apscategories Table id INT UNSIGNED 10 √ null
webalizer_group_referrer Table group_name VARCHAR 255 null
domain_aliases Table dns_zone_id INT UNSIGNED 10 √ null
mail_aliases Table apsServiceInstanceId INT UNSIGNED 10 0
smb_users Table contactName VARCHAR 255 √ null
ApiRpcCallsStat Table id INT UNSIGNED 10 √ null
smb_servicePermissions Table serviceInstanceId INT 10 null
MailOutgoingMessagesPeaks Table mailId INT UNSIGNED 10 null
cp_access Table netaddr VARCHAR 39 null
APSLicenseTypes Table license_type_hash VARCHAR 255 null
DomainServices Table ipCollectionId INT UNSIGNED 10 0
ServiceNodes Table externalId VARCHAR 255 √ null
DomainOutgoingMessagesStats Table rejected BIGINT UNSIGNED 20 0
ClientsTraffic Table smtp_out BIGINT UNSIGNED 20 0
dom_level_usrs Table ownership enum('false', 'true') 6 true
fileSharingUsers Table login VARCHAR 255 null
ServicePermissions Table permissionName VARCHAR 255 null
stat Table transfer BIGINT UNSIGNED 20 √ null
subdomains Table sys_user_id INT UNSIGNED 10 0
smb_serviceEntryPoints Table redirectUrl VARCHAR 255 √ null
dns_zone Table ttl_unit INT UNSIGNED 10 1
secret_keys Table key_id VARCHAR 255 null
smb_apsProvisionEnvironments Table value VARCHAR 255 √ null
longtasks Table progressParams BLOB 65535 √ null
protected_dirs Table dom_type enum('domain', 'subdomain') 9 domain
apsInstancesParameters Table name VARCHAR 255 null
pd_users Table account_id INT UNSIGNED 10 0
ServiceInstallations Table id INT UNSIGNED 10 √ null
smb_settings Table value TEXT 65535 √ null
subdomains Table coldfusion enum('false', 'true') 6 false
hosting Table webstat VARCHAR 20 none
secret_keys Table description VARCHAR 255 null
ServiceNodes Table ipAddress VARCHAR 255 local
smb_userServicePermissions Table userId INT 10 null
exp_event Table user VARCHAR 255 null
dns_recs Table displayHost VARCHAR 255 null
WebApps Table name VARCHAR 255 √ null
mass_mail Table to_resellers enum('false', 'true') 6 false
actions Table enabled enum('false', 'true') 6 true
SubscriptionOutgoingMessagesPeaks Table beginDate DATETIME 19 null
apsResourcesParameters Table name VARCHAR 255 null
badmailfrom Table domain VARCHAR 255 null
externalWebmails Table enabled INT 10 0
DomainsTraffic Table dom_id INT UNSIGNED 10 0
domains Table icpStatus INT 10 0
certificates Table cert_file VARCHAR 255 null
BackupsScheduled Table backup_day INT UNSIGNED 10 0
Logos Table id INT UNSIGNED 10 √ null
ServiceNodeCache Table pathId VARCHAR 255 null
smb_serviceEntryPoints Table servicePermissionId INT 10 null
mail_aliases Table mn_id INT UNSIGNED 10 0
smb_users Table imType INT 10 √ null
smb_apsInstances Table id INT 10 √ null
subdomains Table certificate_id INT UNSIGNED 10 √ 0
ScheduledTasks Table dayOfMonth VARCHAR 255 null
TraceFailedRequestsProviders Table ruleId INT UNSIGNED 10 null
smb_apsPackages Table globalSettingsNotSet INT 10 √ 0
apsContexts Table id INT UNSIGNED 10 √ null
dom_param Table param VARCHAR 245 null
ApiRpcCallsStat Table Count INT UNSIGNED 10 0
Configurations Table name VARCHAR 255 null
spamfilter Table username VARCHAR 128 null
resp_forward Table rn_id INT UNSIGNED 10 0
dns_zone Table displayName VARCHAR 255 null
Templates Table owner_id INT UNSIGNED 10 null
hosting Table write_modify VARCHAR 255 √ null
smb_apsInstances Table parentContextId INT 10 null
pd_users Table login VARCHAR 20 null
smb_componentUpdates Table componentName VARCHAR 255 √ null
dsn Table description VARCHAR 255 √ null
smb_users Table isBuiltIn INT 10 √ 0
smb_apsResources Table class VARCHAR 255 null
MailOutgoingMessagesStats Table rejected BIGINT UNSIGNED 20 0
ClientsTraffic Table ftp_out BIGINT UNSIGNED 20 0
APSLicenses Table id INT UNSIGNED 10 √ null
longtasks Table finishTime TIMESTAMP 19 0000-00-00 00:00:00
Subscriptions Table external_id VARCHAR 255 √ null
IisAppPoolDomains Table domainId INT UNSIGNED 10 null
smb_productUpgrades Table description VARCHAR 255 √ null
SubscriptionOutgoingMessagesStats Table rejected BIGINT UNSIGNED 20 0
BackendCache Table key VARCHAR 128 null
smb_fileSharingUnlistedFiles Table id INT 10 √ null
clients Table ownership enum('false', 'true') 6 true
APSClientApplicationItems Table broadcast enum('false', 'true') 6 false
anon_ftp Table incoming_subdirs enum('false', 'true') 6 false
domains Table description VARCHAR 255 √ null
PlanItemProperties Table name VARCHAR 255 null
dom_level_usrs Table uid VARCHAR 255 √ null
custom_buttons Table plan_item_name VARCHAR 255 √ null
BackupsScheduled Table prefix VARCHAR 255 √ null
ServiceNodeConfiguration Table serviceNodeId INT UNSIGNED 10 null
mail_resp Table ans_freq INT 10 √ 10
secret_keys Table client_id INT UNSIGNED 10 √ null
WebServerSettings Table id INT UNSIGNED 10 √ null
IP_Addresses Table main enum('false', 'true') 6 false
mail_redir Table mn_id INT UNSIGNED 10 0
spamfilter_preferences Table prefid INT UNSIGNED 10 √ null
mail Table mail_group enum('false', 'true') 6 false
mail_resp Table text MEDIUMTEXT 16777215 √ null
Configurations Table status enum('error', 'generation', 'ok') 10 error
MailOutgoingMessagesStats Table mailId INT UNSIGNED 10 null
hosting Table managed_runtime_version VARCHAR 255
mail_resp Table subject VARCHAR 255 √ null
protected_dirs Table ssl enum('false', 'true') 6 false
Templates Table note_id INT UNSIGNED 10 √ null
dsn Table driver VARCHAR 255 null
domains Table htype enum('none', 'vrt_hst', 'std_fwd', 'frm_fwd') 7 none
SubscriptionProperties Table value VARCHAR 255 null
mass_mail Table to_domains enum('false', 'true') 6 false
MailLists Table dom_id INT UNSIGNED 10 0
smb_settings Table name VARCHAR 255 √ null
pd_users Table pd_id INT UNSIGNED 10 0
smb_apsInstances Table uuid VARCHAR 255 √ null
smb_fileSharingUnlistedFiles Table name VARCHAR 255 √ null
db_users Table passwd VARCHAR 16 null
ServiceInstanceResources Table serviceResourceId INT UNSIGNED 10 null
smb_users Table additionalInfo TEXT 65535 √ null
Notifications Table send2reseller VARCHAR 1 √ null
mass_mail Table body TEXT 65535 null
resp_freq Table email VARCHAR 245 null
smb_roles Table name VARCHAR 255 √ null
admin_aliases Table account_id INT UNSIGNED 10 null
domain_aliases Table icpPermit VARCHAR 255 √ null
smb_productUpgrades Table version VARCHAR 255 √ null
ServiceInstances Table serviceInstallationId INT UNSIGNED 10 null
log_rotation Table email VARCHAR 255 √ null
mass_mail Table subject VARCHAR 255 null
dns_recs_t Table opt VARCHAR 255 null
domains Table guid VARCHAR 255 00000000-0000-0000-0000-000000000000
smb_apsCategories Table name VARCHAR 255 √ null
smb_apsPackagesCategories Table id INT 10 √ null
subdomains Table maintenance_mode enum('false', 'true') 6 false
domains Table webspace_status BIGINT UNSIGNED 20 0
ClientsTraffic Table pop3_imap_in BIGINT UNSIGNED 20 0
hosting Table ssi_html enum('false', 'true') 6 false
clients Table email VARCHAR 255 √ null
clients Table parent_id INT UNSIGNED 10 0
smb_apsProvisions Table class VARCHAR 255 null
DomainsTraffic Table pop3_imap_out BIGINT UNSIGNED 20 0
SubscriptionOutgoingMessagesPeaks Table rejected BIGINT UNSIGNED 20 0
smb_serviceEntryPoints Table description VARCHAR 255 √ null
db_users Table status enum('normal', 'orphaned') 8 normal
db_users Table external_id VARCHAR 255 √ null
subdomains Table dom_id INT UNSIGNED 10 0
dom_level_usrs Table passwd VARCHAR 255 null
smb_locales Table code VARCHAR 255 √ null
GL_remote_domains Table type enum('black', 'white') 6 black
mail_aliases Table alias VARCHAR 245 null
certificates Table id INT UNSIGNED 10 √ null
hotlink_prot Table enabled enum('false', 'true') 6 false
clients Table perm_id INT UNSIGNED 10 0
key_history_params Table key_id INT UNSIGNED 10 0
ServiceNodeConfiguration Table name VARCHAR 255 null
accounts Table type VARCHAR 32 plain
exp_event Table flushed enum('true', 'false') 5 false
web_users Table php enum('false', 'true') 6 false
BackupsScheduled Table split_size BIGINT UNSIGNED 20 0
ServiceNodeEnvironment Table serviceNodeId INT UNSIGNED 10 null
mass_mail Table name VARCHAR 255 null
mass_mail_domains Table mm_id INT UNSIGNED 10 null
disk_usage Table mailboxes BIGINT UNSIGNED 20 √ 0
apsResources Table id INT UNSIGNED 10 √ null
anon_ftp Table display_login enum('false', 'true') 6 false
Webmails Table name VARCHAR 255 null
ClientsTraffic Table date DATE 10 0000-00-00
db_users Table account_id INT UNSIGNED 10 null
APSApplicationItems Table disabled enum('false', 'true') 6 false
smb_componentUpdates Table id INT 10 √ null
mail_redir Table address VARCHAR 245 null
hosting Table sys_user_id INT UNSIGNED 10 0
Cards Table companyName VARCHAR 255 √ null
GL_settings Table value VARCHAR 255 null
DatabaseUserRemoteAccessRules Table id INT UNSIGNED 10 √ null
SubscriptionProperties Table subscription_id INT UNSIGNED 10 0
key_history Table id INT UNSIGNED 10 √ null
data_bases Table id INT UNSIGNED 10 √ null
PlanServiceProperties Table name VARCHAR 255 null
smb_apsInstanceErrors Table instanceId INT 10 null
Webmails Table id INT UNSIGNED 10 √ null
domains Table external_id VARCHAR 255 √ null
anon_ftp Table dom_id INT UNSIGNED 10 0
PlanItems Table applicableToSubscription INT UNSIGNED 10 0
mail_resp Table apsServiceInstanceId INT UNSIGNED 10 0
PleskStats Table param VARCHAR 255 null
smb_apsResources Table id INT 10 √ null
anon_ftp Table id INT UNSIGNED 10 √ null
ServiceInstances Table enabled INT UNSIGNED 10 1
APSCatalogUpdates Table package_release VARCHAR 30 √ null
key_history Table filename VARCHAR 255 √ null
fileSharingUsers Table userId INT 10 null
report Table user_type INT UNSIGNED 10 0
secret_keys Table ip_address VARCHAR 39 null
MailOutgoingMessagesPeaks Table endDate DATETIME 19 √ null
SubscriptionOutgoingMessagesStats Table limitValue BIGINT 19 -1
ip_pool Table id INT UNSIGNED 10 √ null
APSClientApplicationItems Table instances_limit INT 10 -1
smb_users Table phone VARCHAR 255 √ null
web_users Table perl enum('false', 'true') 6 false
dns_zone Table minimum_unit INT UNSIGNED 10 1
Modules Table display_name VARCHAR 255 null
hosting Table ssl enum('false', 'true') 6 false
protected_dirs Table realm VARCHAR 255 √ null
dom_level_usrs Table state enum('false', 'true') 6 false
IisAppPools Table recyclingByPrivateMemory BIGINT 19 -1
clients Table overuse enum('false', 'true') 6 false
resp_freq Table num INT 10 √ 0
Skins Table id INT UNSIGNED 10 √ null
SessionContexts Table sessionId VARCHAR 33 √ null
hosting Table certificate_id INT UNSIGNED 10 √ 0
ScheduledTasks Table dayOfWeek VARCHAR 255 null
Configurations Table active enum('false', 'true') 6 true
ScheduledTasks Table id INT UNSIGNED 10 √ null
smb_productUpgrades Table shown INT 10 √ 0
smb_apsProvisionEnvironments Table provisionId INT 10 null
GL_settings Table serviceNodeId INT UNSIGNED 10 1
PhpSettingsParameters Table name VARCHAR 255 null
clients Table tmpl_id INT UNSIGNED 10 0
apsContexts Table ssl enum('false', 'true') 6 false
dns_zone Table type enum('slave', 'master') 6 master
domain_aliases Table status BIGINT UNSIGNED 20 0
Skins Table name VARCHAR 255 null
disk_usage Table subdomains BIGINT UNSIGNED 20 √ 0
PlanItems Table applicableToEmail INT UNSIGNED 10 0
WebServerSettingsParameters Table value TEXT 65535 √ null
domain_aliases Table displayName VARCHAR 255 null
smb_roleServicePermissions Table servicePermissionId INT 10 null
anon_ftp Table incoming enum('false', 'true') 6 false
badmailfrom Table serviceNodeId INT UNSIGNED 10 1
key_history Table register_date TIMESTAMP 19 CURRENT_TIMESTAMP
ServiceNodes Table accessKey TEXT 65535 √ null
ComposerInstances Table path VARCHAR 255 null
Repository Table component_id INT UNSIGNED 10 0
dns_zone Table expire INT UNSIGNED 10 604800
smb_productUpgrades Table id INT 10 √ null
DatabaseServers Table admin_password CHAR 255 null
subdomains Table www_root VARCHAR 255 httpdocs
ServiceInstallations Table status INT UNSIGNED 10 0
domain_aliases Table web enum('true', 'false') 5 false
smb_apsInstances Table metaId INT 10 null
IisAppPools Table ownerType enum('client', 'domain') 7 client
domains Table params_id INT UNSIGNED 10 0
web_users Table ssi enum('false', 'true') 6 false
upgrade_history Table mu VARCHAR 255 √ null
ftp_users Table id INT UNSIGNED 10 √ null
smb_fileSharingUnlistedFiles Table creationDate VARCHAR 25 null
ServiceNodeEnvironment Table name VARCHAR 255 null
mass_mail_domains Table dom_id INT UNSIGNED 10 null
IisAppPools Table idleTimeout INT UNSIGNED 10 5
sessions Table modified INT UNSIGNED 10 √ null
smb_users Table isLegacyUser INT 10 √ 0
smb_apsPackages Table version VARCHAR 255 √ null
PersistentCache Table key VARCHAR 128 null
BackupsScheduled Table period INT UNSIGNED 10 0
locales Table active enum('false', 'true') 6 true
ServiceNodeCertificates Table serviceNodeId INT UNSIGNED 10 null
smb_apsBundleFilterItems Table id INT UNSIGNED 10 √ null
BackupsScheduled Table mssql_native_backup INT 10 1
PackageUpdateLocks Table id INT UNSIGNED 10 null
CliCallsStat Table lasExecutionDateTime DATETIME 19 0000-00-00 00:00:00
smb_roleServicePermissions Table roleId INT 10 null
mail Table mail_name VARCHAR 245 null
exp_event Table host VARCHAR 255 null
clients Table vendor_id INT UNSIGNED 10 √ null
Modules Table packname VARCHAR 255 null
TmplData Table tmpl_id INT UNSIGNED 10 0
smb_productUpgrades Table releaseId VARCHAR 255 √ null
domains Table cert_rep_id INT UNSIGNED 10 √ 0
disk_usage Table webapps BIGINT UNSIGNED 20 √ 0
data_bases Table external_id VARCHAR 255 √ null
Subscriptions Table locked enum('false', 'true') 6 false
smb_apsPackageUpdates Table packager VARCHAR 255 √ null
dns_recs Table val VARCHAR 255 null
smb_serviceEntryPoints Table hidden INT 10 √ 0
sys_users Table home VARCHAR 255 null
forwarding Table redirect VARCHAR 255 √ null
ScheduledTasks Table sysUserLogin VARCHAR 255 √ null
dns_recs_t Table id INT UNSIGNED 10 √ null
exp_event Table id BIGINT UNSIGNED 20 √ null
IP_Addresses Table iface VARCHAR 255 null
dns_recs Table type enum('NS', 'A', 'AAAA', 'CNAME', 'MX', 'PTR', 'TXT', 'SRV', 'DS', 'master', 'none') 6 A
hosting Table php enum('false', 'true') 6 false
ServiceNodeCache Table path TEXT 65535 √ null
BackupsScheduled Table obj_type enum('server', 'reseller', 'client', 'domain') 8 null
certificates Table pvt_key BLOB 65535 √ null
MailOutgoingMessagesStats Table limitValue BIGINT 19 -1
anon_ftp Table incoming_readable enum('false', 'true') 6 false
smb_apsResourceParameters Table value VARCHAR 255 √ null
MailOutgoingMessagesPeaks Table beginDate DATETIME 19 null
smb_apsPackageUpdates Table updatePackageId INT 10 √ null
smb_apsProvisions Table id INT 10 √ null
Permissions Table permission VARCHAR 255 null
smb_users Table companyName VARCHAR 255 √ null
apsResources Table pleskType VARCHAR 255 null
fileSharingUsers Table id INT 10 √ null
clients Table sapp_pool_id INT UNSIGNED 10 0
certificates Table ca_cert BLOB 65535 √ null
ScheduledTasks Table month VARCHAR 255 null
smb_servicePermissionAccounts Table userId INT 10 null
smb_apsSettings Table id INT 10 √ null
smb_servicePermissions Table id INT 10 √ null
mail Table perm_id INT UNSIGNED 10 0
SSOBranding Table http_request_domain VARCHAR 255 null
hosting Table php_isapi enum('false', 'true') 6 false
DatabaseUserRemoteAccessRules Table databaseUserId INT UNSIGNED 10 null
smb_apsMetas Table name VARCHAR 255 null
apsResources Table pleskId INT UNSIGNED 10 null
Parameters Table value VARCHAR 255 √ null
GL_settings Table param VARCHAR 255 null
ServiceNodeCertificates Table certificateId INT UNSIGNED 10 null
dns_recs Table dns_zone_id INT UNSIGNED 10 √ null
data_bases Table type enum('mysql', 'postgresql', 'mssql') 10 mysql
TraceFailedRequestsRules Table domainId INT UNSIGNED 10 null
sys_users Table shell VARCHAR 255 null
ip_pool Table ip_address_id INT UNSIGNED 10 null
log_rotation Table id INT UNSIGNED 10 √ null
event_handlers Table command TEXT 65535 √ null
domain_aliases Table external_id VARCHAR 255 √ null
ComposerInstances Table id INT UNSIGNED 10 √ null
DomainServices Table type enum('mail', 'tomcat', 'maillists', 'web') 9 √ null
avstatistics Table date DATE 10 0000-00-00
Cards Table zip VARCHAR 10 √ null
sys_users Table serviceNodeId INT UNSIGNED 10 0
APSCatalogUpdates Table update_name VARCHAR 255 √ null
Configurations Table objectId INT UNSIGNED 10 √ null
longtaskparams Table val MEDIUMTEXT 16777215 √ null
longtasks Table progressMax INT UNSIGNED 10 1
clients Table guid VARCHAR 36 00000000-0000-0000-0000-000000000000
disk_usage Table anonftp BIGINT UNSIGNED 20 √ 0
BackupsSettings Table id INT UNSIGNED 10 √ null
Templates Table name VARCHAR 255 null
Notifications Table note_id INT UNSIGNED 10 √ null
smb_users Table subscriptionDomainId INT UNSIGNED 10 √ 0
BackupsScheduled Table last DATETIME 19 √ null
dns_recs_t Table displayVal VARCHAR 255 null
dns_recs Table opt VARCHAR 255 null
Configurations Table objectType VARCHAR 255 null
hosting Table python enum('false', 'true') 6 false
DomainServices Table dom_id INT UNSIGNED 10 0
DomainsTraffic Table pop3_imap_in BIGINT UNSIGNED 20 0
smb_serviceEntryPoints Table icon VARCHAR 255 √ null
APSCatalogUpdates Table update_packager VARCHAR 255 √ null
Webmails Table product_id VARCHAR 255 null
dsn Table id INT UNSIGNED 10 √ null
mn_param Table param VARCHAR 245 null
custom_buttons Table sort_key INT UNSIGNED 10 100
domains Table parentDomainId INT UNSIGNED 10 0
BackupExcludeFiles Table files TEXT 65535 √ null
TraceFailedRequestsRules Table id INT UNSIGNED 10 √ null
DomainOutgoingMessagesStats Table limitValue BIGINT 19 -1
Permissions Table id INT UNSIGNED 10 √ null
apsContexts Table pleskId INT UNSIGNED 10 null
actions Table name VARCHAR 255 null
ApiRpcCallsStat Table LastExecutionDate DATETIME 19 0000-00-00 00:00:00
smb_serviceEntryPoints Table label VARCHAR 255 √ null
BackupsScheduled Table full_backup_period INT UNSIGNED 10 0
ScheduledTasks Table isActive INT 10 0
sessions Table sess_id VARCHAR 33 null
SubscriptionOutgoingMessagesPeaks Table subscriptionId INT UNSIGNED 10 null
PlanItems Table isVisible INT UNSIGNED 10 1
smb_serviceEntryPoints Table id INT 10 √ null
mail Table redirect enum('false', 'true') 6 false
IP_Addresses Table status BIGINT UNSIGNED 20 0
smb_apsPackages Table vendor VARCHAR 255 √ null
smb_apsSettings Table name VARCHAR 255 null
Webmails Table enabled enum('false', 'true') 6 false
longtasks Table progressStatus VARCHAR 255 queue
custom_buttons Table level_id INT UNSIGNED 10 0
MailMessagesStat Table sent BIGINT UNSIGNED 20 0
apsContextsApplications Table apsContextId INT UNSIGNED 10 null
DynamicIpSecurity Table maxConcurrentRequests INT UNSIGNED 10 5
resp_attach Table filename VARCHAR 245 null
PersistentCache Table expire TIMESTAMP 19 CURRENT_TIMESTAMP
mail Table virusfilter enum('none', 'incoming', 'outgoing', 'any') 8 none
DomainsTraffic Table http_in BIGINT UNSIGNED 20 0
subdomains Table php enum('false', 'true') 6 false
SessionContexts Table data MEDIUMTEXT 16777215 √ null
ScheduledTasks Table email TEXT 65535 √ null
clients Table external_id VARCHAR 255 √ null
smb_apsPackages Table release VARCHAR 255 √ null
ScheduledTasks Table description TEXT 65535 √ null
mail Table dom_id INT UNSIGNED 10 0
ServiceInstanceDepends Table serviceInstanceId INT UNSIGNED 10 null
PackageUpdateNotifications Table eventDate DATETIME 19 0000-00-00 00:00:00
subdomains Table ssl enum('false', 'true') 6 false
APSLicenseTypes Table application_name VARCHAR 255 null
smb_fileSharingUnlistedFiles Table salt VARCHAR 255 √ null
smb_apsPackages Table packagerHomePage VARCHAR 255 √ null
ServiceNodes Table id INT UNSIGNED 10 √ null
ApiRpcCallsStat Table FilterName VARCHAR 50 0
cl_param Table cl_id INT UNSIGNED 10 0
longtasks Table pid INT UNSIGNED 10 0
log_components Table old_value VARCHAR 255 null
hosting Table dom_id INT UNSIGNED 10 0
smb_apsBundleFilters Table id INT UNSIGNED 10 √ null
smb_apsContexts Table contextType INT 10 √ 0
PackageUpdateNotifications Table data MEDIUMTEXT 16777215 √ null
Notes Table id INT UNSIGNED 10 √ null
sys_users Table quota BIGINT UNSIGNED 20 0
PlanItems Table classname VARCHAR 255 null
mail Table redir_addr VARCHAR 255 √ null
ApiRpcCallsStat Table Session VARCHAR 8 0
dsn Table name VARCHAR 255 null
Cards Table id INT UNSIGNED 10 √ null
hosting Table real_traffic BIGINT UNSIGNED 20 √ 0
smb_roles Table ownerId INT UNSIGNED 10 √ null
ApsTokens Table applicationId VARCHAR 2000 null
SBResellers Table sb_reseller_id VARCHAR 255 null
mail_resp Table reply_to VARCHAR 255 √ null
APSApplicationItems Table id INT UNSIGNED 10 √ null
clients Table pcode VARCHAR 10 √ null
log_rotation Table max_number_of_logfiles BIGINT UNSIGNED 20 √ 0
dns_recs Table id INT UNSIGNED 10 √ null
smb_users Table isLocked INT 10 √ 0
clients Table city VARCHAR 255 √ null
DatabaseServers Table server_version CHAR 255 √ null
cp_access Table type enum('allow', 'deny') 6 allow
subdomains Table fastcgi enum('false', 'true') 6 false
ClientsTraffic Table http_out BIGINT UNSIGNED 20 0
web_users Table cgi enum('false', 'true') 6 false
key_history_params Table val VARCHAR 255 √ null
smb_apsPackageUpdates Table version VARCHAR 255 √ null
BackupsScheduled Table content_type enum('backup_content_all_at_domain', 'backup_content_vhost_only', 'backup_content_mail_only') 29 backup_content_all_at_domain
hotlink_friends Table id INT UNSIGNED 10 √ null
data_bases Table db_server_id INT UNSIGNED 10 null
spamfilter Table serviceNodeId INT UNSIGNED 10 1
CliCallsStat Table command VARCHAR 255 null
APSCatalogUpdates Table received DATETIME 19 √ 0000-00-00 00:00:00
APSApplicationItems Table license_type_id INT UNSIGNED 10 0
ModuleSettings Table name VARCHAR 255 null
ScheduledTasks Table arguments TEXT 65535 √ null
longtasks Table type VARCHAR 255 null
APSCatalogUpdates Table update_vendor VARCHAR 255 √ null
APSCatalogUpdates Table recommended enum('false', 'true') 6 false
spamfilter_preferences Table preference VARCHAR 30 null
subdomains Table asp enum('false', 'true') 6 false
PhpSettings Table noteId INT UNSIGNED 10 0
dns_zone Table ttl INT UNSIGNED 10 86400
ApsTokens Table id INT UNSIGNED 10 √ null
dns_zone Table retry_unit INT UNSIGNED 10 1
avstatistics Table val BIGINT UNSIGNED 20 0
TraceFailedRequestsProviderAreas Table name VARCHAR 255 null
report_auto Table domain INT UNSIGNED 10 √ 0
MailLists Table name VARCHAR 255 null
Subscriptions Table object_type enum('client', 'domain') 7 null
dns_refs Table uid VARCHAR 255 null
report Table is_default enum('false', 'true') 6 false
admin_aliases_param Table param VARCHAR 245 null
mail_resp Table id INT UNSIGNED 10 √ null
smb_roleServicePermissions Table id INT 10 √ null
Notifications Table send2email VARCHAR 1 null
avstatistics Table type enum('summary', 'viruses', 'recipients', 'spam_summary', 'spam_recipients') 15 summary
subdomains Table displayName VARCHAR 255 null
log_rotation Table turned_on enum('false', 'true') 6 false
DynamicIpSecurity Table dom_id INT UNSIGNED 10 null
IP_Addresses Table default_domain_id INT UNSIGNED 10 0
smb_serviceInstances Table externalId VARCHAR 255 √ null
DomainsTraffic Table smtp_out BIGINT UNSIGNED 20 0
subdomains Table ssi enum('false', 'true') 6 false
dns_zone Table syncSoa enum('true', 'false', 'skip') 5 skip
db_users Table db_server_id INT UNSIGNED 10 0
IisAppPoolDomains Table poolId INT UNSIGNED 10 null
PlanServiceProperties Table planServiceId INT UNSIGNED 10 null
longtaskparams Table param VARCHAR 255 null
smb_userServicePermissions Table id INT 10 √ null
smb_roles Table isBuiltIn INT 10 √ 0
smb_locales Table title VARCHAR 255 √ null
ServiceInstances Table status INT UNSIGNED 10 1
accounts Table id INT UNSIGNED 10 √ null
sys_users Table mapped_to INT UNSIGNED 10 √ null
smb_componentUpdates Table build VARCHAR 255 √ null
custom_buttons Table conhelp TEXT 65535 √ null
BackupsScheduled Table backupExcludeFilesId INT UNSIGNED 10 √ null
BackupsScheduled Table id INT UNSIGNED 10 √ null
BackupsScheduled Table suspend enum('false', 'true') 6 false
Subscriptions Table custom enum('false', 'true') 6 false
dns_zone Table serial_format enum('UNIXTIMESTAMP', 'YYYYMMDDNN') 14 UNIXTIMESTAMP
smb_roles Table id INT 10 √ null
clients Table logo_id INT UNSIGNED 10 0
smb_apsResourceParameters Table id INT 10 √ null
custom_buttons Table text VARCHAR 255 √ null
fileSharingUsers Table password VARCHAR 255 √ null
mail Table apsServiceAccountInstanceId INT 10 0
smb_servicePermissions Table permissionCode VARCHAR 255 √ null
clients Table id INT UNSIGNED 10 √ null
IisAppPools Table isStarted INT 10 1
custom_buttons Table level INT UNSIGNED 10 0
subdomains Table asp_dot_net enum('false', 'true') 6 false
hotlink_prot Table dom_id INT UNSIGNED 10 null
MailLists Table id INT UNSIGNED 10 √ null
Modules Table name VARCHAR 255 null
Configurations Table id INT UNSIGNED 10 √ null
ftp_users Table sys_user_id INT UNSIGNED 10 0
dns_recs_t Table uid VARCHAR 255 √ null
Cards Table email VARCHAR 255 √ null
report_auto Table email VARCHAR 254 null
apsContexts Table pleskType VARCHAR 255 null
smb_users Table zip VARCHAR 255 √ null
log_actions Table action_id INT UNSIGNED 10 0
upgrade_history Table version_info VARCHAR 50 √ null
dns_zone Table serial VARCHAR 12 0
smb_apsPackages Table id INT 10 √ null
exp_event Table event_time TIMESTAMP 19 CURRENT_TIMESTAMP
event_handlers Table action_id INT UNSIGNED 10 0
PersistentCache Table events VARCHAR 255 null
sys_users Table login VARCHAR 20 null
smb_apsPackages Table vendorHomePage VARCHAR 255 √ null
webalizer_hidden_referrer Table referrer VARCHAR 255 null
dsn Table configured enum('false', 'true') 6 false
SubscriptionOutgoingMessagesStats Table passed BIGINT UNSIGNED 20 0
smb_apsProvisionEnvironments Table name VARCHAR 255 null
db_users Table db_id INT UNSIGNED 10 0
smb_apsMetas Table contextId INT 10 null
ClientsTraffic Table smtp_in BIGINT UNSIGNED 20 0
DynamicIpSecurity Table maxRequests INT UNSIGNED 10 20
RestrictedDomains Table name VARCHAR 255 null
log_components Table new_value VARCHAR 255 null
DomainOutgoingMessagesPeaks Table rejected BIGINT UNSIGNED 20 0
externalWebmails Table url VARCHAR 255 √ null
report Table user_id INT UNSIGNED 10 0
IisAppPools Table cpuLimitAction enum('NoAction', 'KillW3wp', 'Throttle', 'ThrottleUnderLoad') 17 NoAction
APSLicenses Table personal enum('false', 'true') 6 false
DomainsTraffic Table ftp_out BIGINT UNSIGNED 20 0
smb_apsBundleFilterItems Table filterId INT UNSIGNED 10 0
webalizer_hidden_referrer Table id INT UNSIGNED 10 √ null
Cards Table address VARCHAR 255 √ null
smb_apsBundleFilters Table type enum('white', 'black') 6 black
log_components Table component VARCHAR 255 null
Notifications Table email VARCHAR 255 null
ModuleSettings Table module_id INT UNSIGNED 10 0
key_history Table update_disabled enum('false', 'true') 6 false
sys_users Table id INT UNSIGNED 10 √ null
IP_Addresses Table id INT UNSIGNED 10 √ null
db_users Table dom_id INT UNSIGNED 10 0
smb_users Table email VARCHAR 255 √ null
SBConfig Table param_value VARCHAR 255 √ null
ClientsTraffic Table ftp_in BIGINT UNSIGNED 20 0
locales Table id VARCHAR 17 null
protected_dirs Table id INT UNSIGNED 10 √ null
Webmails Table release VARCHAR 255 null
report Table name VARCHAR 255 √ null
clients Table login VARCHAR 255 null
admin_aliases Table aemail VARCHAR 255 null
admin_aliases_param Table val VARCHAR 255 √ null
smb_apsMetas Table id INT 10 √ null
Modules Table description VARCHAR 255 √ null
admin_aliases Table arealname VARCHAR 255 null
SBResellers Table sb_client_login VARCHAR 255 null
smb_serviceProviders Table classname VARCHAR 255 √ null
smb_locales Table id INT 10 √ null
Configurations Table errorFile BLOB 65535 √ null
smtp_poplocks Table ip_mask INT UNSIGNED 10 32
mail Table mbox_quota BIGINT 19 -1
smb_serviceInstances Table description VARCHAR 255 √ null
mail_resp Table keystr VARCHAR 255 √ null
anon_ftp Table max_conn INT UNSIGNED 10 √ null
SitePagesStat Table date DATE 10 0000-00-00
DomainOutgoingMessagesStats Table passed BIGINT UNSIGNED 20 0
apscategories Table category_name VARCHAR 255 √ null
sys_users Table account_id INT UNSIGNED 10 0
apsContexts Table subscriptionId INT UNSIGNED 10 0
smb_users Table login VARCHAR 255 √ null
protected_dirs Table cgi_bin enum('false', 'true') 6 false
ApiRpcCallsStat Table Version VARCHAR 7 null
custom_buttons Table place enum('domain', 'domain-properties', 'client', 'reseller', 'reseller-settings', 'admin', 'admin-settings', 'navigation') 17 domain
dns_zone Table id INT UNSIGNED 10 √ null
upgrade_history Table db_version VARCHAR 50 √ null
smb_fileSharingUnlistedFiles Table path VARCHAR 255 √ null
mass_mail Table from_email VARCHAR 255 null
mail_aliases Table id INT UNSIGNED 10 √ null
PleskPagesStat Table date DATE 10 0000-00-00
dns_zone Table minimum INT UNSIGNED 10 10800
Notes Table text TEXT 65535 null
smb_roleGeneralPermissions Table generalPermissionId INT 10 null
APSLicenses Table source TEXT 65535 √ null
PlansSubscriptions Table subscription_id INT UNSIGNED 10 null
smb_componentUpdates Table shown INT 10 √ 0
BackupsScheduled Table backup_time VARCHAR 8 00:00:00
web_users Table python enum('false', 'true') 6 false
db_users Table login VARCHAR 128 null
PlanItems Table id INT UNSIGNED 10 √ null
clients Table country VARCHAR 2 √ null
smb_apsPackageUpdates Table release VARCHAR 255 √ null
smb_apsContexts Table requirementContextId VARCHAR 255 √ null
smb_apsProvisionEnvironments Table id INT 10 √ null
dns_recs Table time_stamp TIMESTAMP 19 CURRENT_TIMESTAMP
custom_buttons Table id INT UNSIGNED 10 √ null
report_auto Table recipient INT UNSIGNED 10 0
APSLicenses Table ka_url VARCHAR 255 null
BlUpgrades Table status enum('new', 'fatal', 'optional', 'success') 8 new
DomainServices Table parameters_id INT UNSIGNED 10 0
smb_apsInstanceErrors Table text TEXT 65535 √ null
DomainsTraffic Table date DATE 10 0000-00-00
suspend_handler_history Table dom_id INT UNSIGNED 10 null
hosting Table asp enum('false', 'true') 6 false
smb_servicePermissionAccounts Table id INT 10 √ null
smb_users Table fax VARCHAR 255 √ null
WebServerSettingsParameters Table name VARCHAR 255 null
apsResourcesParameters Table apsResourceId INT UNSIGNED 10 null
smb_apsInstances Table registryResourceId VARCHAR 36 √ null
Subscriptions Table id INT UNSIGNED 10 √ null
longtasks Table progressValue INT UNSIGNED 10 0
dom_level_usrs Table dom_id INT UNSIGNED 10 0
exp_event Table obj_class VARCHAR 255 license
domains Table adminDescription VARCHAR 255 √ null
Cards Table country VARCHAR 2 √ null
smb_users Table externalId VARCHAR 255 √ null
report Table type INT UNSIGNED 10 0
ServiceInstances Table id INT UNSIGNED 10 √ null
BackendCache Table data TEXT 65535 null
PlanItemProperties Table plan_item_id INT UNSIGNED 10 0
dns_zone Table refresh_unit INT UNSIGNED 10 1
PlanItems Table name VARCHAR 255 null
smb_apsPackageUpdates Table packageId INT 10 null
mail_resp Table mem_limit INT 10 √ 1000
SBResellers Table id INT UNSIGNED 10 √ null
MailOutgoingMessagesPeaks Table rejected BIGINT UNSIGNED 20 0
web_users Table asp_dot_net enum('false', 'true') 6 false
subdomains Table cgi enum('false', 'true') 6 false
smb_serviceEntryPoints Table externalId VARCHAR 255 √ null
APSLicenses Table key_number VARCHAR 255 null
dns_refs Table zoneRecordId INT UNSIGNED 10 √ null
IP_Addresses Table ssl_certificate_id INT UNSIGNED 10 0
Notifications Table send2client VARCHAR 1 null
PhpSettingsParameters Table value TEXT 65535 √ null
smb_servicePermissionAccounts Table externalId VARCHAR 255 √ null
protected_dirs Table path VARCHAR 245 null
IisAppPools Table identity VARCHAR 20 null
certificates Table ca_file VARCHAR 255 null
WebApps Table domain_service_id INT UNSIGNED 10 0
ApiRpcCallsStat Table Operator VARCHAR 50 null
PleskPagesStat Table url VARCHAR 255 null
resp_attach Table id INT UNSIGNED 10 √ null
BackupsSettings Table param VARCHAR 255 null
ApiRpcCallsStat Table Command VARCHAR 50 null
mass_mail Table to_clients enum('false', 'true') 6 false
smb_roleGeneralPermissions Table roleId INT 10 null
smb_users Table state VARCHAR 255 √ null
APSClientApplicationItems Table app_item_id INT UNSIGNED 10 0
ftp_users Table dom_id INT UNSIGNED 10 0
ClientsTraffic Table pop3_imap_out BIGINT UNSIGNED 20 0
smb_apsPackages Table name VARCHAR 255 null
mass_mail_clients Table mm_id INT UNSIGNED 10 null
smb_users Table id INT 10 √ null
PlansSubscriptions Table quantity INT UNSIGNED 10 1
disk_usage Table configs BIGINT UNSIGNED 20 √ 0
disk_usage Table logs BIGINT UNSIGNED 20 √ 0
ServiceNodes Table description VARCHAR 255 null
ScheduledTasks Table hour VARCHAR 255 null
protected_dirs Table non_ssl enum('false', 'true') 6 false
actions Table descr VARCHAR 255 null
domains Table resellerDescription VARCHAR 255 √ null
mass_mail Table to_domains_mode enum('all', 'select', 'except') 6 all
smb_apsContexts Table packageId INT 10 null
smb_apsPackages Table installed VARCHAR 26 √ null
MailOutgoingMessagesStats Table passed BIGINT UNSIGNED 20 0
smb_apsSettings Table value VARCHAR 255 √ null
SessionContexts Table contextId VARCHAR 255 null
smb_apsProvisions Table contextId INT 10 null
Cards Table city VARCHAR 255 √ null
custom_buttons Table options INT UNSIGNED 10 0
resp_forward Table id INT UNSIGNED 10 √ null
DatabaseCustomHosts Table id INT UNSIGNED 10 null
domains Table gl_filter enum('on', 'off') 3 on
subdomains Table php_handler_type enum('cgi', 'fastcgi', 'module', 'isapi') 7 module
SitePagesStat Table hits BIGINT UNSIGNED 20 0
APSLicenses Table license_type_id INT UNSIGNED 10 0
Configurations Table serviceNodeId INT UNSIGNED 10 1
apsResources Table registryId VARCHAR 36 null
anon_ftp Table login_text TEXT 65535 √ null
BackupsScheduled Table email VARCHAR 255 √ null
mail_resp Table charset VARCHAR 245 UTF-8
avstatistics Table name VARCHAR 255 null
ServiceInstallationProperties Table value TEXT 65535 √ null
admin_aliases Table login VARCHAR 20 null
Cards Table state VARCHAR 255 √ null
sessions Table ip_dual_stack VARCHAR 39 √ null
disk_usage Table mssql_dbases BIGINT UNSIGNED 20 0
TraceFailedRequestsRules Table statusCodes VARCHAR 255 null
longtaskparams Table task_id INT UNSIGNED 10 null
smb_servicePermissions Table status VARCHAR 255 √ null
Modules Table id INT UNSIGNED 10 √ null
sessions Table login_time INT UNSIGNED 10 √ null
Templates Table type enum('reseller', 'client', 'domain', 'domain_addon') 12 null
BackupsScheduled Table active enum('false', 'true') 6 null
smb_apsPackagesCategories Table categoryId INT 10 √ null
clients Table address VARCHAR 255 √ null
SBConfig Table param_name VARCHAR 255 √ null
Logos Table name VARCHAR 255 √ null
smb_users Table country VARCHAR 255 √ null
resp_freq Table id INT UNSIGNED 10 √ null
DatabaseUserRemoteAccessRules Table type enum('allow', 'deny') 6 null
domains Table id INT UNSIGNED 10 √ null
smb_users Table uuid VARCHAR 36 null
data_bases Table dom_id INT UNSIGNED 10 0
domains Table real_size BIGINT UNSIGNED 20 √ 0
smb_users Table locale VARCHAR 17 √ null
ScheduledTasks Table phpHandlerId VARCHAR 255 √ null
clients Table status BIGINT UNSIGNED 20 0
hosting Table perl enum('false', 'true') 6 false
mail_resp Table key_where enum('subj', 'body', 'no') 5 no
smb_apsResourceParameters Table resourceId INT 10 null
DatabaseUserRemoteAccessRules Table ipAddress VARCHAR 39 null
DynamicIpSecurity Table requestInterval INT UNSIGNED 10 200
dns_zone Table syncRecords enum('true', 'false', 'skip') 5 skip
DomainServices Table status BIGINT 19 0
PleskPagesStat Table hits BIGINT UNSIGNED 20 0
domains Table cr_date DATE 10 √ null
APSCatalogUpdates Table update_type enum('patch', 'upgrade') 7 patch
mass_mail Table to_resellers_mode enum('all', 'select', 'except') 6 all
smb_serviceInstances Table id INT 10 √ null
domains Table name VARCHAR 255 null
dns_recs_t Table time_stamp TIMESTAMP 19 CURRENT_TIMESTAMP
hosting Table max_connection INT 10 √ -1
IpAddressesCollections Table ipAddressId INT UNSIGNED 10 null
Notifications Table send2admin VARCHAR 1 null
APSCatalogUpdates Table update_release VARCHAR 30 √ null
ServiceInstanceDepends Table apiType VARCHAR 255 null
PackageUpdateNotifications Table id INT UNSIGNED 10 null
db_users Table role VARCHAR 255 readWrite
password_secrets Table created DATETIME 19 null
subdomains Table python enum('false', 'true') 6 false
stat Table dom_id INT UNSIGNED 10 0
LimitsReservation Table limitName VARCHAR 255 null
spamfilter_preferences Table value VARCHAR 255 null
PersistentCache Table uid VARCHAR 32 null
resp_freq Table rn_id INT UNSIGNED 10 0
mail Table autoresponder enum('false', 'true') 6 false
APSLicenseTypes Table description VARCHAR 255 √ null
DomainServices Table id INT UNSIGNED 10 √ null
IisAppPools Table recyclingByRequests INT 10 -1
event_handlers Table priority INT UNSIGNED 10 0
ServiceNodeCache Table serviceNodeId INT UNSIGNED 10 null
sessions Table login VARCHAR 255 √ null
Cards Table phone VARCHAR 255 √ null
DatabaseServers Table type enum('mysql', 'postgresql', 'mssql') 10 mysql
smb_apsPackages Table isVisible INT 10 √ 0
mail Table spamfilter enum('false', 'true') 6 true
clients Table description VARCHAR 255 √ null
APSCatalogUpdates Table update_version VARCHAR 30 √ null
mail_resp Table resp_name VARCHAR 245 null
TmplData Table element VARCHAR 255 null
data_bases Table name VARCHAR 64 null
clients Table type enum('admin', 'reseller', 'client') 8 client
Modules Table plesk_max_version VARCHAR 30 √ null
DatabaseServers Table parameters_id INT UNSIGNED 10 √ null
smb_apsCategories Table id INT 10 √ null
DatabaseServers Table port INT UNSIGNED 10 √ null
custom_buttons Table file VARCHAR 245 null
smb_users Table ownerId INT UNSIGNED 10 √ null
report_auto Table last DATETIME 19 √ null
domain_aliases Table seoRedirect enum('false', 'true') 6 false
LimitsReservation Table collectionRef VARCHAR 128 null
smb_apsPackages Table packager VARCHAR 255 √ null
SiteAppsHitsStat Table name VARCHAR 255 null
smb_apsContexts Table requirementContextClass VARCHAR 255 √ null
Templates Table uuid VARCHAR 36 null
Modules Table status enum('true', 'false') 5 true
Modules Table version VARCHAR 30 null
APSCatalogUpdates Table package_version VARCHAR 30 √ null
clients Table locale VARCHAR 17 en-US
log_rotation Table compress_enable enum('false', 'true') 6 false
BackupsScheduled Table obj_id INT UNSIGNED 10 0
ServiceNodeCache Table cache TEXT 65535 √ null
mail Table id INT UNSIGNED 10 √ null
clients Table phone VARCHAR 255 √ null
GL_remote_domains Table domain VARCHAR 255 null
ServicePermissions Table serviceName VARCHAR 255 null
APSLicenses Table expiration_date DATE 10 √ null
apsInstancesParameters Table value VARCHAR 255 √ null
mn_param Table mn_id INT UNSIGNED 10 0
LimitsReservation Table expiration DATETIME 19 null
Limits Table id INT UNSIGNED 10 √ null
smb_roleGeneralPermissions Table id INT 10 √ null
ServiceInstallationProperties Table name VARCHAR 255 null
BlUpgrades Table id VARCHAR 255 null
domains Table displayName VARCHAR 255 null
PhpSettings Table id INT UNSIGNED 10 √ null
domains Table webspace_id INT UNSIGNED 10 0
IP_Addresses Table ip_address VARCHAR 39 null
smb_users Table authCookie VARCHAR 255 √ null
dns_refs Table status enum('syn', 'mod', 'del') 4 syn
smb_apsPackages Table isUploaded INT 10 √ 0
clients Table cname VARCHAR 255 √ null
mass_mail Table to_clients_mode enum('all', 'select', 'except') 6 all
ServiceNodeCertificates Table caFile VARCHAR 255 √ null
domain_aliases Table mail enum('true', 'false') 5 false
web_users Table sys_user_id INT UNSIGNED 10 0
hotlink_friends Table friend_dom VARCHAR 255 null
hosting Table traffic_bandwidth INT 10 √ -1
ApsTokens Table token VARCHAR 255 null
longtasks Table status VARCHAR 255 not_started
ApiRpcCallsStat Table GroupOperation INT 10 0
web_users Table id INT UNSIGNED 10 √ null
DomainsTraffic Table ftp_in BIGINT UNSIGNED 20 0
PlansSubscriptions Table plan_id INT UNSIGNED 10 null
smb_roleGeneralPermissions Table isAllowed INT 10 √ null
ServiceLimits Table serviceName VARCHAR 255 null
Notifications Table subj VARCHAR 255 null
resp_forward Table address VARCHAR 245 null
Notifications Table id INT UNSIGNED 10 √ null
Limits Table limit_name VARCHAR 255 null
report_auto Table id INT UNSIGNED 10 √ null
dns_zone Table external_id VARCHAR 255 √ null
clients Table fax VARCHAR 255 √ null
ScheduledTasks Table sysUserId INT UNSIGNED 10 √ null
exp_event Table event_type enum('started', 'stopped', 'created', 'updated', 'deleted', 'status_changed', 'terminated', 'flushed', 'installed', 'uninstalled', 'siteapp_added', 'siteapp_removed', 'expired', 'exceeded', 'guid_changed') 15 started
APSLicenses Table update_date DATE 10 √ null
TmplData Table value VARCHAR 255 null
resp_attach Table rn_id INT UNSIGNED 10 0
webalizer_group_referrer Table referrer VARCHAR 255 null
report_section Table name VARCHAR 255 null
certificates Table cert BLOB 65535 √ null
web_users Table asp enum('false', 'true') 6 false
Configurations Table file BLOB 65535 √ null
DatabaseServers Table last_error enum('no_error', 'connection_failed', 'permission_denied', 'other_error', 'credentials_not_set') 19 no_error
key_history Table options VARCHAR 255 √ null
ServiceNodeEnvironment Table section VARCHAR 255 null
dns_recs_t Table host VARCHAR 255 null
smb_apsBundleFilterItems Table propertyValue VARCHAR 255 √ null
IisAppPools Table managedPipelineMode enum('Classic', 'Integrated') 10 Integrated
hosting Table php_handler_id VARCHAR 255 fastcgi
IisAppPools Table recyclingByVirtualMemory BIGINT 19 -1
ModuleSettings Table value VARCHAR 2000 null
webalizer_group_referrer Table dom_id INT UNSIGNED 10 null
SubscriptionOutgoingMessagesPeaks Table endDate DATETIME 19 √ null
clients Table state VARCHAR 255 √ null
DomainOutgoingMessagesPeaks Table beginDate DATETIME 19 null
CliCallsStat Table id INT UNSIGNED 10 null
BlUpgradeActions Table action VARCHAR 255 null
smb_fileSharingUnlistedFiles Table expiration INT 10 √ null
misc Table val VARCHAR 2000 √ null
web_users Table write_modify VARCHAR 255 √ null
domains Table overuse enum('false', 'true') 6 false
disk_usage Table dom_id INT UNSIGNED 10 0
key_history_params Table param VARCHAR 63 null
admin_aliases Table status BIGINT UNSIGNED 20 0
report_auto Table client INT UNSIGNED 10 √ 0
ServiceInstallations Table name VARCHAR 255 null
smb_apsInstanceErrors Table id INT 10 √ null
smb_users Table creationDate VARCHAR 25 null
report_section Table id INT UNSIGNED 10 √ null
smb_apsBundleFilterItems Table propertyName VARCHAR 255 √ null
mail Table account_id INT UNSIGNED 10 0
subdomains Table id INT UNSIGNED 10 √ null
IisAppPools Table externalId VARCHAR 255 √ null
DatabaseServers Table host VARCHAR 63 null
password_secrets Table secret VARCHAR 255 null
IisAppPools Table idleTimeoutAction enum('Terminate', 'Suspend') 10 Terminate
ScheduledTasks Table notify enum('ignore', 'errors', 'always') 7 ignore
ClientsTraffic Table http_in BIGINT UNSIGNED 20 0
dom_level_usrs Table card_id INT UNSIGNED 10 √ null
dns_recs Table external_id VARCHAR 255 √ null
longtasks Table context VARCHAR 255 √ null
Templates Table external_id VARCHAR 255 √ null
anon_ftp Table quota BIGINT UNSIGNED 20 √ 1048576
anon_ftp Table bandwidth INT UNSIGNED 10 √ null
hosting Table ssi enum('false', 'true') 6 false
IP_Addresses Table ftps enum('false', 'true') 6 false
cp_access Table id INT UNSIGNED 10 √ null
cl_param Table val VARCHAR 255 √ null
accounts Table password TEXT 65535 √ null
DatabaseCustomHosts Table host VARCHAR 255 √ null
BlUpgradeActions Table status enum('new', 'error', 'skip', 'success') 7 new
PlanItemProperties Table value VARCHAR 255 null
BackupsScheduled Table with_content enum('false', 'true') 6 true
cl_param Table param VARCHAR 245 null