BLMKQ2Y7

1-- phpMyAdmin SQL Dump
2-- version 4.8.3
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Generation Time: Jan 13, 2019 at 05:36 PM
7-- Server version: 5.7.17-log
8-- PHP Version: 7.2.10
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `scrumtable`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `projekt`
29--
30
31DROP TABLE IF EXISTS `projekt`;
32CREATE TABLE IF NOT EXISTS `projekt` (
33  `idProjekt` int(11) NOT NULL AUTO_INCREMENT,
34  `naziv` varchar(500) COLLATE utf8_slovenian_ci NOT NULL,
35  `steviloSprintov` int(11) NOT NULL,
36  PRIMARY KEY (`idProjekt`),
37  UNIQUE KEY `idProjekt` (`idProjekt`)
38) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
39
40--
41-- Dumping data for table `projekt`
42--
43
44INSERT INTO `projekt` (`idProjekt`, `naziv`, `steviloSprintov`) VALUES
45(23, 'Test', 1),
46(24, 'TEST2', 1);
47
48-- --------------------------------------------------------
49
50--
51-- Table structure for table `sprint`
52--
53
54DROP TABLE IF EXISTS `sprint`;
55CREATE TABLE IF NOT EXISTS `sprint` (
56  `idSprint` int(11) NOT NULL AUTO_INCREMENT,
57  `naziv` varchar(500) COLLATE utf8_slovenian_ci NOT NULL,
58  `idProjekt` int(11) NOT NULL,
59  PRIMARY KEY (`idSprint`),
60  UNIQUE KEY `idSprint` (`idSprint`)
61) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
62
63--
64-- Dumping data for table `sprint`
65--
66
67INSERT INTO `sprint` (`idSprint`, `naziv`, `idProjekt`) VALUES
68(15, 'Sprint 1', 23),
69(16, 'Sprint 1', 24);
70
71-- --------------------------------------------------------
72
73--
74-- Table structure for table `task`
75--
76
77DROP TABLE IF EXISTS `task`;
78CREATE TABLE IF NOT EXISTS `task` (
79  `idTask` int(11) NOT NULL AUTO_INCREMENT,
80  `naziv` varchar(500) COLLATE utf8_slovenian_ci NOT NULL,
81  `opis` varchar(500) COLLATE utf8_slovenian_ci NOT NULL,
82  `rok_taska` date NOT NULL,
83  `obtezitev` int(11) NOT NULL,
84  `stanje` int(3) NOT NULL,
85  `idSprint` int(11) NOT NULL,
86  `idUporabnik` int(11) DEFAULT NULL,
87  PRIMARY KEY (`idTask`),
88  UNIQUE KEY `idTask` (`idTask`)
89) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
90
91--
92-- Dumping data for table `task`
93--
94
95INSERT INTO `task` (`idTask`, `naziv`, `opis`, `rok_taska`, `obtezitev`, `stanje`, `idSprint`, `idUporabnik`) VALUES
96(3, 'TESTNI ', 'ZA TEST.', '2019-01-15', 4, 2, 15, 7),
97(4, 'testni task', 'Test, narejen za testiranje dodeljevanja taska uporabniku.', '2019-01-21', 4, 1, 15, NULL);
98
99-- --------------------------------------------------------
100
101--
102-- Table structure for table `uporabnik`
103--
104
105DROP TABLE IF EXISTS `uporabnik`;
106CREATE TABLE IF NOT EXISTS `uporabnik` (
107  `idUporabnik` int(11) NOT NULL AUTO_INCREMENT,
108  `ime` varchar(50) COLLATE utf8_slovenian_ci NOT NULL,
109  `priimek` varchar(50) COLLATE utf8_slovenian_ci NOT NULL,
110  `email` varchar(50) COLLATE utf8_slovenian_ci NOT NULL,
111  `geslo` varchar(50) COLLATE utf8_slovenian_ci NOT NULL,
112  PRIMARY KEY (`idUporabnik`),
113  UNIQUE KEY `idUporabnik` (`idUporabnik`)
114) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
115
116--
117-- Dumping data for table `uporabnik`
118--
119
120INSERT INTO `uporabnik` (`idUporabnik`, `ime`, `priimek`, `email`, `geslo`) VALUES
121(7, 'Uroš', 'Zagoranski', 'uros@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220'),
122(8, 'Toni', 'Haramija', 'toni@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220'),
123(9, 'Test', 'Test', 'test@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220');
124
125-- --------------------------------------------------------
126
127--
128-- Table structure for table `uporabnikhasprojekt`
129--
130
131DROP TABLE IF EXISTS `uporabnikhasprojekt`;
132CREATE TABLE IF NOT EXISTS `uporabnikhasprojekt` (
133  `idUporabnikHasProjekt` int(11) NOT NULL AUTO_INCREMENT,
134  `idProjekt` int(11) NOT NULL,
135  `idUporabnik` int(11) NOT NULL,
136  PRIMARY KEY (`idUporabnikHasProjekt`),
137  UNIQUE KEY `idUporabnikHasProjekt` (`idUporabnikHasProjekt`)
138) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
139
140--
141-- Dumping data for table `uporabnikhasprojekt`
142--
143
144INSERT INTO `uporabnikhasprojekt` (`idUporabnikHasProjekt`, `idProjekt`, `idUporabnik`) VALUES
145(32, 23, 9),
146(33, 23, 7),
147(34, 24, 9);
148COMMIT;
149
150/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
151/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
152/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;