-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generato il: Nov 14, 2014 alle 16:45
-- Versione del server: 5.5.38-0ubuntu0.14.04.1
-- Versione PHP: 5.5.9-1ubuntu4.4

USE logintesi;

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 */;

-- --------------------------------------------------------

--
-- Struttura della tabella `aggprova`
--

CREATE TABLE IF NOT EXISTS `aggprova` (
  `chiave` varchar(50) COLLATE utf8_bin NOT NULL,
  `time` double NOT NULL,
  `checks` int(11) NOT NULL,
  PRIMARY KEY (`chiave`),
  UNIQUE KEY `key` (`chiave`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dump dei dati per la tabella `aggprova`
--

INSERT INTO `aggprova` (`chiave`, `time`, `checks`) VALUES
('10157426982320510', 1415145803639, 1),
('10244937857444543', 1415284664538, 1),
('10308106918353456', 1415243065790, 1),
('10385651273134167', 1415289922479, 1),
('10414239987472834', 1415285560312, 1),
('1097785784725414', 1415284853312, 1),
('10983265112121106', 1415242393295, 1),
('1286713061377424', 1415036978051, 1),
('1408285479764558', 1415278883075, 1),
('1490801371315190', 1415285333816, 1),
('1741331087669285', 1415811578318, 1),
('18516070104459806', 1415276863684, 1),
('2217380018747176', 1415145507080, 1),
('2260502250327125', 1415284745047, 1),
('2473377684156933', 1415284628252, 1),
('2504043195911198', 1415285115955, 1),
('2686774762838581', 1415278911038, 1),
('2744239278608085', 1415036291300, 1),
('2956509786688513', 1415271435934, 1),
('2961042458190883', 1415277033282, 1),
('3109253928772677', 1415284540445, 1),
('3311335330604631', 1415237862686, 1),
('3486758220086141', 1415242975878, 1),
('3571361357113219', 1415285156048, 1),
('4091389111256716', 1415025754182, 1),
('42848425102166715', 1415242068918, 1),
('4457124515989723', 1415811050681, 1),
('4577865146663611', 1415285170075, 1),
('4796791993070257', 1415288554998, 1),
('5005653368852396', 1415285312682, 1),
('5226217037177487', 1415145721770, 1),
('5308112899337743', 1415037335958, 1),
('5362524692721963', 1415811381242, 1),
('5382075363462279', 1415272904986, 1),
('5650512812480934', 1415271249954, 1),
('5735648814288922', 1415036889526, 1),
('62029084106069252', 1415241839377, 1),
('6712150141518271', 1415285510994, 1),
('6786243849285602', 1415811389915, 1),
('6992436366972266', 1415242705239, 1),
('7106071695334106', 1415811170493, 1),
('7158700078303143', 1415284726466, 1),
('7307203380313108', 1415819825863, 1),
('75372031101482498', 1415284519581, 1),
('7703030541673651', 1415272914342, 1),
('8065501483698608', 1415819808393, 1),
('8468895456378674', 1415241733824, 1),
('8760904545449404', 1415285230458, 1),
('8838732364680254', 1415271877269, 1),
('9576830372163956', 1415283251776, 1);

-- --------------------------------------------------------

--
-- Struttura della tabella `connessi`
--

CREATE TABLE IF NOT EXISTS `connessi` (
  `user` varchar(50) COLLATE utf8_bin NOT NULL,
  `tempkey` varchar(50) COLLATE utf8_bin NOT NULL,
  `thread` tinyint(1) NOT NULL,
  `time` double NOT NULL,
  UNIQUE KEY `tempkey` (`tempkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dump dei dati per la tabella `connessi`
--

INSERT INTO `connessi` (`user`, `tempkey`, `thread`, `time`) VALUES
('danilo.berardinelli@studio.unibo.it', '2545550210880139', 0, 1415975986391);

-- --------------------------------------------------------

--
-- Struttura della tabella `esercizi`
--

CREATE TABLE IF NOT EXISTS `esercizi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `esercizio` varchar(20) COLLATE utf8_bin NOT NULL,
  `utente` varchar(50) COLLATE utf8_bin NOT NULL,
  `click` int(11) NOT NULL,
  `time` double NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;

--
-- Dump dei dati per la tabella `esercizi`
--

INSERT INTO `esercizi` (`id`, `esercizio`, `utente`, `click`, `time`) VALUES
(1, 'tautologia.xml', 'danilo.berardinelli@studio.unibo.it', 1, 1415923860705),
(2, 'tautologia.xml', 'danilo.berardinelli@studio.unibo.it', 1, 1415975624027),
(3, 'tautologia.xml', 'danilo.berardinelli@studio.unibo.it', 3, 1415975983857);

/*!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 */;
