-----------------------
CREATE TABLE IF NOT EXISTS public.interpolation_types (
    id serial not null,
    name character varying(255) COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT interpolation_types_pkey PRIMARY KEY (id)
);

-----------------------------------------------------------------
insert into interpolation_types (id, name) values (1, 'Krigagem');
insert into interpolation_types (id,name) values (2, 'IDW');

----------------------------------------------------------------
alter table parameters add column interpolation_type_id integer not null default 1 references interpolation_types(id);
alter table parameters add column pow integer null;

----------------------------------------------------------------
alter table products add column interpolation_type_id integer not null default 1 references interpolation_types(id);
alter table products add column pow integer null;