--
-- ADD COLUMNS for table `tbl_addons_api`
--

ALTER TABLE tbl_addons_api
ADD litecoin_API varchar(255) NULL,
ADD bitcoin_API varchar(255) NULL,
ADD dogecoin_API varchar(255) NULL,
ADD litecoin_testnet_API varchar(255) NULL,
ADD bitcoin_testnet_API varchar(255) NULL,
ADD dogecoin_testnet_API varchar(255) NULL,
ADD merchantName varchar(255) NULL,
ADD type varchar(255) NULL,
ADD purchased int NOT NULL DEFAULT '0';

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

--
-- ADD COLUMNS for table `tbl_deposits`
--

ALTER TABLE tbl_deposits
ADD img varchar(255) NULL,
ADD deposit_account varchar(255) NULL;

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

--
-- ADD COLUMNS for table `tbl_payment_methods`
--

ALTER TABLE tbl_payment_methods
ADD type varchar(255) NULL,
ADD variableComm decimal(10,2) NULL,
ADD fixedComm decimal(10,2) NULL,
ADD transFee decimal(10,2) NULL,
ADD iswithdrawable int NOT NULL DEFAULT '0',
ADD note varchar(1024) NULL;

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

--
-- ADD COLUMNS for table `tbl_users`
--

ALTER TABLE tbl_users
ADD two_factor_auth varchar(255) NULL,
ADD lang_id int NOT NULL DEFAULT '1';

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

--
-- ADD COLUMNS for table `tbl_withdrawals`
--

ALTER TABLE tbl_withdrawals
ADD withdrawal_method varchar(255) NULL,
ADD withdrawal_account varchar(255) NULL,
ADD bank_name varchar(255) NULL,
ADD account_name varchar(255) NULL,
ADD account_number varchar(255) NULL,
ADD swift_code varchar(255) NULL,
ADD reason varchar(1024) NULL;

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

--
-- Updating type data for table `tbl_payment_methods`
--

UPDATE tbl_payment_methods
SET type = 'auto', variableComm = '0.00', fixedComm = '0.00', transFee = '0.00'
WHERE name = 'Stripe';

UPDATE tbl_payment_methods
SET type = 'auto', variableComm = '0.00', fixedComm = '0.00', transFee = '0.00'
WHERE name = 'Bitcoin';

UPDATE tbl_payment_methods
SET type = 'auto', variableComm = '0.00', fixedComm = '0.00', transFee = '0.00'
WHERE name = 'Ethereum'; 

UPDATE tbl_payment_methods
SET type = 'auto', variableComm = '0.00', fixedComm = '0.00', transFee = '0.00'
WHERE name = 'Litecoin';

UPDATE tbl_payment_methods
SET type = 'auto', variableComm = '0.00', fixedComm = '0.00', transFee = '0.00'
WHERE name = 'Dash';

UPDATE tbl_payment_methods
SET type = 'auto', variableComm = '0.00', fixedComm = '0.00', transFee = '0.00'
WHERE name = 'Ripple';

UPDATE tbl_payment_methods
SET type = 'auto', variableComm = '0.00', fixedComm = '0.00', transFee = '0.00'
WHERE name = 'Bitcoin Cash';

UPDATE tbl_payment_methods
SET type = 'bank', variableComm = '0.00', fixedComm = '0.00', transFee = '0.00'
WHERE name = 'Bank Transfer';

UPDATE tbl_payment_methods
SET type = 'auto', variableComm = '0.00', fixedComm = '0.00', transFee = '0.00'
WHERE name = 'Paypal';

UPDATE tbl_payment_methods
SET type = 'auto', variableComm = '0.00', fixedComm = '0.00', transFee = '0.00'
WHERE name = 'Litecoin Testnet';

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

--
-- Dumping data for table `tbl_addons_api`
--

