Nextrek
Diff Revisions
235
vs
237
for /Android/SmartCharging/endPoints/smartcharging.sql
|
@@ -3,7 +3,7 @@ |
3 |
3 |
|
-- http://www.phpmyadmin.net |
4 |
4 |
|
-- |
5 |
5 |
|
-- Host: 127.0.0.1 |
6 |
|
- |
-- Generation Time: Lug 09, 2015 alle 10:51 |
|
6 |
+ |
-- Generation Time: Lug 09, 2015 alle 11:03 |
7 |
7 |
|
-- Versione del server: 5.6.20 |
8 |
8 |
|
-- PHP Version: 5.5.15 |
9 |
9 |
|
|
|
@@ -29,7 +29,7 @@ |
29 |
29 |
|
CREATE TABLE IF NOT EXISTS `commenti` ( |
30 |
30 |
|
`id` int(11) NOT NULL, |
31 |
31 |
|
`id_locale` int(11) NOT NULL, |
32 |
|
- |
`id_user` int(11) NOT NULL, |
|
32 |
+ |
`id_user` int(11) DEFAULT NULL, |
33 |
33 |
|
`voto` int(11) NOT NULL, |
34 |
34 |
|
`descrizione` varchar(255) NOT NULL, |
35 |
35 |
|
`data` date NOT NULL |
|
@@ -143,6 +143,35 @@ |
143 |
143 |
|
-- |
144 |
144 |
|
ALTER TABLE `utente` |
145 |
145 |
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5; |
|
146 |
+ |
-- |
|
147 |
+ |
-- Limiti per le tabelle scaricate |
|
148 |
+ |
-- |
|
149 |
+ |
|
|
150 |
+ |
-- |
|
151 |
+ |
-- Limiti per la tabella `commenti` |
|
152 |
+ |
-- |
|
153 |
+ |
ALTER TABLE `commenti` |
|
154 |
+ |
ADD CONSTRAINT `commenti_ibfk_1` FOREIGN KEY (`id_locale`) REFERENCES `locale` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
155 |
+ |
ADD CONSTRAINT `commenti_ibfk_2` FOREIGN KEY (`id_user`) REFERENCES `utente` (`id`) ON DELETE SET NULL ON UPDATE CASCADE; |
|
156 |
+ |
|
|
157 |
+ |
-- |
|
158 |
+ |
-- Limiti per la tabella `immagini_commenti` |
|
159 |
+ |
-- |
|
160 |
+ |
ALTER TABLE `immagini_commenti` |
|
161 |
+ |
ADD CONSTRAINT `immagini_commenti_ibfk_1` FOREIGN KEY (`id_commento`) REFERENCES `commenti` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; |
|
162 |
+ |
|
|
163 |
+ |
-- |
|
164 |
+ |
-- Limiti per la tabella `immagini_locali` |
|
165 |
+ |
-- |
|
166 |
+ |
ALTER TABLE `immagini_locali` |
|
167 |
+ |
ADD CONSTRAINT `immagini_locali_ibfk_1` FOREIGN KEY (`id_locale`) REFERENCES `locale` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; |
|
168 |
+ |
|
|
169 |
+ |
-- |
|
170 |
+ |
-- Limiti per la tabella `locale` |
|
171 |
+ |
-- |
|
172 |
+ |
ALTER TABLE `locale` |
|
173 |
+ |
ADD CONSTRAINT `locale_ibfk_1` FOREIGN KEY (`id_utente_owner`) REFERENCES `utente` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; |
|
174 |
+ |
|
146 |
175 |
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
147 |
176 |
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
148 |
177 |
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |