--
-- Host: mysql51-34.perso    Database: pietonsdata
-- ------------------------------------------------------


--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` int(11) unsigned NOT NULL,
  `author_id` int(11) unsigned NOT NULL,
  `title` varchar(200) NOT NULL,
  `content` text NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `project_id` (`project_id`),
  KEY `author_id` (`author_id`),
  CONSTRAINT `blog_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `blog_ibfk_2` FOREIGN KEY (`author_id`) REFERENCES `members` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `blog`
--


--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `article_id` int(11) unsigned NOT NULL,
  `author_id` int(11) unsigned NOT NULL,
  `content` text NOT NULL,
  `date` datetime NOT NULL,
  `in_reply_to` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `article_id` (`article_id`,`author_id`,`in_reply_to`),
  KEY `author_id` (`author_id`),
  CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`article_id`) REFERENCES `blog` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `comments_ibfk_2` FOREIGN KEY (`author_id`) REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `comments`
--


--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `projets_id` int(10) unsigned NOT NULL,
  `title` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `beginning` datetime NOT NULL,
  `end` datetime NOT NULL,
  `place` text NOT NULL,
  `obligatoire` tinyint(1) NOT NULL,
  `cost` float NOT NULL,
  `public` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `projets_id` (`projets_id`),
  CONSTRAINT `events_ibfk_1` FOREIGN KEY (`projets_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `events`
--


--
-- Table structure for table `event_presence`
--

CREATE TABLE `event_presence` (
  `members_id` int(11) unsigned NOT NULL,
  `event_id` int(11) unsigned NOT NULL,
  KEY `members_id` (`members_id`),
  KEY `calendar_id` (`event_id`),
  CONSTRAINT `event_presence_ibfk_1` FOREIGN KEY (`members_id`) REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `event_presence_ibfk_2` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `event_presence`
--


--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `beginning` date NOT NULL,
  `end` date NOT NULL,
  `progress` int(11) NOT NULL COMMENT '0 = en projet / 1 = en cours / 2 = terminé / 3 = suspendu / 4 = abandonné',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` VALUES (1,'The Feeling','Tournage d\'un clip vidéo pour le titre The Feeling du groupe Cromer.\r\n\r\nCromer est un trio de rock expérimental lausannois, formé en 2009 par les frères Schaffner, qui allie une recherche sonore instinctive avec un songwriting mêlant le traditionnel à l\'inattendu.\r\n\r\nLeur titre The Feeling est mis en image et se présente sous la forme d\'un court-métrage: on suit les pensées d\'une jeune fille qui va tenter d\'exprimer son doute profond sur l\'authenticité de sa vie à travers la peinture, une échappatoire qui va se révéler défectueuse...\r\n\r\nAinsi, ce clip tente de restituer ce type de nostalgie vaine, puissante et doucereuse.','2011-01-01','2011-08-01',0),(2,'Poursuites à travers Lausanne','Ce projet a pour but premier d\'apprendre les techniques cinématographiques de bases: le cadrage, faire en sorte qu\'une image soit équilibrée, les plongées/contre-plongées, etc.\r\nPour ce faire, nous avons décidé de créer un court-métrage laissant la possibilité a différents aspects d\'être testé: les dialogues, poursuites, plans-larges; en mettant en scène les acteurs dans une poursuite à travers Lausanne.\r\nDes membres ayant déjà fait des stages de cinéma et ayant de l’expérience sont là pour nous enseigner cet art.','2011-01-01','2011-11-01',0),(3,'Du sang sur le cou du chat','Rainer Werner Fassbinder, l\'auteur de cette pièce, est un réalisateur acteur et metteur en scène allemand né le 31 mai 1945 à Bad Wörishofen (Bavière). Il est l’un des représentants majeurs du Nouveau cinéma allemand des années 1960-1970.\r\n\r\nDu sang sur le cou du chat (Blut am Hals der Katze) a été montée en 1971 par Fassbinder et Peer Raben, à l\'Antiteater aux Städtischen Bühnen Nürnberg.\r\n\r\nNous travaillons cette pièce dans le cadre des ateliers données les dimanches des week-ends artistiques par le metteur en scène Pascal Francfort.','2011-03-01','2012-01-01',0),(4,'Dormez, je le veux!','Georges Feydeau, né à Paris le 8 décembre 1862 et mort à Rueil-Malmaison le 5 juin 1921, est un auteur dramatique français, connu pour ses très nombreux vaudevilles.\r\n\r\nDormez, je le veux! est une comédie en un acte de Feydeau, montée en 1897.\r\n\r\nNous travaillons cette pièce dans le cadre des ateliers données les dimanches des week-ends artistiques par le metteur en scène Pascal Francfort.','2011-07-01','2011-09-01',0),(5,'Week-ends','Un samedi par mois, les Piétons de la Scène se retrouvent pour faire le point sur les différents projets en cours.\r\nDe plus, des activités théâtrales ou des petites conférences sont amenées à titre pédagogique. Chacun est donc invité à créer et à partager.\r\nLe soir, un délicieux repas nous est proposé.','2011-01-01','2030-01-01',0),(6,'Les Piétons de la Scène','Projet créé pour des raison pratique (blog).','2010-10-20','2035-10-20',1);

--
-- Table structure for table `project_participation`
--

CREATE TABLE `project_participation` (
  `members_id` int(11) unsigned NOT NULL,
  `project_id` int(11) unsigned NOT NULL,
  `responsable` tinyint(1) NOT NULL,
  KEY `members_id` (`members_id`),
  KEY `project_id` (`project_id`),
  CONSTRAINT `project_participation_ibfk_1` FOREIGN KEY (`members_id`) REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `project_participation_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `project_participation`
--

INSERT INTO `project_participation` VALUES (3,1,1),(7,1,1),(16,1,1),(12,2,1),(18,2,1),(29,5,1),(18,5,1),(21,5,1),(25,5,1),(26,5,1),(31,5,1),(31,1,0),(23,2,0),(29,1,0),(15,1,0),(17,3,0),(17,4,0),(18,6,1),(21,6,1),(25,6,1),(29,6,1),(31,6,1);

--
-- Table structure for table `realisations`
--

CREATE TABLE `realisations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titre` text CHARACTER SET utf8 NOT NULL,
  `description` text CHARACTER SET utf8 NOT NULL,
  `short_description` text CHARACTER SET utf8 NOT NULL,
  `duree` text NOT NULL,
  `date` date NOT NULL,
  `occasion` text NOT NULL,
  `credits` text NOT NULL,
  `visible` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `realisations`
--

INSERT INTO `realisations` VALUES (1,'Recto-verso','Quand XX rencontre XY, mêlant images, musique et poésie.','Quand XX rencontre XY, mêlant images, musique et poésie.','9:09','2010-10-08','Camp de théâtre d\'automne 2010','<tr>\r\n			<td>Acteurs</td>\r\n			<td>Océane, Xavier, Sonia, Johanna, Evelyne</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Caméra</td>\r\n			<td>Sacha</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Costumes</td>\r\n			<td>Cassandre, Laura, Emile</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Texte</td>\r\n			<td>Darius</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Musique</td>\r\n			<td>Emile, Sacha</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Remerciements</td>\r\n			<td>A tous les participants du camp<br/>A Léo pour son soutien matériel et spirituel.<br/>A Donatienne pour la scène romantique.</td>\r\n		</tr>',1),(2,'Cornemuse des Alizées','In hac habitasse platea dictumst. Nam congue mattis bibendum. Morbi suscipit faucibus tortor, sit amet tempor neque pharetra vitae. Praesent rutrum dapibus dui, ut varius dui sollicitudin quis. Proin euismod nulla id tortor viverra non rhoncus metus viverra. Suspendisse potenti. Morbi urna nibh, tempor sed malesuada quis, convallis at est. Ut et elit sit amet nulla posuere gravida. Etiam pellentesque dapibus ligula, sit amet blandit arcu aliquam non. Vivamus sed velit eu eros dignissim imperdiet. Donec nisl sapien, varius quis sodales at, egestas sit amet lorem. Aliquam tincidunt velit eget ante facilisis lacinia pulvinar mauris placerat. Quisque condimentum luctus mauris, vel accumsan diam porta sed. Vestibulum sit amet eros tellus. ','Comment sauver un son défectueux ?<br>Mini-courts métrages.','01:30','2010-10-07','Camp de théâtre d\'automne 2010','<tr>\r\n			<td>Acteurs</td>\r\n			<td>Poneyane, Poneyvier, Poneynia, Ponehanna, Poneyvline</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Caméra</td>\r\n			<td>Poneybron</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Costumes</td>\r\n			<td>Poneyssandre, Poneyra, Poneymile</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Texte</td>\r\n			<td>Poneyrus</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Musique</td>\r\n			<td>Poneymile, Poneybron</td>\r\n		</tr>',1),(3,'Le pari','','Mini-courts métrages.','2:20','2009-08-12','Camp de théâtre août 2009','',1),(4,'Musique','','','04:01','2010-08-12','Camp d\'août 2010','',1),(5,'L\'atelier','','Mini-courts métrages.','02:01','2009-08-12','Camp de théâtre d\'août 2009','',1),(6,'07h01','','Chaque matin le réveil démarre la rengaine quotidienne...jusqu\'à quand ?','19:07','2010-10-10','Camp de théâtre d\'octobre 2010','',1),(7,'La Venoge','','','13:23','2010-10-12','Camp de théâtre d\'octobre 2010','',1),(8,'Musique','','','03:16','2009-08-12','Camp d\'août 2009','',1),(9,'Bouton','','','09:19','2010-10-01','Camp de théâtre d\'octobre 2010','',1),(10,'I\'m too sexy','','','13:28','2009-10-01','Camp de théâtre d\'octobre 2009','',1),(11,'PlastiK','','','20:41','2010-08-01','Camp de théâtre d\'août 2010.','',1),(12,'Bobébé Bobo','','','03:47','2006-08-01','Camp de théâtre d\'août 2006','',1);

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL,
  `service` varchar(100) NOT NULL,
  `member_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  CONSTRAINT `services_ibfk_1` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `services`
--


--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reference` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `montant` double NOT NULL,
  `type` int(11) NOT NULL,
  `date-paiement` int(11) NOT NULL,
  `date-credit` int(11) NOT NULL,
  `date-traitement` int(11) NOT NULL,
  `frais` int(11) NOT NULL,
  `donnees` varchar(150) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `fileid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=91 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` VALUES (1,'2',19,20,1305385200,1305385200,1305385200,0,'',''),(2,'15',20,20,1305385200,1305385200,1305385200,0,'',''),(3,'7',20,20,1305385200,1305385200,1305385200,0,'',''),(4,'11',20,20,1305385200,1305385200,1305385200,0,'',''),(5,'12',20,20,1305385200,1305385200,1305385200,0,'',''),(6,'14',15,20,1305385200,1305385200,1305385200,0,'',''),(7,'20',15,20,1305385200,1305385200,1305385200,0,'',''),(8,'21',20,20,1305385200,1305385200,1305385200,0,'',''),(9,'17',20,20,1305385200,1305385200,1305385200,0,'',''),(10,'18',20,20,1305385200,1305385200,1305385200,0,'',''),(11,'22',20,20,1305385200,1305385200,1305385200,0,'',''),(12,'23',20,20,1305385200,1305385200,1305385200,0,'',''),(13,'24',5,20,1305385200,1305385200,1305385200,0,'',''),(14,'39',20,20,1305385200,1305385200,1305385200,0,'',''),(15,'27',5,20,1305385200,1305385200,1305385200,0,'',''),(16,'29',20,20,1305385200,1305385200,1305385200,0,'',''),(17,'31',5,20,1305385200,1305385200,1305385200,0,'',''),(18,'15',10,20,1302361200,1302361200,1302361200,0,'',''),(19,'5',10,20,1302361200,1302361200,1302361200,0,'',''),(20,'21',10,20,1302361200,1302361200,1302361200,0,'',''),(21,'17',10,20,1302361200,1302361200,1302361200,0,'',''),(22,'18',10,20,1302361200,1302361200,1302361200,0,'',''),(23,'19',10,20,1302361200,1302361200,1302361200,0,'',''),(24,'22',10,20,1302361200,1302361200,1302361200,0,'',''),(25,'23',10,20,1302361200,1302361200,1302361200,0,'',''),(26,'24',10,20,1302361200,1302361200,1302361200,0,'',''),(27,'26',10,20,1302361200,1302361200,1302361200,0,'',''),(28,'29',10,20,1302361200,1302361200,1302361200,0,'',''),(29,'31',10,20,1302361200,1302361200,1302361200,0,'',''),(30,'2',10,20,1299945600,1299945600,1299945600,0,'',''),(31,'3',25,20,1299945600,1299945600,1299945600,0,'',''),(32,'5',25,20,1299945600,1299945600,1299945600,0,'',''),(33,'6',15,20,1299945600,1299945600,1299945600,0,'',''),(34,'7',25,20,1299945600,1299945600,1299945600,0,'',''),(35,'11',10,20,1299945600,1299945600,1299945600,0,'',''),(36,'16',25,20,1299945600,1299945600,1299945600,0,'',''),(37,'21',25,20,1299945600,1299945600,1299945600,0,'',''),(38,'17',25,20,1299945600,1299945600,1299945600,0,'',''),(39,'18',25,20,1299945600,1299945600,1299945600,0,'',''),(40,'19',15,20,1299945600,1299945600,1299945600,0,'',''),(41,'23',25,20,1299945600,1299945600,1299945600,0,'',''),(42,'28',25,20,1299945600,1299945600,1299945600,0,'',''),(43,'29',25,20,1299945600,1299945600,1299945600,0,'',''),(44,'30',15,20,1299945600,1299945600,1299945600,0,'',''),(45,'31',25,20,1299945600,1299945600,1299945600,0,'',''),(47,'5',15,20,1297526400,1297526400,1297526400,0,'',''),(48,'6',15,20,1297526400,1297526400,1297526400,0,'',''),(49,'7',15,20,1297526400,1297526400,1297526400,0,'',''),(50,'9',15,20,1297526400,1297526400,1297526400,0,'',''),(51,'12',25,20,1297526400,1297526400,1297526400,0,'',''),(52,'14',15,20,1297526400,1297526400,1297526400,0,'',''),(54,'20',15,20,1297526400,1297526400,1297526400,0,'',''),(55,'21',25,20,1297526400,1297526400,1297526400,0,'',''),(56,'17',25,20,1297526400,1297526400,1297526400,0,'',''),(57,'18',15,20,1297526400,1297526400,1297526400,0,'',''),(58,'40',10,20,1297526400,1297526400,1297526400,0,'',''),(59,'22',25,20,1297526400,1297526400,1297526400,0,'',''),(60,'23',15,20,1297526400,1297526400,1297526400,0,'',''),(61,'27',25,20,1297526400,1297526400,1297526400,0,'',''),(62,'28',15,20,1297526400,1297526400,1297526400,0,'',''),(63,'29',25,20,1297526400,1297526400,1297526400,0,'',''),(65,'30',15,20,1297526400,1297526400,1297526400,0,'',''),(66,'31',25,20,1297526400,1297526400,1297526400,0,'',''),(67,'3',15,20,1295107200,1295107200,1295107200,0,'',''),(68,'4',15,20,1295107200,1295107200,1295107200,0,'',''),(69,'15',25,20,1295107200,1295107200,1295107200,0,'',''),(70,'5',15,20,1295107200,1295107200,1295107200,0,'',''),(71,'7',15,20,1295107200,1295107200,1295107200,0,'',''),(72,'9',25,20,1295107200,1295107200,1295107200,0,'',''),(73,'12',25,20,1295107200,1295107200,1295107200,0,'',''),(74,'13',10,20,1295107200,1295107200,1295107200,0,'',''),(75,'14',25,20,1295107200,1295107200,1295107200,0,'',''),(76,'16',15,20,1295107200,1295107200,1295107200,0,'',''),(77,'20',25,20,1295107200,1295107200,1295107200,0,'',''),(78,'21',25,20,1295107200,1295107200,1295107200,0,'',''),(79,'17',25,20,1295107200,1295107200,1295107200,0,'',''),(80,'18',15,20,1295107200,1295107200,1295107200,0,'',''),(81,'19',25,20,1295107200,1295107200,1295107200,0,'',''),(82,'22',25,20,1295107200,1295107200,1295107200,0,'',''),(83,'23',25,20,1295107200,1295107200,1295107200,0,'',''),(84,'25',10,20,1295107200,1295107200,1295107200,0,'',''),(85,'26',10,20,1295107200,1295107200,1295107200,0,'',''),(86,'28',25,20,1295107200,1295107200,1295107200,0,'',''),(87,'29',25,20,1295107200,1295107200,1295107200,0,'',''),(89,'30',25,20,1295107200,1295107200,1295107200,0,'',''),(90,'31',25,20,1295107200,1295107200,1295107200,0,'','');


