编辑文件 - n-1410.sql

✏️ 正在编辑: n-1410.sql

路径: /srv/systems_dir/koruspay/data/database/n-1410.sql
提示: 您可以编辑任何文件（包括二进制文件），但请注意不当修改可能导致文件损坏。

ALTER TABLE `tb_empresas` 
  RENAME COLUMN `tipo_tarifa` TO `tipo_tarifa_pix`,
  RENAME COLUMN `tarifa` TO `tarifa_pix`,
	ADD `data_criacao` DATE NULL AFTER `cnpj`,
	ADD `data_nascimento_responsavel` DATE NULL AFTER `cpf_responsavel`,
	ADD `account_number` VARCHAR(20) NULL AFTER `account_id`,
  ADD `payer_id` VARCHAR(100) NULL AFTER `account_number`,
  ADD `security_hash` VARCHAR(100) NULL AFTER `payer_id`,
  ADD `access_key` TEXT NULL AFTER `security_hash`,
  ADD `tipo_tarifa_boleto` INT NULL AFTER `tarifa_pix`,
  ADD `tarifa_boleto` DECIMAL(15,2) NOT NULL DEFAULT 0 AFTER `tipo_tarifa_boleto`,
  ADD `tipo_tarifa_split` INT NULL AFTER `tarifa_boleto`,
  ADD `tarifa_split` DECIMAL(15,2) NOT NULL DEFAULT 0 AFTER `tipo_tarifa_split`,
  DROP COLUMN `chave_pix`,
  DROP COLUMN `tipo_pix_devolucao`,
  DROP COLUMN `pix_devolucao`
;

CREATE TABLE
  `tb_payers` (
    `id` int NOT NULL AUTO_INCREMENT,
    `empresa_id` int NOT NULL,
    `nome` varchar(255) DEFAULT NULL,
    `cpf` varchar(14) DEFAULT NULL,
    `celular` varchar(14) DEFAULT NULL,
    `email` varchar(255) DEFAULT NULL,
    `id_payer` varchar(100) DEFAULT NULL,
    `cep` varchar(8) DEFAULT NULL,
    `endereco` varchar(255) DEFAULT NULL,
    `numero` varchar(5) DEFAULT NULL,
    `bairro` varchar(100) DEFAULT NULL,
    `cidade` varchar(100) DEFAULT NULL,
    `uf` char(2) DEFAULT NULL,
    `complemento` varchar(255) DEFAULT NULL,    
    `excluido` tinyint NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `empresa_id` (`empresa_id`),
    KEY `excluido` (`excluido`)
  )

ALTER TABLE `tb_transactions` 
  DROP COLUMN `tarifa`,
  DROP COLUMN `data_hora_recebimento`,
  ADD `data_lancamento` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `id`,
  ADD `lote_itens_id` INT NULL AFTER `lote_id`,
  ADD `invoice_id_pix` VARCHAR(100) NULL AFTER `id`,
  ADD `invoice_id_boleto` VARCHAR(100) NULL AFTER `invoice_id_pix`,
  ADD `transfer_id` VARCHAR(100) NULL AFTER `invoice_id_boleto`,
  ADD `payer_id` INT NULL AFTER `empresa_id`,
  ADD `descricao` VARCHAR(255) NULL AFTER `lote_id`,
	ADD `desconto` DECIMAL(15,2) NOT NULL DEFAULT 0 AFTER `valor_total`,
  ADD `multa` DECIMAL(15,2) NOT NULL DEFAULT 0 AFTER `juros`,
  ADD `pix_qr_code` TEXT NULL AFTER `codigo_barras`,
  MODIFY COLUMN `tipo` ENUM('CREDITO','RECEBIMENTO','SAQUE','PAGAMENTO','TARIFA') NOT NULL DEFAULT 'CREDITO',
  MODIFY COLUMN `situacao` VARCHAR(15) NULL,
  MODIFY COLUMN `data_baixa` DATETIME,
  MODIFY COLUMN `data_fatura` DATETIME,
  MODIFY COLUMN `data_erro` DATETIME,
  ADD INDEX (`tipo`)
;

ALTER TABLE `tb_lotes_itens` 
  MODIFY COLUMN `data_erro` DATETIME
;

CREATE TABLE
  `tb_company_keys` (
    `id` int NOT NULL AUTO_INCREMENT,
    `company_id` int NOT NULL,
    `key` varchar(255) DEFAULT NULL,
    `bank_code` varchar(3) DEFAULT NULL,
    `branch_code` varchar(10) DEFAULT NULL,
    `account_number` varchar(20) DEFAULT NULL,
    `account_type` varchar(20) DEFAULT NULL,
    `data_cadastro` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
    `excluido` tinyint NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `company_id` (`company_id`),
    KEY `excluido` (`excluido`),
    INDEX (`type_key`)
  )

← 返回文件管理器