--
-- Host: localhost    Database: zerofy
-- ------------------------------------------------------


--
-- Table structure for table `attach_requests`
--

CREATE TABLE `attach_requests` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `initiative_id` bigint unsigned NOT NULL,
  `tenant_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `attach_requests_user_id_foreign` (`user_id`),
  KEY `attach_requests_initiative_id_foreign` (`initiative_id`),
  CONSTRAINT `attach_requests_initiative_id_foreign` FOREIGN KEY (`initiative_id`) REFERENCES `initiatives` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `attach_requests_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attach_requests`
--

INSERT INTO `attach_requests` VALUES (3,'2023-05-24 10:21:08','2023-05-24 10:21:08',2,22,1),(4,'2023-05-24 12:41:24','2023-05-24 12:41:24',3,24,2),(5,'2023-05-25 14:29:41','2023-05-25 14:29:41',3,25,2),(6,'2023-05-26 14:04:54','2023-05-26 14:04:54',2,16,1),(7,'2023-06-02 15:45:27','2023-06-02 15:45:27',7,19,3),(8,'2023-06-17 08:55:15','2023-06-17 08:55:15',2,25,1),(9,'2023-06-17 10:08:04','2023-06-17 10:08:04',8,20,4),(11,'2023-06-20 07:51:27','2023-06-20 07:51:27',8,46,4),(12,'2023-06-20 07:51:28','2023-06-20 07:51:28',8,46,4),(13,'2023-06-28 13:53:35','2023-06-28 13:53:35',7,48,3),(14,'2023-06-30 09:14:37','2023-06-30 09:14:37',3,38,2),(15,'2023-07-25 12:00:39','2023-07-25 12:00:39',10,34,2),(16,'2023-08-01 07:05:57','2023-08-01 07:05:57',3,27,2),(17,'2023-10-11 13:29:35','2023-10-11 13:29:35',15,32,6),(18,'2023-10-11 13:29:35','2023-10-11 13:29:35',15,32,6);

--
-- Table structure for table `attachments`
--

CREATE TABLE `attachments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `attachments_reference_id_foreign` (`reference_id`),
  CONSTRAINT `attachments_reference_id_foreign` FOREIGN KEY (`reference_id`) REFERENCES `initiatives` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attachments`
--

INSERT INTO `attachments` VALUES (5,'2023-05-22 20:03:51','2023-05-22 20:03:51','a:1:{i:0;s:24:\"WFH Policy template.docx\";}','a:1:{i:0;i:23339;}',13,'initiative'),(6,'2023-05-23 08:43:34','2023-08-08 16:40:15','a:1:{i:0;s:44:\"Step-by-Step E-Bike Cycle to Work Scheme.pdf\";}','a:1:{i:0;i:111056;}',14,'initiative'),(43,'2023-06-07 20:35:08','2023-06-07 20:35:08','a:1:{i:0;s:28:\"Tax Savings for e-bikes.docx\";}','a:1:{i:0;i:23559;}',51,'initiative'),(44,'2023-06-07 20:52:06','2023-06-07 20:52:06','a:1:{i:0;s:24:\"attach-1-1682513922.jpeg\";}','a:1:{i:0;i:6159;}',18,'initiative'),(46,'2023-06-07 21:28:40','2023-06-07 21:28:40','a:1:{i:0;s:38:\"Green Procurement policy template.docx\";}','a:1:{i:0;i:23498;}',22,'initiative'),(48,'2023-06-08 19:25:00','2023-06-08 19:50:06','a:1:{i:0;s:34:\"Efficient Driving Style Guide.docx\";}','a:1:{i:0;i:29907;}',54,'initiative'),(49,'2023-06-08 19:34:16','2023-06-08 19:34:16','a:1:{i:0;s:18:\"Travel Policy.docx\";}','a:1:{i:0;i:59869;}',55,'initiative'),(50,'2023-06-09 06:51:16','2023-06-09 06:51:16','a:1:{i:0;s:73:\"Case Study - Energy Saving in R&D Campus for Primary Drug Development.pdf\";}','a:1:{i:0;i:225290;}',56,'initiative'),(51,'2023-06-09 07:59:11','2023-06-09 10:39:03','a:1:{i:0;s:48:\"Guide - Engage with staff on Sustainability.docx\";}','a:1:{i:0;i:26644;}',57,'initiative'),(53,'2023-08-02 07:41:17','2023-08-02 07:43:22','a:1:{i:0;s:44:\"Guide to being a Sustainability Champion.pdf\";}','a:1:{i:0;i:816950;}',46,'initiative'),(54,'2023-08-08 13:54:15','2023-08-08 14:22:29','a:1:{i:0;s:48:\"Carbon Reduction Plan Best Practice Template.pdf\";}','a:1:{i:0;i:74885;}',25,'initiative'),(55,'2023-09-29 08:40:31','2023-09-29 08:40:31','a:1:{i:0;s:42:\"Electric Car Salary Sacrafice Example.docx\";}','a:1:{i:0;i:610690;}',62,'initiative'),(56,'2023-11-02 13:47:28','2023-11-02 13:47:28','a:1:{i:0;s:5:\"1.png\";}','a:1:{i:0;i:466615;}',24,'initiative'),(57,'2023-11-02 14:11:54','2023-11-02 14:11:54','a:1:{i:0;s:29:\"Event Attendee Guidelines.png\";}','a:1:{i:0;i:1225083;}',64,'initiative'),(58,'2023-11-10 09:20:42','2023-11-10 09:20:42','a:1:{i:0;s:36:\"Environmental Policy Review 2022.pdf\";}','a:1:{i:0;i:178355;}',66,'initiative'),(59,'2023-11-10 10:01:56','2023-11-14 15:02:09','a:2:{i:0;s:33:\"Furniture Subscription Model .pdf\";i:1;s:34:\"Environmental savings examples.pdf\";}','a:2:{i:0;i:275688;i:1;i:208635;}',65,'initiative');

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` bigint NOT NULL DEFAULT '0',
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,'2023-05-21 01:06:31',NULL,'Employees',0,NULL),(2,'2023-05-21 01:06:31',NULL,'Goods & Services',0,NULL),(3,'2023-05-21 01:06:31',NULL,'Office & Building',0,NULL),(4,'2023-05-21 01:06:31',NULL,'Operations',0,NULL),(5,'2023-05-21 01:06:31',NULL,'Commuting',1,NULL),(6,'2023-05-21 01:06:31',NULL,'Travel',1,NULL),(7,'2023-05-21 01:06:31',NULL,'Behaviour',1,NULL),(8,'2023-05-21 01:06:31',NULL,'Software',2,NULL),(9,'2023-05-21 01:06:31',NULL,'IT Equipment',2,NULL),(10,'2023-05-21 01:06:31',NULL,'Sales & Mktg',2,NULL),(11,'2023-05-21 01:06:31',NULL,'Marketing',2,NULL),(12,'2023-05-21 01:06:31',NULL,'Waste',2,NULL),(13,'2023-05-21 01:06:31',NULL,'Procurement',2,NULL),(14,'2023-05-21 01:06:31',NULL,'Logistic',2,NULL),(15,'2023-05-21 01:06:31',NULL,'Behaviour',3,NULL),(16,'2023-05-21 01:06:31',NULL,'Electricity',3,NULL),(17,'2023-05-21 01:06:31',NULL,'Waste',3,NULL),(18,'2023-05-21 01:06:31',NULL,'Procurement',3,NULL),(19,'2023-05-21 01:06:31',NULL,'Logistic',3,NULL),(20,'2023-05-21 01:06:31',NULL,'Production',4,NULL),(21,'2023-05-21 01:06:31',NULL,'Behaviour',4,NULL),(22,'2023-05-21 01:06:31',NULL,'Fuel & related consumption',4,NULL),(23,'2023-05-21 01:06:31',NULL,'Electricity',4,NULL),(24,'2023-05-21 01:06:31',NULL,'Waste',4,NULL),(25,'2023-05-21 01:06:31',NULL,'Logistic',4,NULL),(26,'2023-05-21 01:06:31',NULL,'Procurement',4,NULL),(27,'2023-05-23 08:31:57','2023-05-23 08:31:57','Events',18,'2023-05-23'),(28,'2023-05-23 15:18:43','2023-05-23 15:18:43','Events',2,'2023-05-23'),(29,'2023-05-24 06:52:34','2023-05-24 06:52:34','Strategy',4,'2023-05-24'),(32,'2023-05-24 12:06:14','2023-05-24 12:06:14','Investments',0,'2023-05-24'),(33,'2023-05-24 12:07:07','2023-05-24 12:07:07','Investing Activities',32,'2023-05-24'),(34,'2023-05-24 16:59:32','2023-05-24 16:59:32','Company Strategy',0,'2023-05-24'),(35,'2023-05-24 16:59:52','2023-05-24 16:59:52','Strategic Actions',34,'2023-05-24'),(36,'2023-10-20 06:48:37','2023-10-20 06:48:37','Home Office & Staff Tips',1,'2023-10-20');

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cities_country_id_foreign` (`country_id`),
  CONSTRAINT `cities_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities`
--


--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `plan_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `tenant_id` bigint unsigned NOT NULL,
  `progress_id` bigint unsigned NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `comments_plan_id_foreign` (`plan_id`),
  KEY `comments_user_id_foreign` (`user_id`),
  KEY `comments_tenant_id_foreign` (`tenant_id`),
  KEY `comments_progress_id_foreign` (`progress_id`),
  CONSTRAINT `comments_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `comments_progress_id_foreign` FOREIGN KEY (`progress_id`) REFERENCES `progress` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `comments_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` VALUES (54,'2023-11-02 13:50:15','2023-11-02 13:50:15',291,3,2,328,'Guidelines for the investment team to share with companies receiving financial investment from Creative UK have been shared with the investment team on 02.11. Need feedback before they share with new companies entering the investment portfolio and if they will share with the existing companies who have received financing from CUK.');

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `flag` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` bigint NOT NULL,
  `unicode` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--


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

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `initiative_by_tenant`
--

CREATE TABLE `initiative_by_tenant` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tenant_id` bigint unsigned NOT NULL,
  `initiative_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` int NOT NULL,
  `sub_category_id` int DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `progress` tinyint NOT NULL DEFAULT '0',
  `from_date` date DEFAULT NULL,
  `to_date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `initiative_by_tenant`
--


--
-- Table structure for table `initiative_by_tenants`
--

CREATE TABLE `initiative_by_tenants` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tenant_id` bigint unsigned NOT NULL,
  `initiative_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` int NOT NULL,
  `sub_category_id` int DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `progress` tinyint NOT NULL DEFAULT '0',
  `from_date` date DEFAULT NULL,
  `to_date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `initiative_by_tenants`
--

INSERT INTO `initiative_by_tenants` VALUES (1,'2023-05-22 06:33:30','2023-05-22 06:33:30',1,'test',1,7,2,0,NULL,NULL),(2,'2023-05-22 06:34:10','2023-05-22 06:34:10',1,'test new',1,7,2,0,NULL,NULL),(3,'2023-05-22 06:44:58','2023-05-22 06:44:58',1,'test new 2',1,6,2,0,NULL,NULL),(4,'2023-05-22 06:54:19','2023-05-22 06:54:19',1,'test new 7',1,5,2,0,NULL,NULL),(5,'2023-05-22 07:06:33','2023-05-22 07:06:33',1,'test new 8',2,8,2,0,NULL,NULL),(6,'2023-05-22 07:07:36','2023-05-22 07:07:36',1,'test new 9',4,21,2,0,NULL,NULL),(7,'2023-05-22 08:28:29','2023-05-22 08:28:29',1,NULL,0,0,2,0,NULL,NULL),(8,'2023-05-22 08:28:36','2023-05-22 08:28:36',1,NULL,0,0,2,0,NULL,NULL),(9,'2023-05-22 08:54:46','2023-05-22 08:54:46',1,'Bring in own Vegan food',1,7,2,0,NULL,NULL),(10,'2023-05-22 09:05:34','2023-05-22 09:05:34',1,NULL,0,0,2,0,NULL,NULL),(11,'2023-05-22 09:26:28','2023-05-22 09:26:28',1,'Chris - test',1,6,2,0,NULL,NULL),(12,'2023-05-22 20:26:35','2023-05-22 20:26:35',1,'Reduce usage of chemicals',2,26,2,0,NULL,NULL),(13,'2023-05-26 04:16:20','2023-05-26 04:16:20',2,'Manchester Office - Monthly Home Recycle Event',1,7,3,0,NULL,NULL),(14,'2023-05-26 12:02:36','2023-05-26 12:02:36',2,'Bring in own Vegan food',1,6,3,0,NULL,NULL),(15,'2023-05-26 14:51:24','2023-05-26 14:51:24',2,'Manchester Office - Monthly Home Recycle Event',1,7,3,0,NULL,NULL),(16,'2023-05-26 14:51:30','2023-05-26 14:51:30',2,'Manchester Office - Monthly Home Recycle Event',1,7,3,0,NULL,NULL),(17,'2023-05-26 16:03:39','2023-05-26 16:03:39',2,'Manchester Office - Monthly Home Recycle Event',1,7,3,0,NULL,NULL),(18,'2023-05-26 16:03:45','2023-05-26 16:03:45',2,'Manchester Office - Monthly Home Recycle Event',1,7,3,0,NULL,NULL),(19,'2023-05-26 16:03:54','2023-05-26 16:03:54',2,'Manchester Office - Monthly Home Recycle Event',1,7,3,0,NULL,NULL),(20,'2023-05-27 06:42:59','2023-05-27 06:42:59',2,'Manchester Office - Monthly Home Recycle Event',1,7,3,0,NULL,NULL),(21,'2023-05-31 13:33:23','2023-05-31 13:33:23',2,'Manchester Office - Monthly Home Recycle Event',3,19,3,0,NULL,NULL),(22,'2023-06-01 08:00:40','2023-06-01 08:00:40',2,'Manchester Office - Monthly Home Recycle Event',1,7,3,0,NULL,NULL),(23,'2023-06-06 07:53:12','2023-06-06 07:53:12',2,'Manchester Office - Monthly Home Recycle Event',1,7,3,0,NULL,NULL),(24,'2023-06-06 21:05:52','2023-06-06 21:05:52',2,'Manchester Office - Monthly Home Recycle Event',1,7,3,0,NULL,NULL),(25,'2023-06-08 08:45:08','2023-06-08 08:45:08',3,'Manchester Office - Monthly Home Recycle Event',1,7,7,0,NULL,NULL),(26,'2023-06-09 14:24:44','2023-06-09 14:24:44',4,'Manchester Office - Monthly Home Recycle Event',1,7,8,0,NULL,NULL),(27,'2023-06-09 14:25:10','2023-06-09 14:25:10',4,'Manchester Office - Monthly Home Recycle Event',1,7,8,0,NULL,NULL),(28,'2023-06-14 10:22:07','2023-06-14 10:22:07',3,'Manchester Office - Monthly Home Recycle Event',32,33,7,0,NULL,NULL),(29,'2023-06-14 10:23:39','2023-06-14 10:23:39',3,'Manchester Office - Monthly Home Recycle Event',32,33,7,0,NULL,NULL),(30,'2023-06-14 10:24:03','2023-06-14 10:24:03',3,'Manchester Office - Monthly Home Recycle Event',0,1,7,0,NULL,NULL),(31,'2023-06-15 13:48:12','2023-06-15 13:48:12',4,'Manchester Office - Monthly Home Recycle Event',1,7,8,0,NULL,NULL),(32,'2023-06-16 09:42:16','2023-06-16 09:42:16',4,NULL,0,0,8,0,NULL,NULL),(33,'2023-06-16 11:41:29','2023-06-16 11:41:29',3,'Manchester Office - Monthly Home Recycle Event',1,7,7,0,NULL,NULL),(34,'2023-06-18 20:04:47','2023-06-18 20:04:47',4,'Manchester Office - Monthly Home Recycle Event',2,8,8,0,NULL,NULL),(35,'2023-06-18 20:04:53','2023-06-18 20:04:53',4,'Manchester Office - Monthly Home Recycle Event',2,8,8,0,NULL,NULL),(36,'2023-06-18 20:15:40','2023-06-18 20:15:40',3,'Manchester Office - Monthly Home Recycle Event',1,6,7,0,NULL,NULL),(37,'2023-06-18 20:22:24','2023-06-18 20:22:24',1,'test',2,8,2,0,NULL,NULL),(38,'2023-06-18 20:25:49','2023-06-18 20:25:49',3,'Manchester Office - Monthly Home Recycle Event',2,10,7,0,NULL,NULL),(39,'2023-06-20 07:28:29','2023-06-20 07:28:29',3,'Manchester Office - Monthly Home Recycle Event',1,7,7,0,NULL,NULL),(40,'2023-06-20 09:21:09','2023-06-20 09:21:09',4,'Manchester Office - Monthly Home Recycle Event',1,7,8,0,NULL,NULL),(41,'2023-06-20 18:44:10','2023-06-20 18:44:10',3,'Manchester Office - Monthly Home Recycle Event',1,7,7,0,NULL,NULL),(42,'2023-06-22 07:39:12','2023-06-22 07:39:12',3,'Manchester Office - Monthly Home Recycle Event',1,7,7,0,NULL,NULL),(43,'2023-06-22 08:28:34','2023-06-22 08:28:34',3,'Manchester Office - Monthly Home Recycle Event',1,7,7,0,NULL,NULL),(44,'2023-06-22 09:06:34','2023-06-22 09:06:34',1,'test',3,17,2,0,NULL,NULL),(45,'2023-06-22 09:44:09','2023-06-22 09:44:09',4,'Manchester Office - Monthly Home Recycle Event',1,7,8,0,NULL,NULL),(46,'2023-06-22 11:18:39','2023-06-22 11:18:39',3,'Manchester Office - Monthly Home Recycle Event',1,7,7,0,NULL,NULL),(47,'2023-06-22 12:22:21','2023-06-22 12:22:21',3,'Manchester Office - Monthly Home Recycle Event',1,7,7,0,NULL,NULL),(48,'2023-06-22 14:29:01','2023-06-22 14:29:01',4,'Manchester Office - Monthly Home Recycle Event',1,7,8,0,NULL,NULL),(49,'2023-06-27 07:42:01','2023-06-27 07:42:01',3,'Manchester Office - Monthly Home Recycle Event',1,7,7,0,NULL,NULL),(50,'2023-06-27 08:44:57','2023-06-27 08:44:57',3,'Manchester Office - Monthly Home Recycle Event',1,7,7,0,NULL,NULL),(51,'2023-06-27 08:45:07','2023-06-27 08:45:07',3,'Manchester Office - Monthly Home Recycle Event',1,7,7,0,NULL,NULL),(52,'2023-06-29 08:16:22','2023-06-29 08:16:22',3,'Manchester Office - Monthly Home Recycle Event',1,7,7,0,NULL,NULL),(53,'2023-06-30 08:29:56','2023-06-30 08:29:56',3,'Manchester Office - Monthly Home Recycle Event',1,7,7,0,NULL,NULL),(54,'2023-07-05 08:25:01','2023-07-05 08:25:01',3,'Manchester Office - Monthly Home Recycle Event',1,7,7,0,NULL,NULL),(55,'2023-07-27 13:06:51','2023-07-27 13:06:51',5,'MilanOffice - Monthly Home Recycle Event',1,7,13,0,NULL,NULL),(56,'2023-07-27 13:06:56','2023-07-27 13:06:56',5,'MilanOffice - Monthly Home Recycle Event',1,7,13,0,NULL,NULL),(57,'2023-07-27 13:07:13','2023-07-27 13:07:13',5,'MilanOffice - Monthly Home Recycle Event',1,7,13,0,NULL,NULL),(58,'2023-07-27 13:07:54','2023-07-27 13:07:54',5,'Milan Office - Monthly Home Recycle Event',1,7,13,0,NULL,NULL),(59,'2023-07-27 13:08:43','2023-07-27 13:08:43',5,'Milan Office - Monthly Home Recycle Event',1,7,13,0,NULL,NULL),(60,'2023-07-29 17:48:12','2023-07-29 17:48:12',1,'test Initaitive',2,8,2,0,NULL,NULL),(61,'2023-07-30 19:26:57','2023-07-30 19:26:57',1,'test from new initiative',2,8,2,0,NULL,NULL),(62,'2023-07-30 19:50:53','2023-07-30 19:50:53',1,'test from new initiative',2,8,2,0,NULL,NULL),(63,'2023-07-30 19:51:35','2023-07-30 19:51:35',1,'asdasdasd',1,5,2,0,NULL,NULL),(64,'2023-07-31 19:31:38','2023-07-31 19:31:38',1,'Tiger Hardin',34,35,2,0,NULL,NULL),(65,'2023-08-06 11:03:55','2023-08-06 11:03:55',1,'talafha test',2,8,2,0,NULL,NULL),(66,'2023-08-06 11:10:21','2023-08-06 11:10:21',4,'test',4,20,8,0,NULL,NULL),(67,'2023-08-12 22:05:31','2023-08-12 22:05:31',1,'QA Testing',3,17,2,0,NULL,NULL),(68,'2023-08-12 22:06:11','2023-08-12 22:06:11',1,'Sarah 77',3,17,2,0,NULL,NULL),(69,'2023-08-13 11:08:30','2023-08-13 11:08:30',1,'test from talafha',2,8,2,0,NULL,NULL),(70,'2023-08-14 09:50:59','2023-08-14 09:50:59',1,'test from talafha',2,8,2,0,NULL,NULL),(71,'2023-08-14 09:55:49','2023-08-14 09:55:49',1,'test',2,8,2,0,NULL,NULL),(72,'2023-08-14 10:05:01','2023-08-14 10:05:01',1,'test',4,20,2,0,NULL,NULL),(73,'2023-09-18 10:28:23','2023-09-18 10:28:23',2,'Manchester Office - Monthly Home Recycle Event',1,7,3,0,NULL,NULL),(74,'2023-10-17 18:30:06','2023-10-17 18:30:06',4,'Social Pillar 2 - xyz',1,7,8,0,NULL,NULL),(75,'2024-01-23 08:48:41','2024-01-23 08:48:41',6,'Manchester Office - Monthly Home Recycle Event',3,18,15,0,NULL,NULL),(76,'2024-01-26 12:09:40','2024-01-26 12:09:40',6,'Manchester Office - Monthly Home Recycle Event',1,7,15,0,NULL,NULL);

--
-- Table structure for table `initiative_categories`
--

CREATE TABLE `initiative_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `initiative_id` bigint unsigned NOT NULL,
  `category_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `initiative_categories_initiative_id_foreign` (`initiative_id`),
  KEY `initiative_categories_category_id_foreign` (`category_id`),
  CONSTRAINT `initiative_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `initiative_categories_initiative_id_foreign` FOREIGN KEY (`initiative_id`) REFERENCES `initiatives` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `initiative_categories`
--


--
-- Table structure for table `initiative_partner_services`
--

CREATE TABLE `initiative_partner_services` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `initiative_id` bigint unsigned NOT NULL,
  `partner_service_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `initiative_partner_services_initiative_id_foreign` (`initiative_id`),
  KEY `initiative_partner_services_partner_service_id_foreign` (`partner_service_id`),
  CONSTRAINT `initiative_partner_services_initiative_id_foreign` FOREIGN KEY (`initiative_id`) REFERENCES `initiatives` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `initiative_partner_services_partner_service_id_foreign` FOREIGN KEY (`partner_service_id`) REFERENCES `partner_services` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `initiative_partner_services`
--


--
-- Table structure for table `initiatives`
--

