Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.7.0
- -- https://www.phpmyadmin.net/
- --
- -- Hôte : localhost
- -- Généré le : Dim 22 oct. 2017 à 22:58
- -- Version du serveur : 10.1.25-MariaDB
- -- Version de PHP : 7.1.7
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET AUTOCOMMIT = 0;
- START TRANSACTION;
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8mb4 */;
- --
- -- Base de données : `joomla`
- --
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_usergroups`
- --
- CREATE TABLE `jv3_usergroups` (
- `id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key',
- `parent_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Adjacency List Reference Id',
- `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
- `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
- `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- --
- -- Déchargement des données de la table `jv3_usergroups`
- --
- INSERT INTO `jv3_usergroups` (`id`, `parent_id`, `lft`, `rgt`, `title`) VALUES
- (1, 0, 1, 18, 'Public'),
- (2, 1, 8, 15, 'Enregistré'),
- (3, 2, 9, 14, 'Auteur'),
- (4, 3, 10, 13, 'Rédacteur'),
- (5, 4, 11, 12, 'Validateur'),
- (6, 1, 4, 7, 'Gestionnaire'),
- (7, 6, 5, 6, 'Administrateur'),
- (8, 1, 16, 17, 'Super Utilisateur'),
- (9, 1, 2, 3, 'Invité');
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_users`
- --
- CREATE TABLE `jv3_users` (
- `id` int(11) NOT NULL,
- `name` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
- `username` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
- `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
- `password` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
- `block` tinyint(4) NOT NULL DEFAULT '0',
- `sendEmail` tinyint(4) DEFAULT '0',
- `registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `activation` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
- `params` text COLLATE utf8mb4_unicode_ci NOT NULL,
- `lastResetTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date of last password reset',
- `resetCount` int(11) NOT NULL DEFAULT '0' COMMENT 'Count of password resets since lastResetTime',
- `otpKey` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Two factor authentication encrypted keys',
- `otep` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'One time emergency passwords',
- `requireReset` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Require user to reset password on next login'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- --
- -- Déchargement des données de la table `jv3_users`
- -- Login : root / Password : root
- INSERT INTO `jv3_users` (`id`, `name`, `username`, `email`, `password`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`, `otpKey`, `otep`, `requireReset`) VALUES
- (339, 'Super Utilisateur', 'root', 'mail@domaine.com', '$2y$10$XmOIXujzMKRIw2Vy0f50C.d17QCyQu0K/l0f0vrbttqwHal0wjSXe', 0, 1, '2017-10-19 13:36:18', '2017-10-22 22:33:52', '0', '', '0000-00-00 00:00:00', 0, '', '', 0);
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_user_keys`
- --
- CREATE TABLE `jv3_user_keys` (
- `id` int(10) UNSIGNED NOT NULL,
- `user_id` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
- `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
- `series` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
- `invalid` tinyint(4) NOT NULL,
- `time` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
- `uastring` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_user_notes`
- --
- CREATE TABLE `jv3_user_notes` (
- `id` int(10) UNSIGNED NOT NULL,
- `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
- `catid` int(10) UNSIGNED NOT NULL DEFAULT '0',
- `subject` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
- `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
- `state` tinyint(3) NOT NULL DEFAULT '0',
- `checked_out` int(10) UNSIGNED NOT NULL DEFAULT '0',
- `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `created_user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
- `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `modified_user_id` int(10) UNSIGNED NOT NULL,
- `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `review_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_user_profiles`
- --
- CREATE TABLE `jv3_user_profiles` (
- `user_id` int(11) NOT NULL,
- `profile_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
- `profile_value` text COLLATE utf8mb4_unicode_ci NOT NULL,
- `ordering` int(11) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Simple user profile storage table';
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_user_usergroup_map`
- --
- CREATE TABLE `jv3_user_usergroup_map` (
- `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__users.id',
- `group_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__usergroups.id'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- --
- -- Déchargement des données de la table `jv3_user_usergroup_map`
- --
- INSERT INTO `jv3_user_usergroup_map` (`user_id`, `group_id`) VALUES
- (339, 8);
- --
- -- Index pour les tables déchargées
- --
- --
- -- Index pour la table `jv3_usergroups`
- --
- ALTER TABLE `jv3_usergroups`
- ADD PRIMARY KEY (`id`),
- ADD UNIQUE KEY `idx_usergroup_parent_title_lookup` (`parent_id`,`title`),
- ADD KEY `idx_usergroup_title_lookup` (`title`),
- ADD KEY `idx_usergroup_adjacency_lookup` (`parent_id`),
- ADD KEY `idx_usergroup_nested_set_lookup` (`lft`,`rgt`) USING BTREE;
- --
- -- Index pour la table `jv3_users`
- --
- ALTER TABLE `jv3_users`
- ADD PRIMARY KEY (`id`),
- ADD KEY `idx_name` (`name`(100)),
- ADD KEY `idx_block` (`block`),
- ADD KEY `username` (`username`),
- ADD KEY `email` (`email`);
- --
- -- Index pour la table `jv3_user_keys`
- --
- ALTER TABLE `jv3_user_keys`
- ADD PRIMARY KEY (`id`),
- ADD UNIQUE KEY `series` (`series`),
- ADD UNIQUE KEY `series_2` (`series`),
- ADD UNIQUE KEY `series_3` (`series`),
- ADD KEY `user_id` (`user_id`);
- --
- -- Index pour la table `jv3_user_notes`
- --
- ALTER TABLE `jv3_user_notes`
- ADD PRIMARY KEY (`id`),
- ADD KEY `idx_user_id` (`user_id`),
- ADD KEY `idx_category_id` (`catid`);
- --
- -- Index pour la table `jv3_user_profiles`
- --
- ALTER TABLE `jv3_user_profiles`
- ADD UNIQUE KEY `idx_user_id_profile_key` (`user_id`,`profile_key`);
- --
- -- Index pour la table `jv3_user_usergroup_map`
- --
- ALTER TABLE `jv3_user_usergroup_map`
- ADD PRIMARY KEY (`user_id`,`group_id`);
- --
- -- AUTO_INCREMENT pour les tables déchargées
- --
- --
- -- AUTO_INCREMENT pour la table `jv3_usergroups`
- --
- ALTER TABLE `jv3_usergroups`
- MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', AUTO_INCREMENT=10;
- --
- -- AUTO_INCREMENT pour la table `jv3_users`
- --
- ALTER TABLE `jv3_users`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=340;
- --
- -- AUTO_INCREMENT pour la table `jv3_user_keys`
- --
- ALTER TABLE `jv3_user_keys`
- MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT pour la table `jv3_user_notes`
- --
- ALTER TABLE `jv3_user_notes`
- MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;COMMIT;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement