/home/desid573/cpmove_failed_mysql_dbs.1787413258
Edit: /home/desid573/cpmove_failed_mysql_dbs.1787413258/desid573_oldvine.sql (18141B)
-- MySQL dump 10.13 Distrib 8.4.9, for Linux (x86_64)
--
-- Host: localhost Database: desid573_oldvine
-- ------------------------------------------------------
-- 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_oldvine`
--
--
-- Table structure for table `block`
--
DROP TABLE IF EXISTS `block`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `block` (
`id` int NOT NULL AUTO_INCREMENT,
`vid` int NOT NULL,
`old_vine` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`variety` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`year` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`block` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`clone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`no_vines` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`rootstock_bool` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`rootstock` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`soil_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`training` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`orientation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `block`
--
LOCK TABLES `block` WRITE;
/*!40000 ALTER TABLE `block` DISABLE KEYS */;
INSERT INTO `block` (`id`, `vid`, `old_vine`, `variety`, `year`, `block`, `clone`, `no_vines`, `area`, `rootstock_bool`, `rootstock`, `soil_type`, `training`, `orientation`, `permission`) VALUES (1,1,'Old Vine','Semillon','1987','Back Block','gin','400','4','rootstock','chardonnay','grass','upright','up-down',''),(8,12,'Survivor Vine','Shiraz','1952','Front Block','','1288','2','own roots','','Sand over clay','Sprawl','East-West',''),(7,4,'Young Vine','Chardonnay','2009','bing bong','gin gin','3','3','rootstock','Riparia','Sand over clay','Lyre','North-South',''),(6,1,'Centenarian Vine','cbs','1956','River Block','','2','5','own roots','','alluvial','bush','north-south',''),(9,14,'Centenarian Vine','Test ','1926 ','Test ','Test ','3900','3','rootstock','Kober','Sand over clay','VSP','Test ',''),(10,15,'Young Vine','Chardonnay','1999','1999','','12','5','own roots','','Alluvial','Bush','East-West',''),(11,18,'Centenarian Vine','bob\'s','198\'9','bob\'s','bob\'s','1\'1','7\'8','rootstock','bob\'s','bob\'s','bob\'s','bob\'s','yes'),(12,18,'Survivor Vine','Grenache','1988','test','','1','1','own roots','','Alluvial','Bush','East-West','no'),(13,19,'Survivor Vine','Muscat Gordo','1926','Test','test','125','0.6','rootstock','Test','Test','test','north','yes'),(14,28,'Old Vine','Chenin Blanc','1972','Corner Gnangara/West Swan Road','N/A','2000','0.2','rootstock','34em','Loam','Lyre','East-West',''),(15,28,'Old Vine','Chenin Blanc','1972','Corner Gnangara/West Swan Road','N/A','2000','0.2','rootstock','34em','Loam','Lyre','East-West',''),(16,27,'Survivor Vine','Shiraz','1926 ','','','300','2','own roots','','loam on clay base','Vertical trellising','East-West','yes'),(17,27,'Survivor Vine','Shiraz','1932','','','2600','1.7','own roots','','loam on clay base','Vertical trellising','East-West','yes'),(18,27,'Old Vine','Shiraz','1977','','','1900','1.4','own roots','','loam on clay base','Vertical trellising','East-West','yes'),(19,32,'Old Vine','Cabernet Sauvignon','1972','','Houghton','666','0.5 ha','rootstock','Schwartzman','Alluvial','Post and wire','North-South','yes'),(20,33,'Survivor Vine','Chenin Blanc','1930','Block 11','','2566','1.94 ha','own roots','','Alluvial','VSP','East-West','yes'),(21,33,'Old Vine','Chenin Blanc','1955','Block 12','','3320','2.51','own roots','','Sand over clay','VSP','East-West','yes'),(22,33,'Old Vine','Chenin Blanc','1963','Gateway','','3175','2.4ha','own roots','','Sand over clay','VSP','North-South','yes'),(23,34,'Centenarian Vine','Grenache','prior to 1933 still hoping for more information from historian Librarian at Swan Library.','Lot 241','','1200 ','5 acres','own roots','','Sand over clay','Bush','East-West','no'),(24,34,'Centenarian Vine','Grenache','prior to 1933 still hoping for more information from historian Librarian at Swan Library.','Lot 241','','1200 ','5 acres','own roots','','Sand over clay','Bush','East-West','no'),(25,34,'Centenarian Vine','Chardonnay','prior to 1933 still hoping for more information from historian Librarian at Swan Library.','Lot 241','','2995','6Acres','own roots','','Sand over clay','Bush','East-West',''),(26,34,'Centenarian Vine','Grenache','prior to 1933 still hoping for more information from historian Librarian at Swan Library.','Lot 241','','2995','6Acres','own roots','','Sand over clay','Bush','East-West',''),(27,34,'Centenarian Vine','Grenache','prior to 1933 still hoping for more information from historian Librarian at Swan Library.','Lot 241','','2995','6Acres','own roots','','Sand over clay','Bush','East-West',''),(28,37,'Young Vine','Grenache','2018','B7','unknown','2100','0.97','rootstock','Schwartzman','Loam','VSP','North-South','');
/*!40000 ALTER TABLE `block` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `register`
--
DROP TABLE IF EXISTS `register`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `register` (
`id` int NOT NULL AUTO_INCREMENT,
`vineyard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`vineyard_owner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`vineyard_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`vineyard_suburb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`contact_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`contact_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`contact_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`contact_mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`bought` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`purchase` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`login_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `register`
--
LOCK TABLES `register` WRITE;
/*!40000 ALTER TABLE `register` DISABLE KEYS */;
INSERT INTO `register` (`id`, `vineyard_name`, `vineyard_owner`, `vineyard_address`, `vineyard_suburb`, `contact_name`, `contact_email`, `contact_phone`, `contact_mobile`, `bought`, `purchase`, `login_code`) VALUES (22,'Tylers Vineyard ','Donelle and Colin Tyler','301 Padbury Avenue ','Millendon ','Donelle Tyler','0438296000','','0438296000','Talijancich, Windy creek in the past \r\nPresent OFW ','','597b68db60549ed95901baff19b04771'),(20,'','','','','','','','','','','b781cbb29054db12f88f08c6e161c199'),(21,'Rocket\'s Vineyard','Lyn Mann','30 Nolan Avenue','Upper Swan','Genevieve Mann','0439973195','0439973195','0439973195','Corymbia and Vino Volta','None','8d64c68c6f055ef5ea553aa795744bbc'),(19,'Vineyard Test','Joe Bloggs','19 Hyem','Herne Hill ','Sharon O\'Reilly','0419043059','0419043059','0419043059','','','db9028af2e85e53b562f60348ad66a0c'),(14,'Vineyard test ','Joe bloggs ','5 hyena st herne hill ','','Joe bluffs ','Sharon.oreillt@iinet.net.au ','0449590223','0449590223 ','Xxxxx','Xxxxx','aaee9f0a365cf413f72b40665ca67778'),(15,'Test','Deb Tucker','Great Northern Hwy, Herne Hill 6056','','Deb Tucker','debsytucker@gmail.com','+61447195819','0447195819','Jo Bloggs','Joe Bloggs','0c48f20bafa7d726f73265e3e6d697b3'),(16,'Test','Test','Test','','Test','Test','Test','Test','Test','Test','c3868c8277f5dc846fe660697fa7adca'),(23,'Tylers Vineyard ','Donelle and Colin Tyler','301 Padbury Avenue ','Millendon ','Donelle Tyler','0438296000','','0438296000','Talijancich, Windy creek in the past \r\nPresent OFW ','','597b68db60549ed95901baff19b04771'),(24,'funk ','funk cider/funk wine','38 swan street ','Henley Brook','Mariane Bornelli','0428649660','93787007','0428649660','we have not sold grapes yet and we might use all of them for our own production.','Garbin Estate\r\nSandalford\r\nWe also purchased grenache from a grower on Campersic road but I don\'t know who (Garth sourced it for us)','d2d80a424018b8b3a597989e8636ba48'),(25,'Windy Creek Estate','Tony Cobanov','27 Stock Road','Herne Hill','Tony Cobanov','0417 972 016','9296 1057','0417 972 016','','','8533b364a4e6edab897712c528e9e27b'),(26,'Deb','Deb','Swan Valley','Herne Hill','Deb','0447195819','0447195819','0447195819','','','b829fca112866b3315943f82d8ffc865'),(27,'Talijancich Wines','James and Hilda Talijancich','26 Hyem Road','Herne Hill','James Talijancich','0419 191 771','9296 4289','0419 191 771','','','293a42c52ebe9d451ae9add57810aca0'),(28,'Edgecombe Brothers','Edgecombe Bros Pty Ltd','1733 Gnangara Road','Henley Brook','Alfred Edgecombe','N/A','92964307','N/A','N/A','John Barret-Leonard/Davis Family, West Swan Road Belhus 6069','3c1cfc7e02e872f7e99ba581ec0974db'),(29,'Henley Brook Winery ','Xilei Liu ','6 Swan St ','Henley Brook ','Xilei Liu (Celia)','0475938885','','0475938885','','','0e48e037428bc73204164fc7cb3bdd83'),(30,'Twin Hill Wines ','Stephen and Anthony Kraljevich','1093 Great Northern Hwy','Baskerville ','Robyn Kraljevich ','0438956329','','0438956329','','','e628bae210e553462bdbb4a6e24ce77f'),(31,'Talijancich Wines','James and Hilda Talijancich','26 Hyem Rd','HERNE HILL','Hilda Talijancich','0419191771','0892964289','0419191771','','','293a42c52ebe9d451ae9add57810aca0'),(32,'Lamont Winery','Corin Lamont','85 Bisdee Road','Millendon 6056','Corin lamont','0488776474','92964485','0488776474','','','96982b4b135394abdfa304e52a1b367e'),(33,'Nikola Estate','Yukich Family','148 Dale Road','Middle Swan','Matty Trent','0417948669','0417948669','0417948669','Houghton Wines','','ba1264cc43a586bf281c45ec5b8a4885'),(34,'Tylers Vineyard','Donelle and Colin Tyler','301 Padbury Avenue','Millendon/ Perth','Donelle Tyler','0438296000','','0438296000','Olive Farm Wines, Anthony Yurisich','','4f441eb469f87eba0fc9ff0f4eba0059'),(35,'Tylers Vineyard','Donelle and Colin Tyler','301 Padbury Avenue','Millendon/ Perth','Donelle Tyler','0438296000','','0438296000','Olive Farm Wines, Anthony Yurisich','','4f441eb469f87eba0fc9ff0f4eba0059'),(36,'Tylers Vineyard','Donelle and Colin Tyler','301 Padbury Avenue','Millendon/ Perth','Donelle Tyler','0438296000','','0438296000','Olive Farm Wines, Anthony Yurisich','','4f441eb469f87eba0fc9ff0f4eba0059'),(37,'Sandalford Caversham Estate','Prendiville Group','3210 West Swan Road','Caversham','Ross Pamment','0407 601 553','08 9374 9314','0407 601 553','Vino Volta\r\nFogarty Wine Group\r\nRiverbank Estate','N/A','d8bb1cfc5d8d6c3810bf649ebcd4043c'),(38,'Twin Hill Wines ','Stephen and Anthony Kraljevich','1093 Great Northern Hwy','Baskerville ','Robyn Kraljevich ','0438956329','','0438956329','','','e46dbf728b5ca51c76bb06fa23e4e18d'),(39,'Spencer Kshlerin','Usability','71205 Miller Lane','East Kaiberg','22969874','7733060983','3799568041','7733060983','','','9307906a450e40f80e3d1eb343dae5f3'),(40,'LAMONT WINERY','CORIN LAMONT','85 BISDEE ROAD','MILLENDON','CORIN LAMONT','0488776474','92964485','0488776474','NONE','NONE','96982b4b135394abdfa304e52a1b367e'),(41,'xx','xx','xx','xx','xx','xx','xx','xx','xx','xx','a87d4a315ef086339bc89fb12c694a8f'),(42,'Asif Ali','','Ul. Dziewiarska 34','','Asif Ali','7532833829','7532833829','7532833829','Hello http://svoldvine.com.au,\r\n \r\nI wanted to reach out to see if you’re open to exploring ways to grow your website traffic and boost online performance.\r\n \r\nWe offer customized SEO services that deliver measurable improvements.\r\n \r\nOnce you share your ','Hello http://svoldvine.com.au,\r\n \r\nI hope you’re doing well. I came across your business online and thought you might be interested in improving your visibility and traffic on search engines.\r\n \r\nWe specialize in helping businesses strengthen their online','c954bf53925ac89f2e5d80e3ea5b0f9d'),(43,'Natasha Raj','','Corso Porta Borsari 40','','Natasha Raj','3684124452','3684124452','3684124452','Hello,\r\n\r\n\r\nI hope everything is going great on your end.\r\n\r\n\r\nOur company has a team of full-time SEO experts focused on delivering keyword-driven results.\r\n\r\n\r\nPlease let me know if you\'d like to see our SEO plans and price list.\r\n\r\n\r\nWarm regards,\r\n\r\n\r','Hello,\r\n\r\n\r\nI hope everything is going great on your end.\r\n\r\n\r\nOur company has a team of full-time SEO experts focused on delivering keyword-driven results.\r\n\r\n\r\nPlease let me know if you\'d like to see our SEO plans and price list.\r\n\r\n\r\nWarm regards,\r\n\r\n\r','efea640733e29ac8c6d0625fdf6f03cf'),(44,'Edward Smith','','Klettsbu? 43','','Edward Smith','4323280','4323280','4323280','Hi,\r\n\r\nI checked your website and found a few SEO improvements that can help increase your Google rankings and generate more quality leads.\r\n\r\nI can share a quick SEO proposal with pricing and a strategy tailored for your business growth.\r\n\r\nLet me know i','Hi,\r\n\r\nI checked your website and found a few SEO improvements that can help increase your Google rankings and generate more quality leads.\r\n\r\nI can share a quick SEO proposal with pricing and a strategy tailored for your business growth.\r\n\r\nLet me know i','8c348b7c8ed00ff22ad3f3d428c1b623'),(45,'Natasha Raj','','Ul. 1 Maja 45','','Natasha Raj','796623051','796623051','796623051','Hello,\r\n\r\nI came across your website and noticed there may be opportunities to improve search visibility and overall SEO performance.\r\n\r\nWe provide SEO support tailored to business goals and website requirements.\r\n\r\nIf you\'d like more details, I can share','Hello,\r\n\r\nI came across your website and noticed there may be opportunities to improve search visibility and overall SEO performance.\r\n\r\nWe provide SEO support tailored to business goals and website requirements.\r\n\r\nIf you\'d like more details, I can share','efea640733e29ac8c6d0625fdf6f03cf'),(46,'Natasha Raj','','Landhausstra?E 6','','Natasha Raj','3332514394','3332514394','3332514394','Hi,\r\n\r\nQuick question regarding your website — are you planning any updates or SEO improvements?\r\n\r\nWe support businesses with website development and optimization.\r\n\r\nPlease let me know if you\'d like to see our SEO plans and price list.\r\n\r\nBest regards,\r','Hi,\r\n\r\nQuick question regarding your website — are you planning any updates or SEO improvements?\r\n\r\nWe support businesses with website development and optimization.\r\n\r\nPlease let me know if you\'d like to see our SEO plans and price list.\r\n\r\nBest regards,\r','efea640733e29ac8c6d0625fdf6f03cf'),(47,'Jalvi ..!!','','Salzburgerstrasse 65','','Jalvi ..!!','','','','Hello,\r\n\r\nI hope everything is going great on your end.\r\n\r\nOur company has a team of full-time SEO experts focused on delivering keyword-driven results.\r\n\r\nPlease let me know if you\'d like to see our SEO plans and price list.\r\n\r\nWarm regards,\r\n\r\nJalvi','Hello,\r\n\r\nI hope everything is going great on your end.\r\n\r\nOur company has a team of full-time SEO experts focused on delivering keyword-driven results.\r\n\r\nPlease let me know if you\'d like to see our SEO plans and price list.\r\n\r\nWarm regards,\r\n\r\nJalvi','f4a0645f371826fa6d6a53b9b11db517'),(48,'Madhuri Rai','','26 Main Road','','Madhuri Rai','7801632428','7801632428','7801632428','Hello,\r\n\r\nI came across your website and wanted to ask if you\'re currently looking for SEO support.\r\n\r\nWe provide keyword research, on-page SEO, technical optimization, and ongoing SEO services.\r\n\r\nIf this sounds relevant, let me know and I\'ll send over o','Hello,\r\n\r\nI came across your website and wanted to ask if you\'re currently looking for SEO support.\r\n\r\nWe provide keyword research, on-page SEO, technical optimization, and ongoing SEO services.\r\n\r\nIf this sounds relevant, let me know and I\'ll send over o','6a4ad637bbb08fe078d645f15f3cb5d2');
/*!40000 ALTER TABLE `register` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping events for database 'desid573_oldvine'
--
--
-- Dumping routines for database 'desid573_oldvine'
--
/*!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:05