-- 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
) 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`) VALUES
(1, '2017-11-02 17:04:01', '2017-11-02 17:04:01', 'Harry', 'James', 'Potter', 'harry@bid2rent.com', '1234', 91, 8025632101, 0, 2, 1),
(3, '2017-11-02 17:05:43', '2017-11-02 17:05:43', 'John', 'Rimson', 'Patrix', 'john@bid2rent.com', '1234', 91, 9632145841, 0, 3, 1),
(4, '2017-11-02 17:19:42', '2017-11-02 17:19:42', 'abc', 'abc', 'abc', 'abc@bid2rent.uk', '$2y$10$JjRBTePVRHQ5OqeVh71jN.5jXWD9qse.cPmWRkhrbb6R3jNM/.Tgm', 76, 897876897, 0, 2, 1),
(5, '2017-11-02 17:20:49', '2017-11-02 17:20:49', 'ff', 's', 'fddf', 'f@fgfg', '$2y$10$lpbLMZ1iRmUF4J/UPMrE0.RGtJOAZv4kH2RXr2Z469HtJbw1gmWKC', 45, 5454545, 0, 3, 1),
(6, '2017-11-02 17:21:19', '2017-11-02 17:21:19', 'a', 'a', 'a', 'a', '$2y$10$DjVLz9lXSKMhM/CjdSd5euvGy9suOY9QVOW5FosC7QJFPZr6wWFbe', 23, 45465, 0, 2, 1);

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

--
-- 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 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 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', 0),
(2, '2017-11-02 16:24:55', '2017-11-02 16:24:55', 'Property Owner', 0),
(4, '2017-11-02 16:25:05', '2017-11-02 16:25:05', 'Tenant', 0);

--
-- 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=7;
--
-- AUTO_INCREMENT for table `user_logins`
--
ALTER TABLE `user_logins`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `user_types`
--
ALTER TABLE `user_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
