3 -- http://www.phpmyadmin.net
6 -- Generato il: Nov 14, 2014 alle 16:45
7 -- Versione del server: 5.5.38-0ubuntu0.14.04.1
8 -- Versione PHP: 5.5.9-1ubuntu4.4
12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
13 SET time_zone = "+00:00";
16 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19 /*!40101 SET NAMES utf8 */;
22 -- Database: `logintesi`
25 -- --------------------------------------------------------
28 -- Struttura della tabella `admin`
31 CREATE TABLE IF NOT EXISTS `admin` (
32 `username` varchar(30) COLLATE utf8_bin NOT NULL,
33 `password` varchar(30) COLLATE utf8_bin NOT NULL,
34 UNIQUE KEY `username` (`username`)
35 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
38 -- Dump dei dati per la tabella `admin`
41 INSERT INTO `admin` (`username`, `password`) VALUES
42 ('danilo.berardinelli', '123stella');
44 -- --------------------------------------------------------
47 -- Struttura della tabella `aggprova`
50 CREATE TABLE IF NOT EXISTS `aggprova` (
51 `chiave` varchar(50) COLLATE utf8_bin NOT NULL,
52 `time` double NOT NULL,
53 `checks` int(11) NOT NULL,
54 PRIMARY KEY (`chiave`),
55 UNIQUE KEY `key` (`chiave`)
56 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
59 -- Dump dei dati per la tabella `aggprova`
62 INSERT INTO `aggprova` (`chiave`, `time`, `checks`) VALUES
63 ('10157426982320510', 1415145803639, 1),
64 ('10244937857444543', 1415284664538, 1),
65 ('10308106918353456', 1415243065790, 1),
66 ('10385651273134167', 1415289922479, 1),
67 ('10414239987472834', 1415285560312, 1),
68 ('1097785784725414', 1415284853312, 1),
69 ('10983265112121106', 1415242393295, 1),
70 ('1286713061377424', 1415036978051, 1),
71 ('1408285479764558', 1415278883075, 1),
72 ('1490801371315190', 1415285333816, 1),
73 ('1741331087669285', 1415811578318, 1),
74 ('18516070104459806', 1415276863684, 1),
75 ('2217380018747176', 1415145507080, 1),
76 ('2260502250327125', 1415284745047, 1),
77 ('2473377684156933', 1415284628252, 1),
78 ('2504043195911198', 1415285115955, 1),
79 ('2686774762838581', 1415278911038, 1),
80 ('2744239278608085', 1415036291300, 1),
81 ('2956509786688513', 1415271435934, 1),
82 ('2961042458190883', 1415277033282, 1),
83 ('3109253928772677', 1415284540445, 1),
84 ('3311335330604631', 1415237862686, 1),
85 ('3486758220086141', 1415242975878, 1),
86 ('3571361357113219', 1415285156048, 1),
87 ('4091389111256716', 1415025754182, 1),
88 ('42848425102166715', 1415242068918, 1),
89 ('4457124515989723', 1415811050681, 1),
90 ('4577865146663611', 1415285170075, 1),
91 ('4796791993070257', 1415288554998, 1),
92 ('5005653368852396', 1415285312682, 1),
93 ('5226217037177487', 1415145721770, 1),
94 ('5308112899337743', 1415037335958, 1),
95 ('5362524692721963', 1415811381242, 1),
96 ('5382075363462279', 1415272904986, 1),
97 ('5650512812480934', 1415271249954, 1),
98 ('5735648814288922', 1415036889526, 1),
99 ('62029084106069252', 1415241839377, 1),
100 ('6712150141518271', 1415285510994, 1),
101 ('6786243849285602', 1415811389915, 1),
102 ('6992436366972266', 1415242705239, 1),
103 ('7106071695334106', 1415811170493, 1),
104 ('7158700078303143', 1415284726466, 1),
105 ('7307203380313108', 1415819825863, 1),
106 ('75372031101482498', 1415284519581, 1),
107 ('7703030541673651', 1415272914342, 1),
108 ('8065501483698608', 1415819808393, 1),
109 ('8468895456378674', 1415241733824, 1),
110 ('8760904545449404', 1415285230458, 1),
111 ('8838732364680254', 1415271877269, 1),
112 ('9576830372163956', 1415283251776, 1);
114 -- --------------------------------------------------------
117 -- Struttura della tabella `confmail`
120 CREATE TABLE IF NOT EXISTS `confmail` (
121 `user` varchar(50) COLLATE utf8_bin NOT NULL,
122 `pass` varchar(50) COLLATE utf8_bin NOT NULL,
123 `hash` varchar(50) COLLATE utf8_bin NOT NULL,
124 `time` double DEFAULT NULL,
125 UNIQUE KEY `user` (`user`)
126 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
128 -- --------------------------------------------------------
131 -- Struttura della tabella `connessi`
134 CREATE TABLE IF NOT EXISTS `connessi` (
135 `user` varchar(50) COLLATE utf8_bin NOT NULL,
136 `tempkey` varchar(50) COLLATE utf8_bin NOT NULL,
137 `thread` tinyint(1) NOT NULL,
138 `time` double NOT NULL,
139 UNIQUE KEY `tempkey` (`tempkey`)
140 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
143 -- Dump dei dati per la tabella `connessi`
146 INSERT INTO `connessi` (`user`, `tempkey`, `thread`, `time`) VALUES
147 ('danilo.berardinelli@studio.unibo.it', '2545550210880139', 0, 1415975986391);
149 -- --------------------------------------------------------
152 -- Struttura della tabella `esercizi`
155 CREATE TABLE IF NOT EXISTS `esercizi` (
156 `id` int(11) NOT NULL AUTO_INCREMENT,
157 `esercizio` varchar(20) COLLATE utf8_bin NOT NULL,
158 `utente` varchar(50) COLLATE utf8_bin NOT NULL,
159 `click` int(11) NOT NULL,
160 `time` double NOT NULL,
162 UNIQUE KEY `id` (`id`)
163 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;
166 -- Dump dei dati per la tabella `esercizi`
169 INSERT INTO `esercizi` (`id`, `esercizio`, `utente`, `click`, `time`) VALUES
170 (1, 'tautologia.xml', 'danilo.berardinelli@studio.unibo.it', 1, 1415923860705),
171 (2, 'tautologia.xml', 'danilo.berardinelli@studio.unibo.it', 1, 1415975624027),
172 (3, 'tautologia.xml', 'danilo.berardinelli@studio.unibo.it', 3, 1415975983857);
174 -- --------------------------------------------------------
177 -- Struttura della tabella `utenti`
180 CREATE TABLE IF NOT EXISTS `utenti` (
181 `user` varchar(50) COLLATE utf8_bin NOT NULL,
182 `pass` varchar(15) COLLATE utf8_bin NOT NULL,
183 UNIQUE KEY `user` (`user`)
184 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
187 -- Dump dei dati per la tabella `utenti`
190 INSERT INTO `utenti` (`user`, `pass`) VALUES
191 ('danilo.berardinelli@studio.unibo.it', '123stella');
193 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
194 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
195 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;