Nextrek
Subversion Repository Public Repository

Nextrek

URLs

Copy to Clipboard
Explore
Commits

Diff Revisions 606 vs 678 for /Android/SmartCharging/endPoints/smartcharging_data.sql

Diff revisions: vs.
  @@ -3,7 +3,7 @@
3 3 -- http://www.phpmyadmin.net
4 4 --
5 5 -- Host: 127.0.0.1
6 - -- Generation Time: Ago 28, 2015 alle 14:20
6 + -- Generation Time: Set 03, 2015 alle 12:03
7 7 -- Versione del server: 5.6.24
8 8 -- PHP Version: 5.6.8
9 9
  @@ -20,6 +20,170 @@
20 20 -- Database: `smartcharging`
21 21 --
22 22
23 + -- --------------------------------------------------------
24 +
25 + --
26 + -- Struttura della tabella `commenti`
27 + --
28 +
29 + CREATE TABLE IF NOT EXISTS `commenti` (
30 + `id` int(11) NOT NULL,
31 + `id_locale` int(11) NOT NULL,
32 + `id_user` int(11) DEFAULT NULL,
33 + `voto` int(11) NOT NULL,
34 + `descrizione` varchar(255) CHARACTER SET latin1 NOT NULL,
35 + `data` datetime NOT NULL
36 + ) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;
37 +
38 + --
39 + -- Dump dei dati per la tabella `commenti`
40 + --
41 +
42 + INSERT INTO `commenti` (`id`, `id_locale`, `id_user`, `voto`, `descrizione`, `data`) VALUES
43 + (27, 98, 225, 4, 'Non ci andate!!', '2015-08-30 15:36:28'),
44 + (28, 96, 260, 5, 'hfdkkgfhhhhhhh', '2015-08-31 17:43:32'),
45 + (29, 101, NULL, 0, 'Fgghh', '2015-09-01 10:49:12'),
46 + (30, 101, NULL, 0, 'Jzjajaja', '2015-09-01 10:49:43'),
47 + (31, 111, 274, 1, 'hhfddlihghkkhvxdsfukkg\n', '2015-09-01 12:55:25'),
48 + (32, 111, 274, 1, 'hhfddlihghkkhvxdsfukkg\n', '2015-09-01 12:55:26'),
49 + (33, 111, 274, 2, 'kgktkgghhdfjnfndjdkfjf', '2015-09-01 12:56:41'),
50 + (34, 111, 274, 2, 'miglioriamola ', '2015-09-01 12:57:48'),
51 + (35, 111, 274, 2, 'miglioriamola ', '2015-09-01 12:57:53'),
52 + (36, 111, 274, 2, 'gggghh', '2015-09-01 13:04:37'),
53 + (37, 111, 274, 2, 'gggghh', '2015-09-01 13:04:42'),
54 + (38, 111, 274, 2, 'gggghh', '2015-09-01 13:04:50'),
55 + (39, 111, 274, 5, 'gggghh', '2015-09-01 13:04:55'),
56 + (40, 111, 274, 5, 'gggghh', '2015-09-01 13:05:07'),
57 + (41, 111, 274, 5, 'gggghh', '2015-09-01 13:05:10'),
58 + (42, 111, 274, 5, 'gggghh', '2015-09-01 13:05:11'),
59 + (43, 99, 274, 3, 'jfpxhpzhzd', '2015-09-01 13:10:16'),
60 + (44, 101, 275, 0, 'Ccc', '2015-09-01 13:25:20'),
61 + (45, 101, 275, 0, 'Ccc', '2015-09-01 13:25:21'),
62 + (46, 101, 275, 0, 'Ccc', '2015-09-01 13:25:23'),
63 + (47, 101, 275, 0, '1', '2015-09-01 13:27:45'),
64 + (48, 101, 275, 0, '2', '2015-09-01 13:27:53'),
65 + (49, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
66 + (50, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
67 + (51, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
68 + (52, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
69 + (53, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
70 + (54, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
71 + (55, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
72 + (56, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
73 + (57, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
74 + (58, 101, 275, 0, 'Ciao', '2015-09-01 13:32:16'),
75 + (59, 101, 275, 0, 'Ciao', '2015-09-01 13:32:17'),
76 + (60, 101, 275, 0, 'Fghj', '2015-09-01 14:53:01'),
77 + (61, 101, 275, 0, 'Fghj', '2015-09-01 14:53:08'),
78 + (62, 111, 301, 0, 'ggh', '2015-09-02 12:38:12'),
79 + (63, 111, 301, 0, 'ggh', '2015-09-02 12:38:12'),
80 + (64, 101, 305, 0, 'hshaja', '2015-09-02 12:45:18'),
81 + (65, 101, 225, 2, 'Ciaoooo', '2015-09-02 13:20:02'),
82 + (66, 101, 275, 5, 'Fty', '2015-09-02 17:07:02'),
83 + (67, 99, 275, 0, 'àààààà', '2015-09-02 17:07:36'),
84 + (68, 133, 333, 0, 'Magnifico, ho caricato il mio telefono al 100%!', '2015-09-03 11:59:52'),
85 + (69, 133, 333, 5, 'Magnifico ho caricato il mio Smartphone al 100%!', '2015-09-03 12:01:15');
86 +
87 + -- --------------------------------------------------------
88 +
89 + --
90 + -- Struttura della tabella `immagini_commenti`
91 + --
92 +
93 + CREATE TABLE IF NOT EXISTS `immagini_commenti` (
94 + `id_commento` int(11) NOT NULL,
95 + `img` varchar(255) CHARACTER SET latin1 NOT NULL
96 + ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
97 +
98 + --
99 + -- Dump dei dati per la tabella `immagini_commenti`
100 + --
101 +
102 + INSERT INTO `immagini_commenti` (`id_commento`, `img`) VALUES
103 + (31, '55e5840b4aa00.jpeg'),
104 + (31, '55e584177e1f9.jpeg'),
105 + (32, '55e5840b4aa00.jpeg'),
106 + (32, '55e584177e1f9.jpeg'),
107 + (33, '55e58461e05a1.jpeg'),
108 + (34, '55e58499eb14a.jpeg'),
109 + (35, '55e58499eb14a.jpeg'),
110 + (41, '55e58663057bd.jpeg'),
111 + (42, '55e58663057bd.jpeg');
112 +
113 + -- --------------------------------------------------------
114 +
115 + --
116 + -- Struttura della tabella `immagini_locali`
117 + --
118 +
119 + CREATE TABLE IF NOT EXISTS `immagini_locali` (
120 + `id_locale` int(11) NOT NULL,
121 + `img` varchar(255) CHARACTER SET latin1 NOT NULL
122 + ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
123 +
124 + --
125 + -- Dump dei dati per la tabella `immagini_locali`
126 + --
127 +
128 + INSERT INTO `immagini_locali` (`id_locale`, `img`) VALUES
129 + (96, '55e080b881b32.jpeg'),
130 + (98, '55e081d1e9e37.jpeg'),
131 + (99, '55e082fae3368.jpeg'),
132 + (99, '55e0830c835e6.jpeg'),
133 + (100, '55e083b4a4fc5.jpeg'),
134 + (111, '55e56ce9c306c.png');
135 +
136 + -- --------------------------------------------------------
137 +
138 + --
139 + -- Struttura della tabella `locale`
140 + --
141 +
142 + CREATE TABLE IF NOT EXISTS `locale` (
143 + `id` int(11) NOT NULL,
144 + `id_utente_owner` int(11) NOT NULL,
145 + `nomelocale` varchar(255) CHARACTER SET latin1 NOT NULL,
146 + `descrizione` varchar(255) CHARACTER SET latin1 NOT NULL,
147 + `tipologia` int(11) NOT NULL,
148 + `lat` double DEFAULT NULL,
149 + `lon` double DEFAULT NULL,
150 + `indirizzo` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
151 + `email` varchar(255) CHARACTER SET latin1 NOT NULL,
152 + `telefono` varchar(255) CHARACTER SET latin1 NOT NULL,
153 + `sito` varchar(255) CHARACTER SET latin1 NOT NULL,
154 + `n_punti_ricarica` int(11) NOT NULL DEFAULT '0',
155 + `hidden` int(11) NOT NULL DEFAULT '0'
156 + ) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=utf8;
157 +
158 + --
159 + -- Dump dei dati per la tabella `locale`
160 + --
161 +
162 + INSERT INTO `locale` (`id`, `id_utente_owner`, `nomelocale`, `descrizione`, `tipologia`, `lat`, `lon`, `indirizzo`, `email`, `telefono`, `sito`, `n_punti_ricarica`, `hidden`) VALUES
163 + (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),
164 + (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),
165 + (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),
166 + (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),
167 + (100, 224, 'Null pointer, no scherzo', 'Data:) ', 6, 41.8224472, 12.5183907, 'millevoi ', 'bsnsns@djjs.it', '646464', 'null.null.it', 990, 0),
168 + (101, 227, 'hshsjs', 'Nsnsnsja', 1, 41.6445071, 12.9129985, 'cori', 'bsnsnsj@.', '6464667', 'hsnsjsnsns', 4444, 0),
169 + (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),
170 + (119, 305, 'hahahana', 'hahaja', 5, 0, 0, '', 'babananaja@jsjs.it', '54646494', 'hahanaba', 46, 0),
171 + (120, 306, 'sgagahah', 'hshahaha\ngshah\nsuha', 4, 0, 0, '', 'xjjsks@jdkdk.ir', '14545454', 'hshahaha', 6464, 0),
172 + (121, 308, 'prova locale', 'aaaaa', 4, 11.111111, 11.222222, 'aaaaaa', 'admin@ciampibookstore.it', '111111111', 'via vai', 1, 0),
173 + (125, 324, 'shsjanjaja', 'Ajjajajahsheusisks\n', 5, 11.825138, 42.590275, 'dj', 'sbshhshsh@ndndns.it', '44444', 'kajajakakakak', 44, 0),
174 + (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);
175 +
176 + -- --------------------------------------------------------
177 +
178 + --
179 + -- Struttura della tabella `tipologie`
180 + --
181 +
182 + CREATE TABLE IF NOT EXISTS `tipologie` (
183 + `id` int(11) NOT NULL,
184 + `tipologia` varchar(255) CHARACTER SET latin1 NOT NULL
185 + ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
186 +
23 187 --
24 188 -- Dump dei dati per la tabella `tipologie`
25 189 --
  @@ -29,118 +193,169 @@
29 193 (1, 'palestra'),
30 194 (2, 'bar'),
31 195 (3, 'pizzeria'),
32 - (4, 'ristorante'),
33 - (5, 'cartoleria'),
34 - (6, 'edicola'),
35 - (7, 'market'),
36 - (8, 'ferramenta'),
37 - (9, 'elettronica'),
38 - (10, 'altro');
196 + (4, 'fastfood'),
197 + (5, 'ristorante'),
198 + (6, 'cartoleria'),
199 + (7, 'edicola'),
200 + (8, 'market'),
201 + (9, 'ferramenta'),
202 + (10, 'elettronica'),
203 + (11, 'altro');
204 +
205 + -- --------------------------------------------------------
206 +
207 + --
208 + -- Struttura della tabella `utente`
209 + --
210 +
211 + CREATE TABLE IF NOT EXISTS `utente` (
212 + `id` int(11) NOT NULL,
213 + `username` varchar(255) CHARACTER SET latin1 NOT NULL,
214 + `password` varchar(255) CHARACTER SET latin1 NOT NULL,
215 + `nome` varchar(255) CHARACTER SET latin1 NOT NULL,
216 + `cognome` varchar(255) CHARACTER SET latin1 NOT NULL,
217 + `cell` varchar(255) CHARACTER SET latin1 NOT NULL,
218 + `email` varchar(255) CHARACTER SET latin1 NOT NULL,
219 + `avatar` varchar(255) CHARACTER SET latin1 NOT NULL,
220 + `is_owner` int(11) NOT NULL DEFAULT '0',
221 + `token` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
222 + `is_active` int(11) NOT NULL DEFAULT '1',
223 + `is_admin` int(11) NOT NULL DEFAULT '0'
224 + ) ENGINE=InnoDB AUTO_INCREMENT=334 DEFAULT CHARSET=utf8;
39 225
40 226 --
41 227 -- Dump dei dati per la tabella `utente`
42 228 --
43 229
44 230 INSERT INTO `utente` (`id`, `username`, `password`, `nome`, `cognome`, `cell`, `email`, `avatar`, `is_owner`, `token`, `is_active`, `is_admin`) VALUES
45 - (127, 'shhsjsjs', '$2y$10$3IkUXX1cEzYFsQQRG75DwuKbsskaW8fAFRTWcf9Yo1HyEQyeNIPiC', 'federico', 'fontna', '4694944', 'kfksksks@.dududj', '55d5de759baff.jpeg', 0, '6635ce370ecfe02659f4a98a862bb1ed2f8032aa', 1, 0),
46 - (128, 'dhdjdnjdjd', '$2y$10$3kz.05IOE/jCUJF8ATtRD.Qx5uBolQyIrlWSHbJ8k88RgU3/HnqzS', 'hdjdd', 'duhdhd', '454224', 'dhddjdhdh@55555.', '55d5deb463a8b.jpeg', 0, '', 0, 0),
47 - (130, 'xjjxjxxbzhz', '$2y$10$.mDJI33zYQKdW2byJHw2JO9WcejJmUxWsIs1J8D8ybe7FxIDWoli.', 'jcjcidjd', 'djxjjxu', '', 'ndjskeke@.', '55d5df9167794.jpeg', 0, '4842413dc19741f0fc86bd5fc65bbde77c62b552', 1, 0),
48 - (131, 'sbzbbxhx', '$2y$10$qh.vptoYhjtUTewJzXADzOjejWQMAVeq5wYvnh.BosEEqxKulCKKG', 'jchdjdjd', 'xhjdjx', '466464', 'dhdhdhdhhd@.dud', '55d5e49974963.jpeg', 0, '90e82b8582ed12a2b62756cde1aadc7d4e45dcc9', 1, 0),
49 - (132, 'xhxjjxjx', '$2y$10$tfFMv.Prjj7NK6Cs6mylzuWPYi6Gd2FhlqVW.uBwuj5ZoXDz5CX9W', 'nxnxjx', 'xduxuux', '', 'xxhuxjs.it@', '55d5e4f6e55bd.jpeg', 0, 'cd6f189e88bde5d28bdfa7e6bc9a05f631f72a8c', 1, 0),
50 - (134, 'hshsbscjdjd', '$2y$10$9AT2rCOsLgt99Bvx6vyVyO4USBDc9fU630qfXr3l2MM95ws2SLlcm', 'mmck', 'dudjdjd', '46649191', 'hdhhd@hdhd.it', '', 0, '39ffaae9731c675b3e30e7a7d2f6a0651165e461', 1, 0),
51 - (135, 'xhhdhdjdjd', '$2y$10$9P8xtCpe7LCsy2qL3KpM5er9OpTf4JueNfO7.7ujSiaUc9pdH6tlK', 'hhjdjdhd', 'nxjxjxjx', '6564949', 'hdhdhdh@hdhdj.it', '', 0, '4418af7b1eda3b5ba2bd52087b204a96da94753b', 1, 0),
52 - (136, 'federico', '$2y$10$KfS6HgzxVF5s.dNFTFKqQOOIfMivLruZWEnuG7LYY.k71wYsPbOlW', 'Federico', 'Fontana', '32656464646464', 'scanafei@gnail.com', '55d838c1b626d.jpeg', 0, '', 0, 0),
53 - (137, 'hajaiajaja', '$2y$10$YQHgM8k2RWn/Bhy3zBBpLebqP4kY61ZYqgrJ57nT/.RMcypZZ3xbO', 'mckxkdk', 'sjjsjsjs', '68668688', 'jdjsjsjaja@djjdd.it', '55db08622123e.jpeg', 0, '', 0, 0),
54 - (140, 'federico1', '$2y$10$nuUW1rlUy9XCZP/oDZ7yD.GMdvvutXzvJn6lh9zrmGuKTuR.T8Ks2', 'federico', 'fontana', '65355', 'scanapoi@.', '55db8ace0501b.jpeg', 1, '', 0, 0),
55 - (141, 'Michele Stefanelli', '', 'Michele', 'Stefanelli', '', 'stefanelli.mi@gmail.com', '', 0, '', 0, 0),
56 - (142, 'freestyler', '$2y$10$dUItudSqzu2L//cxTWj04O3RDIAGgUDfD54CMna0hqt91o6JCwvy6', 'fabrizio', 'cicola', '3343790141', 'freestyler22@gmail.com', '55dc2b4746926.jpeg', 0, '', 0, 0),
57 - (143, 'pincopallino1', '$2y$10$ghcs5K.XON2vKJ8MyozJt.2FOR4YhB8yVNRwLxGxT8gAcHl53J2Jm', 'pinco', 'pallino', '333333333', 'pinco@pallino.it', '55dc35f5bebc2.jpeg', 0, 'ed49f34229c73c30203c01ab01e5a0d9c3adc165', 1, 0),
58 - (144, 'ciaociao', '$2y$10$RuWqbkWoiziHTSQD3tGfEeIumhB9gEoLGKqXNspVDG33XapnKmE3y', 'jdkdjd', 'suududud', '5965646464', 'ciao@ciao.', '55dc3b17b9405.jpeg', 1, '', 0, 0),
59 - (145, 'qwerty123', '$2y$10$Q..WENFkiDICU7DS5JT0PuaX8yjkwcEGSm86smGTjH67D/d1uOVza', 'ududu', 'eyyeyey', '', 'we@.', '55dc3c1885099.jpeg', 0, 'eae7d7c14a9c7271340e2b34ce6c339bab1f75fd', 1, 0),
60 - (146, 'locale123', '$2y$10$YiTRskUOiZPtud5O5qMnteNDDLn/ADO8G0u5Cqn19g1kT5xxUvS9G', 'jdjdjd', 'ydydhdh', '', 'shshhshs@.', '55dc3c9d1f78a.jpeg', 1, '', 0, 0),
61 - (147, 'dhjsjsus', '$2y$10$b/vF7QkkSi9gYrph7hO8zez4Z2Gz9rPkUaS/LvGtM0FazNwABJg/C', 'fese', 'jdjdudu', '', 'ndjdid@.', '55dc414e1cd94.jpeg', 0, '', 0, 0),
62 - (148, 'MhzDevFrizz', '$2y$10$XvlRWARRTYlx7zw1.epjZOT7tu8hA4l4TF2kQJqSo5cTNvjTV/xxa', 'Michele', 'Stefanelli', '333222558', 'MhzDev@gmail.com ', '55dc48407b062.jpeg', 1, '', 0, 0),
63 - (149, 'FSallustio-admin', '$2y$10$jLGv7QB/QNABlcCBG7mEdOqXFc3vcEQj/4t2LHS34k2tVIWEEFNAK', '', '', '', '', '', 0, '', 0, 1),
64 - (150, 'Nextrek-admin', '$2y$10$kO31xMgANUD9L.KuQUSrKOJuByYYg6RGxJrchnvY/gSaq4LSkKwGS', '', '', '', 'smartcharging@nextrek.net', '', 0, '', 0, 1),
65 - (151, 'John', '$2y$10$HEDluKhBLh9y6ALdYXN6iump5QWcph.6hxLtfflz1LQe0VuUfgC3K', 'John', 'Bauan', '333333333', 'john.moses.bauan@nextrek.net', '', 0, '', 0, 0),
66 - (152, 'ciccio', '$2y$10$OCI9CYT8AooEp1qhggdroO0/d0Z1VMpr1MtWYw0h4sPeLTjIyLXEu', 'Ciccio', 'Graziani', '333333333', 'ciccio@graziani.it', '55ded3031e848.jpg', 1, '', 0, 0),
67 - (162, 'StrizziPatrizzi', '$2y$10$bTs/8WhO8CRrGE4JJECAMe28Bluch82yb//pl4QqdgOILEPQlD0A6', 'Nome', 'Cognome ', '333665896', 'strizzi@gmail.com', '55df2128bf363.jpeg', 1, 'c09656cf76adcd045c62e0963983e23706034207', 1, 0),
68 - (204, 'lucatrek', '$2y$10$7hQLPGoIbJVcCuiHi1BflOWwarIGMkyiYjbSYsgLDw1MwJyKFMln.', 'Luca', 'Zicari', '3292014456', 'luca.zicari@nextrek.net', '', 0, '7401e7e6591ba9533924b6084550927667781d2b', 1, 0);
231 + (221, 'Panellox', '$2y$10$K.YH0zhmUbY.eM7AQouM1uEC2IEgKbWMwrGkfMOz3QVHsVA/YsRLq', 'Panello', 'Vino', '46466494', 'hsjsjs@jdjdj.it', '55e080c24b1a1.jpeg', 1, '428455d2543345970cecb8c5295c16ef51ee1238', 1, 0),
232 + (222, 'XxxGinaPaxerellaxxx', '$2y$10$9HsSUoEOpI96gd1CepwVGeNk8CbjyhgRPp7Dya1/lnI5faU2BGrQu', 'Gina ', 'Lollobbriggida', '99908', 'tuttagina@gmail.zucca', '55e081dd38815.jpeg', 1, '3ef7811d0abe165aac7efc030d312bdcf67d34a6', 1, 0),
233 + (223, 'GiullareMagalli', '$2y$10$zM00AN2nmGzRIdS1mPnyI.sTyULq8Bf0KQrXes8RS2YSOjOxSwwnu', 'Magalli', 'Swarzneghereng', '97777777777', 'sweetmagalli@qwerty.non', '55e0830e660b0.jpeg', 1, 'a66a5857b603ebf45f56db0d9d67493464630ad1', 1, 0),
234 + (224, 'buzzanofillo', '$2y$10$v.Q9oHqOrJH7ufG0y/fUdO8QhWqkPHqO..fCs76C7qSKEFO1W5pf2', 'he jsjajja', 'shsjsjs', '646464', 'bsnsns@djjs.it', '55e083b6c5e32.jpeg', 1, 'f37f2109deb945c0cde37d633c098f8a0c60df86', 1, 0),
235 + (225, 'john', '$2y$10$eQ.pPq3bPjAHtDPK7WtH/uTAO4w3C001094pHMtQfyZCB8A3uWL8C', 'John', 'Bauan', '3827382938', 'quello@qualcosa.it', '', 0, 'a6eb01f221e3cb63110139a3ebed25bba6f630a3', 1, 0),
236 + (226, 'quertilol', '$2y$10$.XZvhKKccFRK0o.8vxJ1puiZObpCj72NFvsDg/khJr.Ym2ZupYMlm', 'strizzafrullo', 'parafrostis', '0101010101', 'pastafrullo@pifrunante.fastoloso', '55e411e91be51.jpeg', 0, 'b6388b9ad9421ed9864411b906aa62382eea6d36', 1, 0),
237 + (227, 'bsbsnsns', '$2y$10$e3bzKc5gUKaWrrjPVkYp2OnJegH1cFGwlQ7/RpmS1j.0V44fu.PHa', 'I euhssshsjsn', 'jsnsjs', '6464667', 'bsnsnsj@.', '55e412cb24004.jpeg', 1, 'dd70ff0a9441254e3ebb7769066edcf874a1686d', 1, 0),
238 + (258, 'pierdom86', '$2y$10$TncSTWtjHbPBZURfq2wJf.ijTzyLvcnQzjdCRiknm4AHW5GecfKnC', 'Pier Domenico ', 'bonamassa', '328322145', 'bbyambo@gmail.com', '55e4711048b7b.jpeg', 0, 'bd435ec7f0f6f4639245dc24e2acca87d52eb319', 1, 0),
239 + (260, 'pipponee', '$2y$10$yciMuAf7XdrJcfTG8EfLKelJaRpq.6pVnkyEqWjDmCVFQW61upsgq', 'pippo', 'Disney ', '3283221455', 'pippo@Gmail.com', '55e47452848f8.jpeg', 0, '9176eb2af83a0404d2ceea43bb0b268e23e73e15', 1, 0),
240 + (272, 'lucatrek', '$2y$10$/d1ksDX1IQBPa3UobLXkBOpuzvNdZgG3i98g6iSPP4UeJpdPRYnim', 'Luca', 'Zicari', '3292014456', 'luca.zicari@nextrek.net', '55e56b24230c2.png', 1, '3904ba0dbea0c13c8c9f85cb4ee1a0412b4fd19e', 1, 0),
241 + (274, 'pierdomenico', '$2y$10$svPgAxUzX3StB4TZftCMH.xSQFhIUijvMoCyC3u62HR4UbUSeNQuC', 'pippo', 'Disney ', '3225362552', 'pip@mail.com', '55e583498c6db.jpeg', 0, '2698d541fc49d84e6896c4972e12aebb7432689b', 1, 0),
242 + (275, 'Michele Stefanelli', '', 'Michele', 'Stefanelli', '', 'stefanelli.mi@gmail.com', '55e58961bc96d.jpg', 0, 'CAAUiLZBcTEEkBANYRXQLDS7tYBaJePByCJIJikzAgCLYMvrZC8BjdalV5RvBJCOvPCkPp91Ymd8fuhFwGdiBSpA94wks1uERVZCEPZBlT2KLZBlUZCEZCKVnFxtco4l0s28jZADQNtXWvy9qRd0kZAdSsMzDYIOgDxzQ7MODpiuW5yJiysAKbrD7SgA4NWrYpSA9RTx0oKYYhHgQ6iZAZAZCsx7nNeLuxrFbYdZC17EMcr2MVvQZDZD', 1, 0),
243 + (276, 'proviamo', '$2y$10$sV12zS6/FXW5xhId903C5uuWSF4xBMT5nz/iP6MUgh/tVepU5Zqe2', 'pippo', 'prova', '3285642512', 'prova@gmail.com', '55e59781649cd.jpeg', 0, '83211437b1d5e144c84d68fb4a2e6c2346945ea1', 1, 0),
244 + (277, 'FSallustio-admin', '$2y$10$vfi6CAfbytglEx5STwbXWeA3VHIPhSJ648Q8RY2jf8uJW/ozZkZz2', 'Felice', 'Sallustio', '', 'felice.sallustio@nextrek.net', '', 0, '70d171ff19e1aa8661f73e1d875b74fd69270a34', 1, 1),
245 + (284, 'SuperAdmin', '$2y$10$RyfZjegyNRVGV9Nw3S5OXOPSx5GC0IPZSdXDiZi333ha5DU6Wz8Pe', 'a', 'a', '2323232323232', 'd.disotto@gmail.com', '', 0, '040503240b929ef57264cfea41bbf5f68f76b997', 1, 0),
246 + (298, 'sbhshsjaja', '$2y$10$dFeoKH0wv8X3l008pKu0suVfOREVxf05Yo.Vp/OXl1DaUFT5Ge4.S', '', '', '', 'dnznnsns@772727.it', '', 0, '94f95a644b09b3ee8f61c9f764f0f6fa79ab6f1b', 1, 0),
247 + (299, 'sbhshsjajashha', '$2y$10$bEs9/.ofFydm1iA0jvwz.e6VEMsI2q/zRVuQpDYAlB8qC/Ipu10e6', '', '', '', 'dnzns@772727.it', '', 0, '5986d96e67ef923449503610a51b271178824534', 1, 0),
248 + (300, 'nsnsnsnnsz', '$2y$10$MvCJhaL3ym75V9Nat04.gOSKksjIUMAA0wbBUg6Rcb33U.AjHeHyS', '', '', '', 'bzhzhz@73727.it', '', 0, '204a859ba746e732f24b2797012023324cc96825', 1, 0),
249 + (301, 'abbajajaj', '$2y$10$OkRljWd6Nzs0O.768G0IReodjGZJkn1uKTFx.EVjnD7LslCmuIOOW', '', '', '', 'jsjsjaja@jdjdjs.it', '', 0, '14b4f1f060cf5ab16cf9239c16357a69e8c091a8', 1, 0),
250 + (305, 'anannhajsjs', '$2y$10$AdidRLsoneIIr2ynwbURQu1RudIrdu04gH49vYdESU1UswZn5bOZO', 'mcjdjd', 'sbsnana', '54646494', 'babananaja@jsjs.it', '', 1, '9176fd823d39a11160cc9409264daeec574d3cfa', 1, 0),
251 + (306, 'nsjsjajaj', '$2y$10$mNbcOBIrfVZ/00NJrndVKOWR93M6v/KsYWzx9mg09JgZYmBBzNla2', 'hshshsnaan', 'hsjsjajaj', '14545454', 'xjjsks@jdkdk.ir', '', 1, 'f0a06aaac59f9ac9c13fad7df853a30284bc8532', 1, 0),
252 + (308, 'aaaaaaaaaaa', '$2y$10$8/yq8Boe8eq.Alf6QBl3mOwIwS62eljS0xA54NUaxLi.I9pXQm2Dy', 'a', 'a', '2323232323232', 'damiano.disotto@nextrek.net', '55e6d4765defd.jpg', 1, '97910e9f914948fcb2df5fdb9063276bcf9a16e1', 1, 0),
253 + (311, 'SuperAdmin2', '$2y$10$mmzOIfnktiIiZo5aV8bMTu5ARF.Q3fQD2r2NfKAre6.zBtZ2c4Cnm', 'aaaa', 'aaaa', '243423', 'info@premru.com', '55e6f1eb81b32.jpg', 0, 'd2587df1ec4377e979f0918c3f0d61c53810156d', 1, 0),
254 + (312, 'cnzbczmz', '$2y$10$DceE/Wfq714a7m3NSpHnt.7KroNLWHBS2n4tGHpUbN64zJElEYJYi', '', '', '', 'duuskz@gdjslj.it', '', 0, '1768e537828028644f462083f0792a0de778239d', 1, 0),
255 + (313, 'jsmdhdkha', '$2y$10$bYAo0FTsehL0h7rsLG6kSuBq6Z9sdJvTK6dq4WRAsFHrKa8EBLawe', '', '', '', 'fzgzjsjak@gjdjks.it', '', 0, '1aa740cfffc84e28d5e899d5903a1a54fd53672c', 1, 0),
256 + (317, 'john1', '$2y$10$3OecIOzqRc.p3WpqJf8HX.45ycMbPe3klM21dfL4v4qxzYQaV1y2S', 'john1', 'Bbv', '', 'John@john.it', '', 0, '5a9f16e65c885d4e4bfd10aae76b660aebe3f49e', 1, 0),
257 + (321, 'Montgomery', '$2y$10$qH3TiNmii1MmqCDOF0b7GeoBmsytIAWZvct9dXrgW0ylBdCJ77cdm', 'Montgomery', '', '', 'Burns@burns.it', '', 0, '', 1, 0),
258 + (322, 'SmartCharging', '$2y$10$k/4fxyxxTH2APAgrwrk65.bmXLiOKCsa.2yVY3.g/1yIlfuX6gDPq', 'Michele ', 'Stefanelli', '555133244', 'info@smartcharging.it', '55e71e81bef92.jpeg', 0, 'b5a303ced93536a3f01812cd23f2ba05adb6ce0a', 1, 0),
259 + (323, 'hshajakak', '$2y$10$3V1jzzd.WFWdv7F.ESSVw.oE166iX6jLOxgN3BsAELJsmStWjtgSW', '', '', '', 'cjdjjdd@hdhdj.it', '', 0, '3c7b077c3c82ad0798afe2cca84c195afc43e50b', 1, 0),
260 + (324, 'shsjajkaka', '$2y$10$K1FqLSkdF88G81fPwq5UueBDa7NSylhTSqXjkk2uG2I6Lym31mzKe', 'jsjsjsjs', 'jsjsjsjsjs', '44444', 'sbshhshsh@ndndns.it', '55e803611c9c3.jpeg', 1, '1aac4e8f600b8170a61d4c2cab59e1313d0ce633', 1, 0),
261 + (325, 'sjsjsjjsjs', '$2y$10$Ty4m9g55lWH24xC9YuHsGOwDYkJNfRGafkiBD90ShUTVc0aFOg12C', 'xjdjjsjsks', 'hsusjjsjs', '267676767', 'jzjsjsjs@ndjdjd.it', '', 0, 'c331cf00b999a00cc11370646b2a3cc6d34f69fc', 1, 0),
262 + (326, 'sqwwqfsjs', '$2y$10$RuhIjyp/glvedScD.Kfqj.6c21g.8ke6anGgWrideTUdmdIQUdNKO', 'xjdjjsjsks', 'hsusjjsjs', '267676767', 'jzffjs@ndjdjd.it', '', 0, '01fc2baee930370a69376ff456175d3429c77eb5', 1, 0),
263 + (327, 'sqwffwqfsjs', '$2y$10$sBavgZf/D6JmGUFG448HwesEsQZ7zI0QK7FP/0hq0xivbsXLZFY4O', 'xjdjjsjsks', 'hsusjjsjs', '267676767', 'jwqfjs@ndjdjd.it', '', 0, 'b210e3891c9666fe01063b74e5647b16cb5a8abc', 1, 0),
264 + (328, 'wqffwqfsjs', '$2y$10$TMrgfeHO2XJJ5qOXoSrQRuIZE/R9tS.v0PZKVS1ApyvDtYfwCWdWC', 'xjdjjsjsks', 'hsusjjsjs', '267676767', 'jwwqws@ndjdjd.it', '', 0, 'a2f53af8322a1563914c6ddaf8aff3133e1e9a57', 1, 0),
265 + (329, 'wqfqwfwqfsjs', '$2y$10$E1zJX4HhZMdyuUpGwmOl.um3nFVgsW4yIAJsPCmWJhyPodun5w5we', 'xjdjjsjsks', 'hsusjjsjs', '267676767', 'jwwqs@ndjdjd.it', '', 0, '43d190cdcdb674c09cdf671c99eef5948eb06b56', 1, 0),
266 + (330, 'wqafqwfwqfsjs', '$2y$10$jGuWKWbQpPFD59mEE2REFOEbfmqlxuu1NJZzEmeX5mZ2/CQtT40JW', 'xjdjjsjsks', 'hsusjjsjs', '267676767', 'jwwaqs@ndjdjd.it', '', 0, '6b776758caf090a6e9dd389254c6171013d8aab1', 1, 0),
267 + (331, 'wqaafqwfwqfsjs', '$2y$10$GU.TVmx7lnDVIBsE/0VM4eHcYtDJbbXD1tRUyd22MZ9ApIAncOgny', 'xjdjjsjsks', 'hsusjjsjs', '267676767', 'jwwaqas@ndjdjd.it', '', 0, '7712dc13d62abdfda20303cdf3ac64a692e1954c', 1, 0),
268 + (332, 'wasdqwfwqfsjs', '$2y$10$0UMXEeVSEtL9/hHDotmGgOjSc3kOoydQSosPpv2Ew../O8r1IxBjC', 'xjdjjsjsks', 'hsusjjsjs', '267676767', 'dsaqas@ndjdjd.it', '', 0, '2b28ed9ccdd3b519c1ee53b42b7ff0f7dae61276', 1, 0),
269 + (333, 'NextrekCaffe', '$2y$10$8uK3Ni2N.WgLW5vgDHfmmeHBhBhXWHmEFPxtDKguso5PDwJalH0KG', 'Fabio', 'Massimo', '55556512', 'nextrek@nextrek.net', '55e8116d58740.jpeg', 1, '19f6553cbd798eb9c9ddb707f8d4062c8f955904', 1, 0);
69 270
70 271 --
71 - -- Dump dei dati per la tabella `locale`
272 + -- Indexes for dumped tables
72 273 --
73 274
74 - INSERT INTO `locale` (`id`, `id_utente_owner`, `nomelocale`, `descrizione`, `tipologia`, `lat`, `lon`, `indirizzo`, `email`, `telefono`, `sito`, `n_punti_ricarica`) VALUES
75 - (76, 127, 'luigi', 'jdjdjdjdjd', 7, 0, 0, '', 'kfksksks@.dududj', '4694944', 'jfjdd.it', 0),
76 - (77, 128, 'dnhdjdud', 'dhdhhdhdd', 0, 0, 0, '', 'dhddjdhdh@55555.', '454224', 'dhdhdhhd', 0),
77 - (78, 130, 'bbbbbb', 'sbhshshjsj', 0, 0, 0, '', 'ndjskeke@.', '', 'hshshsjjs.itsbbsh', 0),
78 - (79, 131, 'buona la pizza', 'dhjdjdjdjdjdxdnsjjx pizza buona con il sugo', 3, 39.9019341, 18.2618805, 'labico', 'dhdhdhdhhd@.dud', '466464', 'hdhdjxjxjx.pizza', 0),
79 - (80, 132, 'pjdndjd', 'dydhdhdjudud', 7, 39.9019705, 18.2618546, 'Genazzano', 'xxhuxjs.it@', '', 'dhshshsh.it', 0),
80 - (81, 132, 'Federico pizza', 'Bella LA pizza', 3, 0, 0, '', 'jdjdks@.iy', '646464', 'hxjsjeidie@.', 0),
81 - (82, 132, 'vvubuhiu', 'vhvububuh', 0, 0, 0, '', 'jvjvu@,.', '5', 'jvhvuguh', 0),
82 - (83, 136, 'localevvvvvv blu', 'ci piace molto il blu', 0, 45.943161, 24.96676, 'romania', 'scanafei@gnail.com', '32656464646464', 'blue.it', 0),
83 - (84, 136, 'jvibihi', 'jdjdjdjdodiif', 1, 45.6323582, 8.1219977, 'romanina', 'fjbidbidb@.', '', 'www.google.it', 0),
84 - (85, 136, 'giallooo', 'lovvvvvvv', 0, 41.8383438, 12.888712, 'Palestrina', 'ndksk@.', '7554542', 'giallo.it', 0),
85 - (86, 136, 'locale nero', 'nero', 0, 51.165691, 10.451526, 'Germania', 'dhdhdhdj@.', '464643', 'hdhdhdjsj.it', 0),
86 - (87, 140, 'fede ', 'fedefededefedefe', 0, 41.741883, 12.9118412, 'artena', 'scanapoi@.', '65355', 'fede.it', 0),
87 - (88, 140, 'rico', 'ricordi o', 4, 40.463667, -3.74922, 'spagna', 'hdhdjsjei@.', '6565', 'fhjdjdjd@.it', 0),
88 - (89, 144, 'ciao', 'ciao', 0, 43.7710513, 11.2486208, 'toscana', 'ciao@ciao.', '5965646464', 'ciao.it', 0),
89 - (90, 146, 'jdjdud', 'dyydys', 0, 44.0678288, 12.5695158, 'rimini', 'shshhshs@.', '', 'dyydud', 0),
90 - (91, 148, 'Nextrek ', 'Ciao c\nCiaooa\nEjshlgdykegkdgdkkgdkgdgekkgdkgekegkgekgekegkgdkgdkgdkdgkgdhkrkrhlhrkhrlhroyryoryororuuorohrkhrohrhrohorhroohrlhrlhrhlrkhrkhrohrohrhroohrhrohor', 10, 41.8846233, 12.5747576, 'via del Pergolato 18', 'MhzDev@gmail.com ', '333222558', 'www.nextrek.net', 0),
91 - (92, 148, 'Hhu', 'Utjffjjfjfjfjfjfjfjgjg', 3, 41.9078795, 12.4776937, 'via del corso 45 roma', 'Ffggh@fgh.iy', '5566', 'Gghuuu', 0),
92 - (93, 152, 'Da Ciccio', 'Da Ciccio', 3, 0, 0, '', 'info@daciccio.it', '333333334', 'www.daciccio.it', 5),
93 - (94, 162, 'locale ', 'Descrizione ', 4, 0, 0, '', 'strizzi@gmail.com', '333665896', 'sito', 0);
275 + --
276 + -- Indexes for table `commenti`
277 + --
278 + ALTER TABLE `commenti`
279 + ADD PRIMARY KEY (`id`), ADD KEY `id_locale` (`id_locale`), ADD KEY `id_user` (`id_user`), ADD KEY `id_locale_2` (`id_locale`);
94 280
95 281 --
96 - -- Dump dei dati per la tabella `commenti`
282 + -- Indexes for table `immagini_commenti`
97 283 --
284 + ALTER TABLE `immagini_commenti`
285 + ADD KEY `id_commento` (`id_commento`);
98 286
99 - INSERT INTO `commenti` (`id`, `id_locale`, `id_user`, `voto`, `descrizione`, `data`) VALUES
100 - (13, 83, 136, 4, 'ydyxychxhdh', '2015-08-22 14:53:18'),
101 - (14, 87, 140, 3, 'bel negozio', '2015-08-24 23:22:29'),
102 - (15, 85, 142, 0, 'test', '2015-08-25 10:46:37'),
103 - (17, 91, 148, 0, 'MADO PROPRIO BELLO', '2015-08-25 12:50:42'),
104 - (18, 91, 141, 0, 'Ho perso 5 euro', '2015-08-25 14:49:03'),
105 - (20, 91, 141, 5, 'Sono guarito dal raffreddore in questo locale miracoloso', '2015-08-25 15:07:30'),
106 - (21, 91, 148, 0, 'Fighissimo\n ', '2015-08-25 17:44:54'),
107 - (22, 91, 148, 0, '', '2015-08-26 09:56:37'),
108 - (23, 91, 148, 0, '', '2015-08-26 10:04:46');
287 + --
288 + -- Indexes for table `immagini_locali`
289 + --
290 + ALTER TABLE `immagini_locali`
291 + ADD KEY `id_locale` (`id_locale`);
109 292
110 293 --
111 - -- Dump dei dati per la tabella `immagini_commenti`
294 + -- Indexes for table `locale`
112 295 --
296 + ALTER TABLE `locale`
297 + ADD PRIMARY KEY (`id`), ADD KEY `id_utente_owner` (`id_utente_owner`), ADD KEY `tipologia` (`tipologia`), ADD KEY `tipologia_2` (`tipologia`);
113 298
114 - INSERT INTO `immagini_commenti` (`id_commento`, `img`) VALUES
115 - (13, '55d870bca5b37.jpeg'),
116 - (14, '55db8b0b704b9.jpeg'),
117 - (15, '55dc2b5e22180.jpeg'),
118 - (18, '55dc6423433be.jpeg'),
119 - (18, '55dc643e4c884.jpeg');
299 + --
300 + -- Indexes for table `tipologie`
301 + --
302 + ALTER TABLE `tipologie`
303 + ADD PRIMARY KEY (`id`);
120 304
121 305 --
122 - -- Dump dei dati per la tabella `immagini_locali`
306 + -- Indexes for table `utente`
123 307 --
308 + ALTER TABLE `utente`
309 + ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `email` (`email`), ADD KEY `token` (`token`), ADD KEY `email_2` (`email`);
124 310
125 - INSERT INTO `immagini_locali` (`id_locale`, `img`) VALUES
126 - (76, '55d5de7496342.jpeg'),
127 - (77, '55d5deac03197.jpeg'),
128 - (78, '55d5df866e634.jpeg'),
129 - (79, '55d5e49881390.jpeg'),
130 - (80, '55d5e4f62123e.jpeg'),
131 - (81, '55d835e64e338.jpeg'),
132 - (83, '55d838b8c0a46.jpeg'),
133 - (86, '55d83d6b1efe9.jpeg'),
134 - (83, '55db742a8b3c8.jpeg'),
135 - (83, '55db74761312d.jpeg'),
136 - (85, '55db756098968.jpeg'),
137 - (85, '55db7573dd40a.jpeg'),
138 - (85, '55db75981cd94.jpeg'),
139 - (87, '55db8abba2d70.jpeg'),
140 - (88, '55dc0aae67f35.jpeg'),
141 - (89, '55dc3aeeefd95.jpeg'),
142 - (91, '55dc48124190a.jpeg'),
143 - (91, '55dc48295c079.jpeg');
311 + --
312 + -- AUTO_INCREMENT for dumped tables
313 + --
314 +
315 + --
316 + -- AUTO_INCREMENT for table `commenti`
317 + --
318 + ALTER TABLE `commenti`
319 + MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=70;
320 + --
321 + -- AUTO_INCREMENT for table `locale`
322 + --
323 + ALTER TABLE `locale`
324 + MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=134;
325 + --
326 + -- AUTO_INCREMENT for table `utente`
327 + --
328 + ALTER TABLE `utente`
329 + MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=334;
330 + --
331 + -- Limiti per le tabelle scaricate
332 + --
333 +
334 + --
335 + -- Limiti per la tabella `commenti`
336 + --
337 + ALTER TABLE `commenti`
338 + ADD CONSTRAINT `commenti_ibfk_1` FOREIGN KEY (`id_locale`) REFERENCES `locale` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
339 + ADD CONSTRAINT `commenti_ibfk_2` FOREIGN KEY (`id_user`) REFERENCES `utente` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
340 +
341 + --
342 + -- Limiti per la tabella `immagini_commenti`
343 + --
344 + ALTER TABLE `immagini_commenti`
345 + ADD CONSTRAINT `immagini_commenti_ibfk_1` FOREIGN KEY (`id_commento`) REFERENCES `commenti` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
346 +
347 + --
348 + -- Limiti per la tabella `immagini_locali`
349 + --
350 + ALTER TABLE `immagini_locali`
351 + ADD CONSTRAINT `immagini_locali_ibfk_1` FOREIGN KEY (`id_locale`) REFERENCES `locale` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
352 +
353 + --
354 + -- Limiti per la tabella `locale`
355 + --
356 + ALTER TABLE `locale`
357 + ADD CONSTRAINT `locale_ibfk_1` FOREIGN KEY (`id_utente_owner`) REFERENCES `utente` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
358 + ADD CONSTRAINT `locale_ibfk_2` FOREIGN KEY (`tipologia`) REFERENCES `tipologie` (`id`) ON UPDATE CASCADE;
144 359
145 360 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
146 361 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

View View this file contents

History View the full history

Feeds

Commits for /Android/SmartCharging/endPoints/smartcharging_data.sql

Need assistance?   Get in touch, or head to our documentation site.