| Server IP : 54.233.248.239 / Your IP : 172.28.20.13 Web Server : Apache System : Linux ip-172-28-29-189 6.5.0-1014-aws #14~22.04.1-Ubuntu SMP Thu Feb 15 15:27:06 UTC 2024 x86_64 User : www-data ( 33) PHP Version : 7.2.34-43+ubuntu22.04.1+deb.sury.org+1 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/vinumday2_0/storage/sql/ |
Upload File : |
# 2021-01-30
CREATE TABLE `marketplace_log` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`cliente_id` INT(11) NOT NULL DEFAULT '0',
`empresa_id_origem` INT(11) NOT NULL DEFAULT '0',
`empresa_id_destino` INT(11) NOT NULL DEFAULT '0',
`user_id` INT(11) NOT NULL DEFAULT '0',
`estado_id` INT(11) NOT NULL DEFAULT '0',
`data_transferencia` TIMESTAMP NULL DEFAULT NULL,
`quantidade` INT(11) NOT NULL DEFAULT '0',
`pedidos` INT(11) NOT NULL DEFAULT '0',
`valor` DECIMAL(15,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`id`),
INDEX `fk001_marketplaceLog_cliente` (`cliente_id`),
INDEX `fk002_marketplaceLog_empresaOrigem` (`empresa_id_origem`),
INDEX `fk003_marketplaceLog_empresaDestino` (`empresa_id_destino`),
INDEX `fk004_marketplaceLog_user` (`user_id`),
CONSTRAINT `fk001_marketplaceLog_cliente` FOREIGN KEY (`cliente_id`) REFERENCES `cadastro` (`id`),
CONSTRAINT `fk002_marketplaceLog_empresaOrigem` FOREIGN KEY (`empresa_id_origem`) REFERENCES `empresa` (`id`),
CONSTRAINT `fk003_marketplaceLog_empresaDestino` FOREIGN KEY (`empresa_id_destino`) REFERENCES `empresa` (`id`),
CONSTRAINT `fk004_marketplaceLog_user` FOREIGN KEY (`user_id`) REFERENCES `sis_users` (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;
ALTER TABLE `pedido_venda`
ADD COLUMN `data_transferencia_marketplace` TIMESTAMP NULL DEFAULT NULL AFTER `empresa_id_old`;