CREATE TABLE `initiatives` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sub_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `impact` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cost_of_implementation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` int NOT NULL,
  `sub_category_id` int DEFAULT NULL,
  `language_id` int NOT NULL,
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `initiatives`
--

INSERT INTO `initiatives` VALUES (13,'2023-05-22 20:03:51','2023-05-25 14:40:43','Flexible Work From Home (WFH) policy','Working arrangement where employees have the option to decide the location and time for their work','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">A flexible WFH policy offers better work-life balance, increased job satisfaction, and reduced commuting time and expenses for employees. While employers can benefit from increased productivity, reduced overhead costs, and improved retention rates. It can also enhance the quality of air in cities when fewer people travel during peak hours.</p>\r\n<p dir=\"ltr\">This action is only possible if employees can complete their work effectively and meet their performance objectives.&nbsp;</p>\r\n<p dir=\"ltr\">A robust WFH policy is critical to ensure the positive benefits of this action. Identify and clarify needs, requirements, and equipment needed for every employee. Outline the method of communications between remote and in-office employees and how productivity and performance will be monitored. Make sure there are efforts to increase team synergy and reduce negative impacts such as social isolation.&nbsp;</p>\r\n<p dir=\"ltr\">Get employee feedback about individual and collective preferences in developing your WFH policy. The policy needs to align with the company\'s and its employees\' needs.</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\"><span style=\"color: rgb(35, 111, 161);\"><strong>Estimated Impact</strong></span></p>\r\n<p dir=\"ltr\"><strong>Reduce emission</strong></p>\r\n<p dir=\"ltr\">Commuting with car daily (under 1 hour each day) equals to 3.2 tonnes of CO2 per person per year (US Data). A policy that allows two days per week WFH can reduced 40% of the emission in per year.&nbsp;</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\">*It is also important to consider the employees&rsquo; carbon footprint at home to ensure holistic measures and reductions for the climate.&nbsp;</p>\r\n<p>&nbsp;</p>','large','medium',1,5,1,'2023-05-22'),(14,'2023-05-23 08:43:34','2023-08-08 16:40:15','E-Bike Leasing Scheme for Staff (UK)','\'Cycle to Work\' schemes for employees have grown in prevalence, but promoting this for e-bikes opens up this mode of travel to more employees','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">Cycle to Work (Salary Sacrifice) is a simple scheme whereby an employer can provide staff with an electric bike &lsquo;tax free&rsquo; at approximately half the retail price and at no cost to the company. This can enable employees to save up to 48% of the cost of a bike...amazing and really simple.</p>\r\n<p dir=\"ltr\">The company must&nbsp; set up a &lsquo;cycle to work&rsquo; scheme, purchases the chosen bike and &lsquo;loans it&lsquo; to the member of staff over a fixed period. For the company this means the HR department sets up a simple salary control system. The member of staff then commits to a small monthly reduction in gross salary thereby fully mitigating the cost to the employer.</p>\r\n<ul>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">The employee obtains the bike of their choice &lsquo;tax and vat free&rsquo;, by saving on the PAYE and NI contributions.</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">In addition the company saves the national insurance (12 .8 %) on the reduced salary whilst providing its staff with an excellent benefit that provides an efficient and environmentally friendly form of transport.</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">The company can treat the cost as capital expenditure and claim capital allowance in the normal manner.</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">The employee will also improve their physical fitness and reap numerous health benefits. They will also avoid parking and \'Clean Air Zone\' (CAZ) charges which have been established in cities such as Bath and Bristol.&nbsp;</p>\r\n</li>\r\n</ul>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\"><strong>Estimated Impact</strong></p>\r\n<p dir=\"ltr\">Commuting with car daily (under 1 hour each day) equals to 3.2 tonnes of CO2 per person per year so any changes to reduce commuting especially by non electric cars can have a significant carbon saving annualy accross your workforce.</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p>&nbsp;</p>','moderate','low',1,5,1,'2023-05-23'),(16,'2023-05-23 12:00:14','2023-05-25 14:43:58','Limit physically polluting promotional products','Include sustainable considerations in choosing goodies and merchandise for your company','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">This action is part of responsible and conscious sales and marketing strategies. Potential customers and competitors are paying attention to your sustainability claims&mdash;your decisions in the sales campaigns are at the forefront of building trust and confidence in your claims and promises. Think beyond the promotional phase, and create a proper strategy for getting the most out of your promotional products. What happens after the goods are gifted away?</p>\r\n<p dir=\"ltr\">When selecting promotional goods, focus on the carbon footprint, environmental impact, sustainable materials, and ethical sourcing. These considerations can even be cost-effective in the long run, reduce waste, build loyalty, and create brand evangelists. Share your decisions and experience with your potential customers (especially if you forgo promotional goods to reduce your carbon footprints).&nbsp;</p>\r\n<p dir=\"ltr\">Choosing eco-friendly merchandise and goodies reduces your environmental impact, improves the brand image, and increases employees engagements, as such decisions demonstrate the company\'s commitment to its sustainable visions and aspirations.&nbsp;</p>\r\n<p dir=\"ltr\">Promote something bigger than your products and service. Start by consciously choosing your promotional goods.&nbsp;</p>\r\n<p dir=\"ltr\"><strong>Estimated Impact</strong></p>\r\n<p dir=\"ltr\">82% of consumers highlight that it is important that companies use eco-friendly materials for their promotional products (Advertising Specialty Institute - ASI)</p>\r\n<p>&nbsp;</p>','low','low',2,10,1,'2023-05-23'),(17,'2023-05-23 13:32:15','2023-05-25 14:46:12','Switch existing car fleet to Electric Vehicles (EVs)','Electric vehicle fleets can mean big savings in running costs for your company as well as being better for the environment.','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">Electric vehicle fleets can mean big savings in running costs for your company as well as being better for the environment. Maintenance costs running EV&rsquo;s is cheaper than running traditional petrol cars. EV&rsquo;s have fewer moving parts so there&rsquo;s no replacing oil and the brakes often last longer due to regenerative braking. This all adds up to long term savings and carbon reduction.&nbsp;</p>\r\n<p dir=\"ltr\">Various tax incentives now exist to support both the investment in EV&acute;s but also in the infrastructure you need to charge your vehicles on site. Green loans and leasing options are also available through our partner network. We have detailed a check-list guide to help you assess the option to switch to EV.</p>\r\n<p dir=\"ltr\"><strong>Estimated Impact</strong></p>\r\n<p>Switching your petrol or diesel company vehicles to electric will remove all the direct emissions you are currently producing from this type of travel. You can expect your carbon footprint within this area of travel to reduce by as much a <strong>70% </strong>by switching to EV.</p>','low','low',1,6,1,'2023-05-23'),(18,'2023-05-23 13:36:19','2023-05-25 14:46:38','Favour local suppliers','Explore suppliers within your area and reduce your carbon footprint, increase efficiency, and support the local economy.','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">Sourcing locally is part of the green manufacturing approach, which has various benefits. Local suppliers are more flexible and reactive than suppliers who are farther away. You have greater control over the process while reducing supply chain costs, especially the logistics.&nbsp;</p>\r\n<p dir=\"ltr\">This action is also good for the community as you directly influence the local economy, supporting fellow manufacturers, service providers, and people close to you. Localizing supply your supply chain can reduce your carbon footprint significantly. Optimizing shipping and storage requirements reduce emissions and energy use.</p>\r\n<p dir=\"ltr\">Start by exploring local resources and capabilities. Use these to your business advantage. Take the opportunity to attend local trade shows and events. Look for events in your industry, niche, as well as general events. Network with other local businesses and be part of the local associations. Building a robust local network can help get tips and recommendations for new suppliers.&nbsp;</p>\r\n<p dir=\"ltr\">Think long-term when building your local network and working with local suppliers. Ensure the local suppliers are also vetted against your sustainable philosophy and policies. It is important to assess the product\'s entire life cycle to measure the impact of choosing local or global suppliers.</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\"><strong>Estimated Impact</strong></p>\r\n<p dir=\"ltr\">An average meal will travel approximately 1200 km from farm to plate.&nbsp;</p>\r\n<p dir=\"ltr\">Shipping alone makes up 3% of all emissions and 10% of transportation-related emissions.&nbsp;</p>\r\n<p><strong id=\"docs-internal-guid-afa144bc-7fff-75ea-13cd-3b99f77376d5\"><br><br></strong></p>','low','low',2,13,1,'2023-05-23'),(19,'2023-05-23 13:37:40','2023-05-25 14:46:52','Find low carbon footprint suppliers','Identifying, working, and collaborating with climate-progressive suppliers','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">To identify and select low-carbon footprint suppliers, a rigorous process of research, testing, and evaluation is necessary. One way to start is by implementing policies encouraging existing suppliers to reduce their environmental impact and improve their sustainability practices. It\'s also important to increase awareness and knowledge of green procurement within the purchasing team and assign a dedicated person to lead this effort.</p>\r\n<p dir=\"ltr\">Begin with defining the company&rsquo;s criteria in evaluating suppliers regarding their carbon footprint. This may include factors such as the energy efficiency of their operations, the use of renewable energy, and their commitment to reducing GHG emissions. Identify your preferences either to work with suppliers with existing sustainable practices in place or work together with climate-progressive suppliers to create a low-carbon supply chain together.&nbsp;</p>\r\n<p dir=\"ltr\">By establishing a robust green procurement policy, companies can identify and partner with suppliers that are committed to sustainability and can help reduce their environmental impact. (see our Action Card: Green Procurement Policy)</p>\r\n<p dir=\"ltr\"><strong>Estimated Impact</strong></p>\r\n<p><strong id=\"docs-internal-guid-414101eb-7fff-df75-f9e7-9a8bc4a5e362\"><br></strong>Hydrotreated Vegetable Oil (HVO) offers up to a 90% reduction in carbon emissions over regular diesel.</p>','low','low',2,13,1,'2023-05-23'),(20,'2023-05-23 13:38:47','2023-05-25 14:47:29','Develop an environmental policy for the office','An important step toward creating a sustainable workspace','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">An environmental policy is your company&rsquo;s written commitment to your organization\'s people, customers, and suppliers. The commitment includes managing environmental issues, including proper waste management, reducing pollution and emissions, compliance with environmental legislations, offering sustainable related training to staff, and monitoring your company&rsquo;s overall environmental performance.&nbsp;</p>\r\n<p dir=\"ltr\">Bring your green team and create an &lsquo;Environment Policy Statement.&rsquo; Each statement must include a target audience (e.g., employees, customers, suppliers, etc.) and be as specific and feasible as possible. The goals need to be achievable within a certain period of time. Seek input and feedback from key stakeholders in drafting the policy.</p>\r\n<p dir=\"ltr\">The policy is recommended to be formalized within the organization and fully endorsed by the management. Once formalized, the policy needs to be reviewed periodically and continuously shared within the system. Ensure that the policy is communicated effectively to the target audiences.&nbsp;</p>\r\n<p dir=\"ltr\">An effective environmental policy can help to improve performance and promote a sustainable workplace culture.&nbsp;</p>','low','low',3,15,1,'2023-05-23'),(21,'2023-05-23 13:40:02','2023-05-25 14:47:58','Apply the waste hierarchy to office waste','The waste hierarchy encourages the prevention, reduction,  reuse of waste and minimizing waste disposal.','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">Many companies are unaware of how waste generation impacts their bottom line (i.e., the net income). The waste hierarchy focuses on preventing and reducing the negative impact of waste as well as improving resource efficiency. According to the hierarchy, the most preferred option is waste prevention, followed by reusing, recycling, recovering, and waste disposal. The hierarchy helps to simplify and support waste management in companies. It is an improvement of the traditional approach of &lsquo;the three Rs&rdquo; (reduce, reuse, recycle).</p>\r\n<p dir=\"ltr\">By applying the waste hierarchy approach in the office, a company can reduce the amount of waste generated and save costs. Plan how to implement waste hierarchy in the office and monitor the progress&mdash;establish a benchmark to know what and how much waste you&rsquo;re producing and create a strategy to produce less. Focus on sorting and segregating waste to ensure its recyclability and value recovery.</p>\r\n<p dir=\"ltr\">The aim is to keep resources in the system longer and minimize the waste sent to landfills and incinerators. Implementing this action in the office can expose and influence employees to apply the experience in their personal life.&nbsp;&nbsp;<strong><br></strong></p>\r\n<p dir=\"ltr\"><strong>Estimated Impact</strong></p>\r\n<p dir=\"ltr\">UK offices generate an average of 22kg of waste per person per month.</p>\r\n<p dir=\"ltr\">In 2018, the total amount of waste generated by offices in the UK was 10 million tonnes. The most common type of waste generated was paper and cardboard (5.5 million tonnes), followed by food waste (1.4 million tonnes), mixed recyclables (1.3 million tonnes), and plastics (0.9 million tonnes) - (DEFRA).&nbsp;</p>','low','low',3,17,1,'2023-05-23'),(22,'2023-05-23 13:41:35','2023-06-05 19:23:23','Set up a green procurement policy','Prioritise products and services that are environmentally friendly, socially responsible, and economically viable','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">Green procurement is purchasing goods and services with a reduced environmental impact compared to conventional alternatives. Incorporating sustainable performance as a selection criterion is a key aspect of green procurement. Quality of services and competitive offerings are still important considerations.</p>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<p>Setting up a green procurement policy can contribute to reducing carbon emissions for a company in several ways:</p>\r\n<p style=\"padding-left: 40px;\">1. <strong>Supplier Selection</strong>: A green procurement policy encourages the company to select suppliers that prioritize sustainable practices and offer environmentally friendly products. By choosing suppliers with low-carbon manufacturing processes, renewable energy use, or eco-friendly materials, the company can reduce the carbon footprint associated with its supply chain.</p>\r\n<p style=\"padding-left: 40px;\">2. <strong>Energy Efficiency</strong>: Green procurement policies can prioritize energy-efficient products and equipment. By procuring energy-efficient technologies, such as lighting systems, appliances, or vehicles, a company can reduce energy consumption and associated carbon emissions during the use phase.</p>\r\n<p style=\"padding-left: 40px;\">3. <strong>Lifecycle Assessment</strong>: A green procurement policy may require suppliers to provide information about the lifecycle carbon footprint of their products. This allows the company to make informed decisions based on the environmental impact of a product throughout its entire lifecycle, including production, transportation, use, and disposal. By choosing products with lower carbon footprints, the company can contribute to emissions reduction.</p>\r\n<p style=\"padding-left: 40px;\">4. <strong>Waste Management</strong>: Green procurement policies often emphasize reducing waste generation and promoting recycling or reuse. By procuring products with minimal packaging, recyclable materials, or extended product lifecycles, a company can reduce waste sent to landfills, thus decreasing associated greenhouse gas emissions.</p>\r\n<p style=\"padding-left: 40px;\">5. <strong>Employee Awareness</strong>: Implementing a green procurement policy can raise employee awareness about sustainability and encourage eco-friendly behavior within the organization. By promoting environmentally conscious practices, such as reducing paper usage, using energy-efficient equipment, or choosing public transportation, employees can collectively contribute to reducing carbon emissions.</p>\r\n<p style=\"padding-left: 40px;\">6. <strong>Stakeholder Engagement</strong>: A green procurement policy demonstrates the company\'s commitment to sustainability, which can positively influence stakeholders, including customers, investors, and communities. This can enhance the company\'s reputation, attract environmentally conscious consumers, and potentially increase market share. As a result, the company can indirectly contribute to reducing carbon emissions by driving demand for low-carbon products and encouraging other organizations to adopt sustainable practices.</p>\r\n<p>By integrating environmentally friendly considerations into procurement processes, a company can play a significant role in reducing carbon emissions throughout its supply chain and operations, ultimately contributing to broader sustainability and climate change mitigation efforts.</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p dir=\"ltr\"><span style=\"color: rgb(35, 111, 161);\"><strong>Estimated Impact</strong></span></p>\r\n<p dir=\"ltr\">92% of an average company&rsquo;s emissions originate in the value chain</p>\r\n<p dir=\"ltr\">Collaborating with suppliers is vital in delivering net zero.</p>\r\n<p>&nbsp;</p>','low','low',4,26,1,'2023-05-23'),(23,'2023-05-23 15:24:31','2023-05-23 15:24:31','ISO 20121 - Sustainable Event','Gaining audit status on events gives a gold standard in sustainability adherence',NULL,'low','low',2,28,1,'2023-05-23'),(24,'2023-05-24 06:19:54','2023-05-24 12:30:55','Best Practice Guidelines for Investment Portfolio','Provide Best Practice Framework Guidelines for Investment Portfolio via Zerofy platform','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">When providing financing to other businesses there is a certain responsibility to consider how the investments are deployed up against sustainability frameworks and best practice, alongside other more traditional ownership, social and financial eligibility, and checks. It is also an important note to remember that any investment made, even as a minority ownership, does form part of the financing companies Carbon Footprint under the most recognised reporting standards framework, Greenhouse Gas Protocol. But at this stage we see no benefit for the investment companies to report on their own Carbon Footprint.&nbsp;&nbsp;&nbsp;</p>\r\n<p dir=\"ltr\"><strong>Recommended Action</strong></p>\r\n<p dir=\"ltr\">Zerofy can offer a simple and standardized service within our platform that can be implemented towards investment companies in various ways depending on how this fits with the Investment Portfolios required frameworks. Zerofy would offer the platform at a lower cost for portfolio companies (subject to discussions on how this should work, and include the following product offering:</p>\r\n<p dir=\"ltr\">&middot;&nbsp; Access to the platform for participating portfolio investment companies</p>\r\n<p dir=\"ltr\">&middot;&nbsp; Provide a standard set of recommended &ldquo;Best Practice&rdquo; actions and frameworks around carbon reduction or avoidance initiatives</p>\r\n<p dir=\"ltr\">&middot;&nbsp; Actions will be supported by relevant local service partners where needed</p>\r\n<p dir=\"ltr\">&middot;&nbsp; Provide any form of reporting requirements within the platform needed by Creative UK</p>\r\n<p dir=\"ltr\">&middot;&nbsp; Supported by the Zerofy sustainability experts</p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">Zerofy is flexible to work towards a model that fits into how your investment team wishes to operate this and will continue to work towards a model that fits within your new investment framework.</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\"><strong>Benefits</strong></p>\r\n<p dir=\"ltr\">&middot;&nbsp; Providing added value to portfolio companies and easy access to best practice frameworks</p>\r\n<p dir=\"ltr\">&middot;&nbsp; Increase the sustainability credentials of investment portfolio</p>\r\n<p dir=\"ltr\">&middot;&nbsp; Show leadership on sustainability issues and actions</p>\r\n<p>&middot;&nbsp; Reduce environmental impact of the investment portfolio</p>','large','low',32,33,1,'2023-05-24'),(25,'2023-05-24 07:02:11','2023-08-08 13:36:27','Carbon Reduction Strategy Goals and Targets','Showcase your organisation’s journey to net zero, create targets and KPIs to track your success.','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">Setting an integrated sustainability strategy that fits within the company\'s short and long-term objectives is vital to achieving a successful outcome for the business and promotes credibility to customers, investors, employees and other stakeholders.</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\">The aim of the Carbon Reduction Plan (CRP) is to demonstrate your organisation\'s commitment to Net Zero, presenting your long-term goals and short-term action plan. If your company has quantified its impact through carbon accounting, these should be reported as baseline emissions with complimentary emission reduction targets.&nbsp;</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\">Remember, this document may be shared with those in management level roles, other stakeholders and published on your company website, so ensure it is clear and concise.&nbsp;</p>\r\n<p><br>Refer to the supporting documents for a CRP Best Practice Template. A brief overview of the format of the CRP is detailed below:&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Introduction</p>\r\n</li>\r\n<ul>\r\n<li dir=\"ltr\" aria-level=\"2\">Essential information (i.e. company name, date of publication).&nbsp;</li>\r\n<li dir=\"ltr\" aria-level=\"2\">\r\n<p dir=\"ltr\" role=\"presentation\">Declaration of your company&rsquo;s commitment to Net Zero.&nbsp;</p>\r\n</li>\r\n</ul>\r\n</ul>\r\n<ul>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Baseline emissions</p>\r\n</li>\r\n<ul>\r\n<li dir=\"ltr\" aria-level=\"2\">\r\n<p dir=\"ltr\" role=\"presentation\">Provide an overview of your current emissions or baseline emissions (depending whether emissions have been previously reported).</p>\r\n</li>\r\n</ul>\r\n</ul>\r\n<ul>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Emission reduction targets</p>\r\n</li>\r\n<ul>\r\n<li dir=\"ltr\" aria-level=\"2\">\r\n<p dir=\"ltr\" role=\"presentation\">State your emission reduction targets and KPIs to track performance.&nbsp;</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"2\">\r\n<p dir=\"ltr\" role=\"presentation\">Use graphs to illustrate your goals for the future, displaying your baseline emissions against your target.&nbsp;</p>\r\n</li>\r\n</ul>\r\n</ul>\r\n<ul>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Declaration and Sign-off&nbsp;</p>\r\n</li>\r\n<ul>\r\n<li dir=\"ltr\" aria-level=\"2\">\r\n<p dir=\"ltr\" role=\"presentation\">Ensure your CRP is signed off by a member of your board of directors.&nbsp;</p>\r\n</li>\r\n</ul>\r\n</ul>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\"><strong>Estimated Impact</strong></p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<ul>\r\n<li dir=\"ltr\">Producing a high quality CRP is imperative for your organisation to demonstrate it\'s commitment and alignment with your sustainability and net zero goals.</li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li dir=\"ltr\">The CRP forms the key backdrop when communicating with fellow employees to gain their understanding and buy-in for completing the actions set within the Zerofy platform.&nbsp;</li>\r\n</ul>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p>&nbsp;</p>','large','low',34,35,1,'2023-05-24'),(27,'2023-05-24 12:48:49','2023-05-24 12:48:49','Source for greener/sustainable venues','Spaces and facilities that focus on minimising environmental impact and promoting social responsibility','<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\">Sustainable venues strive to minimize carbon emissions, protect natural resources, and contribute positively to the local community and ecosystem. These venues include sustainable considerations in every aspect of offerings. Their key characteristics include:&nbsp;</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<ul>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Focusing on energy efficiency practices and technologies;</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Utilizing renewable energy resources (e.g., solar panels);</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Implementing water-saving measures;</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Promoting responsible water management.&nbsp;</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Prioritizing waste reduction, recycling, and composting</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Partnering with responsible waste management companies</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Using eco-friendly and recycled materials in the event construction, furnishing, and decor</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Active in environmental education and engagement</p>\r\n</li>\r\n</ul>\r\n<p dir=\"ltr\">Explore and identify venues that actively work on reducing their environmental footprint, promoting sustainable best practices, and inspiring others to adopt more sustainable approaches in the event industry.&nbsp;</p>\r\n<p dir=\"ltr\">With the proper criteria and consideration, you can effectively reduce your carbon footprint, enrich your event experience, ensure accessibility to your attendees, and build a network of people and places for your green events.&nbsp;</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\"><strong>Estimated Impact</strong></p>\r\n<p dir=\"ltr\">84% of events&rsquo; carbon footprints are from air, train, and car travel</p>\r\n<p>&nbsp;</p>','moderate','medium',2,28,1,'2023-05-24'),(28,'2023-05-24 12:50:21','2023-05-24 12:50:21','Offer sustainable-oriented food experience','Explore sustainable catering that also offers exciting gastronomic stories and experience','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">Sustainable catering focuses on environmentally conscious sourcing, preparing, serving, and disposing of food and materials. This service is commonly available in many locations. It is essential to ensure the service providers are responsible and committed to their sustainable offerings to ensure it is not just a &lsquo;green theatre.&rsquo;</p>\r\n<p dir=\"ltr\">Innovative gastronomic design and experience is a critical aspect of an event as it offers a shared experience to attendees, influences carbon footprints, and is one of the sources of waste generation. Seek values beyond caterers&rsquo; sustainable offerings and explore stories and experiences that would be tasty and memorable to the attendees.&nbsp;</p>\r\n<p dir=\"ltr\">Collaborate with the caterer to create unique and sustainable menu options that showcase creative flavors and techniques while considering dietary preferences and restrictions.</p>\r\n<p dir=\"ltr\">Explore new themes (e.g., farm-to-table options), ingredients (e.g., crackers made from beer waste), and ways of eating (e.g., edible plates). Challenge your caterer to create something bold yet sustainable and cost-effective. The experience also includes how your caterer/ organizer manages leftover food&mdash;reducing the chance for the leftovers to be turned into waste.&nbsp;&nbsp;</p>\r\n<p dir=\"ltr\">Lastly, build a robust communication strategy to educate attendees about the sustainable practices employed throughout the catering process. Share stories about the origins of the ingredients, collaborations with local suppliers, and efforts to reduce waste and carbon footprint.</p>\r\n<p dir=\"ltr\">Utilize social media, event websites, and venue signage to highlight the catering experience\'s sustainable aspects and encourage attendees to participate in eco-friendly initiatives.</p>\r\n<p>&nbsp;</p>','low','low',2,28,1,'2023-05-24'),(29,'2023-05-24 12:51:43','2023-05-24 12:51:43','Identify ways to manage food waste after events','Managed food waste accordingly to reduce environmental impact and promote sustainability','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">Even though the first effort is to reduce waste, it is more than likely that there will be food waste by the end of your event. Always remember that throwing perfectly edible food into landfills (even for composting) should be the last action in your waste management plan for food waste.&nbsp;</p>\r\n<p dir=\"ltr\">How your food waste will (or can) be managed should start from the design of the food offered during the event. Identify the types of waste the food selected will generate and find the best way to manage them sustainably. When it is impossible, consider changing your menu or how it is being presented. Discuss with your caterer designing food that can last longer, be easily packed to be sent to a third party, and be transported easily without reducing its taste, and overall quality.</p>\r\n<p dir=\"ltr\">A holistic gastronomic menu considers how the leftover can be managed sustainably.</p>\r\n<p dir=\"ltr\">Be open to challenging the status quo. For example, offer free or minimum pay for leftover takeaways for staff and attendees, learn about the local regulation when it comes to food donation, identify reputable food banks and shelters in the area, partner with sustainable food stakeholders to manage your leftovers( e.g., Too Good To Go), explore other alternatives points for your food waste (e.g., animal farms).&nbsp;</p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\"><strong>Estimated Impact</strong></p>\r\n<p dir=\"ltr\">A third of all food produced for human use, valued at $1 trillion, is lost or wasted each year (UN&rsquo;s Food and Agriculture Organization (FAO))</p>\r\n<p dir=\"ltr\">The average event industry wastes between 15% to 20% of food it produces</p>\r\n<p>&nbsp;</p>','low','low',2,28,1,'2023-05-24'),(30,'2023-05-24 12:52:46','2023-05-25 14:55:32','Have an energy measurement strategy in place','Effectively track energy usage, identify areas of improvement, and monitor progress','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">Measure your energy consumption is the crucial first step in effectively managing and optimizing energy usage, reducing cost, and minimizing environmental impact. However, this task can be challenging without a well-structured plan and strategy.&nbsp;</p>\r\n<p dir=\"ltr\">Developing a well-defined energy measurement strategy is critical for companies to track energy usage accurately, identify areas of improvement and monitor progress toward energy efficiency goals. Start by building an inventory of energy consumption points and identify those that can be measured effectively using existing devices and technology.&nbsp;</p>\r\n<p dir=\"ltr\">Choose appropriate tools and equipment to measure energy usage accurately. This may include energy meters, sub-meters, data loggers, smart meters, or energy management systems. Consider the level of detail required, compatibility with existing systems, and ease of data collection and analysis.</p>\r\n<p dir=\"ltr\">Gain a clear understanding of your current resources and capacity in measuring, tracking, collecting, analyzing, and reporting your energy consumption. This assessment will help you to build a roadmap toward having comprehensive measurement data from all the consumption points.&nbsp;</p>\r\n<p dir=\"ltr\">It is essential to recognize that measuring your energy usage is an ongoing process that requires commitment, and continuous improvement.</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\"><strong>Estimated Impact</strong></p>\r\n<p dir=\"ltr\">Based on EU pilot projects, on average smart meters provide energy saving between 2% to 10%.</p>\r\n<p>&nbsp;</p>','moderate','low',2,28,1,'2023-05-24'),(31,'2023-05-24 12:53:58','2023-05-24 12:53:58','Start to measure energy usage in your event','An essential step to understanding and managing your environmental impact','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">An effective approach to measuring energy usage during events can identify opportunities to reduce energy consumption and promote sustainability.</p>\r\n<p dir=\"ltr\">Start by identifying the energy sources and points of consumption. Identify ways to measure and monitor consumption by installing energy meters. Adopting an independent measuring consumption approach is beneficial because venues might change, but your system, technical setup, and equipment remain the same.&nbsp;</p>\r\n<p dir=\"ltr\">Track and collect data on energy consumption throughout the event. Keep the first data cycle as a baseline for future changes and improvement. This data is helpful in pinpointing areas of high energy usage and potential opportunities for optimization. It also offers a means to compare your energy usage against similar events and future events.&nbsp;</p>\r\n<p dir=\"ltr\">Measuring the energy usage enables you to calculate the energy intensity by dividing the total energy consumption by a relevant metric, for example, per attendee, per square footage, or by the hour. Maintaining a record of energy consumption is vital to evaluate the effectiveness of energy-saving measures, give valuable insights to the organizers and stakeholders, and showcase your commitment to energy management and sustainability.&nbsp;<strong><br></strong></p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\"><strong>Estimated Impact</strong></p>\r\n<p dir=\"ltr\">Power represents up to 70% of an event\'s carbon footprint (excluding attendees\' travel)</p>\r\n<p>&nbsp;</p>','low','low',2,28,1,'2023-05-24'),(32,'2023-05-24 14:12:56','2023-08-03 12:23:02','Subsidised Public Transport & Staff Loans for Travel','Encourage staff to travel by public transport through offering financial incentives','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\"><strong>Season tickets and loans for public transport</strong></p>\r\n<p dir=\"ltr\">Offering discounted season tickets and loans for public transport can help to encourage employees to look at options for sustainable travel and commuting. Where a loan is provided to an employee to purchase a season ticket, there are no tax or National Insurance Consequences (NIC) as long as the total loan is below &pound;10,000. Details below explain how subsidised travel and loans can be put into place and the implications. Note they can be done in combination of each other.</p>\r\n<p dir=\"ltr\">Note - If employees are provided with a season ticket or vouchers to purchase a season ticket this will, however, be treated as a taxable benefit (same as paying more salary) and reporting obligations will apply.&nbsp;</p>\r\n<ol>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\"><strong>Subsidised Public Transport</strong></p>\r\n</li>\r\n</ol>\r\n<p dir=\"ltr\">If the company decides to partially subsidise public transport for example, contributing to subsidised or free public bus transport. You don&rsquo;t have to pay any tax or National Insurance on these costs or report anything to HMRC. So this is a staff incentive not taxed to support the move to public transport.</p>\r\n<p dir=\"ltr\">An example would be when you help finance a bus route that gives your employees free or reduced-rate transport between their homes and work or between workplaces.</p>\r\n<ol start=\"2\">\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\"><strong>Loans made to employees to buy season tickets</strong></p>\r\n</li>\r\n</ol>\r\n<p dir=\"ltr\">Commuting costs can become a significant burden for many employees. Help retain your employees by enabling their access to affordable transport. Subsidising travel will either require your company to pay upfront for season tickets or various companies offer financial arrangements that can be underwritten by the company.</p>\r\n<p dir=\"ltr\">Interest free loans can help to enable cheaper annual passes which will encourage employees to continually choose public transport.&nbsp;</p>\r\n<p dir=\"ltr\">Loans can be provided at interest free rates if the company wishes to help subsidise the real cost of travel for staff, or with an interest rate determined by HMRC. Each approach results in a different tax implication for the company which can be explored in further depth with the Zerofy team.&nbsp;</p>\r\n<p dir=\"ltr\">There are a variety options available when selecting a staff travel subsidy. The Zerofy team recommend arranging a meeting to discuss and narrow the scope on how your company would wish to set up their staff travel subsidy.&nbsp;</p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\"><strong>Benefits Overview</strong></p>\r\n<p dir=\"ltr\">a) Increased public transport usage.</p>\r\n<p dir=\"ltr\">b) Reduction in carbon emissions caused by commuting.&nbsp;</p>\r\n<p dir=\"ltr\">c) Additional value added to being an employee.&nbsp;</p>\r\n<p>&nbsp;</p>','low','medium',1,5,1,'2023-05-24'),(33,'2023-05-24 14:16:34','2023-08-01 07:10:08','Implement a “No plastic” policy','Plastics are a major issue for the environment and business has a big part to play in lowering its impact','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">Reducing plastic usage is essential for climate action due to several reasons. Plastic production emits greenhouse gases during the extraction and refinement of fossil fuels. By decreasing plastic usage, we can reduce the demand for fossil fuels and lower greenhouse gas emissions. Additionally, plastic manufacturing consumes significant energy, often from fossil fuel sources, resulting in increased carbon dioxide emissions. By reducing plastic usage, we can decrease energy requirements and lower our carbon footprint. Improperly managed plastic waste contributes to environmental issues, including the release of greenhouse gases and the burden on waste management systems. By reducing plastic usage, we can alleviate these problems. Plastic packaging relies on materials that contribute to deforestation, releasing carbon and causing habitat destruction. By promoting sustainable packaging alternatives and reducing plastic usage, we can help mitigate deforestation. Plastic pollution harms marine ecosystems, with plastic waste breaking down into harmful microplastics that affect marine life and enter the food chain. By reducing plastic usage, we can minimize microplastic production and protect marine ecosystems. In summary, reducing plastic usage is crucial for climate action as it lowers greenhouse gas emissions, decreases energy consumption, improves waste management, mitigates deforestation, and combats marine pollution. Adopting sustainable alternatives and responsible consumption is key to building a sustainable future.</p>\r\n<p>&nbsp;</p>\r\n<p dir=\"ltr\">Reducing plastic usage in your company is an admirable goal that can have a positive impact on the environment. Here are some steps you can take to achieve this:</p>\r\n<p style=\"padding-left: 40px;\">1. <strong>Conduct a plastic audit</strong>: Assess the current plastic consumption in your company by conducting an audit. Identify areas where plastic is being used excessively and determine the types of plastic used.</p>\r\n<p style=\"padding-left: 40px;\">2. <strong>Set specific goals</strong>: Establish specific, measurable, achievable, relevant, and time-bound (SMART) goals for reducing plastic usage. For example, aim to reduce plastic waste by a certain percentage within a specific timeframe.</p>\r\n<p style=\"padding-left: 40px;\">3. <strong>Raise awareness and educate employees</strong>: Educate your employees about the environmental impacts of plastic and the importance of reducing its usage. Promote awareness campaigns, workshops, or training sessions to encourage behavior change.</p>\r\n<p style=\"padding-left: 40px;\">4.<strong> Encourage reusable alternatives</strong>: Identify opportunities to replace single-use plastic items with reusable alternatives. For example, switch from plastic cups to glass or ceramic cups, use metal cutlery instead of plastic utensils, and provide reusable water bottles for employees.</p>\r\n<p style=\"padding-left: 40px;\">5. <strong>Implement a waste management system</strong>: Establish an effective waste management system to ensure proper segregation and recycling of plastic waste. Encourage employees to recycle and provide clearly labeled recycling bins throughout the office.</p>\r\n<p style=\"padding-left: 40px;\">6. <strong>Partner with suppliers</strong>: Collaborate with your suppliers to find alternative packaging options that minimize or eliminate plastic. Request that they use eco-friendly packaging materials, such as biodegradable or compostable alternatives.</p>\r\n<p style=\"padding-left: 40px;\">7. <strong>Offer incentives</strong>: Create incentives or rewards for employees who actively contribute to reducing plastic usage. This can include recognition programs or bonuses for innovative ideas that lead to significant reductions.</p>\r\n<p style=\"padding-left: 40px;\">8. <strong>Review purchasing practices</strong>: Assess your purchasing practices and prioritize suppliers that offer sustainable alternatives to plastic products. Consider factors like packaging, durability, and recyclability when selecting suppliers.</p>\r\n<p style=\"padding-left: 40px;\">9. <strong>Optimize product design</strong>: Explore ways to redesign products or packaging to reduce the need for plastic. For example, consider using less packaging material, using recycled or biodegradable materials, or implementing refillable options.</p>\r\n<p style=\"padding-left: 40px;\">10. <strong>Monitor progress and communicate</strong>: Regularly track and analyze your progress towards reducing plastic usage. Share updates with employees, customers, and other stakeholders to showcase your company\'s commitment to sustainability and inspire others to do the same.</p>\r\n<p dir=\"ltr\">Remember, the journey towards reducing plastic usage is an ongoing process. Continuously evaluate your practices, engage stakeholders, and seek innovative solutions to further minimize plastic consumption in your company.</p>\r\n<p>&nbsp;</p>','low','low',2,12,1,'2023-05-24'),(34,'2023-05-24 16:38:06','2023-08-02 07:55:50','Allocate a Green Champion by department','Ensure each key team has a Green Champion to educate and motivate their team to enable behavioural emission reduction change','<p>&nbsp;</p>\r\n<ul>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Companies should have an overall Green Champion to manage the Zerofy platform and ensure the staff are educated and on board the Sustainability journey and Net Zero target.</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">To most effectively ensure the new carbon reduction policies and initiatives are adopted, quickly across the company, the Green Champion should allocate access to the Zerofy platform and allocate responsibilities to the heads of the different departments where the company is a sufficient size, such as the Head of Marketing, Finance Director or Sales Director.&nbsp;</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">These team leaders with teams under their management will ensure their teams are educated on the Net Zero and Sustainability industry and The companies Zerofy Net Zero decarbonisation strategy through the Zerofy Academy Module within the platform.&nbsp;</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Ensure staff feedback by inputting data around commuting and carbon footprint in the office for the Zerofy reporting to be accurate.</p>\r\n</li>\r\n</ul>\r\n<p>&nbsp;</p>','large','low',4,21,1,'2023-05-24'),(35,'2023-05-24 16:40:42','2023-05-25 14:52:43','Educate your customers','Communicate your initiatives to your customers','<p>&nbsp;</p>\r\n<p>Maximise the marketing value of your activities to customers and external stakeholders. Zerofy offers a range of materials you can use in your marketing channels to promote your actions and status.</p>','low','low',4,21,1,'2023-05-24'),(36,'2023-05-24 16:42:08','2023-05-24 16:42:08','Request carbon footprint intensity from your suppliers','An audit of your key suppliers carbon intensity levels is a good way to validate you are making the best environmental choices',NULL,'low','low',4,21,1,'2023-05-24'),(37,'2023-05-24 16:43:39','2023-06-05 19:13:35','Reduce usage of software data processing and hosting','Running an internal efficiency audit and usage testing is a good way to find cost and environmental savings','<p>&nbsp;</p>\r\n<p>Reducing software data processing and hosting can contribute to reducing carbon emissions in several ways:</p>\r\n<p style=\"padding-left: 40px;\">1. <strong>Energy Efficiency</strong>: Data processing and hosting require significant amounts of energy, which often comes from fossil fuel-based sources. By optimizing software and infrastructure, you can reduce the energy consumption associated with these processes. This can be achieved through efficient code, server consolidation, virtualization, and utilizing energy-efficient hardware.</p>\r\n<p style=\"padding-left: 40px;\">2. <strong>Cloud Computing</strong>: Moving data processing and hosting to cloud service providers can be more energy-efficient than maintaining local servers. Cloud providers typically have optimized data centers, which are designed to minimize energy consumption. By leveraging the shared infrastructure of cloud providers, you can reduce the carbon footprint associated with running and cooling physical servers.</p>\r\n<p style=\"padding-left: 40px;\">3. <strong>Server Virtualization</strong>: Virtualization allows multiple virtual servers to run on a single physical server, thereby optimizing server usage and reducing energy consumption. By consolidating workloads and running multiple applications on fewer physical servers, you can decrease the overall energy requirements and, consequently, the associated carbon emissions.</p>\r\n<p style=\"padding-left: 40px;\">4.<strong> Data Center Location</strong>: Choosing data centers powered by renewable energy sources can significantly reduce the carbon footprint. Opting for data centers that use renewable energy, such as solar or wind power, helps shift the energy consumption away from fossil fuels, contributing to a greener computing infrastructure.</p>\r\n<p style=\"padding-left: 40px;\">5. <strong>Software Optimization</strong>: Writing efficient code and optimizing software applications can reduce the processing power required and, subsequently, the energy consumed during data processing. Minimizing unnecessary computations, optimizing algorithms, and reducing resource usage can all contribute to more energy-efficient software.</p>\r\n<p style=\"padding-left: 40px;\">6. <strong>Data Compression and Storage Optimizatio</strong>n: Reducing the size of data files through compression techniques and optimizing storage can lead to lower energy consumption. Smaller files require less energy for storage, retrieval, and transmission, resulting in reduced carbon emissions.</p>\r\n<p>By employing these strategies, organizations and individuals can contribute to a more sustainable computing ecosystem by reducing energy consumption and minimizing carbon emissions associated with software data processing and hosting.</p>','low','low',2,8,1,'2023-05-24'),(38,'2023-05-24 16:45:31','2023-08-03 12:46:23','Offer Vegetarian or Vegan Food Options','Low carbon food choices for meetings, events and staff can have a big impact','<p>&nbsp;</p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">The food we consume has a massive impact on our planet. Agriculture takes up half the habitable land on Earth, destroys forests and other ecosystems and produces a quarter of the world&rsquo;s greenhouse gas emissions. Meat and dairy specifically accounts for around 14.5% of global greenhouse gas emissions. By incorporating more vegetarian options in your workplace, you can help reduce your carbon footprint.&nbsp;</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">You have the power to transform your workplace into a healthier and more sustainable environment by promoting vegetarian food choices. By emphasizing the advantages of a balanced diet and incorporating engaging initiatives, you can create a positive impact on the well-being of your employees, the environment, and the overall success of your organisation.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">&nbsp;</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">As a company you have options to encourage lower carbon food within your organisation:</span></strong></p>\r\n<ol start=\"1\" type=\"1\">\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l1 level1 lfo1; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Set-up a new policy that ensures only vegetarian or vegan foods options are offered during meetings or events. Various suppliers can cover catering needs within this area with creative and exciting food options.</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l1 level1 lfo1; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Promote the sustainability and health benefits of reducing meat consumption to your employees. The </span><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Zerofy team have developed content that can be used to help create effective campaigns. This includes a guide to running specific events which help promote vegetarian and vegan meals. </span></li>\r\n</ol>\r\n<p><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">World Vegetarian Day Event:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">&nbsp;Organize a special event on October 1st to celebrate World Vegetarian Day. Encourage employees to try vegetarian meals and provide educational resources, recipes, and tastings to spark their interest.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Meatless Monday Campaign:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> Launch a &ldquo;Meatless Monday&rdquo; campaign, encouraging employees to opt for vegetarian meals at least one day a week. Provide information on the benefits of plant-based diets and share delicious meatless recipes to inspire participation.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\">&nbsp;</p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Benefits Overview</span></strong></p>\r\n<ul type=\"disc\">\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo2; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">University of Oxford found that adopting a vegetarian diet could reduce an individual&rsquo;s carbon footprint by up to 73% &ndash; (unless you are a frequent flyer).</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo2; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Reducing meat consumption can also contribute to alertness, productivity and support in fighting major health issues such as obesity and heart disease.</span></li>\r\n</ul>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p>&nbsp;</p>','low','low',1,7,1,'2023-05-24'),(39,'2023-05-24 16:47:02','2023-08-08 15:06:21','Implement a travel management system','Control your company\'s travel volume and costs by enforcing a travel policy','<p>&nbsp;</p>\r\n<p>Implementing a travel management system can help a company reduce its carbon footprint in several ways:</p>\r\n<ul>\r\n<li><strong>Efficient travel planning:</strong> A travel management system enables centralised and streamlined travel planning and booking processes. It allows companies to optimize travel routes, minimize layovers, and select the most fuel-efficient modes of transportation. By reducing unnecessary travel and optimising itineraries, companies can significantly decrease their carbon emissions.</li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li><strong>Increase productivity and save time</strong>: Travel management systems often include features that promote virtual meetings and video conferencing. By leveraging these tools, companies can reduce the need for employees to travel for meetings and conferences, thereby minimizing transportation-related carbon emissions.&nbsp;</li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li><strong>Enhanced carbon emissions tracking</strong>: Many travel management systems integrate carbon emissions tracking capabilities. By measuring and reporting the carbon footprint associated with each trip, companies can gain valuable insights into their emissions profile. This information can be used to track trends, identify areas for improvement, set targets and monitor progress for reducing carbon emissions from travel within the wider company\'s Carbon Reduction Plan.&nbsp;</li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li><strong>Better access to alternative transportation options</strong>: A travel management system can provide employees with access to alternative transportation options such as public transportation or carpooling. The system can facilitate the coordination and scheduling of shared transportation arrangements, encouraging employees to choose greener alternatives.</li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li><strong>Align with sustainability policies and guidelines</strong>: Travel management systems can incorporate sustainability policies and guidelines, serving as a reminder and guide for employees to make sustainable travel choices. This includes selecting accommodation with strong environmental credentials, choosing airlines with lower emissions, or considering alternative travel modes like train or bus for shorter distances.</li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<p><strong>Estimated Impact</strong></p>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li>By implementing a travel management system, your company will make a significant step towards reducing the carbon emissions associated with company travel. This will ensure any company travel aligns closely with your company\'s net zero commitments and wider Carbon Reduction Plan.&nbsp;</li>\r\n</ul>','low','low',1,6,1,'2023-05-24'),(40,'2023-05-24 16:48:00','2023-05-24 16:48:00','Minimise the impact of company gatherings','Planning carefully on location, venue and transport can seriously lower the environmental impact of company gatherings',NULL,'moderate','low',1,6,1,'2023-05-24'),(41,'2023-05-24 16:50:11','2023-05-24 16:50:11','Circular value chain optimisation audit','Reviewing all current recurring purchases is a valuable way to look at alternative ways of purchasing and disposing in areas such as IT Hardware',NULL,'moderate','low',4,24,1,'2023-05-24'),(42,'2023-05-24 17:18:41','2023-08-02 11:59:18','Offset your residual carbon footprint','It takes time to become carbon neutral but a great short-term solution is to offset any carbon emissions you have via validated project','<p>&nbsp;</p>\r\n<p><strong>How Does Carbon Offsetting Work?</strong></p>\r\n<p>Offsetting carbon emissions is a continuous process starting with measuring your carbon footprint, setting a strategy to decarbonise your organization and offsetting emissions you can&rsquo;t reduce. Offsetting means you can take action now to reduce global emissions while low or zero emission approaches are developed for your company. &nbsp;</p>\r\n<p>Carbon offsets are just one tool to tackle climate change and should not be considered as a stand-alone action. After measuring a carbon footprint, organizations and individuals should reduce their emissions as much as possible, as well as taking responsibility for what remains, by buying carbon credits.</p>\r\n<p>This can be valuble to your business and allow you to demonstrate to stakeholders that you are both working towards avoiding and reducing your carbon footprint and also investing in being carbon neutral through offsets as you work towards <span lang=\"EN-GB\" style=\"font-size: 12.0pt; font-family: \'Calibri\',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: \'Times New Roman\'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-GB; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;\">Net Zero ambitions.</span></p>\r\n<p><strong>Options to Carbon Offset</strong></p>\r\n<p><span lang=\"EN-GB\" style=\"mso-ansi-language: EN-GB;\">Zerofy has a range of verified carbon offsetting projects than your company can pick from. The price for each project will depend on several factors, including location and the scope of what the project is looking to achieve, for example projects to build wind-energy in developing countries are often the cheapest offset projects ranging up to more wholistic sustainability investment projects looking at longer term economic shifts in developing countries. Importantly we also source from local partners so you can invest in projects within your local area.</span></p>\r\n<p><span lang=\"EN-GB\" style=\"mso-ansi-language: EN-GB;\">Given the range of offsetting projects available we advise to contact Zerofy for a short consultation if this is an area of interest and we can narrow the scope down with you to find the right types of projects in terms of costs and location that meet your requirements.</span></p>\r\n<p>&nbsp;</p>','low','low',34,35,1,'2023-05-24'),(43,'2023-05-24 17:31:36','2023-05-25 14:57:43','Be bold, creative, and conscious with products given in events','Opt for eco-friendly options in every products selection','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">Here are various marketing items that are given during events by the organisers and exhibitors. These products giveaways can create excitement during an event and elevate brand awareness. However, without proper considerations and planning it is highly likely that most of these products end up in landfills.&nbsp;</p>\r\n<p dir=\"ltr\">It is worthwhile to be bold and creative while conscious and responsible in designing and deciding your marketing giveaways. Instead of selecting objects, consider what kind of excitement you aspire to create during the event. Its better to give less with clear intention than to keep be seen giving items nobody needs.</p>\r\n<p dir=\"ltr\">With that in mind, consider the longevity, usefulness, and the entire life cycle of each item. Include option that are eco-friendly and circular. These items can be reusable, upcycled/ recycled, biodegradable, or digital. Make sure the items are produced and sourced ethically and sustainably.&nbsp;</p>\r\n<p dir=\"ltr\">Remember to communicate the sustainable attributes of your marketing freebies to the recipients. Use eco-friendly packaging, provide information on the materials used, and highlight the environmental benefits of the items. By opting for sustainable marketing giveaways, you can promote your brand, reduce waste while also promoting sustainable practices and values</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\"><strong>Estimated Impact</strong></p>\r\n<p dir=\"ltr\">The average person owns&nbsp; at least 30 promo items, most only hold onto the product for less than year.&nbsp;</p>\r\n<p><strong id=\"docs-internal-guid-0c9b7d28-7fff-6b05-d737-fd56ea4524c9\"><br><br><br></strong></p>','low','low',2,28,1,'2023-05-24'),(44,'2023-05-25 05:23:37','2023-05-25 14:53:32','Carbon Neutral Hotel Stays','Amend Travel Policy for Carbon Neutral Hotels','<p>&nbsp;</p>\r\n<p>When making staff hotel bookings a small amendment to your travel policy to first check to see if a Net Zero hotel option is available within the company policy pricing guidlines using the following website:</p>\r\n<p>https://staze.com/</p>','moderate','low',1,6,1,'2023-05-25'),(46,'2023-05-25 14:16:09','2023-11-10 10:18:45','Appoint & Educate the Carbon Heroes','Empower those championing your company’s sustainability initiatives through specialist tools, training and resources','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">The Carbon Heroes within your company play a critical role in understanding, implementing and promoting sustainability initiatives. The Carbon Heroes should act as ambassadors/influencers of your sustainability strategy and network with employees to create a culture of sustainability with your company. Employees should be able to rely on the Carbon Heroes for clarification and guidance on your actions.&nbsp;</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\">It is crucial that the Carbon Hero fully understands the &lsquo;carbon jargon&rsquo; and topics associated with your company&rsquo;s net zero journey. There are a number of short courses available for aspiring Carbon Heroes to participate in. These are available both online and in-person, subject to your company&rsquo;s location, availability and budget. Taking part in these courses will help to boost the Carbon Heroes&rsquo; confidence in motivating other employees in the company. The passion, knowledge and skills of the Carbon Hero should trickle down to the employees to promote their active participation in your company&rsquo;s net zero journey.&nbsp;</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\">Aside from progressing your company&rsquo;s net zero journey, emphasise the benefits that additional training will bring to the Carbon Heroes&rsquo; personal growth and professional development. Skills and knowledge acquired in the courses can be applied in the workplace and in your Carbon Heroes&rsquo; day-to-day lives.</p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\"><span style=\"text-decoration: underline;\">Video Content&nbsp;</span></p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">The links below will take you to a variety of clips surrounding the topic of sustainability. These clips should be distributed to the Carbon Heroes to educate and raise their awareness on why reducing carbon emissions is such a pertinent issue.</p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<ul>\r\n<li dir=\"ltr\"><strong>BBC Earth, \'The Tipping Point | Climate Change: The Facts | BBC Earth,</strong>&nbsp;<strong><a href=\"https://www.youtube.com/watch?v=febBRv2Vftk\">https://www.youtube.com/watch?v=febBRv2Vftk</a></strong></li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li dir=\"ltr\"><strong id=\"docs-internal-guid-85358264-7fff-8835-2e3b-d9e11fbf61b3\">Grist, \'The climate tipping points that could change the Earth forever\',&nbsp;<a href=\"https://www.youtube.com/watch?v=j3q7j8igyN4\">https://www.youtube.com/watch?v=j3q7j8igyN4</a></strong></li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li dir=\"ltr\"><strong>TED, \'What is net-zero?\', <a href=\"https://www.youtube.com/watch?v=QPmUAfuqM08\">https://www.youtube.com/watch?v=QPmUAfuqM08</a></strong></li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li dir=\"ltr\"><strong>Waterpedia, What is Sustainable Development and why is it important? <a href=\"https://www.youtube.com/watch?v=amDNovg9f0o\">https://www.youtube.com/watch?v=amDNovg9f0o</a></strong></li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>','low','low',1,7,1,'2023-05-25'),(47,'2023-06-05 14:18:01','2023-06-06 11:24:02','IT Hardware - Circular Economy','Avoid buying new Hardware such as laptops and phones','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">All companies depend on having a well-functioning IT that makes daily operations easy to maneuver. This necessitates regular updates and replacements so that the equipment is always up to date.&nbsp;</p>\r\n<p dir=\"ltr\">Circular Economy within IT Equipment is a sustainable approach to the entire life cycle of your equipment. This can give both substantial cost savings for your business whilst at the same time reducing the environmental impact of buying new, saving on Co2 emissions, water usage, chemicals and rare earth metals that are often extracted in negative ways for the local environment and people sourcing them.</p>\r\n<p dir=\"ltr\">In practice this means purchasing Refurbished IT equipment from reputable suppliers, for items such as laptops, monitors, phones, and other hardware devices. On top of this it is also possible to sell your old IT equipment or have it disposed of in an environmentally safe way.</p>\r\n<p dir=\"ltr\">Zerofy has a network of carefully selected partners within this area that can help your company set-up a circular economy for all your IT equipment. Our partners can offer all the support you need to get refurbished equipment when you need it and also dispose or sell obsolete equipment.</p>\r\n<p dir=\"ltr\"><strong>Estimated Impact</strong></p>\r\n<p dir=\"ltr\">The IT industry is responsible for 2% of all Co2 emissions. The circular economy encourages reuse and recycling. For every computer reused, we can reduce carbon dioxide emissions, save raw materials, and stimulate a circular economy where products are used more efficiently.</p>\r\n<p dir=\"ltr\">For 20 PC laptops this is the difference between buying New and Refurbished:</p>\r\n<ul>\r\n<li dir=\"ltr\" style=\"color: rgb(0, 0, 0); font-style: italic;\"><span style=\"color: rgb(0, 0, 0);\"><em>14,000 KG of C02</em></span></li>\r\n<li dir=\"ltr\" style=\"color: rgb(0, 0, 0); font-style: italic;\"><span style=\"color: rgb(0, 0, 0);\"><em>21,000 liters of Water</em></span></li>\r\n<li dir=\"ltr\" style=\"color: rgb(0, 0, 0); font-style: italic;\"><span style=\"color: rgb(0, 0, 0);\"><em>440 KG of Chemicals</em></span></li>\r\n</ul>\r\n<p><em>Source: Computers and the Environment: Understanding and Managing their Impacts</em></p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p>&nbsp;</p>','moderate','low',2,9,1,'2023-06-05'),(48,'2023-06-05 19:48:54','2023-06-05 19:49:25','Move to offices with newer standards','Moving to newer or refurbished building will reduce instantaneously company\'s carbon footprint','<p>&nbsp;</p>\r\n<p>Moving to new offices can contribute to reducing carbon emissions in several ways:</p>\r\n<p>1. <strong>Energy Efficiency</strong>: New office spaces are often designed with energy-efficient features, such as better insulation, efficient heating, ventilation, and air conditioning (HVAC) systems, and energy-saving lighting. These upgrades can significantly reduce energy consumption and associated carbon emissions compared to older, less efficient buildings.</p>\r\n<p>2. <strong>Renewable Energy Integration</strong>: When moving to new offices, companies have the opportunity to explore renewable energy options. They can install solar panels, wind turbines, or geothermal systems to generate clean energy on-site. By relying on renewable energy sources, the company can reduce its dependence on fossil fuels and decrease carbon emissions related to electricity consumption.</p>\r\n<p>3. <strong>Smart Building Technology</strong>: New office spaces often come equipped with advanced building management systems and smart technologies. These systems optimize energy usage by controlling lighting, temperature, and ventilation based on occupancy and environmental conditions. By utilizing smart building technology, companies can minimize energy waste and lower carbon emissions.</p>\r\n<p>4. <strong>Commute and Transportation</strong>: Moving to a new location can provide employees with improved transportation options, such as being closer to public transit stations, bike lanes, or walking paths. This can encourage employees to use greener commuting methods, reducing reliance on single-occupancy vehicles and lowering carbon emissions associated with daily commutes.</p>\r\n<p>5. <strong>Sustainable Infrastructure</strong>: New offices may be part of sustainable developments or eco-friendly buildings that prioritize green infrastructure. These include features like green roofs, rainwater harvesting systems, and natural landscaping. These sustainable elements contribute to carbon sequestration, reduce the urban heat island effect, and promote biodiversity, thus indirectly reducing carbon emissions.</p>\r\n<p>6. <strong>Behavioral Changes</strong>: Moving to a new office often coincides with a change in the work environment and culture. This presents an opportunity for companies to promote sustainability initiatives, encourage eco-friendly behaviors among employees, and implement policies such as waste reduction, recycling programs, and sustainable procurement practices. By fostering a culture of sustainability, companies can engage employees in carbon reduction efforts.</p>\r\n<p>By considering and implementing these sustainable practices during the transition to new offices, companies can significantly reduce their carbon footprint and demonstrate their commitment to environmental stewardship.</p>','large','high',3,16,1,'2023-06-05'),(49,'2023-06-07 20:04:41','2023-06-07 20:25:30','Set up solar panels on offices','Solar panels on offices reduce carbon footprint by generating clean energy, minimizing emissions, and offsetting carbon, promoting sustainability and long-term cost savings.','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">Installing solar panels on offices is an effective way to reduce carbon footprint and promote sustainability. Solar panels harness energy from the sun and convert it into electricity, providing a renewable energy source that reduces dependence on fossil fuels. By generating electricity from solar power, offices can minimize their contribution to carbon dioxide (CO2) emissions, which are a major cause of climate change.</p>\r\n<p dir=\"ltr\">Solar panels help reduce energy consumption from the grid. Offices often consume substantial amounts of electricity for various devices, lighting, and HVAC systems. By <strong>generating their own clean energy</strong>, offices can offset the need for grid electricity, which is often sourced from fossil fuel-based power plants. This reduces the carbon emissions associated with electricity generation and contributes to a greener energy mix.</p>\r\n<p dir=\"ltr\">Furthermore, some regions allow businesses to <strong>sell excess solar energy back to the grid</strong> through net metering or feed-in tariffs. This not only provides financial benefits to the office but also helps offset carbon emissions from other sources. By contributing renewable energy to the local grid, offices actively participate in carbon offsetting and support the transition to a cleaner energy system.</p>\r\n<p dir=\"ltr\">Installing solar panels also has advantages beyond environmental impact. It <strong>showcases a commitment to sustainability and corporate social responsibility</strong>, which can improve the public perception of the office and attract environmentally conscious customers, investors, and employees. Moreover, while the initial investment in solar panel installation may be significant, the long-term benefits outweigh the costs. Solar panels have a lifespan of 25-30 years and require minimal maintenance, resulting in long-term cost savings by reducing reliance on grid electricity and mitigating rising energy costs.</p>\r\n<p dir=\"ltr\">In conclusion, solar panels on offices offer a range of benefits for reducing carbon footprint. By generating clean energy, minimizing emissions, lowering energy consumption, contributing to carbon offsetting, and promoting sustainability, solar panels play a vital role in mitigating climate change and creating a greener future.</p>\r\n<p>&nbsp;</p>','large','high',3,16,1,'2023-06-07'),(51,'2023-06-07 20:35:08','2024-02-14 18:35:00','E-Bikes for Staff Commuting','Benefits for your staff and the Environment','<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\">&nbsp;</p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-US\" style=\"font-size: 11.0pt; font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">Our partner</span><span lang=\"EN-GB\" style=\"font-size: 11.0pt; font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> Elsykkelbutikken solves the transport needs to and from work for many people. Some companies need electric bikes to help run their business or to offer for staff to help with an alternative way to commute to the office. We have selected Elsykkelbutikken as they offer very competitive pricing and service support from local hubs, as well as financing options and full support in setting up company e-bike schemes for staff or for other business needs.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-outline-level: 2;\"><strong><span style=\"font-size: 11.0pt; font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">Financing</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span style=\"font-size: 11.0pt; font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">We help you apply for financing for your company.&nbsp;The process is simple and you can lease the e-bike for up to 5 years.&nbsp;Service costs may be included in the leasing price.&nbsp;Get in touch and we will help with this.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-outline-level: 2;\"><strong><span style=\"font-size: 11.0pt; font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">You get the VAT back!</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span style=\"font-size: 11.0pt; font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">The tax authority has established in a statement of principle that the purchase of an electric bicycle gives the right to a deduction of value added tax (this is different from a normal bicycle).&nbsp;</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><strong><span style=\"font-size: 11.0pt; font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">Estimated Impact</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span style=\"font-size: 11.0pt; font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">Commuting with car daily (under 1 hour each day) equals to 3.2 tonnes of CO2 per person per year so any changes to reduce commuting especially by non electric cars can have a significant carbon saving annualy accross your workforce.</span></p>','low','low',1,5,1,'2023-06-07'),(52,'2023-06-07 20:56:04','2023-06-07 20:58:39','Design policy for water conservation','Reducing water waste is a major contributor to climate change because energy-intensive processes such as water treatment and distribution require significant amounts of energy, leading to greenhouse gas emissions and contributing to global warming.','<p dir=\"ltr\">An example of a water conservation policy for a company could include the following measures and guidelines:</p>\r\n<p dir=\"ltr\" style=\"padding-left: 40px;\">1. <strong>Water Efficiency Measures</strong>: Encourage employees to use water efficiently by implementing measures such as installing low-flow faucets, toilets, and urinals, and maintaining them regularly to avoid leaks and water wastage.</p>\r\n<p dir=\"ltr\" style=\"padding-left: 40px;\">2. <strong>Irrigation Practices</strong>: Implement smart irrigation systems that use weather data or soil moisture sensors to optimize watering schedules, avoiding overwatering and reducing water waste. Use native and drought-resistant plants in landscaping to minimize irrigation needs.</p>\r\n<p dir=\"ltr\" style=\"padding-left: 40px;\" role=\"presentation\">3. <strong>Equipment and Facility Upgrades</strong>: Invest in water-efficient equipment, appliances, and technologies across the company\'s facilities. This can include water-efficient dishwashers, washing machines, cooling towers, and other industrial processes that require water.</p>\r\n<p dir=\"ltr\" style=\"padding-left: 40px;\" role=\"presentation\">4. <strong>Employee Education and Awareness</strong>: Conduct regular training sessions or workshops to educate employees about the importance of water conservation and provide tips on reducing water usage both in the workplace and at home. Encourage employees to report any leaks or water-related issues promptly.</p>\r\n<p dir=\"ltr\" style=\"padding-left: 40px;\" role=\"presentation\">5. <strong>Water Monitoring and Auditing</strong>: Implement a system to monitor water usage regularly and conduct periodic water audits to identify areas of excessive consumption and potential water-saving opportunities. Use the collected data to set targets for reducing water consumption.</p>\r\n<p dir=\"ltr\" style=\"padding-left: 40px;\" role=\"presentation\">6. <strong>Water Recycling and Reuse</strong>: Identify opportunities for water recycling and reuse within the company\'s operations. For example, implement rainwater harvesting systems to collect and utilize rainwater for non-potable purposes such as irrigation or toilet flushing.</p>\r\n<p dir=\"ltr\" style=\"padding-left: 40px;\" role=\"presentation\">7. <strong>Supplier Engagement</strong>: Encourage suppliers and vendors to adopt sustainable water practices and prioritize partnerships with environmentally responsible suppliers who share the commitment to water conservation.</p>\r\n<p dir=\"ltr\" style=\"padding-left: 40px;\" role=\"presentation\">8. <strong>Reporting and Accountability</strong>: Establish a reporting mechanism to track and report the company\'s water consumption and savings regularly. Set goals and targets for water reduction and track progress towards achieving them.</p>\r\n<p dir=\"ltr\" style=\"padding-left: 40px;\" role=\"presentation\">9. <strong>Community Outreach</strong>: Engage with local communities and participate in water conservation initiatives and programs. Collaborate with relevant organizations or institutions to raise awareness about water conservation and promote sustainable water practices beyond the company\'s premises.</p>\r\n<p dir=\"ltr\" style=\"padding-left: 40px;\" role=\"presentation\">10. <strong>Continuous Improvement</strong>: Regularly review and evaluate the effectiveness of the water conservation policy and associated measures. Identify opportunities for improvement and make necessary adjustments to ensure ongoing water efficiency and conservation efforts.</p>\r\n<p dir=\"ltr\">It\'s important to tailor the policy to the specific needs and operations of the company while considering local regulations and water availability.</p>\r\n<p>&nbsp;</p>','large','high',4,24,1,'2023-06-07'),(53,'2023-06-08 13:50:36','2023-06-08 13:50:36','Motivate your staff to take carbon reduction actions outside work','Bring your team together and nurture a sustainable culture within the organization.','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">It is essential to consider personal values, interests, and lifestyle when motivating your staff to take carbon reduction actions in their personal life. Encouraging these actions can positively impact the environment and their personal life and indirectly nurture a sustainable culture within the organization.&nbsp;</p>\r\n<p dir=\"ltr\">Start by educating your staff on the benefits of carbon reduction actions. Bringing everyone on the same page and sharing the company&rsquo;s values is vital. Set an example by implementing sustainable practices within the organization (e.g., plastic recycling, vegetarian meal day). Provides resources to support your staff in initiating their carbon reduction actions (e.g., local recycling programs, tips to save energy &amp; money). Whenever possible, incentivize these actions by offering perks such as financial support on public transport or bicycles or once per week free vegetarian.&nbsp;&nbsp;</p>\r\n<p dir=\"ltr\">Create a community of passionate staff members who take these actions and make them the ambassadors/influencers within the organization. Establish an internal social media group and organize events to promote a sustainable way of living and bring more people into the community.</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\"><strong>Estimated impact</strong></p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\">Transportation</p>\r\n<p dir=\"ltr\">Typical passenger car 271g CO2e per kilometer</p>\r\n<p dir=\"ltr\">Riding bikes &nbsp; &nbsp; 21g CO2e per kilometer</p>\r\n<p dir=\"ltr\">CO2e savings: 90% emission reduction</p>\r\n<p><strong><br><br></strong></p>\r\n<p dir=\"ltr\">Food</p>\r\n<p dir=\"ltr\">Beef/lamb &nbsp; 14.1 g CO2e per kcal</p>\r\n<p dir=\"ltr\">Vegetables &nbsp; &nbsp; 2.8 g CO2e per kcal</p>\r\n<p dir=\"ltr\">CO2e saving: 80% emission reduction</p>\r\n<p>&nbsp;</p>','low','low',1,7,1,'2023-06-08'),(54,'2023-06-08 19:25:00','2023-06-08 19:29:07','Efficient Driving Styles','If staff do need to drive, they can save money and C02 by driving efficiently','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">Efficient driving is a driving style that reduces fuel bills, cuts carbon emissions and lowers accident rates. It is about becoming a better driver, rather than sacrificing the performance or enjoyment of driving. For electric vehicles (EVs), efficient driving also brings greater vehicle range.</p>\r\n<p dir=\"ltr\">Save on fuel, reduce carbon emissions and improve air quality by following our driving tips and thinking about your vehicle choice. Driving efficiently also has safety benefits due to its strong focus on better anticipation.</p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\"><strong>Recommended Action</strong></p>\r\n<p dir=\"ltr\">The attached document gives a full guide to share with your staff on how they can reduce their fuel consumption by adapting their driving habits. This will give them both cost savings in fuel and reduce their environmental impact. The document explains how they can do this through:</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<ul>\r\n<li dir=\"ltr\">Drive Smoothly</li>\r\n<li dir=\"ltr\">Shift up early to a higher gear</li>\r\n<li dir=\"ltr\">Avoid excessive speeds</li>\r\n<li dir=\"ltr\">Windows Vs air conditioning&nbsp;</li>\r\n<li dir=\"ltr\">Tyre pressures</li>\r\n<li dir=\"ltr\">Tips for electric vehicles</li>\r\n</ul>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\"><strong>Benefits</strong></p>\r\n<ol>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Reduce fuel consumption</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Lower carbon emissions</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Lower risk of vehicle wear and tear</p>\r\n</li>\r\n</ol>\r\n<p>&nbsp;</p>','moderate','low',1,5,1,'2023-06-08'),(55,'2023-06-08 19:34:16','2023-06-08 19:35:59','Sustainable Travel Policy','Travel Policy for Financial Control & Plant','<p class=\"MsoNormal\">&nbsp;</p>\r\n<p class=\"MsoNormal\"><span style=\"mso-bidi-font-family: Arial;\">it is recommended that a sustainable travel hierarchy is adopted where travel to workplaces is<strong style=\"mso-bidi-font-weight: normal;\"> </strong>required and necessary (and home working or virtual alternatives cannot be implemented. Organisations that adopt shared desks and genuinely flexible working will see significant savings.]</span></p>\r\n<p class=\"MsoNormal\"><span style=\"mso-bidi-font-family: Arial;\">Making no journey provides the best financial and environmental savings, however sometimes a meeting, discussion, networking or activity needs to take place in some shape or form and cannot be simply neglected.<span style=\"mso-spacerun: yes;\">&nbsp; </span>The Sustainable Travel Hierarchy helps employees select the most suitable mode of transport. </span></p>\r\n<p class=\"MsoNormal\"><span style=\"mso-bidi-font-family: Arial;\">Before embarking on any journey, it is the responsibility of all employees and their line managers to ensure the most cost-effective means of travel and where applicable, appropriate accommodation is used. [For some organisations, &lsquo;cost effective&rsquo; may be replaced with such terms as &lsquo;sustainable&rsquo; or &lsquo;carbon efficient&rsquo;].</span></p>','moderate','low',1,6,1,'2023-06-08'),(56,'2023-06-09 06:51:16','2023-06-16 10:24:54','Energy Consumption Assessment of R&D Set-up','Energy Expert for Pharma R&D','<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">&nbsp;</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">Zerofy has a specific partner who specilaise in supporting pharmasutical R&amp;D facilities reduce their energy consumption by assessing various areas of the processes run, facilities and machinery. We recomend that an initial consultation takes place with our partner EECO2 to discuss any potential scope for energy savings within your direct control.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><strong><span lang=\"NO-BOK\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: NO-BOK; mso-fareast-language: EN-GB;\">Information on assements delivered by EECO2 and case study example attached:</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><strong><span style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">We deliver a 30% reduction in utilities usage with an average payback of 2.8 years.</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">Pharmaceutical and high-tech manufacturing is extremely energy intensive. With sustainability targets getting closer, understanding where to start and what to prioritise is critical to achieving success.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">Our&nbsp;<strong>3C&rsquo;s Assessment Process</strong>&nbsp;is in line with ISO50002 standards and focuses on reducing cost &amp; carbon whilst maintaining &amp; improving compliance. Our unique collaborative approach enables our experts to understand your site(s) current status, the barriers and priorities providing a comprehensive, cost effective, practical plan to reach your sustainability objectives.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">Delivered on-site or remote, separate or integrated, we utilise our experience and expertise to apply engineering best practice within the life science sector.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">To date we have assessed over 300 life science facilities, including manufacturing, laboratories and R&amp;D facilities across the world, with&nbsp;<strong>over 1TWh, 240,000tCO2e &amp; &pound;115 million of savings identified in the last 3-years</strong> alone.</span></p>','large','medium',3,16,1,'2023-06-09'),(57,'2023-06-09 07:59:11','2023-06-09 10:40:43','Strategies for Promoting Sustainability within the Workplace','Strategies For Promoting Sustainability In The Workplace','<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-outline-level: 3;\">&nbsp;</p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-outline-level: 3;\"><strong><span style=\"font-size: 10.5pt; font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">Do employees prefer sustainable companies?</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span style=\"font-size: 10.5pt; font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">77% </span><span lang=\"EN-GB\" style=\"font-size: 10.5pt; font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">of workers would like their company to be more sustainable *.&nbsp;Companies must take sustainability seriously in order to placate not only investors and customers but also employees.</span></p>\r\n<h2 style=\"background: white;\"><strong><span lang=\"EN-GB\" style=\"font-size: 10.5pt; font-family: \'Times New Roman\',serif; color: #06262d;\">Why engage employees in sustainability?</span></strong></h2>\r\n<p style=\"background: white; box-sizing: border-box; margin: 1.25rem 0px 0px; line-height: clamp(20px, 1.666vw, 24px); font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; text-align: start; widows: 2; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; word-spacing: 0px;\"><span lang=\"EN-GB\" style=\"font-size: 10.5pt; color: #06262d; mso-ansi-language: EN-GB;\">When you try to build a company culture, you need buy-in from all parties, starting with senior leadership and moving on to all other employees in the organisation. This does not happen by dictating how internal stakeholders will behave but rather by engaging with them on crucial topics.</span></p>\r\n<p style=\"background: white; box-sizing: border-box; line-height: clamp(20px, 1.666vw, 24px); font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; text-align: start; widows: 2; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; word-spacing: 0px; margin: 7.5pt 0cm 0cm 0cm;\"><span lang=\"EN-GB\" style=\"font-size: 10.5pt; color: #06262d; mso-ansi-language: EN-GB;\">If you want people to adopt environmentally friendly practices in the workplace, they need to understand what they need to do and why they need to do it. They must believe in the vision that the organisation has and want to work to fashion it into reality.</span></p>\r\n<p style=\"background: white; box-sizing: border-box; line-height: clamp(20px, 1.666vw, 24px); font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; text-align: start; widows: 2; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; word-spacing: 0px; margin: 7.5pt 0cm 0cm 0cm;\"><span lang=\"EN-GB\" style=\"font-size: 10.5pt; color: #06262d; mso-ansi-language: EN-GB;\">Staff engagement on sustainability involves a two-way conversation about the best ways your company can cut out damaging practices and integrate sustainability into the working day seamlessly. If employees help shape the policies, they will be more willing to implement them and work at them until they become successful.</span></p>\r\n<p style=\"background: white;\"><strong><span lang=\"EN-GB\" style=\"font-size: 10.5pt; mso-fareast-font-family: \'Times New Roman\'; mso-fareast-theme-font: major-fareast; color: #06262d; mso-ansi-language: EN-GB;\">Importance of Culture</span></strong></p>\r\n<p style=\"background: white;\"><span lang=\"EN-GB\" style=\"font-size: 10.5pt; mso-fareast-font-family: \'Times New Roman\'; mso-fareast-theme-font: major-fareast; color: #06262d; mso-ansi-language: EN-GB;\">Company culture </span><span lang=\"EN-GB\" style=\"font-size: 10.5pt; color: #06262d; mso-ansi-language: EN-GB;\">is key to driving positive changes, so the first step to promoting sustainability is to promote a green culture within the organisation. </span></p>\r\n<p style=\"background: white;\"><strong><span lang=\"EN-GB\" style=\"font-size: 10.5pt; color: #06262d; mso-ansi-language: EN-GB;\">Recommended Actions</span></strong></p>\r\n<p style=\"background: white;\"><span lang=\"EN-GB\" style=\"font-size: 10.5pt; color: #06262d; mso-ansi-language: EN-GB;\">Zerofy has attached a guide on actions to best engage with your staff and built sustainability into your culture. We also have presentations you can use as templates to use in meetings with staff to explain, engage and promote your actions.</span></p>','large','low',1,7,1,'2023-06-09'),(58,'2023-06-12 06:25:36','2023-06-12 06:25:36','Set Science Based Reduction Targets (SBT)','The ultimate commitment to hitting the 2030 and 2050 Net Zero goals','<p>&nbsp;</p>\r\n<h4 dir=\"ltr\">Science-Based Targets initiative (SBTi)</h4>\r\n<ul>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Companies must set reduction targets for their scope 1 and 2 emissions for the next 5-15 years that are consistent with a temperature rise below 1.5&deg;C compared to pre-industrial levels.</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Companies must also measure all of their scope 3 emissions</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">If the company&rsquo;s scope 3 emissions make up more than 40% of their total emissions, they must also set a reduction target for scope 3 emissions.</p>\r\n</li>\r\n</ul>\r\n<p dir=\"ltr\"><strong>In order to set SBTi&rsquo;s, companies must do the following:</strong></p>\r\n<ul>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Set a scope: Companies need to define the scope of their emissions, including which emissions sources will be covered by their target</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Choose a target setting method: companies need to select one of four SBTi-approved methods for setting their emissions targets</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Develop a target: Companies need to calculate their emissions reduction target based on their chosen method and ambition level, as well as set a timeline for achieving the target</p>\r\n</li>\r\n<li dir=\"ltr\" aria-level=\"1\">\r\n<p dir=\"ltr\" role=\"presentation\">Submit for validation: once the target has been developed, companies can submit it to the SBTi for validation, which involves an independent assessment to ensure the target meets the SBTi&rsquo;s criteria for scientific rigor and alignment with the Paris Agreement</p>\r\n</li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<p>https://sciencebasedtargets.org/step-by-step-process</p>','moderate','medium',34,35,1,'2023-06-12'),(60,'2023-08-03 12:40:28','2023-08-03 12:40:28','Educate employees about your initiatives','Ensure your team understands the Net Zero journey','<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\">Empower employees with information. The inclusive and active participation of employees is vital to the success of the company&rsquo;s sustainable initiative. It also ensures long-lasting change within the organization.&nbsp;</p>\r\n<p dir=\"ltr\">Providing sustainable training is a significant step in nurturing sustainable workplace culture. Employees need to understand the concept and why management initiated the green journey. Telling your employees what they need to do is NOT the best way to get their interest, trust, excitement, commitment, and ownership in the initiative. It is crucial to provide a space for employees to get involved in creating and deciding the company\'s green initiatives.&nbsp;&nbsp;&nbsp;</p>\r\n<p dir=\"ltr\">Nurture a bottom-up approach by offering field-specific sustainable training, incentives to start green challenges or projects, offer perks and additional incentives for sustainable champions within your organization. Let your employee drive your sustainable initiatives and make it a collective goal instead of a given goal by the management.&nbsp;</p>\r\n<p dir=\"ltr\">Educating employees on sustainable initiatives can help create a culture of sustainability within the company, which can benefit the environment, society, and the company itself. Strive to make every employee a sustainability champion.</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\"><span style=\"color: rgb(35, 111, 161);\"><strong>Estimated Impact</strong></span></p>\r\n<p dir=\"ltr\"><strong>Cost Saving</strong></p>\r\n<p dir=\"ltr\">Energy training and awareness campaigns can potentially create 6% of annual energy savings. This saving can be increased up to 21% with technological support and expertise. (International Energy Agency- IEA)&nbsp;</p>\r\n<p dir=\"ltr\"><strong>Improved productivity</strong></p>\r\n<p dir=\"ltr\">Companies that invest in employee training and development have a 24% higher profit margin than those that do not. (American Society for Training &amp; Development - ASTD)</p>\r\n<p>\'Motivate your staff to take carbon reduction actions outside work\',\'Bring your team together and nurture a sustainable culture within the organization\',\'</p>\r\n<p dir=\"ltr\">It is essential to consider personal values, interests, and lifestyle when motivating your staff to take carbon reduction actions in their personal life. Encouraging these actions can positively impact the environment and their personal life and indirectly nurture a sustainable culture within the organization.&nbsp;</p>\r\n<p dir=\"ltr\">Start by educating your staff on the benefits of carbon reduction actions. Bringing everyone on the same page and sharing the company&rsquo;s values is vital. Set an example by implementing sustainable practices within the organization (e.g., plastic recycling, vegetarian meal day). Provides resources to support your staff in initiating their carbon reduction actions (e.g., local recycling programs, tips to save energy &amp; money). Whenever possible, incentivize these actions by offering perks such as financial support on public transport or bicycles or once per week free vegetarian.&nbsp;&nbsp;</p>\r\n<p dir=\"ltr\">Create a community of passionate staff members who take these actions and make them the ambassadors/influencers within the organization. Establish an internal social media group and organize events to promote a sustainable way of living and bring more people into the community.</p>\r\n<p dir=\"ltr\">&nbsp;</p>\r\n<p dir=\"ltr\"><strong><span style=\"color: rgb(35, 111, 161);\">Estimated impact</span></strong></p>\r\n<p dir=\"ltr\"><strong>Transportation</strong></p>\r\n<p dir=\"ltr\">Typical passenger car 271g CO2e per kilometer</p>\r\n<p dir=\"ltr\">Riding bikes &nbsp; &nbsp; 21g CO2e per kilometer</p>\r\n<p dir=\"ltr\">CO2e savings: 90% emission reduction</p>\r\n<p dir=\"ltr\"><strong>Food</strong></p>\r\n<p dir=\"ltr\">Beef/lamb &nbsp; 14.1 g CO2e per kcal</p>\r\n<p dir=\"ltr\">Vegetables &nbsp; &nbsp; 2.8 g CO2e per kcal</p>\r\n<p dir=\"ltr\">CO2e saving: 80% emission reduction</p>\r\n<p>&nbsp;</p>','low','low',1,7,1,'2023-08-03'),(61,'2023-08-15 08:31:42','2023-08-15 08:34:24','Incentivise Low Carbon Travel through AI Technology','Utilise software that means every employee is automatically rewarded and recognised for deciding to commute sustainably','<p dir=\"ltr\">Recommendations related to education and empowerment may have helped to build a strong case for sustainable decision making amongst your company&rsquo;s employees. However, new software available ensures that every time an employee makes a sustainable commuting decision, it is recognised and rewarded. Use this innovative form of software in your company to engage employees further and ensure the majority are working towards the same sustainable travel goals.&nbsp;</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\">The Codos App is an effective and easily accessible tool which employees install on their smartphones to help motivate their sustainable commuting efforts. The Codos App employs Automated Transportation Mode Detection to detect when a sustainable transportation mode has been used to reach a destination.</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\">Research from Dr Voshmgir showed that purpose-driven tokens help to incentivise individuals&rsquo; behaviour towards a collective goal. By measuring the amount of CO2 avoided in each journey, employees can track their commute and receive purpose-driven &lsquo;Codos tokens&rsquo; for their positive sustainable efforts. These tokens can then be used to purchase products in a marketplace.&nbsp;</p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\">Automatic detection technology means that little effort is required by employees to understand the benefits of sustainable transportation modes for themselves and the planet. The App also promotes data privacy ensuring all user information is encrypted whilst validating sustainable commutes.&nbsp;</p>\r\n<p><strong><br><br><br><br></strong></p>\r\n<p dir=\"ltr\"><strong>Estimated Impact&nbsp;</strong></p>\r\n<p><strong>&nbsp;</strong></p>\r\n<p dir=\"ltr\">In the EU, if employees were to make one sustainable commute per week up to 36,000,000 tons of CO2 could be avoided.&nbsp;&nbsp;</p>\r\n<p>&nbsp;</p>','moderate','low',1,5,1,'2023-08-15'),(62,'2023-09-29 08:35:18','2023-10-06 08:17:42','Electric Car Scheme for Staff','EV Subscriptions via Salary Sacrifice','<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\">&nbsp;</p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">The UK Government now Allows Companies to offer electric cars to staff through salary sacrifice.&nbsp;</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Salary sacrifice offers a big incentive to both companies and their staff to switch to electric vehicles whilst allowing the employee to save&nbsp;<strong>30 to 60% on the cost of an electric car by paying from salary before tax,</strong> and the <strong>company also saves costs on National Insurance contributions</strong> from the salary scarified amounts made by staff. The company is also not liable for any financial risk and employees gain a significant benefit if they wanted to switch to an electric car.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">The most flexible way of accessing this is by setting up a company scheme through a Zerofy partner in the form of a <strong>flexible subscription model</strong>. This allows staff to enter a monthly subscription and gain tax savings on the following areas within a total monthly subscription that is then deducted from their salary. Staff can pick from a range of models at different prices and cancel with a month&rsquo;s notice if required if a persons situation should change.</span></p>\r\n<ul type=\"disc\">\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">The Car</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Servicing</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Insurance</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Home Charger</span></li>\r\n</ul>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\">&nbsp;</p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\">Check out the attached example for the salary benefits to staff.</p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\">&nbsp;</p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\">&nbsp;</p>','low','low',1,5,1,'2023-09-29'),(63,'2023-10-19 13:49:13','2023-11-08 09:37:53','Educate your employees to reduce energy usage at home','Staff tips to reduce energy consumption','<p class=\"sc-fccdlf\" style=\"vertical-align: baseline; box-sizing: inherit; margin: 1.2rem 0px; line-height: 2.4rem; max-width: none; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; text-align: start; widows: 2; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; word-spacing: 0px;\">&nbsp;</p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; text-align: justify; mso-outline-level: 1;\"><strong><span style=\"font-family: \'Futura Medium\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 18.0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">Making energy work better</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; text-align: justify; mso-outline-level: 1;\">&nbsp;</p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; text-align: justify; mso-outline-level: 2;\"><strong><span style=\"font-family: \'Futura Medium\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">For you, your wallet, and the planet</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; text-align: justify;\"><span style=\"font-family: \'Futura Medium\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">OVO</span><span lang=\"EN-US\" style=\"font-family: \'Futura Medium\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\"> energy is offering staff within all Zerofy customers specific support to improve your home energy usage. Helping</span><span style=\"font-family: \'Futura Medium\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\"> UK homes take steps to reduce their bills and our collective carbon footprint. So join us on the path to energy that works better for you, your wallet, and the planet.</span></p>\r\n<p class=\"MsoNormal\" style=\"text-align: justify;\"><span style=\"font-family: \'Futura Medium\',sans-serif; mso-ansi-language: #0C00;\">&nbsp;</span></p>\r\n<h4 style=\"text-align: justify; text-indent: -18.0pt; mso-list: l0 level1 lfo1; vertical-align: baseline; margin: 0cm 0cm .0001pt 18.0pt;\"><!-- [if !supportLists]--><span style=\"font-family: \'Futura Medium\',sans-serif; mso-fareast-font-family: \'Futura Medium\'; color: #2f3749; mso-ansi-language: #0C00; font-style: normal;\"><span style=\"mso-list: Ignore;\">1)<span style=\"font: 7.0pt \'Times New Roman\';\">&nbsp;&nbsp; </span></span></span><!--[endif]--><span lang=\"EN-GB\" style=\"font-family: \'Futura Medium\',sans-serif; color: #2f3749; font-style: normal;\">The energy revolution starts in your pocket</span></h4>\r\n<p class=\"sc-fccdlf\" style=\"text-align: start; vertical-align: baseline; box-sizing: inherit; margin: 1.2rem 0px; line-height: 2.4rem; max-width: none; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; word-spacing: 0px;\"><span style=\"font-family: \'Futura Medium\',sans-serif; color: #2f3749;\">Smart meter customers can check exactly how much energy their home&rsquo;s using at a glance. With our free app, find out the greenest time to use energy, and see where we think your energy&rsquo;s going, from cooking to entertainment.</span></p>\r\n<p class=\"MsoNormal\"><span style=\"mso-ansi-language: #0C00;\">&nbsp;</span></p>\r\n<h4 style=\"text-indent: -18.0pt; mso-list: l0 level1 lfo1; vertical-align: baseline; margin: 0cm 0cm .0001pt 18.0pt;\"><!-- [if !supportLists]--><span style=\"font-family: \'Futura\',sans-serif; mso-fareast-font-family: Futura; mso-bidi-font-family: Futura; color: #2f3749; mso-ansi-language: #0C00; font-style: normal;\"><span style=\"mso-list: Ignore;\">2)<span style=\"font: 7.0pt \'Times New Roman\';\">&nbsp;&nbsp; </span></span></span><!--[endif]--><span lang=\"EN-GB\" style=\"font-family: \'Futura\',sans-serif; color: #2f3749; font-style: normal;\">It&rsquo;s not watt, it&rsquo;s when</span></h4>\r\n<p class=\"sc-fccdlf\" style=\"vertical-align: baseline; box-sizing: inherit; margin: 1.2rem 0px; line-height: 2.4rem; max-width: none; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; text-align: start; widows: 2; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; word-spacing: 0px;\"><span style=\"font-family: \'Futura\',sans-serif; color: #2f3749;\">Get rewarded for using energy at off-peak times. Eligible customers can sign up for Power Move and benefit from using energy at greener times of the day and get money off their energy bills.</span></p>\r\n<p class=\"MsoNormal\"><span style=\"mso-ansi-language: #0C00;\">&nbsp;</span></p>\r\n<h4 style=\"text-indent: -18.0pt; mso-list: l0 level1 lfo1; vertical-align: baseline; margin: 0cm 0cm .0001pt 18.0pt;\"><!-- [if !supportLists]--><span style=\"font-family: \'Futura\',sans-serif; mso-fareast-font-family: Futura; mso-bidi-font-family: Futura; color: #2f3749; mso-ansi-language: #0C00; font-style: normal;\"><span style=\"mso-list: Ignore;\">3)<span style=\"font: 7.0pt \'Times New Roman\';\">&nbsp;&nbsp; </span></span></span><!--[endif]--><span lang=\"EN-GB\" style=\"font-family: \'Futura\',sans-serif; color: #2f3749; font-style: normal;\">Introducing OVO Energy Experts</span></h4>\r\n<p class=\"sc-fccdlf\" style=\"vertical-align: baseline; box-sizing: inherit; margin: 1.2rem 0px; line-height: 2.4rem; max-width: none; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; text-align: start; widows: 2; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; word-spacing: 0px;\"><span style=\"font-family: \'Futura\',sans-serif; color: #2f3749;\">Our OVO Energy Experts will come to your house and carry out a full assessment of how your home uses energy. Then you\'ll get a personalised Home Health Report with advice to help you save energy and money along with a brand new Energy Performance Certificate.</span></p>\r\n<p class=\"sc-fccdlf\" style=\"vertical-align: baseline;\"><span style=\"font-family: \'Futura\',sans-serif; color: #2f3749;\">&nbsp;</span></p>\r\n<h4 style=\"text-indent: -18.0pt; mso-list: l0 level1 lfo1; vertical-align: baseline; margin: 0cm 0cm .0001pt 18.0pt;\"><!-- [if !supportLists]--><span style=\"font-family: \'Futura\',sans-serif; mso-fareast-font-family: Futura; mso-bidi-font-family: Futura; color: #2f3749; mso-ansi-language: #0C00; font-style: normal;\"><span style=\"mso-list: Ignore;\">4)<span style=\"font: 7.0pt \'Times New Roman\';\">&nbsp;&nbsp; </span></span></span><!--[endif]--><span lang=\"EN-GB\" style=\"font-family: \'Futura\',sans-serif; color: #2f3749; font-style: normal;\">Greener Energy upgrade</span></h4>\r\n<p class=\"sc-fccdlf\" style=\"vertical-align: baseline; box-sizing: inherit; margin: 1.2rem 0px; line-height: 2.4rem; max-width: none; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; text-align: start; widows: 2; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; word-spacing: 0px;\"><span style=\"font-family: \'Futura\',sans-serif; color: #2f3749;\">Our supercharged upgrade is the most transparent way for you to buy green energy. It includes 100% renewable electricity, green and offset gas and an annual contribution of &pound;20 to help independent renewable power generators get up and running in the UK. Together we&rsquo;re powering a more sustainable future for the country.</span></p>\r\n<p class=\"sc-fccdlf\" style=\"vertical-align: baseline;\"><span style=\"font-family: \'Futura\',sans-serif; color: #2f3749;\">&nbsp;</span></p>\r\n<p class=\"MsoNormal\"><span style=\"mso-ansi-language: #0C00;\">&nbsp;</span></p>\r\n<p class=\"sc-fcCDlF jxbrVQ\">&nbsp;</p>','moderate','low',1,36,1,'2023-10-19'),(64,'2023-11-02 14:11:54','2023-11-02 14:11:54','Educate Event Attendees','Advise to Event Attendees on how to lower their carbon impact','<p><strong><span lang=\"EN-GB\" style=\"mso-ansi-language: EN-GB;\">Guidelines for Event Attendees</span></strong></p>\r\n<p><span lang=\"EN-GB\" style=\"mso-ansi-language: EN-GB;\">Much of the carbon footprint from physical events is driven by the attendees, how they travel to the event, how long they are staying in the area and the behaviour they follow whilst at the event.</span></p>\r\n<p><span lang=\"EN-GB\" style=\"mso-ansi-language: EN-GB;\">In order to reduce the impact that attendees have several actions can be taken in order to provide information on behaviour before and during the event as well as taking steps to give options and advise on how they can reduce their environmental impact.</span></p>\r\n<p><span lang=\"EN-GB\" style=\"mso-ansi-language: EN-GB;\">Zerofy provide best practice guidelines of how to reduce attendee impact that should be shared before the event and highlighted during the event. It is also to offer green alternatives where possible for areas such as travel, hotel stays and eating and drinking. A best practice guideline is provided that can be adapted to specific locations based on the best practice framework shown.</span></p>\r\n<p><strong><span lang=\"EN-GB\" style=\"mso-ansi-language: EN-GB;\">Other Actions</span></strong></p>\r\n<p><span lang=\"EN-GB\" style=\"mso-ansi-language: EN-GB;\">To get a more precise view of the carbon footprint derived from attendees and behaviour at the events additional data is needed to be collected on areas such as how they travel, where and how long they stay and what they do at the Event.</span></p>\r\n<p><span lang=\"EN-GB\" style=\"mso-ansi-language: EN-GB;\">This will give valuable insights into the &ldquo;real&rdquo; carbon footprint of the event and also how actions taken help to reduce this and change behaviour over time. As such we recommend creating surveys and voting mechanisms that can be used to engage, educate and document attendees that can be developed with the support of Zerofy.</span></p>','moderate','low',2,28,1,'2023-11-02'),(65,'2023-11-09 14:30:18','2023-11-13 10:53:53','Office Furniture - Circular economy','Circular model to office furnishings','<p class=\"MsoNormal\" style=\"mso-margin-bottom-alt: auto; line-height: 14.4pt; mso-outline-level: 2; background: white;\">&nbsp;</p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-bottom-alt: auto; line-height: 14.4pt; mso-outline-level: 2; background: white;\"><strong><span style=\"font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; color: black; letter-spacing: -.1pt; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">Fill the office &ndash; not the landfill</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"margin-bottom: 12.0pt; line-height: 18.0pt; background: white;\"><span style=\"font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; color: black; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">Every year, millions in tons of furniture are discarded by consumers and businesses. Under current models of consumption, one single workspace can represent between 140-320 kg of potential waste. Today&rsquo;s office planning and design is still largely defined by linear business models &mdash; ones that often result in accumulating goods and poor planning that leads to unnecessary waste.</span></p>\r\n<p class=\"MsoNormal\" style=\"margin-bottom: 12.0pt; line-height: 18.0pt; background: white;\"><strong><span lang=\"EN-US\" style=\"font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; color: black; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">New ways to furnish your office and reduce the impact on the Environment.</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"margin-bottom: 12.0pt; line-height: 18.0pt; background: white;\"><span lang=\"EN-US\" style=\"font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; color: black; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">A</span><span style=\"font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; color: black; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\"> circular business approach offers access to quality furniture and adaptable workspaces </span><span lang=\"EN-US\" style=\"font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; color: black; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">through a subscription model.</span><span style=\"font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; color: black; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\"> By choosing to subscribe instead of buy, you&rsquo;re taking an important step towards reducing the carbon footprint of your operations. When there is no longer a need for certain pieces of furniture in your office,&nbsp;</span><span lang=\"EN-US\" style=\"font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; color: black; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">i</span><span style=\"font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; color: black; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">nstead they will be refurbished and re-used, prolonging their lifespan.</span><span style=\"font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; color: black; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\"> </span><span style=\"font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; color: black; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: #0C00; mso-fareast-language: EN-GB;\">Products that previously lasted 3 years can now last for 30.</span><span lang=\"NO-BOK\" style=\"font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; color: black; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: NO-BOK; mso-fareast-language: EN-GB;\">&nbsp;</span><span lang=\"EN-US\" style=\"font-family: \'Arial\',sans-serif; mso-fareast-font-family: \'Times New Roman\'; color: black; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">Using a circular subscription approach to furnishing your office gives a flexible way to increase or decrease with the size and location of your business and allows you to have high-quality office fittings that are replenished with refurbished items when they are needed without throwing away old or buying brand new equipment.</span></p>\r\n<p class=\"MsoNormal\" style=\"margin-bottom: 12.0pt; line-height: 18.0pt; background: white;\">Zerofy have a partner that can help evaluate your needs and switch to a circular approach and we will gain a customised proposal for your business for your review if you want to find out exactly how this can work for you, the environmental savings it will give and costs to switch.</p>\r\n<h2 style=\"margin-top: 0cm; line-height: 14.4pt; background: white;\"><span style=\"font-size: 12.0pt; font-family: \'Arial\',sans-serif; color: black; letter-spacing: -.1pt;\">Reducing climate impact by up to 70% and increasing material use</span></h2>\r\n<p style=\"line-height: 18.0pt; background: white; box-sizing: border-box; overflow-wrap: break-word; margin: 0cm 0cm 12.0pt 0cm;\" data-block-key=\"stgw1\"><span style=\"font-family: \'Arial\',sans-serif; color: black;\">Based on a lifecycle analysis carried out by </span><span lang=\"EN-US\" style=\"font-family: \'Arial\',sans-serif; color: black; mso-ansi-language: EN-US;\">Zerofy Partner </span><span style=\"font-family: \'Arial\',sans-serif; color: black;\">NORNORM, comparing&nbsp;circular furnishing service with buying office furniture, significant benefits are identified with the circular model. The circular model reduces CO2 emission by up to 70% and makes better use of resources. The positive effects are generated through furniture circulation and prolonging their lifetime by up to 4 times compared to when furniture is bought.</span></p>','moderate','low',3,17,1,'2023-11-09'),(66,'2023-11-10 09:20:42','2023-11-10 10:04:01','Create Environmental Policy','Environmental Policy','<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\">&nbsp;</p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">What is an Environmental Policy?</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">An environmental policy addresses how a company manages and monitors its impact on the environment &ndash; both in its own operations and those of its supply chain. There is no set format but typically such policies cover use of energy and water, prevention of pollution, waste and recycling, and use of chemicals. As well as specific targets on reducing impact, a policy should also cover broader approaches to improving the environment such as changing work cultures, outreach and consumer behaviour.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Why have an Environmental Policy?</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Having an environmental policy can significantly benefit a business &ndash; helping it to meet legal requirements, cut costs, conserve raw materials and energy, and make processes more efficient. This is an important document that can be shared with staff as a framework of best practice to follow, with clients if they request to see your credentials and can be shared on your own website if you wish to publicise what you are actively doing to improve your impact on the environment.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Zerofy will support you carrying out your environmental assessment as part of your onboarding and develop a policy that fits your companies needs and aligns with the actions you are taking to improve your Environmental impact. This will form one of the key summary output reports to track your progress and aims over time.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">&nbsp;</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">What is included in an Environmental Policy?</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">While there is no set format for what to include in an environmental policy, criteria usually cover actions that specifically address environmental problems as well as broader approaches relating to company culture, outreach and consumer behaviour. These are some examples of the items used and we have included an example template you can download.</span></p>\r\n<ul type=\"disc\">\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">ensuring compliance with environmental legislation and other requirements</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">laying out the importance of environmental issues to the company&nbsp;</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">assessing the environmental impact of operations and supply chains</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">reducing pollution, emissions and waste</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">reducing the use of all raw materials and energy</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">raising awareness, encouraging participation and training staff in environmental matters</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">expecting similar environmental standards from all suppliers and contractors</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">assisting customers to use products and services in an environmentally sensitive way</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">liaising with the local community</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">communicating environmental aims and objectives to employees and external stakeholders.</span></li>\r\n</ul>','low','low',34,35,1,'2023-11-10');

--
-- Table structure for table `initiatives_partners`
--

CREATE TABLE `initiatives_partners` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `initiative_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `partner_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `initiatives_partners_partner_id_foreign` (`partner_id`),
  CONSTRAINT `initiatives_partners_partner_id_foreign` FOREIGN KEY (`partner_id`) REFERENCES `partners` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `initiatives_partners`
--

INSERT INTO `initiatives_partners` VALUES (2,'2023-05-15 08:11:30','2023-05-15 08:35:50','a:2:{i:0;s:1:\"2\";i:1;s:1:\"6\";}',2),(3,'2023-05-15 08:40:08','2023-05-24 05:25:10','a:1:{i:0;s:2:\"14\";}',3),(5,'2023-05-22 20:09:50','2023-05-22 20:09:50','a:1:{i:0;s:2:\"13\";}',7),(6,'2023-05-22 20:41:17','2023-05-22 20:41:17','a:1:{i:0;s:2:\"13\";}',8),(7,'2023-05-23 13:56:00','2023-05-23 13:56:00','a:1:{i:0;s:2:\"17\";}',9),(8,'2023-05-31 20:07:41','2023-05-31 20:07:41','a:1:{i:0;s:2:\"39\";}',10),(9,'2023-06-05 15:59:43','2023-06-05 15:59:43','a:1:{i:0;s:2:\"47\";}',11),(10,'2023-06-05 19:57:06','2023-06-05 19:57:06','a:1:{i:0;s:2:\"48\";}',12),(11,'2023-06-07 20:14:52','2023-06-07 20:14:52','a:1:{i:0;s:2:\"49\";}',13),(12,'2023-06-07 20:42:30','2023-06-07 20:42:30','a:1:{i:0;s:2:\"51\";}',14),(13,'2023-06-09 06:58:50','2023-06-09 06:58:50','a:1:{i:0;s:2:\"56\";}',15),(14,'2023-08-02 18:57:55','2023-08-02 18:57:55','N;',16),(15,'2023-09-29 08:47:03','2023-09-29 08:47:03','a:1:{i:0;s:2:\"62\";}',17),(16,'2023-10-19 13:51:27','2023-10-19 13:51:27','a:1:{i:0;s:2:\"63\";}',18),(17,'2023-11-09 14:36:28','2023-11-09 14:36:28','a:1:{i:0;s:2:\"65\";}',19);

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES (1,'2023-05-21 01:06:31','2023-05-21 01:06:31','EN','en.png');

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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=86 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,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2023_04_02_082457_create_tenants_table',1),(6,'2023_04_02_101655_create_initiatives_table',1),(7,'2023_04_02_102250_create_languages_table',1),(8,'2023_04_02_103506_create_partners_table',1),(9,'2023_04_02_103745_create_initiatives_partners_table',1),(10,'2023_04_02_104458_add_partner_id_to_initiatives_partners_table',1),(11,'2023_04_02_104943_create_tenants_recommended_initaitives_table',1),(12,'2023_04_02_105121_add_tenant_id_to_tenants_recommended_initaitives_table',1),(13,'2023_04_02_105822_create_timelines_table',1),(14,'2023_04_02_110124_add_tenant_id_to_timelines_table',1),(15,'2023_04_02_110206_add_initiative_id_to_timelines_table',1),(16,'2023_04_02_110439_add_user_id_to_timelines_table',1),(17,'2023_04_02_110812_create_timeline_progresses_table',1),(18,'2023_04_02_111025_add_timeline_id_to_timeline_progresses_table',1),(19,'2023_04_02_111137_add_user_id_to_timeline_progresses_table',1),(20,'2023_04_02_111250_create_timeline_comments_table',1),(21,'2023_04_02_111427_add_timeline_id_to_timeline_comments_table',1),(22,'2023_04_02_111512_add_user_id_to_timeline_comments_table',1),(23,'2023_04_02_111710_create_partner_services_table',1),(24,'2023_04_02_111846_add_partner_id_to_partner_services_table',1),(25,'2023_04_02_112009_create_service_inquieries_table',1),(26,'2023_04_02_112124_add_user_id_to_service_inquieries_table',1),(27,'2023_04_02_112217_add_partner_service_id_to_service_inquieries_table',1),(28,'2023_04_02_112405_create_initiative_partner_services_table',1),(29,'2023_04_02_112505_add_initiative_id_to_initiative_partner_services_table',1),(30,'2023_04_02_112626_add_partner_service_to_initiative_partner_services_table',1),(31,'2023_04_02_130750_create_categories_table',1),(32,'2023_04_02_131751_create_partner_services_categories_table',1),(33,'2023_04_02_131921_add_partner_service_id_to_partner_services_categories_table',1),(34,'2023_04_02_132023_add_category_id_to_partner_services_categories_table',1),(35,'2023_04_02_132203_create_initiative_categories_table',1),(36,'2023_04_02_132304_add_initiative_id_to_initiative_categories_table',1),(37,'2023_04_02_132411_add_category_id_to_initiative_categories_table',1),(38,'2023_04_02_132541_create_attachments_table',1),(39,'2023_04_02_132653_add_initiative_id_to_attachments_table',1),(40,'2023_04_02_133046_create_countries_table',1),(41,'2023_04_02_133301_create_cities_table',1),(42,'2023_04_02_133411_add_country_id_to_cities_table',1),(43,'2023_04_02_133556_create_tenants_countries_table',1),(44,'2023_04_02_133643_add_tenant_id_to_tenants_countries_table',1),(45,'2023_04_02_133715_add_city_id_to_tenants_countries_table',1),(46,'2023_04_02_134005_create_sub_sectors_table',1),(47,'2023_04_02_134024_create_sectors_table',1),(48,'2023_04_02_134310_add_sector_id_to_sub_sectors_table',1),(49,'2023_04_13_010745_add_user_id_to_tenants_table',1),(50,'2023_05_01_092128_add_role_to_users_table',1),(51,'2023_05_07_191704_add_initiative_id_to_tenants_recommended_initiatives',1),(52,'2023_05_08_140141_create_notifications_table',1),(53,'2023_05_09_112018_create_plans_table',1),(54,'2023_05_09_113345_create_progress_table',1),(55,'2023_05_09_115501_create_comments_table',1),(56,'2023_05_09_123614_create_initiative_by_tenant_table',1),(57,'2023_05_10_072340_add_initiative_id_to_plans_table',1),(58,'2023_05_10_072509_add_recommended_initiatives_id_to_plans_table',1),(59,'2023_05_10_072636_add_recommended_user_id_to_plans_table',1),(60,'2023_05_10_072646_add_recommended_tenant_id_to_plans_table',1),(61,'2023_05_10_072922_add_plan_id_to_progress_table',1),(62,'2023_05_10_073012_add_user_id_to_progress_table',1),(63,'2023_05_10_073023_add_tenant_id_to_progress_table',1),(64,'2023_05_10_073032_add_initiative_id_to_progress_table',1),(65,'2023_05_10_085136_add_plan_id_to_comments_table',1),(66,'2023_05_10_085145_add_user_id_to_comments_table',1),(67,'2023_05_10_085156_add_tenant_id_to_comments_table',1),(68,'2023_05_10_085206_add_progress_id_to_comments_table',1),(69,'2023_05_11_081741_initiative_by_tenants',1),(70,'2023_05_15_102411_add_token_to_plans_table',1),(71,'2023_05_15_125804_add_parent_id_to_users_table',1),(72,'2023_05_22_142810_create_attach_requests',2),(73,'2023_05_22_185742_add_user_id_to_attach_requests_table',2),(74,'2023_05_22_185802_add_initiative_id_to_attach_requests_table',2),(75,'2023_05_24_124924_update_category_id_to_tenants_recommended_initiatives_table',3),(76,'2023_05_24_125400_add_category_id_to_tenants_recommended_initiatives_table',3),(77,'2023_05_24_125514_add_sub_category_id_to_tenants_recommended_initiatives_table',3),(78,'2023_05_24_125530_add_sub_category_id_to_tenants_recommended_initiatives_table',3),(79,'2023_05_24_130453_update_category_id_to_initiatives_table',4),(80,'2023_05_31_113856_add_linkable_to_tenants_table',5),(81,'2023_05_31_120609_add_framelink_to_tenants_table',5),(82,'2023_08_01_085019_add_nullable_to_initiative_id_in_plans_table',6),(83,'2023_08_01_092825_add_initiative_by_tenant_id_to_plans_table',6),(84,'2023_08_01_141438_add_nullable_to_initiative_id_in_progress_table',6),(85,'2023_08_01_141524_add_initiative_by_tenant_id_to_progress_table',6);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint unsigned NOT NULL,
  `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `partner_services`
