invitations pour les acces aux sources

[mw_sourceml] / mw_sourceml.php

diff --git a/mw_sourceml.php b/mw_sourceml.php
index 2769e77..2c7cc5b 100644 (file)
--- a/mw_sourceml.php
+++ b/mw_sourceml.php
@@ -21,6 +21,7 @@
       $env->set_link("users/albums", $env->url("users/albums"), "Albums", 31);
       $env->set_link("users/morceaux", $env->url("users/morceaux"), "Morceaux", 32);
       $env->set_link("users/pistes", $env->url("users/pistes"), "Sources", 33);
+      $env->set_link("users/sources_invitations", $env->url("users/sources_invitations"), "Invitations", 34);
 
       $env->set_link("menu_top/groupes", $env->url("sources/groupe"), "Groupes", 10);
       $env->set_link("menu_top/albums", $env->url("sources/album"), "Albums", 11);
@@ -200,6 +201,17 @@
         .") DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
         $sgbd->query($sql);
 
+        $sql =
+         "CREATE TABLE `#--sml_sources_invitations`("
+        ."  `id` INT(11) NOT NULL AUTO_INCREMENT,"
+        ."  `id_user` INT(11) NOT NULL,"
+        ."  `id_source` INT(11) NOT NULL,"
+        ."  `id_author` INT(11) NOT NULL,"
+        ."  `id_sources_access` INT(11) NOT NULL,"
+        ."  PRIMARY KEY (`id`)"
+        .")";
+        $sgbd->query($sql);
+
       }
       catch(Exception $e){
         return "imposible de creer les tables en base";
@@ -323,6 +335,12 @@
       catch(Exception $e){
         return "impossible de supprimer la table #--sml_source_documents";
       }
+      try{
+        $sgbd->query("DROP TABLE #--sml_sources_invitations");
+      }
+      catch(Exception $e){
+        return "impossible de supprimer la table #--sml_sources_invitations";
+      }
       return true;
     }