projects
/
mtweb
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
maj version dans config.xml
[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{
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();
$env = $this->env();
$data = $env->data();
$sgbd = $data->sgbd();
@@
-28,13
+28,17
@@
catch(Exception $e){
return $e->getMessage();
}
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")
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";
}
catch(Exception $e){
return "impossible de savoir si les tables existent deja";
@@
-85,6
+89,14
@@
.")";
$sgbd->query($sql);
.")";
$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();
}
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);
"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.";
}
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