Evo dump-a...
Code:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `tblgrane`
-- ----------------------------
DROP TABLE IF EXISTS `tblgrane`;
CREATE TABLE `tblgrane` (
`IdBroj` char(2) COLLATE utf8_slovenian_ci NOT NULL,
`NIdBroj` char(2) COLLATE utf8_slovenian_ci NOT NULL,
`Naziv` char(20) COLLATE utf8_slovenian_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
-- ----------------------------
-- Records of tblgrane
-- ----------------------------
INSERT INTO `tblgrane` VALUES ('1', '0', 'Grana 1');
INSERT INTO `tblgrane` VALUES ('2', '0', 'Grana 2');
INSERT INTO `tblgrane` VALUES ('3', '0', 'Grana 3');
INSERT INTO `tblgrane` VALUES ('4', '1', 'Grana 4');
INSERT INTO `tblgrane` VALUES ('5', '1', 'Grana 5');
INSERT INTO `tblgrane` VALUES ('6', '4', 'Grana 6');
-- ----------------------------
-- Table structure for `tblkupci`
-- ----------------------------
DROP TABLE IF EXISTS `tblkupci`;
CREATE TABLE `tblkupci` (
`IdBroj` char(2) COLLATE utf8_slovenian_ci NOT NULL,
`Grana` char(2) COLLATE utf8_slovenian_ci NOT NULL,
`Naziv` char(20) COLLATE utf8_slovenian_ci NOT NULL,
`VrednostKupovine` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
-- ----------------------------
-- Records of tblkupci
-- ----------------------------
INSERT INTO `tblkupci` VALUES ('1', '2', 'Kupac 1', '100');
INSERT INTO `tblkupci` VALUES ('2', '3', 'Kupac 2', '200');
INSERT INTO `tblkupci` VALUES ('3', '4', 'Kupac 3', '200');
INSERT INTO `tblkupci` VALUES ('4', '5', 'Kupac 4', '100');
INSERT INTO `tblkupci` VALUES ('5', '6', 'Kupac 5', '200');