· 6 years ago · Jul 09, 2019, 09:20 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.3.16-MariaDB - mariadb.org binary distribution
4-- Server OS: Win64
5-- HeidiSQL Version: 9.5.0.5196
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for beertag
16CREATE DATABASE IF NOT EXISTS `beertag` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `beertag`;
18
19-- Dumping structure for table beertag.authorities
20CREATE TABLE IF NOT EXISTS `authorities` (
21 `role_id` bigint(20) NOT NULL AUTO_INCREMENT,
22 `authority` varchar(255) DEFAULT NULL,
23 `username` varchar(255) DEFAULT NULL,
24 PRIMARY KEY (`role_id`)
25) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
26
27-- Dumping data for table beertag.authorities: 1 rows
28/*!40000 ALTER TABLE `authorities` DISABLE KEYS */;
29INSERT INTO `authorities` (`role_id`, `authority`, `username`) VALUES
30 (1, 'ROLE_USER', 'vicky'),
31 (2, 'ROLE_ADMIN', 'vankata'),
32 (3, 'ROLE_ADMIN', 'admin'),
33 (4, 'ROLE_USER', 'pesho'),
34 (5, 'ROLE_USER', 'gosho'),
35 (6, 'ROLE_USER', 'tosho'),
36 (7, 'ROLE_ADMIN', 'adminToDelete');
37/*!40000 ALTER TABLE `authorities` ENABLE KEYS */;
38
39-- Dumping structure for table beertag.beers
40CREATE TABLE IF NOT EXISTS `beers` (
41 `beer_id` int(11) NOT NULL AUTO_INCREMENT,
42 `abv` double DEFAULT NULL,
43 `brewery` varchar(200) DEFAULT NULL,
44 `country` varchar(150) DEFAULT NULL,
45 `description` varchar(255) DEFAULT NULL,
46 `beer_image` mediumblob DEFAULT NULL,
47 `name` varchar(200) DEFAULT NULL,
48 `rating` double DEFAULT NULL,
49 `style` varchar(255) DEFAULT NULL,
50 `votes_count` int(11) DEFAULT NULL,
51 PRIMARY KEY (`beer_id`)
52) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
53
54-- Dumping data for table beertag.beers: 2 rows
55/*!40000 ALTER TABLE `beers` DISABLE KEYS */;
56INSERT INTO `beers` (`beer_id`, `abv`, `brewery`, `country`, `description`, `beer_image`, `name`, `rating`, `style`, `votes_count`) VALUES
57 (1, 5.7, 'Zagorka Brewery', 'Bulgaria', 'Brand from the city of Stara Zagora', NULL, 'Zagorka Rezerva', 5, 'dark', 1),
58 (2, 2.2, 'Shumensko Brewery', 'Bulgaria', 'Owned by Carlsberg', NULL, 'Shumensko Twist', 3, 'flavoured', 2),
59 (3, 6, 'Kamenitza Brewery', 'Bulgaria', 'Mujete znaqt zashto', NULL, 'Kamenitza', 0, 'dark', 0),
60 (4, 4.4, 'Astika Brewery', 'Bulgaria', 'Chisto ot moreto', NULL, 'Burgasko', 0, 'light', 0),
61 (5, 4.7, 'Pirinsko Pivo', 'Bulgaria', 'Chisto ot planinata', NULL, 'Pirinsko', 0, 'light', 0),
62 (6, 4.5, 'Corona Extra', 'Mexico', 'One of top-selling beers worldwide', NULL, 'Corona Extra', 0, 'pale lager', 0),
63 (7, 5, 'Heineken Brewery', 'Netherlands', 'Dutch beer made in Amsterdam', NULL, 'Heineken', 0, 'light', 0);
64/*!40000 ALTER TABLE `beers` ENABLE KEYS */;
65
66-- Dumping structure for table beertag.beer_tags
67CREATE TABLE IF NOT EXISTS `beer_tags` (
68 `beer_id` int(11) NOT NULL,
69 `tag_id` int(11) NOT NULL,
70 KEY `FKp526blxg922766loy9sd8n0x9` (`tag_id`),
71 KEY `FKewrqvh9tkpjuh1c8xd55t5eui` (`beer_id`)
72) ENGINE=MyISAM DEFAULT CHARSET=latin1;
73
74-- Dumping data for table beertag.beer_tags: 0 rows
75/*!40000 ALTER TABLE `beer_tags` DISABLE KEYS */;
76/*!40000 ALTER TABLE `beer_tags` ENABLE KEYS */;
77
78-- Dumping structure for table beertag.tags
79CREATE TABLE IF NOT EXISTS `tags` (
80 `id` int(11) NOT NULL AUTO_INCREMENT,
81 `name` varchar(100) DEFAULT NULL,
82 PRIMARY KEY (`id`)
83) ENGINE=MyISAM DEFAULT CHARSET=latin1;
84
85-- Dumping data for table beertag.tags: 0 rows
86/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
87/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
88
89-- Dumping structure for table beertag.users
90CREATE TABLE IF NOT EXISTS `users` (
91 `user_id` int(11) NOT NULL AUTO_INCREMENT,
92 `email` varchar(100) DEFAULT NULL,
93 `enabled` bit(1) DEFAULT NULL,
94 `first_name` varchar(20) DEFAULT NULL,
95 `last_name` varchar(20) DEFAULT NULL,
96 `password` varchar(20) DEFAULT NULL,
97 `username` varchar(20) DEFAULT NULL,
98 `role_id` bigint(20) DEFAULT NULL,
99 PRIMARY KEY (`user_id`),
100 KEY `FKcir1phbv18ycs062m9ygjtpbk` (`role_id`)
101) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
102
103-- Dumping data for table beertag.users: 1 rows
104/*!40000 ALTER TABLE `users` DISABLE KEYS */;
105INSERT INTO `users` (`user_id`, `email`, `enabled`, `first_name`, `last_name`, `password`, `username`, `role_id`) VALUES
106 (1, 'vicky@mail.bg', b'1', 'Viktoriya', 'Georgieva', '{noop}12345678', 'vicky', 1),
107 (2, 'vankata@mail.bg', b'1', 'Vankata', 'Simeonov', '{noop}adminadmin', 'vankata', 2),
108 (3, 'admin@gmail.com', b'1', 'admin', 'admin', '{noop}12345678', 'admin', 3),
109 (4, 'peshov@gmail.com', b'1', 'Pesho', 'Peshov', '{noop}12345678', 'pesho', 4),
110 (5, 'goshov@gmail.com', b'1', 'Gosho', 'Goshov', '{noop}12345678', 'gosho', 5),
111 (6, 'toshev@gmail.com', b'1', 'Tosho', 'Toshev', '{noop}12345678', 'tosho', 6),
112 (7, 'adminToDelete@gmail.com', b'1', 'admin', 'admin', '{noop}adminadmin', 'adminToDelete', 7),;
113/*!40000 ALTER TABLE `users` ENABLE KEYS */;
114
115-- Dumping structure for table beertag.user_beer_dranklist
116CREATE TABLE IF NOT EXISTS `user_beer_dranklist` (
117 `user_id` int(11) NOT NULL,
118 `beer_id` int(11) NOT NULL,
119 KEY `FKfub7ybbib97lpogkai7cbo0vj` (`beer_id`),
120 KEY `FK6u9o6trfocau3cuaxsps7q1ey` (`user_id`)
121) ENGINE=MyISAM DEFAULT CHARSET=latin1;
122
123-- Dumping data for table beertag.user_beer_dranklist: 0 rows
124/*!40000 ALTER TABLE `user_beer_dranklist` DISABLE KEYS */;
125/*!40000 ALTER TABLE `user_beer_dranklist` ENABLE KEYS */;
126
127-- Dumping structure for table beertag.user_beer_wishlist
128CREATE TABLE IF NOT EXISTS `user_beer_wishlist` (
129 `user_id` int(11) NOT NULL,
130 `beer_id` int(11) NOT NULL,
131 KEY `FKppoo1gq3yh7ciconhnkdk1111` (`beer_id`),
132 KEY `FKawu26t4bs3yvkbimfpoinnxa7` (`user_id`)
133) ENGINE=MyISAM DEFAULT CHARSET=latin1;
134
135-- Dumping data for table beertag.user_beer_wishlist: 0 rows
136/*!40000 ALTER TABLE `user_beer_wishlist` DISABLE KEYS */;
137/*!40000 ALTER TABLE `user_beer_wishlist` ENABLE KEYS */;
138
139/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
140/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
141/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;