#[ ZACATEK SOUBORU ]#

#DEF <SCHEMA>    frontsql
#DEF <PRIMARYKEY> i_akc_ub
#DEF <TABLENAME> akc_ub

#[ CREATE TABLE ZACATEK ]#
    i_akcia integer NOT NULL DEFAULT (0)::integer,
    osob smallint DEFAULT (0)::smallint,
    odter timestamp without time zone NOT NULL DEFAULT '1971-01-01 00:00:00'::timestamp without time zone,
    doter timestamp without time zone NOT NULL DEFAULT '1971-01-01 00:00:00'::timestamp without time zone,
    i_typ_izby integer,
    datcas timestamp without time zone DEFAULT '1971-01-01 00:00:00'::timestamp without time zone,
    c_user integer,
    zmaz smallint,
    pozn text COLLATE pg_catalog."default",
    nakl_cena numeric DEFAULT 0.00,
    cena numeric DEFAULT 0.0,
    i_izba integer DEFAULT (0)::integer,
    pocet integer DEFAULT 0,
    in_pozn text COLLATE pg_catalog."default",
    dph numeric,
    i_akc_ub SERIAL,
    CONSTRAINT i_akc_ub PRIMARY KEY (i_akc_ub)
#[ CREATE TABLE KONEC ]#

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

DROP INDEX IF EXISTS frontsql."FK_akc_ub__typ_izby";
CREATE INDEX "FK_akc_ub__typ_izby"
    ON frontsql.akc_ub USING btree
    (i_typ_izby ASC NULLS LAST)
    TABLESPACE pg_default;

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

END IF;
#[ KONEC SOUBORU ]#