FM / cpmove_failed_mysql

/home/desid573/cpmove_failed_mysql_dbs.1787413258/

/home/desid573/cpmove_failed_mysql_dbs.1787413258

Name	Size	Mode	Actions
exmawjn/	-	0755	rm
hjfltmn/	-	0755	rm
iycwuxz/	-	0755	rm
pioxjd1/	-	0755	rm
desid573_1410_inventory.create	1532	0600	edit dl rm
desid573_1410_inventory.sql	13101	0644	edit dl rm
desid573_ample.create	1496	0600	edit dl rm
desid573_ample.sql	23499	0644	edit dl rm
desid573_angel_drivers.create	1528	0600	edit dl rm
desid573_angel_drivers.sql	46029	0644	edit dl rm
desid573_eway_codes.create	1516	0600	edit dl rm
desid573_eway_codes.sql	280056841	0644	edit dl rm
desid573_famcab_api.create	1516	0600	edit dl rm
desid573_famcab_api.sql	7099373	0644	edit dl rm
desid573_familycab.create	1512	0600	edit dl rm
desid573_familycab.sql	32255236	0644	edit dl rm
desid573_gcdriver.create	1508	0600	edit dl rm
desid573_gcdriver.sql	33498	0644	edit dl rm
desid573_ims.create	1488	0600	edit dl rm
desid573_ims.sql	13928	0644	edit dl rm
desid573_inquiries.create	1512	0600	edit dl rm
desid573_inquiries.sql	5094749	0644	edit dl rm
desid573_magic.create	1496	0600	edit dl rm
desid573_magic.sql	85568	0644	edit dl rm
desid573_magic_site.create	1516	0600	edit dl rm
desid573_magic_site.sql	1442	0644	edit dl rm
desid573_new_pro_api.create	1520	0600	edit dl rm
desid573_new_pro_api.sql	2709995	0644	edit dl rm
desid573_oldvine.create	1504	0600	edit dl rm
desid573_oldvine.sql	18141	0644	edit dl rm
desid573_phewl.create	1496	0600	edit dl rm
desid573_phewl.sql	53985	0644	edit dl rm
desid573_tollster.create	1508	0600	edit dl rm
desid573_tollster.sql	1221097	0644	edit dl rm
desid573_wp38.create	1492	0600	edit dl rm
desid573_wp38.sql	912231	0644	edit dl rm
desid573_wp172.create	1496	0600	edit dl rm
desid573_wp172.sql	175912	0644	edit dl rm
desid573_wp255.create	1500	0600	edit dl rm
desid573_wp255.sql	314501	0644	edit dl rm
desid573_wp676.create	1500	0600	edit dl rm
desid573_wp676.sql	12067179	0644	edit dl rm
desid573_wp_0a5zc.create	1508	0600	edit dl rm
desid573_wp_0a5zc.sql	123538	0644	edit dl rm
desid573_wp_new.create	1500	0600	edit dl rm
desid573_wp_new.sql	7810728	0644	edit dl rm
openfileslimit	5	0600	edit dl rm
wp-cron-darb.php	1659	0644	edit dl rm

Edit: /home/desid573/cpmove_failed_mysql_dbs.1787413258/desid573_ims.sql (13928B)

-- MySQL dump 10.13  Distrib 8.4.9, for Linux (x86_64)
--
-- Host: localhost    Database: desid573_ims
-- ------------------------------------------------------
-- Server version	8.4.9-cll-lve

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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 */;

--
-- Current Database: `desid573_ims`
--

--
-- Table structure for table `ims_brands`
--

DROP TABLE IF EXISTS `ims_brands`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ims_brands` (
  `brand_id` int NOT NULL AUTO_INCREMENT,
  `brand_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `brand_active` int NOT NULL DEFAULT '0',
  `brand_status` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`brand_id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ims_brands`
--

