Columns

Columns

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