e71tGkww

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