Nextrek
Subversion Repository Public Repository

Nextrek

URLs

Copy to Clipboard
Explore
Commits

Diff Revisions 612 vs 678 for /Android/SmartCharging/endPoints/smartcharging.sql

Diff revisions: vs.
  @@ -1,11 +1,11 @@
1 1 -- phpMyAdmin SQL Dump
2 - -- version 4.2.7.1
2 + -- version 4.3.11
3 3 -- http://www.phpmyadmin.net
4 4 --
5 5 -- Host: 127.0.0.1
6 - -- Generation Time: Ago 31, 2015 alle 10:35
7 - -- Versione del server: 5.6.20
8 - -- PHP Version: 5.5.15
6 + -- Generation Time: Set 03, 2015 alle 12:03
7 + -- Versione del server: 5.6.24
8 + -- PHP Version: 5.6.8
9 9
10 10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11 11 SET time_zone = "+00:00";
  @@ -27,13 +27,13 @@
27 27 --
28 28
29 29 CREATE TABLE IF NOT EXISTS `commenti` (
30 - `id` int(11) NOT NULL,
30 + `id` int(11) NOT NULL,
31 31 `id_locale` int(11) NOT NULL,
32 32 `id_user` int(11) DEFAULT NULL,
33 33 `voto` int(11) NOT NULL,
34 - `descrizione` varchar(255) NOT NULL,
34 + `descrizione` varchar(255) CHARACTER SET latin1 NOT NULL,
35 35 `data` datetime NOT NULL
36 - ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;
36 + ) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;
37 37
38 38 -- --------------------------------------------------------
39 39
  @@ -43,8 +43,8 @@
