/home/desid573/cpmove_failed_mysql_dbs.1787413258
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