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";
.")";
$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();
"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.";