create new table for user preferences

stonebuzz · stonebuzz · commit 72654292f2cb · 2014-10-10T14:18:01.000+02:00
diff --git a/hook.php b/hook.php
@@ -46,8 +46,8 @@
  */
 function plugin_mantis_install() {
 
-   require_once('inc/mantis.class.php');
-   PluginMantisMantis::install();
+    require_once('inc/mantis.class.php');
+    PluginMantisMantis::install();
 
     global $DB;
 
@@ -59,28 +59,44 @@ function plugin_mantis_install() {
                idTicket int(11) NOT NULL,
                idMantis int(11) NOT NULL,
                dateEscalade date NOT NULL,
+               itemType varchar NOT NULL,
                user int(11) NOT NULL)";
         $DB->query($query) or die($DB->error());
     }else{
-        $mig = new Migration();
+        $mig = new Migration(200);
         $table = 'glpi_plugin_mantis_mantis';
         $mig->addField($table, 'itemType', 'string');
         $mig->executeMigration();
     }
 
 
+    // création de la table du plugin
+    if (!TableExists("glpi_plugin_mantis_userprefs")) {
+        $query = "CREATE TABLE glpi_plugin_mantis_userprefs (
+               id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+               users_id int(11) NOT NULL ,
+               followTask int(11) NOT NULL default '0',
+               followFollow int(11) NOT NULL default '0',
+               followAttachment int(11) NOT NULL default '0',
+               followTitle int(11) NOT NULL default '0',
+               followDescription int(11) NOT NULL default '0',
+               followCategorie int(11) NOT NULL default '0',
+               followLinkedItem int(11) NOT NULL default '0',
+               UNIQUE KEY (`users_id`))";
+        $DB->query($query) or die($DB->error());
+    }
+
+
 
 
    // Création de la table uniquement lors de la première installation
    if (!TableExists("glpi_plugin_mantis_profiles")) {
-
       // requete de création de la table
       $query = "CREATE TABLE `glpi_plugin_mantis_profiles` (
                `id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_profiles (id)',
                `right` char(1) collate utf8_unicode_ci default NULL,
                PRIMARY KEY  (`id`)
              ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
-
       $DB->queryOrDie($query, $DB->error());
 
       //creation du premier accès nécessaire lors de l'installation du plugin
@@ -98,24 +114,26 @@ function plugin_mantis_install() {
                   pwd varchar(255) NOT NULL default '',
                   champsUrlGlpi varchar(100) NOT NULL default '',
                   champsGlpi varchar(100) NOT NULL default '',
-                  enable_assign int(1) NOT NULL default 0,
+                  enable_assign int(3) NOT NULL default 0,
+                  neutralize_escalation int(3) NOT NULL default 0,
+                  status_after_escalation int(3) NOT NULL default 0,
+                  show_option_delete int(3) NOT NULL default 0,
+                  doc_categorie int(3) NOT NULL default 0,
+                  itemType varchar(255) NOT NULL,
                   etatMantis varchar(100) NOT NULL default '')";
         $DB->query($query) or die($DB->error());
-
         //insertion du occcurence dans la table (occurrence par default)
         $query = "INSERT INTO glpi_plugin_mantis_configs
                        (id, host,url,login,pwd)
                 VALUES (NULL, '','','','')";
         $DB->query($query) or die("error in glpi_plugin_mantis_configs table" . $DB->error());
     }else{
-
-        $mig = new Migration();
+        $mig = new Migration(200);
         $table = 'glpi_plugin_mantis_configs';
         $mig->addField($table, 'neutralize_escalation', 'integer',array('value' => 5));
         $mig->addField($table, 'status_after_escalation', 'integer');
         $mig->addField($table, 'show_option_delete', 'integer',array('value' => 0));
         $mig->addField($table, 'doc_categorie', 'integer',array('value' => 0));
-
         $mig->addField($table, 'itemType', 'string');
         $mig->executeMigration();
     }
@@ -129,15 +147,6 @@ function plugin_mantis_install() {
  * @return boolean
  */
 function plugin_mantis_uninstall() {
-    global $DB;
-
-    $tables = array("glpi_plugin_mantis_mantis",
-        "glpi_plugin_mantis_profiles");
-
-    Foreach ($tables as $table) {
-        $DB->query("DROP TABLE IF EXISTS " . $table . ";");
-    }
-
    require_once('inc/mantis.class.php');
    PluginMantisMantis::uninstall();
    return true;
