- Plesk 10.x for Linux
- Plesk 11.x for Windows
- Plesk 11.x for Linux
- Plesk 12.0 for Linux
database dependencies and descriptions of tables.
The following dumps for '
' and '
' databases only contain records for one application. They were created in the following way: create a dump of the '
' and '
' databases before and after application installation, then diff these dumps.
diff psa.sql_before psa.sql_after
diff apsc.sql_before apsc.sql_after
Contains information about all application resources:
urlPrefix, isSiteRoot, phpMinVersion
Information about application paths:
- application root
Information about databases
Information about database users
These two tables connect the '
' and '
' tables and the '
smb_apsInstances, smb_apsContexts, smb_serviceInstances, smb_apsMetas, smb_serviceEntryPoints, smb_servicePermissions, smb_userServicePermissions
These tables contain information about:
- The package from which the application was installed
- URL links to the CMS administrative interface, blogs, upload theme and upload plugin
- User permissions
Contains information about the package:
id, name, version, release, registryUid
Contains information about the application:
registry_object_idof this application
package_idfrom which this application was installed
Contains the UID for applications, packages, application resources and creation time.
The resource UID connects (3 resource records for one application):
psa.apsResources(two records with pleskType = 'hosting' and 'urlMapping')
psa.apsResources(two records with pleskType = 'db' and 'db_user')
Contains information about this application (a CMS), made up of 5 records:
Two records with the same value. This connects the two
. It is easy to find required APS resources by selecting the 3-4 lines after
Contains a description of these resources:
Contains full information about the application package:
apsc.aps_package.id = psa.smb_apsPackages.id
Useful MySQL queries
by the domain:
select app.id as application_id, regob.id as application_registry_object_id, app.package_id, pack.name as package_name
from apsc.aps_application app, apsc.aps_package pack, apsc.aps_registry_object regob
where regob.id = app.registry_object_id and
app.package_id = pack.id and
regob.uid = ( select conapp.registryApplicationId
from psa.apsContextsApplications conapp, psa.apsContexts cont, psa.domains dom
where cont.id=conapp.apsContextId and dom.id=cont.pleskId and dom.name like 'domain.tld');
Get all records that are present in the
but which are absent in the
select smb_apsInstances.registryResourceId from smb_apsInstances left JOIN apsc.aps_registry_object on apsc.aps_registry_object.uid = smb_apsInstances.registryResourceId where apsc.aps_registry_object.uid is NULL;