| Server IP : 54.94.228.101 / 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 : |
ALTER TABLE `sis_basic_info`
ADD COLUMN `ativar_desconto_deposito` TINYINT(4) NULL DEFAULT '0' AFTER `reserva_estoque`;
ALTER TABLE `sis_basic_info`
ADD COLUMN `cupom_desconto_id` INT(11) NULL DEFAULT NULL AFTER `ativar_desconto_deposito`;
INSERT INTO `cupom` (`thumbnail_principal`, `meta_keywords`, `meta_descricao`, `slug`, `codigo`, `descricao`, `percentual_desconto`, `valor_desconto`, `data_de_expiracao`, `status`, `tipo`, `todos_clientes`, `primeiro_pedido`, `id_canal`) VALUES (NULL, NULL, NULL, 'pixoutlet2021', 'PIXOUTLET2021', 'Desconto de 10% para pagamentos via depósito, TED, DOC ou PIX', 10.00, 0.00, '2021-12-31', 'A', 'C', 1, 0, 0);
UPDATE sis_basic_info SET ativar_desconto_deposito = 1 WHERE id=1;
ALTER TABLE `pedido_venda`
CHANGE COLUMN `tipo_deposito` `tipo_deposito` ENUM('D','DOC','TED','PIX') NULL DEFAULT NULL AFTER `comprovante`;