-- MySQL dump 10.13  Distrib 8.0.44, for Linux (x86_64)
--
-- Host: localhost    Database: ceulocker
-- ------------------------------------------------------
-- Server version	8.0.44-0ubuntu0.22.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `email_body_templates`
--

DROP TABLE IF EXISTS `email_body_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_body_templates` (
  `email_body_no` int NOT NULL AUTO_INCREMENT,
  `email_body_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `dev_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `email_include` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `email_subject_line` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `email_preheader` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `active` bit(1) DEFAULT NULL,
  `date_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`email_body_no`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `email_body_templates`
--

LOCK TABLES `email_body_templates` WRITE;
/*!40000 ALTER TABLE `email_body_templates` DISABLE KEYS */;
INSERT INTO `email_body_templates` VALUES (1,'a','initial provider submission email','/c/includes/emails/email_templates/4a-email-template-content.cfm','CEU Locker Submission: [ceul_list]','Application[s] submitted to [org_abbrev]',_binary '','2025-11-08 11:13:46','2025-11-08 11:13:46'),(2,'b','Create new holder OR provider account','/c/includes/emails/email_templates/4b-email-template-content.cfm','Verify your CEU Locker Email Account','This code is valid for the next 60 minutes and can only be used once.',_binary '','2025-11-08 11:13:46','2025-11-08 11:13:46'),(3,'c','Password recovery request','/c/includes/emails/email_templates/4c-email-template-content.cfm','CEU Locker Password Recovery','This code is valid for the next 60 minutes and can only be used once.',_binary '','2025-11-08 11:13:46','2025-11-08 11:13:46'),(4,'d','Send reviewer notice for Review Assignment','/c/includes/emails/email_templates/4d-email-template-content.cfm','[urgent] CEU Locker Reviewer Assignment: [ceul_id]',NULL,_binary '','2025-11-08 11:13:46','2025-11-08 11:13:46'),(5,'e','Fatal error reported by reviewer for ceul','/c/includes/emails/email_templates/4e-email-template-content.cfm','CEU Locker Fatal Error Reported by your Reviewer','[Reviewer Name]: [ceulid]',_binary '','2025-11-08 11:13:46','2025-11-08 11:13:46'),(6,'f','Final decision taken by admin','/c/includes/emails/email_templates/4f-email-template-content.cfm','[ceul_id] [decision] by [org abbrev]','Thank you for using CEU Locker to submit your course credit applications',_binary '','2025-11-08 11:13:46','2025-11-08 11:13:46'),(8,'h','Purchase system fee credits for provider only','/c/includes/emails/email_templates/4h-email-template-content.cfm','CEU Locker System Fee Credit Purchase: [no_of_credits] credits by [provider_company]','Thank you for working with CEU Locker. System Fees help support the platform for all.',_binary '','2025-11-08 11:13:46','2025-11-08 11:13:46'),(11,'k','Reviewer conflict of interest reported','/c/includes/emails/email_templates/4k-email-template-content.cfm','CEU Locker Conflict of Interest reported by your Reviewer','[Reviewer Name]: [ceulid]',_binary '','2025-11-08 11:13:46','2025-11-08 11:13:46'),(14,'m','Make organization name change request','/c/includes/emails/email_templates/4m-email-template-content.cfm','CEU Locker Admin Org name change request','',_binary '','2025-11-08 11:13:46','2025-11-08 11:13:46'),(15,'n','Team member invitation, to add new provider','/c/includes/emails/email_templates/4n-email-template-content.cfm','CEU Locker: Team member invite from [provider company]','Thank you for using CEU Locker!',_binary '','2025-11-08 11:13:46','2025-11-08 11:13:46'),(16,'o','Account validation confirmation','/c/includes/emails/email_templates/4o-email-template-content.cfm','Email Address Validated & Active','Thank you for Validating Your Email Address',_binary '','2025-11-19 07:11:02','2025-11-19 07:11:02'),(17,'p','Instant final decision taken by admin','/c/includes/emails/email_templates/4p-email-template-content.cfm','[ceul_id] [decision] by [org abbrev]','Thank you for using CEU Locker to submit your course credit applications',_binary '','2025-11-21 06:29:31','2025-11-21 06:29:31'),(18,'q','Pending CEULID confirmation','/c/includes/emails/email_templates/4q-email-template-content.cfm','Pending CEULID confirmation','Pending CEULID confirmation',_binary '','2025-12-09 09:54:59','2025-12-09 09:54:59'),(19,'r','Invite new account','/c/includes/emails/email_templates/4r-email-template-content.cfm','Invite new account','Invite new account',_binary '','2025-12-09 10:10:22','2025-12-09 10:10:22');
/*!40000 ALTER TABLE `email_body_templates` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-01-23  5:03:43
