psa.domains

Overview

Column Descriptions

id –

CREATE TABLE `domains` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cr_date` date DEFAULT NULL,
  `name` varchar(255) CHARACTER SET ascii NOT NULL,
  `displayName` varchar(255) CHARACTER SET utf8 NOT NULL,
  `dns_zone_id` int(10) unsigned NOT NULL,
  `status` bigint(20) unsigned NOT NULL DEFAULT '0',
  `htype` enum('none','vrt_hst','std_fwd','frm_fwd') NOT NULL,
  `real_size` bigint(20) unsigned DEFAULT '0',
  `cl_id` int(10) unsigned NOT NULL,
  `cert_rep_id` int(10) unsigned DEFAULT NULL,
  `limits_id` int(10) unsigned DEFAULT NULL,
  `params_id` int(10) unsigned DEFAULT NULL,
  `guid` varchar(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  `external_id` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '',
  `overuse` enum('false','true') NOT NULL DEFAULT 'false',
  `gl_filter` enum('on','off') NOT NULL DEFAULT 'on',
  `vendor_id` int(10) unsigned DEFAULT NULL,
  `webspace_id` int(10) unsigned NOT NULL DEFAULT '0',
  `webspace_status` bigint(20) unsigned NOT NULL DEFAULT '0',
  `parentDomainId` int(10) unsigned NOT NULL DEFAULT '0',
  `permissions_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `displayName` (`displayName`),
  KEY `cl_id` (`cl_id`),
  KEY `cert_rep_id` (`cert_rep_id`),
  KEY `limits_id` (`limits_id`),
  KEY `params_id` (`params_id`),
  KEY `vendor_id` (`vendor_id`),
  KEY `webspace_id` (`webspace_id`),
  KEY `parentDomainId` (`parentDomainId`),
  KEY `permissions_id` (`permissions_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1

Related documentation