CLpDY1Qd

1DROP TABLE IF EXISTS `finansijski_promet`;
2/*!40101 SET @saved_cs_client     = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `finansijski_promet` (
5  `FPRO_ID` int(10) NOT NULL DEFAULT '0',
6  `KNJN_ID` int(10) NOT NULL DEFAULT '-1',
7  `dokId` int(10) NOT NULL DEFAULT '-1',
8  `dokId_VEZA` int(10) NOT NULL DEFAULT '-1',
9  `KON_ID` int(10) NOT NULL DEFAULT '-1',
10  `TanId` int(10) NOT NULL DEFAULT '-1',
11  `anId` int(10) NOT NULL DEFAULT '-1',
12  `pgodId` int(10) NOT NULL DEFAULT '-1',
13  `MT_ID` int(10) NOT NULL DEFAULT '-1',
14  `FPRO_IZVOR` varchar(45) NOT NULL DEFAULT '',
15  `FPRO_SMER` int(10) NOT NULL DEFAULT '-1',
16  `FPRO_IZNOS` decimal(16,2) NOT NULL DEFAULT '0.00',
17  `FPRO_IZNOS_VALUTA` decimal(16,2) NOT NULL DEFAULT '0.00',
18  `valId` int(10) NOT NULL DEFAULT '-1',
19  `FPRO_OPIS` varchar(255) NOT NULL DEFAULT '',
20  `FPRO_VREMEPR` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
21  PRIMARY KEY (`FPRO_ID`),
22  KEY `dokIdX` (`dokId`),
23  KEY `KNJN_IDX` (`KNJN_ID`),
24  KEY `anIdX` (`KON_ID`,`TanId`,`anId`,`pgodId`,`valId`),
25  KEY `KON_IDX` (`KON_ID`),
26  KEY `KON_PG_IDX` (`KON_ID`,`pgodId`),
27  KEY `MT_PG_ID` (`MT_ID`,`pgodId`)
28) ENGINE=InnoDB DEFAULT CHARSET=utf8;
29/*!40101 SET character_set_client = @saved_cs_client */;
30
31--
32-- Dumping data for table `finansijski_promet`
33--
34
35LOCK TABLES `finansijski_promet` WRITE;
36/*!40000 ALTER TABLE `finansijski_promet` DISABLE KEYS */;
37/*!40000 ALTER TABLE `finansijski_promet` ENABLE KEYS */;
38UNLOCK TABLES;
39
40--
41-- Table structure for table `glavna_knjiga`
42--
43
44DROP TABLE IF EXISTS `glavna_knjiga`;
45/*!40101 SET @saved_cs_client     = @@character_set_client */;
46/*!40101 SET character_set_client = utf8 */;
47CREATE TABLE `glavna_knjiga` (
48  `GK_ID` int(10) NOT NULL DEFAULT '0',
49  `KON_ID` int(10) NOT NULL DEFAULT '-1',
50  `pgodId` int(10) NOT NULL DEFAULT '-1',
51  `valId` int(10) NOT NULL DEFAULT '-1',
52  `GK_POC_STANJE` decimal(18,2) NOT NULL DEFAULT '0.00',
53  `GK_POC_STANJE_VAL` decimal(18,2) NOT NULL DEFAULT '0.00',
54  `GK_DUGIJE` decimal(18,2) NOT NULL DEFAULT '0.00',
55  `GK_DUGIJE_VAL` decimal(18,2) NOT NULL DEFAULT '0.00',
56  `GK_POTRAZUJE` decimal(18,2) NOT NULL DEFAULT '0.00',
57  `GK_POTRAZUJE_VAL` decimal(18,2) NOT NULL DEFAULT '0.00',
58  PRIMARY KEY (`GK_ID`),
59  KEY `IDX_KON_PGOD` (`KON_ID`,`pgodId`)
60) ENGINE=InnoDB DEFAULT CHARSET=utf8;
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Dumping data for table `glavna_knjiga`
65--
66
67LOCK TABLES `glavna_knjiga` WRITE;
68/*!40000 ALTER TABLE `glavna_knjiga` DISABLE KEYS */;
69/*!40000 ALTER TABLE `glavna_knjiga` ENABLE KEYS */;
70UNLOCK TABLES;
71
72--
73-- Table structure for table `grupa_analiza`
74--
75
76DROP TABLE IF EXISTS `grupa_analiza`;
77/*!40101 SET @saved_cs_client     = @@character_set_client */;
78/*!40101 SET character_set_client = utf8 */;
79CREATE TABLE `grupa_analiza` (
80  `GRanId` int(10) NOT NULL DEFAULT '0',
81  `GRAN_NAZIV` varchar(40) NOT NULL DEFAULT '',
82  PRIMARY KEY (`GRanId`)
83) ENGINE=InnoDB DEFAULT CHARSET=utf8;
84/*!40101 SET character_set_client = @saved_cs_client */;
85
86--
87-- Dumping data for table `grupa_analiza`
88--
89
90LOCK TABLES `grupa_analiza` WRITE;
91/*!40000 ALTER TABLE `grupa_analiza` DISABLE KEYS */;
92INSERT INTO `grupa_analiza` VALUES (1040,'Hemijske analize'),(1041,'Otrovne materiije i teški metali'),(1042,'Fizičke analize'),(1043,'Mikrobiološke analize'),(1080,'Radiološke'),(1081,'Senzorne analize');
93/*!40000 ALTER TABLE `grupa_analiza` ENABLE KEYS */;
94UNLOCK TABLES;