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_sql_install.php
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
(file)
--- 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{
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();
$env = $this->env();
$data = $env->data();
$sgbd = $data->sgbd();
@@
-22,13
+22,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";
@@
-89,6
+93,15
@@
.") DEFAULT CHARSET=utf8";
$sgbd->query($sql);
.") 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";
}
catch(Exception $e){
return "imposible de creer les tables en base";
@@
-126,6
+139,11
@@
."(3, 'webmaster', 'webmaster')";
$sgbd->query($sql);
."(3, 'webmaster', 'webmaster')";
$sgbd->query($sql);
+ $sql =
+ "INSERT INTO #--versions(`application`, `version`) VALUES"
\r
+ ."('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.";
@@
-134,5
+152,3
@@
}
}
}
}
-
-?>
\ No newline at end of file