#[ ZACATEK SOUBORU ]#

#DEF <SCHEMA>    frontsql
#DEF <PRIMARYKEY> i_akc_slu
#DEF <TABLENAME> akc_slu

#[ CREATE TABLE ZACATEK ]#
    i_akcia integer,
    i_sluzba integer,
    odter timestamp without time zone,
    doter timestamp without time zone,
    cena numeric,
    nakl_cena numeric,
    i_food integer,
    i_vykonavat integer,
    i_zod_oso integer,
    pozn text COLLATE pg_catalog."default",
    stav smallint,
    zmaz boolean DEFAULT false,
    c_user integer,
    datcas timestamp without time zone DEFAULT '1971-01-01 00:00:00'::timestamp without time zone,
    pocet integer DEFAULT 1,
    i_dodavat integer,
    i_os_zo integer,
    i_os_vy integer,
    i_os_do integer,
    food_limit character varying(45) COLLATE pg_catalog."default",
    in_pozn text COLLATE pg_catalog."default",
    dph numeric,
    i_priestor integer,
    i_akc_slu SERIAL,
    CONSTRAINT i_akc_slu PRIMARY KEY (i_akc_slu)
#[ CREATE TABLE KONEC ]#

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

DROP INDEX IF EXISTS frontsql."FK_akc_slu_do";
CREATE INDEX "FK_akc_slu_do"
    ON frontsql.akc_slu USING btree
    (i_os_do ASC NULLS LAST)
    TABLESPACE pg_default;

DROP INDEX IF EXISTS frontsql."FK_akc_slu_sluzba";
CREATE INDEX "FK_akc_slu_sluzba"
    ON frontsql.akc_slu USING btree
    (i_sluzba ASC NULLS LAST)
    TABLESPACE pg_default;

DROP INDEX IF EXISTS frontsql."FK_akc_slu_vykon";
CREATE INDEX "FK_akc_slu_vykon"
    ON frontsql.akc_slu USING btree
    (i_os_vy ASC NULLS LAST)
    TABLESPACE pg_default;

DROP INDEX IF EXISTS frontsql."FK_akc_slu_zo";
CREATE INDEX "FK_akc_slu_zo"
    ON frontsql.akc_slu USING btree
    (i_os_zo ASC NULLS LAST)
    TABLESPACE pg_default;

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

END IF;
#[ KONEC SOUBORU ]#