You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Please take a look at the following SQL formatted using vscode-sqltools (notice two spaces in front last CREATEs):
-- Tabela de contribuintesCREATETABLEIF NOT EXISTS fiscalidade_taxpayers (
-- Identificador único
id BIGSERIALPRIMARY KEY,
-- Nome
name VARCHAR(200) NOT NULL UNIQUE,
-- Razão Social
business_name VARCHAR(200) NOT NULL UNIQUE,
-- CNPJ
registry VARCHAR(20) NOT NULL UNIQUE,
-- E-mail
email VARCHAR(100) NOT NULL UNIQUE,
-- Certificado PKCS #12
certificate TEXTNOT NULL,
-- Senha do certificado
certificate_password VARCHAR(100) NOT NULL,
-- Token para login
token VARCHAR(60) NOT NULL UNIQUE,
-- Administrador
manager BOOLEAN DEFAULT TRUE,
-- Ativo
active BOOLEANNOT NULL DEFAULT TRUE,
-- Data de cadastro
created_at TIMESTAMP WITHOUT TIME ZONE DEFAULT CURRENT_TIMESTAMP
);
-- Insere usuário padrão (admin)INSERT INTO fiscalidade_taxpayers (
name,
business_name,
registry,
email,
certificate,
certificate_password,
token,
manager
)
VALUES
(
'admin',
'Administrador',
'',
'',
'',
'',
'yBtY7BaUiGIHMEXzs1UUdr',
true
);
-- Tabela de serviçosCREATETABLEIF NOT EXISTS fiscalidade_services (
-- Identificador único
id BIGSERIALPRIMARY KEY,
-- Descrição (NF-e, NFC-e etc.)
description CHARACTER VARYING(50) NOT NULL UNIQUE,
-- Serviço (nfe, nfce etc.)
slug CHARACTER VARYING(50) NOT NULL UNIQUE,
-- Ativo
active BOOLEANNOT NULL DEFAULT TRUE,
-- Data de cadastro
created_at TIMESTAMP WITHOUT TIME ZONE DEFAULT CURRENT_TIMESTAMP
);
-- Tabela para relacionar serviço a contribuinteCREATETABLEIF NOT EXISTS fiscalidade_taxpayers_services (
id BIGSERIALPRIMARY KEY,
-- ID do contribuinte
taxpayer_id BIGINTNOT NULLREFERENCES fiscalidade_taxpayers (id) ONUPDATE CASCADE ON DELETE CASCADE,
-- ID do serviço
service_id BIGINTNOT NULLREFERENCES fiscalidade_services (id) ONUPDATE CASCADE ON DELETE CASCADE,
-- Data de permissão
allowed_at TIMESTAMP WITHOUT TIME ZONE DEFAULT CURRENT_TIMESTAMP,
-- Data de cadastro
created_at TIMESTAMP WITHOUT TIME ZONE DEFAULT CURRENT_TIMESTAMP,
UNIQUE (taxpayer_id, service_id)
);
-- Insere serviços disponíveis.INSERT INTO fiscalidade_services (description, slug)
VALUES
('NF-e', 'nfe');
It should be formatted as following:
-- Tabela de contribuintesCREATETABLEIF NOT EXISTS fiscalidade_taxpayers (
-- Identificador único
id BIGSERIALPRIMARY KEY,
-- Nome
name VARCHAR(200) NOT NULL UNIQUE,
-- Razão Social
business_name VARCHAR(200) NOT NULL UNIQUE,
-- CNPJ
registry VARCHAR(20) NOT NULL UNIQUE,
-- E-mail
email VARCHAR(100) NOT NULL UNIQUE,
-- Certificado PKCS #12
certificate TEXTNOT NULL,
-- Senha do certificado
certificate_password VARCHAR(100) NOT NULL,
-- Token para login
token VARCHAR(60) NOT NULL UNIQUE,
-- Administrador
manager BOOLEAN DEFAULT TRUE,
-- Ativo
active BOOLEANNOT NULL DEFAULT TRUE,
-- Data de cadastro
created_at TIMESTAMP WITHOUT TIME ZONE DEFAULT CURRENT_TIMESTAMP
);
-- Insere usuário padrão (admin)INSERT INTO fiscalidade_taxpayers (
name,
business_name,
registry,
email,
certificate,
certificate_password,
token,
manager
)
VALUES
(
'admin',
'Administrador',
'',
'',
'',
'',
'yBtY7BaUiGIHMEXzs1UUdr',
true
);
-- Tabela de serviçosCREATETABLEIF NOT EXISTS fiscalidade_services (
-- Identificador único
id BIGSERIALPRIMARY KEY,
-- Descrição (NF-e, NFC-e etc.)
description CHARACTER VARYING(50) NOT NULL UNIQUE,
-- Serviço (nfe, nfce etc.)
slug CHARACTER VARYING(50) NOT NULL UNIQUE,
-- Ativo
active BOOLEANNOT NULL DEFAULT TRUE,
-- Data de cadastro
created_at TIMESTAMP WITHOUT TIME ZONE DEFAULT CURRENT_TIMESTAMP
);
-- Tabela para relacionar serviço a contribuinteCREATETABLEIF NOT EXISTS fiscalidade_taxpayers_services (
id BIGSERIALPRIMARY KEY,
-- ID do contribuinte
taxpayer_id BIGINTNOT NULLREFERENCES fiscalidade_taxpayers (id) ONUPDATE CASCADE ON DELETE CASCADE,
-- ID do serviço
service_id BIGINTNOT NULLREFERENCES fiscalidade_services (id) ONUPDATE CASCADE ON DELETE CASCADE,
-- Data de permissão
allowed_at TIMESTAMP WITHOUT TIME ZONE DEFAULT CURRENT_TIMESTAMP,
-- Data de cadastro
created_at TIMESTAMP WITHOUT TIME ZONE DEFAULT CURRENT_TIMESTAMP,
UNIQUE (taxpayer_id, service_id)
);
-- Insere serviços disponíveis.INSERT INTO fiscalidade_services (description, slug)
VALUES
('NF-e', 'nfe');
Hi.
Please take a look at the following SQL formatted using
vscode-sqltools
(notice two spaces in front lastCREATE
s):It should be formatted as following:
Partially related/fixable by: #507
The text was updated successfully, but these errors were encountered: