--
-- Host: localhost    Database: monica
-- ------------------------------------------------------


--
-- Table structure for table `activities`
--

CREATE TABLE `activities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `activity_type_id` int(10) unsigned DEFAULT NULL,
  `summary` varchar(255) NOT NULL,
  `description` longtext DEFAULT NULL,
  `happened_at` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activities_activity_type_id_foreign` (`activity_type_id`),
  KEY `activities_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `activities_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `activities_activity_type_id_foreign` FOREIGN KEY (`activity_type_id`) REFERENCES `activity_types` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activities`
--


--
-- Table structure for table `activity_contact`
--

CREATE TABLE `activity_contact` (
  `activity_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `account_id` int(10) unsigned NOT NULL,
  KEY `activity_contact_activity_id_foreign` (`activity_id`),
  KEY `activity_contact_contact_id_foreign` (`contact_id`),
  KEY `activity_contact_account_id_foreign` (`account_id`),
  CONSTRAINT `activity_contact_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `activity_contact_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `activities` (`id`) ON DELETE CASCADE,
  CONSTRAINT `activity_contact_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_contact`
--


--
-- Table structure for table `activity_statistics`
--

CREATE TABLE `activity_statistics` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `year` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_statistics_account_id_foreign` (`account_id`),
  KEY `activity_statistics_contact_id_foreign` (`contact_id`),
  CONSTRAINT `activity_statistics_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `activity_statistics_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_statistics`
--


--
-- Table structure for table `activity_type_categories`
--

CREATE TABLE `activity_type_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `translation_key` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_type_categories_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `activity_type_categories_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_type_categories`
--

INSERT INTO `activity_type_categories` VALUES (1,NULL,1,NULL,'simple_activities',NULL,NULL),(2,NULL,1,NULL,'sport',NULL,NULL),(3,NULL,1,NULL,'food',NULL,NULL),(4,NULL,1,NULL,'cultural_activities',NULL,NULL),(5,NULL,2,NULL,'simple_activities',NULL,NULL),(6,NULL,2,NULL,'sport',NULL,NULL),(7,NULL,2,NULL,'food',NULL,NULL),(8,NULL,2,NULL,'cultural_activities',NULL,NULL),(9,NULL,3,NULL,'simple_activities',NULL,NULL),(10,NULL,3,NULL,'sport',NULL,NULL),(11,NULL,3,NULL,'food',NULL,NULL),(12,NULL,3,NULL,'cultural_activities',NULL,NULL);

--
-- Table structure for table `activity_types`
--

CREATE TABLE `activity_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `activity_type_category_id` int(10) unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `translation_key` varchar(255) DEFAULT NULL,
  `location_type` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_types_activity_type_category_id_foreign` (`activity_type_category_id`),
  KEY `activity_types_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `activity_types_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `activity_types_activity_type_category_id_foreign` FOREIGN KEY (`activity_type_category_id`) REFERENCES `activity_type_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_types`
--

INSERT INTO `activity_types` VALUES (1,NULL,1,1,NULL,'just_hung_out',NULL,NULL,NULL),(2,NULL,1,1,NULL,'watched_movie_at_home',NULL,NULL,NULL),(3,NULL,1,1,NULL,'talked_at_home',NULL,NULL,NULL),(4,NULL,1,2,NULL,'did_sport_activities_together',NULL,NULL,NULL),(5,NULL,1,3,NULL,'ate_at_his_place',NULL,NULL,NULL),(6,NULL,1,3,NULL,'went_bar',NULL,NULL,NULL),(7,NULL,1,3,NULL,'ate_at_home',NULL,NULL,NULL),(8,NULL,1,3,NULL,'picnicked',NULL,NULL,NULL),(9,NULL,1,3,NULL,'ate_restaurant',NULL,NULL,NULL),(10,NULL,1,4,NULL,'went_theater',NULL,NULL,NULL),(11,NULL,1,4,NULL,'went_concert',NULL,NULL,NULL),(12,NULL,1,4,NULL,'went_play',NULL,NULL,NULL),(13,NULL,1,4,NULL,'went_museum',NULL,NULL,NULL),(14,NULL,2,5,NULL,'just_hung_out',NULL,NULL,NULL),(15,NULL,2,5,NULL,'watched_movie_at_home',NULL,NULL,NULL),(16,NULL,2,5,NULL,'talked_at_home',NULL,NULL,NULL),(17,NULL,2,6,NULL,'did_sport_activities_together',NULL,NULL,NULL),(18,NULL,2,7,NULL,'ate_at_his_place',NULL,NULL,NULL),(19,NULL,2,7,NULL,'went_bar',NULL,NULL,NULL),(20,NULL,2,7,NULL,'ate_at_home',NULL,NULL,NULL),(21,NULL,2,7,NULL,'picnicked',NULL,NULL,NULL),(22,NULL,2,7,NULL,'ate_restaurant',NULL,NULL,NULL),(23,NULL,2,8,NULL,'went_theater',NULL,NULL,NULL),(24,NULL,2,8,NULL,'went_concert',NULL,NULL,NULL),(25,NULL,2,8,NULL,'went_play',NULL,NULL,NULL),(26,NULL,2,8,NULL,'went_museum',NULL,NULL,NULL),(27,NULL,3,9,NULL,'just_hung_out',NULL,NULL,NULL),(28,NULL,3,9,NULL,'watched_movie_at_home',NULL,NULL,NULL),(29,NULL,3,9,NULL,'talked_at_home',NULL,NULL,NULL),(30,NULL,3,10,NULL,'did_sport_activities_together',NULL,NULL,NULL),(31,NULL,3,11,NULL,'ate_at_his_place',NULL,NULL,NULL),(32,NULL,3,11,NULL,'went_bar',NULL,NULL,NULL),(33,NULL,3,11,NULL,'ate_at_home',NULL,NULL,NULL),(34,NULL,3,11,NULL,'picnicked',NULL,NULL,NULL),(35,NULL,3,11,NULL,'ate_restaurant',NULL,NULL,NULL),(36,NULL,3,12,NULL,'went_theater',NULL,NULL,NULL),(37,NULL,3,12,NULL,'went_concert',NULL,NULL,NULL),(38,NULL,3,12,NULL,'went_play',NULL,NULL,NULL),(39,NULL,3,12,NULL,'went_museum',NULL,NULL,NULL);

--
-- Table structure for table `address_contact_field_label`
--

CREATE TABLE `address_contact_field_label` (
  `contact_field_label_id` bigint(20) unsigned NOT NULL,
  `address_id` int(10) unsigned NOT NULL,
  `account_id` int(10) unsigned NOT NULL,
  KEY `address_contact_field_label_index` (`contact_field_label_id`,`address_id`,`account_id`),
  KEY `address_contact_field_label_address_id_foreign` (`address_id`),
  KEY `address_contact_field_label_account_id_foreign` (`account_id`),
  CONSTRAINT `address_contact_field_label_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `address_contact_field_label_address_id_foreign` FOREIGN KEY (`address_id`) REFERENCES `addresses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `address_contact_field_label_contact_field_label_id_foreign` FOREIGN KEY (`contact_field_label_id`) REFERENCES `contact_field_labels` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `address_contact_field_label`
--


--
-- Table structure for table `addressbooks`
--

CREATE TABLE `addressbooks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `description` varchar(500) DEFAULT NULL,
  `name` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `addressbooks_name_index` (`name`),
  KEY `addressbooks_user_id_foreign` (`user_id`),
  KEY `addressbooks_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `addressbooks_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `addressbooks_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `addressbooks`
--


--
-- Table structure for table `addresses`
--

CREATE TABLE `addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `place_id` int(10) unsigned DEFAULT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `addresses_contact_id_foreign` (`contact_id`),
  KEY `addresses_place_id_foreign` (`place_id`),
  KEY `addresses_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `addresses_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `addresses_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `addresses_place_id_foreign` FOREIGN KEY (`place_id`) REFERENCES `places` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `addresses`
--


--
-- Table structure for table `api_usage`
--

CREATE TABLE `api_usage` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(255) NOT NULL,
  `method` varchar(255) NOT NULL,
  `client_ip` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `api_usage`
--

INSERT INTO `api_usage` VALUES (1,'https://mandraw.noho.st/monica/api/contacts/1/activities?page=1','GET','85.190.89.158','2024-01-03 00:53:42','2024-01-03 00:53:42'),(2,'https://mandraw.noho.st/monica/api/contacts/1/activities?page=1','GET','85.190.89.158','2024-01-03 00:55:04','2024-01-03 00:55:04'),(3,'https://mandraw.noho.st/monica/api/contacts/1/activities?page=1','GET','85.190.89.158','2024-01-03 00:55:43','2024-01-03 00:55:43'),(4,'https://mandraw.noho.st/monica/api/contacts/1/activities?page=1','GET','85.190.89.158','2024-01-03 01:02:49','2024-01-03 01:02:49'),(5,'https://mandraw.noho.st/monica/api/contacts/2/activities?page=1','GET','85.190.89.158','2024-01-03 01:03:54','2024-01-03 01:03:54'),(6,'https://mandraw.noho.st/monica/api/contacts/2/activities?page=1','GET','85.190.89.158','2024-01-03 01:04:04','2024-01-03 01:04:04'),(7,'https://mandraw.noho.st/monica/api/contacts/5/activities?page=1','GET','85.190.89.158','2024-01-03 01:19:01','2024-01-03 01:19:01'),(8,'https://mandraw.noho.st/monica/api/contacts/6/activities?page=1','GET','85.190.89.158','2024-01-03 01:19:29','2024-01-03 01:19:29'),(9,'https://mandraw.noho.st/monica/api/contacts/7/activities?page=1','GET','85.190.89.158','2024-01-03 01:21:08','2024-01-03 01:21:08'),(10,'https://mandraw.noho.st/monica/api/contacts/7/activities?page=1','GET','85.190.89.158','2024-01-03 01:23:24','2024-01-03 01:23:24'),(11,'https://mandraw.noho.st/monica/api/contacts/6/activities?page=1','GET','85.190.89.158','2024-01-03 01:24:02','2024-01-03 01:24:02'),(12,'https://mandraw.noho.st/monica/api/contacts/6/activities?page=1','GET','85.190.89.158','2024-01-03 01:24:56','2024-01-03 01:24:56'),(13,'https://mandraw.noho.st/monica/api/contacts/8/activities?page=1','GET','85.190.89.158','2024-01-03 01:25:46','2024-01-03 01:25:46'),(14,'https://mandraw.noho.st/monica/api/contacts/8/activities?page=1','GET','85.190.89.158','2024-01-03 01:26:09','2024-01-03 01:26:09'),(15,'https://mandraw.noho.st/monica/api/contacts/2/activities?page=1','GET','85.190.89.158','2024-01-03 01:26:55','2024-01-03 01:26:55'),(16,'https://mandraw.noho.st/monica/api/contacts/1/activities?page=1','GET','85.190.89.158','2024-01-03 01:26:59','2024-01-03 01:26:59'),(17,'https://mandraw.noho.st/monica/api/contacts/5/activities?page=1','GET','85.190.89.158','2024-01-03 01:27:52','2024-01-03 01:27:52'),(18,'https://mandraw.noho.st/monica/api/contacts/5/activities?page=1','GET','85.190.89.158','2024-01-03 01:28:19','2024-01-03 01:28:19'),(19,'https://mandraw.noho.st/monica/api/contacts/9/activities?page=1','GET','85.190.89.158','2024-01-03 01:29:58','2024-01-03 01:29:58'),(20,'https://mandraw.noho.st/monica/api/contacts/9/activities?page=1','GET','85.190.89.158','2024-01-03 01:31:22','2024-01-03 01:31:22'),(21,'https://mandraw.noho.st/monica/api/contacts/10/activities?page=1','GET','85.190.89.158','2024-01-03 01:34:28','2024-01-03 01:34:28'),(22,'https://mandraw.noho.st/monica/api/contacts/10/activities?page=1','GET','85.190.89.158','2024-01-03 01:34:46','2024-01-03 01:34:46'),(23,'https://mandraw.noho.st/monica/api/contacts/10/activities?page=1','GET','85.190.89.158','2024-01-03 01:36:13','2024-01-03 01:36:13'),(24,'https://mandraw.noho.st/monica/api/contacts/11/activities?page=1','GET','85.190.90.2','2024-01-05 05:36:00','2024-01-05 05:36:00'),(25,'https://mandraw.noho.st/monica/api/contacts/11/activities?page=1','GET','85.190.90.2','2024-01-05 05:39:51','2024-01-05 05:39:51'),(26,'https://mandraw.noho.st/monica/api/contacts/11/activities?page=1','GET','85.190.90.2','2024-01-05 05:56:23','2024-01-05 05:56:23'),(27,'https://mandraw.noho.st/monica/api/contacts/11/activities?page=1','GET','85.190.90.2','2024-01-05 05:56:40','2024-01-05 05:56:40'),(28,'https://mandraw.noho.st/monica/api/contacts/12/activities?page=1','GET','85.190.90.2','2024-01-05 05:57:04','2024-01-05 05:57:04'),(29,'https://mandraw.noho.st/monica/api/contacts/12/activities?page=1','GET','85.190.90.2','2024-01-05 05:57:44','2024-01-05 05:57:44'),(30,'https://mandraw.noho.st/monica/api/contacts/8/activities?page=1','GET','85.190.90.2','2024-01-05 06:00:14','2024-01-05 06:00:14'),(31,'https://mandraw.noho.st/monica/api/contacts/9/activities?page=1','GET','85.190.90.2','2024-01-05 06:00:17','2024-01-05 06:00:17'),(32,'https://mandraw.noho.st/monica/api/contacts/1/activities?page=1','GET','85.190.90.2','2024-01-05 06:00:21','2024-01-05 06:00:21'),(33,'https://mandraw.noho.st/monica/api/contacts/7/activities?page=1','GET','85.190.90.2','2024-01-05 06:00:26','2024-01-05 06:00:26'),(34,'https://mandraw.noho.st/monica/api/contacts/13/activities?page=1','GET','85.190.90.2','2024-01-05 06:11:56','2024-01-05 06:11:56'),(35,'https://mandraw.noho.st/monica/api/contacts/13/activities?page=1','GET','85.190.90.2','2024-01-05 06:59:56','2024-01-05 06:59:56'),(36,'https://mandraw.noho.st/monica/api/contacts/14/activities?page=1','GET','185.161.170.69','2024-01-07 01:53:42','2024-01-07 01:53:42'),(37,'https://mandraw.noho.st/monica/api/contacts/14/activities?page=1','GET','185.161.170.69','2024-01-07 01:55:20','2024-01-07 01:55:20'),(38,'https://mandraw.noho.st/monica/api/contacts/14/activities?page=1','GET','185.161.170.69','2024-01-07 01:55:37','2024-01-07 01:55:37'),(39,'https://mandraw.noho.st/monica/api/contacts/14/activities?page=1','GET','185.161.170.69','2024-01-07 01:55:47','2024-01-07 01:55:47'),(40,'https://mandraw.noho.st/monica/api/contacts/15/activities?page=1','GET','185.161.170.69','2024-01-07 01:58:09','2024-01-07 01:58:09'),(41,'https://mandraw.noho.st/monica/api/contacts/15/activities?page=1','GET','185.161.170.69','2024-01-07 01:58:48','2024-01-07 01:58:48'),(42,'https://mandraw.noho.st/monica/api/contacts/16/activities?page=1','GET','185.161.170.69','2024-01-07 02:00:33','2024-01-07 02:00:33'),(43,'https://mandraw.noho.st/monica/api/contacts/16/activities?page=1','GET','185.161.170.69','2024-01-07 02:01:54','2024-01-07 02:01:54'),(44,'https://mandraw.noho.st/monica/api/contacts/15/activities?page=1','GET','185.161.170.69','2024-01-07 02:04:14','2024-01-07 02:04:14'),(45,'https://mandraw.noho.st/monica/api/contacts/16/activities?page=1','GET','185.161.170.69','2024-01-07 02:07:08','2024-01-07 02:07:08'),(46,'https://mandraw.noho.st/monica/api/contacts/15/activities?page=1','GET','185.161.170.69','2024-01-07 02:08:30','2024-01-07 02:08:30'),(47,'https://mandraw.noho.st/monica/api/contacts/17/activities?page=1','GET','185.161.170.69','2024-01-07 02:13:29','2024-01-07 02:13:29'),(48,'https://mandraw.noho.st/monica/api/contacts/17/activities?page=1','GET','185.161.170.69','2024-01-07 02:28:51','2024-01-07 02:28:51'),(49,'https://mandraw.noho.st/monica/api/contacts/17/activities?page=1','GET','185.161.170.69','2024-01-07 02:29:25','2024-01-07 02:29:25'),(50,'https://mandraw.noho.st/monica/api/contacts/7/activities?page=1','GET','185.161.170.69','2024-01-09 12:29:49','2024-01-09 12:29:49'),(51,'https://mandraw.noho.st/monica/api/contacts/3/activities?page=1','GET','185.161.170.69','2024-01-09 16:02:45','2024-01-09 16:02:45'),(52,'https://mandraw.noho.st/monica/api/contacts/3/activities?page=1','GET','185.161.170.69','2024-01-09 16:03:00','2024-01-09 16:03:00'),(53,'https://mandraw.noho.st/monica/api/contacts/3/activities?page=1','GET','185.161.170.69','2024-01-09 16:03:09','2024-01-09 16:03:09'),(54,'https://mandraw.noho.st/monica/api/contacts/2/activities?page=1','GET','185.161.170.69','2024-01-09 16:03:41','2024-01-09 16:03:41'),(55,'https://mandraw.noho.st/monica/api/contacts/2/activities?page=1','GET','185.161.170.69','2024-01-09 16:04:05','2024-01-09 16:04:05'),(56,'https://mandraw.noho.st/monica/api/contacts/2/activities?page=1','GET','185.161.170.69','2024-01-09 16:04:11','2024-01-09 16:04:11'),(57,'https://mandraw.noho.st/monica/api/contacts/7/activities?page=1','GET','185.161.170.69','2024-01-09 16:44:44','2024-01-09 16:44:44'),(58,'https://mandraw.noho.st/monica/api/contacts/7/activities?page=1','GET','185.161.170.69','2024-01-09 16:45:30','2024-01-09 16:45:30'),(59,'https://mandraw.noho.st/monica/api/contacts/18/activities?page=1','GET','85.190.89.148','2024-01-10 09:59:15','2024-01-10 09:59:15'),(60,'https://mandraw.noho.st/monica/api/contacts/18/activities?page=1','GET','85.190.89.148','2024-01-10 09:59:36','2024-01-10 09:59:36'),(61,'https://mandraw.noho.st/monica/api/contacts/18/activities?page=1','GET','85.190.89.148','2024-01-10 10:02:51','2024-01-10 10:02:51'),(62,'https://mandraw.noho.st/monica/api/contacts/9/activities?page=1','GET','85.190.89.148','2024-01-10 10:03:44','2024-01-10 10:03:44'),(63,'https://mandraw.noho.st/monica/api/contacts/3/activities?page=1','GET','85.190.89.148','2024-01-10 10:04:01','2024-01-10 10:04:01'),(64,'https://mandraw.noho.st/monica/api/contacts/3/activities?page=1','GET','85.190.89.148','2024-01-10 10:04:53','2024-01-10 10:04:53'),(65,'https://mandraw.noho.st/monica/api/contacts/4/activities?page=1','GET','85.190.89.148','2024-01-10 10:05:08','2024-01-10 10:05:08'),(66,'https://mandraw.noho.st/monica/api/contacts/4/activities?page=1','GET','85.190.89.148','2024-01-10 10:05:48','2024-01-10 10:05:48'),(67,'https://mandraw.noho.st/monica/api/contacts/19/activities?page=1','GET','85.190.89.148','2024-01-10 10:08:16','2024-01-10 10:08:16'),(68,'https://mandraw.noho.st/monica/api/contacts/19/activities?page=1','GET','85.190.89.148','2024-01-10 10:08:51','2024-01-10 10:08:51'),(69,'https://mandraw.noho.st/monica/api/contacts/20/activities?page=1','GET','85.190.89.148','2024-01-10 10:23:53','2024-01-10 10:23:53'),(70,'https://mandraw.noho.st/monica/api/contacts/20/activities?page=1','GET','85.190.89.148','2024-01-10 10:25:33','2024-01-10 10:25:33'),(71,'https://mandraw.noho.st/monica/api/contacts/21/activities?page=1','GET','85.190.89.148','2024-01-10 17:31:43','2024-01-10 17:31:43'),(72,'https://mandraw.noho.st/monica/api/contacts/6/activities?page=1','GET','85.190.90.7','2024-01-11 06:02:43','2024-01-11 06:02:43'),(73,'https://mandraw.noho.st/monica/api/contacts/6/activities?page=1','GET','85.190.90.7','2024-01-11 06:02:56','2024-01-11 06:02:56'),(74,'https://mandraw.noho.st/monica/api/contacts/17/activities?page=1','GET','85.190.90.7','2024-01-11 07:30:12','2024-01-11 07:30:12'),(75,'https://mandraw.noho.st/monica/api/contacts/21/activities?page=1','GET','85.190.89.169','2024-01-16 12:24:42','2024-01-16 12:24:42'),(76,'https://mandraw.noho.st/monica/api/contacts/21/activities?page=1','GET','85.190.89.169','2024-01-16 12:24:52','2024-01-16 12:24:52'),(77,'https://mandraw.noho.st/monica/api/contacts/21/activities?page=1','GET','85.190.89.169','2024-01-16 12:25:02','2024-01-16 12:25:02'),(78,'https://mandraw.noho.st/monica/api/contacts/21/activities?page=1','GET','85.190.89.169','2024-01-16 12:25:07','2024-01-16 12:25:07'),(79,'https://mandraw.noho.st/monica/api/contacts/21/activities?page=1','GET','85.190.89.169','2024-01-16 12:25:13','2024-01-16 12:25:13'),(80,'https://mandraw.noho.st/monica/api/contacts/21/activities?page=1','GET','85.190.89.169','2024-01-16 12:26:02','2024-01-16 12:26:02'),(81,'https://mandraw.noho.st/monica/api/contacts/6/activities?page=1','GET','185.161.170.38','2024-01-17 07:04:27','2024-01-17 07:04:27'),(82,'https://mandraw.noho.st/monica/api/contacts/22/activities?page=1','GET','185.161.169.16','2024-01-20 15:31:35','2024-01-20 15:31:35'),(83,'https://mandraw.noho.st/monica/api/contacts/22/activities?page=1','GET','185.161.169.16','2024-01-20 16:01:26','2024-01-20 16:01:26'),(84,'https://mandraw.noho.st/monica/api/contacts/22/activities?page=1','GET','185.161.169.16','2024-01-20 16:26:25','2024-01-20 16:26:25'),(85,'https://mandraw.noho.st/monica/api/contacts/17/activities?page=1','GET','185.161.170.68','2024-01-25 04:22:07','2024-01-25 04:22:07'),(86,'https://mandraw.noho.st/monica/api/contacts/17/activities?page=1','GET','185.161.170.68','2024-01-25 04:22:54','2024-01-25 04:22:54'),(87,'https://mandraw.noho.st/monica/api/contacts/17/activities?page=1','GET','185.161.170.68','2024-01-25 04:23:09','2024-01-25 04:23:09'),(88,'https://mandraw.noho.st/monica/api/contacts/17/activities?page=1','GET','185.161.170.68','2024-01-25 04:23:12','2024-01-25 04:23:12'),(89,'https://mandraw.noho.st/monica/api/contacts/17/activities?page=1','GET','185.161.170.68','2024-01-25 04:24:24','2024-01-25 04:24:24'),(90,'https://mandraw.noho.st/monica/api/contacts/17/activities?page=1','GET','85.190.89.201','2024-01-25 14:49:06','2024-01-25 14:49:06'),(91,'https://mandraw.noho.st/monica/api/contacts/17/activities?page=1','GET','85.190.89.155','2024-02-02 01:12:26','2024-02-02 01:12:26'),(92,'https://mandraw.noho.st/monica/api/contacts/23/activities?page=1','GET','85.190.89.66','2024-02-04 18:47:06','2024-02-04 18:47:06'),(93,'https://mandraw.noho.st/monica/api/contacts/23/activities?page=1','GET','85.190.89.66','2024-02-04 18:47:23','2024-02-04 18:47:23'),(94,'https://mandraw.noho.st/monica/api/contacts/24/activities?page=1','GET','85.190.89.66','2024-02-04 19:53:42','2024-02-04 19:53:42'),(95,'https://mandraw.noho.st/monica/api/contacts/24/activities?page=1','GET','85.190.89.66','2024-02-04 21:01:58','2024-02-04 21:01:58'),(96,'https://mandraw.noho.st/monica/api/contacts/23/activities?page=1','GET','85.190.89.66','2024-02-04 21:03:10','2024-02-04 21:03:10'),(97,'https://mandraw.noho.st/monica/api/contacts/23/activities?page=1','GET','85.190.89.66','2024-02-04 21:03:21','2024-02-04 21:03:21'),(98,'https://mandraw.noho.st/monica/api/contacts/25/activities?page=1','GET','185.161.171.33','2024-05-19 13:03:57','2024-05-19 13:03:57'),(99,'https://mandraw.noho.st/monica/api/contacts/25/activities?page=1','GET','185.161.171.33','2024-05-19 13:04:22','2024-05-19 13:04:22'),(100,'https://mandraw.noho.st/monica/api/contacts/25/activities?page=1','GET','185.161.171.16','2024-05-20 17:25:45','2024-05-20 17:25:45'),(101,'https://mandraw.noho.st/monica/api/contacts/25/activities?page=1','GET','85.190.89.177','2024-05-21 14:48:54','2024-05-21 14:48:54');

--
-- Table structure for table `audit_logs`
--

CREATE TABLE `audit_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `author_id` int(10) unsigned DEFAULT NULL,
  `about_contact_id` int(10) unsigned DEFAULT NULL,
  `author_name` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `objects` text NOT NULL,
  `audited_at` datetime NOT NULL,
  `should_appear_on_dashboard` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audit_logs_account_id_foreign` (`account_id`),
  KEY `audit_logs_author_id_foreign` (`author_id`),
  KEY `audit_logs_about_contact_id_foreign` (`about_contact_id`),
  CONSTRAINT `audit_logs_about_contact_id_foreign` FOREIGN KEY (`about_contact_id`) REFERENCES `contacts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `audit_logs_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `audit_logs_author_id_foreign` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_logs`
