CREATE TABLE IF NOT EXISTS artikli (
      id integer PRIMARY KEY AUTOINCREMENT,
      naziv text NOT NULL,
      sifra text NOT NULL,
      kataloska_oznaka text DEFAULT NULL,
      barkod text DEFAULT NULL,
      merna_jedinica text NOT NULL,
      pdv_tip integer NOT NULL,
      last_edit integer DEFAULT NULL
    );''')
CREATE TABLE IF NOT EXISTS partneri (
      id integer PRIMARY KEY AUTOINCREMENT,
      naziv text NOT NULL,
      mesto text NOT NULL,
      id_mesta integer NOT NULL,
      adresa text NOT NULL,
      pib text NOT NULL,
      maticni_broj text NOT NULL,
      u_pdvu integer DEFAULT NULL,
      drzava text DEFAULT NULL
    );''')

CREATE TABLE IF NOT EXISTS zalihe (
      id integer PRIMARY KEY AUTOINCREMENT,
      sifra_artikla integer NOT NULL,
      trenutna_kolicina float DEFAULT '0.000000000',
      prodajna_cena_bez_pdv float DEFAULT '0.000000000',
      prodajna_cena_sa_pdv float DEFAULT '0.000000000'
    );''')