psa.certificates
Overview
The certificates table contains information about the SSL certificates installed on the server.
Column Descriptions
id – primary key that is automatically incremented
csr – certificate signing request in binary form
pvt_key – private key in binary form
cert – certificate in binary form
cert_file – the filename for the certificate file
ca_cert – CA certificates (intermediate certificates) in binary form
ca_file – the filename for the CA certificate file
name – the friendly name for the SSL certificate in Plesk
Table Structure
CREATE TABLE `certificates` ( `id` int(10) unsigned NOT NULL auto_increment, `csr` blob NOT NULL, `pvt_key` blob NOT NULL, `cert` blob NOT NULL, `cert_file` varchar(255) character set ascii collate ascii_bin NOT NULL default '', `ca_cert` blob NOT NULL, `ca_file` varchar(255) character set ascii collate ascii_bin NOT NULL default '', `name` varchar(255) character set utf8 NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 |