-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Creato il: Gen 05, 2019 alle 19:44
-- Versione del server: 10.1.36-MariaDB
-- Versione PHP: 7.2.10

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: `tekweb_00`
--

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

--
-- Struttura della tabella `User`
--

CREATE TABLE `User` (
  `User_id` int(11) NOT NULL,
  `User_nickname` varchar(30) NOT NULL,
  `User_password` varchar(255) NOT NULL,
  `User_name` varchar(20) NOT NULL,
  `User_surname` varchar(30) NOT NULL,
  `User_email` varchar(100) NOT NULL,
  `User_phone` varchar(20) NOT NULL,
  `User_copertina` varchar(255) NOT NULL,
  `User_profilo` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dump dei dati per la tabella `User`
--

INSERT INTO `User` (`User_id`, `User_nickname`, `User_password`, `User_name`, `User_surname`, `User_email`, `User_phone`, `User_copertina`, `User_profilo`) VALUES
(4, 'saram', '$2y$10$xZmelD4om4VGDIpFTRMV8.7hcdhE3s8RpvimjvLTVn/P/KeksCz.W', 'sara', 'morini', 'sara@gmail.com', '1234567', '', ''),
(5, 'fram', '$2y$10$zgxN4VOKbnWxEIRAmHKMtO4BOkQVBEw.wwnmqjbzQiCF7vw7ZS2ui', 'francesco', 'montelli', 'fra@gmail.com', '123456789', '', ''),
(6, 'sofym', '$2y$10$sGP2jLeXx7Xhs3MLhdM7DONARdq5Zbmo8E2.ddz892t3m6Trgw5O2', 'sofia', 'montanari', 'sofy@gmail.com', '12345678', '', ''),
(7, 'gigi', '$2y$10$zWYHzmBCjEyy8gQx0/4Xjeq4MWInmU.hd6R35ZnlbKtTUVFPRcun2', 'gigi', 'proietti', 'gigi@p.it', '12345678', '', ''),
(8, 'sara2', '$2y$10$EhFFTvB7kv3JncyCBrQg7ePCq9OBftIbM1kaJf0oWDHaAlGUEvA9i', 'sara2', 'morini', 'sara2@g.it', '12345678', '', ''),
(9, 'user', '$2y$10$mbaYj4vZzCgmJIHkapZwOe0tJ.nPVJhYCS40Wtc3HImAsnVtFOqnm', 'username', 'user', 'user@user.it', '', '/images/utenti/copertina/user', ''),
(10, 'user2', '$2y$10$Wvs3yn4qI3NSh6MJVMl/..exBjqk.pjJFOhNVvpAu1j5SvkXYhWh.', 'user2', 'siodfa', 'asdfn@gkjab.it', '', '', ''),
(11, 'laura', '$2y$10$mp44r.zszqX79iq4LfHBGOjcKpvPiJcFjvFTtYM081uL6NOlUqZIS', 'laura', 'milandri', 'laura@milandri.it', '4567890\'', '', '');

--
-- Indici per le tabelle scaricate
--

--
-- Indici per le tabelle `User`
--
ALTER TABLE `User`
  ADD PRIMARY KEY (`User_id`),
  ADD UNIQUE KEY `User_nickname` (`User_nickname`),
  ADD UNIQUE KEY `User_email` (`User_email`);

--
-- AUTO_INCREMENT per le tabelle scaricate
--

--
-- AUTO_INCREMENT per la tabella `User`
--
ALTER TABLE `User`
  MODIFY `User_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
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 */;