-- DBF - conversion  into SQL
-- Datetime create dump: 08 10 2019 | 17:36:43

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone="+01:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

-- --------------------------------------------------------
-- 
-- `proracun_ZARJED`
-- 

CREATE TABLE IF NOT EXISTS `proracun_ZARJED` (
`SIFRA_RJ` VARCHAR(2) ,
`NAZIV_RJ` VARCHAR(30) ,
`RAZDJEL` VARCHAR(60) ,
`GLAVA` VARCHAR(60) ,
`ADRESA_RJ` VARCHAR(20) ,
`PTT_RJ` VARCHAR(5) ,
`MJESTO_RJ` VARCHAR(15) ,
`ZIRO` VARCHAR(35) ,
`SIF_DJEL` VARCHAR(15) ,
`MJ_PLAT_PR` VARCHAR(15) ,
`OBVEZNIK` VARCHAR(1) ,
`JMBG_RJ` VARCHAR(13) ,
`DAT_UNOSA` DATE ,
`OIB` VARCHAR(11) ,
`ZIRO_IBAN` VARCHAR(4) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dump data table `proracun_ZARJED` (1 Records)
-- 

INSERT INTO `proracun_ZARJED` (`SIFRA_RJ`, `NAZIV_RJ`, `RAZDJEL`, `GLAVA`, `ADRESA_RJ`, `PTT_RJ`, `MJESTO_RJ`, `ZIRO`, `SIF_DJEL`, `MJ_PLAT_PR`, `OBVEZNIK`, `JMBG_RJ`, `DAT_UNOSA`, `OIB`, `ZIRO_IBAN`) VALUES
('01', 'OPĆINA NOVIGRAD PODRAVSKI     ', 'PREDST.TIJELA I JUO                                         ', '1                                                           ', 'Trg dr.Franje Tuđman', '48325', 'NOVIGRAD PODR. ', '2484008-1829200004                 ', '8411           ', 'KOPRIVNICA     ', 'N', '2721945      ', null, '73712345649', 'HR14');


/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;