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_1410_inventory.sql (13101B)

-- MySQL dump 10.13  Distrib 8.4.9, for Linux (x86_64)
--
-- Host: localhost    Database: desid573_1410_inventory
-- ------------------------------------------------------
-- 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_1410_inventory`
--

--
-- Table structure for table `admin`
--

DROP TABLE IF EXISTS `admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `admin` (
  `id` int NOT NULL AUTO_INCREMENT,
  `first_name` varchar(25) NOT NULL,
  `last_name` varchar(25) NOT NULL,
  `email` varchar(255) NOT NULL,
  `mobile1` varchar(15) NOT NULL,
  `mobile2` varchar(15) NOT NULL,
  `password` char(60) NOT NULL,
  `role` char(5) NOT NULL,
  `created_on` datetime NOT NULL,
  `last_login` datetime NOT NULL,
  `last_seen` datetime NOT NULL,
  `last_edited` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `account_status` char(1) NOT NULL DEFAULT '1',
  `deleted` char(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `mobile1` (`mobile1`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin`
--

LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` (`id`, `first_name`, `last_name`, `email`, `mobile1`, `mobile2`, `password`, `role`, `created_on`, `last_login`, `last_seen`, `last_edited`, `account_status`, `deleted`) VALUES (1,'Admin','Demo','demo@1410inc.xyz','08021111111','07032222222','$2y$10$xv9I14OlR36kPCjlTv.wEOX/6Dl7VMuWCl4vCxAVWP1JwYIaw4J2C','Super','2017-01-04 22:19:16','2024-05-01 19:40:34','2018-05-18 17:28:09','2024-05-01 09:40:34','1','0'),(2,'Lewis','Cann','lewis@chapelfarm.com.au','+61400227505','','$2y$10$WZK2U3nuzlQ42jRHYpyVFO/85FB2TsXI0GS6HqkRj7GXUd81gnjw6','Super','2024-05-01 19:41:20','2024-07-04 09:46:52','2024-07-04 09:54:31','2024-07-03 23:54:31','1','0');
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `eventlog`
--

DROP TABLE IF EXISTS `eventlog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `eventlog` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `event` varchar(200) NOT NULL,
  `eventRowIdOrRef` varchar(20) DEFAULT NULL,
  `eventDesc` text,
  `eventTable` varchar(20) DEFAULT NULL,
  `staffInCharge` bigint unsigned NOT NULL,
  `eventTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eventlog`
--

LOCK TABLES `eventlog` WRITE;
/*!40000 ALTER TABLE `eventlog` DISABLE KEYS */;
INSERT INTO `eventlog` (`id`, `event`, `eventRowIdOrRef`, `eventDesc`, `eventTable`, `staffInCharge`, `eventTime`) VALUES (1,'Creation of new item','1','Addition of 432 quantities of a new item \'Temple Sparkling White\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-01 09:43:07'),(2,'Creation of new item','2','Addition of 79 quantities of a new item \'Chapel Farm Sparkling Rose\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-01 09:44:53'),(3,'Creation of new item','3','Addition of 31 quantities of a new item \'Chapel Farm Sparkling White\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-01 09:45:58'),(4,'Creation of new item','4','Addition of 485 quantities of a new item \'Jane Brook Sparkling White\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-01 09:46:19'),(5,'Creation of new item','5','Addition of 56 quantities of a new item \'Jane Brook Sparkling Gold\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-01 09:46:47'),(6,'Creation of new item','6','Addition of 151 quantities of a new item \'Chapel Farm Sparkling Gold\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-01 09:47:23'),(7,'Creation of new item','7','Addition of 67 quantities of a new item \'Jane Brook Sweet Sparkling Gold\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-01 09:47:48'),(8,'Creation of new item','8','Addition of 2580 quantities of a new item \'Plain Jane White\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-01 09:48:16'),(9,'Creation of new item','9','Addition of 648 quantities of a new item \'Chapel Farm Temple Moscato\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-01 09:49:00'),(10,'Creation of new item','10','Addition of 16 quantities of a new item \'Chapel Farm Temple Chardonnay\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-01 09:49:20'),(11,'Creation of new item','11','Addition of 636 quantities of a new item \'Plain Jane Red\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-01 09:50:09'),(12,'Creation of new item','12','Addition of 120 quantities of a new item \'Jane Brook Shiraz 2018\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-01 09:50:44'),(13,'Creation of new item','13','Addition of 900 quantities of a new item \'2022 Chapel Farm Shiraz\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-04 07:22:52'),(14,'Creation of new item','14','Addition of 2496 quantities of a new item \'2017 Cabernet Sauvignon Jane Brook\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-04 07:23:30'),(15,'Creation of new item','15','Addition of 240 quantities of a new item \'2018 Malbec Jane Brook\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-04 07:23:59'),(16,'Creation of new item','16','Addition of 240 quantities of a new item \'2022 Grenache Shiraz Chapel Farm\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-04 07:24:25'),(17,'Creation of new item','17','Addition of 10 quantities of a new item \'Liqueur Verdelho Chapel Farm\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-04 07:24:53'),(18,'Creation of new item','18','Addition of 13 quantities of a new item \'Liqueur Shiraz Chapel Farm\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-04 07:25:25'),(19,'Creation of new item','19','Addition of 0 quantities of a new item \'2024 Rose Chapel Farm Temple\' with a unit price of &#8358;0.00 to stock','items',2,'2024-05-04 07:28:02'),(20,'Stock Update (New Stock)','19','850 quantities of 2024 Rose Chapel Farm Temple was added to stock\n Reason: Produced 2024, bottled April','items',2,'2024-05-04 07:28:40'),(21,'Stock Update (New Stock)','2','472 quantities of Chapel Farm Sparkling Rose was added to stock\n Reason: New items were produced','items',2,'2024-06-19 03:38:31');
/*!40000 ALTER TABLE `eventlog` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `items`
--

DROP TABLE IF EXISTS `items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text,
  `unitPrice` decimal(10,2) NOT NULL,
  `quantity` int NOT NULL,
  `dateAdded` datetime NOT NULL,
  `lastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `items`
--

LOCK TABLES `items` WRITE;
/*!40000 ALTER TABLE `items` DISABLE KEYS */;
INSERT INTO `items` (`id`, `name`, `code`, `description`, `unitPrice`, `quantity`, `dateAdded`, `lastUpdated`) VALUES (1,'Temple Sparkling White','CFTW','',0.00,432,'2024-05-01 19:43:07','2024-05-01 09:43:07'),(2,'Chapel Farm Sparkling Rose','CFSR','',0.00,551,'2024-05-01 19:44:53','2024-06-19 03:38:31'),(3,'Chapel Farm Sparkling White','CFSW','',0.00,31,'2024-05-01 19:45:58','2024-05-01 09:45:58'),(4,'Jane Brook Sparkling White','JBSF','',0.00,485,'2024-05-01 19:46:19','2024-05-01 09:46:19'),(5,'Jane Brook Sparkling Gold','JBSG','',0.00,56,'2024-05-01 19:46:47','2024-05-01 09:46:47'),(6,'Chapel Farm Sparkling Gold','CFSG','',0.00,151,'2024-05-01 19:47:23','2024-05-01 09:47:23'),(7,'Jane Brook Sweet Sparkling Gold','JBSS','',0.00,67,'2024-05-01 19:47:48','2024-05-01 09:47:48'),(8,'Plain Jane White','PJW','',0.00,2580,'2024-05-01 19:48:16','2024-05-01 09:48:16'),(9,'Chapel Farm Temple Moscato','CFTM','',0.00,648,'2024-05-01 19:49:00','2024-05-01 09:49:00'),(10,'Chapel Farm Temple Chardonnay','CFTC','',0.00,16,'2024-05-01 19:49:20','2024-05-01 09:49:20'),(11,'Plain Jane Red','PJR','$5 each ex WET ex GST',0.00,636,'2024-05-01 19:50:09','2024-05-01 09:50:09'),(12,'Jane Brook Shiraz 2018','18JBS','',0.00,120,'2024-05-01 19:50:44','2024-05-01 09:50:44'),(13,'2022 Chapel Farm Shiraz','22SHZCF','back block',0.00,900,'2024-05-04 17:22:52','2024-05-04 07:22:52'),(14,'2017 Cabernet Sauvignon Jane Brook','17CABJB','',0.00,2496,'2024-05-04 17:23:30','2024-05-04 07:23:30'),(15,'2018 Malbec Jane Brook','17MALJB','',0.00,240,'2024-05-04 17:23:59','2024-05-04 07:23:59'),(16,'2022 Grenache Shiraz Chapel Farm','22GRECF','',0.00,240,'2024-05-04 17:24:25','2024-05-04 07:24:25'),(17,'Liqueur Verdelho Chapel Farm','LIQVERCF','',0.00,10,'2024-05-04 17:24:53','2024-05-04 07:24:53'),(18,'Liqueur Shiraz Chapel Farm','LIQSHZCF','',0.00,13,'2024-05-04 17:25:25','2024-05-04 07:25:25'),(19,'2024 Rose Chapel Farm Temple','24ROSCF','',0.00,850,'2024-05-04 17:28:02','2024-05-04 07:28:40');
/*!40000 ALTER TABLE `items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lk_sess`
--

DROP TABLE IF EXISTS `lk_sess`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lk_sess` (
  `id` varchar(40) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int unsigned NOT NULL DEFAULT '0',
  `data` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lk_sess`
--

LOCK TABLES `lk_sess` WRITE;
/*!40000 ALTER TABLE `lk_sess` DISABLE KEYS */;
/*!40000 ALTER TABLE `lk_sess` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transactions`
--

DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `transactions` (
  `transId` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref` varchar(10) NOT NULL,
  `itemName` varchar(50) NOT NULL,
  `itemCode` varchar(50) NOT NULL,
  `description` text,
  `quantity` int NOT NULL,
  `unitPrice` decimal(10,2) NOT NULL,
  `totalPrice` decimal(10,2) NOT NULL,
  `totalMoneySpent` decimal(10,2) NOT NULL,
  `amountTendered` decimal(10,2) NOT NULL,
  `discount_amount` decimal(10,2) NOT NULL,
  `discount_percentage` decimal(10,2) NOT NULL,
  `vatPercentage` decimal(10,2) NOT NULL,
  `vatAmount` decimal(10,2) NOT NULL,
  `changeDue` decimal(10,2) NOT NULL,
  `modeOfPayment` varchar(20) NOT NULL,
  `cust_name` varchar(20) DEFAULT NULL,
  `cust_phone` varchar(15) DEFAULT NULL,
  `cust_email` varchar(50) DEFAULT NULL,
  `transType` char(1) NOT NULL,
  `staffId` bigint unsigned NOT NULL,
  `transDate` datetime NOT NULL,
  `lastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cancelled` char(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`transId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transactions`
--

LOCK TABLES `transactions` WRITE;
/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'desid573_1410_inventory'
--

--
-- Dumping routines for database 'desid573_1410_inventory'
--
/*!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:38:47

cmd: