Nextrek
@ 224
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 |
-- phpMyAdmin SQL Dump -- version 4.2.7.1 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Lug 08, 2015 alle 09:35 -- Versione del server: 5.6.20 -- PHP Version: 5.5.15 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `smartcharging` -- -- -------------------------------------------------------- -- -- Struttura della tabella `commenti` -- CREATE TABLE IF NOT EXISTS `commenti` ( `id` int(11) NOT NULL, `id_locale` int(11) NOT NULL, `id_user` int(11) NOT NULL, `voto` int(11) NOT NULL, `descrizione` varchar(255) NOT NULL, `data` date NOT NULL, `img` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Struttura della tabella `locale` -- CREATE TABLE IF NOT EXISTS `locale` ( `id` int(11) NOT NULL, `nominativo` varchar(255) NOT NULL, `cell` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `nomelocale` varchar(255) NOT NULL, `descrizione` varchar(255) NOT NULL, `tipologia` int(11) NOT NULL, `img1` varchar(255) NOT NULL, `img2` varchar(255) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `lat` double DEFAULT NULL, `lon` double DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -------------------------------------------------------- -- -- Struttura della tabella `utente` -- CREATE TABLE IF NOT EXISTS `utente` ( `id` int(11) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `nominativo` varchar(255) NOT NULL, `cell` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `img` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ; -- -- Indexes for dumped tables -- -- -- Indexes for table `commenti` -- ALTER TABLE `commenti` ADD PRIMARY KEY (`id`), ADD KEY `id_locale` (`id_locale`), ADD KEY `id_user` (`id_user`), ADD KEY `id_locale_2` (`id_locale`); -- -- Indexes for table `locale` -- ALTER TABLE `locale` ADD PRIMARY KEY (`id`); -- -- Indexes for table `utente` -- ALTER TABLE `utente` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `commenti` -- ALTER TABLE `commenti` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `locale` -- ALTER TABLE `locale` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `utente` -- ALTER TABLE `utente` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23; -- -- Limiti per le tabelle scaricate -- -- -- Limiti per la tabella `commenti` -- ALTER TABLE `commenti` ADD CONSTRAINT `commenti_ibfk_1` FOREIGN KEY (`id_locale`) REFERENCES `locale` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `commenti_ibfk_2` FOREIGN KEY (`id_user`) REFERENCES `utente` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
Commits for Nextrek/Android/SmartCharging/endPoints/smartcharging.sql
Revision | Author | Commited | Message |
---|---|---|---|
224 Diff | FSallustio | Wed 08 Jul, 2015 07:36:39 +0000 | - Piccolo refactor (sia lato php che lato sql); |
218 | FSallustio | Tue 07 Jul, 2015 13:47:35 +0000 | - Aggiunta prima versione dello schema del db; |