CREATE TABLE katalog.zbozi
(
  id serial NOT NULL,
  dodavatel_id integer NOT NULL,
  CONSTRAINT zbozi_pkey PRIMARY KEY (id ),
  CONSTRAINT fk_dodavatel FOREIGN KEY (dodavatel_id)
      REFERENCES katalog.dodavatel (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE RESTRICT,
)
WITH (
  OIDS=FALSE
);

CREATE INDEX fki_dodavatel
  ON katalog.zbozi
  USING btree
  (dodavatel_id );

CREATE TABLE katalog.dodavatel
(
  id integer NOT NULL DEFAULT nextval('katalog.dodavatele_id_seq'::regclass),
  CONSTRAINT dodavatele_pkey PRIMARY KEY (id )
)
WITH (
  OIDS=FALSE
);