-- phpMyAdmin SQL Dump
-- version 2.8.0.3-Debian-1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Nov 14, 2006 at 04:06 PM
-- Server version: 5.0.22
-- PHP Version: 5.1.2
-- 
-- Database: `crowdup`
-- 

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

-- 
-- Table structure for table `PARTICIPANT`
-- 

CREATE TABLE `PARTICIPANT` (
  `id` int(11) NOT NULL auto_increment,
  `manifestation_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `personaltext` varchar(255) NOT NULL,
  `longitude` varchar(40) NOT NULL,
  `latitude` varchar(40) NOT NULL,
  `ref_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

-- 
-- Dumping data for table `PARTICIPANT`
-- 

INSERT INTO `PARTICIPANT` (`id`, `manifestation_id`, `title`, `personaltext`, `longitude`, `latitude`, `ref_id`) VALUES (2, 1, '', 'Join in ', '1.443007', '43.604363', 0),
(3, 1, 'Premier participant', 'Mon premier gus', '1.23454', '32.575698009', 0),
(4, 1, 'jeremi', 'jerevendique', '1.23454', '32.575698009', 1),
(8, 1, 'title', 'personal text', '2.724609375', '47.398349200359256', -1),
(7, 1, 'title', 'personal text', '2.724609375', '47.398349200359256', -1),
(9, 1, 'title', 'personal text', '2.724609375', '47.398349200359256', -1),
(10, 1, 'title', 'personal text', '2.724609375', '47.398349200359256', -1),
(11, 1, 'title', 'personal text', '2.724609375', '47.398349200359256', -1),
(12, 1, 'title', 'personal text', '-1.3623046875', '47.84265762816535', -1),
(13, 1, 'title', 'personal text', '10.986328125', '45.336701909968106', -1),
(14, 1, 'title', 'personal text', '2.0654296875', '48.42920055556841', -1),
(15, 10, 'title', 'personal text', '7.119140625', '50.48547354578499', -1),
(16, 11, 'title', 'personal text', '3.0322265625', '50.708634400828224', -1),
(17, 12, 'go', 'go on', '1.669921875', '46.76996843356982', -1),
(18, 13, 'yep', 'yes', '2.373046875', '48.86471476180277', -1),
(19, 14, 'xtof', 'Mémoire du Barcamp ! ', '2.369699478149414', '48.83963900301541', -1),
(20, 16, 'Marica', 'Join My Demonstration', '2.2412109375', '48.77791275550184', -1),
(21, 17, 'titles', 'sdfs ', '2.8125', '48.48748647988415', -1),
(22, 20, 'Club des hauts débats gourmands', 'Pizza & Mashpit', '2.3327600955963135', '48.870078439512724', -1),
(23, 22, 'title', 'personal text', '2.28515625', '48.83579746243093', -1);

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

-- 
-- Table structure for table `manifestation`
-- 

CREATE TABLE `manifestation` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `shortname` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `longitude` varchar(40) NOT NULL,
  `latitude` varchar(40) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='MANIFESTATION' AUTO_INCREMENT=23 ;

-- 
-- Dumping data for table `manifestation`
-- 

INSERT INTO `manifestation` (`id`, `shortname`, `title`, `description`, `longitude`, `latitude`) VALUES (1, 'test', 'test', 'testdesc', '234123', '2312423'),
(2, 'test', 'test', 'testdesc', '234123', '2312423'),
(3, 'testsdg', 'test', 'testdesc', '234123', '2312423'),
(4, 'testsdg', 'test', 'testdesc', '234123', '2312423'),
(5, 'test', 'test', 'testdesc', '', ''),
(6, 'test', 'test', 'testdesc', '', ''),
(7, 'test', 'test', 'testdesc', '', ''),
(8, 'test', 'test', 'testdesc', '', ''),
(9, 'bar', 'foo', 'foofoo', '2.5927734375', '48.893615361480194'),
(10, 'name here', 'title', 'title', '9.1845703125', '48.74894534343293'),
(11, 'foo', 'foo', 'foo', '2.28515625', '48.951366470947725'),
(12, 'Paris', 'Test1', 'Test2', '1.7138671875', '47.2195681123155'),
(13, 'Louis', 'cool', 'test', '2.3291015625', '48.83579746243093'),
(14, 'wikinet', '4 place de valois', 'siliconvalois', '2.3383498191833496', '48.863077314067475'),
(15, 'wikinet', 'paris', 'paris', '2.28515625', '48.719961222646276'),
(16, 'Girl Power', 'title', 'title', '2.3291015625', '48.80686346108517'),
(17, 'test', 'test', 'test', '2.28515625', '48.951366470947725'),
(18, 'name here', 'title', 'title', '2.3892688751220703', '48.86909043681761'),
(19, 'name here', 'title', 'title', '3.603515625', '48.719961222646276'),
(20, 'Paris', 'Manifestation International', 'Global campaign', '2.332792282104492', '48.870078439512724'),
(21, 'name here', 'title', 'title', '3.0322265625', '47.398349200359256'),
(22, 'coucou', 'c', 'u', '1.7578125', '49.06666839558116');