43 43
44 44 CREATE TABLE IF NOT EXISTS `immagini_commenti` (
45 45 `id_commento` int(11) NOT NULL,
46 - `img` varchar(255) NOT NULL
47 - ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
46 + `img` varchar(255) CHARACTER SET latin1 NOT NULL
47 + ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
48 48
49 49 -- --------------------------------------------------------
50 50
  @@ -54,8 +54,8 @@
54 54
55 55 CREATE TABLE IF NOT EXISTS `immagini_locali` (
56 56 `id_locale` int(11) NOT NULL,
57 - `img` varchar(255) NOT NULL
58 - ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
57 + `img` varchar(255) CHARACTER SET latin1 NOT NULL
58 + ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
59 59
60 60 -- --------------------------------------------------------
61 61
  @@ -64,20 +64,20 @@
64 64 --
65 65
66 66 CREATE TABLE IF NOT EXISTS `locale` (
67 - `id` int(11) NOT NULL,
67 + `id` int(11) NOT NULL,
68 68 `id_utente_owner` int(11) NOT NULL,
69 - `nomelocale` varchar(255) NOT NULL,
70 - `descrizione` varchar(255) NOT NULL,
69 + `nomelocale` varchar(255) CHARACTER SET latin1 NOT NULL,
70 + `descrizione` varchar(255) CHARACTER SET latin1 NOT NULL,
71 71 `tipologia` int(11) NOT NULL,
72 72 `lat` double DEFAULT NULL,
73 73 `lon` double DEFAULT NULL,
74 - `indirizzo` varchar(255) DEFAULT NULL,
75 - `email` varchar(255) NOT NULL,
76 - `telefono` varchar(255) NOT NULL,
77 - `sito` varchar(255) NOT NULL,
74 + `indirizzo` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
75 + `email` varchar(255) CHARACTER SET latin1 NOT NULL,
76 + `telefono` varchar(255) CHARACTER SET latin1 NOT NULL,
77 + `sito` varchar(255) CHARACTER SET latin1 NOT NULL,
78 78 `n_punti_ricarica` int(11) NOT NULL DEFAULT '0',
79 79 `hidden` int(11) NOT NULL DEFAULT '0'
80 - ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=95 ;
80 + ) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=utf8;
81 81
82 82 -- --------------------------------------------------------
83 83
  @@ -87,8 +87,8 @@
87 87
88 88 CREATE TABLE IF NOT EXISTS `tipologie` (
89 89 `id` int(11) NOT NULL,
90 - `tipologia` varchar(255) NOT NULL
91 - ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
90 + `tipologia` varchar(255) CHARACTER SET latin1 NOT NULL
91 + ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
92 92
93 93 -- --------------------------------------------------------
94 94
  @@ -97,19 +97,19 @@
97 97 --
98 98
99 99 CREATE TABLE IF NOT EXISTS `utente` (
100 - `id` int(11) NOT NULL,
101 - `username` varchar(255) NOT NULL,
102 - `password` varchar(255) NOT NULL,
103 - `nome` varchar(255) NOT NULL,
104 - `cognome` varchar(255) NOT NULL,
105 - `cell` varchar(255) NOT NULL,
106 - `email` varchar(255) NOT NULL,
107 - `avatar` varchar(255) NOT NULL,
100 + `id` int(11) NOT NULL,
101 + `username` varchar(255) CHARACTER SET latin1 NOT NULL,
102 + `password` varchar(255) CHARACTER SET latin1 NOT NULL,
103 + `nome` varchar(255) CHARACTER SET latin1 NOT NULL,
104 + `cognome` varchar(255) CHARACTER SET latin1 NOT NULL,
105 + `cell` varchar(255) CHARACTER SET latin1 NOT NULL,
106 + `email` varchar(255) CHARACTER SET latin1 NOT NULL,
107 + `avatar` varchar(255) CHARACTER SET latin1 NOT NULL,
108 108 `is_owner` int(11) NOT NULL DEFAULT '0',
109 - `token` varchar(255) DEFAULT NULL,
109 + `token` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
110 110 `is_active` int(11) NOT NULL DEFAULT '1',
111 111 `is_admin` int(11) NOT NULL DEFAULT '0'
112 - ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=205 ;
112 + ) ENGINE=InnoDB AUTO_INCREMENT=334 DEFAULT CHARSET=utf8;
113 113
114 114 --
115 115 -- Indexes for dumped tables
  @@ -119,37 +119,37 @@
119 119 -- Indexes for table `commenti`
120 120 --
121 121 ALTER TABLE `commenti`
122 - ADD PRIMARY KEY (`id`), ADD KEY `id_locale` (`id_locale`), ADD KEY `id_user` (`id_user`), ADD KEY `id_locale_2` (`id_locale`);
122 + ADD PRIMARY KEY (`id`), ADD KEY `id_locale` (`id_locale`), ADD KEY `id_user` (`id_user`), ADD KEY `id_locale_2` (`id_locale`);
123 123
124 124 --
125 125 -- Indexes for table `immagini_commenti`
126 126 --
127 127 ALTER TABLE `immagini_commenti`
128 - ADD KEY `id_commento` (`id_commento`);
128 + ADD KEY `id_commento` (`id_commento`);
129 129
130 130 --
131 131 -- Indexes for table `immagini_locali`
132 132 --
133 133 ALTER TABLE `immagini_locali`
134 - ADD KEY `id_locale` (`id_locale`);
134 + ADD KEY `id_locale` (`id_locale`);
135 135
136 136 --
137 137 -- Indexes for table `locale`
138 138 --
139 139 ALTER TABLE `locale`
140 - ADD PRIMARY KEY (`id`), ADD KEY `id_utente_owner` (`id_utente_owner`), ADD KEY `tipologia` (`tipologia`);
140 + ADD PRIMARY KEY (`id`), ADD KEY `id_utente_owner` (`id_utente_owner`), ADD KEY `tipologia` (`tipologia`), ADD KEY `tipologia_2` (`tipologia`);
141 141
142 142 --
143 143 -- Indexes for table `tipologie`
144 144 --
145 145 ALTER TABLE `tipologie`
146 - ADD PRIMARY KEY (`id`);
146 + ADD PRIMARY KEY (`id`);
147 147
148 148 --
149 149 -- Indexes for table `utente`
150 150 --
151 151 ALTER TABLE `utente`
152 - ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `email` (`email`), ADD KEY `token` (`token`), ADD KEY `email_2` (`email`);
152 + ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `email` (`email`), ADD KEY `token` (`token`), ADD KEY `email_2` (`email`);
153 153
154 154 --
155 155 -- AUTO_INCREMENT for dumped tables
  @@ -159,17 +159,17 @@
159 159 -- AUTO_INCREMENT for table `commenti`
160 160 --
161 161 ALTER TABLE `commenti`
162 - MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=24;
162 + MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=70;
163 163 --
164 164 -- AUTO_INCREMENT for table `locale`
165 165 --
166 166 ALTER TABLE `locale`
167 - MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=95;
167 + MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=134;
168 168 --
169 169 -- AUTO_INCREMENT for table `utente`
170 170 --
171 171 ALTER TABLE `utente`
172 - MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=205;
172 + MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=334;
173 173 --
174 174 -- Limiti per le tabelle scaricate
175 175 --
  @@ -198,7 +198,7 @@
198 198 --
199 199 ALTER TABLE `locale`
200 200 ADD CONSTRAINT `locale_ibfk_1` FOREIGN KEY (`id_utente_owner`) REFERENCES `utente` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
201 - ADD CONSTRAINT `locale_ibfk_2` FOREIGN KEY (`tipologia`) REFERENCES `tipologie` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
201 + ADD CONSTRAINT `locale_ibfk_2` FOREIGN KEY (`tipologia`) REFERENCES `tipologie` (`id`) ON UPDATE CASCADE;
202 202
203 203 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
204 204 /*!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.sql

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