3 class mw_data_sqlite_install extends mw_data{
5 function install_sqlite($params){
9 $host = isset($params["host"]) ? $params["host"] : "";
10 $base = isset($params["base"]) ? $params["base"] : "";
11 $user = isset($params["user"]) ? $params["user"] : "";
12 $password = isset($params["password"]) ? $params["password"] : "";
13 if(!$host || !$base) return "paramètres manquant pour la base SQLite";
15 $parent_dir = dirname($host);
16 if(is_dir($parent_dir)) @mkdir($host);
17 if(!is_dir($host)) return "impossible de créer le répertoire des données SQLite";
26 $sgbd->select_db($base);
29 return $e->getMessage();
33 $sgbd->table_exists("#--actions_roles")
34 || $sgbd->table_exists("#--config")
35 || $sgbd->table_exists("#--roles")
36 || $sgbd->table_exists("#--users")
37 || $sgbd->table_exists("#--users_roles");
40 return "impossible de savoir si les tables existent deja";
43 return "des tables a installer existent deja en base. installation annulee";
48 "CREATE TABLE #--actions_roles("
\r
49 ." id INTEGER PRIMARY KEY AUTOINCREMENT,"
50 ." `action` TEXT NOT NULL,"
\r
51 ." id_role INTEGER NOT NULL"
\r
56 "CREATE TABLE #--config("
\r
57 ." id INTEGER PRIMARY KEY AUTOINCREMENT,"
\r
58 ." `key` TEXT NOT NULL,"
\r
59 ." `value` TEXT NOT NULL"
\r
64 "CREATE TABLE #--roles("
\r
65 ." id INTEGER PRIMARY KEY AUTOINCREMENT,"
\r
66 ." nom TEXT NOT NULL,"
\r
67 ." intitule TEXT NOT NULL"
\r
72 "CREATE TABLE #--users("
\r
73 ." id INTEGER PRIMARY KEY AUTOINCREMENT,"
\r
74 ." login TEXT NOT NULL,"
\r
75 ." password TEXT NOT NULL,"
\r
76 ." email TEXT NOT NULL"
\r
81 "CREATE TABLE #--users_roles("
\r
82 ." id INTEGER PRIMARY KEY AUTOINCREMENT,"
\r
83 ." id_user INTEGER NOT NULL,"
\r
84 ." id_role INTEGER NOT NULL"
90 return "imposible de creer les tables en base. ".$e->getMessage();
94 "INSERT INTO #--actions_roles (`id`, `action`, `id_role`) VALUES (13, 'admin', 1)";
\r
97 "INSERT INTO #--actions_roles (`id`, `action`, `id_role`) VALUES (14, 'users', 2)";
100 "INSERT INTO #--actions_roles (`id`, `action`, `id_role`) VALUES (19, 'users/identification', 0)";
103 "INSERT INTO #--actions_roles (`id`, `action`, `id_role`) VALUES (20, 'config', 3)";
\r
107 "INSERT INTO #--config(id, `key`, `value`) VALUES (1, 'site_name', 'mtweb')";
\r
110 "INSERT INTO #--config(id, `key`, `value`) VALUES (2, 'max_list', '10')";
113 "INSERT INTO #--config(id, `key`, `value`) VALUES (3, 'description', '')";
\r
116 "INSERT INTO #--config(id, `key`, `value`) VALUES (4, 'out', 'default')";
119 "INSERT INTO #--config(id, `key`, `value`) VALUES (5, 'start_action', '')";
\r
122 "INSERT INTO #--config(id, `key`, `value`) VALUES (6, 'contact_form', '0')";
125 "INSERT INTO #--config(id, `key`, `value`) VALUES (8, 'email', '')";
\r
128 "INSERT INTO #--config(id, `key`, `value`) VALUES (9, 'captcha', '0')";
131 "INSERT INTO #--config(id, `key`, `value`) VALUES (16, 'start_action_params', '')";
\r
134 "INSERT INTO #--config(id, `key`, `value`) VALUES (20, 'out_navig_menu_top', 'on')";
137 "INSERT INTO #--config(id, `key`, `value`) VALUES (22, 'out_colonne', 'on')";
\r
140 "INSERT INTO #--config(id, `key`, `value`) VALUES (29, 'default_allow', '1')";
144 "INSERT INTO #--roles(`id`, `nom`, `intitule`) VALUES (0, 'guest', 'invité')";
\r
147 "INSERT INTO #--roles(`id`, `nom`, `intitule`) VALUES (1, 'admin', 'administrateur')";
150 "INSERT INTO #--roles(`id`, `nom`, `intitule`) VALUES (2, 'membre', 'membre')";
153 "INSERT INTO #--roles(`id`, `nom`, `intitule`) VALUES (3, 'webmaster', 'webmaster')";
158 return "les tables ont ete ajoutees en base mais impossible d'y enregistrer les valeurs par defaut.";