· 6 years ago · May 28, 2019, 01:42 PM
1-- --------------------------------------------------------
2-- Хост: 127.0.0.1
3-- Версия на сървъра: 10.1.31-MariaDB - mariadb.org binary distribution
4-- ОС на сървъра: Win32
5-- HeidiSQL Версия: 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-- Дъмп структура за таблица php_web_test.answers
15CREATE TABLE IF NOT EXISTS `answers` (
16 `id` int(11) NOT NULL AUTO_INCREMENT,
17 `body` longtext NOT NULL,
18 `author_id` int(11) NOT NULL,
19 `question_id` int(11) NOT NULL,
20 `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
21 PRIMARY KEY (`id`),
22 KEY `FK_answers_author_id__users_id` (`author_id`),
23 KEY `FK_answers_question_id__questions_id` (`question_id`),
24 CONSTRAINT `FK_answers_author_id__users_id` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`),
25 CONSTRAINT `FK_answers_question_id__questions_id` FOREIGN KEY (`question_id`) REFERENCES `questions` (`id`)
26) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
27
28-- Дъмп данни за таблица php_web_test.answers: ~3 rows (approximately)
29/*!40000 ALTER TABLE `answers` DISABLE KEYS */;
30INSERT INTO `answers` (`id`, `body`, `author_id`, `question_id`, `created_on`) VALUES
31 (1, 'Trudno se pishe PHP', 1, 3, '2019-05-26 14:00:14'),
32 (2, 'Ne e chak tolkoz trudno', 3, 3, '2019-05-26 16:22:21'),
33 (3, 'Nqma :(', 3, 6, '2019-05-27 20:01:14');
34/*!40000 ALTER TABLE `answers` ENABLE KEYS */;
35
36-- Дъмп структура за таблица php_web_test.categories
37CREATE TABLE IF NOT EXISTS `categories` (
38 `id` int(11) NOT NULL AUTO_INCREMENT,
39 `name` varchar(255) NOT NULL DEFAULT '0',
40 PRIMARY KEY (`id`)
41) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
42
43-- Дъмп данни за таблица php_web_test.categories: ~3 rows (approximately)
44/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
45INSERT INTO `categories` (`id`, `name`) VALUES
46 (1, 'Programming'),
47 (2, 'Databases'),
48 (3, 'Chat');
49/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
50
51-- Дъмп структура за таблица php_web_test.profiles
52CREATE TABLE IF NOT EXISTS `profiles` (
53 `user_id` int(11) NOT NULL,
54 `facebook_url` varchar(200) DEFAULT NULL,
55 `born_on` date DEFAULT NULL,
56 PRIMARY KEY (`user_id`),
57 CONSTRAINT `FK_profiles_user_id__users_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
58) ENGINE=InnoDB DEFAULT CHARSET=latin1;
59
60-- Дъмп данни за таблица php_web_test.profiles: ~2 rows (approximately)
61/*!40000 ALTER TABLE `profiles` DISABLE KEYS */;
62INSERT INTO `profiles` (`user_id`, `facebook_url`, `born_on`) VALUES
63 (1, 'fb.com/a', NULL),
64 (2, NULL, '2019-05-27');
65/*!40000 ALTER TABLE `profiles` ENABLE KEYS */;
66
67-- Дъмп структура за таблица php_web_test.questions
68CREATE TABLE IF NOT EXISTS `questions` (
69 `id` int(11) NOT NULL AUTO_INCREMENT,
70 `title` varchar(200) NOT NULL,
71 `body` longtext NOT NULL,
72 `category_id` int(11) NOT NULL,
73 `author_id` int(11) NOT NULL,
74 `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
75 PRIMARY KEY (`id`),
76 KEY `FK_questions_category_id__categories_id` (`category_id`),
77 KEY `FK_questions_author_id__users_id` (`author_id`),
78 CONSTRAINT `FK_questions_author_id__users_id` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`),
79 CONSTRAINT `FK_questions_category_id__categories_id` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`)
80) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
81
82-- Дъмп данни за таблица php_web_test.questions: ~3 rows (approximately)
83/*!40000 ALTER TABLE `questions` DISABLE KEYS */;
84INSERT INTO `questions` (`id`, `title`, `body`, `category_id`, `author_id`, `created_on`) VALUES
85 (3, 'KAk da pisha na PHP', 'Interesuwam se kak da pisha na PHP. Pomagadaite', 1, 2, '2019-05-26 12:00:00'),
86 (5, 'KAk se pishe SQL', 'Ili MySQL?', 2, 1, '2019-05-27 17:57:00'),
87 (6, 'Ima li JAvari', 'Kajete be', 3, 2, '2019-05-27 20:00:00');
88/*!40000 ALTER TABLE `questions` ENABLE KEYS */;
89
90-- Дъмп структура за таблица php_web_test.questions_tags
91CREATE TABLE IF NOT EXISTS `questions_tags` (
92 `question_id` int(11) NOT NULL,
93 `tag_id` int(11) NOT NULL,
94 PRIMARY KEY (`question_id`,`tag_id`),
95 KEY `FK_questions_tags_tag_id__tags_id` (`tag_id`),
96 CONSTRAINT `FK_questions_tags_question_id__questions_id` FOREIGN KEY (`question_id`) REFERENCES `questions` (`id`),
97 CONSTRAINT `FK_questions_tags_tag_id__tags_id` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`)
98) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
99
100-- Дъмп данни за таблица php_web_test.questions_tags: ~5 rows (approximately)
101/*!40000 ALTER TABLE `questions_tags` DISABLE KEYS */;
102INSERT INTO `questions_tags` (`question_id`, `tag_id`) VALUES
103 (3, 1),
104 (3, 2),
105 (3, 4),
106 (5, 2),
107 (6, 1);
108/*!40000 ALTER TABLE `questions_tags` ENABLE KEYS */;
109
110-- Дъмп структура за таблица php_web_test.tags
111CREATE TABLE IF NOT EXISTS `tags` (
112 `id` int(11) NOT NULL AUTO_INCREMENT,
113 `name` varchar(255) NOT NULL DEFAULT '0',
114 PRIMARY KEY (`id`)
115) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
116
117-- Дъмп данни за таблица php_web_test.tags: ~4 rows (approximately)
118/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
119INSERT INTO `tags` (`id`, `name`) VALUES
120 (1, 'PHP'),
121 (2, 'SQL'),
122 (3, 'Java'),
123 (4, 'Chushki');
124/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
125
126-- Дъмп структура за таблица php_web_test.users
127CREATE TABLE IF NOT EXISTS `users` (
128 `id` int(11) NOT NULL AUTO_INCREMENT,
129 `username` varchar(200) CHARACTER SET latin1 NOT NULL,
130 `password` varchar(255) CHARACTER SET latin1 NOT NULL,
131 `deleted_on` timestamp NULL DEFAULT NULL,
132 PRIMARY KEY (`id`),
133 UNIQUE KEY `username` (`username`)
134) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4;
135
136-- Дъмп данни за таблица php_web_test.users: ~17 rows (approximately)
137/*!40000 ALTER TABLE `users` DISABLE KEYS */;
138INSERT INTO `users` (`id`, `username`, `password`, `deleted_on`) VALUES
139 (1, 'pesho', '123', NULL),
140 (2, 'gosho', '321', NULL),
141 (3, 'penka', '132', NULL),
142 (4, 'gichka', '222', NULL),
143 (5, 'minka', '111', NULL),
144 (7, 'Manol4o', '345', NULL),
145 (8, 'Min4o', '3', NULL),
146 (9, 'asd', 'sad', NULL),
147 (10, 'dsfsdfdsfg', 'dfgdfgdfg', NULL),
148 (11, 'Min4ooo', '345', NULL),
149 (12, '123', 'nova_parola', NULL),
150 (13, 'EmoCholakov', '345', NULL),
151 (14, '321', 'nova_parola_again', NULL),
152 (15, 'CholakEmov\', \'345\'), ( (SELECT u.password FROM users u WHERE id = 2), \'nova_parola_again\'); -- ', 'tgrhgr43t', NULL),
153 (16, 'minchominchev', '$argon2i$v=19$m=1024,t=2,p=2$SEdHMXI0V2hZbkdxaFllTg$KDtc1zVqd8j9FD/5cezxM2BhxpgWkLofxPY9+LI9Xx0', NULL),
154 (17, 'fgrwedfv', '$argon2i$v=19$m=1024,t=2,p=2$V2JuTkIwRkg1U2h1MjNYbw$om99hMzxzQds3LAK4fn7Uv/W/fg7zRu9Z7jtXdZLfJY', NULL),
155 (19, 'new_user', '$argon2i$v=19$m=1024,t=2,p=2$Zk5yeVBFek1vd2w5RlAzRQ$UqVpB3sQZciUqH9Iq2HP7v+7rJAuOrd9jX3i7BUmtgw', NULL),
156 (22, 'penka_new', '$argon2i$v=19$m=1024,t=2,p=2$djlqZW5HUmc5MUJUci5DSQ$hv4ifdgdKUWY9wZWH1bqnkEYB3cw0ClBrQ+CFyAtXGM', NULL),
157 (26, '', '$argon2i$v=19$m=1024,t=2,p=2$bHdHbWpvMlhhWVE1Szhxbg$q+aPl3QC+PGAydOMPLRTi5lwLadw+HtZ4a5uVshu5xc', NULL),
158 (34, 'dfvb gdfv bgdfv', '$argon2i$v=19$m=1024,t=2,p=2$QzFkb2UyWFExR1hpQklQVg$Dy2n++2zlfeiE2d8fGZoWMagoSPDDXP6nNjhA+H8HG0', NULL);
159/*!40000 ALTER TABLE `users` ENABLE KEYS */;
160
161/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
162/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
163/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;