--

CREATE TABLE `partner_services` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `image_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `partner_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `partner_services_partner_id_foreign` (`partner_id`),
  CONSTRAINT `partner_services_partner_id_foreign` FOREIGN KEY (`partner_id`) REFERENCES `partners` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partner_services`
--

INSERT INTO `partner_services` VALUES (5,'2023-05-15 08:44:17','2023-05-22 18:58:45','Energy Consulting - Norway','<p>Services</p>\r\n<p>We offer a range of consultancy services within the following areas:</p>\r\n<ul>\r\n<li>A</li>\r\n<li>B</li>\r\n<li>C</li>\r\n<li>D</li>\r\n</ul>\r\n<p>The process is that we offer a free consultation after colleting come infomration via the Zerofy Platform and look at scnearios together.</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>','partner_service-1684142907.png',2),(6,'2023-05-22 20:14:28','2023-05-22 20:14:28','HR and Payroll Services','<p>Engaging with innovative HR and Payroll services will allow you to hire from anywhere, in a scalable way.&nbsp;</p>','partner_service-1684786468.jpg',7),(7,'2023-05-22 20:39:13','2023-05-22 20:41:25','Lunch boxes on-demand','<p>Your employees can order food delivered to the office only the day they want to work from the office, and avoid waste this way</p>','partner_service-1684787953.jpg',8),(8,'2023-05-23 13:58:14','2023-08-04 09:24:07','We can help support you with EV charging needs for your business, finding the best solution for you','<p>With the government\'s ban on the sale of petrol and diesel cars in 2030, your business may be looking at how you can move to an electric fleet or simply provide charging points for your customers and staff.</p>\r\n<p>With 57% of Britons considering EV\'s for their next vehicle purchase, installing electric car chargers could be good for your net zero targets as well as boosting revenue.</p>\r\n<p>As your expert partner, we\'ll design an electric vehicle charging solution around your business needs, whether it\'s charge point infrastructure for your workplace, or home charge points for your vehicle fleet, we\'ll support on everything from grant applications to operational training.</p>','partner_service-1691141047.jpeg',9),(9,'2023-05-24 05:28:02','2023-05-24 05:46:38','E-Bike Cycle to Work Scheme','<p>With 30 years of&nbsp;knowledge and years of experience in the cycling and leisure industries,&nbsp;we fully understand the needs of all our customers. We believe that our&nbsp;electric bicycle&nbsp;range is unsurpassed in terms of quality, reliability, efficiency and practicality as well as value for money.</p>\r\n<p>We can help you set-up your company e-bike cycle to work scheme and get that in place as well as offering a wide range of different e-bikes for your staff, along with service and repais. We are hear and ready to speak to you about your exact needs and to support you in each step of the way.</p>','partner_service-1684907198.jpeg',3),(10,'2023-05-31 20:01:35','2023-05-31 20:07:49','Travel Management Systems','<p>These platforms support you in ensuring that employees follow your travel policy, and will save time for your internal resources</p>','partner_service-1685563295.jpg',10),(11,'2023-06-05 16:04:54','2023-06-05 16:08:10','Tech Hardware through Circular Economy','<p>&nbsp;</p>\r\n<p>&nbsp;</p>','partner_service-1685981094.jpg',11),(12,'2023-06-05 20:00:07','2023-06-05 20:00:32','Flexible office spaces Norway','<p>Workspaces that offer adaptable and customizable options to meet the evolving needs of individuals and businesses. These spaces are designed to provide a flexible and agile working environment, allowing companies to adjust their office requirements based on factors such as team size, project duration, or business growth.</p>','partner_service-1685995207.jpg',12),(13,'2023-06-07 20:20:37','2023-06-07 20:20:37','Solar Panel Installation','<p>Connect with one of our partners to evaluate feasibility and eventually set up panels that will produce clean energy for you&nbsp;</p>','partner_service-1686169237.jpg',13),(14,'2023-06-07 20:46:25','2023-06-07 20:51:01','E-bikes for business',NULL,'partner_service-1686171061.png',14),(15,'2023-06-09 06:59:53','2023-06-09 07:05:21','Pharma R&D Energy Assessments','<div class=\"w-full relative zoom-in\">&nbsp;</div>\r\n<div class=\"w-full md:w-4/5 mx-4 zoom-in\">\r\n<h3 class=\"text-green leading-snug uppercase py-2\">ASSESSMENTS</h3>\r\n<div class=\"py-4\">\r\n<p><strong>We deliver a 30% reduction in utilities usage with an average payback of 2.8 years.</strong></p>\r\n<p>Pharmaceutical and high-tech manufacturing is extremely energy intensive. With sustainability targets getting closer, understanding where to start and what to prioritise is critical to achieving success.</p>\r\n<p>Our&nbsp;<strong>3C&rsquo;s Assessment Process</strong>&nbsp;is in line with ISO50002 standards and focuses on reducing cost &amp; carbon whilst maintaining &amp; improving compliance. Our unique collaborative approach enables our experts to understand your site(s) current status, the barriers and priorities providing a comprehensive, cost effective, practical plan to reach your sustainability objectives.</p>\r\n<p>Delivered on-site or remote, separate or integrated, we utilise our experience and expertise to apply engineering best practice within the life science sector.</p>\r\n<p>To date we have assessed over 300 life science facilities, including manufacturing, laboratories and R&amp;D facilities across the world, with&nbsp;<strong>over 1TWh, 240,000tCO2e &amp; &pound;115 million of savings identified in the last 3-years</strong>&nbsp;alone.</p>\r\n</div>\r\n</div>','partner_service-1686294321.png',15),(16,'2023-08-02 19:00:22','2023-08-02 19:11:02','Food disposal services','<p>Zerofy has multiple local and national partners that can support you recycle food waist from events.&nbsp;</p>','partner_service-1691003462.jpeg',16),(17,'2023-08-02 19:16:33','2023-08-02 19:16:33','Offer Vegetarian or Vegan Food Options','<p class=\"MsoNormal\"><span lang=\"EN-GB\">Specialist suppliers can provide vegetarian and vegan food for your company catering needs.</span></p>','partner_service-1691003793.png',16),(18,'2023-08-03 13:00:35','2023-08-04 09:36:11','Zerofy Multi Partner',NULL,'partner_service-1691141771.png',16),(19,'2023-09-29 08:48:29','2023-09-29 08:48:29','Electric Car Leasing/ Salary Sacrifice','<p>&nbsp;</p>\r\n<p class=\"MsoNormal\"><span lang=\"EN-GB\">Zerofy partner, Voltric offers full service offerings from setting up Electric Vehicle Salary Sacrifice schemes through to car delivery and management.</span></p>','partner_service-1695977309.png',17),(20,'2023-10-19 13:56:59','2023-10-20 06:37:59','Smart Thermostat',NULL,'partner_service-1697783879.jpeg',18),(21,'2023-11-09 14:38:01','2023-11-09 14:38:01','Circular economy - office furniture',NULL,'partner_service-1699540681.jpg',19);

--
-- Table structure for table `partner_services_categories`
--

CREATE TABLE `partner_services_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `partner_service_id` bigint unsigned NOT NULL,
  `category_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `partner_services_categories_partner_service_id_foreign` (`partner_service_id`),
  KEY `partner_services_categories_category_id_foreign` (`category_id`),
  CONSTRAINT `partner_services_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `partner_services_categories_partner_service_id_foreign` FOREIGN KEY (`partner_service_id`) REFERENCES `partner_services` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partner_services_categories`
--


--
-- Table structure for table `partners`
--

CREATE TABLE `partners` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `header_image_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sub_header_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partners`
--

INSERT INTO `partners` VALUES (2,'2023-05-15 08:11:30','2023-05-22 18:50:13','EEFFY','partner_logo-1684781413.png','partner_header_image-1684139982.png','Eeffy provides thorough and quick energy efficiency evaluation with instant ROI','<p>Your Eeffy consultant is helping</p>','tonetebo@gmail.com',NULL),(3,'2023-05-15 08:40:07','2023-05-24 05:25:10','UK Electric Bike Center','partner_logo-1684905910.jpeg','partner_header_image-1684905910.jpeg','Electric Bike','<p>With&nbsp; nearly 10 years of experience with electric bikes, we are one of the leading experts on Electric bikes in Kent. Whether looking to&nbsp;try before you&nbsp;buy, need a ebike service or repair&nbsp;or to hire an electric bike, we offer impartial and honest advice on selecting the best electric bike for your needs, the&nbsp;<strong>UK Electric Bike Centre Ltd is here to help you.</strong></p>','chris.hart@zerofy.io',NULL),(7,'2023-05-22 20:09:50','2023-05-22 20:09:50','Deel','partner_logo-1684786190.png','partner_header_image-1684786190.png','Deel allows you to hire anyone to work for you, from anywhere','<ul class=\"checklist\">\r\n<li><strong>Payroll &amp; Benefits.</strong>&nbsp;Pay your team on time, with one click, no matter where they live. Provide local benefits. Streamline offers &amp; onboarding.</li>\r\n<li><strong>Compliance.</strong>&nbsp;Avoid mistakes (and fines) with the right documentation in place. We know the local laws so you don\'t have to.</li>\r\n<li><strong>HRIS.</strong>&nbsp;Manage your entire global team in one HR platform, from people data, time off and&nbsp; expenses to reporting, performance, and more.</li>\r\n</ul>','antoine.thebault@zerofy.io',NULL),(8,'2023-05-22 20:41:17','2023-05-22 20:46:09','Lunsjkollektivet','partner_logo-1684788077.png','partner_header_image-1684788077.png','Lunsjkollektivet replaces the old canteen with a digital canteen that saves your company time, money and food waste','<p>Full cost control</p>\r\n<p>Zero food waste</p>\r\n<p>Amazing work lunch delivered to the door everyday</p>','antoine.thebault@zerofy.io',NULL),(9,'2023-05-23 13:56:00','2023-05-23 13:56:00','EV Charging Stations','partner_logo-1684850160.jpeg','partner_header_image-1684850160.jpeg','xxx','<p>With the government\'s ban on the sale of petrol and diesel cars in 2030, your business may be looking at how you can move to an electric fleet or simply provide charging points for your customers and staff.</p>\r\n<p>With 57% of Britons considering EV\'s for their next vehicle purchase, installing electric car chargers could be good for your net zero targets as well as boosting revenue.</p>\r\n<p>As your expert partner, we\'ll design an electric vehicle charging solution around your business needs, whether it\'s charge point infrastructure for your workplace, or home charge points for your vehicle fleet, we\'ll support on everything from grant applications to operational training.</p>','chris.hart@zerofy.io',NULL),(10,'2023-05-31 20:07:41','2023-05-31 20:09:16','TravelPerk','partner_logo-1685563661.png','partner_header_image-1685563661.png','All-in-One Platform to Book Corporate Flights, Hotels, Trains and Cars','<p><span style=\"font-size: 10pt;\">Book &amp; Manage Everything in one place. World\'s Largest Domestic &amp; International Inventory. Corporate Travel Tool and Corporate Travel Experts.</span></p>\r\n<div class=\"tick show\"><span style=\"font-size: 10pt;\">For Travel Managers, it allows you to:</span></div>\r\n<div class=\"tick show\">\r\n<div class=\"tick show\">\r\n<ul>\r\n<li style=\"font-size: 10pt;\"><span style=\"font-size: 10pt;\">Save time, money and stay in control</span></li>\r\n<li style=\"font-size: 10pt;\"><span style=\"font-size: 10pt;\">Achieve full travel policy compliance which reflect company\'s target to reduce travel</span></li>\r\n<li style=\"font-size: 10pt;\"><span style=\"font-size: 10pt;\">View &amp; track travel data in real-time, allowing accurate CO2 reporting. </span></li>\r\n<li style=\"font-size: 10pt;\"><span style=\"font-size: 10pt;\">Offset all company\'s travels, automatically</span></li>\r\n</ul>\r\n</div>\r\n<div class=\"tick show\">\r\n<div class=\"tick show\">&nbsp;</div>\r\n</div>\r\n</div>','antoine.thebault@zerofy.io',NULL),(11,'2023-06-05 15:59:43','2023-06-05 16:14:39','CHG Meridian','partner_logo-1685981679.jpeg','partner_header_image-1685981679.jpeg','Tech Hardware Circle Economy Experts','<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-outline-level: 1;\"><strong><span lang=\"EN-US\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 18.0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">Buy Refurbished IT Equipment</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-US\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">By choosing used computer equipment, you as a company get quality equipment at far lower purchase prices. The IT equipment that goes through our production is exclusively sourced from the corporate market where the build quality of the materials and electrical component is of a high standard. The equipment is carefully tested, erased, and cleaned before being sent out to new owners.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-US\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">Read more about buying refurbished: </span><span lang=\"NO-BOK\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: NO-BOK; mso-fareast-language: EN-GB;\"><a href=\"https://www.chg-meridianshop.no/buy/\"><span lang=\"EN-US\" style=\"color: blue; mso-ansi-language: EN-US;\">https://www.chg-meridianshop.no/buy/</span></a></span><span lang=\"EN-US\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">&nbsp;</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-outline-level: 1;\"><strong><span lang=\"EN-US\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 18.0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">Sell IT Equipment</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"NO-BOK\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: NO-BOK; mso-fareast-language: EN-GB;\"><a href=\"https://www.youtube.com/watch?v=CHwjArWP9xA\"><span lang=\"EN-US\" style=\"color: blue; mso-ansi-language: EN-US;\">https://www.youtube.com/watch?v=CHwjArWP9xA</span></a></span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-US\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">Many companies are sitting on old IT equipment that they can neither get rid of nor realize the value of. We give usable equipment a second life. Obsolete equipment is destroyed and recycled in an environmentally sound and safe manner. When the ICT equipment is going to the second-hand market, there are several considerations to consider, such as logistics, security, warranty, and the environment. We specialize in this. If your company wants to sell used IT equipment, we would like you to contact us and describe the equipment. Based on this information, we make an offer, and you can realize the value before it is too late.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-US\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">Read more about selling your IT: </span><span lang=\"NO-BOK\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: NO-BOK; mso-fareast-language: EN-GB;\"><a href=\"https://www.chg-meridianshop.no/sell/\"><span lang=\"EN-US\" style=\"color: blue; mso-ansi-language: EN-US;\">https://www.chg-meridianshop.no/sell/</span></a></span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-outline-level: 1;\"><strong><span lang=\"EN-US\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 18.0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">Greenlease New IT</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-US\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">At CHG-MERIDIAN, we have been providing leasing solutions for over 35 years and have helped our customers\' businesses grow. Make the most of your IT budget with a flexible and customized solution. Whether you\'re looking for an effective way to manage your portfolio or improve your procurement methods, we\'ll help you find a solution that multiplies your business over the life of assets.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-US\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">All companies depend on having a well-functioning IT park that makes daily operations easy to maneuver. This necessitates regular updates and replacements so that the equipment is always up to date. With a sustainable approach throughout the entire life cycle, where upgrading of the IT park takes place in an economical and simple way, you as a company will save both money and the environment in the long run. We take care of the entire lifecycle of your IT equipment for your business, so you as a customer can focus on usage and day-to-day operations.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;\"><span lang=\"EN-US\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-ansi-language: EN-US; mso-fareast-language: EN-GB;\">Minimum lease value 500,000 NOK</span></p>','chris.hart@zerofy.io',NULL),(12,'2023-06-05 19:57:06','2023-06-05 19:57:06','Spaces','partner_logo-1685995026.png','partner_header_image-1685995026.png','Office spaces with flexible contracts','<p>Spaces offers a range of flexible workspace solutions for individuals and businesses. Their services include fully furnished private offices, coworking spaces, meeting rooms, and virtual office options. They provide a dynamic and inspiring environment with modern amenities, high-speed internet, and access to professional business support services. Spaces in Oslo caters to diverse professional needs, promoting collaboration, networking, and productivity in a vibrant working community.</p>','antoine.thebault@zerofy.io',NULL),(13,'2023-06-07 20:14:52','2023-06-07 20:33:31','OTOVO','partner_logo-1686169712.png','partner_header_image-1686169712.png','The easiest way to get solar panel on your roof','<p><span style=\"font-size: 10pt;\">It&rsquo;s tailor-made for your roof: Otovo positions solar panels so that they make maximum use of sunlight, and you enjoy maximum reductions in your power bills<br>It&rsquo;s a deal that&rsquo;s right for you: There is no &lsquo;standard&rsquo; Otovo installation. It will be one that&rsquo;s perfect for your home, your budget and your schedule.<br>Otovo installs and connects: Otovo takes care of the entire process and paperwork before, during and after installation. You can track progress on your Otovo dashboard.<br>You enjoy economical electricity for decades: And you can sell any electricity you don&rsquo;t use to the national grid. Welcome to the future!</span></p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>','antoine.thebault@zerofy.io',NULL),(14,'2023-06-07 20:42:30','2023-06-07 20:50:35','The electric bike shop','partner_logo-1686171035.png','partner_header_image-1686170550.jpg','Electric Bike',NULL,'chris.hart@zerofy.io',NULL),(15,'2023-06-09 06:58:50','2023-06-09 07:06:09','EECO2','partner_logo-1686294369.png','partner_header_image-1686294369.webp','Energy Reduction - Pharma R&D Experts','<p><strong>EECO2 is trusted by the world&rsquo;s largest pharmaceutical companies to design and implement carbon and cost reduction strategies whilst maintaining or improving quality and compliance.</strong></p>\r\n<p>We help clients to achieve their sustainability goals. From global net zero initiatives to site or system level implementation, EECO2 provides the strategic and practical support required to effect impressive &amp; quantifiable results through energy efficiency.</p>','chris.hart@zerofy.io',NULL),(16,'2023-08-02 18:57:55','2023-08-04 09:36:36','.','partner_logo-1691141796.png','partner_header_image-1691141796.png','Multi Supplier Options','<p>For certain products and services Zerofy had a number of partners who we will contact on your request to find the best partner for your needs. If you want more details please hit the request button below.</p>','chris.hart@zerofy.io',NULL),(17,'2023-09-29 08:47:03','2023-09-29 08:47:03','EV Staff Subscription','partner_logo-1695977223.png','partner_header_image-1695977223.png','EV Leasing','<p>&nbsp;</p>\r\n<p class=\"MsoNormal\"><span lang=\"EN-GB\">Zerofy partner, Voltric offers full service offerings from setting up Electric Vehicle Salary Sacrifice schemes through to car delivery and management.</span></p>','chris.hart@zerofy.io',NULL),(18,'2023-10-19 13:51:27','2023-10-20 06:44:21','Staff - Home Energy Reduction','partner_logo-1697783830.png','partner_header_image-1697783830.jpeg','Smart Home - Thermostat','<div class=\"sc-dkrFOg styles__FeaturedItemSMContainer-sc-aqfo30-3 jPKqmy iRNdGP\">\r\n<div>\r\n<h2><span style=\"font-size: 11.0pt;\">Meet the wireless tado&deg; Smart Thermostat &ndash; just &pound;72</span></h2>\r\n<p class=\"sc-htbuwn\" style=\"margin-left: 18.0pt; text-indent: -18.0pt; mso-list: l0 level1 lfo1;\"><!-- [if !supportLists]--><span style=\"font-size: 10.0pt; mso-bidi-font-size: 11.0pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;\"><span style=\"mso-list: Ignore;\">&middot;<span style=\"font: 7.0pt \'Times New Roman\';\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><!--[endif]--><span style=\"font-size: 11.0pt;\">Control your heating and hot water wherever you are</span></p>\r\n<p class=\"sc-htbuwn\" style=\"margin-left: 18.0pt; text-indent: -18.0pt; mso-list: l0 level1 lfo1;\"><!-- [if !supportLists]--><span style=\"font-size: 10.0pt; mso-bidi-font-size: 11.0pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;\"><span style=\"mso-list: Ignore;\">&middot;<span style=\"font: 7.0pt \'Times New Roman\';\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><!--[endif]--><span style=\"font-size: 11.0pt;\">Reduce the energy your heating uses &ndash; by up to 28%<sup>1</sup></span></p>\r\n<p class=\"sc-htbuwn\" style=\"margin-left: 18.0pt; text-indent: -18.0pt; mso-list: l0 level1 lfo1;\"><!-- [if !supportLists]--><span style=\"font-size: 10.0pt; mso-bidi-font-size: 11.0pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;\"><span style=\"mso-list: Ignore;\">&middot;<span style=\"font: 7.0pt \'Times New Roman\';\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><!--[endif]--><span style=\"font-size: 11.0pt;\">Exclusive price for OVO members of &pound;72 (saving of &pound;127.99)<sup>2, 3</sup></span></p>\r\n<p class=\"sc-fccdlf\"><span style=\"font-size: 11.0pt;\">Pay &pound;72 now or &pound;6 a month for 12 months.<sup>2</sup></span></p>\r\n<h3><span style=\"font-size: 11.0pt;\">Fit your heating around your routine</span></h3>\r\n<p class=\"sc-fccdlf\"><span style=\"font-size: 11.0pt;\">Smart Schedule lets you plan your temperature by the hour. So your heating is always just right.</span></p>\r\n<h3><span style=\"font-size: 11.0pt;\">Works with the weather</span></h3>\r\n<p class=\"sc-fccdlf\"><span style=\"font-size: 11.0pt;\">tado&deg; adapts to your local weather forecast. So on a sunny day, tado&deg; turns down the heating to save energy.</span></p>\r\n<h3><span style=\"font-size: 11.0pt;\">Keep that lovely heat in</span></h3>\r\n<p class=\"sc-fccdlf\"><span style=\"font-size: 11.0pt;\">tado&deg; detects open windows and reminds you to turn down your heating to save energy.</span></p>\r\n<h3><span style=\"font-size: 11.0pt;\">Never heat an empty home</span></h3>\r\n<p class=\"sc-fccdlf\"><span style=\"font-size: 11.0pt;\">With Geofencing, tado&deg; reminds you to turn down the heating when you leave the house, and to turn it up before you get home.</span></p>\r\n<p class=\"MsoNormal\"><span style=\"mso-ansi-language: #0C00;\">&nbsp;</span></p>\r\n</div>\r\n</div>','chris.hart@zerofy.io',NULL),(19,'2023-11-09 14:36:28','2023-11-13 11:52:19','NORNORM','partner_logo-1699540854.jpg','partner_header_image-1699540813.jpg','Circular economy - office furniture','<p class=\"MsoNormal\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Arial\',sans-serif; color: black; letter-spacing: -.1pt; font-weight: normal;\">Zerofy partner NORNORM offers a new and flexible way of equipping your office with modern, attractive Nordic design furniture. You can customise the set-up you need for your offices and change the set-up as you require over time. </span></strong><strong><span lang=\"EN-GB\" style=\"font-family: \'Arial\',sans-serif; color: black; letter-spacing: -.1pt; font-weight: normal;\">Rather than buying or renting new equipment, you can simply change your subscription to match your needs. If your furniture needs replacing, Nor Norm will replace furniture using their pool of refurbished equipment giving large savings on waist.&nbsp;</span></strong></p>\r\n<p class=\"MsoNormal\"><a title=\"NORNORM PRODUCT RANGE\" href=\"https://nornorm.com/styles-brands/\" target=\"_blank\" rel=\"noopener\">NORNORM PRODUCT RANGE</a></p>\r\n<p class=\"MsoNormal\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Arial\',sans-serif; color: black; letter-spacing: -.1pt; font-weight: normal;\">Your company is charged based on a subscription model per the size of your office and this removes much of the upfront costs of equipping office space.&nbsp;</span></strong><strong><span lang=\"EN-GB\" style=\"font-family: \'Arial\',sans-serif; color: black; letter-spacing: -.1pt; font-weight: normal;\">You pay a small set-up fee and monthly subscription depending on the size of your office, which can be changed to meet your needs and if you move office so does the subscription.</span></strong></p>\r\n<p class=\"MsoNormal\">&nbsp;</p>\r\n<p class=\"MsoNormal\"><strong><span lang=\"EN-GB\" style=\"font-family: Arial, sans-serif; color: black; letter-spacing: -0.1pt;\">The Zerofy team will assist you in getting a full offer from NORNORM, just contact us via the button below.</span></strong></p>\r\n<p class=\"MsoNormal\">&nbsp;</p>\r\n<p class=\"MsoNormal\"><strong>How NORNORM works</strong></p>\r\n<p class=\"MsoNormal\"><strong><span lang=\"EN-US\" style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: EN-US;\">Step 1 - </span></strong><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">Tell us your needs. Let us know about your personal style, functional needs and floor plan so that we can get a clear sense of what you are looking for and how to best facilitate your needs. Our solutions cover everything from a lounge area to an entire office revamp.</span><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">&nbsp;</span></p>\r\n<p class=\"MsoNormal\"><strong><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">Step 2 -</span></strong><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">&nbsp; See your new workspace. We will then create a bespoke furnishing solution and generate an interactive 3D-model of your floor plan. With this model, you can easily add and remove elements, get a live price estimate and share it with your colleagues before sign-off.</span></p>\r\n<p class=\"MsoNormal\"><strong><span lang=\"EN-US\" style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: EN-US;\">Step 3 - </span></strong><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">Set-Up/ all-in-one solution Once the designing phase is done and a build date has been booked, we will come and install the furniture at your premises on the first day of the subscription.</span><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">&nbsp;</span></p>\r\n<p class=\"MsoNormal\"><strong><span lang=\"EN-US\" style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: EN-US;\">Step 4 -</span></strong><strong><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">&nbsp;</span></strong><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">Day-to-day Facilitate the day-to-day work with services such as the NORNORM app. For example, you can have the height on your sit or stand desk automatically adjust to your preferences upon arrival or order repairs by simply scanning barcodes that are outfitted on each piece of furniture.</span></p>\r\n<p class=\"MsoNormal\"><strong><span lang=\"EN-US\" style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: EN-US;\">Step 5 -</span></strong><span lang=\"EN-US\" style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: EN-US;\"> </span><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">Change - Tailored to you Our personalised service does not end at the &ldquo;checkout&rdquo; button. See your relationship with us </span><span lang=\"EN-US\" style=\"font-family: \'MS Gothic\'; mso-bidi-font-family: \'MS Gothic\'; mso-ansi-language: #0C00;\"> </span><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">as an ongoing dialogue instead of a one-time exchange. You are free to make design changes at any time. Scale up, scale down and switch it all around.</span></p>\r\n<p class=\"MsoNormal\"><strong><span lang=\"EN-US\" style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: EN-US;\">Step 6 -</span></strong><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\"> We go full circle If changes are made to your plan, or if you decide to cancel your subscription, we&rsquo;ll come to disassemble and collect the furniture at your premises. To minimise waste and increase the lifespan of our products, we repair, refurbish and circulate all our retired furniture to other businesses.</span></p>\r\n<p class=\"MsoNormal\">&nbsp;</p>\r\n<p class=\"MsoNormal\"><strong><span lang=\"EN-AU\" style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: EN-AU;\">NORNORM Pricing Model</span></strong></p>\r\n<p class=\"MsoNormal\"><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">&nbsp;</span></p>\r\n<p class=\"MsoNormal\"><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">Pricing Monthly subscription starting from &euro;3 per m&sup2; and set-up fee starting from &euro;18 per m&sup2;</span><span lang=\"EN-US\" style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: EN-US;\">. </span><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">Our subscriptions don\'t just deliver quality furniture, they provide every additional service that enable a complete and circular workspace.</span><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">&nbsp;</span></p>\r\n<p class=\"MsoNormal\"><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Design of your workspace</span></p>\r\n<p class=\"MsoNormal\"><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Flexibility to change whenever</span></p>\r\n<p class=\"MsoNormal\"><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; All the furniture you need</span></p>\r\n<p class=\"MsoNormal\"><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Delivery, assembly &amp; setup</span></p>\r\n<p class=\"MsoNormal\"><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Service and management via our app</span></p>\r\n<p class=\"MsoNormal\"><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">&nbsp;</span></p>\r\n<p class=\"MsoNormal\"><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">With our subscription model, your company not only pays less for furniture but gets a fully designed, fitted, and installed workplace that we adapt to your needs over time. All our furniture is part of our circular ecosystem, contributing to a healthy workplace environment.</span></p>\r\n<p class=\"MsoNormal\"><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">&nbsp;</span></p>\r\n<p class=\"MsoNormal\"><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No large investment upfront</span></p>\r\n<p class=\"MsoNormal\"><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Flexible for functional changes</span></p>\r\n<p class=\"MsoNormal\"><span style=\"font-family: \'Arial\',sans-serif; mso-ansi-language: #0C00;\">&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pay for what you need, when you need it</span></p>\r\n<h3 style=\"margin-left: 18.0pt; text-align: justify; text-indent: -18.0pt; line-height: 14.4pt; background: white;\"><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\"><strong><span lang=\"EN-GB\" style=\"color: black; letter-spacing: -0.1pt;\">&nbsp;</span></strong></span></h3>','chris.hart@zerofy.io',NULL);

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--


--
-- Table structure for table `plans`
--

CREATE TABLE `plans` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `initiative_id` bigint unsigned DEFAULT NULL,
  `recommended_initiatives_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `tenant_id` bigint unsigned NOT NULL,
  `owner_id` tinyint NOT NULL DEFAULT '0',
  `owner_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `assigned` tinyint NOT NULL DEFAULT '0',
  `from_date` date DEFAULT NULL,
  `to_date` date DEFAULT NULL,
  `progress` tinyint NOT NULL DEFAULT '4',
  `status` tinyint NOT NULL DEFAULT '0',
  `initiative_from` tinyint NOT NULL,
  `api_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `initiativeByTenant_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `plans_initiative_id_foreign` (`initiative_id`),
  KEY `plans_recommended_initiatives_id_foreign` (`recommended_initiatives_id`),
  KEY `plans_user_id_foreign` (`user_id`),
  KEY `plans_tenant_id_foreign` (`tenant_id`),
  KEY `plans_initiativebytenant_id_foreign` (`initiativeByTenant_id`),
  CONSTRAINT `plans_initiative_id_foreign` FOREIGN KEY (`initiative_id`) REFERENCES `initiatives` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `plans_initiativebytenant_id_foreign` FOREIGN KEY (`initiativeByTenant_id`) REFERENCES `initiative_by_tenants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `plans_recommended_initiatives_id_foreign` FOREIGN KEY (`recommended_initiatives_id`) REFERENCES `tenants_recommended_initiatives` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `plans_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `plans_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=391 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plans`
--

INSERT INTO `plans` VALUES (219,'2023-07-27 13:07:54','2023-07-27 13:07:54',58,NULL,13,5,5,'chris.hart@zerofy.io',0,'2023-07-27','2023-07-27',1,0,1,NULL,NULL),(232,'2023-08-07 13:43:25','2023-09-07 15:10:55',13,147,2,1,12,'fadwayassin4@gmail.com',0,NULL,NULL,4,0,0,'7661b720e1a764cacf7643ca2e65983a',NULL),(233,'2023-08-11 08:17:13','2023-08-11 08:18:11',13,60,7,3,5,'chris.hart@zerofy.io',0,NULL,NULL,1,0,0,NULL,NULL),(234,'2023-08-11 08:17:17','2023-08-11 08:17:17',48,66,7,3,0,NULL,0,NULL,NULL,4,0,0,NULL,NULL),(235,'2023-08-11 08:17:20','2023-08-11 08:18:58',47,64,7,3,0,NULL,0,NULL,NULL,2,1,0,NULL,NULL),(236,'2023-08-12 22:05:31','2023-08-12 22:05:46',NULL,NULL,2,1,0,'s.hiary@techsfactory.com',0,'2023-08-15','2023-10-07',1,1,1,'a58f8860964f7069cbd30ce4b580dd3a',67),(237,'2023-08-12 22:06:11','2023-08-12 22:06:11',NULL,NULL,2,1,0,'s.hiary@techsfactory.com',0,'2023-08-18','2023-09-28',3,0,1,'90d2341c1890b2bb0bf10fba893b88c9',68),(238,'2023-08-13 11:08:30','2023-08-13 12:48:03',NULL,NULL,2,1,16,'a.talafha@techsfactory.com',1,'2023-08-15','2023-09-20',2,1,1,'0c13a21d3ae2e838791b205892b7cc45',69),(241,'2023-08-14 10:05:01','2023-08-14 10:07:41',NULL,NULL,2,1,19,'a.talafha@techsfactory.com',1,'2023-08-09','2023-08-25',2,0,1,'e739adae8d7c3d5f827ae4f4bdc86950',72),(286,'2023-10-30 17:02:00','2023-11-07 11:04:36',35,45,3,2,0,NULL,0,NULL,NULL,1,0,0,NULL,NULL),(291,'2023-11-02 13:48:09','2023-11-02 13:48:22',24,30,3,2,0,NULL,0,NULL,NULL,1,0,0,NULL,NULL),(292,'2023-11-02 14:12:30','2023-11-02 14:13:19',64,158,3,2,0,NULL,0,NULL,NULL,1,0,0,NULL,NULL),(295,'2023-11-07 11:06:45','2023-11-07 11:06:45',16,116,3,2,0,NULL,0,NULL,NULL,4,0,0,NULL,NULL),(311,'2023-11-24 09:13:07','2023-11-24 09:13:07',29,37,3,2,0,NULL,0,NULL,NULL,4,0,0,NULL,NULL),(312,'2023-11-24 09:13:18','2023-11-24 09:13:18',27,35,3,2,0,NULL,0,NULL,NULL,4,0,0,NULL,NULL),(313,'2023-11-24 09:13:53','2023-11-24 09:13:53',25,117,3,2,0,NULL,0,NULL,NULL,4,0,0,NULL,NULL),(314,'2023-11-24 09:14:07','2023-11-24 09:14:07',57,148,3,2,0,NULL,0,NULL,NULL,4,0,0,NULL,NULL),(315,'2023-11-24 09:14:23','2023-11-24 09:14:23',53,151,3,2,0,NULL,0,NULL,NULL,4,0,0,NULL,NULL),(316,'2023-11-24 09:50:17','2023-11-24 09:50:17',55,152,3,2,0,NULL,0,NULL,NULL,4,0,0,NULL,NULL),(317,'2023-11-24 09:50:23','2024-02-01 14:49:33',22,43,3,2,0,'Hassan.mughal@wearecreative.uk',0,NULL,NULL,4,0,0,'928807bd287983a56d809e4acbbc1602',NULL),(353,'2024-01-22 08:19:18','2024-01-22 08:19:18',28,36,3,2,0,NULL,0,NULL,NULL,4,0,0,NULL,NULL),(354,'2024-01-22 08:19:25','2024-01-22 08:19:25',34,44,3,2,0,NULL,0,NULL,NULL,4,0,0,NULL,NULL),(355,'2024-01-22 08:19:31','2024-03-14 10:34:33',44,54,3,2,0,'Sarah.jones@wearecreative.uk',0,NULL,NULL,4,0,0,'9a2f5f943384999bdf1084bbed1a774e',NULL),(356,'2024-01-22 08:19:35','2024-01-22 08:19:35',37,115,3,2,0,NULL,0,NULL,NULL,4,0,0,NULL,NULL),(357,'2024-01-22 08:19:40','2024-01-22 08:19:40',60,119,3,2,0,NULL,0,NULL,NULL,4,0,0,NULL,NULL),(387,'2024-03-01 10:10:30','2024-03-01 10:10:30',60,121,15,6,0,NULL,0,NULL,NULL,4,0,0,NULL,NULL),(388,'2024-03-01 10:10:33','2024-03-01 10:10:33',13,122,15,6,0,NULL,0,NULL,NULL,4,0,0,NULL,NULL),(389,'2024-03-12 11:57:55','2024-03-12 11:57:55',31,39,3,2,0,NULL,0,NULL,NULL,4,0,0,NULL,NULL),(390,'2024-03-13 15:42:48','2024-03-13 15:42:48',22,129,15,6,0,NULL,0,NULL,NULL,4,0,0,NULL,NULL);

--
-- Table structure for table `progress`
--

CREATE TABLE `progress` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `plan_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `tenant_id` bigint unsigned NOT NULL,
  `initiative_id` bigint unsigned DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `initiativeByTenant_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `progress_plan_id_foreign` (`plan_id`),
  KEY `progress_user_id_foreign` (`user_id`),
  KEY `progress_tenant_id_foreign` (`tenant_id`),
  KEY `progress_initiative_id_foreign` (`initiative_id`),
  KEY `progress_initiativebytenant_id_foreign` (`initiativeByTenant_id`),
  CONSTRAINT `progress_initiative_id_foreign` FOREIGN KEY (`initiative_id`) REFERENCES `initiatives` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `progress_initiativebytenant_id_foreign` FOREIGN KEY (`initiativeByTenant_id`) REFERENCES `initiative_by_tenants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `progress_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `progress_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `progress_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=440 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `progress`
--

INSERT INTO `progress` VALUES (259,'2023-07-27 13:07:54','2023-07-27 13:07:54',219,13,5,58,'',NULL),(267,'2023-08-07 13:43:25','2023-08-07 13:43:25',232,2,1,13,'',NULL),(268,'2023-08-11 08:17:13','2023-08-11 08:17:13',233,7,3,13,'',NULL),(269,'2023-08-11 08:17:17','2023-08-11 08:17:17',234,7,3,48,'',NULL),(270,'2023-08-11 08:17:20','2023-08-11 08:17:20',235,7,3,47,'',NULL),(272,'2023-08-12 22:05:31','2023-08-12 22:05:31',236,2,1,NULL,'',67),(273,'2023-08-12 22:06:11','2023-08-12 22:06:11',237,2,1,NULL,'',68),(274,'2023-08-13 11:08:30','2023-08-13 11:08:30',238,2,1,NULL,'',69),(277,'2023-08-14 10:05:01','2023-08-14 10:05:01',241,2,1,NULL,'',72),(323,'2023-10-30 17:02:00','2023-10-30 17:02:00',286,3,2,35,'',NULL),(328,'2023-11-02 13:48:09','2023-11-02 13:48:09',291,3,2,24,'',NULL),(329,'2023-11-02 14:12:30','2023-11-02 14:12:30',292,3,2,64,'',NULL),(330,'2023-11-02 14:13:58','2023-11-02 14:13:58',292,2,2,64,'<p>Guidlines for major events send to Events team to be implemented on the CUK website on the Events section. Specific surveys are still to be developed.</p>',NULL),(333,'2023-11-07 11:06:45','2023-11-07 11:06:45',295,3,2,16,'',NULL),(339,'2023-11-07 16:01:12','2023-11-07 16:01:12',286,2,2,35,'<p>Zerofy working with Investment team and Events team to establish sustainability framework to share with external customers</p>',NULL),(340,'2023-11-07 16:01:34','2023-11-07 16:01:34',291,2,2,24,'<p>Waiting on confirmation from investment team for next steps</p>',NULL),(357,'2023-11-24 09:13:07','2023-11-24 09:13:07',311,3,2,29,'',NULL),(358,'2023-11-24 09:13:18','2023-11-24 09:13:18',312,3,2,27,'',NULL),(359,'2023-11-24 09:13:53','2023-11-24 09:13:53',313,3,2,25,'',NULL),(360,'2023-11-24 09:14:07','2023-11-24 09:14:07',314,3,2,57,'',NULL),(361,'2023-11-24 09:14:23','2023-11-24 09:14:23',315,3,2,53,'',NULL),(362,'2023-11-24 09:50:17','2023-11-24 09:50:17',316,3,2,55,'',NULL),(363,'2023-11-24 09:50:23','2023-11-24 09:50:23',317,3,2,22,'',NULL),(399,'2024-01-22 08:19:18','2024-01-22 08:19:18',353,3,2,28,'',NULL),(400,'2024-01-22 08:19:25','2024-01-22 08:19:25',354,3,2,34,'',NULL),(401,'2024-01-22 08:19:31','2024-01-22 08:19:31',355,3,2,44,'',NULL),(402,'2024-01-22 08:19:35','2024-01-22 08:19:35',356,3,2,37,'',NULL),(403,'2024-01-22 08:19:40','2024-01-22 08:19:40',357,3,2,60,'',NULL),(435,'2024-03-01 10:10:30','2024-03-01 10:10:30',387,15,6,60,'',NULL),(436,'2024-03-01 10:10:33','2024-03-01 10:10:33',388,15,6,13,'',NULL),(437,'2024-03-04 12:39:42','2024-03-04 12:39:42',387,6,6,60,NULL,NULL),(438,'2024-03-12 11:57:55','2024-03-12 11:57:55',389,3,2,31,'',NULL),(439,'2024-03-13 15:42:48','2024-03-13 15:42:48',390,15,6,22,'',NULL);

--
-- Table structure for table `sectors`
--

CREATE TABLE `sectors` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sectors`
--

