IP : 18.226.200.44Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
softaculous/
x2/
../
lime5/
../
geeklog/
../
moodle44/
../
akaunting/
akaunting.sql/
/
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 utf8 */;
-- -- Dumping data for table `[[dbprefix]]email_templates` --
INSERT INTO `[[dbprefix]]email_templates` VALUES (1, 1, 'invoice_new_customer', 'App\\Notifications\\Sale\\Invoice', 'settings.email.templates.invoice_new_customer', '{invoice_number} invoice created', 'Dear {customer_name},<br /><br />We have prepared the following invoice for you: <strong>{invoice_number}</strong>.<br /><br />You can see the invoice details and proceed with the payment from the following link: <a href="{invoice_guest_link}">{invoice_number}</a>.<br /><br />Feel free to contact us with any questions.<br /><br />Best Regards,<br />{company_name}', NULL, 'core::seed', NULL, '[[regtime]]', '[[regtime]]', NULL), (2, 1, 'invoice_remind_customer', 'App\\Notifications\\Sale\\Invoice', 'settings.email.templates.invoice_remind_customer', '{invoice_number} invoice overdue notice', 'Dear {customer_name},<br /><br />This is an overdue notice for <strong>{invoice_number}</strong> invoice.<br /><br />The invoice total is {invoice_total} and was due <strong>{invoice_due_date}</strong>.<br /><br />You can see the invoice details and proceed with the payment from the following link: <a href="{invoice_guest_link}">{invoice_number}</a>.<br /><br />Best Regards,<br />{company_name}', NULL, 'core::seed', NULL, '[[regtime]]', '[[regtime]]', NULL), (3, 1, 'invoice_remind_admin', 'App\\Notifications\\Sale\\Invoice', 'settings.email.templates.invoice_remind_admin', '{invoice_number} invoice overdue notice', 'Hello,<br /><br />{customer_name} has received an overdue notice for <strong>{invoice_number}</strong> invoice.<br /><br />The invoice total is {invoice_total} and was due <strong>{invoice_due_date}</strong>.<br /><br />You can see the invoice details from the following link: <a href="{invoice_admin_link}">{invoice_number}</a>.<br /><br />Best Regards,<br />{company_name}', NULL, 'core::seed', NULL, '[[regtime]]', '[[regtime]]', NULL), (4, 1, 'invoice_recur_customer', 'App\\Notifications\\Sale\\Invoice', 'settings.email.templates.invoice_recur_customer', '{invoice_number} recurring invoice created', 'Dear {customer_name},<br /><br />Based on your recurring circle, we have prepared the following invoice for you: <strong>{invoice_number}</strong>.<br /><br />You can see the invoice details and proceed with the payment from the following link: <a href="{invoice_guest_link}">{invoice_number}</a>.<br /><br />Feel free to contact us for any question.<br /><br />Best Regards,<br />{company_name}', NULL, 'core::seed', NULL, '[[regtime]]', '[[regtime]]', NULL), (5, 1, 'invoice_recur_admin', 'App\\Notifications\\Sale\\Invoice', 'settings.email.templates.invoice_recur_admin', '{invoice_number} recurring invoice created', 'Hello,<br /><br />Based on {customer_name} recurring circle, <strong>{invoice_number}</strong> invoice has been automatically created.<br /><br />You can see the invoice details from the following link: <a href="{invoice_admin_link}">{invoice_number}</a>.<br /><br />Best Regards,<br />{company_name}', NULL, 'core::seed', NULL, '[[regtime]]', '[[regtime]]', NULL), (6, 1, 'invoice_view_admin', 'App\\Notifications\\Sale\\Invoice', 'settings.email.templates.invoice_view_admin', '{invoice_number} invoice viewed', 'Hello,<br /><br />{customer_name} has viewed the <strong>{invoice_number}</strong> invoice.<br /><br />You can see the invoice details from the following link: <a href="{invoice_admin_link}">{invoice_number}</a>.<br /><br />Best Regards,<br />{company_name}', NULL, 'core::seed', NULL, '[[regtime]]', '[[regtime]]', NULL), (7, 1, 'invoice_payment_customer', 'App\\Notifications\\Portal\\PaymentReceived', 'settings.email.templates.invoice_payment_customer', 'Payment received for {invoice_number} invoice', 'Dear {customer_name},<br /><br />Thank you for the payment. Find the payment details below:<br /><br />-------------------------------------------------<br />Amount: <strong>{transaction_total}</strong><br />Date: <strong>{transaction_paid_date}</strong><br />Invoice Number: <strong>{invoice_number}</strong><br />-------------------------------------------------<br /><br />You can always see the invoice details from the following link: <a href="{invoice_guest_link}">{invoice_number}</a>.<br /><br />Feel free to contact us for any question.<br /><br />Best Regards,<br />{company_name}', NULL, 'core::seed', NULL, '[[regtime]]', '[[regtime]]', NULL), (8, 1, 'invoice_payment_admin', 'App\\Notifications\\Portal\\PaymentReceived', 'settings.email.templates.invoice_payment_admin', 'Payment received for {invoice_number} invoice', 'Hello,<br /><br />{customer_name} recorded a payment for <strong>{invoice_number}</strong> invoice.<br /><br />You can see the invoice details from the following link: <a href="{invoice_admin_link}">{invoice_number}</a>.<br /><br />Best Regards,<br />{company_name}', NULL, 'core::seed', NULL, '[[regtime]]', '[[regtime]]', NULL), (9, 1, 'bill_remind_admin', 'App\\Notifications\\Purchase\\Bill', 'settings.email.templates.bill_remind_admin', '{bill_number} bill reminding notice', 'Hello,<br /><br />This is a reminding notice for <strong>{bill_number}</strong> bill to {vendor_name}.<br /><br />The bill total is {bill_total} and is due <strong>{bill_due_date}</strong>.<br /><br />You can see the bill details from the following link: <a href="{bill_admin_link}">{bill_number}</a>.<br /><br />Best Regards,<br />{company_name}', NULL, 'core::seed', NULL, '[[regtime]]', '[[regtime]]', NULL), (10, 1, 'bill_recur_admin', 'App\\Notifications\\Purchase\\Bill', 'settings.email.templates.bill_recur_admin', '{bill_number} recurring bill created', 'Hello,<br /><br />Based on {vendor_name} recurring circle, <strong>{bill_number}</strong> invoice has been automatically created.<br /><br />You can see the bill details from the following link: <a href="{bill_admin_link}">{bill_number}</a>.<br /><br />Best Regards,<br />{company_name}', NULL, 'core::seed', NULL, '[[regtime]]', '[[regtime]]', NULL), (11, 1, 'payment_received_customer', 'App\\Notifications\\Banking\\Transaction', 'settings.email.templates.payment_received_customer', 'Your receipt from {company_name}', 'Dear {contact_name},<br /><br />Thank you for the payment. <br /><br />You can see the payment details from the following link: <a href="{payment_guest_link}">{payment_date}</a>.<br /><br />Feel free to contact us with any questions.<br /><br />Best Regards,<br />{company_name}', NULL, 'core::seed', NULL, '[[regtime]]', '[[regtime]]', NULL), (12, 1, 'payment_made_vendor', 'App\\Notifications\\Banking\\Transaction', 'settings.email.templates.payment_made_vendor', 'Payment made by {company_name}', 'Dear {contact_name},<br /><br />We have made the following payment. <br /><br />You can see the payment details from the following link: <a href="{payment_guest_link}">{payment_date}</a>.<br /><br />Feel free to contact us with any questions.<br /><br />Best Regards,<br />{company_name}', NULL, 'core::seed', NULL, '[[regtime]]', '[[regtime]]', NULL);
-- -- Dumping data for table `[[dbprefix]]roles` --
INSERT INTO `[[dbprefix]]roles` VALUES (1, 'admin', 'Admin', 'They get full access to your Akaunting including customers, invoices, reports, settings, and apps.', NULL, NULL, '[[regtime]]', '[[regtime]]'), (2, 'manager', 'Manager', 'They get full access to your Akaunting, but can''t manage users and apps.', NULL, NULL, '[[regtime]]', '[[regtime]]'), (3, 'customer', 'Customer', 'They can access the Client Portal and pay their invoices online through the payment methods you set up.', NULL, NULL, '[[regtime]]', '[[regtime]]'), (4, 'accountant', 'Accountant', 'They can access invoices, transactions, reports, and create journal entries.', NULL, NULL, '[[regtime]]', '[[regtime]]');
-- -- Constraints for table `[[dbprefix]]categories` -- ALTER TABLE `[[dbprefix]]categories` ADD CONSTRAINT `[[dbprefix]]categories_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `[[dbprefix]]categories` (`id`);
-- -- Constraints for table `[[dbprefix]]media` -- ALTER TABLE `[[dbprefix]]media` ADD CONSTRAINT `original_media_id` FOREIGN KEY (`original_media_id`) REFERENCES `[[dbprefix]]media` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]mediables` -- ALTER TABLE `[[dbprefix]]mediables` ADD CONSTRAINT `[[dbprefix]]mediables_media_id_foreign` FOREIGN KEY (`media_id`) REFERENCES `[[dbprefix]]media` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]role_permissions` -- ALTER TABLE `[[dbprefix]]role_permissions` ADD CONSTRAINT `[[dbprefix]]role_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `[[dbprefix]]permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `[[dbprefix]]role_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `[[dbprefix]]roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `[[dbprefix]]transactions` -- ALTER TABLE `[[dbprefix]]transactions` ADD CONSTRAINT `[[dbprefix]]transactions_split_id_foreign` FOREIGN KEY (`split_id`) REFERENCES `[[dbprefix]]transactions` (`id`);
-- -- Constraints for table `[[dbprefix]]user_permissions` -- ALTER TABLE `[[dbprefix]]user_permissions` ADD CONSTRAINT `[[dbprefix]]user_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `[[dbprefix]]permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `[[dbprefix]]user_roles` -- ALTER TABLE `[[dbprefix]]user_roles` ADD CONSTRAINT `[[dbprefix]]user_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `[[dbprefix]]roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
/*!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 */;