

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `about` text DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(32) NOT NULL,
  `password_reset_token` varchar(20) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `last_logout` datetime DEFAULT NULL,
  `ip_address` varchar(20) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `is_admin` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


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

--
-- Table structure for table `advertisement`
--

CREATE TABLE `advertisement` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `page` int(11) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `script` text DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `serial_position` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `date` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `advertisement`
--

INSERT INTO `advertisement` (`id`, `name`, `page`, `image`, `script`, `url`, `serial_position`, `status`, `date`) VALUES
(1, 'coinmarket-top', 7, 'public/upload/advertisement/ff5a204fdd1722068e78222fd1d24a82.jpg', NULL, 'https://www.bdtask.com/', 1, 1, '2021-09-29 09:08:35'),
(2, 'coinmarket-bottom', 7, 'public/upload/advertisement/ff5a204fdd1722068e78222fd1d24a82.jpg', NULL, 'https://www.bdtask.com/', 2, 1, '2021-09-29 09:09:01'),
(3, 'exchange-top', 7, 'public/upload/advertisement/ff5a204fdd1722068e78222fd1d24a82.jpg', NULL, 'https://www.bdtask.com/', 1, 1, '2021-09-29 09:09:26'),
(4, 'exchange-bottom', 7, 'public/upload/advertisement/ff5a204fdd1722068e78222fd1d24a82.jpg', NULL, 'https://www.bdtask.com/', 2, 1, '2021-09-29 09:09:37'),
(5, 'news-sidebar-top', 7, 'public/upload/advertisement/dff78ee612b37fc12c9e7fa94839d855.jpg', NULL, 'https://www.bdtask.com/', 6, 1, '2019-01-14 18:56:21'),
(6, 'news-sidebar-bottom', 7, 'public/upload/advertisement/7fabc49dd69e0a0d6e111f3fcae0118a.jpg', NULL, 'https://www.bdtask.com/', 7, 1, '2019-01-14 18:59:50'),
(7, 'news-top', 7, 'public/upload/advertisement/430370437495d1a5eb9031a7505d2d13.png', NULL, 'https://www.bdtask.com/', 8, 1, '2019-01-14 19:04:08'),
(8, 'news-bottom', 7, 'public/upload/advertisement/544f538275dae3b46b917ab60f68c316.png', NULL, 'https://www.bdtask.com/', 9, 1, '2019-01-14 19:11:04'),
(9, 'news details-top', 7, 'public/upload/advertisement/ff5a204fdd1722068e78222fd1d24a82.jpg', NULL, 'https://www.bdtask.com/', 3, 1, '2021-09-29 09:10:10'),
(10, 'news details-bottom', 7, 'public/upload/advertisement/ff5a204fdd1722068e78222fd1d24a82.jpg', NULL, 'https://www.bdtask.com/', 4, 1, '2021-09-29 09:10:18'),
(11, 'news details-sidebar-top', 7, 'public/upload/advertisement/ff5a204fdd1722068e78222fd1d24a82.jpg', NULL, 'https://www.bdtask.com/', 1, 1, '2021-09-29 09:10:25'),
(12, 'news details-sidebar-bottom', 7, 'public/upload/advertisement/ff5a204fdd1722068e78222fd1d24a82.jpg', NULL, 'https://www.bdtask.com/', 2, 1, '2021-09-29 09:10:33'),
(13, 'Price-bottom', 7, 'public/upload/advertisement/ff5a204fdd1722068e78222fd1d24a82.jpg', NULL, 'https://www.bdtask.com/', 5, 1, '2021-09-29 09:10:40'),
(14, 'Price-top', 7, 'public/upload/advertisement/ff5a204fdd1722068e78222fd1d24a82.jpg', NULL, 'https://www.bdtask.com/', 3, 1, '2021-09-29 09:10:48'),
(15, 'Price-middle', 7, 'public/upload/advertisement/ff5a204fdd1722068e78222fd1d24a82.jpg', NULL, 'https://www.bdtask.com/', 4, 1, '2021-09-29 09:10:59'),
(16, 'Price-sidebar-top', 7, 'public/upload/advertisement/ff5a204fdd1722068e78222fd1d24a82.jpg', NULL, 'https://www.bdtask.com/', 1, 1, '2021-09-29 09:11:06'),
(17, 'Price-sidebar-bottom', 7, 'public/upload/advertisement/ff5a204fdd1722068e78222fd1d24a82.jpg', NULL, 'https://www.bdtask.com/', 2, 1, '2021-09-29 09:11:12');

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

--
-- Table structure for table `coinpayments_payments`
--

