#[ ZACATEK SOUBORU ]#

#DEF <SCHEMA>    frontsql
#DEF <PRIMARYKEY> i_akc_prie
#DEF <TABLENAME> akc_prie

#[ CREATE TABLE ZACATEK ]#
    i_akcia integer,
    i_priestor integer,
    odter timestamp without time zone,
    doter timestamp without time zone,
    nakl_cena numeric,
    cena numeric,
    i_usporiad integer,
    pozn text COLLATE pg_catalog."default",
    zmaz boolean DEFAULT false,
    c_user integer,
    datcas timestamp without time zone DEFAULT '1971-01-01 00:00:00'::timestamp without time zone,
    osob smallint,
    in_pozn text COLLATE pg_catalog."default",
    dph numeric,
    i_akc_prie SERIAL,
    CONSTRAINT i_akc_prie PRIMARY KEY (i_akc_prie)
#[ CREATE TABLE KONEC ]#

#[ IF EXIST ZACATEK ]#
#[ PRIMARYKEY ]#

DROP INDEX IF EXISTS frontsql.i_akcia;
CREATE INDEX i_akcia
    ON frontsql.akc_prie USING btree
    (i_akcia ASC NULLS LAST)
    TABLESPACE pg_default;

DROP INDEX IF EXISTS frontsql.i_priestor;
CREATE INDEX i_priestor
    ON frontsql.akc_prie USING btree
    (i_priestor ASC NULLS LAST)
    TABLESPACE pg_default;
END IF;
#[ KONEC SOUBORU ]#