LOCK TABLES `ims_brands` WRITE;
/*!40000 ALTER TABLE `ims_brands` DISABLE KEYS */;
INSERT INTO `ims_brands` (`brand_id`, `brand_name`, `brand_active`, `brand_status`) VALUES (24,'Chapel Farm',1,1),(25,'Jane Brook',1,1),(26,'First Bite',1,1),(27,'Collector of Souls',1,1);
/*!40000 ALTER TABLE `ims_brands` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ims_categories`
--

DROP TABLE IF EXISTS `ims_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ims_categories` (
  `categories_id` int NOT NULL AUTO_INCREMENT,
  `categories_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `categories_active` int NOT NULL DEFAULT '0',
  `categories_status` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`categories_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ims_categories`
--

LOCK TABLES `ims_categories` WRITE;
/*!40000 ALTER TABLE `ims_categories` DISABLE KEYS */;
INSERT INTO `ims_categories` (`categories_id`, `categories_name`, `categories_active`, `categories_status`) VALUES (5,'WET',1,1),(6,'No WET',1,1),(7,'Excise',1,1);
/*!40000 ALTER TABLE `ims_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ims_clients`
--

DROP TABLE IF EXISTS `ims_clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ims_clients` (
  `id_clients` int unsigned NOT NULL AUTO_INCREMENT,
  `client_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_phone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_state` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_zip` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_info` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id_clients`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ims_clients`
--

LOCK TABLES `ims_clients` WRITE;
/*!40000 ALTER TABLE `ims_clients` DISABLE KEYS */;
INSERT INTO `ims_clients` (`id_clients`, `client_name`, `client_phone`, `client_email`, `client_address`, `client_city`, `client_state`, `client_zip`, `client_info`) VALUES (5,'Chapel Farm','(089) 250-4755','','231 Toodyay Rd','Middle Swan','WA','6056',''),(6,'The Estate','(089) 250-4755','','229 Toodyay Rd','Middle Swan','WA','6056','');
/*!40000 ALTER TABLE `ims_clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ims_order_item`
--

DROP TABLE IF EXISTS `ims_order_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ims_order_item` (
  `order_item_id` int NOT NULL AUTO_INCREMENT,
  `order_id` int NOT NULL DEFAULT '0',
  `product_id` int NOT NULL DEFAULT '0',
  `quantity` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_item_status` int NOT NULL DEFAULT '0',
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`order_item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ims_order_item`
--

LOCK TABLES `ims_order_item` WRITE;
/*!40000 ALTER TABLE `ims_order_item` DISABLE KEYS */;
INSERT INTO `ims_order_item` (`order_item_id`, `order_id`, `product_id`, `quantity`, `rate`, `total`, `order_item_status`, `description`) VALUES (1,1,12,'1','1','1.00',1,NULL),(2,2,19,'1','1','1.00',1,NULL);
/*!40000 ALTER TABLE `ims_order_item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ims_orders`
--

DROP TABLE IF EXISTS `ims_orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ims_orders` (
  `order_id` int NOT NULL AUTO_INCREMENT,
  `order_date` date NOT NULL,
  `client_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_contact` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sub_total` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `vat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `discount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `grand_total` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `paid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `due` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_type` int NOT NULL,
  `payment_status` int NOT NULL,
  `payment_place` int NOT NULL,
  `gstn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_status` int NOT NULL DEFAULT '0',
  `user_id` int NOT NULL,
  `orderid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ims_orders`
--

LOCK TABLES `ims_orders` WRITE;
/*!40000 ALTER TABLE `ims_orders` DISABLE KEYS */;
INSERT INTO `ims_orders` (`order_id`, `order_date`, `client_name`, `client_contact`, `sub_total`, `vat`, `total_amount`, `discount`, `grand_total`, `paid`, `due`, `payment_type`, `payment_status`, `payment_place`, `gstn`, `order_status`, `user_id`, `orderid`, `notes`) VALUES (1,'2022-10-26','5','(089) 250-4755','1.00','0.10','1.10','0','1.10','0','1.10',1,1,1,'0.10',1,3,'2022102600001',''),(2,'2022-10-27','6','(089) 250-4755','1.00','0.10','1.10','0','1.10','0','1.10',1,1,1,'0.10',1,3,'2022102700002','');
/*!40000 ALTER TABLE `ims_orders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ims_product`
--

DROP TABLE IF EXISTS `ims_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ims_product` (
  `product_id` int NOT NULL AUTO_INCREMENT,
  `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_image` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `brand_id` int NOT NULL,
  `categories_id` int NOT NULL,
  `quantity` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '0',
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ims_product`
--

LOCK TABLES `ims_product` WRITE;
/*!40000 ALTER TABLE `ims_product` DISABLE KEYS */;
INSERT INTO `ims_product` (`product_id`, `product_name`, `product_image`, `brand_id`, `categories_id`, `quantity`, `rate`, `active`, `status`, `description`) VALUES (12,'NV Plain Jane Rose','../assets/images/stock/12451456486358f520b5dca.png',24,5,'106','1',1,1,''),(13,'NV Plain Jane White','../assets/images/stock/15119721606358f57d97663.png',25,6,'300','1',1,1,''),(14,'2020 Sauvignon Blanc','../assets/images/stock/3076893876358f7a075406.png',25,6,'40','1',1,1,'Margaret River'),(15,'2017 Malbec','../assets/images/stock/19035426516358f7dc1a27b.png',25,6,'55','1',1,1,'Margaret River'),(16,'2017 Cabernet Sauvignon','../assets/images/stock/17046463136358f837bb3a1.png',25,6,'50','1',1,1,'Margaret River'),(17,'2018 Shiraz','../assets/images/stock/355334566358f86667b7a.png',25,6,'50','1',1,1,'Swan Valley Back Block'),(18,'NV Sparkling Gold','../assets/images/stock/12200609476358f8a5dc6a7.png',25,6,'0','1',1,1,''),(19,'NV Sparkling Gold SWEET','../assets/images/stock/20245842436358f8d28331a.png',25,6,'9','1',1,1,''),(20,'NV Plain Jane Red','../assets/images/stock/12732774546358fc443f11a.png',25,6,'350','1',1,1,''),(21,'2017 Sauvignon Blanc Semillon','../assets/images/stock/11777720996358fc8822822.png',25,6,'32','1',1,1,'Margaret River'),(22,'NV Sparkling Rose','../assets/images/stock/2492848486358fcbe049f4.png',25,6,'6','1',1,1,''),(23,'NV Sparkling White','../assets/images/stock/2830089026358fcf3b483b.png',25,6,'100','1',1,1,''),(24,'NV Sparkling Temple White','../assets/images/stock/15765229406358ff6ab5b6a.png',24,6,'5','1',1,1,''),(25,'NV Temple Moscato','../assets/images/stock/11876531176358ff86ed997.png',24,6,'60','1',1,1,'');
/*!40000 ALTER TABLE `ims_product` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ims_system`
--

DROP TABLE IF EXISTS `ims_system`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ims_system` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(20) NOT NULL,
  `zip` varchar(100) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `cell` varchar(100) NOT NULL,
  `email` varchar(255) NOT NULL,
  `tax` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ims_system`
--

LOCK TABLES `ims_system` WRITE;
/*!40000 ALTER TABLE `ims_system` DISABLE KEYS */;
INSERT INTO `ims_system` (`id`, `company`, `address`, `city`, `state`, `zip`, `phone`, `cell`, `email`, `tax`) VALUES (1,'Chapel Farm Estate','229-231 Toodyay Rd','Middle Swan','WA','6056','','','chapelfarm@chapelfarm.com.au','10%');
/*!40000 ALTER TABLE `ims_system` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ims_users`
--

DROP TABLE IF EXISTS `ims_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ims_users` (
  `user_id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ims_users`
--

LOCK TABLES `ims_users` WRITE;
/*!40000 ALTER TABLE `ims_users` DISABLE KEYS */;
INSERT INTO `ims_users` (`user_id`, `username`, `password`, `email`) VALUES (1,'admin','19ed9acf2adf0858a053eb452d05d83c',''),(2,'test','d41d8cd98f00b204e9800998ecf8427e','bla@home.com'),(3,'lewiscann','5f4dcc3b5aa765d61d8327deb882cf99','lwscann@gmail.com');
/*!40000 ALTER TABLE `ims_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'desid573_ims'
--

--
-- Dumping routines for database 'desid573_ims'
--
/*!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 2026-08-23  1:39:01

cmd: