implementations sgbd dans env/sgbd

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

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..7e42995 100644 (file)
--- a/mw/app/data/modules/sql/mw_data_sqlite_install.php
+++ b/mw/app/data/modules/sql/mw_data_sqlite_install.php
@@ -2,7 +2,7 @@
 
   class mw_data_sqlite_install extends mw_data{
 
-    function install_sqlite($params){
+    public function install_sqlite($params){
       $env = $this->env();
       $data = $env->data();
       $sgbd = $data->sgbd();
@@ -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.";
@@ -161,5 +177,3 @@
     }
 
   }
-
-?>
\ No newline at end of file