X-Git-Url: http://git.dj3c1t.com/?a=blobdiff_plain;f=mw%2Fapp%2Fdata%2Fmodules%2Fsql%2Fmw_data_sql_install.php;h=22b86dcd950aec5ae1460288600a97348f0cdf69;hb=ed558d720ebf6985290c99297f5b1d2c86d1f60a;hp=19a8a8d8b9412a431dc642a01f752a6bf991d672;hpb=0ada6496e6c552c473a5816734b38896ccdd345b;p=mtweb

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
--- 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"
+        ."('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.";