Nextrek
Diff Revisions
406
vs
415
for /Android/SmartCharging/endPoints/nightly/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 20, 2015 alle 17:57 |
|
6 |
+ |
-- Generation Time: Lug 22, 2015 alle 10:21 |
7 |
7 |
|
-- Versione del server: 5.6.20 |
8 |
8 |
|
-- PHP Version: 5.5.15 |
9 |
9 |
|
|
|
@@ -88,8 +88,8 @@ |
88 |
88 |
|
`cell` varchar(255) NOT NULL, |
89 |
89 |
|
`email` varchar(255) NOT NULL, |
90 |
90 |
|
`avatar` varchar(255) NOT NULL, |
91 |
|
- |
`is_owner` tinyint(1) NOT NULL |
92 |
|
- |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ; |
|
91 |
+ |
`token` varchar(255) DEFAULT NULL |
|
92 |
+ |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ; |
93 |
93 |
|
|
94 |
94 |
|
-- |
95 |
95 |
|
-- Indexes for dumped tables |
|
@@ -123,7 +123,7 @@ |
123 |
123 |
|
-- Indexes for table `utente` |
124 |
124 |
|
-- |
125 |
125 |
|
ALTER TABLE `utente` |
126 |
|
- |
ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `email` (`email`); |
|
126 |
+ |
ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `email` (`email`), ADD KEY `token` (`token`); |
127 |
127 |
|
|
128 |
128 |
|
-- |
129 |
129 |
|
-- AUTO_INCREMENT for dumped tables |
|
@@ -143,7 +143,7 @@ |
143 |
143 |
|
-- AUTO_INCREMENT for table `utente` |
144 |
144 |
|
-- |
145 |
145 |
|
ALTER TABLE `utente` |
146 |
|
- |
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=33; |
|
146 |
+ |
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=34; |
147 |
147 |
|
-- |
148 |
148 |
|
-- Limiti per le tabelle scaricate |
149 |
149 |
|
-- |