--

INSERT INTO `audit_logs` VALUES (1,3,3,1,'John Doe','contact_created','{\"contact_name\":\"Raeyamoon (Raeya)\",\"contact_id\":1}','2024-01-03 00:53:18',1,'2024-01-03 00:53:18','2024-01-03 00:53:18'),(2,3,3,2,'John Doe','contact_created','{\"contact_name\":\"R3zzy_exe (Rezzy)\",\"contact_id\":2}','2024-01-03 00:54:44',1,'2024-01-03 00:54:44','2024-01-03 00:54:44'),(3,3,3,3,'John Doe','contact_created','{\"contact_name\":\"TheForebringer (Fore)\",\"contact_id\":3}','2024-01-03 01:18:23',1,'2024-01-03 01:18:23','2024-01-03 01:18:23'),(4,3,3,4,'John Doe','contact_created','{\"contact_name\":\"Raydel (Raydel)\",\"contact_id\":4}','2024-01-03 01:18:38',1,'2024-01-03 01:18:38','2024-01-03 01:18:38'),(5,3,3,5,'John Doe','contact_created','{\"contact_name\":\"Himmie (Himmers)\",\"contact_id\":5}','2024-01-03 01:18:59',1,'2024-01-03 01:18:59','2024-01-03 01:18:59'),(6,3,3,6,'John Doe','contact_created','{\"contact_name\":\"Gilphchen (Gilph)\",\"contact_id\":6}','2024-01-03 01:19:27',1,'2024-01-03 01:19:27','2024-01-03 01:19:27'),(7,3,3,7,'John Doe','contact_created','{\"contact_name\":\"Ryan (Ryan)\",\"contact_id\":7}','2024-01-03 01:21:07',1,'2024-01-03 01:21:07','2024-01-03 01:21:07'),(8,3,3,8,'John Doe','contact_created','{\"contact_name\":\"MiloAndVe (Milo)\",\"contact_id\":8}','2024-01-03 01:25:45',1,'2024-01-03 01:25:45','2024-01-03 01:25:45'),(9,3,3,9,'John Doe','contact_created','{\"contact_name\":\"CandlesVt (Candles)\",\"contact_id\":9}','2024-01-03 01:29:57',1,'2024-01-03 01:29:57','2024-01-03 01:29:57'),(10,3,3,10,'John Doe','contact_created','{\"contact_name\":\"RibstheGoblin (Ribs)\",\"contact_id\":10}','2024-01-03 01:34:27',1,'2024-01-03 01:34:27','2024-01-03 01:34:27'),(11,3,3,10,'John Doe','contact_description_cleared','{\"contact_name\":\"RibstheGoblin (Ribs)\",\"contact_id\":10}','2024-01-03 01:36:12',1,'2024-01-03 01:36:12','2024-01-03 01:36:12'),(12,3,3,11,'John Doe','contact_created','{\"contact_name\":\"Grumlarkin\",\"contact_id\":11}','2024-01-05 05:35:58',1,'2024-01-05 05:35:58','2024-01-05 05:35:58'),(13,3,3,11,'John Doe','contact_description_cleared','{\"contact_name\":\"Grumlarkin\",\"contact_id\":11}','2024-01-05 05:56:21',1,'2024-01-05 05:56:21','2024-01-05 05:56:21'),(14,3,3,12,'John Doe','contact_created','{\"contact_name\":\"Oreami\",\"contact_id\":12}','2024-01-05 05:57:03',1,'2024-01-05 05:57:03','2024-01-05 05:57:03'),(15,3,3,13,'John Doe','contact_created','{\"contact_name\":\"Hihsasuke (Sookie)\",\"contact_id\":13}','2024-01-05 06:11:55',1,'2024-01-05 06:11:55','2024-01-05 06:11:55'),(16,3,3,14,'John Doe','contact_created','{\"contact_name\":\"ArtxesSprinkles (Art)\",\"contact_id\":14}','2024-01-07 01:53:41',1,'2024-01-07 01:53:41','2024-01-07 01:53:41'),(17,3,3,14,'John Doe','contact_description_cleared','{\"contact_name\":\"ArtxesSprinkles (Art)\",\"contact_id\":14}','2024-01-07 01:55:36',1,'2024-01-07 01:55:36','2024-01-07 01:55:36'),(18,3,3,15,'John Doe','contact_created','{\"contact_name\":\"OnlySenpaii (Senpaii)\",\"contact_id\":15}','2024-01-07 01:58:08',1,'2024-01-07 01:58:08','2024-01-07 01:58:08'),(19,3,3,16,'John Doe','contact_created','{\"contact_name\":\"Hony_Beea (Beea)\",\"contact_id\":16}','2024-01-07 02:00:32',1,'2024-01-07 02:00:32','2024-01-07 02:00:32'),(20,3,3,16,'John Doe','contact_description_cleared','{\"contact_name\":\"Hony_Beea (Beea)\",\"contact_id\":16}','2024-01-07 02:07:07',1,'2024-01-07 02:07:07','2024-01-07 02:07:07'),(21,3,3,17,'John Doe','contact_created','{\"contact_name\":\"Dad_Knight (Dad)\",\"contact_id\":17}','2024-01-07 02:13:28',1,'2024-01-07 02:13:28','2024-01-07 02:13:28'),(22,3,3,3,'John Doe','contact_description_cleared','{\"contact_name\":\"TheForebringer (Fore)\",\"contact_id\":3}','2024-01-09 16:02:58',1,'2024-01-09 16:02:58','2024-01-09 16:02:58'),(23,3,3,3,'John Doe','contact_description_cleared','{\"contact_name\":\"TheForebringer (Fore)\",\"contact_id\":3}','2024-01-09 16:03:07',1,'2024-01-09 16:03:07','2024-01-09 16:03:07'),(24,3,3,2,'John Doe','contact_description_cleared','{\"contact_name\":\"R3zzy_exe (Rezzy)\",\"contact_id\":2}','2024-01-09 16:04:04',1,'2024-01-09 16:04:04','2024-01-09 16:04:04'),(25,3,3,2,'John Doe','contact_description_cleared','{\"contact_name\":\"R3zzy_exe (Rezzy)\",\"contact_id\":2}','2024-01-09 16:04:10',1,'2024-01-09 16:04:10','2024-01-09 16:04:10'),(26,3,3,7,'John Doe','contact_description_cleared','{\"contact_name\":\"Ryan (Ryan)\",\"contact_id\":7}','2024-01-09 16:45:29',1,'2024-01-09 16:45:29','2024-01-09 16:45:29'),(27,3,3,18,'John Doe','contact_created','{\"contact_name\":\"Feydruidia (Fey)\",\"contact_id\":18}','2024-01-10 09:59:14',1,'2024-01-10 09:59:14','2024-01-10 09:59:14'),(28,3,3,18,'John Doe','contact_description_cleared','{\"contact_name\":\"Feydruidia (Fey)\",\"contact_id\":18}','2024-01-10 09:59:35',1,'2024-01-10 09:59:35','2024-01-10 09:59:35'),(29,3,3,19,'John Doe','contact_created','{\"contact_name\":\"ReactiveCupid93\",\"contact_id\":19}','2024-01-10 10:08:14',1,'2024-01-10 10:08:14','2024-01-10 10:08:14'),(30,3,3,20,'John Doe','contact_created','{\"contact_name\":\"Zoebaskervillevt (Zoe)\",\"contact_id\":20}','2024-01-10 10:23:51',1,'2024-01-10 10:23:51','2024-01-10 10:23:51'),(31,3,3,21,'John Doe','contact_created','{\"contact_name\":\"The_Dummiest_Demon (Hex)\",\"contact_id\":21}','2024-01-10 17:31:41',1,'2024-01-10 17:31:41','2024-01-10 17:31:41'),(32,3,3,6,'John Doe','contact_description_cleared','{\"contact_name\":\"Gilphchen (Gilph)\",\"contact_id\":6}','2024-01-11 06:02:55',1,'2024-01-11 06:02:55','2024-01-11 06:02:55'),(33,3,3,21,'John Doe','contact_description_cleared','{\"contact_name\":\"The_Dummiest_Demon (Hex)\",\"contact_id\":21}','2024-01-16 12:25:01',1,'2024-01-16 12:25:01','2024-01-16 12:25:01'),(34,3,3,21,'John Doe','contact_description_cleared','{\"contact_name\":\"The_Dummiest_Demon (Hex)\",\"contact_id\":21}','2024-01-16 12:25:06',1,'2024-01-16 12:25:06','2024-01-16 12:25:06'),(35,3,3,22,'John Doe','contact_created','{\"contact_name\":\"ExEro (Henry)\",\"contact_id\":22}','2024-01-20 15:31:33',1,'2024-01-20 15:31:33','2024-01-20 15:31:33'),(36,3,3,22,'John Doe','contact_description_cleared','{\"contact_name\":\"ExEro (Henry)\",\"contact_id\":22}','2024-01-20 16:01:25',1,'2024-01-20 16:01:25','2024-01-20 16:01:25'),(37,3,3,23,'John Doe','contact_created','{\"contact_name\":\"LuceBreaks (Luce)\",\"contact_id\":23}','2024-02-04 18:47:04',1,'2024-02-04 18:47:04','2024-02-04 18:47:04'),(38,3,3,24,'John Doe','contact_created','{\"contact_name\":\"PartTimeKadence (Kadence)\",\"contact_id\":24}','2024-02-04 19:53:41',1,'2024-02-04 19:53:41','2024-02-04 19:53:41'),(39,3,3,23,'John Doe','contact_description_cleared','{\"contact_name\":\"LuceBreaks (Luce)\",\"contact_id\":23}','2024-02-04 21:03:18',1,'2024-02-04 21:03:18','2024-02-04 21:03:18'),(40,3,3,25,'Mai Dragora','contact_created','{\"contact_name\":\"Max (Max)\",\"contact_id\":25}','2024-05-19 14:03:55',1,'2024-05-19 13:03:55','2024-05-19 13:03:55'),(41,3,3,25,'Mai Dragora','contact_description_cleared','{\"contact_name\":\"Max (Max)\",\"contact_id\":25}','2024-05-19 14:04:21',1,'2024-05-19 13:04:21','2024-05-19 13:04:21');

--
-- Table structure for table `calls`
--

CREATE TABLE `calls` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `called_at` datetime NOT NULL,
  `content` mediumtext DEFAULT NULL,
  `contact_called` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `calls_contact_id_foreign` (`contact_id`),
  KEY `calls_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `calls_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `calls_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `calls`
--


--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `website` varchar(255) DEFAULT NULL,
  `number_of_employees` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `companies_account_id_foreign` (`account_id`),
  CONSTRAINT `companies_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `companies`
--


--
-- Table structure for table `contact_field_contact_field_label`
--

CREATE TABLE `contact_field_contact_field_label` (
  `contact_field_label_id` bigint(20) unsigned NOT NULL,
  `contact_field_id` int(10) unsigned NOT NULL,
  `account_id` int(10) unsigned NOT NULL,
  KEY `contact_field_contact_field_label_index` (`contact_field_label_id`,`contact_field_id`,`account_id`),
  KEY `contact_field_contact_field_label_contact_field_id_foreign` (`contact_field_id`),
  KEY `contact_field_contact_field_label_account_id_foreign` (`account_id`),
  CONSTRAINT `contact_field_contact_field_label_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `contact_field_contact_field_label_contact_field_id_foreign` FOREIGN KEY (`contact_field_id`) REFERENCES `contact_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `contact_field_contact_field_label_contact_field_label_id_foreign` FOREIGN KEY (`contact_field_label_id`) REFERENCES `contact_field_labels` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_field_contact_field_label`
--


--
-- Table structure for table `contact_field_labels`
--

CREATE TABLE `contact_field_labels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `label_i18n` varchar(20) DEFAULT NULL,
  `label` varchar(500) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `contact_field_labels_label_i18n_account_id_index` (`label_i18n`,`account_id`),
  KEY `contact_field_labels_label_account_id_index` (`label`,`account_id`),
  KEY `contact_field_labels_account_id_foreign` (`account_id`),
  CONSTRAINT `contact_field_labels_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_field_labels`
--


--
-- Table structure for table `contact_field_types`
--

CREATE TABLE `contact_field_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `fontawesome_icon` varchar(255) DEFAULT NULL,
  `protocol` varchar(255) DEFAULT NULL,
  `delible` tinyint(1) NOT NULL DEFAULT 1,
  `type` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `contact_field_types_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `contact_field_types_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_field_types`
--

INSERT INTO `contact_field_types` VALUES (1,NULL,1,'Email','fa fa-envelope-open-o','mailto:',0,'email','2024-01-02 23:41:17','2024-01-02 23:41:17'),(2,NULL,1,'Phone','fa fa-volume-control-phone','tel:',0,'phone','2024-01-02 23:41:17','2024-01-02 23:41:17'),(3,NULL,1,'Facebook','fa fa-facebook-official','https://facebook.com/',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(4,NULL,1,'Twitter','fa fa-twitter-square',NULL,1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(5,NULL,1,'Whatsapp','fa fa-whatsapp','https://wa.me/',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(6,NULL,1,'Telegram','fa fa-telegram','telegram:',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(7,NULL,1,'LinkedIn','fa fa-linkedin-square',NULL,1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(8,NULL,2,'Email','fa fa-envelope-open-o','mailto:',0,'email','2024-01-02 23:41:18','2024-01-02 23:41:18'),(9,NULL,2,'Phone','fa fa-volume-control-phone','tel:',0,'phone','2024-01-02 23:41:18','2024-01-02 23:41:18'),(10,NULL,2,'Facebook','fa fa-facebook-official','https://facebook.com/',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(11,NULL,2,'Twitter','fa fa-twitter-square',NULL,1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(12,NULL,2,'Whatsapp','fa fa-whatsapp','https://wa.me/',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(13,NULL,2,'Telegram','fa fa-telegram','telegram:',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(14,NULL,2,'LinkedIn','fa fa-linkedin-square',NULL,1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(15,'ed09d358-4e20-4690-aa33-7343335305d4',3,'Email','fa fa-envelope-open-o','mailto:',0,'email','2024-01-02 23:41:19','2024-01-03 00:53:42'),(16,'94edb83c-760e-4147-a4a3-1265dcaa3545',3,'Phone','fa fa-volume-control-phone','tel:',0,'phone','2024-01-02 23:41:19','2024-01-03 00:53:42'),(17,'50de18e3-8ab4-4386-a708-c2ba3cf9343f',3,'Facebook','fa fa-facebook-official','https://facebook.com/',1,NULL,'2024-01-02 23:41:19','2024-01-03 00:53:42'),(18,'7fb5b87c-f938-40c8-9e32-a3b34c7df6cf',3,'Twitter','fa fa-twitter-square',NULL,1,NULL,'2024-01-02 23:41:19','2024-01-03 00:53:42'),(19,'0d77517a-2c7d-4c86-8c78-3e223663dfd6',3,'Whatsapp','fa fa-whatsapp','https://wa.me/',1,NULL,'2024-01-02 23:41:19','2024-01-03 00:53:42'),(20,'59c0fa5c-d76c-4e47-9ba9-65ef4ea7fe7a',3,'Telegram','fa fa-telegram','telegram:',1,NULL,'2024-01-02 23:41:19','2024-01-03 00:53:42'),(21,'4e4a1d52-4e33-492b-957a-9cf9bcd5026c',3,'LinkedIn','fa fa-linkedin-square',NULL,1,NULL,'2024-01-02 23:41:19','2024-01-03 00:53:42'),(22,'4c3ac6b8-b1e4-48ce-b76a-9ab2c49b65ec',3,'Twitch','fa fa-twitch',NULL,1,NULL,'2024-01-03 01:08:23','2024-01-03 01:17:31');

--
-- Table structure for table `contact_fields`
--

CREATE TABLE `contact_fields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `contact_field_type_id` int(10) unsigned NOT NULL,
  `data` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `contact_fields_contact_id_foreign` (`contact_id`),
  KEY `contact_fields_contact_field_type_id_foreign` (`contact_field_type_id`),
  KEY `contact_fields_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `contact_fields_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `contact_fields_contact_field_type_id_foreign` FOREIGN KEY (`contact_field_type_id`) REFERENCES `contact_field_types` (`id`) ON DELETE CASCADE,
  CONSTRAINT `contact_fields_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_fields`
--

INSERT INTO `contact_fields` VALUES (1,NULL,3,2,18,'https://twitter.com/R3ZZY_EXE','2024-01-03 01:06:09','2024-01-03 01:06:09'),(2,NULL,3,6,22,'https://www.twitch.tv/gilphchen','2024-01-03 01:20:04','2024-01-03 01:20:04'),(3,NULL,3,7,22,'https://www.twitch.tv/spectre828','2024-01-03 01:22:28','2024-01-03 01:22:28'),(4,NULL,3,7,18,'https://twitter.com/KitsuneNoKage88','2024-01-03 01:22:52','2024-01-03 01:22:52'),(5,NULL,3,8,18,'https://twitter.com/MiloAndVe1','2024-01-03 01:26:16','2024-01-03 01:26:16'),(6,NULL,3,8,22,'https://www.twitch.tv/miloandve','2024-01-03 01:26:44','2024-01-03 01:26:44'),(8,NULL,3,1,18,'https://twitter.com/RaeyaMoon','2024-01-03 01:27:24','2024-01-03 01:27:24'),(9,NULL,3,1,22,'https://twitch.tv/RaeyaMoon','2024-01-03 01:27:40','2024-01-03 01:27:40'),(10,NULL,3,9,18,'https://twitter.com/CandlesVT','2024-01-03 01:30:11','2024-01-03 01:30:11'),(11,NULL,3,9,22,'https://www.twitch.tv/candlesthegoblin','2024-01-03 01:30:27','2024-01-03 01:30:27'),(12,NULL,3,10,18,'https://twitter.com/Ribsthegoblin','2024-01-03 01:35:16','2024-01-03 01:35:16'),(13,NULL,3,11,22,'https://www.twitch.tv/grumlarkin','2024-01-05 05:36:20','2024-01-05 05:36:20'),(14,NULL,3,11,18,'https://twitter.com/grumlarkin','2024-01-05 05:36:33','2024-01-05 05:36:33'),(15,NULL,3,12,18,'https://twitter.com/OreamiVT','2024-01-05 05:58:57','2024-01-05 05:58:57'),(16,NULL,3,12,22,'https://www.twitch.tv/oreamivt','2024-01-05 05:59:42','2024-01-05 05:59:42'),(17,NULL,3,13,22,'https://www.twitch.tv/Hihsasuke','2024-01-05 06:12:05','2024-01-05 06:12:05'),(18,NULL,3,13,18,'https://twitter.com/Hihsasuke','2024-01-05 06:12:58','2024-01-05 06:12:58'),(19,NULL,3,14,22,'https://www.twitch.tv/artxesprinkles','2024-01-07 01:54:00','2024-01-07 01:54:00'),(20,NULL,3,14,18,'https://twitter.com/ArtxeSprinkles','2024-01-07 01:54:38','2024-01-07 01:54:38'),(21,NULL,3,15,18,'https://twitter.com/onlysenpaii','2024-01-07 01:58:56','2024-01-07 01:58:56'),(22,NULL,3,15,22,'https://www.twitch.tv/onlysenpaii','2024-01-07 01:59:38','2024-01-07 01:59:38'),(23,NULL,3,16,18,'https://twitter.com/hony_beea','2024-01-07 02:09:21','2024-01-07 02:09:21'),(24,NULL,3,16,22,'https://www.twitch.tv/hony_beea','2024-01-07 02:09:38','2024-01-07 02:09:38'),(25,NULL,3,17,22,'https://www.twitch.tv/dad_knight','2024-01-07 02:14:06','2024-01-07 02:14:06'),(26,NULL,3,17,18,'https://twitter.com/spud_north','2024-01-07 02:28:21','2024-01-07 02:28:21'),(27,NULL,3,18,22,'https://www.twitch.tv/feydruidia','2024-01-10 10:00:50','2024-01-10 10:00:50'),(28,NULL,3,18,18,'https://twitter.com/FeyDruidia','2024-01-10 10:01:14','2024-01-10 10:01:14'),(29,NULL,3,4,18,'https://twitter.com/RaydelRestorer','2024-01-10 10:06:42','2024-01-10 10:06:42'),(30,NULL,3,4,22,'https://www.twitch.tv/raydel_r','2024-01-10 10:07:01','2024-01-10 10:07:01'),(31,NULL,3,19,18,'https://twitter.com/ReactiveCupid93/','2024-01-10 10:09:03','2024-01-10 10:09:03'),(32,NULL,3,20,18,'https://twitter.com/ZoeBaskerville','2024-01-10 10:24:16','2024-01-10 10:24:16'),(33,NULL,3,20,22,'https://www.twitch.tv/zoebaskervillevt','2024-01-10 10:24:35','2024-01-10 10:24:35'),(34,NULL,3,21,18,'https://twitter.com/Hexed_Maniac','2024-01-10 17:33:13','2024-01-10 17:33:13'),(35,NULL,3,21,22,'https://www.twitch.tv/the_dummiest_demon','2024-01-10 17:33:19','2024-01-10 17:33:19'),(36,NULL,3,24,18,'https://twitter.com/KadenceNashVT','2024-02-04 21:02:50','2024-02-04 21:02:50');

--
-- Table structure for table `contact_photo`
--

CREATE TABLE `contact_photo` (
  `contact_id` int(10) unsigned NOT NULL,
  `photo_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `contact_photo_photo_id_foreign` (`photo_id`),
  KEY `contact_photo_contact_id_foreign` (`contact_id`),
  CONSTRAINT `contact_photo_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `contact_photo_photo_id_foreign` FOREIGN KEY (`photo_id`) REFERENCES `photos` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_photo`
--

INSERT INTO `contact_photo` VALUES (1,1,'2024-01-03 01:02:48','2024-01-03 01:02:48'),(2,2,'2024-01-03 01:04:03','2024-01-03 01:04:03'),(7,3,'2024-01-03 01:23:22','2024-01-03 01:23:22'),(6,4,'2024-01-03 01:24:55','2024-01-03 01:24:55'),(8,5,'2024-01-03 01:26:08','2024-01-03 01:26:08'),(5,6,'2024-01-03 01:28:18','2024-01-03 01:28:18'),(9,7,'2024-01-03 01:31:21','2024-01-03 01:31:21'),(10,8,'2024-01-03 01:34:44','2024-01-03 01:34:44'),(11,9,'2024-01-05 05:39:50','2024-01-05 05:39:50'),(12,10,'2024-01-05 05:57:43','2024-01-05 05:57:43'),(13,11,'2024-01-05 06:59:55','2024-01-05 06:59:55'),(14,12,'2024-01-07 01:55:46','2024-01-07 01:55:46'),(15,13,'2024-01-07 01:58:47','2024-01-07 01:58:47'),(16,14,'2024-01-07 02:01:53','2024-01-07 02:01:53'),(17,15,'2024-01-07 02:29:23','2024-01-07 02:29:23'),(18,16,'2024-01-10 10:02:50','2024-01-10 10:02:50'),(3,17,'2024-01-10 10:04:51','2024-01-10 10:04:51'),(4,18,'2024-01-10 10:05:47','2024-01-10 10:05:47'),(19,19,'2024-01-10 10:08:50','2024-01-10 10:08:50'),(20,20,'2024-01-10 10:25:32','2024-01-10 10:25:32'),(21,21,'2024-01-16 12:26:01','2024-01-16 12:26:01'),(22,22,'2024-01-20 16:26:24','2024-01-20 16:26:24'),(23,23,'2024-02-04 18:47:22','2024-02-04 18:47:22'),(24,24,'2024-02-04 21:01:56','2024-02-04 21:01:56');

--
-- Table structure for table `contact_tag`
--

CREATE TABLE `contact_tag` (
  `contact_id` int(10) unsigned NOT NULL,
  `tag_id` int(10) unsigned NOT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `contact_tag_account_id_foreign` (`account_id`),
  KEY `contact_tag_contact_id_foreign` (`contact_id`),
  KEY `contact_tag_tag_id_foreign` (`tag_id`),
  CONSTRAINT `contact_tag_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `contact_tag_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `contact_tag_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_tag`
--

INSERT INTO `contact_tag` VALUES (7,1,3,'2024-01-09 16:45:37','2024-01-09 16:45:37'),(9,1,3,'2024-01-10 10:03:48','2024-01-10 10:03:48'),(3,1,3,'2024-01-10 10:04:58','2024-01-10 10:04:58'),(19,1,3,'2024-01-10 10:08:56','2024-01-10 10:08:56'),(20,1,3,'2024-01-10 10:25:48','2024-01-10 10:25:48');

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `address_book_id` bigint(20) unsigned DEFAULT NULL,
  `first_name` varchar(255) NOT NULL,
  `middle_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `nickname` varchar(255) DEFAULT NULL,
  `gender_id` int(11) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `uuid` char(36) DEFAULT NULL,
  `is_starred` tinyint(1) NOT NULL DEFAULT 0,
  `is_partial` tinyint(1) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `is_dead` tinyint(1) NOT NULL DEFAULT 0,
  `deceased_special_date_id` int(10) unsigned DEFAULT NULL,
  `deceased_reminder_id` int(10) unsigned DEFAULT NULL,
  `last_talked_to` date DEFAULT NULL,
  `stay_in_touch_frequency` int(11) DEFAULT NULL,
  `stay_in_touch_trigger_date` datetime DEFAULT NULL,
  `birthday_special_date_id` int(10) unsigned DEFAULT NULL,
  `birthday_reminder_id` int(10) unsigned DEFAULT NULL,
  `first_met_through_contact_id` int(11) DEFAULT NULL,
  `first_met_special_date_id` int(10) unsigned DEFAULT NULL,
  `first_met_reminder_id` int(10) unsigned DEFAULT NULL,
  `first_met_where` varchar(255) DEFAULT NULL,
  `first_met_additional_info` longtext DEFAULT NULL,
  `job` varchar(255) DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `food_preferences` longtext DEFAULT NULL,
  `avatar_source` varchar(255) NOT NULL DEFAULT 'default',
  `avatar_gravatar_url` varchar(250) DEFAULT NULL,
  `avatar_adorable_uuid` char(36) DEFAULT NULL,
  `avatar_adorable_url` varchar(250) DEFAULT NULL,
  `avatar_default_url` varchar(250) DEFAULT NULL,
  `avatar_photo_id` int(10) unsigned DEFAULT NULL,
  `has_avatar` tinyint(1) NOT NULL DEFAULT 0,
  `avatar_external_url` varchar(400) DEFAULT NULL,
  `avatar_file_name` varchar(255) DEFAULT NULL,
  `avatar_location` varchar(255) NOT NULL DEFAULT 'local',
  `gravatar_url` varchar(255) DEFAULT NULL,
  `vcard` mediumtext DEFAULT NULL,
  `distant_etag` varchar(256) DEFAULT NULL,
  `last_consulted_at` timestamp NULL DEFAULT NULL,
  `number_of_views` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `default_avatar_color` varchar(255) NOT NULL,
  `has_avatar_bool` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `contacts_birthday_reminder_id_foreign` (`birthday_reminder_id`),
  KEY `contacts_first_met_reminder_id_foreign` (`first_met_reminder_id`),
  KEY `contacts_deceased_reminder_id_foreign` (`deceased_reminder_id`),
  KEY `contacts_birthday_special_date_id_foreign` (`birthday_special_date_id`),
  KEY `contacts_first_met_special_date_id_foreign` (`first_met_special_date_id`),
  KEY `contacts_deceased_special_date_id_foreign` (`deceased_special_date_id`),
  KEY `contacts_account_id_uuid_index` (`account_id`,`uuid`),
  KEY `contacts_avatar_photo_id_foreign` (`avatar_photo_id`),
  KEY `contacts_address_book_id_foreign` (`address_book_id`),
  CONSTRAINT `contacts_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `contacts_address_book_id_foreign` FOREIGN KEY (`address_book_id`) REFERENCES `addressbooks` (`id`) ON DELETE CASCADE,
  CONSTRAINT `contacts_avatar_photo_id_foreign` FOREIGN KEY (`avatar_photo_id`) REFERENCES `photos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `contacts_birthday_reminder_id_foreign` FOREIGN KEY (`birthday_reminder_id`) REFERENCES `reminders` (`id`) ON DELETE SET NULL,
  CONSTRAINT `contacts_birthday_special_date_id_foreign` FOREIGN KEY (`birthday_special_date_id`) REFERENCES `special_dates` (`id`) ON DELETE SET NULL,
  CONSTRAINT `contacts_deceased_reminder_id_foreign` FOREIGN KEY (`deceased_reminder_id`) REFERENCES `reminders` (`id`) ON DELETE SET NULL,
  CONSTRAINT `contacts_deceased_special_date_id_foreign` FOREIGN KEY (`deceased_special_date_id`) REFERENCES `special_dates` (`id`) ON DELETE SET NULL,
  CONSTRAINT `contacts_first_met_reminder_id_foreign` FOREIGN KEY (`first_met_reminder_id`) REFERENCES `reminders` (`id`) ON DELETE SET NULL,
  CONSTRAINT `contacts_first_met_special_date_id_foreign` FOREIGN KEY (`first_met_special_date_id`) REFERENCES `special_dates` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` VALUES (1,3,NULL,'Raeyamoon',NULL,NULL,'Raeya',8,NULL,'3b093b18-42d5-4227-89aa-c62cd6087695',1,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'d37ea91b-80bd-47f4-a3d7-4d679e1eb6fc','200/d37ea91b-80bd-47f4-a3d7-4d679e1eb6fc.png','avatars/bf79b693-c496-4f8f-ab80-1733857becfb.jpg?1704243198',1,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-05 06:00:20',6,NULL,'2024-01-03 00:53:01','2024-05-19 13:01:37','#fdb660',0),(2,3,NULL,'R3zzy_exe',NULL,NULL,'Rezzy',7,NULL,'c762be65-9d3f-4b60-b584-d5c5189dfd4a',0,0,1,0,NULL,NULL,NULL,NULL,NULL,8,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'469f213b-20d8-4972-ac2d-bb31443e6280','200/469f213b-20d8-4972-ac2d-bb31443e6280.png','avatars/f0061aa8-e995-45db-9885-75918ff586bd.jpg?1704243284',2,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-09 16:04:10',6,NULL,'2024-01-03 00:54:44','2024-05-19 13:01:37','#fdb660',0),(3,3,NULL,'TheForebringer',NULL,NULL,'Fore',7,NULL,'d856c2ff-b136-4bd8-b6a6-7a4d2ef4bd0f',0,0,1,0,NULL,NULL,NULL,NULL,NULL,6,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'7e3f7e4b-6e88-48be-a8e2-0e520aa33562','200/7e3f7e4b-6e88-48be-a8e2-0e520aa33562.png','avatars/bd777f56-729b-434c-a3c7-d4e8075ca360.jpg?1704244703',17,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-10 10:04:52',5,NULL,'2024-01-03 01:18:23','2024-05-19 13:01:37','#93521e',0),(4,3,NULL,'Raydel',NULL,NULL,'Raydel',9,NULL,'2d8719dc-4d51-42d2-81ed-5cd9761970f3',0,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'48eecd76-6b1f-4ab3-b315-d70072782f4c','200/48eecd76-6b1f-4ab3-b315-d70072782f4c.png','avatars/2cc8cd6b-292f-4649-bc3a-6abbdb4d1ac8.jpg?1704244718',18,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-10 10:05:47',2,NULL,'2024-01-03 01:18:38','2024-05-19 13:01:37','#709512',0),(5,3,NULL,'Himmie',NULL,NULL,'Himmers',8,NULL,'e2f0aa7c-89ee-49c5-b194-2ff09884997d',0,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'615bef2e-ce86-4b30-8d2a-8a13224fc8b1','200/615bef2e-ce86-4b30-8d2a-8a13224fc8b1.png','avatars/015ebe10-26d3-4db5-a317-9a04fb07db1c.jpg?1704244739',6,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-03 01:28:18',3,NULL,'2024-01-03 01:18:59','2024-05-19 13:01:37','#709512',0),(6,3,NULL,'Gilphchen',NULL,NULL,'Gilph',9,NULL,'fb90aaca-a974-4dc4-ac81-61c53a7f475c',0,0,1,0,NULL,NULL,NULL,NULL,NULL,11,6,7,NULL,NULL,NULL,'In Ryan\'s chat',NULL,NULL,NULL,'photo',NULL,'0a20adfb-80f2-42b6-a7c9-324f0bdaf5df','200/0a20adfb-80f2-42b6-a7c9-324f0bdaf5df.png','avatars/868f26ff-a823-44ca-b0d3-21bbf8e0d493.jpg?1704244767',4,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-17 07:04:27',6,NULL,'2024-01-03 01:19:27','2024-05-19 13:01:37','#ff9807',0),(7,3,NULL,'Ryan',NULL,NULL,'Ryan',7,NULL,'d1ec7385-5df1-438c-9bb3-0b04123527e8',1,0,1,0,NULL,NULL,NULL,NULL,NULL,9,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'689d03ae-76db-45bc-9272-e162b4d643b0','200/689d03ae-76db-45bc-9272-e162b4d643b0.png','avatars/33cfba7d-72b2-445d-b997-1e2261ff28fa.jpg?1704244867',3,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-09 16:45:29',6,NULL,'2024-01-03 01:21:07','2024-05-19 13:01:37','#b3d5fe',0),(8,3,NULL,'MiloAndVe',NULL,NULL,'Milo',7,NULL,'b7f727be-a7f4-4d30-8a4d-f2136f6133e5',1,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'61a10ea1-c5f7-491f-b47b-31d53c612633','200/61a10ea1-c5f7-491f-b47b-31d53c612633.png','avatars/3708dfe9-302d-4c98-8951-8454e76b429c.jpg?1704245145',5,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-05 06:00:13',3,NULL,'2024-01-03 01:25:45','2024-05-19 13:01:37','#b3d5fe',0),(9,3,NULL,'CandlesVt',NULL,NULL,'Candles',NULL,NULL,'57a13ec1-7ae4-40ce-b933-639caa8d6972',1,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'621f7455-4ca4-467f-927c-20ef288c2ed7','200/621f7455-4ca4-467f-927c-20ef288c2ed7.png','avatars/5496c613-22bd-4df6-953b-503d2bce3ced.jpg?1704245397',7,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-10 10:03:43',4,NULL,'2024-01-03 01:29:57','2024-05-19 13:01:37','#b3d5fe',0),(10,3,NULL,'RibstheGoblin',NULL,NULL,'Ribs',7,NULL,'70636e67-8b57-42ef-9587-2dcdeaa1b18c',0,0,1,0,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'28e01542-a019-4efd-b381-c2ea31a3a18b','200/28e01542-a019-4efd-b381-c2ea31a3a18b.png','avatars/a5a58987-0040-432c-8d98-1eb739c6217d.jpg?1704245667',8,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-03 01:36:12',3,NULL,'2024-01-03 01:34:27','2024-05-19 13:01:37','#fdb660',0),(11,3,NULL,'Grumlarkin',NULL,NULL,NULL,9,NULL,'638f81fd-50e8-4919-91a3-5574eb4196ef',0,0,1,0,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'99067cc6-090e-436d-9d5e-7af0af380c37','200/99067cc6-090e-436d-9d5e-7af0af380c37.png','avatars/9e79a73f-bb57-45af-ac55-eca83cfd3a94.jpg?1704432958',9,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-05 05:56:39',4,NULL,'2024-01-05 05:35:58','2024-05-19 13:01:37','#fdb660',0),(12,3,NULL,'Oreami',NULL,NULL,NULL,7,NULL,'3277d8aa-f334-483b-8148-8956d468a6d2',0,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'57c70180-b2f1-4f5b-8d46-8917dddcddce','200/57c70180-b2f1-4f5b-8d46-8917dddcddce.png','avatars/1e874ed7-4310-4b23-be01-c07cc9712cc9.jpg?1704434223',10,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-05 05:57:43',2,NULL,'2024-01-05 05:57:03','2024-05-19 13:01:37','#e5e5cd',0),(13,3,NULL,'Hihsasuke',NULL,NULL,'Sookie',7,NULL,'8a81249f-5829-4650-99b9-36c518eac3e9',0,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'9dba76d6-60fe-49bd-b68e-1cc09bc2d3eb','200/9dba76d6-60fe-49bd-b68e-1cc09bc2d3eb.png','avatars/746fc795-e78b-4340-8e51-d4f49dcbf8e3.jpg?1704435115',11,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-05 06:59:55',2,NULL,'2024-01-05 06:11:55','2024-05-19 13:01:37','#fdb660',0),(14,3,NULL,'ArtxesSprinkles',NULL,NULL,'Art',7,NULL,'5cf53069-1469-43f1-97d0-e094ff0d1dbe',0,0,1,0,NULL,NULL,NULL,NULL,NULL,3,NULL,4,NULL,NULL,NULL,'Was collabbing with Raydel',NULL,NULL,NULL,'photo',NULL,'75822cb4-2720-40a7-ab7c-fd90efac66b3','200/75822cb4-2720-40a7-ab7c-fd90efac66b3.png','avatars/743ecfd5-dc4d-4d62-b2bb-3d2f94fb4160.jpg?1704592421',12,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-07 01:55:46',4,NULL,'2024-01-07 01:53:40','2024-05-19 13:01:37','#e5e5cd',0),(15,3,NULL,'OnlySenpaii',NULL,NULL,'Senpaii',7,NULL,'9809ac06-cb39-4835-b469-ff87989e6507',0,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,'Collab with Beea',NULL,NULL,NULL,'photo',NULL,'6b06e026-b55f-40f9-95e7-861a13c4ee19','200/6b06e026-b55f-40f9-95e7-861a13c4ee19.png','avatars/56bd1ba5-1b36-4ea4-8fc0-a88281022d19.jpg?1704592688',13,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-07 02:08:28',4,NULL,'2024-01-07 01:58:08','2024-05-19 13:01:37','#ff9807',0),(16,3,NULL,'Hony_Beea',NULL,NULL,'Beea',9,NULL,'66f35ae4-215f-4c54-a54b-117e6b9f7198',0,0,1,0,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'3b0479ef-fb1a-4c11-9372-b1a9d64c5b87','200/3b0479ef-fb1a-4c11-9372-b1a9d64c5b87.png','avatars/b31ef81c-e03e-4c1b-9ca0-343568cbcb12.jpg?1704592832',14,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-07 02:07:07',3,NULL,'2024-01-07 02:00:32','2024-05-19 13:01:37','#5f479a',0),(17,3,NULL,'Dad_Knight',NULL,NULL,'Dad',7,NULL,'ea799da1-4b32-4958-806f-161610da588d',0,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,'Met through Beea\'s chat',NULL,NULL,NULL,'photo',NULL,'532149d0-9654-48d5-b525-5ad18944ba04','200/532149d0-9654-48d5-b525-5ad18944ba04.png','avatars/a2ea9ef7-1f30-418c-b3ec-a2fe9e689cdc.jpg?1704593608',15,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-02-02 01:12:25',9,NULL,'2024-01-07 02:13:28','2024-05-19 13:01:37','#5f479a',0),(18,3,NULL,'Feydruidia',NULL,NULL,'Fey',8,NULL,'1cc11a72-fb2f-4a7d-92e9-81b6316f5662',0,0,1,0,NULL,NULL,NULL,NULL,NULL,10,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'076426af-680c-4b63-8441-a5c1070c3e17','200/076426af-680c-4b63-8441-a5c1070c3e17.png','avatars/8d89628c-ec73-474f-bcd1-a040b45368a6.jpg?1704880754',16,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-10 10:02:50',3,NULL,'2024-01-10 09:59:14','2024-05-19 13:01:37','#bd5067',0),(19,3,NULL,'ReactiveCupid93',NULL,NULL,NULL,NULL,NULL,'cdc25400-b813-420e-a9d2-22f3857bf74d',0,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'30bdf8d1-07cd-4b65-96df-69f69846d0bb','200/30bdf8d1-07cd-4b65-96df-69f69846d0bb.png','avatars/e8118e7e-d350-428a-a43b-2913a802cfd6.jpg?1704881294',19,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-10 10:08:50',2,NULL,'2024-01-10 10:08:14','2024-05-19 13:01:37','#ff9807',0),(20,3,NULL,'Zoebaskervillevt',NULL,NULL,'Zoe',8,NULL,'6ff99d5f-6103-4d56-9304-5813dcd3613d',0,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'e7ee132e-5cef-4165-804e-1afd02d09d35','200/e7ee132e-5cef-4165-804e-1afd02d09d35.png','avatars/9a528bd0-5b44-4d15-99bc-a0aec7e78344.jpg?1704882231',20,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-10 10:25:32',2,NULL,'2024-01-10 10:23:51','2024-05-19 13:01:37','#bd5067',0),(21,3,NULL,'The_Dummiest_Demon',NULL,NULL,'Hex',8,NULL,'0a9c713b-1321-4a4b-ac2b-cd687ae0e409',0,0,1,0,NULL,NULL,NULL,NULL,NULL,13,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'87b4e751-8c7f-442f-9da9-1c8deea6459b','200/87b4e751-8c7f-442f-9da9-1c8deea6459b.png','avatars/420bbe8c-7d07-4285-91ae-5057bff1268a.jpg?1704907901',21,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-16 12:26:01',6,NULL,'2024-01-10 17:31:41','2024-05-19 13:01:37','#b3d5fe',0),(22,3,NULL,'ExEro',NULL,NULL,'Henry',7,NULL,'d84a6890-0e4f-4fd1-9178-920bda4dfbd0',0,0,1,0,NULL,NULL,NULL,NULL,NULL,14,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'0efbe802-72a1-43c2-b56a-bff83dd80604','200/0efbe802-72a1-43c2-b56a-bff83dd80604.png','avatars/88feb418-5f08-4a1c-9ce9-60be45d96598.jpg?1705764693',22,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-01-21 13:51:14',4,NULL,'2024-01-20 15:31:33','2024-05-19 13:01:37','#5f479a',0),(23,3,NULL,'LuceBreaks',NULL,NULL,'Luce',8,NULL,'a397bf08-ea80-4af0-ae17-f4113a3c76a9',0,0,1,0,NULL,NULL,NULL,NULL,NULL,15,10,24,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'a96ded29-fa82-4dc5-9fa7-35030feeacfb','200/a96ded29-fa82-4dc5-9fa7-35030feeacfb.png','avatars/4a32e728-1757-4d18-8fc2-e9ee4d91d519.jpg?1707072424',23,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-02-04 21:03:18',4,NULL,'2024-02-04 18:47:04','2024-05-19 13:01:37','#bd5067',0),(24,3,NULL,'PartTimeKadence',NULL,NULL,'Kadence',NULL,NULL,'04822338-cb60-40ef-b7c4-d806e93d070e',0,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'photo',NULL,'0cf4029c-6e4a-4c03-95ef-59139244af26','200/0cf4029c-6e4a-4c03-95ef-59139244af26.png','avatars/43c7b3a9-5b11-4b0b-b225-2af5cce8d57c.jpg?1707076421',24,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-02-04 21:01:57',2,NULL,'2024-02-04 19:53:41','2024-05-19 13:01:37','#e5e5cd',0),(25,3,NULL,'Max',NULL,NULL,'Max',8,NULL,'1f5ab7f8-eedd-42f3-b7ba-9d6974ff7f1e',1,0,1,0,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default',NULL,'3aadc2f9-8d25-4d18-9aba-d199e1397660','200/3aadc2f9-8d25-4d18-9aba-d199e1397660.png','avatars/1f5ab7f8-eedd-42f3-b7ba-9d6974ff7f1e.jpg?1716127435',NULL,0,NULL,NULL,'local',NULL,NULL,NULL,'2024-05-21 14:48:53',4,NULL,'2024-05-19 13:03:55','2024-05-19 13:04:21','#b3d5fe',0);

--
-- Table structure for table `conversations`
--

CREATE TABLE `conversations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `contact_field_type_id` int(10) unsigned NOT NULL,
  `happened_at` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `conversations_contact_id_foreign` (`contact_id`),
  KEY `conversations_contact_field_type_id_foreign` (`contact_field_type_id`),
  KEY `conversations_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `conversations_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `conversations_contact_field_type_id_foreign` FOREIGN KEY (`contact_field_type_id`) REFERENCES `contact_field_types` (`id`) ON DELETE CASCADE,
  CONSTRAINT `conversations_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `conversations`
--


--
-- Table structure for table `crons`
--

CREATE TABLE `crons` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `command` varchar(255) NOT NULL,
  `last_run` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `crons_command_unique` (`command`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `crons`
--


--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `iso` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `symbol` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=154 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` VALUES (1,'CAD','Canadian Dollar','$',NULL,NULL),(2,'USD','US Dollar','$',NULL,NULL),(3,'GBP','British Pound','£',NULL,NULL),(4,'EUR','Euro','€',NULL,NULL),(5,'RUB','Russian Ruble','₽',NULL,NULL),(6,'ZAR','South African Rand','R ',NULL,NULL),(7,'DKK','Danish krone','kr.',NULL,NULL),(8,'INR','Indian rupee','₹',NULL,NULL),(9,'BRL','Brazilian Real','R$',NULL,NULL),(10,'CHF','Swiss CHF','CHF',NULL,NULL),(11,'AED','Emirati Dirham','.د.ب',NULL,NULL),(12,'AFN','Afghan Afghani','؋',NULL,NULL),(13,'ALL','Albanian lek','lek',NULL,NULL),(14,'AMD','Armenian dram','',NULL,NULL),(15,'ANG','Dutch Guilder','ƒ',NULL,NULL),(16,'AOA','Angolan Kwanza','Kz',NULL,NULL),(17,'ARS','Argentine peso','$',NULL,NULL),(18,'AUD','Australian Dollar','$',NULL,NULL),(19,'AWG','Arubin florin','ƒ',NULL,NULL),(20,'AZN','Azerbaijani manat','ман',NULL,NULL),(21,'BAM','Bosnian Convertible Marka','KM',NULL,NULL),(22,'BBD','Barbadian dollar','$',NULL,NULL),(23,'BDT','Bangladeshi Taka','Tk',NULL,NULL),(24,'BGN','Bulgarian lev','лв',NULL,NULL),(25,'BHD','Bahraini Dinar','.د.ب or BD',NULL,NULL),(26,'BIF','Burundian Franc','',NULL,NULL),(27,'BMD','Bermudian dollar','$',NULL,NULL),(28,'BND','Bruneian Dollar','$',NULL,NULL),(29,'BOB','Bolivian Boliviano','$b',NULL,NULL),(30,'BSD','Bahamian dollar','B$',NULL,NULL),(31,'BTN','Bhutanese Ngultrum','Nu.',NULL,NULL),(32,'BWP','Botswana Pula','P',NULL,NULL),(33,'BYR','Belarusian ruble','р',NULL,NULL),(34,'BZD','Belize dollar','BZ$',NULL,NULL),(35,'CLP','Chilean Peso','$',NULL,NULL),(36,'CNY','Yuan or chinese renminbi','¥',NULL,NULL),(37,'COP','Colombian peso','$',NULL,NULL),(38,'CRC','Costa Rican colón','₡',NULL,NULL),(39,'CUC','Cuban convertible peso','$',NULL,NULL),(40,'CUP','Cuban peso','₱',NULL,NULL),(41,'CVE','Cape Verdean Escudo','$',NULL,NULL),(42,'CZK','Czech koruna','Kč',NULL,NULL),(43,'DJF','Djiboutian Franc','fdj',NULL,NULL),(44,'DOP','Dominican peso','$',NULL,NULL),(45,'DZD','Algerian Dinar','جد',NULL,NULL),(46,'EGP','Egyptian Pound','£ ',NULL,NULL),(47,'ERN','Eritrean nakfa','ናቕፋ',NULL,NULL),(48,'ETB','Ethiopian Birr','Br',NULL,NULL),(49,'FJD','Fijian dollar','$',NULL,NULL),(50,'FKP','Falkland Island Pound','£',NULL,NULL),(51,'GEL','Georgian lari','ლ',NULL,NULL),(52,'GHS','Ghanaian Cedi','GH¢',NULL,NULL),(53,'GIP','Gibraltar pound','£',NULL,NULL),(54,'GMD','Gambian dalasi','',NULL,NULL),(55,'GNF','Guinean Franc','',NULL,NULL),(56,'GTQ','Guatemalan Quetzal','Q',NULL,NULL),(57,'GYD','Guyanese dollar','$',NULL,NULL),(58,'HKD','Hong Kong dollar','HK$',NULL,NULL),(59,'HNL','Honduran lempira','L',NULL,NULL),(60,'HRK','Croatian kuna','kn',NULL,NULL),(61,'HTG','Haitian gourde','G',NULL,NULL),(62,'HUF','Hungarian forint','Ft',NULL,NULL),(63,'IDR','Indonesian Rupiah','Rp',NULL,NULL),(64,'ILS','Israeli Shekel','₪',NULL,NULL),(65,'IQD','Iraqi Dinar','ع.د',NULL,NULL),(66,'IRR','Iranian Rial','',NULL,NULL),(67,'ISK','Icelandic Krona','kr',NULL,NULL),(68,'JMD','Jamaican dollar','J$',NULL,NULL),(69,'JOD','Jordanian Dinar','',NULL,NULL),(70,'JPY','Japanese yen','¥',NULL,NULL),(71,'KES','Kenyan Shilling','KSh',NULL,NULL),(72,'KGS','Kyrgyzstani som','лв',NULL,NULL),(73,'KHR','Cambodian Riel','៛',NULL,NULL),(74,'KMF','Comoran Franc','',NULL,NULL),(75,'KPW','North Korean won','₩',NULL,NULL),(76,'KRW','South Korean won','₩',NULL,NULL),(77,'KWD','Kuwaiti Dinar','ك',NULL,NULL),(78,'KYD','Caymanian Dollar','$',NULL,NULL),(79,'KZT','Kazakhstani tenge','₸',NULL,NULL),(80,'LAK','Lao or Laotian Kip','₭',NULL,NULL),(81,'LBP','Lebanese Pound','ل.ل',NULL,NULL),(82,'LKR','Sri Lankan Rupee','Rs',NULL,NULL),(83,'LRD','Liberian Dollar','$',NULL,NULL),(84,'LSL','Lesotho loti','L or M',NULL,NULL),(85,'LTL','Lithuanian litas','Lt',NULL,NULL),(86,'LYD','Libyan Dinar',' د.ل',NULL,NULL),(87,'MAD','Moroccan Dirham','م.د.',NULL,NULL),(88,'MDL','Moldovan Leu','L',NULL,NULL),(89,'MGA','Malagasy Ariary','Ar',NULL,NULL),(90,'MKD','Macedonian Denar','ден',NULL,NULL),(91,'MMK','Burmese Kyat','K',NULL,NULL),(92,'MNT','Mongolian Tughrik','₮',NULL,NULL),(93,'MOP','Macau Pataca','MOP$',NULL,NULL),(94,'MRO','Mauritanian Ouguiya','UM',NULL,NULL),(95,'MUR','Mauritian rupee','Rs',NULL,NULL),(96,'MVR','Maldivian Rufiyaa','rf',NULL,NULL),(97,'MWK','Malawian Kwacha','MK',NULL,NULL),(98,'MXN','Mexico Peso','$',NULL,NULL),(99,'MYR','Malaysian Ringgit','RM',NULL,NULL),(100,'MZN','Mozambican Metical','MT',NULL,NULL),(101,'NAD','Namibian Dollar','$',NULL,NULL),(102,'NGN','Nigerian Naira','₦',NULL,NULL),(103,'NIO','Nicaraguan córdoba','C$',NULL,NULL),(104,'NOK','Norwegian krone','kr',NULL,NULL),(105,'NPR','Nepalese Rupee','Rs',NULL,NULL),(106,'NZD','New Zealand Dollar','$',NULL,NULL),(107,'OMR','Omani Rial','ع.ر.',NULL,NULL),(108,'PAB','Balboa panamérn','B/',NULL,NULL),(109,'PEN','Peruvian nuevo sol','S/',NULL,NULL),(110,'PGK','Papua New Guinean Kina','K',NULL,NULL),(111,'PHP','Philippine Peso','₱',NULL,NULL),(112,'PKR','Pakistani Rupee','Rs',NULL,NULL),(113,'PLN','Polish złoty','zł',NULL,NULL),(114,'PYG','Paraguayan guarani','₲',NULL,NULL),(115,'QAR','Qatari Riyal','ق.ر ',NULL,NULL),(116,'RON','Romanian leu','lei',NULL,NULL),(117,'RSD','Serbian Dinar','РСД',NULL,NULL),(118,'RWF','Rwandan franc','FRw, RF, R₣',NULL,NULL),(119,'SAR','Saudi Arabian Riyal','ر.س',NULL,NULL),(120,'SBD','Solomon Islander Dollar','SI$',NULL,NULL),(121,'SCR','Seychellois Rupee','Rs',NULL,NULL),(122,'SDG','Sudanese Pound','',NULL,NULL),(123,'SEK','Swedish krona','kr',NULL,NULL),(124,'SGD','Singapore Dollar','$',NULL,NULL),(125,'SLL','Sierra Leonean Leone','Le',NULL,NULL),(126,'SOS','Somali Shilling','S',NULL,NULL),(127,'SRD','Surinamese dollar','$',NULL,NULL),(128,'SSP','South Sudanese pound','£',NULL,NULL),(129,'SYP','Syrian Pound','£',NULL,NULL),(130,'SZL','Swazi Lilangeni','L or E',NULL,NULL),(131,'THB','Thai Baht','฿',NULL,NULL),(132,'TJS','Tajikistani somoni','',NULL,NULL),(133,'TMT','Turkmenistan manat','T',NULL,NULL),(134,'TND','Tunisian Dinar','',NULL,NULL),(135,'TOP','Tongan Pa\'anga','T$',NULL,NULL),(136,'TRY','Turkish Lira','',NULL,NULL),(137,'TTD','Trinidadian dollar','TT$',NULL,NULL),(138,'TWD','Taiwan New Dollar','NT$',NULL,NULL),(139,'TZS','Tanzanian Shilling','Sh',NULL,NULL),(140,'UAH','Ukrainian Hryvnia','₴',NULL,NULL),(141,'UGX','Ugandan Shilling','USh',NULL,NULL),(142,'UYU','Uruguayan peso','$U',NULL,NULL),(143,'UZS','Uzbekistani som','лв',NULL,NULL),(144,'VEF','Venezuelan bolivar','Bs',NULL,NULL),(145,'VND','Vietnamese Dong','₫',NULL,NULL),(146,'VUV','Ni-Vanuatu Vatu','VT',NULL,NULL),(147,'WST','Samoan Tālā','$',NULL,NULL),(148,'XCD','East Caribbean dollar','EC$',NULL,NULL),(149,'XOF','CFA Franc','',NULL,NULL),(150,'XPF','CFP Franc','',NULL,NULL),(151,'YER','Yemeni Rial','',NULL,NULL),(152,'ZMW','Zambian Kwacha','ZMK',NULL,NULL),(153,'ZWD','Zimbabwean Dollar','Z$',NULL,NULL);

--
-- Table structure for table `days`
--

CREATE TABLE `days` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `date` date NOT NULL,
  `rate` int(11) NOT NULL,
  `comment` mediumtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `days_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `days_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `days`
--


--
-- Table structure for table `debts`
--

CREATE TABLE `debts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `in_debt` varchar(255) NOT NULL DEFAULT 'no',
  `status` varchar(255) NOT NULL DEFAULT 'inprogress',
  `amount` int(11) NOT NULL,
  `currency_id` int(10) unsigned DEFAULT NULL,
  `reason` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `debts_contact_id_foreign` (`contact_id`),
  KEY `debts_currency_id_foreign` (`currency_id`),
  KEY `debts_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `debts_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `debts_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `debts_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `debts`
--


--
-- Table structure for table `default_activity_type_categories`
--

CREATE TABLE `default_activity_type_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `translation_key` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `default_activity_type_categories`
--

INSERT INTO `default_activity_type_categories` VALUES (1,'simple_activities','2024-01-02 23:40:49','2024-01-02 23:40:49'),(2,'sport','2024-01-02 23:40:49','2024-01-02 23:40:49'),(3,'food','2024-01-02 23:40:49','2024-01-02 23:40:49'),(4,'cultural_activities','2024-01-02 23:40:49','2024-01-02 23:40:49');

--
-- Table structure for table `default_activity_types`
--

CREATE TABLE `default_activity_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `default_activity_type_category_id` int(11) NOT NULL,
  `translation_key` varchar(255) NOT NULL,
  `location_type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `default_activity_types`
--

INSERT INTO `default_activity_types` VALUES (1,1,'just_hung_out','outside','2024-01-02 23:40:49','2024-01-02 23:40:49'),(2,1,'watched_movie_at_home','my_place','2024-01-02 23:40:49','2024-01-02 23:40:49'),(3,1,'talked_at_home','my_place','2024-01-02 23:40:49','2024-01-02 23:40:49'),(4,2,'did_sport_activities_together','outside','2024-01-02 23:40:49','2024-01-02 23:40:49'),(5,3,'ate_at_his_place','his_place','2024-01-02 23:40:49','2024-01-02 23:40:49'),(6,3,'went_bar','outside','2024-01-02 23:40:49','2024-01-02 23:40:49'),(7,3,'ate_at_home','my_place','2024-01-02 23:40:49','2024-01-02 23:40:49'),(8,3,'picnicked','outside','2024-01-02 23:40:49','2024-01-02 23:40:49'),(9,3,'ate_restaurant','outside','2024-01-02 23:40:49','2024-01-02 23:40:49'),(10,4,'went_theater','outside','2024-01-02 23:40:49','2024-01-02 23:40:49'),(11,4,'went_concert','outside','2024-01-02 23:40:49','2024-01-02 23:40:49'),(12,4,'went_play','outside','2024-01-02 23:40:49','2024-01-02 23:40:49'),(13,4,'went_museum','outside','2024-01-02 23:40:49','2024-01-02 23:40:49');

--
-- Table structure for table `default_contact_field_types`
--

CREATE TABLE `default_contact_field_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `fontawesome_icon` varchar(255) DEFAULT NULL,
  `protocol` varchar(255) DEFAULT NULL,
  `migrated` tinyint(1) NOT NULL DEFAULT 0,
  `delible` tinyint(1) NOT NULL DEFAULT 1,
  `type` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `default_contact_field_types`
--

INSERT INTO `default_contact_field_types` VALUES (1,'Email','fa fa-envelope-open-o','mailto:',1,0,'email',NULL,NULL),(2,'Phone','fa fa-volume-control-phone','tel:',1,0,'phone',NULL,NULL),(3,'Facebook','fa fa-facebook-official','https://facebook.com/',1,1,NULL,NULL,NULL),(4,'Twitter','fa fa-twitter-square',NULL,1,1,NULL,NULL,NULL),(5,'Whatsapp','fa fa-whatsapp','https://wa.me/',1,1,NULL,NULL,NULL),(6,'Telegram','fa fa-telegram','telegram:',1,1,NULL,NULL,NULL),(7,'LinkedIn','fa fa-linkedin-square',NULL,1,1,NULL,NULL,NULL);

--
-- Table structure for table `default_life_event_categories`
--

CREATE TABLE `default_life_event_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `translation_key` varchar(255) NOT NULL,
  `migrated` 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=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `default_life_event_categories`
--

INSERT INTO `default_life_event_categories` VALUES (1,'work_education',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(2,'family_relationships',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(3,'home_living',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(4,'health_wellness',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(5,'travel_experiences',1,'2024-01-02 23:40:50','2024-01-02 23:40:50');

--
-- Table structure for table `default_life_event_types`
--

CREATE TABLE `default_life_event_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `default_life_event_category_id` int(10) unsigned NOT NULL,
  `translation_key` varchar(255) NOT NULL,
  `specific_information_structure` text DEFAULT NULL,
  `migrated` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `default_life_event_types_default_life_event_category_id_foreign` (`default_life_event_category_id`),
  CONSTRAINT `default_life_event_types_default_life_event_category_id_foreign` FOREIGN KEY (`default_life_event_category_id`) REFERENCES `default_life_event_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `default_life_event_types`
--

INSERT INTO `default_life_event_types` VALUES (1,1,'new_job','{\"employer\": {\"type\": \"string\", \"value\": \"\"}, \"job_title\": {\"type\": \"string\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(2,1,'retirement','{\"profession\": {\"type\": \"string\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(3,1,'new_school','{\"degree\": {\"type\": \"string\", \"value\": \"\"}, \"end_date\": {\"type\": \"date\", \"value\": \"\"}, \"end_date_reminder_id\": {\"type\": \"integer\", \"value\": \"\"}, \"school_name\": {\"type\": \"string\", \"value\": \"\"}, \"studying\": {\"type\": \"string\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(4,1,'study_abroad','{\"degree\": {\"type\": \"string\", \"value\": \"\"}, \"end_date\": {\"type\": \"date\", \"value\": \"\"}, \"end_date_reminder_id\": {\"type\": \"integer\", \"value\": \"\"}, \"school_name\": {\"type\": \"string\", \"value\": \"\"}, \"studying\": {\"type\": \"string\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(5,1,'volunteer_work','{\"organization\": {\"type\": \"string\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(6,1,'published_book_or_paper','{\"full_citation\": {\"type\": \"string\", \"value\": \"\"}, \"url\": {\"type\": \"string\", \"value\": \"\"}, \"citation\": {\"type\": \"string\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(7,1,'military_service','{\"end_date\": {\"type\": \"date\", \"value\": \"\"}, \"end_date_reminder_id\": {\"type\": \"integer\", \"value\": \"\"}, \"branch\": {\"type\": \"string\", \"value\": \"\"}, \"division\": {\"type\": \"string\", \"value\": \"\"}, \"country\": {\"type\": \"string\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(8,2,'new_relationship',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(9,2,'engagement','{\"with_contact_id\": {\"type\": \"integer\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(10,2,'marriage','{\"with_contact_id\": {\"type\": \"integer\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(11,2,'anniversary',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(12,2,'expecting_a_baby','{\"contact_id\": {\"type\": \"integer\", \"value\": \"\"}, \"expected_date\": {\"type\": \"date\", \"value\": \"\"}, \"expected_date_reminder_id\": {\"type\": \"integer\", \"value\": \"\"}, \"expected_gender\": {\"type\": \"string\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(13,2,'new_child',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(14,2,'new_family_member',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(15,2,'new_pet',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(16,2,'end_of_relationship','{\"breakup_reason\": {\"type\": \"string\", \"value\": \"\"}, \"who_broke_up_contact_id\": {\"type\": \"integer\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(17,2,'loss_of_a_loved_one',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(18,3,'moved','{\"where_to\": {\"type\": \"string\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(19,3,'bought_a_home','{\"address\": {\"type\": \"string\", \"value\": \"\"}, \"estimated_value\": {\"type\": \"number\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(20,3,'home_improvement',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(21,3,'holidays','{\"where\": {\"type\": \"string\", \"value\": \"\"}, \"duration_in_days\": {\"type\": \"integer\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(22,3,'new_vehicle','{\"type\": {\"type\": \"string\", \"value\": \"\"}, \"model\": {\"type\": \"string\", \"value\": \"\"}, \"model_year\": {\"type\": \"string\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(23,3,'new_roommate','{\"contact_id\": {\"type\": \"string\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(24,4,'overcame_an_illness',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(25,4,'quit_a_habit',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(26,4,'new_eating_habits',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(27,4,'weight_loss','{\"amount\": {\"type\": \"string\", \"value\": \"\"}, \"unit\": {\"type\": \"string\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(28,4,'wear_glass_or_contact',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(29,4,'broken_bone',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(30,4,'removed_braces',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(31,4,'surgery','{\"nature\": {\"type\": \"string\", \"value\": \"\"}, \"number_days_in_hospital\": {\"type\": \"integer\", \"value\": \"\"}, \"number_days_in_hospital\": {\"type\": \"integer\", \"value\": \"\"}, \"expected_date_out_of_hospital_reminder_id\": {\"type\": \"integer\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(32,4,'dentist',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(33,5,'new_sport',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(34,5,'new_hobby',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(35,5,'new_instrument',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(36,5,'new_language',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(37,5,'tattoo_or_piercing',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(38,5,'new_license',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(39,5,'travel','{\"visited_place\": {\"type\": \"string\", \"value\": \"\"}, \"duration_in_days\": {\"type\": \"integer\", \"value\": \"\"}}',1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(40,5,'achievement_or_award',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(41,5,'changed_beliefs',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(42,5,'first_word',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50'),(43,5,'first_kiss',NULL,1,'2024-01-02 23:40:50','2024-01-02 23:40:50');

--
-- Table structure for table `default_relationship_type_groups`
--

CREATE TABLE `default_relationship_type_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `delible` tinyint(1) NOT NULL DEFAULT 0,
  `migrated` 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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `default_relationship_type_groups`
--

INSERT INTO `default_relationship_type_groups` VALUES (1,'love',0,1,NULL,NULL),(2,'family',0,1,NULL,NULL),(3,'friend',0,1,NULL,NULL),(4,'work',0,1,NULL,NULL);

--
-- Table structure for table `default_relationship_types`
--

CREATE TABLE `default_relationship_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `name_reverse_relationship` varchar(255) NOT NULL,
  `relationship_type_group_id` int(11) NOT NULL,
  `delible` tinyint(1) NOT NULL DEFAULT 0,
  `migrated` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `default_relationship_types_migrated_index` (`migrated`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `default_relationship_types`
--

INSERT INTO `default_relationship_types` VALUES (1,'partner','partner',1,0,1,NULL,NULL),(2,'spouse','spouse',1,0,1,NULL,NULL),(3,'date','date',1,0,1,NULL,NULL),(4,'lover','lover',1,0,1,NULL,NULL),(5,'inlovewith','lovedby',1,0,1,NULL,NULL),(6,'lovedby','inlovewith',1,0,1,NULL,NULL),(7,'ex','ex',1,0,1,NULL,NULL),(8,'parent','child',2,0,1,NULL,NULL),(9,'child','parent',2,0,1,NULL,NULL),(10,'sibling','sibling',2,0,1,NULL,NULL),(11,'grandparent','grandchild',2,0,1,NULL,NULL),(12,'grandchild','grandparent',2,0,1,NULL,NULL),(13,'uncle','nephew',2,0,1,NULL,NULL),(14,'nephew','uncle',2,0,1,NULL,NULL),(15,'cousin','cousin',2,0,1,NULL,NULL),(16,'godfather','godson',2,0,1,NULL,NULL),(17,'godson','godfather',2,0,1,NULL,NULL),(18,'friend','friend',3,0,1,NULL,NULL),(19,'bestfriend','bestfriend',3,0,1,NULL,NULL),(20,'colleague','colleague',4,0,1,NULL,NULL),(21,'boss','subordinate',4,0,1,NULL,NULL),(22,'subordinate','boss',4,0,1,NULL,NULL),(23,'mentor','protege',4,0,1,NULL,NULL),(24,'protege','mentor',4,0,1,NULL,NULL),(25,'ex_husband','ex_husband',1,0,1,NULL,NULL),(26,'stepparent','stepchild',2,0,1,NULL,NULL),(27,'stepchild','stepparent',2,0,1,NULL,NULL);

--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `original_filename` varchar(255) NOT NULL,
  `new_filename` varchar(255) NOT NULL,
  `filesize` int(11) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `mime_type` varchar(255) DEFAULT NULL,
  `number_of_downloads` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `documents_contact_id_foreign` (`contact_id`),
  KEY `documents_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `documents_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `documents_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `documents`
--


--
-- Table structure for table `emotion_activity`
--

CREATE TABLE `emotion_activity` (
  `account_id` int(10) unsigned NOT NULL,
  `activity_id` int(10) unsigned NOT NULL,
  `emotion_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `emotion_activity_account_id_foreign` (`account_id`),
  KEY `emotion_activity_activity_id_foreign` (`activity_id`),
  KEY `emotion_activity_emotion_id_foreign` (`emotion_id`),
  CONSTRAINT `emotion_activity_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `emotion_activity_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `activities` (`id`) ON DELETE CASCADE,
  CONSTRAINT `emotion_activity_emotion_id_foreign` FOREIGN KEY (`emotion_id`) REFERENCES `emotions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `emotion_activity`
--


--
-- Table structure for table `emotion_call`
--

CREATE TABLE `emotion_call` (
  `account_id` int(10) unsigned NOT NULL,
  `call_id` int(10) unsigned NOT NULL,
  `emotion_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `emotion_call_account_id_foreign` (`account_id`),
  KEY `emotion_call_call_id_foreign` (`call_id`),
  KEY `emotion_call_emotion_id_foreign` (`emotion_id`),
  KEY `emotion_call_contact_id_foreign` (`contact_id`),
  CONSTRAINT `emotion_call_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `emotion_call_call_id_foreign` FOREIGN KEY (`call_id`) REFERENCES `calls` (`id`) ON DELETE CASCADE,
  CONSTRAINT `emotion_call_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `emotion_call_emotion_id_foreign` FOREIGN KEY (`emotion_id`) REFERENCES `emotions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `emotion_call`
--


--
-- Table structure for table `emotions`
--

CREATE TABLE `emotions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `emotion_primary_id` int(10) unsigned NOT NULL,
  `emotion_secondary_id` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `emotions_emotion_primary_id_foreign` (`emotion_primary_id`),
  KEY `emotions_emotion_secondary_id_foreign` (`emotion_secondary_id`),
  CONSTRAINT `emotions_emotion_primary_id_foreign` FOREIGN KEY (`emotion_primary_id`) REFERENCES `emotions_primary` (`id`) ON DELETE CASCADE,
  CONSTRAINT `emotions_emotion_secondary_id_foreign` FOREIGN KEY (`emotion_secondary_id`) REFERENCES `emotions_secondary` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `emotions`
--

INSERT INTO `emotions` VALUES (1,1,1,'adoration',NULL,NULL),(2,1,1,'affection',NULL,NULL),(3,1,1,'love',NULL,NULL),(4,1,1,'fondness',NULL,NULL),(5,1,1,'liking',NULL,NULL),(6,1,1,'attraction',NULL,NULL),(7,1,1,'caring',NULL,NULL),(8,1,1,'tenderness',NULL,NULL),(9,1,1,'compassion',NULL,NULL),(10,1,1,'sentimentality',NULL,NULL),(11,1,2,'arousal',NULL,NULL),(12,1,2,'desire',NULL,NULL),(13,1,2,'lust',NULL,NULL),(14,1,2,'passion',NULL,NULL),(15,1,2,'infatuation',NULL,NULL),(16,1,3,'longing',NULL,NULL),(17,2,4,'amusement',NULL,NULL),(18,2,4,'bliss',NULL,NULL),(19,2,4,'cheerfulness',NULL,NULL),(20,2,4,'gaiety',NULL,NULL),(21,2,4,'glee',NULL,NULL),(22,2,4,'jolliness',NULL,NULL),(23,2,4,'joviality',NULL,NULL),(24,2,4,'joy',NULL,NULL),(25,2,4,'delight',NULL,NULL),(26,2,4,'enjoyment',NULL,NULL),(27,2,4,'gladness',NULL,NULL),(28,2,4,'happiness',NULL,NULL),(29,2,4,'jubilation',NULL,NULL),(30,2,4,'elation',NULL,NULL),(31,2,4,'satisfaction',NULL,NULL),(32,2,4,'ecstasy',NULL,NULL),(33,2,4,'euphoria',NULL,NULL),(34,2,5,'enthusiasm',NULL,NULL),(35,2,5,'zeal',NULL,NULL),(36,2,5,'zest',NULL,NULL),(37,2,5,'excitement',NULL,NULL),(38,2,5,'thrill',NULL,NULL),(39,2,5,'exhilaration',NULL,NULL),(40,2,6,'contentment',NULL,NULL),(41,2,6,'pleasure',NULL,NULL),(42,2,7,'pride',NULL,NULL),(43,2,7,'pleasure',NULL,NULL),(44,2,8,'eagerness',NULL,NULL),(45,2,8,'hope',NULL,NULL),(46,2,9,'enthrallment',NULL,NULL),(47,2,9,'rapture',NULL,NULL),(48,2,10,'relief',NULL,NULL),(49,3,11,'amazement',NULL,NULL),(50,3,11,'surprise',NULL,NULL),(51,3,11,'astonishment',NULL,NULL),(52,4,12,'aggravation',NULL,NULL),(53,4,12,'irritation',NULL,NULL),(54,4,12,'agitation',NULL,NULL),(55,4,12,'annoyance',NULL,NULL),(56,4,12,'grouchiness',NULL,NULL),(57,4,12,'grumpiness',NULL,NULL),(58,4,13,'exasperation',NULL,NULL),(59,4,13,'frustration',NULL,NULL),(60,4,14,'anger',NULL,NULL),(61,4,14,'rage',NULL,NULL),(62,4,14,'outrage',NULL,NULL),(63,4,14,'fury',NULL,NULL),(64,4,14,'wrath',NULL,NULL),(65,4,14,'hostility',NULL,NULL),(66,4,14,'ferocity',NULL,NULL),(67,4,14,'bitterness',NULL,NULL),(68,4,14,'hate',NULL,NULL),(69,4,14,'loathing',NULL,NULL),(70,4,14,'scorn',NULL,NULL),(71,4,14,'spite',NULL,NULL),(72,4,14,'vengefulness',NULL,NULL),(73,4,14,'dislike',NULL,NULL),(74,4,14,'resentment',NULL,NULL),(75,4,15,'disgust',NULL,NULL),(76,4,15,'revulsion',NULL,NULL),(77,4,15,'contempt',NULL,NULL),(78,4,16,'envy',NULL,NULL),(79,4,16,'jealousy',NULL,NULL),(80,5,17,'agony',NULL,NULL),(81,5,17,'suffering',NULL,NULL),(82,5,17,'hurt',NULL,NULL),(83,5,17,'anguish',NULL,NULL),(84,5,18,'depression',NULL,NULL),(85,5,18,'despair',NULL,NULL),(86,5,18,'hopelessness',NULL,NULL),(87,5,18,'gloom',NULL,NULL),(88,5,18,'glumness',NULL,NULL),(89,5,18,'sadness',NULL,NULL),(90,5,18,'unhappiness',NULL,NULL),(91,5,18,'grief',NULL,NULL),(92,5,18,'sorrow',NULL,NULL),(93,5,18,'woe',NULL,NULL),(94,5,18,'misery',NULL,NULL),(95,5,18,'melancholy',NULL,NULL),(96,5,19,'dismay',NULL,NULL),(97,5,19,'disappointment',NULL,NULL),(98,5,19,'displeasure',NULL,NULL),(99,5,20,'guilt',NULL,NULL),(100,5,20,'shame',NULL,NULL),(101,5,20,'regret',NULL,NULL),(102,5,20,'remorse',NULL,NULL),(103,5,21,'alienation',NULL,NULL),(104,5,21,'isolation',NULL,NULL),(105,5,21,'neglect',NULL,NULL),(106,5,21,'loneliness',NULL,NULL),(107,5,21,'rejection',NULL,NULL),(108,5,21,'homesickness',NULL,NULL),(109,5,21,'defeat',NULL,NULL),(110,5,21,'dejection',NULL,NULL),(111,5,21,'insecurity',NULL,NULL),(112,5,21,'embarrassment',NULL,NULL),(113,5,21,'humiliation',NULL,NULL),(114,5,21,'insult',NULL,NULL),(115,5,22,'pity',NULL,NULL),(116,5,22,'sympathy',NULL,NULL),(117,6,23,'alarm',NULL,NULL),(118,6,23,'shock',NULL,NULL),(119,6,23,'fear',NULL,NULL),(120,6,23,'fright',NULL,NULL),(121,6,23,'horror',NULL,NULL),(122,6,23,'terror',NULL,NULL),(123,6,23,'panic',NULL,NULL),(124,6,23,'hysteria',NULL,NULL),(125,6,23,'mortification',NULL,NULL),(126,6,24,'anxiety',NULL,NULL),(127,6,24,'nervousness',NULL,NULL),(128,6,24,'tenseness',NULL,NULL),(129,6,24,'uneasiness',NULL,NULL),(130,6,24,'apprehension',NULL,NULL),(131,6,24,'worry',NULL,NULL),(132,6,24,'distress',NULL,NULL),(133,6,24,'dread',NULL,NULL);

--
-- Table structure for table `emotions_primary`
--

CREATE TABLE `emotions_primary` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `emotions_primary`
--

INSERT INTO `emotions_primary` VALUES (1,'love',NULL,NULL),(2,'joy',NULL,NULL),(3,'surprise',NULL,NULL),(4,'anger',NULL,NULL),(5,'sadness',NULL,NULL),(6,'fear',NULL,NULL);

--
-- Table structure for table `emotions_secondary`
--

CREATE TABLE `emotions_secondary` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `emotion_primary_id` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `emotions_secondary_emotion_primary_id_foreign` (`emotion_primary_id`),
  CONSTRAINT `emotions_secondary_emotion_primary_id_foreign` FOREIGN KEY (`emotion_primary_id`) REFERENCES `emotions_primary` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `emotions_secondary`
--

INSERT INTO `emotions_secondary` VALUES (1,1,'affection',NULL,NULL),(2,1,'lust',NULL,NULL),(3,1,'longing',NULL,NULL),(4,2,'cheerfulness',NULL,NULL),(5,2,'zest',NULL,NULL),(6,2,'contentment',NULL,NULL),(7,2,'pride',NULL,NULL),(8,2,'optimism',NULL,NULL),(9,2,'enthrallment',NULL,NULL),(10,2,'relief',NULL,NULL),(11,3,'surprise',NULL,NULL),(12,4,'irritation',NULL,NULL),(13,4,'exasperation',NULL,NULL),(14,4,'rage',NULL,NULL),(15,4,'disgust',NULL,NULL),(16,4,'envy',NULL,NULL),(17,5,'suffering',NULL,NULL),(18,5,'sadness',NULL,NULL),(19,5,'disappointment',NULL,NULL),(20,5,'shame',NULL,NULL),(21,5,'neglect',NULL,NULL),(22,5,'sympathy',NULL,NULL),(23,6,'horror',NULL,NULL),(24,6,'nervousness',NULL,NULL);

--
-- Table structure for table `entries`
--

CREATE TABLE `entries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `post` longtext NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `entries_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `entries_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `entries`
--


--
-- Table structure for table `export_jobs`
--

CREATE TABLE `export_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `type` varchar(4) NOT NULL,
  `status` varchar(6) DEFAULT NULL,
  `location` varchar(6) DEFAULT NULL,
  `filename` varchar(256) DEFAULT NULL,
  `started_at` datetime DEFAULT NULL,
  `ended_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `export_jobs_account_id_foreign` (`account_id`),
  KEY `export_jobs_user_id_foreign` (`user_id`),
  KEY `export_jobs_uuid_index` (`uuid`),
  CONSTRAINT `export_jobs_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `export_jobs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `export_jobs`
--


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `genders`
--

CREATE TABLE `genders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` char(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `genders_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `genders_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `genders`
--

INSERT INTO `genders` VALUES (1,NULL,1,'Man','M','2024-01-02 23:41:17','2024-01-02 23:41:17'),(2,NULL,1,'Woman','F','2024-01-02 23:41:17','2024-01-02 23:41:17'),(3,NULL,1,'Rather not say','O','2024-01-02 23:41:17','2024-01-02 23:41:17'),(4,NULL,2,'Man','M','2024-01-02 23:41:18','2024-01-02 23:41:18'),(5,NULL,2,'Woman','F','2024-01-02 23:41:18','2024-01-02 23:41:18'),(6,NULL,2,'Rather not say','O','2024-01-02 23:41:18','2024-01-02 23:41:18'),(7,'36ee5ef0-bbf8-4536-a7c2-f923d9ad9f78',3,'Man','M','2024-01-02 23:41:19','2024-01-03 01:06:09'),(8,'30d56c45-eb05-4d46-adc1-3bbbf9129f06',3,'Woman','F','2024-01-02 23:41:19','2024-01-03 01:27:24'),(9,'9e5b768f-4db1-4cb4-bb56-3c45d16fab50',3,'Non-binary','O','2024-01-02 23:41:19','2024-01-03 01:20:04');

--
-- Table structure for table `gift_photo`
--

CREATE TABLE `gift_photo` (
  `photo_id` int(10) unsigned NOT NULL,
  `gift_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`photo_id`,`gift_id`),
  KEY `gift_photo_gift_id_foreign` (`gift_id`),
  CONSTRAINT `gift_photo_gift_id_foreign` FOREIGN KEY (`gift_id`) REFERENCES `gifts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `gift_photo_photo_id_foreign` FOREIGN KEY (`photo_id`) REFERENCES `photos` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gift_photo`
--


--
-- Table structure for table `gifts`
--

CREATE TABLE `gifts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `is_for` int(10) unsigned DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `comment` longtext DEFAULT NULL,
  `url` longtext DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `currency_id` int(10) unsigned DEFAULT NULL,
  `status` varchar(8) NOT NULL DEFAULT 'idea',
  `date` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `gifts_contact_id_foreign` (`contact_id`),
  KEY `gifts_is_for_foreign` (`is_for`),
  KEY `gifts_currency_id_foreign` (`currency_id`),
  KEY `gifts_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `gifts_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `gifts_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `gifts_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE SET NULL,
  CONSTRAINT `gifts_is_for_foreign` FOREIGN KEY (`is_for`) REFERENCES `contacts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gifts`
--


--
-- Table structure for table `import_job_reports`
--

CREATE TABLE `import_job_reports` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `import_job_id` int(10) unsigned NOT NULL,
  `contact_information` mediumtext NOT NULL,
  `skipped` tinyint(1) NOT NULL,
  `skip_reason` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `import_job_reports_account_id_foreign` (`account_id`),
  KEY `import_job_reports_user_id_foreign` (`user_id`),
  KEY `import_job_reports_import_job_id_foreign` (`import_job_id`),
  CONSTRAINT `import_job_reports_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `import_job_reports_import_job_id_foreign` FOREIGN KEY (`import_job_id`) REFERENCES `import_jobs` (`id`) ON DELETE CASCADE,
  CONSTRAINT `import_job_reports_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `import_job_reports`
--


--
-- Table structure for table `import_jobs`
--

CREATE TABLE `import_jobs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `type` varchar(255) NOT NULL DEFAULT 'vcard',
  `contacts_found` int(11) DEFAULT NULL,
  `contacts_skipped` int(11) DEFAULT NULL,
  `contacts_imported` int(11) DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `started_at` date DEFAULT NULL,
  `ended_at` date DEFAULT NULL,
  `failed` tinyint(1) NOT NULL DEFAULT 0,
  `failed_reason` mediumtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `import_jobs_account_id_foreign` (`account_id`),
  KEY `import_jobs_user_id_foreign` (`user_id`),
  CONSTRAINT `import_jobs_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `import_jobs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `import_jobs`
--


--
-- Table structure for table `instances`
--

CREATE TABLE `instances` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `current_version` varchar(255) NOT NULL,
  `latest_version` varchar(255) DEFAULT NULL,
  `latest_release_notes` mediumtext DEFAULT NULL,
  `number_of_versions_since_current_version` int(11) DEFAULT NULL,
  `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;

--
-- Dumping data for table `instances`
--

INSERT INTO `instances` VALUES (1,'2158cf85-628a-41c8-b927-c2dfcbdd0150','','',NULL,NULL,'2024-01-02 23:40:46','2024-01-02 23:40:46');

--
-- Table structure for table `invitations`
--

CREATE TABLE `invitations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `invited_by_user_id` int(10) unsigned NOT NULL,
  `email` varchar(255) NOT NULL,
  `invitation_key` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invitations_account_id_foreign` (`account_id`),
  KEY `invitations_invited_by_user_id_foreign` (`invited_by_user_id`),
  CONSTRAINT `invitations_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invitations_invited_by_user_id_foreign` FOREIGN KEY (`invited_by_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invitations`
--


--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` text NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_batches`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_reserved_at_index` (`queue`,`reserved_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `journal_entries`
--

CREATE TABLE `journal_entries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `date` datetime NOT NULL,
  `journalable_id` int(11) NOT NULL,
  `journalable_type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `journal_entries_account_id_foreign` (`account_id`),
  CONSTRAINT `journal_entries_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `journal_entries`
--


--
-- Table structure for table `life_event_categories`
--

CREATE TABLE `life_event_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `default_life_event_category_key` varchar(255) DEFAULT NULL,
  `core_monica_data` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `life_event_categories_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `life_event_categories_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `life_event_categories`
--

INSERT INTO `life_event_categories` VALUES (1,NULL,1,'Work & education','work_education',1,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(2,NULL,1,'Family & relationships','family_relationships',1,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(3,NULL,1,'Home & living','home_living',1,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(4,NULL,1,'Health & wellness','health_wellness',1,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(5,NULL,1,'Travel & experiences','travel_experiences',1,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(6,NULL,2,'Work & education','work_education',1,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(7,NULL,2,'Family & relationships','family_relationships',1,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(8,NULL,2,'Home & living','home_living',1,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(9,NULL,2,'Health & wellness','health_wellness',1,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(10,NULL,2,'Travel & experiences','travel_experiences',1,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(11,NULL,3,'Work & education','work_education',1,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(12,NULL,3,'Family & relationships','family_relationships',1,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(13,NULL,3,'Home & living','home_living',1,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(14,NULL,3,'Health & wellness','health_wellness',1,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(15,NULL,3,'Travel & experiences','travel_experiences',1,'2024-01-02 23:41:20','2024-01-02 23:41:20');

--
-- Table structure for table `life_event_types`
--

CREATE TABLE `life_event_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `life_event_category_id` int(10) unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `default_life_event_type_key` varchar(255) DEFAULT NULL,
  `core_monica_data` tinyint(1) NOT NULL DEFAULT 0,
  `specific_information_structure` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `life_event_types_life_event_category_id_foreign` (`life_event_category_id`),
  KEY `life_event_types_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `life_event_types_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `life_event_types_life_event_category_id_foreign` FOREIGN KEY (`life_event_category_id`) REFERENCES `life_event_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `life_event_types`
--

INSERT INTO `life_event_types` VALUES (1,NULL,1,1,NULL,'new_job',1,'{\"employer\": {\"type\": \"string\", \"value\": \"\"}, \"job_title\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(2,NULL,1,1,NULL,'retirement',1,'{\"profession\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(3,NULL,1,1,NULL,'new_school',1,'{\"degree\": {\"type\": \"string\", \"value\": \"\"}, \"end_date\": {\"type\": \"date\", \"value\": \"\"}, \"end_date_reminder_id\": {\"type\": \"integer\", \"value\": \"\"}, \"school_name\": {\"type\": \"string\", \"value\": \"\"}, \"studying\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(4,NULL,1,1,NULL,'study_abroad',1,'{\"degree\": {\"type\": \"string\", \"value\": \"\"}, \"end_date\": {\"type\": \"date\", \"value\": \"\"}, \"end_date_reminder_id\": {\"type\": \"integer\", \"value\": \"\"}, \"school_name\": {\"type\": \"string\", \"value\": \"\"}, \"studying\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(5,NULL,1,1,NULL,'volunteer_work',1,'{\"organization\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(6,NULL,1,1,NULL,'published_book_or_paper',1,'{\"full_citation\": {\"type\": \"string\", \"value\": \"\"}, \"url\": {\"type\": \"string\", \"value\": \"\"}, \"citation\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(7,NULL,1,1,NULL,'military_service',1,'{\"end_date\": {\"type\": \"date\", \"value\": \"\"}, \"end_date_reminder_id\": {\"type\": \"integer\", \"value\": \"\"}, \"branch\": {\"type\": \"string\", \"value\": \"\"}, \"division\": {\"type\": \"string\", \"value\": \"\"}, \"country\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(8,NULL,1,2,NULL,'new_relationship',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(9,NULL,1,2,NULL,'engagement',1,'{\"with_contact_id\": {\"type\": \"integer\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(10,NULL,1,2,NULL,'marriage',1,'{\"with_contact_id\": {\"type\": \"integer\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(11,NULL,1,2,NULL,'anniversary',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(12,NULL,1,2,NULL,'expecting_a_baby',1,'{\"contact_id\": {\"type\": \"integer\", \"value\": \"\"}, \"expected_date\": {\"type\": \"date\", \"value\": \"\"}, \"expected_date_reminder_id\": {\"type\": \"integer\", \"value\": \"\"}, \"expected_gender\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(13,NULL,1,2,NULL,'new_child',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(14,NULL,1,2,NULL,'new_family_member',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(15,NULL,1,2,NULL,'new_pet',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(16,NULL,1,2,NULL,'end_of_relationship',1,'{\"breakup_reason\": {\"type\": \"string\", \"value\": \"\"}, \"who_broke_up_contact_id\": {\"type\": \"integer\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(17,NULL,1,2,NULL,'loss_of_a_loved_one',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(18,NULL,1,3,NULL,'moved',1,'{\"where_to\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(19,NULL,1,3,NULL,'bought_a_home',1,'{\"address\": {\"type\": \"string\", \"value\": \"\"}, \"estimated_value\": {\"type\": \"number\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(20,NULL,1,3,NULL,'home_improvement',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(21,NULL,1,3,NULL,'holidays',1,'{\"where\": {\"type\": \"string\", \"value\": \"\"}, \"duration_in_days\": {\"type\": \"integer\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(22,NULL,1,3,NULL,'new_vehicle',1,'{\"type\": {\"type\": \"string\", \"value\": \"\"}, \"model\": {\"type\": \"string\", \"value\": \"\"}, \"model_year\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(23,NULL,1,3,NULL,'new_roommate',1,'{\"contact_id\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(24,NULL,1,4,NULL,'overcame_an_illness',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(25,NULL,1,4,NULL,'quit_a_habit',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(26,NULL,1,4,NULL,'new_eating_habits',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(27,NULL,1,4,NULL,'weight_loss',1,'{\"amount\": {\"type\": \"string\", \"value\": \"\"}, \"unit\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(28,NULL,1,4,NULL,'wear_glass_or_contact',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(29,NULL,1,4,NULL,'broken_bone',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(30,NULL,1,4,NULL,'removed_braces',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(31,NULL,1,4,NULL,'surgery',1,'{\"nature\": {\"type\": \"string\", \"value\": \"\"}, \"number_days_in_hospital\": {\"type\": \"integer\", \"value\": \"\"}, \"number_days_in_hospital\": {\"type\": \"integer\", \"value\": \"\"}, \"expected_date_out_of_hospital_reminder_id\": {\"type\": \"integer\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(32,NULL,1,4,NULL,'dentist',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(33,NULL,1,5,NULL,'new_sport',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(34,NULL,1,5,NULL,'new_hobby',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(35,NULL,1,5,NULL,'new_instrument',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(36,NULL,1,5,NULL,'new_language',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(37,NULL,1,5,NULL,'tattoo_or_piercing',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(38,NULL,1,5,NULL,'new_license',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(39,NULL,1,5,NULL,'travel',1,'{\"visited_place\": {\"type\": \"string\", \"value\": \"\"}, \"duration_in_days\": {\"type\": \"integer\", \"value\": \"\"}}','2024-01-02 23:41:17','2024-01-02 23:41:17'),(40,NULL,1,5,NULL,'achievement_or_award',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(41,NULL,1,5,NULL,'changed_beliefs',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(42,NULL,1,5,NULL,'first_word',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(43,NULL,1,5,NULL,'first_kiss',1,NULL,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(44,NULL,2,6,NULL,'new_job',1,'{\"employer\": {\"type\": \"string\", \"value\": \"\"}, \"job_title\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(45,NULL,2,6,NULL,'retirement',1,'{\"profession\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(46,NULL,2,6,NULL,'new_school',1,'{\"degree\": {\"type\": \"string\", \"value\": \"\"}, \"end_date\": {\"type\": \"date\", \"value\": \"\"}, \"end_date_reminder_id\": {\"type\": \"integer\", \"value\": \"\"}, \"school_name\": {\"type\": \"string\", \"value\": \"\"}, \"studying\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(47,NULL,2,6,NULL,'study_abroad',1,'{\"degree\": {\"type\": \"string\", \"value\": \"\"}, \"end_date\": {\"type\": \"date\", \"value\": \"\"}, \"end_date_reminder_id\": {\"type\": \"integer\", \"value\": \"\"}, \"school_name\": {\"type\": \"string\", \"value\": \"\"}, \"studying\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(48,NULL,2,6,NULL,'volunteer_work',1,'{\"organization\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(49,NULL,2,6,NULL,'published_book_or_paper',1,'{\"full_citation\": {\"type\": \"string\", \"value\": \"\"}, \"url\": {\"type\": \"string\", \"value\": \"\"}, \"citation\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(50,NULL,2,6,NULL,'military_service',1,'{\"end_date\": {\"type\": \"date\", \"value\": \"\"}, \"end_date_reminder_id\": {\"type\": \"integer\", \"value\": \"\"}, \"branch\": {\"type\": \"string\", \"value\": \"\"}, \"division\": {\"type\": \"string\", \"value\": \"\"}, \"country\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(51,NULL,2,7,NULL,'new_relationship',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(52,NULL,2,7,NULL,'engagement',1,'{\"with_contact_id\": {\"type\": \"integer\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(53,NULL,2,7,NULL,'marriage',1,'{\"with_contact_id\": {\"type\": \"integer\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(54,NULL,2,7,NULL,'anniversary',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(55,NULL,2,7,NULL,'expecting_a_baby',1,'{\"contact_id\": {\"type\": \"integer\", \"value\": \"\"}, \"expected_date\": {\"type\": \"date\", \"value\": \"\"}, \"expected_date_reminder_id\": {\"type\": \"integer\", \"value\": \"\"}, \"expected_gender\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(56,NULL,2,7,NULL,'new_child',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(57,NULL,2,7,NULL,'new_family_member',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(58,NULL,2,7,NULL,'new_pet',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(59,NULL,2,7,NULL,'end_of_relationship',1,'{\"breakup_reason\": {\"type\": \"string\", \"value\": \"\"}, \"who_broke_up_contact_id\": {\"type\": \"integer\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(60,NULL,2,7,NULL,'loss_of_a_loved_one',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(61,NULL,2,8,NULL,'moved',1,'{\"where_to\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(62,NULL,2,8,NULL,'bought_a_home',1,'{\"address\": {\"type\": \"string\", \"value\": \"\"}, \"estimated_value\": {\"type\": \"number\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(63,NULL,2,8,NULL,'home_improvement',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(64,NULL,2,8,NULL,'holidays',1,'{\"where\": {\"type\": \"string\", \"value\": \"\"}, \"duration_in_days\": {\"type\": \"integer\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(65,NULL,2,8,NULL,'new_vehicle',1,'{\"type\": {\"type\": \"string\", \"value\": \"\"}, \"model\": {\"type\": \"string\", \"value\": \"\"}, \"model_year\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(66,NULL,2,8,NULL,'new_roommate',1,'{\"contact_id\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(67,NULL,2,9,NULL,'overcame_an_illness',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(68,NULL,2,9,NULL,'quit_a_habit',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(69,NULL,2,9,NULL,'new_eating_habits',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(70,NULL,2,9,NULL,'weight_loss',1,'{\"amount\": {\"type\": \"string\", \"value\": \"\"}, \"unit\": {\"type\": \"string\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(71,NULL,2,9,NULL,'wear_glass_or_contact',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(72,NULL,2,9,NULL,'broken_bone',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(73,NULL,2,9,NULL,'removed_braces',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(74,NULL,2,9,NULL,'surgery',1,'{\"nature\": {\"type\": \"string\", \"value\": \"\"}, \"number_days_in_hospital\": {\"type\": \"integer\", \"value\": \"\"}, \"number_days_in_hospital\": {\"type\": \"integer\", \"value\": \"\"}, \"expected_date_out_of_hospital_reminder_id\": {\"type\": \"integer\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(75,NULL,2,9,NULL,'dentist',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(76,NULL,2,10,NULL,'new_sport',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(77,NULL,2,10,NULL,'new_hobby',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(78,NULL,2,10,NULL,'new_instrument',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(79,NULL,2,10,NULL,'new_language',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(80,NULL,2,10,NULL,'tattoo_or_piercing',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(81,NULL,2,10,NULL,'new_license',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(82,NULL,2,10,NULL,'travel',1,'{\"visited_place\": {\"type\": \"string\", \"value\": \"\"}, \"duration_in_days\": {\"type\": \"integer\", \"value\": \"\"}}','2024-01-02 23:41:18','2024-01-02 23:41:18'),(83,NULL,2,10,NULL,'achievement_or_award',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(84,NULL,2,10,NULL,'changed_beliefs',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(85,NULL,2,10,NULL,'first_word',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(86,NULL,2,10,NULL,'first_kiss',1,NULL,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(87,NULL,3,11,NULL,'new_job',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(88,NULL,3,11,NULL,'retirement',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(89,NULL,3,11,NULL,'new_school',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(90,NULL,3,11,NULL,'study_abroad',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(91,NULL,3,11,NULL,'volunteer_work',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(92,NULL,3,11,NULL,'published_book_or_paper',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(93,NULL,3,11,NULL,'military_service',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(94,NULL,3,12,NULL,'new_relationship',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(95,NULL,3,12,NULL,'engagement',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(96,NULL,3,12,NULL,'marriage',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(97,NULL,3,12,NULL,'anniversary',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(98,NULL,3,12,NULL,'expecting_a_baby',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(99,NULL,3,12,NULL,'new_child',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(100,NULL,3,12,NULL,'new_family_member',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(101,NULL,3,12,NULL,'new_pet',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(102,NULL,3,12,NULL,'end_of_relationship',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(103,NULL,3,12,NULL,'loss_of_a_loved_one',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(104,NULL,3,13,NULL,'moved',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(105,NULL,3,13,NULL,'bought_a_home',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(106,NULL,3,13,NULL,'home_improvement',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(107,NULL,3,13,NULL,'holidays',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(108,NULL,3,13,NULL,'new_vehicle',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(109,NULL,3,13,NULL,'new_roommate',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(110,NULL,3,14,NULL,'overcame_an_illness',1,NULL,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(111,NULL,3,14,NULL,'quit_a_habit',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(112,NULL,3,14,NULL,'new_eating_habits',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(113,NULL,3,14,NULL,'weight_loss',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(114,NULL,3,14,NULL,'wear_glass_or_contact',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(115,NULL,3,14,NULL,'broken_bone',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(116,NULL,3,14,NULL,'removed_braces',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(117,NULL,3,14,NULL,'surgery',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(118,NULL,3,14,NULL,'dentist',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(119,NULL,3,15,NULL,'new_sport',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(120,NULL,3,15,NULL,'new_hobby',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(121,NULL,3,15,NULL,'new_instrument',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(122,NULL,3,15,NULL,'new_language',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(123,NULL,3,15,NULL,'tattoo_or_piercing',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(124,NULL,3,15,NULL,'new_license',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(125,NULL,3,15,NULL,'travel',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(126,NULL,3,15,NULL,'achievement_or_award',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(127,NULL,3,15,NULL,'changed_beliefs',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(128,NULL,3,15,NULL,'first_word',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20'),(129,NULL,3,15,NULL,'first_kiss',1,NULL,'2024-01-02 23:41:20','2024-01-02 23:41:20');

--
-- Table structure for table `life_events`
--

CREATE TABLE `life_events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `life_event_type_id` int(10) unsigned NOT NULL,
  `reminder_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `note` mediumtext DEFAULT NULL,
  `happened_at` datetime NOT NULL,
  `happened_at_month_unknown` tinyint(1) NOT NULL DEFAULT 0,
  `happened_at_day_unknown` tinyint(1) NOT NULL DEFAULT 0,
  `specific_information` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `life_events_contact_id_foreign` (`contact_id`),
  KEY `life_events_life_event_type_id_foreign` (`life_event_type_id`),
  KEY `life_events_reminder_id_foreign` (`reminder_id`),
  KEY `life_events_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `life_events_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `life_events_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `life_events_life_event_type_id_foreign` FOREIGN KEY (`life_event_type_id`) REFERENCES `life_event_types` (`id`) ON DELETE CASCADE,
  CONSTRAINT `life_events_reminder_id_foreign` FOREIGN KEY (`reminder_id`) REFERENCES `reminders` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `life_events`
--


--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `conversation_id` int(10) unsigned NOT NULL,
  `content` longtext NOT NULL,
  `written_at` datetime NOT NULL,
  `written_by_me` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `messages_conversation_id_foreign` (`conversation_id`),
  KEY `messages_contact_id_foreign` (`contact_id`),
  KEY `messages_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `messages_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `messages_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `messages_conversation_id_foreign` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `messages`
--


--
-- Table structure for table `metadata_love_relationships`
--

CREATE TABLE `metadata_love_relationships` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `relationship_id` int(10) unsigned NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `notes` mediumtext DEFAULT NULL,
  `meet_date` datetime DEFAULT NULL,
  `official_date` datetime DEFAULT NULL,
  `breakup_date` datetime DEFAULT NULL,
  `breakup_reason` mediumtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `metadata_love_relationships_account_id_foreign` (`account_id`),
  KEY `metadata_love_relationships_relationship_id_foreign` (`relationship_id`),
  CONSTRAINT `metadata_love_relationships_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `metadata_love_relationships_relationship_id_foreign` FOREIGN KEY (`relationship_id`) REFERENCES `relationships` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `metadata_love_relationships`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=276 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2016_06_01_000001_create_oauth_auth_codes_table',1),(4,'2016_06_01_000002_create_oauth_access_tokens_table',1),(5,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(6,'2016_06_01_000004_create_oauth_clients_table',1),(7,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(8,'2016_06_07_234741_create_account_table',1),(9,'2016_06_08_003006_add_account_info_table',1),(10,'2016_06_08_005413_create_contacts_table',1),(11,'2016_06_25_224219_create_reminder_type_table',1),(12,'2016_06_28_191025_create_tasks_table',1),(13,'2016_06_30_185050_create_notes_table',1),(14,'2016_07_25_133835_add_width_field',1),(15,'2016_08_28_122938_create_kids_table',1),(16,'2016_08_28_215159_create_relations_table',1),(17,'2016_09_03_202027_add_reminder_id_to_contacts',1),(18,'2016_09_05_134937_add_last_talked_to_field',1),(19,'2016_09_05_135927_add_people_id_to_contacts',1),(20,'2016_09_05_145111_add_name_info_to_peoples',1),(21,'2016_09_06_213550_create_activity_type_table',1),(22,'2016_09_10_164406_create_jobs_table',1),(23,'2016_09_10_170122_create_notifications_table',1),(24,'2016_09_12_014120_create_failed_jobs_table',1),(25,'2016_09_30_014720_add_kid_to_reminder',1),(26,'2016_10_15_024156_add_deleted_at_to_users',1),(27,'2016_10_19_155139_create_cache_table',1),(28,'2016_10_19_155800_create_sessions_table',1),(29,'2016_10_21_022941_add_statistics_table',1),(30,'2016_10_24_013543_add_journal_setting_to_users',1),(31,'2016_10_24_014257_create_journal_tables',1),(32,'2016_10_28_002518_add_metric_to_settings',1),(33,'2016_11_01_014353_create_activities_table',1),(34,'2016_11_01_015957_add_icon_column',1),(35,'2016_11_03_150307_add_activity_location_to_activities',1),(36,'2016_11_09_013049_add_events_table',1),(37,'2016_12_08_011555_remove_type_from_notes',1),(38,'2016_12_13_133945_add_gifts_table',1),(39,'2016_12_28_150831_change_title_column',1),(40,'2017_01_14_200815_add_facebook_columns_to_users_table',1),(41,'2017_01_15_045025_add_colors_to_users',1),(42,'2017_01_22_142645_add_fields_to_contacts',1),(43,'2017_01_23_043831_change_people_to_contact_for_kids',1),(44,'2017_01_26_013524_change_people_to_significantother',1),(45,'2017_01_26_022852_change_notes_to_contact',1),(46,'2017_01_26_034553_add_notes_count_to_contact',1),(47,'2017_01_27_024356_change_people_in_events',1),(48,'2017_01_28_180156_remove_deleted_at_from_significant_others',1),(49,'2017_01_28_184901_remove_deleted_at_from_kids',1),(50,'2017_01_28_193913_remove_deleted_at_from_notes',1),(51,'2017_01_28_222114_remove_viewed_at_from_contacts',1),(52,'2017_01_29_175146_remove_delete_at_from_activities',1),(53,'2017_01_29_175629_add_number_activities_to_contacts',1),(54,'2017_01_31_025849_add_activity_statistics_table',1),(55,'2017_02_02_232450_add_confirmation',1),(56,'2017_02_04_225618_change_reminders_table',1),(57,'2017_02_05_035925_add_gifts_metrics_to_contacts',1),(58,'2017_02_05_041740_change_gifts_table',1),(59,'2017_02_05_042122_change_people_to_contact_for_gifts',1),(60,'2017_02_07_041607_change_tasks_table',1),(61,'2017_02_07_051355_add_number_tasks_to_contact',1),(62,'2017_02_08_002251_change_number_tasks_contact',1),(63,'2017_02_08_025358_add_sort_preferences_to_users',1),(64,'2017_02_10_195613_remove_notifications_table',1),(65,'2017_02_10_214714_remove_people_table',1),(66,'2017_02_10_215405_remove_entities_table',1),(67,'2017_02_10_224355_calculate_statistics',1),(68,'2017_02_11_154900_add_avatars_to_contacts',1),(69,'2017_02_12_134220_create_entries_table',1),(70,'2017_05_03_155254_move_significant_other_data',1),(71,'2017_05_04_164723_remove_contact_encryption',1),(72,'2017_05_04_185921_add_title_to_activities',1),(73,'2017_05_04_193252_alter_activity_nullable',1),(74,'2017_05_08_164514_remove_encryption_tasks',1),(75,'2017_05_30_002239_remove_predefined_reminders',1),(76,'2017_05_30_023116_create_money_table',1),(77,'2017_06_07_173437_add_multiple_genders_choices',1),(78,'2017_06_10_152945_add_social_networks_to_contacts',1),(79,'2017_06_10_155349_create_currencies_data',1),(80,'2017_06_11_025227_remove_encryption_journal',1),(81,'2017_06_11_110735_change_unique_constraint_for_contacts',1),(82,'2017_06_13_035059_remove_gifts_encryption',1),(83,'2017_06_13_195740_add_company_to_contacts',1),(84,'2017_06_14_131803_remove_bern_timezone',1),(85,'2017_06_14_132911_add_zar_currency_to_currencies_table',1),(86,'2017_06_16_215256_add_about_who_to_reminders',1),(87,'2017_06_17_010900_fix_contacts_table',1),(88,'2017_06_17_153814_refactor_user_table',1),(89,'2017_06_19_105842_add_stripe_fields_to_users',1),(90,'2017_06_20_121345_add_invitations_statistics',1),(91,'2017_06_22_210813_add_name_order_to_users',1),(92,'2017_06_27_134704_create_import_table',1),(93,'2017_06_29_211725_add_import_job_to_statistics',1),(94,'2017_06_29_230523_add_gravatar_url_to_users',1),(95,'2017_07_02_155736_create_tags_table',1),(96,'2017_07_04_132743_add_tags_to_statistics',1),(97,'2017_07_09_164312_update_bad_translation_key',1),(98,'2017_07_12_014244_create_calls_table',1),(99,'2017_07_17_005012_drop_reminders_count_from_contacts',1),(100,'2017_07_18_215312_add_danish_kroner_to_currencies_table',1),(101,'2017_07_18_215758_add_indian_rupee_to_currencies_table',1),(102,'2017_07_19_094503_add_brazilian_real_to_currencies',1),(103,'2017_07_22_153209_create_instance_table',1),(104,'2017_07_26_220021_change_contacts_table',1),(105,'2017_08_02_152838_change_string_to_boolean_for_reminders',1),(106,'2017_08_06_085629_change_events_data',1),(107,'2017_08_06_153253_move_kids_to_contacts',1),(108,'2017_08_16_041431_add_contact_avatar_location',1),(109,'2017_08_21_224835_remove_paid_limitations_for_current_users',1),(110,'2017_09_10_125918_remove_unusued_counters',1),(111,'2017_09_13_095923_add_tracking_table',1),(112,'2017_09_13_191714_add_partial_notion',1),(113,'2017_10_14_083556_change_gift_column_structure',1),(114,'2017_10_17_170803_change_gift_structure',1),(115,'2017_10_19_134816_create_activity_contact_table',1),(116,'2017_10_19_135215_move_activities_to_pivot_table',1),(117,'2017_10_25_102923_remove_contact_id_activities_table',1),(118,'2017_11_01_122541_add_met_through_to_contacts',1),(119,'2017_11_02_202601_add_is_dead_to_contacts',1),(120,'2017_11_10_174654_create_contact_fields_table',1),(121,'2017_11_10_181043_migrate_contacts_information',1),(122,'2017_11_10_202620_move_addresses_from_contact_to_addresses',1),(123,'2017_11_10_204035_delete_contact_fields_from_contacts',1),(124,'2017_11_20_115635_change-amount-to-double-on-debts',1),(125,'2017_11_27_083043_add_more_statistics',1),(126,'2017_11_27_134403_add_new_avatar_to_contacts',1),(127,'2017_11_27_202857_change_tasks_table_structure',1),(128,'2017_12_01_113748_update_notes',1),(129,'2017_12_04_164831_create_ages_table',1),(130,'2017_12_04_165421_move_ages_data',1),(131,'2017_12_10_181535_remove_important_dates_table',1),(132,'2017_12_10_205328_add_account_id_to_activities',1),(133,'2017_12_10_214545_add_last_consulted_at_to_contacts',1),(134,'2017_12_13_115857_create_day_table',1),(135,'2017_12_21_163616_update_journal_entries_with_existing_activities',1),(136,'2017_12_21_170327_add_google2fa_secret_to_users',1),(137,'2017_12_24_115641_create_pets_table',1),(138,'2017_12_31_114224_add_dashboard_tab_to_users',1),(139,'2018_01_15_105858_create_additional_reminders_table',1),(140,'2018_01_16_203358_add_gift_received',1),(141,'2018_01_16_212320_rename_gift_columns',1),(142,'2018_01_17_230820_add_gift_tab_view_to_users',1),(143,'2018_01_27_014146_add_custom_gender',1),(144,'2018_02_25_202752_change_locale_in_db',1),(145,'2018_02_28_223747_update_notification_table',1),(146,'2018_03_03_204440_create_relationship_type_table',1),(147,'2018_03_18_085815_populate_default_relationship_type_tables',1),(148,'2018_03_18_090209_populate_relationship_type_tables_with_default_values',1),(149,'2018_03_18_090345_migrate_current_relationship_table_to_new_relationship_structure',1),(150,'2018_03_24_083258_migrate_offsprings',1),(151,'2018_04_04_220850_create_default_modules_table',1),(152,'2018_04_04_222608_create_account_modules_table',1),(153,'2018_04_10_205655_fix_production_error',1),(154,'2018_04_10_222515_migrate-modules',1),(155,'2018_04_13_131008_fix-contacts-data',1),(156,'2018_04_13_205231_create_changes_table',1),(157,'2018_04_14_081052_fix_wrong_gender',1),(158,'2018_04_19_190239_stay_in_touch',1),(159,'2018_05_06_061227_external_countries',1),(160,'2018_05_07_070458_create_terms_table',1),(161,'2018_05_13_110706_add_ex_wife_husband_relationship',1),(162,'2018_05_16_143631_add_nickname_to_contacts',1),(163,'2018_05_16_214222_add_timestamps_to_currencies',1),(164,'2018_05_20_121028_accept_terms',1),(165,'2018_05_20_225034_change_name_order_user-_preferencies',1),(166,'2018_05_24_160546_fix-inconsistant-reminder-time',1),(167,'2018_06_10_191450_add_love_metadata_relationshisp',1),(168,'2018_06_10_221746_migrate_entries_objects',1),(169,'2018_06_11_184017_change_default_user_table',1),(170,'2018_06_13_000100_create_u2f_key_table',1),(171,'2018_06_14_212502_change_default_name_order_user_table',1),(172,'2018_07_03_204220_create_default_activity_type_groups_table',1),(173,'2018_07_08_104306_update-timestamps-timezone',1),(174,'2018_07_26_104306_create-conversations',1),(175,'2018_08_06_145046_add_starred_to_contacts',1),(176,'2018_08_09_18000_fix-empty-reminder-time',1),(177,'2018_08_18_180426_add_legacy_free_plan',1),(178,'2018_08_29_124804_add_conversations_to_statistics',1),(179,'2018_08_29_222051_add_conversations_to_modules',1),(180,'2018_08_31_020908_create_life_events_table',1),(181,'2018_09_02_150531_contact_archiving',1),(182,'2018_09_05_025008_add_default_profile_view',1),(183,'2018_09_05_213507_mark_modules_migrated',1),(184,'2018_09_13_135926_add_description_field_to_contacts',1),(185,'2018_09_18_142844_remove_events',1),(186,'2018_09_23_024528_add_documents_table',1),(187,'2018_09_29_114125_add_reminder_to_life_events',1),(188,'2018_10_01_211757_add_number_of_views',1),(189,'2018_10_04_181116_life_event_vehicle',1),(190,'2018_10_07_120133_fix_json_column',1),(191,'2018_10_16_000703_add_documents_to_module_table',1),(192,'2018_10_19_081816_life_event_tattoo',1),(193,'2018_10_27_230346_fix_non_english_tab_slugs',1),(194,'2018_10_28_165814_email_verified',1),(195,'2018_11_11_145035_remove_changelogs_table',1),(196,'2018_11_15_172333_make_contact_id_nullable_in_tasks',1),(197,'2018_11_18_021908_create_images_table',1),(198,'2018_11_21_212932_add_contacts_uuid',1),(199,'2018_11_25_020818_add_contact_photo_table',1),(200,'2018_11_30_154729_recovery_codes',1),(201,'2018_12_08_233140_add_who_called_to_calls',1),(202,'2018_12_09_023232_add_emotions_table',1),(203,'2018_12_09_145956_create_emotion_call_table',1),(204,'2018_12_16_195440_add_gps_coordinates_to_addressess',1),(205,'2018_12_19_002819_create_places_table',1),(206,'2018_12_19_003444_move_addresses_data',1),(207,'2018_12_21_235418_add_weather_table',1),(208,'2018_12_22_021123_add_weather_preferences_to_users',1),(209,'2018_12_22_200413_add_reminder_initial_date_to_reminders',1),(210,'2018_12_24_164256_add_companies_table',1),(211,'2018_12_24_220019_add_occupations_table',1),(212,'2018_12_25_001736_add_linkedin_to_default_contact_field_type',1),(213,'2018_12_25_012011_move_linkedin_data_to_contact_field_type',1),(214,'2018_12_29_091017_default_temperature_scale',1),(215,'2018_12_29_135516_sync_token',1),(216,'2019_01_05_152329_add_reminder_ids_to_contacts',1),(217,'2019_01_05_152405_migrate_previous_remiders',1),(218,'2019_01_05_152456_drop_special_date_id_from_reminders',1),(219,'2019_01_05_152526_schedule_new_reminders',1),(220,'2019_01_05_202557_add_foreign_keys_to_reminder',1),(221,'2019_01_05_202748_add_foreign_key_to_reminder_rule',1),(222,'2019_01_05_202938_add_foreign_key_to_contacts',1),(223,'2019_01_05_203201_add_foreign_key_for_reminder_in_life-events_table',1),(224,'2019_01_06_135133_update_u2f_key_table',1),(225,'2019_01_06_150143_add_inactive_flag_to_reminders',1),(226,'2019_01_06_190036_u2f_key_name',1),(227,'2019_01_11_142944_add_foreign_keys_to_activities',1),(228,'2019_01_11_183717_change_activities_date_type',1),(229,'2019_01_17_093812_add_admin_user',1),(230,'2019_01_18_142032_add_dav_uuid',1),(231,'2019_01_22_034555_create_emotion_activity_table',1),(232,'2019_01_24_221539_change_activity_model_location',1),(233,'2019_01_31_223600_add_swiss_chf_to_currencies_table',1),(234,'2019_02_08_234959_remove_users_without_account',1),(235,'2019_02_09_200203_add_gender_type',1),(236,'2019_02_17_112452_add_default_gender',1),(237,'2019_02_20_205744_allow_gender_null',1),(238,'2019_02_24_223855_remove_relation_type_name',1),(239,'2019_03_27_103012_set_default_profile_links',1),(240,'2019_03_29_163611_add_webauthn',1),(241,'2019_05_05_194746_add_cron_schedule',1),(242,'2019_05_15_205533_rename_preferences',1),(243,'2019_05_26_000000_add_relationship_table_indexes',1),(244,'2019_05_27_000000_populate_relationship_type_tables_with_stepparent_values',1),(245,'2019_08_12_213308_change_avatars_structure',1),(246,'2019_08_12_222938_create_avatars_for_existing_contacts',1),(247,'2019_08_13_160332_add_me_contact_on_user',1),(248,'2019_08_14_091427_update_stripe_columns',1),(249,'2019_09_04_075311_fix_tattoo_or_piercing_translation',1),(250,'2019_12_17_024553_add_foreign_keys',1),(251,'2019_12_21_100315_change_gift_status',1),(252,'2019_12_21_194559_add_photo_gift',1),(253,'2019_12_27_23533_rename_picnicked',1),(254,'2020_02_03_015403_create_audit_log_table',1),(255,'2020_02_18_211620_add_contact_field_label',1),(256,'2020_03_22_132429_rename_birthday_reminder_title_deceased',1),(257,'2020_03_25_055551_add_address_book',1),(258,'2020_03_25_065551_add_addressbook_subscription',1),(259,'2020_03_25_082324_add_contact_address_book_id',1),(260,'2020_03_25_201407_add_contact_vcard_data',1),(261,'2020_04_24_185810_remove_duplicate_currency',1),(262,'2020_04_24_205810_currencies_table_seed',1),(263,'2020_04_24_212138_update_amount_format',1),(264,'2020_05_08_072433_google2fa_column_size',1),(265,'2020_05_31_091556_custom_life_event_types',1),(266,'2020_08_05_184814_upgrade_passport',1),(267,'2020_11_01_000001_create_subscription_items_table',1),(268,'2020_12_19_205923_add_uuids',1),(269,'2021_04_23_190837_remove_reminder_sent',1),(270,'2021_09_27_023405_create_job_batches_table',1),(271,'2021_10_11_060512_add_distant_etag',1),(272,'2021_10_14_212144_v_card_company',1),(273,'2022_01_01_202745_add_export_jobs',1),(274,'2022_01_02_222042_contact_soft_delete',1),(275,'2022_04_25_165338_cashier_stripe_rename_plan',1);

--
-- Table structure for table `notes`
--

CREATE TABLE `notes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `body` mediumtext NOT NULL,
  `is_favorited` tinyint(1) NOT NULL DEFAULT 0,
  `favorited_at` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notes_contact_id_foreign` (`contact_id`),
  KEY `notes_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `notes_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `notes_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notes`
--


--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_auth_codes`
--


--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned NOT NULL,
  `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;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` VALUES (1,1,'2024-01-02 23:41:15','2024-01-02 23:41:15');

--
-- Table structure for table `occupations`
--

CREATE TABLE `occupations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `salary` int(11) DEFAULT NULL,
  `salary_unit` varchar(255) DEFAULT NULL,
  `currently_works_here` tinyint(1) DEFAULT 0,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `occupations_account_id_foreign` (`account_id`),
  KEY `occupations_contact_id_foreign` (`contact_id`),
  KEY `occupations_company_id_foreign` (`company_id`),
  CONSTRAINT `occupations_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `occupations_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `occupations_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `occupations`
--


--
-- Table structure for table `pet_categories`
--

CREATE TABLE `pet_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `is_common` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pet_categories`
--

INSERT INTO `pet_categories` VALUES (1,'reptile',0,NULL,NULL),(2,'bird',0,NULL,NULL),(3,'cat',1,NULL,NULL),(4,'dog',1,NULL,NULL),(5,'fish',1,NULL,NULL),(6,'hamster',0,NULL,NULL),(7,'horse',0,NULL,NULL),(8,'rabbit',0,NULL,NULL),(9,'rat',0,NULL,NULL),(10,'small_animal',0,NULL,NULL),(11,'other',0,NULL,NULL);

--
-- Table structure for table `pets`
--

CREATE TABLE `pets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `pet_category_id` int(10) unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pets_contact_id_foreign` (`contact_id`),
  KEY `pets_pet_category_id_foreign` (`pet_category_id`),
  KEY `pets_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `pets_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pets_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pets_pet_category_id_foreign` FOREIGN KEY (`pet_category_id`) REFERENCES `pet_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pets`
--


--
-- Table structure for table `photos`
--

CREATE TABLE `photos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `original_filename` varchar(255) NOT NULL,
  `new_filename` varchar(255) NOT NULL,
  `filesize` int(11) DEFAULT NULL,
  `mime_type` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `photos_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `photos_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `photos`
--

INSERT INTO `photos` VALUES (1,'bfe94dae-4982-4717-a284-dceb83110da4',3,'NCpxduIM_400x400.jpg','photos/zfo4f18iCoA8J6tPQh7Sloj1USeJHAiLocUMam1b.jpg',150413,'image/jpeg','2024-01-03 01:02:48','2024-01-03 01:27:24'),(2,'84ac1c30-1c4c-459b-a1e1-c9c0d760596d',3,'qhl20SOn_400x400.jpg','photos/OmzwHTfEwzcUUTPu6DciXA0IZtH3vktB1QxyzgMC.jpg',159292,'image/jpeg','2024-01-03 01:04:03','2024-01-03 01:06:09'),(3,NULL,3,'1N0TznCa_400x400.jpg','photos/oEioKUt3REQNNY7x5r2dxqwxphKx13DQ9tIFITVl.jpg',52615,'image/jpeg','2024-01-03 01:23:22','2024-01-03 01:23:22'),(4,NULL,3,'c91657d1-a59d-44fe-84b1-3d7102af3f06-profile_image-70x70.png','photos/J25DMi0j5r6IvRgbsqNA6iJpNSmyo03zxmt1I2jS.jpg',8201,'image/jpeg','2024-01-03 01:24:55','2024-01-03 01:24:55'),(5,'eef34ba6-6fe3-478c-8ff0-d3a30a1c8fc0',3,'j5ZjRFjS_400x400.jpg','photos/mXSq8V0i2e562mbLNkes8V94iRkgBUchYTFXM0A5.jpg',189126,'image/jpeg','2024-01-03 01:26:08','2024-01-03 01:26:16'),(6,NULL,3,'70z9znnkd.png','photos/0CYyOeS1vN1bcUg8BbRqWJbGWQx15AqbheVKiHPm.jpg',28784,'image/jpeg','2024-01-03 01:28:18','2024-01-03 01:28:18'),(7,NULL,3,'7X6bPD4i_400x400.jpg','photos/K2Rk6Q3G3F8al2y03roI0NjK92SCMnOQWglvgbsJ.jpg',95532,'image/jpeg','2024-01-03 01:31:21','2024-01-03 01:31:21'),(8,'d9fc4079-be56-40ff-a4a7-869add279076',3,'Capture d\'écran 2024-01-03 023327.png','photos/l6vgOZxoujXfKxCcK0hnm1FQGER9Yted44eDD7Or.jpg',320423,'image/jpeg','2024-01-03 01:34:44','2024-01-03 01:35:16'),(9,NULL,3,'usb1ggdl_400x400.jpg','photos/1mA8ySKeqEWS5UjgBIfXdV4RMfReqQ855jk4ATUY.jpg',85903,'image/jpeg','2024-01-05 05:39:50','2024-01-05 05:39:50'),(10,'05ef4a88-ad53-4d42-a15d-07c2e4e292ea',3,'g4QOWPOv_400x400.jpg','photos/66eYwZYo5081zA0iWig2BukjdCERkKWtNBjMyqL9.jpg',129320,'image/jpeg','2024-01-05 05:57:43','2024-01-05 05:58:57'),(11,NULL,3,'FD_fl_5l_400x400.jpg','photos/eba7dt5esLH2ddsnXhnYMQHb157qb0JkhR6qHeP1.jpg',106299,'image/jpeg','2024-01-05 06:59:55','2024-01-05 06:59:55'),(12,NULL,3,'L1wZCKLR_400x400.jpg','photos/KGq9QGf6R5UXdftURjpBXZ08g27jS7aEwOAHRuYh.jpg',67079,'image/jpeg','2024-01-07 01:55:46','2024-01-07 01:55:46'),(13,'78db530f-d048-4d8c-88e1-42273d6ca637',3,'aImaGelN_400x400.jpg','photos/UoqCtVL1CV3HACxRWgjAM6dx4oYlRfEA1zvLlm76.jpg',134755,'image/jpeg','2024-01-07 01:58:47','2024-01-07 01:58:56'),(14,'40304874-2e78-4fb4-8548-4f938a075bc7',3,'F6cSYMwXQAEJ2i8.png','photos/Gkco32EXSTxA4e4GUHDfXEGt9CS4EP5HAdD9bfs2.jpg',1189763,'image/jpeg','2024-01-07 02:01:53','2024-01-07 02:09:21'),(15,'56597c8c-47da-4e5e-a93e-b713b1b92906',3,'Tvjs5UA0_400x400.jpg','photos/BJvrT9LcFkwOby4a9auyn05V6Qp7yGu0NYWmUNsc.jpg',113255,'image/jpeg','2024-01-07 02:29:23','2024-01-25 04:23:10'),(16,NULL,3,'GC3OQspWUAAukXj.jpg','photos/GyAvrPESVvXMxjqeBcUu2XPfgKR5qMWoVHnHNugr.jpg',393919,'image/jpeg','2024-01-10 10:02:50','2024-01-10 10:02:50'),(17,NULL,3,'1500x500.jpg','photos/D4x6q2PjbUfh4wto8NbhR04C3xJktz1Zziv9OIhW.jpg',266512,'image/jpeg','2024-01-10 10:04:51','2024-01-10 10:04:51'),(18,'9a646322-7b1b-469b-a724-a8e03ba68f57',3,'skibidi.png','photos/fLKsm45CwBlYcUyu142nMEIZAINqc6e70hwWJhuV.jpg',379929,'image/jpeg','2024-01-10 10:05:47','2024-01-10 10:06:42'),(19,'f038ef2c-7937-435b-a368-a2985f04d5e5',3,'0Aqpg7kq_400x400.jpg','photos/RcI8WAAzVWEZbJ8z4bPTVmOkc0pQ3jTb7Xrna4rL.jpg',66814,'image/jpeg','2024-01-10 10:08:50','2024-01-10 10:09:03'),(20,NULL,3,'D4iTCXC6_400x400.jpg','photos/8DKYDXFQ8Fhiq7ZKZEmbNMM8hZZ8zTJzwdHd5szM.jpg',114483,'image/jpeg','2024-01-10 10:25:32','2024-01-10 10:25:32'),(21,NULL,3,'Ap-_UykI_400x400.jpg','photos/IhVx1rvOcXESRCfYFKZiBvtAZP60IoN9SPXRB1Ya.jpg',78806,'image/jpeg','2024-01-16 12:26:01','2024-01-16 12:26:01'),(22,NULL,3,'35956416a1961cb4412654cbfd6c5719.webp','photos/fSrPJAtKkIs5xYXNSYEtKluV3BhPlVQVGOlw6bg1.jpg',163458,'image/jpeg','2024-01-20 16:26:24','2024-01-20 16:26:24'),(23,NULL,3,'3k5wpFSD_400x400.jpg','photos/6NOGWtEUovIUBO5qpOqEi4NRlTjEeqS88C8RPZgO.jpg',131732,'image/jpeg','2024-02-04 18:47:22','2024-02-04 18:47:22'),(24,'909260ac-5e70-46dd-ae40-5e5d53debfc7',3,'IVkc1NYS.png','photos/RID2mVXB9527SWtj4GeA2aXHp4lusTC00vo9MxMU.jpg',46084,'image/jpeg','2024-02-04 21:01:56','2024-02-04 21:02:50');

--
-- Table structure for table `places`
--

CREATE TABLE `places` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `street` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `province` varchar(255) DEFAULT NULL,
  `postal_code` varchar(255) DEFAULT NULL,
  `country` char(3) DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `places_account_id_foreign` (`account_id`),
  CONSTRAINT `places_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `places`
--


--
-- Table structure for table `recovery_codes`
--

CREATE TABLE `recovery_codes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `recovery` varchar(255) NOT NULL,
  `used` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `recovery_codes_account_id_foreign` (`account_id`),
  KEY `recovery_codes_user_id_foreign` (`user_id`),
  CONSTRAINT `recovery_codes_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `recovery_codes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `recovery_codes`
--


--
-- Table structure for table `relationship_type_groups`
--

CREATE TABLE `relationship_type_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `delible` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `relationship_type_groups_account_id_name_index` (`account_id`,`name`),
  CONSTRAINT `relationship_type_groups_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `relationship_type_groups`
--

INSERT INTO `relationship_type_groups` VALUES (1,1,'love',0,NULL,NULL),(2,1,'family',0,NULL,NULL),(3,1,'friend',0,NULL,NULL),(4,1,'work',0,NULL,NULL),(5,2,'love',0,NULL,NULL),(6,2,'family',0,NULL,NULL),(7,2,'friend',0,NULL,NULL),(8,2,'work',0,NULL,NULL),(9,3,'love',0,NULL,NULL),(10,3,'family',0,NULL,NULL),(11,3,'friend',0,NULL,NULL),(12,3,'work',0,NULL,NULL);

--
-- Table structure for table `relationship_types`
--

CREATE TABLE `relationship_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `name_reverse_relationship` varchar(255) NOT NULL,
  `relationship_type_group_id` int(10) unsigned NOT NULL,
  `delible` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `relationship_types_account_id_foreign` (`account_id`),
  KEY `relationship_types_relationship_type_group_id_foreign` (`relationship_type_group_id`),
  CONSTRAINT `relationship_types_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `relationship_types_relationship_type_group_id_foreign` FOREIGN KEY (`relationship_type_group_id`) REFERENCES `relationship_type_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `relationship_types`
--

INSERT INTO `relationship_types` VALUES (1,1,'partner','partner',1,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(2,1,'spouse','spouse',1,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(3,1,'date','date',1,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(4,1,'lover','lover',1,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(5,1,'inlovewith','lovedby',1,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(6,1,'lovedby','inlovewith',1,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(7,1,'ex','ex',1,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(8,1,'parent','child',2,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(9,1,'child','parent',2,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(10,1,'sibling','sibling',2,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(11,1,'grandparent','grandchild',2,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(12,1,'grandchild','grandparent',2,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(13,1,'uncle','nephew',2,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(14,1,'nephew','uncle',2,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(15,1,'cousin','cousin',2,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(16,1,'godfather','godson',2,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(17,1,'godson','godfather',2,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(18,1,'friend','friend',3,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(19,1,'bestfriend','bestfriend',3,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(20,1,'colleague','colleague',4,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(21,1,'boss','subordinate',4,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(22,1,'subordinate','boss',4,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(23,1,'mentor','protege',4,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(24,1,'protege','mentor',4,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(25,1,'ex_husband','ex_husband',1,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(26,1,'stepparent','stepchild',2,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(27,1,'stepchild','stepparent',2,0,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(28,2,'partner','partner',5,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(29,2,'spouse','spouse',5,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(30,2,'date','date',5,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(31,2,'lover','lover',5,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(32,2,'inlovewith','lovedby',5,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(33,2,'lovedby','inlovewith',5,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(34,2,'ex','ex',5,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(35,2,'parent','child',6,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(36,2,'child','parent',6,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(37,2,'sibling','sibling',6,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(38,2,'grandparent','grandchild',6,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(39,2,'grandchild','grandparent',6,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(40,2,'uncle','nephew',6,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(41,2,'nephew','uncle',6,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(42,2,'cousin','cousin',6,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(43,2,'godfather','godson',6,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(44,2,'godson','godfather',6,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(45,2,'friend','friend',7,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(46,2,'bestfriend','bestfriend',7,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(47,2,'colleague','colleague',8,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(48,2,'boss','subordinate',8,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(49,2,'subordinate','boss',8,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(50,2,'mentor','protege',8,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(51,2,'protege','mentor',8,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(52,2,'ex_husband','ex_husband',5,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(53,2,'stepparent','stepchild',6,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(54,2,'stepchild','stepparent',6,0,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(55,3,'partner','partner',9,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(56,3,'spouse','spouse',9,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(57,3,'date','date',9,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(58,3,'lover','lover',9,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(59,3,'inlovewith','lovedby',9,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(60,3,'lovedby','inlovewith',9,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(61,3,'ex','ex',9,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(62,3,'parent','child',10,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(63,3,'child','parent',10,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(64,3,'sibling','sibling',10,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(65,3,'grandparent','grandchild',10,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(66,3,'grandchild','grandparent',10,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(67,3,'uncle','nephew',10,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(68,3,'nephew','uncle',10,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(69,3,'cousin','cousin',10,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(70,3,'godfather','godson',10,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(71,3,'godson','godfather',10,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(72,3,'friend','friend',11,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(73,3,'bestfriend','bestfriend',11,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(74,3,'colleague','colleague',12,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(75,3,'boss','subordinate',12,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(76,3,'subordinate','boss',12,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(77,3,'mentor','protege',12,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(78,3,'protege','mentor',12,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(79,3,'ex_husband','ex_husband',9,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(80,3,'stepparent','stepchild',10,0,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(81,3,'stepchild','stepparent',10,0,'2024-01-02 23:41:19','2024-01-02 23:41:19');

--
-- Table structure for table `relationships`
--

CREATE TABLE `relationships` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `relationship_type_id` int(10) unsigned NOT NULL,
  `contact_is` int(10) unsigned NOT NULL,
  `of_contact` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `relationships_relationship_type_id_foreign` (`relationship_type_id`),
  KEY `relationships_contact_is_foreign` (`contact_is`),
  KEY `relationships_of_contact_foreign` (`of_contact`),
  KEY `relationships_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `relationships_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `relationships_contact_is_foreign` FOREIGN KEY (`contact_is`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `relationships_of_contact_foreign` FOREIGN KEY (`of_contact`) REFERENCES `contacts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `relationships_relationship_type_id_foreign` FOREIGN KEY (`relationship_type_id`) REFERENCES `relationship_types` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `relationships`
--

INSERT INTO `relationships` VALUES (1,NULL,3,55,1,2,'2024-01-03 00:55:03','2024-01-03 00:55:03'),(2,NULL,3,55,2,1,'2024-01-03 00:55:03','2024-01-03 00:55:03');

--
-- Table structure for table `reminder_outbox`
--

CREATE TABLE `reminder_outbox` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `reminder_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `planned_date` date NOT NULL,
  `nature` varchar(255) NOT NULL DEFAULT 'reminder',
  `notification_number_days_before` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reminder_outbox_account_id_foreign` (`account_id`),
  KEY `reminder_outbox_reminder_id_foreign` (`reminder_id`),
  KEY `reminder_outbox_user_id_foreign` (`user_id`),
  CONSTRAINT `reminder_outbox_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `reminder_outbox_reminder_id_foreign` FOREIGN KEY (`reminder_id`) REFERENCES `reminders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `reminder_outbox_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reminder_outbox`
--

INSERT INTO `reminder_outbox` VALUES (1,3,1,3,'2024-01-04','reminder',NULL,'2024-01-03 01:36:12','2024-01-03 01:36:12'),(2,3,2,3,'2024-08-06','reminder',NULL,'2024-01-09 16:03:07','2024-01-09 16:03:07'),(3,3,2,3,'2024-07-30','notification',7,'2024-01-09 16:03:07','2024-01-09 16:03:07'),(4,3,2,3,'2024-07-07','notification',30,'2024-01-09 16:03:07','2024-01-09 16:03:07'),(5,3,3,3,'2024-05-12','reminder',NULL,'2024-01-09 16:04:10','2024-01-09 16:04:10'),(6,3,3,3,'2024-05-05','notification',7,'2024-01-09 16:04:10','2024-01-09 16:04:10'),(7,3,3,3,'2024-04-12','notification',30,'2024-01-09 16:04:10','2024-01-09 16:04:10'),(8,3,4,3,'2024-05-19','reminder',NULL,'2024-01-09 16:45:29','2024-01-09 16:45:29'),(9,3,4,3,'2024-05-12','notification',7,'2024-01-09 16:45:29','2024-01-09 16:45:29'),(10,3,4,3,'2024-04-19','notification',30,'2024-01-09 16:45:29','2024-01-09 16:45:29'),(11,3,5,3,'2024-01-15','reminder',NULL,'2024-01-10 09:59:35','2024-01-10 09:59:35'),(12,3,6,3,'2024-01-17','reminder',NULL,'2024-01-11 06:02:55','2024-01-11 06:02:55'),(13,3,7,3,'2025-01-16','reminder',NULL,'2024-01-16 12:25:06','2024-01-16 12:25:06'),(14,3,7,3,'2025-01-09','notification',7,'2024-01-16 12:25:06','2024-01-16 12:25:06'),(15,3,7,3,'2024-12-17','notification',30,'2024-01-16 12:25:06','2024-01-16 12:25:06'),(16,3,8,3,'2025-01-19','reminder',NULL,'2024-01-20 16:01:25','2024-01-20 16:01:25'),(17,3,8,3,'2025-01-12','notification',7,'2024-01-20 16:01:25','2024-01-20 16:01:25'),(18,3,8,3,'2024-12-20','notification',30,'2024-01-20 16:01:25','2024-01-20 16:01:25'),(19,3,9,3,'2024-02-05','reminder',NULL,'2024-01-25 04:24:22','2024-01-25 04:24:22'),(20,3,9,3,'2024-01-29','notification',7,'2024-01-25 04:24:22','2024-01-25 04:24:22'),(21,3,10,3,'2025-02-04','reminder',NULL,'2024-02-04 21:03:18','2024-02-04 21:03:18'),(22,3,10,3,'2025-01-28','notification',7,'2024-02-04 21:03:18','2024-02-04 21:03:18'),(23,3,10,3,'2025-01-05','notification',30,'2024-02-04 21:03:18','2024-02-04 21:03:18');

--
-- Table structure for table `reminder_rules`
--

CREATE TABLE `reminder_rules` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `number_of_days_before` int(11) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reminder_rules_account_id_foreign` (`account_id`),
  CONSTRAINT `reminder_rules_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reminder_rules`
--

INSERT INTO `reminder_rules` VALUES (1,1,7,1,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(2,1,30,1,'2024-01-02 23:41:17','2024-01-02 23:41:17'),(3,2,7,1,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(4,2,30,1,'2024-01-02 23:41:18','2024-01-02 23:41:18'),(5,3,7,1,'2024-01-02 23:41:19','2024-01-02 23:41:19'),(6,3,30,1,'2024-01-02 23:41:19','2024-01-02 23:41:19');

--
-- Table structure for table `reminders`
--

CREATE TABLE `reminders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) DEFAULT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `initial_date` date NOT NULL,
  `title` mediumtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `frequency_type` varchar(255) NOT NULL,
  `frequency_number` int(11) DEFAULT NULL,
  `delible` tinyint(1) NOT NULL DEFAULT 1,
  `inactive` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reminders_contact_id_foreign` (`contact_id`),
  KEY `reminders_account_id_uuid_index` (`account_id`,`uuid`),
  CONSTRAINT `reminders_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `reminders_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reminders`
--

INSERT INTO `reminders` VALUES (1,NULL,3,10,'2024-01-04','Wish happy birthday to RibstheGoblin',NULL,'year',1,0,0,'2024-01-03 01:36:12','2024-01-03 01:36:12'),(2,NULL,3,3,'2024-08-06','Wish happy birthday to TheForebringer',NULL,'year',1,0,0,'2024-01-09 16:03:07','2024-01-09 16:03:07'),(3,NULL,3,2,'2024-05-12','Wish happy birthday to R3zzy_exe',NULL,'year',1,0,0,'2024-01-09 16:04:10','2024-01-09 16:04:10'),(4,NULL,3,7,'2024-05-19','Wish happy birthday to Ryan',NULL,'year',1,0,0,'2024-01-09 16:45:29','2024-01-09 16:45:29'),(5,NULL,3,18,'2024-01-15','Wish happy birthday to Feydruidia',NULL,'year',1,0,0,'2024-01-10 09:59:35','2024-01-10 09:59:35'),(6,NULL,3,6,'2024-01-17','Wish happy birthday to Gilphchen',NULL,'year',1,0,0,'2024-01-11 06:02:55','2024-01-11 06:02:55'),(7,NULL,3,21,'2024-01-16','Wish happy birthday to The_Dummiest_Demon',NULL,'year',1,0,0,'2024-01-16 12:25:06','2024-01-16 12:25:06'),(8,NULL,3,22,'2024-01-19','Wish happy birthday to ExEro',NULL,'year',1,0,0,'2024-01-20 16:01:25','2024-01-20 16:01:25'),(9,NULL,3,17,'2024-02-05','Collab','2am','one_time',1,1,0,'2024-01-25 04:24:22','2024-01-25 04:24:22'),(10,NULL,3,23,'2024-02-04','Wish happy birthday to LuceBreaks',NULL,'year',1,0,0,'2024-02-04 21:03:18','2024-02-04 21:03:18');

--
-- Table structure for table `reminders_sent`
--

CREATE TABLE `reminders_sent` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `contact_id` int(11) NOT NULL,
  `reminder_id` int(11) DEFAULT NULL,
  `title` mediumtext NOT NULL,
  `description` longtext NOT NULL,
  `html_sent_content` longtext NOT NULL,
  `sent_date` datetime NOT NULL,
  `scheduled_number_days_before` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reminders_sent`
--


--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` text NOT NULL,
  `last_activity` int(11) NOT NULL,
  UNIQUE KEY `sessions_id_unique` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--


--
-- Table structure for table `special_dates`
--

CREATE TABLE `special_dates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned NOT NULL,
  `uuid` char(36) DEFAULT NULL,
  `is_age_based` tinyint(1) NOT NULL DEFAULT 0,
  `is_year_unknown` tinyint(1) NOT NULL DEFAULT 0,
  `date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `special_dates_account_id_uuid_index` (`account_id`,`uuid`),
  KEY `special_dates_contact_id_foreign` (`contact_id`),
  CONSTRAINT `special_dates_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `special_dates_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `special_dates`
--

INSERT INTO `special_dates` VALUES (1,3,10,NULL,0,1,'2024-01-04','2024-01-03 01:36:12','2024-01-03 01:36:12'),(2,3,11,NULL,0,1,'2024-01-08','2024-01-05 05:56:21','2024-01-05 05:56:22'),(3,3,14,NULL,0,1,'2024-05-14','2024-01-07 01:55:36','2024-01-07 01:55:36'),(4,3,16,NULL,0,0,'1999-09-26','2024-01-07 02:07:07','2024-01-07 02:07:07'),(6,3,3,NULL,0,1,'2024-08-06','2024-01-09 16:03:07','2024-01-09 16:03:07'),(8,3,2,NULL,0,1,'2024-05-12','2024-01-09 16:04:10','2024-01-09 16:04:10'),(9,3,7,NULL,0,1,'2024-05-19','2024-01-09 16:45:29','2024-01-09 16:45:29'),(10,3,18,NULL,0,1,'2024-01-15','2024-01-10 09:59:35','2024-01-10 09:59:35'),(11,3,6,NULL,0,1,'2024-01-17','2024-01-11 06:02:55','2024-01-11 06:02:55'),(13,3,21,NULL,0,1,'2024-01-16','2024-01-16 12:25:06','2024-01-16 12:25:06'),(14,3,22,NULL,0,1,'2024-01-19','2024-01-20 16:01:25','2024-01-20 16:01:25'),(15,3,23,NULL,0,1,'2024-02-04','2024-02-04 21:03:18','2024-02-04 21:03:18'),(16,3,25,NULL,0,1,'2024-05-09','2024-05-19 13:04:21','2024-05-19 13:04:21');

--
-- Table structure for table `subscription_items`
--

CREATE TABLE `subscription_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `subscription_id` bigint(20) unsigned NOT NULL,
  `stripe_id` varchar(255) NOT NULL,
  `stripe_product` varchar(255) DEFAULT NULL,
  `stripe_price` varchar(255) NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscription_items_subscription_id_stripe_plan_unique` (`subscription_id`,`stripe_price`),
  KEY `subscription_items_stripe_id_index` (`stripe_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_items`
--


--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `stripe_id` varchar(255) NOT NULL,
  `stripe_status` varchar(255) NOT NULL,
  `stripe_price` varchar(255) NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `trial_ends_at` timestamp NULL DEFAULT NULL,
  `ends_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subscriptions_account_id_stripe_status_index` (`account_id`,`stripe_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--


--
-- Table structure for table `synctoken`
--

CREATE TABLE `synctoken` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT 'contacts',
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `synctoken_user_id_foreign` (`user_id`),
  KEY `synctoken_account_id_user_id_name_index` (`account_id`,`user_id`,`name`),
  CONSTRAINT `synctoken_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `synctoken_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `synctoken`
--


--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `name_slug` varchar(255) NOT NULL,
  `description` mediumtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tags_account_id_foreign` (`account_id`),
  CONSTRAINT `tags_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` VALUES (1,3,'vtuber','vtuber',NULL,'2024-01-09 16:45:37','2024-01-09 16:45:37');

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `contact_id` int(10) unsigned DEFAULT NULL,
  `uuid` char(36) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `description` longtext DEFAULT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT 0,
  `completed_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tasks_account_id_uuid_index` (`account_id`,`uuid`),
  KEY `tasks_contact_id_foreign` (`contact_id`),
  CONSTRAINT `tasks_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tasks_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tasks`
--


--
-- Table structure for table `term_user`
--

CREATE TABLE `term_user` (
  `account_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `ip_address` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `term_user_account_id_foreign` (`account_id`),
  KEY `term_user_user_id_foreign` (`user_id`),
  KEY `term_user_term_id_foreign` (`term_id`),
  CONSTRAINT `term_user_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `term_user_term_id_foreign` FOREIGN KEY (`term_id`) REFERENCES `terms` (`id`) ON DELETE CASCADE,
  CONSTRAINT `term_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `term_user`
--

INSERT INTO `term_user` VALUES (1,1,1,'127.0.0.1','2024-01-02 23:41:17','2024-01-02 23:41:17'),(2,2,1,'127.0.0.1','2024-01-02 23:41:18','2024-01-02 23:41:18'),(3,3,1,'127.0.0.1','2024-01-02 23:41:19','2024-01-02 23:41:19');

--
-- Table structure for table `terms`
--

CREATE TABLE `terms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `term_version` varchar(255) NOT NULL,
  `term_content` mediumtext NOT NULL,
  `privacy_version` varchar(255) NOT NULL,
  `privacy_content` mediumtext NOT NULL,
  `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;

--
-- Dumping data for table `terms`
--

INSERT INTO `terms` VALUES (1,'2','\nScope of service\nMonica supports the following browsers:\n\nInternet Explorer (11+)\nFirefox (50+)\nChrome (latest)\nSafari (latest)\nI do not guarantee that the site will work with other browsers, but it’s very likely that it will just work.\n\nRights\nYou don’t have to provide your real name when you register to an account. You do however need a valid email address if you want to upgrade your account to the paid version, or receive reminders by email.\n\nYou have the right to close your account at any time.\n\nYou have the right to export your data at any time, in the SQL format.\n\nYour data will not be intentionally shown to other users or shared with third parties.\n\nYour personal data will not be shared with anyone without your consent.\n\nYour data is backed up every hour.\n\nIf the site ceases operation, you will receive an opportunity to export all your data before the site dies.\n\nAny new features that affect privacy will be strictly opt-in.\n\nResponsibilities\nYou will not use the site to store illegal information or data under the Canadian law (or any law).\n\nYou have to be at least 18+ to create an account and use the site.\n\nYou must not abuse the site by knowingly posting malicious code that could harm you or the other users.\n\nYou must only use the site to do things that are widely accepted as morally good.\n\nYou may not make automated requests to the site.\n\nYou may not abuse the invitation system.\n\nYou are responsible for keeping your account secure.\n\nI reserve the right to close accounts that abuse the system (thousands of contacts with hundred of thousands of reminders for instance) or use it in an unreasonable manner.\n\nOther important legal stuff\nThough I want to provide a great service, there are certain things about the service I cannot promise. For example, the services and software are provided “as-is”, at your own risk, without express or implied warranty or condition of any kind. I also disclaim any warranties of merchantability, fitness for a particular purpose or non-infringement. Monica will have no responsibility for any harm to your computer system, loss or corruption of data, or other harm that results from your access to or use of the Services or Software.\n\nThese Terms can change at any time, but I’ll never be a dick about it. Running this site is a dream come true to me, and I hope I’ll be able to run it as long as I can.\n        ','2','\nMonica is an open source project. The hosted version has a premium plan that let us collect money so we can pay for the servers and additional servers, but the main goal is not to make money (otherwise we wouldn’t have opened source it).\n\nMonica comes in two flavors: you can either use our hosted version, or download it and run it yourself. In the latter case, we do not track anything at all. We don’t know that you’ve even downloaded the product. Do whatever you want with it (but respect your local laws).\n\nWhen you create your account on our hosted version, you are giving the site information about yourself that we collect. This includes your name, your email address and your password, that is encrypted before being stored. We do not store any other personal information.\n\nWhen you login to the service, we are using cookies to remember your login credentials. This is the only use we do with the cookies.\n\nMonica runs on Linode and we are the only ones, apart from Linode’s employees, who have access to those servers.\n\nWe do hourly backups of the database.\n\nYour password is encrypted with bcrypt, a password hashing algorithm that is highly secure. You can also activate two factor authentication on your account if you need an extra layer of security. Apart from those encryptions mechanism, your data is not encrypted in the database. If someone gets access to the database, they will be able to read your data. We do our best to make sure that this will never happen, but it can happen.\n\nIf a data breach happens, we will contact the users who are affected to warn them about the breach.\n\nTransactional emails are dserved through Postmark.\n\nWe use an open source tool called Sentry to track errors that happen in production. Their service records the errors, but they don’t have access to any information apart the account ID, which lets me debug what’s going on.\n\nThe site does not currently and will never show ads. It also does not, and don’t intend to, sell data to a third party, with or without your consent. We are just against this. Fuck ads.\n\nWe do no use any tracking third parties, like Google Analytics or Intercom, that track user behaviours or data, neither on the marketing site or the hosted version. We are deeply against their principles as they would use those data to profile you, which we are totally against.\n\nAll the data you put on Monica belongs to you. We do not have any rights on it. Please don’t put illegal stuff on it, otherwise we’d be in trouble.\n\nAll the information about the contacts you put on Monica are private to you. We do not cross link information between accounts or use one information in an account to populate another account (unlike Facebook for instance).\n\nWe use Stripe to collect payments made to access the paid version. We do not store credit card information or anything concerning the transactions themselves on our servers. However, as per the open source library we use to process the payments (Laravel Cashier), we store the last 4 digits of the credit card, the brand name (VISA or MasterCard). As a user, you are identified on Stripe by a random number that they generate and use.\n\nRegarding the payments, you can downgrade to the free plan whenever you like. When you do, Stripe is automatically updated and we have no way to charge you again, even if we would like to. The less we deal with payment information, the happier we are.\n\nYou can export your data at any time. You can also use the API to export all your data if you know how to do it. You can also request that we process this ourselves and send it to you. Your data will be exported in the SQL format.\n\nWhen you close your account, we immediately destroy all your personal information and don’t keep any backup. While you have control over this, we can delete an account for you if you ask us.\n\nIn certain situations, we may be required to disclose peronal data in response to lawful requests by public authorities, including to met national security or law enforcements requirements. We just hope that this never happens.\n\nIf you violate the terms of use we will terminate your account and notify you about it. However if you follow the \"don’t be a dick\" policy, nothing should ever happen to you and we’ll all be happy.\n\nMonica uses only open-source projects that are mainly hosted on Github.\n\nWe will update this privacy policy as soon as we introduce new information practices. If we do, we will send an email to the email address specified in your account. We will never be a dick about it and will never, ever, introduce something in what we do that will affect your right to the absolute privacy.','2018-04-11 23:00:00',NULL);

--
-- Table structure for table `u2f_key`
--

CREATE TABLE `u2f_key` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT 'key',
  `user_id` int(10) unsigned NOT NULL,
  `keyHandle` varchar(255) NOT NULL,
  `publicKey` varchar(255) NOT NULL,
  `certificate` text NOT NULL,
  `counter` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `u2f_key_publickey_unique` (`publicKey`),
  KEY `u2f_key_user_id_foreign` (`user_id`),
  CONSTRAINT `u2f_key_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `u2f_key`
--


--
-- Table structure for table `weather`
--

CREATE TABLE `weather` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `place_id` int(10) unsigned NOT NULL,
  `weather_json` varchar(2000) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `weather_account_id_foreign` (`account_id`),
  KEY `weather_place_id_foreign` (`place_id`),
  CONSTRAINT `weather_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `weather_place_id_foreign` FOREIGN KEY (`place_id`) REFERENCES `places` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `weather`
--


--
-- Dumping routines for database 'monica'
--