INSERT INTO `sectors` VALUES (1,'2023-05-21 01:06:31','2023-05-21 01:06:31','ُTest From Seeders','test.png','test.png',NULL);

--
-- Table structure for table `service_inquieries`
--

CREATE TABLE `service_inquieries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `partner_service_id` bigint unsigned NOT NULL,
  `status` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `service_inquieries_user_id_foreign` (`user_id`),
  KEY `service_inquieries_partner_service_id_foreign` (`partner_service_id`),
  CONSTRAINT `service_inquieries_partner_service_id_foreign` FOREIGN KEY (`partner_service_id`) REFERENCES `partner_services` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `service_inquieries_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `service_inquieries`
--


--
-- Table structure for table `sub_sectors`
--

CREATE TABLE `sub_sectors` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sector_id` bigint unsigned NOT NULL,
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sub_sectors_sector_id_foreign` (`sector_id`),
  CONSTRAINT `sub_sectors_sector_id_foreign` FOREIGN KEY (`sector_id`) REFERENCES `sectors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sub_sectors`
--

INSERT INTO `sub_sectors` VALUES (1,'2023-05-21 01:06:31','2023-05-21 01:06:31','ُTest From Seeders','test.png',1,NULL);

--
-- Table structure for table `tenants`
--

CREATE TABLE `tenants` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_registration_number` bigint NOT NULL,
  `active` tinyint NOT NULL DEFAULT '0',
  `sub_sector_id` int DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `parentId` tinyint NOT NULL DEFAULT '0',
  `deleted_at` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `linkable` int NOT NULL DEFAULT '0',
  `framelink` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tenants_user_id_foreign` (`user_id`),
  CONSTRAINT `tenants_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tenants`
