| Server IP : 162.214.74.102 / Your IP : 216.73.217.114 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/www/lrsys_apps/leo/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);
/*
// GLAUCO MELCHIORS EMERIM
// 17/01/2022
// PW-341-New
*/
ALTER TABLE `module_imobles_enterprise`
DROP COLUMN `portal_publication_type`;
ALTER TABLE `module_imobles_enterprise_units_type`
ADD COLUMN `portal_publication_type` ENUM('STANDARD', 'PREMIUM', 'SUPER PREMIUM', 'DO NOT PUBLISH');
ALTER TABLE `module_imobles_portal_listings`
DROP COLUMN `module_imobles_enterprise_id`,
DROP COLUMN `module_imobles_enterprise_units_type_id`,
DROP COLUMN `error`,
ADD COLUMN `total_listings` INT NULL DEFAULT NULL,
ADD COLUMN `total_errors` INT NULL DEFAULT NULL,
ADD COLUMN `errors` TEXT DEFAULT NULL;
ALTER TABLE `module_imobles_portal_listings`
MODIFY `xml` MEDIUMTEXT DEFAULT NULL;
TRUNCATE `module_imobles_portal_listings`;
DROP TABLE IF EXISTS `module_imobles_portal_listings_units_type`;
CREATE TABLE `module_imobles_portal_listings_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,
`module_imobles_portal_listings_id` int(11) DEFAULT NULL,
`module_imobles_enterprise_units_type_id` int(11) DEFAULT NULL,
`module_imobles_enterprise_id` int(11) DEFAULT NULL,
`xml` MEDIUMTEXT DEFAULT NULL,
`error` VARCHAR(300) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* GLAUCO MELCHIORS EMERIM
* 11/01/2022
* PW-363
*/
DROP TABLE IF EXISTS `module_imobles_whatsapp_campaign`;
CREATE TABLE `module_imobles_whatsapp_campaign` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`created_at` TIMESTAMP NULL DEFAULT NULL,
`updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` TIMESTAMP NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`title` VARCHAR(100) DEFAULT NULL,
`message` TEXT DEFAULT NULL,
`csv` TEXT DEFAULT NULL,
`start_time` TIME NULL DEFAULT NULL,
`end_time` TIME NULL DEFAULT NULL,
`daily_limit` INT(6) DEFAULT NULL,
`total_sent` INT(9) DEFAULT NULL,
`status` ENUM('pending', 'sending', 'finished') NOT NULL DEFAULT 'pending',
`active` TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_whatsapp_campaign_contact`;
CREATE TABLE `module_imobles_whatsapp_campaign_contact` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`created_at` TIMESTAMP NULL DEFAULT NULL,
`updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` TIMESTAMP NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`module_imobles_whatsapp_campaign_id` INT(11) NOT NULL,
`name` VARCHAR(30) NOT NULL,
`phone` VARCHAR(30) NOT NULL,
`origin` VARCHAR(30) DEFAULT NULL,
`sent` TINYINT(1) NOT NULL DEFAULT '0',
`sent_at` TIMESTAMP NULL DEFAULT NULL,
`error` VARCHAR(300) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/* GLAUCO MELCHIORS EMERIM
* 04/02/2022
* PW-441
*/
ALTER TABLE `module_imobles_listings`
ADD COLUMN `called_at` TIMESTAMP NULL DEFAULT NULL,
ADD COLUMN `called_by` INT NULL DEFAULT NULL,
ADD COLUMN `called_msg` TEXT NULL DEFAULT NULL;
/* ANDRE CAMARGO
* 02/03/2022
* PW-456
*/
DROP TABLE IF EXISTS `module_imobles_leads_conversion_type`;
CREATE TABLE `module_imobles_leads_conversion_type` (
`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),
`alias` VARCHAR(100),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_leads_conversion_fields`;
CREATE TABLE `module_imobles_leads_conversion_fields` (
`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),
`alias` VARCHAR(100),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_leads_conversion`;
CREATE TABLE `module_imobles_leads_conversion` (
`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,
`crm_accounts_id` INT NULL DEFAULT NULL,
`page_uri` text NULL DEFAULT NULL,
`page_name` text NULL DEFAULT NULL,
`development_id` INT NULL DEFAULT NULL,
`unit_type_id` INT NULL DEFAULT NULL,
`ip_address` varchar(100) NULL DEFAULT NULL,
`hutk` varchar(100) NULL DEFAULT NULL,
`hs_sync` int NULL DEFAULT NULL,
`params` mediumtext NULL DEFAULT NULL,
`conversion_type_id` INT NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_leads_conversion_params`;
CREATE TABLE `module_imobles_leads_conversion_params` (
`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,
`conversion_id` INT NULL DEFAULT NULL,
`conversion_field_id` INT NULL DEFAULT NULL,
`value` mediumtext NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* ANDRE CAMARGO
* 27/02/2022
* PW-457
*/
ALTER TABLE `module_imobles_enterprise_units_type`
ADD COLUMN `parent_id` INT NULL AFTER `portal_publication_type`;
DROP TABLE IF EXISTS `module_imobles_digisac_contacts`;
CREATE TABLE `module_imobles_digisac_contacts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`crm_account_id` INT NULL DEFAULT NULL,
`contact_id` varchar(200) DEFAULT NULL,
`service_id` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_hubspot_contacts`;
CREATE TABLE `module_imobles_hubspot_contacts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`crm_account_id` INT NULL DEFAULT NULL,
`hs_object_id` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* GLAUCO MELCHIORS EMERIM
* 10/03/2022
* PW-406
*/
DROP TABLE IF EXISTS `module_imobles_listings_prices_consolidated`;
CREATE TABLE `module_imobles_listings_prices_consolidated` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`reference_date` DATE NOT NULL,
`enterprise_id` INT(11) NOT NULL,
`unit_type_id` INT(11) NOT NULL,
`number_rooms` INT(11) NOT NULL,
`address_city_id` INT(11) NOT NULL,
`address_neighborhood_id` INT(11) NOT NULL,
`address_neighborhood_sanitized` VARCHAR(200) NOT NULL,
`release_date` DATE NOT NULL,
`release_year` INT(11) NOT NULL,
`area` FLOAT(10,2) NOT NULL,
`min_price` FLOAT(10,2) NOT NULL,
`avg_price` FLOAT(10,2) NOT NULL,
`max_price` FLOAT(10,2) NOT NULL,
PRIMARY KEY (`id`),
INDEX `enterprise_idx` (`enterprise_id` ASC),
INDEX `unit_type_idx` (`unit_type_id` ASC),
INDEX `number_rooms_idx` (`number_rooms` ASC),
INDEX `city_idx` (`address_city_id` ASC),
INDEX `neighborhood_idx` (`address_neighborhood_id` ASC),
INDEX `release_year_idx` (`release_year` ASC),
INDEX `city_neighborhood_rooms_year_idx` (`address_city_id` ASC, `address_neighborhood_id` ASC, `number_rooms` ASC, `release_year` ASC),
UNIQUE INDEX `reference_date_unit_type_unq` (`reference_date` ASC, `unit_type_id` ASC)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* ANDRE CAMARGO
* 16/03/2022
* PW-491
*/
ALTER TABLE `module_imobles_units_amenities`
ADD COLUMN `icon` VARCHAR(100) NULL;
ALTER TABLE `module_imobles_enterprise_amenities`
ADD COLUMN `icon` VARCHAR(100) NULL;
ALTER TABLE `module_imobles_type_units_amenities`
ADD COLUMN `icon` VARCHAR(100) NULL;
/*
* ANDRE CAMARGO
* 16/03/2022
* PW-483
*/
ALTER TABLE `module_imobles_enterprise_imgs`
ADD COLUMN `alt_text` VARCHAR(70) NULL AFTER `construction_company_id`;
/*
* GLAUCO MELCHIORS EMERIM
* 21/03/2022
* PW-488
*/
ALTER TABLE `module_imobles_enterprise_towers`
ADD COLUMN `total_units` int;
/*
* GLAUCO MELCHIORS EMERIM
* 21/03/2022
* PW-489
*/
ALTER TABLE `module_imobles_docs`
ADD COLUMN `issued_date` datetime DEFAULT NULL;
/*
* LEONARDO LOPES RAMOS
* 29/03/2022
* PW-505
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `searchable` TINYINT(1) NULL DEFAULT NULL;
ALTER TABLE `module_imobles_enterprise_units_type`
ADD COLUMN `price_min` INT(11) NULL DEFAULT NULL,
ADD COLUMN `price_avg` INT(11) NULL DEFAULT NULL,
ADD COLUMN `price_max` INT(11) NULL DEFAULT NULL,
ADD COLUMN `iptu_avg` INT(11) NULL DEFAULT NULL,
ADD COLUMN `condo_fee_avg` INT(11) NULL DEFAULT NULL,
ADD COLUMN `total_listings` INT(11) NULL DEFAULT NULL ,
ADD COLUMN `available_units` INT(11) NULL DEFAULT NULL;
/*
* ANDRE CAMARGO
* 01/04/2022
* PW-498
*/
ALTER TABLE `module_imobles_enterprise_imgs`
ADD COLUMN `mark_water` TINYINT(1) NULL DEFAULT 0 AFTER `alt_text`;
DROP TABLE IF EXISTS `module_imobles_default_crop`;
CREATE TABLE `module_imobles_default_crop` (
`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,
`width` int,
`height` int,
`title` VARCHAR(100),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* GLAUCO MELCHIORS EMERIM
* 11/04/2022
* PW-510
*/
ALTER TABLE `module_imobles_company_construction`
ADD COLUMN `foundation_year` INT NULL DEFAULT NULL,
ADD COLUMN `enterprises_delivered` INT NULL DEFAULT NULL,
ADD COLUMN `partners` TEXT NULL DEFAULT NULL,
ADD COLUMN `company_group` TEXT NULL DEFAULT NULL;
/*
* GLAUCO MELCHIORS EMERIM
* 20/04/2022
* PW-530
*/
LOCK TABLES `module_imobles_crawler_types` WRITE;
INSERT INTO `module_imobles_crawler_types` (`type`, `name`) VALUES ('orulo', 'Órulo');
UNLOCK TABLES;
ALTER TABLE `module_imobles_docs`
ADD COLUMN `crawler_type_id` INT NULL DEFAULT NULL,
ADD COLUMN `crawler_document_id` VARCHAR(100) NULL DEFAULT NULL,
ADD INDEX `crawler_document_search` (`module_imobles_enterprise_id` ASC, `crawler_type_id` ASC, `crawler_document_id` ASC, `delete_at` ASC);
ALTER TABLE `module_imobles_enterprise_imgs`
ADD COLUMN `crawler_type_id` INT NULL DEFAULT NULL,
ADD COLUMN `crawler_image_id` VARCHAR(100) NULL DEFAULT NULL,
ADD INDEX `crawler_image_search` (`module_imobles_enterprise_id` ASC, `crawler_type_id` ASC, `crawler_image_id` ASC, `delete_at` ASC);
/*
* GLAUCO MELCHIORS EMERIM
* 03/05/2022
* PW-553
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `intermediate_installment_type` ENUM('None', 'Annual', 'Biannual') DEFAULT "Biannual";
/*
* GLAUCO MELCHIORS EMERIM
* 10/05/2022
* PW-572
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `orulo_id` VARCHAR(400) NULL DEFAULT NULL;
ALTER TABLE `module_imobles_enterprise_units_type`
ADD COLUMN `orulo_id` VARCHAR(400) NULL DEFAULT NULL;
/*
* GLAUCO MELCHIORS EMERIM
* 18/05/2022
* PW-600
*/
ALTER TABLE `module_imobles_docs`
ADD COLUMN `company_construction_id` int(11) DEFAULT NULL;
/*
* 23/05/2022
* PW-633
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `sync_orulo` INT (1) default '1';
/*
* GLAUCO MELCHIORS EMERIM
* 24/05/2022
* PW-635
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `payment_plan_flow` ENUM('Bank Financing', 'Investor') NOT NULL DEFAULT 'Bank Financing';
/*
* GLAUCO MELCHIORS EMERIM
* 23/05/2022
* PW-671
*/
ALTER TABLE `module_imobles_whatsapp_campaign`
ADD COLUMN `send_interval` INT NULL DEFAULT NULL;
/*
* GLAUCO MELCHIORS EMERIM
* 23/05/2022
* PW-668
*/
ALTER TABLE `module_imobles_whatsapp_campaign`
ADD COLUMN `start_date` DATE NULL DEFAULT NULL;
/*
* GLAUCO MELCHIORS EMERIM
* 03/06/2022
* PW-706
*/
ALTER TABLE `module_imobles_company_construction`
ADD COLUMN `orulo_id` VARCHAR(400) NULL DEFAULT NULL;
/*
* GLAUCO MELCHIORS EMERIM
* 03/06/2022
* PW-716
*/
ALTER TABLE `module_imobles_whatsapp_campaign`
DROP COLUMN `send_interval`,
ADD COLUMN `send_interval_min` INT NULL DEFAULT NULL,
ADD COLUMN `send_interval_max` INT NULL DEFAULT NULL;
/*
* GLAUCO MELCHIORS EMERIM
* 09/06/2022
* PW-722
*/
DROP TABLE IF EXISTS `module_imobles_leads_cost`;
CREATE TABLE `module_imobles_leads_cost` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`created_at` TIMESTAMP NULL DEFAULT NULL,
`updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` TIMESTAMP NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`product` VARCHAR(100) DEFAULT NULL,
`city` VARCHAR(100) DEFAULT NULL,
`optimal_price` FLOAT(10,2) NULL DEFAULT NULL,
`extra_fields` LONGTEXT DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* GLAUCO MELCHIORS EMERIM
* 13/06/2022
* PW-731
*/
ALTER TABLE `module_imobles_enterprise_imgs`
MODIFY COLUMN `alt_text` VARCHAR(130);
/*
* GLAUCO MELCHIORS EMERIM
* 14/06/2022
* PW-736
*/
ALTER TABLE `module_imobles_leads_cost`
DROP COLUMN `city`,
ADD COLUMN `city_id` INT NULL DEFAULT NULL;
/*
* GLAUCO MELCHIORS EMERIM
* 14/06/2022
* PW-735
*/
DROP TABLE IF EXISTS `module_imobles_leads_redirects`;
CREATE TABLE `module_imobles_leads_redirects` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`created_at` TIMESTAMP NULL DEFAULT NULL,
`updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` TIMESTAMP NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`googgle_ads_keyword` VARCHAR(100) DEFAULT NULL,
`googgle_ads_geo_target` VARCHAR(100) DEFAULT NULL,
`landing_page_url` VARCHAR(100) DEFAULT NULL,
`placeholder` VARCHAR(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* GLAUCO MELCHIORS EMERIM
* 15/06/2022
* PW-741
*/
DROP TABLE IF EXISTS `module_imobles_leads_products`;
CREATE TABLE `module_imobles_leads_products` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`created_at` TIMESTAMP NULL DEFAULT NULL,
`updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` TIMESTAMP NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`name` VARCHAR(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_leads_products_rules`;
CREATE TABLE `module_imobles_leads_products_rules` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`created_at` TIMESTAMP NULL DEFAULT NULL,
`updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` TIMESTAMP NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`leads_product_id` INT NULL DEFAULT NULL,
`city_id` INT NULL DEFAULT NULL,
`leads_conversion_type_id` INT NULL DEFAULT NULL,
`price_min` FLOAT(10,2) NULL DEFAULT NULL,
`price_max` FLOAT(10,2) NULL DEFAULT NULL,
`rooms_min` INT NULL DEFAULT NULL,
`rooms_max` INT NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* GLAUCO MELCHIORS EMERIM
* 17/06/2022
* PW-741
*/
ALTER TABLE `module_imobles_leads_redirects`
CHANGE COLUMN `googgle_ads_keyword` `google_ads_keyword` VARCHAR(100),
CHANGE COLUMN `googgle_ads_geo_target` `google_ads_geo_target` VARCHAR(100);
/*
* GLAUCO MELCHIORS EMERIM
* 20/06/2022
* PW-752
*/
ALTER TABLE `module_imobles_leads_products_rules`
CHANGE COLUMN `price_min` `price_min` DOUBLE(16,2),
CHANGE COLUMN `price_max` `price_max` DOUBLE(16,2);
/*
* GLAUCO MELCHIORS EMERIM
* 20/06/2022
* PW-757
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `distance_to_the_beach` INT NULL DEFAULT NULL;
/*
* GLAUCO MELCHIORS EMERIM
* 21/06/2022
* PW-759
*/
ALTER TABLE `module_imobles_enterprise_amenities`
CHANGE COLUMN `type` `type` ENUM('recreation','services','safety','fitness','plant', 'pet') NULL DEFAULT NULL ;
ALTER TABLE `module_imobles_type_units_amenities`
CHANGE COLUMN `type` `type` ENUM('recreation','services','safety','fitness','plant', 'pet') NULL DEFAULT NULL ;
ALTER TABLE `module_imobles_units_amenities`
ADD COLUMN `type` ENUM('recreation','services','safety','fitness','plant', 'pet') NULL DEFAULT NULL ;
/*
* GLAUCO MELCHIORS EMERIM
* 04/07/2022
* PW-777
*/
ALTER TABLE `module_imobles_enterprise_units_type`
ADD COLUMN `imobles_indicates` INT (1) default null;
/*
* GLAUCO MELCHIORS EMERIM
* 08/07/2022
* PW-796
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `youtube_video` VARCHAR(200) NULL DEFAULT NULL;
/*
* GLAUCO MELCHIORS EMERIM
* 05/07/2022
* PW-782
*/
DROP TABLE IF EXISTS `module_imobles_logs`;
CREATE TABLE `module_imobles_logs` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`created_at` TIMESTAMP NULL DEFAULT NULL,
`updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` TIMESTAMP NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`type` VARCHAR(100) DEFAULT NULL,
`params` LONGTEXT DEFAULT NULL,
`verified` TINYINT (1) default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* GLAUCO MELCHIORS EMERIM
* 14/07/2022
* PW-817
*/
ALTER TABLE `module_imobles_enterprise_amenities`
ADD COLUMN `alternative_names` VARCHAR(400) NULL DEFAULT NULL,
ADD COLUMN `verified` TINYINT(1) NULL DEFAULT NULL;
ALTER TABLE `module_imobles_type_units_amenities`
ADD COLUMN `alternative_names` VARCHAR(400) NULL DEFAULT NULL,
ADD COLUMN `verified` TINYINT(1) NULL DEFAULT NULL;
/*
* LEONARDO LOPES RAMOS
* 19/07/2022
* WISERLEADS
*/
DROP TABLE IF EXISTS `module_imobles_leads_wiserleads_contacts`;
CREATE TABLE `module_imobles_leads_wiserleads_contacts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`crm_account_id` INT NOT NULL,
`wiserlead_id` INT NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_leads_conversion`
ADD COLUMN `leads_product_id` INT(11) NULL;
/*
* GLAUCO MELCHIORS EMERIM
* 21/07/2022
* PW-836
*/
ALTER TABLE `module_imobles_leads_cost`
ADD COLUMN `leads_product_id` INT NULL DEFAULT NULL;
/*
* LEONARDO LOPES RAMOS
* 27/07/2022
*/
ALTER TABLE `module_imobles_enterprise_imgs`
CHANGE COLUMN `tags` `tags` VARCHAR(100) NULL DEFAULT NULL;
ALTER TABLE `module_imobles_enterprise_imgs`
ADD INDEX `construction_company` (`tags` ASC, `construction_company_id` ASC);
/*
*ANDRE CAMARGO
*03/09/2022
* PW-1016
*/
DROP TABLE IF EXISTS `module_imobles_enterprise_category_amenities`;
CREATE TABLE `module_imobles_enterprise_category_amenities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`default` tinyint(1) DEFAULT '0',
`sorder` int(1) ,
`city_ids` mediumtext ,
`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_group_amenities`;
CREATE TABLE `module_imobles_enterprise_group_amenities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`default` tinyint(1) DEFAULT '0',
`sorder` int(1) ,
`category_id` int(1) ,
`amenities_ids` mediumtext ,
`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;
/*
* GLAUCO MELCHIORS EMERIM
* 14/09/2022
* PW-1034
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `dwv_id` VARCHAR(400) NULL DEFAULT NULL;
/*
* LEONARDO LOPES RAMOS
* 14/09/2022
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `price_type` ENUM('price_on_request', 'undisclosed_price') NULL DEFAULT NULL;
/*
* GLAUCO MELCHIORS EMERIM
* 16/09/2022
* PW-1039
*/
ALTER TABLE `module_imobles_enterprise_units`
ADD COLUMN `dwv_id` VARCHAR(400) NULL DEFAULT NULL;
/*
* LEONARDO LOPES RAMOS
* 16/09/2022
*/
ALTER TABLE `module_imobles_enterprise_units_type_amenities`
ADD INDEX `amenities` (`module_imobles_enterprise_units_type_id` ASC, `module_imobles_type_units_amenities_id` ASC);
ALTER TABLE `module_imobles_enterprise_units_type`
ADD INDEX `SECOND` (`module_imobles_enterprise_id` ASC, `number_rooms` ASC, `number_bathroom` ASC, `area` ASC, `number_garage` ASC, `crawler_type_id` ASC, `site_enabled` ASC, `delete_at` ASC, `price_min` ASC, `price_avg` ASC, `price_max` ASC);
/*
* GLAUCO MELCHIORS EMERIM
* 18/07/2022
* PW-820
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `address_neighborhood_id` INT(11) NULL DEFAULT NULL;
ALTER TABLE `module_imobles_neighborhoods`
ADD COLUMN `google_details` LONGTEXT NULL DEFAULT NULL;
/*
* ANDRE CAMARGO
* 16/09/2022
* PW-1049
*/
DROP TABLE IF EXISTS `module_imobles_slug_redirect`;
CREATE TABLE `module_imobles_slug_redirect` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`url_origin` text,
`url_final` text,
`title` mediumtext DEFAULT NULL,
`description` mediumtext DEFAULT NULL,
`h1` mediumtext DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* GLAUCO MELCHIORS EMERIM
* 19/09/2022
* PW-1039
*/
ALTER TABLE `module_imobles_enterprise_towers`
ADD COLUMN `dwv_id` VARCHAR(400) NULL DEFAULT NULL;
/*
* LEONRDO LOPES RAMOS
* 20/09/2022
*/
ALTER TABLE `module_imobles_enterprise`
ADD INDEX `address` (`address_neighborhood_id` ASC, `address_neighborhood_sanitized` ASC, `address_log_sanitized` ASC);
/*
* 23/09/2022
* LEONARDO LOPES RAMOS
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `pre_launch` INT (1) default NULL;
/*
* 09/10/2022
* LEONARDO LOPES RAMOS
*/
ALTER TABLE `module_imobles_enterprise_units`
DROP INDEX `indice_buscador` ,
ADD INDEX `indice_buscador` (`module_imobles_enterprise_units_type_id` ASC, `delete_at` ASC, `crawler_type_id` ASC, `unavailable` ASC, `dwv_id` ASC, `module_imobles_enterprise_towers_id` ASC);
ALTER TABLE `module_imobles_listings`
DROP INDEX `indice` ,
ADD INDEX `indice` (`advertiser_id` ASC, `delete_at` ASC, `unit_id` ASC);
/*
* 28/10/2022
* LEONARDO LOPES RAMOS
*/
ALTER TABLE `module_imobles_leads_wiserleads_contacts`
ADD COLUMN `hs_deal_id` INT(11) NULL AFTER `wiserlead_id`;
ALTER TABLE `module_imobles_leads_wiserleads_contacts`
ADD INDEX `DEAL` (`hs_deal_id` ASC);
/*
* GLAUCO MELCHIORS EMERIM
* 31/10/2022
* PW-1144
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `meeting_date` DATETIME NULL DEFAULT NULL;
/*
* GLAUCO MELCHIORS EMERIM
* 28/10/2022
* PW-858
*/
ALTER TABLE `module_imobles_docs`
ADD COLUMN `converted_csv` TEXT default null;
/*
* ANDRE CAMARGO
* 01/11/2022
* PW-1133
*/
DROP TABLE IF EXISTS `module_imobles_task_category`;
CREATE TABLE `module_imobles_task_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` enum('credit_repair','pre_sale','sale','pos_sale'),
`name` mediumtext DEFAULT NULL,
`default` tinyint(1) DEFAULT '0',
`sorder` int(1) ,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_tasks`;
CREATE TABLE `module_imobles_tasks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text DEFAULT NULL,
`description` mediumtext DEFAULT NULL,
`images` mediumtext DEFAULT NULL,
`url` text,
`module_imobles_task_category_id` int,
`sorder` int(1) ,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_tasks_customers`;
CREATE TABLE `module_imobles_tasks_customers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`crm_account_id` int DEFAULT NULL,
`module_imobles_tasks_id` int DEFAULT NULL,
`date_init` datetime NULL DEFAULT NULL,
`date_end` datetime NULL DEFAULT NULL,
`finished` int NULL DEFAULT NULL,
details mediumtext,
`finished_by` INT NULL DEFAULT NULL,
`finished_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* 07/11/2022
* LEONARDO LOPES RAMOS
*/
ALTER TABLE `module_imobles_leads_wiserleads_contacts`
CHANGE COLUMN `hs_deal_id` `hs_deal_id` BIGINT(21) NULL DEFAULT NULL ;
/*
* ANDRE CAMARGO
* 07/11/2022
* PW-1157
*/
ALTER TABLE `module_imobles_enterprise_imgs`
ADD COLUMN `neighborhood_id` INT NULL AFTER `crawler_image_id`;
ALTER TABLE `module_imobles_enterprise_imgs`
CHANGE COLUMN `type` `type` ENUM('backend', 'listing', 'neighborhood') NULL DEFAULT NULL ;
DROP TABLE IF EXISTS `module_imobles_enterprise_img_neighborhood_tags`;
CREATE TABLE `module_imobles_enterprise_img_neighborhood_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;
ALTER TABLE `module_imobles_enterprise_imgs`
ADD INDEX `neighborhood_id` (`neighborhood_id` ASC);
/*
* GLAUCO MELCHIORS EMERIM
* 22/11/2022
* PW-1183
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `estimated_price` TINYINT (1) default null;
/*
* GLAUCO MELCHIORS EMERIM
* 23/11/2022
* PW-1199
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `has_no_ri` TINYINT (1) default null;
/*
* GLAUCO MELCHIORS EMERIM
* 24/11/2022
* PW-1198
*/
ALTER TABLE `module_imobles_whatsapp_campaign`
ADD COLUMN `send_at_weekends` TINYINT NULL DEFAULT NULL;
/*
* 30/11/2022
* LEONARDO LOPES RAMOS
*/
ALTER TABLE `module_imobles_dynamic_urls`
ADD INDEX `index2` (`url` ASC);
/*
* GLAUCO MELCHIORS EMERIM
* 01/12/2022
* PW-1205
*/
ALTER TABLE `module_imobles_tasks_customers`
DROP COLUMN `finished`,
ADD COLUMN `status` ENUM('open', 'finished_on_time', 'finished_late') NOT NULL DEFAULT 'open';
/*
* GLAUCO MELCHIORS EMERIM
* 09/12/2022
* PW-1233
*/
ALTER TABLE `module_imobles_whatsapp_campaign`
ADD COLUMN `forbidden_dates` VARCHAR(200);
/*
* LEONARDO LOPES RAMOS
* 13/12/2022
*/
ALTER TABLE `module_imobles_enterprise_units`
ADD INDEX `CSV` (`number_unity` ASC);
/*
* GLAUCO MELCHIORS EMERIM
* 14/12/2022
* PW-1252
*/
ALTER TABLE `module_imobles_listings`
ADD INDEX `indice_unit_crawlertype_delete` (`unit_id` ASC, `crawler_type_id` ASC, `delete_at` ASC);
/*
* GLAUCO MELCHIORS EMERIM
* 22/12/2022
* PW-1252
*/
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `youtube_json` LONGTEXT NULL DEFAULT NULL;
/*
* LEONARDO LOPES RAMOS
* 02/01/2023
*/
ALTER TABLE `module_imobles_cache`
ADD INDEX `Cache` (`method` ASC, `controller` ASC);
DROP TABLE IF EXISTS `module_imobles_leads_history`;
CREATE TABLE `module_imobles_leads_history` (
`lead_hash` VARCHAR(100) DEFAULT NULL,
`hs_utk` VARCHAR(100) DEFAULT NULL,
`api_method` VARCHAR(100) DEFAULT NULL,
`api_controller` VARCHAR(100) DEFAULT NULL,
`api_request` mediumtext DEFAULT NULL,
`created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_leads_history`
ADD INDEX `INDEX` (`hs_utk` ASC, `lead_hash` ASC);
ALTER TABLE `module_imobles_leads_history`
ADD COLUMN `crm_account_id` INT NULL DEFAULT NULL AFTER `created_at`,
ADD INDEX `CRM` (`crm_account_id` ASC);
ALTER TABLE `module_imobles_leads_conversion`
ADD INDEX `INDEX` (`crm_accounts_id` ASC);
/*
* GLAUCO MELCHIORS EMERIM
* 25/01/2023
* PW-1301
*/
ALTER TABLE `module_imobles_company_construction`
ADD COLUMN `accept_exchange` TINYINT (1) default null;
/*
* GLAUCO MELCHIORS EMERIM
* 01/02/2023
* PW-1331
*/
ALTER TABLE `module_imobles_proposal`
ADD COLUMN `scenario_title` VARCHAR(30),
ADD COLUMN `scenario_description` VARCHAR(120);
/*
* ANDRE CAMARO
* 03/02/2023
* PW-1328
*/
DROP TABLE IF EXISTS `module_imobles_crm_goals_category`;
CREATE TABLE `module_imobles_crm_goals_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,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_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_crm_goals`;
CREATE TABLE `module_imobles_crm_goals` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`title` VARCHAR(300),
`crm_accounts_id` INT NOT NULL,
`module_imobles_crm_goals_category_id` INT NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `module_imobles_crm_goals_comments`;
CREATE TABLE `module_imobles_crm_goals_comments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`comment` longtext,
`crm_accounts_id` INT NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* ANDRE CAMARO
* 10/02/2023
* PW-1350
*/
DROP TABLE IF EXISTS `module_imobles_crm_journey_stages`;
CREATE TABLE `module_imobles_crm_journey_stages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sorder` int(1) ,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_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_crm_journey_tasks`;
CREATE TABLE `module_imobles_crm_journey_tasks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`title` VARCHAR(300),
`description` longtext,
`closed` int(1) ,
journey_stage_id int(11),
due_date date,
client_responsibility int(1),
`crm_accounts_id` INT NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* GLAUCO MELCHIORS EMERIM
* 13/02/2023
* PW-1349
*/
ALTER TABLE `module_imobles_proposal`
ADD COLUMN `unit_type_approved` LONGTEXT NULL DEFAULT NULL;
DROP TABLE IF EXISTS `module_imobles_proposal_comments`;
CREATE TABLE `module_imobles_proposal_comments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`proposal_id` int(11) NOT NULL,
`unit_type_id` int(11) NOT NULL,
`comment` LONGTEXT NULL DEFAULT NULL,
`from_me` TINYINT (1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* GLAUCO MELCHIORS EMERIM
* 16/02/2023
* PW-1363
*/
ALTER TABLE `module_imobles_proposal`
ADD COLUMN `scenario_approved` TINYINT (1) DEFAULT NULL;
/*
* GLAUCO MELCHIORS EMERIM
* 21/02/2023
* PW-1363
*/
ALTER TABLE `module_imobles_proposal_comments`
CHANGE COLUMN `unit_type_id` `unit_type_id` INT(11) NULL ;
/*
* GLAUCO MELCHIORS EMERIM
* 28/02/2023
* PW-1386
*/
ALTER TABLE `module_imobles_proposal`
ADD COLUMN `scenario_values` LONGTEXT NULL DEFAULT NULL;
/*
* ANDRE CAMARGO
* 12/03/2023
* PW-1409
*/
DROP TABLE IF EXISTS `module_imobles_pipe_stages`;
CREATE TABLE `module_imobles_pipe_stages` (
`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,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_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_pipe_vgv`;
CREATE TABLE `module_imobles_pipe_vgv` (
`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,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_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_pipe_timing`;
CREATE TABLE `module_imobles_pipe_timing` (
`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,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_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_pipe_engagement`;
CREATE TABLE `module_imobles_pipe_engagement` (
`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,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_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_pipe_first_contact`;
CREATE TABLE `module_imobles_pipe_first_contact` (
`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,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_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_pipe_lost_reason`;
CREATE TABLE `module_imobles_pipe_lost_reason` (
`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,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_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_pipe_status`;
CREATE TABLE `module_imobles_pipe_status` (
`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,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_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_pipe_service_region`;
CREATE TABLE `module_imobles_pipe_service_region` (
`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,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_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_deals`;
CREATE TABLE `module_imobles_deals` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`title` VARCHAR(100),
`timing_id` int(11),
`vgv_id` int(11),
`engagement_id` int(11),
`first_contact_id` int(11),
`lost_reason_id` int(11),
`sale_stage_id` int(11),
`status_id` int(11),
`service_region_id` int(11),
`crm_account_id` int(11),
`crm_account_related` longtext,
`sdr_id` int(11),
`seller_id` int(11),
`first_choice` text,
`high_engagement` ENUM('S','N'),
`deal_amount` decimal(20,2),
commission DECIMAL(20,2),
expected_closed_date date,
stage_update_at DateTime,
closed_at timestamp NULL DEFAULT NULL,
closed_by INT NULL DEFAULT NULL,
opp_created_at timestamp NULL DEFAULT NULL,
opp_created_by INT NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_deals`
CHANGE COLUMN `high_engagement` `high_engagement` TINYINT NULL DEFAULT 0 ;
ALTER TABLE `module_imobles_pipe_stages`
ADD COLUMN `type` ENUM('presale', 'sale') NULL AFTER `name`;
ALTER TABLE `module_imobles_pipe_timing`
ADD COLUMN `weight` INT NULL AFTER `name`;
ALTER TABLE `module_imobles_pipe_vgv`
ADD COLUMN `weight` INT NULL AFTER `name`;
ALTER TABLE `module_imobles_pipe_engagement`
ADD COLUMN `weight` INT NULL AFTER `name`;
/*
* GLAUCO MELCHIORS EMERIM
* 16/03/2023
* PW-1446
*/
ALTER TABLE `module_imobles_company_construction`
ADD COLUMN status ENUM('green','yellow','red') NULL DEFAULT NULL;
/*
* LEONARDO LOPES RAMOS
* 17/03/2023
*/
ALTER TABLE `module_imobles_crm_goals_comments`
ADD COLUMN `deal_id` int(11) DEFAULT NULL,
ADD COLUMN `from_client` TINYINT (1) DEFAULT NULL;
/*
* GLAUCO MELCHIORS EMERIM
* 21/03/2023
* PW-1447
*/
ALTER TABLE `module_imobles_enterprise_imgs`
ADD INDEX `index_construction_company_delete` (`delete_at` ASC, `construction_company_id` ASC);
/*
* ANDRE CAMARGO
* 20/03/2023
* PW-1442
*/
DROP TABLE IF EXISTS `module_imobles_deal_tasks`;
CREATE TABLE `module_imobles_deal_tasks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`title` VARCHAR(300),
`description` longtext,
`closed` int(1) default null ,
deal_id int(11),
due_date date,
client_responsibility int(1) default null,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* LEONARDO LOPES RAMOS
* 28/03/2023
*/
ALTER TABLE `module_imobles_deals`
ADD COLUMN `hs_deal_id` VARCHAR(45) NULL;
ALTER TABLE `module_imobles_deals`
ADD COLUMN `passing_event_date` timestamp NULL DEFAULT NULL,
ADD COLUMN `passing_event_type` ENUM('call', 'in_person', 'video', 'other') NULL DEFAULT NULL;
ALTER TABLE `module_imobles_deal_tasks`
ADD COLUMN `hs_task_id` VARCHAR(45) NULL;
/*
* GLAUCO MELCHIORS EMERIM
* 03/04/2023
* PW-1463
*/
ALTER TABLE `module_imobles_enterprise_units_type`
ADD COLUMN `payment_plan_params` TEXT NULL DEFAULT NULL;
/*
* LEONARDO LOPES RAMOS
* 04/04/2023
*/
ALTER TABLE `module_imobles_deals`
ADD COLUMN `closing_journey` VARCHAR(255) NULL;
/*
* GLAUCO MELCHIORS EMERIM
* 03/04/2023
* PW-1463
*/
ALTER TABLE `module_imobles_enterprise_units_type`
DROP COLUMN `payment_plan_params`;
ALTER TABLE `module_imobles_enterprise`
ADD COLUMN `payment_plan_params` TEXT NULL DEFAULT NULL;
* GLAUCO MELCHIORS EMERIM
* 13/04/2023
* PW-1489
*/
DROP TABLE IF EXISTS `module_imobles_deals_docs`;
CREATE TABLE `module_imobles_deals_docs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`deal_id` int(11) DEFAULT NULL,
`category_id` int(11) DEFAULT NULL,
`obs` TEXT DEFAULT NULL,
`issued_date` datetime DEFAULT NULL,
`expiration_date` datetime DEFAULT NULL,
`src` varchar(100) DEFAULT NULL,
`name` TEXT DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX `index_deal_id` (`deal_id` ASC, `deleted_at` ASC)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* LEONARDO LOPES RAMOS
* 14/04/2023
*/
DROP TABLE IF EXISTS `module_imobles_mygpt_messages`;
CREATE TABLE `module_imobles_mygpt_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`crm_account_id` int(11) NULL DEFAULT NULL,
`sys_user_id` int(11) NULL DEFAULT NULL,
`deal_id` int(11) NULL DEFAULT NULL,
`msg` LONGTEXT NULL DEFAULT NULL,
`msg_type` VARCHAR(100) NULL DEFAULT NULL,
`is_from_bot` TINYINT (1) NULL DEFAULT NULL,
`is_first` TINYINT (1) NULL DEFAULT NULL,
`read_at` timestamp NULL DEFAULT NULL,
`digisac_id` VARCHAR(100) NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_mygpt_messages`
ADD INDEX `index2` (`sys_user_id` ASC,`crm_account_id` ASC, `created_at` DESC);
DROP TABLE IF EXISTS `module_imobles_mygpt_digisac_contacts`;
CREATE TABLE `module_imobles_mygpt_digisac_contacts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`crm_account_id` int(11) NULL DEFAULT NULL,
`sys_user_id` int(11) NULL DEFAULT NULL,
`user_type` VARCHAR(100) NULL DEFAULT NULL,
`digisac_contact_id` VARCHAR(100) NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_mygpt_digisac_contacts`
ADD INDEX `index2` (`digisac_contact_id` ASC,`crm_account_id` ASC, `sys_user_id` DESC);
/*
* LEONARDO LOPES RAMOS
* 17/03/2023
*/
ALTER TABLE `module_imobles_crm_goals`
ADD COLUMN `deal_id` int(11) DEFAULT NULL;
ALTER TABLE `module_imobles_crm_goals`
ADD INDEX `indexDeal` (`deal_id` ASC);
ALTER TABLE `module_imobles_proposal`
ADD COLUMN `deal_id` int(11) DEFAULT NULL;
ALTER TABLE `module_imobles_proposal`
ADD INDEX `indexDeal` (`deal_id` ASC);
/*
* LEONARDO LOPES RAMOS
* 26/03/2023
*/
ALTER TABLE `module_imobles_deals`
ADD COLUMN `journey_stage_id` int(11) DEFAULT NULL;
ALTER TABLE `module_imobles_crm_journey_tasks`
ADD COLUMN `deal_id` int(11) DEFAULT NULL;
ALTER TABLE `module_imobles_crm_journey_tasks`
ADD INDEX `indexDeal` (`deal_id` ASC);
/*
* LEONARDO LOPES RAMOS
* 02/05/2023
*/
DROP TABLE IF EXISTS `module_imobles_deals_notes`;
CREATE TABLE `module_imobles_deals_notes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` INT NULL DEFAULT NULL,
`updated_by` INT NULL DEFAULT NULL,
`deleted_by` INT NULL DEFAULT NULL,
`crm_account_id` int(11) NULL DEFAULT NULL,
`sys_user_id` int(11) NULL DEFAULT NULL,
`deal_id` int(11) NULL DEFAULT NULL,
`msg` LONGTEXT NULL DEFAULT NULL,
`hs_note_id` VARCHAR(100) NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_deals_notes`
ADD INDEX `index2` (`crm_account_id` ASC);
ALTER TABLE `module_imobles_deals_notes`
DROP COLUMN `sys_user_id`;
ALTER TABLE `module_imobles_deals_notes`
ADD COLUMN `sys_activity_id` INT(11) NULL DEFAULT NULL;
ALTER TABLE `module_imobles_hubspot_contacts`
ADD INDEX `CRM` (`crm_account_id` ASC, `hs_object_id` ASC) VISIBLE;
ALTER TABLE `module_imobles_deal_tasks`
ADD COLUMN `responsible_id` INT(11) NULL DEFAULT NULL,
ADD COLUMN `type` ENUM('followup','meeting','delivery') NULL DEFAULT NULL;
/*
* LEONARDO LOPES RAMOS
* 09/09/2023
*/
ALTER TABLE `module_imobles_mygpt_messages`
ADD COLUMN `params` TEXT NULL DEFAULT NULL;
ALTER TABLE `module_imobles_mygpt_messages`
CHANGE COLUMN `params` `params` LONGTEXT NULL DEFAULT NULL ;
/*
* GLAUCO MELCHIORS EMERIM
* 12/04/2023
* PW-1479
*/
DROP TABLE IF EXISTS `module_imobles_notifications_history`;
CREATE TABLE `module_imobles_notifications_history` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`article_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*
* LEONARDO LOPES RAMOS
* 31/05/2023
*/
DROP TABLE IF EXISTS `module_imobles_leads_automation`;
CREATE TABLE `module_imobles_leads_automation` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`crm_account_id` int(11) NOT NULL,
`deal_id` int(11) NOT NULL,
`conversion_id` int(11) NOT NULL,
`verified` TINYINT (1) NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `module_imobles_leads_automation`
ADD INDEX `index2` (`verified` ASC, `deal_id` ASC);
ALTER TABLE `module_imobles_logs`
ADD INDEX `Type` (`type` ASC);
ALTER TABLE `module_imobles_logs`
DROP INDEX `Type` ,
ADD INDEX `Type` (`type` ASC, `verified` ASC);
/*
* GLAUCO MELCHIORS EMERIM
* 29/06/2023
* PW-1583
*/
ALTER TABLE `module_imobles_enterprise_units_type`
ADD COLUMN `standard_price` DECIMAL(10,2) default null;