-- https://www.phpmyadmin.net/
--




--
-- Database: `bid2rent`
--

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `firstname` varchar(50) NOT NULL,
  `middlename` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `country_code` int(11) NOT NULL,
  `mobile` bigint(11) NOT NULL,
  `is_mobile_verified` int(11) NOT NULL,
  `user_type_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `otp` int(6) NOT NULL,
  `emirates_id` varchar(250) NOT NULL,
  `passport_image` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `users` (`id`, `created_at`, `modified_at`, `firstname`, `middlename`, `lastname`, `email`, `password`, `country_code`, `mobile`, `is_mobile_verified`, `user_type_id`, `status`, `otp`, `emirates_id`, `passport_image`) VALUES
(16, '2017-11-03 12:27:04', '2017-11-03 12:27:04', 'Harry', 'James', 'Potter', 'harry@bid2rent.com', '$2y$10$cO0afM.PIMwjHKTDNkCZ2eQcaWBSSOAfaOS1Fy/OHBhcxTotewDMO', 91, 8562012305, 0, 2, 1, 0, '', ''),
(18, '2017-11-03 13:13:27', '2017-11-03 13:13:27', 'lily', 'ken', 'wilson', 'lily@bid.com', '$2y$10$g88R1bjv9TnUDiCjBNlT..Y1JHTHpQetskfHCllAIjQYsLqnsRFaG', 94, 8554566, 0, 2, 1, 0, '', ''),
(32, '2017-11-08 12:58:44', '2017-11-08 12:58:44', 'Nikita', '', 'Gupta', 'earth.nikita149@gmail.com', '$2y$10$xy4vDUpLNVbxweZB9N1qAe0vQuk4Mv4C.YnBtdw7R2QrF4xX7bqAm', 971, 502315469, 0, 2, 1, 0, '', ''),
(33, '2017-11-09 12:08:25', '2017-11-09 12:08:25', 'Administrator', '', '', 'admin@bid2rent.ae', '$2y$10$9jmggrkoikfskpV2YeDNbet.EYw4386nbOfO7HrxhPKwzz2fRT52W', 971, 502314569, 0, 1, 1, 0, '', ''),
(37, '2017-11-10 12:27:17', '2017-11-10 06:58:43', 'John', '', 'Peterson', 'john@bid2rent.ae', '$2y$10$IbdvRaqExS.yKQsp/zj0l.CwMTB8UntST0NcJ7ENd7iHYjohvhFXm', 971, 501234567, 1, 2, 1, 383639, '', ''),
(38, '2017-11-10 13:04:40', '2017-11-10 07:34:44', 'Nik', '', 'Boston', 'nik@bid2rent.ae', '$2y$10$8URLaISDx5/ZBuxyrmqfqOL204pz2W5gxu45qPVc7acjPXDAx1RU.', 971, 501234567, 1, 3, 1, 889971, '', ''),
(39, '2017-11-13 10:29:37', '2017-11-13 10:29:37', 'Nick', '', 'Wikson', 'nik@bid2rent.com', '$2y$10$32dXVwzm6QWbHjIAWLs43.z3720uSwDysx88mW2YEb8G0qa/E9B/G', 971, 565656565, 0, 3, 1, 349884, '12345', '1510549177.pdf');

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

--
-- Table structure for table `user_logins`
--

CREATE TABLE `user_logins` (
  `id` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` bigint(11) NOT NULL,
  `login_time` datetime NOT NULL,
  `logout_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_logins`
--

INSERT INTO `user_logins` (`id`, `created_at`, `modified_at`, `user_id`, `login_time`, `logout_time`) VALUES
(1, '2017-11-10 12:41:02', '2017-11-13 04:11:11', 37, '2017-11-13 04:11:11', NULL);

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

--
-- Table structure for table `user_types`
--

CREATE TABLE `user_types` (
  `id` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `name` varchar(50) NOT NULL,
  `user_count` bigint(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_types`
--

INSERT INTO `user_types` (`id`, `created_at`, `modified_at`, `name`, `user_count`) VALUES
(1, '2017-11-02 16:24:55', '2017-11-02 16:24:55', 'Admin', 1),
(2, '2017-11-02 16:24:55', '2017-11-02 16:24:55', 'Property Owner', 2),
(3, '2017-11-02 16:25:05', '2017-11-02 16:25:05', 'Tenant', 2);

--
-- Indexes for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;
--
-- AUTO_INCREMENT for table `user_logins`
--
ALTER TABLE `user_logins`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `user_types`
--
ALTER TABLE `user_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