--

INSERT INTO `tenants` VALUES (1,'Test from seeders Tenant','tenants_logo-1685612150.png','test from seeders address','www.testfromseeders.com',1234567890,1,1,2,0,NULL,'2023-05-21 01:06:31','2023-06-22 09:08:35',1,'https://lookerstudio.google.com/embed/reporting/c8f9d9cf-2dac-4924-a582-4595d0256937/page/yO06C'),(2,'Creative UK','tenants_logo-1686071381.png','Tomorrow Building, 130 Broadway, 2nd Floor /Suite 7 MediaCityUK, Salford M50 2UW','https://www.wearecreative.uk/',123123123,1,1,3,0,NULL,'2023-05-15 08:24:51','2023-06-06 17:09:41',1,'https://lookerstudio.google.com/embed/reporting/2d08043d-6dd1-45c6-8691-51f69fc83797/page/yO06C'),(3,'Salescreen','tenants_logo-1686913326.png','Karl Johans gt. 13, 0154 Oslo','https://www.salesscreen.com/',997254953,1,1,7,0,NULL,'2023-05-29 07:30:58','2023-06-16 11:02:06',1,'https://lookerstudio.google.com/embed/reporting/c8f9d9cf-2dac-4924-a582-4595d0256937/page/yO06C'),(4,'MDC','tenants_logo-1686146440.svg','Medicines Discovery Catapult Block 35, Mereside Alderley Park, Macclesfield Cheshire SK10 4ZF','https://md.catapult.org.uk/',11111,1,1,8,0,NULL,'2023-06-07 14:00:40','2023-07-31 14:04:07',1,'https://lookerstudio.google.com/embed/reporting/9e62cb35-a0e6-4f59-8bab-d825be50ff71/page/p_cop3qxp9zc'),(5,'Atex','tenants_logo-1690455043.png','123123','https://www.atex.com/',123123,1,1,13,0,NULL,'2023-07-27 10:44:32','2023-07-27 10:52:59',1,'https://lookerstudio.google.com/embed/reporting/fcb7ec7c-b2cc-464c-944a-a2636ea9c88a/page/yO06C'),(6,'UK Demo','tenants_logo-1691067318.svg','abc','zerofy.io',123,1,1,15,0,NULL,'2023-08-03 12:55:18','2023-08-03 15:32:42',1,'https://lookerstudio.google.com/embed/reporting/a12db906-3bb7-4f9e-bf9b-371df4f2ff27/page/p_1xhmarhj8c\" frameborder=\"0\" style=\"border:0\"');