CREATE TABLE `coinpayments_payments` (
  `id` int(11) NOT NULL,
  `amount1` double NOT NULL,
  `amount2` double NOT NULL,
  `buyer_name` varchar(100) NOT NULL,
  `currency1` varchar(100) NOT NULL,
  `currency2` varchar(100) NOT NULL,
  `fee` double NOT NULL,
  `ipn_id` text NOT NULL,
  `ipn_mode` varchar(20) NOT NULL,
  `ipn_type` varchar(20) NOT NULL,
  `ipn_version` varchar(20) NOT NULL,
  `merchant` text NOT NULL,
  `received_amount` double NOT NULL,
  `received_confirms` varchar(100) NOT NULL,
  `status` varchar(20) NOT NULL,
  `status_text` text NOT NULL,
  `txn_id` text NOT NULL,
  `user_id` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `crypto_payments`
--

CREATE TABLE `crypto_payments` (
  `paymentID` int(11) UNSIGNED NOT NULL,
  `boxID` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `boxType` enum('paymentbox','captchabox') NOT NULL,
  `orderID` varchar(50) NOT NULL DEFAULT '',
  `userID` varchar(50) NOT NULL DEFAULT '',
  `countryID` varchar(3) NOT NULL DEFAULT '',
  `coinLabel` varchar(6) NOT NULL DEFAULT '',
  `amount` double(20,8) NOT NULL DEFAULT 0.00000000,
  `amountUSD` double(20,8) NOT NULL DEFAULT 0.00000000,
  `unrecognised` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `addr` varchar(34) NOT NULL DEFAULT '',
  `txID` char(64) NOT NULL DEFAULT '',
  `txDate` datetime DEFAULT NULL,
  `txConfirmed` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `txCheckDate` datetime DEFAULT NULL,
  `processed` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `processedDate` datetime DEFAULT NULL,
  `recordCreated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `dbt_admin_wallet`
--

CREATE TABLE `dbt_admin_wallet` (
  `aw_id` int(11) NOT NULL,
  `version` tinyint(4) NOT NULL,
  `id` varchar(40) NOT NULL,
  `address` varchar(45) NOT NULL,
  `ciphertext` varchar(70) NOT NULL,
  `iv` varchar(35) NOT NULL,
  `cipher` varchar(15) NOT NULL,
  `kdf` varchar(8) NOT NULL,
  `dklen` tinyint(4) NOT NULL,
  `salt` varchar(70) NOT NULL,
  `n` int(11) NOT NULL,
  `r` tinyint(4) NOT NULL,
  `p` tinyint(4) NOT NULL,
  `mac` varchar(70) NOT NULL,
  `encrypt_val` text NOT NULL,
  `wallet` varchar(50) NOT NULL,
  `using_for` varchar(10) NOT NULL COMMENT 'BEP/ERC',
  `tnx_type` varchar(20) NOT NULL COMMENT 'DEPOSIT/EARNINGS',
  `status` tinyint(1) NOT NULL COMMENT '1 = Using, 2 = Idel, 0 = Deactive',
  `created_at` datetime DEFAULT NULL,
  `update_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `dbt_affiliation`
--

CREATE TABLE `dbt_affiliation` (
  `id` int(11) NOT NULL,
  `type` varchar(20) NOT NULL,
  `commission` double(19,8) NOT NULL,
  `status` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dbt_affiliation`
--

INSERT INTO `dbt_affiliation` (`id`, `type`, `commission`, `status`) VALUES
(1, 'PERCENT', 10.00000000, 1);

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

--
-- Table structure for table `dbt_balance`
--

CREATE TABLE `dbt_balance` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) NOT NULL,
  `balance` double(19,8) NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `dbt_balance_log`
--

CREATE TABLE `dbt_balance_log` (
  `log_id` bigint(22) NOT NULL,
  `balance_id` int(11) NOT NULL,
  `user_id` varchar(100) NOT NULL,
  `transaction_type` varchar(100) NOT NULL,
  `transaction_amount` double(19,8) NOT NULL,
  `transaction_fees` double(19,8) NOT NULL,
  `ip` varchar(100) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `dbt_buy_token`
--

CREATE TABLE `dbt_buy_token` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `from_wallet` varchar(255) NOT NULL,
  `to_wallet` varchar(255) NOT NULL,
  `token_amount` double NOT NULL,
  `txn_hash` varchar(255) NOT NULL,
  `cid` int(11) NOT NULL,
  `create_time` datetime NOT NULL,
  `is_blockchain` tinyint(1) NOT NULL COMMENT '0=local,1=blockchain',
  `status` tinyint(1) NOT NULL COMMENT '0=cancel,1=success,2=request,3=pending',
  `created_at` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `dbt_coin_info`
--

CREATE TABLE `dbt_coin_info` (
  `id` int(11) NOT NULL,
  `token_type` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `symbol` varchar(255) NOT NULL,
  `image` varchar(300) DEFAULT NULL,
  `decimal_value` varchar(55) DEFAULT NULL,
  `contract_address` varchar(100) DEFAULT NULL,
  `hold_coin` double(20,4) NOT NULL DEFAULT 0.0000,
  `pre_sell` double(20,4) NOT NULL DEFAULT 0.0000,
  `sell_available` double(20,4) NOT NULL DEFAULT 0.0000,
  `total_coin` double(20,4) NOT NULL,
  `is_transferable` tinyint(1) NOT NULL DEFAULT 0,
  `explorer_url` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dbt_coin_info`
--

INSERT INTO `dbt_coin_info` (`id`, `token_type`, `name`, `symbol`, `image`, `decimal_value`, `contract_address`, `hold_coin`, `pre_sell`, `sell_available`, `total_coin`, `is_transferable`, `explorer_url`, `status`) VALUES
(1, 'Local', '', '', NULL, NULL, 'Local', 0, 0, 0, 0, 0, NULL, 1);

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

--
-- Table structure for table `dbt_country`
--

CREATE TABLE `dbt_country` (
  `id` int(11) NOT NULL,
  `iso` char(2) NOT NULL,
  `name` varchar(80) NOT NULL,
  `nicename` varchar(80) NOT NULL,
  `iso3` char(3) DEFAULT NULL,
  `numcode` smallint(6) DEFAULT NULL,
  `phonecode` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dbt_country`
--

INSERT INTO `dbt_country` (`id`, `iso`, `name`, `nicename`, `iso3`, `numcode`, `phonecode`) VALUES
(1, 'AF', 'AFGHANISTAN', 'Afghanistan', 'AFG', 4, 93),
(2, 'AL', 'ALBANIA', 'Albania', 'ALB', 8, 355),
(3, 'DZ', 'ALGERIA', 'Algeria', 'DZA', 12, 213),
(4, 'AS', 'AMERICAN SAMOA', 'American Samoa', 'ASM', 16, 1684),
(5, 'AD', 'ANDORRA', 'Andorra', 'AND', 20, 376),
(6, 'AO', 'ANGOLA', 'Angola', 'AGO', 24, 244),
(7, 'AI', 'ANGUILLA', 'Anguilla', 'AIA', 660, 1264),
(8, 'AQ', 'ANTARCTICA', 'Antarctica', 'ATA', NULL, 0),
(9, 'AG', 'ANTIGUA AND BARBUDA', 'Antigua and Barbuda', 'ATG', 28, 1268),
(10, 'AR', 'ARGENTINA', 'Argentina', 'ARG', 32, 54),
(11, 'AM', 'ARMENIA', 'Armenia', 'ARM', 51, 374),
(12, 'AW', 'ARUBA', 'Aruba', 'ABW', 533, 297),
(13, 'AU', 'AUSTRALIA', 'Australia', 'AUS', 36, 61),
(14, 'AT', 'AUSTRIA', 'Austria', 'AUT', 40, 43),
(15, 'AZ', 'AZERBAIJAN', 'Azerbaijan', 'AZE', 31, 994),
(16, 'BS', 'BAHAMAS', 'Bahamas', 'BHS', 44, 1242),
(17, 'BH', 'BAHRAIN', 'Bahrain', 'BHR', 48, 973),
(18, 'BD', 'BANGLADESH', 'Bangladesh', 'BGD', 50, 880),
(19, 'BB', 'BARBADOS', 'Barbados', 'BRB', 52, 1246),
(20, 'BY', 'BELARUS', 'Belarus', 'BLR', 112, 375),
(21, 'BE', 'BELGIUM', 'Belgium', 'BEL', 56, 32),
(22, 'BZ', 'BELIZE', 'Belize', 'BLZ', 84, 501),
(23, 'BJ', 'BENIN', 'Benin', 'BEN', 204, 229),
(24, 'BM', 'BERMUDA', 'Bermuda', 'BMU', 60, 1441),
(25, 'BT', 'BHUTAN', 'Bhutan', 'BTN', 64, 975),
(26, 'BO', 'BOLIVIA', 'Bolivia', 'BOL', 68, 591),
(27, 'BA', 'BOSNIA AND HERZEGOVINA', 'Bosnia and Herzegovina', 'BIH', 70, 387),
(28, 'BW', 'BOTSWANA', 'Botswana', 'BWA', 72, 267),
(29, 'BV', 'BOUVET ISLAND', 'Bouvet Island', NULL, NULL, 0),
(30, 'BR', 'BRAZIL', 'Brazil', 'BRA', 76, 55),
(31, 'IO', 'BRITISH INDIAN OCEAN TERRITORY', 'British Indian Ocean Territory', 'IOT', NULL, 246),
(32, 'BN', 'BRUNEI DARUSSALAM', 'Brunei Darussalam', 'BRN', 96, 673),
(33, 'BG', 'BULGARIA', 'Bulgaria', 'BGR', 100, 359),
(34, 'BF', 'BURKINA FASO', 'Burkina Faso', 'BFA', 854, 226),
(35, 'BI', 'BURUNDI', 'Burundi', 'BDI', 108, 257),
(36, 'KH', 'CAMBODIA', 'Cambodia', 'KHM', 116, 855),
(37, 'CM', 'CAMEROON', 'Cameroon', 'CMR', 120, 237),
(38, 'CA', 'CANADA', 'Canada', 'CAN', 124, 1),
(39, 'CV', 'CAPE VERDE', 'Cape Verde', 'CPV', 132, 238),
(40, 'KY', 'CAYMAN ISLANDS', 'Cayman Islands', 'CYM', 136, 1345),
(41, 'CF', 'CENTRAL AFRICAN REPUBLIC', 'Central African Republic', 'CAF', 140, 236),
(42, 'TD', 'CHAD', 'Chad', 'TCD', 148, 235),
(43, 'CL', 'CHILE', 'Chile', 'CHL', 152, 56),
(44, 'CN', 'CHINA', 'China', 'CHN', 156, 86),
(45, 'CX', 'CHRISTMAS ISLAND', 'Christmas Island', 'CXR', NULL, 61),
(46, 'CC', 'COCOS (KEELING) ISLANDS', 'Cocos (Keeling) Islands', 'CCK', NULL, 672),
(47, 'CO', 'COLOMBIA', 'Colombia', 'COL', 170, 57),
(48, 'KM', 'COMOROS', 'Comoros', 'COM', 174, 269),
(49, 'CG', 'CONGO', 'Congo', 'COG', 178, 242),
(50, 'CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'Congo, the Democratic Republic of the', 'COD', 180, 242),
(51, 'CK', 'COOK ISLANDS', 'Cook Islands', 'COK', 184, 682),
(52, 'CR', 'COSTA RICA', 'Costa Rica', 'CRI', 188, 506),
(53, 'CI', 'COTE D\'IVOIRE', 'Cote D\'Ivoire', 'CIV', 384, 225),
(54, 'HR', 'CROATIA', 'Croatia', 'HRV', 191, 385),
(55, 'CU', 'CUBA', 'Cuba', 'CUB', 192, 53),
(56, 'CY', 'CYPRUS', 'Cyprus', 'CYP', 196, 357),
(57, 'CZ', 'CZECH REPUBLIC', 'Czech Republic', 'CZE', 203, 420),
(58, 'DK', 'DENMARK', 'Denmark', 'DNK', 208, 45),
(59, 'DJ', 'DJIBOUTI', 'Djibouti', 'DJI', 262, 253),
(60, 'DM', 'DOMINICA', 'Dominica', 'DMA', 212, 1767),
(61, 'DO', 'DOMINICAN REPUBLIC', 'Dominican Republic', 'DOM', 214, 1809),
(62, 'EC', 'ECUADOR', 'Ecuador', 'ECU', 218, 593),
(63, 'EG', 'EGYPT', 'Egypt', 'EGY', 818, 20),
(64, 'SV', 'EL SALVADOR', 'El Salvador', 'SLV', 222, 503),
(65, 'GQ', 'EQUATORIAL GUINEA', 'Equatorial Guinea', 'GNQ', 226, 240),
(66, 'ER', 'ERITREA', 'Eritrea', 'ERI', 232, 291),
(67, 'EE', 'ESTONIA', 'Estonia', 'EST', 233, 372),
(68, 'ET', 'ETHIOPIA', 'Ethiopia', 'ETH', 231, 251),
(69, 'FK', 'FALKLAND ISLANDS (MALVINAS)', 'Falkland Islands (Malvinas)', 'FLK', 238, 500),
(70, 'FO', 'FAROE ISLANDS', 'Faroe Islands', 'FRO', 234, 298),
(71, 'FJ', 'FIJI', 'Fiji', 'FJI', 242, 679),
(72, 'FI', 'FINLAND', 'Finland', 'FIN', 246, 358),
(73, 'FR', 'FRANCE', 'France', 'FRA', 250, 33),
(74, 'GF', 'FRENCH GUIANA', 'French Guiana', 'GUF', 254, 594),
(75, 'PF', 'FRENCH POLYNESIA', 'French Polynesia', 'PYF', 258, 689),
(76, 'TF', 'FRENCH SOUTHERN TERRITORIES', 'French Southern Territories', NULL, NULL, 0),
(77, 'GA', 'GABON', 'Gabon', 'GAB', 266, 241),
(78, 'GM', 'GAMBIA', 'Gambia', 'GMB', 270, 220),
(79, 'GE', 'GEORGIA', 'Georgia', 'GEO', 268, 995),
(80, 'DE', 'GERMANY', 'Germany', 'DEU', 276, 49),
(81, 'GH', 'GHANA', 'Ghana', 'GHA', 288, 233),
(82, 'GI', 'GIBRALTAR', 'Gibraltar', 'GIB', 292, 350),
(83, 'GR', 'GREECE', 'Greece', 'GRC', 300, 30),
(84, 'GL', 'GREENLAND', 'Greenland', 'GRL', 304, 299),
(85, 'GD', 'GRENADA', 'Grenada', 'GRD', 308, 1473),
(86, 'GP', 'GUADELOUPE', 'Guadeloupe', 'GLP', 312, 590),
(87, 'GU', 'GUAM', 'Guam', 'GUM', 316, 1671),
(88, 'GT', 'GUATEMALA', 'Guatemala', 'GTM', 320, 502),
(89, 'GN', 'GUINEA', 'Guinea', 'GIN', 324, 224),
(90, 'GW', 'GUINEA-BISSAU', 'Guinea-Bissau', 'GNB', 624, 245),
(91, 'GY', 'GUYANA', 'Guyana', 'GUY', 328, 592),
(92, 'HT', 'HAITI', 'Haiti', 'HTI', 332, 509),
(93, 'HM', 'HEARD ISLAND AND MCDONALD ISLANDS', 'Heard Island and Mcdonald Islands', NULL, NULL, 0),
(94, 'VA', 'HOLY SEE (VATICAN CITY STATE)', 'Holy See (Vatican City State)', 'VAT', 336, 39),
(95, 'HN', 'HONDURAS', 'Honduras', 'HND', 340, 504),
(96, 'HK', 'HONG KONG', 'Hong Kong', 'HKG', 344, 852),
(97, 'HU', 'HUNGARY', 'Hungary', 'HUN', 348, 36),
(98, 'IS', 'ICELAND', 'Iceland', 'ISL', 352, 354),
(99, 'IN', 'INDIA', 'India', 'IND', 356, 91),
(100, 'ID', 'INDONESIA', 'Indonesia', 'IDN', 360, 62),
(101, 'IR', 'IRAN, ISLAMIC REPUBLIC OF', 'Iran, Islamic Republic of', 'IRN', 364, 98),
(102, 'IQ', 'IRAQ', 'Iraq', 'IRQ', 368, 964),
(103, 'IE', 'IRELAND', 'Ireland', 'IRL', 372, 353),
(104, 'IL', 'ISRAEL', 'Israel', 'ISR', 376, 972),
(105, 'IT', 'ITALY', 'Italy', 'ITA', 380, 39),
(106, 'JM', 'JAMAICA', 'Jamaica', 'JAM', 388, 1876),
(107, 'JP', 'JAPAN', 'Japan', 'JPN', 392, 81),
(108, 'JO', 'JORDAN', 'Jordan', 'JOR', 400, 962),
(109, 'KZ', 'KAZAKHSTAN', 'Kazakhstan', 'KAZ', 398, 7),
(110, 'KE', 'KENYA', 'Kenya', 'KEN', 404, 254),
(111, 'KI', 'KIRIBATI', 'Kiribati', 'KIR', 296, 686),
(112, 'KP', 'KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF', 'Korea, Democratic People\'s Republic of', 'PRK', 408, 850),
(113, 'KR', 'KOREA, REPUBLIC OF', 'Korea, Republic of', 'KOR', 410, 82),
(114, 'KW', 'KUWAIT', 'Kuwait', 'KWT', 414, 965),
(115, 'KG', 'KYRGYZSTAN', 'Kyrgyzstan', 'KGZ', 417, 996),
(116, 'LA', 'LAO PEOPLE\'S DEMOCRATIC REPUBLIC', 'Lao People\'s Democratic Republic', 'LAO', 418, 856),
(117, 'LV', 'LATVIA', 'Latvia', 'LVA', 428, 371),
(118, 'LB', 'LEBANON', 'Lebanon', 'LBN', 422, 961),
(119, 'LS', 'LESOTHO', 'Lesotho', 'LSO', 426, 266),
(120, 'LR', 'LIBERIA', 'Liberia', 'LBR', 430, 231),
(121, 'LY', 'LIBYAN ARAB JAMAHIRIYA', 'Libyan Arab Jamahiriya', 'LBY', 434, 218),
(122, 'LI', 'LIECHTENSTEIN', 'Liechtenstein', 'LIE', 438, 423),
(123, 'LT', 'LITHUANIA', 'Lithuania', 'LTU', 440, 370),
(124, 'LU', 'LUXEMBOURG', 'Luxembourg', 'LUX', 442, 352),
(125, 'MO', 'MACAO', 'Macao', 'MAC', 446, 853),
(126, 'MK', 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'Macedonia, the Former Yugoslav Republic of', 'MKD', 807, 389),
(127, 'MG', 'MADAGASCAR', 'Madagascar', 'MDG', 450, 261),
(128, 'MW', 'MALAWI', 'Malawi', 'MWI', 454, 265),
(129, 'MY', 'MALAYSIA', 'Malaysia', 'MYS', 458, 60),
(130, 'MV', 'MALDIVES', 'Maldives', 'MDV', 462, 960),
(131, 'ML', 'MALI', 'Mali', 'MLI', 466, 223),
(132, 'MT', 'MALTA', 'Malta', 'MLT', 470, 356),
(133, 'MH', 'MARSHALL ISLANDS', 'Marshall Islands', 'MHL', 584, 692),
(134, 'MQ', 'MARTINIQUE', 'Martinique', 'MTQ', 474, 596),
(135, 'MR', 'MAURITANIA', 'Mauritania', 'MRT', 478, 222),
(136, 'MU', 'MAURITIUS', 'Mauritius', 'MUS', 480, 230),
(137, 'YT', 'MAYOTTE', 'Mayotte', NULL, NULL, 269),
(138, 'MX', 'MEXICO', 'Mexico', 'MEX', 484, 52),
(139, 'FM', 'MICRONESIA, FEDERATED STATES OF', 'Micronesia, Federated States of', 'FSM', 583, 691),
(140, 'MD', 'MOLDOVA, REPUBLIC OF', 'Moldova, Republic of', 'MDA', 498, 373),
(141, 'MC', 'MONACO', 'Monaco', 'MCO', 492, 377),
(142, 'MN', 'MONGOLIA', 'Mongolia', 'MNG', 496, 976),
(143, 'MS', 'MONTSERRAT', 'Montserrat', 'MSR', 500, 1664),
(144, 'MA', 'MOROCCO', 'Morocco', 'MAR', 504, 212),
(145, 'MZ', 'MOZAMBIQUE', 'Mozambique', 'MOZ', 508, 258),
(146, 'MM', 'MYANMAR', 'Myanmar', 'MMR', 104, 95),
(147, 'NA', 'NAMIBIA', 'Namibia', 'NAM', 516, 264),
(148, 'NR', 'NAURU', 'Nauru', 'NRU', 520, 674),
(149, 'NP', 'NEPAL', 'Nepal', 'NPL', 524, 977),
(150, 'NL', 'NETHERLANDS', 'Netherlands', 'NLD', 528, 31),
(151, 'AN', 'NETHERLANDS ANTILLES', 'Netherlands Antilles', 'ANT', 530, 599),
(152, 'NC', 'NEW CALEDONIA', 'New Caledonia', 'NCL', 540, 687),
(153, 'NZ', 'NEW ZEALAND', 'New Zealand', 'NZL', 554, 64),
(154, 'NI', 'NICARAGUA', 'Nicaragua', 'NIC', 558, 505),
(155, 'NE', 'NIGER', 'Niger', 'NER', 562, 227),
(156, 'NG', 'NIGERIA', 'Nigeria', 'NGA', 566, 234),
(157, 'NU', 'NIUE', 'Niue', 'NIU', 570, 683),
(158, 'NF', 'NORFOLK ISLAND', 'Norfolk Island', 'NFK', 574, 672),
(159, 'MP', 'NORTHERN MARIANA ISLANDS', 'Northern Mariana Islands', 'MNP', 580, 1670),
(160, 'NO', 'NORWAY', 'Norway', 'NOR', 578, 47),
(161, 'OM', 'OMAN', 'Oman', 'OMN', 512, 968),
(162, 'PK', 'PAKISTAN', 'Pakistan', 'PAK', 586, 92),
(163, 'PW', 'PALAU', 'Palau', 'PLW', 585, 680),
(164, 'PS', 'PALESTINIAN TERRITORY, OCCUPIED', 'Palestinian Territory, Occupied', NULL, NULL, 970),
(165, 'PA', 'PANAMA', 'Panama', 'PAN', 591, 507),
(166, 'PG', 'PAPUA NEW GUINEA', 'Papua New Guinea', 'PNG', 598, 675),
(167, 'PY', 'PARAGUAY', 'Paraguay', 'PRY', 600, 595),
(168, 'PE', 'PERU', 'Peru', 'PER', 604, 51),
(169, 'PH', 'PHILIPPINES', 'Philippines', 'PHL', 608, 63),
(170, 'PN', 'PITCAIRN', 'Pitcairn', 'PCN', 612, 0),
(171, 'PL', 'POLAND', 'Poland', 'POL', 616, 48),
(172, 'PT', 'PORTUGAL', 'Portugal', 'PRT', 620, 351),
(173, 'PR', 'PUERTO RICO', 'Puerto Rico', 'PRI', 630, 1787),
(174, 'QA', 'QATAR', 'Qatar', 'QAT', 634, 974),
(175, 'RE', 'REUNION', 'Reunion', 'REU', 638, 262),
(176, 'RO', 'ROMANIA', 'Romania', 'ROM', 642, 40),
(177, 'RU', 'RUSSIAN FEDERATION', 'Russian Federation', 'RUS', 643, 70),
(178, 'RW', 'RWANDA', 'Rwanda', 'RWA', 646, 250),
(179, 'SH', 'SAINT HELENA', 'Saint Helena', 'SHN', 654, 290),
(180, 'KN', 'SAINT KITTS AND NEVIS', 'Saint Kitts and Nevis', 'KNA', 659, 1869),
(181, 'LC', 'SAINT LUCIA', 'Saint Lucia', 'LCA', 662, 1758),
(182, 'PM', 'SAINT PIERRE AND MIQUELON', 'Saint Pierre and Miquelon', 'SPM', 666, 508),
(183, 'VC', 'SAINT VINCENT AND THE GRENADINES', 'Saint Vincent and the Grenadines', 'VCT', 670, 1784),
(184, 'WS', 'SAMOA', 'Samoa', 'WSM', 882, 684),
(185, 'SM', 'SAN MARINO', 'San Marino', 'SMR', 674, 378),
(186, 'ST', 'SAO TOME AND PRINCIPE', 'Sao Tome and Principe', 'STP', 678, 239),
(187, 'SA', 'SAUDI ARABIA', 'Saudi Arabia', 'SAU', 682, 966),
(188, 'SN', 'SENEGAL', 'Senegal', 'SEN', 686, 221),
(189, 'CS', 'SERBIA AND MONTENEGRO', 'Serbia and Montenegro', NULL, NULL, 381),
(190, 'SC', 'SEYCHELLES', 'Seychelles', 'SYC', 690, 248),
(191, 'SL', 'SIERRA LEONE', 'Sierra Leone', 'SLE', 694, 232),
(192, 'SG', 'SINGAPORE', 'Singapore', 'SGP', 702, 65),
(193, 'SK', 'SLOVAKIA', 'Slovakia', 'SVK', 703, 421),
(194, 'SI', 'SLOVENIA', 'Slovenia', 'SVN', 705, 386),
(195, 'SB', 'SOLOMON ISLANDS', 'Solomon Islands', 'SLB', 90, 677),
(196, 'SO', 'SOMALIA', 'Somalia', 'SOM', 706, 252),
(197, 'ZA', 'SOUTH AFRICA', 'South Africa', 'ZAF', 710, 27),
(198, 'GS', 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'South Georgia and the South Sandwich Islands', NULL, NULL, 0),
(199, 'ES', 'SPAIN', 'Spain', 'ESP', 724, 34),
(200, 'LK', 'SRI LANKA', 'Sri Lanka', 'LKA', 144, 94),
(201, 'SD', 'SUDAN', 'Sudan', 'SDN', 736, 249),
(202, 'SR', 'SURINAME', 'Suriname', 'SUR', 740, 597),
(203, 'SJ', 'SVALBARD AND JAN MAYEN', 'Svalbard and Jan Mayen', 'SJM', 744, 47),
(204, 'SZ', 'SWAZILAND', 'Swaziland', 'SWZ', 748, 268),
(205, 'SE', 'SWEDEN', 'Sweden', 'SWE', 752, 46),
(206, 'CH', 'SWITZERLAND', 'Switzerland', 'CHE', 756, 41),
(207, 'SY', 'SYRIAN ARAB REPUBLIC', 'Syrian Arab Republic', 'SYR', 760, 963),
(208, 'TW', 'TAIWAN, PROVINCE OF CHINA', 'Taiwan, Province of China', 'TWN', 158, 886),
(209, 'TJ', 'TAJIKISTAN', 'Tajikistan', 'TJK', 762, 992),
(210, 'TZ', 'TANZANIA, UNITED REPUBLIC OF', 'Tanzania, United Republic of', 'TZA', 834, 255),
(211, 'TH', 'THAILAND', 'Thailand', 'THA', 764, 66),
(212, 'TL', 'TIMOR-LESTE', 'Timor-Leste', NULL, NULL, 670),
(213, 'TG', 'TOGO', 'Togo', 'TGO', 768, 228),
(214, 'TK', 'TOKELAU', 'Tokelau', 'TKL', 772, 690),
(215, 'TO', 'TONGA', 'Tonga', 'TON', 776, 676),
(216, 'TT', 'TRINIDAD AND TOBAGO', 'Trinidad and Tobago', 'TTO', 780, 1868),
(217, 'TN', 'TUNISIA', 'Tunisia', 'TUN', 788, 216),
(218, 'TR', 'TURKEY', 'Turkey', 'TUR', 792, 90),
(219, 'TM', 'TURKMENISTAN', 'Turkmenistan', 'TKM', 795, 7370),
(220, 'TC', 'TURKS AND CAICOS ISLANDS', 'Turks and Caicos Islands', 'TCA', 796, 1649),
(221, 'TV', 'TUVALU', 'Tuvalu', 'TUV', 798, 688),
(222, 'UG', 'UGANDA', 'Uganda', 'UGA', 800, 256),
(223, 'UA', 'UKRAINE', 'Ukraine', 'UKR', 804, 380),
(224, 'AE', 'UNITED ARAB EMIRATES', 'United Arab Emirates', 'ARE', 784, 971),
(225, 'GB', 'UNITED KINGDOM', 'United Kingdom', 'GBR', 826, 44),
(226, 'US', 'UNITED STATES', 'United States', 'USA', 840, 1),
(227, 'UM', 'UNITED STATES MINOR OUTLYING ISLANDS', 'United States Minor Outlying Islands', NULL, NULL, 1),
(228, 'UY', 'URUGUAY', 'Uruguay', 'URY', 858, 598),
(229, 'UZ', 'UZBEKISTAN', 'Uzbekistan', 'UZB', 860, 998),
(230, 'VU', 'VANUATU', 'Vanuatu', 'VUT', 548, 678),
(231, 'VE', 'VENEZUELA', 'Venezuela', 'VEN', 862, 58),
(232, 'VN', 'VIET NAM', 'Viet Nam', 'VNM', 704, 84),
(233, 'VG', 'VIRGIN ISLANDS, BRITISH', 'Virgin Islands, British', 'VGB', 92, 1284),
(234, 'VI', 'VIRGIN ISLANDS, U.S.', 'Virgin Islands, U.s.', 'VIR', 850, 1340),
(235, 'WF', 'WALLIS AND FUTUNA', 'Wallis and Futuna', 'WLF', 876, 681),
(236, 'EH', 'WESTERN SAHARA', 'Western Sahara', 'ESH', 732, 212),
(237, 'YE', 'YEMEN', 'Yemen', 'YEM', 887, 967),
(238, 'ZM', 'ZAMBIA', 'Zambia', 'ZMB', 894, 260),
(239, 'ZW', 'ZIMBABWE', 'Zimbabwe', 'ZWE', 716, 263),
(240, 'RS', 'SERBIA', 'Serbia', 'SRB', 688, 381),
(241, 'AP', 'ASIA PACIFIC REGION', 'Asia / Pacific Region', '0', 0, 0),
(242, 'ME', 'MONTENEGRO', 'Montenegro', 'MNE', 499, 382),
(243, 'AX', 'ALAND ISLANDS', 'Aland Islands', 'ALA', 248, 358),
(244, 'BQ', 'BONAIRE, SINT EUSTATIUS AND SABA', 'Bonaire, Sint Eustatius and Saba', 'BES', 535, 599),
(245, 'CW', 'CURACAO', 'Curacao', 'CUW', 531, 599),
(246, 'GG', 'GUERNSEY', 'Guernsey', 'GGY', 831, 44),
(247, 'IM', 'ISLE OF MAN', 'Isle of Man', 'IMN', 833, 44),
(248, 'JE', 'JERSEY', 'Jersey', 'JEY', 832, 44),
(249, 'XK', 'KOSOVO', 'Kosovo', '---', 0, 381),
(250, 'BL', 'SAINT BARTHELEMY', 'Saint Barthelemy', 'BLM', 652, 590),
(251, 'MF', 'SAINT MARTIN', 'Saint Martin', 'MAF', 663, 590),
(252, 'SX', 'SINT MAARTEN', 'Sint Maarten', 'SXM', 534, 1),
(253, 'SS', 'SOUTH SUDAN', 'South Sudan', 'SSD', 728, 211);

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

--
-- Table structure for table `dbt_cron`
--

CREATE TABLE `dbt_cron` (
  `id` int(5) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `command` varchar(255) NOT NULL,
  `interval_sec` int(10) NOT NULL,
  `last_run_at` datetime DEFAULT NULL,
  `next_run_at` datetime DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `dbt_currency`
--

CREATE TABLE `dbt_currency` (
  `id` int(11) NOT NULL,
  `icon` varchar(300) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `symbol` varchar(100) NOT NULL,
  `rate` double DEFAULT NULL,
  `white_paper` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dbt_currency`
--

INSERT INTO `dbt_currency` (`id`, `icon`, `name`, `symbol`, `rate`, `white_paper`) VALUES
(1, 'USD', 'USDT', 'USD', 1, NULL);

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

--
-- Table structure for table `dbt_deposit`
--

CREATE TABLE `dbt_deposit` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) NOT NULL,
  `amount` double(19,8) NOT NULL,
  `method` varchar(50) NOT NULL,
  `fees_amount` double(19,8) NOT NULL,
  `comment` varchar(300) DEFAULT NULL,
  `deposit_date` datetime DEFAULT NULL,
  `approved_date` datetime DEFAULT NULL,
  `stripe_session_id` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL COMMENT '0=Pending, 1= confirm, 2=Cancel',
  `ip` varchar(50) NOT NULL,
  `approved_cancel_by` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `dbt_encrypt_data`
--

CREATE TABLE `dbt_encrypt_data` (
  `encrypt_id` bigint(20) NOT NULL,
  `version` tinyint(4) NOT NULL,
  `id` varchar(40) NOT NULL,
  `address` varchar(45) NOT NULL,
  `wallet` varchar(45) NOT NULL,
  `ciphertext` varchar(70) NOT NULL,
  `iv` varchar(35) NOT NULL,
  `cipher` varchar(15) NOT NULL,
  `kdf` varchar(8) NOT NULL,
  `dklen` tinyint(4) NOT NULL,
  `salt` varchar(70) NOT NULL,
  `n` int(11) NOT NULL,
  `r` tinyint(4) NOT NULL,
  `p` tinyint(4) NOT NULL,
  `mac` varchar(70) NOT NULL,
  `encrypt_val` text NOT NULL,
  `user_id` varchar(12) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `update_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `dbt_fees`
--

CREATE TABLE `dbt_fees` (
  `id` int(11) NOT NULL,
  `level` varchar(100) NOT NULL,
  `fees` double NOT NULL,
  `status` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dbt_fees`
--

INSERT INTO `dbt_fees` (`id`, `level`, `fees`, `status`) VALUES
(2, 'DEPOSIT', 2, 0),
(3, 'TRANSFER', 3, 0),
(4, 'WITHDRAW', 2, 0);

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

--
-- Table structure for table `dbt_messenger`
--

CREATE TABLE `dbt_messenger` (
  `id` int(11) NOT NULL,
  `sender_id` varchar(50) NOT NULL,
  `reciver_id` varchar(50) NOT NULL,
  `subject` text NOT NULL,
  `messege` text NOT NULL,
  `replay_id` int(11) NOT NULL,
  `date_time` datetime NOT NULL,
  `status` int(11) NOT NULL,
  `admin_status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `dbt_networking_setting`
--

CREATE TABLE `dbt_networking_setting` (
  `id` int(11) NOT NULL,
  `network_type` varchar(15) NOT NULL,
  `rpc_url` varchar(255) NOT NULL,
  `ip_address` varchar(25) DEFAULT NULL,
  `port_number` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


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

--
-- Table structure for table `dbt_release_setup`
--

CREATE TABLE `dbt_release_setup` (
  `id` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `round_name` varchar(100) NOT NULL,
  `day` tinyint(5) NOT NULL,
  `target` int(11) NOT NULL,
  `fillup_target` double(19,8) NOT NULL,
  `exchange_currency` varchar(100) NOT NULL,
  `start_date` datetime NOT NULL,
  `status` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `dbt_sms_email_template`
--

CREATE TABLE `dbt_sms_email_template` (
  `id` int(11) NOT NULL,
  `sms_or_email` varchar(10) CHARACTER SET latin1 NOT NULL,
  `template_name` varchar(50) CHARACTER SET latin1 NOT NULL,
  `subject_en` varchar(300) CHARACTER SET latin1 NOT NULL,
  `subject_fr` varchar(300) CHARACTER SET latin1 NOT NULL,
  `template_en` varchar(300) CHARACTER SET latin1 NOT NULL,
  `template_fr` varchar(300) CHARACTER SET latin1 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dbt_sms_email_template`
--

INSERT INTO `dbt_sms_email_template` (`id`, `sms_or_email`, `template_name`, `subject_en`, `subject_fr`, `template_en`, `template_fr`) VALUES
(1, 'sms', 'transfer_verification', 'Transfer Verification Code', 'Transfer Verification Code', 'You are about to transfar %amount% to the account %receiver_id% Your code is %code%\r\n', 'Vous ?tes sur le point de transf?rer% amount% sur le compte% receiver_id% Votre code est %code%\r\n'),
(2, 'email', 'transfer_verification', 'Transfer Verification', 'Transfer Verification', 'You are about to transfar %amount% to the account %receiver_id%  Your code is %verify_code%', 'Vous ?tes sur le point de transf?rer% amount% sur le compte% receiver_id% Votre code est % varify_code% '),
(3, 'sms', 'transfer_success', 'Transfer Confirm', 'Transfer Confirm', 'You successfully transfer The amount $%amount% to the account %receiver_id%. Your new balance is %new_balance%', 'You successfully transfer The amount $%amount% to the account %receiver_id%. Your new balance is %new_balance%'),
(4, 'email', 'transfer_success', 'Tranfer Confirm', 'Tranfer Confirm', 'You successfully transfer The amount $%amount% to the account %receiver_id%. Your new balance is %new_balance%', 'You successfully transfer The amount $%amount% to the account %receiver_id%. Your new balance is %new_balance%'),
(5, 'sms', 'withdraw_verification', '', 'Withdraw Verification French', 'You Withdraw The Amount Is %amount% The Verification Code is <h1>%varify_code%</h1>', 'You Withdraw The Amount Is %amount% The Verification Code is <h1>%varify_code%</h1>'),
(6, 'email', 'withdraw_verification', 'Withdraw Verification', 'Withdraw Verification French', 'You Withdraw The Amount Is %amount% The Verification Code is %varify_code%', 'You Withdraw The Amount Is %amount% The Verification Code is %varify_code%'),
(7, 'sms', 'withdraw_success', 'Withdraw Success', 'Withdraw Success', 'Hi, %name% You successfully withdraw the amount is $%amount% from your account. Your new balance is $%new_balance%', 'Hi, %name% You successfully withdraw the amount is $%amount% from your account. Your new balance is $%new_balance%'),
(8, 'email', 'withdraw_success', 'Withdraw', 'Withdraw', 'You successfully withdraw the amount is $%amount% from your account. Your new balance is $%new_balance%', 'You successfully withdraw the amount is $%amount% from your account. Your new balance is $%new_balance%'),
(9, 'email', 'forgot_password', '', '', 'The Verification Code is <h1>%varify_code%</h1>', 'The Verification Code is <h1>%varify_code%</h1>'),
(10, 'sms', 'deposit_success', 'Deposit', 'Deposit', 'Hi, %name% You Successfully  Deposit The Amount Is %amount%  date %date%', 'Hi, %name% You Successfully  Deposit The Amount Is %amount%  date %date%'),
(11, 'email', 'deposit_success', 'Deposit', 'Deposit', 'You successfully deposit the amount is %amount%. ', 'You successfully deposit the amount is %amount%. '),
(12, 'email', 'registered', 'Account Activation', 'Account Activation', 'Your account was created successfully Please click on the link below to activate your account. %url%\r\n', 'Votre compte a &eacute;t&eacute; cr&eacute;&eacute; avec succ&egrave;s, veuillez cliquer sur le lien ci-dessous pour activer votre compte.&nbsp;%url%\r\n');

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

--
-- Table structure for table `dbt_transfer`
--

CREATE TABLE `dbt_transfer` (
  `id` int(11) NOT NULL,
  `sender_user_id` varchar(255) DEFAULT NULL,
  `receiver_user_id` varchar(255) DEFAULT NULL,
  `amount` double(19,8) DEFAULT NULL,
  `fees` double(19,8) NOT NULL,
  `request_ip` varchar(45) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `comments` mediumtext DEFAULT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='client to client transfer success, request data recorded.';

--
-- Dumping data for table `dbt_transfer`
--

INSERT INTO `dbt_transfer` (`id`, `sender_user_id`, `receiver_user_id`, `amount`, `fees`, `request_ip`, `date`, `comments`, `status`) VALUES
(1, 'B0TASK', 'B0TASK', 10.00000000, 0.30000000, '::1', '2022-02-09', '', 1);

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

--
-- Table structure for table `dbt_user`
--

CREATE TABLE `dbt_user` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) NOT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(300) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `password_reset_token` varchar(300) DEFAULT NULL,
  `googleauth` varchar(100) DEFAULT NULL,
  `referral_id` varchar(100) DEFAULT NULL,
  `referral_status` tinyint(1) NOT NULL DEFAULT 0,
  `language` varchar(50) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `bio` text DEFAULT NULL,
  `image` varchar(300) DEFAULT NULL,
  `status` tinyint(1) NOT NULL COMMENT '"0=Deactivated account, 1=Activated account, 2=Pending account, 3=Suspend account"',
  `verified` int(11) NOT NULL DEFAULT 0 COMMENT '0= did not submit info, 1= verified, 2=Cancel, 3=processing',
  `created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `ip` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dbt_user`
--


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

--
-- Table structure for table `dbt_user_cryptowallet`
--

CREATE TABLE `dbt_user_cryptowallet` (
  `id` bigint(22) NOT NULL,
  `user_id` varchar(100) NOT NULL,
  `wallet` varchar(100) NOT NULL,
  `balance` double(19,8) NOT NULL,
  `datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `dbt_user_log`
--

CREATE TABLE `dbt_user_log` (
  `log_id` int(11) NOT NULL,
  `log_type` varchar(50) NOT NULL COMMENT '"acc_update = User Account Update, login=User Login info, deposit=User Deposit info, transfer=User Transfer info, withdraw=User Withdraw info, open_order="',
  `access_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `user_agent` varchar(300) NOT NULL,
  `user_id` varchar(100) NOT NULL,
  `ip` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dbt_user_log`
--

INSERT INTO `dbt_user_log` (`log_id`, `log_type`, `access_time`, `user_agent`, `user_id`, `ip`) VALUES
(1, 'login', '2022-02-28 16:01:11', '{\"device\":\"Chrome\",\"browser\":\"Chrome V-98.0.4758.102\",\"platform\":\"Windows 10\"}', 'B0TASK', '182.160.105.186');

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

--
-- Table structure for table `dbt_user_verify_doc`
--

CREATE TABLE `dbt_user_verify_doc` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) NOT NULL,
  `verify_type` varchar(100) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `gender` tinyint(1) NOT NULL,
  `id_number` varchar(300) NOT NULL,
  `document1` varchar(300) NOT NULL,
  `document2` varchar(300) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `dbt_verify`
--

CREATE TABLE `dbt_verify` (
  `id` int(11) NOT NULL,
  `ip_address` varchar(250) DEFAULT NULL,
  `session_id` varchar(250) DEFAULT NULL,
  `verify_code` varchar(250) DEFAULT NULL,
  `user_id` varchar(250) DEFAULT NULL,
  `data` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dbt_verify`
--

INSERT INTO `dbt_verify` (`id`, `ip_address`, `session_id`, `verify_code`, `user_id`, `data`, `status`) VALUES
(1, '::1', '1', 'H2KKIO', 'B0TASK', '{\"sender_user_id\":\"B0TASK\",\"receiver_user_id\":\"B0TASK\",\"amount\":\"10\",\"fees\":0.30000000000000004,\"request_ip\":\"::1\",\"date\":\"2022-02-09 06:51:22\",\"comments\":\"\",\"status\":1}', 0);

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

--
-- Table structure for table `dbt_withdraw`
--

CREATE TABLE `dbt_withdraw` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) NOT NULL,
  `wallet_id` varchar(100) NOT NULL,
  `amount` double NOT NULL,
  `method` varchar(50) NOT NULL,
  `fees_amount` double NOT NULL,
  `comment` varchar(300) DEFAULT NULL,
  `request_date` datetime DEFAULT NULL,
  `success_date` datetime DEFAULT NULL,
  `cancel_date` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL COMMENT '0=Cancel request, 1=Approved request, 2=Pending request',
  `ip` varchar(50) NOT NULL,
  `approved_cancel_by` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `earnings`
--

CREATE TABLE `earnings` (
  `earning_id` int(11) NOT NULL,
  `user_id` varchar(250) NOT NULL,
  `Purchaser_id` varchar(250) DEFAULT NULL,
  `earning_type` varchar(45) NOT NULL,
  `package_id` varchar(250) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `date` varchar(45) NOT NULL,
  `amount` varchar(45) NOT NULL,
  `comments` mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Weekly ROI, Monthly ROI, team bonous, direct referal bonous';

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

--
-- Table structure for table `email_sms_gateway`
--

CREATE TABLE `email_sms_gateway` (
  `es_id` int(11) NOT NULL,
  `gatewayname` varchar(100) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `protocol` varchar(100) DEFAULT NULL,
  `host` varchar(100) DEFAULT NULL,
  `port` varchar(100) DEFAULT NULL,
  `user` varchar(100) DEFAULT NULL,
  `userid` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `mailtype` varchar(100) DEFAULT NULL,
  `charset` varchar(100) DEFAULT NULL,
  `api` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `email_sms_gateway`
--

INSERT INTO `email_sms_gateway` (`es_id`, `gatewayname`, `title`, `protocol`, `host`, `port`, `user`, `userid`, `password`, `mailtype`, `charset`, `api`) VALUES
(1, 'budgetsms', 'Bdtask SMS', NULL, 'https://api.budgetsms.net/sendsms/?', NULL, 'tradeboxbdtask', '139062', NULL, NULL, NULL, 'b39edd600577b6b3bd16cc69aec82f05'),
(2, 'smtp', 'Bbtask mail', 'gsmtp', 'ssl://smtp.gmail.com', '465', 'rdmvaijah@gmail.com', '', 'vai99862', 'html', 'utf-8', NULL);

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

--
-- Table structure for table `investment`
--

CREATE TABLE `investment` (
  `order_id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `sponsor_id` varchar(255) NOT NULL,
  `package_id` int(11) NOT NULL,
  `amount` float NOT NULL DEFAULT 0,
  `invest_date` date DEFAULT NULL,
  `day` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='All investment and primary investor and referrar information will be stored here.';

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

--
-- Table structure for table `language`
--

CREATE TABLE `language` (
  `id` int(11) UNSIGNED NOT NULL,
  `phrase` text CHARACTER SET utf8 NOT NULL,
  `english` text CHARACTER SET utf8 DEFAULT NULL,
  `french` text CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `language`
--

INSERT INTO `language` (`id`, `phrase`, `english`, `french`) VALUES
(1, 'email', 'Email Address', 'Email'),
(2, 'password', 'Password', 'Mot de passe'),
(3, 'login', 'Log In', 'Connexion'),
(4, 'incorrect_email_password', 'Incorrect Email/Password!', 'Mot de passe ou email incorrect'),
(5, 'user_role', 'User Role', 'R?le Utilisateur'),
(6, 'please_login', 'Please Log In', 'Veuillez vous connecter'),
(7, 'setting', 'Setting', 'Reglages'),
(8, 'profile', 'Profile', 'Profil'),
(9, 'logout', 'Log Out', 'D?connexion'),
(10, 'please_try_again', 'Please Try Again', 'Essayez encore !'),
(11, 'admin', 'Admin', 'Administrateur'),
(12, 'dashboard', 'Dashboard', 'Tableau De Bord'),
(13, 'language_setting', 'Language Setting', 'Reglage Langue'),
(14, 'status', 'Status', 'Status'),
(15, 'active', 'Active', 'Actif'),
(16, 'inactive', 'Inactive', 'Inactif'),
(17, 'cancel', 'Cancel', 'Annuler'),
(18, 'save', 'Save', 'Sauvegarder'),
(19, 'serial', 'SL.NO', 'Serial'),
(20, 'action', 'Action', 'Action'),
(21, 'edit', 'Edit ', 'Editer'),
(22, 'delete', 'Delete', 'Supprimer'),
(23, 'save_successfully', 'Save Successfully!', 'Sauvegarde reussi'),
(24, 'update_successfully', 'Update Successfully!', 'Mise ? jour reussi'),
(25, 'delete_successfully', 'Delete successfully!', 'Suppression Reussi'),
(26, 'are_you_sure', 'Are You Sure ? ', 'Etes-vous sure?'),
(27, 'ip_address', 'IP Address', 'Adresse IP'),
(28, 'application_title', 'Application Title', 'Titre appli'),
(29, 'favicon', 'Favicon', 'favicon'),
(30, 'logo', 'Logo', 'Logo'),
(31, 'footer_text', 'Footer Text', 'Titre Footer'),
(32, 'language', 'Language', 'Langue'),
(33, 'website_title', 'Website Title', 'Titre site web'),
(34, 'invalid_logo', 'Invalid Logo', 'Logo invalide'),
(35, 'submit_successfully', 'Submit Successfully!', 'Envoi reussi'),
(36, 'application_setting', 'Application Setting', 'Reglages appli'),
(37, 'invalid_favicon', 'Invalid Favicon', 'Favicon Invalide'),
(38, 'submit', 'Submit', 'Envoyez'),
(39, 'site_align', 'Website Align', 'Alignement site'),
(40, 'right_to_left', 'Right to Left', 'Doite vers la gauche'),
(41, 'left_to_right', 'Left to Right', 'Gauche Vers la droite'),
(42, 'subject', 'Subject', 'Sujet'),
(43, 'receiver_name', 'Send To', 'Nom B?n?ficiaire'),
(44, 'select_user', 'Select User', 'Selectionner Utilisateur'),
(45, 'message_sent', 'Messages Sent', 'Message Envoy?'),
(46, 'mail', 'Mail', 'Mail'),
(47, 'send_mail', 'Send Mail', 'Envoyer Mail'),
(48, 'mail_setting', 'Mail Setting', 'Reglage mail'),
(49, 'protocol', 'Protocol', 'Protocole'),
(50, 'mailpath', 'Mail Path', 'Repertoire Mail'),
(51, 'mailtype', 'Mail Type', 'Type mail'),
(52, 'validate_email', 'Validate Email Address', 'Validez votre Email'),
(53, 'true', 'True', 'Vraie'),
(54, 'false', 'False', 'faux'),
(55, 'attach_file', 'Attach File', 'Joindre un document'),
(56, 'wordwrap', 'Enable Word Wrap', 'Wordwrap'),
(57, 'send', 'Send', 'Envoyer'),
(58, 'app_setting', 'App Setting', 'Reglages appli'),
(59, 'sms', 'SMS', 'SMS'),
(60, 'gateway_setting', 'Gateway Setting', 'Reglage portail'),
(61, 'time_zone', 'Time Zone', 'Time Zone'),
(62, 'provider', 'Provider', 'Fournisseur'),
(63, 'sms_template', 'SMS Template', 'Template SMS'),
(64, 'template_name', 'Template Name', 'Nom Du Mod?le'),
(65, 'sms_schedule', 'SMS Schedule', 'Emploi du temps SMS'),
(66, 'schedule_name', 'Schedule Name', 'Nom d\'horaire'),
(67, 'time', 'Time', 'Heure'),
(68, 'already_exists', 'Already Exists', 'Existe d?j?'),
(69, 'send_custom_sms', 'Send Custom SMS', 'Envoyer SMS personalis?'),
(70, 'sms_sent', 'SMS Sent!', 'SMS envoy?'),
(71, 'custom_sms_list', 'Custom SMS List', 'List SMS personalis?'),
(72, 'reciver', 'Reciver', 'B?n?ficiaire'),
(73, 'auto_sms_report', 'Auto SMS Report', 'Rapport SMS Auto'),
(74, 'user_sms_list', 'User SMS List', 'Liste SMS utilisateurs'),
(75, 'send_sms', 'Send SMS', 'Envoyer SMS'),
(76, 'new_sms', 'New SMS', 'Nouveau Message'),
(77, 'update', 'Update', 'Mettre à Jour'),
(78, 'reset', 'Reset', 'Reinitialiser'),
(79, 'messages', 'Messages', 'Messages'),
(80, 'inbox', 'Inbox', 'Boite de r?ception'),
(81, 'sent', 'Sent', 'Envoy?'),
(82, 'captcha', 'Captcha', 'Captcha'),
(83, 'welcome_back', 'Welcome back ', 'Bienvenue ? nouveau !'),
(84, 'inbox_message', 'Inbox Message', 'SMS Boite de r?ception'),
(85, 'image_upload_successfully', 'Image Upload Successfully.', 'Upload d\'image reussi'),
(86, 'users', 'Users', 'Utilisateurs'),
(87, 'add_user', 'Add User', 'Ajouter utilisateur'),
(88, 'user_list', 'User List', 'Liste D\'utilisateur'),
(89, 'firstname', 'First Name', 'Nom'),
(90, 'lastname', 'Last Name', 'Pr?noms'),
(91, 'about', 'About', 'A propos de nous'),
(92, 'preview', 'Preview', 'Visualliser'),
(93, 'last_login', 'Last Login', 'Derni?re connexion'),
(94, 'last_logout', 'Last Logout', 'Derni?re D?connexion'),
(95, 'image', 'Image', 'Image'),
(96, 'fullname', 'Full Name', 'Nom Complet'),
(97, 'new_message', 'New Message', 'Nouveau Message'),
(98, 'message', 'Message', 'Un Message'),
(99, 'sender_name', 'Sender Name', 'Nom de l\'exp?diteur'),
(100, 'sl_no', 'Sl No', 'Sl Non'),
(101, 'message_details', 'Message Details', 'D?tails message'),
(102, 'date', 'Date', 'Date'),
(103, 'select_option', 'Select Option', 'Selectionner Option'),
(104, 'edit_profile', 'Edit Profile', 'Editer Profile'),
(105, 'edit_user', 'Edit User', 'Editer utilisateur'),
(106, 'sent_message', 'Sent Message', 'Message Envoy?'),
(107, 'sub_admin', 'Sub Admin', 'Sub Administrateur'),
(108, 'admin_list', 'Admin List', 'List Administrateurs'),
(109, 'add_admin', 'Add Admin', 'Ajouter Administrateur'),
(110, 'edit_admin', 'Edit Admin', 'Editer Admin'),
(111, 'username', 'Username', 'Nom utilisateur'),
(112, 'sponsor_id', 'Sponsor ID', 'ID sponsor'),
(113, 'mobile', 'Mobile', 'Mobile'),
(114, 'register', 'Register', 'Enregistrer'),
(115, 'conf_password', 'Confirm Password', 'Reglage mot de passe'),
(116, 'user_id', 'User ID', 'ID utilisateur'),
(117, 'package', 'Package', 'Pack'),
(118, 'create', 'Create', 'Cr?er'),
(119, 'package_name', 'Package Name', 'Nom du pack'),
(120, 'package_deatils', 'Package Deatils', 'Detail pack'),
(121, 'package_amount', 'Package Amount', 'Montant pack'),
(122, 'daily_roi', 'Daily ROI', 'ROI journalier'),
(123, 'weekly_roi', 'Weekly ROI', 'ROI Hebdomadaire'),
(124, 'monthly_roi', 'Monthly ROI', 'ROI Mensuel'),
(125, 'yearly_roi', 'Yearly ROI', 'ROI annuel'),
(126, 'total_percent', 'Total Percent', 'Poucentage Total'),
(127, 'add_package', 'Add Package', 'Ajouter un Pack'),
(128, 'edit_package', 'Edit Package', 'Editer Pack'),
(129, 'package_list', 'Package List', 'Liste Packs'),
(130, 'withdraw', 'Withdraw', 'Retirer'),
(131, 'request', 'Request', 'Requ?te'),
(132, 'success', 'Success', 'Succ?s ! '),
(133, 'request_date', 'Request Date', 'Date Requ?te'),
(134, 'payment_method', 'Payment Method', 'Methode de paiement'),
(135, 'amount', 'Amount', 'Montant'),
(136, 'charge', 'Charge', 'Frais'),
(137, 'total', 'Total', 'Le Total'),
(138, 'comments', 'Comments', 'Commentaires'),
(139, 'pending', 'Pending', 'En cours'),
(140, 'cancel_date', 'Cancel Date', 'Annuler date'),
(141, 'block_list', 'Block List', 'Liste Noire'),
(142, 'commission', 'Commission', 'Commission'),
(143, 'setup', 'Setup', 'Regler'),
(144, 'setup_list', 'Setup List', 'Liste de reglage'),
(145, 'commission_list', 'Commission List', 'Liste Commission'),
(146, 'level_name', 'Level Name', 'Nom du stage'),
(147, 'personal_invest', 'Personal Invest', 'Mon investissement'),
(148, 'total_invest', 'Total Invest', 'Total Investissement'),
(149, 'team_bonous', 'Team Bonous', 'Bonus d\'Equipe'),
(150, 'referral_bonous', 'Referral Bonous', 'Bonus parrainage'),
(151, 'form_submit_msg', 'Insert Successfully', 'Envoyer formulaire'),
(152, 'transection_category', 'Transaction Category', 'Cat?gorie Transaction'),
(153, 'transfer_add_msg', 'Transfer Successfully', 'Ajouter SMS transfert'),
(154, 'transfer', 'Transfer', 'Transfert'),
(155, 'deposit', 'Deposit', 'Depot'),
(156, 'add_deposit', 'Add Deposit', 'Effectuer un Depot'),
(157, 'deposit_list', 'Deposit List', 'Liste De Dépôt'),
(158, 'team', 'Team', 'Équipe'),
(159, 'investment', 'Investment', 'Investissement personnel'),
(160, 'notification', 'Notification', 'Notification'),
(161, 'receiver_id', 'Receiver Id', 'ID B?n?ficiaire'),
(162, 'comment', 'Comments', 'Commentaire'),
(163, 'otp_send_to', 'OTP Send To', 'OTP envoyer ?'),
(164, 'transection', 'Transaction', 'Transactions'),
(165, 'buy', 'Buy', 'Acheter'),
(166, 'balance', 'Balance', 'Solde de compte'),
(167, 'deposit_amount', 'Deposit Amount', 'Montant Depot'),
(168, 'deposit_method', 'Deposit Method', 'Methode depot'),
(169, 'deposit_wallet_id', 'Deposit Wallet Id', 'Wallet ID'),
(170, 'confirm_transfer', 'Confirm Transfer', 'Confirmer transfert'),
(171, 'transfer_amount', 'Transfer Amount', 'Montant Transfert'),
(172, 'enter_verify_code', 'Enter Verify Code', 'Entrer code de v?rification'),
(173, 'confirm', 'Confirm', 'Confirmer'),
(174, 'deopsit_add_msg', 'Deposit Add Successfully.', 'Depot effectu? avec succ?s'),
(175, 'transfar_recite', 'Transfer Recite', 'Re?u de transfert'),
(176, 'earn', 'Earn', 'Gagner'),
(177, 'balance_is_unavailable', 'Balance Is not sufficient', 'Solde insuffisant'),
(178, 'package_buy_successfully', 'Package Buy Successfully!', 'Achat du package reussi ! '),
(179, 'withdraw_recite', 'Withdraw Recite', 'Re?u de retrait'),
(180, 'withdraw_confirm', 'withdraw Confirm', 'Confirmation Retrait'),
(181, 'change_verify', 'Confirm Verify', 'Changer Verification'),
(182, 'change_password', 'Password Change', 'Changer mot de passe'),
(183, 'enter_confirm_password', 'Enter Confirm Password', 'Confirmer mot de passe'),
(184, 'enter_new_password', 'Enter New Password', 'Entrer nouveau mot de passe'),
(185, 'enter_old_password', 'Enter Old Password', 'Entrer ancien mot de passe'),
(186, 'change', 'Change', 'Changer'),
(187, 'password_change_successfull', 'Password Change Successfully', 'Mot de passe chang? avec succ?s'),
(188, 'old_password_is_wrong', 'Old Password Is Wrong', 'Entrer ancien mot de passe incorrect'),
(189, 'fees_setting', 'Fees Setting', 'Reglages frais'),
(190, 'level', 'Level', 'Stage'),
(191, 'select_level', 'Select Level', 'Selectionner stage'),
(192, 'fees_setting_successfully', 'Fees Setting Successfully', 'Reglages Frais reussi'),
(193, 'bitcoin', 'Bitcoin', 'Bitcoin'),
(194, 'payeer', 'Payeer', 'Payeer'),
(195, 'name', 'Name', 'Nom'),
(196, 'order_id', 'Order Id', 'ID de commande'),
(197, 'fees', 'Fees', 'Frais'),
(198, 'period', 'Period', 'P?riode'),
(199, 'commission_ret', 'Commission Ret', 'Commission ret'),
(200, 'title', 'Title', 'Titre'),
(201, 'details', 'Details', 'Details'),
(202, 'personal_info', 'Personal Information', 'Informations personnels'),
(203, 'sponsor_info', 'Sponsor Information', 'Info Sponsor'),
(204, 'affiliate_url', 'Affiliat Url', 'Lien parrainage'),
(205, 'copy', 'Copy', 'Copier'),
(206, 'my_payout', 'My Payout', 'Mes Paiements'),
(207, 'personal_sales', 'Personal Sales', 'Ventes Personnelles'),
(208, 'bank_details', 'Bank Details', 'Details de banque'),
(209, 'beneficiary_name', 'Beneficiary Name', 'Nom Beneficiaire'),
(210, 'bank_name', 'Bank Name', 'Nom de banque'),
(211, 'branch', 'Branch', 'Branche'),
(212, 'account_number', 'Account Number', 'Num?ro de compte'),
(213, 'ifsc_code', 'IFC Code', 'Code IFSC'),
(214, 'account', 'Account', 'Compte'),
(215, 'my_commission', 'My Commission', 'Mes commissions'),
(216, 'finance', 'Finance', 'La Finance'),
(217, 'exchange', 'Exchange', 'échange'),
(218, 'bitcoin_setting', 'Bitcoin Setting', 'Reglages bitcoin'),
(219, 'payeer_setting', 'Payeer Setting', 'Reglages Payeer'),
(220, 'bank_information', 'Bank Information', 'Infos de banque'),
(221, 'bitcoin_wallet_id', 'Bitcoin Wallet ID', 'Wallet Bitcoin'),
(222, 'payment_method_setting', 'Payment Method Setting', 'Reglage methode de paiement'),
(223, 'payeer_wallet_id', 'Payeer Wallet Id', 'ID Payeer'),
(224, 'my_package', 'My Package', 'Mes packs'),
(225, 'my_team', 'My Team', 'Mon Equipe'),
(226, 'receipt', 'Receipt', 'R??u'),
(227, 'withdraw_successfull', 'Withdraw Successfully', 'Retrait reussi !'),
(228, 'team_bonus', 'Team Bonus', 'Bonus d\'Equipe'),
(229, 'withdraw_list', 'Withdraw List', 'Liste De Retrait'),
(230, 'pending_withdraw', 'Pending Withdraw', 'En Attente De Retrait'),
(231, 'reciver_account', 'Receiver Account', 'Compte B?n?ficiaire'),
(232, 'french', 'French', 'Fran?ais'),
(233, 'commission_setup', 'Commission Setup', 'Reglage commission'),
(234, 'personal_investment', 'Personal Investment', 'Investissement personnel'),
(235, 'total_investment', 'Total investment', 'Total Investissement'),
(236, 'transfer_list', 'Transfer List', 'Liste transfert'),
(237, 'form_to', 'From To', ''),
(238, 'receive', 'Receive', ''),
(239, 'wallet_id', 'Wallet Id', 'ID Wallet'),
(240, 'withdraw_details', 'Withdraw Details', 'Details retraits'),
(241, 'generation_one', 'Generation One', 'G?n?ration 1'),
(242, 'generation_two', 'Generation Two', 'G?n?ration 2'),
(243, 'generation_three', 'Generation Three', 'G?n?ration 3'),
(244, 'generation_four', 'Generation Four', 'G?n?ration 4'),
(245, 'generation_five', 'Generation Five', 'G?n?ration 5'),
(246, 'generation_empty_message', 'You Have No Generation', ''),
(247, 'view', 'View', 'Aper?u'),
(248, 'cancle', 'Cancel', 'Annuler'),
(249, 'type', 'Type', 'Type'),
(250, 'your_total_balance_is', 'Your Total Balance Is', 'Votre montant total est de'),
(251, 'bonus', 'Bonus', 'Bonus'),
(252, 'personal_turnover', 'Sponser Turnover', 'Mon Chiffre d\'affaire perso'),
(253, 'team_turnover', 'Team Turnover', 'Chiffre d\'affaire Equipe'),
(254, 'post_article', 'Post Article', ''),
(255, 'article_list', 'Article List', 'LIste article'),
(256, 'add_article', 'Add Article', 'Ajouter article'),
(257, 'headline_en', 'Headline English', 'Titre EN'),
(258, 'headline_fr', 'Headline French', 'Titre  FR'),
(259, 'article_en', 'Article English', 'Article EN'),
(260, 'article_fr', 'Article French', 'Article FR'),
(261, 'edit_article', 'Edit Article', 'Editer article'),
(262, 'cat_list', 'Category List', 'Liste panier'),
(263, 'add_cat', 'Add Category', 'Ajouter au panier'),
(264, 'parent_cat', 'Parent Category', ''),
(265, 'cat_name_en', 'Category Name English', 'Nom panier EN'),
(266, 'cat_name_fr', 'Category Name French', 'Nom panier FR'),
(267, 'cat_title_en', 'Category Title English', 'Titre Panier EN'),
(268, 'cat_title_fr', 'Category Title French', 'Titre panier FR'),
(269, 'select_cat', 'Select Category', 'Selectionner Cat'),
(270, 'edit_cat', 'Edit Category', 'Editer Panier'),
(271, 'position_serial', 'Position Serial', ''),
(272, 'currency_list', 'Currency List', 'Liste de devise'),
(273, 'currency', 'Currency', 'Monnaie'),
(274, 'cryptocurrency_name', 'CryptoCurrency  Name', 'Nom Crypto monnaie'),
(275, 'select_cryptocurrency', 'Select Cryptocurrency', 'Selectionner Crypto'),
(276, 'edit_currency', 'Edit Currency', 'Editer Devise'),
(277, 'exchange_list', 'Exchange List', 'Liste ?changes'),
(278, 'add_exchange', 'Add Exchange', 'Ajouter Echange'),
(279, 'edit_exchange', 'Edit Exchange', 'Editer Echange'),
(280, 'wallet_data', 'Wallet ID', 'Donn?es Wallet'),
(281, 'sell_adjustment', 'Sell Adjustment', 'Ajustement Vente'),
(282, 'buy_adjustment', 'Buy Adjustment', ''),
(283, 'exchange_wallet', 'Exchange Wallet', 'Wallet Echange'),
(284, 'exchange_wallet_list', 'Exchange Wallet List', 'Liste Wallet echange'),
(285, 'add_exchange_wallet', 'Add Exchange Wallet', 'Ajouter Wallet'),
(286, 'edit_exchange_wallet', 'Edit Exchange Wallet', 'Modifier Wallet echange'),
(287, 'local_currency_list', 'Local Currency List', 'LIste  Monnaies locales'),
(288, 'local_currency', 'Local Currency', 'Devise Locale'),
(289, 'add_local_currency', 'Add Local Currency', 'Ajouter Monnaie'),
(290, 'edit_local_currency', 'Edit Local Currency', 'Editer Devise locale'),
(291, 'currency_name', 'Currency Name', 'Nom devise'),
(292, 'currency_iso_code', 'Currency ISO Code', 'Code ISO devise '),
(293, 'usd_exchange_rate', 'USD Exchange Rate', 'Taux d\'echange USD'),
(294, 'currency_symbol', 'Currency Symbol', 'Symboles Devise'),
(295, 'symbol_position', 'Symbol Position', 'Position symbole'),
(296, 'currency_position', 'Currency Position', 'Position devise'),
(297, 'payment_gateway', 'Payment Gateway', 'Passerelle De Paiement'),
(298, 'gateway_name', 'Gateway Name', 'Nom passerelle'),
(299, 'gateway_setting', 'Gateway Setting', 'Reglage portail'),
(300, 'add_payment_gateway', 'Add Payment Gateway', 'Ajouter Methode paiment'),
(301, 'public_key', 'Public Key', 'Cl? publique'),
(302, 'private_key', 'Private Key', ''),
(303, 'shop_id', 'Shop ID', 'ID shop'),
(304, 'secret_key', 'Secret Key', 'Cl? secrete'),
(305, 'edit_payment_gateway', 'Edit Payment Gateway', 'Editer Methode de paiement'),
(306, 'slider_list', 'Slider List', ''),
(307, 'add_slider', 'Add Slider', 'Ajouter Slider'),
(308, 'headline', 'Headline', 'Titre'),
(309, 'edit_slider', 'Edit Slider', ''),
(310, 'social_app', 'Social App', ''),
(311, 'edit_social_app', 'Edit Social App', 'Editer RS appli'),
(312, 'social_link', 'Social Link', ''),
(313, 'add_link', 'Add Link', 'Ajouter Lien'),
(314, 'link', 'Link', 'Lien'),
(315, 'icon', 'Icon', 'Ic?ne'),
(316, 'edit_social_link', 'Edit Social Link', 'Edit les liens RS'),
(317, 'transection_info', 'Transection Info', 'Info transaction'),
(318, 'sell', 'Sell', 'Vendre'),
(319, 'article', 'Article', 'Article'),
(320, 'coin_amount', 'Coin Amount', 'Montat Crypto'),
(321, 'coin_name', 'Coin Name', 'Nom Crypto'),
(322, 'buy_amount', 'Buy Amount', 'Montant achat'),
(323, 'sell_amount', 'Sell Amount', 'Montant ? vendre'),
(324, 'wallet_data', 'Wallet ID', 'Donn?es Wallet'),
(325, 'usd_amount', 'USD Amount', 'Montant USD'),
(326, 'rate_coin', 'Coin Rate', 'Taux coin'),
(327, 'local_amount', 'Local Amount', 'Montant Local'),
(328, 'om_name', 'OM Name', 'Nom OM'),
(329, 'om_mobile_no', 'OM Phone No', 'N? OM'),
(330, 'transaction_no', 'Transaction No', 'N? de transaction'),
(331, 'idcard_no', 'ID Card No', 'N? CNI'),
(332, 'buy_list', 'Buy List', 'Buy list'),
(333, 'add_buy', 'Add Buy', 'Ajouter Achat'),
(334, 'transection_type', 'Transection Type', 'Type de transaction'),
(335, 'payment_successfully', 'Payment Successfully', 'Paiement effectu?'),
(336, 'payment_cancel', 'Payment Cancel', 'Paiement annul?'),
(337, 'payment_successfully', 'Payment Successfully', 'Paiement effectu?'),
(338, 'sell_list', 'Sell List', 'LIste de vente '),
(339, 'add_sell', 'Add Sell', 'Ajouter Vente'),
(340, 'edit_sell', 'Edit Sell', ''),
(341, 'account_active_mail', 'Please check Email to activate your account', 'Activer votre mail'),
(342, 'accept_terms_privacy', 'Crypto Privacy policy and Terms of Use', 'Accepter conditions et termes'),
(343, 'username_used', 'Username Already Used', 'Nom d\'utilisateur d?j? utilis?'),
(344, 'account_create_success_social', 'Account Created Successfully and Your Account activated', 'Compte cr?e avec succ?s'),
(345, 'email_used', 'Email Already Used', 'Adresse mail d?j? utilis?'),
(346, 'account_create_active_link', 'Account Created Successfully. Activation link send your Email address', 'Lien d\'activation'),
(347, 'active_account', 'Active Account', 'Compte actif'),
(348, 'wrong_try_activation', 'Wrong Try', 'Mauvaise activation'),
(349, 'pay_now', 'Pay Now', 'Payer maintenant'),
(350, 'payment_successfully', 'Payment Successfully', 'Paiement effectu?'),
(351, 'sell_successfully', 'Sell Successfully', 'Vente effectu?e avec succ?s'),
(352, 'already_clicked', 'Already Clicked There', 'D?ja Valid?'),
(353, 'user_info', 'User Info', 'info utilisateur'),
(354, 'user_id', 'User ID', 'ID utilisateur'),
(355, 'registered_ip', 'Registered IP', ''),
(356, 'requested_ip', 'Requested IP', ''),
(357, 'transaction_status', 'Transaction Status', 'Status de la transaction'),
(358, 'receive_status', 'receive_status', ''),
(359, 'receive_complete', 'Receive Complete', ''),
(360, 'payment_status', 'Payment Status', 'Status de paiement'),
(361, 'payment_complete', 'Payment Complete', 'Paiement complet'),
(362, 'url', 'URL', 'url'),
(363, 'app_id', 'App ID', 'ID appli'),
(364, 'app_secret', 'App Secret', 'Secret Appli'),
(365, 'api_key', 'API Key', 'Cl? API'),
(366, 'app_name', 'App Name', 'Nom Appli'),
(367, 'social_list', 'Social List', ''),
(368, 'select_payment_method', 'Select Payment Method', 'Selectionner mode de paiement'),
(369, 'payable', 'Payable', ''),
(370, 'rate', 'Rate', 'Taux'),
(371, 'how_do_you_receive_money', 'How do you receive money', 'Comment Re?evoir votre argent'),
(372, 'withdraw_method', 'Withdraw Method', 'Methode de retrait'),
(373, 'select_withdraw_method', 'Select Withdraw Method', 'Selectionner m?thode de retrait'),
(374, 'account_info', 'Account Info', 'Info compte'),
(375, 'upload_docunemts', 'Upload Docunemts', 'Ajouter fichier'),
(376, 'my_generation', 'My Generation', 'Mon Equipe'),
(377, 'category', 'Category', 'Cat?gorie'),
(378, 'slider_h1_en', 'Slider H1 English', ''),
(379, 'slider_h1_fr', 'Slider H1 French', ''),
(380, 'slider_h2_en', 'Slider H2 English', ''),
(381, 'slider_h2_fr', 'Slider H2 French', ''),
(382, 'slider_h3_en', 'Slider H3 English', ''),
(383, 'slider_h3_fr', 'Slider H3 French', ''),
(384, 'complete', 'Complete', 'Complet'),
(385, 'refresh_currency', 'Refresh Currency', ''),
(386, 'cryptocurrency', 'Crypto Currency', 'Crypto Monnaie'),
(387, 'symbol', 'Symbol', 'Symbole'),
(388, 'please_select_cryptocurrency_first', 'Please Select CryptoCurrency First', 'Veuillez choisir une crypto monnaie'),
(389, 'please_select_diffrent_payment_method', 'Please select Diffrent Payment Method', 'Selectionner une autre m?thode de paiement'),
(390, 'add_credit', 'Add Credit', 'Ajouter Un Crédit'),
(391, 'credit', 'Credit', 'Cr?dit'),
(392, 'credit_list', 'Credit List', 'Liste De Crédit'),
(393, 'notes', 'Note', 'Notes'),
(394, 'my_level_info', 'My Level Info', 'Info Niveau'),
(395, 'slider', 'Slider', 'Slider'),
(396, 'exchange_setting', 'Exchange Setting', 'Paramètre D\'échange'),
(397, 'exchange_all_request', 'Exchange all Request', 'Toutes requ?tes echanges'),
(398, 'total_user', 'Total User', 'Nombre d\'utilisateurs'),
(399, 'total_roi', 'Total ROI', 'Total ROI'),
(400, 'total_commission', 'Total Commission', 'Total commission'),
(401, 'download_pdf', 'Download PDF', 'T?l?charger '),
(402, 'view_all_news', 'View all news', 'Aper?u News'),
(403, 'download_company_brochure', 'Download Company Brochure', 'T?l?chargez notre brochure'),
(404, 'get_in_touch', 'Get in touch', 'Contactez-nous'),
(405, 'read_more', 'Read More', 'Lire plus'),
(406, 'know_more', 'Know more', 'Savoir plus'),
(407, 'choose_plan', 'Choose plan', 'acheter'),
(408, 'latest_jobs', 'Latest Jobs', 'Latest Jobs'),
(409, 'website', 'Website', 'website'),
(410, 'chose_one_of_the_following_methods', 'Chose One of the Following Methods.', 'chose_one_of_the_following_methods.'),
(411, 'sign_in_using_your_email_address', 'Sign in Using Your Email Address', 'Connectez-vous avec votre username ou email'),
(412, 'forgot_password', 'Forgot Password', 'Forgot Password'),
(413, 'remember_me', 'Remember me', 'Remember me'),
(414, 'username_or_email', 'Username or email', 'Username or email'),
(415, 'dont_have_an_account', 'Don\'t have an account', 'Don\'t have an account'),
(416, 'sign_up_now', 'Sign up Now', 'Cr?er un compte maintenant'),
(417, 'send_code', 'Send Code', 'Send Code'),
(418, 'sign_up', 'Sign Up', 'Cr?er un compte'),
(419, 'already_user', 'Already User', 'Already User'),
(420, 'sign_in_now', 'Sign In Now', 'Connectez-vous maintenant'),
(421, 'sign_up_for_free', 'Sign Up For Free', 'Cr?er un compte gratuitement'),
(422, 'join_thousands_of_companies_that_Use_globalcrypt_every_day', 'Join Thousands of Companies that Use Global Crypto Every Day', 'Join Thousands of Companies that Use Global Crypto Every Day'),
(423, 'your_password_at_global_crypto_are_encrypted_and_secured', 'Your Password at Global Crypto are encrypted and Secured', 'Votre mot de passe Global Crypto est crypt? et securis?'),
(424, 'email_username_used', 'Email/Username Already Used', 'Email/Username Already Used'),
(425, 'address', 'Address', 'Address'),
(426, 'phone', 'Phone', 'Phone'),
(427, 'admin_align', 'Admin Align', 'Admin Align'),
(428, 'office_time', 'Office Time', 'Office Time'),
(429, 'logo_web', 'WebSite Logo', 'WebSite Logo'),
(430, 'dashboard_logo', 'Dashboard Logo', 'Dashboard Logo'),
(431, 'advertisement', 'Advertisement', 'Advertisement'),
(432, 'script', 'Script', 'Script'),
(433, 'add_advertisement', 'Add Advertisement', 'Add Advertisement'),
(434, 'page', 'Page', 'Page'),
(435, 'embed_code', 'Embed code', 'Embed code'),
(436, 'add_type', 'Add Type', 'Add Type'),
(437, 'edit_advertisement', 'Edit Advertisement', 'Edit Advertisement'),
(438, 'host', 'Host', 'Host'),
(439, 'port', 'Port', 'Port'),
(440, 'apikey', 'API Key', 'API Key'),
(441, 'mail_type', 'Mail Type', 'Mail Type'),
(442, 'charset', 'Charset', 'Charset'),
(443, 'news', 'News', 'News'),
(444, 'news_list', 'News List', 'Liste Des Nouvelles'),
(445, 'edit_news', 'Edit News', 'Edit News'),
(446, 'post_news', 'Post News', 'Post News'),
(447, 'close', 'Close', 'Close'),
(448, 'contact_us', 'Contact Us', 'Contact Us'),
(449, 'watch_video', 'WATCH VIDEO', 'WATCH VIDEO'),
(450, 'about_bitcoin', 'About Bitcoin', 'About Bitcoin'),
(451, 'get_start', 'Get Start', 'Get Start'),
(452, 'cryptocoins', 'Crypto Coins', 'Crypto Coins'),
(453, 'subscribe_to_our_newsletter', 'Subscribe to our newsletter!', 'Subscribe to our newsletter!'),
(454, 'email_newslatter', 'Email Newsletter', 'Email Newsletter'),
(455, 'services', 'Services', 'Services'),
(456, 'our_company', 'Our Company', 'Our Company'),
(457, 'sign_in', 'Sign In', 'Connectez-vous'),
(458, 'join_the_new_yera_of_cryptocurrency_exchange', 'Join the new Yera of cryptocurrency exchange', 'Join the new Yera of cryptocurrency exchange'),
(459, 'access_the_cryptocurrency_experience_you_deserve', 'Access the cryptocurrency experience you deserve', 'Access the cryptocurrency experience you deserve'),
(460, 'home', 'Home', 'Home'),
(461, 'scroll_to_top', 'Scroll to Top', 'Scroll to Top'),
(462, 'ticker', 'Ticker', 'Ticker'),
(463, 'price', 'Price', 'Price'),
(464, 'capitalization', 'Capitalization', 'Capitalization'),
(465, '1d_change', '1D change', '1D change'),
(466, 'graph_24h', 'Graph 24H', 'Graph 24H'),
(467, 'recent_post', 'Recent Post', 'Recent Post'),
(468, 'my_social_link', 'My Social link', 'My Social link'),
(469, 'tell_us_about_your_project', 'Tell Us About Your Project', 'Tell Us About Your Project'),
(470, 'company', 'Company', 'Company'),
(471, 'reset_your_password', 'Reset Your Password', 'Reset Your Password'),
(472, '24h_change', '24H change', '24H change'),
(473, '24h_volume', '24H Volume', '24H Volume'),
(474, 'latitudelongitude', 'Latitude, Longitude', 'Latitude, Longitude'),
(475, 'send_money', 'Send Money', 'Send Money'),
(476, 'article2', 'Article 2', 'article 2'),
(477, 'contact', 'Contact', 'contact'),
(478, 'team', 'Team', 'Équipe'),
(479, 'client', 'Client', 'client'),
(480, 'service', 'Service', 'service'),
(481, 'testimonial', 'Testimonial', 'Témoignage'),
(482, 'faq', 'F.A.Q', 'faq'),
(483, 'short_description_en', 'Short description english', 'Short Description'),
(484, 'long_description_en', 'Long description English', 'Long Description'),
(485, 'short_description_fr', 'Short description english', 'Short Description'),
(486, 'long_description_fr', 'Long description English', 'Long Description'),
(487, 'info', 'Information', 'Information'),
(488, 'quote', 'Quote', 'Quote'),
(489, 'question_fr', 'Question French', 'Question French'),
(490, 'question_en', 'Question English', 'Question English'),
(491, 'answer_en', 'Answer English', 'Answer English'),
(492, 'answer_fr', 'Answer French', 'Answer French'),
(493, 'content', 'Page Content', 'Page Content'),
(494, 'add_content', 'Add Content', 'Add Content'),
(495, 'edit_content', 'Edit Content', 'Edit Content'),
(496, 'video', 'video (If Youtube Link)', 'video'),
(497, 'add_faq', 'Add F.A.Q', 'Add faq'),
(498, 'add_testimonial', 'Add Testimonial', 'Add testimonial'),
(499, 'add_service', 'Add Service', 'Add service'),
(500, 'add_client', 'Add Client', 'Add client'),
(501, 'add_team', 'Add Team', 'Add team'),
(502, 'add_contact', 'Add Contact', 'Add contact'),
(503, 'add_article', 'Add Article', 'Add article'),
(504, 'edit_article', 'edit Article', 'edit article'),
(505, 'edit_contact', 'edit Contact', 'edit contact'),
(506, 'edit_team', 'edit Team', 'edit team'),
(507, 'edit_client', 'edit Client', 'edit client'),
(508, 'edit_service', 'edit Service', 'edit service'),
(509, 'edit_testimonial', 'edit Testimonial', 'edit testimonial'),
(510, 'edit_faq', 'edit F.A.Q', 'edit faq'),
(511, 'article_list', 'Article List', 'article'),
(512, 'contact_list', 'Contact List', 'contact'),
(513, 'team_list', 'Team List', 'team'),
(514, 'client_list', 'Client List', 'client'),
(515, 'service_list', 'Service List', 'service'),
(516, 'testimonial_list', 'Testimonial List', 'testimonial'),
(517, 'faq_list', 'F.A.Q List', 'faq'),
(518, 'content_list', 'Page Content', 'Page Content'),
(519, 'add_teammember', 'Add Team member', 'Add Team member'),
(520, 'tooltip_package_name', 'Example: Silver Package', 'Example: Silver Package'),
(521, 'tooltip_package_details', 'This is for Package Short Details', 'This is for Package Short Details.'),
(522, 'tooltip_package_amount', 'Package Amount in Dollar. Example: 200', 'Package Amount in Dollar. Example: 200'),
(523, 'tooltip_package_daily_roi', 'Please Set this field with Zero. Example: 0', 'Please Set this field with Zero. Example: 0'),
(524, 'tooltip_package_weekly_roi', 'Who buy this package they will get weekly ROI in Dollar. Example: 5. They will get every week 5 till them package period', 'Who buy this package they will get weekly ROI in Dollar. Example: 5. They will get every week 5 till them package period'),
(525, 'tooltip_package_monthly_roi', 'Sum of weekly ROI in a month', 'Sum of weekly ROI in a month'),
(526, 'tooltip_package_yearly_roi', 'Sum of weekly ROI in a Year', 'Sum of weekly ROI in a Year'),
(527, 'tooltip_package_total_percent_roi', 'Total Persent Of ROI', 'Total Persent Of ROI'),
(528, 'tooltip_package_period', 'Package Period(Day) ex: 365 Day', 'Package Period(Day) ex: 365 Day'),
(529, 'trading', 'Trading', 'Trade'),
(530, 'trade_history', 'Trade History', 'Trade History'),
(531, 'market', 'Market', 'Market'),
(532, 'coin_pair', 'Coin Pair', 'Coin Pair'),
(533, 'pending_deposit', 'Pending Deposit', 'Dépôt En Attente'),
(534, 'email_and_sms_setting', 'Email And Sms Setting', 'Email And Sms Setting'),
(535, 'email_and_sms_gateway', 'Email And Sms Gateway', 'Email And Sms Gateway'),
(536, 'trade', 'Trade', 'Trade'),
(537, 'referral_id', 'Referral ID', ''),
(538, 'please_enter_valid_email', 'Please Enter Valid Email !!!', 'Please Enter Valid Email !!!'),
(539, 'already_subscribe', 'This Email Address already subscribed', 'This Email Address already subscribed'),
(540, 'message_send_successfuly', 'TMessage send successfuly', 'Message send successfuly'),
(541, 'message_send_fail', 'Message send Fail', 'Message send Fail'),
(542, 'setup_payment_gateway', 'setup payment gateway', 'setup payment gateway'),
(543, 'blog', 'Blog', 'Blog'),
(544, 'advisors', 'Advisors', 'Conseillers'),
(545, 'advisors_list', 'Advisors List\r\n', 'Advisors List'),
(546, 'edit_advisors', 'Edit Advisors', 'Edit Advisors'),
(547, 'designation', 'Designation', 'Designation'),
(548, 'user_profile', 'User Profile', 'User Profile'),
(549, 'token_sold', 'Token Sold', 'Token Sold'),
(550, 'token', 'Token', 'Token'),
(551, 'token_value', 'Token Value', 'Token Value'),
(552, 'running', 'Running', 'Fonctionnement'),
(553, 'team_overview', 'Team Overview', 'Team Overview'),
(554, 'overview_header_en', 'Overview Header English', 'Overview Header English'),
(555, 'sub_header_en', 'Sub Header English', 'Sub Header English'),
(556, 'description_en', 'Description English', 'Description English'),
(557, 'overview_header_fr', 'Overview Header French', 'Overview Header French'),
(558, 'sub_header_fr', 'Sub Header French', 'Sub Header French'),
(559, 'description_fr', 'Description French', 'Description French'),
(560, 'flag', 'Flag', 'Flag'),
(561, 'round_name', 'Round Name', 'Round Name'),
(562, 'target', 'Target', 'Target'),
(563, 'coin', 'Coin', 'Coin'),
(564, 'release_date', 'Release Date', 'Release Date'),
(565, 'release_time', 'Release Time', 'Release Time'),
(566, 'duration', 'Duration', 'Duration'),
(567, 'roi', 'ROI', 'ROI'),
(568, 'referral', 'REFERRAL', 'REFERRAL'),
(569, 'total_coin', 'Total Coin', 'Total Coin'),
(570, 'hold_coin', 'Hold Coin', 'Hold Coin'),
(571, 'pre_sell', 'Pre Sell', 'Pre Sell'),
(572, 'sell_available', 'Sell Available', 'Sell Available'),
(573, 'sell_available_limit', 'You can\'t release coin more than sell available limit. ', 'You can\'t release coin more than sell available limit. '),
(574, 'client_id', 'Client Id', 'Client Id'),
(575, 'client_secret', 'Client Secret', 'Client Secret'),
(576, 'live_demo', 'Live demo', 'Live demo'),
(577, 'target_raised', '% target raised', '% target raised'),
(578, 'ends_in', 'ends in:', 'ends in:'),
(579, 'raised', 'Raised', 'Raised'),
(580, 'whitepaper', 'Whitepaper', 'Whitepaper'),
(581, 'soft_cap', 'Soft Cap', 'Soft Cap'),
(582, 'buy_tokens', 'Buy Tokens', 'Buy Tokens'),
(583, 'bonus', 'Bonus', 'Bonus'),
(584, 'how_it_work', 'How it work', 'How it work'),
(585, 'pre_sale', 'Pre-Sale', 'Pre-Sale'),
(586, 'ico_pre_sell_live', 'ICO PRE - SALE IS LIVE', 'ICO PRE - SALE IS LIVE'),
(587, 'password_required', 'Password Required', 'Mot de passe requis'),
(588, 'email_required', 'Email Required', 'Email (requis'),
(589, 'first_name_required', 'First Name Required', 'First Name Required'),
(590, 'last_name_required', 'Last Name Required', 'Last Name Required'),
(591, 'user_name_required', 'User Name Required', 'User Name Required'),
(592, 'please_enter_at_least', 'Please Enter at least 8 Characters input', 'Please Enter at least 8 Characters input'),
(593, 'confirm_password_must_be_filled_out', 'Confirm Password must be filled out', 'Confirm Password must be filled out'),
(594, 'password_miss_match', 'Password miss match', 'Password miss match'),
(595, 'must_confirm_privacy_policy_and_terms_and_condition', 'Must Confirm Privacy Policy and Terms and Conditions', 'Must Confirm Privacy Policy and Terms and Conditions'),
(596, 'please_input_your_email', 'Please Input Your Email', 'Please Input Your Email'),
(597, 'please_enter_valid_email', 'Please Enter Valid Email', 'Please Enter Valid Email'),
(598, 'subscription_complete', 'Subscription complete', 'Subscription complete'),
(599, 'message_send_successfully', 'Message send successfully', 'Message send successfully'),
(600, 'the_clock_has_stopped', 'The clock has stopped', 'The clock has stopped'),
(601, 'a_lowercase_letter', 'A lowercase letter', 'A lowercase letter'),
(602, 'a_capital_uppercase_letter', 'A capital(uppercase) letter', 'A capital(uppercase) letter'),
(603, 'a_special', 'A special', 'A special'),
(604, 'a_number', 'A number', 'A number'),
(605, 'minimum_8_characters', 'Minimum 8 characters', 'Minimum 8 characters'),
(606, 'referral_id_is_invalid', 'Referral ID is invalid', 'Referral ID is invalid'),
(607, 'invalid_ip_address', 'Invalid IP address', 'Invalid IP address'),
(608, 'please_activate_your_account', 'Please activate your account', 'Please activate your account'),
(609, 'already_registered', 'Already registered', 'Already registered'),
(610, 'this_account_is_now_pending', 'This account is now pending', 'This account is now pending'),
(611, 'this_account_is_suspend', 'This account is suspend', 'This account is suspend'),
(612, 'something_wrong', 'Something wrong', 'Something wrong'),
(613, 'first_name', 'First Name', 'First Name'),
(614, 'email_address', 'Email Address', 'Email Address'),
(615, 'password_mismatch', 'password mismatch', 'password mismatch'),
(616, 'invalid_authentication_code', 'Invalid Authentication Code', 'Invalid Authentication Code'),
(617, 'password_reset_code_send_check_your_email', 'Password reset code send.Check your email', 'Password reset code send.Check your email'),
(618, 'google_authentication_disabled', 'Google Authentication Disabled', 'Google Authentication Disabled'),
(619, 'google_authentication_enabled', 'Google Authentication Enabled', 'Google Authentication Enabled'),
(620, 'this_account_already_activated', 'This account already activated', 'This account already activated'),
(621, 'login_or_register', 'Login or Register', 'Login or Register'),
(622, 'social_links', 'social links', 'social links'),
(623, 'ico_pre_sale_is_live', 'ICO PRE - SALE IS LIVE', 'ICO PRE - SALE IS LIVE'),
(624, 'roadmap', 'Roadmap', 'Feuille De Route'),
(625, 'initial_token_distribution', 'Initial Token Distribution', 'Initial Token Distribution'),
(626, 'your_name', 'Your Name', 'Your Name'),
(627, 'send_message', 'Send message', 'Send message'),
(628, 'log_in', 'Log in', 'Log in'),
(629, 'privacy_policy', 'Privacy policy', 'Privacy policy'),
(630, 'terms_of_use', 'Terms of Use', 'Terms of Use'),
(631, 'verification_code', 'Verification code', 'Verification code'),
(632, 'new_password', 'New Password', 'New Password'),
(633, 'this_category_contain_exist', 'This category contain exist', 'This category contain exist'),
(634, 'notice', 'Notice', 'Notice'),
(635, 'update_failed', 'Update Failed', 'Update Failed'),
(636, 'send_the_amount_successfully', 'Send the amount successfully', 'Send the amount successfully'),
(637, 'language_list', 'Language List', 'Language List'),
(638, 'phrase_list', 'Phrase List', 'Phrase List'),
(639, 'language_added_successfully', 'Language added successfully', 'Language added successfully'),
(640, 'edit_phrase', 'Edit Phrase', 'Edit Phrase'),
(641, 'phrase_added_successfully', 'Phrase added successfully', 'Phrase added successfully'),
(642, 'phrase_already_exists', 'Phrase already exists', 'Phrase already exists'),
(643, 'label_added_successfully', 'Label added successfully', 'Label added successfully'),
(644, 'exchange_history', 'Exchange History', 'Exchange History'),
(645, 'exchange_canceled', 'Exchange Canceled', 'Exchange Canceled'),
(646, 'pending_user_list', 'Pending User List', 'Pending User List'),
(647, 'subscriber_list', 'Subscriber List', 'Subscriber List'),
(648, 'pending_user_verify', 'Pending User verify', 'Pending User verify'),
(649, 'affiliation_setup', 'Affiliation Setup', 'Affiliation Setup'),
(650, 'coin_manager', 'Coin Manager', 'Gestionnaire De Pièces'),
(651, 'coin_setup', 'Coin Setup', 'Configuration Des Pièces'),
(652, 'coin_symbol', 'Coin Symbol', 'Coin Symbol'),
(653, 'pair_with', 'Pair With', 'Pair With'),
(654, 'setup_successfully', 'Setup Successfully', 'Setup Successfully'),
(655, 'now_you_cant_change_it', 'Now, you can\'t change it', 'Now, you can\'t change it'),
(656, 'edit_coin_pair', 'Edit coin pair', 'Edit coin pair'),
(657, 'market_symbol', 'Market symbol', 'Market symbol'),
(658, 'cron_jobs', 'Cron Jobs', 'Cron Jobs'),
(659, 'command', 'Command', 'Command'),
(660, 'interval_sec', 'Interval sec', 'Interval sec'),
(661, 'edit_cron_jobs', 'Edit Cron Jobs', 'Edit Cron Jobs'),
(662, 'helpline', 'Helpline', 'Helpline'),
(663, 'menu_control', 'Menu Control', 'Contrôle Des Menus'),
(664, 'white_paper', 'White Paper', 'Papier Blanc'),
(665, 'coin_release', 'Coin Release', 'Coin Release'),
(666, 'day', 'Day', 'Day'),
(667, 'start_date', 'Start date', 'Start date'),
(668, 'start_time', 'Start time', 'Start time'),
(669, 'edit_coin_release', 'Edit Coin Release', 'Edit Coin_release'),
(670, 'coin_market', 'Coin Market', 'Coin Market'),
(671, 'edit_market', 'Edit Market', 'Edit Market'),
(672, 'exchange_coin', 'Exchange Coin', 'Exchange Coin'),
(673, 'method', 'Method', 'Method'),
(674, 'qty', 'Qty', 'Qty'),
(675, 'feature_is_disable', 'Feature is disable', 'Feature is disable'),
(676, 'bank_information_update_successfully', 'Bank Information Update Successfully', 'Bank Information Update Successfully'),
(677, 'last_name', 'Last Name', 'Last Name'),
(678, 'there_is_no_phone_number', 'There is no Phone number', 'There is no Phone number'),
(679, 'page_exception', 'Page Exception', 'Page Exception'),
(680, 'token_buy', 'Token Buy', 'Achat De Jetons'),
(681, 'coin_qty', 'Coin qty', 'Coin qty'),
(682, 'server_problem', 'Server Problem', 'Server Problem'),
(683, 'buy_successful', 'Buy Successful', 'Buy Successful'),
(684, 'you_dont_have_sufficient_balance', 'You don\'t have sufficient Balance', 'You don\'t have sufficient Balance'),
(685, 'token_list', 'Token List', 'Token List'),
(686, 'verify_account', 'Verify Account', 'Verify Account'),
(687, 'verify_type', 'Verify type', 'Verify type'),
(688, 'gender', 'Gender', 'Gender'),
(689, 'id_number', 'Id number', 'Id number'),
(690, 'verification_is_being_processed', 'Verification Is being Processed', 'Verification Is being Processed'),
(691, 'your_address', 'Your Address', 'Your Address'),
(692, 'payment_canceled', 'Payment Canceled', 'Payment Canceled'),
(693, 'percent', 'Percent', 'Percent'),
(694, 'fixed', 'Fixed', 'Fixed'),
(695, 'market_capacity', 'Market Capacity', 'Market Capacity'),
(696, 'capacity_text', 'Capacity Text', 'Capacity Text'),
(697, 'top_menu', 'Top Menu', 'Top Menu'),
(698, 'footer', 'Footer', 'Footer'),
(699, 'top_and_footer', 'Top and Footer', 'Top and Footer'),
(700, 'full_name', 'Full Name', 'Full Name'),
(701, 'canceled', 'Canceled', 'Canceled'),
(702, 'support', 'Support', 'Support'),
(703, 'fillup_target', 'Fillup Target', 'Fillup Target'),
(704, 'exchange_currency', 'Exchange Currency', 'Exchange Currency'),
(705, 'interval_seconds', 'Interval Seconds', 'Interval Seconds'),
(706, 'start_cron_jobs_date', 'Start Cron Jobs Date', 'Start Cron Jobs Date'),
(707, 'start_cron_jobs_time', 'Start Cron Jobs Time', 'Start Cron Jobs Time'),
(708, 'interval_seconds', 'Interval(seconds)', 'Interval(seconds)'),
(709, 'last_run', 'Last Run', 'Last Run'),
(710, 'next_run', 'Next Run', 'Next Run'),
(711, 'coin_full_name', 'Coin Full Name', 'Coin Full Name'),
(712, 'algorithm', 'Algorithm', 'Algorithm'),
(713, 'rank', 'Rank', 'Rank'),
(714, 'show_home', 'Show Home', 'Show Home'),
(715, 'coin_icon', 'Coin Icon', 'Coin Icon'),
(716, 'iso_code', 'ISO Code', 'ISO Code'),
(717, 'email_notification_settings', 'Email Notification Settings', 'Email Notification Settings'),
(718, 'sms_sending', 'SMS Sending', 'SMS Sending'),
(719, 'for_sms_gateway_use', 'For SMS Gateway Use', 'For SMS Gateway Use'),
(720, 'total_fees', 'Total Fees', 'Total Fees'),
(721, 'market_investment', 'Market Investment', 'Market Investment'),
(722, 'exchange_type', 'Exchange Type', 'Exchange Type'),
(723, 'crypto_qty', 'Crypto Qty', 'Crypto Qty'),
(724, 'crypto_rate', 'Crypto Rate', 'Crypto Rate'),
(725, 'complete_qty', 'Complete Qty', 'Complete Qty'),
(726, 'available_qty', 'Available Qty', 'Available Qty'),
(727, 'payout_cronjob', 'Payout Cronjob', 'Payout Cronjob'),
(728, 'source', 'Source', 'Source'),
(729, 'datetime', 'Datetime', 'Datetime'),
(730, 'download_file', 'Download File', 'Download File'),
(731, 'required_qty', 'Required QTY', 'Required QTY'),
(732, 'required_amount', 'Required Amount', 'Required Amount'),
(733, 'available_amount', 'Available Amount', 'Available Amount'),
(734, 'open', 'Open', 'Open'),
(735, 'language_name', 'Language Name', 'Language Name'),
(736, 'phrase_name', 'Phrase Name', 'Phrase Name'),
(737, 'phrase', 'Phrase', 'Phrase'),
(738, 'add_phrase', 'Add Phrase', 'Add Phrase'),
(739, 'label', 'Label', 'Label'),
(740, 'verify_user', 'Verify User', 'Verify User'),
(741, 'subscriber', 'Subscriber', 'Subscriber'),
(742, 'cms', 'CMS', 'CMS'),
(743, 'chart', 'Chart', 'Graphique'),
(744, 'about_coin', 'About Coin', 'About Coin'),
(745, 'ico_settings', 'ICO settings', 'ICO settings'),
(746, 'coin_releasing', 'Coin Releasing', 'Coin Releasing'),
(747, 'menu_control_settings', 'Menu Control Settings', 'Menu Control Settings'),
(748, 'ico_wallet', 'ICO Wallet', 'ICO Wallet'),
(749, 'callback_url', 'Callback Url', 'Callback Url'),
(750, 'success_url', 'Success Url', 'Success Url'),
(751, 'cancel_url', 'Cancel Url', 'Cancel Url'),
(752, 'upload_document_for_profile_verification', 'Upload Document For Profile Verification', 'Upload Document For Profile Verification'),
(753, 'verification_type', 'Verification Type', 'Verification Type'),
(754, 'surname', 'Surname', 'Surname'),
(755, 'nid', 'NID', 'NID'),
(756, 'upload_document', 'Upload Document', 'Upload Document'),
(757, 'approve', 'Approve', 'Approve'),
(758, 'search', 'Search', 'Search'),
(759, 'transaction_log', 'Transaction Log', 'Transaction Log'),
(760, 'earning_history', 'Earning History', 'Earning History'),
(761, 'transaction', 'Transaction', 'Transaction'),
(762, 'white_paper_pdf', 'White Paper PDF', 'White Paper PDF'),
(763, 'information', 'Information', 'Information'),
(764, 'payment_process', 'Payment Process', 'Payment Process'),
(765, 'summation_of_all_deposit_sell_received_roi_and_referral_amount', 'Summation of all deposit, sell, received, roi and referral amount.', 'Summation of all deposit, sell, received, roi and referral amount.'),
(766, 'summation_of_all_your_buy_and_exchange_calculate_token', 'Summation of all your buy and exchange calculate token', 'Summation of all your buy and exchange calculate token'),
(767, 'multiplication_of_all_token_and_token_rate', 'Multiplication of all token and token rate', 'Multiplication of all token and token rate'),
(768, 'smsbox', 'Smsbox', 'Smsbox'),
(769, 'mailbox', 'Mailbox', 'Mailbox'),
(770, 'help_line', 'Help Line', 'Ligne D\'aide'),
(771, 'see_all_messages', 'See All Messages', 'See All Messages'),
(772, 'view_all', 'View all', 'View all'),
(773, 'payout_setting', 'Payout Setting', 'Payout Setting'),
(774, 'package_payout', 'Package Payout', 'Package Payout'),
(775, 'buy_token', 'Buy Token', 'Acheter Jeton'),
(776, 'wallet_history', 'Wallet History', 'Wallet History'),
(777, 'open_exchange', 'Open Exchange', 'Échange Ouvert'),
(778, 'canceled_exchange', 'Canceled Exchange', 'Échange Annulé'),
(779, 'history', 'History', 'Histoire'),
(780, 'sell_avaiable', 'Sell Avaiable', 'Sell Avaiable'),
(781, 'crypto_balance', 'Crypto Balance', 'Crypto Balance'),
(782, 'buy_coin', 'Buy Coin', 'Buy Coin'),
(783, 'quantity', 'Quantity', 'Quantity'),
(784, 'sell_coin', 'Sell Coin', 'Sell Coin'),
(785, 'market_depth', 'Market Depth', 'Market Depth'),
(786, 'weekly_roi_added', 'Weekly ROI Added', 'Weekly ROI Added'),
(787, 'purchase_order_no', 'Purchase Order No', 'Purchase Order No'),
(788, 'this_page_is_disable', 'This page is disable', 'This page is disable'),
(789, 'payout_no', 'Payout No', 'Payout No'),
(790, 'check_your_email', 'Check your email', 'Check your email'),
(791, 'buy_qty', 'Buy Qty', 'Buy Qty'),
(792, 'transaction_id', 'Transaction ID', 'Transaction ID'),
(793, 'source_address', 'Source Address', 'Source Address'),
(794, 'price_in', 'Price in', 'Price in'),
(795, 'passport', 'Passport', 'Passport'),
(796, 'drivers_license', 'Driver\'s license', 'Driver\'s license'),
(797, 'government_issued_id_card', 'Government-issued ID Card', 'Government-issued ID Card'),
(798, 'given_name', 'Given Name', 'Given Name'),
(799, 'passport_nid_license_number', 'Passport/NID/License Number', 'Passport/NID/License Number'),
(800, 'male', 'Male', 'Male'),
(801, 'female', 'Female', 'Female'),
(802, 'profile_is_verified', 'Profile is Verified', 'Profile is Verified'),
(803, 'verification_cancel', 'Verification Cancel', 'Verification Cancel'),
(804, 'verification_is_processing', 'Verification is Processing', 'Verification is Processing'),
(805, 'withdraw_no', 'Withdraw No', 'Withdraw No'),
(806, 'transfer_no', 'Transfer No', 'Transfer No'),
(807, 'user', 'User', 'User'),
(808, 'edit_teammember', 'Edit Team Member', 'Edit Team Member'),
(809, 'you_did_not_upload_any_file', 'You didn\'t upload any file', 'You didn\'t upload any file'),
(810, 'article2_en', 'Article 2 English', 'Article 2 English'),
(811, 'article2_fr', 'Article 2 French', 'Article 2 FR'),
(812, 'roadmap_list', 'RoadMap List', 'RoadMap List'),
(813, 'add_roadmap', 'Add RoadMap', 'Add RoadMap'),
(814, 'short_description', 'Short Description', 'Short Description'),
(815, 'this_position_is_exists', 'This position is exists.', 'This position is exists.'),
(816, 'cat_title', 'Category Title', 'Category Title'),
(817, 'cat_title2_en', 'Category Title 2 English', 'Category Title 2 English'),
(818, 'invalid_amount', 'Invalid Amount', 'Invalid Amount'),
(819, 'there_is_something_wrong', 'There is something wrong', 'There is something wrong'),
(820, 'buy_request_successfully', 'Buy request successfully', 'Buy request successfully'),
(821, 'sell_request_successfully', 'Sell request successfully', 'Sell request successfully'),
(822, 'testtest', NULL, NULL),
(823, 'create_admin', 'Create Admin', 'Create Admin'),
(824, 'create_user', 'Create User', 'Create User'),
(825, 'create_team', 'Create Team', 'Create Team'),
(826, 'email_gateway_setup', 'Email Gateway Setup', 'Configuration De La Passerelle De Messagerie'),
(827, 'check_your_email_server', 'Check Your Email Server', 'V?rifiez Votre Serveur De Messagerie'),
(828, 'email_gateway', 'Email Gateway', 'Passerelle De Messagerie'),
(829, 'sms_gateway', 'Sms Gateway', 'Passerelle Sms'),
(830, 'email-gateway', 'Email-gateway', 'Passerelle De Messagerie'),
(831, 'sms_gateway_setup', 'Sms Gateway Setup', 'Configuration De La Passerelle SMS'),
(832, 'check_your_sms_gateway', 'Check Your Sms Gateway', 'V?rifiez Votre Passerelle Sms'),
(833, 'mobile_number', 'Mobile Number', 'Num?ro De Portable'),
(834, 'mobile_no', 'Mobile No', 'Mobile Non'),
(835, 'email_sms_template', 'Email Sms Template', 'Mod?le De Courrier ?lectronique SMS'),
(836, 'template_type', 'Template Type', 'Type De Mod?le'),
(837, 'template_english', 'Template English', 'Mod?le Anglais'),
(838, 'template_french', 'Template French', 'Mod?le Fran?ais'),
(839, 'subject_english', 'Subject English', 'Sujet Anglais'),
(840, 'subject_french', 'Subject French', 'Sujet Fran?ais'),
(841, 'email-sms-template', 'Email-sms-template', 'Email-sms-template'),
(842, 'template-update', 'Template-update', 'Mod?le-mise ? Jour'),
(843, 'package-list', 'Package-list', 'Liste De Paquets'),
(844, 'add-package', 'Add-package', 'Add-package'),
(845, 'latest_version', 'Latest Version', 'Derni?re Version'),
(846, 'current_version', 'Current Version', 'Version Actuelle'),
(847, 'kyc', 'KYC', 'KYC'),
(848, 'transfer-confirm', 'Transfer-confirm', 'Transfert-confirmer'),
(849, 'paypal', 'Paypal', 'Pay Pal'),
(850, 'stripe', 'Stripe', 'Bande'),
(851, 'token-list', 'Token List', 'Liste De Jetons'),
(852, 'ico-wallet', 'ICO Wallet', 'Ico-portefeuille'),
(853, 'exchange-history', 'Exchange-history', '?change-histoire'),
(854, 'themes', 'Themes', 'Th?mes'),
(855, 'module', 'Module', 'Module'),
(856, 'add-ons', 'Add-ons', 'Modules Complémentaires'),
(857, 'upload', 'Upload', 'T?l?charger'),
(858, 'add_module', 'Add Module', 'Ajouter Un Module'),
(859, 'download', 'Download', 'T?l?charger'),
(860, 'purchase_key', 'Purchase Key', 'Cl? D\'achat'),
(861, 'overwrite', 'Overwrite', '?craser'),
(862, 'buy_now', 'Buy Now', 'Acheter Maintenant'),
(863, 'theme_name', 'Theme Name', 'Nom Du Th?me'),
(864, 'fdfd', NULL, NULL),
(865, 'coin-setup', 'Coin-setup', 'Monnayeur'),
(866, 'menu-control', 'Menu-control', 'Menu-contr?le'),
(867, 'coin-releasing-list', 'Coin Releasing List', 'Liste-lib?ration-de-pi?ces'),
(868, 'coin-manager', 'Coin-manager', 'Monnayeur'),
(869, 'affiliation', 'Affiliation', 'Affiliation');
INSERT INTO `language` (`id`, `phrase`, `english`, `french`) VALUES
(870, 'payment-gateway', 'Payment-gateway', 'Passerelle De Paiement'),
(871, 'email-sms-settings', 'Email-sms-settings', 'Email-sms-param?tres'),
(872, 'sms-gateway', 'SMS Gateway', 'Passerelle Sms'),
(873, 'fees-setting', 'Fees-setting', 'Tarification'),
(874, 'app-setting', 'App-setting', 'Param?tre D\'application'),
(875, 'addon', 'Addon', 'Ajouter'),
(876, 'theme', 'Theme', 'Theme'),
(877, 'all-package', 'All-package', 'Tout-paquet'),
(878, 'package-payout', 'Package-payout', 'Package-paiement'),
(879, 'mypackage', 'Mypackage', 'Mon Colis'),
(880, 'credit-list', 'Credit-list', 'Liste De Cr?dit'),
(881, 'add-credit', 'Add-credit', 'Ajouter Un Cr?dit'),
(882, 'deposit-list', 'Deposit-list', 'Liste De D?p?t'),
(883, 'pending-deposit', 'Pending-deposit', 'D?p?t En Attente'),
(884, 'withdraw-list', 'Withdraw-list', 'Retrait-liste'),
(885, 'pending-withdraw', 'Pending-withdraw', 'En Attente-retrait'),
(886, 'add-admin', 'Add-admin', 'Ajouter-admin'),
(887, 'admin-list', 'Admin-list', 'Liste-admin'),
(888, 'subscriber-list', 'Subscriber-list', 'Liste D\'abonn?s'),
(889, 'verify-user', 'Verify-user', 'V?rifier-utilisateur'),
(890, 'user-list', 'User-list', 'Liste D\'utilisateur'),
(891, 'add-user', 'Add-user', 'Ajouter-utilisateur'),
(892, 'web-language-list', 'Web-language-list', 'Liste-langue-web'),
(893, 'advertisement-list', 'Advertisement List', 'Liste D\'annonces'),
(894, 'social-link-list', 'Social-link-list', 'Liste De Liens Sociaux'),
(895, 'category-list', 'Category List', 'Liste-cat?gorie'),
(896, 'news-list', 'News-list', 'Liste De Nouvelles'),
(897, 'aboutcoin', 'About Coin', 'À Propos De La Monnaie'),
(898, 'page-content-list', 'Page-content-list', 'Liste-contenu-page'),
(899, 'ico-settings', 'ICO-settings', 'ICO-param?tres'),
(900, 'white-paper', 'White-paper', 'Papier Blanc'),
(901, 'helpline-message', 'Helpline-message', 'Helpline-message'),
(902, 'autoupdate', 'Autoupdate', 'Mise ? Jour Automatique'),
(903, 'customer', 'Customer', 'Client'),
(904, 'language-setting', 'Language-setting', 'Param?tres De Langue'),
(905, 'change-password', 'Change Password', 'Changer Le Mot De Passe'),
(906, 'verify-account', 'Verify-account', 'V?rifier Le Compte'),
(907, 'payment-method-setting', 'Payment-method-setting', 'Configuration-mode-de-paiement'),
(908, 'transactions', 'Transactions', 'Transactions'),
(909, 'exchange-opened', 'Exchange-opened', 'Bourse Ouverte'),
(910, 'notifications', 'Notifications', 'Avis'),
(911, 'notification-list', 'Notification-list', 'Liste-de-notification'),
(912, 'message-list', 'Message-list', 'Liste De Messages'),
(913, 'help-line', 'Help-line', 'Ligne D\'aide'),
(914, 'please_wait', 'Please wait', 'S\'il Vous Pla?t, Attendez'),
(915, 'accounts', 'Accounts', 'Comptes'),
(916, 'password_change', 'Password Change', 'Changement De Mot De Passe'),
(917, 'credit_details', 'Credit Details', 'Détails De Crédit'),
(918, 'credit-details', 'Credit Details', NULL),
(919, 'enter_default_password', 'Enter Default Password', 'Enter Default Password'),
(920, 'old_password', 'Old Password', 'Old Password'),
(921, 'confirm_password', 'Confirm Password', 'Confirm Password'),
(922, 'gourl', 'Gourl', 'Gourle'),
(923, 'add_theme', 'Add Theme', 'Ajouter Un Thème'),
(924, 'page_content', 'Page Content', 'Contenu De La Page'),
(925, 'f.a.q', 'F.A.Q', 'FAQ'),
(926, 'category_list', 'Category List', 'Liste Des Catégories'),
(927, 'social_link_list', 'Social Link List', 'Liste De Liens Sociaux'),
(928, 'advertisement_list', 'Advertisement List', 'Liste Des Publicités'),
(929, 'web_language_list', 'Web Language List', 'Liste Des Langues Web'),
(930, 'coinpayment', 'Coinpayment', 'Paiement Par Pièces'),
(931, 'cancelled', 'Cancelled', 'Annulé'),
(932, 'ico_setting', 'ICO Setting', 'Réglage Ico'),
(933, 'coin_releasing_list', 'Coin Releasing List', 'Liste De Libération De Pièces'),
(934, 'install', 'Install', NULL),
(935, 'erc20_wallet', 'ERC20 Wallet', 'Portefeuille ERC20'),
(936, 'erc20_private_key', 'ERC20 Private Key', 'Clé Privée ERC20'),
(937, 'minters_wallet', 'Minters Wallet', 'Portefeuille Minters'),
(938, 'admin_password', 'Admin Password', 'Mot De Passe D\'administrateur'),
(939, 'erc20', 'ERC20', 'ERC20'),
(940, 'admin_wallet', 'Admin Wallet', 'Portefeuille Administrateur'),
(941, 'erc20_coin', 'ERC20 Coin', 'Pièce ERC20'),
(942, 'contact_address', 'Contract Address', 'Adresse De Contract'),
(943, 'creator_wallet', 'Creator Address', ''),
(944, 'coin_symbol', 'Coin Symbol', ''),
(945, 'initial_price', 'Initial Price', ''),
(946, 'coin_logo', 'Coin Logo', 'Logo De Pièce De Monnaie'),
(947, 'available_serial', 'Available Serial', 'Série Disponible'),
(948, 'add_erc20_coin', 'Add ERC20 Coin', 'Ajouter Une Pièce ERC20'),
(949, 'erc20_market', 'ERC20 Market', 'Marché ERC20'),
(950, 'erc20_coin_pair', 'ERC20 Coin Pair', 'Paire De Pièces ERC20'),
(951, 'contract_address', 'Contract Address', 'Adresse de contact'),
(952, 'creator', 'Creator', 'CrÃ©ateur'),
(953, 'proof_type', 'Proof Type', 'Preuve Type'),
(954, 'add_coin', 'Add Coin', 'Ajouter une piÃ¨ce'),
(955, 'token_symbol', 'Token Symbol', 'Token Symbol'),
(956, 'decimal_value', 'Decimal Value', 'valeur dÃ©cimale'),
(957, 'creator_address', 'Creator Address', 'Adresse Du Créateur'),
(958, 'deposit_confirm', 'Deposit Confirm', 'Dépôt Confirmer'),
(959, 'balance_receive_from_user', 'Balance Receive From User', 'Solde Reçu De L\'utilisateur'),
(960, 'sent_user_balance', 'Sent User Balance', 'Solde De L\'utilisateur Envoyé'),
(961, 'decimal', 'Decimal', 'Décimal'),
(962, 'supply', 'Supply', 'La Fourniture'),
(963, 'position', 'Position', 'Positionner'),
(964, 'create_erc20_wallet', 'Admin ERC20 Wallet Setup', 'Créer Un Portefeuille ERC20'),
(965, 'server_ip', 'Server IP', 'IP Du Serveur'),
(966, 'database_name', 'Database Name', 'Nom De La Base De Données'),
(967, 'user_name', 'User Name', 'Nom D\'utilisateur'),
(968, 'infura_id', 'Infura ID', 'Identifiant Infura'),
(969, 'minimum_amount', 'Minimum Amount', 'Montant Minimal'),
(970, 'maximum_amount', 'Maximum Amount', 'Quantité Maximale'),
(971, 'documentation', 'Documentations', 'Documentations'),
(972, 'note', 'Note', 'Noter'),
(973, 'you_can_use_above_link_for_cron_job_copy_and_past_at_cron_job_command_box', 'You Can Use Above Link For Cron Job. Copy And Past At Cron Job Command Box', 'Vous Pouvez Utiliser Le Lien Ci-dessus Pour Le Travail Cron. '),
(974, 'set_cron_job_once_per_2_minutes', 'Set Cron Job Once Per 2 Minutes', 'Définir La Tâche Cron Une Fois Toutes Les 2 Minutes'),
(975, 'set_cron_job_once_per_5_minutes', 'Set Cron Job Once Per 5 Minutes', 'Définir La Tâche Cron Une Fois Toutes Les 5 Minutes'),
(976, 'initial', 'Initial', 'Initiale'),
(977, 'create_your_infura_account', 'Create Your Infura Account', 'Créez Votre Compte Infura'),
(978, 'data_not_found', 'Data Not Found', 'Données Non Trouvées'),
(979, 'fund_received', 'Fund Received', 'Fonds Reçu'),
(980, 'erc20_balance', 'ERC20 Balance', 'Balance ERC20'),
(981, 'erc20_diposit_address', 'ERC20 Diposit Address', 'Adresse De Dépôt ERC20'),
(982, 'please_note', 'Please Note', 'Veuillez Noter'),
(983, 'coins_will_be_deposited_when_you_add_amount_in_this_wallet', 'Coins Will Be Deposited, When You Add Amount In This Wallet', 'Les Pièces Seront Déposées Lorsque Vous Ajoutez Un Montant Dans Ce Portefeuille'),
(984, 'your_transaction_validity_24_hours__please_deposit_this_wallet_immediately', 'Your Transaction Validity 24 Hours  Please Deposit This Wallet Immediately', 'Validité De Votre Transaction 24 Heures Veuillez Déposer Ce Portefeuille Immédiatement'),
(985, 'admin_information', 'Admin Information', 'Admin Information'),
(986, 'add-category', 'Add Category', NULL),
(987, 'menu', 'Menu', NULL),
(988, 'uninstall', 'Uninstall', 'Uninstall'),
(989, 'for_checking_transfer_status', 'For Transfer Checking User Transaction Status', NULL),
(990, 'transaction_type', 'Transaction Type', 'Type De Transaction'),
(991, 'transaction_hash', 'Transaction Hash', 'Hachage De Transaction'),
(992, 'verification_success', 'Verification Success', 'Vérification Réussie'),
(993, 'for_generating_internal_wallet_address', 'For Generating Internal Wallet Address', 'Pour Générer Une Adresse De Portefeuille Interne'),
(994, 'for_sending_coin_to_the_blockchain_network', 'For Sending Coin To The Blockchain Network', 'Pour Envoyer Des Pièces Au Réseau Blockchain'),
(995, 'for_checking_transaction_status', 'For Checking Transaction Status', 'Pour Vérifier L\'état De La Transaction'),
(996, 'rpc_url', 'RPC URL', 'URL RPC'),
(997, 'sent_to_blockchain', 'Sent To Blockchain', 'Envoyé à Blockchain'),
(998, 'export_private_key', 'Export Private Key', 'Export Private Key'),
(999, 'token_transfer', 'Token Transfer', 'Token Transfer'),
(1000, 'transaction_history', 'Transaction History', 'Transaction History'),
(1001, 'testnet', 'Testnet', 'Testnet'),
(1002, 'mainnet', 'Mainnet', 'Mainnet'),
(1003, 'transfer_token', 'Transfer Token', 'Transfer Token'),
(1004, 'sent_quantity', 'Sent Quantity', 'Sent Quantity'),
(1005, 'wallet', 'Wallet Address', NULL),
(1006, 'sent_token', 'Sent Token', NULL),
(1007, 'transfer_request_sent_successfully', 'Transfer Request Sent Successfully', NULL),
(1008, 'for_checking_transfer_status', 'For Transfer Checking User Transaction Status', NULL),
(1009, 'bep20_wallet', 'BEP20 Wallet', 'BEP20 Wallet'),
(1010, 'bep20_private_key', 'BEP20 Private Key', 'BEP20 Private Key'),
(1011, 'import', 'Import', 'Importer'),
(1012, 'networksetting', 'Network Setting', 'Paramètre réseau'),
(1013, 'txn_hash', 'Transaction Hash', 'Transaction Hash'),
(1014, 'receiver_address', 'Receiver Address', NULL);

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

--
-- Table structure for table `menu_control`
--

CREATE TABLE `menu_control` (
  `id` int(11) NOT NULL,
  `ico_wallet` int(11) NOT NULL,
  `exchange` int(11) NOT NULL,
  `package` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `menu_control`
--

INSERT INTO `menu_control` (`id`, `ico_wallet`, `exchange`, `package`) VALUES
(1, 1, 1, 1);

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

--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `receiver_id` varchar(250) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `datetime` datetime NOT NULL,
  `sender_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0=unseen, 1=seen, 2=delete',
  `receiver_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0=unseen, 1=seen, 2=delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `message`
--

INSERT INTO `message` (`id`, `sender_id`, `receiver_id`, `subject`, `message`, `datetime`, `sender_status`, `receiver_status`) VALUES
(1, 1, 'VW5FJE', 'Deposit', 'Hi, bdtask demo You Successfully  Deposit The Amount Is 10.00000000  date 07 February 2022', '2022-02-07 03:31:51', 0, 0),
(2, 1, 'B0TASK', 'Transfer Confirm', 'You successfully transfer The amount $10 to the account B0TASK. Your new balance is 990.7', '2022-02-09 06:53:06', 0, 0);

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

--
-- Table structure for table `module`
--

CREATE TABLE `module` (
  `id` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 NOT NULL,
  `description` text CHARACTER SET utf8 DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `directory` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `notification_id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `date` timestamp NULL DEFAULT NULL,
  `notification_type` varchar(45) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `details` mediumtext DEFAULT NULL,
  `status` varchar(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='SMS and Email notified data will be stored in this table.';

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

--
-- Table structure for table `payeer_payments`
--

CREATE TABLE `payeer_payments` (
  `id` int(11) NOT NULL,
  `m_operation_id` int(11) NOT NULL,
  `m_operation_ps` int(11) NOT NULL,
  `m_operation_date` varchar(100) NOT NULL,
  `m_operation_pay_date` varchar(100) NOT NULL,
  `m_shop` int(11) NOT NULL,
  `m_orderid` varchar(300) NOT NULL,
  `m_amount` varchar(100) NOT NULL,
  `m_curr` varchar(100) NOT NULL,
  `m_desc` varchar(300) NOT NULL,
  `m_status` varchar(100) NOT NULL,
  `m_sign` text NOT NULL,
  `lang` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `payment_gateway`
--

CREATE TABLE `payment_gateway` (
  `id` int(11) NOT NULL,
  `identity` varchar(50) NOT NULL,
  `agent` varchar(100) NOT NULL,
  `public_key` text NOT NULL,
  `private_key` text NOT NULL,
  `shop_id` varchar(100) NOT NULL,
  `secret_key` varchar(100) NOT NULL,
  `data` text NOT NULL,
  `status` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `payment_gateway`
--

INSERT INTO `payment_gateway` (`id`, `identity`, `agent`, `public_key`, `private_key`, `shop_id`, `secret_key`, `data`, `status`) VALUES
(1, 'bitcoin', 'GoUrl Payment', 'a:13:{s:7:\"bitcoin\";s:50:\"43137AACNNeySpeedcoin77SPDPUBaJBxvUGvX7KgmBcx9CGvb\";s:11:\"bitcoincash\";s:0:\"\";s:8:\"litecoin\";s:0:\"\";s:4:\"dash\";s:0:\"\";s:8:\"dogecoin\";s:0:\"\";s:9:\"speedcoin\";s:50:\"43137AACNNeySpeedcoin77SPDPUBaJBxvUGvX7KgmBcx9CGvb\";s:8:\"reddcoin\";s:0:\"\";s:7:\"potcoin\";s:0:\"\";s:11:\"feathercoin\";s:0:\"\";s:8:\"vertcoin\";s:0:\"\";s:8:\"peercoin\";s:0:\"\";s:12:\"monetaryunit\";s:0:\"\";s:17:\"universalcurrency\";s:0:\"\";}', 'a:13:{s:7:\"bitcoin\";s:50:\"43137AACNNeySpeedcoin77SPDPRVyzic8CEewfdazdv9HwdH2\";s:11:\"bitcoincash\";s:0:\"\";s:8:\"litecoin\";s:0:\"\";s:4:\"dash\";s:0:\"\";s:8:\"dogecoin\";s:0:\"\";s:9:\"speedcoin\";s:50:\"43137AACNNeySpeedcoin77SPDPRVyzic8CEewfdazdv9HwdH2\";s:8:\"reddcoin\";s:0:\"\";s:7:\"potcoin\";s:0:\"\";s:11:\"feathercoin\";s:0:\"\";s:8:\"vertcoin\";s:0:\"\";s:8:\"peercoin\";s:0:\"\";s:12:\"monetaryunit\";s:0:\"\";s:17:\"universalcurrency\";s:0:\"\";}', '', '', '', 1),
(2, 'payeer', 'Payeer', '474181962', 'xOngnN7CMIx6w5S3', '', '', '', 0),
(3, 'phone', 'Mobile Money', '+880 1746 40 68 01', '', '', '', '', 1),
(4, 'paypal', 'Paypal', 'AfmTkhn-GYb_HAsPayWeLDVTG39jNjGsJ3siJSNDs6QGr52KDLnAT28fIv4TVni5P3Dax8w1y-Libl_j', 'EHGJveSf9GJcbyQwgYmouRi9baBPKLPqeSYjYesiG4UJTSnQ45q3gwQdkB6TvFQAjkYm42D1P_Hqn340', '', 'sandbox', '', 1),
(5, 'stripe', 'Stripe', 'pk_test_BPLwYal0sn4KkKaDTzuj5oRq', 'sk_test_6J6dcwXf8ruEZGCvlC09C9NK', '', '', '', 1),
(6, 'coinpayment', 'CoinPayments', '0ef5d693629164125849eee7f24deeea058fde91a232b3091525724a480c2c34', '0e1Efced49C5e902a4abF65A01e4F41c040f58aa48f4A6b041e0508D45dc1164', '', '', '{\"marcent_id\":\"f8224829cda4268f107089fd92a469c6\",\"ipn_secret\":\"Bdtask@#2021\",\"debug_email\":\"turan.vuiyan@gmail.com\",\"debuging_active\":1,\"withdraw\":\"0\"}', 1);

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

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `setting_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `logo_web` varchar(255) NOT NULL,
  `favicon` varchar(255) DEFAULT NULL,
  `language` varchar(100) DEFAULT NULL,
  `site_align` varchar(50) DEFAULT NULL,
  `footer_text` varchar(255) DEFAULT NULL,
  `time_zone` varchar(100) DEFAULT NULL,
  `latitude` varchar(100) DEFAULT NULL,
  `office_time` varchar(255) DEFAULT NULL,
  `update_notification` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`setting_id`, `title`, `description`, `email`, `phone`, `logo`, `logo_web`, `favicon`, `language`, `site_align`, `footer_text`, `time_zone`, `latitude`, `office_time`, `update_notification`) VALUES
(1, 'Crypto Currency Treading System', 'Bangladesh, Dhaka.', 'info@test.com', '', '///public/upload/settings/5385b510d68935d70ac6374386a40ecd.png', '///public/upload/settings/3e0408b38ca08be14cd13d6db241ed10.png', '///public/upload/settings/ce8cb9255d11ec59b439f808a370a6b5.png', 'english', 'LTR', 'All rights reserved. Made with love by Bdtask', 'Asia/Dhaka', '40.6700, -73.9400', 'Monday - Friday: 08:00 - 22:00\r\nSaturday, Sunday: Closed', 1);

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

--
-- Table structure for table `sms_email_send_setup`
--

CREATE TABLE `sms_email_send_setup` (
  `id` int(11) NOT NULL,
  `method` text NOT NULL,
  `deposit` int(11) DEFAULT NULL,
  `transfer` int(11) DEFAULT NULL,
  `withdraw` int(11) DEFAULT NULL,
  `payout` int(11) DEFAULT NULL,
  `commission` int(11) DEFAULT NULL,
  `team_bonnus` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sms_email_send_setup`
--

INSERT INTO `sms_email_send_setup` (`id`, `method`, `deposit`, `transfer`, `withdraw`, `payout`, `commission`, `team_bonnus`) VALUES
(1, 'email', 0, 0, 0, NULL, NULL, NULL),
(2, 'sms', NULL, 0, 0, NULL, NULL, NULL);

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

--
-- Table structure for table `testing_tb`
--

CREATE TABLE `testing_tb` (
  `sl` int(11) NOT NULL,
  `place` varchar(255) NOT NULL,
  `data` text NOT NULL,
  `datetime` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` tinyint(2) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'website_template', 1, '2021-01-17 11:54:13', '2021-09-04 08:22:11');

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

--
-- Table structure for table `web_article`
--

CREATE TABLE `web_article` (
  `article_id` int(11) NOT NULL,
  `slug` varchar(100) DEFAULT NULL,
  `headline_en` varchar(300) DEFAULT NULL,
  `headline_fr` varchar(300) DEFAULT NULL,
  `article_image` varchar(100) DEFAULT NULL,
  `custom_url` varchar(300) NOT NULL,
  `article1_en` longtext NOT NULL,
  `article1_fr` longtext NOT NULL,
  `article2_en` longtext NOT NULL,
  `article2_fr` longtext NOT NULL,
  `video` varchar(300) DEFAULT NULL,
  `cat_id` int(11) DEFAULT NULL,
  `page_content` int(11) DEFAULT 0 COMMENT 'if this is a Page content set 1 else 0',
  `position_serial` int(11) NOT NULL,
  `publish_date` datetime NOT NULL,
  `publish_by` varchar(20) NOT NULL,
  `edit_history` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `web_article`
--

INSERT INTO `web_article` (`article_id`, `slug`, `headline_en`, `headline_fr`, `article_image`, `custom_url`, `article1_en`, `article1_fr`, `article2_en`, `article2_fr`, `video`, `cat_id`, `page_content`, `position_serial`, `publish_date`, `publish_by`, `edit_history`) VALUES
(1, NULL, 'What is ICO Crypto?', 'What is ICO Crypto?', 'public/upload/766555a4325c61b84cb801635fbe719e.png', '', '<p>ICO Crypto is a platform for the future of funding that powering for the new equity blockchain.</p>\r\n', '', '<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humor, or randomized words which don&#39;t look even slightly believable.</p>\r\n', '', 'https://www.youtube.com/watch?v=RRzrr2oqNPA', 2, 1, 1, '2021-09-06 05:43:11', 'admin@demo.com', 0),
(2, NULL, 'Cryptoland Just Entered the Real World', 'Cryptoland Just Entered the Real World', 'public/upload/71c99062ca8ad956da6c370fe902c8c4.jpg', '', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.<br></p>', '', '', '', 'https://www.youtube.com/watch?v=RRzrr2oqNPA', 1, 1, 1, '2019-01-10 07:19:41', 'admin@demo.com', 0),
(3, '50', '$50', NULL, NULL, '', 'billion USD — excepted revenue of coins by 2020', 'billion USD — excepted revenue of coins by 2020', '', '', NULL, 20, 0, 0, '2021-09-06 07:04:23', 'admin@demo.com', 0),
(4, '150', '150', NULL, NULL, '', 'million potential clients worldwide', 'million potential clients worldwide', '', '', NULL, 20, 0, 0, '2018-12-27 11:46:12', 'admin@demo.com', 0),
(5, '25', '25%', NULL, NULL, '', 'no borders for international payments', 'no borders for international payments', '', '', NULL, 20, 0, 0, '2018-12-27 11:46:38', 'admin@demo.com', 0),
(6, '10x', '10x', NULL, NULL, '', 'faster transaction speed', 'faster transaction speed', '', '', NULL, 20, 0, 0, '2018-12-27 11:46:48', 'admin@demo.com', 0),
(7, NULL, 'Bitcoin public trading launched', 'Bitcoin public trading launched', NULL, '', 'First 1,000 Bitcoins were released to the public, each one costing $0.3', 'First 1,000 Bitcoins were released to the public, each one costing $0.3', '$67,751,058', 'Total Market Capitalization', NULL, 3, 0, 1, '2018-06-27 00:00:00', '', 0),
(8, NULL, 'First peak value for Bitcoin', 'First peak value for Bitcoin', NULL, '', 'First 1,000 Bitcoins were released to the public, each one costing $0.3', 'First 1,000 Bitcoins were released to the public, each one costing $0.3', '$67,751,058', 'Total Market Capitalization', NULL, 3, 0, 3, '2018-07-27 00:00:00', '', 0),
(9, NULL, '$1 billion capitalization', '$1 billion capitalization', NULL, '', 'First 1,000 Bitcoins were released to the public, each one costing $0.3', 'First 1,000 Bitcoins were released to the public, each one costing $0.3', '$67,751,058', 'Total Market Capitalization', NULL, 3, 0, 3, '2018-08-27 00:00:00', '', 0),
(10, NULL, 'Bitcoin worth $1,000', 'Bitcoin worth $1,000', NULL, '', 'First 1,000 Bitcoins were released to the public, each one costing $0.3', 'First 1,000 Bitcoins were released to the public, each one costing $0.3', '$67,751,058', 'Total Market Capitalization', NULL, 3, 0, 1, '2018-09-05 00:00:00', '', 0),
(11, NULL, 'Ripple\'s major gains', 'Ripple\'s major gains', NULL, '', 'First 1,000 Bitcoins were released to the public, each one costing $0.3', 'First 1,000 Bitcoins were released to the public, each one costing $0.3', '$67,751,058', 'Total Market Capitalization', NULL, 3, 0, 5, '2018-09-25 00:00:00', '', 0),
(12, NULL, 'LiteCoin\'s surge', 'LiteCoin\'s surge', NULL, '', 'First 1,000 Bitcoins were released to the public, each one costing $0.3', 'First 1,000 Bitcoins were released to the public, each one costing $0.3', '$67,751,058', 'Total Market Capitalization', NULL, 3, 0, 6, '2018-10-19 00:00:00', '', 0),
(13, NULL, 'Ethereum`s meteoric rise', 'Ethereum`s meteoric rise', NULL, '', 'First 1,000 Bitcoins were released to the public, each one costing $0.3', 'First 1,000 Bitcoins were released to the public, each one costing $0.3', '$67,751,058', 'Total Market Capitalization', NULL, 3, 0, 7, '2018-11-15 00:00:00', '', 0),
(14, NULL, 'Private/Pre Sale', NULL, NULL, '', '60', '#8d62cd', '', '', NULL, 17, 0, 1, '2019-01-09 07:08:29', 'admin@demo.com', 0),
(15, NULL, 'Public ICO', NULL, NULL, '', '10', '#0095eb', '', '', NULL, 17, 0, 2, '2018-12-27 12:08:51', 'admin@demo.com', 0),
(16, NULL, 'Team & Advisor', NULL, NULL, '', '25', '#df0866', '', '', NULL, 17, 0, 3, '2018-12-27 12:09:10', 'admin@demo.com', 0),
(17, NULL, 'Marketing', NULL, NULL, '', '30', '#f68968', '', '', NULL, 17, 0, 4, '2018-12-27 12:10:20', 'admin@demo.com', 0),
(18, NULL, 'Bounty', NULL, NULL, '', '30', '#f2ebce', '', '', NULL, 17, 0, 5, '2018-12-27 12:10:54', 'admin@demo.com', 0),
(19, NULL, 'Crowdsale', NULL, NULL, '', '350', '#09ffdf', '', '', NULL, 18, 0, 1, '2021-08-05 05:49:21', 'admin@demo.com', 0),
(20, NULL, 'Team', NULL, NULL, '', '340', '#f2ebce', '', '', NULL, 18, 0, 2, '2018-12-27 12:23:17', 'admin@demo.com', 0),
(21, NULL, 'Advisore', NULL, NULL, '', '274', '#f68968', '', '', NULL, 18, 0, 3, '2018-12-27 12:23:16', 'admin@demo.com', 0),
(22, NULL, 'Project Reserve', NULL, NULL, '', '234', '#df0866', '', '', NULL, 18, 0, 4, '2018-12-27 12:23:14', 'admin@demo.com', 0),
(23, NULL, 'Mosternodes', NULL, NULL, '', '214', '#0095eb', '', '', NULL, 18, 0, 5, '2018-12-27 12:23:13', 'admin@demo.com', 0),
(24, NULL, 'Mosternodes', NULL, NULL, '', '194', '#f2ebce', '', '', NULL, 18, 0, 6, '2018-12-27 12:23:11', 'admin@demo.com', 0),
(26, NULL, 'JOHN DOE', NULL, '/public/upload/team/37d7c20949ac4bb7752339a848ddd023.jpg', '', '<p>UI Designer</p>\r\n', '<p>UI Designer</p>\r\n', '', '', NULL, 5, 0, 1, '2021-08-05 05:10:31', 'admin@demo.com', 0),
(27, NULL, 'JOHN DOE', NULL, 'public/upload/team/e550079e7c1c92fce88fc18f97d1d1a3.jpg', '', 'UI Designer', 'UI Designer', '', '', NULL, 5, 0, 2, '2018-12-27 12:35:33', 'admin@demo.com', 0),
(28, NULL, 'JOHN DOE', NULL, 'public/upload/team/2ea5dcd56cbf07857c5e779bc2aac6e7.jpg', '', 'UI Designer', 'UI Designer', '', '', NULL, 5, 0, 3, '2018-12-27 12:36:05', 'admin@demo.com', 0),
(29, NULL, 'JOHN DOE', NULL, 'public/upload/team/f578a4cea754be444f1c1d1ce18f9374.jpg', '', 'UI Designer', 'UI Designer', '', '', NULL, 5, 0, 4, '2018-12-27 12:36:17', 'admin@demo.com', 0),
(30, NULL, 'JOHN DOE', NULL, 'public/upload/team/9aca2d83fb6df075638512b3da11315f.jpg', '', 'UI Designer', 'UI Designer', '', '', NULL, 5, 0, 5, '2018-12-27 12:36:29', 'admin@demo.com', 0),
(31, NULL, 'JOHN DOE', NULL, 'public/upload/team/4d44c8efc5bb01a1a6b8d104483c6b0a.jpg', '', 'UI Designer', 'UI Designer', '', '', NULL, 5, 0, 6, '2018-12-27 12:36:44', 'admin@demo.com', 0),
(32, NULL, 'JOHN DOE', NULL, 'public/upload/team/cc5c6257e80f0f39c0f81f149ca8fb44.jpg', '', 'UI Designer', 'UI Designer', '', '', NULL, 5, 0, 7, '2018-12-27 12:37:36', 'admin@demo.com', 0),
(33, NULL, 'JOHN DOE', NULL, 'public/upload/team/6fd3f95f0aa92740ebec2c002945bbae.jpg', '', 'UI Designer', 'UI Designer', '', '', NULL, 5, 0, 8, '2018-12-27 12:37:59', 'admin@demo.com', 0),
(34, NULL, 'JOHN DOE', NULL, 'public/upload/team/c1b56d81f4a915333209fafa0f960d60.jpg', '', 'UI Designer', 'UI Designer', '', '', NULL, 5, 0, 9, '2018-12-27 12:38:16', 'admin@demo.com', 0),
(35, NULL, 'JOHN DOE', NULL, '/public/upload/advisors/1632049512_cc1bd1d26ee48420f7ea.jpg', '', 'Bitcoin Expert', '#', '#', '#', NULL, 15, 0, 1, '2021-09-19 05:05:13', 'admin@demo.com', 0),
(36, NULL, 'JOHN DOE', NULL, 'public/upload/advisors/6a0dc87a2fb87a7b04fe4fcd1139f2ab.jpg', '', 'Software Enginer', '#', '#', '#', NULL, 15, 0, 2, '2018-12-27 12:41:07', 'admin@demo.com', 0),
(37, NULL, 'JOHN DOE', NULL, 'public/upload/advisors/c6423366875ca03549428d44ecf59e0f.jpg', '', 'Bitcoin Mining Exparts', '#', '#', '#', NULL, 15, 0, 3, '2018-12-27 12:42:15', 'admin@demo.com', 0),
(38, NULL, 'JOHN DOE', NULL, 'public/upload/advisors/8bf34014a827ae5ff1b908fb8b14a111.jpg', '', 'Bitcoin Mining Exparts', '#', '#', '#', NULL, 15, 0, 4, '2018-12-27 12:41:47', 'admin@demo.com', 0),
(39, NULL, 'What is WordPress?', 'What is WordPress?', NULL, '', 'WordPress is open source web software that you can install on your web server to create your website, blog, community, or network. WordPress started out as a tool for blogging, but has evolved into a full-fledged Content Management System (CMS), capable of powering websites, networks, and communities.', 'WordPress is open source web software that you can install on your web server to create your website, blog, community, or network. WordPress started out as a tool for blogging, but has evolved into a full-fledged Content Management System (CMS), capable of powering websites, networks, and communities.', '', '', NULL, 12, 0, 0, '2018-12-27 12:44:14', 'admin@demo.com', 0),
(40, NULL, 'How do you know when it is time to get support?', 'How do you know when it is time to get support?', NULL, '', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Reprehenderit, ipsum, fuga, in, obcaecati magni ullam nobis voluptas fugiat tenetur voluptatum quas tempora maxime rerum neque deserunt suscipit provident cumque et mollitia ex aspernatur porro minus sapiente voluptatibus eos at perferendis repellat odit aliquid harum molestias ratione pariatur adipisci. Aliquid, iure.', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Reprehenderit, ipsum, fuga, in, obcaecati magni ullam nobis voluptas fugiat tenetur voluptatum quas tempora maxime rerum neque deserunt suscipit provident cumque et mollitia ex aspernatur porro minus sapiente voluptatibus eos at perferendis repellat odit aliquid harum molestias ratione pariatur adipisci. Aliquid, iure.', '', '', NULL, 12, 0, 0, '2018-12-27 12:45:18', 'admin@demo.com', 0),
(41, NULL, 'What payment methods do you accept?', 'What payment methods do you accept?', NULL, '', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Reprehenderit, ipsum, fuga, in, obcaecati magni ullam nobis voluptas fugiat tenetur voluptatum quas tempora maxime rerum neque deserunt suscipit provident cumque et mollitia ex aspernatur porro minus sapiente voluptatibus eos at perferendis repellat odit aliquid harum molestias ratione pariatur adipisci. Aliquid, iure.', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Reprehenderit, ipsum, fuga, in, obcaecati magni ullam nobis voluptas fugiat tenetur voluptatum quas tempora maxime rerum neque deserunt suscipit provident cumque et mollitia ex aspernatur porro minus sapiente voluptatibus eos at perferendis repellat odit aliquid harum molestias ratione pariatur adipisci. Aliquid, iure.', '', '', NULL, 12, 0, 0, '2018-12-27 12:45:39', 'admin@demo.com', 0),
(42, NULL, 'Where can I see which insurance plans are?', 'Where can I see which insurance plans are?', NULL, '', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Reprehenderit, ipsum, fuga, in, obcaecati magni ullam nobis voluptas fugiat tenetur voluptatum quas tempora maxime rerum neque deserunt suscipit provident cumque et mollitia ex aspernatur porro minus sapiente voluptatibus eos at perferendis repellat odit aliquid harum molestias ratione pariatur adipisci. Aliquid, iure.', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Reprehenderit, ipsum, fuga, in, obcaecati magni ullam nobis voluptas fugiat tenetur voluptatum quas tempora maxime rerum neque deserunt suscipit provident cumque et mollitia ex aspernatur porro minus sapiente voluptatibus eos at perferendis repellat odit aliquid harum molestias ratione pariatur adipisci. Aliquid, iure.', '', '', NULL, 13, 0, 0, '2018-12-27 12:46:23', 'admin@demo.com', 0),
(43, NULL, 'How do you know when it is time to get support?', 'How do you know when it is time to get support?', NULL, '', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Reprehenderit, ipsum, fuga, in, obcaecati magni ullam nobis voluptas fugiat tenetur voluptatum quas tempora maxime rerum neque deserunt suscipit provident cumque et mollitia ex aspernatur porro minus sapiente voluptatibus eos at perferendis repellat odit aliquid harum molestias ratione pariatur adipisci. Aliquid, iure.', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Reprehenderit, ipsum, fuga, in, obcaecati magni ullam nobis voluptas fugiat tenetur voluptatum quas tempora maxime rerum neque deserunt suscipit provident cumque et mollitia ex aspernatur porro minus sapiente voluptatibus eos at perferendis repellat odit aliquid harum molestias ratione pariatur adipisci. Aliquid, iure.', '', '', NULL, 13, 0, 0, '2018-12-27 12:46:45', 'admin@demo.com', 0),
(44, NULL, 'What payment methods do you accept?', 'What payment methods do you accept?', NULL, '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Reprehenderit, ipsum, fuga, in, obcaecati magni ullam nobis voluptas fugiat tenetur voluptatum quas tempora maxime rerum neque deserunt suscipit provident cumque et mollitia ex aspernatur porro minus sapiente voluptatibus eos at perferendis repellat odit aliquid harum molestias ratione pariatur adipisci. Aliquid, iure.</p>\r\n', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Reprehenderit, ipsum, fuga, in, obcaecati magni ullam nobis voluptas fugiat tenetur voluptatum quas tempora maxime rerum neque deserunt suscipit provident cumque et mollitia ex aspernatur porro minus sapiente voluptatibus eos at perferendis repellat odit aliquid harum molestias ratione pariatur adipisci. Aliquid, iure.</p>\r\n', '', '', NULL, 14, 0, 0, '2021-08-22 04:27:16', 'admin@demo.com', 0),
(45, NULL, 'Tanzil', NULL, '', '', 'This is the best ICO application', '', 'I strongly recommend it', '', NULL, 11, 0, 0, '2021-09-06 06:21:22', 'admin@demo.com', 0),
(46, NULL, 'WHO ARE WE?', 'WHO ARE WE?', NULL, '', 'Meet the Entire Team', 'Meet the Entire Team', 'Lorem ipsum dolor, sit amet consectetur adipisicing elit. Adipisci quae nesciunt officia! Autem, nam eum voluptatem, esse voluptatibus deleniti tempora laboriosam sequi pariatur, explicabo itaque.', 'Lorem ipsum dolor, sit amet consectetur adipisicing elit. Adipisci quae nesciunt officia! Autem, nam eum voluptatem, esse voluptatibus deleniti tempora laboriosam sequi pariatur, explicabo itaque.', NULL, NULL, 0, 0, '2021-09-06 06:22:12', '', 0),
(47, NULL, 'JHON DOE', NULL, '/public/upload/team/1632049110_a0e4dec746bb8af97b2b.jpg', '', '', '', '', '', NULL, 5, 0, 11, '2021-09-19 04:58:30', 'admin@demo.com', 0),
(48, NULL, 'JHON DOE', NULL, NULL, '', '', '', 'Best ICO application', '', NULL, 11, 0, 0, '2021-09-06 06:22:12', 'admin@demo.com', 0),
(49, NULL, 'Money Reimagined', 'Money Reimagined', NULL, '', 'Exploring the transformation of value in the digital age.', 'Exploring the transformation of value in the digital age.', '', '', NULL, 3, 0, 4, '2021-09-06 00:00:00', '', 0),
(50, '100', '$100', NULL, NULL, '', 'billion USD — excepted revenue of coins by 2021', 'billion USD — excepted revenue of coins by 2020', '', '', NULL, 20, 0, 0, '2021-09-06 07:04:51', 'admin@demo.com', 0);

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

--
-- Table structure for table `web_category`
--

CREATE TABLE `web_category` (
  `cat_id` int(11) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `cat_name_en` varchar(100) NOT NULL,
  `cat_name_fr` varchar(100) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `cat_image` varchar(300) DEFAULT NULL,
  `cat_title1_en` varchar(100) DEFAULT NULL,
  `cat_title1_fr` varchar(100) DEFAULT NULL,
  `cat_title2_en` varchar(300) DEFAULT NULL,
  `cat_title2_fr` varchar(300) DEFAULT NULL,
  `menu` int(11) DEFAULT NULL COMMENT '1 = Top Menu, 2 = Footer 1, 3 = Footer 2, 4 = Top and Footer 1, 5 = Top and Footer 2, 0 = Not Menu',
  `position_serial` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `web_category`
--

INSERT INTO `web_category` (`cat_id`, `slug`, `cat_name_en`, `cat_name_fr`, `parent_id`, `cat_image`, `cat_title1_en`, `cat_title1_fr`, `cat_title2_en`, `cat_title2_fr`, `menu`, `position_serial`, `status`) VALUES
(1, 'home', 'Home', 'FranÃ§ais', 0, '', '', 'FranÃ§ais', '', '', 0, NULL, 1),
(2, 'about', 'About', 'FranÃ§ais', 0, '', '', '', '', '', 4, 1, 1),
(3, 'roadmap', 'RoadMap', 'FranÃ§ais', 0, '', 'RoadMap', 'RoadMap', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed quis accumsan nisi Ut ut felis congue nisl hendrerit commodo.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed quis accumsan nisi Ut ut felis congue nisl hendrerit commodo.', 5, 2, 1),
(4, 'token', 'Token', 'FranÃ§ais', 0, '', 'Token Distribution', 'Token Distribution', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed quis accumsan nisi Ut ut felis congue nisl hendrerit commodo.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed quis accumsan nisi Ut ut felis congue nisl hendrerit commodo.', 4, 3, 1),
(5, 'team', 'Team', 'FranÃ§ais', 0, '', 'Our Team Member', 'Our Team Member', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed quis accumsan nisi Ut ut felis congue nisl hendrerit commodo.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed quis accumsan nisi Ut ut felis congue nisl hendrerit commodo.', 4, 4, 1),
(6, 'faq', 'FAQ', 'FranÃ§ais', 0, '', 'Frequently Asked Questions', 'Frequently Asked Questions', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed quis accumsan nisi Ut ut felis congue nisl hendrerit commodo.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed quis accumsan nisi Ut ut felis congue nisl hendrerit commodo.', 5, 5, 1),
(7, 'blog', 'Blog', 'FranÃ§ais', 0, '', 'Recent Blogs Posts', 'Recent Blogs Posts', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed quis accumsan nisi Ut ut felis congue nisl hendrerit commodo.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed quis accumsan nisi Ut ut felis congue nisl hendrerit commodo.', 4, 6, 1),
(8, 'contact', 'Contact', 'FranÃ§ais', 0, '', 'For ICO Projects', 'For ICO Projects', 'Coinsurance invests in promising ICO projects. We offer you a funding and access to our community.', 'Coinsurance invests in promising ICO projects. We offer you a funding and access to our community.', 5, 7, 1),
(9, 'ico', 'ICO', 'FranÃ§ais', 7, '', '', '', '', '', 0, NULL, 1),
(10, 'btc', 'BTC', 'FranÃ§ais', 7, '', '', '', '', '', 0, NULL, 1),
(11, 'testimonial', 'Testimonial', '', 0, '', 'Frequently Asked Questions', 'Frequently Asked Questions', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed quis accumsan nisi Ut ut felis congue nisl hendrerit commodo.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed quis accumsan nisi Ut ut felis congue nisl hendrerit commodo.', 0, 0, 1),
(12, 'regular-questation', 'Regular Questation', 'Regular Questation', 6, '', '', '', '', '', 0, 1, 1),
(13, 'clients-questation', 'Clients Questation', '', 6, '', '', '', '', '', 0, 2, 1),
(14, 'trending-questation', 'Trending Questation', '', 6, '', '', '', '', '', 0, 3, 1),
(15, 'advisors', 'Advisors', 'advisors', 0, '', 'Frequently Asked Questions', 'Frequently Asked Questions', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed quis accumsan nisi Ut ut felis congue nisl hendrerit commodo.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed quis accumsan nisi Ut ut felis congue nisl hendrerit commodo.', 0, 0, 1),
(16, 'chart', 'Chart', '', 0, '', '', '', '', '', 0, 0, 1),
(17, 'chart-one', 'Chart one', '', 16, '', '', '', '', '', 0, 0, 1),
(18, 'chart-two', 'Chart two', '', 16, '', '', '', '', '', 0, 2, 1),
(19, 'client', 'Client', 'Client', 2, '', '', '', '', '', 0, 0, 1),
(20, 'aboutcoin', 'AboutCoin', '', 2, '', 'Run Your ICO from Anywhere', 'Run Your ICO from Anywhere', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed quis accumsan nisi Ut ut felis congue nisl hendrerit commodo.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed quis accumsan nisi Ut ut felis congue nisl hendrerit commodo.', 0, 0, 1),
(21, 'coin', 'Coin', 'Pièce de Monnaie', 6, '', '', '', '', '', 0, 0, 1);

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

--
-- Table structure for table `web_language`
--

CREATE TABLE `web_language` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(256) DEFAULT NULL,
  `flag` varchar(256) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `web_language`
--

INSERT INTO `web_language` (`id`, `name`, `flag`) VALUES
(1, 'France', 'fr');

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

--
-- Table structure for table `web_news`
--

CREATE TABLE `web_news` (
  `article_id` int(11) NOT NULL,
  `slug` varchar(100) DEFAULT NULL,
  `headline_en` varchar(300) DEFAULT NULL,
  `headline_fr` varchar(300) DEFAULT NULL,
  `article_image` varchar(100) DEFAULT NULL,
  `custom_url` varchar(300) DEFAULT NULL,
  `article1_en` longtext,
  `article1_fr` longtext,
  `article2_en` longtext,
  `article2_fr` longtext,
  `cat_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `position_serial` int(11) DEFAULT NULL,
  `publish_date` datetime DEFAULT NULL,
  `publish_by` varchar(20) DEFAULT NULL,
  `edit_history` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `web_news`
--

INSERT INTO `web_news` (`article_id`, `slug`, `headline_en`, `headline_fr`, `article_image`, `custom_url`, `article1_en`, `article1_fr`, `article2_en`, `article2_fr`, `cat_id`, `parent_id`, `position_serial`, `publish_date`, `publish_by`, `edit_history`) VALUES
(1, 'true-flip-enters-the-slot-market-with-chains-code', 'True Flip enters the slot market with Chain?s Code', '', 'public/upload/news/bd92f765617da2c82d5cef5c1ebde2d3.jpg', '', '<div>Lorem ipsum dolor sit amet, quo omittam moderatius in, te cum mutat malorum. Autem ullum cu sed. Id per enim deserunt, vel an choro dolores voluptatum. His viderer civibus te, quis vero timeam te mel. Meis nulla nec id. Te eros ubique ius.</div><div><br></div><div>Pri nisl velit at. Ei lobortis forensibus dissentiunt sit, ius idque veritus in, in aeterno invenire usu. Esse inani inermis eam ea. Justo perfecto dignissim an pri, ea sit dico neglegentur, id mundi maiestatis vel. Eos eu stet dicit. Porro suscipiantur id usu, antiopam moderatius sit ne. Ei nulla torquatos ullamcorper sed, no stet graece instructior vel, eirmod vulputate an duo.</div><div><br></div><div>Splendide laboramus eam cu, veritus singulis vel et, essent assentior an vim. Prima paulo ut mei, no tota erat eam. Constituam consequuntur his ad. Ad ius libris labore, ex sumo regione eos. No ius vero apeirian.</div><div><br></div><div>Mollis integre persius ad nam. At agam constituam sit, an mea dolores iracundia conceptam, vis no atqui verear detracto. Et fugit ridens intellegam duo, eu facilisi erroribus duo. Et vix homero verear liberavisse, natum nonumes splendide usu at. Ea vis meliore offendit intellegebat. Ne mazim philosophia usu.</div><div><br></div><div>At mazim tacimates per. Ne reque tractatos mel, at eos case commodo. Cu animal constituam pri, ea nam ceteros copiosae philosophia. Ei modo fuisset pertinax vim, id vis tacimates interpretaris mediocritatem. Vel no esse scripserit, nostrum tacimates his te.</div><div><br></div><div>Corpora postulant voluptatum nam eu. Cum te agam delectus ullamcorper, nostrum perfecto an nam. Ne quo accusata adversarium, illud efficiantur te nam. At veri simul virtute mei, deleniti persecuti te mei. Ludus animal eam cu, an nulla prompta imperdiet vis. Est cu dicam soluta everti.</div><div><br></div><div>Aliquam feugait perfecto per ne, an adolescens sententiae vis, his no noster animal. At vim vidit apeirian appellantur, no graecis invidunt sea. Illud oblique ad ius, eum no partem consectetuer, equidem incorrupte cum cu. At usu docendi tibique evertitur. Duis deserunt pri at. Aeque tempor usu et, ex illum facer efficiendi nam.</div><div><br></div><div>Vel quodsi iracundia ne, eu audiam tibique mnesarchum est. Diam oporteat suavitate pri id. Eos latine euripidis ad, ad mei partem accommodare, nam at elitr vitae voluptaria. Id sea ceteros suscipiantur. Ne per viderer tacimates repudiare, sed id quaestio cotidieque. Ei hinc dolor putent usu, falli lucilius nam at.</div><div><br></div><div>Aperiam detracto qualisque cu sea, sea te deleniti scripserit. Option feugiat sit ei. Labore volumus instructior eos ne, id graecis antiopam assueverit vel, no appetere argumentum eloquentiam quo. Error option dolorum nam cu. Vim tantas populo et, te mea quem quando decore.</div><div><br></div><div>Duo ad elit aperiam. Et error aliquip mea. Cum ut facete assentior, ei vis dictas erroribus salutatus. Mea eu iusto volumus argumentum, sed eu quando regione indoctum.</div>', '', '', '', 10, NULL, 0, '2018-12-27 12:53:21', 'admin@demo.com', 0),
(2, 'bitcoin-in-brief-monday-twitter-wields-the-banhammer', 'Bitcoin in Brief Monday: Twitter Wields the Banhammer', '', 'public/upload/news/c325b409f002e058ddbe9fa5dc07290f.jpg', '', '<div>Lorem ipsum dolor sit amet, quo omittam moderatius in, te cum mutat malorum. Autem ullum cu sed. Id per enim deserunt, vel an choro dolores voluptatum. His viderer civibus te, quis vero timeam te mel. Meis nulla nec id. Te eros ubique ius.</div><div><br></div><div>Pri nisl velit at. Ei lobortis forensibus dissentiunt sit, ius idque veritus in, in aeterno invenire usu. Esse inani inermis eam ea. Justo perfecto dignissim an pri, ea sit dico neglegentur, id mundi maiestatis vel. Eos eu stet dicit. Porro suscipiantur id usu, antiopam moderatius sit ne. Ei nulla torquatos ullamcorper sed, no stet graece instructior vel, eirmod vulputate an duo.</div><div><br></div><div>Splendide laboramus eam cu, veritus singulis vel et, essent assentior an vim. Prima paulo ut mei, no tota erat eam. Constituam consequuntur his ad. Ad ius libris labore, ex sumo regione eos. No ius vero apeirian.</div><div><br></div><div>Mollis integre persius ad nam. At agam constituam sit, an mea dolores iracundia conceptam, vis no atqui verear detracto. Et fugit ridens intellegam duo, eu facilisi erroribus duo. Et vix homero verear liberavisse, natum nonumes splendide usu at. Ea vis meliore offendit intellegebat. Ne mazim philosophia usu.</div><div><br></div><div>At mazim tacimates per. Ne reque tractatos mel, at eos case commodo. Cu animal constituam pri, ea nam ceteros copiosae philosophia. Ei modo fuisset pertinax vim, id vis tacimates interpretaris mediocritatem. Vel no esse scripserit, nostrum tacimates his te.</div><div><br></div><div>Corpora postulant voluptatum nam eu. Cum te agam delectus ullamcorper, nostrum perfecto an nam. Ne quo accusata adversarium, illud efficiantur te nam. At veri simul virtute mei, deleniti persecuti te mei. Ludus animal eam cu, an nulla prompta imperdiet vis. Est cu dicam soluta everti.</div><div><br></div><div>Aliquam feugait perfecto per ne, an adolescens sententiae vis, his no noster animal. At vim vidit apeirian appellantur, no graecis invidunt sea. Illud oblique ad ius, eum no partem consectetuer, equidem incorrupte cum cu. At usu docendi tibique evertitur. Duis deserunt pri at. Aeque tempor usu et, ex illum facer efficiendi nam.</div><div><br></div><div>Vel quodsi iracundia ne, eu audiam tibique mnesarchum est. Diam oporteat suavitate pri id. Eos latine euripidis ad, ad mei partem accommodare, nam at elitr vitae voluptaria. Id sea ceteros suscipiantur. Ne per viderer tacimates repudiare, sed id quaestio cotidieque. Ei hinc dolor putent usu, falli lucilius nam at.</div><div><br></div><div>Aperiam detracto qualisque cu sea, sea te deleniti scripserit. Option feugiat sit ei. Labore volumus instructior eos ne, id graecis antiopam assueverit vel, no appetere argumentum eloquentiam quo. Error option dolorum nam cu. Vim tantas populo et, te mea quem quando decore.</div><div><br></div><div>Duo ad elit aperiam. Et error aliquip mea. Cum ut facete assentior, ei vis dictas erroribus salutatus. Mea eu iusto volumus argumentum, sed eu quando regione indoctum.</div>', '', '', '', 9, NULL, 0, '2018-12-27 12:54:12', 'admin@demo.com', 0),
(3, 'ethereum-price-technical-analysis-ethusd-eyes-more-gains', 'Ethereum Price Technical Analysis ? ETH/USD Eyes More Gains', '', 'public/upload/news/b222d9177c5c522393710d9c10bc0c7f.jpg', '', '<div>Lorem ipsum dolor sit amet, quo omittam moderatius in, te cum mutat malorum. Autem ullum cu sed. Id per enim deserunt, vel an choro dolores voluptatum. His viderer civibus te, quis vero timeam te mel. Meis nulla nec id. Te eros ubique ius.</div><div><br></div><div>Pri nisl velit at. Ei lobortis forensibus dissentiunt sit, ius idque veritus in, in aeterno invenire usu. Esse inani inermis eam ea. Justo perfecto dignissim an pri, ea sit dico neglegentur, id mundi maiestatis vel. Eos eu stet dicit. Porro suscipiantur id usu, antiopam moderatius sit ne. Ei nulla torquatos ullamcorper sed, no stet graece instructior vel, eirmod vulputate an duo.</div><div><br></div><div>Splendide laboramus eam cu, veritus singulis vel et, essent assentior an vim. Prima paulo ut mei, no tota erat eam. Constituam consequuntur his ad. Ad ius libris labore, ex sumo regione eos. No ius vero apeirian.</div><div><br></div><div>Mollis integre persius ad nam. At agam constituam sit, an mea dolores iracundia conceptam, vis no atqui verear detracto. Et fugit ridens intellegam duo, eu facilisi erroribus duo. Et vix homero verear liberavisse, natum nonumes splendide usu at. Ea vis meliore offendit intellegebat. Ne mazim philosophia usu.</div><div><br></div><div>At mazim tacimates per. Ne reque tractatos mel, at eos case commodo. Cu animal constituam pri, ea nam ceteros copiosae philosophia. Ei modo fuisset pertinax vim, id vis tacimates interpretaris mediocritatem. Vel no esse scripserit, nostrum tacimates his te.</div><div><br></div><div>Corpora postulant voluptatum nam eu. Cum te agam delectus ullamcorper, nostrum perfecto an nam. Ne quo accusata adversarium, illud efficiantur te nam. At veri simul virtute mei, deleniti persecuti te mei. Ludus animal eam cu, an nulla prompta imperdiet vis. Est cu dicam soluta everti.</div><div><br></div><div>Aliquam feugait perfecto per ne, an adolescens sententiae vis, his no noster animal. At vim vidit apeirian appellantur, no graecis invidunt sea. Illud oblique ad ius, eum no partem consectetuer, equidem incorrupte cum cu. At usu docendi tibique evertitur. Duis deserunt pri at. Aeque tempor usu et, ex illum facer efficiendi nam.</div><div><br></div><div>Vel quodsi iracundia ne, eu audiam tibique mnesarchum est. Diam oporteat suavitate pri id. Eos latine euripidis ad, ad mei partem accommodare, nam at elitr vitae voluptaria. Id sea ceteros suscipiantur. Ne per viderer tacimates repudiare, sed id quaestio cotidieque. Ei hinc dolor putent usu, falli lucilius nam at.</div><div><br></div><div>Aperiam detracto qualisque cu sea, sea te deleniti scripserit. Option feugiat sit ei. Labore volumus instructior eos ne, id graecis antiopam assueverit vel, no appetere argumentum eloquentiam quo. Error option dolorum nam cu. Vim tantas populo et, te mea quem quando decore.</div><div><br></div><div>Duo ad elit aperiam. Et error aliquip mea. Cum ut facete assentior, ei vis dictas erroribus salutatus. Mea eu iusto volumus argumentum, sed eu quando regione indoctum.</div>', '', '', '', 10, NULL, 0, '2018-12-27 12:54:22', 'admin@demo.com', 0),
(4, 'south-africa-puts-onus-on-taxpayers-to-declare-all-cryptocurrency-income', 'South Africa Puts Onus on Taxpayers to Declare All Cryptocurrency Income', '', 'public/upload/news/166e293c430bdf835f0c6d6a127e4e13.jpg', '', '<div>Lorem ipsum dolor sit amet, quo omittam moderatius in, te cum mutat malorum. Autem ullum cu sed. Id per enim deserunt, vel an choro dolores voluptatum. His viderer civibus te, quis vero timeam te mel. Meis nulla nec id. Te eros ubique ius.</div><div><br></div><div>Pri nisl velit at. Ei lobortis forensibus dissentiunt sit, ius idque veritus in, in aeterno invenire usu. Esse inani inermis eam ea. Justo perfecto dignissim an pri, ea sit dico neglegentur, id mundi maiestatis vel. Eos eu stet dicit. Porro suscipiantur id usu, antiopam moderatius sit ne. Ei nulla torquatos ullamcorper sed, no stet graece instructior vel, eirmod vulputate an duo.</div><div><br></div><div>Splendide laboramus eam cu, veritus singulis vel et, essent assentior an vim. Prima paulo ut mei, no tota erat eam. Constituam consequuntur his ad. Ad ius libris labore, ex sumo regione eos. No ius vero apeirian.</div><div><br></div><div>Mollis integre persius ad nam. At agam constituam sit, an mea dolores iracundia conceptam, vis no atqui verear detracto. Et fugit ridens intellegam duo, eu facilisi erroribus duo. Et vix homero verear liberavisse, natum nonumes splendide usu at. Ea vis meliore offendit intellegebat. Ne mazim philosophia usu.</div><div><br></div><div>At mazim tacimates per. Ne reque tractatos mel, at eos case commodo. Cu animal constituam pri, ea nam ceteros copiosae philosophia. Ei modo fuisset pertinax vim, id vis tacimates interpretaris mediocritatem. Vel no esse scripserit, nostrum tacimates his te.</div><div><br></div><div>Corpora postulant voluptatum nam eu. Cum te agam delectus ullamcorper, nostrum perfecto an nam. Ne quo accusata adversarium, illud efficiantur te nam. At veri simul virtute mei, deleniti persecuti te mei. Ludus animal eam cu, an nulla prompta imperdiet vis. Est cu dicam soluta everti.</div><div><br></div><div>Aliquam feugait perfecto per ne, an adolescens sententiae vis, his no noster animal. At vim vidit apeirian appellantur, no graecis invidunt sea. Illud oblique ad ius, eum no partem consectetuer, equidem incorrupte cum cu. At usu docendi tibique evertitur. Duis deserunt pri at. Aeque tempor usu et, ex illum facer efficiendi nam.</div><div><br></div><div>Vel quodsi iracundia ne, eu audiam tibique mnesarchum est. Diam oporteat suavitate pri id. Eos latine euripidis ad, ad mei partem accommodare, nam at elitr vitae voluptaria. Id sea ceteros suscipiantur. Ne per viderer tacimates repudiare, sed id quaestio cotidieque. Ei hinc dolor putent usu, falli lucilius nam at.</div><div><br></div><div>Aperiam detracto qualisque cu sea, sea te deleniti scripserit. Option feugiat sit ei. Labore volumus instructior eos ne, id graecis antiopam assueverit vel, no appetere argumentum eloquentiam quo. Error option dolorum nam cu. Vim tantas populo et, te mea quem quando decore.</div><div><br></div><div>Duo ad elit aperiam. Et error aliquip mea. Cum ut facete assentior, ei vis dictas erroribus salutatus. Mea eu iusto volumus argumentum, sed eu quando regione indoctum.</div>', '', '', '', 10, NULL, 0, '2018-07-29 01:23:13', 'admin@demo.com', 0),
(5, 'neo-eos-litecoin-iota-and-stellar-technical-analysis-april-9-2018', 'NEO, EOS, Litecoin, IOTA and Stellar: Technical Analysis April 9, 2018', '', 'public/upload/news/b731dbe9143e088de015c0c844d40105.jpg', '', '<div>Lorem ipsum dolor sit amet, quo omittam moderatius in, te cum mutat malorum. Autem ullum cu sed. Id per enim deserunt, vel an choro dolores voluptatum. His viderer civibus te, quis vero timeam te mel. Meis nulla nec id. Te eros ubique ius.</div><div><br></div><div>Pri nisl velit at. Ei lobortis forensibus dissentiunt sit, ius idque veritus in, in aeterno invenire usu. Esse inani inermis eam ea. Justo perfecto dignissim an pri, ea sit dico neglegentur, id mundi maiestatis vel. Eos eu stet dicit. Porro suscipiantur id usu, antiopam moderatius sit ne. Ei nulla torquatos ullamcorper sed, no stet graece instructior vel, eirmod vulputate an duo.</div><div><br></div><div>Splendide laboramus eam cu, veritus singulis vel et, essent assentior an vim. Prima paulo ut mei, no tota erat eam. Constituam consequuntur his ad. Ad ius libris labore, ex sumo regione eos. No ius vero apeirian.</div><div><br></div><div>Mollis integre persius ad nam. At agam constituam sit, an mea dolores iracundia conceptam, vis no atqui verear detracto. Et fugit ridens intellegam duo, eu facilisi erroribus duo. Et vix homero verear liberavisse, natum nonumes splendide usu at. Ea vis meliore offendit intellegebat. Ne mazim philosophia usu.</div><div><br></div><div>At mazim tacimates per. Ne reque tractatos mel, at eos case commodo. Cu animal constituam pri, ea nam ceteros copiosae philosophia. Ei modo fuisset pertinax vim, id vis tacimates interpretaris mediocritatem. Vel no esse scripserit, nostrum tacimates his te.</div><div><br></div><div>Corpora postulant voluptatum nam eu. Cum te agam delectus ullamcorper, nostrum perfecto an nam. Ne quo accusata adversarium, illud efficiantur te nam. At veri simul virtute mei, deleniti persecuti te mei. Ludus animal eam cu, an nulla prompta imperdiet vis. Est cu dicam soluta everti.</div><div><br></div><div>Aliquam feugait perfecto per ne, an adolescens sententiae vis, his no noster animal. At vim vidit apeirian appellantur, no graecis invidunt sea. Illud oblique ad ius, eum no partem consectetuer, equidem incorrupte cum cu. At usu docendi tibique evertitur. Duis deserunt pri at. Aeque tempor usu et, ex illum facer efficiendi nam.</div><div><br></div><div>Vel quodsi iracundia ne, eu audiam tibique mnesarchum est. Diam oporteat suavitate pri id. Eos latine euripidis ad, ad mei partem accommodare, nam at elitr vitae voluptaria. Id sea ceteros suscipiantur. Ne per viderer tacimates repudiare, sed id quaestio cotidieque. Ei hinc dolor putent usu, falli lucilius nam at.</div><div><br></div><div>Aperiam detracto qualisque cu sea, sea te deleniti scripserit. Option feugiat sit ei. Labore volumus instructior eos ne, id graecis antiopam assueverit vel, no appetere argumentum eloquentiam quo. Error option dolorum nam cu. Vim tantas populo et, te mea quem quando decore.</div><div><br></div><div>Duo ad elit aperiam. Et error aliquip mea. Cum ut facete assentior, ei vis dictas erroribus salutatus. Mea eu iusto volumus argumentum, sed eu quando regione indoctum.</div>', '', '', '', 9, NULL, 0, '2018-07-29 01:23:21', 'admin@demo.com', 0),
(6, 'why-invest-in-dash', 'Why Invest in Dash?', '', 'public/upload/news/9d5c09ab5b25569514fa852e2d2c1483.jpg', '', '<div>Lorem ipsum dolor sit amet, quo omittam moderatius in, te cum mutat malorum. Autem ullum cu sed. Id per enim deserunt, vel an choro dolores voluptatum. His viderer civibus te, quis vero timeam te mel. Meis nulla nec id. Te eros ubique ius.</div><div><br></div><div>Pri nisl velit at. Ei lobortis forensibus dissentiunt sit, ius idque veritus in, in aeterno invenire usu. Esse inani inermis eam ea. Justo perfecto dignissim an pri, ea sit dico neglegentur, id mundi maiestatis vel. Eos eu stet dicit. Porro suscipiantur id usu, antiopam moderatius sit ne. Ei nulla torquatos ullamcorper sed, no stet graece instructior vel, eirmod vulputate an duo.</div><div><br></div><div>Splendide laboramus eam cu, veritus singulis vel et, essent assentior an vim. Prima paulo ut mei, no tota erat eam. Constituam consequuntur his ad. Ad ius libris labore, ex sumo regione eos. No ius vero apeirian.</div><div><br></div><div>Mollis integre persius ad nam. At agam constituam sit, an mea dolores iracundia conceptam, vis no atqui verear detracto. Et fugit ridens intellegam duo, eu facilisi erroribus duo. Et vix homero verear liberavisse, natum nonumes splendide usu at. Ea vis meliore offendit intellegebat. Ne mazim philosophia usu.</div><div><br></div><div>At mazim tacimates per. Ne reque tractatos mel, at eos case commodo. Cu animal constituam pri, ea nam ceteros copiosae philosophia. Ei modo fuisset pertinax vim, id vis tacimates interpretaris mediocritatem. Vel no esse scripserit, nostrum tacimates his te.</div><div><br></div><div>Corpora postulant voluptatum nam eu. Cum te agam delectus ullamcorper, nostrum perfecto an nam. Ne quo accusata adversarium, illud efficiantur te nam. At veri simul virtute mei, deleniti persecuti te mei. Ludus animal eam cu, an nulla prompta imperdiet vis. Est cu dicam soluta everti.</div><div><br></div><div>Aliquam feugait perfecto per ne, an adolescens sententiae vis, his no noster animal. At vim vidit apeirian appellantur, no graecis invidunt sea. Illud oblique ad ius, eum no partem consectetuer, equidem incorrupte cum cu. At usu docendi tibique evertitur. Duis deserunt pri at. Aeque tempor usu et, ex illum facer efficiendi nam.</div><div><br></div><div>Vel quodsi iracundia ne, eu audiam tibique mnesarchum est. Diam oporteat suavitate pri id. Eos latine euripidis ad, ad mei partem accommodare, nam at elitr vitae voluptaria. Id sea ceteros suscipiantur. Ne per viderer tacimates repudiare, sed id quaestio cotidieque. Ei hinc dolor putent usu, falli lucilius nam at.</div><div><br></div><div>Aperiam detracto qualisque cu sea, sea te deleniti scripserit. Option feugiat sit ei. Labore volumus instructior eos ne, id graecis antiopam assueverit vel, no appetere argumentum eloquentiam quo. Error option dolorum nam cu. Vim tantas populo et, te mea quem quando decore.</div><div><br></div><div>Duo ad elit aperiam. Et error aliquip mea. Cum ut facete assentior, ei vis dictas erroribus salutatus. Mea eu iusto volumus argumentum, sed eu quando regione indoctum.</div>', '', '', '', 9, NULL, 0, '2018-07-29 01:25:38', 'admin@demo.com', 0),
(7, 'asic-resistance-increasingly-hot-topic-in-crypto-as-monero-forks', 'ASIC Resistance Increasingly Hot Topic in Crypto as Monero Forks', '', 'public/upload/news/32083222f2430503659756a60d3b0b6b.jpg', '', '<div>Lorem ipsum dolor sit amet, quo omittam moderatius in, te cum mutat malorum. Autem ullum cu sed. Id per enim deserunt, vel an choro dolores voluptatum. His viderer civibus te, quis vero timeam te mel. Meis nulla nec id. Te eros ubique ius.</div><div><br></div><div>Pri nisl velit at. Ei lobortis forensibus dissentiunt sit, ius idque veritus in, in aeterno invenire usu. Esse inani inermis eam ea. Justo perfecto dignissim an pri, ea sit dico neglegentur, id mundi maiestatis vel. Eos eu stet dicit. Porro suscipiantur id usu, antiopam moderatius sit ne. Ei nulla torquatos ullamcorper sed, no stet graece instructior vel, eirmod vulputate an duo.</div><div><br></div><div>Splendide laboramus eam cu, veritus singulis vel et, essent assentior an vim. Prima paulo ut mei, no tota erat eam. Constituam consequuntur his ad. Ad ius libris labore, ex sumo regione eos. No ius vero apeirian.</div><div><br></div><div>Mollis integre persius ad nam. At agam constituam sit, an mea dolores iracundia conceptam, vis no atqui verear detracto. Et fugit ridens intellegam duo, eu facilisi erroribus duo. Et vix homero verear liberavisse, natum nonumes splendide usu at. Ea vis meliore offendit intellegebat. Ne mazim philosophia usu.</div><div><br></div><div>At mazim tacimates per. Ne reque tractatos mel, at eos case commodo. Cu animal constituam pri, ea nam ceteros copiosae philosophia. Ei modo fuisset pertinax vim, id vis tacimates interpretaris mediocritatem. Vel no esse scripserit, nostrum tacimates his te.</div><div><br></div><div>Corpora postulant voluptatum nam eu. Cum te agam delectus ullamcorper, nostrum perfecto an nam. Ne quo accusata adversarium, illud efficiantur te nam. At veri simul virtute mei, deleniti persecuti te mei. Ludus animal eam cu, an nulla prompta imperdiet vis. Est cu dicam soluta everti.</div><div><br></div><div>Aliquam feugait perfecto per ne, an adolescens sententiae vis, his no noster animal. At vim vidit apeirian appellantur, no graecis invidunt sea. Illud oblique ad ius, eum no partem consectetuer, equidem incorrupte cum cu. At usu docendi tibique evertitur. Duis deserunt pri at. Aeque tempor usu et, ex illum facer efficiendi nam.</div><div><br></div><div>Vel quodsi iracundia ne, eu audiam tibique mnesarchum est. Diam oporteat suavitate pri id. Eos latine euripidis ad, ad mei partem accommodare, nam at elitr vitae voluptaria. Id sea ceteros suscipiantur. Ne per viderer tacimates repudiare, sed id quaestio cotidieque. Ei hinc dolor putent usu, falli lucilius nam at.</div><div><br></div><div>Aperiam detracto qualisque cu sea, sea te deleniti scripserit. Option feugiat sit ei. Labore volumus instructior eos ne, id graecis antiopam assueverit vel, no appetere argumentum eloquentiam quo. Error option dolorum nam cu. Vim tantas populo et, te mea quem quando decore.</div><div><br></div><div>Duo ad elit aperiam. Et error aliquip mea. Cum ut facete assentior, ei vis dictas erroribus salutatus. Mea eu iusto volumus argumentum, sed eu quando regione indoctum.</div>', '', '', '', 10, NULL, 0, '2018-07-29 01:23:28', 'admin@demo.com', 0),
(8, 'canadian-mining-giant-hyperblock-acquires-cryptoglobal-for-106-million', 'CANADIAN MINING GIANT HYPERBLOCK ACQUIRES CRYPTOGLOBAL FOR $106 MILLION', '', 'public/upload/news/e56c8562afa3795f3c4c3ecccc3bfa83.jpg', '', '<div>Lorem ipsum dolor sit amet, quo omittam moderatius in, te cum mutat malorum. Autem ullum cu sed. Id per enim deserunt, vel an choro dolores voluptatum. His viderer civibus te, quis vero timeam te mel. Meis nulla nec id. Te eros ubique ius.</div><div><br></div><div>Pri nisl velit at. Ei lobortis forensibus dissentiunt sit, ius idque veritus in, in aeterno invenire usu. Esse inani inermis eam ea. Justo perfecto dignissim an pri, ea sit dico neglegentur, id mundi maiestatis vel. Eos eu stet dicit. Porro suscipiantur id usu, antiopam moderatius sit ne. Ei nulla torquatos ullamcorper sed, no stet graece instructior vel, eirmod vulputate an duo.</div><div><br></div><div>Splendide laboramus eam cu, veritus singulis vel et, essent assentior an vim. Prima paulo ut mei, no tota erat eam. Constituam consequuntur his ad. Ad ius libris labore, ex sumo regione eos. No ius vero apeirian.</div><div><br></div><div>Mollis integre persius ad nam. At agam constituam sit, an mea dolores iracundia conceptam, vis no atqui verear detracto. Et fugit ridens intellegam duo, eu facilisi erroribus duo. Et vix homero verear liberavisse, natum nonumes splendide usu at. Ea vis meliore offendit intellegebat. Ne mazim philosophia usu.</div><div><br></div><div>At mazim tacimates per. Ne reque tractatos mel, at eos case commodo. Cu animal constituam pri, ea nam ceteros copiosae philosophia. Ei modo fuisset pertinax vim, id vis tacimates interpretaris mediocritatem. Vel no esse scripserit, nostrum tacimates his te.</div><div><br></div><div>Corpora postulant voluptatum nam eu. Cum te agam delectus ullamcorper, nostrum perfecto an nam. Ne quo accusata adversarium, illud efficiantur te nam. At veri simul virtute mei, deleniti persecuti te mei. Ludus animal eam cu, an nulla prompta imperdiet vis. Est cu dicam soluta everti.</div><div><br></div><div>Aliquam feugait perfecto per ne, an adolescens sententiae vis, his no noster animal. At vim vidit apeirian appellantur, no graecis invidunt sea. Illud oblique ad ius, eum no partem consectetuer, equidem incorrupte cum cu. At usu docendi tibique evertitur. Duis deserunt pri at. Aeque tempor usu et, ex illum facer efficiendi nam.</div><div><br></div><div>Vel quodsi iracundia ne, eu audiam tibique mnesarchum est. Diam oporteat suavitate pri id. Eos latine euripidis ad, ad mei partem accommodare, nam at elitr vitae voluptaria. Id sea ceteros suscipiantur. Ne per viderer tacimates repudiare, sed id quaestio cotidieque. Ei hinc dolor putent usu, falli lucilius nam at.</div><div><br></div><div>Aperiam detracto qualisque cu sea, sea te deleniti scripserit. Option feugiat sit ei. Labore volumus instructior eos ne, id graecis antiopam assueverit vel, no appetere argumentum eloquentiam quo. Error option dolorum nam cu. Vim tantas populo et, te mea quem quando decore.</div><div><br></div><div>Duo ad elit aperiam. Et error aliquip mea. Cum ut facete assentior, ei vis dictas erroribus salutatus. Mea eu iusto volumus argumentum, sed eu quando regione indoctum.</div>', '', '', '', 10, NULL, 0, '2018-07-29 01:23:34', 'admin@demo.com', 0),
(9, 'how-can-blockchains-remove-the-pay-to-trade-barrier-in-the-market', 'How Can Blockchains Remove the ?Pay to Trade? Barrier in the Market?', '', 'public/upload/news/2ff94094fcfbe19daf303a479b9fad68.jpg', '', '<div>Lorem ipsum dolor sit amet, quo omittam moderatius in, te cum mutat malorum. Autem ullum cu sed. Id per enim deserunt, vel an choro dolores voluptatum. His viderer civibus te, quis vero timeam te mel. Meis nulla nec id. Te eros ubique ius.</div><div><br></div><div>Pri nisl velit at. Ei lobortis forensibus dissentiunt sit, ius idque veritus in, in aeterno invenire usu. Esse inani inermis eam ea. Justo perfecto dignissim an pri, ea sit dico neglegentur, id mundi maiestatis vel. Eos eu stet dicit. Porro suscipiantur id usu, antiopam moderatius sit ne. Ei nulla torquatos ullamcorper sed, no stet graece instructior vel, eirmod vulputate an duo.</div><div><br></div><div>Splendide laboramus eam cu, veritus singulis vel et, essent assentior an vim. Prima paulo ut mei, no tota erat eam. Constituam consequuntur his ad. Ad ius libris labore, ex sumo regione eos. No ius vero apeirian.</div><div><br></div><div>Mollis integre persius ad nam. At agam constituam sit, an mea dolores iracundia conceptam, vis no atqui verear detracto. Et fugit ridens intellegam duo, eu facilisi erroribus duo. Et vix homero verear liberavisse, natum nonumes splendide usu at. Ea vis meliore offendit intellegebat. Ne mazim philosophia usu.</div><div><br></div><div>At mazim tacimates per. Ne reque tractatos mel, at eos case commodo. Cu animal constituam pri, ea nam ceteros copiosae philosophia. Ei modo fuisset pertinax vim, id vis tacimates interpretaris mediocritatem. Vel no esse scripserit, nostrum tacimates his te.</div><div><br></div><div>Corpora postulant voluptatum nam eu. Cum te agam delectus ullamcorper, nostrum perfecto an nam. Ne quo accusata adversarium, illud efficiantur te nam. At veri simul virtute mei, deleniti persecuti te mei. Ludus animal eam cu, an nulla prompta imperdiet vis. Est cu dicam soluta everti.</div><div><br></div><div>Aliquam feugait perfecto per ne, an adolescens sententiae vis, his no noster animal. At vim vidit apeirian appellantur, no graecis invidunt sea. Illud oblique ad ius, eum no partem consectetuer, equidem incorrupte cum cu. At usu docendi tibique evertitur. Duis deserunt pri at. Aeque tempor usu et, ex illum facer efficiendi nam.</div><div><br></div><div>Vel quodsi iracundia ne, eu audiam tibique mnesarchum est. Diam oporteat suavitate pri id. Eos latine euripidis ad, ad mei partem accommodare, nam at elitr vitae voluptaria. Id sea ceteros suscipiantur. Ne per viderer tacimates repudiare, sed id quaestio cotidieque. Ei hinc dolor putent usu, falli lucilius nam at.</div><div><br></div><div>Aperiam detracto qualisque cu sea, sea te deleniti scripserit. Option feugiat sit ei. Labore volumus instructior eos ne, id graecis antiopam assueverit vel, no appetere argumentum eloquentiam quo. Error option dolorum nam cu. Vim tantas populo et, te mea quem quando decore.</div><div><br></div><div>Duo ad elit aperiam. Et error aliquip mea. Cum ut facete assentior, ei vis dictas erroribus salutatus. Mea eu iusto volumus argumentum, sed eu quando regione indoctum.</div>', '', '', '', 9, NULL, 0, '2018-07-29 01:23:40', 'admin@demo.com', 0),
(10, 'how-blockchain-is-making-it-easier-to-get', 'How Blockchain Is Making It Easier to Get', '', 'public/upload/news/32083222f2430503659756a60d3b0b6b.jpg', '', '<div>Lorem ipsum dolor sit amet, quo omittam moderatius in, te cum mutat malorum. Autem ullum cu sed. Id per enim deserunt, vel an choro dolores voluptatum. His viderer civibus te, quis vero timeam te mel. Meis nulla nec id. Te eros ubique ius.</div><div><br></div><div>Pri nisl velit at. Ei lobortis forensibus dissentiunt sit, ius idque veritus in, in aeterno invenire usu. Esse inani inermis eam ea. Justo perfecto dignissim an pri, ea sit dico neglegentur, id mundi maiestatis vel. Eos eu stet dicit. Porro suscipiantur id usu, antiopam moderatius sit ne. Ei nulla torquatos ullamcorper sed, no stet graece instructior vel, eirmod vulputate an duo.</div><div><br></div><div>Splendide laboramus eam cu, veritus singulis vel et, essent assentior an vim. Prima paulo ut mei, no tota erat eam. Constituam consequuntur his ad. Ad ius libris labore, ex sumo regione eos. No ius vero apeirian.</div><div><br></div><div>Mollis integre persius ad nam. At agam constituam sit, an mea dolores iracundia conceptam, vis no atqui verear detracto. Et fugit ridens intellegam duo, eu facilisi erroribus duo. Et vix homero verear liberavisse, natum nonumes splendide usu at. Ea vis meliore offendit intellegebat. Ne mazim philosophia usu.</div><div><br></div><div>At mazim tacimates per. Ne reque tractatos mel, at eos case commodo. Cu animal constituam pri, ea nam ceteros copiosae philosophia. Ei modo fuisset pertinax vim, id vis tacimates interpretaris mediocritatem. Vel no esse scripserit, nostrum tacimates his te.</div><div><br></div><div>Corpora postulant voluptatum nam eu. Cum te agam delectus ullamcorper, nostrum perfecto an nam. Ne quo accusata adversarium, illud efficiantur te nam. At veri simul virtute mei, deleniti persecuti te mei. Ludus animal eam cu, an nulla prompta imperdiet vis. Est cu dicam soluta everti.</div><div><br></div><div>Aliquam feugait perfecto per ne, an adolescens sententiae vis, his no noster animal. At vim vidit apeirian appellantur, no graecis invidunt sea. Illud oblique ad ius, eum no partem consectetuer, equidem incorrupte cum cu. At usu docendi tibique evertitur. Duis deserunt pri at. Aeque tempor usu et, ex illum facer efficiendi nam.</div><div><br></div><div>Vel quodsi iracundia ne, eu audiam tibique mnesarchum est. Diam oporteat suavitate pri id. Eos latine euripidis ad, ad mei partem accommodare, nam at elitr vitae voluptaria. Id sea ceteros suscipiantur. Ne per viderer tacimates repudiare, sed id quaestio cotidieque. Ei hinc dolor putent usu, falli lucilius nam at.</div><div><br></div><div>Aperiam detracto qualisque cu sea, sea te deleniti scripserit. Option feugiat sit ei. Labore volumus instructior eos ne, id graecis antiopam assueverit vel, no appetere argumentum eloquentiam quo. Error option dolorum nam cu. Vim tantas populo et, te mea quem quando decore.</div><div><br></div><div>Duo ad elit aperiam. Et error aliquip mea. Cum ut facete assentior, ei vis dictas erroribus salutatus. Mea eu iusto volumus argumentum, sed eu quando regione indoctum.</div>', '', '', '', 10, NULL, 0, '2018-07-29 01:23:49', 'admin@demo.com', 0),
(11, 'ripple-price-technical-analysis-xrpusd', 'Ripple Price Technical Analysis ? XRP/USD', '', 'public/upload/news/1624108242_d6f48e3f12188914203a.jpg', '', '<div>Lorem ipsum dolor sit amet, quo omittam moderatius in, te cum mutat malorum. Autem ullum cu sed. Id per enim deserunt, vel an choro dolores voluptatum. His viderer civibus te, quis vero timeam te mel. Meis nulla nec id. Te eros ubique ius.</div><div><br></div><div>Pri nisl velit at. Ei lobortis forensibus dissentiunt sit, ius idque veritus in, in aeterno invenire usu. Esse inani inermis eam ea. Justo perfecto dignissim an pri, ea sit dico neglegentur, id mundi maiestatis vel. Eos eu stet dicit. Porro suscipiantur id usu, antiopam moderatius sit ne. Ei nulla torquatos ullamcorper sed, no stet graece instructior vel, eirmod vulputate an duo.</div><div><br></div><div>Splendide laboramus eam cu, veritus singulis vel et, essent assentior an vim. Prima paulo ut mei, no tota erat eam. Constituam consequuntur his ad. Ad ius libris labore, ex sumo regione eos. No ius vero apeirian.</div><div><br></div><div>Mollis integre persius ad nam. At agam constituam sit, an mea dolores iracundia conceptam, vis no atqui verear detracto. Et fugit ridens intellegam duo, eu facilisi erroribus duo. Et vix homero verear liberavisse, natum nonumes splendide usu at. Ea vis meliore offendit intellegebat. Ne mazim philosophia usu.</div><div><br></div><div>At mazim tacimates per. Ne reque tractatos mel, at eos case commodo. Cu animal constituam pri, ea nam ceteros copiosae philosophia. Ei modo fuisset pertinax vim, id vis tacimates interpretaris mediocritatem. Vel no esse scripserit, nostrum tacimates his te.</div><div><br></div><div>Corpora postulant voluptatum nam eu. Cum te agam delectus ullamcorper, nostrum perfecto an nam. Ne quo accusata adversarium, illud efficiantur te nam. At veri simul virtute mei, deleniti persecuti te mei. Ludus animal eam cu, an nulla prompta imperdiet vis. Est cu dicam soluta everti.</div><div><br></div><div>Aliquam feugait perfecto per ne, an adolescens sententiae vis, his no noster animal. At vim vidit apeirian appellantur, no graecis invidunt sea. Illud oblique ad ius, eum no partem consectetuer, equidem incorrupte cum cu. At usu docendi tibique evertitur. Duis deserunt pri at. Aeque tempor usu et, ex illum facer efficiendi nam.</div><div><br></div><div>Vel quodsi iracundia ne, eu audiam tibique mnesarchum est. Diam oporteat suavitate pri id. Eos latine euripidis ad, ad mei partem accommodare, nam at elitr vitae voluptaria. Id sea ceteros suscipiantur. Ne per viderer tacimates repudiare, sed id quaestio cotidieque. Ei hinc dolor putent usu, falli lucilius nam at.</div><div><br></div><div>Aperiam detracto qualisque cu sea, sea te deleniti scripserit. Option feugiat sit ei. Labore volumus instructior eos ne, id graecis antiopam assueverit vel, no appetere argumentum eloquentiam quo. Error option dolorum nam cu. Vim tantas populo et, te mea quem quando decore.</div><div><br></div><div>Duo ad elit aperiam. Et error aliquip mea. Cum ut facete assentior, ei vis dictas erroribus salutatus. Mea eu iusto volumus argumentum, sed eu quando regione indoctum.</div>', '', '', '', 9, NULL, 0, '2018-12-27 12:55:44', 'admin@demo.com', 0),
(12, 'bitfinex-introduces-trading-for-12-altcoins', 'Bitfinex Introduces Trading for 12 Altcoins', '', 'public/upload/news/bd92f765617da2c82d5cef5c1ebde2d3.jpg', '', '<div>Lorem ipsum dolor sit amet, quo omittam moderatius in, te cum mutat malorum. Autem ullum cu sed. Id per enim deserunt, vel an choro dolores voluptatum. His viderer civibus te, quis vero timeam te mel. Meis nulla nec id. Te eros ubique ius.</div><div><br></div><div>Pri nisl velit at. Ei lobortis forensibus dissentiunt sit, ius idque veritus in, in aeterno invenire usu. Esse inani inermis eam ea. Justo perfecto dignissim an pri, ea sit dico neglegentur, id mundi maiestatis vel. Eos eu stet dicit. Porro suscipiantur id usu, antiopam moderatius sit ne. Ei nulla torquatos ullamcorper sed, no stet graece instructior vel, eirmod vulputate an duo.</div><div><br></div><div>Splendide laboramus eam cu, veritus singulis vel et, essent assentior an vim. Prima paulo ut mei, no tota erat eam. Constituam consequuntur his ad. Ad ius libris labore, ex sumo regione eos. No ius vero apeirian.</div><div><br></div><div>Mollis integre persius ad nam. At agam constituam sit, an mea dolores iracundia conceptam, vis no atqui verear detracto. Et fugit ridens intellegam duo, eu facilisi erroribus duo. Et vix homero verear liberavisse, natum nonumes splendide usu at. Ea vis meliore offendit intellegebat. Ne mazim philosophia usu.</div><div><br></div><div>At mazim tacimates per. Ne reque tractatos mel, at eos case commodo. Cu animal constituam pri, ea nam ceteros copiosae philosophia. Ei modo fuisset pertinax vim, id vis tacimates interpretaris mediocritatem. Vel no esse scripserit, nostrum tacimates his te.</div><div><br></div><div>Corpora postulant voluptatum nam eu. Cum te agam delectus ullamcorper, nostrum perfecto an nam. Ne quo accusata adversarium, illud efficiantur te nam. At veri simul virtute mei, deleniti persecuti te mei. Ludus animal eam cu, an nulla prompta imperdiet vis. Est cu dicam soluta everti.</div><div><br></div><div>Aliquam feugait perfecto per ne, an adolescens sententiae vis, his no noster animal. At vim vidit apeirian appellantur, no graecis invidunt sea. Illud oblique ad ius, eum no partem consectetuer, equidem incorrupte cum cu. At usu docendi tibique evertitur. Duis deserunt pri at. Aeque tempor usu et, ex illum facer efficiendi nam.</div><div><br></div><div>Vel quodsi iracundia ne, eu audiam tibique mnesarchum est. Diam oporteat suavitate pri id. Eos latine euripidis ad, ad mei partem accommodare, nam at elitr vitae voluptaria. Id sea ceteros suscipiantur. Ne per viderer tacimates repudiare, sed id quaestio cotidieque. Ei hinc dolor putent usu, falli lucilius nam at.</div><div><br></div><div>Aperiam detracto qualisque cu sea, sea te deleniti scripserit. Option feugiat sit ei. Labore volumus instructior eos ne, id graecis antiopam assueverit vel, no appetere argumentum eloquentiam quo. Error option dolorum nam cu. Vim tantas populo et, te mea quem quando decore.</div><div><br></div><div>Duo ad elit aperiam. Et error aliquip mea. Cum ut facete assentior, ei vis dictas erroribus salutatus. Mea eu iusto volumus argumentum, sed eu quando regione indoctum.</div>', '', '', '', 9, NULL, 0, '2018-12-27 12:55:57', 'admin@demo.com', 0),
(13, 'bitcoin-cash-price-trend-including', 'Bitcoin Cash Price Trend Including', 'Bitcoin Cash Price Trend Including', '//public/upload/news/b222d9177c5c522393710d9c10bc0c7f.jpg', '', '<div>Lorem ipsum dolor sit amet, quo omittam moderatius in, te cum mutat malorum. Autem ullum cu sed. Id per enim deserunt, vel an choro dolores voluptatum. His viderer civibus te, quis vero timeam te mel. Meis nulla nec id. Te eros ubique ius.</div>\r\n\r\n<div>&nbsp;</div>\r\n\r\n<div>Pri nisl velit at. Ei lobortis forensibus dissentiunt sit, ius idque veritus in, in aeterno invenire usu. Esse inani inermis eam ea. Justo perfecto dignissim an pri, ea sit dico neglegentur, id mundi maiestatis vel. Eos eu stet dicit. Porro suscipiantur id usu, antiopam moderatius sit ne. Ei nulla torquatos ullamcorper sed, no stet graece instructior vel, eirmod vulputate an duo.</div>\r\n\r\n<div>&nbsp;</div>\r\n\r\n<div>Splendide laboramus eam cu, veritus singulis vel et, essent assentior an vim. Prima paulo ut mei, no tota erat eam. Constituam consequuntur his ad. Ad ius libris labore, ex sumo regione eos. No ius vero apeirian.</div>\r\n\r\n<div>&nbsp;</div>\r\n\r\n<div>Mollis integre persius ad nam. At agam constituam sit, an mea dolores iracundia conceptam, vis no atqui verear detracto. Et fugit ridens intellegam duo, eu facilisi erroribus duo. Et vix homero verear liberavisse, natum nonumes splendide usu at. Ea vis meliore offendit intellegebat. Ne mazim philosophia usu.</div>\r\n\r\n<div>&nbsp;</div>\r\n\r\n<div>At mazim tacimates per. Ne reque tractatos mel, at eos case commodo. Cu animal constituam pri, ea nam ceteros copiosae philosophia. Ei modo fuisset pertinax vim, id vis tacimates interpretaris mediocritatem. Vel no esse scripserit, nostrum tacimates his te.</div>\r\n\r\n<div>&nbsp;</div>\r\n\r\n<div>Corpora postulant voluptatum nam eu. Cum te agam delectus ullamcorper, nostrum perfecto an nam. Ne quo accusata adversarium, illud efficiantur te nam. At veri simul virtute mei, deleniti persecuti te mei. Ludus animal eam cu, an nulla prompta imperdiet vis. Est cu dicam soluta everti.</div>\r\n\r\n<div>&nbsp;</div>\r\n\r\n<div>Aliquam feugait perfecto per ne, an adolescens sententiae vis, his no noster animal. At vim vidit apeirian appellantur, no graecis invidunt sea. Illud oblique ad ius, eum no partem consectetuer, equidem incorrupte cum cu. At usu docendi tibique evertitur. Duis deserunt pri at. Aeque tempor usu et, ex illum facer efficiendi nam.</div>\r\n\r\n<div>&nbsp;</div>\r\n\r\n<div>Vel quodsi iracundia ne, eu audiam tibique mnesarchum est. Diam oporteat suavitate pri id. Eos latine euripidis ad, ad mei partem accommodare, nam at elitr vitae voluptaria. Id sea ceteros suscipiantur. Ne per viderer tacimates repudiare, sed id quaestio cotidieque. Ei hinc dolor putent usu, falli lucilius nam at.</div>\r\n\r\n<div>&nbsp;</div>\r\n\r\n<div>Aperiam detracto qualisque cu sea, sea te deleniti scripserit. Option feugiat sit ei. Labore volumus instructior eos ne, id graecis antiopam assueverit vel, no appetere argumentum eloquentiam quo. Error option dolorum nam cu. Vim tantas populo et, te mea quem quando decore.</div>\r\n\r\n<div>&nbsp;</div>\r\n\r\n<div>Duo ad elit aperiam. Et error aliquip mea. Cum ut facete assentior, ei vis dictas erroribus salutatus. Mea eu iusto volumus argumentum, sed eu quando regione indoctum.</div>\r\n', '', '', '', 9, NULL, 0, '2021-09-06 07:14:07', 'admin@demo.com', 0);

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

--
-- Table structure for table `web_slider`
--

CREATE TABLE `web_slider` (
  `id` int(11) NOT NULL,
  `slider_h1_en` varchar(900) DEFAULT NULL,
  `slider_h1_fr` varchar(900) DEFAULT NULL,
  `slider_h2_en` varchar(900) DEFAULT NULL,
  `slider_h2_fr` varchar(900) DEFAULT NULL,
  `slider_h3_en` varchar(900) DEFAULT NULL,
  `slider_h3_fr` varchar(900) DEFAULT NULL,
  `slider_img` varchar(300) DEFAULT NULL,
  `custom_url` varchar(300) NOT NULL,
  `status` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `web_social_link`
--

CREATE TABLE `web_social_link` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL,
  `icon` varchar(100) NOT NULL,
  `status` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `web_social_link`
--

INSERT INTO `web_social_link` (`id`, `name`, `link`, `icon`, `status`, `date`) VALUES
(1, 'Facebook', 'https://www.facebook.com', 'facebook', 1, '2018-04-02 05:52:31'),
(2, 'twitter', 'https://twitter.com', 'tumblr', 1, '2018-07-09 22:12:09'),
(3, 'google plus', 'https://google-plus.com', 'linkedin', 1, '2018-07-09 22:12:09'),
(4, 'youtube', 'https://www.youtube.com', 'dribbble', 1, '2018-07-09 22:12:09'),
(5, 'instagram', 'https://instagram.com', 'instagram', 0, '2021-09-07 04:30:43');

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


--
-- Table structure for table `dbt_payout_method`
--

CREATE TABLE `dbt_payout_method` (
  `id` int(11) NOT NULL,
  `user_id` varchar(250) NOT NULL,
  `method` varchar(250) NOT NULL,
  `wallet_id` varchar(250) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------
--
-- Table structure for table `web_subscriber`
--

CREATE TABLE `web_subscriber` (
  `sub_id` int(11) NOT NULL,
  `email` varchar(100) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


ALTER TABLE `dbt_user` ADD `wallet_status` TINYINT(1) NOT NULL DEFAULT '0' AFTER `image`;
ALTER TABLE `dbt_release_setup` CHANGE `fillup_target` `fillup_target` DOUBLE(19,8) NOT NULL DEFAULT '0';
ALTER TABLE `dbt_release_setup` CHANGE `exchange_currency` `exchange_currency` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL;
ALTER TABLE `dbt_buy_token` CHANGE `from_wallet` `from_wallet` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL;
ALTER TABLE `dbt_buy_token` CHANGE `txn_hash` `txn_hash` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL;
ALTER TABLE `dbt_admin_wallet` CHANGE `tnx_type` `tnx_type` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'DEPOSIT/EARNINGS';
--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `crypto_payments`
--
ALTER TABLE `crypto_payments`
  ADD PRIMARY KEY (`paymentID`),
  ADD UNIQUE KEY `key3` (`boxID`,`orderID`,`userID`,`txID`,`amount`,`addr`),
  ADD KEY `boxID` (`boxID`),
  ADD KEY `boxType` (`boxType`),
  ADD KEY `userID` (`userID`),
  ADD KEY `countryID` (`countryID`),
  ADD KEY `orderID` (`orderID`),
  ADD KEY `amount` (`amount`),
  ADD KEY `amountUSD` (`amountUSD`),
  ADD KEY `coinLabel` (`coinLabel`),
  ADD KEY `unrecognised` (`unrecognised`),
  ADD KEY `addr` (`addr`),
  ADD KEY `txID` (`txID`),
  ADD KEY `txDate` (`txDate`),
  ADD KEY `txConfirmed` (`txConfirmed`),
  ADD KEY `txCheckDate` (`txCheckDate`),
  ADD KEY `processed` (`processed`),
  ADD KEY `processedDate` (`processedDate`),
  ADD KEY `recordCreated` (`recordCreated`),
  ADD KEY `key1` (`boxID`,`orderID`),
  ADD KEY `key2` (`boxID`,`orderID`,`userID`);

--
-- Indexes for table `dbt_admin_wallet`
--
ALTER TABLE `dbt_admin_wallet`
  ADD PRIMARY KEY (`aw_id`);

--
-- Indexes for table `dbt_balance`
--
ALTER TABLE `dbt_balance`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_id` (`user_id`);

--
-- Indexes for table `dbt_balance_log`
--
ALTER TABLE `dbt_balance_log`
  ADD PRIMARY KEY (`log_id`);

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

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

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

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

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

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

--
-- Indexes for table `dbt_encrypt_data`
--
ALTER TABLE `dbt_encrypt_data`
  ADD PRIMARY KEY (`encrypt_id`);

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

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

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

--
-- Indexes for table `dbt_release_setup`
--
ALTER TABLE `dbt_release_setup`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `round_name` (`round_name`);

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

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

--
-- Indexes for table `dbt_user`
--
ALTER TABLE `dbt_user`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_id` (`user_id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD UNIQUE KEY `phone` (`phone`),
  ADD UNIQUE KEY `username` (`username`);

--
-- Indexes for table `dbt_user_cryptowallet`
--
ALTER TABLE `dbt_user_cryptowallet`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `wallet` (`wallet`);

--
-- Indexes for table `dbt_user_log`
--
ALTER TABLE `dbt_user_log`
  ADD PRIMARY KEY (`log_id`);

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

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

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

--
-- Indexes for table `earnings`
--
ALTER TABLE `earnings`
  ADD PRIMARY KEY (`earning_id`);

--
-- Indexes for table `email_sms_gateway`
--
ALTER TABLE `email_sms_gateway`
  ADD PRIMARY KEY (`es_id`);

--
-- Indexes for table `investment`
--
ALTER TABLE `investment`
  ADD PRIMARY KEY (`order_id`),
  ADD UNIQUE KEY `idinvestment_UNIQUE` (`order_id`);

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

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

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

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

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`notification_id`);

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

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

--
-- Indexes for table `setting`
--
ALTER TABLE `setting`
  ADD PRIMARY KEY (`setting_id`);

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

--
-- Indexes for table `testing_tb`
--
ALTER TABLE `testing_tb`
  ADD PRIMARY KEY (`sl`);

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

--
-- Indexes for table `web_article`
--
ALTER TABLE `web_article`
  ADD PRIMARY KEY (`article_id`),
  ADD UNIQUE KEY `slug` (`slug`);

--
-- Indexes for table `web_category`
--
ALTER TABLE `web_category`
  ADD PRIMARY KEY (`cat_id`),
  ADD UNIQUE KEY `slug` (`slug`);

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

--
-- Indexes for table `web_news`
--
ALTER TABLE `web_news`
  ADD PRIMARY KEY (`article_id`),
  ADD UNIQUE KEY `slug` (`slug`);

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

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

--
-- Indexes for table `web_subscriber`
--
ALTER TABLE `web_subscriber`
  ADD PRIMARY KEY (`sub_id`),
  ADD UNIQUE KEY `email` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `advertisement`
--
ALTER TABLE `advertisement`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `coinpayments_payments`
--
ALTER TABLE `coinpayments_payments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crypto_payments`
--
ALTER TABLE `crypto_payments`
  MODIFY `paymentID` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dbt_admin_wallet`
--
ALTER TABLE `dbt_admin_wallet`
  MODIFY `aw_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dbt_balance`
--
ALTER TABLE `dbt_balance`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dbt_balance_log`
--
ALTER TABLE `dbt_balance_log`
  MODIFY `log_id` bigint(22) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dbt_buy_token`
--
ALTER TABLE `dbt_buy_token`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dbt_coin_info`
--
ALTER TABLE `dbt_coin_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `dbt_country`
--
ALTER TABLE `dbt_country`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=254;

--
-- AUTO_INCREMENT for table `dbt_cron`
--
ALTER TABLE `dbt_cron`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dbt_currency`
--
ALTER TABLE `dbt_currency`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `dbt_deposit`
--
ALTER TABLE `dbt_deposit`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dbt_encrypt_data`
--
ALTER TABLE `dbt_encrypt_data`
  MODIFY `encrypt_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dbt_fees`
--
ALTER TABLE `dbt_fees`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `dbt_messenger`
--
ALTER TABLE `dbt_messenger`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dbt_networking_setting`
--
ALTER TABLE `dbt_networking_setting`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `dbt_release_setup`
--
ALTER TABLE `dbt_release_setup`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dbt_sms_email_template`
--
ALTER TABLE `dbt_sms_email_template`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `dbt_transfer`
--
ALTER TABLE `dbt_transfer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `dbt_user`
--
ALTER TABLE `dbt_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `dbt_user_cryptowallet`
--
ALTER TABLE `dbt_user_cryptowallet`
  MODIFY `id` bigint(22) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dbt_user_log`
--
ALTER TABLE `dbt_user_log`
  MODIFY `log_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `dbt_user_verify_doc`
--
ALTER TABLE `dbt_user_verify_doc`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dbt_verify`
--
ALTER TABLE `dbt_verify`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `dbt_withdraw`
--
ALTER TABLE `dbt_withdraw`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `earnings`
--
ALTER TABLE `earnings`
  MODIFY `earning_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `email_sms_gateway`
--
ALTER TABLE `email_sms_gateway`
  MODIFY `es_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `investment`
--
ALTER TABLE `investment`
  MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `language`
--
ALTER TABLE `language`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1015;

--
-- AUTO_INCREMENT for table `menu_control`
--
ALTER TABLE `menu_control`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `message`
--
ALTER TABLE `message`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `module`
--
ALTER TABLE `module`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `notification_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payeer_payments`
--
ALTER TABLE `payeer_payments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_gateway`
--
ALTER TABLE `payment_gateway`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `setting`
--
ALTER TABLE `setting`
  MODIFY `setting_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sms_email_send_setup`
--
ALTER TABLE `sms_email_send_setup`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `testing_tb`
--
ALTER TABLE `testing_tb`
  MODIFY `sl` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `themes`
--
ALTER TABLE `themes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `web_article`
--
ALTER TABLE `web_article`
  MODIFY `article_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT for table `web_category`
--
ALTER TABLE `web_category`
  MODIFY `cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `web_language`
--
ALTER TABLE `web_language`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `web_news`
--
ALTER TABLE `web_news`
  MODIFY `article_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `web_slider`
--
ALTER TABLE `web_slider`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `web_social_link`
--
ALTER TABLE `web_social_link`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `web_subscriber`
--
ALTER TABLE `web_subscriber`
  MODIFY `sub_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Indexes for table `dbt_payout_method`
--
ALTER TABLE `dbt_payout_method`
  ADD PRIMARY KEY (`id`);
  
--
-- AUTO_INCREMENT for table `dbt_payout_method`
--
ALTER TABLE `dbt_payout_method`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `dbt_user_verify_doc` CHANGE `gender` `gender` TINYINT(1) NOT NULL COMMENT '1=male,2=female';
ALTER TABLE `web_article` CHANGE `article1_en` `article1_en` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `web_article` CHANGE `article1_fr` `article1_fr` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `web_article` CHANGE `article2_en` `article2_en` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `web_article` CHANGE `article2_fr` `article2_fr` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `web_article` CHANGE `custom_url` `custom_url` VARCHAR(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `web_article` CHANGE `position_serial` `position_serial` INT(11) NULL;
ALTER TABLE `web_article` CHANGE `edit_history` `edit_history` INT(11) NULL;
ALTER TABLE `web_news` CHANGE `headline_en` `headline_en` VARCHAR(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `web_news` CHANGE `headline_fr` `headline_fr` VARCHAR(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `web_news` CHANGE `custom_url` `custom_url` VARCHAR(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `web_news` CHANGE `article1_en` `article1_en` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `web_news` CHANGE `article1_fr` `article1_fr` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `web_news` CHANGE `article2_en` `article2_en` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `web_news` CHANGE `article2_fr` `article2_fr` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `web_news` CHANGE `position_serial` `position_serial` INT(11) NULL;
ALTER TABLE `web_news` CHANGE `publish_date` `publish_date` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `web_news` CHANGE `edit_history` `edit_history` INT(11) NULL;
INSERT INTO `language` (`id`, `phrase`, `english`, `french`) VALUES (NULL, 'add-news', 'Add News', 'Add News');
ALTER TABLE `dbt_messenger` CHANGE `replay_id` `replay_id` INT(11) NULL;
ALTER TABLE `dbt_messenger` CHANGE `admin_status` `admin_status` INT(11) NULL;
ALTER TABLE `payment_gateway` CHANGE `secret_key` `secret_key` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
INSERT INTO `web_article` (`article_id`, `slug`, `headline_en`, `headline_fr`, `article_image`, `custom_url`, `article1_en`, `article1_fr`, `article2_en`, `article2_fr`, `video`, `cat_id`, `page_content`, `position_serial`, `publish_date`, `publish_by`, `edit_history`) VALUES (NULL, NULL, 'Privacy Policy', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, '2022-03-27 10:31:51.000000', '', NULL);
