-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generato il: Lug 31, 2012 alle 11:14
-- Versione del server: 5.5.16
-- Versione PHP: 5.3.8

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: `appdatamobile`
--

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

--
-- Struttura della tabella `eventi`
--

CREATE TABLE IF NOT EXISTS `eventi` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) NOT NULL,
  `Description` varchar(300) DEFAULT NULL,
  `Datetime` datetime NOT NULL,
  `LocationId` int(8) unsigned NOT NULL,
  `UserId` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;

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

INSERT INTO `eventi` (`id`, `Name`, `Description`, `Datetime`, `LocationId`, `UserId`) VALUES
(30, 'Raduno Motociclisti', 'Descrizione', '2012-07-31 13:34:00', 5158, '100000426821134'),
(31, 'Sagra del Tordello', 'Tordelli a sfare', '2012-11-30 15:21:00', 5158, '100000426821134'),
(32, 'Tutti al Calcetto!', 'Calcetto a 5', '2012-05-16 16:19:00', 5839, '100000426821134'),
(33, 'Evento di Fabrizio', 'Tanta, tanta descrizione', '2012-07-25 00:00:00', 5158, '100001593681962'),
(34, 'Evento 4', 'Descrizione Evento 4', '2012-07-30 01:00:00', 5135, '100000426821134'),
(35, 'Che ganzata', 'Ganzo evento granzo', '2012-12-25 18:00:00', 5135, '100000426821134'),
(36, 'Partita Innaugurale Libertas', 'Si gioca, si mangia, si beve, ci si diverte!', '2012-11-23 16:21:00', 4833, '100000426821134');

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

--
-- Struttura della tabella `partecipa`
--

CREATE TABLE IF NOT EXISTS `partecipa` (
  `id` int(15) unsigned NOT NULL AUTO_INCREMENT,
  `EventId` int(10) unsigned NOT NULL,
  `FriendId` varchar(20) NOT NULL,
  `Stato` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `EventId` (`EventId`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=46 ;

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

INSERT INTO `partecipa` (`id`, `EventId`, `FriendId`, `Stato`) VALUES
(26, 30, '100001593681962', 1),
(27, 30, '100000438280505', 0),
(28, 31, '100000438280505', 0),
(29, 31, '100001593681962', 0),
(30, 32, '100000438280505', 0),
(31, 32, '100001593681962', 0),
(32, 33, '100000438280505', 0),
(33, 33, '100000426821134', 3),
(34, 34, '1277427892', 0),
(35, 34, '1439967870', 0),
(36, 34, '1642625615', 0),
(37, 34, '1655710438', 0),
(38, 35, '1000306527', 0),
(39, 35, '1504650874', 0),
(40, 35, '1544593922', 0),
(41, 36, '1358268423', 0),
(42, 36, '1536011877', 0),
(43, 36, '1580523428', 0),
(44, 36, '100000621830090', 0),
(45, 36, '100000438280505', 0);

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