-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `forum`
--

-- --------------------------------------------------------

--
-- Table structure for table `komentari`
--

CREATE TABLE IF NOT EXISTS `komentari` (
  `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `program` text COLLATE latin2_croatian_ci NOT NULL,
  `tema` text COLLATE latin2_croatian_ci NOT NULL,
  `pitanje` bigint(20) NOT NULL,
  `sadrzaj` text COLLATE latin2_croatian_ci NOT NULL,
  `korisnik` text COLLATE latin2_croatian_ci NOT NULL,
  `ocjena` int(11) NOT NULL,
  `zatvoreno` text COLLATE latin2_croatian_ci NOT NULL,
  `datum` datetime NOT NULL,
  `vrsta` int(11) NOT NULL,
  `sadrzajpitanja` text COLLATE latin2_croatian_ci NOT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin2 COLLATE=latin2_croatian_ci;

--
-- Dumping data for table `komentari`
--

INSERT INTO `komentari` (`ID`, `program`, `tema`, `pitanje`, `sadrzaj`, `korisnik`, `ocjena`, `zatvoreno`, `datum`, `vrsta`, `sadrzajpitanja`) VALUES
(2, '1', '3', 23, 'Proba komentara', '2', 0, '0', '2020-05-24 08:34:46', 5, 'Kada ce program pokazati valute'),
(3, '1', '3', 23, 'Proba kometara 2', '2', 0, '0', '2020-05-24 08:52:26', 5, 'Kada ce program pokazati valute');

-- --------------------------------------------------------

--
-- Table structure for table `korisnici`
--

CREATE TABLE IF NOT EXISTS `korisnici` (
  `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sifra` text COLLATE latin2_croatian_ci NOT NULL,
  `imeiprezime` text COLLATE latin2_croatian_ci NOT NULL,
  `adresa` text COLLATE latin2_croatian_ci NOT NULL,
  `mjesto` text COLLATE latin2_croatian_ci NOT NULL,
  `drzava` text COLLATE latin2_croatian_ci NOT NULL,
  `klijent` int(11) NOT NULL,
  `email` text COLLATE latin2_croatian_ci NOT NULL,
  `vijesti` int(11) NOT NULL,
  `korime` text COLLATE latin2_croatian_ci NOT NULL,
  `lozinka` text COLLATE latin2_croatian_ci NOT NULL,
  `firma` text COLLATE latin2_croatian_ci NOT NULL,
  `telefon` text COLLATE latin2_croatian_ci NOT NULL,
  `anydesk` text COLLATE latin2_croatian_ci NOT NULL,
  `pol` text COLLATE latin2_croatian_ci NOT NULL,
  `aktivan` int(11) NOT NULL,
  `profil` int(11) NOT NULL,
  `datumprijave` date NOT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin2 COLLATE=latin2_croatian_ci;

--
-- Dumping data for table `korisnici`
--

INSERT INTO `korisnici` (`ID`, `sifra`, `imeiprezime`, `adresa`, `mjesto`, `drzava`, `klijent`, `email`, `vijesti`, `korime`, `lozinka`, `firma`, `telefon`, `anydesk`, `pol`, `aktivan`, `profil`, `datumprijave`) VALUES
(3, '2', 'Borojevic Zlatko', 'Samac', 'Samac', '', 0, '', 0, 'bzlatko', '111', '', '', '', '1', 1, 1, '2020-05-18'),
(4, '3', 'Slavica Stanojevic', 'Samac', 'Samac', 'BiH', 0, '', 0, 'slavica', '111', '', '', '', '2', 1, 0, '2020-05-23');

-- --------------------------------------------------------

--
-- Table structure for table `odgovori`
--

CREATE TABLE IF NOT EXISTS `odgovori` (
  `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `program` text COLLATE latin2_croatian_ci NOT NULL,
  `tema` text COLLATE latin2_croatian_ci NOT NULL,
  `pitanje` bigint(20) NOT NULL,
  `sadrzaj` text COLLATE latin2_croatian_ci NOT NULL,
  `korisnik` text COLLATE latin2_croatian_ci NOT NULL,
  `ocjena` int(11) NOT NULL,
  `zatvoreno` text COLLATE latin2_croatian_ci NOT NULL,
  `datum` datetime NOT NULL,
  `vrsta` int(11) NOT NULL,
  `sadrzajpitanja` text COLLATE latin2_croatian_ci NOT NULL,
  `nazivteme` text COLLATE latin2_croatian_ci NOT NULL,
  `nazivprograma` text COLLATE latin2_croatian_ci NOT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin2 COLLATE=latin2_croatian_ci;

--
-- Dumping data for table `odgovori`
--

INSERT INTO `odgovori` (`ID`, `program`, `tema`, `pitanje`, `sadrzaj`, `korisnik`, `ocjena`, `zatvoreno`, `datum`, `vrsta`, `sadrzajpitanja`, `nazivteme`, `nazivprograma`) VALUES
(13, '1', '3', 21, 'U tabeli stavke kolona Popust unesite  Postotak rabata koji dodjeljujete na Veleprodajnu cijenu robe', '3', 5, '0', '2020-05-24 09:08:48', 4, 'Kako se odredjuje rabat', 'Fakturisanje', 'Erkos'),
(12, '1', '3', 22, 'Valuta definise rok placanja a u programu sluzi za generisanje izvjestaja o potrazivanjima od kupaca koji nisu na vrijeme platili racun', '3', 5, '0', '2020-05-24 08:57:33', 4, 'Sta znaci valuta i za cega se koristi', 'Fakturisanje', 'Erkos'),
(11, '1', '3', 23, 'Kada pokrenete izvjestaj Pregled potrazivanja u Valuti', '3', 4, '0', '2020-05-24 07:42:09', 4, 'Kada ce program pokazati valute', 'Fakturisanje', 'Erkos');

-- --------------------------------------------------------

--
-- Table structure for table `pitanja`
--

CREATE TABLE IF NOT EXISTS `pitanja` (
  `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `program` text COLLATE latin2_croatian_ci NOT NULL,
  `tema` text COLLATE latin2_croatian_ci NOT NULL,
  `sadrzaj` text COLLATE latin2_croatian_ci NOT NULL,
  `korisnik` text COLLATE latin2_croatian_ci NOT NULL,
  `rijeseno` text COLLATE latin2_croatian_ci NOT NULL,
  `zatvoreno` text COLLATE latin2_croatian_ci NOT NULL,
  `datum` datetime NOT NULL,
  `vrsta` int(11) NOT NULL,
  `nazivprograma` text COLLATE latin2_croatian_ci NOT NULL,
  `nazivteme` text COLLATE latin2_croatian_ci NOT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin2 COLLATE=latin2_croatian_ci;

--
-- Dumping data for table `pitanja`
--

INSERT INTO `pitanja` (`ID`, `program`, `tema`, `sadrzaj`, `korisnik`, `rijeseno`, `zatvoreno`, `datum`, `vrsta`, `nazivprograma`, `nazivteme`) VALUES
(24, '1', '8', 'Ne vide se podaci o firmi. Gdje se postavljaju ?', '2', '0', '0', '2020-05-23 06:12:01', 0, '', ''),
(25, '1', '1', 'Marza ne radi kako treba', '2', '0', '0', '2020-05-23 06:22:12', 0, 'Erkos', 'Kalkulacije'),
(26, '1', '4', 'slaganje po partneru', '2', '0', '0', '2020-05-23 06:25:41', 0, 'Erkos', 'Trgovacka knjiga'),
(27, '1', '7', '123456789', '2', '0', '0', '2020-05-23 06:26:19', 0, 'Erkos', 'Proba vremena'),
(23, '1', '3', 'Kada ce program pokazati valute', '2', '0', '0', '2020-05-22 15:32:09', 0, 'Erkos', 'Fakturisanje'),
(22, '1', '3', 'Sta znaci valuta i za cega se koristi', '2', '0', '0', '2020-05-22 15:31:26', 0, 'Erkos', 'Fakturisanje'),
(21, '1', '3', 'Kako se odredjuje rabat', '2', '0', '0', '2020-05-22 11:07:07', 0, 'Erkos', 'Fakturisanje');

-- --------------------------------------------------------

--
-- Table structure for table `softwer`
--

CREATE TABLE IF NOT EXISTS `softwer` (
  `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sifra` text COLLATE latin2_croatian_ci NOT NULL,
  `naziv` text COLLATE latin2_croatian_ci NOT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin2 COLLATE=latin2_croatian_ci;

--
-- Dumping data for table `softwer`
--

INSERT INTO `softwer` (`ID`, `sifra`, `naziv`) VALUES
(1, '1', 'Erkos'),
(2, '2', 'Plate');

-- --------------------------------------------------------

--
-- Table structure for table `teme`
--

CREATE TABLE IF NOT EXISTS `teme` (
  `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `idsoft` text COLLATE latin2_croatian_ci NOT NULL,
  `nazivsoft` text COLLATE latin2_croatian_ci NOT NULL,
  `sifra` bigint(20) NOT NULL,
  `naziv` text COLLATE latin2_croatian_ci NOT NULL,
  `datum` datetime NOT NULL,
  `korisnik` text COLLATE latin2_croatian_ci NOT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin2 COLLATE=latin2_croatian_ci;

--
-- Dumping data for table `teme`
--

INSERT INTO `teme` (`ID`, `idsoft`, `nazivsoft`, `sifra`, `naziv`, `datum`, `korisnik`) VALUES
(5, '1', 'Erkos', 1, 'Kalkulacije', '2020-05-18 00:00:00', '2'),
(6, '2', 'Plate', 2, 'Stope doprinosa', '2020-05-18 00:00:00', '2'),
(7, '1', 'Erkos', 3, 'Fakturisanje', '2020-05-18 00:00:00', '2'),
(8, '1', 'Erkos', 4, 'Trgovacka knjiga', '2020-05-18 00:00:00', '2'),
(9, '2', 'Plate', 5, 'Rekapitulacije', '2020-05-18 00:00:00', '2'),
(10, '1', 'Erkos', 6, 'Knjiga nabavke i utroska repromaterijala', '2020-05-18 00:00:00', '2'),
(11, '1', 'Erkos', 7, 'Proba vremena', '2020-05-19 15:11:02', '2'),
(12, '1', 'Erkos', 8, 'Knjige za samostalne djelatnosti', '2020-05-23 06:12:01', '2');
COMMIT;

