· 9 years ago · Jan 14, 2017, 08:56 PM
1-- phpMyAdmin SQL Dump
2-- version 4.6.5.1
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost:8889
6-- Generation Time: Jan 14, 2017 at 09:53 PM
7-- Server version: 5.6.34
8-- PHP Version: 7.1.0
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `petdo12`
15--
16CREATE DATABASE IF NOT EXISTS `petdo12` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
17USE `petdo12`;
18
19-- --------------------------------------------------------
20
21--
22-- Table structure for table `advice`
23--
24
25CREATE TABLE `advice` (
26 `id` int(11) NOT NULL,
27 `user_id` int(11) NOT NULL,
28 `subject` varchar(255) NOT NULL,
29 `text` text NOT NULL,
30 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
31) ENGINE=InnoDB DEFAULT CHARSET=utf8;
32
33--
34-- Dumping data for table `advice`
35--
36
37INSERT INTO `advice` (`id`, `user_id`, `subject`, `text`, `time`) VALUES
38(116, 168, 'IM2', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
39(117, 169, 'ASP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
40(118, 169, 'TP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
41(119, 168, 'IM1', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
42(120, 168, 'IM2', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
43(121, 169, 'ASP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
44(122, 169, 'TP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
45(123, 168, 'IM1', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
46(124, 168, 'IM2', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
47(125, 169, 'ASP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
48(126, 169, 'TP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
49(127, 168, 'IM1', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
50(128, 168, 'IM2', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
51(129, 169, 'ASP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
52(130, 169, 'TP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
53(131, 168, 'IM1', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
54(132, 168, 'IM2', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
55(133, 169, 'ASP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
56(134, 169, 'TP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
57(135, 168, 'IM1', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
58(136, 168, 'IM2', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
59(137, 169, 'ASP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
60(138, 169, 'TP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
61(139, 168, 'IM1', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
62(140, 168, 'IM2', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
63(141, 169, 'ASP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
64(142, 169, 'TP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
65(143, 168, 'IM1', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
66(144, 168, 'IM2', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
67(145, 169, 'ASP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
68(146, 169, 'TP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
69(147, 168, 'IM1', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
70(148, 168, 'IM2', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
71(149, 169, 'ASP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
72(151, 196, 'xgfchgvjbh', 'hjb', '2017-01-14 18:51:17'),
73(152, 168, 'IM2', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
74(153, 169, 'ASP', '\\n Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.\\n ', '0000-00-00 00:00:00'),
75(154, 196, 'uu', 'uu', '2017-01-14 18:53:12');
76
77-- --------------------------------------------------------
78
79--
80-- Table structure for table `resource`
81--
82
83CREATE TABLE `resource` (
84 `id` int(11) NOT NULL,
85 `description` varchar(255) NOT NULL,
86 `filepath` varchar(255) NOT NULL,
87 `user_id` int(11) NOT NULL
88) ENGINE=InnoDB DEFAULT CHARSET=utf8;
89
90--
91-- Dumping data for table `resource`
92--
93
94INSERT INTO `resource` (`id`, `description`, `filepath`, `user_id`) VALUES
95(1, 'super materijal', '/files/skripta.pdf', 1);
96
97-- --------------------------------------------------------
98
99--
100-- Table structure for table `user`
101--
102
103CREATE TABLE `user` (
104 `id` int(11) NOT NULL,
105 `username` varchar(255) NOT NULL,
106 `password` varchar(255) NOT NULL,
107 `profileimg` varchar(255) NOT NULL,
108 `email` varchar(255) NOT NULL
109) ENGINE=InnoDB DEFAULT CHARSET=utf8;
110
111--
112-- Dumping data for table `user`
113--
114
115INSERT INTO `user` (`id`, `username`, `password`, `profileimg`, `email`) VALUES
116(167, 'admin', 'admin', '../images/admin.png', 'test@test.com'),
117(168, 'IM2mag', 'ostrogradski', '../images/admin.png', 'test@test.com'),
118(169, 'kompajler', 'interpreter', '../images/admin.png', 'test@test.com'),
119(170, 'admin', 'admin', '../images/admin.png', 'test@test.com'),
120(171, 'IM2mag', 'ostrogradski', '../images/admin.png', 'test@test.com'),
121(172, 'kompajler', 'interpreter', '../images/admin.png', 'test@test.com'),
122(173, 'admin', 'admin', '../images/admin.png', 'test@test.com'),
123(174, 'IM2mag', 'ostrogradski', '../images/admin.png', 'test@test.com'),
124(175, 'kompajler', 'interpreter', '../images/admin.png', 'test@test.com'),
125(176, 'admin', 'admin', '../images/admin.png', 'test@test.com'),
126(177, 'IM2mag', 'ostrogradski', '../images/admin.png', 'test@test.com'),
127(178, 'kompajler', 'interpreter', '../images/admin.png', 'test@test.com'),
128(179, 'admin', 'admin', '../images/admin.png', 'test@test.com'),
129(180, 'IM2mag', 'ostrogradski', '../images/admin.png', 'test@test.com'),
130(181, 'kompajler', 'interpreter', '../images/admin.png', 'test@test.com'),
131(182, 'admin', 'admin', '../images/admin.png', 'test@test.com'),
132(183, 'IM2mag', 'ostrogradski', '../images/admin.png', 'test@test.com'),
133(184, 'kompajler', 'interpreter', '../images/admin.png', 'test@test.com'),
134(185, 'admin', 'admin', '../images/admin.png', 'test@test.com'),
135(186, 'IM2mag', 'ostrogradski', '../images/admin.png', 'test@test.com'),
136(187, 'kompajler', 'interpreter', '../images/admin.png', 'test@test.com'),
137(188, 'admin', 'admin', '../images/admin.png', 'test@test.com'),
138(189, 'IM2mag', 'ostrogradski', '../images/admin.png', 'test@test.com'),
139(190, 'kompajler', 'interpreter', '../images/admin.png', 'test@test.com'),
140(191, 'admin', 'admin', '../images/admin.png', 'test@test.com'),
141(192, 'IM2mag', 'ostrogradski', '../images/admin.png', 'test@test.com'),
142(193, 'admin', 'admin', '../images/admin.png', 'test@test.com'),
143(194, 'IM2mag', 'ostrogradski', '../images/admin.png', 'test@test.com'),
144(195, 'kompajler', 'interpreter', '../images/admin.png', 'test@test.com'),
145(196, 'admin', 'admin', '../images/admin.png', 'test@test.com'),
146(197, 'IM2mag', 'ostrogradski', '../images/admin.png', 'test@test.com');
147
148--
149-- Indexes for dumped tables
150--
151
152--
153-- Indexes for table `advice`
154--
155ALTER TABLE `advice`
156 ADD PRIMARY KEY (`id`),
157 ADD UNIQUE KEY `id` (`id`),
158 ADD KEY `user_id` (`user_id`);
159
160--
161-- Indexes for table `resource`
162--
163ALTER TABLE `resource`
164 ADD PRIMARY KEY (`id`),
165 ADD KEY `user_id` (`user_id`);
166
167--
168-- Indexes for table `user`
169--
170ALTER TABLE `user`
171 ADD PRIMARY KEY (`id`);
172
173--
174-- AUTO_INCREMENT for dumped tables
175--
176
177--
178-- AUTO_INCREMENT for table `advice`
179--
180ALTER TABLE `advice`
181 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=155;
182--
183-- AUTO_INCREMENT for table `resource`
184--
185ALTER TABLE `resource`
186 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
187--
188-- AUTO_INCREMENT for table `user`
189--
190ALTER TABLE `user`
191 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=198;
192--
193-- Constraints for dumped tables
194--
195
196--
197-- Constraints for table `advice`
198--
199ALTER TABLE `advice`
200 ADD CONSTRAINT `advice_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);
201
202--
203-- Constraints for table `resource`
204--
205ALTER TABLE `resource`
206 ADD CONSTRAINT `resource_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);