text: -- phpMyAdmin SQL Dump
  -- version 4.8.2
  -- https://www.phpmyadmin.net/
  --
  -- Vært: 127.0.0.1
  -- Genereringstid: 14. 02 2019 kl. 13:01:46
  -- Serverversion: 10.1.34-MariaDB
  -- PHP-version: 7.2.8
  
  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 */;
  
  --
  -- Database: `crud`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Struktur-dump for tabellen `profiles`
  --
  
  CREATE TABLE `profiles` (
    `id` int(11) NOT NULL,
    `firstname` varchar(25) DEFAULT NULL,
    `lastname` varchar(25) DEFAULT NULL,
    `bio` varchar(25) DEFAULT NULL,
    `users_id` varchar(25) NOT NULL,
    `photos_id` varchar(25) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur-dump for tabellen `roles`
  --
  
  CREATE TABLE `roles` (
    `id` int(11) NOT NULL,
    `name` varchar(25) NOT NULL,
    `level` varchar(25) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Data dump for tabellen `roles`
  --
  
  INSERT INTO `roles` (`id`, `name`, `level`) VALUES
  (1, 'super admin', '100'),
  (2, 'admin', '90'),
  (3, 'moderator', '80'),
  (4, 'author', '70'),
  (5, 'users', '10'),
  (6, 'guest', '1');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur-dump for tabellen `users`
  --
  
  CREATE TABLE `users` (
    `id` int(11) NOT NULL,
    `username` varchar(25) NOT NULL,
    `password` varchar(25) NOT NULL,
    `roles_id` varchar(25) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Data dump for tabellen `users`
  --
  
  INSERT INTO `users` (`id`, `username`, `password`, `roles_id`) VALUES
  (1, 'admin', '1234', '1'),
  (2, 'kat', 'hej', '2'),
  (3, 'bruger1', '123', ''),
  (4, 'bruger1', '123', ''),
  (5, 'christian-torno', 'hej123', '');
  
  --
  -- Begrænsninger for dumpede tabeller
  --
  
  --
  -- Indeks for tabel `profiles`
  --
  ALTER TABLE `profiles`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks for tabel `roles`
  --
  ALTER TABLE `roles`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks for tabel `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Brug ikke AUTO_INCREMENT for slettede tabeller
  --
  
  --
  -- Tilføj AUTO_INCREMENT i tabel `profiles`
  --
  ALTER TABLE `profiles`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- Tilføj AUTO_INCREMENT i tabel `roles`
  --
  ALTER TABLE `roles`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- Tilføj AUTO_INCREMENT i tabel `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  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 */;
  