| Server IP : 162.214.74.102 / Your IP : 216.73.217.80 Web Server : Apache System : Linux dedi-4363141.lrsys.com.br 3.10.0-1160.119.1.el7.tuxcare.els25.x86_64 #1 SMP Wed Oct 1 17:37:27 UTC 2025 x86_64 User : lrsys ( 1015) PHP Version : 5.6.40 Disable Function : exec,passthru,shell_exec,system MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/lrsys/public_html/lrsys_apps/imobles/application/plugins/module_imobles/install/ |
Upload File : |
DROP TABLE IF EXISTS `module_imobles_enterprise`;
CREATE TABLE `module_imobles_enterprise` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`delete_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`delete_by` INT NULL DEFAULT NULL,
`name` VARCHAR(200) ,
`alias` VARCHAR(100),
`desc` mediumtext,
date_delivery_1 date,
module_imobles_enterprise_amenities_id int,
module_imobles_enterprise_standard_id int,
module_imobles_company_construction_id int,
financing_company_construction ENUM('Yes','No','With restriction'),
permute ENUM('Yes','No','Uninformed'),
discount decimal (10,2),
site_imobles VARCHAR(200),
link_hotsite VARCHAR(200),
link_price_list VARCHAR(200),
link_presentation VARCHAR(100),
link_table_disponible VARCHAR(200),
value_input_porcentage decimal(10,2),
value_founding_porcentage decimal(10,2),
value_installment_porcentage decimal(20,6),
link_logo VARCHAR(200),
link_mapa VARCHAR(200),
link_capa VARCHAR(200),
comparator_status ENUM('Backlog','Started','Finished'),
price_list_status ENUM('Pending','Published'),
price_list_date_verify datetime,
relese_date datetime,
release_status ENUM('In Works','Ready to move in','Lauch','Pre Launch'),
price_list_date datetime,
link_capa_comparator VARCHAR(200) ,
hubspot VARCHAR(200) ,
enable TINYINT (1) default '1',
phone VARCHAR(20) ,
site VARCHAR(200) ,
address_log VARCHAR(200) ,
address_number VARCHAR(20) ,
address_neightborhood VARCHAR(100) ,
address_city_id int ,
address_state_id int,
address_zip varchar(20),
link_google text ,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_enterprise_attachment`;
CREATE TABLE `module_imobles_enterprise_attachment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`src` varchar(100) DEFAULT NULL,
`name` text DEFAULT NULL,
`module_imobles_enterprise_id` int(11) DEFAULT NULL,
`user_id` int(11),
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `module_imobles_enterprise_amenities`;
CREATE TABLE `module_imobles_enterprise_amenities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`default` tinyint(1) DEFAULT '0',
`sorder` int(1) ,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`delete_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`delete_by` INT NULL DEFAULT NULL,
`name` VARCHAR(100),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_enterprise_standard`;
CREATE TABLE `module_imobles_enterprise_standard` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`default` tinyint(1) DEFAULT '0',
`sorder` int(1) ,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`delete_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`delete_by` INT NULL DEFAULT NULL,
`name` VARCHAR(100),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_company_construction`;
CREATE TABLE `module_imobles_company_construction` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`default` tinyint(1) DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`delete_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`delete_by` INT NULL DEFAULT NULL,
`name` VARCHAR(100),
`contact_name` VARCHAR(100),
`contact_phone` VARCHAR(20),
`state_id` int,
`city_id` int,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_company_construction`
ADD COLUMN `sorder` INT NULL AFTER `city_id`;
ALTER TABLE `module_imobles_enterprise`
CHANGE COLUMN `relese_date` `release_date` DATETIME NULL DEFAULT NULL ;
ALTER TABLE `module_imobles_enterprise_amenities`
CHANGE COLUMN `name` `name` TEXT NULL DEFAULT NULL ;
ALTER TABLE `module_imobles_enterprise_standard`
CHANGE COLUMN `name` `name` TEXT NULL DEFAULT NULL ;
ALTER TABLE `module_imobles_company_construction`
CHANGE COLUMN `name` `name` TEXT NULL DEFAULT NULL ;
LOCK TABLES `module_imobles_company_construction` WRITE;
/*!40000 ALTER TABLE `module_imobles_company_construction` DISABLE KEYS */;
INSERT INTO `module_imobles_company_construction` VALUES (1,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'OPUS',NULL,NULL,NULL,NULL,NULL),(2,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'DINÂMICA',NULL,NULL,NULL,NULL,NULL),(3,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'BAMBUÍ',NULL,NULL,NULL,NULL,NULL),(4,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'BRASAL',NULL,NULL,NULL,NULL,NULL),(5,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'CMO',NULL,NULL,NULL,NULL,NULL),(6,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'CITY',NULL,NULL,NULL,NULL,NULL),(7,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'TERRAL',NULL,NULL,NULL,NULL,NULL),(8,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'ST CONSTRUTORA',NULL,NULL,NULL,NULL,NULL),(9,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'PARTINI',NULL,NULL,NULL,NULL,NULL),(10,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'PONTAL',NULL,NULL,NULL,NULL,NULL),(11,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'EBM',NULL,NULL,NULL,NULL,NULL),(12,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'GECON',NULL,NULL,NULL,NULL,NULL),(13,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'QUEIROZ SILVEIRA',NULL,NULL,NULL,NULL,NULL),(14,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'FR INCORPORADORA',NULL,NULL,NULL,NULL,NULL),(15,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'NEW INC',NULL,NULL,NULL,NULL,NULL),(16,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'ELMO',NULL,NULL,NULL,NULL,NULL),(17,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'EUROAMÉRICA',NULL,NULL,NULL,NULL,NULL),(18,0,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'ELDORADO PARQUE',NULL,NULL,NULL,NULL,NULL),(19,0,'2020-11-05 18:30:42','2020-11-05 18:30:42',NULL,1,1,NULL,'SERCA',NULL,NULL,NULL,NULL,NULL),(20,0,'2020-11-05 18:30:42','2020-11-05 18:30:42',NULL,1,1,NULL,'ECTUAL',NULL,NULL,NULL,NULL,NULL),(21,0,'2020-11-05 18:30:42','2020-11-05 18:30:42',NULL,1,1,NULL,'ACCE',NULL,NULL,NULL,NULL,NULL),(22,0,'2020-11-05 18:30:42','2020-11-05 18:30:42',NULL,1,1,NULL,'ARGO',NULL,NULL,NULL,NULL,NULL),(23,0,'2020-11-05 18:30:42','2020-11-05 18:30:42',NULL,1,1,NULL,'TAPAJÓS',NULL,NULL,NULL,NULL,NULL),(24,0,'2020-11-05 18:30:42','2020-11-05 18:30:42',NULL,1,1,NULL,'GPL`',NULL,NULL,NULL,NULL,NULL),(25,0,'2020-11-05 18:30:42','2020-11-05 18:30:42',NULL,1,1,NULL,'DECASTRO',NULL,NULL,NULL,NULL,NULL),(26,0,'2020-11-05 18:30:42','2020-11-05 18:30:42',NULL,1,1,NULL,'EPOCA',NULL,NULL,NULL,NULL,NULL),(27,0,'2020-11-05 18:30:43','2020-11-05 18:30:43',NULL,1,1,NULL,'CONSCIENTE',NULL,NULL,NULL,NULL,NULL),(28,0,'2020-11-05 18:30:43','2020-11-05 18:30:43',NULL,1,1,NULL,'ESPAÇO CONSTRUTORA',NULL,NULL,NULL,NULL,NULL),(29,0,'2020-11-05 18:30:43','2020-11-05 18:30:43',NULL,1,1,NULL,'ÉPURA',NULL,NULL,NULL,NULL,NULL),(30,0,'2020-11-05 18:30:43','2020-11-05 18:30:43',NULL,1,1,NULL,'ICA CONSTRUTORA',NULL,NULL,NULL,NULL,NULL),(31,0,'2020-11-05 18:30:43','2020-11-05 18:30:43',NULL,1,1,NULL,'CANAL',NULL,NULL,NULL,NULL,NULL),(32,0,'2020-11-05 18:30:43','2020-11-05 18:30:43',NULL,1,1,NULL,'BARBOSA BARROS CONSTRUTORA',NULL,NULL,NULL,NULL,NULL),(33,0,'2020-11-05 18:30:43','2020-11-05 18:30:43',NULL,1,1,NULL,'CASAMORADA',NULL,NULL,NULL,NULL,NULL),(34,0,'2020-11-05 18:30:43','2020-11-05 18:30:43',NULL,1,1,NULL,'VEGA CONSTRUTORA',NULL,NULL,NULL,NULL,NULL),(35,0,'2020-11-05 18:30:43','2020-11-05 18:30:43',NULL,1,1,NULL,'ALLIANÇA ENGENHARIA',NULL,NULL,NULL,NULL,NULL),(36,0,'2020-11-05 18:30:43','2020-11-05 18:30:43',NULL,1,1,NULL,'GALWAN',NULL,NULL,NULL,NULL,NULL),(37,0,'2020-11-05 18:30:43','2020-11-05 18:30:43',NULL,1,1,NULL,'CITTÁ ENGENHARIA',NULL,NULL,NULL,NULL,NULL),(38,0,'2020-11-05 18:30:43','2020-11-05 18:30:43',NULL,1,1,NULL,'GRUPO PROENG',NULL,NULL,NULL,NULL,NULL),(39,0,'2020-11-05 18:30:43','2020-11-05 18:30:43',NULL,1,1,NULL,'SÁ CAVALCANTE',NULL,NULL,NULL,NULL,NULL),(40,0,'2020-11-05 18:30:43','2020-11-05 18:30:43',NULL,1,1,NULL,'ATRIUM',NULL,NULL,NULL,NULL,NULL),(41,0,'2020-11-05 18:30:43','2020-11-05 18:30:43',NULL,1,1,NULL,'ATTIVA',NULL,NULL,NULL,NULL,NULL),(42,0,'2020-11-05 18:30:44','2020-11-05 18:30:44',NULL,1,1,NULL,'ENEC',NULL,NULL,NULL,NULL,NULL),(43,0,'2020-11-05 18:30:44','2020-11-05 18:30:44',NULL,1,1,NULL,'ENGEL',NULL,NULL,NULL,NULL,NULL),(44,0,'2020-11-05 18:30:44','2020-11-05 18:30:44',NULL,1,1,NULL,'GRAND',NULL,NULL,NULL,NULL,NULL),(45,0,'2020-11-05 18:30:44','2020-11-05 18:30:44',NULL,1,1,NULL,'HSI',NULL,NULL,NULL,NULL,NULL),(46,0,'2020-11-05 18:30:44','2020-11-05 18:30:44',NULL,1,1,NULL,'INNOVAR',NULL,NULL,NULL,NULL,NULL),(47,0,'2020-11-05 18:30:44','2020-11-05 18:30:44',NULL,1,1,NULL,'JAVÉ CONSTRUTORA',NULL,NULL,NULL,NULL,NULL),(48,0,'2020-11-05 18:30:44','2020-11-05 18:30:44',NULL,1,1,NULL,'KEMP ENGENHARIA',NULL,NULL,NULL,NULL,NULL),(49,0,'2020-11-05 18:30:44','2020-11-05 18:30:44',NULL,1,1,NULL,'LIC INCORPORADORA',NULL,NULL,NULL,NULL,NULL),(50,0,'2020-11-05 18:30:44','2020-11-05 18:30:44',NULL,1,1,NULL,'LOFT',NULL,NULL,NULL,NULL,NULL),(51,0,'2020-11-05 18:30:44','2020-11-05 18:30:44',NULL,1,1,NULL,'MARTINS SOARES',NULL,NULL,NULL,NULL,NULL),(52,0,'2020-11-05 18:30:44','2020-11-05 18:30:44',NULL,1,1,NULL,'MÁXIMO CONSTRUTORA',NULL,NULL,NULL,NULL,NULL),(53,0,'2020-11-05 18:30:44','2020-11-05 18:30:44',NULL,1,1,NULL,'RODRIGUES DA CUNHA',NULL,NULL,NULL,NULL,NULL),(54,0,'2020-11-05 18:30:44','2020-11-05 18:30:44',NULL,1,1,NULL,'SIM ENGENHARIA',NULL,NULL,NULL,NULL,NULL),(55,0,'2020-11-05 18:30:44','2020-11-05 18:30:44',NULL,1,1,NULL,'SOUSA ANDRADE',NULL,NULL,NULL,NULL,NULL),(56,0,'2020-11-05 18:30:45','2020-11-05 18:30:45',NULL,1,1,NULL,'WR CONSTRUTORA',NULL,NULL,NULL,NULL,NULL),(57,0,'2020-11-05 18:30:45','2020-11-05 18:30:45',NULL,1,1,NULL,'WV MALDI',NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `module_imobles_company_construction` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `module_imobles_enterprise_amenities`
--
--
-- Dumping data for table `module_imobles_enterprise_standard`
--
LOCK TABLES `module_imobles_enterprise_standard` WRITE;
/*!40000 ALTER TABLE `module_imobles_enterprise_standard` DISABLE KEYS */;
INSERT INTO `module_imobles_enterprise_standard` VALUES (1,0,NULL,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'ALTO (R$ 800K-1,5M)'),(2,0,NULL,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'MÉDIO (R$ 300K-799K)'),(3,0,NULL,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'LUXO (R$ >1,5M)'),(4,0,NULL,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'BAIXO (R$ 200K-299K)'),(5,0,NULL,'2020-11-05 18:30:41','2020-11-05 18:30:41',NULL,1,1,NULL,'MCMV (R$ <200K)'),(6,0,NULL,'2020-11-05 18:30:45','2020-11-05 18:30:45',NULL,1,1,NULL,'PENDENTE');
/*!40000 ALTER TABLE `module_imobles_enterprise_standard` ENABLE KEYS */;
UNLOCK TABLES;
UPDATE `module_imobles_company_construction` SET `default`='1' WHERE `id`>='1';
UPDATE `module_imobles_enterprise_standard` SET `default`='1' WHERE `id`>='1';
DROP TABLE IF EXISTS `module_imobles_enterprise_entreprise_amenities`;
CREATE TABLE `module_imobles_enterprise_entreprise_amenities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`module_imobles_enterprise_id` int(11) DEFAULT NULL,
`module_imobles_enterprise_amenities_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `module_imobles_enterprise`
DROP COLUMN `module_imobles_enterprise_amenities_id`;
DROP TABLE IF EXISTS `module_imobles_enterprise_towers`;
CREATE TABLE `module_imobles_enterprise_towers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`title` VARCHAR(100),
`alias` VARCHAR(100),
`floors` int,
module_imobles_enterprise_id int,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
-- IMB-5
DROP TABLE IF EXISTS `module_imobles_units_amenities`;
CREATE TABLE `module_imobles_units_amenities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`default` tinyint(1) DEFAULT '0',
`sorder` int(1) ,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`delete_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`delete_by` INT NULL DEFAULT NULL,
`name` VARCHAR(100),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_enterprise_units_type`;
CREATE TABLE `module_imobles_enterprise_units_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`delete_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`delete_by` INT NULL DEFAULT NULL,
`title` VARCHAR(200) ,
`alias` VARCHAR(100),
`desc` mediumtext,
module_imobles_enterprise_id int(11) DEFAULT NULL,
area decimal (10,2),
roof TINYINT (1) default '0',
duplex TINYINT (1) default '1',
promotion TINYINT (1) default '1',
hobbox TINYINT (1) default '1',
garage_drawer TINYINT (1) default '1',
number_rooms int,
number_suite int,
number_bathroom int,
number_toilet int,
number_garage int,
link_plant VARCHAR(200),
table_disponible VARCHAR(200),
varanda_sacada ENUM('Little','Gourmet','There is not','Big'),
status_wordpress VARCHAR(200),
garages_cheaper_plant VARCHAR(200),
comparator_status ENUM('Backlog','Started','Finished'),
link_capa_comparator VARCHAR(200) ,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_enterprise_units_type_amenities`;
CREATE TABLE `module_imobles_enterprise_units_type_amenities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`module_imobles_enterprise_units_type_id` int(11) DEFAULT NULL,
`module_imobles_units_amenities_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_enterprise_units_type_plant`;
CREATE TABLE `module_imobles_enterprise_units_type_plant` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`src` varchar(100) DEFAULT NULL,
`name` text DEFAULT NULL,
`module_imobles_enterprise_units_type_id` int(11) DEFAULT NULL,
`user_id` int(11),
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_units_amenities`
RENAME TO `module_imobles_type_units_amenities` ;
DROP TABLE IF EXISTS `module_imobles_enterprise_units_type_amenities`;
CREATE TABLE `module_imobles_enterprise_units_type_amenities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`module_imobles_enterprise_units_type_id` int(11) DEFAULT NULL,
`module_imobles_units_amenities_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_enterprise_units_type_amenities`
CHANGE COLUMN `module_imobles_units_amenities_id` `module_imobles_type_units_amenities_id` INT(11) NULL DEFAULT NULL ;
DROP TABLE IF EXISTS `module_imobles_units_amenities`;
CREATE TABLE `module_imobles_units_amenities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`default` tinyint(1) DEFAULT '0',
`sorder` int(1) ,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`delete_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`delete_by` INT NULL DEFAULT NULL,
`name` VARCHAR(100),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_enterprise_units`;
CREATE TABLE `module_imobles_enterprise_units` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`delete_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`delete_by` INT NULL DEFAULT NULL,
`module_imobles_enterprise_units_type` int ,
`number_unity` VARCHAR(100),
`floor` int,
`module_imobles_enterprise_towers_id` int(11) DEFAULT NULL,
`amount` decimal (10,2),
`alias` varchar(100),
`desc` longtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_enterprise_units_amenities`;
CREATE TABLE `module_imobles_enterprise_units_amenities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`mudule_imobles_enterprise_units_id` int(11) DEFAULT NULL,
`module_imobles_units_amenities_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_enterprise_units`
CHANGE COLUMN `module_imobles_enterprise_units_type` `module_imobles_enterprise_units_type_id` INT(11) NULL DEFAULT NULL ;
ALTER TABLE `module_imobles_enterprise_units_amenities`
CHANGE COLUMN `mudule_imobles_enterprise_units_id` `module_imobles_enterprise_units_id` INT(11) NULL DEFAULT NULL ;
--
-- Alterações para Crawler da Viva Real
-- Leonardo Lopes Ramos
--
ALTER TABLE `module_imobles_enterprise_amenities`
ADD COLUMN `alias` VARCHAR(100) NULL DEFAULT NULL;
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `unitTypes` ENUM('APARTMENT','HOME', 'CONDOMINIUM', 'OTHER') NOT NULL DEFAULT 'APARTMENT',
ADD COLUMN `videoTourLink` VARCHAR(200) NULL DEFAULT NULL;
-- IMB 7
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `dec_address_log` VARCHAR(200) NULL AFTER `link_google`,
ADD COLUMN `dec_address_number` VARCHAR(20) NULL AFTER `dec_address_log`,
ADD COLUMN `dec_address_neightborhood` VARCHAR(100) NULL AFTER `dec_address_number`,
ADD COLUMN `dec_address_city_id` INT NULL AFTER `dec_address_neightborhood`,
ADD COLUMN `dec_address_state_id` INT NULL AFTER `dec_address_city_id`,
ADD COLUMN `dec_address_zip` VARCHAR(20) NULL AFTER `dec_address_state_id`;
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `obs` MEDIUMTEXT NULL AFTER `dec_address_zip`;
ALTER TABLE `module_imobles_enterprise_towers`
ADD COLUMN `stage` ENUM('In Works', 'Ready to move in', 'Lauch', 'Pre Launch') NULL AFTER `module_imobles_enterprise_id`,
ADD COLUMN `date_delivery` DATE NULL AFTER `stage`;
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `dec_address_complement` VARCHAR(100) NULL AFTER `obs`,
ADD COLUMN `address_complement` VARCHAR(100) NULL AFTER `dec_address_complement`;
-- REMOVE AS COLUNAS SOLICITADAS DO BANCO TMBM
ALTER TABLE `module_imobles_enterprise`
DROP COLUMN `link_capa_comparator`,
DROP COLUMN `price_list_date`,
DROP COLUMN `release_status`,
DROP COLUMN `release_date`,
DROP COLUMN `price_list_date_verify`,
DROP COLUMN `price_list_status`,
DROP COLUMN `comparator_status`,
DROP COLUMN `link_capa`,
DROP COLUMN `link_mapa`,
DROP COLUMN `link_logo`,
DROP COLUMN `link_table_disponible`,
DROP COLUMN `link_presentation`,
DROP COLUMN `link_price_list`,
DROP COLUMN `date_delivery_1`;
ALTER TABLE `module_imobles_company_construction`
DROP COLUMN `contact_phone`,
DROP COLUMN `contact_name`,
ADD COLUMN `crm_accounts_id` INT NULL AFTER `sorder`;
-- correção de erro que estava dando no ssitema
DROP TABLE IF EXISTS `module_imobles_enterprise_imgs`;
CREATE TABLE `module_imobles_enterprise_imgs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`delete_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`delete_by` INT NULL DEFAULT NULL,
`src` varchar(100) DEFAULT NULL,
`name` text DEFAULT NULL,
tags text,
description mediumtext,
type enum('backend','listing'),
`sorder` int(1) ,
`module_imobles_enterprise_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_enterprise_img_backend_tags`;
CREATE TABLE `module_imobles_enterprise_img_backend_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`default` tinyint(1) DEFAULT '0',
`sorder` int(1) ,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`delete_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`delete_by` INT NULL DEFAULT NULL,
`name` VARCHAR(100),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_enterprise_img_listing_tags`;
CREATE TABLE `module_imobles_enterprise_img_listing_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`default` tinyint(1) DEFAULT '0',
`sorder` int(1) ,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`delete_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`delete_by` INT NULL DEFAULT NULL,
`name` VARCHAR(100),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_company_construction_crm_accounts`;
CREATE TABLE `module_imobles_company_construction_crm_accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`module_imobles_company_construction_id` INT NULL DEFAULT NULL,
`crm_accounts_id` INT NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
-- IMB-9
DROP TABLE IF EXISTS `module_imobles_docs`;
CREATE TABLE `module_imobles_docs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`delete_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`delete_by` INT NULL DEFAULT NULL,
`src` varchar(100) DEFAULT NULL,
`name` TEXT DEFAULT NULL,
`obs` TEXT DEFAULT NULL,
`module_imobles_docs_category_id` int(11) DEFAULT NULL,
`module_imobles_enterprise_units_type_id` int(11) DEFAULT NULL,
`module_imobles_enterprise_unity_id` int(11) DEFAULT NULL,
`expiration_date` datetime DEFAULT NULL,
`module_imobles_enterprise_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_docs_category`;
CREATE TABLE `module_imobles_docs_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`default` tinyint(1) DEFAULT '0',
`sorder` int(1) ,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`delete_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`delete_by` INT NULL DEFAULT NULL,
`name` VARCHAR(100),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_docs_category`
ADD COLUMN `alias` VARCHAR(100) NULL DEFAULT NULL;
--
-- Alterações para Crawler da Viva Real
-- Leonardo Lopes Ramos
-- 07/12/2020
--
ALTER TABLE `module_imobles_enterprise_towers`
ADD COLUMN `unitsOnTheFloor` INT NULL DEFAULT NULL;
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `crawler_type` VARCHAR(200) NULL DEFAULT NULL,
ADD COLUMN `crawler_listing_id` VARCHAR(200) NULL DEFAULT NULL,
ADD COLUMN `crawler_listing_link` VARCHAR(200) NULL DEFAULT NULL,
ADD COLUMN `crawler_portal` VARCHAR(200) NULL DEFAULT NULL;
DROP TABLE IF EXISTS `module_imobles_advertisers`;
CREATE TABLE `module_imobles_advertisers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(200) NOT NULL,
`phones` VARCHAR(200) NULL DEFAULT NULL,
`logoUrl` VARCHAR(200) NULL DEFAULT NULL,
`licenseNumber` VARCHAR(200) NULL DEFAULT NULL,
`websiteUrl` VARCHAR(200) NULL DEFAULT NULL,
`crawler_type` VARCHAR(200) NULL DEFAULT NULL,
`crawler_createdDate` VARCHAR(200) NULL DEFAULT NULL,
`crawler_accountLink` VARCHAR(200) NULL DEFAULT NULL,
`crawler_advertiser_id` VARCHAR(200) NULL DEFAULT NULL,
`crawler_listing_id` VARCHAR(200) NULL DEFAULT NULL,
`crawler_listing_link` VARCHAR(200) NULL DEFAULT NULL,
`crawler_portal` VARCHAR(200) NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`delete_at` timestamp NULL DEFAULT NULL,
`delete_by` INT NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_listings`;
CREATE TABLE `module_imobles_listings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entreprise_id` INT NULL DEFAULT NULL,
`unit_type_id` INT NULL DEFAULT NULL,
`unit_id` INT NULL DEFAULT NULL,
`advertiser_id` VARCHAR(200) NULL DEFAULT NULL,
`listingType` VARCHAR(200) NULL DEFAULT NULL,
`description` mediumtext NULL DEFAULT NULL,
`title` VARCHAR(200) NULL DEFAULT NULL,
`crawler_type` VARCHAR(200) NULL DEFAULT NULL,
`crawler_contractType` VARCHAR(200) NULL DEFAULT NULL,
`crawler_createdAt` timestamp NULL DEFAULT NULL,
`crawler_updatedAt` VARCHAR(200) NULL DEFAULT NULL,
`crawler_publicationType` VARCHAR(200) NULL DEFAULT NULL,
`crawler_externalId` VARCHAR(200) NULL DEFAULT NULL,
`crawler_stamps` VARCHAR(200) NULL DEFAULT NULL,
`crawler_pricingInfos` VARCHAR(200) NULL DEFAULT NULL,
`crawler_businessType` VARCHAR(200) NULL DEFAULT NULL,
`crawler_price` decimal (10,2) NULL DEFAULT NULL,
`crawler_status` VARCHAR(200) NULL DEFAULT NULL,
`crawler_whatsappNumber` VARCHAR(200) NULL DEFAULT NULL,
`crawler_listing_id` VARCHAR(200) NULL DEFAULT NULL,
`crawler_listing_link` VARCHAR(200) NULL DEFAULT NULL,
`crawler_portal` VARCHAR(200) NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`delete_at` timestamp NULL DEFAULT NULL,
`delete_by` INT NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `latitude` Float(16,14) NULL DEFAULT NULL,
ADD COLUMN `longitude` Float(16,14) NULL DEFAULT NULL,
ADD COLUMN `crawler_poisList` VARCHAR(200) NULL DEFAULT NULL,
ADD COLUMN `google_geometry` VARCHAR(200) NULL DEFAULT NULL,
ADD COLUMN `google_phone` VARCHAR(200) NULL DEFAULT NULL,
ADD COLUMN `google_place_id` VARCHAR(200) NULL DEFAULT NULL,
ADD COLUMN `google_plus_code` VARCHAR(200) NULL DEFAULT NULL,
ADD COLUMN `google_rating` VARCHAR(200) NULL DEFAULT NULL,
ADD COLUMN `google_reference` VARCHAR(200) NULL DEFAULT NULL,
ADD COLUMN `google_reviews` VARCHAR(200) NULL DEFAULT NULL,
ADD COLUMN `google_user_ratings_total` VARCHAR(200) NULL DEFAULT NULL,
ADD COLUMN `google_json` LONGTEXT NULL DEFAULT NULL,
ADD COLUMN `address_log_sanitized` VARCHAR(200) NULL DEFAULT NULL,
ADD COLUMN `address_neighborhood_sanitized` VARCHAR(200) NULL DEFAULT NULL;
ALTER TABLE `module_imobles_listings`
ADD COLUMN `crawler_json` LONGTEXT NULL DEFAULT NULL;
DROP TABLE IF EXISTS `module_imobles_crawler_vivareal`;
CREATE TABLE `module_imobles_crawler_vivareal` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`bairro` VARCHAR(200) NULL DEFAULT NULL,
`from` INT(4) NULL DEFAULT NULL,
`status` ENUM('continue','error','finished') NULL DEFAULT NULL,
`count_linstings` INT(6) NULL DEFAULT NULL,
`return` LONGTEXT NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_enterprise`
ADD FULLTEXT INDEX `FUZZY` (`name` ASC, `desc` ASC, `address_complement` ASC);
DROP TABLE IF EXISTS `module_imobles_google_nearby`;
CREATE TABLE `module_imobles_google_nearby` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`latitude` Float(16,14) NULL DEFAULT NULL,
`longitude` Float(16,14) NULL DEFAULT NULL,
`address_encoded` VARCHAR(200) NULL DEFAULT NULL,
`google_json` LONGTEXT NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_enterprise_imgs`
ADD COLUMN `unit_type_id` INT NULL DEFAULT NULL,
ADD COLUMN `unit_id` INT NULL DEFAULT NULL,
ADD COLUMN `listing_id` INT NULL DEFAULT NULL,
ADD COLUMN `duplicated` TINYINT (1) default '0';
/*
* Leonardo Lopes Ramos
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `verified` TINYINT (1) default '0',
ADD COLUMN `crawler_json` LONGTEXT NULL DEFAULT NULL,
ADD COLUMN `crawler_enterprise_id` VARCHAR(200) NULL DEFAULT NULL,
ADD COLUMN `merge_type` ENUM('img','desc','adrress','unit_type','enterprise_name', 'manual') NULL DEFAULT NULL,
ADD COLUMN `merge_json` LONGTEXT NULL DEFAULT NULL,
ADD COLUMN `release_date` DATETIME NULL DEFAULT NULL;
ALTER TABLE `module_imobles_enterprise_units_type`
ADD COLUMN `verified` TINYINT (1) default '0';
ALTER TABLE `module_imobles_enterprise_units`
ADD COLUMN `verified` TINYINT (1) default '0';
ALTER TABLE `module_imobles_enterprise_towers`
ADD COLUMN `verified` TINYINT (1) default '0',
ADD COLUMN `deleted_at` timestamp NULL DEFAULT NULL,
ADD COLUMN `deleted_by` INT NULL DEFAULT NULL;
ALTER TABLE `module_imobles_listings`
ADD COLUMN `verified` TINYINT (1) default '0',
ADD COLUMN `merge_type` ENUM('img','desc','adrress','unit_type','enterprise_name', 'manual') NULL DEFAULT NULL;
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `alternative_names` VARCHAR(400) NULL DEFAULT NULL;
ALTER TABLE `module_imobles_listings`
ADD FULLTEXT INDEX `FUZZY` (`title` ASC, `description` ASC, `crawler_externalId` ASC);
ALTER TABLE `module_imobles_enterprise_amenities`
ADD COLUMN `type` ENUM('recreation','services','safety','plant') NULL DEFAULT NULL,
ADD COLUMN `crawler_ref` VARCHAR(200) NULL DEFAULT NULL;
ALTER TABLE `module_imobles_units_amenities`
ADD COLUMN `alias` VARCHAR(100) NULL DEFAULT NULL;
ALTER TABLE `module_imobles_type_units_amenities`
ADD COLUMN `alias` VARCHAR(100) NULL DEFAULT NULL;
LOCK TABLES `module_imobles_enterprise_amenities` WRITE;
/*!40000 ALTER TABLE `module_imobles_enterprise_amenities` DISABLE KEYS */;
INSERT INTO `module_imobles_enterprise_amenities` VALUES (1,0,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'VARANDA DE JOGOS','VARANDA DE JOGOS',NULL,NULL),(2,0,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'SALÃO DE FESTAS INFANTIL','SALÃO DE FESTAS INFANTIL',NULL,NULL),(3,1,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'SALÃO DE FESTAS','PARTY_HALL',NULL,NULL),(4,1,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'PLAYGROUND','PLAYGROUND',NULL,NULL),(5,0,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'ÁREA DE CHURRASQUEIRAS','ÁREA DE CHURRASQUEIRAS',NULL,NULL),(6,1,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'QUADRA ESPORTIVA','SPORTS_COURT',NULL,NULL),(7,1,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'PISCINA ADULTO','ADULT_POOL',NULL,NULL),(8,0,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'BRINQUEDOTECA / ESPAÇO KIDS','BRINQUEDOTECA / ESPAÇO KIDS',NULL,NULL),(9,0,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'VAGA CARRO ELÉTICO','VAGA CARRO ELÉTICO',NULL,NULL),(10,1,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'SAUNA','SAUNA',NULL,NULL),(11,1,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'ESPAÇO GOURMET','GOURMET_SPACE',NULL,NULL),(12,1,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'SALA DE JOGOS ADULTO','ADULT_GAME_ROOM',NULL,NULL),(13,0,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'ESPAÇO FITNESS / ACADEMIA','ESPAÇO FITNESS / ACADEMIA',NULL,NULL),(14,0,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'PET PLACE','PET PLACE',NULL,NULL),(15,1,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'COWORKING','COWORKING',NULL,NULL),(16,0,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'BIKE SHARING','BIKE SHARING',NULL,NULL),(17,0,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'BICICLETÁRIO','BICICLETÁRIO',NULL,NULL),(18,1,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'PISCINA INFANTIL','CHILDRENS_POOL',NULL,NULL),(19,1,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'SPA','SPA',NULL,NULL),(20,0,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'PISCINA ADULTO COBERTA','PISCINA ADULTO COBERTA',NULL,NULL),(21,0,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'MINI-QUADRA','MINI-QUADRA',NULL,NULL),(22,0,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'ADEGA GOURMET','ADEGA GOURMET',NULL,NULL),(23,0,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'ESPAÇO MULHER','ESPAÇO MULHER',NULL,NULL),(24,0,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'ROOFTOP DE LAZER','ROOFTOP DE LAZER',NULL,NULL),(25,1,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'LAVANDERIA COMPARTILHADA','LAUNDRY',NULL,NULL),(26,0,NULL,'2020-11-06 05:10:15','2020-11-06 05:10:15',NULL,1,1,NULL,'ESPAÇO OFFICE','ESPAÇO OFFICE',NULL,NULL),(27,0,NULL,'2020-11-06 05:10:16','2020-11-06 05:10:16',NULL,1,1,NULL,'PRAÇA','PRAÇA',NULL,NULL),(28,0,NULL,'2020-11-06 05:10:16','2020-11-06 05:10:16',NULL,1,1,NULL,'PILATES','PILATES',NULL,NULL),(29,0,NULL,'2020-11-06 05:10:16','2020-11-06 05:10:16',NULL,1,1,NULL,'ESPAÇO FAST FOOD','ESPAÇO FAST FOOD',NULL,NULL),(30,0,NULL,'2020-11-06 05:10:16','2020-11-06 05:10:16',NULL,1,1,NULL,'ESPAÇO SALÃO DE BELEZA','ESPAÇO SALÃO DE BELEZA',NULL,NULL),(31,0,NULL,'2020-11-06 05:10:16','2020-11-06 05:10:16',NULL,1,1,NULL,'PUB','PUB',NULL,NULL),(32,0,NULL,'2020-11-06 05:10:17','2020-11-06 05:10:17',NULL,1,1,NULL,'ESPAÇO YOGA / ZEN','ESPAÇO YOGA / ZEN',NULL,NULL),(33,1,NULL,'2020-11-06 05:10:17','2020-11-06 05:10:17',NULL,1,1,NULL,'QUADRA DE TÊNIS','TENNIS_COURT',NULL,NULL),(34,0,NULL,'2020-11-06 05:10:17','2020-11-06 05:10:17',NULL,1,1,NULL,'CAR SHARING','CAR SHARING',NULL,NULL),(35,0,NULL,'2020-11-06 05:10:17','2020-11-06 05:10:17',NULL,1,1,NULL,'XADREZ KIDS','XADREZ KIDS',NULL,NULL),(36,0,NULL,'2020-11-06 05:10:17','2020-11-06 05:10:17',NULL,1,1,NULL,'SNOOKER','SNOOKER',NULL,NULL),(37,0,NULL,'2020-11-06 05:10:17','2020-11-06 05:10:17',NULL,1,1,NULL,'LAGO','LAGO',NULL,NULL),(38,0,NULL,'2020-11-06 05:10:17','2020-11-06 05:10:17',NULL,1,1,NULL,'PARQUE INFANTIL','PARQUE INFANTIL',NULL,NULL),(39,0,NULL,'2020-11-06 05:10:17','2020-11-06 05:10:17',NULL,1,1,NULL,'ESPAÇO LEITURA','ESPAÇO LEITURA',NULL,NULL),(40,0,NULL,'2020-11-06 05:10:17','2020-11-06 05:10:17',NULL,1,1,NULL,'PISCINA AQUECIDA','PISCINA AQUECIDA',NULL,NULL),(41,1,NULL,'2020-11-06 05:10:17','2020-11-06 05:10:17',NULL,1,1,NULL,'PISTA DE CAMINHADA','HIKING_TRAIL',NULL,NULL),(42,0,NULL,'2020-11-06 05:10:18','2020-11-06 05:10:18',NULL,1,1,NULL,'HORTA COMUNITÁRIA','HORTA COMUNITÁRIA',NULL,NULL),(43,0,NULL,'2020-11-06 05:10:18','2020-11-06 05:10:18',NULL,1,1,NULL,'CINEMA','CINEMA',NULL,NULL),(44,0,NULL,'2020-11-06 05:10:18','2020-11-06 05:10:18',NULL,1,1,NULL,'TERRAÇO GOURMET','TERRAÇO GOURMET',NULL,NULL),(45,0,NULL,'2020-11-06 05:10:18','2020-11-06 05:10:18',NULL,1,1,NULL,'PET CARE','PET CARE',NULL,NULL),(46,1,NULL,'2020-11-06 05:10:18','2020-11-06 05:10:18',NULL,1,1,NULL,'SALA DE MASSAGEM','MASSAGE',NULL,NULL),(47,0,NULL,'2020-11-06 05:10:19','2020-11-06 05:10:19',NULL,1,1,NULL,'PERGOLADO','PERGOLADO',NULL,NULL),(48,1,NULL,'2020-11-06 05:10:19','2020-11-06 05:10:19',NULL,1,1,NULL,'QUADRA DE SQUASH','SQUASH',NULL,NULL),(49,0,NULL,'2020-11-06 05:10:20','2020-11-06 05:10:20',NULL,1,1,NULL,'GARAGE BAND','GARAGE BAND',NULL,NULL),(50,0,NULL,'2020-11-06 05:10:20','2020-11-06 05:10:20',NULL,1,1,NULL,'DOG PARK','DOG PARK',NULL,NULL),(51,0,NULL,'2020-11-06 05:10:20','2020-11-06 05:10:20',NULL,1,1,NULL,'ATELIÊ','ATELIÊ',NULL,NULL),(52,0,NULL,'2020-11-06 05:10:20','2020-11-06 05:10:20',NULL,1,1,NULL,'SCOOTERS E CARROS ELÉTRICOS','SCOOTERS E CARROS ELÉTRICOS',NULL,NULL),(53,0,NULL,'2020-11-06 05:10:20','2020-11-06 05:10:20',NULL,1,1,NULL,'CAR WASH','CAR WASH',NULL,NULL),(54,0,NULL,'2020-11-06 05:10:20','2020-11-06 05:10:20',NULL,1,1,NULL,'CAFETERIA','CAFETERIA',NULL,NULL),(55,0,NULL,'2020-11-06 05:10:20','2020-11-06 05:10:20',NULL,1,1,NULL,'BOLICHE','BOLICHE',NULL,NULL),(56,0,NULL,'2020-11-06 05:10:20','2020-11-06 05:10:20',NULL,1,1,NULL,'PISCINA SEMI-OLIMPICO','PISCINA SEMI-OLIMPICO',NULL,NULL),(57,0,NULL,'2020-11-06 05:10:21','2020-11-06 05:10:21',NULL,1,1,NULL,'ESPAÇO BUSINESS','ESPAÇO BUSINESS',NULL,NULL),(58,0,NULL,'2020-11-06 05:10:22','2020-11-06 05:10:22',NULL,1,1,NULL,'HIDROMASSAGEM','HIDROMASSAGEM',NULL,NULL),(59,0,NULL,'2020-11-06 05:10:22','2020-11-06 05:10:22',NULL,1,1,NULL,'FRAUDÁRIO','FRAUDÁRIO',NULL,NULL),(60,0,NULL,'2020-11-06 05:10:22','2020-11-06 05:10:22',NULL,1,1,NULL,'CABANAS','CABANAS',NULL,NULL),(61,0,NULL,'2020-11-06 05:10:23','2020-11-06 05:10:23',NULL,1,1,NULL,'PRAÇA DE ESPORTES','PRAÇA DE ESPORTES',NULL,NULL),(63,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'ACADEMIA','GYM',NULL,NULL),(65,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'PARQUE','GREEN_SPACE',NULL,NULL),(66,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'JARDIM','GARDEN',NULL,NULL),(67,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'PISCINA','POOL',NULL,NULL),(68,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'QUINTAL','BACKYARD',NULL,NULL),(71,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'INTERNET','INTERNET_ACCESS',NULL,NULL),(72,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'DEPÓSITO','DEPOSIT',NULL,NULL),(73,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'ELEVADOR','ELEVATOR',NULL,NULL),(74,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'GARAGEM','GARAGE',NULL,NULL),(75,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'GERADOR ELÉTRICO','ELECTRIC_GENERATOR',NULL,NULL),(78,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'RECEPÇÃO','RECEPTION',NULL,NULL),(79,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'TV A CABO','CABLE_TV',NULL,NULL),(80,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'CIRCUITO DE SEGURANÇA','SAFETY_CIRCUIT',NULL,NULL),(81,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'CONDOMÍNIO FECHADO','GATED_COMMUNITY',NULL,NULL),(82,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'INTERFONE','INTERCOM',NULL,NULL),(83,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'SEGURANÇA 24H','SECURITY_24_HOURS',NULL,NULL),(84,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'SISTEMA DE ALARME','ALARM_SYSTEM',NULL,NULL),(85,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'VIGIA','WATCHMAN',NULL,NULL),(86,1,NULL,NULL,'2021-02-10 14:18:50',NULL,NULL,NULL,NULL,'ÁREA DE SERVIÇO','SERVICE_AREA',NULL,NULL),(91,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'SALA DE JANTAR','DINNER_ROOM',NULL,NULL),(92,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'HOME CINEMA','HOME_CINEMA',NULL,NULL),(94,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'ESPAÇO TEEN','TEEN_SPACE',NULL,NULL),(95,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'GRAMADO','GRASS',NULL,NULL),(98,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'PET FRIENDLY','PETS_ALLOWED',NULL,NULL),(99,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'COPA','COPA',NULL,NULL),(100,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'PRÓXIMO A ESTRADAS DE ACESSO','NEAR_ACCESS_ROADS',NULL,NULL),(101,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'PRÓXIMO AO SHOPPING','NEAR_SHOPPING_CENTER',NULL,NULL),(102,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'SALA DE JOGOS TEEN','YOUTH_GAME_ROOM',NULL,NULL),(103,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'PRÓXIMO A ESCOLAS','NEAR_SCHOOL',NULL,NULL),(104,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'PRÓXIMO AO TRANSPORTE PÚBLICO','NEAR_PUBLIC_TRANSPORT',NULL,NULL),(105,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'PRÓXIMO A HOSPITAL','NEAR_HOSPITAL',NULL,NULL),(108,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'DISABLED ACCESS','DISABLED_ACCESS',NULL,NULL),(109,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'ÁREA DE RECREAÇÃO','RECREATION_AREA',NULL,NULL),(112,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'SALA DE JOGOS','GAMES_ROOM',NULL,NULL),(114,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'PRÓXIMO A SERVIÇOS PÚBLICOS','ESSENTIAL_PUBLIC_SERVICES',NULL,NULL),(115,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'JANELAS AMPLAS','LARGE_WINDOW',NULL,NULL),(116,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'PAY PER USE SERVICES','PAY_PER_USE_SERVICES',NULL,NULL),(117,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'PORCELANA','PORCELAIN',NULL,NULL),(118,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'VENTILAÇÃO NATURAL','NATURAL_VENTILATION',NULL,NULL),(119,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'GAS ENCANADO','PLATED_GAS',NULL,NULL),(121,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'HALL DE ENTRADA','ENTRANCE_HALL',NULL,NULL),(122,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'COZINHA AMERICANA','AMERICAN_KITCHEN',NULL,NULL),(123,1,NULL,NULL,'2021-02-10 14:48:53',NULL,NULL,NULL,NULL,'VARANDA COM CHURRASQUEIRA','BARBECUE_BALCONY',NULL,NULL);
/*!40000 ALTER TABLE `module_imobles_enterprise_amenities` ENABLE KEYS */;
UNLOCK TABLES;
LOCK TABLES `module_imobles_type_units_amenities` WRITE;
/*!40000 ALTER TABLE `module_imobles_type_units_amenities` DISABLE KEYS */;
INSERT INTO `module_imobles_type_units_amenities` VALUES (1,1,NULL,NULL,'2021-02-10 18:01:14',NULL,NULL,NULL,NULL,'CHURRASQUEIRA','BARBECUE_GRILL'),(2,1,NULL,NULL,'2021-02-10 18:01:14',NULL,NULL,NULL,NULL,'COZINHA','KITCHEN'),(3,1,NULL,NULL,'2021-02-10 18:01:14',NULL,NULL,NULL,NULL,'COZINHA AMPLA','LARGE_KITCHEN'),(4,1,NULL,NULL,'2021-02-10 18:01:14',NULL,NULL,NULL,NULL,'JANELAS AMPLAS','LARGE_WINDOW'),(5,1,NULL,NULL,'2021-02-10 18:01:14',NULL,NULL,NULL,NULL,'LAREIRA','FIREPLACE'),(6,1,NULL,NULL,'2021-02-10 18:01:14',NULL,NULL,NULL,NULL,'QUARTO AMPLO','LARGE_ROOM'),(7,1,NULL,NULL,'2021-02-10 18:01:14',NULL,NULL,NULL,NULL,'SALA DE JANTAR','DINNER_ROOM'),(8,1,NULL,NULL,'2021-02-10 18:01:14',NULL,NULL,NULL,NULL,'VARANDA','BALCONY'),(9,1,NULL,NULL,'2021-02-10 18:01:14',NULL,NULL,NULL,NULL,'VARANDA COM CHURRASQUEIRA','BARBECUE_BALCONY'),(10,1,NULL,NULL,'2021-02-10 18:01:14',NULL,NULL,NULL,NULL,'VARANDA GOURMET','GOURMET_BALCONY'),(11,1,NULL,NULL,'2021-02-10 18:01:14',NULL,NULL,NULL,NULL,'VENTILAÇÃO NATURAL','NATURAL_VENTILATION'),(12,1,NULL,NULL,'2021-02-10 18:01:14',NULL,NULL,NULL,NULL,'ÁREA DE SERVIÇO','SERVICE_AREA');
/*!40000 ALTER TABLE `module_imobles_type_units_amenities` ENABLE KEYS */;
UNLOCK TABLES;
LOCK TABLES `module_imobles_units_amenities` WRITE;
/*!40000 ALTER TABLE `module_imobles_units_amenities` DISABLE KEYS */;
INSERT INTO `module_imobles_units_amenities` VALUES (1,1,NULL,NULL,'2021-02-10 18:01:22',NULL,NULL,NULL,NULL,'AMBIENTES INTEGRADOS','INTEGRATED_ENVIRONMENTS'),(2,1,NULL,NULL,'2021-02-10 18:01:22',NULL,NULL,NULL,NULL,'AQUECIMENTO','HEATING'),(3,1,NULL,NULL,'2021-02-10 18:01:22',NULL,NULL,NULL,NULL,'AR CONDICIONADO','AIR_CONDITIONING'),(4,1,NULL,NULL,'2021-02-10 18:01:22',NULL,NULL,NULL,NULL,'ARMÁRIO EMBUTIDO','BUILTIN_WARDROBE'),(5,1,NULL,NULL,'2021-02-10 18:01:22',NULL,NULL,NULL,NULL,'ARMÁRIO NA COZINHA','KITCHEN_CABINETS'),(6,1,NULL,NULL,'2021-02-10 18:01:22',NULL,NULL,NULL,NULL,'CABEAMENTO COMPLETO','FULL_CABLING'),(7,1,NULL,NULL,'2021-02-10 18:01:22',NULL,NULL,NULL,NULL,'CLOSET','CLOSET'),(8,1,NULL,NULL,'2021-02-10 18:01:22',NULL,NULL,NULL,NULL,'ESCRITÓRIO','HOME_OFFICE'),(9,1,NULL,NULL,'2021-02-10 18:01:22',NULL,NULL,NULL,NULL,'MOBILIADO','FURNISHED'),(10,1,NULL,NULL,'2021-02-10 18:01:22',NULL,NULL,NULL,NULL,'TV A CABO','CABLE_TV'),(11,1,NULL,NULL,'2021-02-10 18:01:22',NULL,NULL,NULL,NULL,'VISTA ABERTA','EXTERIOR_VIEW'),(12,1,NULL,NULL,'2021-02-10 18:01:22',NULL,NULL,NULL,NULL,'VISTA PARA LAGO','LAKE_VIEW');
/*!40000 ALTER TABLE `module_imobles_units_amenities` ENABLE KEYS */;
UNLOCK TABLES;
/*
/ REGISTRO AS TAGS PARA CADASTRO DAS IMAGENS DOS EMPREENDIMENTOS
*/
LOCK TABLES `module_imobles_enterprise_img_backend_tags` WRITE;
/*!40000 ALTER TABLE `module_imobles_enterprise_img_backend_tags` DISABLE KEYS */;
INSERT INTO `module_imobles_enterprise_img_backend_tags` VALUES (1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'capa'),(2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'logo'),(3,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'capa_comparador'),(4,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'planta');
/*!40000 ALTER TABLE `module_imobles_enterprise_img_backend_tags` ENABLE KEYS */;
UNLOCK TABLES;
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `link_price_table` VARCHAR(400) NULL DEFAULT NULL,
ADD COLUMN `link_presentation` VARCHAR(400) NULL DEFAULT NULL,
ADD COLUMN `link_availability` VARCHAR(400) NULL DEFAULT NULL;
DROP TABLE IF EXISTS `module_imobles_crawler_forbidden_terms`;
CREATE TABLE `module_imobles_crawler_forbidden_terms` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_by` INT NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`term` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `module_imobles_crawler_forbidden_terms`
--
LOCK TABLES `module_imobles_crawler_forbidden_terms` WRITE;
/*!40000 ALTER TABLE `module_imobles_crawler_forbidden_terms` DISABLE KEYS */;
INSERT INTO `module_imobles_crawler_forbidden_terms` VALUES (1,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'term'),(2,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'vaca brava'),(3,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'areiao'),(4,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Bougainville'),(5,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Américas'),(6,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Atlanta'),(7,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Ibéria'),(8,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Lago'),(9,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Seville'),(10,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Parque'),(11,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Floresta'),(12,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Humaitá'),(13,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Ipê'),(14,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Mont Serrat'),(15,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Rio Branco'),(16,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Serra Do Mar'),(17,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Trade Center'),(18,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'TransAmérica'),(19,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Praia Grande'),(20,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Confidence'),(21,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Rio'),(22,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Ponta Negra'),(23,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'Rio');
/*!40000 ALTER TABLE `module_imobles_crawler_forbidden_terms` ENABLE KEYS */;
UNLOCK TABLES;
/*
/ LEONARDO LOPES RAMOS
*/
DROP TABLE IF EXISTS `module_imobles_crawler_types`;
CREATE TABLE `module_imobles_crawler_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_by` INT NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`type` varchar(100) DEFAULT NULL,
`name` varchar(100) DEFAULT NULL,
`description` varchar(400) DEFAULT NULL,
`params` LONGTEXT DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
LOCK TABLES `module_imobles_crawler_types` WRITE;
INSERT INTO `module_imobles_crawler_types` (`type`, `name`) VALUES ('vivareal', 'Zap Imóveis');
INSERT INTO `module_imobles_crawler_types` (`type`, `name`) VALUES ('googlemaps', 'Google Maps');
INSERT INTO `module_imobles_crawler_types` (`type`, `name`) VALUES ('arcgis_gyn', 'Mapa Fácil Goiânia');
INSERT INTO `module_imobles_crawler_types` (`type`, `name`) VALUES ('airtable', 'Imobles - AirTable');
UNLOCK TABLES;
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `crawler_type_id` INT NULL DEFAULT NULL;
ALTER TABLE `module_imobles_enterprise_units_type`
ADD COLUMN `crawler_type_id` INT NULL DEFAULT NULL;
ALTER TABLE `module_imobles_enterprise_units`
ADD COLUMN `unavailable` INT NULL DEFAULT NULL,
ADD COLUMN `crawler_type_id` INT NULL DEFAULT NULL;
ALTER TABLE `module_imobles_listings`
ADD COLUMN `crawler_type_id` INT NULL DEFAULT NULL;
-- IMB-15
ALTER TABLE `module_imobles_listings`
ADD COLUMN `unavailable` TINYINT(1) NULL AFTER `crawler_type_id`;
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `crawler_neighborhood_id` INT NULL DEFAULT NULL;
-- IMB-16 INDICE PARA AGILIZAR A CONSULTA
ALTER TABLE `module_imobles_listings`
ADD INDEX `indice` (`advertiser_id` ASC, `delete_at` ASC);
ALTER TABLE `module_imobles_listings`
ADD INDEX `indice_query_listing` (`entreprise_id` ASC, `advertiser_id` ASC, `crawler_businessType` ASC, `unavailable` ASC);
ALTER TABLE `module_imobles_enterprise`
ADD INDEX `module_imobles_enterprise_search` (`crawler_type_id` ASC, `crawler_enterprise_id` ASC, `google_place_id` ASC, `verified` ASC);
ALTER TABLE `module_imobles_listings`
ADD INDEX `indice_query_listing_type_unity` (`unit_type_id` ASC, `advertiser_id` ASC, `crawler_businessType` ASC, `unavailable` ASC);
ALTER TABLE `module_imobles_enterprise_towers`
ADD INDEX `indice` (`module_imobles_enterprise_id` ASC, `stage` ASC);
-- IMB 18 INDICES
ALTER TABLE `module_imobles_enterprise_imgs`
ADD INDEX `index2` (`delete_at` ASC, `module_imobles_enterprise_id` ASC);
ALTER TABLE `module_imobles_listings`
ADD INDEX `indice_api` (`unit_type_id` ASC, `advertiser_id` ASC, `crawler_type_id` ASC, `unavailable` ASC);
ALTER TABLE `module_imobles_enterprise_towers`
ADD INDEX `indice_api` (`module_imobles_enterprise_id` ASC, `date_delivery` DESC);
ALTER TABLE `module_imobles_enterprise_entreprise_amenities`
ADD INDEX `indice` (`module_imobles_enterprise_id` ASC, `module_imobles_enterprise_amenities_id` ASC);
ALTER TABLE `module_imobles_enterprise`
ADD INDEX `indice_api` (`delete_at` ASC, `verified` ASC);
-- ANDRÉ CAMARGO
-- IMB-19
ALTER TABLE `module_imobles_type_units_amenities`
ADD COLUMN `type` VARCHAR(100) NULL AFTER `alias`;
DROP TABLE IF EXISTS `module_imobles_mandeumzap_listings`;
CREATE TABLE `module_imobles_mandeumzap_listings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` INT NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`advertise_id` INT NULL DEFAULT NULL,
`listing_id` INT NULL DEFAULT NULL,
`send_at` timestamp NULL DEFAULT NULL,
`muz_msg_id` INT NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_mandeumzap_listings`
ADD COLUMN `msg` MEDIUMTEXT NULL AFTER `muz_msg_id`;
-- CORREÇÃO DO NOME DA COLUNA BANCO
ALTER TABLE `module_imobles_mandeumzap_listings`
CHANGE COLUMN `advertise_id` `advertiser_id` INT(11) NULL DEFAULT NULL ;
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `airtable_id` VARCHAR(400) NULL DEFAULT NULL,
ADD COLUMN `link_decorated` VARCHAR(400) NULL DEFAULT NULL;
ALTER TABLE `module_imobles_enterprise_units_type`
ADD COLUMN `airtable_id` VARCHAR(400) NULL DEFAULT NULL;
ALTER TABLE `module_imobles_enterprise_units_type`
CHANGE COLUMN `varanda_sacada` `varanda_sacada` ENUM('Opcional', 'Sala Gourmet', 'Sem Varanda', 'Técnica', 'Varanda Balcão', 'Varanda com Piscina', 'Varanda Gourmet', 'Varanda Tradicional') NULL DEFAULT NULL;
/*
// LEONARDO LOPES RAMOS
// 29/04/2021
*/
CREATE TABLE `module_imobles_listings_prices` (
`id` INT NOT NULL AUTO_INCREMENT,
`listing_id` INT(11) NOT NULL,
`unit_type_id` INT(11) NOT NULL,
`date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`rental` INT(1) NULL DEFAULT NULL,
`price` FLOAT(16,2) NULL DEFAULT NULL,
`yearly_iptu` FLOAT(10,2) NULL DEFAULT NULL,
`condo_fee` FLOAT(10,2) NULL DEFAULT NULL,
PRIMARY KEY (`id`)
);
ALTER TABLE `module_imobles_listings_prices`
ADD INDEX `listing_id` (`listing_id` ASC),
ADD INDEX `unit_type_id` (`unit_type_id` ASC);
/*
// LEONARDO LOPES RAMOS
// 30/04/2021
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `imobles_client` INT(1) NULL DEFAULT NULL;
/*
// ANDRE CAMARGO, INDEX CONSULTA MOSTRAR UNIDADES DISPONIVEIS
// 04/05/2021
*/
ALTER TABLE `module_imobles_enterprise_units`
ADD INDEX `indice_buscador` (`module_imobles_enterprise_units_type_id` ASC, `delete_at` ASC, `crawler_type_id` ASC, `unavailable` ASC);
/*
// LEONARDO LOPES RAMOS
// 11/05/2021
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `has_listing` INT(1) NULL DEFAULT NULL;
ALTER TABLE `module_imobles_enterprise_amenities`
CHANGE COLUMN `type` `type` ENUM('recreation','services','safety','fitness') NULL DEFAULT NULL ;
ALTER TABLE `module_imobles_type_units_amenities`
CHANGE COLUMN `type` `type` ENUM('recreation','services','safety','fitness','plant') NULL DEFAULT NULL ;
ALTER TABLE `module_imobles_enterprise_amenities`
ADD COLUMN `required` INT(1) NULL DEFAULT NULL;
/*
// LEONARDO LOPES RAMOS
// 18/05/2021
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `wordpress_id` INT(11) NULL DEFAULT NULL;
/*
// LEONARDO LOPES RAMOS
// 01/06/2021
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `init_sales` timestamp NULL DEFAULT NULL;
/*
// LEONARDO LOPES RAMOS
// 29/06/2021
*/
ALTER TABLE `module_imobles_enterprise_imgs`
ADD COLUMN `webp` TINYINT (1) default null,
ADD COLUMN `resized` TINYINT (1) default null;
/*
// ANDRE IMB-25
// 29/06/2021
*/
DROP TABLE IF EXISTS `module_imobles_proposal`;
CREATE TABLE `module_imobles_proposal` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_by` INT NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`user_id` int DEFAULT NULL,
client_id int DEFAULT NULL,
resale int DEFAULT 0,
unit_type_ids mediumtext,
listing_ids mediumtext,
review int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `module_imobles_proposal_estimate`;
CREATE TABLE `module_imobles_proposal_estimate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_by` INT NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`listing_id` int DEFAULT NULL,
proposal_id int DEFAULT NULL,
obs mediumtext,
review int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*
// LEONARDO LOPES RAMOS
// 06/07/2021
*/
ALTER TABLE `module_imobles_enterprise_units`
ADD COLUMN `garage_covered` INT (1) default null,
ADD COLUMN `garage_area` decimal (10,2) default null;
/*
// LEONARDO LOPES RAMOS
// 06/07/2021
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `site_enabled` INT (1) default null;
/*
// LEONARDO LOPES RAMOS
// 04/08/2021
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `hotsite_params` LONGTEXT NULL DEFAULT NULL;
ALTER TABLE `module_imobles_company_construction`
ADD COLUMN `hotsite_params` LONGTEXT NULL DEFAULT NULL;
ALTER TABLE `module_imobles_enterprise_imgs`
ADD COLUMN `construction_company_id` INT NULL DEFAULT NULL;
/*
// PAULO RODRIGO MOREIRA
// 06/07/2021
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `csv_translator_class` VARCHAR (100) default null,
ADD COLUMN `csv_translator_method` VARCHAR (100) default null;
ALTER TABLE `module_imobles_docs`
ADD COLUMN `processed` INT (1) default null,
ADD COLUMN `csv_translation_error` INT (1) default null;
/*
// PAULO MOREIRA
// 18/08/2021
*/
ALTER TABLE `module_imobles_enterprise_units_type`
ADD COLUMN `site_enabled` INT (1) default null;
/*
// LEONARDO LOPES RAMOS
//
*/
ALTER TABLE `module_imobles_listings`
ADD COLUMN `review_unit_type` INT (1) default null;
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `site_url` VARCHAR (150) default null,
ADD COLUMN `site_url_canonical` LONGTEXT NULL DEFAULT NULL;
/*
// ANDRE CAMARGO
// 31/08/2021
// PW-152 - PW-154
*/
DROP TABLE IF EXISTS `module_imobles_cache`;
CREATE TABLE `module_imobles_cache` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_by` INT NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`controller` ENUM('ApiController') DEFAULT 'ApiController',
`method` ENUM('searchDevelopments','developmentDetails','getLocations','sitemapGenerator'),
json_input mediumtext,
json_input_hash mediumtext,
json_output LONGTEXT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB ;
ALTER TABLE `module_imobles_cache`
ADD INDEX `indice` (`controller` ASC, `method` ASC),
ADD FULLTEXT INDEX `full` (`json_input_hash` ASC);
ALTER TABLE `module_imobles_cache`
CHANGE COLUMN `json_input_hash` `json_input_hash` VARCHAR(500) NULL DEFAULT NULL ;
ALTER TABLE `module_imobles_cache`
DROP INDEX `indice`,
ADD INDEX `indice` (`controller` ASC, `method` ASC, `json_input_hash` ASC);
ALTER TABLE `module_imobles_cache`
CHANGE COLUMN `json_input` `json_input` LONGTEXT NULL DEFAULT NULL ,
CHANGE COLUMN `json_output` `json_output` LONGTEXT NULL DEFAULT NULL ;
ALTER TABLE `module_imobles_cache`
DROP INDEX `full` ;
ALTER TABLE `module_imobles_cache`
CHANGE COLUMN `json_input_hash` `json_input_hash` VARCHAR(200) NULL DEFAULT NULL ;
ALTER TABLE `module_imobles_cache`
ADD INDEX `indice2` (`controller` ASC),
ADD INDEX `indice3` (`method` ASC),
ADD INDEX `indice4` (`json_input_hash` ASC);
/*
// PAULO MOREIRA
// 03/09/2021
*/
DROP TABLE IF EXISTS `module_imobles_dynamic_urls`;
CREATE TABLE `module_imobles_dynamic_urls` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_by` INT NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`url` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/na-planta');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/pronto-para-morar');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/1-quartos');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/2-quartos');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/3-quartos');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/4-quartos');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/alphaville-araguaia');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/alto-da-gloria');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/chacaras-dona-ge');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/eldorado');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/jardim-america');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/jardim-atlantico');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/jardim-bom-jesus');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/jardim-das-esmeraldas');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/jardim-europa');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/jardim-goias');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/parque-amazonia');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/parque-flamboyant');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/parque-oeste-industrial');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/setor-aeroporto');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/setor-bela-vista');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/setor-bueno');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/setor-campinas');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/setor-central');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/setor-coimbra');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/setor-crimeia-oeste');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/setor-marista');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/setor-negrao-de-lima');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/setor-nova-suica');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/setor-oeste');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/setor-pedro-ludovico');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/setor-serra-dourada');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/setor-serrinha');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/setor-universitario');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/vila-lucy');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/vila-rosa');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/5-quartos');
INSERT INTO `module_imobles_dynamic_urls` (url) VALUES ('https://imobles.com/apartamentos/venda/goiania/setor-leste-universitario');
/*
// ANDRE CAMARGO
// 31/08/2021
// PW-152 - PW-153
*/
DROP TABLE IF EXISTS `module_imobles_neighborhoods`;
CREATE TABLE `module_imobles_neighborhoods` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_by` INT NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`state_id` INT NULL DEFAULT NULL,
`city_id` INT NULL DEFAULT NULL,
`name` text,
`sanitized_name` text,
`alternative_names` mediumtext,
`google_place_id` text,
`params` mediumtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB ;
DROP TABLE IF EXISTS `module_imobles_neighborhoods_related`;
CREATE TABLE `module_imobles_neighborhoods_related` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`neighborhood_id` INT ,
`related_neighborhood_id` INT ,
PRIMARY KEY (`id`)
) ENGINE=InnoDB ;
/*
// LEONARDO LOPES RAMOS
// 09/09/2021
*/
ALTER TABLE `module_imobles_company_construction`
ADD COLUMN `google_place_id` VARCHAR(200) NULL DEFAULT NULL,
ADD COLUMN `google_place_json` LONGTEXT NULL DEFAULT NULL;
/*
// PAULO MOREIRA
// 10/09/2021
*/
ALTER TABLE `module_imobles_dynamic_urls`
ADD COLUMN `update_frequency` ENUM('DAILY','WEEKLY', 'MONTHLY') NOT NULL DEFAULT 'DAILY';
/*
// LEONARDO LOPES RAMOS
// 15/07/20201
*/
ALTER TABLE `module_imobles_cache`
CHANGE COLUMN `method` `method` ENUM('searchDevelopments','developmentDetails','getLocations','sitemapGenerator','dynamicUrls','constructionCompanyUrls','companyConstructionDetails') NULL DEFAULT NULL;
/*
// LEONARDO LOPES RAMOS
// 16/09/2021
*/
ALTER TABLE `module_imobles_company_construction`
ADD COLUMN `address_log` VARCHAR(200) NULL DEFAULT NULL,
ADD COLUMN `address_number` INT(10) NULL DEFAULT NULL;
/*
// ANDRÉ CAMARGO
// 23/09/2021
*/
ALTER TABLE `module_imobles_cache`
CHANGE COLUMN `method` `method` ENUM('searchDevelopments', 'developmentDetails', 'getLocations', 'sitemapGenerator', 'dynamicUrls', 'constructionCompanyUrls', 'companyConstructionDetails', 'searchDevelopmentsSimilar') NULL DEFAULT NULL ;
ALTER TABLE `module_imobles_enterprise_imgs`
ADD INDEX `indice3` (`unit_type_id` ASC, `type` ASC, `delete_at` ASC);
/*
// LEONARDO LOPES
// 22/10/2021
*/
ALTER TABLE module_imobles_enterprise
CHANGE COLUMN value_input_porcentage value_input_porcentage DECIMAL(10,6) NULL DEFAULT NULL ,
CHANGE COLUMN value_founding_porcentage value_founding_porcentage DECIMAL(10,6) NULL DEFAULT NULL ,
CHANGE COLUMN value_installment_porcentage value_installment_porcentage DECIMAL(20,6) NULL DEFAULT NULL ;
/*
// PAULO RODRIGO MOREIRA
// 06/07/2021
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `fetch_from_drive` INT(1) default null;
ALTER TABLE `module_imobles_docs`
ADD COLUMN `google_drive_id` VARCHAR(200) default null;
/*
// GLAUCO MELCHIORS EMERIM
// 03/11/2021
// PW-228
*/
ALTER TABLE `module_imobles_neighborhoods`
ADD COLUMN `preposition` ENUM('In', 'On') NULL AFTER `params`;
/*
// GLAUCO MELCHIORS EMERIM
// 09/11/2021
// PW-322
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `sanitized` INT(1) NULL DEFAULT NULL;
/*
// GLAUCO MELCHIORS EMERIM
// 09/11/2021
// PW-323
*/
ALTER TABLE `module_imobles_enterprise_units_type` CHANGE
COLUMN `varanda_sacada` `varanda_sacada` ENUM('Opcional', 'Sala Gourmet', 'Sem Varanda', 'Técnica', 'Varanda Balcão', 'Varanda com Piscina', 'Varanda Gourmet', 'Varanda Tradicional', 'Garden') NULL DEFAULT NULL ;
/*
// GLAUCO MELCHIORS EMERIM
// 19/11/2021
// PW-326
*/
LOCK TABLES `module_imobles_crawler_types` WRITE;
INSERT INTO `module_imobles_crawler_types` (`type`, `name`) VALUES ('ingaia', 'inGaia');
INSERT INTO `module_imobles_crawler_types` (`type`, `name`) VALUES ('proprietariodireto', 'Proprietário Direto');
INSERT INTO `module_imobles_crawler_types` (`type`, `name`) VALUES ('quintoandar', 'Quinto Andar');
INSERT INTO `module_imobles_crawler_types` (`type`, `name`) VALUES ('mercadolivre', 'Mercado Livre');
INSERT INTO `module_imobles_crawler_types` (`type`, `name`) VALUES ('uol', 'UOL');
INSERT INTO `module_imobles_crawler_types` (`type`, `name`) VALUES ('urbs', 'URBS');
INSERT INTO `module_imobles_crawler_types` (`type`, `name`) VALUES ('loopim', 'LOOPIM');
UNLOCK TABLES;
/*
// GLAUCO MELCHIORS EMERIM
// 10/12/2021
// PW-333
*/
ALTER TABLE `module_imobles_enterprise_units_type`
ADD COLUMN `units_number_ends` VARCHAR(10) NULL AFTER `site_enabled`;
/*
// LEONARDO LOPES RAMOS
// 16/12/2021
// PW-346
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `relevance` INT(3) NULL DEFAULT NULL,
ADD COLUMN `slug` VARCHAR(200) NULL DEFAULT NULL,
ADD UNIQUE INDEX `slug_UNIQUE` (`slug` ASC);
/*
// GLAUCO MELCHIORS EMERIM
// 20/12/2021
// PW-335
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `value_signal_porcentage` DECIMAL(10,6) NULL DEFAULT NULL,
ADD COLUMN `value_semester_porcentage` DECIMAL(10,6) NULL DEFAULT NULL,
ADD COLUMN `value_keys_porcentage` DECIMAL(10,6) NULL DEFAULT NULL,
ADD COLUMN `value_financed_porcentage` DECIMAL(10,6) NULL DEFAULT NULL,
ADD COLUMN `value_total_porcentage` DECIMAL(10,6) NULL DEFAULT NULL,
ADD COLUMN `value_difference_porcentage` DECIMAL(10,6) NULL DEFAULT NULL,
ADD COLUMN `financing_input_qtd` INT(3) NULL DEFAULT NULL,
ADD COLUMN `financing_signal_qtd` INT(3) NULL DEFAULT NULL,
ADD COLUMN `financing_monthly_qtd` INT(3) NULL DEFAULT NULL,
ADD COLUMN `financing_semester_qtd` INT(3) NULL DEFAULT NULL,
ADD COLUMN `financing_keys_qtd` INT(3) NULL DEFAULT NULL,
ADD COLUMN `financing_input_value` DECIMAL(10,2) NULL DEFAULT NULL,
ADD COLUMN `financing_signal_value` DECIMAL(10,2) NULL DEFAULT NULL,
ADD COLUMN `financing_monthly_value` DECIMAL(10,2) NULL DEFAULT NULL,
ADD COLUMN `financing_semester_value` DECIMAL(10,2) NULL DEFAULT NULL,
ADD COLUMN `financing_keys_value` DECIMAL(10,2) NULL DEFAULT NULL,
ADD COLUMN `financing_financed_value` DECIMAL(10,2) NULL DEFAULT NULL,
ADD COLUMN `financing_total_value` DECIMAL(10,2) NULL DEFAULT NULL,
ADD COLUMN `financing_founding_value` DECIMAL(10,2) NULL DEFAULT NULL,
ADD COLUMN `financing_total_calculated_value` DECIMAL(10,2) NULL DEFAULT NULL,
ADD COLUMN `financing_difference_value` DECIMAL(10,2) NULL DEFAULT NULL;
/*
// GLAUCO MELCHIORS EMERIM
// 31/12/2021
// PW-341
*/
DROP TABLE IF EXISTS `module_imobles_portal_listings_types`;
CREATE TABLE `module_imobles_portal_listings_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_by` INT NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`type` varchar(100) DEFAULT NULL,
`name` varchar(100) DEFAULT NULL,
`description` varchar(400) DEFAULT NULL,
`params` LONGTEXT DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
LOCK TABLES `module_imobles_portal_listings_types` WRITE;
INSERT INTO `module_imobles_portal_listings_types` (`type`, `name`) VALUES ('grupozap', 'Grupo Zap');
UNLOCK TABLES;
DROP TABLE IF EXISTS `module_imobles_portal_listings`;
CREATE TABLE `module_imobles_portal_listings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`delete_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`delete_by` INT NULL DEFAULT NULL,
`module_imobles_enterprise_id` int(11) DEFAULT NULL,
`module_imobles_enterprise_units_type_id` int(11) DEFAULT NULL,
`module_imobles_portal_listings_types_id` int(11) DEFAULT NULL,
`xml` text DEFAULT NULL,
`error` VARCHAR(300) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `portal_publication_type` VARCHAR(30) DEFAULT NULL;
ALTER TABLE `module_imobles_enterprise_units_type`
ADD COLUMN `portal_listings_update` TINYINT(1) DEFAULT NULL;
/*
// LEONARDO LOPES RAMOS
// 13/01/2022
// PW-347
*/
ALTER TABLE `module_imobles_company_construction`
ADD COLUMN `site_url` VARCHAR (150) NULL DEFAULT null,
ADD COLUMN `slug` VARCHAR(200) NULL DEFAULT NULL,
ADD UNIQUE INDEX `slug_UNIQUE` (`slug` ASC);