-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `proinvest_v36`
--

-- --------------------------------------------------------

--
-- Table structure for table `ci_sessions`
--

CREATE TABLE `ci_sessions` (
  `id` varchar(40) NOT NULL DEFAULT '0',
  `ip_address` varchar(45) NOT NULL DEFAULT '0',
  `user_agent` varchar(120) DEFAULT NULL,
  `timestamp` int UNSIGNED NOT NULL DEFAULT '0',
  `data` longblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_coinbase`
--

CREATE TABLE `tbl_coinbase` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `invoice` varchar(255) NOT NULL,
  `planId` int NOT NULL,
  `txn_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0',
  `modifiedDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_coinpayments`
--

CREATE TABLE `tbl_coinpayments` (
  `id` int NOT NULL,
  `userid` int NOT NULL,
  `invoice` varchar(128) NOT NULL,
  `txnCode` varchar(128) NOT NULL,
  `address` varchar(128) NOT NULL,
  `method` varchar(128) NOT NULL,
  `plan` int NOT NULL,
  `amount1` decimal(10,0) NOT NULL,
  `amount2` varchar(128) NOT NULL,
  `status` int NOT NULL,
  `expiry` datetime NOT NULL,
  `createdDtm` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_content`
--

CREATE TABLE `tbl_content` (
  `id` int NOT NULL,
  `template` int DEFAULT NULL,
  `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `value` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_content`
--

INSERT INTO `tbl_content` (`id`, `template`, `name`, `value`) VALUES
(1, 1, 'policy', 0x[encoded data, 6188 characters]),
(2, 1, 'terms', 0x[encoded data, 9574 characters]),
(3, 1, 'footer', 0x4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2056656c697420647563696d757320766f6c757074617469627573206e6571756520696c6c6f20696420726570656c6c617420717569737175616d3f20417574656d20657870656469746120656172756d2071756165206c61626f72756d20697073756d2061642e),
(4, 1, 'header_sub_title', 0x0a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020204f75722061696d20697320746f20756e6c6f636b206f757220636c69656e7473272066696e616e6369616c2066726565646f6d),
(5, 1, 'header_title', 0x0a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a2020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a2020202020202020202020202020202020202020202020202020202020202020486967682052657475726e7320576974682043616c63756c61746564205269736b20202020),
(6, 1, 'header_description', 0x50726f496e7665737420697320696e74656e64656420666f722070656f706c652077696c6c696e6720746f2061636869657665207765616c746820616e642066696e616e6369616c2066726565646f6d2062757420756e61626c6520746f20646f20736f20626563617573652074686579277265206e6f742066696e616e6369616c20657870657274732e2020202020202020202020202020202020202020),
(7, 1, 'card_1_subtitle', 0x47657420746f206b6e6f77207573),
(8, 1, 'card_1_title', 0x41626f75742050726f496e766573742046756e64),
(9, 1, 'card_1_content', 0x0a20202020202020202020202020202020202020203c7370616e207873733d2272656d6f766564223e4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2053757363697069742065756d20696c6c756d2074656d706f72613f20447563696d75732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d20657420736974206e6973692c206d6f6c6c6974696120616e696d6920706f72726f20667567612073657175692c206d6f6c65737469617320726570656c6c617420657863657074757269206e6f6269732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d2065742e4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2053757363697069742065756d20696c6c756d2074656d706f72613f20447563696d75732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d20657420736974206e6973692c206d6f6c6c6974696120616e696d6920706f72726f20667567612073657175692c206d6f6c65737469617320726570656c6c617420657863657074757269206e6f6269732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d2065742e3c2f7370616e3e2020202020202020202020202020202020202020),
(10, 1, 'card_2_subtitle', 0x496e766573746d656e7420506c616e73),
(11, 1, 'card_2_title', 0x0a202020202020202020202020202020200a202020202020202020202020202020200a202020202020202020202020202020200a202020202020202020202020202020200a202020202020202020202020202020200a202020202020202020202020202020200a202020202020202020202020202020200a202020202020202020202020202020204f757220496e766573746d656e7420506c616e732020202020202020202020202020202020202020202020202020202020202020),
(12, 1, 'card_3_subtitle', 0x5369676e20557020616e64206265636f6d6520616e20616666696c6961746520746f646179),
(13, 1, 'card_3_title', 0x416666696c696174652050726f6772616d20466f7220596f75),
(14, 1, 'card_3_content', 0x0a20202020202020202020202020202020202020204c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2053757363697069742065756d20696c6c756d2074656d706f72613f20447563696d75732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d20657420736974206e6973692c206d6f6c6c6974696120616e696d6920706f72726f20667567612073657175692c206d6f6c65737469617320726570656c6c617420657863657074757269206e6f6269732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d2065742e4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2053757363697069742065756d20696c6c756d2074656d706f72613f20447563696d75732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d20657420736974206e6973692c206d6f6c6c6974696120616e696d6920706f72726f20667567612073657175692c206d6f6c65737469617320726570656c6c617420657863657074757269206e6f6269732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d2065742e0a2020202020202020202020202020202020202020),
(15, 1, 'card_4_subtitle', 0x57687920576f726b20576974682055733f),
(16, 1, 'card_4_title', 0x47657420746f206b6e6f77207573),
(17, 1, 'card_4_content', 0x0a20202020202020202020202020202020202020204c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2053757363697069742065756d20696c6c756d2074656d706f72613f20447563696d75732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d20657420736974206e6973692c206d6f6c6c6974696120616e696d6920706f72726f20667567612073657175692c206d6f6c65737469617320726570656c6c617420657863657074757269206e6f6269732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d2065742e4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2053757363697069742065756d20696c6c756d2074656d706f72613f20447563696d75732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d20657420736974206e6973692c206d6f6c6c6974696120616e696d6920706f72726f20667567612073657175692c206d6f6c65737469617320726570656c6c617420657863657074757269206e6f6269732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d2065742e0a2020202020202020202020202020202020202020),
(18, 1, 'card_5_subtitle', 0x436f6e74616374205573),
(19, 1, 'card_5_title', 0x0a20202020202020202020202020202020537065616b2057697468205573),
(20, 1, 'card_5_content', 0x4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e73656374657475722061646970697363696e6720656c69742e20536564207175697320616363756d73616e206e6973692055742075742066656c697320636f6e677565206e69736c2068656e64726572697420636f6d6d6f646f2e20202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020),
(21, 2, 'policy', 0x[encoded data, 6188 characters]),
(22, 2, 'terms', 0x[encoded data, 9574 characters]),
(23, 2, 'footer', 0x4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2056656c697420647563696d757320766f6c757074617469627573206e6571756520696c6c6f20696420726570656c6c617420717569737175616d3f20417574656d20657870656469746120656172756d2071756165206c61626f72756d20697073756d2061642e),
(24, 2, 'header_sub_title', 0x4f75722061696d20697320746f20756e6c6f636b206f757220636c69656e7473272066696e616e6369616c2066726565646f6d),
(25, 2, 'header_title', 0x0a2020202020202020202020202020202020202020202020200a2020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020486967682052657475726e7320576974682043616c63756c61746564205269736b202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020),
(26, 2, 'header_description', 0x0a20202020202020202020202020202020202020200a20202020202020202020202020202020202020200a20202020202020202020202020202020202020200a20202020202020202020202020202020202020200a20202020202020202020202020202020202020200a202020202020202020202020202020202020202050726f696e7665737420697320696e74656e64656420666f722070656f706c652077696c6c696e6720746f2061636869657665207765616c746820616e642066696e616e6369616c2066726565646f6d2062757420756e61626c6520746f20646f20736f20626563617573652074686579277265206e6f742066696e616e6369616c20657870657274732e202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020),
(27, 2, 'card_1_subtitle', 0x47657420746f206b6e6f77207573),
(28, 2, 'card_1_title', 0x41626f7574205573),
(29, 2, 'card_1_content', 0x0a20202020202020202020202020202020202020200a20202020202020202020202020202020202020200a20202020202020202020202020202020202020200a20202020202020202020202020202020202020200a20202020202020202020202020202020202020200a20202020202020202020202020202020202020204c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2053757363697069742065756d20696c6c756d2074656d706f72613f20447563696d75732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d20657420736974206e6973692c206d6f6c6c6974696120616e696d6920706f72726f20667567612073657175692c206d6f6c65737469617320726570656c6c617420657863657074757269206e6f6269732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d2065742e4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2053757363697069742065756d20696c6c756d2074656d706f72613f20447563696d75732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d20657420736974206e6973692c206d6f6c6c6974696120616e696d6920706f72726f20667567612073657175692c206d6f6c65737469617320726570656c6c617420657863657074757269206e6f6269732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d2065742e202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020),
(30, 2, 'card_2_subtitle', 0x486f7720546f20496e76657374),
(31, 2, 'card_2_title', 0x0a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a202020202020202020202020496e76657374696e67204973204173204561737920417320312c322c33202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020),
(32, 2, 'card_2_content_1_title', 0x437265617465204163636f756e74),
(33, 2, 'card_2_content_1_info', 0x5265676973746572206f6e206f757220706c6174666f726d2e),
(34, 2, 'card_2_content_2_title', 0x53656c65637420496e766573746d656e7420506c616e),
(35, 2, 'card_2_content_2_info', 0x53656c65637420796f75722070726566657272656420696e766573746d656e7420706c616e2e),
(36, 2, 'card_2_content_3_title', 0x4561726e),
(37, 2, 'card_2_content_3_info', 0x47657420796f75722072657475726e7320636f6e76656e69656e746c792e),
(38, 2, 'card_3_subtitle', 0x41626f7574205573),
(39, 2, 'card_3_title', 0x47657420746f206b6e6f77207573),
(40, 2, 'card_3_content', 0x0a20202020202020202020202020202020202020200a20202020202020202020202020202020202020200a20202020202020202020202020202020202020200a20202020202020202020202020202020202020200a20202020202020202020202020202020202020200a20202020202020202020202020202020202020204c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2053757363697069742065756d20696c6c756d2074656d706f72613f20447563696d75732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d20657420736974206e6973692c206d6f6c6c6974696120616e696d6920706f72726f20667567612073657175692c206d6f6c65737469617320726570656c6c617420657863657074757269206e6f6269732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d2065742e4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2053757363697069742065756d20696c6c756d2074656d706f72613f20447563696d75732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d20657420736974206e6973692c206d6f6c6c6974696120616e696d6920706f72726f20667567612073657175692c206d6f6c65737469617320726570656c6c617420657863657074757269206e6f6269732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d2065742e202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020),
(41, 2, 'card_4_subtitle', 0x57687920576f726b20576974682055733f),
(42, 2, 'card_4_title', 0x47657420746f206b6e6f77207573),
(43, 2, 'card_4_content', 0x0a20202020202020202020202020202020202020200a20202020202020202020202020202020202020200a20202020202020202020202020202020202020200a20202020202020202020202020202020202020200a20202020202020202020202020202020202020200a20202020202020202020202020202020202020204c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2053757363697069742065756d20696c6c756d2074656d706f72613f20447563696d75732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d20657420736974206e6973692c206d6f6c6c6974696120616e696d6920706f72726f20667567612073657175692c206d6f6c65737469617320726570656c6c617420657863657074757269206e6f6269732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d2065742e4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2053757363697069742065756d20696c6c756d2074656d706f72613f20447563696d75732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d20657420736974206e6973692c206d6f6c6c6974696120616e696d6920706f72726f20667567612073657175692c206d6f6c65737469617320726570656c6c617420657863657074757269206e6f6269732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d2065742e202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020),
(44, 2, 'card_5_subtitle', 0x496e766573746d656e7420506c616e73),
(45, 2, 'card_5_title', 0x0a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a2020202020202020202020204f757220496e766573746d656e7420506c616e73202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020),
(46, 2, 'card_6_subtitle', 0x4c6574277320576f726b20546f676574686572),
(47, 2, 'card_6_title', 0x0a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a2020202020202020202020200a2020202020202020202020204a6f696e20557320546f646179);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_deposits`
--

CREATE TABLE `tbl_deposits` (
  `id` int NOT NULL,
  `txnCode` varchar(128) NOT NULL,
  `userId` int NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `paymentMethod` varchar(128) NOT NULL,
  `planId` int NOT NULL,
  `maturityDtm` datetime NOT NULL,
  `img` varchar(255) DEFAULT NULL,
  `deposit_account` varchar(255) DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0',
  `createdBy` int NOT NULL,
  `createdDtm` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_earnings`
--

CREATE TABLE `tbl_earnings` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `type` varchar(128) NOT NULL,
  `depositId` int NOT NULL,
  `txnCode` varchar(128) NOT NULL,
  `amount` decimal(13,2) NOT NULL,
  `email_sent` tinyint NOT NULL DEFAULT '0',
  `createdDtm` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_email_templates`
--

CREATE TABLE `tbl_email_templates` (
  `id` int NOT NULL,
  `type` varchar(128) NOT NULL,
  `title` varchar(124) NOT NULL,
  `mail_subject` varchar(128) NOT NULL,
  `mail_body` blob NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedDtm` datetime NOT NULL,
  `createdDtm` datetime NOT NULL,
  `sms_body` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `tbl_email_templates` (`id`, `type`, `title`, `mail_subject`, `mail_body`, `modifiedBy`, `modifiedDtm`, `createdDtm`, `sms_body`) VALUES
(7, 'Add Client', '', 'Welcome to !companyName', 0x[encoded data, 10188 characters], 1, '2021-02-10 15:52:32', '0000-00-00 00:00:00', 'Your new account at !companyName has been created. Please click on the following link to set your password. !passwordResetLink'),
(8, 'Account Updated', '', 'You\'ve updated your !companyName Payment Account', 0x[encoded data, 7910 characters], 1, '2021-02-10 15:52:48', '0000-00-00 00:00:00', 'Your payment account has been updated. If this was not you, kindly contact support as soon as possible.'),
(9, 'Registration', '', 'Welcome to !companyName', 0x[encoded data, 7046 characters], 1, '2021-02-10 15:53:15', '0000-00-00 00:00:00', 'Welcome to !companyName. Here are your login details.     Email: !clientEmail  Password: xxxxxxxxx'),
(10, 'Deposit Failed', '', 'There is an error with your deposit at !companyName', 0x[encoded data, 8218 characters], 1, '2021-02-10 15:53:30', '0000-00-00 00:00:00', '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.'),
(11, 'Earnings Email', '', 'Your have earned !amount from !companyName', 0x[encoded data, 6796 characters], 1, '2021-02-10 15:53:46', '0000-00-00 00:00:00', 'You have earned !amount from !companyName with reference number !ref. Please check your account.'),
(12, 'Test Email', '', '!companyName Test Email', 0x[encoded data, 6714 characters], 1, '2021-02-10 15:54:03', '0000-00-00 00:00:00', 'This is a test SMS');
INSERT INTO `tbl_email_templates` (`id`, `type`, `title`, `mail_subject`, `mail_body`, `modifiedBy`, `modifiedDtm`, `createdDtm`, `sms_body`) VALUES
(13, 'Withdrawal Rejected', '', 'Your withdrawal request has been rejected', 0x[encoded data, 6784 characters], 1, '2021-02-10 15:54:18', '2020-07-01 16:20:48', 'Your request for withdrawing !withdrawalAmount has been rejected. Please contact support for further information'),
(14, 'Deposit Notification', '', 'You have a new deposit to approve.', 0x[encoded data, 6776 characters], 1, '2021-02-10 15:54:38', '2020-07-01 16:20:48', 'You have a new deposit to approve'),
(15, 'Email Verification', '', 'Please verify your email', 0x[encoded data, 6742 characters], 1, '2022-01-12 12:02:01', '2021-08-26 09:44:55', 'The verification url is !verification_url');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_faqs`
--

CREATE TABLE `tbl_faqs` (
  `id` int NOT NULL,
  `question` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `answer` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `isActive` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_faqs`
--

INSERT INTO `tbl_faqs` (`id`, `question`, `answer`, `isActive`) VALUES
(3, 'Where are you incorporated?', 'Ducimus eum culpa voluptates dolorem dolorum et sit nisi, mollitia animi porro fuga sequi, molestias repellat excepturi nobis eum culpa voluptates dolorem dolorum et.Lorem ipsum dolor sit amet, consectetur adipisicing elit.', 0),
(5, 'Do you have a referral program', 'Ducimus eum culpa voluptates dolorem dolorum et sit nisi, mollitia animi porro fuga sequi, molestias repellat excepturi nobis eum culpa voluptates dolorem dolorum et.Lorem ipsum dolor sit amet, consectetur adipisicing elit.', 0);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_languages`
--

CREATE TABLE `tbl_languages` (
  `id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `code` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `logo` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `createdDtm` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_languages`
--

INSERT INTO `tbl_languages` (`id`, `name`, `code`, `logo`) VALUES
(1, 'English', 'EN', 'gb-eng.png'),
(2, 'Russian', 'RU', 'russia.png'),
(3, 'Português', 'PT', 'portuguese.png'),
(4, 'Español', 'ES', 'spain.png'),
(5, 'German', 'GE', 'germany.png');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_lang_modules`
--

CREATE TABLE `tbl_lang_modules` (
  `id` int NOT NULL,
  `code` varchar(255) NOT NULL,
  `lang_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_lang_modules`
--

INSERT INTO `tbl_lang_modules` (`id`, `code`, `lang_name`) VALUES
(1, 'common', 'common terms'),
(2, 'registration', 'registration terms'),
(3, 'login', 'login terms'),
(4, 'dashboard', 'dashboard terms'),
(5, 'transactions', 'transactions terms'),
(6, 'payment_methods', 'payments terms'),
(7, 'users', 'users terms'),
(8, 'plans', 'plans terms'),
(9, 'plugins', 'plugins terms'),
(10, 'email_templates', 'email templates terms'),
(11, 'settings', 'settings terms'),
(12, 'languages', 'language settings terms'),
(13, 'validation', 'validation terms'),
(14, 'tickets', 'tickets terms'),
(15, 'web_control', 'web control terms'),
(16, 'kyc', 'KYC terms');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_last_login`
--

CREATE TABLE `tbl_last_login` (
  `id` bigint NOT NULL,
  `userId` bigint NOT NULL,
  `sessionData` varchar(2048) NOT NULL,
  `machineIp` varchar(1024) NOT NULL,
  `userAgent` varchar(128) NOT NULL,
  `agentString` varchar(1024) NOT NULL,
  `platform` varchar(128) NOT NULL,
  `createdDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_last_login`
--

INSERT INTO `tbl_last_login` (`id`, `userId`, `sessionData`, `machineIp`, `userAgent`, `agentString`, `platform`, `createdDtm`) VALUES
(1, 1, '{\"userId\":\"1\",\"role\":\"1\",\"roleText\":\"1\",\"firstName\":\"Administrator\",\"lastName\":\"Proinvest\",\"ppic\":\"\",\"lastLogin\":\"2022-02-21 09:00:00\",\"isLoggedIn\":true}', '::1', 'Chrome 98.0.4758.102', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.102 Safari/537.36', 'Mac OS X', '2022-02-21 12:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_payeer`
--

CREATE TABLE `tbl_payeer` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `planId` int NOT NULL,
  `order_id` varchar(255) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0',
  `modifiedDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_payment_methods`
--

CREATE TABLE `tbl_payment_methods` (
  `id` int NOT NULL,
  `name` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `logo` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `ref` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `API` int DEFAULT NULL,
  `bank_name` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `account_name` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `account_number` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `swift_code` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `variableComm` decimal(10,2) DEFAULT NULL,
  `fixedComm` decimal(10,2) DEFAULT NULL,
  `transFee` decimal(10,2) DEFAULT NULL,
  `depo_variable_comm` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `depo_fixed_comm` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `withdr_variable_comm` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `withdr_fixed_comm` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `iswithdrawable` int NOT NULL DEFAULT '0',
  `note` varchar(1024) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `status` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_payment_methods`
--

INSERT INTO `tbl_payment_methods` (`id`, `name`, `logo`, `type`, `ref`, `API`, `bank_name`, `account_name`, `account_number`, `swift_code`, `variableComm`, `fixedComm`, `transFee`, `depo_variable_comm`, `depo_fixed_comm`, `withdr_variable_comm`, `withdr_fixed_comm`, `iswithdrawable`, `note`, `status`) VALUES
(2, 'Stripe', 'stripe.jpg', 'auto', 'ST', 1, '', '', '', '', '0.00', '0.00', '0.00', '0', '0', '0', '0', 0, '', 0),
(3, 'Bitcoin', 'bitcoin.png', 'manual', 'BTC', 4, '', '', '', '', '0.00', '0.00', '0.00', '0', '0', '0', '0', 0, NULL, 0),
(4, 'Ethereum', 'ethereum.jpg', 'auto', 'ETH', 4, '', '', '', '', '0.00', '0.00', '0.00', '0', '0', '0', '0', 0, '', 0),
(5, 'LiteCoin', 'litecoin.png', 'auto', 'LTC', 4, '', '', '', '', '0.00', '0.00', '0.00', '0', '0', '0', '0', 0, '', 0),
(7, 'Dash', 'dash.png', 'auto', 'DASH', 4, '', '', '', '', '0.00', '0.00', '0.00', '0', '0', '0', '0', 0, '', 0),
(8, 'Ripple', 'ripple.png', 'auto', 'XRP', 4, '', '', '', '', '0.00', '0.00', '0.00', '0', '0', '0', '0', 0, '', 0),
(10, 'Bitcoin Cash', 'bitcoincash.png', 'auto', 'BCH', 4, '', '', '', '', '0.00', '0.00', '0.00', '0', '0', '0', '0', 0, '', 0),
(11, 'Bank Transfer', 'bank-transfer.png', 'bank', 'BT', 0, NULL, NULL, NULL, NULL, '0.00', '0.00', '0.00', '0', '0', '0', '0', 0, '', 0),
(12, 'Paypal', 'paypal.png', 'auto', 'PP', 2, '', '', '', '', '0.00', '0.00', '0.00', '0', '0', '0', '0', 0, '', 0),
(13, 'Litecoin Testnet', 'ltct.png', 'auto', 'LTCT', 4, '', '', '', '', '0.00', '0.00', '0.00', '0', '0', '0', '0', 0, '', 0),
(14, 'Payeer', 'payeer.png', 'auto', 'PY', 9, '', '', '', '', '0.00', '0.00', '0.00', '0', '0', '0', '0', 0, '', 0),
(15, 'Paystack', 'paystack.png', 'auto', 'PSK', 10, '', '', '', '', '0.00', '0.00', '0.00', '0', '0', '0', '0', 0, '', 0),
(35, 'USDT', 'USDT.png', 'auto', 'USDT', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '0', 0, NULL, 0),
(36, 'User Wallet', 'wallet.png', 'wallet', 'WLT', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '0', 0, NULL, 0),
(38, 'Coinbase', 'coinbase.png', 'auto', 'CB', 54, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '0', 0, NULL, 0),
(39, 'Perfect Money', 'Perfect_Money.png', 'auto', 'PM', 55, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '0', 0, NULL, 0);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_paypal`
--

CREATE TABLE `tbl_paypal` (
  `id` int NOT NULL,
  `userid` int NOT NULL,
  `invoice` varchar(255) NOT NULL,
  `plan` int 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;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_paystack`
--

CREATE TABLE `tbl_paystack` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `ref` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `plan` int DEFAULT NULL,
  `status` int DEFAULT NULL,
  `createdDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_perfect_money`
--

CREATE TABLE `tbl_perfect_money` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `planId` int NOT NULL,
  `payee_account` varchar(255) DEFAULT NULL,
  `payer_account` varchar(255) DEFAULT NULL,
  `payee_name` varchar(255) DEFAULT NULL,
  `payment_id` varchar(255) DEFAULT NULL,
  `payment_batch_number` varchar(255) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `status` int DEFAULT '0',
  `modifiedDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_periods`
--

CREATE TABLE `tbl_periods` (
  `id` int NOT NULL,
  `periodName` varchar(128) NOT NULL,
  `maturity_desc` varchar(128) NOT NULL,
  `period_hrs` int NOT NULL,
  `createdDtm` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_periods`
--

INSERT INTO `tbl_periods` (`id`, `periodName`, `maturity_desc`, `period_hrs`, `createdDtm`) VALUES
(1, 'Hourly', '1 hour', 1, '2019-12-01 00:00:00'),
(2, 'Daily', '1 day', 24, '2019-12-01 00:00:00'),
(3, 'Weekly', '1 week', 168, '2019-12-01 00:00:00'),
(4, 'Fortnightly', '2 Weeks', 336, '2019-12-01 00:00:00'),
(5, 'Monthly', '1 month', 720, '2019-12-01 00:00:00'),
(6, 'Quarterly', '3 months', 2160, '2019-12-01 00:00:00'),
(7, 'Semi-annually', '6 months', 4320, '2019-12-01 00:00:00'),
(8, 'Annually', '1 year', 8640, '2019-12-01 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_permissions`
--

CREATE TABLE `tbl_permissions` (
  `module_id` varchar(128) NOT NULL,
  `person_id` int NOT NULL,
  `action_id` varchar(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_plans`
--

CREATE TABLE `tbl_plans` (
  `id` int NOT NULL,
  `name` varchar(128) NOT NULL,
  `minInvestment` decimal(13,2) NOT NULL,
  `maxInvestment` decimal(13,2) NOT NULL,
  `intAfterMaturity` tinyint(1) DEFAULT '0',
  `principalReturn` tinyint(1) NOT NULL DEFAULT '0',
  `clientDisplay` int NOT NULL,
  `profit` decimal(13,2) NOT NULL,
  `interest_interval` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `investment_period` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `businessDays` int NOT NULL DEFAULT '0',
  `createdBy` int NOT NULL,
  `createdDtm` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_referrals`
--

CREATE TABLE `tbl_referrals` (
  `id` int NOT NULL,
  `referrerId` int NOT NULL,
  `referredId` int NOT NULL,
  `createdDtm` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_reset_password`
--

CREATE TABLE `tbl_reset_password` (
  `id` bigint NOT NULL,
  `email` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `activation_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `agent` varchar(512) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `client_ip` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `isDeleted` tinyint NOT NULL DEFAULT '0',
  `createdBy` bigint NOT NULL DEFAULT '1',
  `createdDtm` datetime DEFAULT NULL,
  `updatedBy` bigint DEFAULT NULL,
  `updatedDtm` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_roles`
--

CREATE TABLE `tbl_roles` (
  `roleId` tinyint NOT NULL COMMENT 'role id',
  `role` varchar(50) NOT NULL COMMENT 'role text'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_roles`
--

INSERT INTO `tbl_roles` (`roleId`, `role`) VALUES
(1, 'System Administrator'),
(2, 'Manager'),
(3, 'Client');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_settings`
--

CREATE TABLE `tbl_settings` (
  `type` varchar(128) NOT NULL,
  `value` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `updatedDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_settings`
--

INSERT INTO `tbl_settings` (`type`, `value`, `updatedDtm`) VALUES
('address', '2295  Oak Street, Old Forge, New York ', '0000-00-00 00:00:00'),
('backend_template', '1', '2021-07-01 17:55:11'),
('chatWidget', NULL, '0000-00-00 00:00:00'),
('chat_plugin', 'Tawk', '2020-04-01 13:10:00'),
('chat_plugin_active', '0', '2020-04-01 13:12:21'),
('cron_url', 'cronjobs', '0000-00-00 00:00:00'),
('currency', 'USD', '0000-00-00 00:00:00'),
('currency_exchange_rate', NULL, '0000-00-00 00:00:00'),
('currency_position', 'before', '0000-00-00 00:00:00'),
('darkLogo', 'logo.png', '0000-00-00 00:00:00'),
('default_language', 'English', '2021-02-25 09:18:54'),
('description', 'Proinvest is an investment company that aggregates funds for investment in bitcoin and forex trading.                                                                                                                                                                                                                                                                                                                                                                                                               ', '0000-00-00 00:00:00'),
('disableRefPayouts', '0', '0000-00-00 00:00:00'),
('disable_frontend', '0', '2020-11-16 18:09:04'),
('disable_index', '0', '2020-11-16 18:07:08'),
('email', 'info@proinvest.co', '0000-00-00 00:00:00'),
('email_active', '1', '0000-00-00 00:00:00'),
('envato_purchase_code', NULL, '2021-01-04 12:17:23'),
('favicon', 'favicon1.png', '0000-00-00 00:00:00'),
('frontend_template', '2', '2020-06-01 15:17:46'),
('google_recaptcha', '0', '2020-04-01 13:11:47'),
('keywords', 'proinvest, bitcoin trading, forex, investment, trading                                                                                                                                                                                                                                                                                                                                                                                                                                                              ', '0000-00-00 00:00:00'),
('kyc_allow_deposits', '0', '2020-11-09 09:09:51'),
('kyc_allow_withdrawals', '0', '2020-11-09 09:10:05'),
('kyc_status', '1', '2020-11-09 09:09:51'),
('kyc_verify_address', '0', '2020-11-09 09:10:45'),
('kyc_verify_id', '0', '2020-11-09 09:10:45'),
('min_withdrawal', '1', '2020-04-01 13:10:00'),
('name', 'ProInvest Fund', '0000-00-00 00:00:00'),
('phone1', '315-369-597', '0000-00-00 00:00:00'),
('phone2', '315-369-597', '0000-00-00 00:00:00'),
('prompt_payment_account', '0', '2020-11-09 09:09:51'),
('recaptcha_version', 'v3', '2020-06-01 15:17:46'),
('refactive', '0', '2020-11-07 09:02:14'),
('reffrequency', '0', '2020-11-07 09:01:51'),
('refInterest', '10', '0000-00-00 00:00:00'),
('refType', 'simple', '0000-00-00 00:00:00'),
('require_phone_for_signup', '1', '2020-11-09 09:09:51'),
('signup_email_verification', '1', '2020-11-09 09:09:51'),
('sms_active', '0', '0000-00-00 00:00:00'),
('sms_phone', NULL, '0000-00-00 00:00:00'),
('SMTPCrypto', NULL, '0000-00-00 00:00:00'),
('SMTPHost', NULL, '0000-00-00 00:00:00'),
('SMTPPass', NULL, '0000-00-00 00:00:00'),
('SMTPPort', NULL, '0000-00-00 00:00:00'),
('SMTPProtocol', NULL, '0000-00-00 00:00:00'),
('SMTPUser', NULL, '0000-00-00 00:00:00'),
('timezone', 'UTC', '2021-02-09 11:50:57'),
('title', 'Proinvest PLC Fund                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  ', '0000-00-00 00:00:00'),
('two_factor_auth', 'Google Authenticator', '2020-04-01 13:10:00'),
('two_factor_auth_active', '0', '2020-04-01 13:12:48'),
('url', '', '0000-00-00 00:00:00'),
('valid', '0', '2021-01-04 12:17:23'),
('version', '2102101513', '2021-02-09 11:50:57'),
('weekendPayouts', '', '0000-00-00 00:00:00'),
('whiteLogo', 'logo-white.png', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_templates`
--

CREATE TABLE `tbl_templates` (
  `id` int NOT NULL,
  `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `img` varchar(255) NOT NULL,
  `isActive` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_templates`
--

INSERT INTO `tbl_templates` (`id`, `name`, `img`, `isActive`) VALUES
(1, 'Classic', 'classic_template.png', 1),
(2, 'Modern', 'modern_template.png', 0);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_tickets`
--

CREATE TABLE `tbl_tickets` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `subject` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `message` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `categoryId` int NOT NULL,
  `priority` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `assignedTo` int NOT NULL,
  `resolved` int NOT NULL DEFAULT '0',
  `clientReply` int NOT NULL DEFAULT '0',
  `supportReply` int NOT NULL DEFAULT '0',
  `createdDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_ticket_categories`
--

CREATE TABLE `tbl_ticket_categories` (
  `categoryId` int NOT NULL,
  `categoryName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_ticket_categories`
--

INSERT INTO `tbl_ticket_categories` (`categoryId`, `categoryName`) VALUES
(1, 'Deposit'),
(2, 'Withdrawal'),
(3, 'Earning'),
(4, 'Referral'),
(5, 'Account'),
(6, 'Other');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_ticket_replies`
--

CREATE TABLE `tbl_ticket_replies` (
  `replyId` int NOT NULL,
  `ticketId` int NOT NULL,
  `message` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `repliedById` int NOT NULL,
  `seen` int NOT NULL DEFAULT '0',
  `createdDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_verification`
--

CREATE TABLE `tbl_verification` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `id_type` varchar(255) DEFAULT NULL,
  `identification_document` varchar(255) DEFAULT NULL,
  `rejected_identification_document` varchar(255) DEFAULT NULL,
  `rejection_reason_id` varchar(255) DEFAULT NULL,
  `status1` int NOT NULL DEFAULT '0',
  `address_type` varchar(255) NOT NULL,
  `address_document` varchar(255) DEFAULT NULL,
  `rejected_address_document` varchar(255) DEFAULT NULL,
  `rejection_reason_address` varchar(255) DEFAULT NULL,
  `status2` int NOT NULL DEFAULT '0',
  `overall_status` int NOT NULL DEFAULT '0',
  `assignedTo` int DEFAULT NULL,
  `createdDtm` datetime NOT NULL,
  `updatedDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_withdrawals`
--

CREATE TABLE `tbl_withdrawals` (
  `id` int NOT NULL,
  `txnCode` varchar(1024) NOT NULL,
  `userId` int NOT NULL,
  `transaction_fee` decimal(13,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(13,2) NOT NULL,
  `amount_less_transaction_fee` decimal(13,2) NOT NULL,
  `withdrawal_method` varchar(255) DEFAULT NULL,
  `withdrawal_account` varchar(255) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `account_name` varchar(255) DEFAULT NULL,
  `account_number` varchar(255) DEFAULT NULL,
  `swift_code` varchar(255) DEFAULT NULL,
  `status` int NOT NULL,
  `reason` varchar(1024) DEFAULT NULL,
  `createdBy` int NOT NULL,
  `createdDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ci_sessions`
--
ALTER TABLE `ci_sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `last_activity_idx` (`timestamp`);

--
-- Indexes for table `tbl_coinbase`
--
ALTER TABLE `tbl_coinbase`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_coinpayments`
--
ALTER TABLE `tbl_coinpayments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_content`
--
ALTER TABLE `tbl_content`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_deposits`
--
ALTER TABLE `tbl_deposits`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_earnings`
--
ALTER TABLE `tbl_earnings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_email_templates`
--
ALTER TABLE `tbl_email_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_faqs`
--
ALTER TABLE `tbl_faqs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_languages`
--
ALTER TABLE `tbl_languages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_lang_modules`
--
ALTER TABLE `tbl_lang_modules`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_last_login`
--
ALTER TABLE `tbl_last_login`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_payeer`
--
ALTER TABLE `tbl_payeer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_payment_methods`
--
ALTER TABLE `tbl_payment_methods`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_paypal`
--
ALTER TABLE `tbl_paypal`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_paystack`
--
ALTER TABLE `tbl_paystack`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_perfect_money`
--
ALTER TABLE `tbl_perfect_money`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_periods`
--
ALTER TABLE `tbl_periods`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_permissions`
--
ALTER TABLE `tbl_permissions`
  ADD PRIMARY KEY (`module_id`,`person_id`,`action_id`);

--
-- Indexes for table `tbl_plans`
--
ALTER TABLE `tbl_plans`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_referrals`
--
ALTER TABLE `tbl_referrals`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_reset_password`
--
ALTER TABLE `tbl_reset_password`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_roles`
--
ALTER TABLE `tbl_roles`
  ADD PRIMARY KEY (`roleId`);

--
-- Indexes for table `tbl_settings`
--
ALTER TABLE `tbl_settings`
  ADD PRIMARY KEY (`type`);

--
-- Indexes for table `tbl_templates`
--
ALTER TABLE `tbl_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_tickets`
--
ALTER TABLE `tbl_tickets`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_ticket_categories`
--
ALTER TABLE `tbl_ticket_categories`
  ADD PRIMARY KEY (`categoryId`);

--
-- Indexes for table `tbl_ticket_replies`
--
ALTER TABLE `tbl_ticket_replies`
  ADD PRIMARY KEY (`replyId`);

--
-- Indexes for table `tbl_verification`
--
ALTER TABLE `tbl_verification`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_withdrawals`
--
ALTER TABLE `tbl_withdrawals`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for table `tbl_coinbase`
--
ALTER TABLE `tbl_coinbase`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_coinpayments`
--
ALTER TABLE `tbl_coinpayments`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_content`
--
ALTER TABLE `tbl_content`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `tbl_deposits`
--
ALTER TABLE `tbl_deposits`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_earnings`
--
ALTER TABLE `tbl_earnings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_email_templates`
--
ALTER TABLE `tbl_email_templates`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `tbl_faqs`
--
ALTER TABLE `tbl_faqs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tbl_languages`
--
ALTER TABLE `tbl_languages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `tbl_lang_modules`
--
ALTER TABLE `tbl_lang_modules`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `tbl_last_login`
--
ALTER TABLE `tbl_last_login`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_payeer`
--
ALTER TABLE `tbl_payeer`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_payment_methods`
--
ALTER TABLE `tbl_payment_methods`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT for table `tbl_paypal`
--
ALTER TABLE `tbl_paypal`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_paystack`
--
ALTER TABLE `tbl_paystack`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_perfect_money`
--
ALTER TABLE `tbl_perfect_money`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_periods`
--
ALTER TABLE `tbl_periods`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tbl_plans`
--
ALTER TABLE `tbl_plans`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_referrals`
--
ALTER TABLE `tbl_referrals`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_reset_password`
--
ALTER TABLE `tbl_reset_password`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_templates`
--
ALTER TABLE `tbl_templates`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tbl_tickets`
--
ALTER TABLE `tbl_tickets`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_ticket_categories`
--
ALTER TABLE `tbl_ticket_categories`
  MODIFY `categoryId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `tbl_ticket_replies`
--
ALTER TABLE `tbl_ticket_replies`
  MODIFY `replyId` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_verification`
--
ALTER TABLE `tbl_verification`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_withdrawals`
--
ALTER TABLE `tbl_withdrawals`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;
COMMIT;

