-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Aug 05, 2021 at 06:20 AM
-- Server version: 5.7.31
-- PHP Version: 7.3.21

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `hub_live_new`
--

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

--
-- Table structure for table `members`
--

DROP TABLE IF EXISTS `members`;
CREATE TABLE IF NOT EXISTS `members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `starguide_user_id` varchar(128) CHARACTER SET latin1 NOT NULL,
  `facebook_username` varchar(128) CHARACTER SET latin1 DEFAULT NULL,
  `google_username` varchar(128) CHARACTER SET latin1 DEFAULT NULL,
  `email` varchar(128) CHARACTER SET latin1 NOT NULL,
  `full_name` varchar(128) NOT NULL,
  `gender` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
  `date_of_birth` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
  `address` varchar(128) DEFAULT NULL,
  `city` varchar(64) NOT NULL,
  `district` varchar(64) DEFAULT NULL,
  `mobile` varchar(32) CHARACTER SET latin1 NOT NULL,
  `added_date` datetime NOT NULL,
  `ip_address` varchar(64) CHARACTER SET latin1 NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `starguide_user_id` (`starguide_user_id`),
  KEY `added_date` (`added_date`)
) ENGINE=MyISAM AUTO_INCREMENT=184583 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`id`, `starguide_user_id`, `facebook_username`, `google_username`, `email`, `full_name`, `gender`, `date_of_birth`, `address`, `city`, `district`, `mobile`, `added_date`, `ip_address`, `created_at`, `updated_at`, `deleted_at`) VALUES
(164069, '164069', '', '', 'myquoc84@gmail.com', 'Quoc Tong', '', '', '', 'Hồ Chí Minh', '', '0918172128', '2021-06-07 03:50:12', '14.187.132.182', NULL, NULL, NULL),
(63836, '63836', '', '', 'quangduy22@gmail.com', 'Duy Quang', '', '', '', 'Hồ Chí Minh', '', '0908250851', '2021-06-07 03:53:16', '123.20.226.15', NULL, NULL, NULL),
(164102, '164102', '', '', 'leduylan309@gmail.com', 'Lê Duy Lân', '', '', '', 'Hồ Chí Minh', '', '0767543789', '2021-06-07 04:19:07', '1.53.205.165', NULL, NULL, NULL),
(8190, '8190', '', '', 'luuquang88@gmail.com', 'Quang Luu', '', '', '', 'Hồ Chí Minh', '', '0974650093', '2021-06-07 06:53:47', '115.73.190.109', NULL, NULL, NULL),
(1343, '1343', '', '', 'ariel_354@yahoo.com', 'Ngọc Diễm', '', '', '', 'Hồ Chí Minh', '', '0905354362', '2021-06-07 07:56:33', '116.51.40.72', NULL, NULL, NULL),
(163561, '163561', '', '', 'hoang.1992a3@gmail.com', 'Nguyễn Huy Hoàng', '', '', '', 'Hà Nội', '', '0907228992', '2021-06-10 13:04:25', '118.71.15.141', NULL, NULL, NULL),
(1324, '1324', '', '', 'vuvansanhsh@gmail.com', 'Vũ Văn Sanh', '', '', '', 'Hà Nội', '', '0822185222', '2021-06-11 06:43:07', '116.51.40.76', NULL, NULL, NULL),
(167314, '167314', '', '', 'thuhuyenle0412@yahoo.com', 'Thu Huyền', '', '', '', 'Hà Nội', '', '0932381389', '2021-06-13 12:00:27', '117.0.204.236', NULL, NULL, NULL),
(1328, '1328', '', '', 'qtuanns@gmail.com', 'Trần Quốc Tuấn', '', '', '', 'Hồ Chí Minh', '', '0908412472', '2021-06-15 03:26:51', '116.51.40.72', NULL, NULL, NULL),
(168235, '168235', '', '', 'longp7v108@gmail.com', 'Vũ Long', '', '', '', 'Hà Nội', '', '0978997993', '2021-06-15 10:29:23', '42.113.119.43', NULL, NULL, NULL),
(166506, '166506', '', '', 'hocbaocaothue@gmail.com', 'Minh Phong', '', '', '', 'Hồ Chí Minh', '', '0983429935', '2021-06-16 17:43:36', '171.235.87.12', NULL, NULL, NULL),
(109482, '109482', '', '', 'truongdm.cdu@gmail.com', 'Đàm Trường', '', '', '', 'Hà Nội', '', '0989242729', '2021-06-18 01:07:23', '222.254.35.226', NULL, NULL, NULL),
(58031, '58031', '', '', 'qhunglee@gmail.com', 'Lý Quốc Hưng', '', '', '', 'Hồ Chí Minh', '', '0902208787', '2021-06-19 08:57:07', '123.20.115.103', NULL, NULL, NULL),
(167090, '167090', '', '', 'chinhphucgiacmo@gmail.com', 'Nguyễn bá khanh', '', '', '', 'Hà Nội', '', '0943653076', '2021-06-21 05:02:50', '171.240.88.90', NULL, NULL, NULL),
(32819, '32819', '', '', 'nguyenthitham85@gmail.com', 'Phụng Phan', '', '', '', 'Hồ Chí Minh', '', '0356245825', '2021-06-21 08:37:46', '171.235.87.12', NULL, NULL, NULL),
(184582, '184582', NULL, NULL, 'truongkimphung1982@gmail.com', 'Trương Kim Phụng', NULL, NULL, NULL, 'Hồ Chí Minh', NULL, '0909021073', '2021-08-03 16:14:14', '42.118.215.61', '2021-08-03 16:14:14', '2021-08-03 16:14:14', NULL);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
