编辑文件 - n-1430.sql

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

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

ALTER TABLE `tb_companys`
  ADD `municipality_code` INT DEFAULT NULL AFTER `city`,
  ADD `automatic_nfse` tinyint DEFAULT 1 AFTER `obs`
  ;

CREATE TABLE tb_settings (
    id INT AUTO_INCREMENT PRIMARY KEY,
    reason VARCHAR(150) NOT NULL,
    fantasy VARCHAR(150) NOT NULL,
    doc_number VARCHAR(18) NOT NULL,
    address VARCHAR(255),
    city VARCHAR(100),
    state CHAR(2),
    zip_code VARCHAR(10),
    phone VARCHAR(20),
    email VARCHAR(150),
    nfse_series VARCHAR(10),
    nfse_last_number INT DEFAULT 0,
    nfse_enforceability INT DEFAULT 0,
    nfse_aliquot DECIMAL(15,2) DEFAULT 0,
    nfse_tax_type INT DEFAULT 0,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE
  `tb_services` (
    `id` int NOT NULL AUTO_INCREMENT,
    `code` varchar(5) NOT NULL,
    `tax_code` varchar(5) DEFAULT NULL,
    `description` varchar(250) NOT NULL,
    `cnae` varchar(7) DEFAULT NULL,
    `tax_type` int DEFAULT NULL,
    `enforceability` tinyint DEFAULT NULL,
    `aliquot` decimal(15, 2) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3 COLLATE = utf8mb3_unicode_ci;

insert into `tb_services` (`aliquot`, `cnae`, `code`, `tax_code`, `description`, `enforceability`, `tax_type`) 
  values (NULL, '8020001', '80.20', NULL, 'Atividades de monitoramento de sitemas de segurança eletrônico', NULL, NULL);

CREATE TABLE
  `tb_nfse` (
    `id` int NOT NULL AUTO_INCREMENT,
    `id_integration` varchar(50) NOT NULL,
    `id_nfse` varchar(50) DEFAULT NULL,
    `docket_id` int DEFAULT NULL,
    `message` text,
    `protocol` varchar(250) DEFAULT NULL,
    `status_code` int DEFAULT NULL,
    `error` varchar(250) DEFAULT NULL,
    `date_send` datetime DEFAULT NULL,
    `date_process` datetime DEFAULT NULL,
    `number_nfse` int DEFAULT NULL,
    `number` int DEFAULT NULL,
    `series` int DEFAULT NULL,
    `lot` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
    `verification_code` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
    `url_pdf` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
    `url_xml` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
    `date_authorization` datetime DEFAULT NULL,
    `deleted` tinyint DEFAULT '0',

PRIMARY KEY (`id`),
    KEY `docket_id` (`docket_id`)
  ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3 COLLATE = utf8mb3_unicode_ci;

CREATE TABLE
  `tb_nfse_itens` (
    `id` int NOT NULL AUTO_INCREMENT,
    `nfse_id` int NOT NULL,
    `provider_doc_number` varchar(19) NOT NULL,
    `taker_reason` varchar(250) DEFAULT NULL,
    `taker_doc_number` varchar(19) NOT NULL,
    `taker_email` varchar(150) NOT NULL,
    `taker_city` varchar(50) DEFAULT NULL,
    `taker_zip_code` varchar(8) NOT NULL,
    `taker_neighborhood` varchar(50) DEFAULT NULL,
    `taker_state` varchar(2) DEFAULT NULL,
    `taker_number` varchar(2) DEFAULT NULL,
    `service_description` varchar(250) NOT NULL,
    `service_amount` decimal(15, 2) DEFAULT NULL,
    `service_cnae` varchar(7) DEFAULT NULL,
    `service_iss_enforceability` int DEFAULT NULL,
    `service_iss_aliquot` decimal(15, 2) DEFAULT NULL,
    `service_iss_tax_type` int DEFAULT NULL,
    `deleted` tinyint DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `nfse_id` (`nfse_id`),
    CONSTRAINT `tb_nfse_itens_ibfk_1` FOREIGN KEY (`nfse_id`) REFERENCES `tb_nfse` (`id`)
  ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb3 COLLATE = utf8mb3_unicode_ci

← 返回文件管理器