· 7 years ago · Feb 16, 2019, 03:02 PM
1-- phpMyAdmin SQL Dump
2-- version 4.8.2
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: Feb 16, 2019 at 03:58 PM
7-- Server version: 10.1.34-MariaDB
8-- PHP Version: 7.2.8
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: `cybeer`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `beers`
29--
30
31DROP TABLE IF EXISTS `beers`;
32CREATE TABLE `beers` (
33 `id` int(11) NOT NULL,
34 `name` varchar(255) COLLATE latin1_general_ci NOT NULL,
35 `user_id` int(11) NOT NULL,
36 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
37) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
38
39-- --------------------------------------------------------
40
41--
42-- Table structure for table `brewing_lists`
43--
44
45DROP TABLE IF EXISTS `brewing_lists`;
46CREATE TABLE `brewing_lists` (
47 `id` int(11) NOT NULL,
48 `user_id` int(11) NOT NULL,
49 `date_start` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
50 `date_end` timestamp NULL DEFAULT NULL,
51 `tank_id` int(11) NOT NULL
52) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
53
54--
55-- Dumping data for table `brewing_lists`
56--
57
58INSERT INTO `brewing_lists` (`id`, `user_id`, `date_start`, `date_end`, `tank_id`) VALUES
59(7, 1, '2019-02-16 10:10:45', '2019-02-16 10:19:13', 8),
60(8, 1, '2019-02-16 10:20:03', '2019-02-16 10:20:49', 9),
61(9, 1, '2019-02-16 14:47:43', NULL, 10);
62
63-- --------------------------------------------------------
64
65--
66-- Table structure for table `brewing_log`
67--
68
69DROP TABLE IF EXISTS `brewing_log`;
70CREATE TABLE `brewing_log` (
71 `id` int(11) NOT NULL,
72 `brewing_list_id` int(11) NOT NULL,
73 `action` enum('add','deduct') COLLATE latin1_general_ci DEFAULT NULL,
74 `storage_id` int(11) DEFAULT NULL,
75 `amount` decimal(10,2) DEFAULT NULL,
76 `units` enum('kg','l','ks') COLLATE latin1_general_ci DEFAULT NULL,
77 `description` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
78 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
79) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
80
81--
82-- Dumping data for table `brewing_log`
83--
84
85INSERT INTO `brewing_log` (`id`, `brewing_list_id`, `action`, `storage_id`, `amount`, `units`, `description`, `created`) VALUES
86(11, 7, NULL, NULL, NULL, NULL, 'Za?atie varenia: naplnenie nádrže 180 litrami vody | ', '2019-02-16 10:10:45'),
87(12, 7, 'add', 8, '2.00', 'kg', 'Pridavam psenicu', '2019-02-16 10:18:11'),
88(13, 7, 'add', 9, '2.00', 'kg', 'Teraz ide slad', '2019-02-16 10:18:30'),
89(14, 7, NULL, NULL, NULL, NULL, 'Ukon?enie varenia', '2019-02-16 10:19:13'),
90(15, 8, NULL, NULL, NULL, NULL, 'Za?atie varenia: naplnenie nádrže 190 litrami vody | ideme skusit apu', '2019-02-16 10:20:03'),
91(16, 8, 'add', 9, '8.00', 'kg', 'Najprv slad', '2019-02-16 10:20:21'),
92(17, 8, 'add', 8, '18.00', 'kg', 'Teraz by mala ist psenica', '2019-02-16 10:20:42'),
93(18, 8, NULL, NULL, NULL, NULL, 'Ukon?enie varenia', '2019-02-16 10:20:49'),
94(19, 9, NULL, NULL, NULL, NULL, 'Za?atie varenia: naplnenie nádrže 150 litrami vody | ', '2019-02-16 14:47:44'),
95(20, 9, 'add', 8, '4.80', '', '', '2019-02-16 14:47:55');
96
97-- --------------------------------------------------------
98
99--
100-- Table structure for table `clients`
101--
102
103DROP TABLE IF EXISTS `clients`;
104CREATE TABLE `clients` (
105 `id` int(11) NOT NULL,
106 `name` varchar(255) COLLATE latin1_general_ci NOT NULL,
107 `surname` varchar(255) COLLATE latin1_general_ci NOT NULL,
108 `phone` varchar(255) COLLATE latin1_general_ci NOT NULL,
109 `company` varchar(255) COLLATE latin1_general_ci NOT NULL,
110 `address` varchar(255) COLLATE latin1_general_ci NOT NULL,
111 `town` varchar(255) COLLATE latin1_general_ci NOT NULL,
112 `postcode` varchar(255) COLLATE latin1_general_ci NOT NULL,
113 `user_id` int(11) NOT NULL,
114 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
115) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
116
117--
118-- Dumping data for table `clients`
119--
120
121INSERT INTO `clients` (`id`, `name`, `surname`, `phone`, `company`, `address`, `town`, `postcode`, `user_id`, `created`) VALUES
122(1, 'Pavol', 'Havlik', '0950595773', 'Pivovar pod Topolom', 'Jarabikova 21/65', 'Podhajky', '555555', 1, '2018-11-14 17:41:36'),
123(2, 'Milan', 'Zahorsky', '0949 999 999', 'Hriskov', 'Lumena 2/37', 'Strmohrad', '62626', 1, '2018-11-14 17:42:52'),
124(3, 'Jozef', 'Mihalek', '0911 111 111', 'Tatry s.r.o.', 'Dziviakova 15', 'Tolava', '20020', 1, '2018-11-15 16:50:29'),
125(4, 'Jozef', 'Mihalek', '0911 111 111', 'Tatry s.r.o.', 'Dziviakova 15', 'Tolava', '20020', 1, '2018-11-15 16:51:00'),
126(5, 'Jozef', 'Mihalek', '0911 111 111', 'Tatry s.r.o.', 'Dziviakova 15', 'Tolava', '20020', 1, '2018-11-15 16:52:06'),
127(6, 'Jozef', 'Mihalek', '0911 111 111', 'Tatry s.r.o.', 'Dziviakova 15', 'Tolava', '20020', 1, '2018-11-15 16:52:30'),
128(7, 'Jozef', 'Mihalek', '0911 111 111', 'Tatry s.r.o.', 'Dziviakova 15', 'Tolava', '20020', 1, '2018-11-15 16:53:11'),
129(8, 'mariaca', 'hacaca', '000 55 88 9999', 'mno.jhj', 'mala', 'jakuza', '55555', 1, '2018-12-17 18:40:38');
130
131-- --------------------------------------------------------
132
133--
134-- Table structure for table `export`
135--
136
137DROP TABLE IF EXISTS `export`;
138CREATE TABLE `export` (
139 `id` int(11) NOT NULL,
140 `user_id` int(11) NOT NULL,
141 `client_id` int(11) NOT NULL,
142 `tank_id` int(11) NOT NULL,
143 `amount` decimal(10,2) NOT NULL,
144 `packaging` varchar(255) COLLATE latin1_general_ci NOT NULL,
145 `packaging_returned` timestamp NULL DEFAULT NULL,
146 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
147 `updated` timestamp NULL DEFAULT NULL
148) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
149
150--
151-- Dumping data for table `export`
152--
153
154INSERT INTO `export` (`id`, `user_id`, `client_id`, `tank_id`, `amount`, `packaging`, `packaging_returned`, `created`, `updated`) VALUES
155(7, 1, 1, 8, '100.00', '2x50L', NULL, '2019-02-16 10:19:36', NULL);
156
157-- --------------------------------------------------------
158
159--
160-- Table structure for table `storage`
161--
162
163DROP TABLE IF EXISTS `storage`;
164CREATE TABLE `storage` (
165 `id` int(11) NOT NULL,
166 `user_id` int(11) NOT NULL,
167 `name` varchar(255) COLLATE latin1_general_ci NOT NULL,
168 `amount` decimal(10,2) NOT NULL,
169 `units` enum('kg','l','ks') COLLATE latin1_general_ci NOT NULL
170) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
171
172--
173-- Dumping data for table `storage`
174--
175
176INSERT INTO `storage` (`id`, `user_id`, `name`, `amount`, `units`) VALUES
177(8, 1, 'PÅ¡enica', '75.20', 'kg'),
178(9, 1, 'Slad', '40.00', 'kg');
179
180-- --------------------------------------------------------
181
182--
183-- Table structure for table `storage_log`
184--
185
186DROP TABLE IF EXISTS `storage_log`;
187CREATE TABLE `storage_log` (
188 `id` int(11) NOT NULL,
189 `user_id` int(11) NOT NULL,
190 `storage_id` int(11) NOT NULL,
191 `action` enum('add','deduct') COLLATE latin1_general_ci NOT NULL,
192 `amount` decimal(10,2) NOT NULL,
193 `source` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
194 `source_type` enum('brewing_list') COLLATE latin1_general_ci DEFAULT NULL,
195 `source_id` int(11) DEFAULT NULL,
196 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
197) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
198
199--
200-- Dumping data for table `storage_log`
201--
202
203INSERT INTO `storage_log` (`id`, `user_id`, `storage_id`, `action`, `amount`, `source`, `source_type`, `source_id`, `created`) VALUES
204(3, 1, 8, 'deduct', '2.00', 'Varenie', 'brewing_list', 7, '2019-02-16 10:18:11'),
205(4, 1, 9, 'deduct', '2.00', 'Varenie', 'brewing_list', 7, '2019-02-16 10:18:30'),
206(5, 1, 9, 'deduct', '8.00', 'Varenie', 'brewing_list', 8, '2019-02-16 10:20:21'),
207(6, 1, 8, 'deduct', '18.00', 'Varenie', 'brewing_list', 8, '2019-02-16 10:20:42'),
208(7, 1, 8, 'deduct', '4.80', 'Varenie', 'brewing_list', 9, '2019-02-16 14:47:55');
209
210-- --------------------------------------------------------
211
212--
213-- Table structure for table `tanks`
214--
215
216DROP TABLE IF EXISTS `tanks`;
217CREATE TABLE `tanks` (
218 `id` int(11) NOT NULL,
219 `user_id` int(11) NOT NULL,
220 `type` enum('CL','CK') COLLATE latin1_general_ci NOT NULL,
221 `name` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
222 `capacity` decimal(10,2) NOT NULL,
223 `status` decimal(10,2) NOT NULL
224) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
225
226--
227-- Dumping data for table `tanks`
228--
229
230INSERT INTO `tanks` (`id`, `user_id`, `type`, `name`, `capacity`, `status`) VALUES
231(8, 1, 'CK', 'Stella', '200.00', '80.00'),
232(9, 1, 'CL', 'Apa', '200.00', '190.00'),
233(10, 1, 'CK', 'Epa 14', '500.00', '150.00');
234
235-- --------------------------------------------------------
236
237--
238-- Table structure for table `tanks_log`
239--
240
241DROP TABLE IF EXISTS `tanks_log`;
242CREATE TABLE `tanks_log` (
243 `id` int(11) NOT NULL,
244 `tank_id` int(11) NOT NULL,
245 `user_id` int(11) NOT NULL,
246 `text` text COLLATE latin1_general_ci NOT NULL,
247 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
248) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
249
250-- --------------------------------------------------------
251
252--
253-- Table structure for table `users`
254--
255
256DROP TABLE IF EXISTS `users`;
257CREATE TABLE `users` (
258 `id` int(11) NOT NULL,
259 `name` varchar(255) COLLATE latin1_general_ci NOT NULL,
260 `email` varchar(255) COLLATE latin1_general_ci NOT NULL,
261 `password` varchar(255) COLLATE latin1_general_ci NOT NULL
262) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
263
264--
265-- Indexes for dumped tables
266--
267
268--
269-- Indexes for table `beers`
270--
271ALTER TABLE `beers`
272 ADD PRIMARY KEY (`id`);
273
274--
275-- Indexes for table `brewing_lists`
276--
277ALTER TABLE `brewing_lists`
278 ADD PRIMARY KEY (`id`);
279
280--
281-- Indexes for table `brewing_log`
282--
283ALTER TABLE `brewing_log`
284 ADD PRIMARY KEY (`id`);
285
286--
287-- Indexes for table `clients`
288--
289ALTER TABLE `clients`
290 ADD PRIMARY KEY (`id`);
291
292--
293-- Indexes for table `export`
294--
295ALTER TABLE `export`
296 ADD PRIMARY KEY (`id`);
297
298--
299-- Indexes for table `storage`
300--
301ALTER TABLE `storage`
302 ADD PRIMARY KEY (`id`);
303
304--
305-- Indexes for table `storage_log`
306--
307ALTER TABLE `storage_log`
308 ADD PRIMARY KEY (`id`);
309
310--
311-- Indexes for table `tanks`
312--
313ALTER TABLE `tanks`
314 ADD PRIMARY KEY (`id`),
315 ADD KEY `name` (`name`);
316
317--
318-- Indexes for table `tanks_log`
319--
320ALTER TABLE `tanks_log`
321 ADD PRIMARY KEY (`id`);
322
323--
324-- Indexes for table `users`
325--
326ALTER TABLE `users`
327 ADD PRIMARY KEY (`id`);
328
329--
330-- AUTO_INCREMENT for dumped tables
331--
332
333--
334-- AUTO_INCREMENT for table `beers`
335--
336ALTER TABLE `beers`
337 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
338
339--
340-- AUTO_INCREMENT for table `brewing_lists`
341--
342ALTER TABLE `brewing_lists`
343 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
344
345--
346-- AUTO_INCREMENT for table `brewing_log`
347--
348ALTER TABLE `brewing_log`
349 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
350
351--
352-- AUTO_INCREMENT for table `clients`
353--
354ALTER TABLE `clients`
355 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
356
357--
358-- AUTO_INCREMENT for table `export`
359--
360ALTER TABLE `export`
361 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
362
363--
364-- AUTO_INCREMENT for table `storage`
365--
366ALTER TABLE `storage`
367 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
368
369--
370-- AUTO_INCREMENT for table `storage_log`
371--
372ALTER TABLE `storage_log`
373 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
374
375--
376-- AUTO_INCREMENT for table `tanks`
377--
378ALTER TABLE `tanks`
379 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
380
381--
382-- AUTO_INCREMENT for table `users`
383--
384ALTER TABLE `users`
385 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
386COMMIT;
387
388/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
389/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
390/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;