编辑文件 - 001.sql

✏️ 正在编辑: 001.sql

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

# Dump de tabela tb_acessos_historico
# ------------------------------------------------------------

CREATE TABLE `tb_acessos_historico` (
  `id` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int NOT NULL,
  `ip` varchar(16) COLLATE utf8mb3_unicode_ci NOT NULL,
  `datahora` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `tb_acessos_historico_usuario_id_index` (`usuario_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

# Dump de tabela tb_empresas
# ------------------------------------------------------------

CREATE TABLE `tb_empresas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fantasia` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `razao_social` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cnpj` varchar(19) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `data_cadastro` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `responsavel` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cpf_responsavel` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cep` varchar(8) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `endereco` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `bairro` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cidade` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `uf` char(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `complemento` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `numero` varchar(5) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `celular` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fone` varchar(14) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tipo_tarifa` int DEFAULT '0',
  `tarifa` decimal(15,2) DEFAULT '0.00',
  `account_id` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `chave_pix` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tipo_pix_devolucao` varchar(20) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pix_devolucao` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `obs` text COLLATE utf8mb3_unicode_ci,
  `desativado` tinyint NOT NULL DEFAULT '0',
  `excluido` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `excluido` (`excluido`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

# Dump de tabela tb_lotes
# ------------------------------------------------------------

CREATE TABLE `tb_lotes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `empresa_id` int NOT NULL,
  `numero` varchar(10) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'PENDENTE',
  `data_hora_criacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `origem` varchar(10) COLLATE utf8mb3_unicode_ci NOT NULL,
  `excluido` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `excluido` (`excluido`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

# Dump de tabela tb_lotes_itens
# ------------------------------------------------------------

CREATE TABLE `tb_lotes_itens` (
  `id` int NOT NULL AUTO_INCREMENT,
  `lote_id` int NOT NULL,
  `tipo_pix` varchar(10) COLLATE utf8mb3_unicode_ci NOT NULL,
  `pix` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `valor` decimal(15,2) NOT NULL DEFAULT '0.00',
  `descricao` varchar(140) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pix_end2end_id` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'PENDENTE',
  `descricao_status` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `url_comprovante` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `valor_devolvido` decimal(15,2) NOT NULL DEFAULT '0.00',
  `excluido` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `lote_id` (`lote_id`),
  KEY `excluido` (`excluido`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

# Dump de tabela tb_recebimentos
# ------------------------------------------------------------

CREATE TABLE `tb_recebimentos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `empresa_id` int NOT NULL,
  `lote_id` int NOT NULL,
  `valor_total` decimal(15,2) NOT NULL DEFAULT '0.00',
  `tarifa` decimal(15,2) NOT NULL DEFAULT '0.00',
  `valor_tarifa` decimal(15,2) NOT NULL DEFAULT '0.00',
  `data_hora_recebimento` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'PENDENTE',
  `url_comprovante` varchar(250) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `descricao_erro` varchar(250) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `origem` varchar(10) COLLATE utf8mb3_unicode_ci NOT NULL,
  `excluido` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `empresa_id` (`empresa_id`),
  KEY `excluido` (`excluido`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

# Dump de tabela tb_token_api
# ------------------------------------------------------------

CREATE TABLE `tb_token_api` (
  `id` int NOT NULL AUTO_INCREMENT,
  `empresa_id` int NOT NULL,
  `api` varchar(20) COLLATE utf8mb3_unicode_ci NOT NULL,
  `token` text COLLATE utf8mb3_unicode_ci,
  `data_expiracao` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

# Dump de tabela tb_usuarios
# ------------------------------------------------------------

CREATE TABLE `tb_usuarios` (
  `id` int NOT NULL AUTO_INCREMENT,
  `empresa_id` int NOT NULL,
  `nome` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `senha` varchar(100) COLLATE utf8mb3_unicode_ci NOT NULL,
  `grupo` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ip` varchar(15) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `token_reset_senha` varchar(32) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `data_request_reset` date DEFAULT NULL,
  `secret_gauth` varchar(20) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `desativado` tinyint DEFAULT '0',
  `excluido` tinyint DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `excluido` (`excluido`),
  KEY `empresa_id` (`empresa_id`),
  KEY `login` (`email`,`senha`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

# Dump de tabela tb_credentials
# ------------------------------------------------------------

CREATE TABLE `tb_credentials` (
  `id` int NOT NULL AUTO_INCREMENT,
  `empresa_id` int NOT NULL,
  `api_key` VARCHAR(29) NOT NULL,
  `client_id` VARCHAR(16) NOT NULL,
  `client_secret` VARCHAR(32) NOT NULL,
  `data_cadastro` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `tb_credentials_empresa_id` (`empresa_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

← 返回文件管理器