118 lines
No EOL
3.7 KiB
SQL
118 lines
No EOL
3.7 KiB
SQL
/*
|
|
* Copyright 2008-2019 Anael Mobilia
|
|
*
|
|
* This file is part of image-heberg.fr.
|
|
*
|
|
* image-heberg.fr is free software: you can redistribute it and/or modify
|
|
* it under the terms of the GNU General Public License as published by
|
|
* the Free Software Foundation, either version 3 of the License, or
|
|
* (at your option) any later version.
|
|
*
|
|
* image-heberg.fr is distributed in the hope that it will be useful,
|
|
* but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
* GNU General Public License for more details.
|
|
*
|
|
* You should have received a copy of the GNU General Public License
|
|
* along with image-heberg.fr. If not, see <http://www.gnu.org/licenses/>
|
|
*/
|
|
|
|
--
|
|
-- Structure de la table `images`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `images` (
|
|
`id` int(20) NOT NULL AUTO_INCREMENT,
|
|
`ip_envoi` text NOT NULL,
|
|
`date_envoi` datetime NULL DEFAULT NULL,
|
|
`old_name` text NOT NULL,
|
|
`new_name` text NOT NULL,
|
|
`size` int(11) NOT NULL,
|
|
`height` int(11) NOT NULL,
|
|
`width` int(11) NOT NULL,
|
|
`last_view` date NULL DEFAULT NULL,
|
|
`nb_view_v4` int(11) NOT NULL DEFAULT '0',
|
|
`nb_view_v6` int(11) NOT NULL DEFAULT '0',
|
|
`md5` tinytext NOT NULL,
|
|
`isBloquee` tinyint(1) NOT NULL DEFAULT '0',
|
|
`isSignalee` tinyint(1) NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
|
|
|
|
--
|
|
-- Structure de la table `login`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `login` (
|
|
`pk_login` int(11) NOT NULL AUTO_INCREMENT,
|
|
`ip_login` text NOT NULL,
|
|
`date_login` datetime NOT NULL,
|
|
`pk_membres` int(11) NOT NULL,
|
|
PRIMARY KEY (`pk_login`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
|
|
|
|
--
|
|
-- Structure de la table `membres`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `membres` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`email` text NOT NULL,
|
|
`login` text NOT NULL,
|
|
`password` text NOT NULL,
|
|
`date_inscription` date NOT NULL,
|
|
`ip_inscription` text NOT NULL,
|
|
`lvl` tinyint(4) NOT NULL,
|
|
`isActif` tinyint(1) NOT NULL DEFAULT '1',
|
|
`token` text,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
|
|
|
|
--
|
|
-- Structure de la table `possede`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `possede` (
|
|
`image_id` int(11) NOT NULL,
|
|
`pk_membres` int(11) NOT NULL,
|
|
PRIMARY KEY (`image_id`,`pk_membres`),
|
|
KEY `image_id` (`image_id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
--
|
|
-- Structure de la table `thumbnails`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `thumbnails` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`id_image` int(11) NOT NULL,
|
|
`date_creation` date NULL DEFAULT NULL,
|
|
`new_name` text NOT NULL,
|
|
`size` int(11) NOT NULL,
|
|
`height` int(11) NOT NULL,
|
|
`width` int(11) NOT NULL,
|
|
`last_view` date NULL DEFAULT NULL,
|
|
`nb_view_v4` int(11) NOT NULL DEFAULT '0',
|
|
`nb_view_v6` int(11) NOT NULL DEFAULT '0',
|
|
`md5` tinytext NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `id_image` (`id_image`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
--
|
|
-- Création du compte administrateur
|
|
--
|
|
INSERT INTO `membres` (`id`, `email`, `login`, `password`, `date_inscription`, `ip_inscription`, `lvl`) VALUES
|
|
(1, 'john.doe@example.com', 'admin', '$2y$10$2mn2aXq7R2ROZhi9R3H1iO95vSXo0Vd02u3vAdAZSkZhcBq4Vd1bu', DATE(NOW()), '127.0.0.1', 2);
|
|
|
|
--
|
|
-- Images 404 & bannie
|
|
--
|
|
INSERT INTO `images` (`id`, `ip_envoi`, `date_envoi`, `old_name`, `new_name`, `size`, `height`, `width`, `last_view`, `nb_view_v4`, `nb_view_v6`, `md5`, `isBloquee`, `isSignalee`) VALUES
|
|
(1, '127.0.0.1', '2008-01-01 00:00:00', '_image_404.png', '_image_404.png', 30703, 150, 640, NULL, 0, 0, '6858ce6ddc171a0fd9640831a5e74dfd', 0, 0),
|
|
(2, '127.0.0.1', '2008-01-01 00:00:00', '_image_banned.png', '_image_banned.png', 28713, 150, 640, NULL, 0, 0, '12c357976276091e7cd42e98debb7fb1', 0, 0);
|
|
|
|
--
|
|
-- Assignation à l'administrateur
|
|
--
|
|
INSERT INTO `possede` (`image_id`, `pk_membres`) VALUES ('1', '1'), ('2', '1'); |