-- phpMyAdmin SQL Dump
-- version 4.3.11
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Set 03, 2015 alle 12:03
-- Versione del server: 5.6.24
-- PHP Version: 5.6.8

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

--
-- Database: `smartcharging`
--

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

--
-- Struttura della tabella `commenti`
--

CREATE TABLE IF NOT EXISTS `commenti` (
  `id` int(11) NOT NULL,
  `id_locale` int(11) NOT NULL,
  `id_user` int(11) DEFAULT NULL,
  `voto` int(11) NOT NULL,
  `descrizione` varchar(255) CHARACTER SET latin1 NOT NULL,
  `data` datetime NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;

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

INSERT INTO `commenti` (`id`, `id_locale`, `id_user`, `voto`, `descrizione`, `data`) VALUES
(27, 98, 225, 4, 'Non ci andate!!', '2015-08-30 15:36:28'),
(28, 96, 260, 5, 'hfdkkgfhhhhhhh', '2015-08-31 17:43:32'),
(29, 101, NULL, 0, 'Fgghh', '2015-09-01 10:49:12'),
(30, 101, NULL, 0, 'Jzjajaja', '2015-09-01 10:49:43'),
(31, 111, 274, 1, 'hhfddlihghkkhvxdsfukkg\n', '2015-09-01 12:55:25'),
(32, 111, 274, 1, 'hhfddlihghkkhvxdsfukkg\n', '2015-09-01 12:55:26'),
(33, 111, 274, 2, 'kgktkgghhdfjnfndjdkfjf', '2015-09-01 12:56:41'),
(34, 111, 274, 2, 'miglioriamola ', '2015-09-01 12:57:48'),
(35, 111, 274, 2, 'miglioriamola ', '2015-09-01 12:57:53'),
(36, 111, 274, 2, 'gggghh', '2015-09-01 13:04:37'),
(37, 111, 274, 2, 'gggghh', '2015-09-01 13:04:42'),
(38, 111, 274, 2, 'gggghh', '2015-09-01 13:04:50'),
(39, 111, 274, 5, 'gggghh', '2015-09-01 13:04:55'),
(40, 111, 274, 5, 'gggghh', '2015-09-01 13:05:07'),
(41, 111, 274, 5, 'gggghh', '2015-09-01 13:05:10'),
(42, 111, 274, 5, 'gggghh', '2015-09-01 13:05:11'),
(43, 99, 274, 3, 'jfpxhpzhzd', '2015-09-01 13:10:16'),
(44, 101, 275, 0, 'Ccc', '2015-09-01 13:25:20'),
(45, 101, 275, 0, 'Ccc', '2015-09-01 13:25:21'),
(46, 101, 275, 0, 'Ccc', '2015-09-01 13:25:23'),
(47, 101, 275, 0, '1', '2015-09-01 13:27:45'),
(48, 101, 275, 0, '2', '2015-09-01 13:27:53'),
(49, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
(50, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
(51, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
(52, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
(53, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
(54, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
(55, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
(56, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
(57, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
(58, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
(59, 101, 275, 0, 'Ciao', '2015-09-01 13:32:17'),
(60, 101, 275, 0, 'Fghj', '2015-09-01 14:53:01'),
(61, 101, 275, 0, 'Fghj', '2015-09-01 14:53:08'),
(62, 111, 301, 0, 'ggh', '2015-09-02 12:38:12'),
(63, 111, 301, 0, 'ggh', '2015-09-02 12:38:12'),
(64, 101, 305, 0, 'hshaja', '2015-09-02 12:45:18'),
(65, 101, 225, 2, 'Ciaoooo', '2015-09-02 13:20:02'),
(66, 101, 275, 5, 'Fty', '2015-09-02 17:07:02'),
(67, 99, 275, 0, 'àààààà', '2015-09-02 17:07:36'),
(68, 133, 333, 0, 'Magnifico, ho caricato il mio telefono al 100%!', '2015-09-03 11:59:52'),
(69, 133, 333, 5, 'Magnifico ho caricato il mio Smartphone al 100%!', '2015-09-03 12:01:15');

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

--
-- Struttura della tabella `immagini_commenti`
--

CREATE TABLE IF NOT EXISTS `immagini_commenti` (
  `id_commento` int(11) NOT NULL,
  `img` varchar(255) CHARACTER SET latin1 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `immagini_commenti` (`id_commento`, `img`) VALUES
(31, '55e5840b4aa00.jpeg'),
(31, '55e584177e1f9.jpeg'),
(32, '55e5840b4aa00.jpeg'),
(32, '55e584177e1f9.jpeg'),
(33, '55e58461e05a1.jpeg'),
(34, '55e58499eb14a.jpeg'),
(35, '55e58499eb14a.jpeg'),
(41, '55e58663057bd.jpeg'),
(42, '55e58663057bd.jpeg');

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

--
-- Struttura della tabella `immagini_locali`
--

CREATE TABLE IF NOT EXISTS `immagini_locali` (
  `id_locale` int(11) NOT NULL,
  `img` varchar(255) CHARACTER SET latin1 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `immagini_locali` (`id_locale`, `img`) VALUES
(96, '55e080b881b32.jpeg'),
(98, '55e081d1e9e37.jpeg'),
(99, '55e082fae3368.jpeg'),
(99, '55e0830c835e6.jpeg'),
(100, '55e083b4a4fc5.jpeg'),
(111, '55e56ce9c306c.png');

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

--
-- Struttura della tabella `locale`
--

CREATE TABLE IF NOT EXISTS `locale` (
  `id` int(11) NOT NULL,
  `id_utente_owner` int(11) NOT NULL,
  `nomelocale` varchar(255) CHARACTER SET latin1 NOT NULL,
  `descrizione` varchar(255) CHARACTER SET latin1 NOT NULL,
  `tipologia` int(11) NOT NULL,
  `lat` double DEFAULT NULL,
  `lon` double DEFAULT NULL,
  `indirizzo` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `email` varchar(255) CHARACTER SET latin1 NOT NULL,
  `telefono` varchar(255) CHARACTER SET latin1 NOT NULL,
  `sito` varchar(255) CHARACTER SET latin1 NOT NULL,
  `n_punti_ricarica` int(11) NOT NULL DEFAULT '0',
  `hidden` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=utf8;

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

INSERT INTO `locale` (`id`, `id_utente_owner`, `nomelocale`, `descrizione`, `tipologia`, `lat`, `lon`, `indirizzo`, `email`, `telefono`, `sito`, `n_punti_ricarica`, `hidden`) VALUES
(96, 221, 'Panello tutto shop', 'Locale di intrattenimento ', 3, 41.9026456, 12.4847137, 'via del tritone roma', 'hsjsjs@jdjdj.it', '46466494', 'www.tantaroba.it', 5, 0),
(97, 221, 'Ricambi tappi penne', 'Avete perso il tappo della penna, no problem! ', 4, 0, 0, '', 'Tappibelli@gmail.strizz', '3336699', 'www.thepenisonthetable.com', 0, 0),
(98, 222, 'Verzeghe lappe e petecchie', 'Grandi verdure per grandi uomini*', 4, 41.8727778, 12.4838931, 'roma ostiense ', 'tuttagina@gmail.zucca', '99908', 'www.allverduris.com', 9, 0),
(99, 223, 'Aria fritta tutto 1 euro', 'Errore 404 missing item da vendere', 10, 41.8873284, 12.576615, 'via del Pergolato ', 'sweetmagalli@qwerty.non', '97777777777', 'niente.it', 0, 0),
(100, 224, 'Null pointer, no scherzo', 'Data:) ', 6, 41.8224472, 12.5183907, 'millevoi ', 'bsnsns@djjs.it', '646464', 'null.null.it', 990, 0),
(101, 227, 'hshsjs', 'Nsnsnsja', 1, 41.6445071, 12.9129985, 'cori', 'bsnsnsj@.', '6464667', 'hsnsjsnsns', 4444, 0),
(111, 272, 'Nextrek Coffee Bar', 'Bla bla bla bla bla bla bla bla bla bla bla ', 3, 41.8846233, 12.5747576, 'Via del pergolato, 18', 'luca.zicari@nextrek.net', '3292014456', 'www.nextrekbar.it', 5, 0),
(119, 305, 'hahahana', 'hahaja', 5, 0, 0, '', 'babananaja@jsjs.it', '54646494', 'hahanaba', 46, 0),
(120, 306, 'sgagahah', 'hshahaha\ngshah\nsuha', 4, 0, 0, '', 'xjjsks@jdkdk.ir', '14545454', 'hshahaha', 6464, 0),
(121, 308, 'prova locale', 'aaaaa', 4, 11.111111, 11.222222, 'aaaaaa', 'admin@ciampibookstore.it', '111111111', 'via vai', 1, 0),
(125, 324, 'shsjanjaja', 'Ajjajajahsheusisks\n', 5, 11.825138, 42.590275, 'dj', 'sbshhshsh@ndndns.it', '44444', 'kajajakakakak', 44, 0),
(133, 333, 'Nextrek Caffe', 'Un bel locale dove godersi un buon caffe mente Ricarichi il tuo smartphone.', 10, 41.9034651, 12.4794072, 'Via del corso, Roma', 'nextrek@nextrek.net', '55556512', 'www.nextrek.net', 6, 0);

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

--
-- Struttura della tabella `tipologie`
--

CREATE TABLE IF NOT EXISTS `tipologie` (
  `id` int(11) NOT NULL,
  `tipologia` varchar(255) CHARACTER SET latin1 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `tipologie` (`id`, `tipologia`) VALUES
(0, 'abbigliamento'),
(1, 'palestra'),
(2, 'bar'),
(3, 'pizzeria'),
(4, 'fastfood'),
(5, 'ristorante'),
(6, 'cartoleria'),
(7, 'edicola'),
(8, 'market'),
(9, 'ferramenta'),
(10, 'elettronica'),
(11, 'altro');

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

--
-- Struttura della tabella `utente`
--

CREATE TABLE IF NOT EXISTS `utente` (
  `id` int(11) NOT NULL,
  `username` varchar(255) CHARACTER SET latin1 NOT NULL,
  `password` varchar(255) CHARACTER SET latin1 NOT NULL,
  `nome` varchar(255) CHARACTER SET latin1 NOT NULL,
  `cognome` varchar(255) CHARACTER SET latin1 NOT NULL,
  `cell` varchar(255) CHARACTER SET latin1 NOT NULL,
  `email` varchar(255) CHARACTER SET latin1 NOT NULL,
  `avatar` varchar(255) CHARACTER SET latin1 NOT NULL,
  `is_owner` int(11) NOT NULL DEFAULT '0',
  `token` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `is_active` int(11) NOT NULL DEFAULT '1',
  `is_admin` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=334 DEFAULT CHARSET=utf8;

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

INSERT INTO `utente` (`id`, `username`, `password`, `nome`, `cognome`, `cell`, `email`, `avatar`, `is_owner`, `token`, `is_active`, `is_admin`) VALUES
(221, 'Panellox', '$2y$10$K.YH0zhmUbY.eM7AQouM1uEC2IEgKbWMwrGkfMOz3QVHsVA/YsRLq', 'Panello', 'Vino', '46466494', 'hsjsjs@jdjdj.it', '55e080c24b1a1.jpeg', 1, '428455d2543345970cecb8c5295c16ef51ee1238', 1, 0),
(222, 'XxxGinaPaxerellaxxx', '$2y$10$9HsSUoEOpI96gd1CepwVGeNk8CbjyhgRPp7Dya1/lnI5faU2BGrQu', 'Gina ', 'Lollobbriggida', '99908', 'tuttagina@gmail.zucca', '55e081dd38815.jpeg', 1, '3ef7811d0abe165aac7efc030d312bdcf67d34a6', 1, 0),
(223, 'GiullareMagalli', '$2y$10$zM00AN2nmGzRIdS1mPnyI.sTyULq8Bf0KQrXes8RS2YSOjOxSwwnu', 'Magalli', 'Swarzneghereng', '97777777777', 'sweetmagalli@qwerty.non', '55e0830e660b0.jpeg', 1, 'a66a5857b603ebf45f56db0d9d67493464630ad1', 1, 0),
(224, 'buzzanofillo', '$2y$10$v.Q9oHqOrJH7ufG0y/fUdO8QhWqkPHqO..fCs76C7qSKEFO1W5pf2', 'he jsjajja', 'shsjsjs', '646464', 'bsnsns@djjs.it', '55e083b6c5e32.jpeg', 1, 'f37f2109deb945c0cde37d633c098f8a0c60df86', 1, 0),
(225, 'john', '$2y$10$eQ.pPq3bPjAHtDPK7WtH/uTAO4w3C001094pHMtQfyZCB8A3uWL8C', 'John', 'Bauan', '3827382938', 'quello@qualcosa.it', '', 0, 'a6eb01f221e3cb63110139a3ebed25bba6f630a3', 1, 0),
(226, 'quertilol', '$2y$10$.XZvhKKccFRK0o.8vxJ1puiZObpCj72NFvsDg/khJr.Ym2ZupYMlm', 'strizzafrullo', 'parafrostis', '0101010101', 'pastafrullo@pifrunante.fastoloso', '55e411e91be51.jpeg', 0, 'b6388b9ad9421ed9864411b906aa62382eea6d36', 1, 0),
(227, 'bsbsnsns', '$2y$10$e3bzKc5gUKaWrrjPVkYp2OnJegH1cFGwlQ7/RpmS1j.0V44fu.PHa', 'I euhssshsjsn', 'jsnsjs', '6464667', 'bsnsnsj@.', '55e412cb24004.jpeg', 1, 'dd70ff0a9441254e3ebb7769066edcf874a1686d', 1, 0),
(258, 'pierdom86', '$2y$10$TncSTWtjHbPBZURfq2wJf.ijTzyLvcnQzjdCRiknm4AHW5GecfKnC', 'Pier Domenico ', 'bonamassa', '328322145', 'bbyambo@gmail.com', '55e4711048b7b.jpeg', 0, 'bd435ec7f0f6f4639245dc24e2acca87d52eb319', 1, 0),
(260, 'pipponee', '$2y$10$yciMuAf7XdrJcfTG8EfLKelJaRpq.6pVnkyEqWjDmCVFQW61upsgq', 'pippo', 'Disney ', '3283221455', 'pippo@Gmail.com', '55e47452848f8.jpeg', 0, '9176eb2af83a0404d2ceea43bb0b268e23e73e15', 1, 0),
(272, 'lucatrek', '$2y$10$/d1ksDX1IQBPa3UobLXkBOpuzvNdZgG3i98g6iSPP4UeJpdPRYnim', 'Luca', 'Zicari', '3292014456', 'luca.zicari@nextrek.net', '55e56b24230c2.png', 1, '3904ba0dbea0c13c8c9f85cb4ee1a0412b4fd19e', 1, 0),
(274, 'pierdomenico', '$2y$10$svPgAxUzX3StB4TZftCMH.xSQFhIUijvMoCyC3u62HR4UbUSeNQuC', 'pippo', 'Disney ', '3225362552', 'pip@mail.com', '55e583498c6db.jpeg', 0, '2698d541fc49d84e6896c4972e12aebb7432689b', 1, 0),
(275, 'Michele Stefanelli', '', 'Michele', 'Stefanelli', '', 'stefanelli.mi@gmail.com', '55e58961bc96d.jpg', 0, 'CAAUiLZBcTEEkBANYRXQLDS7tYBaJePByCJIJikzAgCLYMvrZC8BjdalV5RvBJCOvPCkPp91Ymd8fuhFwGdiBSpA94wks1uERVZCEPZBlT2KLZBlUZCEZCKVnFxtco4l0s28jZADQNtXWvy9qRd0kZAdSsMzDYIOgDxzQ7MODpiuW5yJiysAKbrD7SgA4NWrYpSA9RTx0oKYYhHgQ6iZAZAZCsx7nNeLuxrFbYdZC17EMcr2MVvQZDZD', 1, 0),
(276, 'proviamo', '$2y$10$sV12zS6/FXW5xhId903C5uuWSF4xBMT5nz/iP6MUgh/tVepU5Zqe2', 'pippo', 'prova', '3285642512', 'prova@gmail.com', '55e59781649cd.jpeg', 0, '83211437b1d5e144c84d68fb4a2e6c2346945ea1', 1, 0),
(277, 'FSallustio-admin', '$2y$10$vfi6CAfbytglEx5STwbXWeA3VHIPhSJ648Q8RY2jf8uJW/ozZkZz2', 'Felice', 'Sallustio', '', 'felice.sallustio@nextrek.net', '', 0, '70d171ff19e1aa8661f73e1d875b74fd69270a34', 1, 1),
(284, 'SuperAdmin', '$2y$10$RyfZjegyNRVGV9Nw3S5OXOPSx5GC0IPZSdXDiZi333ha5DU6Wz8Pe', 'a', 'a', '2323232323232', 'd.disotto@gmail.com', '', 0, '040503240b929ef57264cfea41bbf5f68f76b997', 1, 0),
(298, 'sbhshsjaja', '$2y$10$dFeoKH0wv8X3l008pKu0suVfOREVxf05Yo.Vp/OXl1DaUFT5Ge4.S', '', '', '', 'dnznnsns@772727.it', '', 0, '94f95a644b09b3ee8f61c9f764f0f6fa79ab6f1b', 1, 0),
(299, 'sbhshsjajashha', '$2y$10$bEs9/.ofFydm1iA0jvwz.e6VEMsI2q/zRVuQpDYAlB8qC/Ipu10e6', '', '', '', 'dnzns@772727.it', '', 0, '5986d96e67ef923449503610a51b271178824534', 1, 0),
(300, 'nsnsnsnnsz', '$2y$10$MvCJhaL3ym75V9Nat04.gOSKksjIUMAA0wbBUg6Rcb33U.AjHeHyS', '', '', '', 'bzhzhz@73727.it', '', 0, '204a859ba746e732f24b2797012023324cc96825', 1, 0),
(301, 'abbajajaj', '$2y$10$OkRljWd6Nzs0O.768G0IReodjGZJkn1uKTFx.EVjnD7LslCmuIOOW', '', '', '', 'jsjsjaja@jdjdjs.it', '', 0, '14b4f1f060cf5ab16cf9239c16357a69e8c091a8', 1, 0),
(305, 'anannhajsjs', '$2y$10$AdidRLsoneIIr2ynwbURQu1RudIrdu04gH49vYdESU1UswZn5bOZO', 'mcjdjd', 'sbsnana', '54646494', 'babananaja@jsjs.it', '', 1, '9176fd823d39a11160cc9409264daeec574d3cfa', 1, 0),
(306, 'nsjsjajaj', '$2y$10$mNbcOBIrfVZ/00NJrndVKOWR93M6v/KsYWzx9mg09JgZYmBBzNla2', 'hshshsnaan', 'hsjsjajaj', '14545454', 'xjjsks@jdkdk.ir', '', 1, 'f0a06aaac59f9ac9c13fad7df853a30284bc8532', 1, 0),
(308, 'aaaaaaaaaaa', '$2y$10$8/yq8Boe8eq.Alf6QBl3mOwIwS62eljS0xA54NUaxLi.I9pXQm2Dy', 'a', 'a', '2323232323232', 'damiano.disotto@nextrek.net', '55e6d4765defd.jpg', 1, '97910e9f914948fcb2df5fdb9063276bcf9a16e1', 1, 0),
(311, 'SuperAdmin2', '$2y$10$mmzOIfnktiIiZo5aV8bMTu5ARF.Q3fQD2r2NfKAre6.zBtZ2c4Cnm', 'aaaa', 'aaaa', '243423', 'info@premru.com', '55e6f1eb81b32.jpg', 0, 'd2587df1ec4377e979f0918c3f0d61c53810156d', 1, 0),
(312, 'cnzbczmz', '$2y$10$DceE/Wfq714a7m3NSpHnt.7KroNLWHBS2n4tGHpUbN64zJElEYJYi', '', '', '', 'duuskz@gdjslj.it', '', 0, '1768e537828028644f462083f0792a0de778239d', 1, 0),
(313, 'jsmdhdkha', '$2y$10$bYAo0FTsehL0h7rsLG6kSuBq6Z9sdJvTK6dq4WRAsFHrKa8EBLawe', '', '', '', 'fzgzjsjak@gjdjks.it', '', 0, '1aa740cfffc84e28d5e899d5903a1a54fd53672c', 1, 0),
(317, 'john1', '$2y$10$3OecIOzqRc.p3WpqJf8HX.45ycMbPe3klM21dfL4v4qxzYQaV1y2S', 'john1', 'Bbv', '', 'John@john.it', '', 0, '5a9f16e65c885d4e4bfd10aae76b660aebe3f49e', 1, 0),
(321, 'Montgomery', '$2y$10$qH3TiNmii1MmqCDOF0b7GeoBmsytIAWZvct9dXrgW0ylBdCJ77cdm', 'Montgomery', '', '', 'Burns@burns.it', '', 0, '', 1, 0),
(322, 'SmartCharging', '$2y$10$k/4fxyxxTH2APAgrwrk65.bmXLiOKCsa.2yVY3.g/1yIlfuX6gDPq', 'Michele ', 'Stefanelli', '555133244', 'info@smartcharging.it', '55e71e81bef92.jpeg', 0, 'b5a303ced93536a3f01812cd23f2ba05adb6ce0a', 1, 0),
(323, 'hshajakak', '$2y$10$3V1jzzd.WFWdv7F.ESSVw.oE166iX6jLOxgN3BsAELJsmStWjtgSW', '', '', '', 'cjdjjdd@hdhdj.it', '', 0, '3c7b077c3c82ad0798afe2cca84c195afc43e50b', 1, 0),
(324, 'shsjajkaka', '$2y$10$K1FqLSkdF88G81fPwq5UueBDa7NSylhTSqXjkk2uG2I6Lym31mzKe', 'jsjsjsjs', 'jsjsjsjsjs', '44444', 'sbshhshsh@ndndns.it', '55e803611c9c3.jpeg', 1, '1aac4e8f600b8170a61d4c2cab59e1313d0ce633', 1, 0),
(325, 'sjsjsjjsjs', '$2y$10$Ty4m9g55lWH24xC9YuHsGOwDYkJNfRGafkiBD90ShUTVc0aFOg12C', 'xjdjjsjsks', 'hsusjjsjs', '267676767', 'jzjsjsjs@ndjdjd.it', '', 0, 'c331cf00b999a00cc11370646b2a3cc6d34f69fc', 1, 0),
(326, 'sqwwqfsjs', '$2y$10$RuhIjyp/glvedScD.Kfqj.6c21g.8ke6anGgWrideTUdmdIQUdNKO', 'xjdjjsjsks', 'hsusjjsjs', '267676767', 'jzffjs@ndjdjd.it', '', 0, '01fc2baee930370a69376ff456175d3429c77eb5', 1, 0),
(327, 'sqwffwqfsjs', '$2y$10$sBavgZf/D6JmGUFG448HwesEsQZ7zI0QK7FP/0hq0xivbsXLZFY4O', 'xjdjjsjsks', 'hsusjjsjs', '267676767', 'jwqfjs@ndjdjd.it', '', 0, 'b210e3891c9666fe01063b74e5647b16cb5a8abc', 1, 0),
(328, 'wqffwqfsjs', '$2y$10$TMrgfeHO2XJJ5qOXoSrQRuIZE/R9tS.v0PZKVS1ApyvDtYfwCWdWC', 'xjdjjsjsks', 'hsusjjsjs', '267676767', 'jwwqws@ndjdjd.it', '', 0, 'a2f53af8322a1563914c6ddaf8aff3133e1e9a57', 1, 0),
(329, 'wqfqwfwqfsjs', '$2y$10$E1zJX4HhZMdyuUpGwmOl.um3nFVgsW4yIAJsPCmWJhyPodun5w5we', 'xjdjjsjsks', 'hsusjjsjs', '267676767', 'jwwqs@ndjdjd.it', '', 0, '43d190cdcdb674c09cdf671c99eef5948eb06b56', 1, 0),
(330, 'wqafqwfwqfsjs', '$2y$10$jGuWKWbQpPFD59mEE2REFOEbfmqlxuu1NJZzEmeX5mZ2/CQtT40JW', 'xjdjjsjsks', 'hsusjjsjs', '267676767', 'jwwaqs@ndjdjd.it', '', 0, '6b776758caf090a6e9dd389254c6171013d8aab1', 1, 0),
(331, 'wqaafqwfwqfsjs', '$2y$10$GU.TVmx7lnDVIBsE/0VM4eHcYtDJbbXD1tRUyd22MZ9ApIAncOgny', 'xjdjjsjsks', 'hsusjjsjs', '267676767', 'jwwaqas@ndjdjd.it', '', 0, '7712dc13d62abdfda20303cdf3ac64a692e1954c', 1, 0),
(332, 'wasdqwfwqfsjs', '$2y$10$0UMXEeVSEtL9/hHDotmGgOjSc3kOoydQSosPpv2Ew../O8r1IxBjC', 'xjdjjsjsks', 'hsusjjsjs', '267676767', 'dsaqas@ndjdjd.it', '', 0, '2b28ed9ccdd3b519c1ee53b42b7ff0f7dae61276', 1, 0),
(333, 'NextrekCaffe', '$2y$10$8uK3Ni2N.WgLW5vgDHfmmeHBhBhXWHmEFPxtDKguso5PDwJalH0KG', 'Fabio', 'Massimo', '55556512', 'nextrek@nextrek.net', '55e8116d58740.jpeg', 1, '19f6553cbd798eb9c9ddb707f8d4062c8f955904', 1, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `commenti`
--
ALTER TABLE `commenti`
  ADD PRIMARY KEY (`id`), ADD KEY `id_locale` (`id_locale`), ADD KEY `id_user` (`id_user`), ADD KEY `id_locale_2` (`id_locale`);

--
-- Indexes for table `immagini_commenti`
--
ALTER TABLE `immagini_commenti`
  ADD KEY `id_commento` (`id_commento`);

--
-- Indexes for table `immagini_locali`
--
ALTER TABLE `immagini_locali`
  ADD KEY `id_locale` (`id_locale`);

--
-- Indexes for table `locale`
--
ALTER TABLE `locale`
  ADD PRIMARY KEY (`id`), ADD KEY `id_utente_owner` (`id_utente_owner`), ADD KEY `tipologia` (`tipologia`), ADD KEY `tipologia_2` (`tipologia`);

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

--
-- Indexes for table `utente`
--
ALTER TABLE `utente`
  ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `email` (`email`), ADD KEY `token` (`token`), ADD KEY `email_2` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `commenti`
--
ALTER TABLE `commenti`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=70;
--
-- AUTO_INCREMENT for table `locale`
--
ALTER TABLE `locale`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=134;
--
-- AUTO_INCREMENT for table `utente`
--
ALTER TABLE `utente`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=334;
--
-- Limiti per le tabelle scaricate
--

--
-- Limiti per la tabella `commenti`
--
ALTER TABLE `commenti`
ADD CONSTRAINT `commenti_ibfk_1` FOREIGN KEY (`id_locale`) REFERENCES `locale` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `commenti_ibfk_2` FOREIGN KEY (`id_user`) REFERENCES `utente` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Limiti per la tabella `immagini_commenti`
--
ALTER TABLE `immagini_commenti`
ADD CONSTRAINT `immagini_commenti_ibfk_1` FOREIGN KEY (`id_commento`) REFERENCES `commenti` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Limiti per la tabella `immagini_locali`
--
ALTER TABLE `immagini_locali`
ADD CONSTRAINT `immagini_locali_ibfk_1` FOREIGN KEY (`id_locale`) REFERENCES `locale` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Limiti per la tabella `locale`
--
ALTER TABLE `locale`
ADD CONSTRAINT `locale_ibfk_1` FOREIGN KEY (`id_utente_owner`) REFERENCES `utente` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `locale_ibfk_2` FOREIGN KEY (`tipologia`) REFERENCES `tipologie` (`id`) ON UPDATE CASCADE;

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