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




--
-- Database: `bid2rent`
--

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

--
-- Table structure for table `amenities`
--

CREATE TABLE `amenities` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon_class` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int(11) NOT NULL,
  `amenity_status_id` int(11) NOT NULL,
  `property_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `amenities`
--

INSERT INTO `amenities` (`id`, `created_at`, `updated_at`, `name`, `icon_class`, `sort_order`, `amenity_status_id`, `property_count`) VALUES
(1, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Washer/Dryer In Unit', 'parking-spot', 1, 1, 0),
(2, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Pool', 'parking-spot', 2, 1, 0),
(3, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Gym', 'parking-spot', 3, 1, 0),
(4, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Elevator', 'parking-spot', 4, 1, 0),
(5, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Parking Spot', 'parking-spot', 5, 1, 0),
(6, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Fireplace', 'parking-spot', 6, 1, 0),
(7, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Air Conditioning', 'parking-spot', 7, 1, 0),
(8, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Doorman', 'parking-spot', 8, 1, 0),
(9, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Dishwasher', 'parking-spot', 9, 1, 0),
(10, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Deck', 'parking-spot', 10, 1, 0),
(11, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Storage', 'parking-spot', 11, 1, 0),
(12, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Wheelchair Accessible', 'parking-spot', 12, 1, 0),
(13, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Hardwood Floors', 'parking-spot', 13, 1, 0),
(14, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Garden', 'parking-spot', 14, 1, 0),
(15, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Balcony', 'parking-spot', 15, 1, 0),
(16, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Furnished', 'parking-spot', 16, 1, 0),
(17, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'View', 'parking-spot', 17, 1, 0),
(18, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Student Friendly', 'parking-spot', 18, 1, 0),
(19, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'High Rise', 'parking-spot', 19, 1, 0),
(20, '2017-11-20 03:49:13', '2017-11-20 03:49:13', 'Utilities Included', 'parking-spot', 20, 1, 0),
(21, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Washer/Dryer In Unit', 'parking-spot', 1, 1, 0),
(22, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Pool', 'parking-spot', 2, 1, 0),
(23, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Gym', 'parking-spot', 3, 1, 0),
(24, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Elevator', 'parking-spot', 4, 1, 0),
(25, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Parking Spot', 'parking-spot', 5, 1, 0),
(26, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Fireplace', 'parking-spot', 6, 1, 0),
(27, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Air Conditioning', 'parking-spot', 7, 1, 0),
(28, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Doorman', 'parking-spot', 8, 1, 0),
(29, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Dishwasher', 'parking-spot', 9, 1, 0),
(30, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Deck', 'parking-spot', 10, 1, 0),
(31, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Storage', 'parking-spot', 11, 1, 0),
(32, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Wheelchair Accessible', 'parking-spot', 12, 1, 0),
(33, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Hardwood Floors', 'parking-spot', 13, 1, 0),
(34, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Garden', 'parking-spot', 14, 1, 0),
(35, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Balcony', 'parking-spot', 15, 1, 0),
(36, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Furnished', 'parking-spot', 16, 1, 0),
(37, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'View', 'parking-spot', 17, 1, 0),
(38, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Student Friendly', 'parking-spot', 18, 1, 0),
(39, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'High Rise', 'parking-spot', 19, 1, 0),
(40, '2017-11-20 03:49:43', '2017-11-20 03:49:43', 'Utilities Included', 'parking-spot', 20, 1, 0),
(41, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Washer/Dryer In Unit', 'parking-spot', 1, 1, 0),
(42, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Pool', 'parking-spot', 2, 1, 0),
(43, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Gym', 'parking-spot', 3, 1, 0),
(44, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Elevator', 'parking-spot', 4, 1, 0),
(45, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Parking Spot', 'parking-spot', 5, 1, 0),
(46, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Fireplace', 'parking-spot', 6, 1, 0),
(47, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Air Conditioning', 'parking-spot', 7, 1, 0),
(48, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Doorman', 'parking-spot', 8, 1, 0),
(49, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Dishwasher', 'parking-spot', 9, 1, 0),
(50, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Deck', 'parking-spot', 10, 1, 0),
(51, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Storage', 'parking-spot', 11, 1, 0),
(52, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Wheelchair Accessible', 'parking-spot', 12, 1, 0),
(53, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Hardwood Floors', 'parking-spot', 13, 1, 0),
(54, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Garden', 'parking-spot', 14, 1, 0),
(55, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Balcony', 'parking-spot', 15, 1, 0),
(56, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Furnished', 'parking-spot', 16, 1, 0),
(57, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'View', 'parking-spot', 17, 1, 0),
(58, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Student Friendly', 'parking-spot', 18, 1, 0),
(59, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'High Rise', 'parking-spot', 19, 1, 0),
(60, '2017-11-20 03:49:48', '2017-11-20 03:49:48', 'Utilities Included', 'parking-spot', 20, 1, 0),
(61, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Washer/Dryer In Unit', 'parking-spot', 1, 1, 0),
(62, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Pool', 'parking-spot', 2, 1, 0),
(63, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Gym', 'parking-spot', 3, 1, 0),
(64, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Elevator', 'parking-spot', 4, 1, 0),
(65, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Parking Spot', 'parking-spot', 5, 1, 0),
(66, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Fireplace', 'parking-spot', 6, 1, 0),
(67, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Air Conditioning', 'parking-spot', 7, 1, 0),
(68, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Doorman', 'parking-spot', 8, 1, 0),
(69, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Dishwasher', 'parking-spot', 9, 1, 0),
(70, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Deck', 'parking-spot', 10, 1, 0),
(71, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Storage', 'parking-spot', 11, 1, 0),
(72, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Wheelchair Accessible', 'parking-spot', 12, 1, 0),
(73, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Hardwood Floors', 'parking-spot', 13, 1, 0),
(74, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Garden', 'parking-spot', 14, 1, 0),
(75, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Balcony', 'parking-spot', 15, 1, 0),
(76, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Furnished', 'parking-spot', 16, 1, 0),
(77, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'View', 'parking-spot', 17, 1, 0),
(78, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Student Friendly', 'parking-spot', 18, 1, 0),
(79, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'High Rise', 'parking-spot', 19, 1, 0),
(80, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Utilities Included', 'parking-spot', 20, 1, 0),
(81, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Washer/Dryer In Unit', 'parking-spot', 1, 1, 0),
(82, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Pool', 'parking-spot', 2, 1, 0),
(83, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Gym', 'parking-spot', 3, 1, 0),
(84, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Elevator', 'parking-spot', 4, 1, 0),
(85, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Parking Spot', 'parking-spot', 5, 1, 0),
(86, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Fireplace', 'parking-spot', 6, 1, 0),
(87, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Air Conditioning', 'parking-spot', 7, 1, 0),
(88, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Doorman', 'parking-spot', 8, 1, 0),
(89, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Dishwasher', 'parking-spot', 9, 1, 0),
(90, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Deck', 'parking-spot', 10, 1, 0),
(91, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Storage', 'parking-spot', 11, 1, 0),
(92, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Wheelchair Accessible', 'parking-spot', 12, 1, 0),
(93, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Hardwood Floors', 'parking-spot', 13, 1, 0),
(94, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Garden', 'parking-spot', 14, 1, 0),
(95, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Balcony', 'parking-spot', 15, 1, 0),
(96, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Furnished', 'parking-spot', 16, 1, 0),
(97, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'View', 'parking-spot', 17, 1, 0),
(98, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Student Friendly', 'parking-spot', 18, 1, 0),
(99, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'High Rise', 'parking-spot', 19, 1, 0),
(100, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Utilities Included', 'parking-spot', 20, 1, 0),
(101, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Washer/Dryer In Unit', 'parking-spot', 1, 1, 0),
(102, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Pool', 'parking-spot', 2, 1, 0),
(103, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Gym', 'parking-spot', 3, 1, 0),
(104, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Elevator', 'parking-spot', 4, 1, 0),
(105, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Parking Spot', 'parking-spot', 5, 1, 0),
(106, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Fireplace', 'parking-spot', 6, 1, 0),
(107, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Air Conditioning', 'parking-spot', 7, 1, 0),
(108, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Doorman', 'parking-spot', 8, 1, 0),
(109, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Dishwasher', 'parking-spot', 9, 1, 0),
(110, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Deck', 'parking-spot', 10, 1, 0),
(111, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Storage', 'parking-spot', 11, 1, 0),
(112, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Wheelchair Accessible', 'parking-spot', 12, 1, 0),
(113, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Hardwood Floors', 'parking-spot', 13, 1, 0),
(114, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Garden', 'parking-spot', 14, 1, 0),
(115, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Balcony', 'parking-spot', 15, 1, 0),
(116, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Furnished', 'parking-spot', 16, 1, 0),
(117, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'View', 'parking-spot', 17, 1, 0),
(118, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Student Friendly', 'parking-spot', 18, 1, 0),
(119, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'High Rise', 'parking-spot', 19, 1, 0),
(120, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Utilities Included', 'parking-spot', 20, 1, 0),
(121, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Washer/Dryer In Unit', 'parking-spot', 1, 1, 0),
(122, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Pool', 'parking-spot', 2, 1, 0),
(123, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Gym', 'parking-spot', 3, 1, 0),
(124, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Elevator', 'parking-spot', 4, 1, 0),
(125, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Parking Spot', 'parking-spot', 5, 1, 0),
(126, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Fireplace', 'parking-spot', 6, 1, 0),
(127, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Air Conditioning', 'parking-spot', 7, 1, 0),
(128, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Doorman', 'parking-spot', 8, 1, 0),
(129, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Dishwasher', 'parking-spot', 9, 1, 0),
(130, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Deck', 'parking-spot', 10, 1, 0),
(131, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Storage', 'parking-spot', 11, 1, 0),
(132, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Wheelchair Accessible', 'parking-spot', 12, 1, 0),
(133, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Hardwood Floors', 'parking-spot', 13, 1, 0),
(134, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Garden', 'parking-spot', 14, 1, 0),
(135, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Balcony', 'parking-spot', 15, 1, 0),
(136, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Furnished', 'parking-spot', 16, 1, 0),
(137, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'View', 'parking-spot', 17, 1, 0),
(138, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Student Friendly', 'parking-spot', 18, 1, 0),
(139, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'High Rise', 'parking-spot', 19, 1, 0),
(140, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Utilities Included', 'parking-spot', 20, 1, 0);

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

--
-- Table structure for table `amenity_property`
--

CREATE TABLE `amenity_property` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `amenity_id` int(11) NOT NULL,
  `property_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `amenity_statuses`
--

CREATE TABLE `amenity_statuses` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amenity_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `amenity_statuses`
--

INSERT INTO `amenity_statuses` (`id`, `created_at`, `updated_at`, `name`, `amenity_count`) VALUES
(1, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Active', 0),
(2, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Inactive', 0),
(3, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Suspended', 0),
(4, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Expired', 0),
(5, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Closed', 0),
(6, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Active', 0),
(7, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Inactive', 0),
(8, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Suspended', 0),
(9, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Expired', 0),
(10, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Closed', 0),
(11, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Active', 0),
(12, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Inactive', 0),
(13, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Suspended', 0),
(14, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Expired', 0),
(15, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Closed', 0),
(16, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Active', 0),
(17, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Inactive', 0),
(18, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Suspended', 0),
(19, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Expired', 0),
(20, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Closed', 0);

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

--
-- Table structure for table `app_codes`
--

CREATE TABLE `app_codes` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `app_code_status_id` int(11) NOT NULL,
  `app_code_category_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `app_code_categories`
--

CREATE TABLE `app_code_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int(11) NOT NULL,
  `app_code_count` int(11) NOT NULL,
  `app_code_category_status_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `app_code_categories`
--

INSERT INTO `app_code_categories` (`id`, `created_at`, `updated_at`, `name`, `category_code`, `description`, `sort_order`, `app_code_count`, `app_code_category_status_id`) VALUES
(1, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Emirates', 'emirates', 'Lorem ipsum dummy test', 1, 0, 1),
(2, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Property Type', 'property_type', 'Lorem ipsum dummy test', 1, 0, 1),
(3, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Viewing Options', 'viewing_option', 'Lorem ipsum dummy test', 1, 0, 1),
(4, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Bed Room Sizes', 'bed_room_size', 'Lorem ipsum dummy test', 1, 0, 1),
(5, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Wash Room Sizes', 'bed_room_size', 'Lorem ipsum dummy test', 1, 0, 1),
(6, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Emirates', 'emirates', 'Lorem ipsum dummy test', 1, 0, 1),
(7, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Property Type', 'property_type', 'Lorem ipsum dummy test', 1, 0, 1),
(8, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Viewing Options', 'viewing_option', 'Lorem ipsum dummy test', 1, 0, 1),
(9, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Bed Room Sizes', 'bed_room_size', 'Lorem ipsum dummy test', 1, 0, 1),
(10, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Wash Room Sizes', 'bed_room_size', 'Lorem ipsum dummy test', 1, 0, 1),
(11, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Emirates', 'emirates', 'Lorem ipsum dummy test', 1, 0, 1),
(12, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Property Type', 'property_type', 'Lorem ipsum dummy test', 1, 0, 1),
(13, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Viewing Options', 'viewing_option', 'Lorem ipsum dummy test', 1, 0, 1),
(14, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Bed Room Sizes', 'bed_room_size', 'Lorem ipsum dummy test', 1, 0, 1),
(15, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Wash Room Sizes', 'bed_room_size', 'Lorem ipsum dummy test', 1, 0, 1),
(16, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Emirates', 'emirates', 'Lorem ipsum dummy test', 1, 0, 1),
(17, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Property Type', 'property_type', 'Lorem ipsum dummy test', 1, 0, 1),
(18, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Viewing Options', 'viewing_option', 'Lorem ipsum dummy test', 1, 0, 1),
(19, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Bed Room Sizes', 'bed_room_size', 'Lorem ipsum dummy test', 1, 0, 1),
(20, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Wash Room Sizes', 'bed_room_size', 'Lorem ipsum dummy test', 1, 0, 1);

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

--
-- Table structure for table `app_code_statuses`
--

CREATE TABLE `app_code_statuses` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `app_code_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `app_code_statuses`
--

INSERT INTO `app_code_statuses` (`id`, `created_at`, `updated_at`, `name`, `app_code_count`) VALUES
(1, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Active', 0),
(2, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Inactive', 0),
(3, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Active', 0),
(4, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Inactive', 0),
(5, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Active', 0),
(6, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Inactive', 0),
(7, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Active', 0),
(8, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Inactive', 0);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2017_11_18_112919_create_property_table', 1),
(2, '2017_11_18_113013_create_amenities_table', 1),
(3, '2017_11_18_115541_create_amenity_property_table', 1),
(4, '2017_11_18_115701_create_amenity_status_table', 1),
(5, '2017_11_18_121357_create_property_status_table', 1),
(6, '2017_11_18_145903_create_policy_types', 1),
(7, '2017_11_18_145925_create_policies', 1),
(8, '2017_11_19_175409_create_app_code_categories', 1),
(9, '2017_11_19_181338_create_app_codes', 1),
(10, '2017_11_19_181612_create_app_code_statuses', 1),
(11, '2017_11_20_085637_create_users_table', 2),
(12, '2017_11_20_091213_create_user_types_table', 3);

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

--
-- Table structure for table `policies`
--

CREATE TABLE `policies` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci COMMENT 'Helper Text',
  `policy_type_id` int(11) NOT NULL,
  `policy_status_id` int(11) NOT NULL COMMENT '1=Active;0=Inactive',
  `property_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `policies`
--

INSERT INTO `policies` (`id`, `created_at`, `updated_at`, `name`, `description`, `policy_type_id`, `policy_status_id`, `property_count`) VALUES
(1, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'No dogs', NULL, 1, 1, 0),
(2, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'No cats', NULL, 1, 1, 0),
(3, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Cleaning at tenants risk', NULL, 1, 1, 0),
(4, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'No more drilling on walls', NULL, 2, 1, 0),
(5, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'No wall papers allowed', NULL, 2, 1, 0),
(6, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'No dogs', NULL, 1, 1, 0),
(7, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'No cats', NULL, 1, 1, 0),
(8, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Cleaning at tenants risk', NULL, 1, 1, 0),
(9, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'No more drilling on walls', NULL, 2, 1, 0),
(10, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'No wall papers allowed', NULL, 2, 1, 0),
(11, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'No dogs', NULL, 1, 1, 0),
(12, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'No cats', NULL, 1, 1, 0),
(13, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Cleaning at tenants risk', NULL, 1, 1, 0),
(14, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'No more drilling on walls', NULL, 2, 1, 0),
(15, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'No wall papers allowed', NULL, 2, 1, 0),
(16, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'No dogs', NULL, 1, 1, 0),
(17, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'No cats', NULL, 1, 1, 0),
(18, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Cleaning at tenants risk', NULL, 1, 1, 0),
(19, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'No more drilling on walls', NULL, 2, 1, 0),
(20, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'No wall papers allowed', NULL, 2, 1, 0);

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

--
-- Table structure for table `policy_types`
--

CREATE TABLE `policy_types` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Helper Text',
  `is_additional_deposit_required` tinyint(4) NOT NULL COMMENT '1=Additional deposit required; 0=Deposit Not required'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `policy_types`
--

INSERT INTO `policy_types` (`id`, `created_at`, `updated_at`, `name`, `description`, `is_additional_deposit_required`) VALUES
(1, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Pet policy', 'Something about pet animals', 0),
(2, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Maintenence policy', 'Something about Maintenence policy', 0),
(3, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Renovation policy', 'Something about pet policy', 0),
(4, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Pet policy', 'Something about pet animals', 0),
(5, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Maintenence policy', 'Something about Maintenence policy', 0),
(6, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Renovation policy', 'Something about pet policy', 0),
(7, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Pet policy', 'Something about pet animals', 0),
(8, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Maintenence policy', 'Something about Maintenence policy', 0),
(9, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Renovation policy', 'Something about pet policy', 0),
(10, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Pet policy', 'Something about pet animals', 0),
(11, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Maintenence policy', 'Something about Maintenence policy', 0),
(12, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Renovation policy', 'Something about pet policy', 0);

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

--
-- Table structure for table `properties`
--

CREATE TABLE `properties` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Property Name',
  `address` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit` int(11) NOT NULL,
  `area` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitude` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `longitude` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `monthly_rent` double(10,2) NOT NULL COMMENT 'Monthly Rent',
  `security_deposit` double(10,2) NOT NULL COMMENT 'One time deposit',
  `total_price` double(10,2) NOT NULL COMMENT 'Sum of monthly rent, Security Deposit and additional deposit if any',
  `other_policies` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `available_from` date NOT NULL,
  `emirate_id` bigint(20) NOT NULL,
  `property_type_id` bigint(20) NOT NULL,
  `vieweing_option_id` bigint(20) NOT NULL,
  `bedroom_size_id` bigint(20) NOT NULL,
  `washroom_size_id` bigint(20) NOT NULL,
  `landlord_id` bigint(20) NOT NULL,
  `bid_count` int(11) NOT NULL,
  `property_status_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `property_statuses`
--

CREATE TABLE `property_statuses` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `property_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_statuses`
--

INSERT INTO `property_statuses` (`id`, `created_at`, `updated_at`, `name`, `property_count`) VALUES
(1, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Active', 0),
(2, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Inactive', 0),
(3, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Suspended', 0),
(4, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Expired', 0),
(5, '2017-11-20 03:50:15', '2017-11-20 03:50:15', 'Closed', 0),
(6, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Active', 0),
(7, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Inactive', 0),
(8, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Suspended', 0),
(9, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Expired', 0),
(10, '2017-11-20 03:50:28', '2017-11-20 03:50:28', 'Closed', 0),
(11, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Active', 0),
(12, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Inactive', 0),
(13, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Suspended', 0),
(14, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Expired', 0),
(15, '2017-11-20 03:51:43', '2017-11-20 03:51:43', 'Closed', 0),
(16, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Active', 0),
(17, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Inactive', 0),
(18, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Suspended', 0),
(19, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Expired', 0),
(20, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Closed', 0);

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

--
-- 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(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name',
  `user_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `user_types` (`id`, `created_at`, `updated_at`, `name`, `user_count`) VALUES
(1, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Admin', 0),
(2, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Property Owner', 1),
(3, '2017-11-20 03:51:57', '2017-11-20 03:51:57', 'Tenant', 2);

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

--
-- Table structure for table `user_types_old`
--

CREATE TABLE `user_types_old` (
  `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 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `user_types_old`
--

INSERT INTO `user_types_old` (`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 `amenities`
--
ALTER TABLE `amenities`
  ADD PRIMARY KEY (`id`);

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `property_statuses`
--
ALTER TABLE `property_statuses`
  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`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `amenities`
--
ALTER TABLE `amenities`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=141;
--
-- AUTO_INCREMENT for table `amenity_property`
--
ALTER TABLE `amenity_property`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `amenity_statuses`
--
ALTER TABLE `amenity_statuses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `app_codes`
--
ALTER TABLE `app_codes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `app_code_categories`
--
ALTER TABLE `app_code_categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `app_code_statuses`
--
ALTER TABLE `app_code_statuses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `policies`
--
ALTER TABLE `policies`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `policy_types`
--
ALTER TABLE `policy_types`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `properties`
--
ALTER TABLE `properties`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `property_statuses`
--
ALTER TABLE `property_statuses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
--
-- 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(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `user_types_old`
--
ALTER TABLE `user_types_old`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
