qgesJhDu

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : localhost
5Source Server Version : 50505
6Source Host           : localhost:3306
7Source Database       : banka_db
8
9Target Server Type    : MYSQL
10Target Server Version : 50505
11File Encoding         : 65001
12
13Date: 2018-06-16 13:41:24
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `racun`
20-- ----------------------------
21DROP TABLE IF EXISTS `racun`;
22CREATE TABLE `racun` (
23  `racun_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
24  `id` int(5) unsigned NOT NULL,
25  `fk_vlasnik_jmbg` bigint(15) unsigned NOT NULL,
26  `stanje` double(10,0) NOT NULL,
27  PRIMARY KEY (`racun_id`),
28  KEY `fk_racun_vlasnik_jmbg` (`fk_vlasnik_jmbg`),
29  CONSTRAINT `fk_racun_vlasnik_jmbg` FOREIGN KEY (`fk_vlasnik_jmbg`) REFERENCES `vlasnik` (`jmbg`) ON UPDATE CASCADE
30) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
31
32-- ----------------------------
33-- Records of racun
34-- ----------------------------
35INSERT INTO `racun` VALUES ('1', '12345', '1908992805077', '1232');
36INSERT INTO `racun` VALUES ('2', '66669', '1908992805077', '-300');
37INSERT INTO `racun` VALUES ('3', '11111', '1709987230492', '12312');
38INSERT INTO `racun` VALUES ('4', '12121', '1709987230492', '1212');
39
40-- ----------------------------
41-- Table structure for `vlasnik`
42-- ----------------------------
43DROP TABLE IF EXISTS `vlasnik`;
44CREATE TABLE `vlasnik` (
45  `vlasnik_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
46  `jmbg` bigint(13) unsigned NOT NULL,
47  `ime` varchar(24) NOT NULL,
48  `prezime` varchar(24) NOT NULL,
49  `adresa` varchar(200) NOT NULL,
50  PRIMARY KEY (`vlasnik_id`),
51  UNIQUE KEY `uq_vlasnik_jmbg` (`jmbg`)
52) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
53
54-- ----------------------------
55-- Records of vlasnik
56-- ----------------------------
57INSERT INTO `vlasnik` VALUES ('1', '1908992805077', 'mili', 'ca', '128/12 jg, nbg');
58INSERT INTO `vlasnik` VALUES ('2', '1709987230492', 'david', 'dancuk', '12/12/12 alkdjf, skjfTT');