-- Table: public.nfs_impressora_fiscal_aatools_devices

-- DROP TABLE IF EXISTS public.nfs_impressora_fiscal_aatools_devices;

CREATE TABLE IF NOT EXISTS public.nfs_impressora_fiscal_aatools_devices
(
    filial integer NOT NULL,
    sequencia_aatools integer NOT NULL,
    type integer NOT NULL,
    nome character varying(100) COLLATE pg_catalog."default" NOT NULL,
    device character varying(100) COLLATE pg_catalog."default",
    CONSTRAINT nfs_impressora_fiscal_aatools_devices_pkey PRIMARY KEY (filial, sequencia_aatools, type, nome)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.nfs_impressora_fiscal_aatools_devices
    OWNER to postgres;
    
---------------------------------------------------------------------------------------------------------------------

-- Table: public.nfs_impressora_fiscal_type

-- DROP TABLE IF EXISTS public.nfs_impressora_fiscal_type;

CREATE TABLE IF NOT EXISTS public.nfs_impressora_fiscal_type
(
    filial integer NOT NULL,
    sequencia integer NOT NULL,
    desc_type character varying(100) COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT nfs_impressora_fiscal_type_pkey PRIMARY KEY (filial, sequencia)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.nfs_impressora_fiscal_type
    OWNER to postgres;
    
---------------------------------------------------------------------------------------------------------------------

ALTER TABLE nfs_impressora_fiscal_aatools ADD IF NOT EXISTS sequencia_aatools INTEGER;

UPDATE nfs_impressora_fiscal_aatools SET sequencia_aatools = 0 WHERE sequencia_aatools IS NULL;

ALTER TABLE nfs_impressora_fiscal_aatools ALTER COLUMN sequencia_aatools SET NOT NULL;