--
-- Dumping data for table `tbl_settings`
--
INSERT INTO `tbl_settings` (`type`, `value`, `updatedDtm`) VALUES
('signup_email_verification', '0', '2020-11-09 09:09:51'),
('valid', NULL, '2021-01-04 12:17:23');

INSERT INTO `tbl_email_templates` (`id`, `type`, `title`, `mail_subject`, `mail_body`, `modifiedBy`, `modifiedDtm`, `createdDtm`, `sms_body`) VALUES
(NULL, 'Email Verification', '', 'Please verify your email', 0x[BLOB], 1, '2021-08-26 07:32:35', '2021-08-26 09:44:55', 'The verification url is !verification_url');

ALTER TABLE tbl_plans
ADD `interest_interval` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
ADD `investment_period` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

ALTER TABLE tbl_users
ADD email_verification_code varchar(128) NULL,
ADD g_auth_secret varchar(255) DEFAULT NULL;