X-Git-Url: http://git.cyclocoop.org/?p=ptitvelo%2Fweb%2Fwww.git;a=blobdiff_plain;f=www%2Fplugins%2Fagenda_3_5%2Fbase%2Fagenda_evenements.php;fp=www%2Fplugins%2Fagenda_3_5%2Fbase%2Fagenda_evenements.php;h=0573b30b4aeb24e370935ef0506f6d4a990f8c2f;hp=3b7973b94e8773ef3cea1f0a464e3d5d4fee9164;hb=e9831187c8ec71fdae89f823e969d63fc3cbc7f3;hpb=f854641371bdfbaba8fbab6212853d9795ba8cc8

diff --git a/www/plugins/agenda_3_5/base/agenda_evenements.php b/www/plugins/agenda_3_5/base/agenda_evenements.php
index 3b7973b..0573b30 100644
--- a/www/plugins/agenda_3_5/base/agenda_evenements.php
+++ b/www/plugins/agenda_3_5/base/agenda_evenements.php
@@ -39,14 +39,18 @@ function agenda_declarer_tables_auxiliaires($tables_auxiliaires){
 
 	//-- Table des participants ----------------------
 	$spip_evenements_participants = array(
+			"id_evenement_participant" => "BIGINT(21) NOT NULL AUTO_INCREMENT",
 			"id_evenement"	=> "BIGINT (21) DEFAULT '0' NOT NULL",
 			"id_auteur"	=> "BIGINT (21) DEFAULT '0' NOT NULL",
+			"nom"	=> "text NOT NULL DEFAULT ''",
+			"email"	=> "tinytext NOT NULL DEFAULT ''",
 			"date" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
 			"reponse" => "char(3) default '?' NOT NULL", // oui, non, ?
 			);
 	
 	$spip_evenements_participants_key = array(
-			"PRIMARY KEY"	=> "id_evenement, id_auteur",
+			"PRIMARY KEY"	=> "id_evenement_participant",
+			"KEY id_evenement"	=> "id_evenement",
 			"KEY id_auteur"	=> "id_auteur");
 	
 	$tables_auxiliaires['spip_evenements_participants'] = array(
@@ -92,7 +96,8 @@ function agenda_declarer_tables_objets_sql($tables){
 			"horaire" => "varchar(3) DEFAULT 'oui' NOT NULL",
 			"id_evenement_source"	=> "bigint(21) NOT NULL",
 			"statut"	=> "varchar(10) DEFAULT '0' NOT NULL",
-			"maj"	=> "TIMESTAMP"
+			"maj"	=> "TIMESTAMP",
+			"date_creation"	=> "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL"
 		),
 		'key' => array(
 			"PRIMARY KEY"	=> "id_evenement",
@@ -133,7 +138,7 @@ function agenda_declarer_tables_objets_sql($tables){
 			'poubelle' => 'texte_statut_poubelle',
 		),
 		'texte_changer_statut' => 'agenda:texte_evenement_statut',
-		'champs_versionnes' => array('id_article', 'titre', 'descriptif', 'lieu', 'adresse'),
+		'champs_versionnes' => array('id_article', 'titre', 'descriptif', 'lieu', 'adresse', 'date_debut', 'date_fin', 'horaire'),
 
 	);
 
@@ -145,4 +150,5 @@ function agenda_declarer_tables_objets_sql($tables){
 	return $tables;
 }
 
+
 ?>
\ No newline at end of file