#EpikFail Database Schema - api_system

CREATE TABLE `backorder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `merchant_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `cr_date` datetime DEFAULT NULL,
  `exp_date` datetime DEFAULT NULL,
  `drop_date` datetime DEFAULT NULL,
  `price` double NOT NULL DEFAULT '0',
  `status` smallint(2) NOT NULL DEFAULT '0',
  `status_merchant` smallint(2) NOT NULL DEFAULT '0',
  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `delivery_date` timestamp NULL DEFAULT NULL,
  `avail` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `charges` longtext,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `merchant_id` (`merchant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4477333 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `backorder_backoup20181120` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `merchant_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `cr_date` datetime DEFAULT NULL,
  `exp_date` datetime DEFAULT NULL,
  `drop_date` datetime DEFAULT NULL,
  `price` double NOT NULL DEFAULT '0',
  `status` smallint(2) NOT NULL DEFAULT '0',
  `status_merchant` smallint(2) NOT NULL DEFAULT '0',
  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `avail` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `charges` longtext,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `merchant_id` (`merchant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4104965 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `backorder_backup20191226` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `merchant_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `cr_date` datetime DEFAULT NULL,
  `exp_date` datetime DEFAULT NULL,
  `drop_date` datetime DEFAULT NULL,
  `price` double NOT NULL DEFAULT '0',
  `status` smallint(2) NOT NULL DEFAULT '0',
  `status_merchant` smallint(2) NOT NULL DEFAULT '0',
  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `delivery_date` timestamp NULL DEFAULT NULL,
  `avail` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `charges` longtext,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `merchant_id` (`merchant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4164604 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `backorder_delivered` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `backorder_id` int(11) NOT NULL,
  `record_create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `merchant_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `cr_date` datetime DEFAULT NULL,
  `exp_date` datetime DEFAULT NULL,
  `drop_date` datetime DEFAULT NULL,
  `price` double NOT NULL DEFAULT '0',
  `status` smallint(2) NOT NULL DEFAULT '0',
  `status_merchant` smallint(2) NOT NULL DEFAULT '0',
  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `delivery_date` timestamp NULL DEFAULT NULL,
  `avail` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `charges` longtext,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `merchant_id` (`merchant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1203363 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `domain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `merchant_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `cr_date` datetime NOT NULL,
  `exp_date` datetime NOT NULL,
  `exp_date_registry` datetime DEFAULT NULL,
  `authcode` varchar(50) NOT NULL,
  `custom_dns_1` varchar(255) NOT NULL DEFAULT '',
  `custom_dns_2` varchar(255) NOT NULL DEFAULT '',
  `custom_dns_3` varchar(255) NOT NULL DEFAULT '',
  `custom_dns_4` varchar(255) NOT NULL DEFAULT '',
  `custom_dns_5` varchar(255) NOT NULL DEFAULT '',
  `status` enum('locked','unlocked','rlocked') NOT NULL DEFAULT 'unlocked',
  `deleted_status` smallint(2) NOT NULL DEFAULT '0',
  `provider` varchar(10) DEFAULT NULL,
  `params` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `exp_date_idx` (`exp_date`)
) ENGINE=InnoDB AUTO_INCREMENT=17803313 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `domain2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `merchant_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `cr_date` datetime NOT NULL,
  `exp_date` datetime NOT NULL,
  `custom_dns_1` varchar(255) NOT NULL DEFAULT '',
  `custom_dns_2` varchar(255) NOT NULL DEFAULT '',
  `custom_dns_3` varchar(255) NOT NULL DEFAULT '',
  `custom_dns_4` varchar(255) NOT NULL DEFAULT '',
  `custom_dns_5` varchar(255) NOT NULL DEFAULT '',
  `status` enum('locked','unlocked','rlocked') NOT NULL DEFAULT 'unlocked',
  `deleted_status` smallint(2) NOT NULL DEFAULT '0',
  `provider` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4610413 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `domain_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain` varchar(250) DEFAULT NULL,
  `operation` varchar(250) NOT NULL,
  `performed_by_email` varchar(250) DEFAULT NULL,
  `performed_by` int(11) NOT NULL,
  `dtperformed` datetime DEFAULT NULL,
  `whois` longtext,
  `owner` longtext,
  `ns` longtext,
  `forwards` longtext,
  `unified_container` longtext,
  PRIMARY KEY (`id`),
  KEY `domainName` (`domain`)
) ENGINE=InnoDB AUTO_INCREMENT=185015303 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `domain_hosts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) unsigned NOT NULL,
  `host` varchar(255) NOT NULL,
  `reg_cr_date` datetime DEFAULT NULL,
  `reg_up_date` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_domain_hosts_domain_id` (`domain_id`)
) ENGINE=InnoDB AUTO_INCREMENT=754753 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `domain_hosts_ips` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `host_id` int(11) unsigned NOT NULL,
  `type` enum('IPv4','IPv6') DEFAULT 'IPv4',
  `ip` varchar(39) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_domain_hosts_ips_host_id` (`host_id`)
) ENGINE=InnoDB AUTO_INCREMENT=843153 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `domain_hosts_vsn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `registry_num` varchar(255) DEFAULT NULL,
  `fqdn` varchar(255) DEFAULT NULL,
  `tld` varchar(255) DEFAULT NULL,
  `domain` varchar(255) DEFAULT NULL,
  `host` varchar(255) DEFAULT NULL,
  `ip` varchar(100) DEFAULT NULL,
  `reg_cr_date` datetime DEFAULT NULL,
  `reg_up_date` datetime DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `i_domain_hosts_vsn_fqdn` (`fqdn`,`reg_up_date`)
) ENGINE=InnoDB AUTO_INCREMENT=643254 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `domain_info_cache` (
  `id` int(15) unsigned NOT NULL AUTO_INCREMENT,
  `domain` varchar(255) DEFAULT NULL,
  `domain_cr_date` timestamp NULL DEFAULT NULL,
  `domain_exp_date` timestamp NULL DEFAULT NULL,
  `content` longtext,
  `cache_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `api` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `NewIndex1` (`domain`,`cache_date`)
) ENGINE=InnoDB AUTO_INCREMENT=2560703 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `domain_parked_automatically` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `parked_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=7399895 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `domain_partner` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `domain` varchar(255) NOT NULL,
  `internal` tinyint(1) NOT NULL DEFAULT '1',
  `gurid` int(7) unsigned NOT NULL,
  `check_time` datetime DEFAULT NULL,
  `error_desc` text,
  `provider` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_domain` (`domain`),
  KEY `idx_domain_internal` (`domain`,`internal`),
  KEY `idx_provider` (`provider`)
) ENGINE=InnoDB AUTO_INCREMENT=24458 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `domainplexapi_cache` (
  `id` int(15) unsigned NOT NULL AUTO_INCREMENT,
  `domain` varchar(255) DEFAULT NULL,
  `domain_cr_date` timestamp NULL DEFAULT NULL,
  `domain_exp_date` timestamp NULL DEFAULT NULL,
  `content` longtext,
  `cache_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `NewIndex1` (`domain`,`cache_date`)
) ENGINE=InnoDB AUTO_INCREMENT=191058 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `doms` (
  `name` varchar(255) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `dsredirection` (
  `domain` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `email_templates` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `template` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `enable` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
CREATE TABLE `eppproxy_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `inc` int(10) unsigned NOT NULL,
  `prio` varchar(10) NOT NULL,
  `cat` text NOT NULL,
  `thread` varchar(50) NOT NULL,
  `thread_id` varchar(50) NOT NULL,
  `msg` text NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `provider` varchar(10) DEFAULT NULL,
  `server` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1807921935 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--