|
|
1
|
+ |
-- phpMyAdmin SQL Dump
|
|
|
2
|
+ |
-- version 4.3.9
|
|
|
3
|
+ |
-- http://www.phpmyadmin.net
|
|
|
4
|
+ |
--
|
|
|
5
|
+ |
-- Host: sql
|
|
|
6
|
+ |
-- Generation Time: Mar 02, 2019 at 10:25 AM
|
|
|
7
|
+ |
-- Server version: 5.5.60-0+deb8u1
|
|
|
8
|
+ |
-- PHP Version: 5.6.38-0+deb8u1
|
|
|
9
|
+ |
|
|
1
|
10
|
|
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|
|
11
|
+ |
SET AUTOCOMMIT = 0;
|
|
|
12
|
+ |
START TRANSACTION;
|
|
2
|
13
|
|
SET time_zone = "+00:00";
|
|
3
|
14
|
|
|
|
|
15
|
+ |
|
|
4
|
16
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
5
|
17
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
6
|
18
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
7
|
19
|
|
/*!40101 SET NAMES utf8 */;
|
|
8
|
20
|
|
|
|
|
21
|
+ |
--
|
|
|
22
|
+ |
-- Database: `freepost_freepost`
|
|
|
23
|
+ |
--
|
|
9
|
24
|
|
CREATE DATABASE IF NOT EXISTS `freepost_freepost` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
|
10
|
25
|
|
USE `freepost_freepost`;
|
|
11
|
26
|
|
|
|
|
27
|
+ |
-- --------------------------------------------------------
|
|
|
28
|
+ |
|
|
|
29
|
+ |
--
|
|
|
30
|
+ |
-- Table structure for table `comment`
|
|
|
31
|
+ |
--
|
|
|
32
|
+ |
-- Creation: Jul 03, 2017 at 03:39 PM
|
|
|
33
|
+ |
--
|
|
|
34
|
+ |
|
|
12
|
35
|
|
DROP TABLE IF EXISTS `comment`;
|
|
13
|
36
|
|
CREATE TABLE IF NOT EXISTS `comment` (
|
|
14
|
37
|
|
`id` int(11) NOT NULL,
|
|
22
|
45
|
|
`parentUserId` int(11) DEFAULT NULL,
|
|
23
|
46
|
|
`postId` int(11) DEFAULT NULL,
|
|
24
|
47
|
|
`userId` int(11) DEFAULT NULL
|
|
25
|
|
- |
) ENGINE=InnoDB AUTO_INCREMENT=8027 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
48
|
+ |
) ENGINE=InnoDB AUTO_INCREMENT=11235 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
49
|
+ |
|
|
|
50
|
+ |
-- --------------------------------------------------------
|
|
|
51
|
+ |
|
|
|
52
|
+ |
--
|
|
|
53
|
+ |
-- Table structure for table `post`
|
|
|
54
|
+ |
--
|
|
|
55
|
+ |
-- Creation: Nov 25, 2017 at 04:35 AM
|
|
|
56
|
+ |
--
|
|
26
|
57
|
|
|
|
27
|
58
|
|
DROP TABLE IF EXISTS `post`;
|
|
28
|
59
|
|
CREATE TABLE IF NOT EXISTS `post` (
|
|
36
|
67
|
|
`vote` int(11) NOT NULL,
|
|
37
|
68
|
|
`commentsCount` int(11) NOT NULL,
|
|
38
|
69
|
|
`userId` int(11) DEFAULT NULL
|
|
39
|
|
- |
) ENGINE=InnoDB AUTO_INCREMENT=6566 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
70
|
+ |
) ENGINE=InnoDB AUTO_INCREMENT=13821 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
71
|
+ |
|
|
|
72
|
+ |
-- --------------------------------------------------------
|
|
|
73
|
+ |
|
|
|
74
|
+ |
--
|
|
|
75
|
+ |
-- Table structure for table `remember_me`
|
|
|
76
|
+ |
--
|
|
|
77
|
+ |
-- Creation: Jul 03, 2017 at 03:39 PM
|
|
|
78
|
+ |
--
|
|
40
|
79
|
|
|
|
41
|
80
|
|
DROP TABLE IF EXISTS `remember_me`;
|
|
42
|
81
|
|
CREATE TABLE IF NOT EXISTS `remember_me` (
|
|
45
|
84
|
|
`expires` datetime NOT NULL
|
|
46
|
85
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used for user authentication (keep session alive for returning user)';
|
|
47
|
86
|
|
|
|
|
87
|
+ |
-- --------------------------------------------------------
|
|
|
88
|
+ |
|
|
|
89
|
+ |
--
|
|
|
90
|
+ |
-- Table structure for table `topic`
|
|
|
91
|
+ |
--
|
|
|
92
|
+ |
-- Creation: Jul 17, 2018 at 05:50 AM
|
|
|
93
|
+ |
--
|
|
|
94
|
+ |
|
|
|
95
|
+ |
DROP TABLE IF EXISTS `topic`;
|
|
|
96
|
+ |
CREATE TABLE IF NOT EXISTS `topic` (
|
|
|
97
|
+ |
`post_id` int(11) NOT NULL,
|
|
|
98
|
+ |
`name` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Topic name'
|
|
|
99
|
+ |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
100
|
+ |
|
|
|
101
|
+ |
-- --------------------------------------------------------
|
|
|
102
|
+ |
|
|
|
103
|
+ |
--
|
|
|
104
|
+ |
-- Table structure for table `user`
|
|
|
105
|
+ |
--
|
|
|
106
|
+ |
-- Creation: Jan 11, 2019 at 08:29 PM
|
|
|
107
|
+ |
--
|
|
|
108
|
+ |
|
|
48
|
109
|
|
DROP TABLE IF EXISTS `user`;
|
|
49
|
110
|
|
CREATE TABLE IF NOT EXISTS `user` (
|
|
50
|
111
|
|
`id` int(11) NOT NULL,
|
|
58
|
119
|
|
`registered` datetime NOT NULL,
|
|
59
|
120
|
|
`salt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
|
|
60
|
121
|
|
`username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
|
|
61
|
|
- |
`about` varchar(10000) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
|
|
62
|
|
- |
) ENGINE=InnoDB AUTO_INCREMENT=264 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
122
|
+ |
`about` varchar(10000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
|
123
|
+ |
`session` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Stores the hash value of the session_id random string that was assigned to a user (and saved to a cookie) when logging in.',
|
|
|
124
|
+ |
`preferred_feed` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'hot'
|
|
|
125
|
+ |
) ENGINE=InnoDB AUTO_INCREMENT=341 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
126
|
+ |
|
|
|
127
|
+ |
-- --------------------------------------------------------
|
|
|
128
|
+ |
|
|
|
129
|
+ |
--
|
|
|
130
|
+ |
-- Table structure for table `vote_comment`
|
|
|
131
|
+ |
--
|
|
|
132
|
+ |
-- Creation: Jul 03, 2017 at 03:39 PM
|
|
|
133
|
+ |
--
|
|
63
|
134
|
|
|
|
64
|
135
|
|
DROP TABLE IF EXISTS `vote_comment`;
|
|
65
|
136
|
|
CREATE TABLE IF NOT EXISTS `vote_comment` (
|
|
69
|
140
|
|
`userId` int(11) NOT NULL
|
|
70
|
141
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
71
|
142
|
|
|
|
|
143
|
+ |
-- --------------------------------------------------------
|
|
|
144
|
+ |
|
|
|
145
|
+ |
--
|
|
|
146
|
+ |
-- Table structure for table `vote_post`
|
|
|
147
|
+ |
--
|
|
|
148
|
+ |
-- Creation: Jul 03, 2017 at 03:39 PM
|
|
|
149
|
+ |
--
|
|
|
150
|
+ |
|
|
72
|
151
|
|
DROP TABLE IF EXISTS `vote_post`;
|
|
73
|
152
|
|
CREATE TABLE IF NOT EXISTS `vote_post` (
|
|
74
|
153
|
|
`vote` smallint(6) NOT NULL,
|
|
77
|
156
|
|
`userId` int(11) NOT NULL
|
|
78
|
157
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
79
|
158
|
|
|
|
|
159
|
+ |
--
|
|
|
160
|
+ |
-- Indexes for dumped tables
|
|
|
161
|
+ |
--
|
|
80
|
162
|
|
|
|
|
163
|
+ |
--
|
|
|
164
|
+ |
-- Indexes for table `comment`
|
|
|
165
|
+ |
--
|
|
81
|
166
|
|
ALTER TABLE `comment`
|
|
82
|
167
|
|
ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `hashId` (`hashId`), ADD KEY `IDX_9474526C10EE4CEE` (`parentId`), ADD KEY `IDX_9474526C251330C5` (`parentUserId`), ADD KEY `IDX_9474526CE094D20D` (`postId`), ADD KEY `IDX_9474526C64B64DCC` (`userId`), ADD KEY `created` (`created`), ADD KEY `dateCreated` (`dateCreated`), ADD KEY `isRead` (`read`), ADD KEY `vote` (`vote`);
|
|
83
|
168
|
|
|
|
|
169
|
+ |
--
|
|
|
170
|
+ |
-- Indexes for table `post`
|
|
|
171
|
+ |
--
|
|
84
|
172
|
|
ALTER TABLE `post`
|
|
85
|
173
|
|
ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `hashId` (`hashId`), ADD KEY `IDX_5A8A6C8D64B64DCC` (`userId`), ADD KEY `created` (`created`), ADD KEY `dateCreated` (`dateCreated`), ADD KEY `vote` (`vote`);
|
|
86
|
174
|
|
|
|
|
175
|
+ |
--
|
|
|
176
|
+ |
-- Indexes for table `remember_me`
|
|
|
177
|
+ |
--
|
|
87
|
178
|
|
ALTER TABLE `remember_me`
|
|
88
|
179
|
|
ADD PRIMARY KEY (`token`), ADD KEY `userId` (`userId`);
|
|
89
|
180
|
|
|
|
|
181
|
+ |
--
|
|
|
182
|
+ |
-- Indexes for table `topic`
|
|
|
183
|
+ |
--
|
|
|
184
|
+ |
ALTER TABLE `topic`
|
|
|
185
|
+ |
ADD PRIMARY KEY (`post_id`,`name`);
|
|
|
186
|
+ |
|
|
|
187
|
+ |
--
|
|
|
188
|
+ |
-- Indexes for table `user`
|
|
|
189
|
+ |
--
|
|
90
|
190
|
|
ALTER TABLE `user`
|
|
91
|
|
- |
ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `hashId` (`hashId`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `email` (`email`), ADD UNIQUE KEY `passwordResetCode` (`passwordResetToken`);
|
|
|
191
|
+ |
ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `hashId` (`hashId`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `email` (`email`), ADD UNIQUE KEY `passwordResetCode` (`passwordResetToken`), ADD UNIQUE KEY `session` (`session`);
|
|
92
|
192
|
|
|
|
|
193
|
+ |
--
|
|
|
194
|
+ |
-- Indexes for table `vote_comment`
|
|
|
195
|
+ |
--
|
|
93
|
196
|
|
ALTER TABLE `vote_comment`
|
|
94
|
197
|
|
ADD PRIMARY KEY (`commentId`,`userId`), ADD KEY `IDX_1FC60DF46690C3F5` (`commentId`), ADD KEY `IDX_1FC60DF464B64DCC` (`userId`);
|
|
95
|
198
|
|
|
|
|
199
|
+ |
--
|
|
|
200
|
+ |
-- Indexes for table `vote_post`
|
|
|
201
|
+ |
--
|
|
96
|
202
|
|
ALTER TABLE `vote_post`
|
|
97
|
203
|
|
ADD PRIMARY KEY (`postId`,`userId`), ADD KEY `IDX_EDE89DBCE094D20D` (`postId`), ADD KEY `IDX_EDE89DBC64B64DCC` (`userId`);
|
|
98
|
204
|
|
|
|
|
205
|
+ |
--
|
|
|
206
|
+ |
-- AUTO_INCREMENT for dumped tables
|
|
|
207
|
+ |
--
|
|
99
|
208
|
|
|
|
|
209
|
+ |
--
|
|
|
210
|
+ |
-- AUTO_INCREMENT for table `comment`
|
|
|
211
|
+ |
--
|
|
100
|
212
|
|
ALTER TABLE `comment`
|
|
101
|
|
- |
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8027;
|
|
|
213
|
+ |
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11235;
|
|
|
214
|
+ |
--
|
|
|
215
|
+ |
-- AUTO_INCREMENT for table `post`
|
|
|
216
|
+ |
--
|
|
102
|
217
|
|
ALTER TABLE `post`
|
|
103
|
|
- |
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6566;
|
|
|
218
|
+ |
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13821;
|
|
|
219
|
+ |
--
|
|
|
220
|
+ |
-- AUTO_INCREMENT for table `user`
|
|
|
221
|
+ |
--
|
|
104
|
222
|
|
ALTER TABLE `user`
|
|
105
|
|
- |
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=264;
|
|
|
223
|
+ |
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=341;
|
|
|
224
|
+ |
--
|
|
|
225
|
+ |
-- Constraints for dumped tables
|
|
|
226
|
+ |
--
|
|
106
|
227
|
|
|
|
|
228
|
+ |
--
|
|
|
229
|
+ |
-- Constraints for table `comment`
|
|
|
230
|
+ |
--
|
|
107
|
231
|
|
ALTER TABLE `comment`
|
|
108
|
232
|
|
ADD CONSTRAINT `FK_9474526C10EE4CEE` FOREIGN KEY (`parentId`) REFERENCES `comment` (`id`),
|
|
109
|
233
|
|
ADD CONSTRAINT `FK_9474526C251330C5` FOREIGN KEY (`parentUserId`) REFERENCES `user` (`id`),
|
|
110
|
234
|
|
ADD CONSTRAINT `FK_9474526C64B64DCC` FOREIGN KEY (`userId`) REFERENCES `user` (`id`),
|
|
111
|
235
|
|
ADD CONSTRAINT `FK_9474526CE094D20D` FOREIGN KEY (`postId`) REFERENCES `post` (`id`);
|
|
112
|
236
|
|
|
|
|
237
|
+ |
--
|
|
|
238
|
+ |
-- Constraints for table `post`
|
|
|
239
|
+ |
--
|
|
113
|
240
|
|
ALTER TABLE `post`
|
|
114
|
241
|
|
ADD CONSTRAINT `FK_5A8A6C8D64B64DCC` FOREIGN KEY (`userId`) REFERENCES `user` (`id`);
|
|
115
|
242
|
|
|
|
|
243
|
+ |
--
|
|
|
244
|
+ |
-- Constraints for table `remember_me`
|
|
|
245
|
+ |
--
|
|
116
|
246
|
|
ALTER TABLE `remember_me`
|
|
117
|
247
|
|
ADD CONSTRAINT `FK_userId` FOREIGN KEY (`userId`) REFERENCES `user` (`id`);
|
|
118
|
248
|
|
|
|
|
249
|
+ |
--
|
|
|
250
|
+ |
-- Constraints for table `topic`
|
|
|
251
|
+ |
--
|
|
|
252
|
+ |
ALTER TABLE `topic`
|
|
|
253
|
+ |
ADD CONSTRAINT `fk_topic_1` FOREIGN KEY (`post_id`) REFERENCES `post` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
|
|
|
254
|
+ |
|
|
|
255
|
+ |
--
|
|
|
256
|
+ |
-- Constraints for table `vote_comment`
|
|
|
257
|
+ |
--
|
|
119
|
258
|
|
ALTER TABLE `vote_comment`
|
|
120
|
259
|
|
ADD CONSTRAINT `FK_1FC60DF464B64DCC` FOREIGN KEY (`userId`) REFERENCES `user` (`id`),
|
|
121
|
260
|
|
ADD CONSTRAINT `FK_1FC60DF46690C3F5` FOREIGN KEY (`commentId`) REFERENCES `comment` (`id`);
|
|
122
|
261
|
|
|
|
|
262
|
+ |
--
|
|
|
263
|
+ |
-- Constraints for table `vote_post`
|
|
|
264
|
+ |
--
|
|
123
|
265
|
|
ALTER TABLE `vote_post`
|
|
124
|
266
|
|
ADD CONSTRAINT `FK_EDE89DBC64B64DCC` FOREIGN KEY (`userId`) REFERENCES `user` (`id`),
|
|
125
|
267
|
|
ADD CONSTRAINT `FK_EDE89DBCE094D20D` FOREIGN KEY (`postId`) REFERENCES `post` (`id`);
|
|
|
268
|
+ |
COMMIT;
|
|
126
|
269
|
|
|
|
127
|
270
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
128
|
271
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|