informations de versions

[mtweb] / mw / app / data / modules / sql / mw_data_sql_install.php

diff --git a/mw/app/data/modules/sql/mw_data_sql_install.php b/mw/app/data/modules/sql/mw_data_sql_install.php
index 19a8a8d..22b86dc 100644 (file)
--- a/mw/app/data/modules/sql/mw_data_sql_install.php
+++ b/mw/app/data/modules/sql/mw_data_sql_install.php
@@ -22,13 +22,17 @@
       catch(Exception $e){
         return $e->getMessage();
       }
+      if(!($version = $env->version("mtweb"))){
+        return "impossible de lire la version de mtweb";
+      }
       try{
         $EXISTS =
             $sgbd->table_exists("#--actions_roles")
         ||  $sgbd->table_exists("#--config")
         ||  $sgbd->table_exists("#--roles")
         ||  $sgbd->table_exists("#--users")
-        ||  $sgbd->table_exists("#--users_roles");
+        ||  $sgbd->table_exists("#--users_roles")
+        ||  $sgbd->table_exists("#--versions");
       }
       catch(Exception $e){
         return "impossible de savoir si les tables existent deja";
@@ -89,6 +93,15 @@
         .") DEFAULT CHARSET=utf8";
         $sgbd->query($sql);
 
+        $sql =
+         "CREATE TABLE #--versions("
+        ."  id INT(11) NOT NULL AUTO_INCREMENT,"
+        ."  application VARCHAR(255) NOT NULL,"
+        ."  version VARCHAR(255) NOT NULL,"
+        ."  PRIMARY KEY (id)"
+        .") DEFAULT CHARSET=utf8";
+        $sgbd->query($sql);
+
       }
       catch(Exception $e){
         return "imposible de creer les tables en base";
@@ -126,6 +139,11 @@
         ."(3, 'webmaster', 'webmaster')";
         $sgbd->query($sql);
 
+        $sql =
+         "INSERT INTO #--versions(`application`, `version`) VALUES"\r
+        ."('mtweb', ".$this->eq($version).")";
+        $sgbd->query($sql);
+
       }
       catch(Exception $e){
         return "les tables ont ete ajoutees en base mais impossible d'y enregistrer les valeurs par defaut.";