#[ ZACATEK SOUBORU ]#

#DEF <SCHEMA>    frontsql
#DEF <PRIMARYKEY> i_kongres
#DEF <TABLENAME> kongres

#[ CREATE TABLE ZACATEK ]#
    n_kongres character varying(40) COLLATE pg_catalog."default" NOT NULL,
    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,
    popis text COLLATE pg_catalog."default",
    i_klient integer,
    i_kon_oso integer,
    osob integer,
    zmaz boolean DEFAULT false,
    c_user integer,
    datcas timestamp without time zone DEFAULT '1971-01-01 00:00:00'::timestamp without time zone,
    i_cenn_hl integer,
    i_os_klien integer,
    i_os_ko integer,
    i_kongres SERIAL,
    CONSTRAINT pk_i_kongres PRIMARY KEY (i_kongres)
#[ CREATE TABLE KONEC ]#

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

DROP INDEX IF EXISTS frontsql."FK_kongres__klien";
CREATE INDEX "FK_kongres__klien"
    ON frontsql.kongres USING btree
    (i_os_klien ASC NULLS LAST)
    TABLESPACE pg_default;

DROP INDEX IF EXISTS frontsql."FK_kongres__ko";
CREATE INDEX "FK_kongres__ko"
    ON frontsql.kongres USING btree
    (i_os_ko ASC NULLS LAST)
    TABLESPACE pg_default;

END IF;
#[ KONEC SOUBORU ]#