Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.8.3
- -- https://www.phpmyadmin.net/
- --
- -- Host: 127.0.0.1:3306
- -- Generation Time: Jan 13, 2019 at 05:36 PM
- -- Server version: 5.7.17-log
- -- PHP Version: 7.2.10
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET AUTOCOMMIT = 0;
- START TRANSACTION;
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8mb4 */;
- --
- -- Database: `scrumtable`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `projekt`
- --
- DROP TABLE IF EXISTS `projekt`;
- CREATE TABLE IF NOT EXISTS `projekt` (
- `idProjekt` int(11) NOT NULL AUTO_INCREMENT,
- `naziv` varchar(500) COLLATE utf8_slovenian_ci NOT NULL,
- `steviloSprintov` int(11) NOT NULL,
- PRIMARY KEY (`idProjekt`),
- UNIQUE KEY `idProjekt` (`idProjekt`)
- ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
- --
- -- Dumping data for table `projekt`
- --
- INSERT INTO `projekt` (`idProjekt`, `naziv`, `steviloSprintov`) VALUES
- (23, 'Test', 1),
- (24, 'TEST2', 1);
- -- --------------------------------------------------------
- --
- -- Table structure for table `sprint`
- --
- DROP TABLE IF EXISTS `sprint`;
- CREATE TABLE IF NOT EXISTS `sprint` (
- `idSprint` int(11) NOT NULL AUTO_INCREMENT,
- `naziv` varchar(500) COLLATE utf8_slovenian_ci NOT NULL,
- `idProjekt` int(11) NOT NULL,
- PRIMARY KEY (`idSprint`),
- UNIQUE KEY `idSprint` (`idSprint`)
- ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
- --
- -- Dumping data for table `sprint`
- --
- INSERT INTO `sprint` (`idSprint`, `naziv`, `idProjekt`) VALUES
- (15, 'Sprint 1', 23),
- (16, 'Sprint 1', 24);
- -- --------------------------------------------------------
- --
- -- Table structure for table `task`
- --
- DROP TABLE IF EXISTS `task`;
- CREATE TABLE IF NOT EXISTS `task` (
- `idTask` int(11) NOT NULL AUTO_INCREMENT,
- `naziv` varchar(500) COLLATE utf8_slovenian_ci NOT NULL,
- `opis` varchar(500) COLLATE utf8_slovenian_ci NOT NULL,
- `rok_taska` date NOT NULL,
- `obtezitev` int(11) NOT NULL,
- `stanje` int(3) NOT NULL,
- `idSprint` int(11) NOT NULL,
- `idUporabnik` int(11) DEFAULT NULL,
- PRIMARY KEY (`idTask`),
- UNIQUE KEY `idTask` (`idTask`)
- ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
- --
- -- Dumping data for table `task`
- --
- INSERT INTO `task` (`idTask`, `naziv`, `opis`, `rok_taska`, `obtezitev`, `stanje`, `idSprint`, `idUporabnik`) VALUES
- (3, 'TESTNI ', 'ZA TEST.', '2019-01-15', 4, 2, 15, 7),
- (4, 'testni task', 'Test, narejen za testiranje dodeljevanja taska uporabniku.', '2019-01-21', 4, 1, 15, NULL);
- -- --------------------------------------------------------
- --
- -- Table structure for table `uporabnik`
- --
- DROP TABLE IF EXISTS `uporabnik`;
- CREATE TABLE IF NOT EXISTS `uporabnik` (
- `idUporabnik` int(11) NOT NULL AUTO_INCREMENT,
- `ime` varchar(50) COLLATE utf8_slovenian_ci NOT NULL,
- `priimek` varchar(50) COLLATE utf8_slovenian_ci NOT NULL,
- `email` varchar(50) COLLATE utf8_slovenian_ci NOT NULL,
- `geslo` varchar(50) COLLATE utf8_slovenian_ci NOT NULL,
- PRIMARY KEY (`idUporabnik`),
- UNIQUE KEY `idUporabnik` (`idUporabnik`)
- ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
- --
- -- Dumping data for table `uporabnik`
- --
- INSERT INTO `uporabnik` (`idUporabnik`, `ime`, `priimek`, `email`, `geslo`) VALUES
- (7, 'UroΕ‘', 'Zagoranski', 'uros@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220'),
- (8, 'Toni', 'Haramija', 'toni@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220'),
- (9, 'Test', 'Test', 'test@gmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220');
- -- --------------------------------------------------------
- --
- -- Table structure for table `uporabnikhasprojekt`
- --
- DROP TABLE IF EXISTS `uporabnikhasprojekt`;
- CREATE TABLE IF NOT EXISTS `uporabnikhasprojekt` (
- `idUporabnikHasProjekt` int(11) NOT NULL AUTO_INCREMENT,
- `idProjekt` int(11) NOT NULL,
- `idUporabnik` int(11) NOT NULL,
- PRIMARY KEY (`idUporabnikHasProjekt`),
- UNIQUE KEY `idUporabnikHasProjekt` (`idUporabnikHasProjekt`)
- ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
- --
- -- Dumping data for table `uporabnikhasprojekt`
- --
- INSERT INTO `uporabnikhasprojekt` (`idUporabnikHasProjekt`, `idProjekt`, `idUporabnik`) VALUES
- (32, 23, 9),
- (33, 23, 7),
- (34, 24, 9);
- COMMIT;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement