| |
@@ -3,7 +3,7 @@ |
| 3 |
3 |
|
-- http://www.phpmyadmin.net |
| 4 |
4 |
|
-- |
| 5 |
5 |
|
-- Host: 127.0.0.1 |
| 6 |
|
- |
-- Generation Time: Lug 08, 2015 alle 09:35 |
| |
6 |
+ |
-- Generation Time: Lug 09, 2015 alle 08:59 |
| 7 |
7 |
|
-- Versione del server: 5.6.20 |
| 8 |
8 |
|
-- PHP Version: 5.5.15 |
| 9 |
9 |
|
|
| |
@@ -32,28 +32,43 @@ |
| 32 |
32 |
|
`id_user` int(11) NOT NULL, |
| 33 |
33 |
|
`voto` int(11) NOT NULL, |
| 34 |
34 |
|
`descrizione` varchar(255) NOT NULL, |
| 35 |
|
- |
`data` date NOT NULL, |
| 36 |
|
- |
`img` varchar(255) NOT NULL |
| |
35 |
+ |
`data` date NOT NULL |
| 37 |
36 |
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| 38 |
37 |
|
|
| 39 |
38 |
|
-- -------------------------------------------------------- |
| 40 |
39 |
|
|
| 41 |
40 |
|
-- |
| |
41 |
+ |
-- Struttura della tabella `immagini_commenti` |
| |
42 |
+ |
-- |
| |
43 |
+ |
|
| |
44 |
+ |
CREATE TABLE IF NOT EXISTS `immagini_commenti` ( |
| |
45 |
+ |
`id_commento` int(11) NOT NULL, |
| |
46 |
+ |
`img` varchar(255) NOT NULL |
| |
47 |
+ |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| |
48 |
+ |
|
| |
49 |
+ |
-- -------------------------------------------------------- |
| |
50 |
+ |
|
| |
51 |
+ |
-- |
| |
52 |
+ |
-- Struttura della tabella `immagini_locali` |
| |
53 |
+ |
-- |
| |
54 |
+ |
|
| |
55 |
+ |
CREATE TABLE IF NOT EXISTS `immagini_locali` ( |
| |
56 |
+ |
`id_locale` int(11) NOT NULL, |
| |
57 |
+ |
`img` varchar(255) NOT NULL |
| |
58 |
+ |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| |
59 |
+ |
|
| |
60 |
+ |
-- -------------------------------------------------------- |
| |
61 |
+ |
|
| |
62 |
+ |
-- |
| 42 |
63 |
|
-- Struttura della tabella `locale` |
| 43 |
64 |
|
-- |
| 44 |
65 |
|
|
| 45 |
66 |
|
CREATE TABLE IF NOT EXISTS `locale` ( |
| 46 |
67 |
|
`id` int(11) NOT NULL, |
| |
68 |
+ |
`id_utente_owner` int(11) NOT NULL, |
| 47 |
69 |
|
`nominativo` varchar(255) NOT NULL, |
| 48 |
|
- |
`cell` varchar(255) NOT NULL, |
| 49 |
|
- |
`email` varchar(255) NOT NULL, |
| 50 |
|
- |
`nomelocale` varchar(255) NOT NULL, |
| 51 |
70 |
|
`descrizione` varchar(255) NOT NULL, |
| 52 |
71 |
|
`tipologia` int(11) NOT NULL, |
| 53 |
|
- |
`img1` varchar(255) NOT NULL, |
| 54 |
|
- |
`img2` varchar(255) NOT NULL, |
| 55 |
|
- |
`username` varchar(255) NOT NULL, |
| 56 |
|
- |
`password` varchar(255) NOT NULL, |
| 57 |
72 |
|
`lat` double DEFAULT NULL, |
| 58 |
73 |
|
`lon` double DEFAULT NULL |
| 59 |
74 |
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; |
| |
@@ -71,7 +86,8 @@ |
| 71 |
86 |
|
`nominativo` varchar(255) NOT NULL, |
| 72 |
87 |
|
`cell` varchar(255) NOT NULL, |
| 73 |
88 |
|
`email` varchar(255) NOT NULL, |
| 74 |
|
- |
`img` varchar(255) NOT NULL |
| |
89 |
+ |
`avatar` varchar(255) NOT NULL, |
| |
90 |
+ |
`is_owner` tinyint(1) NOT NULL |
| 75 |
91 |
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ; |
| 76 |
92 |
|
|
| 77 |
93 |
|
-- |
| |
@@ -85,10 +101,22 @@ |
| 85 |
101 |
|
ADD PRIMARY KEY (`id`), ADD KEY `id_locale` (`id_locale`), ADD KEY `id_user` (`id_user`), ADD KEY `id_locale_2` (`id_locale`); |
| 86 |
102 |
|
|
| 87 |
103 |
|
-- |
| |
104 |
+ |
-- Indexes for table `immagini_commenti` |
| |
105 |
+ |
-- |
| |
106 |
+ |
ALTER TABLE `immagini_commenti` |
| |
107 |
+ |
ADD KEY `id_commento` (`id_commento`); |
| |
108 |
+ |
|
| |
109 |
+ |
-- |
| |
110 |
+ |
-- Indexes for table `immagini_locali` |
| |
111 |
+ |
-- |
| |
112 |
+ |
ALTER TABLE `immagini_locali` |
| |
113 |
+ |
ADD KEY `id_locale` (`id_locale`); |
| |
114 |
+ |
|
| |
115 |
+ |
-- |
| 88 |
116 |
|
-- Indexes for table `locale` |
| 89 |
117 |
|
-- |
| 90 |
118 |
|
ALTER TABLE `locale` |
| 91 |
|
- |
ADD PRIMARY KEY (`id`); |
| |
119 |
+ |
ADD PRIMARY KEY (`id`), ADD KEY `id_utente_owner` (`id_utente_owner`); |
| 92 |
120 |
|
|
| 93 |
121 |
|
-- |
| 94 |
122 |
|
-- Indexes for table `utente` |
| |
@@ -126,6 +154,24 @@ |
| 126 |
154 |
|
ADD CONSTRAINT `commenti_ibfk_1` FOREIGN KEY (`id_locale`) REFERENCES `locale` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, |
| 127 |
155 |
|
ADD CONSTRAINT `commenti_ibfk_2` FOREIGN KEY (`id_user`) REFERENCES `utente` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; |
| 128 |
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 NO ACTION ON UPDATE NO ACTION; |
| |
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 NO ACTION ON UPDATE NO ACTION; |
| |
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 NO ACTION ON UPDATE NO ACTION; |
| |
174 |
+ |
|
| 129 |
175 |
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
| 130 |
176 |
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
| 131 |
177 |
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
View this file contents
View the full history
Commits for