#[ ZACATEK SOUBORU ]#

#DEF <SCHEMA>    food600
#DEF <PRIMARYKEY> idriadok
#DEF <TABLENAME> zlavy_hlav

#[ CREATE TABLE ZACATEK ]#
    c_kasy integer NOT NULL DEFAULT 0,
    aktivna smallint NOT NULL DEFAULT 0,
    zmazana smallint NOT NULL DEFAULT 0,
    meno character(30) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::bpchar,
    den1 smallint NOT NULL DEFAULT 0,
    den2 smallint NOT NULL DEFAULT 0,
    den3 smallint NOT NULL DEFAULT 0,
    den4 smallint NOT NULL DEFAULT 0,
    den5 smallint NOT NULL DEFAULT 0,
    den6 smallint NOT NULL DEFAULT 0,
    den7 smallint NOT NULL DEFAULT 0,
    mes01 smallint NOT NULL DEFAULT 0,
    mes02 smallint NOT NULL DEFAULT 0,
    mes03 smallint NOT NULL DEFAULT 0,
    mes04 smallint NOT NULL DEFAULT 0,
    mes05 smallint NOT NULL DEFAULT 0,
    mes06 smallint NOT NULL DEFAULT 0,
    mes07 smallint NOT NULL DEFAULT 0,
    mes08 smallint NOT NULL DEFAULT 0,
    mes09 smallint NOT NULL DEFAULT 0,
    mes10 smallint NOT NULL DEFAULT 0,
    mes11 smallint NOT NULL DEFAULT 0,
    mes12 smallint NOT NULL DEFAULT 0,
    casod character(5) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::bpchar,
    casdo character(5) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::bpchar,
    datumod date,
    datumdo date,
    c_data smallint NOT NULL DEFAULT 1,
    typ_zlavy smallint DEFAULT 1,
    zl_koef numeric(20,10) DEFAULT (0),
    zl_zadanie smallint NOT NULL DEFAULT 1,
    vs_druhy smallint NOT NULL DEFAULT 1,
    dat_cas_zm timestamp without time zone,
    autor character(3) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::bpchar,
    napolozku smallint NOT NULL DEFAULT 0,
    naucet smallint NOT NULL DEFAULT 0,
    ajpocenovejhladine smallint NOT NULL DEFAULT 0,
    ibajedna smallint NOT NULL DEFAULT 0,
    ajpozlavenapolozku smallint NOT NULL DEFAULT 0,
    idriadok SERIAL,
    prg_dotaz character(30) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::bpchar,
    prg_natiz character(30) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::bpchar,
    premenna character(30) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::bpchar,
    CONSTRAINT <TABLENAME>_<PRIMARYKEY> PRIMARY KEY (<PRIMARYKEY>)
#[ CREATE TABLE KONEC ]#


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

#[ KONEC SOUBORU ]#