/home/bdqbpbxa/db_dumps/root_db/root_cpmigrations.sql
-- MySQL dump 10.19 Distrib 10.2.39-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: root_cpmigrations
-- ------------------------------------------------------
-- 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 `accounts`
--
DROP TABLE IF EXISTS `accounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accounts` (
`ID` int(5) NOT NULL AUTO_INCREMENT,
`ID_MIGRATION` int(5) DEFAULT NULL,
`USER_REMOTE` varchar(255) DEFAULT NULL,
`NEW_USERNAME` varchar(255) DEFAULT NULL,
`COPY_DB` int(2) DEFAULT NULL,
`COPY_HOME` int(2) DEFAULT NULL,
`COPY_RESELLER` int(2) DEFAULT NULL,
`START_DATE` datetime DEFAULT NULL,
`FINISH_DATE` datetime DEFAULT NULL,
`STATUS` int(5) DEFAULT NULL,
`BACKUP_ID` varchar(0) DEFAULT NULL,
`FILE_NAME` varchar(255) DEFAULT NULL,
`PERCENTAGE` varchar(255) DEFAULT NULL,
`LOGS` text,
`FILE_BACKLOG` varchar(255) DEFAULT NULL,
`FILE_BACK_ELOG` varchar(255) DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `accounts`
--
LOCK TABLES `accounts` WRITE;
/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `accounts_cwp`
--
DROP TABLE IF EXISTS `accounts_cwp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accounts_cwp` (
`ID` int(5) NOT NULL AUTO_INCREMENT,
`ID_MIGRATION` int(5) DEFAULT NULL,
`USER_REMOTE` varchar(255) DEFAULT NULL,
`NEW_USERNAME` varchar(255) DEFAULT NULL,
`COPY_DB` int(2) DEFAULT NULL,
`COPY_HOME` int(2) DEFAULT NULL,
`COPY_RESELLER` int(2) DEFAULT NULL,
`START_DATE` datetime DEFAULT NULL,
`FINISH_DATE` datetime DEFAULT NULL,
`STATUS` int(5) DEFAULT NULL,
`BACKUP_ID` varchar(0) DEFAULT NULL,
`FILE_NAME` varchar(255) DEFAULT NULL,
`PERCENTAGE` varchar(255) DEFAULT NULL,
`LOGS` text,
`FILE_BACKLOG` varchar(255) DEFAULT NULL,
`FILE_BACK_ELOG` varchar(255) DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `accounts_cwp`
--
LOCK TABLES `accounts_cwp` WRITE;
/*!40000 ALTER TABLE `accounts_cwp` DISABLE KEYS */;
/*!40000 ALTER TABLE `accounts_cwp` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `connect_confi`
--
DROP TABLE IF EXISTS `connect_confi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `connect_confi` (
`ID` int(5) NOT NULL AUTO_INCREMENT,
`SERVER_IP` varchar(255) DEFAULT NULL,
`USER` varchar(255) DEFAULT NULL,
`PORT_SSH` varchar(255) DEFAULT NULL,
`APIKEY_CPANEL` varchar(255) DEFAULT NULL,
`COMMAND` varchar(255) DEFAULT NULL,
`SIMULT` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `connect_confi`
--
LOCK TABLES `connect_confi` WRITE;
/*!40000 ALTER TABLE `connect_confi` DISABLE KEYS */;
/*!40000 ALTER TABLE `connect_confi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `connect_confi_cwp`
--
DROP TABLE IF EXISTS `connect_confi_cwp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `connect_confi_cwp` (
`ID` int(5) NOT NULL AUTO_INCREMENT,
`SERVER_IP` varchar(255) DEFAULT NULL,
`USER` varchar(255) DEFAULT NULL,
`PORT_SSH` varchar(255) DEFAULT NULL,
`APIKEY_CPANEL` varchar(255) DEFAULT NULL,
`COMMAND` varchar(255) DEFAULT NULL,
`SIMULT` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `connect_confi_cwp`
--
LOCK TABLES `connect_confi_cwp` WRITE;
/*!40000 ALTER TABLE `connect_confi_cwp` DISABLE KEYS */;
/*!40000 ALTER TABLE `connect_confi_cwp` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `migrations`
--
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
`ID` int(3) NOT NULL AUTO_INCREMENT,
`CODE` varchar(255) DEFAULT NULL,
`ID_REMOTESERVER` int(3) DEFAULT NULL,
`START_DATE` datetime DEFAULT NULL,
`FINISH_DATE` datetime DEFAULT NULL,
`STATUS` int(3) DEFAULT NULL,
`LOGS_TRANSFER` text,
`LOGS_RESTORE` text,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `migrations`
--
LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `migrations_cwp`
--
DROP TABLE IF EXISTS `migrations_cwp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations_cwp` (
`ID` int(3) NOT NULL AUTO_INCREMENT,
`CODE` varchar(255) DEFAULT NULL,
`ID_REMOTESERVER` int(3) DEFAULT NULL,
`START_DATE` datetime DEFAULT NULL,
`FINISH_DATE` datetime DEFAULT NULL,
`STATUS` int(3) DEFAULT NULL,
`LOGS_TRANSFER` text,
`LOGS_RESTORE` text,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `migrations_cwp`
--
LOCK TABLES `migrations_cwp` WRITE;
/*!40000 ALTER TABLE `migrations_cwp` DISABLE KEYS */;
/*!40000 ALTER TABLE `migrations_cwp` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `package`
--
DROP TABLE IF EXISTS `package`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `package` (
`ID` int(1) NOT NULL AUTO_INCREMENT,
`ID_MIGRATION` varchar(255) DEFAULT NULL,
`PACK_NAME` varchar(255) DEFAULT NULL,
`START_DATE` datetime DEFAULT NULL,
`FINISH_DATE` datetime DEFAULT NULL,
`STATUS` int(2) DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `package`
--
LOCK TABLES `package` WRITE;
/*!40000 ALTER TABLE `package` DISABLE KEYS */;
/*!40000 ALTER TABLE `package` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `package_cwp`
--
DROP TABLE IF EXISTS `package_cwp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `package_cwp` (
`ID` int(1) NOT NULL AUTO_INCREMENT,
`ID_MIGRATION` varchar(255) DEFAULT NULL,
`PACK_NAME` varchar(255) DEFAULT NULL,
`START_DATE` datetime DEFAULT NULL,
`FINISH_DATE` datetime DEFAULT NULL,
`STATUS` int(2) DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `package_cwp`
--
LOCK TABLES `package_cwp` WRITE;
/*!40000 ALTER TABLE `package_cwp` DISABLE KEYS */;
/*!40000 ALTER TABLE `package_cwp` 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:17