#[ ZACATEK SOUBORU ]#

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

#[ CREATE TABLE ZACATEK ]#
    idriadok SERIAL,
    id_cen integer NOT NULL DEFAULT 0,
    id_hlad integer NOT NULL DEFAULT 0,
    defhlad smallint NOT NULL DEFAULT 0,
    c_data smallint NOT NULL DEFAULT 1,
    cen_hlad character(2) COLLATE pg_catalog."default",
    m01 smallint NOT NULL DEFAULT 1,
    m02 smallint NOT NULL DEFAULT 1,
    m03 smallint NOT NULL DEFAULT 1,
    m04 smallint NOT NULL DEFAULT 1,
    m05 smallint NOT NULL DEFAULT 1,
    m06 smallint NOT NULL DEFAULT 1,
    m07 smallint NOT NULL DEFAULT 1,
    m08 smallint NOT NULL DEFAULT 1,
    m09 smallint NOT NULL DEFAULT 1,
    m10 smallint NOT NULL DEFAULT 1,
    m11 smallint NOT NULL DEFAULT 1,
    m12 smallint NOT NULL DEFAULT 1,
    d1 smallint NOT NULL DEFAULT 1,
    d2 smallint NOT NULL DEFAULT 1,
    d3 smallint NOT NULL DEFAULT 1,
    d4 smallint NOT NULL DEFAULT 1,
    d5 smallint NOT NULL DEFAULT 1,
    d6 smallint NOT NULL DEFAULT 1,
    d7 smallint NOT NULL DEFAULT 1,
    od date,
    "do" date,
    meno character varying(30) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
    CONSTRAINT <TABLENAME>_<PRIMARYKEY> PRIMARY KEY (idriadok)
#[ CREATE TABLE KONEC ]#

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