text: # ************************************************************
  # Sequel Pro SQL dump
  # Version 4541
  #
  # http://www.sequelpro.com/
  # https://github.com/sequelpro/sequelpro
  #
  # Host: 127.0.0.1 (MySQL 5.6.44)
  # Database: realestate
  # Generation Time: 2019-11-20 01:39:41 +0000
  # ************************************************************
  
  
  /*!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 utf8 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  DROP DATABASE IF EXISTS `realestate`;
  
  CREATE DATABASE `realestate` DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_general_ci;
  
  USE `realestate`;
  
  # Dump of table buildings
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `buildings`;
  
  CREATE TABLE `buildings` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `realestate_id` int(11) DEFAULT NULL,
    `name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
    `sequence_in_realestate` tinyint(1) unsigned DEFAULT NULL,
    `deleted_at` timestamp(4) NULL DEFAULT NULL,
    `created_at` timestamp(4) NULL DEFAULT NULL,
    `updated_at` timestamp(4) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT;
  
  LOCK TABLES `buildings` WRITE;
  /*!40000 ALTER TABLE `buildings` DISABLE KEYS */;
  
  INSERT INTO `buildings` (`id`, `realestate_id`, `name`, `sequence_in_realestate`, `deleted_at`, `created_at`, `updated_at`)
  VALUES
  	(100,100,X'41E6A08B',1,NULL,'2019-08-07 14:46:08.0000','2019-08-07 14:46:10.0000'),
  	(101,100,X'42E6A08B',1,NULL,'2019-08-07 14:46:08.0000','2019-08-07 14:46:10.0000'),
  	(102,101,X'41E6A08B',1,NULL,'2019-08-07 14:46:08.0000','2019-08-07 14:46:10.0000');
  
  /*!40000 ALTER TABLE `buildings` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table house_type_images
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `house_type_images`;
  
  CREATE TABLE `house_type_images` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  
  
  # Dump of table house_types
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `house_types`;
  
  CREATE TABLE `house_types` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) DEFAULT '',
    `image_id` int(11) DEFAULT NULL,
    `deleted_at` datetime DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  
  
  # Dump of table houses
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `houses`;
  
  CREATE TABLE `houses` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `building_id` int(11) DEFAULT NULL,
    `name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
    `layer` int(11) DEFAULT NULL,
    `state` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
    `sequence_in_layer` tinyint(255) DEFAULT NULL,
    `price` decimal(16,2) DEFAULT NULL,
    `deleted_at` timestamp(4) NULL DEFAULT NULL,
    `created_at` timestamp(4) NULL DEFAULT NULL,
    `updated_at` timestamp(4) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT;
  
  LOCK TABLES `houses` WRITE;
  /*!40000 ALTER TABLE `houses` DISABLE KEYS */;
  
  INSERT INTO `houses` (`id`, `building_id`, `name`, `layer`, `state`, `sequence_in_layer`, `price`, `deleted_at`, `created_at`, `updated_at`)
  VALUES
  	(100,100,X'323031',2,X'617661696C61626C65',NULL,2000000.00,NULL,'2019-08-09 11:54:49.9750','2019-08-09 11:54:49.9750'),
  	(101,100,X'323032',2,X'617661696C61626C65',NULL,2100000.00,NULL,'2019-08-09 11:54:49.9850','2019-08-09 11:54:49.9850'),
  	(102,100,X'323033',2,X'617661696C61626C65',NULL,2100000.00,NULL,'2019-08-09 11:54:49.9950','2019-08-09 11:54:49.9950'),
  	(103,100,X'323034',2,X'617661696C61626C65',NULL,2100000.00,NULL,'2019-08-09 11:54:50.0040','2019-08-09 11:54:50.0040'),
  	(104,100,X'333031',3,X'617661696C61626C65',NULL,2200000.00,NULL,'2019-08-09 11:54:50.0130','2019-08-09 11:54:50.0130'),
  	(105,100,X'333032',3,X'617661696C61626C65',NULL,2200000.00,NULL,'2019-08-09 11:54:50.0230','2019-08-09 11:54:50.0230'),
  	(106,100,X'333033',3,X'617661696C61626C65',NULL,2200000.00,NULL,'2019-08-09 11:54:50.0330','2019-08-09 11:54:50.0330'),
  	(107,100,X'333034',3,X'617661696C61626C65',NULL,2200000.00,NULL,'2019-08-09 11:54:50.0430','2019-08-09 11:54:50.0430'),
  	(108,100,X'343031',4,X'617661696C61626C65',NULL,2200000.00,NULL,'2019-08-09 11:54:50.0540','2019-08-09 11:54:50.0540'),
  	(109,100,X'343032',4,X'617661696C61626C65',NULL,2200000.00,NULL,'2019-08-09 11:54:50.0650','2019-08-09 11:54:50.0650'),
  	(110,100,X'343033',4,X'617661696C61626C65',NULL,2200000.00,NULL,'2019-08-09 11:54:50.0750','2019-08-09 11:54:50.0750'),
  	(111,100,X'343034',4,X'617661696C61626C65',NULL,2200000.00,NULL,'2019-08-09 11:54:50.0850','2019-08-09 11:54:50.0850'),
  	(112,100,X'353031',5,X'617661696C61626C65',NULL,2200000.00,NULL,'2019-08-09 11:54:50.0950','2019-08-09 11:54:50.0950'),
  	(113,100,X'353032',5,X'617661696C61626C65',NULL,3200000.00,NULL,'2019-08-09 11:54:50.1060','2019-08-09 11:54:50.1060'),
  	(114,100,X'353033',5,X'617661696C61626C65',NULL,3200000.00,NULL,'2019-08-09 11:54:50.1170','2019-08-09 11:54:50.1170'),
  	(115,100,X'353034',5,X'617661696C61626C65',NULL,3200000.00,NULL,'2019-08-09 11:54:50.1270','2019-08-09 11:54:50.1270'),
  	(116,100,X'363031',6,X'617661696C61626C65',NULL,3200000.00,NULL,'2019-08-09 11:54:50.1360','2019-08-09 11:54:50.1360'),
  	(117,100,X'363032',6,X'617661696C61626C65',NULL,3200000.00,NULL,'2019-08-09 11:54:50.1460','2019-08-09 11:54:50.1460'),
  	(118,100,X'363033',6,X'617661696C61626C65',NULL,3200000.00,NULL,'2019-08-09 11:54:50.1570','2019-08-09 11:54:50.1570'),
  	(119,100,X'363034',6,X'617661696C61626C65',NULL,3200000.00,NULL,'2019-08-09 11:54:50.1680','2019-08-09 11:54:50.1680'),
  	(120,102,X'32383031',28,X'617661696C61626C65',NULL,32000000.00,NULL,'2019-08-09 11:54:50.1780','2019-08-09 11:54:50.1780'),
  	(121,102,X'32383032',28,X'617661696C61626C65',NULL,32000000.00,NULL,'2019-08-09 11:54:50.1780','2019-08-09 11:54:50.1780');
  
  /*!40000 ALTER TABLE `houses` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table realestates
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `realestates`;
  
  CREATE TABLE `realestates` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
    `description` varchar(2048) COLLATE utf8mb4_bin DEFAULT NULL,
    `deleted_at` timestamp(4) NULL DEFAULT NULL,
    `created_at` timestamp(4) NULL DEFAULT NULL,
    `updated_at` timestamp(4) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT;
  
  LOCK TABLES `realestates` WRITE;
  /*!40000 ALTER TABLE `realestates` DISABLE KEYS */;
  
  INSERT INTO `realestates` (`id`, `name`, `description`, `deleted_at`, `created_at`, `updated_at`)
  VALUES
  	(100,X'E8BF90E6B2B3E8939DE6B9BE',X'E4B8BBE8A681E698AFE4BEBFE5AE9C',NULL,'2019-08-07 14:45:22.0000','2019-08-07 14:45:26.0000'),
  	(101,X'E6B7B1E59CB3E6B9BE31E58FB7',X'E4B8BBE8A681E698AFE8B685E8B4B5',NULL,'2019-08-07 14:45:22.0000','2019-08-07 14:45:26.0000');
  
  /*!40000 ALTER TABLE `realestates` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!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 */;
  