-- phpMyAdmin SQL Dump -- version 4.6.6deb5ubuntu0.5 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jul 08, 2021 at 09:54 AM -- Server version: 5.7.34-0ubuntu0.18.04.1 -- PHP Version: 7.3.27-9+ubuntu18.04.1+deb.sury.org+1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!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 */; -- -- Database: `find` -- -- -------------------------------------------------------- -- -- Table structure for table `email_templates` -- CREATE TABLE `email_templates` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `body` text COLLATE utf8mb4_unicode_ci, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `email_templates` -- INSERT INTO `email_templates` (`id`, `name`, `subject`, `body`, `updated_at`) VALUES (29, 'Admin To Practitioner Activate From Waiting List', 'Login credentials - My Appointment', '

Dear [name],

\r\n\r\n

Great news, your My Appointments account is ready to go!

\r\n\r\n

You can now log in via the button below with the following credentials:

\r\n\r\n

Username: [username]
\r\nAuto-generated password: [userpassword]

\r\n\r\n

Next steps: As you are on our $0 p/m plan, the first thing you'll need to do is fill in a form to set up your integrated online payment processing. From there we will take you through our set-up wizard to help you customise your account.

\r\n\r\n


\r\nAfter you have done this, we recommend changing your password which you can do by clicking on your name/image at the top right of any page.

\r\n\r\n

We’ve also recorded a demo which will give you a quick rundown on how to use the My Appointments platform. The video can be viewed here.

\r\n\r\n

A couple of quick tips:

\r\n\r\n\r\n\r\n


\r\nIf you have feedback or suggestions for features you’d like to see, please reach out via email. You can also see a list of upcoming features here.

\r\n\r\n


\r\n[loginbutton]
\r\n
\r\nWe've put a lot of love into building the ultimate practice management system, we hope you love it as much as we do.

\r\n\r\n

Warm regards,

\r\n\r\n


\r\nAnil & Claudia
\r\nMy Appointments co-founders

', '2021-07-03 05:17:46'), (28, 'Password reset', 'Password reset', '

[textAboveLink]

\r\n\r\n

Please enter the verification code below to reset your password.

\r\n\r\n

[/textAboveLink] [textBelowLink]

\r\n\r\n

If you did not request a password change, no further action is required.

\r\n\r\n

[/textBelowLink]

', '2021-05-21 06:00:38'), (27, 'Send wait list email', 'Welcome to the My Appointments waitlist', 'Hello ,\n

\nThank you for joining our waitlist. You’re now set to be one of the first to gain access.\n

\nWe are in the final stages of testing and will be in contact over the coming weeks to get you started on the My Appointments platform.\n

\nIn the meantime, we would appreciate if you could please take a minute to complete our brief survey. As some of our custom features are still in development, your survey responses will help us determine what features are most important to you and therefore when the platform will be ready to grant you access.\n

\nIf you have any questions, please get in touch or follow us on social media (links below) to stay up to date with the latest news.\n

\nWe look forward to bringing our practice management solution to you very soon.\n
\n\n

\nAnil & Claudia
\nMy Appointments Co-founders', '2021-04-15 09:31:50'), (26, 'Client Test', 'Test', '

Mail print

\r\n\r\nRegards\r\n

[practitioner_name]

', '2021-04-02 04:57:36'), (25, 'Client notes', 'Notes', '

Mail print

\r\n\r\nRegards\r\n

[practitioner_name]

', '2021-04-02 04:57:04'), (24, 'Client Invoice', 'Invoice', '

Mail print

\n\nRegards\n

[practitioner_name]

', '2021-05-26 04:15:36'), (23, 'Intake form', 'Intake form', '

You have received intake from link [practitioner_name].

\r\n\r\n\r\n Message:\r\n [message]', '2020-12-16 11:00:16'), (22, 'Client activation email sent via practitioner', 'Invitation via [businessname]', '

Hello [name],

\r\n\r\n

[businessname] has invited you to create an account with My Appointments - a practice management system they use to manage their bookings. From your free account, you can view your appointments, invoices, treatment recommendations and more.

\r\n\r\n

If you’d like to access these features in one user friendly place, you can do so with the following login details:

\r\n\r\n

Username: [username]
\r\nPassword: [userpassword]

\r\n\r\n

Please note, accepting this invitation is optional.

\r\n\r\n

Yours in good health.

', '2021-06-14 05:55:48'), (20, 'Practitioner Email Verification', 'Verify email address', '

[textAboveLink]

\n\n

Thank you for signing up!

\n\n

Please verify your email address by clicking the button below.

\n\n

[/textAboveLink] [textBelowLink]

\n\n

If you did not create an account, no further action is required.

\n\n

[/textBelowLink]

', '2021-04-13 05:09:39'), (19, 'Patient send invoices', 'Invoices - My Appointments', '

Invoices are attached to this email please check.

\r\n\r\n

[message]

', '2020-09-20 23:39:33'), (18, 'Patient to practitioner test result', 'Test result - My Appointments', '

You have received test result from [client_name].

\r\n\r\n

[message]

', '2020-09-10 00:21:57'), (17, 'Practitioner to client test email', 'Test result - My Appointments', '

You have received test result from [practitioner_name].

\n\n\n Message:\n [message]', '2020-06-11 04:55:56'), (16, 'Practitioner communication email', '[subject]', '

You have received communication from [practitioner_name].

\r\n\r\n\r\n Message:\r\n [message]', '2020-05-20 09:53:17'), (15, 'Practitioner reschedule appointment email', 'Appointment reschedule - My Appointments', '

You have received reschedule appointment request from [practitioner_name].

\r\n\r\n\r\n Message:\r\n [message]', '2020-06-11 04:54:13'), (14, 'Practitioner accept appointment email', 'Appointment accepted - My Appointments', '

You have received accepted Appointment from [practitioner_name].

\r\n\r\n

Message: [message]

', '2020-10-02 05:28:34'), (13, 'Practitioner booking request email', 'Request received - My Appointments', '

You have received booking request from [practitioner_name].

\r\n\r\n\r\n Message:\r\n [message]', '2020-06-11 04:53:51'), (11, 'Practitioner Team invitation email', 'Invitation received - My Appointments', '

You have received invitation from [practitioner_name].

', '2020-06-11 04:53:42'), (10, 'Client message email', 'New message recieved - My Appointments', 'You have received message from [practitioner_name].\r\n\r\n Message:\r\n [message]', '2020-06-11 04:52:51'), (9, 'Password reset email - Application', 'Reset forgotten password', '

[textAboveLink]

\n\n

You are receiving this email because we received a password reset request for your account.

\n\n

Please enter below code to reset your password.

\n\n

[/textAboveLink] [textBelowLink]

\n\n

If you did not request a password reset, no further action is required.

\n\n

[/textBelowLink]

', '2020-04-10 18:17:32'), (8, 'Email Verify Success Notification', 'Account verified', '

You have successfully verified your account.

', '2020-03-18 12:58:00'), (7, 'Registration verification email - Application', 'Verify email address', '

[textAboveLink]

\n\n

Please enter below verification code in your mobile application to verify your account.

\n\n

[/textAboveLink] [textBelowLink]

\n\n

If you did not create an account, no further action is required.

\n\n

[/textBelowLink]

', '2021-05-21 05:59:01'), (6, 'Password change notification email', 'Your password has changed', '

You have successfully reset your password.

', '2020-03-19 10:17:09'), (5, 'Password reset email - Web', 'Reset forgotten password', '

[textAboveLink]

\n\n

You are receiving this email because we received a password reset request for your account.

\n\n

[/textAboveLink] [textBelowLink]

\n\n

This password reset link will expire in 60 minutes.

\n

If you did not request a password reset, no further action is required.

\n\n

[/textBelowLink]

', '2020-03-19 15:09:44'), (4, 'Registration welcome email', 'Welcome to My Appointments', '

Dear <first name>,

\r\n\r\n

We are thrileld to have you on board.

\r\n\r\n

My Appointments. 

\r\n\r\n

 

', '2021-05-21 01:09:15'), (3, 'Registration verification email - Web', 'Verify email address', '

[textAboveLink]

\n\n

Please click the button below to verify your email address.

\n\n

[/textAboveLink] [textBelowLink]

\n\n

If you did not create an account, no further action is required.

\n\n

[/textBelowLink]

', '2020-03-19 15:10:00'); -- -- Indexes for dumped tables -- -- -- Indexes for table `email_templates` -- ALTER TABLE `email_templates` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `email_templates` -- ALTER TABLE `email_templates` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30; /*!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 */;