---

CREATE TABLE dev.unique_number (
    code varchar(50) NOT NULL,
    serial_number int4 DEFAULT 0 NOT NULL,
    "version" timestamp DEFAULT now() NOT NULL,
    "comment" varchar(200) NULL,
    text_prefix_number varchar(50) NULL,
    serial_prefix_number int4 DEFAULT 0 NULL,
    id int4 NOT NULL,
    group_code varchar(20) NULL,
    text_postfix_number varchar(50) DEFAULT ''::character varying NULL,
    "sequence" varchar(255) NULL,
    new_year bool DEFAULT false NULL,
    max_pp_val int4 NULL,
    left_padding varchar(20) NULL,
    pad_length int4 NULL,
    CONSTRAINT unique_number_code_key UNIQUE (code),
    CONSTRAINT unique_number_id_pk PRIMARY KEY (id)
)
WITH (
    autovacuum_enabled=on
);

-- Table Triggers

create trigger dev_unique_number_table_audit after
insert
    or
delete
    or
update
    on
    dev.unique_number for each row execute function security.table_audit('id');
create trigger reset_counter_trigger before
update
    of serial_number on
    dev.unique_number for each row
    when (((old.code)::text = 'output_paiment_order_number'::text)) execute function dev.reset_on_reaching_endval();