| Server IP : 162.214.74.102 / Your IP : 216.73.217.80 Web Server : Apache System : Linux dedi-4363141.lrsys.com.br 3.10.0-1160.119.1.el7.tuxcare.els25.x86_64 #1 SMP Wed Oct 1 17:37:27 UTC 2025 x86_64 User : lrsys ( 1015) PHP Version : 5.6.40 Disable Function : exec,passthru,shell_exec,system MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/lrsys/public_html/lrsys_apps/imobles/application/plugins/module_arbo/install/ |
Upload File : |
--
-- Create table 'module_arbo_forms'
--
CREATE TABLE `module_arbo_forms` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`type` enum('IMÓVEL','PROPOSTA') DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Create table 'module_arbo_form_data'
--
CREATE TABLE `module_arbo_form_data` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`form_id` int(11) NOT NULL,
`field` varchar(255) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_module_arbo_form_data_module_arbo_forms` (`form_id`),
CONSTRAINT `fk_module_arbo_form_data_module_arbo_forms`
FOREIGN KEY (`form_id`)
REFERENCES `module_arbo_forms` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Alter Table 'module_arbo_forms'
--
ALTER TABLE `module_arbo_forms`
ADD COLUMN `submitted_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
MODIFY COLUMN `type` VARCHAR(255) DEFAULT NULL;
--
-- Alter Table 'module_arbo_robo_logs'
--
CREATE TABLE `module_arbo_robo_logs` (
`id` INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
`date` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`description` VARCHAR(255) DEFAULT NULL COMMENT 'Received from TypeForm or Send to Gaia',
`data` TEXT DEFAULT NULL,
`operation` VARCHAR(120) DEFAULT NULL COMMENT 'INPUT|OUTPUT',
`status` VARCHAR(255) DEFAULT NULL,
`ip` VARCHAR(120) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Alter Table 'module_arbo_robo_logs'
--
ALTER TABLE `module_arbo_robo_logs`
ADD COLUMN `owner` VARCHAR(255) DEFAULT NULL AFTER `date`;
--
-- Leonardo Lopes | 10/08/2017
--
-- Alter Table 'module_arbo_forms'
--
ALTER TABLE `module_arbo_forms`
ADD COLUMN `typeform_form_id` VARCHAR(55) NULL AFTER `submitted_at`,
ADD COLUMN `typeform_token` VARCHAR(255) NULL AFTER `typeform_form_id`,
ADD COLUMN `sent_to_gaia` INT(1) NOT NULL DEFAULT 0 AFTER `typeform_token`;
--
-- Alter Table 'module_arbo_robo_logs'
--
ALTER TABLE `module_arbo_robo_logs`
ADD COLUMN `form_id` INT(11) DEFAULT NULL;
--
-- Alter Table 'module_arbo_form_data'
--
ALTER TABLE `module_arbo_form_data`
ADD COLUMN `type` VARCHAR(255) DEFAULT NULL,
ADD COLUMN `multi` INT(1) DEFAULT NULL,
ADD COLUMN `typeform_question_id` INT(55) DEFAULT NULL;