/home/bdqbpbxa/db_dumps/root_db/root_cwp.sql
-- MySQL dump 10.19 Distrib 10.2.39-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: root_cwp
-- ------------------------------------------------------
-- Server version 10.1.47-MariaDB
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `backups`
--
DROP TABLE IF EXISTS `backups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `backups` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`backup_enable` varchar(5) NOT NULL,
`backup_location` varchar(60) NOT NULL,
`backup_daily` varchar(5) NOT NULL,
`backup_weekly` varchar(5) NOT NULL,
`backup_monthly` varchar(5) NOT NULL,
`backup_mysql` varchar(5) NOT NULL,
`backup_vmail` varchar(5) NOT NULL,
`backup_all` varchar(5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `backups`
--
LOCK TABLES `backups` WRITE;
/*!40000 ALTER TABLE `backups` DISABLE KEYS */;
INSERT INTO `backups` VALUES (1,'off','/backup','off','off','off','off','off','off');
/*!40000 ALTER TABLE `backups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `domains`
--
DROP TABLE IF EXISTS `domains`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `domains` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`domain` varchar(255) NOT NULL,
`user` varchar(40) NOT NULL,
`path` varchar(255) NOT NULL,
`setup_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `domains`
--
LOCK TABLES `domains` WRITE;
/*!40000 ALTER TABLE `domains` DISABLE KEYS */;
INSERT INTO `domains` VALUES (5,'annsnytka.com','bdqbpbxa','/home/bdqbpbxa/annsnytka.com','2020-10-29 17:38:17'),(7,'baginskiy2.goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/baginskiy2.goodface.com.ua','2020-10-29 17:55:37'),(10,'divisima.goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/divisima.goodface.com.ua','2020-10-29 17:56:36'),(12,'goodface.agency','bdqbpbxa','/home/bdqbpbxa/goodface.agency','2020-10-29 17:58:01'),(14,'karlstorz-events.goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/karlstorz-events.goodface.com.ua','2020-10-29 17:58:29'),(15,'karlstorz.goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/karlstorz.goodface.com.ua','2020-10-29 17:58:47'),(16,'keto.goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/keto.goodface.com.ua','2020-10-29 17:59:01'),(17,'klitschko.goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/klitschko.goodface.com.ua','2020-10-29 17:59:15'),(24,'odrex.goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/odrex.goodface.com.ua','2020-10-29 19:16:08'),(26,'online-platform.goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/online-platform.goodface.com.ua','2020-10-29 19:16:34'),(27,'overplay.goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/overplay.goodface.com.ua','2020-10-29 19:16:46'),(32,'sparkskyiv.com','bdqbpbxa','/home/bdqbpbxa/sparkskyiv.com','2020-10-29 19:17:53');
/*!40000 ALTER TABLE `domains` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nameserver`
--
DROP TABLE IF EXISTS `nameserver`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nameserver` (
`id` int(40) NOT NULL,
`ns1_name` varchar(255) NOT NULL,
`ns1_ip` varchar(50) NOT NULL,
`ns2_name` varchar(255) NOT NULL,
`ns2_ip` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nameserver`
--
LOCK TABLES `nameserver` WRITE;
/*!40000 ALTER TABLE `nameserver` DISABLE KEYS */;
INSERT INTO `nameserver` VALUES (1,'ns1.centos-webpanel.com','127.0.0.1','ns2.centos-webpanel.com','127.0.0.1');
/*!40000 ALTER TABLE `nameserver` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `notifications`
--
DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notifications` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` varchar(255) NOT NULL,
`shortjob` text NOT NULL,
`description` text NOT NULL,
`link` varchar(255) NOT NULL,
`readed` varchar(255) NOT NULL,
`completed` varchar(255) NOT NULL,
`date` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `notifications`
--
LOCK TABLES `notifications` WRITE;
/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
INSERT INTO `notifications` VALUES (1,'root','PHP Compiler 7.3.23','Started PHP 7.3.23 Compiler in background.','/var/log/php-rebuild.log','no','no','2020-10-29 14:19:52');
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `packages`
--
DROP TABLE IF EXISTS `packages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `packages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`package_name` varchar(40) NOT NULL,
`disk_quota` varchar(40) NOT NULL,
`bandwidth` varchar(40) NOT NULL,
`ftp_accounts` varchar(40) NOT NULL,
`email_accounts` varchar(40) NOT NULL,
`email_lists` varchar(40) NOT NULL,
`databases` varchar(40) NOT NULL,
`sub_domains` varchar(40) NOT NULL,
`parked_domains` varchar(40) NOT NULL,
`addons_domains` varchar(40) NOT NULL,
`hourly_emails` varchar(40) NOT NULL,
`reseller` varchar(40) NOT NULL,
`accounts` varchar(40) NOT NULL,
`cgroups` varchar(255) DEFAULT NULL,
`nproc` varchar(40) NOT NULL DEFAULT '40',
`apache_nproc` varchar(40) NOT NULL DEFAULT '40',
`inode` varchar(40) NOT NULL DEFAULT '0',
`nofile` varchar(40) NOT NULL DEFAULT '150',
`nodejs_apps` int(3) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `packages`
--
LOCK TABLES `packages` WRITE;
/*!40000 ALTER TABLE `packages` DISABLE KEYS */;
INSERT INTO `packages` VALUES (1,'default','20000','100000','10','10','10','50','10','10','10','200','','','','40','40','0','150',1);
/*!40000 ALTER TABLE `packages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login_type` varchar(40) NOT NULL,
`ssh_port` varchar(40) NOT NULL,
`root_name` varchar(7) NOT NULL,
`root_email` varchar(255) NOT NULL,
`apache_port` varchar(5) NOT NULL,
`homedir` varchar(200) NOT NULL,
`mysql_pwd` varchar(40) NOT NULL,
`apache_vhost_tpl` text NOT NULL,
`apache_sub_vhost_tpl` text NOT NULL,
`named_tpl` text NOT NULL,
`dns_zone_tpl` text NOT NULL,
`shared_ip` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `settings`
--
LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES (1,'ssh','22','root','my@email.com','8181','/home','','# vhost_start %domain_name%\r\n<VirtualHost %domain_ip%:%domain_port%>\r\nServerName %domain_name%\r\nServerAlias www.%domain_name%\r\nServerAdmin %admin_email%\r\nDocumentRoot \"%homedir%/%username%/public_html\"\r\nScriptAlias /cgi-bin/ \"%homedir%/%username%/public_html/cgi-bin/\r\n# \r\n# Custom settings are loaded below this line (if any exist)\r\n# Include \"/usr/local/apache/conf/userdata/%username%/%domain_name%/*.conf\r\n\r\n<IfModule mod_suexec.c>\r\n SuexecUserGroup %username% %username%\r\n</IfModule>\r\n\r\n<IfModule mod_suphp.c>\r\n suPHP_UserGroup %username% %username%\r\n suPHP_ConfigPath /home/%username%\r\n</IfModule>\r\n\r\n<Directory \"%homedir%/%username%/public_html\">\r\n AllowOverride All\r\n</Directory>\r\n\r\n</VirtualHost>\r\n# vhost_end %domain_name%','# vhost_start %domain_name%\r\n<VirtualHost %domain_ip%:%domain_port%>\r\nServerName %domain_name%\r\nServerAlias www.%domain_name%\r\nServerAdmin %admin_email%\r\nDocumentRoot \"%path%\"\r\nScriptAlias /cgi-bin/ %path%/cgi-bin/\r\n# \r\n# Custom settings are loaded below this line (if any exist)\r\n# Include \"/usr/local/apache/conf/userdata/%username%/%domain_name%/*.conf\r\n\r\n<IfModule mod_suexec.c>\r\n SuexecUserGroup %username% %username%\r\n</IfModule>\r\n\r\n<IfModule mod_suphp.c>\r\n suPHP_UserGroup %username% %username%\r\n</IfModule>\r\n\r\n<Directory \"%path%\">\r\n AllowOverride All\r\n</Directory>\r\n\r\n</VirtualHost>\r\n# vhost_end %domain_name%','// zone %domain%\r\nzone \"%domain%\" {\r\n type master;\r\n file \"/var/named/%domain%.db\";};\r\n// zone_end %domain%','; Panel %version%\r\n; Zone file for %domain%\r\n$TTL 14400\r\n%domain%. 86400 IN SOA %nameserver%. %rpemail%. (\r\n 2013071600 ; serial, todays date+todays\r\n 86400 ; refresh, seconds\r\n 7200 ; retry, seconds\r\n 3600000 ; expire, seconds\r\n 86400 ) ; minimum, seconds\r\n\r\n%domain%. 86400 IN NS %nameserver%.\r\n%domain%. 86400 IN NS %nameserver2%.\r\n\r\n%domain%. IN A %ip%\r\n\r\nlocalhost.%domain%. IN A 127.0.0.1\r\n\r\n%domain%. IN MX 0 %domain%.\r\n\r\nmail IN CNAME %domain%.\r\nwww IN CNAME %domain%.\r\nftp IN CNAME %domain%.\r\n; Add additional settings below this line','194.28.85.210');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `subdomains`
--
DROP TABLE IF EXISTS `subdomains`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subdomains` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subdomain` varchar(255) NOT NULL,
`domain` varchar(255) NOT NULL,
`user` varchar(40) NOT NULL,
`path` varchar(255) NOT NULL,
`setup_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=79 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `subdomains`
--
LOCK TABLES `subdomains` WRITE;
/*!40000 ALTER TABLE `subdomains` DISABLE KEYS */;
INSERT INTO `subdomains` VALUES (1,'karlstorz-events','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/karlstorz-events.goodface.com.ua','2020-10-29 14:15:57'),(3,'annsnytka','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/annsnytka.com','2020-10-29 14:15:59'),(5,'overplay','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/overplay.goodface.com.ua','2020-10-29 14:16:01'),(6,'baginskiy2','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/baginskiy2.goodface.com.ua','2020-10-29 14:16:02'),(8,'keto','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/keto.goodface.com.ua','2020-10-29 14:16:03'),(11,'goodface','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/goodface.agency','2020-10-29 14:16:06'),(69,'biomedical','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/dev-subdomains/biomedical.goodface.com.ua','2022-02-09 14:55:25'),(71,'creo','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/dev-subdomains/creo.goodface.com.ua','2022-04-20 11:05:42'),(15,'odrex','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/odrex.goodface.com.ua','2020-10-29 14:16:09'),(16,'online-platform','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/online-platform.goodface.com.ua','2020-10-29 14:16:10'),(18,'karlstorz','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/karlstorz.goodface.com.ua','2020-10-29 14:16:11'),(19,'payatlas','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/payatlas.goodface.com.ua','2020-10-29 14:16:13'),(75,'sayenko','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/dev-subdomains/sayenko.goodface.com.ua','2022-05-23 11:00:11'),(78,'betterbro','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/dev-subdomains/betterbro.goodface.com.ua','2022-06-01 14:53:46'),(59,'ecosphere','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/ecosphere.goodface.com.ua','2021-10-06 12:09:13'),(25,'klitschko','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/klitschko.goodface.com.ua','2020-10-29 14:16:19'),(27,'sparkskyiv','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/sparkskyiv.com','2020-10-29 14:16:20'),(29,'mail1','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/public_html','2020-10-29 21:37:51'),(32,'test','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/public','2020-11-05 18:24:27'),(61,'4bill','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/4bill.goodface.com.ua','2021-10-12 12:26:40'),(39,'smt','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/smt.goodface.com.ua','2020-12-18 16:44:31'),(49,'new','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/new.goodface.com.ua','2021-04-19 15:20:22'),(50,'my','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/my.goodface.com.ua','2021-04-19 15:24:41'),(52,'commercegate','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/commercegate.goodface.com.ua','2021-07-01 18:55:31'),(53,'mail','goodface.agency','bdqbpbxa','/home/bdqbpbxa/mail','2021-07-08 13:47:52'),(54,'cds','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/cds.goodface.com.ua','2021-07-15 16:40:00'),(67,'u-pod','goodface.com.ua','bdqbpbxa','/home/bdqbpbxa/dev-subdomains/u-pod.goodface.com.ua','2021-11-18 09:25:31');
/*!40000 ALTER TABLE `subdomains` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user`
--
DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(40) NOT NULL,
`domain` varchar(255) NOT NULL,
`ip_address` varchar(50) NOT NULL,
`email` varchar(255) NOT NULL,
`setup_date` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`package` varchar(40) NOT NULL,
`backup` varchar(40) NOT NULL,
`reseller` varchar(40) NOT NULL,
`last_access` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`bandwidth` varchar(40) NOT NULL DEFAULT '0',
`mail_disk` int(11) NOT NULL DEFAULT '0',
`mysql_disk` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user`
--
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'bdqbpbxa','goodface.com.ua','194.28.85.210','maximyakubovich@gmail.com','2020-10-29 14:12:55','1','on','','2021-03-30 23:34:15','9533',0,0),(2,'cascad','wp.cascad.goodface.com.ua','194.28.85.210','my@email.com','2020-11-05 18:29:24','1','on','','2021-03-30 23:31:04','',0,0),(3,'paygray','paygray.goodface.com.ua','194.28.85.210','my@email.com','2020-11-09 16:00:01','1','on','','2021-03-30 23:09:46','',0,0),(4,'thestory','thestory','194.28.85.210','my@email.com','2020-12-03 15:08:45','1','on','','2021-03-30 23:08:39','',0,0),(5,'uvitme','uvitme.goodface.com.ua','194.28.85.210','my@email.com','2021-02-10 15:20:28','1','on','','2021-03-30 23:07:59','',0,0),(8,'cascadg','cascad.goodface.com.ua','194.28.85.210','my@email.com','2021-05-24 15:53:18','1','on','','2000-01-01 00:00:00','',0,0),(9,'payatlas','payatlas.goodface.com.ua','194.28.85.210','my@email.com','2021-05-25 13:16:48','1','on','','2000-01-01 00:00:00','',0,0),(10,'ekabeaut','ekabeauty.goodface.com.ua','194.28.85.210','my@email.com','2021-06-04 13:19:26','1','on','','2000-01-01 00:00:00','9',0,0),(11,'upod','upod','194.28.85.210','my@email.com','2021-09-02 11:22:37','1','on','','2000-01-01 00:00:00','',0,0);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2022-06-11 11:54:38