|
@@ -1,11 +1,11 @@ |
1 |
1 |
|
-- phpMyAdmin SQL Dump |
2 |
|
- |
-- version 4.1.6 |
|
2 |
+ |
-- version 4.2.7.1 |
3 |
3 |
|
-- http://www.phpmyadmin.net |
4 |
4 |
|
-- |
5 |
|
- |
-- Host: localhost |
6 |
|
- |
-- Generation Time: Lug 06, 2015 alle 15:35 |
7 |
|
- |
-- Versione del server: 5.6.16 |
8 |
|
- |
-- PHP Version: 5.5.9 |
|
5 |
+ |
-- Host: 127.0.0.1 |
|
6 |
+ |
-- Generation Time: Lug 08, 2015 alle 09:35 |
|
7 |
+ |
-- Versione del server: 5.6.20 |
|
8 |
+ |
-- PHP Version: 5.5.15 |
9 |
9 |
|
|
10 |
10 |
|
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; |
11 |
11 |
|
SET time_zone = "+00:00"; |
|
@@ -27,17 +27,13 @@ |
27 |
27 |
|
-- |
28 |
28 |
|
|
29 |
29 |
|
CREATE TABLE IF NOT EXISTS `commenti` ( |
30 |
|
- |
`id` int(11) NOT NULL AUTO_INCREMENT, |
|
30 |
+ |
`id` int(11) NOT NULL, |
31 |
31 |
|
`id_locale` int(11) NOT NULL, |
32 |
32 |
|
`id_user` int(11) NOT NULL, |
33 |
33 |
|
`voto` int(11) NOT NULL, |
34 |
34 |
|
`descrizione` varchar(255) NOT NULL, |
35 |
35 |
|
`data` date NOT NULL, |
36 |
|
- |
`img` varchar(255) NOT NULL, |
37 |
|
- |
PRIMARY KEY (`id`), |
38 |
|
- |
KEY `id_locale` (`id_locale`), |
39 |
|
- |
KEY `id_user` (`id_user`), |
40 |
|
- |
KEY `id_locale_2` (`id_locale`) |
|
36 |
+ |
`img` varchar(255) NOT NULL |
41 |
37 |
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
42 |
38 |
|
|
43 |
39 |
|
-- -------------------------------------------------------- |
|
@@ -47,7 +43,7 @@ |
47 |
43 |
|
-- |
48 |
44 |
|
|
49 |
45 |
|
CREATE TABLE IF NOT EXISTS `locale` ( |
50 |
|
- |
`id` int(11) NOT NULL AUTO_INCREMENT, |
|
46 |
+ |
`id` int(11) NOT NULL, |
51 |
47 |
|
`nominativo` varchar(255) NOT NULL, |
52 |
48 |
|
`cell` varchar(255) NOT NULL, |
53 |
49 |
|
`email` varchar(255) NOT NULL, |
|
@@ -58,10 +54,9 @@ |
58 |
54 |
|
`img2` varchar(255) NOT NULL, |
59 |
55 |
|
`username` varchar(255) NOT NULL, |
60 |
56 |
|
`password` varchar(255) NOT NULL, |
61 |
|
- |
`lat` float DEFAULT NULL, |
62 |
|
- |
`lon` float DEFAULT NULL, |
63 |
|
- |
PRIMARY KEY (`id`) |
64 |
|
- |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
|
57 |
+ |
`lat` double DEFAULT NULL, |
|
58 |
+ |
`lon` double DEFAULT NULL |
|
59 |
+ |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; |
65 |
60 |
|
|
66 |
61 |
|
-- -------------------------------------------------------- |
67 |
62 |
|
|
|
@@ -70,17 +65,57 @@ |
70 |
65 |
|
-- |
71 |
66 |
|
|
72 |
67 |
|
CREATE TABLE IF NOT EXISTS `utente` ( |
73 |
|
- |
`id` int(11) NOT NULL AUTO_INCREMENT, |
|
68 |
+ |
`id` int(11) NOT NULL, |
74 |
69 |
|
`username` varchar(255) NOT NULL, |
75 |
70 |
|
`password` varchar(255) NOT NULL, |
76 |
71 |
|
`nominativo` varchar(255) NOT NULL, |
77 |
72 |
|
`cell` varchar(255) NOT NULL, |
78 |
73 |
|
`email` varchar(255) NOT NULL, |
79 |
|
- |
`img` varchar(255) NOT NULL, |
80 |
|
- |
PRIMARY KEY (`id`) |
81 |
|
- |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
|
74 |
+ |
`img` varchar(255) NOT NULL |
|
75 |
+ |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ; |
82 |
76 |
|
|
83 |
77 |
|
-- |
|
78 |
+ |
-- Indexes for dumped tables |
|
79 |
+ |
-- |
|
80 |
+ |
|
|
81 |
+ |
-- |
|
82 |
+ |
-- Indexes for table `commenti` |
|
83 |
+ |
-- |
|
84 |
+ |
ALTER TABLE `commenti` |
|
85 |
+ |
ADD PRIMARY KEY (`id`), ADD KEY `id_locale` (`id_locale`), ADD KEY `id_user` (`id_user`), ADD KEY `id_locale_2` (`id_locale`); |
|
86 |
+ |
|
|
87 |
+ |
-- |
|
88 |
+ |
-- Indexes for table `locale` |
|
89 |
+ |
-- |
|
90 |
+ |
ALTER TABLE `locale` |
|
91 |
+ |
ADD PRIMARY KEY (`id`); |
|
92 |
+ |
|
|
93 |
+ |
-- |
|
94 |
+ |
-- Indexes for table `utente` |
|
95 |
+ |
-- |
|
96 |
+ |
ALTER TABLE `utente` |
|
97 |
+ |
ADD PRIMARY KEY (`id`); |
|
98 |
+ |
|
|
99 |
+ |
-- |
|
100 |
+ |
-- AUTO_INCREMENT for dumped tables |
|
101 |
+ |
-- |
|
102 |
+ |
|
|
103 |
+ |
-- |
|
104 |
+ |
-- AUTO_INCREMENT for table `commenti` |
|
105 |
+ |
-- |
|
106 |
+ |
ALTER TABLE `commenti` |
|
107 |
+ |
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; |
|
108 |
+ |
-- |
|
109 |
+ |
-- AUTO_INCREMENT for table `locale` |
|
110 |
+ |
-- |
|
111 |
+ |
ALTER TABLE `locale` |
|
112 |
+ |
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10; |
|
113 |
+ |
-- |
|
114 |
+ |
-- AUTO_INCREMENT for table `utente` |
|
115 |
+ |
-- |
|
116 |
+ |
ALTER TABLE `utente` |
|
117 |
+ |
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23; |
|
118 |
+ |
-- |
84 |
119 |
|
-- Limiti per le tabelle scaricate |
85 |
120 |
|
-- |
86 |
121 |
|
|
|
@@ -88,8 +123,8 @@ |
88 |
123 |
|
-- Limiti per la tabella `commenti` |
89 |
124 |
|
-- |
90 |
125 |
|
ALTER TABLE `commenti` |
91 |
|
- |
ADD CONSTRAINT `commenti_ibfk_2` FOREIGN KEY (`id_user`) REFERENCES `utente` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, |
92 |
|
- |
ADD CONSTRAINT `commenti_ibfk_1` FOREIGN KEY (`id_locale`) REFERENCES `locale` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; |
|
126 |
+ |
ADD CONSTRAINT `commenti_ibfk_1` FOREIGN KEY (`id_locale`) REFERENCES `locale` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, |
|
127 |
+ |
ADD CONSTRAINT `commenti_ibfk_2` FOREIGN KEY (`id_user`) REFERENCES `utente` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; |
93 |
128 |
|
|
94 |
129 |
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
95 |
130 |
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |