#[ ZACATEK SOUBORU ]#

#DEF <SCHEMA>    frontsql
#DEF <PRIMARYKEY> i_typ_izby
#DEF <TABLENAME> typ_izby

#[ CREATE TABLE ZACATEK ]#
    n_typ_izby character varying(45) COLLATE pg_catalog."default" NOT NULL,
    lozok smallint,
    technicka smallint,
    skr_typ_izby character varying(10) COLLATE pg_catalog."default",
    nakl_cena numeric,
    ch1 numeric,
    ch2 numeric,
    ch3 numeric,
    ch4 numeric,
    ch5 numeric,
    ch6 numeric,
    ch7 numeric,
    ch8 numeric,
    ch9 numeric,
    ch10 numeric,
    pozn text COLLATE pg_catalog."default",
    dph1 numeric,
    dph2 numeric,
    dph3 numeric,
    dph4 numeric,
    dph5 numeric,
    dph6 numeric,
    dph7 numeric,
    dph8 numeric,
    dph9 numeric,
    dph10 numeric,
    poradie integer,
    zmaz boolean DEFAULT false,
    c_user integer,
    datcas timestamp without time zone DEFAULT '1971-01-01 00:00:00'::timestamp without time zone,
    kapacita integer,
    i_cenn integer,
    dph numeric,
    i_typ_izby SERIAL,
    CONSTRAINT pk_i_typ_izby PRIMARY KEY (i_typ_izby)
#[ CREATE TABLE KONEC ]#

#[ IF EXIST ZACATEK ]#
#[ PRIMARYKEY ]#
END IF;
#[ KONEC SOUBORU ]#