41 lines
3.1 KiB
SQL
41 lines
3.1 KiB
SQL
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|
START TRANSACTION;
|
|
SET time_zone = "+00:00";
|
|
|
|
CREATE TABLE `sms_templates` (
|
|
`id` int(11) NOT NULL,
|
|
`identifier` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
|
|
`sms_body` longtext COLLATE utf8_unicode_ci NOT NULL,
|
|
`status` tinyint(1) NOT NULL DEFAULT 1,
|
|
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
|
|
`updated_at` timestamp NOT NULL DEFAULT current_timestamp()
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
|
|
|
INSERT INTO `sms_templates` (`id`, `identifier`, `sms_body`, `status`, `created_at`, `updated_at`) VALUES
|
|
(1, 'mobile_number_verification', '<p>[[code]] is your verification code for [[site_name]].\r\n</p><p>\r\n[[url]]</p>', 1, '2021-03-01 08:04:26', '2021-03-14 05:09:44'),
|
|
(2, 'account_opening_by_admin', '<p>Congratulations [[name]]!\r\n</p><p>You have been added to [[site_name]] as a member.\r\n</p><p>Password is : [[password]]\r\n</p><p>Please contact the administration team if you have any further questions. Best wishes.\r\n</p><p>[[url]]</p>', 0, '2021-03-01 08:17:01', '2021-04-10 06:54:47'),
|
|
(3, 'account_approval', '<p>Congratulations [[name]]!\r\n</p><p>Your account has been approved for [[sitename]] </p><p>Please contact the administration team if you have any further questions. Best wishes.\r\n</p><p>[[url]]</p>', 0, '2021-03-01 08:24:17', '2021-03-18 03:29:48'),
|
|
(4, 'staff_account_opening', '<p>Congratulations [[name]],\r\n</p><p>You have been added to [[site_name]] as Staff.\r\n</p><p>Your account role is : [[role_type]]</p><p>Password is : [[password]]\r\n</p><p>Please contact the administration team if you have any further questions. Best wishes.\r\n</p><p> [[url]]</p>', 0, '2021-03-01 08:56:25', '2021-04-10 06:54:52'),
|
|
(5, 'manual_payment_approval', '<p>Hi [[name]],\r\n</p><p>Your payment for the package purchase has been accepted. </p><p>Payment Code is [[payment_code]\r\n</p><p>[[url]]</p>', 0, '2021-03-01 08:59:42', '2021-04-10 06:54:56'),
|
|
(6, 'express_interest', '<p>Hi [[name]], </p><p>\r\n[[member_name]] has expressed interest in you.\r\n</p><p>[[url]]</p>', 0, '2021-03-01 09:07:49', '2021-04-10 06:54:59'),
|
|
(7, 'accept_interest', '<p>Hi [[name]], </p><p>\r\n[[member_name]] has accepted your interest. </p><p>\r\n[[url]]</p>', 0, '2021-03-01 09:08:13', '2021-04-10 06:55:03'),
|
|
(8, 'password_reset', '<p>Hi [[name]], </p><p>\r\nYour password reset code is [[code]]\r\n</p><p>[[url]]</p>', 1, '2021-03-01 09:42:45', '2021-03-18 02:43:42');
|
|
|
|
|
|
ALTER TABLE `sms_templates`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
ALTER TABLE `sms_templates`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
|
|
|
|
INSERT INTO `settings` (`id`, `type`, `value`, `created_at`, `updated_at`, `deleted_at`)
|
|
VALUES
|
|
(NULL, 'twillo_activation', NULL, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL),
|
|
(NULL, 'fast2sms_activation', NULL, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL),
|
|
(NULL, 'mimo_activation', NULL, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL),
|
|
(NULL, 'ssl_wireless_activation', NULL, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL),
|
|
(NULL, 'nexmo_activation', NULL, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL);
|
|
|
|
COMMIT;
|