Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.6.6deb4
- -- https://www.phpmyadmin.net/
- --
- -- Client : localhost:3306
- -- Généré le : Sam 19 Octobre 2019 à 22:22
- -- Version du serveur : 10.1.37-MariaDB-0+deb9u1
- -- Version de PHP : 7.0.33-0+deb9u3
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- 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 : `gendarmerie`
- --
- -- --------------------------------------------------------
- --
- -- Structure de la table `users`
- --
- CREATE TABLE `users` (
- `ID` int(11) NOT NULL,
- `username` varchar(64) NOT NULL,
- `password` varchar(64) NOT NULL,
- `grade` varchar(64) NOT NULL,
- `orderint` int(255) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- --
- -- Contenu de la table `users`
- --
- INSERT INTO `users` (`ID`, `username`, `password`, `grade`, `orderint`) VALUES
- (30, 'Florian Fartello', 'test', 'Général\r\n', 10),
- (31, 'Jean Michel Mimoul', 'test123', 'Général', 10),
- (32, 'admin', 'test', 'Adjudant', 5),
- (34, 'Thibault Klein', 'test123456', 'Lieutenant', 8),
- (35, 'Alexandre Fournier', '123456', 'Général', 10),
- (36, 'Alexandre Fournier', '123456', 'G.A.V', 1),
- (37, 'Elias MALLET', 'FN060824', 'Capitaine', 9),
- (38, 'Mouloud HAMDAOUI', 'NI090823', 'Lieutenant', 8),
- (39, 'Thibault KLEIN', 'UL270424', 'Lieutenant', 8),
- (40, 'Jean Michel JAIDU', 'KK160125', 'Major', 7),
- (41, 'Mike D. WINTERS', 'NX020525', 'Adjudant-Chef', 6),
- (42, 'Bernard DELARUE', 'CE190423', 'Adjudant', 5),
- (43, 'James Frayen', 'KG240225', 'Adjudant', 5),
- (44, 'Elias SALVETA', 'FT100125', 'Adjudant', 5),
- (45, 'Jack O NEIL', 'KO020525', 'Adjudant', 5),
- (46, 'Nelson MCCRY', 'ON050125', 'Brigadier-Chef', 4),
- (47, 'Paul DESCLAUX', 'QE300325', 'Brigadier-Chef', 4),
- (48, 'Onorox PIRGOV', 'PQ070525', 'Brigadier-Chef', 4),
- (49, 'Alexandre FOURNIER', 'BG070525', 'Brigadier-Chef', 4),
- (50, 'Jack LINDERMAN', 'KM110225', 'Brigadier', 3),
- (51, 'Thibault WILLEMS', 'UX030525', 'Brigadier', 3),
- (52, 'Sébastien WILLEMS', 'TX030525', 'Brigadier', 3),
- (53, 'Wilson LAMBERT', 'XM150425', 'Brigadier', 3),
- (54, 'Dan DAGNOR', 'EE210425', 'Brigadier', 3),
- (55, 'Hank QUOIDBACH', 'IR140525', 'Brigadier', 3),
- (56, 'Florian FARTELLO', 'GG230525 ', 'Brigadier', 3),
- (57, 'Aldo RAINED', 'BS030525 ', 'Adjoint', 2),
- (58, 'Théo DOCQUOY', 'UE010825 ', 'Adjoint', 2),
- (59, 'Zac FERYANDO', 'AG180825 ', 'Adjoint', 2),
- (60, 'François LAPIN', 'GM240923 ', 'G.A.V', 1),
- (61, 'George GILLOT', 'HH160425 ', 'G.A.V', 1),
- (62, 'Greg PEDERSEN', 'HQ180425 ', 'G.A.V', 1),
- (63, 'test', 'test', 'Adjoint', 2),
- (64, 'Jean Michel MIMOUL', 'KN191223 ', 'Général', 10),
- (65, 'test', 'test', 'Général', 10),
- (66, 'Wallace', 'test', 'Général', 10),
- (67, 'Trager', '123456', 'Général', 10),
- (68, 'George Gillot', 'test', 'Général', 10),
- (69, 'Bastien Sapin', 'test', 'Général', 10),
- (70, 'Olson', 'a', 'G.A.V', 1);
- --
- -- Index pour les tables exportées
- --
- --
- -- Index pour la table `users`
- --
- ALTER TABLE `users`
- ADD PRIMARY KEY (`ID`);
- --
- -- AUTO_INCREMENT pour les tables exportées
- --
- --
- -- AUTO_INCREMENT pour la table `users`
- --
- ALTER TABLE `users`
- MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;
- /*!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