-- 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 `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');
COMMIT;

