-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jul 05, 2016 at 01:35 PM
-- Server version: 10.1.10-MariaDB
-- PHP Version: 5.5.33

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 */;

--
-- Database: `loginsystem`
--

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

--
-- Table structure for table `blog_posts`
--

CREATE TABLE `blog_posts` (
  `postID` int(11) UNSIGNED NOT NULL,
  `postTitle` varchar(255) DEFAULT NULL,
  `postDesc` text,
  `postCont` text,
  `postDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blog_posts`
--

INSERT INTO `blog_posts` (`postID`, `postTitle`, `postDesc`, `postCont`, `postDate`) VALUES
(7, '10 Things Your Competitors Can Teach You About Mobile', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis sollicitudin ligula. Nullam nec diam iaculis, ornare erat in,bero.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis sollicitudin ligula. Nullam nec diam iaculis, ornare erat in, semper est. Sed at enim sed leo consequat tincidunt. Nunc faucibus et nibh quis interdum. Proin purus ex, viverra ac hendrerit vel, condimentum vitae turpis. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Ut non nulla a nulla lacinia molestie. Nulla facilisi. Fusce aliquet ultricies arcu eget egestas. Vivamus ac faucibus mauris. Duis quis maximus sem. Etiam eu urna sollicitudin lectus pellentesque pharetra sit amet et libero.', '2016-06-26 00:00:00'),
(8, 'The Ultimate Cheat Sheet On Life', 'Lorem ipsum dolor sit amet, consectetur adipiscing Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis sollicitudin ligula. Nullam nec diam iaculis, ornare erat in,bero.elit. Cras quis sollicitudin ligula. Nullam nec diam iaculis, ornare erat in,bero.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis sollicitudin ligula. Nullam nec diam iaculis, ornare erat in, semper est. Sed at enim sed leo consequat tincidunt. Nunc faucibus et nibh quis interdum. Proin purus ex, viverra ac hendrerit vel, condimentum vitae turpis. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Ut non nulla a nulla lacinia molestie. Nulla facilisi. Fusce aliquet ultricies arcu eget egestas. Vivamus ac faucibus mauris. Duis quis maximus sem. Etiam eu urna sollicitudin lectus pellentesque pharetra sit amet et libero.', '2016-06-26 00:00:00'),
(9, 'How To Solve The Biggest Problems With Chocolate', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis sollicitudin ligula. Nullam nec diam iaculis, ornare erat in,bero.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis sollicitudin ligula. Nullam nec diam iaculis, ornare erat in, semper est. Sed at enim sed leo consequat tincidunt. Nunc faucibus et nibh quis interdum. Proin purus ex, viverra ac hendrerit vel, condimentum vitae turpis. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Ut non nulla a nulla lacinia molestie. Nulla facilisi. Fusce aliquet ultricies arcu eget egestas. Vivamus ac faucibus mauris. Duis quis maximus sem. Etiam eu urna sollicitudin lectus pellentesque pharetra sit amet et libero.', '2016-06-26 00:00:00'),
(10, 'Lorem Ipsum', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis sollicitudin ligula. Nullam nec diam iaculis, ornare erat in,bero.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis sollicitudin ligula. Nullam nec diam iaculis, ornare erat in,bero.', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras quis sollicitudin ligula. Nullam nec diam iaculis, ornare erat in, semper est. Sed at enim sed leo consequat tincidunt. Nunc faucibus et nibh quis interdum. Proin purus ex, viverra ac hendrerit vel, condimentum vitae turpis. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Ut non nulla a nulla lacinia molestie. Nulla facilisi. Fusce aliquet ultricies arcu eget egestas. Vivamus ac faucibus mauris. Duis quis maximus sem. Etiam eu urna sollicitudin lectus pellentesque pharetra sit amet et libero.', '2016-06-26 00:00:00');

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

--
-- Table structure for table `gegevens`
--

CREATE TABLE `gegevens` (
  `id` int(6) NOT NULL,
  `voornaam` varchar(255) NOT NULL,
  `achternaam` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `telefoon` varchar(255) NOT NULL,
  `bericht` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gegevens`
--

INSERT INTO `gegevens` (`id`, `voornaam`, `achternaam`, `email`, `telefoon`, `bericht`) VALUES
(0, 'Test\r\n', 'systeem\r\n', 'test@gmail.com', '0617654299', 'testin this shit\r\ntesthing this shit															"');

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

--
-- Table structure for table `img_uploads`
--

CREATE TABLE `img_uploads` (
  `id` int(10) NOT NULL,
  `file` varchar(100) NOT NULL,
  `type` varchar(30) NOT NULL,
  `size` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `img_uploads`
--

INSERT INTO `img_uploads` (`id`, `file`, `type`, `size`) VALUES
(10, '81341-gpkks7s.png', 'image/png', 44),
(26, '61491-6tonnkq5h9va.jpg', 'image/jpeg', 2478),
(14, '20526-floor1.png', 'image/png', 337),
(24, '65171-1n9er4m8mxj2.jpg', 'image/jpeg', 260),
(25, '16326-cz2utub.png', 'image/png', 118),
(27, '25342-crystalsword.jpg', 'image/jpeg', 87),
(28, '88565-icemountain_logos.jpg', 'image/jpeg', 1349),
(29, '30886-7li9cam.jpg', 'image/jpeg', 166),
(30, '22695-a78337b1322366173c7585e3552072f3.jpg', 'image/jpeg', 163),
(31, '19375-0buvk1p3hfgh.png', 'image/png', 3022),
(34, '69543-enhanced-buzz-6537-1412781055-8.jpg', 'image/jpeg', 169),
(35, '84559-a70d8ab6-1bbf-4dcc-b11f-524c2f56b14a__picture_default_cover.jpg', 'image/jpeg', 5);

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

--
-- Table structure for table `klanten`
--

CREATE TABLE `klanten` (
  `id` int(6) NOT NULL,
  `naam` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `adres` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `klanten`
--

INSERT INTO `klanten` (`id`, `naam`, `email`, `adres`) VALUES
(1, 'Piet Precies', 'piet@piet.nl', 'Pieterweg 12, Leiden'),
(2, 'Guus Geluk', 'guus@guus.nl', 'Geluksweg 3, Leiden'),
(3, 'Sjaak Chocola', 'sjaak@sjaak.nl', 'de sjaak 4, Leiderdorp'),
(4, 'Arie Boomja', 'arie@boompje.nl', 'Geloofstraat 5, Leiden');

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

--
-- Table structure for table `logged_sessions`
--

CREATE TABLE `logged_sessions` (
  `id` int(11) NOT NULL,
  `user` int(11) DEFAULT NULL,
  `type` enum('failed','success') DEFAULT NULL,
  `status` enum('online','offline') DEFAULT NULL,
  `ip_address` varchar(255) DEFAULT NULL,
  `browser_used` varchar(255) DEFAULT NULL,
  `operating_system` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `postID` int(11) UNSIGNED NOT NULL,
  `postTitle` varchar(255) DEFAULT NULL,
  `postDesc` text,
  `postCont` text,
  `postDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` (`postID`, `postTitle`, `postDesc`, `postCont`, `postDate`) VALUES
(1, 'Bendless Love', '<p>That''s right, baby. I ain''t your loverboy Flexo, the guy you love so much. You even love anyone pretending to be him! Interesting. No, wait, the other thing: tedious. Hey, guess what you''re accessories to. The alien mothership is in orbit here. If we can hit that bullseye, the rest of the dominoes will fall like a house of cards. Checkmate.</p>', '<h2>The Mutants Are Revolting</h2>\r\n<p>We don''t have a brig. And until then, I can never die? We need rest. The spirit is willing, but the flesh is spongy and bruised. And yet you haven''t said what I told you to say! How can any of us trust you?</p>\r\n<ul>\r\n<li>Oh, but you can. But you may have to metaphorically make a deal with the devil. And by "devil", I mean Robot Devil. And by "metaphorically", I mean get your coat.</li>\r\n<li>Bender?! You stole the atom.</li>\r\n<li>I was having the most wonderful dream. Except you were there, and you were there, and you were there!</li>\r\n</ul>\r\n<h3>The Series Has Landed</h3>\r\n<p>Fry! Stay back! He''s too powerful! No. We''re on the top. Fry, you can''t just sit here in the dark listening to classical music.</p>\r\n<h4>Future Stock</h4>\r\n<p>Does anybody else feel jealous and aroused and worried? We''re also Santa Claus! You''re going back for the Countess, aren''t you? Well, let''s just dump it in the sewer and say we delivered it.</p>\r\n<ol>\r\n<li>Spare me your space age technobabble, Attila the Hun!</li>\r\n<li>You guys realize you live in a sewer, right?</li>\r\n<li>I guess if you want children beaten, you have to do it yourself.</li>\r\n<li>Yeah. Give a little credit to our public schools.</li>\r\n</ol>\r\n<h5>The Why of Fry</h5>\r\n<p>Who are you, my warranty?! Shinier than yours, meatbag. Dr. Zoidberg, that doesn''t make sense. But, okay! Yes, except the Dave Matthews Band doesn''t rock.</p>', '2013-05-29 00:00:00'),
(2, 'That Darn Katz!', '<p>Wow! A superpowers drug you can just rub onto your skin? You''d think it would be something you''d have to freebase. Fry, you can''t just sit here in the dark listening to classical music. And yet you haven''t said what I told you to say! How can any of us trust you?</p>', '<h2>Xmas Story</h2>\r\n<p>It must be wonderful. Does anybody else feel jealous and aroused and worried? Is today''s hectic lifestyle making you tense and impatient? Soothe us with sweet lies. That''s right, baby. I ain''t your loverboy Flexo, the guy you love so much. You even love anyone pretending to be him!</p>\r\n<ul>\r\n<li>Goodbye, friends. I never thought I''d die like this. But I always really hoped.</li>\r\n<li>They''re like sex, except I''m having them!</li>\r\n<li>Come, Comrade Bender! We must take to the streets!</li>\r\n</ul>\r\n<h3>Anthology of Interest I</h3>\r\n<p>Hey, whatcha watching? They''re like sex, except I''m having them! Well I''da done better, but it''s plum hard pleading a case while awaiting trial for that there incompetence. Yes, except the Dave Matthews Band doesn''t rock. I suppose I could part with ''one'' and still be feared&hellip;</p>\r\n<h4>Teenage Mutant Leela''s Hurdles</h4>\r\n<p>Oh, but you can. But you may have to metaphorically make a deal with the devil. And by "devil", I mean Robot Devil. And by "metaphorically", I mean get your coat. Please, Don-Bot&hellip; look into your hard drive, and open your mercy file! It''s a T. It goes "tuh". I guess if you want children beaten, you have to do it yourself.</p>\r\n<ol>\r\n<li>Spare me your space age technobabble, Attila the Hun!</li>\r\n<li>Well, thanks to the Internet, I''m now bored with sex. Is there a place on the web that panders to my lust for violence?</li>\r\n</ol>\r\n<h5>The Farnsworth Parabox</h5>\r\n<p>Wow! A superpowers drug you can just rub onto your skin? You''d think it would be something you''d have to freebase. We need rest. The spirit is willing, but the flesh is spongy and bruised. It must be wonderful.</p>', '2013-06-05 23:10:35'),
(3, 'How Hermes Requisitioned His Groove Back', '<p>You''re going back for the Countess, aren''t you? Wow! A superpowers drug you can just rub onto your skin? You''d think it would be something you''d have to freebase. Now Fry, it''s been a few years since medical school, so remind me. Disemboweling in your species: fatal or non-fatal? I don''t want to be rescued. Leela, are you alright? You got wanged on the head.</p>', '<h2>The Luck of the Fryrish</h2>\r\n<p>Professor, make a woman out of me. I am the man with no name, Zapp Brannigan! Good man. Nixon''s pro-war and pro-family. The alien mothership is in orbit here. If we can hit that bullseye, the rest of the dominoes will fall like a house of cards. Checkmate. Fry, you can''t just sit here in the dark listening to classical music.</p>\r\n<ul>\r\n<li>Who are those horrible orange men?</li>\r\n<li>Is today''s hectic lifestyle making you tense and impatient?</li>\r\n</ul>\r\n<h3>Lethal Inspection</h3>\r\n<p>Oh, but you can. But you may have to metaphorically make a deal with the devil. And by "devil", I mean Robot Devil. And by "metaphorically", I mean get your coat. No. We''re on the top. Does anybody else feel jealous and aroused and worried? Well I''da done better, but it''s plum hard pleading a case while awaiting trial for that there incompetence. It must be wonderful.</p>\r\n<h4>Where No Fan Has Gone Before</h4>\r\n<p>Who are those horrible orange men? Bender, we''re trying our best. Please, Don-Bot&hellip; look into your hard drive, and open your mercy file! Wow! A superpowers drug you can just rub onto your skin? You''d think it would be something you''d have to freebase. WINDMILLS DO NOT WORK THAT WAY! GOOD NIGHT! Look, last night was a mistake.</p>\r\n<ol>\r\n<li>I''m sorry, guys. I never meant to hurt you. Just to destroy everything you ever believed in.</li>\r\n<li>Stop it, stop it. It''s fine. I will ''destroy'' you!</li>\r\n<li>You guys realize you live in a sewer, right?</li>\r\n</ol>\r\n<h5>Fear of a Bot Planet</h5>\r\n<p>Why yes! Thanks for noticing. Hey, guess what you''re accessories to. Yes, except the Dave Matthews Band doesn''t rock. Take me to your leader! Daddy Bender, we''re hungry.</p>', '2013-06-05 23:20:24'),
(6, 'The Cyber House Rules', '<p>You guys realize you live in a sewer, right? Uh, is the puppy mechanical in any way? Come, Comrade Bender! We must take to the streets! I daresay that Fry has discovered the smelliest object in the known universe! Good news, everyone! There''s a report on TV with some very bad news!</p>', '<h2>The Luck of the Fryrish</h2>\r\n<p>Professor, make a woman out of me. I am the man with no name, Zapp Brannigan! Good man. Nixon''s pro-war and pro-family. The alien mothership is in orbit here. If we can hit that bullseye, the rest of the dominoes will fall like a house of cards. Checkmate. Fry, you can''t just sit here in the dark listening to classical music.</p>\r\n<ul>\r\n<li>Who are those horrible orange men?</li>\r\n<li>Is today''s hectic lifestyle making you tense and impatient?</li>\r\n</ul>\r\n<h3>Lethal Inspection</h3>\r\n<p>Oh, but you can. But you may have to metaphorically make a deal with the devil. And by "devil", I mean Robot Devil. And by "metaphorically", I mean get your coat. No. We''re on the top. Does anybody else feel jealous and aroused and worried? Well I''da done better, but it''s plum hard pleading a case while awaiting trial for that there incompetence. It must be wonderful.</p>\r\n<h4>Where No Fan Has Gone Before</h4>\r\n<p>Who are those horrible orange men? Bender, we''re trying our best. Please, Don-Bot&hellip; look into your hard drive, and open your mercy file! Wow! A superpowers drug you can just rub onto your skin? You''d think it would be something you''d have to freebase. WINDMILLS DO NOT WORK THAT WAY! GOOD NIGHT! Look, last night was a mistake.</p>\r\n<ol>\r\n<li>I''m sorry, guys. I never meant to hurt you. Just to destroy everything you ever believed in.</li>\r\n<li>Stop it, stop it. It''s fine. I will ''destroy'' you!</li>\r\n<li>You guys realize you live in a sewer, right?</li>\r\n</ol>\r\n<h5>Fear of a Bot Planet</h5>\r\n<p>Why yes! Thanks for noticing. Hey, guess what you''re accessories to. Yes, except the Dave Matthews Band doesn''t rock. Take me to your leader! Daddy Bender, we''re hungry.</p>', '2013-06-06 08:28:35');

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

--
-- Table structure for table `ranks`
--

CREATE TABLE `ranks` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(50) NOT NULL,
  `prefix` text NOT NULL,
  `suffix` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ranks`
--

INSERT INTO `ranks` (`id`, `name`, `prefix`, `suffix`) VALUES
(1, 'User', '', ''),
(2, 'banned', '', ''),
(3, 'moderator', '', ''),
(8, 'Admin', '', '');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) UNSIGNED NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(20) NOT NULL,
  `rank` int(1) UNSIGNED NOT NULL DEFAULT '1',
  `avatar` varchar(20) DEFAULT NULL,
  `account_created` char(12) NOT NULL,
  `last_online` varchar(20) NOT NULL,
  `online` enum('0','1') NOT NULL DEFAULT '0',
  `ip_last` char(20) NOT NULL,
  `ip_reg` char(20) NOT NULL,
  `hide_online` enum('0','1') NOT NULL DEFAULT '0',
  `registered` varchar(10) NOT NULL DEFAULT '0000000000',
  `lastonline` varchar(10) NOT NULL DEFAULT '000000000'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `email`, `rank`, `avatar`, `account_created`, `last_online`, `online`, `ip_last`, `ip_reg`, `hide_online`, `registered`, `lastonline`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin@admin.nl', 1, 'avatar.png', '1', '1', '1', '11.11.1', '11.11.1', '0', '0000000000', '000000000'),
(28, 'jjdk', '19c1820bf866d04169d15a743c461922', 'jdka@hotmail.com', 1, NULL, '', '', '0', '', '', '0', '0000000000', '000000000'),
(29, 'adnja', '3c8177ecd3dccb43749a01fb965deeaf', 'derpder@gamam.nl', 1, NULL, '', '', '0', '', '', '0', '0000000000', '000000000'),
(30, 'adjq', 'b240c05abf7488631a4372a126140834', 'jsdka@hotmail.com', 1, NULL, '', '', '0', '', '', '0', '0000000000', '000000000'),
(31, 'adkjak', '2709cc54769b7e22521e1e0c10729908', 'ajkdja@hotmail.com', 1, NULL, '', '', '0', '', '', '0', '0000000000', '000000000'),
(32, 'testing', 'ae2b1fca515949e5d54fb22b8ed95575', '', 1, NULL, '', '', '0', '', '', '0', '0000000000', '000000000'),
(33, 'ysajkdj', '1d9a0ce1caf012880dc6a361e8fb71b4', 'jkasjd@hotmail.com', 1, NULL, '', '', '0', '', '', '0', '0000000000', '000000000'),
(34, 'adjahd', '088b52002a3c4ed07597ff71a691900a', 'adhsjhd@hotmail.com', 1, NULL, '', '', '0', '', '', '0', '0000000000', '000000000'),
(35, 'adskjdk', '2709cc54769b7e22521e1e0c10729908', 'jkjkjsda@hotmail.com', 1, NULL, '', '', '0', '', '', '0', '0000000000', '000000000'),
(36, 'ajsdkajdk', '96974db5b3d8ffe41ca14562b517f673', 'kjakldj@hotmail.com', 1, NULL, '', '', '0', '', '', '0', '0000000000', '000000000'),
(37, 'adkjskldjlk', 'a2bf84aad6c3f75024931d9459b2a2d5', 'jkjad@hotmadal.com', 1, NULL, '', '', '0', '', '', '0', '0000000000', '000000000'),
(38, 'asdkj', 'd25c69dc36890260b9b63ea198ce456b', 'ajskd@hotmail.com', 1, NULL, '', '', '0', '', '', '0', '0000000000', '000000000');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `blog_posts`
--
ALTER TABLE `blog_posts`
  ADD PRIMARY KEY (`postID`);

--
-- Indexes for table `img_uploads`
--
ALTER TABLE `img_uploads`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `klanten`
--
ALTER TABLE `klanten`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `logged_sessions`
--
ALTER TABLE `logged_sessions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`postID`);

--
-- Indexes for table `ranks`
--
ALTER TABLE `ranks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD UNIQUE KEY `id` (`id`) USING HASH;

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `blog_posts`
--
ALTER TABLE `blog_posts`
  MODIFY `postID` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `img_uploads`
--
ALTER TABLE `img_uploads`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
--
-- AUTO_INCREMENT for table `klanten`
--
ALTER TABLE `klanten`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `logged_sessions`
--
ALTER TABLE `logged_sessions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `posts`
--
ALTER TABLE `posts`
  MODIFY `postID` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `ranks`
--
ALTER TABLE `ranks`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9002;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;
/*!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 */;