text: ALTER TABLE tbl_payments_api RENAME TO tbl_addons_api;
  ALTER TABLE tbl_email_templates ADD sms_body varchar(255);
  ALTER TABLE tbl_email_templates MODIFY id INT AUTO_INCREMENT;
  
  --
  -- Table structure for table `tbl_paypal`
  --
  
  CREATE TABLE `tbl_paypal` (
    `id` int(11) NOT NULL,
    `userid` int(11) NOT NULL,
    `invoice` varchar(255) NOT NULL,
    `plan` int(11) NOT NULL,
    `txn_id` varchar(255) NOT NULL,
    `local_currency` float(10,2) NOT NULL,
    `payment_gross` float(10,2) NOT NULL,
    `currency_code` varchar(5) NOT NULL,
    `payer_email` varchar(255) NOT NULL,
    `payment_status` varchar(255) NOT NULL,
    `createdDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  ALTER TABLE `tbl_paypal`
    ADD PRIMARY KEY (`id`);
  
  ALTER TABLE `tbl_paypal`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  -- --------------------------------------------------------
  --
  -- Dumping data for table `tbl_addons_api`
  --
  
  INSERT INTO `tbl_addons_api` (`id`, `name`, `logo`, `public_key`, `secret_key`, `IPN_secret`, `merchantID`, `base_url`, `env`, `currency`, `status`, `createdDtm`) VALUES
  (2, 'PayPal', 'paypal.png', '', '', '', '', '', '', 'USD', 0, '2019-11-22 00:00:00'),
  (3, 'Twilio', 'twilio.png', '', '', '', '', '', '', 'USD', 0, '2019-11-22 00:00:00');
  
  -- --------------------------------------------------------
  
  --
  -- Dumping data for table `tbl_email_templates`
  --
  
  INSERT INTO `tbl_email_templates` (`id`, `type`, `title`, `mail_subject`, `mail_body`, `sms_body`, `modifiedBy`, `modifiedDtm`, `createdDtm`) VALUES
  (DEFAULT, 'Test Email', '', '!companyName Test Email', 0x3c646976207374796c653d22666f6e742d73697a653a3170783b636f6c6f723a236665666566653b6c696e652d6865696768743a3170783b666f6e742d66616d696c793a4c61746f2c2048656c7665746963612c20417269616c2c2073616e732d73657269663b6d61782d6865696768743a3070783b6d61782d77696474683a3070783b223e0d0a20202020596f7572206163636f756e7420686173206265656e20637265617465642073756363657366756c6c792e0d0a3c2f6469763e0d0a0d0a3c7461626c6520626f726465723d2230222063656c6c70616464696e673d2230222063656c6c73706163696e673d2230222077696474683d2231303025223e3c74626f64793e3c74723e3c746420616c69676e3d2263656e74657222207374796c653d226261636b67726f756e642d636f6c6f723a233233323933663b223e0d0a2020202020202020202020203c7461626c6520626f726465723d2230222063656c6c70616464696e673d2230222063656c6c73706163696e673d2230222077696474683d22343830223e3c74626f64793e3c74723e3c746420616c69676e3d2263656e746572222076616c69676e3d22746f7022207374796c653d2270616464696e673a343070782031307078203430707820313070783b223e0d0a2020202020202020202020202020202020202020202020203c6120636c6173733d226e61766261722d6272616e642220687265663d2268747470733a2f2f70726f696e766573742e6178697339362e636f2f223e0d0a202020202020202020202020202020202020202020202020202020203c696d67207372633d2268747470733a2f2f70726f696e766573742e6178697339362e636f2f75706c6f6164732f6c6f676f2d77686974652e706e672220616c743d226c6f676f2d77686974652e706e6722202f3e3c2f613e0d0a20202020202020202020202020202020202020203c2f74643e0d0a202020202020202020202020202020203c2f74723e3c2f74626f64793e3c2f7461626c653e3c2f74643e0d0a202020203c2f74723e3c74723e3c7464207374796c653d226261636b67726f756e642d636f6c6f723a233233323933663b70616464696e673a30707820313070782030707820313070783b2220616c69676e3d2263656e746572223e0d0a2020202020202020202020203c7461626c6520626f726465723d2230222063656c6c70616464696e673d2230222063656c6c73706163696e673d2230222077696474683d22343830223e3c74626f64793e3c74723e3c746420616c69676e3d2263656e746572222076616c69676e3d22746f7022207374796c653d226261636b67726f756e642d636f6c6f723a236666666666663b70616464696e673a343070782032307078203230707820323070783b636f6c6f723a233131313131313b666f6e742d66616d696c793a4c61746f2c2048656c7665746963612c20417269616c2c2073616e732d73657269663b666f6e742d73697a653a343870783b666f6e742d7765696768743a3430303b6c65747465722d73706163696e673a3470783b6c696e652d6865696768743a343870783b223e0d0a202020202020202020202020202020202020202020203c6831207374796c653d22666f6e742d73697a653a323570783b666f6e742d7765696768743a3430303b6d617267696e2d6c6566743a313070783b746578742d616c69676e3a6c6566743b6c65747465722d73706163696e673a3070783b636f6c6f723a233131313131313b223e48692c3c2f68313e0d0a20202020202020202020202020202020202020203c2f74643e0d0a202020202020202020202020202020203c2f74723e3c2f74626f64793e3c2f7461626c653e3c2f74643e0d0a202020203c2f74723e3c74723e3c746420616c69676e3d2263656e74657222207374796c653d226261636b67726f756e642d636f6c6f723a236634663466343b70616464696e673a30707820313070782030707820313070783b223e0d0a2020202020202020202020203c7461626c6520626f726465723d2230222063656c6c70616464696e673d2230222063656c6c73706163696e673d2230222077696474683d22343830223e3c74626f64793e3c74723e3c746420616c69676e3d226c65667422207374796c653d226261636b67726f756e642d636f6c6f723a236666666666663b70616464696e673a323070782033307078203430707820333070783b636f6c6f723a233636363636363b666f6e742d66616d696c793a4c61746f2c2048656c7665746963612c20417269616c2c2073616e732d73657269663b666f6e742d73697a653a313870783b666f6e742d7765696768743a3430303b6c696e652d6865696768743a323570783b223e0d0a2020202020202020202020202020202020203c70207374796c653d226d617267696e3a303b223e546869732069732061207465737420656d61696c2e205468697320697320686f7720796f757220636c69656e74732077696c6c207265636569766520656d61696c732e3c2f703e0d0a202020202020202020202020202020203c2f74643e0d0a20202020202020202020202020203c2f74723e3c74723e3c746420616c69676e3d226c65667422207374796c653d226261636b67726f756e642d636f6c6f723a236666666666663b223e0d0a2020202020202020202020202020202020200d0a202020202020202020202020202020203c2f74643e0d0a20202020202020202020202020203c2f74723e3c2f74626f64793e3c2f7461626c653e3c2f74643e0d0a202020203c2f74723e3c74723e3c746420616c69676e3d2263656e74657222207374796c653d226261636b67726f756e642d636f6c6f723a236634663466343b70616464696e673a30707820313070782030707820313070783b223e3c6272202f3e3c2f74643e0d0a202020203c2f74723e3c74723e3c746420616c69676e3d2263656e74657222207374796c653d226261636b67726f756e642d636f6c6f723a236634663466343b70616464696e673a3330707820313070782030707820313070783b223e0d0a2020202020202020202020203c7461626c6520626f726465723d2230222063656c6c70616464696e673d2230222063656c6c73706163696e673d2230222077696474683d22343830223e3c74626f64793e3c74723e3c746420616c69676e3d2263656e74657222207374796c653d226261636b67726f756e642d636f6c6f723a234336433245443b70616464696e673a333070782033307078203330707820333070783b636f6c6f723a233636363636363b666f6e742d66616d696c793a4c61746f2c2048656c7665746963612c20417269616c2c2073616e732d73657269663b666f6e742d73697a653a313870783b666f6e742d7765696768743a3430303b6c696e652d6865696768743a323570783b223e0d0a20202020202020202020202020202020202020203c6832207374796c653d22666f6e742d73697a653a323070783b666f6e742d7765696768743a3430303b636f6c6f723a233131313131313b6d617267696e3a303b223e4e656564206d6f72652068656c703f3c2f68323e0d0a20202020202020202020202020202020202020203c70207374796c653d226d617267696e3a303b223e3c6120687265663d2268747470733a2f2f70726f696e766573742e6178697339362e636f22207374796c653d22636f6c6f723a233763373264633b223e5765e28099726520686572652c20726561647920746f2074616c6b3c2f613e3c2f703e0d0a2020202020202020202020202020202020203c2f74643e0d0a202020202020202020202020202020203c2f74723e3c2f74626f64793e3c2f7461626c653e3c2f74643e0d0a202020203c2f74723e3c74723e3c746420616c69676e3d2263656e74657222207374796c653d226261636b67726f756e642d636f6c6f723a236634663466343b70616464696e673a30707820313070782030707820313070783b223e0d0a2020202020202020202020203c7461626c6520626f726465723d2230222063656c6c70616464696e673d2230222063656c6c73706163696e673d2230222077696474683d22343830223e3c74626f64793e3c74723e3c746420616c69676e3d226c65667422207374796c653d226261636b67726f756e642d636f6c6f723a236634663466343b70616464696e673a3070782033307078203330707820333070783b636f6c6f723a233636363636363b666f6e742d66616d696c793a4c61746f2c2048656c7665746963612c20417269616c2c2073616e732d73657269663b666f6e742d73697a653a313470783b666f6e742d7765696768743a3430303b6c696e652d6865696768743a313870783b223e0d0a2020202020202020202020202020202020203c70207374796c653d226d617267696e3a303b223e596f75207265636569766564207468697320656d61696c206265636175736520796f752072657175657374656420612070617373776f72642072657365742e20496620796f7520646964206e6f742c203c6120687265663d2268747470733a2f2f70726f696e766573742e6178697339362e636f22207374796c653d22636f6c6f723a233131313131313b666f6e742d7765696768743a3730303b223e706c6561736520636f6e746163742075732e3c2f613e2e3c2f703e0d0a202020202020202020202020202020203c2f74643e0d0a20202020202020202020202020203c2f74723e3c74723e3c746420616c69676e3d226c65667422207374796c653d226261636b67726f756e642d636f6c6f723a236634663466343b70616464696e673a3070782033307078203330707820333070783b636f6c6f723a233636363636363b666f6e742d66616d696c793a4c61746f2c2048656c7665746963612c20417269616c2c2073616e732d73657269663b666f6e742d73697a653a313470783b666f6e742d7765696768743a3430303b6c696e652d6865696768743a313870783b223e0d0a2020202020202020202020202020202020203c70207374796c653d226d617267696e3a303b223e21616464726573733c2f703e0d0a202020202020202020202020202020203c2f74643e0d0a20202020202020202020202020203c2f74723e3c2f74626f64793e3c2f7461626c653e3c2f74643e0d0a202020203c2f74723e3c2f74626f64793e3c2f7461626c653e, 'This is a test SMS', 1, '2020-02-01 13:12:59', '0000-00-00 00:00:00');
  
  --
  -- Dumping sms_body for table `tbl_email_templates`
  --
  
  UPDATE tbl_email_templates SET sms_body='Please go to !resetLink to reset your password. If you did not request a new password please ignore' WHERE id=2;
  UPDATE tbl_email_templates SET sms_body='!referrerName has invited you to join !companyName. Click on !referralLink to register' WHERE id=3;
  UPDATE tbl_email_templates SET sms_body='You have succesfully deposited !depositAmount into your account.' WHERE id=4;
  UPDATE tbl_email_templates SET sms_body='Your request for withdrawing !withdrawalAmount has been processed successfully. Please check your withdrawal account to confirm payment.' WHERE id=5;
  UPDATE tbl_email_templates SET sms_body='Your request for withdrawing !withdrawalAmount has been received successfully. Kindly note that our payment periods are on Mondays, Wednesdays and Fridays.' WHERE id=6;
  UPDATE tbl_email_templates SET sms_body='Your new account at !companyName has been created. Please click on the following link to set your password. !passwordResetLink' WHERE id=7;
  UPDATE tbl_email_templates SET sms_body='Your payment account has been updated. If this was not you, kindly contact support as soon as possible.' WHERE id=8;
  UPDATE tbl_email_templates SET sms_body='Welcome to !companyName. Here are your login details.     Email: !clientEmail  Password: xxxxxxxxx' WHERE id=9;
  UPDATE tbl_email_templates SET sms_body='Your payment for $!depositAmount could not be processed. Please try again.    If you have already sent the funds, kindly get in touch with our support team.' WHERE id=10;
  UPDATE tbl_email_templates SET sms_body='You have earned !amount from !companyName with reference number !ref. Please check your account.' WHERE id=11;
  
  --
  -- Dumping data for table `tbl_settings`
  --
  
  INSERT INTO `tbl_payment_methods` (`id`, `name`, `logo`, `ref`, `API`, `bank_name`, `account_name`, 
  `account_number`, `swift_code`, `status`) VALUES
  (DEFAULT, 'Paypal', 'paypal.png', 'PP', 2, '', '', '', '', 0),
  (DEFAULT, 'Litecoin Testnet', 'ltct.png', 'LTCT', 4, '', '', '', '', 0);
  
  INSERT INTO `tbl_settings` (`type`, `value`, `updatedDtm`) VALUES
  ('email_active', '0', '0000-00-00 00:00:00'),
  ('sms_active', '0', '0000-00-00 00:00:00'),
  ('sms_phone', '', '0000-00-00 00:00:00'),
  ('SMTPCrypto', '', '0000-00-00 00:00:00'),
  ('SMTPProtocol', '', '0000-00-00 00:00:00');
  