-- MySQL dump 10.13 Distrib 5.7.42, for Linux (x86_64) -- -- Host: localhost Database: shopifytest -- ------------------------------------------------------ -- Server version 5.7.42-0ubuntu0.18.04.1 /*!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 `charges` -- DROP TABLE IF EXISTS `charges`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `charges` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `charge_id` bigint(20) NOT NULL, `test` tinyint(1) NOT NULL DEFAULT '0', `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `terms` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `price` decimal(8,2) NOT NULL, `interval` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `capped_amount` decimal(8,2) DEFAULT NULL, `trial_days` int(11) DEFAULT NULL, `billing_on` timestamp NULL DEFAULT NULL, `activated_on` timestamp NULL DEFAULT NULL, `trial_ends_on` timestamp NULL DEFAULT NULL, `cancelled_on` timestamp NULL DEFAULT NULL, `expires_on` timestamp NULL DEFAULT NULL, `plan_id` int(10) unsigned DEFAULT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reference_charge` bigint(20) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `user_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `charges_user_id_foreign` (`user_id`), KEY `charges_plan_id_foreign` (`plan_id`), CONSTRAINT `charges_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`), CONSTRAINT `charges_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `charges` -- LOCK TABLES `charges` WRITE; /*!40000 ALTER TABLE `charges` DISABLE KEYS */; INSERT INTO `charges` VALUES (1,2965209318,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-06-12 19:00:00',NULL,'2023-06-12 19:00:00','2023-06-12 19:00:00',1,NULL,NULL,'2023-06-13 06:01:44','2023-06-13 06:38:41',NULL,4),(2,2965307622,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-06-12 19:00:00',NULL,'2023-06-12 19:00:00','2023-06-12 19:00:00',1,NULL,NULL,'2023-06-13 06:38:41','2023-06-13 07:01:13',NULL,4),(3,2965340390,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-06-12 19:00:00',NULL,'2023-06-13 19:00:00','2023-06-13 19:00:00',1,NULL,NULL,'2023-06-13 07:01:13','2023-06-14 02:45:32',NULL,4),(4,2965700838,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-06-13 19:00:00',NULL,'2023-11-27 19:00:00','2023-11-27 19:00:00',1,NULL,NULL,'2023-06-14 02:45:32','2023-11-28 08:03:24',NULL,4),(5,3057189186,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-06-14 19:00:00',NULL,'2023-06-14 19:00:00','2023-06-14 19:00:00',1,NULL,NULL,'2023-06-15 05:43:03','2023-06-15 06:48:03',NULL,2),(6,3057254722,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-06-14 19:00:00',NULL,'2023-06-14 19:00:00','2023-06-14 19:00:00',1,NULL,NULL,'2023-06-15 06:48:03','2023-06-15 07:01:20',NULL,2),(7,3057287490,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-06-14 19:00:00',NULL,'2023-06-14 19:00:00','2023-06-14 19:00:00',1,NULL,NULL,'2023-06-15 07:01:20','2023-06-15 07:26:26',NULL,2),(8,3057320258,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-06-14 19:00:00',NULL,'2023-08-30 19:00:00','2023-08-30 19:00:00',1,NULL,NULL,'2023-06-15 07:26:26','2023-08-31 06:41:22',NULL,2),(9,2292056116,0,'ACTIVE','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-06-19 19:00:00',NULL,NULL,NULL,1,NULL,NULL,'2023-06-20 13:47:04','2023-06-20 13:47:04',NULL,7),(10,2945155321,0,'ACTIVE','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-07-18 19:00:00',NULL,NULL,NULL,1,NULL,NULL,'2023-07-19 10:16:37','2023-07-19 10:16:37',NULL,9),(11,3113255234,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-08-30 19:00:00',NULL,'2023-09-13 19:00:00','2023-09-13 19:00:00',1,NULL,NULL,'2023-08-31 06:41:22','2023-09-14 02:12:52',NULL,2),(12,3123151170,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-09-13 19:00:00',NULL,'2023-09-13 19:00:00','2023-09-13 19:00:00',1,NULL,NULL,'2023-09-14 02:12:52','2023-09-14 02:26:51',NULL,2),(13,3123183938,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-09-13 19:00:00',NULL,'2023-09-13 19:00:00','2023-09-13 19:00:00',1,NULL,NULL,'2023-09-14 02:26:51','2023-09-14 02:52:49',NULL,2),(14,3123216706,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-09-13 19:00:00',NULL,'2023-10-23 19:00:00','2023-10-23 19:00:00',1,NULL,NULL,'2023-09-14 02:52:49','2023-10-24 02:19:09',NULL,2),(15,3159130434,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-10-23 19:00:00',NULL,'2023-11-27 19:00:00','2023-11-27 19:00:00',1,NULL,NULL,'2023-10-24 02:19:09','2023-11-28 05:31:36',NULL,2),(16,3134652699,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-11-23 19:00:00',NULL,'2023-12-27 19:00:00','2023-12-27 19:00:00',1,NULL,NULL,'2023-11-24 08:37:37','2023-12-28 06:42:17','2023-12-28 06:42:17',16),(17,3178627394,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-11-27 19:00:00',NULL,'2023-11-27 19:00:00','2023-11-27 19:00:00',1,NULL,NULL,'2023-11-28 05:31:36','2023-11-28 05:38:52',NULL,2),(18,3178660162,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-11-27 19:00:00',NULL,'2023-11-27 19:00:00','2023-11-27 19:00:00',1,NULL,NULL,'2023-11-28 05:38:52','2023-11-28 05:51:23',NULL,2),(19,3178725698,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-11-27 19:00:00',NULL,'2023-11-27 19:00:00','2023-11-27 19:00:00',1,NULL,NULL,'2023-11-28 05:51:23','2023-11-28 05:56:08',NULL,2),(20,3178758466,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-11-27 19:00:00',NULL,'2023-11-27 19:00:00','2023-11-27 19:00:00',1,NULL,NULL,'2023-11-28 05:56:08','2023-11-28 06:35:54',NULL,2),(21,3178824002,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-11-27 19:00:00',NULL,'2023-11-27 19:00:00','2023-11-27 19:00:00',1,NULL,NULL,'2023-11-28 06:35:54','2023-11-28 06:57:41',NULL,2),(22,3178856770,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-11-27 19:00:00',NULL,'2023-11-27 19:00:00','2023-11-27 19:00:00',1,NULL,NULL,'2023-11-28 06:57:41','2023-11-28 07:09:09',NULL,2),(23,3178922306,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-11-27 19:00:00',NULL,'2023-11-27 19:00:00','2023-11-27 19:00:00',1,NULL,NULL,'2023-11-28 07:09:09','2023-11-28 07:41:22',NULL,2),(24,3178955074,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-11-27 19:00:00',NULL,'2023-11-27 19:00:00','2023-11-27 19:00:00',1,NULL,NULL,'2023-11-28 07:41:22','2023-11-28 08:05:59',NULL,2),(25,2993488102,1,'ACTIVE','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-11-27 19:00:00',NULL,NULL,NULL,1,NULL,NULL,'2023-11-28 08:03:24','2023-11-28 08:03:24',NULL,4),(26,3178987842,1,'ACTIVE','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-11-27 19:00:00',NULL,NULL,NULL,1,NULL,NULL,'2023-11-28 08:05:59','2023-11-28 08:05:59',NULL,2),(27,3152871707,1,'CANCELLED','SubscriptionFlow App Plan',NULL,'CHARGE',30.00,'EVERY_30_DAYS',NULL,0,NULL,'2023-12-27 19:00:00',NULL,'2023-12-27 19:00:00','2023-12-27 19:00:00',1,NULL,NULL,'2023-12-28 06:53:06','2023-12-28 06:53:53','2023-12-28 06:53:53',16); /*!40000 ALTER TABLE `charges` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` 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(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2020_01_29_010501_create_plans_table',1),(6,'2020_01_29_230905_create_shops_table',1),(7,'2020_01_29_231006_create_charges_table',1),(8,'2020_07_03_211514_add_interval_column_to_charges_table',1),(9,'2020_07_03_211854_add_interval_column_to_plans_table',1),(10,'2021_04_21_103633_add_password_updated_at_to_users_table',1),(11,'2023_11_09_124357_add_column_to_users',2); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `personal_access_tokens` -- DROP TABLE IF EXISTS `personal_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `personal_access_tokens` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `personal_access_tokens_token_unique` (`token`), KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personal_access_tokens` -- LOCK TABLES `personal_access_tokens` WRITE; /*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `plans` -- DROP TABLE IF EXISTS `plans`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `plans` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `price` decimal(8,2) NOT NULL, `interval` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `capped_amount` decimal(8,2) DEFAULT NULL, `terms` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `trial_days` int(11) DEFAULT NULL, `test` tinyint(1) NOT NULL DEFAULT '0', `on_install` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `plans` -- LOCK TABLES `plans` WRITE; /*!40000 ALTER TABLE `plans` DISABLE KEYS */; INSERT INTO `plans` VALUES (1,'ONETIME','SubscriptionFlow App Plan',30.00,NULL,0.00,'Basic Plan 30.00 $',0,0,1,'2023-06-13 02:25:53','2023-12-28 07:50:49'); /*!40000 ALTER TABLE `plans` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `shopify_grandfathered` tinyint(1) NOT NULL DEFAULT '0', `shopify_namespace` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `shopify_freemium` tinyint(1) NOT NULL DEFAULT '0', `plan_id` int(10) unsigned DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `password_updated_at` date DEFAULT NULL, `sf_domain` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_domain_active` tinyint(1) NOT NULL, `is_product_sync` tinyint(1) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`), KEY `users_plan_id_foreign` (`plan_id`), CONSTRAINT `users_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'adon-demo.myshopify.com','shop@adon-demo.myshopify.com',NULL,'shpua_e72029f8b9702ea94dd1cc00b0c323c0',NULL,'2023-01-24 05:49:05','2023-06-13 02:51:35',0,NULL,0,NULL,'2023-06-13 02:51:35','2023-01-24',NULL,0,0),(2,'sfapptest.myshopify.com','shop@sfapptest.myshopify.com',NULL,'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',NULL,'2023-01-24 05:51:51','2024-01-09 05:58:16',0,NULL,0,1,NULL,'2023-11-29','https://shopifydemo.subscriptionflow.com/',1,1),(3,'sfdemointegration.myshopify.com','shop@sfdemointegration.myshopify.com',NULL,'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',NULL,'2023-02-03 06:54:17','2023-06-13 02:51:35',0,NULL,0,NULL,'2023-06-13 02:51:35','2023-02-03',NULL,0,0),(4,'internal-development-store.myshopify.com','shop@internal-development-store.myshopify.com',NULL,'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',NULL,'2023-02-03 07:22:35','2023-11-29 05:51:10',0,NULL,0,1,'2023-11-29 05:51:10','2023-11-28','https://suleman.subscriptionflow.com/',1,1),(5,'appstoretest8.myshopify.com','shop@appstoretest8.myshopify.com',NULL,'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',NULL,'2023-02-15 06:25:51','2023-10-24 07:59:31',0,NULL,0,NULL,'2023-10-24 07:59:31','2023-09-18',NULL,0,0),(6,'app-security.myshopify.com','shop@app-security.myshopify.com',NULL,'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',NULL,'2023-02-15 06:30:09','2023-08-23 02:15:27',0,NULL,0,NULL,'2023-08-23 02:15:27','2023-06-19',NULL,0,0),(7,'fashionbeau06.myshopify.com','shop@fashionbeau06.myshopify.com',NULL,'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',NULL,'2023-03-07 14:29:42','2023-08-23 02:15:27',0,NULL,0,1,'2023-08-23 02:15:27','2023-06-20',NULL,0,0),(8,'appstoretest5.myshopify.com','shop@appstoretest5.myshopify.com',NULL,'',NULL,'2023-03-30 03:55:37','2023-06-13 02:51:35',0,NULL,0,NULL,'2023-06-13 02:51:35',NULL,NULL,0,0),(9,'fashionbeauty19.myshopify.com','shop@fashionbeauty19.myshopify.com',NULL,'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',NULL,'2023-04-05 16:44:22','2023-08-23 02:15:27',0,NULL,0,1,'2023-08-23 02:15:27','2023-07-19',NULL,0,0),(10,'testing-and-research.myshopify.com','shop@testing-and-research.myshopify.com',NULL,'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',NULL,'2023-05-30 05:54:19','2023-06-15 02:18:10',0,NULL,0,NULL,'2023-06-15 02:18:10','2023-06-14',NULL,0,0),(11,'markmarktest.myshopify.com','shop@markmarktest.myshopify.com',NULL,'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',NULL,'2023-06-02 10:24:17','2023-06-13 02:51:35',0,NULL,0,NULL,'2023-06-13 02:51:35','2023-06-02',NULL,0,0),(12,'joycetest20.myshopify.com','shop@joycetest20.myshopify.com',NULL,'',NULL,'2023-06-20 13:53:04','2023-08-23 02:15:27',0,NULL,0,NULL,'2023-08-23 02:15:27',NULL,NULL,0,0),(13,'quickstart-64a14627.myshopify.com','shop@quickstart-64a14627.myshopify.com',NULL,'',NULL,'2023-08-23 07:42:51','2023-08-24 09:11:22',0,NULL,0,NULL,'2023-08-24 09:11:22',NULL,NULL,0,0),(14,'subscriptionflow-integration.myshopify.com','shop@subscriptionflow-integration.myshopify.com',NULL,'',NULL,'2023-08-23 08:03:55','2023-08-24 09:11:22',0,NULL,0,NULL,'2023-08-24 09:11:22',NULL,NULL,0,0),(15,'new-developer-store.myshopify.com','shop@new-developer-store.myshopify.com',NULL,'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',NULL,'2023-08-24 09:20:42','2023-08-28 02:06:35',0,NULL,0,NULL,'2023-08-28 02:06:35','2023-08-24',NULL,0,0),(16,'subscriptionflow-shop.myshopify.com','shop@subscriptionflow-shop.myshopify.com',NULL,'',NULL,'2023-08-31 06:08:24','2023-12-28 06:53:53',0,NULL,0,NULL,'2023-12-28 06:53:53','2023-12-28','https://suleman.subscriptionflow.com/',1,1),(17,'app-security-02.myshopify.com','shop@app-security-02.myshopify.com',NULL,'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',NULL,'2023-09-18 02:05:10','2023-11-29 06:10:22',0,NULL,0,NULL,NULL,'2023-11-29',NULL,0,0); /*!40000 ALTER TABLE `users` 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 2024-01-12 12:31:39