57agdQ8A

1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Sep 22, 2016 at 07:42 PM
7-- Server version: 5.6.17
8-- PHP Version: 5.5.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `prehrana`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `narocilo_feedback`
27--
28
29CREATE TABLE IF NOT EXISTS `narocilo_feedback` (
30  `id` int(11) NOT NULL AUTO_INCREMENT,
31  `fk_uporabnik_id` bigint(20) NOT NULL,
32  `fk_narocilo_id` bigint(20) DEFAULT NULL,
33  `fk_lokal_id` bigint(20) NOT NULL,
34  `ocena` int(11) NOT NULL,
35  `mnenje` text NOT NULL,
36  PRIMARY KEY (`id`),
37  KEY `fk_lokal_id` (`fk_lokal_id`),
38  KEY `fk_uporabnik_id` (`fk_uporabnik_id`),
39  KEY `fk_narocilo_id` (`fk_narocilo_id`)
40) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
41
42--
43-- Dumping data for table `narocilo_feedback`
44--
45
46INSERT INTO `narocilo_feedback` (`id`, `fk_uporabnik_id`, `fk_narocilo_id`, `fk_lokal_id`, `ocena`, `mnenje`) VALUES
47(16, 86891762479, 54532842888, 82386710868, 4, '123');
48
49--
50-- Constraints for dumped tables
51--
52
53--
54-- Constraints for table `narocilo_feedback`
55--
56ALTER TABLE `narocilo_feedback`
57  ADD CONSTRAINT `narocilo_feedback_ibfk_3` FOREIGN KEY (`fk_lokal_id`) REFERENCES `lokal` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
58  ADD CONSTRAINT `narocilo_feedback_ibfk_1` FOREIGN KEY (`fk_uporabnik_id`) REFERENCES `uporabnik` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
59  ADD CONSTRAINT `narocilo_feedback_ibfk_2` FOREIGN KEY (`fk_narocilo_id`) REFERENCES `narocilo` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
60
61/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
62/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
63/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;