-- MariaDB dump 10.19  Distrib 10.11.6-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: lms_test
-- ------------------------------------------------------
-- Server version	10.11.6-MariaDB-0+deb12u1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES 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 `notification_templates`
--

DROP TABLE IF EXISTS `notification_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notification_templates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `template` text NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notification_templates`
--

LOCK TABLES `notification_templates` WRITE;
/*!40000 ALTER TABLE `notification_templates` DISABLE KEYS */;
INSERT INTO `notification_templates` VALUES
(2,'New badge awarded','<p>You received [u.b.title]&nbsp;badge</p>'),
(3,'User group change','<p>Your user group changed to [u.g.title]</p>'),
(4,'Course created','<p>You created a new course&nbsp;with title [c.title]</p>'),
(5,'Course approve','<p>Your course with title [c.title] approved</p>'),
(6,'Course rejection','<p>Your course with title [c.title] rejected</p>'),
(7,'New comment','<p>[u.name] left a new comment for [c.title] course</p>'),
(8,'New support message','<p>[u.name] sent a new support message for [c.title]&nbsp;course</p>'),
(9,'Support message replied','<p>New reply in [c.title] course support message&nbsp;</p>'),
(10,'New support for admin','<p>New support ticket received with title [s.t.title]</p>'),
(11,'Support ticket replied for admin','<p>New reply in support ticket with title&nbsp;[s.t.title]</p>'),
(12,'New financial document','<p>&nbsp;New financial document submitted for [c.title] with type [f.d.type] with amount [amount]</p>'),
(13,'Payout request','<p>New payout request submitted with amount [payout.amount]</p>'),
(14,'Payout processed','Your payout request with amount [payout.amount]&nbsp;&nbsp;proceed to [payout.account]'),
(15,'New sales','<p>Congratulations! New sale for [c.title]</p>'),
(16,'New purchase','<p>Congratulations! New purchase for [c.title]</p>'),
(17,'Rating (Feedback)','<p>New [rate.count] star feedback submitted for [c.title] by [student.name]</p>'),
(18,'Offline payment request','<p>The offline payment request with the amount [amount] submitted. It is under review and you will get informed by email.</p>'),
(19,'Offline payment approved','<p>Offline payment request with amount [amount]&nbsp;approved</p>'),
(20,'Offline payment rejected','<p>Offline payment request with amount [amount]&nbsp;rejected</p>'),
(21,'New subscription plan','<p>[s.p.name] subscription plan activated by [u.name]</p>'),
(22,'New meeting','<p>New meeting booked by [u.name] for [time.date] at [amount]</p>'),
(23,'New meeting link','<p>[instructor.name] defined the meeting link and you can join the meeting on [time.date] using the following link: [link]</p>'),
(24,'Meeting reminder','<p>You have a meeting on [time.date] please remember to join it on time.</p>'),
(25,'Meeting finished','<p>Your meeting finished with the following information</p><p>Instructor: [instructor.name]</p><p>Student: [student.name]</p><p>Meeting time: [time.date]</p>'),
(26,'New contact message','<p>New contact message received from [u.name] with title [c.u.title]</p><p><br></p>'),
(27,'Live class reminder','<p>Your live class session of the [c.title] will be conducted on [time.date]&nbsp;</p>'),
(28,'Promotion plan','<p>[p.p.name] promotion plan activated for [c.title] course</p>'),
(29,'Promotion plan for admin','<p>[p.p.name] promotion plan request submitted for [c.title]</p>'),
(30,'Certificate achieved','<p>You achieved a certificate for [c.title] course</p>'),
(31,'Waiting quiz (Instructor)','<p>[student.name] is waiting for [q.title] quiz result of the [c.title] course. Please review the quiz and submit the grade.</p>'),
(32,'Waiting quiz result','<p>Your [q.title] quiz of the [c.title] course rated by the instructor, and your quiz status is [q.result]</p>'),
(33,'Product new sale','<p>New sale for [p.title] product</p>'),
(34,'Product new purchase','<p>New purchase for [p.title] product</p>'),
(35,'Product new comment','<p>[u.name] left a new comment for [p.title] product</p>'),
(36,'Product tracking code','<p>[u.name] submitted tracking code for [p.title]</p>'),
(37,'Product rating (Feedback)','<p>[u.name] submitted a new [rate.count] stars rating for [p.title] product</p>'),
(38,'Product received','<p>[u.name] received [p.title] product.</p>'),
(39,'Product out of stock','<p>Your product [p.title] is out of stock</p>'),
(40,'Assignment submission (Instructor)','<p>[student.name] submitted an assignment for [c.title] course</p>'),
(41,'Instructor message in assignment','<p>[instructor.name] sent a message for [c.title] assignment</p>'),
(42,'Assignment grade','<p>Your assignment of [c.title] rated by [instructor.name] . Your grade is [assignment_grade]</p>'),
(43,'User access to content','<p>Your access to content is enabled.</p>'),
(44,'Send post in topic','<p>[u.name] sent a post in your topic with title [topic_title]&nbsp;</p>'),
(45,'Blog post published (Instructor)','<p>Your blog post with title [blog_title] published.</p>'),
(46,'New comment for blog post (Instructor)','<p>[u.name] leaft a new comment for your blog with title [blog_title]</p>'),
(47,'Meeting reminder','<p>You have a meeting on [time.date] with [instructor.name]</p>'),
(48,'Subscription expiry reminder','<p>Your subscription expires on [time.date]&nbsp;</p>'),
(49,'Course forum new question','<p>[u.name] registered a question in the [c.title]&nbsp;course forum.</p>'),
(50,'New answer in course forum','<p>[u.name] submitted an answer in the [c.title]&nbsp;course forum.</p>'),
(52,'You received a gift','<p>[u.name]&nbsp;sent you [gift_title] which is a [gift_type]&nbsp;as a gift with the following message: [gift_message]</p>'),
(53,'Gift submitted successfully','<p>Your gift request for [u.name]&nbsp;submitted successfully on [time.date]&nbsp;and the [gift_title] which is a [gift_type]&nbsp;at [amount]&nbsp;will be sent to the recipient on [time.date.2]&nbsp;with the following message: [gift_message]</p>'),
(54,'Gift sent to recipient','<p>We sent the gift request that you submitted on [time.date]&nbsp;for [u.name]. We sent [gift_title]&nbsp;which is a [gift_type]&nbsp;to the recipient with the following message on [time.date] . [gift_message]</p>'),
(55,'Gift request submitted (Admin)','<p>[u.name.2] submitted a gift request for [gift_title]&nbsp;which is a [gift_type]&nbsp;for [u.name]&nbsp;on [time.date]&nbsp;at [amount]&nbsp;and it will be sent to the recipient on [time.date.2]</p>'),
(56,'Gift sent to recipient (Admin)','<p>The system sent a [gift_title]&nbsp;which is a [gift_type]&nbsp;to [u.name]&nbsp;on [time.date.2]&nbsp;successfully. [u.name.2]&nbsp;submitted this request on [time.date]&nbsp;at [amount].</p>'),
(57,'You have an upcoming installment','<p>You have an installment for [installment_title] at [amount]&nbsp;on due date [time.date]</p>'),
(58,'You have an unpaid installment','<p>You have an installment for [installment_title]&nbsp;at [amount]&nbsp;for today. Please pay it as soon as possible.</p>'),
(59,'You have an overdue installment','<p>You have an overdue installment for [installment_title]&nbsp;at [amount]&nbsp;on due date [time.date].</p>'),
(60,'Installment verification request approved','<p>Your verification request for [installment_title]&nbsp;approved.</p>'),
(61,'Installment verification request rejected','<p>Your verification request for [installment_title]&nbsp;rejected.</p>'),
(62,'Installment paid successfully','<p>You paid [amount]&nbsp;for [installment_title]&nbsp;with due date [time.date]&nbsp;successfully.</p>'),
(63,'Installment paid successfully (Admin)','<p>[u.name] paid [amount]&nbsp;for [installment_title]&nbsp;with the due date [time.date]&nbsp;successfully.</p>'),
(64,'Installment upfront amount paid','<p>You paid [amount] as upfront for&nbsp;[installment_title].</p>'),
(65,'Installment verification request submitted','<p>We received your verification request for [installment_title]&nbsp;on [time.date]&nbsp;and the result will be informed to you soon.</p>'),
(66,'Installment verification request submitted (Admin)','<p>[u.name] submitted a verification request for [installment_title]&nbsp;on [time.date].</p>'),
(67,'Installment request submitted','<p>Your installment for [installment_title]&nbsp;at [amount]&nbsp;submitted successfully.</p>'),
(68,'Installment request submitted (Admin)','<p>[u.name] submitted an installment request for [installment_title]&nbsp;at [amount].</p>'),
(69,'New upcoming course submitted','<p>Your upcoming course [item_title]&nbsp;submitted successfully.</p>'),
(70,'New upcoming course submitted (Admin)','<p>[u.name] submitted an upcoming course with title [item_title].</p>'),
(71,'Upcoming course approved','<p>Your upcoming course [item_title]&nbsp;approved.</p>'),
(72,'Upcoming course rejected','<p>Your upcoming course [item_title] rejected.</p>'),
(73,'Your upcoming course published','<p>Your upcoming course [item_title]&nbsp;published.</p>'),
(74,'Your upcoming course followed','<p>[u.name] followed your upcoming course [item_title]</p>'),
(75,'Upcoming course published and is accessible','<p>The upcoming course [item_title] published now and you can check it.</p>'),
(76,'You got cashback!','<p>You got [amount]&nbsp;as cashback and this amount added to your account.</p>'),
(77,'User got cashback (Admin)','<p>[u.name] got [amount] as cashback and this amount charged to their account.</p>'),
(78,'Bundle submitted successfully','<p>Your bundle with the title [item_title]&nbsp;submitted successfully.</p>'),
(79,'Bundle submitted (Admin)','<p>[u.name] submitted a bundle with the title [item_title].</p>'),
(80,'Bundle published successfully','<p>Your bundle with title [item_title]&nbsp;published successfully.</p>'),
(81,'Bundle rejected','<p>Your bundle with title [item_title]&nbsp;rejected.</p>'),
(82,'New review for your bundle','<p>[u.name] submitted a [rate.count] star rating for your bundle [item_title].</p>'),
(83,'You got registration bonus','<p>You got [amount]&nbsp;as registration bonus.</p>'),
(84,'Registration bonus unlocked','<p>Your registration bonus [amount]&nbsp;unlocked. Happy with spending...</p>'),
(85,'Registration bonus unlocked (Admin)','<p>The registration bonus [amount] unlocked for [u.name].</p>'),
(86,'SaaS package activated successfully','<p>[item_title] activated for you until [time.date].</p>'),
(87,'SaaS package activated (Admin)','<p>[u.name] activated [item_title]&nbsp;registration plan until [time.date].</p>'),
(88,'Your contact message submitted','<p>We received your contact message with the subject [c.u.title]&nbsp;on [time.date].</p>'),
(89,'New contact message received','<p>New contact message received from [u.name] with subject [c.u.title] with message [c.u.message] from [c.u.email]</p>'),
(90,'You submitted to waitlist','<p>You submitted to [c.title]&nbsp;waitlist.</p>'),
(91,'User submitted in waitlist','<p>[u.name] submitted to [c.title]&nbsp;waitlist.</p>'),
(92,'New user registered with your affiliate code','<p>[u.name] registered with your affiliate code on [time.date].</p>'),
(93,'New quiz added to course','<p>New quiz with the title [q.title]&nbsp;added to the course [c.title].</p>'),
(94,'New reward point','<p>You collected [points]&nbsp;for [item_title]&nbsp;on [time.date]</p>'),
(95,'New notice','<p>You got a new notice with title [c.title]&nbsp;on [time.date]</p>'),
(96,'New course notice','<p>You got a new course notice for [c.title]&nbsp;with title [item_title]</p>'),
(97,'Your user role changed','<p>Your user role changed to [u.role]</p>'),
(98,'New user group','<p>You added to [u.g.title] user group.</p>'),
(99,'Become instructor/organization request approved','<p>Your become instructor/organization request is approved.</p>'),
(100,'Become instructor/organization request rejected','<p>Your instructor/organization request rejected</p>'),
(101,'New question in course forum','<p>[u.name] posted a new question in [c.title] forum.</p>'),
(102,'New answer in course forum','<p>[u.name] posted a new answer in [c.title] forum.</p>'),
(103,'Live meeting created','<p>[instructor.name] started a new live meeting. Please login to your account and join it now...</p>'),
(104,'New user registered','<p>[u.name] registered on the platform on [time.date]&nbsp;as [u.role]</p>'),
(105,'New instructor/organization request','<p>[u.name] submitted a user role change request on [time.date]</p>'),
(106,'New course enrollment','<p>[u.name] enrolled in [c.title]&nbsp;on [time.date]&nbsp;at [amount]</p>'),
(107,'New forum topic','<p>[u.name] created a new topic with title [topic_title]&nbsp;in [forum_title]&nbsp;forum.</p>'),
(108,'New report','<p>[u.name] reported a content for revising.</p>'),
(109,'New item created','<p>[u.name] created a new item with title [item_title]</p>'),
(110,'New store order','<p>New store order received from [u.name]&nbsp;at [amount]</p>'),
(111,'Subscription plan activated','<p>[u.name] purchased [s.p.name]&nbsp;at [amount]</p>'),
(112,'Content review request','<p>[u.name] sent a review request for [item_title]</p>'),
(113,'New user blog post','<p>[u.name] submitted a blog article with title [blog_title]</p>'),
(114,'New item review (Rating)','<p>[u.name] submitted a new rate for [item_title]</p>'),
(115,'New organization user','<p>[organization.name] submitted [u.name]&nbsp;as new [u.role]</p>'),
(116,'User wallet charge','<p>[u.name] charged their wallet for [amount]</p>'),
(117,'New payout request','<p>[u.name] submitted a new payout request at [amount]</p>'),
(118,'New offline payment request','<p>[u.name] submitted a new offline payment request at [amount]</p>'),
(119,'Content access approval','<p>Your content access request approved. You can access all courses now...</p>'),
(120,'Form submission by user','<p>[u.name] submitted form [form_title]</p>'),
(121,'Cart reminder','<div>We\'re excited to invite you to complete your purchase with us! Enjoy exclusive benefits and offers by finalizing your order now.</div>'),
(122,'Complete your purchase today with discount!','<div>Here\'s an exclusive [discount_amount] discount coupon to encourage you to finalize your purchase with us. Discount Code : [discount_code]</div>');
/*!40000 ALTER TABLE `notification_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 2025-01-28 14:11:03