--
-- Table structure for table `tenants_countries`
--

CREATE TABLE `tenants_countries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tenant_id` bigint unsigned NOT NULL,
  `city_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tenants_countries_tenant_id_foreign` (`tenant_id`),
  KEY `tenants_countries_city_id_foreign` (`city_id`),
  CONSTRAINT `tenants_countries_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `tenants_countries_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tenants_countries`
--


--
-- Table structure for table `tenants_recommended_initiatives`
--

CREATE TABLE `tenants_recommended_initiatives` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tenant_id` bigint unsigned NOT NULL,
  `initiative_id` bigint unsigned NOT NULL,
  `category_id` bigint unsigned NOT NULL,
  `sub_category_id` bigint unsigned NOT NULL,
  `impact` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cost_of_implementation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `partner_services` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tenants_recommended_initiatives_tenant_id_foreign` (`tenant_id`),
  KEY `tenants_recommended_initiatives_initiative_id_foreign` (`initiative_id`),
  KEY `tenants_recommended_initiatives_category_id_foreign` (`category_id`),
  KEY `tenants_recommended_initiatives_sub_category_id_foreign` (`sub_category_id`),
  CONSTRAINT `tenants_recommended_initiatives_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `tenants_recommended_initiatives_initiative_id_foreign` FOREIGN KEY (`initiative_id`) REFERENCES `initiatives` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `tenants_recommended_initiatives_sub_category_id_foreign` FOREIGN KEY (`sub_category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `tenants_recommended_initiatives_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tenants_recommended_initiatives`
--

INSERT INTO `tenants_recommended_initiatives` VALUES (30,'2023-05-24 12:07:53','2023-11-02 13:47:28',2,24,32,33,'moderate','low','N;'),(33,'2023-05-24 12:23:35','2023-08-08 16:40:15',2,14,1,5,'moderate','low','a:1:{i:0;s:1:\"9\";}'),(35,'2023-05-24 12:54:59','2023-05-24 12:54:59',2,27,2,28,'moderate','low','N;'),(36,'2023-05-24 12:55:15','2023-08-02 19:00:41',2,28,2,28,'moderate','low','a:1:{i:0;s:2:\"16\";}'),(37,'2023-05-24 12:55:34','2023-08-02 19:01:31',2,29,2,28,'moderate','low','a:1:{i:0;s:2:\"16\";}'),(39,'2023-05-24 12:56:04','2023-05-24 12:56:04',2,31,2,28,'moderate','low','N;'),(40,'2023-05-24 14:17:44','2023-08-01 07:10:08',2,33,2,12,'low','low','N;'),(41,'2023-05-24 14:18:03','2023-08-03 12:23:02',2,32,1,5,'low','medium','N;'),(43,'2023-05-24 16:29:53','2023-06-07 21:28:40',2,22,4,26,'moderate','low','N;'),(44,'2023-05-24 16:51:47','2023-08-02 07:55:50',2,34,4,21,'large','low','N;'),(45,'2023-05-24 16:52:11','2023-05-25 14:52:43',2,35,4,21,'moderate','low','N;'),(48,'2023-05-24 16:53:20','2023-08-03 12:46:23',2,38,1,7,'low','medium','a:1:{i:0;s:2:\"17\";}'),(49,'2023-05-24 16:53:47','2023-08-08 15:06:21',2,39,1,6,'moderate','low','a:1:{i:0;s:2:\"10\";}'),(52,'2023-05-24 17:19:40','2023-08-02 11:59:18',2,42,34,35,'low','medium','N;'),(54,'2023-05-25 05:23:58','2023-05-25 14:53:32',2,44,1,6,'moderate','low','N;'),(56,'2023-05-25 14:16:35','2023-11-10 10:18:45',2,46,1,7,'large','low','N;'),(59,'2023-05-31 12:28:17','2023-05-31 12:28:17',3,19,2,13,'low','low','N;'),(60,'2023-05-31 19:22:18','2023-05-31 19:22:18',3,13,1,5,'moderate','low','a:1:{i:0;s:1:\"6\";}'),(61,'2023-05-31 19:44:39','2023-08-01 07:10:08',3,33,2,12,'low','low','N;'),(62,'2023-05-31 19:53:13','2023-08-08 15:06:21',3,39,1,6,'large','low','a:1:{i:0;s:2:\"10\";}'),(63,'2023-06-02 12:44:31','2023-06-05 19:13:35',3,37,2,8,'large','medium','N;'),(64,'2023-06-05 14:18:21','2023-06-06 11:24:02',3,47,2,9,'moderate','low','a:1:{i:0;s:2:\"11\";}'),(65,'2023-06-05 19:24:23','2023-06-07 21:28:40',3,22,4,26,'large','medium','N;'),(66,'2023-06-05 19:49:54','2023-06-05 20:01:18',3,48,3,16,'large','high','a:1:{i:0;s:2:\"12\";}'),(70,'2023-06-07 20:20:57','2023-06-07 20:25:30',3,49,3,16,'large','high','a:1:{i:0;s:2:\"13\";}'),(71,'2023-06-07 20:46:46','2024-02-14 18:35:00',3,51,1,5,'low','low','a:1:{i:0;s:2:\"14\";}'),(72,'2023-06-07 20:56:26','2023-06-07 20:58:39',3,52,4,24,'large','high','N;'),(73,'2023-06-08 05:24:29','2023-06-08 05:24:29',3,16,2,10,'moderate','low','N;'),(74,'2023-06-08 05:25:12','2023-06-08 05:25:12',3,19,2,13,'low','low','N;'),(75,'2023-06-08 05:25:28','2023-06-08 05:26:08',3,40,1,6,'moderate','low',NULL),(76,'2023-06-08 05:25:58','2023-06-08 05:26:17',3,22,4,26,'large','high',NULL),(77,'2023-06-08 05:26:41','2023-11-10 10:18:45',3,46,1,7,'large','low','N;'),(78,'2023-06-08 05:27:02','2023-06-08 05:27:02',3,20,3,15,'moderate','low','N;'),(79,'2023-06-08 05:27:54','2023-08-08 14:22:29',3,25,34,35,'large','medium','N;'),(80,'2023-06-08 05:28:17','2023-06-08 05:28:17',3,44,1,6,'moderate','low','N;'),(81,'2023-06-08 05:28:48','2023-08-02 11:59:18',3,42,34,35,'large','high','N;'),(82,'2023-06-08 05:29:27','2023-08-02 07:55:50',3,34,4,21,'moderate','low','N;'),(83,'2023-06-08 13:47:16','2023-11-10 10:18:45',4,46,1,7,'large','low','N;'),(85,'2023-06-08 13:48:42','2023-08-08 16:40:15',4,14,1,5,'low','low','a:1:{i:0;s:1:\"9\";}'),(86,'2023-06-08 13:50:57','2023-06-08 13:50:57',4,53,1,7,'moderate','low','N;'),(87,'2023-06-08 13:52:30','2023-06-08 13:52:30',4,17,1,6,'moderate','medium','a:1:{i:0;s:1:\"8\";}'),(88,'2023-06-08 13:53:23','2023-08-08 15:06:21',4,39,1,6,'low','low','a:1:{i:0;s:2:\"10\";}'),(89,'2023-06-08 13:53:55','2023-06-08 13:53:55',4,47,2,9,'moderate','low','a:1:{i:0;s:2:\"11\";}'),(90,'2023-06-08 13:54:21','2023-06-08 13:54:21',4,18,2,13,'moderate','medium','N;'),(91,'2023-06-08 13:54:48','2023-06-08 13:54:48',4,19,2,13,'large','high','N;'),(93,'2023-06-08 13:56:07','2023-06-08 13:56:07',4,20,3,15,'low','low','N;'),(94,'2023-06-08 13:56:50','2023-06-08 13:56:50',4,36,4,21,'large','medium','N;'),(95,'2023-06-08 13:57:21','2023-06-08 13:57:21',4,22,4,26,'large','low','N;'),(96,'2023-06-08 13:57:56','2023-08-08 14:22:29',4,25,34,35,'moderate','low','N;'),(97,'2023-06-08 13:58:11','2023-08-02 11:59:18',4,42,34,35,'large','high','N;'),(98,'2023-06-08 19:25:47','2023-06-08 19:50:06',4,54,1,5,'moderate','low','N;'),(99,'2023-06-08 19:36:17','2023-06-08 19:36:17',4,55,1,6,'moderate','low','N;'),(100,'2023-06-08 19:40:06','2023-06-08 19:40:06',4,37,2,8,'moderate','medium','N;'),(101,'2023-06-09 07:00:14','2023-06-16 10:24:54',4,56,3,16,'moderate','medium','a:1:{i:0;s:2:\"15\";}'),(103,'2023-06-09 10:42:11','2023-06-09 10:42:11',4,57,1,7,'large','low','N;'),(104,'2023-06-16 07:43:00','2023-06-16 07:43:00',4,13,1,5,'moderate','low','N;'),(109,'2023-07-27 11:24:02','2023-07-27 11:24:02',5,58,34,35,'low','medium','N;'),(110,'2023-07-27 11:24:36','2023-08-02 11:59:18',5,42,34,35,'low','medium','N;'),(115,'2023-08-02 16:44:35','2023-08-02 16:44:35',2,37,2,8,'low','low','N;'),(116,'2023-08-02 16:46:46','2023-08-02 16:46:46',2,16,2,10,'low','low','N;'),(117,'2023-08-02 16:48:25','2023-08-08 14:22:29',2,25,34,35,'large','low','N;'),(118,'2023-08-03 12:37:43','2023-08-03 12:37:43',4,32,1,5,'moderate','low','N;'),(119,'2023-08-03 12:41:27','2023-08-03 12:41:27',2,60,1,7,'moderate','low','N;'),(120,'2023-08-03 12:41:41','2023-08-03 12:41:41',4,60,1,7,'moderate','low','N;'),(121,'2023-08-03 13:01:10','2023-08-03 13:01:10',6,60,1,7,'large','low','N;'),(122,'2023-08-03 13:02:38','2023-08-03 13:02:38',6,13,1,5,'moderate','low','N;'),(125,'2023-08-03 13:04:12','2023-08-03 13:04:12',6,18,2,13,'moderate','medium','N;'),(127,'2023-08-03 13:07:04','2023-08-03 13:07:04',6,21,3,17,'low','low','N;'),(129,'2023-08-03 13:08:20','2023-08-03 13:08:33',6,22,4,26,'large','medium',NULL),(130,'2023-08-03 13:09:02','2023-08-08 14:22:29',6,25,34,35,'large','medium','N;'),(131,'2023-08-03 13:09:32','2023-08-03 13:09:32',6,53,1,7,'moderate','low','N;'),(132,'2023-08-03 13:09:46','2023-08-03 13:09:55',6,57,1,7,'moderate','low',NULL),(133,'2023-08-03 13:10:36','2023-08-03 13:10:36',6,37,2,8,'moderate','low','a:1:{i:0;s:2:\"18\";}'),(134,'2023-08-03 13:11:00','2023-08-03 13:11:00',6,42,34,35,'large','high','N;'),(135,'2023-08-03 13:11:26','2023-08-03 13:11:26',6,55,1,6,'moderate','low','N;'),(136,'2023-08-03 13:11:50','2023-08-08 15:06:21',6,39,1,6,'moderate','low','a:1:{i:0;s:2:\"10\";}'),(137,'2023-08-03 13:13:13','2023-08-03 13:13:13',6,32,1,5,'moderate','low','N;'),(138,'2023-08-03 13:14:06','2023-08-03 13:14:06',6,47,2,9,'moderate','low','a:1:{i:0;s:2:\"11\";}'),(139,'2023-08-03 13:14:35','2023-08-03 13:14:35',6,16,2,10,'moderate','low','N;'),(140,'2023-08-03 13:15:06','2023-08-03 13:15:06',6,22,4,26,'large','medium','N;'),(141,'2023-08-03 13:15:39','2023-08-03 13:15:39',6,27,2,28,'moderate','low','N;'),(142,'2023-08-03 13:16:13','2023-08-03 13:16:13',6,56,3,16,'large','medium','a:1:{i:0;s:2:\"15\";}'),(144,'2023-08-03 13:16:45','2023-08-03 13:16:53',6,52,4,24,'moderate','low',NULL),(145,'2023-08-03 13:17:47','2023-11-02 13:47:28',6,24,32,33,'large','low','N;'),(146,'2023-08-03 13:18:07','2023-08-03 13:18:07',6,31,2,28,'moderate','medium','N;'),(147,'2023-08-07 12:25:02','2023-08-07 12:25:02',1,13,1,5,'moderate','medium','N;'),(148,'2023-08-18 07:40:15','2023-08-18 07:40:15',2,57,1,7,'moderate','low','N;'),(149,'2023-08-18 07:47:01','2023-08-18 07:47:01',2,18,2,13,'moderate','medium','N;'),(150,'2023-08-18 07:47:51','2023-08-18 07:47:51',2,47,2,9,'moderate','low','a:1:{i:0;s:2:\"11\";}'),(151,'2023-08-18 07:48:18','2023-08-18 07:48:18',2,53,1,7,'moderate','low','N;'),(152,'2023-08-18 07:48:59','2023-08-18 07:48:59',2,55,1,6,'moderate','low','N;'),(153,'2023-08-24 11:42:10','2023-08-24 11:42:10',2,61,1,5,'moderate','low','N;'),(154,'2023-09-29 08:40:55','2023-10-06 08:17:42',4,62,1,5,'large','low','a:1:{i:0;s:2:\"19\";}'),(156,'2023-10-19 13:57:19','2023-11-08 09:37:53',6,63,1,36,'moderate','low','a:1:{i:0;s:2:\"20\";}'),(157,'2023-10-24 13:33:17','2023-10-24 13:33:17',2,62,1,5,'low','low','a:1:{i:0;s:2:\"19\";}'),(158,'2023-11-02 14:12:11','2023-11-02 14:12:11',2,64,2,28,'moderate','low','N;'),(159,'2023-11-08 09:23:57','2023-11-08 09:23:57',6,64,2,28,'large','low','N;'),(160,'2023-11-09 14:30:44','2023-11-14 15:02:09',6,65,3,17,'moderate','low','a:1:{i:0;s:2:\"21\";}'),(161,'2023-11-09 20:34:19','2024-02-14 18:35:00',6,51,1,5,'low','low','a:1:{i:0;s:2:\"14\";}'),(162,'2023-11-09 20:36:10','2023-11-09 20:36:10',6,20,3,15,'low','low','N;'),(164,'2023-11-09 20:41:38','2023-11-09 20:41:38',6,52,4,24,'low','low','N;'),(165,'2023-11-09 20:45:50','2023-11-10 10:18:45',6,46,1,7,'moderate','low',NULL),(166,'2023-11-10 09:20:54','2023-11-10 10:04:01',6,66,34,35,'low','low','N;');

--
-- Table structure for table `timeline_comments`
--

CREATE TABLE `timeline_comments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `timeline_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `timeline_comments_timeline_id_foreign` (`timeline_id`),
  KEY `timeline_comments_user_id_foreign` (`user_id`),
  CONSTRAINT `timeline_comments_timeline_id_foreign` FOREIGN KEY (`timeline_id`) REFERENCES `timelines` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `timeline_comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `timeline_comments`
--


--
-- Table structure for table `timeline_progresses`
--

CREATE TABLE `timeline_progresses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `timeline_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` int NOT NULL,
  `deleted_at` date DEFAULT NULL,
  `created_by` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `timeline_progresses_timeline_id_foreign` (`timeline_id`),
  KEY `timeline_progresses_user_id_foreign` (`user_id`),
  CONSTRAINT `timeline_progresses_timeline_id_foreign` FOREIGN KEY (`timeline_id`) REFERENCES `timelines` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `timeline_progresses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `timeline_progresses`
--


--
-- Table structure for table `timelines`
--

CREATE TABLE `timelines` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tenant_id` bigint unsigned NOT NULL,
  `initiative_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `date_from` date NOT NULL,
  `to_date` date NOT NULL,
  `status` tinyint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `timelines_tenant_id_foreign` (`tenant_id`),
  KEY `timelines_initiative_id_foreign` (`initiative_id`),
  KEY `timelines_user_id_foreign` (`user_id`),
  CONSTRAINT `timelines_initiative_id_foreign` FOREIGN KEY (`initiative_id`) REFERENCES `initiatives` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `timelines_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `timelines_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `timelines`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` tinyint NOT NULL DEFAULT '1',
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '2',
  `parent_id` tinyint DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'Test User Admin','test@example.com','2023-05-21 01:06:31','$2y$10$BV9659bGxdfEA7k3ARCRx.zuHIvm1PnDVjlK302oGRsoQTwMMb286',NULL,NULL,NULL,0,'l9LyLQ3zl0w5OpdskoJt0H0iMK9j9Umlen4XSiEVSYSNvtTS9VaqHtnM99in','2023-05-21 01:06:31','2023-05-21 01:06:31','2',NULL),(2,'Yayha','test_t@example.com','2023-05-21 01:06:31','$2y$10$6TKmwQUpktyFsDq/fgIAyepHTIuPJFKyl9.D7nl4OX/OjBNFBDavu','yahya','ayyoub','0000000',1,'T7ArBxLjcIVTZ1cYBbf6dQL7QjRoveX8tczkEZh2HsvSNdzLR7sn6zFz4NkU','2023-05-21 01:06:31','2023-05-24 09:46:38','2',NULL),(3,'Charlotte.Roocroft','Charlotte.Roocroft@wearecreative.uk',NULL,'$2y$10$ZBA2Sa/xAcnEkApC8q9MGOD7Bk8KgmEJ/O1rRekYgec9xWxAjs06q','Charlotte','Roocroft','90871036',1,'XmR5hY3H4ZDdFS7R2IVRyLiXmzYoRxNb9kHiLYY9SXhUuMjJDp9vOhaIcZ0k','2023-05-15 08:25:16','2023-05-24 12:03:41','2',NULL),(4,'test Usertest','yahyafifaonly@gmail.com',NULL,'$2y$10$1cCYyeZheQ1vnhE64skfeef1pZ7FW7BRQdf.zpAxXA4RbSodYgp9y',NULL,NULL,NULL,3,'QkhZ7xLev9X3qSuneYv7LpGWJiMWPP68AGVRWRmXPRfsvM8VyqVEA14ietff','2023-05-22 06:04:20','2023-05-22 06:04:21','2',2),(5,'ChristopherHart','chris.hart@zerofy.io',NULL,'$2y$10$bkvTT7BQFL227eqdlYic0ul.gsOWV8r/96lxkGhzlrGKztjMrOrvC',NULL,NULL,NULL,3,'DOnV9lKDlcOmZmf72ZYn2D0YDMUJHvKDoof5o925C10xIO9Ixwj4j5Htjz1t','2023-05-25 06:02:47','2023-05-25 06:02:47','2',3),(6,'ChristopherHart','christopherhart1@hotmail.com',NULL,'$2y$10$iMY0dYCRYJm7FZfMhqEB3OXxEEbSKhPZxqVcSMVMZvDY1ki.KMa5m',NULL,NULL,NULL,3,'qnbKBxH8jYyOmpuIYc8mAHyvlF3Hf8zJFXweiJQmNVUx4xKqbkFDkJCOZ4mK','2023-05-25 06:49:45','2023-05-25 06:49:45','2',3),(7,'test@example.com','antoine.thebault@zerofy.io',NULL,'$2y$10$02D/3qr95WfY4LHyiraPR.CGzzqmtu0QyFcb6/25lOYi0UdeWOOx.','Antoine','Thebault','48067986',1,'ku78ykky5gStvWWUn2ZqZakj0Ob9q2VLqddxDeocm3HQv9p0YuE2v5It9zlH','2023-05-29 07:28:44','2023-05-31 12:29:44','2',NULL),(8,'sonya.kewley@md.catapult.org.uk','sonya.kewley@md.catapult.org.uk',NULL,'$2y$10$zp3RyvNq/ixHXd4TAUywY.gOW2zDQrKiZ5EsApiqrLtYK6scorQsm','Sonya','Kewley','07918558461',1,'cyx2ZxJCHxCZxKNP1ukStuE9iBVoCRhwbvjdy55uq6aKR1Fq4xD5ADS8IGO3','2023-06-07 13:59:33','2023-06-07 13:59:33','2',NULL),(9,'FinnWeatherhead','finnweatherhead@gmail.com',NULL,'$2y$10$RBJA2.7nK3Y1Zag8vQQTTe55OHYrtU15nj2StkVoAxuLT5EOXDLLy',NULL,NULL,NULL,3,'vGvnW37lq7iG2TlBPvXFXbdm4DTn9n7ANS3tOFO9rPOAJiX7YKLsl7ZieBgU','2023-06-29 10:46:55','2023-06-29 10:46:55','2',7),(10,'HannahShepherd','hannah.shepherd@zerofy.io',NULL,'$2y$10$5q76xZ7pozxj1UMuEZDQnedskNUBjcKt3NOz0YZj2ZzXPsxWweyKW',NULL,NULL,NULL,3,'2dQ8ff4o2BfsPxVE736BN0vsdqU03OHqMl57jPSSxy39ddhv4yWMKhJ4ERSb','2023-06-29 12:31:10','2023-06-29 12:31:10','2',3),(12,'Fadwayasininn','fadwayassin4@gmail.com',NULL,'$2y$10$0BsD4BKXETf9yMvVjGFWeOmoysQt2XdF693UTeMb90a0sLScLYZo.',NULL,NULL,NULL,3,NULL,'2023-07-26 12:20:46','2023-07-26 12:20:46','2',2),(13,'amari@atex.com','amari@atex.com',NULL,'$2y$10$wHmj/KpuNmkHTghpHj3iQ.WtQfpn5dWxzFqm3YFyobTdh125MATHG','Alberto','Amari','123123',1,'KFvvjXBoK3GndNA7nLRETf4jysQs8gxOo9ZRM1jHEWfLh8jYxXsbgeG6QYgp','2023-07-27 10:42:57','2023-07-27 10:42:57','2',NULL),(14,'MDC','md.catapult@zerofy.io',NULL,'$2y$10$dY7WAVUr7ob6aZH9JoXPCuRgfvBZ3FPDoCvTwbQmHU6w4FMjN0DMC','K','K','123123',1,'ppSjJptL1kf4SRgIuMIiAdUiqwe6aMmzCOzRG07AAtbVLAAXXk9gdTJopKdp','2023-07-27 12:31:02','2023-07-27 12:31:02','2',NULL),(15,'ukdemo@example.com','ukdemo@example.com',NULL,'$2y$10$L6/56GcFdgC9LzPph2IoUuIgMHhmvtgKOaBObL2cGuQTs/sWAclz6','UK','Demo','123456789',1,'87QvzhgWCU13wEM6HtQTK0p724W3ea4AlhSYYz8K1wy1I7M2ALScg7ErwHVt','2023-08-03 12:53:20','2023-08-03 12:53:20','2',NULL),(19,'AbdulrahmanTalafha','a.talafha@techsfactory.com',NULL,'$2y$10$g2BhHqUptqYOGdAbHetzQOSuiL1NRjhB34M978CqGFikwXDcv81HC',NULL,NULL,NULL,3,NULL,'2023-08-14 10:07:41','2023-08-14 10:07:41','2',2),(20,'Birte.carelse@wearecreative.uk','Birte.carelse@wearecreative.uk',NULL,'$2y$10$JKHYPMGgWmhvvU4RzGOgFOKxSZtX6Ba.izG36GJoA/rph9PzIdT3W','Birte','Carelse','123123',1,'jiqXXXDIW4cKC9HLQ5URJDfQGlKxDUTvn2QjZKaUeiZmBT1zT7oZcFvARVOh','2023-09-18 10:07:20','2023-09-18 10:07:20','2',NULL),(21,'ToinaLjøstad','Toina.ljostad@gmail.com',NULL,'$2y$10$hECo5z9G1M4Nv0cBgSg6PeQ4fG8ljXv359eosOhVlPqGF1ulayEKS',NULL,NULL,NULL,3,'jUx9CrzFpSSyfLlF3gFaJudgQhKoHDaJ2m30QSZ2IeAyb67tYGc95QLRRHAD','2023-11-15 08:29:29','2023-11-15 08:29:29','2',15),(22,'christopherhart1+2@hotmail.com','christopherhart1+2@hotmail.com',NULL,'$2y$10$0LIyo0ecbEnhVFDGxALHB.59jQ121fV6xiGfI2xgnaQ2o7kpP3H6.','Christopher','Hart','90871036',3,NULL,'2024-01-15 16:40:33','2024-01-15 16:40:33','2',NULL),(23,'InfoHart','info@zerofy.io',NULL,'$2y$10$rT3Sm0wUY3d1W069ve21e.gy0Ou8c/6PQB6hJBADfIb3rGnTvNh9K',NULL,NULL,NULL,3,'qc5shP6O6aFNsSZbaikzxbyYJkgcIsQOAMgNDMBzs6vCVI3Pkax5Vk3GuO6F','2024-01-15 16:44:29','2024-01-15 16:44:29','2',3),(24,'TomSweetsur','Tom.Sweetsur@wearecreative.uk',NULL,'$2y$10$H2ZaHLiuu3jDil2Hf0GEc.vbPid2zEgjtBKniGWWyoqF1IjkPgEee',NULL,NULL,NULL,3,'L5bjunoXn0mvBYvhcFj7MUMNazwCaR38zvLSAp3oGpzvTPXpchupVQ2XHMHi','2024-01-18 15:14:36','2024-01-18 15:14:36','2',3),(29,'Sarah.jones@wearecreative.uk','Sarah.jones@wearecreative.uk',NULL,'$2y$10$8qfmIf8lsbIBtjq//yOK6OVHfubmAPVFGvEqd.uiy/2BnElYUeg/i','Sarah','Jones','90871036',1,NULL,'2024-03-14 11:34:17','2024-03-14 11:34:17','2',NULL);


