X-Git-Url: http://git.dj3c1t.com/?a=blobdiff_plain;f=mw%2Fapp%2Fdata%2Fmodules%2Fsql%2Fmw_data_sql_install.php;h=9dd746d7bf59a31ce6b30ba2ccc65f6a1972ca5f;hb=ad9756b0b72852c82165e824570f21b039fcb359;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..9dd746d 100644
--- a/mw/app/data/modules/sql/mw_data_sql_install.php
+++ b/mw/app/data/modules/sql/mw_data_sql_install.php
@@ -2,7 +2,7 @@
 
   class mw_data_sql_install extends mw_data{
 
-    function install_sql($params){
+    public function install_sql($params){
       $env = $this->env();
       $data = $env->data();
       $sgbd = $data->sgbd();
@@ -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.";
@@ -134,5 +152,3 @@
     }
 
   }
-
-?>
\ No newline at end of file