Problema arquivo .json em SQL

[matheus21]

Estou com problema em uploar meu arquivo .json no meu sql/phpmyadmin,

e no site dis que :

Mecanismo de banco de dados padrão: InnoDB em MariaDB 10.1

 

então tinha que da certo!

 

 

{"status":"success", "message":"CREATE TABLE IF NOT EXISTS `bit_settings` (\n `id` int(11) NOT NULL AUTO_INCREMENT, \n `template` varchar(255) NULL, \n `title` varchar(255) NULL, \n `description` varchar(255) NULL, \n `keywords` varchar(255) NULL, \n `name` varchar(255) NULL, \n `infoemail` varchar(255) NULL, \n `supportemail` varchar(255) NULL, \n `whatsapp` varchar(255) NULL, \n `skype` varchar(255) NULL, \n `url` varchar(255) NULL, \n `referral_comission` varchar(255) NULL, \n `wallet_comission` varchar(255) NULL, \n `login_to_exchange` int(11) NULL, \n `document_verification` int(11) NULL, \n `email_verification` int(11) NULL, \n `phone_verification` int(11) NULL, \n `recaptcha_verification` int(11) NULL, \n `recaptcha_publickey` varchar(255) NULL, \n `recaptcha_privatekey` varchar(255) NULL, \n `nexmo_api_key` varchar(255) NULL, \n `nexmo_api_secret` varchar(255) NULL, \n `worktime_from` varchar(255) NULL, \n `worktime_to` varchar(255) NULL, \n `worktime_gmt` varchar(255) NULL, \n `default_language` varchar(255) NULL, \n `default_template` varchar(255) NULL, \n `operator_status` int(11) NULL, \n `footer` text NULL, \n `facebook` text NULL, \n `twitter` text NULL, \n `google` text NULL, \n `youtube` text NULL, \n `license_key` text NULL, \n PRIMARY KEY (`id`)\n) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;
\n\n\nCREATE TABLE IF NOT EXISTS `bit_users_deposits` (\n `id` int(11) NOT NULL AUTO_INCREMENT, \n `uid` int(11) NULL, \n `amount` varchar(255) NULL, \n `currency` varchar(255) NULL, \n `gateway_id` varchar(255) NULL, \n `payment_hash` varchar(255) NULL, \n `txid` varchar(255) NULL, \n `status` int(11) NULL, \n `time` int(11) NULL, \n `reason` int(11) NULL, \n PRIMARY KEY (`id`)\n) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;
\n\nCREATE TABLE IF NOT EXISTS `bit_users_transactions` (\n `id` int(11) NOT NULL AUTO_INCREMENT, \n `sender` int(11) NULL, \n `recipient` int(11) NULL, \n `amount` varchar(255) NULL, \n `currency` varchar(255) NULL, \n `description` varchar(255) NULL, \n `status` int(11) NULL, \n `time` int(11) NULL, \n PRIMARY KEY (`id`)\n) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;
\n\n\nCREATE TABLE IF NOT EXISTS `bit_users` (\n `id` int(11) NOT NULL AUTO_INCREMENT, \n `username` varchar(255) NULL, \n `password` varchar(255) NULL, \n `password_recovery` text NULL, \n `email_verified` int(11) NULL, \n `email_hash` text NULL, \n `email` varchar(255) NULL, \n `status` int(11) NULL, \n `ip` varchar(255) NULL, \n `last_login` int(11) NULL, \n `signup_time` int(11) NULL, \n `document_verified` int(11) NULL, \n `document_1` text NULL, \n `document_2` text NULL, \n `mobile_verified` int(11) NULL, \n `mobile_number` text NULL, \n PRIMARY KEY (`id`)\n) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;
\n\nCREATE TABLE IF NOT EXISTS `bit_users_earnings` (\n `id` int(11) NOT NULL AUTO_INCREMENT, \n `uid` int(11) NULL, \n `amount` varchar(255) NULL, \n `currency` varchar(255) NULL, \n `created` int(11) NULL, \n `updated` int(11) NULL, \n PRIMARY KEY (`id`)\n) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;
\n\nCREATE TABLE IF NOT EXISTS `bit_users_withdrawals` (\n `id` int(11) NOT NULL AUTO_INCREMENT, \n `uid` int(11) NULL, \n `eid` int(11) NULL, \n `amount` varchar(255) NULL, \n `currency` varchar(255) NULL, \n `company` varchar(255) NULL, \n `requested_on` int(11) NULL, \n `processed_on` int(11) NULL, \n `status` int(11) NULL, \n `u_field_1` varchar(255) NULL, \n `u_field_2` varchar(255) NULL, \n `u_field_3` varchar(255) NULL, \n `u_field_4` varchar(255) NULL, \n `u_field_5` varchar(255) NULL, \n `u_field_6` varchar(255) NULL, \n `u_field_7` varchar(255) NULL, \n `u_field_8` varchar(255) NULL, \n `u_field_9` varchar(255) NULL, \n `u_field_10` varchar(255) NULL, \n PRIMARY KEY (`id`)\n) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;
\n\n\nCREATE TABLE IF NOT EXISTS `bit_sms_codes` (\n `id` int(11) NOT NULL AUTO_INCREMENT, \n `uid` int(11) NULL, \n `sms_code` varchar(255) NULL, \n `verified` int(11) NULL, \n PRIMARY KEY (`id`)\n) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;
\n\nCREATE TABLE IF NOT EXISTS `bit_gateways` (\n `id` int(11) NOT NULL AUTO_INCREMENT, \n `name` varchar(255) NULL, \n `currency` varchar(255) NULL, \n `reserve` varchar(255) NULL, \n `min_amount` varchar(255) NULL, \n `max_amount` varchar(255) NULL, \n `exchange_type` int(11) NULL, \n `include_fee` int(11) NULL, \n `extra_fee` varchar(255) NULL, \n `fee` varchar(255) NULL, \n `allow_send` int(11) NULL, \n `allow_receive` int(11) NULL, \n `default_send` int(11) NULL, \n `default_receive` int(11) NULL, \n `allow_payouts` int(11) NULL, \n `a_field_1` varchar(255) NULL, \n `a_field_2` varchar(255) NULL, \n `a_field_3` varchar(255) NULL, \n `a_field_4` varchar(255) NULL, \n `a_field_5` varchar(255) NULL, \n `a_field_6` varchar(255) NULL, \n `a_field_7` varchar(255) NULL, \n `a_field_8` varchar(255) NULL, \n `a_field_9` varchar(255) NULL, \n `a_field_10` varchar(255) NULL, \n `status` int(11) NULL, \n `external_gateway` int(11) NOT NULL DEFAULT '0', \n `external_icon` text NULL, \n PRIMARY KEY (`id`)\n) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;
\n\nCREATE TABLE IF NOT EXISTS `bit_gateways_fields` (\n `id` int(11) NOT NULL AUTO_INCREMENT, \n `gateway_id` int(11) NULL, \n `field_name` varchar(255) NULL, \n `field_number` int(11) NULL, \n PRIMARY KEY (`id`)\n) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;
\n\nCREATE TABLE IF NOT EXISTS `bit_rates` (\n `id` int(11) NOT NULL AUTO_INCREMENT, \n `gateway_from` int(11) NULL, \n `gateway_to` int(11) NULL, \n `rate_from` varchar(255) NULL, \n `rate_to` varchar(255) NULL, \n PRIMARY KEY (`id`)\n) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;
\n\nCREATE TABLE IF NOT EXISTS `bit_rates` (\n `id` int(11) NOT NULL AUTO_INCREMENT, \n `gateway_from` int(11) NULL, \n `gateway_to` int(11) NULL, \n `rate_from` varchar(255) NULL, \n `rate_to` varchar(255) NULL, \n PRIMARY KEY (`id`)\n) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;
\n\nCREATE TABLE IF NOT EXISTS `bit_exchanges` (\n `id` int(11) NOT NULL AUTO_INCREMENT, \n `uid` int(11) NULL, \n `wid` int(11) NULL, \n `gateway_send` int(11) NULL, \n `gateway_receive` int(11) NULL, \n `amount_send` varchar(255) NULL, \n `amount_receive` varchar(255) NULL, \n `rate_from` varchar(255) NULL, \n `rate_to` varchar(255) NULL, \n `status` int(11) NOT NULL DEFAULT '0', \n `created` int(11) NOT NULL DEFAULT '0', \n `updated` int(11) NOT NULL DEFAULT '0', \n `expired` int(11) NOT NULL DEFAULT '0', \n `u_field_1` varchar(255) NULL, \n `u_field_2` varchar(255) NULL, \n `u_field_3` varchar(255) NULL, \n `u_field_4` varchar(255) NULL, \n `u_field_5` varchar(255) NULL, \n `u_field_6` varchar(255) NULL, \n `u_field_7` varchar(255) NULL, \n `u_field_8` varchar(255) NULL, \n `u_field_9` varchar(255) NULL, \n `u_field_10` varchar(255) NULL, \n `ip` varchar(255) NULL, \n `transaction_id` text NULL, \n `exchange_id` varchar(255) NULL, \n `referral_id` varchar(255) NOT NULL DEFAULT '0', \n `referral_amount` varchar(255) NULL, \n `referral_currency` varchar(255) NULL, \n `referral_status` int(11) NOT NULL DEFAULT '0', \n PRIMARY KEY (`id`)\n) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;
\n\nCREATE TABLE IF NOT EXISTS `bit_transactions` (\n `id` int(11) NOT NULL AUTO_INCREMENT, \n `uid` int(11) NULL, \n `transaction_id` text NULL, \n `status` int(11) NULL, \n `gateway` varchar(255) NULL, \n `amount` varchar(255) NULL, \n `currency` varchar(255) NULL, \n `time` int(11) NULL, \n PRIMARY KEY (`id`)\n) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;
\n\nCREATE TABLE IF NOT EXISTS `bit_testimonials` (\n `id` int(11) NOT NULL AUTO_INCREMENT, \n `uid` int(11) NULL, \n `type` int(11) NULL, \n `exchange_id` int(11) NULL, \n `status` int(11) NULL, \n `time` int(11) NULL, \n `content` text NULL, \n PRIMARY KEY (`id`)\n) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;
\n\nCREATE TABLE IF NOT EXISTS `bit_pages` (\n `id` int(11) NOT NULL AUTO_INCREMENT, \n `title` varchar(255) NULL, \n `prefix` varchar(255) NULL, \n `content` text NULL, \n `created` int(11) NULL, \n `updated` int(11) NULL, \n PRIMARY KEY (`id`)\n) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;
\n\nINSERT INTO `bit_pages` (`id`, `title`, `prefix`, `content`) VALUES\n(1, 'Terms of service', 'terms-of-services', 'Edit from WebAdmin.'), \n(2, 'Privacy Policy', 'privacy-policy', 'Edit from WebAdmin.'), \n(3, 'About', 'about', 'Edit from WebAdmin.');
\n\nCREATE TABLE IF NOT EXISTS `bit_faq` (\n `id` int(11) NOT NULL AUTO_INCREMENT, \n `question` varchar(255) NULL, \n `answer` text NULL, \n `created` int(11) NULL, \n `updated` int(11) NULL, \n PRIMARY KEY (`id`)\n) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;
"}

 

Editado Março 26, 2018 por matheus21