-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le :  lun. 12 mars 2018 à 15:15
-- Version du serveur :  5.7.19
-- Version de PHP :  7.1.9

START TRANSACTION;



--
-- Base de données :  `interactoqdb`
--

-- --------------------------------------------------------

--
-- Structure de la table `ads`
--

CREATE TABLE IF NOT EXISTS `ads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `ads`
--

INSERT INTO `ads` (`id`, `path`, `alt`) VALUES
(1, 'png', 'nlogo1.png'),
(2, 'png', 'nlogo2.png'),
(3, 'png', 'nlogo3.png'),
(4, 'png', 'nlogo4.png'),
(5, 'png', 'nlogo5.png'),
(6, 'png', 'nlogo6.png');

-- --------------------------------------------------------

--
-- Structure de la table `articles_category`
--

CREATE TABLE IF NOT EXISTS `articles_category` (
  `articles_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  PRIMARY KEY (`articles_id`,`category_id`),
  KEY `IDX_A7D8EFDB1EBAF6CC` (`articles_id`),
  KEY `IDX_A7D8EFDB12469DE2` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `articles_category`
--

INSERT INTO `articles_category` (`articles_id`, `category_id`) VALUES
(1, 4),
(2, 2),
(2, 3),
(2, 4),
(2, 5),
(2, 6),
(2, 7),
(3, 1),
(4, 1),
(5, 2),
(6, 1),
(7, 1),
(7, 2),
(8, 8),
(9, 1),
(10, 12),
(12, 3),
(13, 1),
(14, 1),
(15, 12),
(16, 1),
(17, 6),
(18, 10),
(19, 1),
(20, 2),
(21, 1),
(22, 2),
(23, 1),
(24, 1),
(25, 11),
(26, 2),
(27, 11),
(28, 11),
(29, 1),
(30, 3);

-- --------------------------------------------------------

--
-- Structure de la table `article_coauthor`
--

CREATE TABLE IF NOT EXISTS `article_coauthor` (
  `articles_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`articles_id`,`user_id`),
  KEY `IDX_1F3DC93D1EBAF6CC` (`articles_id`),
  KEY `IDX_1F3DC93DA76ED395` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `article_coauthor`
--

INSERT INTO `article_coauthor` (`articles_id`, `user_id`) VALUES
(1, 47),
(1, 48),
(2, 2),
(2, 3),
(2, 4),
(2, 5),
(3, 2),
(5, 2),
(6, 1),
(6, 4),
(6, 5),
(6, 7),
(7, 1),
(7, 2),
(7, 3),
(7, 4),
(7, 5),
(7, 6),
(10, 25),
(11, 10),
(11, 12),
(11, 16),
(11, 25),
(12, 3),
(13, 17),
(15, 1),
(15, 2),
(15, 3),
(15, 4),
(15, 5),
(16, 1),
(16, 3),
(17, 2),
(17, 17),
(18, 12),
(18, 14),
(18, 17),
(19, 4),
(20, 53),
(21, 29),
(21, 40),
(24, 53),
(25, 40),
(27, 28),
(28, 28);

-- --------------------------------------------------------

--
-- Structure de la table `article_reviewer`
--

CREATE TABLE IF NOT EXISTS `article_reviewer` (
  `articles_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`articles_id`,`user_id`),
  KEY `IDX_B5AFD35B1EBAF6CC` (`articles_id`),
  KEY `IDX_B5AFD35BA76ED395` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `article_reviewer`
--

INSERT INTO `article_reviewer` (`articles_id`, `user_id`) VALUES
(1, 5),
(6, 1),
(7, 1),
(7, 2),
(7, 3),
(7, 4),
(20, 48),
(21, 28),
(21, 56),
(25, 28),
(25, 43),
(26, 28),
(26, 47),
(28, 28),
(29, 28);

-- --------------------------------------------------------

--
-- Structure de la table `article_reviewer_invitation`
--

CREATE TABLE IF NOT EXISTS `article_reviewer_invitation` (
  `articles_id` int(11) NOT NULL,
  `invitation_reviewer_id` int(11) NOT NULL,
  PRIMARY KEY (`articles_id`,`invitation_reviewer_id`),
  KEY `IDX_D8E46A0E1EBAF6CC` (`articles_id`),
  KEY `IDX_D8E46A0E78A04A16` (`invitation_reviewer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `article_reviewer_invitation`
--

INSERT INTO `article_reviewer_invitation` (`articles_id`, `invitation_reviewer_id`) VALUES
(20, 1),
(21, 2),
(25, 3),
(25, 4),
(26, 5),
(26, 6),
(28, 7),
(29, 8);

-- --------------------------------------------------------

--
-- Structure de la table `author_coauthor`
--

CREATE TABLE IF NOT EXISTS `author_coauthor` (
  `user_id` int(11) NOT NULL,
  `coautor_user_id` int(11) NOT NULL,
  PRIMARY KEY (`user_id`,`coautor_user_id`),
  KEY `IDX_A54517E3A76ED395` (`user_id`),
  KEY `IDX_A54517E337139AC3` (`coautor_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `author_coauthor`
--

INSERT INTO `author_coauthor` (`user_id`, `coautor_user_id`) VALUES
(2, 47),
(2, 48),
(2, 57),
(17, 40),
(54, 17),
(55, 28);

-- --------------------------------------------------------

--
-- Structure de la table `banner`
--

CREATE TABLE IF NOT EXISTS `banner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `banner`
--

INSERT INTO `banner` (`id`, `path`, `alt`) VALUES
(1, 'jpeg', 'banner1.jpg'),
(2, 'jpeg', 'banner2.jpg'),
(3, 'jpeg', 'banner3.jpg'),
(4, 'jpeg', 'banner4.jpg'),
(5, 'jpeg', 'banner_box1.jpg'),
(6, 'jpeg', 'banner_box2.jpg'),
(7, 'jpeg', 'banner_box3.jpg'),
(8, 'jpeg', 'banner_big1.jpg'),
(9, 'jpeg', 'banner_big2.jpg'),
(10, 'jpeg', 'banner_big3.jpg');

-- --------------------------------------------------------

--
-- Structure de la table `banners`
--

CREATE TABLE IF NOT EXISTS `banners` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `banner_id` int(11) DEFAULT NULL,
  `position` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_250F2568684EC833` (`banner_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `banners`
--

INSERT INTO `banners` (`id`, `banner_id`, `position`) VALUES
(1, 1, 'right-b'),
(2, 2, 'right-b'),
(3, 3, 'right-b'),
(4, 4, 'right-b'),
(5, 5, 'box'),
(6, 6, 'box'),
(7, 7, 'box'),
(8, 8, 'right'),
(9, 9, 'right'),
(10, 10, 'right');

-- --------------------------------------------------------

--
-- Structure de la table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `message` longtext COLLATE utf8_unicode_ci NOT NULL,
  `articles_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_5F9E962A1EBAF6CC` (`articles_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `comments`
--

INSERT INTO `comments` (`id`, `date`, `message`, `articles_id`) VALUES
(1, '2016-05-24 16:39:26', 'merci de corriger les fautes :)', 1),
(2, '2016-05-25 13:21:34', 'merci de corriger l\'erreur khedha :)', 2),
(3, '2016-09-15 17:58:41', ' testtet test', 7);

-- --------------------------------------------------------

--
-- Structure de la table `contact`
--

CREATE TABLE IF NOT EXISTS `contact` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `contact`
--

INSERT INTO `contact` (`id`, `name`, `email`, `subject`, `content`) VALUES
(1, 'sqdqsd', 'qsdqsd', 'qsdqsd', 'sqdsqd'),
(2, 'qsdqsdqsd', 'sqdsqdqsdqsd@sqdqsd.d', 'sqdqsd', 'qsdsdqsd'),
(3, 'BERRAHAL', 'berrahalmalek@gmail.com', 'prise de contact', 'Dear Mr Malek,\r\nI\'m a new doctor ,I would like to  subscribe  in your platforme \r\n\r\nthx \r\nBest Regards'),
(4, 'dsqsqd', 'qsdqsd@kdjqskdj.com', 'qsdqsd', 'qsdqsdqsd'),
(5, 'Floolfcal', 'tagTugEmpottE@gmail.com', 'How do you know if a guy likes you through texting', 'http://fjdhgksf76w444.com hi everyone');

-- --------------------------------------------------------

--
-- Structure de la table `documents`
--

CREATE TABLE IF NOT EXISTS `documents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `documents`
--

INSERT INTO `documents` (`id`, `path`, `alt`) VALUES
(1, 'png', 'ref.png'),
(2, 'jpeg', 'DSC_0684.JPG'),
(3, 'jpeg', '84734-9270379.jpg'),
(4, 'jpeg', '84734-9270379.jpg'),
(5, '', ''),
(6, 'jpeg', 'Activites01.jpg'),
(7, 'png', 'citroen_mockup.png'),
(8, '', ''),
(9, '', ''),
(10, '', ''),
(11, '', ''),
(12, 'asf', 'Wildlife.wmv'),
(13, '', ''),
(14, '', ''),
(15, 'jpeg', 'ios6 roche.jpg'),
(16, '', ''),
(17, '', ''),
(18, '', ''),
(19, '', ''),
(20, 'docx', 'accès eventek .docx'),
(21, 'jpeg', 'Tulips.jpg'),
(22, 'pdf', ' Location bornes+ Ipads Novembre 2017.pdf');

-- --------------------------------------------------------

--
-- Structure de la table `editor_reviwer`
--

CREATE TABLE IF NOT EXISTS `editor_reviwer` (
  `user_id` int(11) NOT NULL,
  `reviewer_user_id` int(11) NOT NULL,
  PRIMARY KEY (`user_id`,`reviewer_user_id`),
  KEY `IDX_7A7D094DA76ED395` (`user_id`),
  KEY `IDX_7A7D094D66789B8C` (`reviewer_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `editor_reviwer`
--

INSERT INTO `editor_reviwer` (`user_id`, `reviewer_user_id`) VALUES
(2, 28),
(2, 43),
(2, 47),
(2, 48),
(2, 49),
(2, 50),
(2, 51),
(2, 52),
(2, 56);

-- --------------------------------------------------------

--
-- Structure de la table `ext_translations`
--

CREATE TABLE IF NOT EXISTS `ext_translations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `locale` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `object_class` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `field` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `foreign_key` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lookup_unique_idx` (`locale`,`object_class`,`field`,`foreign_key`),
  KEY `translations_lookup_idx` (`locale`,`object_class`,`foreign_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `image`
--

CREATE TABLE IF NOT EXISTS `image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `image`
--

INSERT INTO `image` (`id`, `path`, `alt`) VALUES
(1, 'jpeg', 'Diapositive02.jpg'),
(2, 'jpeg', 'signature-Travel-&-Events.jpg'),
(3, 'jpeg', '84734-9270379.jpg'),
(4, 'jpeg', '84734-9270379.jpg'),
(5, '', ''),
(6, 'jpeg', 'Koala.jpg'),
(7, 'jpeg', 'atnea.jpg'),
(8, '', ''),
(9, '', ''),
(10, '', ''),
(11, '', ''),
(12, 'jpeg', 'Penguins.jpg'),
(13, 'jpeg', 'Lighthouse.jpg'),
(14, 'jpeg', 'Koala.jpg'),
(15, '', ''),
(16, '', ''),
(17, '', ''),
(18, 'jpeg', 'a7.jpg'),
(19, '', ''),
(20, 'jpeg', 'Medical-tourim-featured-picture.jpg'),
(21, 'jpeg', 'Koala.jpg'),
(22, 'jpeg', 'Lighthouse.jpg');

-- --------------------------------------------------------

--
-- Structure de la table `media`
--

CREATE TABLE IF NOT EXISTS `media` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dateCreate` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_6A2CA10CA76ED395` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `media`
--

INSERT INTO `media` (`id`, `path`, `alt`, `user_id`, `type`, `dateCreate`) VALUES
(16, 'jpeg', '20160405_darfur.jpg', NULL, '', '0000-00-00 00:00:00'),
(17, 'jpeg', '20160405_darfur.jpg', NULL, '', '0000-00-00 00:00:00'),
(18, 'jpeg', '20160405_darfur.jpg', NULL, '', '0000-00-00 00:00:00'),
(20, 'jpeg', '20160405_darfur.jpg', NULL, '', '0000-00-00 00:00:00'),
(23, 'jpeg', '20160405_darfur.jpg', NULL, '', '0000-00-00 00:00:00'),
(26, 'jpeg', 'Sans titre.jpg', NULL, '', '0000-00-00 00:00:00'),
(27, 'jpeg', 'Sans titre.jpg', NULL, '', '0000-00-00 00:00:00'),
(33, 'jpeg', '20160405_darfur.jpg', NULL, '', '0000-00-00 00:00:00'),
(34, 'jpeg', '20160405_darfur.jpg', NULL, '', '0000-00-00 00:00:00'),
(36, 'jpeg', '20160405_darfur.jpg', NULL, '', '0000-00-00 00:00:00'),
(37, 'jpeg', 'Chrysanthemum.jpg', NULL, '', '0000-00-00 00:00:00'),
(38, 'jpeg', 'Chrysanthemum.jpg', NULL, '', '0000-00-00 00:00:00'),
(39, 'jpeg', 'Desert.jpg', NULL, '', '0000-00-00 00:00:00'),
(40, 'jpeg', 'Desert.jpg', NULL, '', '0000-00-00 00:00:00'),
(41, 'jpeg', 'Desert.jpg', NULL, '', '0000-00-00 00:00:00'),
(42, 'jpeg', 'cool-wallpapers-hd-8087-8418-hd-wallpapers.jpg', NULL, '', '0000-00-00 00:00:00'),
(43, 'jpeg', 'cool-wallpapers-hd-8087-8418-hd-wallpapers.jpg', NULL, '', '0000-00-00 00:00:00'),
(44, 'jpeg', 'cool-wallpapers-hd-8087-8418-hd-wallpapers.jpg', NULL, '', '0000-00-00 00:00:00'),
(45, 'jpeg', '13094295_989055047838948_3864879686319329518_n.jpg', NULL, '', '0000-00-00 00:00:00'),
(46, 'jpeg', '13094295_989055047838948_3864879686319329518_n.jpg', NULL, '', '0000-00-00 00:00:00'),
(47, 'jpeg', '34.jpeg', NULL, '', '0000-00-00 00:00:00'),
(48, 'jpeg', '34.jpeg', NULL, '', '0000-00-00 00:00:00'),
(49, 'jpeg', 'Tribune-Recrutement-commerciaux-arretons-chercher--F.jpg', NULL, '', '0000-00-00 00:00:00'),
(50, 'png', 'Logo_millesima_travel&events.png', NULL, '', '0000-00-00 00:00:00'),
(51, 'jpeg', 'Sidi Jmour 2.jpg', NULL, '', '0000-00-00 00:00:00'),
(52, 'png', 'EHJ 2015.png', NULL, '', '0000-00-00 00:00:00'),
(53, 'png', 'EHJ 2015.png', NULL, '', '0000-00-00 00:00:00'),
(54, 'png', 'EHJ 2015.png', NULL, '', '0000-00-00 00:00:00'),
(55, 'jpeg', 'Fond02_ipad.jpg', NULL, '', '0000-00-00 00:00:00'),
(56, 'jpeg', 'Koala.jpg', NULL, '', '0000-00-00 00:00:00'),
(57, 'jpeg', 'Penguins.jpg', NULL, '', '0000-00-00 00:00:00'),
(58, 'png', 'io7.png', NULL, '', '0000-00-00 00:00:00'),
(59, 'jpeg', 'Chrysanthemum.jpg', NULL, '', '0000-00-00 00:00:00'),
(60, 'jpeg', 'Desert.jpg', NULL, '', '0000-00-00 00:00:00'),
(61, 'jpeg', 'Penguins.jpg', NULL, '', '0000-00-00 00:00:00'),
(62, 'jpeg', 'Jellyfish.jpg', NULL, '', '0000-00-00 00:00:00'),
(63, 'jpeg', 'Jellyfish.jpg', NULL, '', '0000-00-00 00:00:00'),
(64, 'jpeg', 'Lighthouse.jpg', NULL, '', '0000-00-00 00:00:00'),
(65, 'jpeg', 'Koala.jpg', NULL, '', '0000-00-00 00:00:00'),
(66, 'png', 'io7.0.png', NULL, '', '0000-00-00 00:00:00'),
(67, 'jpeg', 'Lighthouse.jpg', NULL, '', '0000-00-00 00:00:00'),
(68, 'jpeg', 'Tulips.jpg', NULL, '', '0000-00-00 00:00:00'),
(69, 'jpeg', 'a1.jpg', NULL, '', '0000-00-00 00:00:00'),
(70, 'jpeg', 'a1.jpg', NULL, '', '0000-00-00 00:00:00'),
(71, 'jpeg', 'ios6 roche.jpg', NULL, '', '0000-00-00 00:00:00'),
(72, 'jpeg', 'a2.jpg', NULL, '', '0000-00-00 00:00:00'),
(73, 'jpeg', 'a1.jpg', NULL, '', '0000-00-00 00:00:00'),
(74, 'jpeg', 'a4.jpg', NULL, '', '0000-00-00 00:00:00'),
(75, 'jpeg', 'a4.jpg', NULL, '', '0000-00-00 00:00:00'),
(76, 'jpeg', 'jepg1', 17, 'IMAGE', '0000-00-00 00:00:00'),
(77, 'jpeg', 'tof2', 17, 'IMAGE', '0000-00-00 00:00:00'),
(78, 'mp4', 'test', 2, 'VIDEO', '0000-00-00 00:00:00'),
(79, 'avi', 'test12', 2, 'VIDEO', '0000-00-00 00:00:00'),
(80, 'jpeg', 'tof1', 17, 'IMAGE', '2017-11-29 09:40:33'),
(81, 'jpeg', 'tof 3', 17, 'IMAGE', '2017-11-29 09:40:49'),
(82, 'jpeg', 'tof5', 17, 'IMAGE', '2017-11-29 09:41:00'),
(83, 'jpeg', 'tof4', 17, 'IMAGE', '2017-11-29 09:41:13'),
(84, 'jpeg', 'tof7', 17, 'IMAGE', '2017-11-29 09:41:31'),
(85, 'jpeg', 'tof9', 17, 'IMAGE', '2017-11-29 09:43:52'),
(86, 'jpeg', 'jpeg 2', 17, 'IMAGE', '2017-11-29 09:44:28'),
(87, 'jpeg', 'jepg5', 17, 'IMAGE', '2017-11-29 09:44:44'),
(88, 'jpeg', 'jepg3', 17, 'IMAGE', '2017-11-29 09:44:59'),
(89, 'jpeg', 'jepg2', 17, 'IMAGE', '2017-11-29 09:45:32'),
(90, 'jpeg', 'jepg4', 17, 'IMAGE', '2017-11-29 09:45:59'),
(91, 'jpeg', 'jepg6', 17, 'IMAGE', '2017-11-29 09:46:45'),
(93, 'jpeg', 'Hydrangeas', 2, 'IMAGE', '2017-12-04 16:33:40'),
(94, 'jpeg', 'Chrysanthème', 2, 'IMAGE', '2017-12-06 10:39:00'),
(95, 'jpeg', 'Désert', 2, 'IMAGE', '2017-12-06 10:39:18'),
(96, 'jpeg', 'Méduses', 2, 'IMAGE', '2017-12-06 10:39:35'),
(97, 'jpeg', 'Koala', 2, 'IMAGE', '2017-12-06 10:39:49'),
(98, 'jpeg', 'Phare', 2, 'IMAGE', '2017-12-06 10:40:06'),
(99, 'jpeg', 'Manchots', 2, 'IMAGE', '2017-12-06 10:40:24'),
(100, 'jpeg', 'Tulipes', 2, 'IMAGE', '2017-12-06 10:40:42'),
(101, 'jpeg', 'Desert', 54, 'IMAGE', '2017-12-06 10:55:24'),
(102, 'jpeg', 'Chrysanthemum', 55, 'IMAGE', '2017-12-11 10:08:19'),
(103, 'jpeg', 'Desert', 55, 'IMAGE', '2017-12-11 10:08:30'),
(104, 'jpeg', 'Tulips', 55, 'IMAGE', '2017-12-11 10:08:40'),
(105, 'jpeg', 'Hydrangeas', 55, 'IMAGE', '2017-12-11 10:08:53'),
(106, 'jpeg', 'Jellyfish', 55, 'IMAGE', '2017-12-11 10:09:01'),
(107, 'jpeg', 'Koala', 55, 'IMAGE', '2017-12-11 10:09:10'),
(108, 'jpeg', 'Penguins', 55, 'IMAGE', '2017-12-11 10:09:18'),
(109, 'jpeg', 'Lighthouse', 55, 'IMAGE', '2017-12-11 10:09:30'),
(110, 'jpeg', 'Penguins', 55, 'IMAGE', '2017-12-11 10:09:48'),
(111, 'mp4', 'video1', 55, 'VIDEO', '2017-12-11 10:10:42');

-- --------------------------------------------------------

--
-- Structure de la table `pictures`
--

CREATE TABLE IF NOT EXISTS `pictures` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `pictures`
--

INSERT INTO `pictures` (`id`, `path`, `alt`) VALUES
(1, 'jpeg', '2c4b30d48aa9797bde07fb99a0a670a8b0a33ffd.jpg'),
(2, 'png', 'pouet.png'),
(3, 'jpeg', '6ba51c907e59f9c68d1a7bf1fe4c2a5ec43fd275.jpg'),
(4, 'jpeg', '60ff8d5f734b8acb8f0fa53af38fc1f7b2606edc.jpg'),
(5, 'jpeg', 'ligue-champions-psg-city-football.jpg'),
(6, 'jpeg', 'police-blegie.jpg'),
(7, 'png', 'bankimoon-successeuse.png'),
(8, 'jpeg', 'medical1.jpg'),
(9, 'jpeg', 'medical2.jpg'),
(10, 'jpeg', 'medical3.jpg'),
(11, 'jpeg', 'medical4.jpg');

-- --------------------------------------------------------

--
-- Structure de la table `profile`
--

CREATE TABLE IF NOT EXISTS `profile` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `profile`
--

INSERT INTO `profile` (`id`, `path`, `alt`) VALUES
(1, 'jpeg', 'profile.jpg'),
(2, 'jpeg', '13094295_989055047838948_3864879686319329518_n.jpg'),
(3, NULL, NULL),
(4, NULL, NULL),
(5, NULL, NULL),
(6, NULL, NULL),
(7, 'jpeg', 'Koala.jpg');

-- --------------------------------------------------------

--
-- Structure de la table `rating`
--

CREATE TABLE IF NOT EXISTS `rating` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `articles_id` int(11) DEFAULT NULL,
  `score` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `comment` longtext COLLATE utf8_unicode_ci NOT NULL,
  `reveiwer_id` int(11) DEFAULT NULL,
  `comment_author` longtext COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dateAt` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D88926221EBAF6CC` (`articles_id`),
  KEY `IDX_D8892622E058392D` (`reveiwer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `rating`
--

INSERT INTO `rating` (`id`, `articles_id`, `score`, `comment`, `reveiwer_id`, `comment_author`, `status`, `dateAt`) VALUES
(1, 1, '1', '<p>ya3tik sa7a wasel :)</p>', 5, '', NULL, '0000-00-00 00:00:00'),
(2, 7, '5', '<p>test 12222</p>', 1, '', NULL, '0000-00-00 00:00:00'),
(3, 21, '1', '<p>refused plagia</p>', 28, '<p>plagia</p>', 'DECLINE', '2017-10-25 11:51:22'),
(4, 25, '3', '<p>modif</p>', 28, '<p>modif</p>', 'WITH_MODIF', '2017-11-29 10:00:44'),
(5, 26, '3', '<p>commentaire editeur</p>', 28, '<p>commentaire auteur<br></p>', 'ACCEPTED', '2017-12-06 11:07:11'),
(6, 28, '5', '<p>Good article</p>', 28, '<p>congratulations</p>', 'ACCEPTED', '2017-12-11 12:19:27'),
(7, 29, '3', '<p>moyyen</p>', 28, 'b', 'WITH_MODIF', '2017-12-11 12:31:47'),
(8, 21, '5', '<p><span style=\"color: rgb(34, 56, 132); font-family: Lato, sans-serif; font-size: 15px;\">Comment To Editor test</span><br></p>', 56, '<p><span style=\"color: rgb(34, 56, 132); font-family: Lato, sans-serif; font-size: 15px;\">Comment To Author Test</span><br></p>', 'ACCEPTED', '2017-12-12 15:59:22');

-- --------------------------------------------------------

--
-- Structure de la table `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `facebook` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `youtube` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `twitter` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `linkedin` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `settings`
--

INSERT INTO `settings` (`id`, `title`, `phone`, `email`, `address`, `facebook`, `youtube`, `twitter`, `linkedin`) VALUES
(1, 'pafcic online', '+216 55 555 555', 'contact@pafciconline', '22 Rue Moussa Ibn Noussaire Menzeh5,Ariana', 'https://www.facebook.com/berrahal.malek', 'https://www.facebook.com/berrahal.malek', 'https://www.facebook.com/berrahal.malek', 'https://www.facebook.com/berrahal.malek');

--
-- Contraintes pour la table `articles_category`
--
ALTER TABLE `articles_category`
  ADD CONSTRAINT `FK_A7D8EFDB12469DE2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_A7D8EFDB1EBAF6CC` FOREIGN KEY (`articles_id`) REFERENCES `articles` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `article_coauthor`
--
ALTER TABLE `article_coauthor`
  ADD CONSTRAINT `FK_F174D0161EBAF6CC` FOREIGN KEY (`articles_id`) REFERENCES `articles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_F174D016A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `article_reviewer`
--
ALTER TABLE `article_reviewer`
  ADD CONSTRAINT `FK_5BE6CA701EBAF6CC` FOREIGN KEY (`articles_id`) REFERENCES `articles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_5BE6CA70A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `article_reviewer_invitation`
--
ALTER TABLE `article_reviewer_invitation`
  ADD CONSTRAINT `FK_DD449601EBAF6CC` FOREIGN KEY (`articles_id`) REFERENCES `articles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_DD4496078A04A16` FOREIGN KEY (`invitation_reviewer_id`) REFERENCES `invitation_reviewer` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `author_coauthor`
--
ALTER TABLE `author_coauthor`
  ADD CONSTRAINT `FK_A54517E337139AC3` FOREIGN KEY (`coautor_user_id`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_A54517E3A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `banners`
--
ALTER TABLE `banners`
  ADD CONSTRAINT `FK_250F2568684EC833` FOREIGN KEY (`banner_id`) REFERENCES `banner` (`id`);

--
-- Contraintes pour la table `comments`
--
ALTER TABLE `comments`
  ADD CONSTRAINT `FK_5F9E962A1EBAF6CC` FOREIGN KEY (`articles_id`) REFERENCES `articles` (`id`);

--
-- Contraintes pour la table `editor_reviwer`
--
ALTER TABLE `editor_reviwer`
  ADD CONSTRAINT `FK_7A7D094D66789B8C` FOREIGN KEY (`reviewer_user_id`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_7A7D094DA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `media`
--
ALTER TABLE `media`
  ADD CONSTRAINT `FK_6A2CA10CA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `rating`
--
ALTER TABLE `rating`
  ADD CONSTRAINT `FK_D88926221EBAF6CC` FOREIGN KEY (`articles_id`) REFERENCES `articles` (`id`),
  ADD CONSTRAINT `FK_D8892622E058392D` FOREIGN KEY (`reveiwer_id`) REFERENCES `user` (`id`);
COMMIT;

