· 8 years ago · Jul 29, 2018, 08:10 PM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Client : 127.0.0.1
6-- Généré le : Dim 29 Juillet 2018 à 22:01
7-- Version du serveur : 5.6.17
8-- Version de PHP : 5.5.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Base de données : `common-database`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Structure de la table `comment`
27--
28
29CREATE TABLE IF NOT EXISTS `comment` (
30 `id_comment` int(11) NOT NULL AUTO_INCREMENT,
31 `id_user` int(11) NOT NULL,
32 `id_tweet` int(11) NOT NULL,
33 `content_comment` varchar(140) DEFAULT NULL,
34 `date_comment` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
35 `delete_comment` tinyint(5) NOT NULL DEFAULT '0',
36 PRIMARY KEY (`id_comment`),
37 KEY `fk_comment_user1_idx` (`id_user`),
38 KEY `fk_comment_tweet1_idx` (`id_tweet`)
39) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
40
41--
42-- Contenu de la table `comment`
43--
44
45INSERT INTO `comment` (`id_comment`, `id_user`, `id_tweet`, `content_comment`, `date_comment`, `delete_comment`) VALUES
46(1, 19, 42, 'joli boobs salope', '2018-07-27 15:48:24', 0);
47
48-- --------------------------------------------------------
49
50--
51-- Structure de la table `follow`
52--
53
54CREATE TABLE IF NOT EXISTS `follow` (
55 `id_followed` int(11) NOT NULL,
56 `id_follower` int(11) NOT NULL,
57 `status_follow` tinyint(5) NOT NULL DEFAULT '1',
58 KEY `fk_follow_user2_idx` (`id_follower`),
59 KEY `fk_follow_user1_idx` (`id_followed`)
60) ENGINE=MyISAM DEFAULT CHARSET=utf8;
61
62--
63-- Contenu de la table `follow`
64--
65
66INSERT INTO `follow` (`id_followed`, `id_follower`, `status_follow`) VALUES
67(19, 14, 1),
68(19, 17, 1),
69(19, 17, 1),
70(19, 16, 1),
71(19, 14, 1),
72(19, 15, 1),
73(19, 17, 1),
74(19, 17, 1),
75(17, 19, 1),
76(17, 19, 1),
77(17, 19, 1),
78(17, 19, 1),
79(17, 19, 1),
80(16, 19, 1),
81(17, 19, 1),
82(20, 21, 1),
83(16, 22, 1),
84(16, 22, 1),
85(19, 23, 1);
86
87-- --------------------------------------------------------
88
89--
90-- Structure de la table `hashtag`
91--
92
93CREATE TABLE IF NOT EXISTS `hashtag` (
94 `id_hashtag` int(11) NOT NULL AUTO_INCREMENT,
95 `name_hashtag` varchar(255) NOT NULL,
96 PRIMARY KEY (`id_hashtag`)
97) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
98
99-- --------------------------------------------------------
100
101--
102-- Structure de la table `like`
103--
104
105CREATE TABLE IF NOT EXISTS `like` (
106 `id_like` int(11) NOT NULL AUTO_INCREMENT,
107 `id_user` int(11) NOT NULL,
108 `id_tweet` int(11) NOT NULL,
109 `status_like` tinyint(5) NOT NULL DEFAULT '1',
110 PRIMARY KEY (`id_like`),
111 KEY `fk_like_user1_idx` (`id_user`),
112 KEY `fk_like_tweet1_idx` (`id_tweet`)
113) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
114
115-- --------------------------------------------------------
116
117--
118-- Structure de la table `media`
119--
120
121CREATE TABLE IF NOT EXISTS `media` (
122 `id_media` int(11) NOT NULL AUTO_INCREMENT,
123 `id_tweet` int(11) NOT NULL,
124 `name_media` varchar(255) DEFAULT NULL,
125 `file_media` varchar(255) DEFAULT NULL,
126 PRIMARY KEY (`id_media`),
127 KEY `fk_media_tweet_idx` (`id_tweet`)
128) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
129
130-- --------------------------------------------------------
131
132--
133-- Structure de la table `message`
134--
135
136CREATE TABLE IF NOT EXISTS `message` (
137 `id_message` int(11) NOT NULL AUTO_INCREMENT,
138 `id_sender` int(11) NOT NULL,
139 `id_receiver` int(11) NOT NULL,
140 `content_message` text,
141 `date_message` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
142 `delete_message` tinyint(5) NOT NULL DEFAULT '0',
143 PRIMARY KEY (`id_message`),
144 KEY `fk_message_user1_idx` (`id_sender`),
145 KEY `fk_message_user2_idx` (`id_receiver`)
146) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ;
147
148--
149-- Contenu de la table `message`
150--
151
152INSERT INTO `message` (`id_message`, `id_sender`, `id_receiver`, `content_message`, `date_message`, `delete_message`) VALUES
153(19, 21, 16, 'auzgazhha', '2018-07-29 16:08:05', 0),
154(18, 21, 16, 'auzgazhha', '2018-07-29 16:07:47', 0),
155(17, 21, 16, 'auzgazhha', '2018-07-29 16:07:30', 0),
156(16, 21, 16, 'auzgazhha', '2018-07-29 16:07:16', 0),
157(15, 21, 16, 'auzgazhha', '2018-07-29 16:07:02', 0),
158(14, 21, 16, 'auzgazhha', '2018-07-29 16:02:41', 0),
159(13, 21, 16, 'azugazuza', '2018-07-29 16:02:38', 0),
160(12, 21, 16, 'aziuhazhaz', '2018-07-29 16:02:36', 0),
161(20, 21, 16, 'auzgazhha', '2018-07-29 16:09:04', 0),
162(21, 21, 16, 'auzgazhha', '2018-07-29 16:09:23', 0),
163(22, 21, 16, 'azeazeaze', '2018-07-29 16:09:26', 0),
164(23, 21, 16, 'azeazeaze', '2018-07-29 16:09:38', 0),
165(24, 21, 16, 'azeaze', '2018-07-29 16:09:40', 0),
166(25, 21, 16, 'azeaze', '2018-07-29 16:09:50', 0),
167(26, 21, 20, 'AZEAZEHAZE', '2018-07-29 16:11:05', 0),
168(27, 21, 20, 'AZEAZEHAZE', '2018-07-29 16:14:45', 0),
169(28, 21, 20, 'zeazezae', '2018-07-29 16:15:27', 0),
170(29, 21, 20, 'zeazezae', '2018-07-29 16:16:01', 0),
171(30, 21, 20, 'zeazezae', '2018-07-29 16:16:08', 0),
172(31, 20, 21, 'salut ', '2018-07-29 16:19:50', 0),
173(32, 21, 20, 'azeaezzae', '2018-07-29 16:34:05', 0),
174(33, 21, 20, 'azezae', '2018-07-29 16:34:55', 0),
175(34, 21, 20, 'azezae', '2018-07-29 16:34:57', 0),
176(35, 22, 20, 'zaeaze', '2018-07-29 17:17:39', 0),
177(36, 22, 20, 'azeaze', '2018-07-29 17:17:41', 0),
178(37, 22, 20, 'azeaze', '2018-07-29 17:18:51', 0),
179(38, 22, 20, 'azeazeaze', '2018-07-29 18:07:20', 0),
180(39, 23, 20, 'azeaze', '2018-07-29 21:38:20', 0);
181
182-- --------------------------------------------------------
183
184--
185-- Structure de la table `retweet`
186--
187
188CREATE TABLE IF NOT EXISTS `retweet` (
189 `id_retweet` int(11) NOT NULL AUTO_INCREMENT,
190 `id_user` int(11) NOT NULL,
191 `id_tweet` int(11) NOT NULL,
192 `date_retweet` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
193 `delete_retweet` tinyint(5) NOT NULL DEFAULT '1',
194 PRIMARY KEY (`id_retweet`),
195 KEY `fk_retweet_user1_idx` (`id_user`),
196 KEY `fk_retweet_tweet1_idx` (`id_tweet`)
197) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
198
199-- --------------------------------------------------------
200
201--
202-- Structure de la table `tweet`
203--
204
205CREATE TABLE IF NOT EXISTS `tweet` (
206 `id_tweet` int(11) NOT NULL AUTO_INCREMENT,
207 `id_user` int(11) NOT NULL,
208 `content_tweet` varchar(140) DEFAULT NULL,
209 `date_tweet` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
210 `delete_tweet` tinyint(5) NOT NULL DEFAULT '1',
211 PRIMARY KEY (`id_tweet`),
212 KEY `fk_tweet_user1_idx` (`id_user`)
213) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=55 ;
214
215--
216-- Contenu de la table `tweet`
217--
218
219INSERT INTO `tweet` (`id_tweet`, `id_user`, `content_tweet`, `date_tweet`, `delete_tweet`) VALUES
220(1, 0, 'snge', '2018-07-23 11:09:25', 1),
221(2, 0, 'aezazeaz', '2018-07-23 11:16:13', 1),
222(3, 0, 'zaeezae', '2018-07-23 11:16:16', 1),
223(4, 0, 'teddy', '2018-07-23 11:19:27', 1),
224(5, 16, 'teddy2', '2018-07-23 11:19:52', 1),
225(6, 16, 'serge', '2018-07-23 11:22:51', 1),
226(7, 16, 'teddy', '2018-07-23 11:42:40', 1),
227(8, 16, 'zaqeoiajzezojeaz', '2018-07-23 14:19:36', 1),
228(9, 16, 'jazkhjeaze', '2018-07-23 15:07:12', 1),
229(10, 16, 'uzaeaz', '2018-07-23 15:12:08', 1),
230(11, 16, 'azeaze', '2018-07-23 15:13:39', 1),
231(12, 16, 'uiazehaz', '2018-07-23 15:15:22', 1),
232(13, 16, '', '2018-07-23 15:19:55', 1),
233(14, 16, '', '2018-07-23 15:20:11', 1),
234(15, 16, '"ueeuaz', '2018-07-23 17:11:45', 1),
235(16, 16, 'aaeazeaz', '2018-07-23 17:33:20', 1),
236(17, 16, 'salut #salope', '2018-07-24 11:51:17', 1),
237(18, 16, '', '2018-07-24 12:29:52', 1),
238(19, 16, '', '2018-07-24 12:30:32', 1),
239(20, 16, '', '2018-07-24 12:31:02', 1),
240(21, 16, '', '2018-07-24 12:31:40', 1),
241(22, 16, '', '2018-07-24 12:32:13', 1),
242(23, 16, '', '2018-07-24 12:32:14', 1),
243(24, 16, 'Teddy #singe', '2018-07-24 12:34:04', 1),
244(25, 16, 'azeuhaez', '2018-07-24 13:01:20', 1),
245(26, 17, 'teddy', '2018-07-24 14:03:44', 1),
246(27, 17, 'azeeaz', '2018-07-24 14:03:50', 1),
247(28, 16, 'singe', '2018-07-25 14:32:14', 1),
248(29, 16, 'singe', '2018-07-25 14:32:28', 1),
249(30, 16, 'azeaze', '2018-07-25 16:09:45', 1),
250(31, 16, 'zaezae #zuehaz', '2018-07-25 16:09:56', 1),
251(32, 16, 'zaeaez @ursa', '2018-07-25 16:10:09', 1),
252(33, 19, 'azeaze', '2018-07-26 12:34:28', 1),
253(34, 19, 'azeazeaze', '2018-07-26 12:34:31', 1),
254(35, 19, 'azeazeaze', '2018-07-26 12:34:33', 1),
255(36, 19, 'azeazeaze', '2018-07-26 12:34:37', 1),
256(37, 19, 'julien le gay', '2018-07-26 17:15:15', 1),
257(38, 19, 'opkop', '2018-07-26 17:33:36', 1),
258(39, 19, '', '2018-07-26 17:33:39', 1),
259(40, 19, 'i_yh', '2018-07-26 17:36:51', 1),
260(41, 19, 'iuhuih', '2018-07-26 17:37:08', 1),
261(42, 19, '', '2018-07-27 13:41:55', 1),
262(43, 0, '', '2018-07-27 15:52:09', 1),
263(44, 19, 'kqsda', '2018-07-27 19:08:23', 1),
264(45, 20, 'zeaezae', '2018-07-29 14:02:06', 1),
265(46, 21, 'azeaze', '2018-07-29 14:23:04', 1),
266(47, 21, 'azeazea', '2018-07-29 14:23:05', 1),
267(48, 21, 'aeazezae', '2018-07-29 14:23:08', 1),
268(49, 21, 'azeazeaze', '2018-07-29 14:23:10', 1),
269(50, 21, '', '2018-07-29 14:40:53', 1),
270(51, 21, 'zo', '2018-07-29 14:41:02', 1),
271(52, 22, 'zazaaz', '2018-07-29 17:03:51', 1),
272(53, 22, 'azazaeaze', '2018-07-29 17:03:54', 1),
273(54, 23, 'azeaze', '2018-07-29 21:38:08', 1);
274
275-- --------------------------------------------------------
276
277--
278-- Structure de la table `tweet_to_tag`
279--
280
281CREATE TABLE IF NOT EXISTS `tweet_to_tag` (
282 `id_tweet` int(11) NOT NULL,
283 `id_tag` int(11) NOT NULL,
284 `status_ttt` int(11) NOT NULL DEFAULT '1',
285 KEY `id_tweet` (`id_tweet`),
286 KEY `id_tag` (`id_tag`)
287) ENGINE=MyISAM DEFAULT CHARSET=utf8;
288
289-- --------------------------------------------------------
290
291--
292-- Structure de la table `user`
293--
294
295CREATE TABLE IF NOT EXISTS `user` (
296 `id_user` int(11) NOT NULL AUTO_INCREMENT,
297 `username` varchar(50) NOT NULL,
298 `email` varchar(255) NOT NULL,
299 `firstname` varchar(255) NOT NULL,
300 `lastname` varchar(255) NOT NULL,
301 `password` varchar(255) NOT NULL,
302 `avatar` varchar(255) DEFAULT NULL,
303 `theme` varchar(255) NOT NULL DEFAULT '#1da1f2',
304 `register_date` datetime DEFAULT CURRENT_TIMESTAMP,
305 `status` tinyint(5) NOT NULL DEFAULT '1',
306 PRIMARY KEY (`id_user`)
307) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
308
309--
310-- Contenu de la table `user`
311--
312
313INSERT INTO `user` (`id_user`, `username`, `email`, `firstname`, `lastname`, `password`, `avatar`, `theme`, `register_date`, `status`) VALUES
314(20, 'Zo', 'zohair@zohair.com', 'zo', 'davudd', '25eac7b40965720ef31f819422c7d2b8f2c228d0', NULL, '#1da1f2', '2018-07-29 13:58:00', 1),
315(19, 'Ursaaaa', 'ursa@ursa.comm', 'lo', 'ris', 'f9016fe3abe78ce977421a0b2481a7654840b0f3', 'images.jpg', '#1da1f2', '2018-07-26 12:09:32', 1),
316(18, 'Loris', 'loris@loris.com', 'loris', 'turpin', 'loris', 'images.jpg', '#1da1f2', '2018-07-26 12:08:12', 1),
317(17, 'teddy', 'ted@tted.com', 'teddy', 'rhim', 'eab554216f1c62b726c3d31ce63b95ade209da76', 'images.jpg', '#1da1f2', '2018-07-24 14:02:27', 1),
318(16, 'UrsaKing', 'ursa@teddy.com', 'Teddy', 'Rhim', '7e71d8bebb92856900b40bc7be8be1985793116f', 'images.jpg', '#1da1f2', '2018-07-20 17:41:15', 1),
319(15, 'Ursaa', 'ursa@ursa.comm', 'Ursa', 'King', 'd871fd9347615914c8bc4e4dee6a06c5d444743b', '', '#1da1f2', '2018-07-20 16:49:59', 1),
320(14, 'Admin', 'admin@admin.com', 'admin', 'admin', 'ecba0f3a93fea4b2f7282ef22b26f933e8c48211', '', '#1da1f2', '2018-07-19 18:14:41', 1),
321(21, 'Julien', 'julien@julien.com', 'Julien', 'Davroux', '46f8b2ea2848b20d717f4fae45bcfe8ec65d1407', 'images.jpg', '#1da1f2', '2018-07-29 14:12:02', 1),
322(22, 'Remy', 'remy@remy.com', 'teddy', 'teddy', 'f839fcc640e7a4ea88b0e05aceec65faeb9f6031', 'images.jpg', '#1da1f2', '2018-07-29 17:03:22', 1),
323(23, 'lol', 'lol@lol.com', 'lol', 'lol', '08dfa4c2fb2979157a48a8eb0adca4cb1c0224ab', NULL, '#1da1f2', '2018-07-29 21:03:17', 1),
324(24, 'Ursa', 'ursa@test.com', 'ursa', 'test', '58c81f95980f33c6429b7c3c4d4801702227fbce', NULL, '#1da1f2', '2018-07-29 21:52:16', 1);
325
326/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
327/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
328/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;