INSERT INTO `tbl_addons_api` (`id`, `name`, `logo`, `public_key`, `secret_key`, `IPN_secret`, `litecoin_API`, `bitcoin_API`, `dogecoin_API`, `litecoin_testnet_API`, `bitcoin_testnet_API`, `dogecoin_testnet_API`, `merchantName`, `merchantID`, `base_url`, `env`, `currency`, `status`, `type`, `purchased`, `createdDtm`) VALUES
(5, 'Google Authenticator', 'googleauth.png', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', 0, 'authenticator', 1, '0000-00-00 00:00:00'),
(6, 'Google Recaptcha', 'recaptcha.png', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', 0, 'recaptcha', 1, '0000-00-00 00:00:00'),
(7, 'Authy', 'authy.png', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', 0, 'authenticator', 1, '0000-00-00 00:00:00'),
(8, 'Tawk.To', 'tawky_big.png', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', 0, 'chat', 1, '0000-00-00 00:00:00'),
(9, 'Payeer', 'payeer.png', '', '', '', '', '', '', '', '', '', NULL, '', '', '', 'USD', 0, 'payment', 1, '2019-11-22 00:00:00'),
(10, 'Paystack', 'paystack.png', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', 0, 'payment', 1, '0000-00-00 00:00:00');

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

--
-- 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, 6236 characters]),
(2, 1, 'terms', 0x[encoded data, 9582 characters]),
(3, 1, 'footer', 0x4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2056656c697420647563696d757320766f6c757074617469627573206e6571756520696c6c6f20696420726570656c6c617420717569737175616d3f20417574656d20657870656469746120656172756d2071756165206c61626f72756d20697073756d2061642e),
(4, 1, 'header_sub_title', 0x0a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020204f75722061696d20697320746f20756e6c6f636b206f757220636c69656e7473272066696e616e6369616c2066726565646f6d),
(5, 1, 'header_title', 0x0a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a20202020202020202020202020202020202020202020202020202020202020200a2020202020202020202020202020202020202020202020202020202020202020486967682052657475726e7320576974682043616c63756c61746564205269736b20202020202020202020),
(6, 1, 'header_description', 0x0a202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020200a2020202020202020202020202020202020202020202020202020202050726f496e7665737420697320696e74656e64656420666f722070656f706c652077696c6c696e6720746f2061636869657665207765616c746820616e642066696e616e6369616c2066726565646f6d2062757420756e61626c6520746f20646f20736f20626563617573652074686579277265206e6f742066696e616e6369616c20657870657274732e),
(7, 1, 'card_1_subtitle', 0x47657420746f206b6e6f77207573),
(8, 1, 'card_1_title', 0x41626f75742050726f496e766573742046756e64),
(9, 1, 'card_1_content', 0x3c7370616e207873733d2272656d6f766564223e4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2053757363697069742065756d20696c6c756d2074656d706f72613f20447563696d75732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d20657420736974206e6973692c206d6f6c6c6974696120616e696d6920706f72726f20667567612073657175692c206d6f6c65737469617320726570656c6c617420657863657074757269206e6f6269732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d2065742e4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2053757363697069742065756d20696c6c756d2074656d706f72613f20447563696d75732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d20657420736974206e6973692c206d6f6c6c6974696120616e696d6920706f72726f20667567612073657175692c206d6f6c65737469617320726570656c6c617420657863657074757269206e6f6269732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d2065742e3c2f7370616e3e),
(10, 1, 'card_2_subtitle', 0x496e766573746d656e7420506c616e73),
(11, 1, 'card_2_title', 0x0a202020202020202020202020202020200a202020202020202020202020202020200a202020202020202020202020202020200a202020202020202020202020202020200a202020202020202020202020202020200a202020202020202020202020202020200a202020202020202020202020202020200a202020202020202020202020202020200a202020202020202020202020202020200a202020202020202020202020202020204f757220696e766573746d656e7420506c616e732020202020202020202020202020202020202020202020202020202020202020),
(12, 1, 'card_3_subtitle', 0x5369676e20757020616e64206265636f6d6520616e20616666696c6961746520746f646179),
(13, 1, 'card_3_title', 0x416666696c696174652050726f6772616d20466f7220596f75),
(14, 1, 'card_3_content', 0x4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2053757363697069742065756d20696c6c756d2074656d706f72613f20447563696d75732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d20657420736974206e6973692c206d6f6c6c6974696120616e696d6920706f72726f20667567612073657175692c206d6f6c65737469617320726570656c6c617420657863657074757269206e6f6269732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d2065742e4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e2053757363697069742065756d20696c6c756d2074656d706f72613f20447563696d75732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d20657420736974206e6973692c206d6f6c6c6974696120616e696d6920706f72726f20667567612073657175692c206d6f6c65737469617320726570656c6c617420657863657074757269206e6f6269732065756d2063756c706120766f6c7570746174657320646f6c6f72656d20646f6c6f72756d2065742e),
(15, 1, 'card_4_subtitle', 0x5265706561746564205175657374696f6e73),
(16, 1, 'card_4_title', 0x4672657175656e746c792041736b6564205175657374696f6e73),
(17, 1, 'card_4_content', 0x4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e73656374657475722061646970697363696e6720656c69742e20536564207175697320616363756d73616e206e6973692055742075742066656c697320636f6e677565206e69736c2068656e64726572697420636f6d6d6f646f2e),
(18, 1, 'card_5_subtitle', 0x436f6e74616374205573),
(19, 1, 'card_5_title', 0x537065616b2057697468205573),
(20, 1, 'card_5_content', 0x4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e73656374657475722061646970697363696e6720656c69742e20536564207175697320616363756d73616e206e6973692055742075742066656c697320636f6e677565206e69736c2068656e64726572697420636f6d6d6f646f2e20202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020);

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

--
-- 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(1024) 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
(1, 'Where are you incorporated?', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore omnis quaerat\r\n                                        nostrum, pariatur ipsam sunt accusamus enim necessitatibus est fugiat, assumenda\r\n                                        dolorem, deleniti corrupti cupiditate ipsum, dolorum voluptatum esse error?', 0),
(2, 'Can I join ProInvest?', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolore omnis quaerat\r\n                                        nostrum, pariatur ipsam sunt accusamus enim necessitatibus est fugiat, assumenda\r\n                                        dolorem, deleniti corrupti cupiditate ipsum, dolorum voluptatum esse error?', 0);

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

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

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

--
-- 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');

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

--
-- 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');

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

--
-- 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;

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

--
-- 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`, `iswithdrawable`, `note`, `status`) VALUES
(14, 'Payeer', 'payeer.png', 'auto', 'PY', 9, '', '', '', '', '0.00', '0.00', '0.00', 0, '', 0),
(15, 'Paystack', 'paystack.png', 'auto', 'PSK', 10, '', '', '', '', '0.00', '0.00', '0.00', 0, '', 0);

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

--
-- 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;

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

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

INSERT INTO `tbl_settings` (`type`, `value`, `updatedDtm`) VALUES
('chat_plugin', 'Tawk', '2020-04-01 13:10:00'),
('chat_plugin_active', '0', '2020-04-01 13:12:21'),
('google_recaptcha', '0', '2020-04-01 13:11:47'),
('min_withdrawal', '1', '2020-04-01 13:10:00'),
('recaptcha_version', '', '2020-06-01 15:17:46'), 
('template', '1', '2020-06-01 15:17:46'),
('two_factor_auth', '', '2020-04-01 13:10:00'),
('two_factor_auth_active', '0', '2020-04-01 13:12:48');

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

--
-- 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);

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

--
-- 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_translations`
--

CREATE TABLE `tbl_translations` (
  `id` int NOT NULL,
  `lang_id` int NOT NULL,
  `module` varchar(255) NOT NULL,
  `key` varchar(255) NOT NULL,
  `translation` varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `tbl_translations` (`id`, `lang_id`, `module`, `key`, `translation`) VALUES
(1152, 1, '15', 'terms_and_conditions', 'Terms & Conditions'),
(1153, 2, '15', 'terms_and_conditions', 'Условия использования'),
(1154, 1, '15', 'faqs', 'FAQs'),
(1155, 2, '15', 'faqs', 'FAQs'),
(1156, 1, '15', 'edit_template', 'Edit Template'),
(1157, 2, '15', 'edit_template', 'Редактировать шаблон'),
(1158, 1, '6', 'add_payment_method', 'Add payment method'),
(1159, 2, '6', 'add_payment_method', 'Добавить способ оплаты'),
(1160, 1, '6', 'payment_type', 'Payment type'),
(1161, 2, '6', 'payment_type', 'Способ оплаты'),
(1162, 1, '6', 'method_name', 'Method name'),
(1163, 2, '6', 'method_name', 'Название метода'),
(1164, 1, '6', 'use_this_method_for_client_withdrawals', 'Use this method for client withdrawals'),
(1165, 2, '6', 'use_this_method_for_client_withdrawals', 'Используйте этот метод для вывода клиентов'),
(1166, 1, '6', 'clients_will_be_able_to_see_this_method_as_a_withdrawal_method', 'Clients will be able to see this method as a withdrawal method'),
(1167, 2, '6', 'clients_will_be_able_to_see_this_method_as_a_withdrawal_method', 'Клиенты смогут увидеть этот метод в качестве метода вывода'),
(1168, 1, '6', 'payment_API', 'Payment API'),
(1169, 2, '6', 'payment_API', 'API оплаты'),
(1170, 1, '6', 'code', 'Code'),
(1171, 2, '6', 'code', 'Код'),
(1172, 1, '6', 'note_to_investor', 'Note to investor'),
(1173, 2, '6', 'note_to_investor', 'Примечание для инвестора'),
(1174, 1, '6', 'logo', 'logo'),
(1175, 2, '6', 'logo', 'логотип'),
(1176, 1, '6', 'bank', 'Bank'),
(1177, 2, '6', 'bank', 'банка'),
(1178, 1, '6', 'manual', 'Manual'),
(1179, 2, '6', 'manual', 'руководство'),
(1180, 1, '6', 'automated', 'Automated'),
(1181, 2, '6', 'automated', 'автоматизированный'),
(1182, 1, '6', 'change_logo', 'Change logo'),
(1183, 2, '6', 'change_logo', 'Изменить логотип'),
(1184, 1, '6', 'allow_withdrawals', 'Allow withdrawals'),
(1185, 2, '6', 'allow_withdrawals', 'Разрешить снятие'),
(1186, 1, '6', 'web_control', 'Web control'),
(1187, 2, '6', 'web_control', 'Веб-контроль'),
(1188, 1, '5', 'completed_withdrawals', 'Completed withdrawals'),
(1189, 2, '5', 'completed_withdrawals', 'Завершенные снятия');

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

--
-- Indexes for table `tbl_content`
--
ALTER TABLE `tbl_content`
  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_payeer`
--
ALTER TABLE `tbl_payeer`
  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_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_translations`
--
ALTER TABLE `tbl_translations`
  ADD PRIMARY KEY (`id`);

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

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

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

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

--
-- AUTO_INCREMENT for table `tbl_payeer`
--
ALTER TABLE `tbl_payeer`
  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_templates`
--
ALTER TABLE `tbl_templates`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- 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_translations`
--
ALTER TABLE `tbl_translations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1190;
  


