| 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/gasch/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`;