X-Git-Url: http://git.dj3c1t.com/?a=blobdiff_plain;ds=sidebyside;f=mw%2Fapp%2Fdata%2Fmodules%2Fsql%2Fmw_data_sqlite_install.php;fp=mw%2Fapp%2Fdata%2Fmodules%2Fsql%2Fmw_data_sqlite_install.php;h=2f241f69593e454fdc6f370983cd600b47f301c9;hb=bec31526c19092982057acabfe12e121442ec19b;hp=8c26638e5ca2246594d5ef7fc37d427beae04a5d;hpb=622eff0b10a740f80efe9f35b58373a9eab54dfe;p=mtweb

diff --git a/mw/app/data/modules/sql/mw_data_sqlite_install.php b/mw/app/data/modules/sql/mw_data_sqlite_install.php
index 8c26638..2f241f6 100644
--- a/mw/app/data/modules/sql/mw_data_sqlite_install.php
+++ b/mw/app/data/modules/sql/mw_data_sqlite_install.php
@@ -28,13 +28,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";
@@ -85,6 +89,14 @@
         .")";
         $sgbd->query($sql);
 
+        $sql =
+         "CREATE TABLE #--versions("
+        ." id INTEGER PRIMARY KEY AUTOINCREMENT,"
+        ."  application TEXT NOT NULL,"
+        ."  version TEXT NOT NULL"
+        .")";
+        $sgbd->query($sql);
+
       }
       catch(Exception $e){
         return "imposible de creer les tables en base. ".$e->getMessage();
@@ -153,6 +165,10 @@
          "INSERT INTO #--roles(`id`, `nom`, `intitule`) VALUES (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.";