✏️ 正在编辑: n-1410-2.sql
路径:
/srv/systems_dir/koruspay/data/database/n-1410-2.sql
提示:
您可以编辑任何文件（包括二进制文件），但请注意不当修改可能导致文件损坏。
CREATE TABLE `tb_company_ips` ( `id` int NOT NULL AUTO_INCREMENT, `company_id` int NOT NULL, `ip` varchar(15) DEFAULT NULL,access history `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP `deleted` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `company_id` (`company_id`), KEY `excluido` (`excluido`) ) RENAME TABLE tb_acessos_historico TO tb_access_history; ALTER TABLE `tb_access_history` RENAME COLUMN `usuario_id` TO `user_id`, RENAME COLUMN `datahora` TO `datehour`; RENAME TABLE tb_empresas TO tb_companys; ALTER TABLE `tb_companys` RENAME COLUMN `cnpj` TO `doc_number`, RENAME COLUMN `fantasia` TO `fantasy`, RENAME COLUMN `razao_social` TO `reason`, RENAME COLUMN `data_criacao` TO `registration_date`, RENAME COLUMN `data_cadastro` TO `created_at`, RENAME COLUMN `responsavel` TO `accountable`, RENAME COLUMN `cpf_responsavel` TO `doc_accountable`, RENAME COLUMN `data_nascimento_responsavel` TO `birthdate_accountable`, RENAME COLUMN `cep` TO `zip_code`, RENAME COLUMN `endereco` TO `street`, RENAME COLUMN `bairro` TO `neighborhood`, RENAME COLUMN `cidade` TO `city`, RENAME COLUMN `uf` TO `state`, RENAME COLUMN `complemento` TO `complement`, RENAME COLUMN `numero` TO `number`, RENAME COLUMN `celular` TO `cell`, RENAME COLUMN `fone` TO `phone`, RENAME COLUMN `tipo_tarifa_pix` TO `type_tax_pix`, RENAME COLUMN `tarifa_pix` TO `tax_pix`, RENAME COLUMN `tipo_tarifa_boleto` TO `type_tax_bankslip`, RENAME COLUMN `tarifa_boleto` TO `tax_bankslip`, RENAME COLUMN `tipo_tarifa_split` TO `type_tax_split`, RENAME COLUMN `tarifa_split` TO `tax_split`, RENAME COLUMN `desativado` TO `disabled`, RENAME COLUMN `excluido` TO `deleted` ; RENAME TABLE tb_company_keys TO tb_company_accounts; ALTER TABLE `tb_company_accounts` RENAME COLUMN `data_cadastro` TO `created_at`, RENAME COLUMN `excluido` TO `deleted` ; ALTER TABLE `tb_credentials` RENAME COLUMN `empresa_id` TO `company_id`, RENAME COLUMN `data_cadastro` TO `created_at`, DROP COLUMN `allowed_ips` ; RENAME TABLE tb_lots TO tb_splits; ALTER TABLE `tb_splits` RENAME COLUMN `empresa_id` TO `company_id`, RENAME COLUMN `numero` TO `number`, RENAME COLUMN `situacao` TO `situation`, RENAME COLUMN `data_hora_criacao` TO `created_at`, RENAME COLUMN `origem` TO `origin`, RENAME COLUMN `excluido` TO `deleted` ; RENAME TABLE tb_lotes_itens TO tb_splits_itens; ALTER TABLE `tb_splits_itens` RENAME COLUMN `lote_id` TO `split_id`, RENAME COLUMN `cpf_cnpj_titular` TO `doc_number`, RENAME COLUMN `nome_titular` TO `name_holder`, RENAME COLUMN `banco` TO `bank_code`, RENAME COLUMN `agencia` TO `branch_code`, RENAME COLUMN `conta` TO `account_number`, RENAME COLUMN `tipo_pix` TO `type_pix`, RENAME COLUMN `valor` TO `amount`, RENAME COLUMN `descricao` TO `description`, RENAME COLUMN `situacao` TO `situation`, RENAME COLUMN `descricao_status` TO `status_description`, RENAME COLUMN `data_erro` TO `date_error`, RENAME COLUMN `reprocessado` TO `reprocessed`, RENAME COLUMN `id_origem` TO `parent_id`, RENAME COLUMN `url_comprovante` TO `proof_url`, RENAME COLUMN `excluido` TO `deleted`, DROP COLUMN `valor_devolvido` ; ALTER TABLE `tb_payers` RENAME COLUMN `empresa_id` TO `company_id`, RENAME COLUMN `nome` TO `name`, RENAME COLUMN `cpf` TO `doc_number`, RENAME COLUMN `celular` TO `cell`, RENAME COLUMN `cep` TO `zip_code`, RENAME COLUMN `endereco` TO `street`, RENAME COLUMN `numero` TO `number`, RENAME COLUMN `bairro` TO `neighborhood`, RENAME COLUMN `cidade` TO `city`, RENAME COLUMN `uf` TO `state`, RENAME COLUMN `complemento` TO `complement`, RENAME COLUMN `excluido` TO `deleted` ; ALTER TABLE `tb_token_api` RENAME COLUMN `empresa_id` TO `company_id`, RENAME COLUMN `data_expiracao` TO `expiration_date` ; ALTER TABLE `tb_transactions` RENAME COLUMN `empresa_id` TO `company_id`, RENAME COLUMN `data_lancamento` TO `created_at`, RENAME COLUMN `lote_id` TO `split_id`, RENAME COLUMN `lote_itens_id` TO `split_item_id`, RENAME COLUMN `descricao` TO `description`, RENAME COLUMN `valor_total` TO `amount`, RENAME COLUMN `desconto` TO `discount`, RENAME COLUMN `multa` TO `penalty`, RENAME COLUMN `valor_tarifa` TO `amount_tax`, RENAME COLUMN `situacao` TO `situation`, RENAME COLUMN `url_comprovante` TO `proof_url`, RENAME COLUMN `descricao_status` TO `status_description`, RENAME COLUMN `data_erro` TO `date_error`, RENAME COLUMN `origem` TO `origin`, RENAME COLUMN `data_vencimento` TO `due_date`, RENAME COLUMN `valor_pago` TO `amount_paid`, RENAME COLUMN `data_pagamento` TO `payment_date`, RENAME COLUMN `tipo` TO `type`, RENAME COLUMN `linha_digitavel` TO `digitable_line`, RENAME COLUMN `codigo_barras` TO `barcode`, RENAME COLUMN `data_baixa` TO `low_date`, RENAME COLUMN `data_fatura` TO `invoice_date`, RENAME COLUMN `id_origem` TO `id_integration`, RENAME COLUMN `excluido` TO `deleted` ; RENAME TABLE tb_usuarios TO tb_users; ALTER TABLE `tb_users` RENAME COLUMN `empresa_id` TO `company_id`, RENAME COLUMN `nome` TO `name`, RENAME COLUMN `senha` TO `password`, RENAME COLUMN `grupo` TO `group`, RENAME COLUMN `token_reset_senha` TO `token_reset_password`, RENAME COLUMN `data_request_reset` TO `date_reset_request`, RENAME COLUMN `desativado` TO `disabled`, RENAME COLUMN `excluido` TO `deleted` ;
💾 保存文件
← 返回文件管理器