Ejemplo n.º 1
0
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "astreintes";
     $this->makeRevision("all");
     $query = "CREATE TABLE `plage_astreinte` (\r\n      `plage_id` INT (11) UNSIGNED NOT NULL auto_increment,\r\n      `date_debut` DATE NOT NULL,\r\n      `date_fin` DATE NOT NULL,\r\n      `libelle` VARCHAR (255) NOT NULL,\r\n      `user_id` INT (11) UNSIGNED,\r\n      PRIMARY KEY (`plage_id`)\r\n      ) /*! ENGINE=MyISAM */ COMMENT='table des astreintes'";
     $this->addQuery($query);
     $this->makeRevision("0.1");
     $query = "RENAME TABLE `plage_astreinte` TO `astreinte_plage`";
     $this->addQuery($query);
     $query = "ALTER TABLE `astreinte_plage`\r\n      ADD `type` VARCHAR (255) NOT NULL,\r\n      CHANGE `date_debut` `start` DATETIME NOT NULL,\r\n      CHANGE `date_fin` `end` DATETIME NOT NULL,\r\n      ADD `phone_astreinte` INT (11) UNSIGNED";
     $this->addQuery($query);
     $this->makeRevision("0.2");
     $query = "ALTER TABLE `astreinte_plage`\r\n      CHANGE `libelle` `libelle` VARCHAR (255),\r\n      CHANGE `user_id` `user_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\r\n      CHANGE `type` `type` ENUM ('medical','admin','personnelsoignant') NOT NULL,\r\n      CHANGE `phone_astreinte` `phone_astreinte` VARCHAR (20) NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.3");
     $query = "ALTER TABLE `astreinte_plage`\r\n                ADD INDEX (`user_id`),\r\n                ADD INDEX (`start`),\r\n                ADD INDEX (`end`);";
     $this->addQuery($query);
     $this->makeRevision("0.4");
     $query = "ALTER TABLE `astreinte_plage`\r\n      CHANGE `phone_astreinte` `phone_astreinte` VARCHAR (30) NOT NULL,\r\n      ADD `group_id` INT (11) UNSIGNED NOT NULL;";
     $this->addQuery($query);
     $query = "ALTER TABLE `astreinte_plage`\r\n      ADD INDEX (`group_id`);";
     $this->addQuery($query);
     $this->mod_version = "0.5";
 }
Ejemplo n.º 2
0
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "forms";
     $this->makeRevision("all");
     $this->mod_version = "0.01";
 }
Ejemplo n.º 3
0
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "dPstats";
     $this->makeRevision("all");
     $this->makeRevision("0.1");
     $query = "CREATE TABLE `temps_op` (\r\n               `temps_op_id` INT(11) NOT NULL AUTO_INCREMENT ,\r\n               `chir_id` INT(11) NOT NULL ,\r\n               `ccam` VARCHAR( 100 ) NOT NULL ,\r\n               `nb_intervention` INT(11) NOT NULL ,\r\n               `estimation` TIME NOT NULL ,\r\n               `occup_moy` TIME NOT NULL ,\r\n               `occup_ecart` TIME NOT NULL ,\r\n               `duree_moy` TIME NOT NULL ,\r\n               `duree_ecart` TIME NOT NULL,\r\n               PRIMARY KEY  (temps_op_id)\r\n               ) /*! ENGINE=MyISAM */ COMMENT='Table temporaire des temps operatoire';";
     $this->addQuery($query);
     $query = "CREATE TABLE `temps_prepa` (\r\n               `temps_prepa_id` INT(11) NOT NULL AUTO_INCREMENT ,\r\n               `chir_id` INT(11) NOT NULL ,\r\n               `nb_prepa` INT(11) NOT NULL ,\r\n               `nb_plages` INT(11) NOT NULL ,\r\n               `duree_moy` TIME NOT NULL ,\r\n               `duree_ecart` TIME NOT NULL,\r\n               PRIMARY KEY  (temps_prepa_id)\r\n               ) /*! ENGINE=MyISAM */ COMMENT='Table temporaire des temps preparatoire';";
     $this->addQuery($query);
     $this->makeRevision("0.11");
     $query = "ALTER TABLE `temps_op` ADD INDEX ( `chir_id` );";
     $this->addQuery($query);
     $query = "ALTER TABLE `temps_op` ADD INDEX ( `ccam` );";
     $this->addQuery($query);
     $query = "ALTER TABLE `temps_prepa` ADD INDEX ( `chir_id` );";
     $this->addQuery($query);
     $this->makeRevision("0.12");
     $query = "CREATE TABLE `temps_hospi` (\r\n               `temps_hospi_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,\r\n               `praticien_id` INT(11) UNSIGNED NOT NULL,\r\n               `ccam` VARCHAR( 100 ) NOT NULL,\r\n               `type` ENUM('ambu','comp') DEFAULT 'ambu' NOT NULL,\r\n               `nb_sejour` INT(11) UNSIGNED DEFAULT NULL,\r\n               `duree_moy` FLOAT UNSIGNED DEFAULT NULL,\r\n               `duree_ecart` FLOAT UNSIGNED DEFAULT NULL,\r\n               PRIMARY KEY (`temps_hospi_id`),\r\n               INDEX (`praticien_id`),\r\n               INDEX (`ccam`)\r\n               ) /*! ENGINE=MyISAM */ COMMENT='Table temporaire des temps d\\'hospitalisation';";
     $this->addQuery($query);
     $this->makeRevision("0.13");
     $query = "ALTER TABLE `temps_hospi` CHANGE `ccam` `ccam` varchar(255) NOT NULL;";
     $this->addQuery($query);
     $query = "ALTER TABLE `temps_op` " . "\nCHANGE `temps_op_id` `temps_op_id` int(11) unsigned NOT NULL AUTO_INCREMENT," . "\nCHANGE `chir_id` `chir_id` int(11) unsigned NOT NULL DEFAULT '0'," . "\nCHANGE `ccam` `ccam` varchar(255) NOT NULL," . "\nCHANGE `nb_intervention` `nb_intervention` int(11) unsigned NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $query = "ALTER TABLE `temps_prepa` " . "\nCHANGE `temps_prepa_id` `temps_prepa_id` int(11) unsigned NOT NULL AUTO_INCREMENT," . "\nCHANGE `chir_id` `chir_id` int(11) unsigned NOT NULL DEFAULT '0'," . "\nCHANGE `nb_prepa` `nb_prepa` int(11) unsigned NOT NULL DEFAULT '0'," . "\nCHANGE `nb_plages` `nb_plages` int(11) unsigned NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.14");
     $query = "ALTER TABLE `temps_hospi` " . "\nCHANGE `type` `type` enum('comp','ambu','seances','ssr','psy') NOT NULL DEFAULT 'ambu';";
     $this->addQuery($query);
     $this->makeRevision("0.15");
     $query = "ALTER TABLE `temps_op`\r\n               ADD `reveil_moy` TIME NOT NULL ,\r\n               ADD `reveil_ecart` TIME NOT NULL;";
     $this->addQuery($query);
     $this->mod_version = "0.16";
 }
Ejemplo n.º 4
0
 /**
  * @see parent::__construct
  */
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "dPdeveloppement";
     $this->makeRevision("all");
     $this->mod_version = "0.1";
 }
Ejemplo n.º 5
0
 /** @see parent::__construct() */
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "drawing";
     $this->makeRevision("all");
     $this->addDependency("dPfiles", "0.30");
     $this->makeRevision("0.1");
     $query = "CREATE TABLE `drawing_category` (\n                `drawing_category_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n                `name` VARCHAR (255) NOT NULL,\n                `description` VARCHAR (255),\n                `creation_datetime` DATETIME NOT NULL\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `drawing_category`\n                ADD INDEX (`creation_datetime`);";
     $this->addQuery($query);
     $this->makeRevision("0.2");
     $this->addPrefQuery("drawing_background", "ffffff");
     $this->makeRevision("0.3");
     $this->addPrefQuery("drawing_advanced_mode", 0);
     $this->makeRevision("0.4");
     $query = "ALTER TABLE `drawing_category`\n                CHANGE `description` `description` TEXT,\n                ADD `object_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\n                ADD `object_class` VARCHAR (80) NOT NULL;";
     $this->addQuery($query);
     $query = "ALTER TABLE `drawing_category`\n                ADD INDEX (`name`),\n                ADD INDEX (`object_id`),\n                ADD INDEX (`object_class`);";
     $this->addQuery($query);
     $this->makeRevision("0.5");
     $this->delPrefQuery("drawing_advanced_mode");
     $query = "ALTER TABLE `drawing_category`\n                ADD `group_id` INT (11) UNSIGNED,\n                ADD `function_id` INT (11) UNSIGNED,\n                ADD `user_id` INT (11) UNSIGNED,\n                DROP `object_id`,\n                DROP `object_class`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `drawing_category`\n                ADD INDEX (`group_id`),\n                ADD INDEX (`function_id`),\n                ADD INDEX (`user_id`);";
     $this->addQuery($query);
     $this->mod_version = "0.6";
 }
Ejemplo n.º 6
0
 /** Constructor */
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "dPadmissions";
     $this->makeRevision("all");
     $this->mod_version = "0.1";
 }
Ejemplo n.º 7
0
 /**
  * @see parent::__construct()
  */
 function __construct()
 {
     parent::__construct();
     $this->mod_name = 'dPportail';
     $this->makeRevision('all');
     $query = 'CREATE TABLE `forum_theme` (
           `forum_theme_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, 
           `title` TEXT NOT NULL, 
           `desc` TEXT, 
           PRIMARY KEY (`forum_theme_id`)) /*! ENGINE=MyISAM */;';
     $this->addQuery($query);
     $query = 'CREATE TABLE `forum_message` (
           `forum_message_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, 
           `forum_thread_id` INT(11) UNSIGNED NOT NULL, 
           `body` TEXT NOT NULL, 
           `date` DATETIME NOT NULL, 
           `user_id` INT(11) UNSIGNED NOT NULL,
           PRIMARY KEY (`forum_message_id`)) /*! ENGINE=MyISAM */;';
     $this->addQuery($query);
     $query = 'CREATE TABLE `forum_thread` (
           `forum_thread_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, 
           `forum_theme_id` INT(11) UNSIGNED NOT NULL, 
           `title` TEXT NOT NULL, 
           `body` TEXT NOT NULL, 
           `date` DATETIME NOT NULL, 
           `user_id` INT(11) UNSIGNED NOT NULL,
           PRIMARY KEY (`forum_thread_id`)) /*! ENGINE=MyISAM */;';
     $this->addQuery($query);
     $this->makeRevision("0.10");
     $query = "ALTER TABLE `forum_message` \n              ADD INDEX (`date`),\n              ADD INDEX (`user_id`),\n              ADD INDEX (`forum_thread_id`);";
     $this->addQuery($query);
     $query = "ALTER TABLE `forum_thread` \n              ADD INDEX (`forum_theme_id`),\n              ADD INDEX (`date`),\n              ADD INDEX (`user_id`);";
     $this->addQuery($query);
     $this->mod_version = '0.11';
 }
Ejemplo n.º 8
0
 function __construct()
 {
     parent::__construct();
     $this->mod_name = 'bloodSalvage';
     $this->makeRevision('all');
     $query = 'CREATE TABLE `blood_salvage` (
   `blood_salvage_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,
   `operation_id` INT (11) UNSIGNED NOT NULL,
   `cell_saver_id` INT (11) UNSIGNED NOT NULL,
   `incident_file_id` INT (11) UNSIGNED,
   `wash_volume` INT (11),
   `saved_volume` INT (11),
   `hgb_pocket` INT (11),
   `hgb_patient` INT (11),
   `transfused_volume`INT(11),
   `anticoagulant_cip` VARCHAR(7),
   `recuperation_start` DATETIME,
   `recuperation_end` DATETIME,
   `transfusion_start` DATETIME,
   `transfusion_end` DATETIME
 ) /*! ENGINE=MyISAM */;';
     $this->addQuery($query);
     $query = 'ALTER TABLE `blood_salvage`
   ADD INDEX (`operation_id`),
   ADD INDEX (`cell_saver_id`),
   ADD INDEX (`incident_file_id`),
   ADD INDEX (`recuperation_start`),
   ADD INDEX (`recuperation_end`),
   ADD INDEX (`transfusion_start`),
   ADD INDEX (`transfusion_end`);';
     $this->addQuery($query);
     $this->makeRevision('0.01');
     $query = 'ALTER TABLE `blood_salvage` 
         ADD `receive_kit` VARCHAR( 32 ),
         ADD `wash_kit` VARCHAR( 32 ) ';
     $this->addQuery($query);
     $query = 'CREATE TABLE `cell_saver` (
 `cell_saver_id`  INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,
 `marque` VARCHAR(50) NOT NULL,
 `modele` VARCHAR( 30 ) NOT NULL
  ) /*! ENGINE=MyISAM */;';
     $this->addQuery($query);
     $query = "CREATE TABLE `type_ei` (\n          `type_ei_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,\n          `concerne` ENUM( 'pat', 'vis', 'pers', 'med', 'mat' ) NOT NULL ,\n          `desc` TEXT NULL,\n          `name` VARCHAR( 30 ) NOT NULL\n          ) /*! ENGINE=MyISAM */ ;";
     $this->addQuery($query);
     $query = " ALTER TABLE `blood_salvage` \n             CHANGE `incident_file_id` `type_ei_id` INT( 11 ) UNSIGNED NULL DEFAULT NULL ;";
     $this->addQuery($query);
     $this->makeRevision('0.02');
     $query = " ALTER TABLE `type_ei`\n             ADD `evenements` VARCHAR( 255 ) NOT NULL,\n             ADD `type_signalement` ENUM('inc','ris') NOT NULL ;";
     $this->addQuery($query);
     $this->makeRevision('0.03');
     $query = " ALTER TABLE `blood_salvage` \n             ADD `sample` ENUM( 'non', 'prel', 'trans' ) NOT NULL DEFAULT 'non' ;";
     $this->addQuery($query);
     $this->makeRevision('0.1');
     $query = "ALTER TABLE `blood_salvage` \n            CHANGE `receive_kit` `receive_kit_ref` VARCHAR( 32 ) NULL DEFAULT NULL ,\n            CHANGE `wash_kit` `wash_kit_ref` VARCHAR( 32 ) NULL DEFAULT NULL ,\n            ADD `receive_kit_lot` VARCHAR( 32 ) NULL DEFAULT NULL AFTER `receive_kit_ref` ,\n            ADD `wash_kit_lot` VARCHAR( 32 ) NULL DEFAULT NULL AFTER `wash_kit_ref`";
     $this->addQuery($query);
     $this->mod_version = '0.2';
 }
Ejemplo n.º 9
0
 /**
  * Constructeur
  */
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "dPboard";
     $this->makeRevision("all");
     $this->makeRevision("0.1");
     // user authorization to see others user in TDB
     $this->addFunctionalPermQuery("allow_other_users_board", 'write_right');
     $this->mod_version = "0.2";
 }
Ejemplo n.º 10
0
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "sip";
     $this->makeRevision("all");
     $this->makeRevision("0.11");
     // Déplacement des requêtes dans le module H'XML
     $this->addDependency("webservices", "0.16");
     $this->mod_version = "0.23.1";
 }
Ejemplo n.º 11
0
 public function setPage()
 {
     if (file_exists("Includes/config.inc.php")) {
         require_once "Includes/config.inc.php";
         $logged = -1;
         $session = new USession();
         $VIndex = new VIndex();
         $controller = $VIndex->getController();
         $task = $VIndex->getTask();
         if ($controller == "log" && ($task == "in" || $task == "out")) {
             $CLog = new CLog();
             $CLog->mux();
             $VIndex->deleteController();
             $VIndex->deleteTask();
         }
         $logged = $session->getValue('type');
         if ($logged === false) {
             $logged = -1;
         }
         if ($VIndex->isClient()) {
             $CAjax = new CAjax();
             $CAjax->mux($logged);
         } else {
             $content = $this->mux($logged);
             $logged = $session->getValue('type');
             if ($logged === false) {
                 $logged = -1;
             }
             $VIndex->setContent($content);
             if ($logged >= 0) {
                 $VIndex->setLoggedPage();
             } else {
                 $VIndex->setGuestPage();
             }
             $VIndex->showPage();
         }
     } else {
         $CSetup = new CSetup();
         $CSetup->mux();
     }
 }
Ejemplo n.º 12
0
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "passwordKeeper";
     $this->makeRevision("all");
     $query = "CREATE TABLE `password_keeper` (\n      `password_keeper_id` INT(11)      UNSIGNED NOT NULL AUTO_INCREMENT,\n      `keeper_name`        VARCHAR(50)  NOT NULL,\n      `is_public`          BOOLEAN      DEFAULT 0,\n      `iv`                 VARCHAR(255) NOT NULL,\n      `sample`             VARCHAR(255) NOT NULL,\n      `user_id`            INT(11)      UNSIGNED NOT NULL,\n      PRIMARY KEY (`password_keeper_id`)) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "CREATE TABLE `password_category` (\n      `category_id`        INT(11)     UNSIGNED NOT NULL AUTO_INCREMENT,\n      `category_name`      VARCHAR(50) NOT NULL,\n      `password_keeper_id` INT(11)     UNSIGNED NOT NULL,\n      PRIMARY KEY (`category_id`)) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "CREATE TABLE `password_entry` (\n      `password_id`          INT(11)      UNSIGNED NOT NULL AUTO_INCREMENT,\n      `password_description` VARCHAR(50)  NOT NULL,\n      `password`             VARCHAR(255) NOT NULL,\n      `password_last_change` DATETIME     NOT NULL,\n      `iv`                   VARCHAR(255) NOT NULL,\n      `password_comments`    TEXT,\n      `category_id`          INT(11)      UNSIGNED NOT NULL,\n      PRIMARY KEY (`password_id`)) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->mod_version = "0.01";
 }
Ejemplo n.º 13
0
 /**
  * @see parent::__construct()
  */
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "search";
     $this->makeRevision("all");
     $this->makeRevision("0.01");
     $query = "CREATE TABLE `search_indexing` (\r\n              `search_indexing_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n              `object_class` VARCHAR (50) NOT NULL,\r\n              `object_id` INT (11) UNSIGNED NOT NULL,\r\n              `type` ENUM('create','store','delete','merge') NOT NULL DEFAULT 'create',\r\n              `date` DATETIME NOT NULL\r\n              ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("0.02");
     $query = "ALTER TABLE `search_indexing`\r\n              CHANGE `object_class` `object_class` CHAR(50) NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.03");
     $query = "ALTER TABLE `search_indexing`\r\n              ADD INDEX `index_order` (`object_class`, `type`, `search_indexing_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.04");
     $query = "CREATE TABLE `search_thesaurus_entry` (\r\n              `search_thesaurus_entry_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n              `entry` TEXT NOT NULL,\r\n              `types` TEXT,\r\n              `titre` VARCHAR (255),\r\n              `contextes` ENUM('generique','pharmacie','pmsi','bloc') NOT NULL DEFAULT 'generique',\r\n              `agregation` ENUM('0','1') NOT NULL DEFAULT '0',\r\n              `group_id` INT(11) UNSIGNED ,\r\n              `function_id` INT(11) UNSIGNED ,\r\n              `user_id` INT(11) UNSIGNED\r\n              ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("0.05");
     $query = "\r\n        CREATE TABLE IF NOT EXISTS `rss_search_items` (\r\n          `rss_search_item_id` BIGINT NOT NULL AUTO_INCREMENT ,\r\n          `rss_id` BIGINT NOT NULL ,\r\n          `search_id` BIGINT NOT NULL,\r\n          `search_class` char(40),\r\n          `rmq` text,\r\n          PRIMARY KEY ( `rss_search_item_id` ) ,\r\n          INDEX ( `rss_id`, `search_id`, `search_class`)\r\n          ) /*! ENGINE=MyISAM */ COMMENT = 'Table des Search Items';";
     $this->addQuery($query);
     $this->makeRevision("0.06");
     $query = "\r\n        CREATE TABLE  `search_thesaurus_entry_target` (\r\n          `search_thesaurus_entry_target_id` BIGINT NOT NULL AUTO_INCREMENT ,\r\n          `search_thesaurus_entry_id` BIGINT NOT NULL ,\r\n          `object_class` VARCHAR(50),\r\n          `object_id`  VARCHAR(50),\r\n          PRIMARY KEY (`search_thesaurus_entry_target_id`),\r\n          INDEX (`search_thesaurus_entry_id`),\r\n          INDEX (`object_id`, `object_class`)\r\n          ) /*! ENGINE=MyISAM */ COMMENT = 'Table des cibles de favoris';";
     $this->addQuery($query);
     $this->makeRevision("0.07");
     $query = "\r\n        ALTER TABLE `search_thesaurus_entry`\r\n        CHANGE `contextes` `contextes` VARCHAR(255) NOT NULL DEFAULT 'generique';";
     $this->addQuery($query);
     $query = "\r\n        ALTER TABLE `search_thesaurus_entry_target`\r\n        CHANGE `search_thesaurus_entry_target_id` `search_thesaurus_entry_target_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,\r\n        CHANGE `search_thesaurus_entry_id` `search_thesaurus_entry_id` INT(11) UNSIGNED\r\n        ;";
     $this->addQuery($query);
     $query = "UPDATE `search_thesaurus_entry` SET `contextes`='prescription' WHERE `contextes`= 'bloc'";
     $this->addQuery($query);
     $query = "\r\n        ALTER TABLE `rss_search_items`\r\n        CHANGE `rss_search_item_id` `rss_search_item_id` INT(11) UNSIGNED,\r\n        CHANGE `rss_id` `rss_id` INT(11) UNSIGNED,\r\n        CHANGE `search_id` `search_id` INT(11) UNSIGNED\r\n        ;";
     $this->addQuery($query);
     $this->makeRevision("0.08");
     $query = "DROP TABLE IF EXISTS `rss_search_items`";
     $this->addQuery($query);
     $query = "CREATE TABLE `rss_search_items` (\r\n                `rss_search_item_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `rss_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\r\n                `search_id` INT (11),\r\n                `search_class` VARCHAR (40),\r\n                `rmq` TEXT\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `rss_search_items`\r\n                ADD INDEX (`rss_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.09");
     $query = "ALTER TABLE `search_thesaurus_entry`\r\n                CHANGE `entry` `entry` TEXT,\r\n                CHANGE `types` `types` VARCHAR (255),\r\n                CHANGE `contextes` `contextes` ENUM ('generique','pharmacie','pmsi','prescription','classique'),\r\n                CHANGE `agregation` `agregation` ENUM ('0','1') DEFAULT '0',\r\n                CHANGE `user_id` `user_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\r\n                ADD `search_auto` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $query = "ALTER TABLE `search_thesaurus_entry`\r\n                ADD INDEX (`group_id`),\r\n                ADD INDEX (`function_id`),\r\n                ADD INDEX (`user_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.10");
     $query = "ALTER TABLE `rss_search_items`\r\n                ADD `user_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "ALTER TABLE `rss_search_items`\r\n                ADD INDEX (`user_id`);";
     $this->addQuery($query);
     $this->mod_version = "0.11";
 }
Ejemplo n.º 14
0
 /**
  * @see parent::__construct()
  */
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "printing";
     $this->makeRevision("all");
     $query = "CREATE TABLE `source_lpr` (\n      `source_lpr_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n      `name` VARCHAR (255) NOT NULL,\n      `object_id` BIGINT DEFAULT NULL,\n      `object_class` VARCHAR(30) DEFAULT NULL,\n      `host` TEXT NOT NULL,\n      `port` INT (11) DEFAULT NULL,\n      `user` VARCHAR (255),\n      `printer_name` VARCHAR (50)\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("0.01");
     $query = "CREATE TABLE `source_smb` (\n      `source_smb_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n      `name` VARCHAR (255) NOT NULL,\n      `object_id` BIGINT DEFAULT NULL,\n      `object_class` VARCHAR(30) DEFAULT NULL,\n      `host` TEXT NOT NULL,\n      `port` INT (11) DEFAULT NULL,\n      `user` VARCHAR (255),\n      `password` VARCHAR (50),\n      `workgroup` VARCHAR (50), \n      `printer_name` VARCHAR (50)\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("0.02");
     $query = "CREATE TABLE IF NOT EXISTS `printer` (\n      `printer_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n      `function_id` INT (11) DEFAULT NULL,\n      `object_id` INT (11) DEFAULT NULL,\n      `object_class` VARCHAR (255) DEFAULT NULL\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("0.03");
     $query = "ALTER TABLE `printer`\n      ADD `label` VARCHAR (255);";
     $this->addQuery($query);
     $this->mod_version = "0.04";
 }
Ejemplo n.º 15
0
 /**
  * The constructor
  *
  * @return \CSetupdicom
  */
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "dicom";
     $this->makeRevision("all");
     $query = "CREATE TABLE `dicom_sender` (\n                `dicom_sender_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n                `nom` VARCHAR (255) NOT NULL,\n                `libelle` VARCHAR (255),\n                `group_id` INT (11) UNSIGNED NOT NULL,\n                `user_id` INT (11) UNSIGNED,\n                `actif` ENUM ('0','1') NOT NULL DEFAULT '0',\n                `save_unsupported_message` ENUM ('0','1') DEFAULT '1',\n                `create_ack_file` ENUM ('0','1') DEFAULT '1',\n                `delete_file` ENUM ('0','1') DEFAULT '1'\n              ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "CREATE TABLE `dicom_source` (\n                `dicom_source_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n                `name` VARCHAR (255) NOT NULL,\n                `role` ENUM ('prod', 'qualif') NOT NULL DEFAULT 'qualif',\n                `host` TEXT NOT NULL,\n                `type_echange` VARCHAR (255),\n                `active` ENUM ('0','1') NOT NULL DEFAULT '1',\n                `loggable` ENUM ('0','1') NOT NULL DEFAULT '1',\n                `port` INT (11) NOT NULL\n              ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "CREATE TABLE `dicom_session` (\n                `dicom_session_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n                `receiver` VARCHAR (255) NOT NULL,\n                `sender` VARCHAR (255) NOT NULL,\n                `begin_date` DATETIME NOT NULL,\n                `end_date` DATETIME,\n                `messages` TEXT,\n                `status` ENUM('Rejected', 'Completed', 'Aborted'),\n                `group_id` INT (11) UNSIGNED,\n                `sender_id` INT (11) UNSIGNED,\n                `receiver_id` INT (11) UNSIGNED,\n                `dicom_exchange_id` INT (11) UNSIGNED,\n                `state` VARCHAR (255) NOT NULL,\n                `presentation_contexts` VARCHAR (255)\n              ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `dicom_session`\n                ADD INDEX (`begin_date`);";
     $this->addQuery($query);
     $query = "CREATE TABLE `dicom_exchange` (\n                `dicom_exchange_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n                `requests` TEXT NOT NULL,\n                `responses` TEXT NOT NULL,\n                `presentation_contexts` VARCHAR (255),\n                `group_id` INT (11) UNSIGNED NOT NULL,\n                `date_production` DATETIME NOT NULL,\n                `sender_id` INT (11) UNSIGNED,\n                `sender_class` ENUM ('CDicomSender'),\n                `receiver_id` INT (11) UNSIGNED,\n                `type` VARCHAR (255),\n                `sous_type` VARCHAR (255),\n                `date_echange` DATETIME,\n                `statut_acquittement` VARCHAR (255),\n                `message_valide` ENUM ('0','1') DEFAULT '0',\n                `acquittement_valide` ENUM ('0','1') DEFAULT '0',\n                `id_permanent` VARCHAR (255),\n                `object_id` INT (11) UNSIGNED,\n                `object_class` VARCHAR (80)\n              ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `dicom_exchange`\n                ADD INDEX (`date_production`);";
     $this->addQuery($query);
     $this->makeRevision("0.1");
     //    $query = "CREATE TABLE `dicom_table_entry` (
     //                `dicom_table_entry_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,
     //                `group_number` INT (11) NOT NULL,
     //                `element_number` INT (11) NOT NULL,
     //                `mb_object_class` VARCHAR (255) NOT NULL,
     //                `mb_object_attr` VARCHAR (255) NOT NULL,
     //                `group_id` INT (11) NOT NULL
     //              ) /*! ENGINE=MyISAM */;";
     //    $this->addQuery($query);
     $query = "ALTER TABLE `dicom_exchange`\n                MODIFY `requests` TEXT,\n                MODIFY `responses` TEXT;";
     $this->addQuery($query);
     $this->makeRevision('0.2');
     $query = "ALTER TABLE `dicom_session`\n                MODIFY `presentation_contexts` TEXT;";
     $this->addQuery($query);
     $this->makeRevision('0.3');
     $query = "ALTER TABLE `dicom_exchange`\n                MODIFY `presentation_contexts` TEXT;";
     $this->addQuery($query);
     $this->makeRevision('0.4');
     $query = "ALTER TABLE `dicom_source`\n                ADD `user` VARCHAR (255),\n                ADD `password` VARCHAR (50),\n                ADD `iv` VARCHAR (255),\n                ADD `libelle` VARCHAR (255);";
     $this->addQuery($query);
     $this->makeRevision('0.5');
     $query = "CREATE TABLE `dicom_configs` (\n                `dicom_config_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n                `sender_id` INT (11) UNSIGNED,\n                `sender_class` ENUM ('CDicomSender'),\n                `send_0032_1032` ENUM('0', '1') DEFAULT '0',\n                `value_0008_0060` VARCHAR(100)\n              ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->mod_version = '0.6';
 }
Ejemplo n.º 16
0
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "dPrepas";
     $this->makeRevision("all");
     $query = "CREATE TABLE `menu` (\r\n               `menu_id` int(11) unsigned NOT NULL AUTO_INCREMENT ,\r\n               `group_id` int(11) UNSIGNED NOT NULL,\r\n               `nom` VARCHAR( 255 ) NOT NULL ,\r\n               `typerepas` int(11) UNSIGNED NOT NULL,\r\n               `plat1` VARCHAR( 255 ),\r\n               `plat2` VARCHAR( 255 ),\r\n               `plat3` VARCHAR( 255 ),\r\n               `plat4` VARCHAR( 255 ),\r\n               `plat5` VARCHAR( 255 ),\r\n               `boisson` VARCHAR( 255 ),\r\n               `pain` VARCHAR( 255 ),\r\n               `diabete` enum('0','1') NOT NULL DEFAULT '0',\r\n               `sans_sel` enum('0','1') NOT NULL DEFAULT '0',\r\n               `sans_residu` enum('0','1') NOT NULL DEFAULT '0',\r\n               `modif` enum('0','1') NOT NULL DEFAULT '1',\r\n               `debut` date NOT NULL,\r\n               `fin` date NOT NULL,\r\n               `repetition` int(11) unsigned NOT NULL,\r\n               PRIMARY KEY ( `menu_id` )) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "CREATE TABLE `plats` (\r\n               `plat_id` int(11) unsigned NOT NULL AUTO_INCREMENT ,\r\n               `group_id` int(11) UNSIGNED NOT NULL,\r\n               `nom` VARCHAR( 255 ) NOT NULL ,\r\n               `type` enum('plat1','plat2','plat3','plat4','plat5','boisson','pain') NOT NULL DEFAULT 'plat1',\r\n               `typerepas` int(11) UNSIGNED NOT NULL,\r\n               PRIMARY KEY ( `plat_id` )) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "CREATE TABLE `repas_type` (\r\n               `typerepas_id` int(11) unsigned NOT NULL AUTO_INCREMENT ,\r\n               `group_id` int(11) UNSIGNED NOT NULL,\r\n               `nom` VARCHAR( 255 ) NOT NULL ,\r\n               `debut` time NOT NULL,\r\n               `fin` time NOT NULL,\r\n               PRIMARY KEY ( `typerepas_id` )) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "CREATE TABLE `repas` (\r\n               `repas_id` int(11) unsigned NOT NULL AUTO_INCREMENT ,\r\n               `affectation_id` int(11) UNSIGNED NOT NULL,\r\n               `menu_id` int(11) UNSIGNED NOT NULL,\r\n               `plat1` int(11) UNSIGNED NULL,\r\n               `plat2` int(11) UNSIGNED NULL,\r\n               `plat3` int(11) UNSIGNED NULL,\r\n               `plat4` int(11) UNSIGNED NULL,\r\n               `plat5` int(11) UNSIGNED NULL,\r\n               `boisson` int(11) UNSIGNED NULL,\r\n               `pain` int(11) UNSIGNED NULL,\r\n               `date` date NOT NULL,\r\n               PRIMARY KEY ( `repas_id` )) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("0.1");
     $query = "ALTER TABLE `repas` CHANGE `menu_id` `menu_id` int(11) UNSIGNED NULL;";
     $this->addQuery($query);
     $query = "ALTER TABLE `repas` ADD `typerepas_id` int(11) UNSIGNED NOT NULL;";
     $this->addQuery($query);
     $query = "ALTER TABLE `menu` ADD `nb_repet` int(11) unsigned NOT NULL;";
     $this->addQuery($query);
     $this->addMethod("fixRepet");
     $this->makeRevision("0.11");
     $query = "CREATE TABLE `validationrepas` (\r\n               `validationrepas_id` int(11) unsigned NOT NULL AUTO_INCREMENT ,\r\n               `service_id` int(11) UNSIGNED NOT NULL,\r\n               `date` date NOT NULL,\r\n               `typerepas_id` int(11) UNSIGNED NOT NULL,\r\n               PRIMARY KEY ( `validationrepas_id` )) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("0.12");
     $query = "ALTER TABLE `repas` ADD `modif` enum('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $query = "ALTER TABLE `validationrepas` ADD `modif` enum('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.13");
     $query = "ALTER TABLE `menu` \r\n                ADD INDEX (`group_id`),\r\n                ADD INDEX (`typerepas`),\r\n                ADD INDEX (`debut`);";
     $this->addQuery($query);
     $query = "ALTER TABLE `plats` \r\n                ADD INDEX (`group_id`),\r\n                ADD INDEX (`typerepas`);";
     $this->addQuery($query);
     $query = "ALTER TABLE `repas` \r\n                ADD INDEX (`affectation_id`),\r\n                ADD INDEX (`menu_id`),\r\n                ADD INDEX (`plat1`),\r\n                ADD INDEX (`plat2`),\r\n                ADD INDEX (`plat3`),\r\n                ADD INDEX (`plat4`),\r\n                ADD INDEX (`plat5`),\r\n                ADD INDEX (`boisson`),\r\n                ADD INDEX (`pain`),\r\n                ADD INDEX (`date`),\r\n                ADD INDEX (`typerepas_id`);";
     $this->addQuery($query);
     $query = "ALTER TABLE `repas_type` \r\n                ADD INDEX (`group_id`);";
     $this->addQuery($query);
     $query = "ALTER TABLE `validationrepas` \r\n                ADD INDEX (`service_id`),\r\n                ADD INDEX (`date`),\r\n                ADD INDEX (`typerepas_id`);";
     $this->addQuery($query);
     $this->mod_version = "0.14";
 }
Ejemplo n.º 17
0
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "dPcim10";
     $this->makeRevision("all");
     $query = "CREATE TABLE `cim10favoris` (\r\n      `favoris_id` bigint(20) NOT NULL auto_increment,\r\n      `favoris_user` int(11) NOT NULL default '0',\r\n      `favoris_code` varchar(16) NOT NULL default '',\r\n      PRIMARY KEY  (`favoris_id`)\r\n      ) /*! ENGINE=MyISAM */ COMMENT='table des favoris cim10'";
     $this->addQuery($query);
     $this->makeRevision("0.1");
     $query = "ALTER TABLE `cim10favoris` \r\n\t\t\tCHANGE `favoris_id` `favoris_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n      CHANGE `favoris_user` `favoris_user` int(11) unsigned NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.11");
     $query = "ALTER TABLE `cim10favoris` \r\n              ADD INDEX (`favoris_user`);";
     $this->addQuery($query);
     $this->makeRevision("0.12");
     $this->addPrefQuery("new_search_cim10", "1");
     $this->mod_version = "0.13";
     // Data source query
     $query = "SELECT * \r\n\t\t\tFROM `master` \r\n\t\t\tWHERE `SID` = '19550'";
     $this->addDatasource("cim10", $query);
 }
Ejemplo n.º 18
0
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "dPressources";
     $this->makeRevision("all");
     $query = "CREATE TABLE `plageressource` (\r\n                 `plageressource_id` BIGINT NOT NULL AUTO_INCREMENT ,\r\n                 `prat_id` BIGINT,\r\n                 `date` DATE NOT NULL ,\r\n                 `debut` TIME NOT NULL ,\r\n                 `fin` TIME NOT NULL ,\r\n                 `tarif` FLOAT DEFAULT '0' NOT NULL ,\r\n                 `paye` TINYINT DEFAULT '0' NOT NULL ,\r\n                 `libelle` VARCHAR( 50 ) ,\r\n                 PRIMARY KEY ( `plageressource_id` )\r\n               ) /*! ENGINE=MyISAM */ COMMENT = 'Table des plages de ressource';";
     $this->addQuery($query);
     $this->makeRevision("0.1");
     $query = "ALTER TABLE `plageressource` ADD INDEX ( `prat_id` ) ;";
     $this->addQuery($query);
     $this->makeRevision("0.11");
     $query = "ALTER TABLE `plageressource` " . "\nCHANGE `plageressource_id` `plageressource_id` int(11) unsigned NOT NULL AUTO_INCREMENT," . "\nCHANGE `prat_id` `prat_id` int(11) unsigned NULL," . "\nCHANGE `paye` `paye` enum('0','1') NOT NULL DEFAULT '0'," . "\nCHANGE `libelle` `libelle` varchar(255) NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.12");
     $query = "UPDATE `plageressource` SET prat_id = NULL WHERE prat_id='0';";
     $this->addQuery($query);
     $this->makeRevision("0.13");
     $query = "ALTER TABLE `plageressource` \r\n              ADD INDEX (`date`);";
     $this->addQuery($query);
     $this->mod_version = "0.14";
 }
Ejemplo n.º 19
0
 /**
  * Standard constructor
  */
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "dPpmsi";
     $this->makeRevision("all");
     $this->makeRevision("0.1");
     $query = "CREATE TABLE `ghm` (\r\n      `ghm_id` BIGINT NOT NULL AUTO_INCREMENT ,\r\n      `operation_id` BIGINT NOT NULL ,\r\n      `DR` VARCHAR( 10 ) ,\r\n      `DASs` TEXT,\r\n      `DADs` TEXT,\r\n      PRIMARY KEY ( `ghm_id` ) ,\r\n      INDEX ( `operation_id` )\r\n      ) /*! ENGINE=MyISAM */ COMMENT = 'Table des GHM';";
     $this->addQuery($query);
     $this->makeRevision("0.11");
     $this->addDependency("dPplanningOp", "0.38");
     $query = "ALTER TABLE `ghm` ADD `sejour_id` INT NOT NULL AFTER `operation_id`;";
     $this->addQuery($query);
     $query = "UPDATE `ghm`, `operations` SET\r\n      `ghm`.`sejour_id` = `operations`.`sejour_id`\r\n      WHERE `ghm`.`operation_id` = `operations`.`operation_id`";
     $this->addQuery($query);
     $this->makeRevision("0.12");
     $query = "ALTER TABLE `ghm` DROP `operation_id` ;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ghm` ADD INDEX ( `sejour_id` ) ;";
     $this->addQuery($query);
     $this->makeRevision("0.13");
     $query = "ALTER TABLE `ghm`\r\n      CHANGE `ghm_id` `ghm_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n      CHANGE `sejour_id` `sejour_id` int(11) unsigned NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.14");
     $query = "DROP TABLE IF EXISTS `ghm`;";
     $this->addQuery($query);
     $this->makeRevision("0.15");
     $query = "CREATE TABLE `traitement_dossier` (\r\n                `traitement_dossier_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `traitement` DATETIME,\r\n                `validate` DATETIME,\r\n                `GHS` VARCHAR (255),\r\n                `rss_id` INT (11) UNSIGNED,\r\n                `sejour_id` INT (11) UNSIGNED\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `traitement_dossier`\r\n                ADD INDEX (`traitement`),\r\n                ADD INDEX (`validate`),\r\n                ADD INDEX (`rss_id`),\r\n                ADD INDEX (`sejour_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.16");
     $query = "  ALTER TABLE `traitement_dossier`\r\n                CHANGE `rss_id` `rss_id` INT (11) UNSIGNED,\r\n                CHANGE `sejour_id` `sejour_id` INT (11) UNSIGNED,\r\n                ADD `dim_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "ALTER TABLE `traitement_dossier`\r\n                ADD INDEX (`dim_id`);";
     $this->addQuery($query);
     $this->mod_version = "0.17";
     // Data source query
     $query = "SHOW TABLES LIKE 'CIM10';";
     $this->addDatasource("cim10", $query);
 }
Ejemplo n.º 20
0
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "reservation";
     $this->makeRevision("all");
     $this->makeRevision("0.01");
     $query = "CREATE TABLE `commentaire_planning` (\r\n      `commentaire_planning_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `salle_id` INT (11) UNSIGNED,\r\n      `libelle` VARCHAR (255) NOT NULL,\r\n      `commentaire` TEXT,\r\n      `debut` DATETIME NOT NULL,\r\n      `fin` DATETIME NOT NULL\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `commentaire_planning` \r\n      ADD INDEX (`salle_id`),\r\n      ADD INDEX (`debut`),\r\n      ADD INDEX (`fin`);";
     $this->addQuery($query);
     $this->makeRevision("0.02");
     $query = "ALTER TABLE `commentaire_planning` \r\n      ADD `color` CHAR (6) DEFAULT 'DDDDDD' AFTER `commentaire`;";
     $this->addQuery($query);
     $this->makeRevision("0.03");
     $query = "CREATE TABLE `examen_operation` (\r\n      `examen_operation_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `completed` ENUM ('0','1') DEFAULT '0',\r\n      `acheminement` ENUM ('courrier','fax','autre'),\r\n      `labo` TEXT,\r\n      `groupe_rh` ENUM ('0','1') DEFAULT '0',\r\n      `flacons` INT (11) UNSIGNED,\r\n      `auto_transfusion` ENUM ('0','1') DEFAULT '0',\r\n      `ecg` ENUM ('0','1') DEFAULT '0',\r\n      `radio_thorax` ENUM ('0','1') DEFAULT '0',\r\n      `radios_autres` TEXT,\r\n      `physio_preop` TEXT,\r\n      `physio_postop` TEXT\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("0.04");
     $this->addPrefQuery("planning_resa_height", 1500);
     $this->makeRevision("0.05");
     $this->addFunctionalPermQuery("planning_resa_days_limit", '0');
     $this->makeRevision("0.06");
     $this->addFunctionalPermQuery("planning_resa_past_days_limit", '0');
     $this->mod_version = "0.07";
 }
Ejemplo n.º 21
0
 /**
  * @see parent::__construct
  */
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "hprimsante";
     $this->makeRevision("all");
     $this->makeRevision("0.1");
     $query = "CREATE TABLE `exchange_hprimsante` (\n              `exchange_hprimsante_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n              `version` VARCHAR(255),\n              `nom_fichier` VARCHAR(255),\n              `group_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\n              `date_production` DATETIME NOT NULL,\n              `sender_id` INT (11) UNSIGNED,\n              `sender_class` ENUM ('CSenderFTP','CSenderSOAP','CSenderMLLP','CSenderFileSystem'),\n              `receiver_id` INT (11) UNSIGNED,\n              `type` VARCHAR (255),\n              `sous_type` VARCHAR (255),\n              `date_echange` DATETIME,\n              `message_content_id` INT (11) UNSIGNED,\n              `acquittement_content_id` INT (11) UNSIGNED,\n              `statut_acquittement` VARCHAR (255),\n              `message_valide` ENUM ('0','1') DEFAULT '0',\n              `acquittement_valide` ENUM ('0','1') DEFAULT '0',\n              `id_permanent` VARCHAR (255),\n              `object_id` INT (11) UNSIGNED,\n              `object_class` ENUM ('CPatient','CSejour','CMedecin'),\n              `code` VARCHAR(255) NOT NULL,\n              `identifiant_emetteur` VARCHAR (255),\n              `reprocess` TINYINT (4) UNSIGNED DEFAULT '0'\n          ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `exchange_hprimsante`\n                ADD INDEX (`group_id`),\n                ADD INDEX (`date_production`),\n                ADD INDEX (`sender_id`),\n                ADD INDEX (`receiver_id`),\n                ADD INDEX (`date_echange`),\n                ADD INDEX (`message_content_id`),\n                ADD INDEX (`acquittement_content_id`),\n                ADD INDEX (`object_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.2");
     $query = "CREATE TABLE `receiver_hprimsante` (\n              `receiver_hprimsante_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n              `nom` VARCHAR (255) NOT NULL,\n              `libelle` VARCHAR (255),\n              `group_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\n              `actif` ENUM ('0','1') NOT NULL DEFAULT '0',\n              `OID` VARCHAR (255),\n              `synchronous` ENUM ('0','1') NOT NULL DEFAULT '1'\n            ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `receiver_hprimsante`\n              ADD INDEX (`group_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.3");
     $query = "CREATE TABLE `hprimsante_config` (\n                `hprimsante_config_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n                `encoding` ENUM ('UTF-8','ISO-8859-1') DEFAULT 'UTF-8',\n                `strict_segment_terminator` ENUM ('0','1') DEFAULT '0',\n                `segment_terminator` ENUM ('CR','LF','CRLF'),\n                `sender_id` INT (11) UNSIGNED,\n                `sender_class` ENUM ('CSenderFTP','CSenderSOAP','CSenderMLLP','CSenderFileSystem'),\n                `action` ENUM ('IPP_NDA','Patient','Sejour','Patient_Sejour') DEFAULT 'IPP_NDA'\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `hprimsante_config`\n                ADD INDEX (`sender_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.4");
     $query = "CREATE TABLE `receiver_hprimsante_config` (\n                `receiver_hprimsante_config_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n                `object_id` INT (11) UNSIGNED,\n                `ADM_version` ENUM ('2.1','2.2','2.3','2.4') DEFAULT '2.1',\n                `ADM_sous_type` ENUM ('C','L', 'R') DEFAULT 'C'\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `receiver_hprimsante_config`\n                ADD INDEX (`object_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.5");
     $query = "ALTER TABLE `receiver_hprimsante`\n                ADD `monitor_sources` ENUM ('0','1') NOT NULL DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.6");
     $query = "ALTER TABLE `hprimsante_config`\n                ADD `notifier_entree_reelle` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.7");
     $query = "ALTER TABLE `exchange_hprimsante`\n                ADD `master_idex_missing` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->mod_version = "0.8";
 }
Ejemplo n.º 22
0
 /**
  * Standard constructor
  */
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "ssr";
     $this->makeRevision("all");
     // Plateau technique
     $this->makeRevision("0.01");
     $query = "CREATE TABLE `plateau_technique` (\r\n      `plateau_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `group_id` INT (11) UNSIGNED,\r\n      `nom` VARCHAR (255) NOT NULL\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `plateau_technique` \r\n      ADD INDEX (`group_id`);";
     $this->addQuery($query);
     // Equipement
     $this->makeRevision("0.02");
     $query = "CREATE TABLE `equipement` (\r\n      `equipement_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `plateau_id` INT (11) UNSIGNED NOT NULL,\r\n      `nom` VARCHAR (255) NOT NULL\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `equipement` \r\n      ADD INDEX (`plateau_id`);";
     $this->addQuery($query);
     // Technicien
     $this->makeRevision("0.03");
     $this->addDependency("mediusers", "0.1");
     $query = "CREATE TABLE `technicien` (\r\n      `technicien_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `plateau_id` INT (11) UNSIGNED NOT NULL,\r\n      `kine_id` INT (11) UNSIGNED NOT NULL\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `technicien` \r\n      ADD INDEX (`plateau_id`),\r\n      ADD INDEX (`kine_id`);";
     $this->addQuery($query);
     // Fiche d'autonomie
     $this->makeRevision("0.04");
     $query = "CREATE TABLE `fiche_autonomie` (\r\n      `fiche_autonomie_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `sejour_id` INT (11) UNSIGNED NOT NULL,\r\n      `alimentation` ENUM ('autonome','partielle','totale'),\r\n      `toilette` ENUM ('autonome','partielle','totale'),\r\n      `habillage_haut` ENUM ('autonome','partielle','totale'),\r\n      `habillage_bas` ENUM ('autonome','partielle','totale'),\r\n      `utilisation_toilette` ENUM ('sonde','couche','bassin','stomie'),\r\n      `transfert_lit` ENUM ('autonome','partielle','totale'),\r\n      `locomotion` ENUM ('autonome','partielle','totale'),\r\n      `locomotion_materiel` ENUM ('canne','cadre','fauteuil'),\r\n      `escalier` ENUM ('autonome','partielle','totale'),\r\n      `pansement` ENUM ('0','1'),\r\n      `escarre` ENUM ('0','1'),\r\n      `comprehension` ENUM ('intacte','alteree'),\r\n      `expression` ENUM ('intacte','alteree'),\r\n      `memoire` ENUM ('intacte','alteree'),\r\n      `resolution_pb` ENUM ('intacte','alteree'),\r\n      `etat_psychique` TEXT,\r\n      `devenir_envisage` TEXT\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `fiche_autonomie` \r\n      ADD INDEX (`sejour_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.05");
     $query = "ALTER TABLE `fiche_autonomie` \r\n      ADD `soins_cutanes` TEXT;";
     $this->addQuery($query);
     // Bilan SSR
     $this->makeRevision("0.06");
     $query = "CREATE TABLE `bilan_ssr` (\r\n      `bilan_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `sejour_id` INT (11) UNSIGNED NOT NULL,\r\n      `kine` VARCHAR (255) NOT NULL,\r\n      `ergo` VARCHAR (255) NOT NULL,\r\n      `psy` VARCHAR (255) NOT NULL,\r\n      `ortho` VARCHAR (255) NOT NULL,\r\n      `diet` VARCHAR (255) NOT NULL,\r\n      `social` VARCHAR (255) NOT NULL,\r\n      `apa` VARCHAR (255) NOT NULL,\r\n      `entree` TEXT,\r\n      `sortie` TEXT\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `bilan_ssr` \r\n      ADD INDEX (`sejour_id`);";
     $this->addQuery($query);
     // RHS
     $this->makeRevision("0.07");
     $query = "CREATE TABLE `rhs` (\r\n      `rhs_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `sejour_id` INT (11) UNSIGNED NOT NULL,\r\n      `date_monday` DATE NOT NULL\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `rhs` \r\n      ADD INDEX (`sejour_id`),\r\n      ADD INDEX (`date_monday`);";
     $this->addQuery($query);
     // Dépendances RHS
     $this->makeRevision("0.08");
     $query = "CREATE TABLE `dependances_rhs` (\r\n      `dependances_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `rhs_id` INT (11) UNSIGNED NOT NULL,\r\n      `habillage`    ENUM ('1','2','3','4'),\r\n      `deplacement`  ENUM ('1','2','3','4'),\r\n      `alimentation` ENUM ('1','2','3','4'),\r\n      `continence`   ENUM ('1','2','3','4'),\r\n      `comportement` ENUM ('1','2','3','4'),\r\n      `relation`     ENUM ('1','2','3','4')\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `dependances_rhs` \r\n      ADD INDEX (`rhs_id`);";
     $this->addQuery($query);
     // Ligne d'activités RHS
     $this->makeRevision("0.09");
     $query = "CREATE TABLE `ligne_activites_rhs` (\r\n      `ligne_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `rhs_id` INT (11) UNSIGNED NOT NULL,\r\n      `executant_id` INT (11) UNSIGNED NOT NULL,\r\n      `code_activite_cdarr` CHAR (4),\r\n      `code_intervenant_cdarr` CHAR (2),\r\n      `qty_mon` INT (11),\r\n      `qty_tue` INT (11),\r\n      `qty_wed` INT (11),\r\n      `qty_thu` INT (11),\r\n      `qty_fri` INT (11),\r\n      `qty_sat` INT (11),\r\n      `qty_sun` INT (11)\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ligne_activites_rhs` \r\n      ADD INDEX (`rhs_id`),\r\n      ADD INDEX (`executant_id`);";
     $this->addQuery($query);
     // Bilan SSR: suppresion des anciennes prescriptions texte, ajout du kine
     $this->makeRevision("0.10");
     $query = "ALTER TABLE `bilan_ssr` \r\n      ADD `kine_id` INT (11) UNSIGNED,\r\n      DROP COLUMN `kine`,\r\n      DROP COLUMN `ergo`,\r\n      DROP COLUMN `psy`,\r\n      DROP COLUMN `ortho`,\r\n      DROP COLUMN `social`,\r\n      DROP COLUMN `diet`,\r\n      DROP COLUMN `apa`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `bilan_ssr` \r\n      ADD INDEX (`kine_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.11");
     $query = "ALTER TABLE `ligne_activites_rhs` \r\n      CHANGE `code_activite_cdarr` `code_activite_cdarr` CHAR (4) NOT NULL,\r\n      CHANGE `qty_mon` `qty_mon` TINYINT (4) UNSIGNED DEFAULT '0',\r\n      CHANGE `qty_tue` `qty_tue` TINYINT (4) UNSIGNED DEFAULT '0',\r\n      CHANGE `qty_wed` `qty_wed` TINYINT (4) UNSIGNED DEFAULT '0',\r\n      CHANGE `qty_thu` `qty_thu` TINYINT (4) UNSIGNED DEFAULT '0',\r\n      CHANGE `qty_fri` `qty_fri` TINYINT (4) UNSIGNED DEFAULT '0',\r\n      CHANGE `qty_sat` `qty_sat` TINYINT (4) UNSIGNED DEFAULT '0',\r\n      CHANGE `qty_sun` `qty_sun` TINYINT (4) UNSIGNED DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.12");
     $query = "CREATE TABLE `element_prescription_to_cdarr` (\r\n      `element_prescription_to_cdarr_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `element_prescription_id` INT (11) UNSIGNED NOT NULL,\r\n      `code` CHAR (4) NOT NULL,\r\n      `commentaire` VARCHAR (255)\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `element_prescription_to_cdarr` \r\n      ADD INDEX (`element_prescription_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.13");
     $query = "CREATE TABLE `evenement_ssr` (\r\n      `evenement_ssr_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `element_prescription_id` INT (11) UNSIGNED NOT NULL,\r\n      `code` CHAR (4) NOT NULL,\r\n      `sejour_id` INT (11) UNSIGNED NOT NULL,\r\n      `debut` DATETIME NOT NULL,\r\n      `duree` INT (11) UNSIGNED NOT NULL,\r\n      `therapeute_id` INT (11) UNSIGNED NOT NULL,\r\n      `realise` ENUM ('0','1') DEFAULT '0'\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `evenement_ssr` \r\n      ADD INDEX (`element_prescription_id`),\r\n      ADD INDEX (`sejour_id`),\r\n      ADD INDEX (`debut`),\r\n      ADD INDEX (`therapeute_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.14");
     $query = "ALTER TABLE `evenement_ssr` \r\n      ADD `equipement_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "ALTER TABLE `evenement_ssr` \r\n      ADD INDEX (`equipement_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.15");
     $query = "ALTER TABLE `bilan_ssr` \r\n      ADD `technicien_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "ALTER TABLE `bilan_ssr` \r\n      ADD INDEX (`technicien_id`);";
     $this->addQuery($query);
     $query = "UPDATE `bilan_ssr`\r\n      SET technicien_id = \r\n        (SELECT technicien_id \r\n        FROM technicien\r\n        WHERE kine_id = bilan_ssr.kine_id\r\n        LIMIT 1);";
     $this->addQuery($query);
     $query = "ALTER TABLE `bilan_ssr` \r\n      DROP kine_id";
     $this->addQuery($query);
     $this->makeRevision("0.16");
     $query = "CREATE TABLE `acte_cdarr` (\r\n      `acte_cdarr_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `evenement_ssr_id` INT (11) UNSIGNED NOT NULL,\r\n      `code` CHAR (4) NOT NULL\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `acte_cdarr` \r\n      ADD INDEX (`evenement_ssr_id`);";
     $this->addQuery($query);
     $query = "INSERT INTO `acte_cdarr` (`evenement_ssr_id`,`code`)\r\n      SELECT `evenement_ssr_id`,`code`\r\n      FROM evenement_ssr";
     $this->addQuery($query);
     $query = "ALTER TABLE `evenement_ssr` \r\n      DROP `code`;";
     $this->addQuery($query);
     $this->makeRevision("0.17");
     $query = "ALTER TABLE `evenement_ssr` \r\n      ADD `remarque` VARCHAR (255);";
     $this->addQuery($query);
     $this->makeRevision("0.18");
     $query = "ALTER TABLE `bilan_ssr` \r\n      ADD `brancardage` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.19");
     $query = "CREATE TABLE `replacement` (\r\n      `replacement_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `sejour_id` INT (11) UNSIGNED NOT NULL,\r\n      `conge_id` INT (11) UNSIGNED NOT NULL,\r\n      `replacer_id` INT (11) UNSIGNED NOT NULL\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `replacement` \r\n      ADD INDEX (`sejour_id`),\r\n      ADD INDEX (`conge_id`),\r\n      ADD INDEX (`replacer_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.20");
     $query = "ALTER TABLE `fiche_autonomie` \r\n      ADD `toilettes` ENUM ('autonome','partielle','totale') NOT NULL";
     $this->addQuery($query);
     $this->makeRevision("0.21");
     $query = "ALTER TABLE `fiche_autonomie` \r\n      ADD `antecedents` TEXT,\r\n      ADD `traitements` TEXT;";
     $this->addQuery($query);
     $this->makeRevision("0.22");
     $query = "ALTER TABLE `evenement_ssr` \r\n              ADD `prescription_line_element_id` INT (11) UNSIGNED NOT NULL";
     $this->addQuery($query);
     $this->addDependency("dPprescription", "0,11");
     $query = "UPDATE `evenement_ssr`\r\n      SET `prescription_line_element_id` = (\r\n        SELECT `prescription_line_element_id` \r\n        FROM `prescription_line_element`\r\n        LEFT JOIN `prescription` ON `prescription_line_element`.`prescription_id` = `prescription`.`prescription_id`\r\n        WHERE `prescription`.`type` = 'sejour'\r\n        AND `prescription`.`object_id` = `evenement_ssr`.`sejour_id`\r\n        AND `prescription_line_element`.`element_prescription_id` = `evenement_ssr`.`element_prescription_id`\r\n      );";
     $this->addQuery($query);
     $query = "ALTER TABLE `evenement_ssr` \r\n      DROP `element_prescription_id`";
     $this->addQuery($query);
     $this->makeRevision("0.23");
     $query = "ALTER TABLE `bilan_ssr` \r\n      ADD `planification` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.24");
     $query = "ALTER TABLE `evenement_ssr` \r\n      CHANGE `sejour_id` `sejour_id` INT (11) UNSIGNED,\r\n      ADD `seance_collective_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "ALTER TABLE `evenement_ssr` \r\n      ADD INDEX (`prescription_line_element_id`),\r\n      ADD INDEX (`seance_collective_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.25");
     $query = "ALTER TABLE `evenement_ssr` \r\n      CHANGE `prescription_line_element_id` `prescription_line_element_id` INT (11) UNSIGNED,\r\n      CHANGE `debut` `debut` DATETIME,\r\n      CHANGE `duree` `duree` INT (11) UNSIGNED,\r\n      CHANGE `therapeute_id` `therapeute_id` INT (11) UNSIGNED,\r\n      CHANGE `realise` `realise` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.26");
     $this->addPrefQuery("ssr_planning_dragndrop", "0");
     $this->addPrefQuery("ssr_planning_resize", "0");
     $this->makeRevision("0.27");
     $query = "ALTER TABLE `equipement` \r\n      ADD `visualisable` ENUM ('0','1') NOT NULL DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.28");
     $this->addPrefQuery("ssr_planification_show_equipement", "1");
     $this->addPrefQuery("ssr_planification_duree", "30");
     $this->makeRevision("0.29");
     $query = "ALTER TABLE `rhs` \r\n      ADD `facture` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.30");
     $query = "ALTER TABLE `evenement_ssr` \r\n      ADD `annule` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.31");
     $query = "ALTER TABLE `technicien` \r\n      ADD `actif` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $query = "ALTER TABLE `equipement` \r\n      ADD `actif` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.32");
     $query = "ALTER TABLE `replacement` \r\n      ADD `deb` DATE,\r\n      ADD `fin` DATE;";
     $this->addQuery($query);
     $query = "ALTER TABLE `replacement` \r\n      ADD INDEX (`deb`),\r\n      ADD INDEX (`fin`);";
     $this->addQuery($query);
     $this->makeRevision("0.33");
     $query = "ALTER TABLE `plateau_technique`\r\n      ADD `repartition` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.34");
     $query = "ALTER TABLE `bilan_ssr`\r\n      ADD `hospit_de_jour` ENUM ('0','1') DEFAULT '0',\r\n      ADD `demi_journee_1` ENUM ('0','1') DEFAULT '0',\r\n      ADD `demi_journee_2` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.35");
     $query = "ALTER TABLE `replacement`\r\n      ADD UNIQUE INDEX replacement (sejour_id, conge_id)";
     $this->addQuery($query);
     $this->makeRevision("0.36");
     $query = "ALTER TABLE `ligne_activites_rhs` \r\n      ADD `auto` ENUM ('0','1') DEFAULT '0'";
     $this->addQuery($query);
     $this->makeRevision("0.37");
     $query = "ALTER TABLE `ligne_activites_rhs` \r\n      ADD UNIQUE ligne (rhs_id, executant_id, code_activite_cdarr)";
     $this->addQuery($query);
     $this->makeRevision("0.38");
     $query = "ALTER TABLE `acte_cdarr` \r\n      ADD `administration_id` INT (11) UNSIGNED,\r\n      CHANGE `evenement_ssr_id` `evenement_ssr_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $this->makeRevision("0.39");
     $query = "ALTER TABLE `acte_cdarr` ADD INDEX (`administration_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.40");
     $query = "ALTER TABLE `acte_cdarr` ADD `sejour_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "ALTER TABLE `acte_cdarr` ADD INDEX (`sejour_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.41");
     if (CAppUI::conf("ssr recusation use_recuse") == 0) {
         $query = "UPDATE `sejour`\r\n        SET `sejour`.`recuse` = '0'\r\n        WHERE `sejour`.`type` = 'ssr'";
         $this->addQuery($query);
     }
     $this->makeRevision("0.42");
     $query = "CREATE TABLE `element_prescription_to_csarr` (\r\n      `element_prescription_to_csarr_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `element_prescription_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\r\n      `code` CHAR (7) NOT NULL,\r\n      `commentaire` VARCHAR (255)\r\n    )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `element_prescription_to_csarr` ADD INDEX (`element_prescription_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.43");
     $query = "CREATE TABLE `acte_csarr` (\r\n      `acte_csarr_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `evenement_ssr_id` INT (11) UNSIGNED,\r\n      `administration_id` INT (11) UNSIGNED,\r\n      `sejour_id` INT (11) UNSIGNED,\r\n      `code` CHAR (7) NOT NULL\r\n    )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `acte_csarr` \r\n      ADD INDEX (`evenement_ssr_id`),\r\n      ADD INDEX (`administration_id`),\r\n      ADD INDEX (`sejour_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.44");
     if (!CAppUI::conf("ssr recusation use_recuse")) {
         $query = "UPDATE `sejour`\r\n        SET `sejour`.`recuse` = '0'\r\n        WHERE `sejour`.`type` = 'ssr'";
         $this->addQuery($query);
     }
     $this->makeRevision("0.45");
     $query = "ALTER TABLE `ligne_activites_rhs` \r\n      CHANGE `rhs_id` `rhs_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\r\n      CHANGE `executant_id` `executant_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\r\n      CHANGE `code_activite_cdarr` `code_activite_cdarr` CHAR (4),\r\n      ADD `code_activite_csarr` CHAR (7);";
     $this->addQuery($query);
     $this->makeRevision("0.46");
     $query = "ALTER TABLE `acte_csarr`\r\n      ADD `modulateurs` VARCHAR (20),\r\n      ADD `phases` VARCHAR (3);";
     $this->addQuery($query);
     $this->makeRevision("0.47");
     $query = "ALTER TABLE `evenement_ssr`\r\n                ADD `type_seance` ENUM ('dediee','non_dediee','collective') DEFAULT 'dediee';";
     $this->addQuery($query);
     $query = "UPDATE `evenement_ssr`\r\n        SET `evenement_ssr`.`type_seance` = 'non_dediee'\r\n        WHERE `evenement_ssr`.`equipement_id` IS NOT NULL";
     $this->addQuery($query);
     $query = "UPDATE `evenement_ssr`\r\n        SET `evenement_ssr`.`type_seance` = 'collective'\r\n        WHERE  `evenement_ssr`.`seance_collective_id` IS NOT NULL";
     $this->addQuery($query);
     $query = "UPDATE `evenement_ssr` e\r\n        INNER JOIN `evenement_ssr` s ON s.`seance_collective_id` = e.`evenement_ssr_id`\r\n        SET e.`type_seance` = 'collective'\r\n        WHERE e.`seance_collective_id` IS NULL\r\n        AND s.`type_seance` = 'collective'";
     $this->addQuery($query);
     $this->makeRevision("0.48");
     $query = "ALTER TABLE `evenement_ssr`\r\n                ADD `nb_patient_seance` INT (11);";
     $this->addQuery($query);
     $this->makeRevision("0.49");
     $query = "ALTER TABLE `ligne_activites_rhs`\r\n                ADD `modulateurs` VARCHAR (20),\r\n                ADD `phases` VARCHAR (3),\r\n                ADD `nb_patient_seance` INT (11);";
     $this->addQuery($query);
     $this->makeRevision("0.50");
     $query = "ALTER TABLE `evenement_ssr`\r\n                CHANGE `type_seance` `type_seance` ENUM ('dediee','non_dediee','collective') DEFAULT 'dediee';";
     $this->addQuery($query);
     $query = "UPDATE `evenement_ssr`\r\n        SET `evenement_ssr`.`type_seance` = 'dediee'\r\n        WHERE  `evenement_ssr`.`type_seance` IS NULL";
     $this->addQuery($query);
     $this->mod_version = "0.51";
     // Data source query
     $query = "SHOW TABLES LIKE 'type_activite'";
     $this->addDatasource("cdarr", $query);
     $query = "SELECT * FROM `activite` WHERE `code` = 'AGR+102'";
     $this->addDatasource("csarr", $query);
 }
Ejemplo n.º 23
0
 function __construct()
 {
     parent::__construct();
     $this->mod_type = "core";
     $this->mod_name = "system";
     $this->makeRevision("all");
     $this->makeRevision("1.0.13");
     $this->addPrefQuery("touchscreen", "0");
     $this->makeRevision("1.0.14");
     $this->addPrefQuery("tooltipAppearenceTimeout", "medium");
     $this->makeRevision("1.0.15");
     $this->addPrefQuery("showLastUpdate", "0");
     $this->makeRevision("1.0.16");
     $query = "ALTER TABLE `message` \r\n      ADD INDEX (`module_id`),\r\n      ADD INDEX (`deb`),\r\n      ADD INDEX (`fin`);";
     $this->addQuery($query);
     $query = "ALTER TABLE `modules` \r\n      DROP `mod_directory`,\r\n      DROP `mod_setup_class`,\r\n      DROP `mod_ui_name`,\r\n      DROP `mod_ui_icon`,\r\n      DROP `mod_description`";
     $this->addQuery($query);
     $this->makeRevision("1.0.17");
     $this->addPrefQuery("showTemplateSpans", "0");
     $this->makeRevision("1.0.18");
     $query = "ALTER TABLE `message` \r\n      ADD `group_id` INT (11) UNSIGNED,\r\n      ADD INDEX (`group_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.19");
     $this->setTimeLimit(300);
     $query = "ALTER TABLE `user_log` \r\n      ADD `ip_address` VARBINARY (16) NULL DEFAULT NULL,\r\n      ADD `extra` TEXT,\r\n      ADD INDEX (`ip_address`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.20");
     $query = "CREATE TABLE `alert` (\r\n      `alert_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `tag` VARCHAR (255) NOT NULL,\r\n      `level` ENUM ('low','medium','high') NOT NULL DEFAULT 'medium',\r\n      `comments` TEXT,\r\n      `handled` ENUM ('0','1') NOT NULL DEFAULT '0',\r\n      `object_id` INT (11) UNSIGNED NOT NULL,\r\n      `object_class` VARCHAR (255) NOT NULL\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `alert` \r\n      ADD INDEX (`object_id`),\r\n      ADD INDEX (`object_class`),\r\n      ADD INDEX (`tag`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.26");
     $query = "DELETE FROM `modules` \r\n      WHERE `mod_name` = 'dPinterop'";
     $this->addQuery($query, true);
     $this->makeRevision("1.0.27");
     $query = "DELETE FROM `modules` \r\n      WHERE `mod_name` = 'dPmateriel'";
     $this->addQuery($query, true);
     $this->makeRevision("1.0.28");
     $query = "CREATE TABLE IF NOT EXISTS `content_html` (\r\n      `content_id` BIGINT NOT NULL auto_increment PRIMARY KEY,\r\n      `content` TEXT,\r\n      `cr_id` INT\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "CREATE TABLE `content_xml` (\r\n      `content_id` BIGINT NOT NULL auto_increment PRIMARY KEY,\r\n      `content` TEXT,\r\n      `import_id` INT\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.0.29");
     $query = "ALTER TABLE `content_html`\r\n      CHANGE `content` `content` mediumtext NULL";
     $this->addQuery($query);
     $this->makeRevision("1.0.30");
     $this->addPrefQuery("directory_to_watch", "");
     $this->makeRevision("1.0.31");
     $this->addPrefQuery("debug_yoplet", "0");
     $this->makeRevision("1.0.32");
     $query = "ALTER TABLE `access_log` \r\n      ADD INDEX ( `period` )";
     $this->addQuery($query);
     $this->makeRevision("1.0.34");
     $query = "CREATE TABLE `source_smtp` (\r\n      `source_smtp_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `port` INT (11) DEFAULT '25',\r\n      `email` VARCHAR (50),\r\n      `ssl` ENUM ('0','1') DEFAULT '0',\r\n      `name` VARCHAR  (255) NOT NULL,\r\n      `role` ENUM ('prod','qualif') NOT NULL DEFAULT 'qualif',\r\n      `host` TEXT NOT NULL,\r\n      `user` VARCHAR  (255),\r\n      `password` VARCHAR (50),\r\n      `type_echange` VARCHAR  (255)\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.0.35");
     $query = "CREATE TABLE `ex_class` (\r\n      `host_class` VARCHAR (255) NOT NULL,\r\n      `event` VARCHAR (255) NOT NULL,\r\n      `ex_class_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "CREATE TABLE `ex_class_field` (\r\n      `ex_class_field_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `ex_class_id` INT (11) UNSIGNED NOT NULL,\r\n      `name` VARCHAR (255) NOT NULL,\r\n      `prop` VARCHAR (255) NOT NULL\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field` \r\n      ADD INDEX (`ex_class_id`);";
     $this->addQuery($query);
     $query = "CREATE TABLE `ex_class_constraint` (\r\n      `ex_class_constraint_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `ex_class_id` INT (11) UNSIGNED NOT NULL,\r\n      `field` VARCHAR  (255) NOT NULL,\r\n      `operator` ENUM ('=','!=','>','>=','<','<=','startsWith','endsWith','contains') NOT NULL DEFAULT '=',\r\n      `value` VARCHAR  (255) NOT NULL\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_constraint` \r\n      ADD INDEX (`ex_class_id`);";
     $this->addQuery($query);
     $query = "CREATE TABLE `ex_class_field_translation` (\r\n      `ex_class_field_translation_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `ex_class_field_id` INT (11) UNSIGNED NOT NULL,\r\n      `lang` CHAR  (2),\r\n      `std` VARCHAR  (255),\r\n      `desc` VARCHAR  (255),\r\n      `court` VARCHAR  (255)\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field_translation` \r\n      ADD INDEX (`ex_class_field_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.36");
     $query = "CREATE TABLE `ex_class_field_enum_translation` (\r\n      `ex_class_field_enum_translation_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `ex_class_field_id` INT (11) UNSIGNED NOT NULL,\r\n      `lang` CHAR  (2),\r\n      `key` VARCHAR  (40),\r\n      `value` VARCHAR  (255)\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field_enum_translation` \r\n      ADD INDEX (`ex_class_field_id`),\r\n      ADD INDEX (`lang`),\r\n      ADD INDEX (`key`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.37");
     $query = "ALTER TABLE `ex_class` \r\n      ADD `name` VARCHAR  (255) NOT NULL;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field_translation` \r\n      ADD INDEX (`lang`)";
     $this->addQuery($query);
     $this->makeRevision("1.0.38");
     $query = "ALTER TABLE `ex_class_field` \r\n      ADD `coord_field_x` TINYINT (4) UNSIGNED,\r\n      ADD `coord_field_y` TINYINT (4) UNSIGNED,\r\n      ADD `coord_label_x` TINYINT (4) UNSIGNED,\r\n      ADD `coord_label_y` TINYINT (4) UNSIGNED;";
     $this->addQuery($query);
     $this->makeRevision("1.0.39");
     $query = "CREATE TABLE `ex_class_host_field` (\r\n      `ex_class_host_field_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `ex_class_id` INT (11) UNSIGNED NOT NULL,\r\n      `field` VARCHAR (80) NOT NULL,\r\n      `coord_label_x` TINYINT (4) UNSIGNED,\r\n      `coord_label_y` TINYINT (4) UNSIGNED,\r\n      `coord_value_x` TINYINT (4) UNSIGNED,\r\n      `coord_value_y` TINYINT (4) UNSIGNED\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_host_field` \r\n      ADD INDEX (`ex_class_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.40");
     $query = "ALTER TABLE `ex_class_field` \r\n      CHANGE `ex_class_id` `ex_class_id` INT (11) UNSIGNED,\r\n      ADD `concept_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field` \r\n      ADD INDEX (`concept_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.41");
     $query = "ALTER TABLE `ex_class` \r\n      ADD `disabled` ENUM ('0','1') NOT NULL DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("1.0.42");
     $query = "CREATE TABLE `content_tabular` (\r\n      `content_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `content` TEXT,\r\n      `import_id` INT (11),\r\n      `separator` CHAR (1)\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.0.43");
     $query = "CREATE TABLE `tag` (\r\n      `tag_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `parent_id` INT (11) UNSIGNED,\r\n      `object_class` VARCHAR (80),\r\n      `name` VARCHAR (255) NOT NULL\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `tag` \r\n      ADD INDEX (`parent_id`),\r\n      ADD INDEX (`object_class`);";
     $this->addQuery($query);
     $query = "CREATE TABLE `tag_item` (\r\n      `tag_item_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `tag_id` INT (11) UNSIGNED NOT NULL,\r\n      `object_id` INT (11) UNSIGNED NOT NULL,\r\n      `object_class` VARCHAR (80) NOT NULL\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `tag_item` \r\n      ADD INDEX (`tag_id`),\r\n      ADD INDEX (`object_id`),\r\n      ADD INDEX (`object_class`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.44");
     $query = "ALTER TABLE `tag` \r\n      ADD `color` VARCHAR (20);";
     $this->addQuery($query);
     $this->makeRevision("1.0.45");
     $query = "CREATE TABLE `ex_list` (\r\n      `ex_list_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `name` VARCHAR (255) NOT NULL\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "CREATE TABLE `ex_list_item` (\r\n      `ex_list_item_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `list_id` INT (11) UNSIGNED NOT NULL,\r\n      `name` VARCHAR (255) NOT NULL,\r\n      `value` INT (11)\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_list_item` \r\n      ADD INDEX (`list_id`);";
     $this->addQuery($query);
     $query = "CREATE TABLE `ex_concept` (\r\n      `ex_concept_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `ex_list_id` INT (11) UNSIGNED,\r\n      `name` VARCHAR (255) NOT NULL,\r\n      `prop` VARCHAR (255) NOT NULL\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_concept` \r\n      ADD INDEX (`ex_list_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.46");
     $this->addPrefQuery("pdf_and_thumbs", "1");
     $this->makeRevision("1.0.47");
     $query = "ALTER TABLE `ex_list` \r\n      ADD `coded` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_list_item` \r\n      ADD `code` CHAR (20);";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_list_item` \r\n      DROP `value`";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_list_item` \r\n      CHANGE `list_id` `list_id` INT (11) UNSIGNED,\r\n      ADD `concept_id` INT (11) UNSIGNED,\r\n      ADD `field_id` INT (11) UNSIGNED";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_list_item` \r\n      ADD INDEX (`concept_id`),\r\n      ADD INDEX (`field_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.48");
     $query = "CREATE TABLE `ex_class_field_group` (\r\n      `ex_class_field_group_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `ex_class_id` INT (11) UNSIGNED,\r\n      `name` VARCHAR (255) NOT NULL\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field_group` \r\n      ADD INDEX (`ex_class_id`);";
     $this->addQuery($query);
     $query = "INSERT INTO `ex_class_field_group` (`name`, `ex_class_id`)\r\n      SELECT 'Groupe principal', `ex_class`.`ex_class_id` FROM `ex_class`";
     $this->addQuery($query);
     // class field
     $query = "ALTER TABLE `ex_class_field` \r\n      ADD `ex_group_id` INT (11) UNSIGNED";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field` \r\n      ADD INDEX (`ex_group_id`)";
     $this->addQuery($query);
     $query = "UPDATE `ex_class_field` \r\n      SET `ex_group_id` = (\r\n        SELECT `ex_class_field_group`.`ex_class_field_group_id` \r\n        FROM `ex_class_field_group` \r\n        WHERE `ex_class_field_group`.`ex_class_id` = `ex_class_field`.`ex_class_id`\r\n        LIMIT 1\r\n      )";
     $this->addQuery($query);
     // class host field
     $query = "ALTER TABLE `ex_class_host_field` \r\n      ADD `ex_group_id` INT (11) UNSIGNED";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_host_field` \r\n      ADD INDEX (`ex_group_id`)";
     $this->addQuery($query);
     $query = "UPDATE `ex_class_host_field` \r\n      SET `ex_group_id` = (\r\n        SELECT `ex_class_field_group`.`ex_class_field_group_id` \r\n        FROM `ex_class_field_group` \r\n        WHERE `ex_class_field_group`.`ex_class_id` = `ex_class_host_field`.`ex_class_id`\r\n        LIMIT 1\r\n      )";
     $this->addQuery($query);
     $this->makeRevision("1.0.49");
     $query = "ALTER TABLE `ex_class_field` \r\n      CHANGE `prop` `prop` TEXT NOT NULL";
     $this->addQuery($query);
     $this->makeRevision("1.0.50");
     $query = "CREATE TABLE `source_file_system` (\r\n        `source_file_system_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n        `name` VARCHAR (255) NOT NULL,\r\n        `role` ENUM ('prod','qualif') NOT NULL DEFAULT 'qualif',\r\n        `host` TEXT NOT NULL,\r\n        `user` VARCHAR (255),\r\n        `password` VARCHAR (50),\r\n        `type_echange` VARCHAR (255)\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.0.51");
     $this->addMethod("updateExObjectTables");
     $this->makeRevision("1.0.52");
     $query = "CREATE TABLE `view_sender` (\r\n      `sender_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `source_id` INT (11) UNSIGNED,\r\n      `name` VARCHAR (255) NOT NULL,\r\n      `description` TEXT,\r\n      `params` TEXT NOT NULL,\r\n      `period` ENUM ('1','2','3','4','5','6','10','15','20','30'),\r\n      `offset` INT (11) UNSIGNED\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `view_sender` \r\n      ADD INDEX (`source_id`);";
     $this->addQuery($query);
     $query = "CREATE TABLE `view_sender_source` (\r\n      `source_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `name` VARCHAR (255) NOT NULL\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `view_sender` \r\n      ADD INDEX (`source_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.53");
     $query = "ALTER TABLE `source_smtp` \r\n      ADD `active` ENUM ('0','1') NOT NULL DEFAULT '1';";
     $this->addQuery($query);
     $query = "ALTER TABLE `source_file_system` \r\n      ADD `active` ENUM ('0','1') NOT NULL DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("1.0.54");
     $query = "ALTER TABLE `view_sender` \r\n      ADD `active` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.0.55");
     $query = "ALTER TABLE `view_sender` \r\n      CHANGE `offset` `offset` INT (11) UNSIGNED NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.0.56");
     $query = "ALTER TABLE `ex_class` \r\n      ADD `conditional` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.0.57");
     $query = "CREATE TABLE `ex_class_field_trigger` (\r\n      `ex_class_field_trigger_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `ex_class_field_id` INT (11) UNSIGNED NOT NULL,\r\n      `ex_class_triggered_id` INT (11) UNSIGNED NOT NULL,\r\n      `trigger_value` VARCHAR (255) NOT NULL\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field_trigger` \r\n      ADD INDEX (`ex_class_field_id`),\r\n      ADD INDEX (`ex_class_triggered_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.58");
     $query = "ALTER TABLE `ex_class_field_group` \r\n      ADD `formula` TEXT;";
     $this->addQuery($query);
     $this->makeRevision("1.0.59");
     $query = "ALTER TABLE `ex_class_field_group` \r\n      ADD `formula_result_field_id` INT (11) UNSIGNED";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field_group` \r\n      ADD INDEX (`formula_result_field_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.60");
     $query = "ALTER TABLE `ex_class_field`\r\n      ADD `formula` TEXT;";
     $this->addQuery($query);
     $query = "UPDATE `ex_class_field` \r\n      LEFT JOIN `ex_class_field_group` ON `ex_class_field_group`.`formula_result_field_id` = `ex_class_field`.`ex_class_field_id`\r\n      SET `ex_class_field`.`formula` = `ex_class_field_group`.`formula`";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field_group` \r\n      DROP `formula`, \r\n      DROP `formula_result_field_id`;";
     $this->addQuery($query);
     $this->makeRevision("1.0.61");
     $query = "ALTER TABLE `ex_list` \r\n      ADD `multiple` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.0.62");
     $query = "ALTER TABLE `ex_class` \r\n      ADD `required` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.0.63");
     $query = "CREATE TABLE `http_redirection` (\r\n       `http_redirection_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n       `priority` INT (11) NOT NULL DEFAULT '0',\r\n       `from` VARCHAR (255) NOT NULL,\r\n       `to` VARCHAR (255) NOT NULL\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.0.64");
     $query = "CREATE TABLE `ex_class_message` (\r\n      `ex_class_message_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `ex_group_id` INT (11) UNSIGNED NOT NULL,\r\n      `type` ENUM ('info','warning','error'),\r\n      `title` VARCHAR (255) NOT NULL,\r\n      `text` TEXT NOT NULL,\r\n      `coord_title_x` TINYINT (4) UNSIGNED,\r\n      `coord_title_y` TINYINT (4) UNSIGNED,\r\n      `coord_text_x` TINYINT (4) UNSIGNED,\r\n      `coord_text_y` TINYINT (4) UNSIGNED\r\n      ) /*! ENGINE=MyISAM */";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_message` \r\n      ADD INDEX (`ex_group_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.65");
     $this->addMethod("addExReferenceFields");
     $query = "ALTER TABLE `ex_class_field`\r\n      ADD `reported` ENUM ('0','1') NOT NULL DEFAULT '0'";
     $this->addQuery($query);
     $this->makeRevision("1.0.66");
     $query = "ALTER TABLE `ex_class_message` \r\n      CHANGE `type` `type` ENUM ('title','info','warning','error');";
     $this->addQuery($query);
     $this->makeRevision("1.0.67");
     $this->addMethod("addExReferenceFields2");
     $query = "ALTER TABLE `ex_class_field` \r\n      CHANGE `reported` `report_level` ENUM ('1','2')";
     $this->addQuery($query);
     $this->makeRevision("1.0.68");
     $this->addPrefQuery("autocompleteDelay", "short");
     $this->makeRevision("1.0.69");
     $query = "ALTER TABLE `view_sender_source` \r\n        ADD `libelle` VARCHAR (255),\r\n        ADD `group_id` INT (11) UNSIGNED NOT NULL,\r\n        ADD `actif` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $query = "ALTER TABLE `view_sender_source` \r\n        ADD INDEX (`group_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.70");
     $query = "ALTER TABLE `view_sender` \r\n        DROP `source_id`;";
     $this->addQuery($query);
     $query = "CREATE TABLE `source_to_view_sender` (\r\n        `source_to_view_sender_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n        `source_id` INT (11) UNSIGNED NOT NULL,\r\n        `sender_id` INT (11) UNSIGNED NOT NULL\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.0.71");
     $query = "ALTER TABLE `view_sender` \r\n      ADD `max_archives` INT (11) UNSIGNED NOT NULL DEFAULT '10';";
     $this->addQuery($query);
     $query = "ALTER TABLE `source_to_view_sender` \r\n      ADD `last_datetime` DATETIME,\r\n      ADD `last_status` ENUM ('triggered','uploaded','checked'),\r\n      ADD `last_count` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "ALTER TABLE `source_to_view_sender` \r\n      ADD INDEX (`last_datetime`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.72");
     $query = "ALTER TABLE `source_to_view_sender` \r\n      ADD `last_duration` FLOAT,\r\n      ADD `last_size` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $this->makeRevision("1.0.73");
     $this->addPrefQuery("moduleFavicon", "0");
     $this->makeRevision("1.0.74");
     $this->addPrefQuery("showCounterTip", 1);
     $this->makeRevision("1.0.75");
     $this->setTimeLimit(300);
     $query = "ALTER TABLE `access_log`\r\n      ADD `processus` FLOAT,\r\n      ADD `processor` FLOAT,\r\n      ADD `peak_memory` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $this->makeRevision("1.0.76");
     $query = "ALTER TABLE `note` \r\n      CHANGE `degre` `degre` ENUM ('low','medium','high') NOT NULL DEFAULT 'low',\r\n      CHANGE `object_class` `object_class` VARCHAR (80) NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("1.0.77");
     $query = "ALTER TABLE `note` \r\n      CHANGE `user_id` `user_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $this->makeRevision("1.0.78");
     $query = "CREATE TABLE `content_any` (\r\n        `content_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n        `content` TEXT,\r\n        `import_id` INT (11)\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.0.79");
     $query = "CREATE TABLE `session` (\r\n       `session_id` VARCHAR(32) NOT NULL PRIMARY KEY,\r\n       `date_creation` INT(11),\r\n       `date_modification` INT(11),\r\n       `user_id` INT (11) NOT NULL DEFAULT '0',\r\n       `user_ip` VARBINARY (16),\r\n       `user_agent` VARCHAR(100),\r\n       `data` BLOB\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.0.80");
     $query = "ALTER TABLE `ex_class` \r\n      ADD `unicity` ENUM ('no','host','reference1','reference2') NOT NULL DEFAULT 'no';";
     $this->addQuery($query);
     $this->makeRevision("1.0.81");
     $query = "ALTER TABLE `source_smtp` \r\n      ADD `loggable` ENUM ('0','1') NOT NULL DEFAULT '1';";
     $this->addQuery($query);
     $query = "ALTER TABLE `source_file_system` \r\n      ADD `loggable` ENUM ('0','1') NOT NULL DEFAULT '1';";
     $this->addQuery($query);
     $this->makeEmptyRevision("1.0.82");
     $this->makeRevision("1.0.83");
     $query = "ALTER TABLE `ex_class` \r\n      ADD `group_id` INT (11) UNSIGNED,\r\n      ADD INDEX (`group_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.84");
     $this->addPrefQuery("textareaToolbarPosition", "right");
     $this->makeRevision("1.0.85");
     $query = "ALTER TABLE `view_sender_source` \r\n      ADD `archive` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.0.86");
     $query = "ALTER TABLE `view_sender` \r\n      CHANGE `period` `period` ENUM ('1','2','3','4','5','6','10','15','20','30','60');";
     $this->addQuery($query);
     $this->makeRevision("1.0.87");
     $query = "ALTER TABLE `source_file_system` \r\n      ADD `fileextension` VARCHAR (255)";
     $this->addQuery($query);
     $this->makeRevision("1.0.88");
     $query = "ALTER TABLE `source_smtp` \r\n      ADD `timeout` INT (11) DEFAULT '5',\r\n      ADD `debug` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     /* 
     $query = "ALTER TABLE `ex_class_field` 
       ADD `coord_field_colspan` TINYINT (4) UNSIGNED NOT NULL DEFAULT '1' AFTER `coord_field_y`,
       ADD `coord_field_rowspan` TINYINT (4) UNSIGNED NOT NULL DEFAULT '1' AFTER `coord_field_colspan`";
     $this->addQuery($query);
     */
     $this->makeRevision("1.0.89");
     $query = "ALTER TABLE `source_file_system` \r\n      ADD `fileextension_write_end` VARCHAR (255);";
     $this->addQuery($query);
     $this->makeRevision("1.0.90");
     $query = "ALTER TABLE `ex_class_field` \r\n      CHANGE `report_level` `report_level` ENUM ('1','2','host')";
     $this->addQuery($query);
     $this->makeRevision("1.0.91");
     $query = "ALTER TABLE `ex_class_constraint` \r\n      ADD INDEX (`field`)";
     $this->addQuery($query);
     $this->addMethod("addExReferenceFieldsIndex");
     $this->makeRevision("1.0.92");
     $query = "CREATE TABLE `sender_file_system` (\r\n        `sender_file_system_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n        `user_id` INT (11) UNSIGNED,\r\n        `nom` VARCHAR (255) NOT NULL,\r\n        `libelle` VARCHAR (255),\r\n        `group_id` INT (11) UNSIGNED NOT NULL,\r\n        `actif` ENUM ('0','1') NOT NULL DEFAULT '0'\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `sender_file_system` \r\n      ADD INDEX (`user_id`),\r\n      ADD INDEX (`group_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.93");
     $query = "ALTER TABLE `ex_class_host_field` \r\n      ADD `host_type` ENUM ('host','reference1','reference2') DEFAULT 'host'";
     $this->addQuery($query);
     $this->makeRevision("1.0.94");
     $query = "ALTER TABLE `ex_class_message` \r\n      CHANGE `title` `title` VARCHAR (255)";
     $this->addQuery($query);
     $this->makeRevision("1.0.95");
     $query = "ALTER TABLE `sender_file_system` \r\n        ADD `save_unsupported_message` ENUM ('0','1') DEFAULT '1',\r\n        ADD `create_ack_file` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("1.0.96");
     $this->addMethod("addExObjectGroupId");
     $this->makeRevision("1.0.97");
     $query = "ALTER TABLE `view_sender` \r\n      ADD `last_duration` FLOAT,\r\n      ADD `last_size` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $this->makeRevision("1.0.98");
     $query = "CREATE TABLE `configuration` (\r\n      `configuration_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `feature` VARCHAR (255) NOT NULL,\r\n      `value` VARCHAR (255),\r\n      `object_id` INT (11) UNSIGNED,\r\n      `object_class` VARCHAR (80)\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `configuration` \r\n      ADD INDEX (`object_id`, `object_class`),\r\n      ADD UNIQUE (`feature`, `object_id`, `object_class`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.99");
     $this->addPrefQuery("MobileUI", 0);
     $this->makeRevision("1.1.00");
     $query = "ALTER TABLE `source_smtp` \r\n      ADD `auth` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("1.1.0");
     $query = "CREATE TABLE `ex_class_field_predicate` (\r\n      `ex_class_field_predicate_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `ex_class_field_id` INT (11) UNSIGNED NOT NULL,\r\n      `operator` ENUM ('=','!=','>','>=','<','<=','startsWith','endsWith','contains') NOT NULL DEFAULT '=',\r\n      `value` VARCHAR (255) NOT NULL\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field_predicate` \r\n      ADD INDEX (`ex_class_field_id`);";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field` \r\n      ADD `predicate_id` INT (11) UNSIGNED,\r\n      ADD INDEX (`predicate_id`)";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class` \r\n      ADD `native_views` VARCHAR(255),\r\n      ADD INDEX (`native_views`)";
     $this->addQuery($query);
     $this->makeRevision("1.1.01");
     $this->addPrefQuery("MobileDefaultModuleView", 1);
     $this->makeRevision("1.1.02");
     $query = "ALTER TABLE `ex_class_field_group` \r\n      ADD `rank` TINYINT (4) UNSIGNED;";
     $this->addQuery($query);
     $this->makeRevision("1.1.03");
     $query = "ALTER TABLE `sender_file_system` \r\n        ADD `delete_file` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("1.1.04");
     $query = "ALTER TABLE `ex_class_field_predicate`\r\n      CHANGE `operator` `operator`\r\n        ENUM ('=','!=','>','>=','<','<=','startsWith','endsWith','contains','hasValue') NOT NULL DEFAULT '=';";
     $this->addQuery($query);
     $this->makeRevision("1.1.05");
     $query = "CREATE TABLE `datasource_log` (\r\n      `datasourcelog_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,\r\n      `datasource` VARCHAR( 40 ) NOT NULL ,\r\n      `requests` INT (11) UNSIGNED NOT NULL,\r\n      `duration` FLOAT NOT NULL ,\r\n      `accesslog_id` INT UNSIGNED NOT NULL ,\r\n      PRIMARY KEY ( `datasourcelog_id` )) /*! ENGINE=MyISAM */";
     $this->addQuery($query);
     $this->makeRevision("1.1.06");
     $query = "DELETE FROM `datasource_log`";
     $this->addQuery($query);
     $query = "ALTER TABLE `datasource_log` \r\n        ADD UNIQUE `doublon` (`datasource` , `accesslog_id`)";
     $this->addQuery($query);
     $this->makeRevision("1.1.07");
     $query = "CREATE TABLE `source_http` (\r\n      `source_http_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `name` VARCHAR (255) NOT NULL,\r\n      `role` ENUM ('prod','qualif') NOT NULL DEFAULT 'qualif',\r\n      `host` TEXT NOT NULL,\r\n      `user` VARCHAR (255),\r\n      `password` VARCHAR (50),\r\n      `type_echange` VARCHAR (255),\r\n      `active` ENUM ('0','1') NOT NULL DEFAULT '1',\r\n      `loggable` ENUM ('0','1') NOT NULL DEFAULT '1'\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.1.08");
     $query = "ALTER TABLE `source_file_system` \r\n        ADD `fileprefix` VARCHAR (255),\r\n        ADD `sort_files_by` ENUM ('date','name','size') DEFAULT 'name';";
     $this->addQuery($query);
     $this->makeRevision("1.1.09");
     $query = "CREATE TABLE `echange_http` (\r\n        `echange_http_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n        `http_fault` ENUM ('0','1') DEFAULT '0',\r\n        `emetteur` VARCHAR (255),\r\n        `destinataire` VARCHAR (255),\r\n        `date_echange` DATETIME NOT NULL,\r\n        `function_name` VARCHAR (255) NOT NULL,\r\n        `input` MEDIUMTEXT,\r\n        `output` MEDIUMTEXT,\r\n        `purge` ENUM ('0','1') DEFAULT '0',\r\n        `response_time` FLOAT\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `echange_http` \r\n        ADD INDEX (`date_echange`);";
     $this->addQuery($query);
     $this->makeRevision("1.1.10");
     $query = "CREATE TABLE `view_access_token` (\r\n      `view_access_token_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `user_id` INT (11) UNSIGNED NOT NULL,\r\n      `datetime_start` DATETIME NOT NULL,\r\n      `ttl_hours` INT (11) UNSIGNED NOT NULL,\r\n      `params` VARCHAR (255) NOT NULL,\r\n      `hash` CHAR (40) NOT NULL\r\n             ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `view_access_token` \r\n      ADD INDEX (`user_id`),\r\n      ADD INDEX (`datetime_start`),\r\n      ADD INDEX (`hash`);";
     $this->addQuery($query);
     // Moved to "admin"
     $this->makeRevision("1.1.11");
     $query = "DROP TABLE `view_access_token`;";
     $this->addQuery($query);
     $this->makeRevision("1.1.12");
     $this->addPrefQuery("notes_anonymous", "0");
     $this->makeRevision("1.1.13");
     $query = "CREATE TABLE `ex_class_event` (\r\n      `ex_class_event_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `ex_class_id` INT (11) UNSIGNED NOT NULL,\r\n      `host_class` VARCHAR (255) NOT NULL,\r\n      `event_name` VARCHAR (255) NOT NULL,\r\n      `disabled` ENUM ('0','1') NOT NULL DEFAULT '1',\r\n      `unicity` ENUM ('no','host') NOT NULL DEFAULT 'no'\r\n             ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_event` \r\n        ADD INDEX (`ex_class_id`), \r\n        ADD INDEX (`host_class`), \r\n        ADD INDEX (`event_name`), \r\n        ADD INDEX (`disabled`);";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_constraint` \r\n        ADD `ex_class_event_id` INT (11) UNSIGNED NOT NULL;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field` \r\n        ADD `report_class` VARCHAR(80) AFTER `report_level`";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_host_field` \r\n        ADD `host_class` VARCHAR(80) AFTER `host_type`";
     $this->addQuery($query);
     $this->makeRevision("1.1.14");
     $this->addMethod("createExClassEvents");
     $this->makeRevision("1.1.15");
     $query = "CREATE TABLE `ex_class_field_property` (\r\n        `ex_class_field_property_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n        `object_class` VARCHAR (80),\r\n        `object_id` INT (11) UNSIGNED NOT NULL,\r\n        `type` VARCHAR (60),\r\n        `value` VARCHAR (255),\r\n        `predicate_id` INT (11) UNSIGNED\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field_property`\r\n        ADD INDEX (`object_class`),\r\n        ADD INDEX (`object_id`),\r\n        ADD INDEX (`predicate_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.1.16");
     $query = "ALTER TABLE `ex_class_field` \r\n        ADD `prefix` VARCHAR (255),\r\n        ADD `suffix` VARCHAR (255)";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field` \r\n        ADD `coord_left` INT (11) AFTER `coord_label_x`,\r\n        ADD `coord_top` INT (11) AFTER `coord_left`,\r\n        ADD `coord_width` INT (11) UNSIGNED AFTER `coord_top`,\r\n        ADD `coord_height` INT (11) UNSIGNED AFTER `coord_width`,\r\n        ADD `subgroup_id` INT (11) UNSIGNED AFTER `ex_group_id`,\r\n        ADD `show_label` ENUM ('0','1') NOT NULL DEFAULT '1',\r\n        ADD `tab_index` INT (11)";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class` \r\n        ADD `pixel_positionning` ENUM ('0','1') NOT NULL DEFAULT '0'";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_message` \r\n        ADD `coord_left` INT (11),\r\n        ADD `coord_top` INT (11),\r\n        ADD `coord_width` INT (11) UNSIGNED,\r\n        ADD `coord_height` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_host_field` \r\n        ADD `coord_left` INT (11),\r\n        ADD `coord_top` INT (11),\r\n        ADD `coord_width` INT (11) UNSIGNED,\r\n        ADD `coord_height` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "CREATE TABLE `ex_class_field_subgroup` (\r\n        `ex_class_field_subgroup_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n        `parent_class` ENUM ('CExClassFieldGroup','CExClassFieldSubgroup') NOT NULL,\r\n        `parent_id` INT (11) UNSIGNED NOT NULL,\r\n        `title` VARCHAR (255),\r\n        `coord_left` INT (11),\r\n        `coord_top` INT (11),\r\n        `coord_width` INT (11) UNSIGNED,\r\n        `coord_height` INT (11) UNSIGNED\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field_subgroup` \r\n        ADD INDEX (`parent_class`),\r\n        ADD INDEX (`parent_id`)";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_message`\r\n        ADD `subgroup_id` INT (11) UNSIGNED AFTER `ex_group_id`";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_message`\r\n        ADD `predicate_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_message`\r\n        ADD INDEX (`predicate_id`);";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field_subgroup`\r\n        ADD `predicate_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field_subgroup`\r\n        ADD INDEX (`predicate_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.1.17");
     $query = "ALTER TABLE `content_tabular`\r\n        CHANGE `content` `content` LONGTEXT;";
     $this->addQuery($query);
     $this->makeRevision("1.1.18");
     $query = "ALTER TABLE `ex_class_field_predicate`\r\n      CHANGE `operator` `operator`\r\n        ENUM ('=','!=','>','>=','<','<=','startsWith','endsWith','contains','hasValue','hasNoValue') NOT NULL DEFAULT '=';";
     $this->addQuery($query);
     $this->makeRevision("1.1.19");
     $query = "CREATE TABLE `source_pop` (\r\n        `source_pop_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n        `name` VARCHAR (255) NOT NULL,\r\n        `user` VARCHAR (255) NOT NULL,\r\n        `password` VARCHAR (255) NOT NULL,\r\n        `role` ENUM ('prod', 'qualif') NOT NULL DEFAULT 'qualif',\r\n        `type` ENUM ('pop3','imap') NOT NULL DEFAULT 'imap',\r\n        `active` ENUM ('0','1') NOT NULL DEFAULT '1',\r\n        `loggable` ENUM ('0','1') NOT NULL DEFAULT '1',\r\n        `port` INT (11) NOT NULL,\r\n        `host` VARCHAR (50) NOT NULL,\r\n        `auth_ssl` ENUM ('None','SSL/TLS','STARTTLS') NOT NULL,\r\n        `timeout` INT NOT NULL\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.1.20");
     $query = "ALTER TABLE `source_pop`\r\n        ADD `libelle` VARCHAR (255) NOT NULL AFTER `name`;";
     $this->addQuery($query);
     $this->makeRevision("1.1.21");
     $query = "ALTER TABLE `source_pop`\r\n        ADD `object_class` VARCHAR (80) NOT NULL,\r\n        ADD `object_id` INT (11) UNSIGNED NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.1.22");
     $query = "CREATE TABLE `translation` (\r\n      `translation_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `source` VARCHAR (255) NOT NULL,\r\n      `translation` TEXT NOT NULL\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.1.23");
     $query = "ALTER TABLE `translation`\r\n      ADD `language` CHAR (2) NOT NULL DEFAULT 'fr';";
     $this->addQuery($query);
     $this->makeRevision("1.1.24");
     $query = "ALTER TABLE `source_pop`\r\n      ADD `last_update` DATETIME,\r\n      ADD `type_echange` VARCHAR (255);";
     $this->addQuery($query);
     $query = "ALTER TABLE `source_pop`\r\n      ADD INDEX (`last_update`);";
     $this->addQuery($query);
     $this->makeRevision("1.1.25");
     $query = "ALTER TABLE `source_smtp`\r\n        CHANGE `password` `password` VARCHAR (255),\r\n        ADD `iv` VARCHAR (16) AFTER `password`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `source_file_system`\r\n        CHANGE `password` `password` VARCHAR (255),\r\n        ADD `iv` VARCHAR (16) AFTER `password`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `source_http`\r\n        CHANGE `password` `password` VARCHAR (255),\r\n        ADD `iv` VARCHAR (16) AFTER `password`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `source_pop`\r\n        CHANGE `password` `password` VARCHAR (255),\r\n        ADD `iv` VARCHAR (16) AFTER `password`;";
     $this->addQuery($query);
     $this->makeRevision("1.1.26");
     $query = "ALTER TABLE `ex_class_field`\r\n        ADD `result_in_title` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.1.27");
     $query = "ALTER TABLE `ex_concept`\r\n        ADD `native_field` VARCHAR (255);";
     $this->addQuery($query);
     $this->makeRevision("1.1.28");
     $query = "CREATE TABLE `config_db` (\r\n      `key` VARCHAR (255) PRIMARY KEY,\r\n      `value` VARCHAR(255)\r\n      )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.1.29");
     $this->addPrefQuery("sessionLifetime", "");
     $this->makeRevision("1.1.30");
     $this->addPrefQuery("planning_dragndrop", "0");
     $this->addPrefQuery("planning_resize", "0");
     $this->makeRevision("1.1.31");
     $query = "UPDATE `user_preferences`\r\n      SET `value` = 'aero-blue'\r\n      WHERE `key` = 'UISTYLE'\r\n      AND `value` = 'aero'";
     $this->addQuery($query, true);
     $this->makeRevision("1.1.32");
     $query = "DELETE user_preferences\r\n      FROM user_preferences\r\n      LEFT JOIN users ON users.user_id = user_preferences.user_id\r\n      WHERE user_preferences.user_id IS NOT NULL AND user_preferences.user_id <> '0'\r\n      AND  users.user_id IS NULL";
     $this->addQuery($query, true);
     $this->makeRevision("1.1.33");
     $query = "ALTER TABLE `session`\r\n      DROP `date_creation`,\r\n      DROP `date_modification`,\r\n      ADD `expire` INT(11) NOT NULL DEFAULT '0'";
     $this->addQuery($query);
     $this->makeRevision("1.1.34");
     $query = "ALTER TABLE `session`\r\n      CHANGE `data` `data` LONGBLOB";
     $this->addQuery($query);
     $this->makeRevision("1.1.35");
     $query = "CREATE TABLE `long_request_log` (\r\n        `long_request_log_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n        `datetime`            DATETIME NOT NULL,\r\n        `duration`            FLOAT UNSIGNED NOT NULL,\r\n        `server_addr`         VARCHAR (255) NOT NULL,\r\n        `user_id`             INT (11) UNSIGNED NOT NULL,\r\n        `query_params_get`    TEXT,\r\n        `query_params_post`   TEXT,\r\n        `session_data`        TEXT\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `long_request_log`\r\n        ADD INDEX (`datetime`),\r\n        ADD INDEX (`user_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.1.36");
     $this->addPrefQuery("accessibility_dyslexic", "0");
     $this->makeRevision("1.1.37");
     $query = "ALTER TABLE `view_sender`\r\n      CHANGE `period` `period` ENUM ('1','2','3','4','5','6','10','15','20','30','60') NOT NULL DEFAULT '30',\r\n      ADD `every` ENUM ('1','2','3','4','6','8','12','24') NOT NULL DEFAULT '1';";
     $this->addQuery($query);
     $query = "ALTER TABLE `view_sender` \r\n      ADD INDEX (`name`);";
     $this->addQuery($query);
     $this->makeRevision("1.1.38");
     $query = "ALTER TABLE `ex_class_field`\r\n                ADD `disabled` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.1.39");
     $query = "ALTER TABLE `long_request_log`\r\n                ADD `requestUID` VARCHAR (255);";
     $this->addQuery($query);
     $query = "ALTER TABLE `long_request_log`\r\n                ADD INDEX (`requestUID`);";
     $this->addQuery($query);
     $this->makeRevision("1.1.40");
     $this->addPrefQuery("planning_hour_division", "2");
     // Création des deux nouveaux champs
     $this->makeRevision("1.1.41");
     $this->setTimeLimit(1200);
     $query = "ALTER TABLE `access_log`\r\n      ADD `aggregate` INT(11) UNSIGNED NOT NULL DEFAULT '10',\r\n      ADD `bot` BOOL NOT NULL DEFAULT 0;";
     $this->addQuery($query);
     // Mise à jour du champ
     $query = "UPDATE `access_log`\r\n      SET `aggregate` = '60';";
     $this->addQuery($query);
     /**
      * Suppression de l'index UNIQUE triplet
      * Création d'un index unique portant sur le précédent triplet + l'agrégat et le booléen bot
      * Création d'un simple index triplet
      */
     $query = "ALTER TABLE `access_log`\r\n      DROP INDEX `triplet`,\r\n      ADD UNIQUE `aggregate` (`module`, `action`, `period`, `aggregate`, `bot`),\r\n      ADD INDEX `triplet` (`module`, `action`, `period`);";
     $this->addQuery($query);
     // Ajout de l'index sur l'ID du journal d'accès concerné
     $query = "ALTER TABLE `datasource_log`\r\n      ADD INDEX `agregat` (`accesslog_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.1.42");
     $this->addMethod("addExObjectAdditionalObject");
     $this->makeRevision("1.1.43");
     $query = "CREATE TABLE `error_log` (\r\n                `error_log_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `user_id` INT (11) UNSIGNED,\r\n                `server_ip` VARCHAR (80),\r\n                `datetime` DATETIME NOT NULL,\r\n                `request_uid` VARCHAR (255),\r\n                `error_type` ENUM (\r\n                  'exception','error','warning','parse','notice','core_error','core_warning','compile_error',\r\n                  'compile_warning','user_error','user_warning','user_notice','strict','recoverable_error','deprecated',\r\n                  'user_deprecated','js_error'\r\n                 ),\r\n                `text` TEXT,\r\n                `file_name` VARCHAR (255),\r\n                `line_number` INT (11),\r\n\r\n                `stacktrace_id` INT (11) UNSIGNED,\r\n                `param_GET_id` INT (11) UNSIGNED,\r\n                `param_POST_id` INT (11) UNSIGNED,\r\n                `session_data_id` INT (11) UNSIGNED\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `error_log`\r\n                ADD INDEX (`user_id`),\r\n                ADD INDEX (`server_ip`),\r\n                ADD INDEX (`datetime`),\r\n                ADD INDEX (`error_type`);";
     $this->addQuery($query);
     $query = "CREATE TABLE `error_log_data` (\r\n                `error_log_data_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `value` LONGTEXT NOT NULL,\r\n                `value_hash` CHAR(32) NOT NULL,\r\n                UNIQUE (`value_hash`)\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.1.44");
     $query = "ALTER TABLE `source_pop`\r\n                CHANGE `port` `port` INT (11) DEFAULT '25',\r\n                CHANGE `timeout` `timeout` TINYINT (4) DEFAULT '5',\r\n                CHANGE `type` `type` ENUM ('pop3','imap'),\r\n                ADD `extension` VARCHAR (255);";
     $this->addQuery($query);
     $query = "ALTER TABLE `source_pop`\r\n                ADD INDEX (`object_class`),\r\n                ADD INDEX (`object_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.1.45");
     $query = "ALTER TABLE `source_pop`\r\n                ADD `cron_update` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("1.1.46");
     $query = "ALTER TABLE `ex_class_field`\r\n                ADD `in_doc_template` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.1.47");
     $query = "ALTER TABLE `error_log`\r\n                ADD `signature_hash` CHAR(32);";
     $this->addQuery($query);
     $this->makeRevision("1.1.48");
     $query = "ALTER TABLE `source_pop`\r\n                ADD `is_private` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.1.49");
     $query = "ALTER TABLE `content_html`\r\n      ADD `last_modified` DATETIME;";
     $this->addQuery($query);
     $this->makeRevision("1.1.50");
     $query = "ALTER TABLE `access_log`\r\n      ADD `nb_requests` INT (11) AFTER `request`;";
     $this->addQuery($query);
     $query = "UPDATE `access_log`, `datasource_log`\r\n      SET `access_log`.`nb_requests` = `datasource_log`.`requests`\r\n      WHERE `access_log`.`accesslog_id` = `datasource_log`.`accesslog_id`\r\n        AND `datasource_log`.`datasource` = 'std';";
     $this->addQuery($query);
     $this->makeRevision("1.1.51");
     $this->addPrefQuery("useEditAutocompleteUsers", 1);
     // Meilleurs index pour les notes
     $this->makeRevision("1.1.52");
     $query = "ALTER TABLE `note`\r\n      DROP INDEX `user_id`,\r\n      ADD INDEX (`user_id`),\r\n      ADD INDEX  `object_guid` (`object_id`, `object_class`);";
     $this->addQuery($query);
     $this->makeRevision("1.1.53");
     $query = "CREATE TABLE `ex_link` (\r\n                `ex_link_id`   INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `ex_class_id`  INT (11) UNSIGNED NOT NULL DEFAULT '0',\r\n                `ex_object_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\r\n                `level` ENUM('object', 'ref1', 'ref2', 'add') NOT NULL DEFAULT 'object',\r\n                `object_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\r\n                `object_class` VARCHAR (80) NOT NULL,\r\n                `group_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\r\n                INDEX (`ex_class_id`),\r\n                INDEX (`ex_object_id`),\r\n                INDEX (`group_id`),\r\n                INDEX `object` (`object_class`, `object_id`)\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->addMethod("buildExLink");
     $this->makeRevision("1.1.54");
     $query = "ALTER TABLE `ex_class_constraint`\r\n      CHANGE `operator` `operator` ENUM ('=','!=','>','>=','<','<=','startsWith','endsWith','contains','in') NOT NULL DEFAULT '=',\r\n      CHANGE `value` `value` TEXT NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("1.1.55");
     $this->addPrefQuery("useMobileSwipe", "0");
     $this->addPrefQuery("MobileDefaultTheme", "a");
     $this->makeRevision("1.1.56");
     $query = "ALTER TABLE `ex_class_field`\r\n                ADD `readonly` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.1.57");
     $this->addMethod("removeZombieExLinks");
     $this->makeRevision("1.1.58");
     $query = "CREATE TABLE `firstname_to_gender` (\r\n                `first_name_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `firstname`  VARCHAR (255) NOT NULL ,\r\n                `sex` VARCHAR (10) NOT NULL DEFAULT 'u')/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.1.59");
     $query = "CREATE TABLE `user_agent` (\r\n                `user_agent_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `user_agent_string` VARCHAR (255) NOT NULL,\r\n                `browser_name` VARCHAR (30),\r\n                `browser_version` VARCHAR (10),\r\n                `platform_name` VARCHAR (30),\r\n                `platform_version` VARCHAR (10),\r\n                `device_name` VARCHAR (30),\r\n                `device_maker` VARCHAR (30),\r\n                `device_type` ENUM ('desktop','mobile','tablet','unknown') NOT NULL DEFAULT 'unknown',\r\n                `pointing_method` ENUM ('mouse','touchscreen','unknown') NOT NULL DEFAULT 'unknown',\r\n                INDEX (`user_agent_string`)\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "CREATE TABLE `user_authentication` (\r\n                `user_authentication_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `user_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\r\n                `previous_user_id` INT (11) UNSIGNED,\r\n                `auth_method` ENUM ('basic','ldap','ldap_guid','token'),\r\n                `datetime_login` DATETIME NOT NULL,\r\n                `datetime_logout` DATETIME,\r\n                `id_address` CHAR (39) NOT NULL,\r\n                `session_id` CHAR (32) NOT NULL,\r\n                `screen_width` SMALLINT (5),\r\n                `screen_height` SMALLINT (5),\r\n                `user_agent_id` INT (11) UNSIGNED,\r\n                INDEX(`user_id`),\r\n                INDEX(`datetime_login`),\r\n                INDEX(`user_agent_id`),\r\n                INDEX(`session_id`)\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "INSERT INTO `user_authentication` (`user_id`, `auth_method`, `datetime_login`)\r\n                SELECT `user_id`, 'basic', `user_last_login` FROM `users` WHERE `user_last_login` IS NOT NULL";
     $this->addQuery($query);
     $this->makeRevision("1.1.60");
     $query = "ALTER TABLE `ex_class_host_field`\r\n                ADD `type` ENUM ('label','value');";
     $this->addQuery($query);
     $this->makeRevision("1.1.61");
     $this->addMethod("addExObjectDates");
     $this->makeRevision("1.1.62");
     $query = "ALTER TABLE `firstname_to_gender`\r\n                CHANGE `sex` `sex` ENUM ('f','m','u') NOT NULL DEFAULT 'u',\r\n                ADD `language` VARCHAR (255);";
     $this->addQuery($query);
     $this->makeRevision("1.1.63");
     $query = "ALTER TABLE `config_db`\r\n      CHANGE `value` `value` VARCHAR(1024);";
     $this->addQuery($query);
     $this->makeRevision("1.1.64");
     $query = "ALTER TABLE `alert`\r\n      ADD `creation_date` DATETIME,\r\n      ADD `handled_date` DATETIME,\r\n      ADD `handled_user_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $this->makeRevision("1.1.65");
     $query = "ALTER TABLE `source_smtp`\r\n        ADD `libelle` VARCHAR (255);";
     $this->addQuery($query);
     $query = "ALTER TABLE `source_file_system`\r\n        ADD `libelle` VARCHAR (255);";
     $this->addQuery($query);
     $query = "ALTER TABLE `source_http`\r\n        ADD `libelle` VARCHAR (255);";
     $this->addQuery($query);
     $this->makeRevision("1.1.66");
     $query = "ALTER TABLE `view_sender` \r\n                ADD `multipart` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.1.67");
     $query = "CREATE TABLE `cronjob` (\r\n                `cronjob_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `name` VARCHAR (255) NOT NULL,\r\n                `description` TEXT,\r\n                `active` ENUM ('0','1') NOT NULL DEFAULT '1',\r\n                `params` TEXT NOT NULL,\r\n                `execution` VARCHAR (255) NOT NULL,\r\n                `cron_login` VARCHAR (20) NOT NULL,\r\n                `cron_password` VARCHAR (50)\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "CREATE TABLE `cronjob_log` (\r\n                `cronjob_log_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `status` ENUM ('started','finished','error') NOT NULL,\r\n                `error` VARCHAR (255),\r\n                `cronjob_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\r\n                `start_datetime` DATETIME NOT NULL,\r\n                `end_datetime` DATETIME\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `cronjob_log`\r\n                ADD INDEX (`cronjob_id`),\r\n                ADD INDEX (`start_datetime`),\r\n                ADD INDEX (`end_datetime`);";
     $this->addQuery($query);
     $this->makeRevision("1.1.68");
     $query = "CREATE TABLE `module_action` (\r\n                `module_action_id` INT(11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `module` VARCHAR(255) NOT NULL,\r\n                `action` VARCHAR(255) NOT NULL,\r\n                UNIQUE `module_action` (`module`, `action`)\r\n                )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `access_log`\r\n              ADD `module_action_id` INT(11) UNSIGNED NOT NULL AFTER `accesslog_id`,\r\n              ADD INDEX (`module_action_id`);";
     $this->addQuery($query);
     $query = "INSERT IGNORE INTO `module_action` (`module`, `action`)\r\n              SELECT DISTINCT `module`, `action`\r\n              FROM `access_log`;";
     $this->addQuery($query);
     $query = "UPDATE `access_log`\r\n              SET `module_action_id` = (\r\n                SELECT `ma`.`module_action_id`\r\n                FROM `module_action` as `ma`\r\n                WHERE `ma`.`module` = `access_log`.`module`\r\n                  AND `ma`.`action` = `access_log`.`action`\r\n              );";
     $this->addQuery($query);
     $query = "ALTER TABLE `access_log`\r\n                DROP INDEX `aggregate`,\r\n                DROP INDEX `triplet`,\r\n                DROP COLUMN `module`,\r\n                DROP COLUMN `action`,\r\n                ADD UNIQUE `aggregate` (`module_action_id`, `period`, `aggregate`, `bot`),\r\n                ADD INDEX `triplet` (`module_action_id`, `period`);";
     $this->addQuery($query);
     $this->makeRevision("1.1.69");
     $query = "ALTER TABLE `datasource_log`\r\n                ADD COLUMN `module_action_id` INT(11) UNSIGNED NOT NULL AFTER `datasourcelog_id`,\r\n                CHANGE     `datasource` `datasource` CHAR(20) NOT NULL,\r\n                ADD COLUMN `period`           DATETIME NOT NULL,\r\n                ADD COLUMN `aggregate`        INT(11) UNSIGNED NOT NULL DEFAULT '10',\r\n                ADD COLUMN `bot`              BOOL NOT NULL DEFAULT 0,\r\n                ADD INDEX (`module_action_id`),\r\n                ADD INDEX (`period`);";
     $this->addQuery($query);
     $query = "UPDATE `datasource_log`\r\n              JOIN `access_log` ON `access_log`.`accesslog_id` = `datasource_log`.`accesslog_id`\r\n              SET `datasource_log`.`module_action_id` = `access_log`.`module_action_id`,\r\n                  `datasource_log`.`period`           = `access_log`.`period`,\r\n                  `datasource_log`.`aggregate`        = `access_log`.`aggregate`,\r\n                  `datasource_log`.`bot`              = `access_log`.`bot`;";
     $this->addQuery($query);
     // Purge of orphan datasource logs
     $query = "DELETE FROM `datasource_log`\r\n              WHERE `accesslog_id` = '0'\r\n                OR `period` = '0000-00-00 00:00:00';";
     $this->addQuery($query);
     $query = "ALTER TABLE `datasource_log`\r\n                DROP INDEX `doublon`,\r\n                DROP INDEX `agregat`,\r\n                DROP COLUMN `accesslog_id`,\r\n                ADD UNIQUE `aggregate` (`datasource`, `module_action_id`, `period`, `aggregate`, `bot`),\r\n                ADD INDEX `triplet` (`datasource`, `module_action_id`, `period`);";
     $this->addQuery($query);
     $this->makeRevision("1.1.70");
     $query = "ALTER TABLE `cronjob`\r\n                ADD `servers_address` VARCHAR (255);";
     $this->addQuery($query);
     $query = "ALTER TABLE `cronjob_log`\r\n                ADD `server_address` VARCHAR (255);";
     $this->addQuery($query);
     $this->makeRevision("1.1.71");
     $query = "CREATE TABLE `access_log_archive`\r\n              LIKE `access_log`;";
     $this->addQuery($query);
     $query = "CREATE TABLE `datasource_log_archive`\r\n              LIKE `datasource_log`;";
     $this->addQuery($query);
     $this->makeRevision("1.1.72");
     $query = "INSERT INTO `access_log_archive` (\r\n                SELECT *\r\n                FROM `access_log`\r\n                WHERE `aggregate` > '10'\r\n              );";
     $this->addQuery($query);
     $query = "INSERT INTO `datasource_log_archive` (\r\n                SELECT *\r\n                FROM `datasource_log`\r\n                WHERE `aggregate` > '10'\r\n              );";
     $this->addQuery($query);
     $this->makeRevision("1.1.73");
     $query = "DELETE FROM `access_log`\r\n              WHERE `aggregate` > '10';";
     $this->addQuery($query);
     $query = "DELETE FROM `datasource_log`\r\n              WHERE `aggregate` > '10';";
     $this->addQuery($query);
     $this->makeRevision("1.1.74");
     $query = "ALTER TABLE `ex_class`\r\n                ADD `cross_context_class` ENUM ('CPatient'),\r\n                DROP `host_class`,\r\n                DROP `event`,\r\n                DROP `disabled`,\r\n                DROP `required`,\r\n                DROP `unicity`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_constraint`\r\n                DROP `ex_class_id`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_field`\r\n                DROP `ex_class_id`,\r\n                DROP `report_level`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_host_field`\r\n                DROP `ex_class_id`,\r\n                DROP `host_type`;";
     $this->addQuery($query);
     $this->makeRevision("1.1.75");
     $query = "ALTER TABLE `ex_link`\r\n                    ADD `datetime_create` DATETIME,\r\n                    ADD `owner_id`        INT(11) UNSIGNED,\r\n                    ADD INDEX (`owner_id`),\r\n                    ADD INDEX (`datetime_create`);";
     $this->addQuery($query);
     $this->addMethod("addExLinkDates");
     $this->makeRevision("1.1.76");
     $query = "CREATE TABLE `ex_class_picture` (\r\n                `ex_class_picture_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `ex_group_id` INT (11) UNSIGNED,\r\n                `subgroup_id` INT (11) UNSIGNED,\r\n                `name` VARCHAR (255) NOT NULL,\r\n                `disabled` ENUM ('0','1') NOT NULL DEFAULT '0',\r\n                `show_label` ENUM ('0','1') NOT NULL DEFAULT '1',\r\n                `predicate_id` INT (11) UNSIGNED,\r\n                `coord_left` INT (11),\r\n                `coord_top` INT (11),\r\n                `coord_width` INT (11) UNSIGNED,\r\n                `coord_height` INT (11) UNSIGNED\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class_picture`\r\n                ADD INDEX (`ex_group_id`),\r\n                ADD INDEX (`subgroup_id`),\r\n                ADD INDEX (`predicate_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.1.77");
     $this->addPrefQuery("navigationHistoryLength", 0);
     $this->makeRevision("1.1.78");
     $query = "ALTER TABLE `ex_class_field`\r\n                ADD `hidden` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.1.79");
     $query = "ALTER TABLE `configuration`\r\n                CHANGE `value` `value` VARCHAR(1024)";
     $this->addQuery($query);
     $this->makeRevision('1.1.80');
     $query = "CREATE TABLE `syslog_source` (\r\n                `syslog_source_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,\r\n                `name`             VARCHAR(255) NOT NULL,\r\n                `role`             ENUM('prod','qualif') NOT NULL DEFAULT 'qualif',\r\n                `host`             TEXT NOT NULL,\r\n                `user`             VARCHAR(255),\r\n                `password`         VARCHAR(50),\r\n                `iv`               VARCHAR(255),\r\n                `type_echange`     VARCHAR(255),\r\n                `active`           ENUM('0','1') NOT NULL DEFAULT '1',\r\n                `loggable`         ENUM('0','1') NOT NULL DEFAULT '1',\r\n                `libelle`          VARCHAR(255)\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision('1.1.81');
     $query = "ALTER TABLE `syslog_source`\r\n                ADD `port` INT(11) DEFAULT '514' NOT NULL,\r\n                ADD `protocol` ENUM('TCP', 'UDP', 'TLS') DEFAULT 'TCP' NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision('1.1.82');
     $query = "ALTER TABLE `syslog_source`\r\n                ADD `timeout` TINYINT(4) DEFAULT '5';";
     $this->addQuery($query);
     $this->makeRevision('1.1.83');
     $query = "ALTER TABLE `syslog_source`\r\n              ADD `ssl_enabled`     ENUM ('0','1') NOT NULL DEFAULT '0',\r\n              ADD `ssl_certificate` VARCHAR(255),\r\n              ADD `ssl_passphrase`  VARCHAR(255);";
     $this->addQuery($query);
     $this->makeRevision('1.1.84');
     $query = "ALTER TABLE `syslog_source`\r\n                CHANGE `password` `password` VARCHAR(255),\r\n                CHANGE `iv`       `iv`       VARCHAR(16) AFTER `password`,\r\n                ADD `iv_passphrase`          VARCHAR(16) AFTER `ssl_passphrase`;";
     $this->addQuery($query);
     $this->makeRevision("1.1.85");
     $this->addMethod("removeDuplicatePreferences");
     $this->makeRevision("1.1.86");
     $query = "ALTER TABLE `error_log`\r\n                ADD `debug` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.1.87");
     $query = "ALTER TABLE `access_log`\r\n                ADD `session_wait` FLOAT AFTER `duration`,\r\n                ADD `session_read` FLOAT AFTER `session_wait`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `access_log_archive`\r\n                ADD `session_wait` FLOAT AFTER `duration`,\r\n                ADD `session_read` FLOAT AFTER `session_wait`;";
     $this->addQuery($query);
     $this->makeRevision("1.1.88");
     $query = "ALTER TABLE user_authentication ADD INDEX user_auth_date (user_id,datetime_login)";
     $this->addQuery($query, true);
     $this->makeRevision("1.1.89");
     $query = "CREATE TABLE `ex_class_category` (\r\n                `ex_class_category_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `group_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\r\n                `title` VARCHAR (255) NOT NULL,\r\n                `description` TEXT,\r\n                `color` VARCHAR (6),\r\n                INDEX (`group_id`)\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ex_class`\r\n                ADD `category_id` INT (11) UNSIGNED,\r\n                ADD INDEX (`category_id`);";
     $this->addQuery($query);
     $this->mod_version = "1.1.90";
 }
Ejemplo n.º 24
0
 /**
  * Standard constructor
  */
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "dPsante400";
     $this->makeRevision("all");
     $query = "CREATE TABLE `id_sante400` (\r\n      `id_sante400_id` INT NOT NULL AUTO_INCREMENT ,\r\n      `object_class` VARCHAR( 25 ) NOT NULL ,\r\n      `object_id` INT NOT NULL ,\r\n       `tag` VARCHAR( 80 ) ,\r\n       `last_update` DATETIME NOT NULL ,\r\n        PRIMARY KEY ( `id_sante400_id` ) ,\r\n        INDEX ( `object_class` , `object_id` , `tag` )) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("0.1");
     $query = "ALTER TABLE `id_sante400` ADD `id400` VARCHAR( 8 ) NOT NULL ;";
     $this->addQuery($query);
     $this->makeRevision("0.11");
     $query = "ALTER TABLE `id_sante400` CHANGE `id400` `id400` VARCHAR( 10 ) NOT NULL ;";
     $this->addQuery($query);
     $this->makeRevision("0.12");
     $query = "ALTER TABLE `id_sante400`\r\n      CHANGE `id_sante400_id` `id_sante400_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n      CHANGE `object_id` `object_id` int(11) unsigned NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.13");
     $query = "ALTER TABLE `id_sante400` DROP INDEX `object_class` ;";
     $this->addQuery($query);
     $query = "ALTER TABLE `id_sante400` ADD INDEX ( `object_class` ) ;";
     $this->addQuery($query);
     $query = "ALTER TABLE `id_sante400` ADD INDEX ( `object_id` ) ;";
     $this->addQuery($query);
     $query = "ALTER TABLE `id_sante400` ADD INDEX ( `tag` ) ;";
     $this->addQuery($query);
     $query = "ALTER TABLE `id_sante400` ADD INDEX ( `last_update` ) ;";
     $this->addQuery($query);
     $query = "ALTER TABLE `id_sante400` ADD INDEX ( `id400` ) ;";
     $this->addQuery($query);
     $this->makeRevision("0.14");
     $query = "UPDATE `id_sante400` \r\n      SET `tag`='labo code4' \r\n      WHERE `tag`='LABO' \r\n      AND `object_class`='CMediusers' ;";
     $this->addQuery($query);
     $this->makeRevision("0.15");
     $query = "UPDATE `id_sante400`\r\n      SET `tag` = CONCAT('NDOS ', LEFT(`tag`, 8))\r\n      WHERE `object_class` = 'CSejour'\r\n      AND `tag` LIKE 'CIDC:___ DMED:________'";
     $this->addQuery($query);
     $this->makeRevision("0.16");
     $query = "CREATE TABLE `trigger_mark` (\r\n      `mark_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `trigger_class` VARCHAR (255) NOT NULL,\r\n      `trigger_number` VARCHAR (10) NOT NULL,\r\n      `mark` VARCHAR (255) NOT NULL,\r\n      `done` ENUM ('0','1') NOT NULL\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("0.17");
     $query = "ALTER TABLE `trigger_mark` ADD UNIQUE `trigger_unique` (\r\n      `trigger_class` ,\r\n      `trigger_number`\r\n    );";
     $this->addQuery($query);
     $query = "ALTER TABLE `trigger_mark` ADD INDEX ( `mark` );";
     $this->addQuery($query);
     $this->makeRevision("0.18");
     $query = "ALTER TABLE `trigger_mark` \r\n       CHANGE `trigger_number` `trigger_number` BIGINT (10) UNSIGNED ZEROFILL NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.19");
     $query = "ALTER TABLE `id_sante400` \r\n       CHANGE `id400` `id400` VARCHAR  (25) NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.20");
     $query = "ALTER TABLE `id_sante400` \r\n       CHANGE `id400` `id400` VARCHAR  (80) NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.21");
     $query = "ALTER TABLE `id_sante400` \r\n       CHANGE `object_class` `object_class` VARCHAR (40) NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.22");
     $query = "CREATE TABLE `incrementer` (\r\n      `incrementer_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `type` ENUM ('IPP','NDA') NOT NULL,\r\n      `group_id` INT (11) UNSIGNED NOT NULL,\r\n      `last_update` DATETIME NOT NULL,\r\n      `value` VARCHAR (255) NOT NULL DEFAULT '1',\r\n      `pattern` VARCHAR (255) NOT NULL\r\n     ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `incrementer` \r\n      ADD INDEX (`last_update`);";
     $this->addQuery($query);
     $this->makeRevision("0.23");
     $query = "ALTER TABLE `incrementer` \r\n      CHANGE `type` `object_class` ENUM ('CPatient','CSejour') NOT NULL;";
     $this->addQuery($query);
     $query = "ALTER TABLE `incrementer` \r\n      ADD INDEX (`object_class`),\r\n      ADD INDEX (`group_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.24");
     $query = "ALTER TABLE `trigger_mark` \r\n      ADD INDEX ( `trigger_class` ),\r\n      ADD INDEX ( `trigger_number` );";
     $this->addQuery($query);
     $this->makeRevision("0.25");
     $query = "ALTER TABLE `incrementer` \r\n      ADD `range_min` INT (11) UNSIGNED,\r\n      ADD `range_max` INT (11);";
     $this->addQuery($query);
     $this->makeRevision("0.26");
     $query = "ALTER TABLE `trigger_mark`\r\n      ADD `when` DATETIME,\r\n     CHANGE `done` `done` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision('0.27');
     $query = "CREATE TABLE `hypertext_link` (\r\n                `hypertext_link_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `name` VARCHAR (255) NOT NULL,\r\n                `link` VARCHAR (255) NOT NULL,\r\n                `object_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\r\n                `object_class` VARCHAR (80) NOT NULL\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = 'ALTER TABLE `hypertext_link`
             ADD INDEX (`object_id`),
             ADD INDEX (`object_class`);';
     $this->addQuery($query);
     $this->makeRevision("0.28");
     if (CModule::getInstalled("hprim21")) {
         $this->addDefaultConfig("dPsante400 CIdSante400 admit_ipp_nda_obligatory", "hprim21 mandatory_num_dos_ipp_adm");
     }
     $this->makeRevision("0.29");
     $query = "ALTER TABLE `id_sante400`\r\n                ADD `datetime_create` DATETIME NOT NULL,\r\n                ADD INDEX ( `datetime_create` ) ;";
     $this->addQuery($query);
     $query = "UPDATE `id_sante400`\r\n      SET `datetime_create` = `last_update`";
     $this->addQuery($query);
     $this->mod_version = '0.30';
 }
Ejemplo n.º 25
0
 function __construct()
 {
     parent::__construct();
     $this->mod_type = "core";
     $this->mod_name = "admin";
     $this->makeRevision("all");
     $this->makeRevision("1.0.14");
     $query = "ALTER TABLE `user_preferences`\n      DROP PRIMARY KEY;";
     $this->addQuery($query);
     $query = "ALTER TABLE `user_preferences`\n      ADD `pref_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n      CHANGE `pref_user` `user_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\n      CHANGE `pref_name` `key` VARCHAR (255) NOT NULL,\n      CHANGE `pref_value` `value` VARCHAR (255);";
     $this->addQuery($query);
     $this->makeRevision("1.0.15");
     $query = "ALTER TABLE `users`\n      ADD INDEX (`user_birthday`),\n      ADD INDEX (`user_last_login`),\n      ADD INDEX (`profile_id`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.16");
     $query = "ALTER TABLE `users`\n      CHANGE `user_address1` `user_address1` VARCHAR( 255 );";
     $this->addQuery($query);
     $this->makeRevision("1.0.17");
     $query = "ALTER TABLE `users`\n      ADD `dont_log_connection` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.0.18");
     $query = "CREATE TABLE `source_ldap` (\n      `source_ldap_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n      `name` VARCHAR (255) NOT NULL,\n      `host` TEXT NOT NULL,\n      `port` INT (11) DEFAULT '389',\n      `rootdn` VARCHAR (255) NOT NULL,\n      `ldap_opt_protocol_version` INT (11) DEFAULT '3',\n      `ldap_opt_referrals` ENUM ('0','1') DEFAULT '0'\n     ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.0.19");
     $query = "ALTER TABLE `source_ldap`\n                ADD `bind_rdn_suffix` VARCHAR (255);";
     $this->addQuery($query);
     $this->makeRevision("1.0.20");
     $query = "ALTER TABLE `source_ldap`\n              ADD `priority` INT (11);";
     $this->addQuery($query);
     $this->makeRevision("1.0.21");
     $query = "ALTER TABLE `source_ldap`\n              ADD `secured` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.0.22");
     $query = "ALTER TABLE `users`\n      CHANGE `user_phone`  `user_phone`  VARCHAR (20),\n      CHANGE `user_mobile` `user_mobile` VARCHAR (20)";
     $this->addQuery($query);
     $this->makeRevision("1.0.23");
     $query = "ALTER TABLE `users`\n      DROP `user_pic`,\n      DROP `user_signature`,\n      CHANGE `user_password`     `user_password`     VARCHAR(255),\n      CHANGE `user_login_errors` `user_login_errors` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '0',\n      CHANGE `user_type`         `user_type`         TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.0.24");
     $query = "ALTER TABLE `users`\n      ADD `user_salt` CHAR(64) AFTER `user_password`,\n      MODIFY `user_password` CHAR(64);";
     $this->addQuery($query);
     $this->makeRevision("1.0.25");
     $this->addDependency("system", "1.1.12");
     $query = "CREATE TABLE `view_access_token` (\n      `view_access_token_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n      `user_id` INT (11) UNSIGNED NOT NULL,\n      `datetime_start` DATETIME NOT NULL,\n      `ttl_hours` INT (11) UNSIGNED NOT NULL,\n      `first_use` DATETIME,\n      `params` VARCHAR (255) NOT NULL,\n      `hash` CHAR (40) NOT NULL\n     ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `view_access_token`\n      ADD INDEX (`user_id`),\n      ADD INDEX (`datetime_start`),\n      ADD INDEX (`first_use`),\n      ADD INDEX (`hash`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.26");
     $query = "ALTER TABLE\n      `user_preferences` CHANGE `user_id` `user_id` INT( 11 ) UNSIGNED NULL";
     $this->addQuery($query);
     $query = "UPDATE `user_preferences`\n      SET `user_id` = NULL\n      WHERE `user_id` = '0'";
     $this->addQuery($query);
     $this->makeRevision("1.0.27");
     $query = "ALTER TABLE `users` ADD `user_astreinte` VARCHAR (20)";
     $this->addQuery($query);
     $this->makeRevision("1.0.28");
     $query = "ALTER TABLE `user_preferences`\n      CHANGE `value` `value` TEXT;";
     $this->addQuery($query);
     $this->makeRevision("1.0.29");
     $date = CMbDT::dateTime();
     $query = "ALTER TABLE `users`\n      ADD `user_password_last_change` DATETIME NOT NULL DEFAULT '{$date}' AFTER `user_password`;";
     $this->addQuery($query);
     $this->makeRevision("1.0.30");
     $query = "ALTER TABLE `users`\n                CHANGE `user_birthday` `user_birthday` CHAR (10)";
     $this->addQuery($query);
     $this->makeRevision("1.0.31");
     $query = "UPDATE `users`\n                SET `user_birthday` = NULL\n                WHERE `user_birthday` = '0000-00-00'";
     $this->addQuery($query);
     $this->makeRevision("1.0.32");
     $this->addPrefQuery("notes_anonymous", "0");
     $this->makeRevision("1.0.33");
     $query = "ALTER TABLE\n                `view_access_token` ADD `restricted` ENUM('0', '1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.0.34");
     $query = "ALTER TABLE `user_preferences`\n              ADD `restricted` ENUM('0', '1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.0.35");
     $query = "CREATE TABLE `log_access_medical_object` (\n                `access_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n                `user_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\n                `datetime` DATETIME NOT NULL,\n                `object_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\n                `object_class` VARCHAR (80) NOT NULL,\n                `group_id` INT (11) UNSIGNED NOT NULL DEFAULT '0'\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.0.36");
     $query = "ALTER TABLE `log_access_medical_object`\n                ADD INDEX (`user_id`),\n                ADD INDEX (`datetime`),\n                ADD INDEX (`object_id`),\n                ADD INDEX (`object_class`),\n                ADD INDEX (`group_id`),\n                ADD UNIQUE unique_line (`user_id`, `datetime`, `object_id`, `object_class`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.37");
     $query = "CREATE TABLE `bris_de_glace` (\n                `bris_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\n                `date` DATETIME NOT NULL,\n                `user_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\n                `object_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\n                `object_class` VARCHAR (80) NOT NULL\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("1.0.38");
     $query = "ALTER TABLE `bris_de_glace`\n                ADD INDEX (`date`),\n                ADD INDEX (`user_id`),\n                ADD INDEX (`object_id`),\n                ADD INDEX (`object_class`);";
     $this->addQuery($query);
     $this->makeRevision("1.0.39");
     $query = "ALTER TABLE `bris_de_glace`\n                ADD `comment` TEXT NOT NULL,\n                ADD `group_id` INT (11) UNSIGNED NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $query = "ALTER TABLE `bris_de_glace`\n                ADD INDEX (`group_id`)";
     $this->addQuery($query);
     $this->makeRevision("1.0.40");
     $query = "ALTER TABLE `users`\n      ADD `force_change_password` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("1.0.41");
     $query = "ALTER TABLE  `users` ADD INDEX (`user_type`)";
     $this->addQuery($query);
     $this->mod_version = "1.0.42";
 }
Ejemplo n.º 26
0
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "dPsalleOp";
     $this->makeRevision("all");
     $this->makeRevision("0.1");
     $query = "CREATE TABLE `acte_ccam` (\r\n                `acte_id` INT NOT NULL ,\r\n                `code_activite` VARCHAR( 2 ) NOT NULL ,\r\n                `code_phase` VARCHAR( 1 ) NOT NULL ,\r\n                `execution` DATETIME NOT NULL ,\r\n                `modificateurs` VARCHAR( 4 ) ,\r\n                `montant_depassement` FLOAT,\r\n                `commentaire` TEXT,\r\n                `operation_id` INT NOT NULL ,\r\n                `executant_id` INT NOT NULL ,\r\n              PRIMARY KEY ( `acte_id` )) /*! ENGINE=MyISAM */";
     $this->addQuery($query);
     $this->makeRevision("0.11");
     $query = "ALTER TABLE `acte_ccam`\r\n                ADD `code_acte` CHAR( 7 ) NOT NULL AFTER `acte_id`";
     $this->addQuery($query);
     $query = "ALTER TABLE `acte_ccam`\r\n                ADD UNIQUE (`code_acte`, `code_activite`, `code_phase`, `operation_id`)";
     $this->addQuery($query);
     $this->makeRevision("0.12");
     $query = "ALTER TABLE `acte_ccam`\r\n                CHANGE `acte_id` `acte_id` INT( 11 ) NOT NULL AUTO_INCREMENT";
     $this->addQuery($query);
     $this->makeRevision("0.13");
     $query = "ALTER TABLE `acte_ccam`\r\n                DROP INDEX `code_acte`";
     $this->addQuery($query);
     $this->makeRevision("0.14");
     $query = "ALTER TABLE `acte_ccam`\r\n                CHANGE `acte_id` `acte_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n                CHANGE `operation_id` `operation_id` int(11) unsigned NOT NULL DEFAULT '0',\r\n                CHANGE `executant_id` `executant_id` int(11) unsigned NOT NULL DEFAULT '0',\r\n                CHANGE `code_activite` `code_activite` tinyint(2) unsigned zerofill NOT NULL,\r\n                CHANGE `code_phase` `code_phase` tinyint(1) unsigned zerofill NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.15");
     $query = "ALTER TABLE `acte_ccam`\r\n                CHANGE `code_acte` `code_acte` varchar(7) NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.16");
     $query = "ALTER TABLE `acte_ccam`\r\n                CHANGE `code_activite` `code_activite` TINYINT(4) NOT NULL,\r\n                CHANGE `code_phase` `code_phase` TINYINT(4) NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.17");
     $query = "ALTER TABLE `acte_ccam`\r\n                CHANGE `operation_id` `subject_id` int(11) unsigned NOT NULL DEFAULT '0',\r\n                ADD `subject_class` VARCHAR(25) NOT NULL;";
     $this->addQuery($query);
     $query = "UPDATE `acte_ccam` SET `subject_class` = 'COperation';";
     $this->addQuery($query);
     $this->makeRevision("0.18");
     $query = "ALTER TABLE `acte_ccam`\r\n                CHANGE `subject_id` `object_id` int(11) unsigned NOT NULL DEFAULT '0',\r\n                CHANGE `subject_class` `object_class` VARCHAR(25) NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.19");
     $query = "ALTER TABLE `acte_ccam`\r\n                ADD `code_association` TINYINT(4)";
     $this->addQuery($query);
     $this->makerevision("0.20");
     $query = "ALTER TABLE `acte_ccam`\r\n                ADD `regle` ENUM('0','1');";
     $this->addQuery($query);
     $this->makerevision("0.21");
     $query = "ALTER TABLE `acte_ccam`\r\n                ADD INDEX ( `code_acte` ),\r\n                ADD INDEX ( `code_activite` ),\r\n                ADD INDEX ( `code_phase` ),\r\n                ADD INDEX ( `object_id` ),\r\n                ADD INDEX ( `executant_id` ),\r\n                ADD INDEX ( `object_class` )";
     $this->addQuery($query);
     $this->makeRevision("0.22");
     $query = "ALTER TABLE `acte_ccam`\r\n                ADD `montant_base` FLOAT;";
     $this->addQuery($query);
     $this->makeRevision("0.23");
     $query = "ALTER TABLE `acte_ccam`\r\n                ADD `signe` ENUM('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.24");
     $query = "ALTER TABLE `acte_ccam`\r\n                ADD `rembourse` ENUM('0','1'),\r\n                CHANGE `object_class` `object_class` ENUM('COperation','CSejour','CConsultation') NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.25");
     $query = "CREATE TABLE `daily_check_item` (\r\n                `daily_check_item_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `list_id` INT (11) UNSIGNED NOT NULL,\r\n                `item_type_id` INT (11) UNSIGNED NOT NULL,\r\n                `checked` ENUM ('0','1') NOT NULL\r\n              ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_item` \r\n                ADD INDEX (`list_id`),\r\n                ADD INDEX (`item_type_id`);";
     $this->addQuery($query);
     $query = "CREATE TABLE `daily_check_item_type` (\r\n                `daily_check_item_type_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `title` VARCHAR (255) NOT NULL,\r\n                `desc` TEXT,\r\n                `active` ENUM ('0','1') NOT NULL,\r\n                `group_id` INT (11) UNSIGNED NOT NULL\r\n              ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_item_type` ADD INDEX (`group_id`)";
     $this->addQuery($query);
     $query = "CREATE TABLE `daily_check_list` (\r\n                `daily_check_list_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `date` DATE NOT NULL,\r\n                `room_id` INT (11) UNSIGNED NOT NULL,\r\n                `validator_id` INT (11) UNSIGNED\r\n              ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_list` \r\n                ADD INDEX (`date`),\r\n                ADD INDEX (`room_id`),\r\n                ADD INDEX (`validator_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.26");
     $query = "ALTER TABLE `daily_check_item_type` \r\n                ADD `category_id` INT (11) UNSIGNED NOT NULL,\r\n                ADD INDEX (`category_id`);";
     $this->addQuery($query);
     $query = "CREATE TABLE `daily_check_item_category` (\r\n                `daily_check_item_category_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `title` VARCHAR (255) NOT NULL,\r\n                `desc` TEXT\r\n              ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("0.27");
     $query = "ALTER TABLE `acte_ccam` \r\n                ADD `charges_sup` ENUM ('0','1')";
     $this->addQuery($query);
     $this->makeRevision("0.28");
     $query = "ALTER TABLE `daily_check_list` \r\n                CHANGE `room_id` `object_id` INT (11) UNSIGNED NOT NULL,\r\n                ADD `object_class` VARCHAR(80) NOT NULL DEFAULT 'CSalle'";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_item_category` \r\n                ADD `target_class` VARCHAR(80) NOT NULL DEFAULT 'CSalle'";
     $this->addQuery($query);
     $this->makeRevision("0.29");
     $query = "ALTER TABLE `daily_check_list` ADD `comments` TEXT";
     $this->addQuery($query);
     $this->makerevision("0.30");
     $query = "ALTER TABLE `acte_ccam`\r\n                ADD `regle_dh` ENUM('0','1') DEFAULT '0' AFTER `regle`;";
     $this->addQuery($query);
     $this->makeRevision("0.31");
     $query = "ALTER TABLE `daily_check_item_category` \r\n                ADD `type` ENUM ('preanesth','preop','postop');";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_item` \r\n                CHANGE `checked` `checked` ENUM ('0','1');";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_item_type` \r\n                ADD `attribute` ENUM ('normal','notrecommended','notapplicable'),\r\n                CHANGE `group_id` `group_id` INT(11) UNSIGNED NULL";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_list` \r\n                ADD `type` ENUM ('preanesth','preop','postop'),\r\n                CHANGE `object_class` `object_class` ENUM ('CSalle','CBlocOperatoire','COperation') NOT NULL";
     $this->addQuery($query);
     // Liste des points de check liste spécifiés par la HAS
     $categories = array('01' => array('preanesth', 'Identité du patient', array(array('le patient a décliné son nom, sinon, par défaut, autre moyen de vérification de son identité', 'normal'))), '02' => array('preanesth', 'L\'intervention et site opératoire sont confirmés', array(array('idéalement par le patient et dans tous les cas, par le dossier ou procédure spécifique', 'normal'), array('la documentation clinique et para clinique nécessaire est disponible en salle', 'normal'))), '03' => array('preanesth', null, array(array('Le mode d\'installation est connu de l\'équipe en salle, cohérent avec le site/intervention et non dangereuse pour le patient', 'notapplicable'))), '04' => array('preanesth', 'Le matériel nécessaire pour l\'intervention est vérifié', array(array('pour la partie chirurgicale', 'normal'), array('pour la partie anesthésique', 'normal'))), '05' => array('preanesth', 'Vérification croisée par l\'équipe de points critiques et des mesures adéquates à prendre', array(array('allergie du patient', 'normal'), array('risque d\'inhalation, de difficulté d\'intubation ou de ventilation au masque', 'normal'), array('risque de saignement important', 'normal'))), '06' => array('preop', 'Vérification « ultime » croisée au sein de l\'équipe', array(array('identité patient correcte', 'normal'), array('intervention prévue confirmée', 'normal'), array('site opératoire correct', 'normal'), array('installation correcte', 'normal'), array('documents nécessaires disponibles', 'notapplicable'))), '07' => array('preop', 'Partage des informations essentielles dans l\'équipe sur des éléments à risque / points critiques de l\'intervention', array(array('sur le plan chirurgical (temps opératoire difficile, points spécifiques de l\'intervention, etc.)', 'normal'), array('sur le plan anesthésique (risques potentiels liés au terrain ou à des traitements éventuellement maintenus)', 'normal'))), '08' => array('preop', null, array(array('Antibioprophylaxie effectuée', 'notrecommended'))), '09' => array('postop', 'Confirmation orale par le personnel auprès de l\'équipe', array(array('de l\'intervention enregistrée', 'normal'), array('du compte final correct des compresses, aiguilles, instruments, etc.', 'notapplicable'), array('de l\'étiquetage des prélèvements, pièces opératoires, etc.', 'notapplicable'), array('du signalement de dysfonctionnements matériels et des événements indésirables', 'normal'))), '10' => array('postop', null, array(array('Les prescriptions pour les suites opératoires immédiates sont faites de manière conjointe', 'notrecommended'))));
     foreach ($categories as $title => $cat) {
         $query = "INSERT INTO `daily_check_item_category` (`title`, `desc`, `target_class`, `type`) VALUES\r\n                               (%1, %2, 'COperation', %3)";
         $query = $this->ds->prepare($query, $title, $cat[1], $cat[0]);
         $this->addQuery($query);
         foreach ($cat[2] as $type) {
             $query = "INSERT INTO `daily_check_item_type` (`title`, `active`, `attribute`, `category_id`) VALUES (\r\n                    %1, '1', %2, (\r\n                      SELECT `daily_check_item_category_id`\r\n                      FROM `daily_check_item_category`\r\n                      WHERE `title` = %3\r\n                      AND `target_class` = 'COperation'\r\n                    )\r\n                  )";
             $query = $this->ds->prepare($query, $type[0], $type[1], $title);
             $this->addQuery($query);
         }
     }
     $this->makeRevision("0.32");
     $query = "ALTER TABLE `acte_ccam` \r\n                ADD INDEX (`execution`);";
     $this->addQuery($query);
     $this->makeRevision("0.33");
     $query = "CREATE TABLE `anesth_perop` (\r\n                `anesth_perop_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `operation_id` INT (11) UNSIGNED NOT NULL,\r\n                `libelle` VARCHAR (255) NOT NULL,\r\n                `datetime` DATETIME NOT NULL\r\n              ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `anesth_perop` \r\n                ADD INDEX (`operation_id`),\r\n                ADD INDEX (`datetime`);";
     $this->addQuery($query);
     $this->makeRevision("0.34");
     $query = "ALTER TABLE `daily_check_item` CHANGE \r\n                `checked` `checked` ENUM ('0','1','yes','no','na','nr')";
     $this->addQuery($query);
     // yes
     $query = "UPDATE `daily_check_item` SET `checked` = 'yes' WHERE `checked` = '1'";
     $this->addQuery($query);
     // no
     $query = "UPDATE `daily_check_item` \r\n                LEFT JOIN `daily_check_item_type` ON `daily_check_item_type`.`daily_check_item_type_id` = `daily_check_item`.`item_type_id`\r\n                SET `daily_check_item`.`checked` = 'no' \r\n                WHERE `daily_check_item`.`checked` = '0' AND (\r\n                  `daily_check_item_type`.`attribute` = 'normal' OR \r\n                  `daily_check_item_type`.`attribute` = 'notrecommended'\r\n                )";
     $this->addQuery($query);
     // nr
     $query = "UPDATE `daily_check_item`\r\n                LEFT JOIN `daily_check_item_type` ON `daily_check_item_type`.`daily_check_item_type_id` = `daily_check_item`.`item_type_id`\r\n                SET `checked` = 'nr' \r\n                WHERE `daily_check_item`.`checked` IS NULL AND \r\n                  `daily_check_item_type`.`attribute` = 'notrecommended'";
     $this->addQuery($query);
     // na
     $query = "UPDATE `daily_check_item`\r\n                LEFT JOIN `daily_check_item_type` ON `daily_check_item_type`.`daily_check_item_type_id` = `daily_check_item`.`item_type_id`\r\n                SET `checked` = 'na' \r\n                WHERE `daily_check_item`.`checked` = '0' AND\r\n                  `daily_check_item_type`.`attribute` = 'notapplicable'";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_item` CHANGE \r\n                `checked` `checked` ENUM ('yes','no','na','nr') NOT NULL";
     $this->addQuery($query);
     $changes = array(array('04', 1, "preanesth", "notapplicable"), array('05', 1, "preanesth", "notapplicable"), array('06', 4, "preop", "normal"), array('07', 1, "preop", "notapplicable"), array('10', 0, "postop", "normal"));
     foreach ($changes as $_change) {
         $libelle = addslashes($categories[$_change[0]][2][$_change[1]][0]);
         $query = "UPDATE `daily_check_item_type` \r\n      LEFT JOIN `daily_check_item_category`\r\n        ON `daily_check_item_category`.`daily_check_item_category_id` = `daily_check_item_type`.`category_id`\r\n      SET `daily_check_item_type`.`attribute` = '{$_change[3]}'\r\n      WHERE \r\n        `daily_check_item_category`.`target_class` = 'COperation' AND \r\n        `daily_check_item_category`.`type` = '{$_change[2]}' AND\r\n        `daily_check_item_category`.`title` = '{$_change[0]}' AND \r\n        `daily_check_item_type`.`title` = '{$libelle}'";
         $this->addQuery($query);
     }
     $query = "ALTER TABLE `daily_check_list` \r\n                CHANGE `type` `type` ENUM ('preanesth','preop','postop','preendoscopie','postendoscopie')";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_item_category` \r\n                CHANGE `type` `type` ENUM ('preanesth','preop','postop','preendoscopie','postendoscopie');";
     $this->addQuery($query);
     // Liste des points de check liste d'endoscopie digestive spécifiés par la HAS (au 24/08/2010)
     $category_changes = array('01' => array('preendoscopie', 'Identité du patient', array(array('le patient a décliné son nom, sinon, par défaut, autre moyen de vérification de son identité', 'normal'))), '02' => array('preendoscopie', null, array(array('Le type de l\'endoscopie est confirmé par le patient et dans tous les cas par le dossier', 'normal'))), '03' => array('preendoscopie', 'Le matériel nécessaire pour l\'intervention est opérationnel', array(array('pour la partie endoscopique', 'normal'), array('pour la partie anesthésique', 'notapplicable'))), '04' => array('preendoscopie', 'Vérification croisée par l\'équipe de points critiques et des mesures adéquates à prendre', array(array('allergie du patient', 'normal'), array('risque d\'inhalation, de difficulté d\'intubation ou de ventilation au masque', 'normal'), array('risque de saignement important', 'normal'))), '05' => array('preendoscopie', null, array(array('Patient à jeun', 'normal'))), '06' => array('preendoscopie', null, array(array('La préparation adéquate (coloscopie, gastrostomie) a été mise en oeuvre', 'notapplicable'))), '07' => array('preendoscopie', null, array(array('Vérification croisée de situations spécifiques entre les membres de l\'équipe médico-soignante ' . 'concernant notamment la gestion des antiagrégants plaquettaires et/ou des anticoagulants', 'notapplicable'))), '08' => array('preendoscopie', null, array(array('Antibioprophylaxie effectuée', 'notapplicable'))), '09' => array('postendoscopie', null, array(array('Confirmation orale par le personnel auprès de l\'équipe de l\'étiquetage des prélèvements, pièces opératoires, etc.', 'notapplicable'))), '10' => array('postendoscopie', null, array(array('Les prescriptions pour les suites immédiates de l\'endoscopie sont faites de manière conjointe', 'normal'))));
     foreach ($category_changes as $title => $cat) {
         $query = "INSERT INTO `daily_check_item_category` (`title`, `desc`, `target_class`, `type`) VALUES (?1, ?2, 'COperation', ?3)";
         $query = $this->ds->prepare($query, $title, $cat[1], $cat[0]);
         $this->addQuery($query);
         foreach ($cat[2] as $type) {
             $query = "INSERT INTO `daily_check_item_type` (`title`, `active`, `attribute`, `category_id`) VALUES (\r\n                    ?1, '1', ?2, (\r\n                      SELECT `daily_check_item_category_id`\r\n                      FROM `daily_check_item_category`\r\n                      WHERE `title` = ?3\r\n                      AND `target_class` = 'COperation'\r\n                      AND `type` = ?4\r\n                    )\r\n                  )";
             $query = $this->ds->prepare($query, $type[0], $type[1], $title, $cat[0]);
             $this->addQuery($query);
         }
     }
     $this->makeRevision("0.35");
     $query = "ALTER TABLE `acte_ccam` \r\n                ADD `sent` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.36");
     $query = "ALTER TABLE `daily_check_item_type` \r\n                ADD `default_value` ENUM ('yes','no','nr','na') NOT NULL DEFAULT 'yes',\r\n                ADD `index` TINYINT (2) UNSIGNED NOT NULL";
     $this->addQuery($query);
     $this->addMethod("addCheckItemsIndex");
     $this->makeRevision("0.37");
     $category_changes = array(array('COperation', 'preanesth', '01', '01', ""), array('COperation', 'preanesth', '04', '05', "L'équipement / matériel nécessaire pour l'intervention est vérifié et ne présente pas de dysfonctionnements"), array('COperation', 'preanesth', '05', '06', "Vérification croisée par l'équipe de points critiques et mise en oeuvre des mesures adéquates : Le patient présente-t-il un ?"), array('COperation', 'preop', '06', '07', "Vérification \"ultime\" croisée au sein de l'équipe en présence des chirurgiens(s), anesthésiste(s), /IADE-IBODE/IDE"), array('COperation', 'preop', '07', '08', "Partage des informations essentielles oralement au sein de l'équipe  sur les éléments à risque / étapes  critiques de l'intervention (Time out)"), array('COperation', 'preop', '08', '09'), array('COperation', 'postop', '09', '10'), array('COperation', 'postop', '10', '11'));
     $this->changeCheckListCategories($category_changes);
     // Category additions
     $category_additions = array(array('COperation', 'preanesth', '04'));
     $this->addCheckListCategories($category_additions);
     // Type changes
     $type_changes = array(array('COperation', 'preanesth', '01', array("index" => 1, "title" => "L'identité du patient est correcte")), array('COperation', 'preanesth', '03', array("index" => 1, "attribute" => "normal")), array('COperation', 'preanesth', '05', array("index" => 2, "title" => "pour la partie anesthésique. \n(N/A: Acte sans prise en charge anesthésique)")), array('COperation', 'preanesth', '06', array("index" => 1, "title" => "risque d'allergie", "default" => "no")), array('COperation', 'preanesth', '06', array("index" => 2, "default" => "no")), array('COperation', 'preanesth', '06', array("index" => 3, "default" => "no")), array('COperation', 'preop', '07', array("index" => 3, "title" => "site opératoire confirmé")), array('COperation', 'preop', '07', array("index" => 4, "title" => "installation correcte confirmée")), array('COperation', 'preop', '07', array("index" => 5, "title" => "documents nécessaires disponibles (notamment imagerie)", "attribute" => "notapplicable")), array('COperation', 'preop', '08', array("index" => 1, "title" => "sur le plan chirurgical (temps opératoire difficile, points spécifiques de l'intervention, identification des matériels nécessaires, confirmation de leur opérationnalité, etc.)")), array('COperation', 'preop', '08', array("index" => 2, "title" => "sur le plan anesthésique (N/A: Acte sans prise en charge anesthésique) (risques potentiels liés au terrain ou à des traitements éventuellement maintenus, etc.)")), array('COperation', 'preop', '09', array("index" => 1, "title" => "L'antibioprophylaxie a été effectuée selon les recommandations et protocoles en vigueur dans l'établissement")), array('COperation', 'postop', '10', array("index" => 4, "title" => "si des évènements indésirables ou porteurs de risques médicaux sont survenus : ont-ils fait l'objet d'un signalement / déclaration ? (N/A: aucun évènement indésirable n'est survenu pendant l'intervention)", "attribute" => "notapplicable")), array('COperation', 'postop', '11', array("index" => 1, "title" => "Les prescriptions pour les suites opératoires immédiates sont faites de manière conjointe entre les équipes chirurgicale et anesthésiste")));
     $this->changeCheckListTypes($type_changes);
     // type additions
     $type_additions = array(array('COperation', 'preanesth', '04', array("index" => 1, "title" => "La préparation cutanée de l'opéré est documentée dans la fiche de liaison service / bloc opératoire (ou autre procédure en oeuvre dans l'établissement)", "attribute" => "notapplicable", "default" => "yes")), array('COperation', 'preop', '09', array("index" => 2, "title" => "La préparation du champ opératoire est réalisée selon le protocole en vigueur dans l'établissement", "attribute" => "notapplicable", "default" => "yes")));
     foreach ($type_additions as $_type) {
         $cat_class = $_type[0];
         $cat_type = $_type[1];
         $cat_title = $_type[2];
         $data = $_type[3];
         $query = $this->ds->prepare("INSERT INTO `daily_check_item_type` (`title`, `attribute`, `default_value`, `index`, `active`, `category_id`)\r\n      VALUES (?1, ?2, ?3, ?4, '1', (\r\n        SELECT daily_check_item_category.daily_check_item_category_id\r\n        FROM daily_check_item_category\r\n        WHERE \r\n          `daily_check_item_category`.`target_class` = '{$cat_class}' AND \r\n          `daily_check_item_category`.`type` = '{$cat_type}' AND\r\n          `daily_check_item_category`.`title` = '{$cat_title}'\r\n        LIMIT 1\r\n      ))", $data["title"], $data["attribute"], $data["default"], $data["index"]);
         $this->addQuery($query);
     }
     // Liste des points de check liste d'endoscopie bronchique spécifiés par la HAS (au 08/02/2011)
     $query = "ALTER TABLE `daily_check_list` \r\n                CHANGE `type` `type` ENUM ('preanesth','preop','postop','preendoscopie','postendoscopie','preendoscopie_bronchique','postendoscopie_bronchique')";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_item_category` \r\n                CHANGE `type` `type` ENUM ('preanesth','preop','postop','preendoscopie','postendoscopie','preendoscopie_bronchique','postendoscopie_bronchique');";
     $this->addQuery($query);
     $check_list = array('01' => array('preendoscopie_bronchique', 'Identité du patient', array(array('le patient a décliné son nom, sinon, par défaut, autre moyen de vérification de son identité', 'normal', 'yes'))), '02' => array('preendoscopie_bronchique', 'Le matériel nécessaire pour l\'intervention est opérationnel', array(array('pour la partie endoscopique', 'normal', 'yes'), array('pour la partie anesthésique', 'notapplicable', 'yes'))), '03' => array('preendoscopie_bronchique', null, array(array('Patient à jeun', 'normal', 'yes'))), '04' => array('preendoscopie_bronchique', 'Vérification croisée par l\'équipe de points critiques et des mesures adéquates à prendre', array(array('allergie du patient', 'normal', 'yes'), array('risque de saignement important', 'normal', 'yes'))), '05' => array('preendoscopie_bronchique', null, array(array('Vérification croisée de situations spécifiques entre les membres de l\'équipe médico-soignante ' . 'concernant notamment la gestion des antiagrégants plaquettaires et/ou des anticoagulants', 'notapplicable', 'yes'))), '06' => array('postendoscopie_bronchique', null, array(array('Confirmation orale par le personnel auprès de l\'équipe de l\'étiquetage des prélèvements, pièces opératoires, etc.', 'notapplicable', 'yes'))), '07' => array('postendoscopie_bronchique', null, array(array('Les prescriptions pour les suites immédiates de l\'endoscopie sont faites de manière conjointe', 'normal', 'yes'))));
     $this->addNewCheckList($check_list);
     $this->makeRevision("0.38");
     $query = "ALTER TABLE `anesth_perop` \r\n                CHANGE `libelle` `libelle` TEXT NOT NULL;";
     $this->addQuery($query);
     $query = "ALTER TABLE `anesth_perop` \r\n                ADD `incident` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.39");
     $query = "ALTER TABLE `acte_ccam` \r\n                ADD `motif_depassement` ENUM ('d','e','f','n') AFTER `montant_depassement`;";
     $this->addQuery($query);
     $this->makeRevision("0.40");
     // Liste des points de check liste sécurité du patient en radiologie
     // interventionnelle spécifiés par la HAS, version 2011-01 (au 16/12/2011)
     $query = "ALTER TABLE `daily_check_list` \r\n                CHANGE `type` `type` ENUM ('preanesth','preop','postop','preendoscopie','postendoscopie','preendoscopie_bronchique','postendoscopie_bronchique','preanesth_radio','preop_radio','postop_radio')";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_item_category` \r\n                CHANGE `type` `type` ENUM ('preanesth','preop','postop','preendoscopie','postendoscopie','preendoscopie_bronchique','postendoscopie_bronchique','preanesth_radio','preop_radio','postop_radio');";
     $this->addQuery($query);
     $check_list = array('00' => array('preanesth_radio', null, array(array('Informations au patient', 'normal', 'yes'), array('Traçabilité du consentement éclairé', 'normal', 'yes'), array('Dossier correspondant au patient', 'normal', 'yes'))), '01' => array('preanesth_radio', null, array(array('L\'identité du patient est correcte', 'normal', 'yes'))), '02' => array('preanesth_radio', 'L\'intervention et site opératoire sont confirmés', array(array('idéalement par le patient et dans tous les cas, par le dossier ou procédure spécifique', 'normal', 'yes'), array('la documentation clinique et para clinique nécessaire est disponible en salle', 'normal', 'yes'))), '03' => array('preanesth_radio', null, array(array('Le mode d\'installation est connu de l\'équipe en salle, cohérent avec le site/intervention et non dangereux pour le patient', 'normal', 'yes'))), '04' => array('preanesth_radio', null, array(array('La préparation cutanée de l\'opéré est documentée dans la fiche de liaison service', 'notapplicable', 'yes'))), '05' => array('preanesth_radio', 'L\'équipement / matériel nécessaire pour l\'intervention est vérifié et ne présente pas de dysfonctionnement', array(array('pour la partie chirurgicale', 'normal', 'yes'), array('pour la partie anesthésique', 'normal', 'yes'), array('pour la partie imagerie', 'normal', 'yes'))), '06' => array('preanesth_radio', 'Vérification croisée par l\'équipe de points critiques et mise en oeuvre des mesures adéquates à prendre. Le patient présente-t-il :', array(array('un risque allergique', 'normal', 'no'), array('un risque lié au produit de contraste', 'normal', 'no'), array('une insuffisance rénale', 'normal', 'no'), array('risque d\'inhalation, de difficulté d\'intubation ou de ventilation au masque', 'normal', 'no'), array('un risque de saignement important', 'normal', 'no'), array('un risque lié à l\'irradiation (grossesse)', 'normal', 'no'))), '07' => array('preop_radio', 'Vérification « ultime » croisée au sein de l\'équipe en présence des anesthésistes, radiologues et manipulateurs électroradio.', array(array('identité patient confirmée', 'normal', 'yes'), array('intervention prévue confirmée', 'normal', 'yes'), array('site interventionnel confirmé', 'normal', 'yes'), array('installation correcte confirmée', 'normal', 'yes'), array('documents nécessaires disponibles', 'normal', 'yes'), array('monitorage du patient vérifié', 'normal', 'yes'))), '08' => array('preop_radio', 'Partage des informations essentielles oralement au sein de l\'équipe sur les éléments à risque / étapes critiques de l\'intervention.', array(array('sur le plan interventionnel (voie d\'abord définie, technique précisée, DMI disponibles, etc.)', 'normal', 'yes'), array('sur le plan anesthésique (risques potentiels liés au terrain ou à des traitements éventuellement maintenus, etc.)', 'notapplicable', 'yes'))), '09' => array('preop_radio', 'Prise en compte de situations spécifiques concernant', array(array('la gestion des antiagrégants', 'notapplicable', 'yes'), array('la gestion des anticoagulants', 'notapplicable', 'yes'), array('l\'antibioprophylaxie effectuée', 'notapplicable', 'yes'), array('la préparation du champ opératoire réalisé selon protocole en vigueur', 'notapplicable', 'yes'))), '10' => array('postop_radio', 'Confirmation orale par le personnel auprès de l\'équipe :', array(array('de l\'intervention enregistrée', 'normal', 'yes'), array('de l\'étiquetage des prélèvements, pièces opératoires, etc.', 'notapplicable', 'yes'), array('des médications utilisées', 'normal', 'yes'), array('de la quantité de produit contraste', 'normal', 'yes'), array('du recueil de l\'irradiation délivrée', 'normal', 'yes'), array('de la traçabilité du matériel et DMI', 'normal', 'yes'), array('de l\'enregistrement des images', 'normal', 'yes'), array('de la feuille de liaison remplie', 'normal', 'yes'), array('si des événements indésirables ou porteurs de risques médicaux sont survenus : ont-ils fait l\'objet d\'un 
              signalement / déclaration ? (Si aucun événement indésirable n\'est survenu pendant l\'intervention, cochez N/A)', 'notapplicable', 'yes'))), '11' => array('postop_radio', null, array(array('Les prescriptions pour les suites opératoires immédiates sont faites de manière conjointe entre les équipes de radiologie et d\'anesthésie', 'normal', 'yes'))));
     $this->addNewCheckList($check_list);
     $this->makeRevision("0.41");
     // Check list pose CVC
     $query = "ALTER TABLE `daily_check_list` \r\n                CHANGE `object_class` `object_class` ENUM ('CSalle','CBlocOperatoire','COperation','CPoseDispositifVasculaire') NOT NULL DEFAULT 'CSalle',\r\n                CHANGE `type` `type` ENUM ('preanesth','preop','postop','preendoscopie','postendoscopie','preendoscopie_bronchique','postendoscopie_bronchique','preanesth_radio','preop_radio','postop_radio','disp_vasc_avant','disp_vasc_pendant','disp_vasc_apres')";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_item_category` \r\n                CHANGE `type` `type` ENUM ('preanesth','preop','postop','preendoscopie','postendoscopie','preendoscopie_bronchique','postendoscopie_bronchique','preanesth_radio','preop_radio','postop_radio','disp_vasc_avant','disp_vasc_pendant','disp_vasc_apres');";
     $this->addQuery($query);
     $check_list = array('01' => array('disp_vasc_avant', null, array(array('Identité du patient vérifiée', 'normal', 'yes'))), '02' => array('disp_vasc_avant', null, array(array('Patient / famille informé', 'normal', 'yes'))), '03' => array('disp_vasc_avant', "ÉVALUATION DES RISQUES", array(array('Risque hémorragique, allergie, contre-indications anatomique ou pathologique', 'normal', 'yes'))), '04' => array('disp_vasc_avant', null, array(array('Choix argumenté du site d\'insertion', 'normal', 'yes'))), '05' => array('disp_vasc_avant', null, array(array('Choix concerté du matériel', 'normal', 'yes'))), '06' => array('disp_vasc_avant', null, array(array('Préparation cutanée appropriée', 'normal', 'yes'))), '07' => array('disp_vasc_avant', null, array(array('Monitorage approprié', 'normal', 'yes'))), '08' => array('disp_vasc_avant', "Vérification du matériel", array(array('Date de péremption, intégrité de l\'emballage', 'normal', 'yes'))), '09' => array('disp_vasc_avant', null, array(array('Échographie', 'normal', 'yes'))), '10' => array('disp_vasc_pendant', "PROCÉDURES D'HYGIÈNE", array(array('Détersion/désinfection avec antiseptique alcoolique', 'normal', 'yes'), array('Conditions d\'asepsie chirurgicale', 'normal', 'yes'))), '11' => array('disp_vasc_pendant', "Vérifications per opératoires des matériels", array(array('Mécanique: Solidité des connexions', 'normal', 'yes'), array('Positionnelle: Extrémité du cathéter', 'normal', 'yes'), array('FONCTIONNELLE: Reflux sanguin', 'normal', 'yes'), array('FONCTIONNELLE: Système perméable', 'normal', 'yes'))), '12' => array('disp_vasc_pendant', null, array(array('Vérification de la fixation du dispositif', 'normal', 'yes'))), '13' => array('disp_vasc_pendant', null, array(array('Pose d\'un pansement occlusif', 'normal', 'yes'))), '14' => array('disp_vasc_pendant', "Si utilisation différée, fermeture du dispositif", array(array('En accord avec la procédure locale', 'normal', 'yes'))), '15' => array('disp_vasc_apres', "CONTRÔLE CVC / DV", array(array('Position du CVC vérifiée', 'normal', 'yes'), array('Recherche de complication', 'normal', 'yes'))), '16' => array('disp_vasc_apres', "TRAÇABILITÉ / COMPTE RENDU", array(array('Matériel, technique, nombre de ponctions, incident', 'normal', 'yes'))), '17' => array('disp_vasc_apres', null, array(array('Prescriptions pour le suivi après pose', 'normal', 'yes'))), '18' => array('disp_vasc_apres', null, array(array('Documents remis au patient', 'normal', 'yes'))));
     $this->addNewCheckList($check_list, "CPoseDispositifVasculaire");
     $this->makeRevision("0.42");
     $query = "ALTER TABLE `acte_ccam`\r\n                ADD `facturable` ENUM ('0','1') NOT NULL DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.43");
     $query = "ALTER TABLE `daily_check_item_category`\r\n                CHANGE `target_class` `target_class` ENUM ('CSalle','CBlocOperatoire','COperation','CPoseDispositifVasculaire') NOT NULL DEFAULT 'CSalle',\r\n                ADD `target_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_item_category`\r\n                ADD INDEX (`target_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.44");
     // Check list sécurité du patient en endoscopie digestive, version 2013
     $this->moveCheckListCategory("10", "postendoscopie", "11");
     $this->moveCheckListCategory("09", "postendoscopie", "10");
     // Nouveau point 09
     $check_list = array('09' => array('preendoscopie', 'Patient suspect ou atteint d\'EST', array(array('(en cas de réponse positive, l\'endoscopie doit être considérée comme un acte à risque de transmission d\'ATNC et ' . 'il convient de se référer aux procédures en cours dans l\'établissement en lien avec l\'Instruction n°DGS/R13/2011' . '/449)', 'normal', 'yes'))));
     $this->addNewCheckList($check_list);
     $this->makeRevision("0.45");
     $query = "ALTER TABLE `acte_ccam`\r\n                ADD `ald` ENUM ('0','1') NOT NULL DEFAULT '0',\r\n                ADD `lieu` ENUM('C', 'D') DEFAULT 'C' NOT NULL,\r\n                ADD `exoneration` ENUM('N', '13', '15', '17', '19') DEFAULT 'N' NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.46");
     $query = "CREATE TABLE `daily_check_list_type` (\r\n                `daily_check_list_type_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `object_class` ENUM ('CSalle','CBlocOperatoire') NOT NULL DEFAULT 'CSalle',\r\n                `object_id` INT (11) UNSIGNED,\r\n                `title` VARCHAR (255) NOT NULL,\r\n                `description` TEXT\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_list_type`\r\n                ADD INDEX (`object_id`);";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_item_category`\r\n                ADD `list_type_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "INSERT INTO `daily_check_list_type` (`object_class`, `object_id`, `title`)\r\n                SELECT `target_class`, `target_id`, 'Check list standard'\r\n                FROM `daily_check_item_category`\r\n                WHERE `target_class` NOT IN ('COperation', 'CPoseDispositifVasculaire')\r\n                GROUP BY `target_class`, `target_id`;";
     $this->addQuery($query);
     $query = "UPDATE `daily_check_item_category` SET\r\n                `list_type_id` = (\r\n                  SELECT `daily_check_list_type_id`\r\n                  FROM `daily_check_list_type`\r\n                  WHERE `daily_check_list_type`.`object_class` = `daily_check_item_category`.`target_class`\r\n                  AND   (\r\n                       `daily_check_list_type`.`object_id`    = `daily_check_item_category`.`target_id`\r\n                    OR `daily_check_list_type`.`object_id` IS NULL AND `daily_check_item_category`.`target_id` IS NULL\r\n                  )\r\n                  LIMIT 1\r\n                )\r\n                WHERE `target_class` NOT IN ('COperation', 'CPoseDispositifVasculaire');";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_list`\r\n                ADD `list_type_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_list`\r\n                ADD INDEX (`list_type_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.47");
     $query = "CREATE TABLE `daily_check_list_type_link` (\r\n                `daily_check_list_type_link_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `object_class` ENUM ('CSalle','CBlocOperatoire') NOT NULL DEFAULT 'CSalle',\r\n                `object_id` INT (11) UNSIGNED,\r\n                `list_type_id` INT (11) UNSIGNED NOT NULL DEFAULT '0'\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_list_type_link`\r\n                ADD INDEX (`object_id`),\r\n                ADD INDEX (`object_class`),\r\n                ADD INDEX (`list_type_id`);";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_list_type`\r\n                ADD `group_id` INT ( 11 ) UNSIGNED NOT NULL DEFAULT 0;";
     $this->addQuery($query);
     $this->makeRevision("0.48");
     $this->addMethod("listToGroup");
     $query = "INSERT INTO `daily_check_list_type_link` (`object_class`, `object_id`, `list_type_id`)\r\n                SELECT `object_class`, `object_id`, `daily_check_list_type_id` FROM `daily_check_list_type`";
     $this->addQuery($query);
     $this->makeRevision("0.49");
     $query = "ALTER TABLE `acte_ccam`\r\n                ADD `extension_documentaire` ENUM ('1','2','3','4','5','6') AFTER `code_association`;";
     $this->addQuery($query);
     $this->makeRevision("0.50");
     // Check list sécurité du patient en endoscopie bronchique, version 2013
     $this->moveCheckListCategory("07", "postendoscopie_bronchique", "08");
     $this->moveCheckListCategory("06", "postendoscopie_bronchique", "07");
     // Nouveau point 06
     $check_list = array('06' => array('preendoscopie_bronchique', 'Patient suspect ou atteint d\'EST', array(array('(en cas de réponse positive, l\'endoscopie doit être considérée comme un acte à risque de transmission d\'ATNC et ' . 'il convient de se référer aux procédures en cours dans l\'établissement en lien avec l\'Instruction n°DGS/R13/2011' . '/449)', 'normal', 'yes'))));
     $this->addNewCheckList($check_list);
     $this->moveCheckListCategory("04", "preendoscopie_bronchique", "05b");
     $this->moveCheckListCategory("02", "preendoscopie_bronchique", "04");
     $this->moveCheckListCategory("03", "preendoscopie_bronchique", "02");
     $this->moveCheckListCategory("05", "preendoscopie_bronchique", "03");
     $this->moveCheckListCategory("05b", "preendoscopie_bronchique", "05");
     $this->makeRevision("0.51");
     $this->addDependency("dPplanningOp", "1.50");
     $this->addDependency("dPbloc", "0.23");
     $query = "ALTER TABLE `daily_check_list`\r\n                ADD `group_id` INT (11) UNSIGNED NOT NULL,\r\n                ADD INDEX (`group_id`);";
     $this->addQuery($query);
     // Update CSalle
     $query = "UPDATE `daily_check_list` SET\r\n                `daily_check_list`.`group_id` = (\r\n                  SELECT `group_id`\r\n                  FROM `bloc_operatoire`\r\n                  LEFT JOIN `sallesbloc` ON `sallesbloc`.`bloc_id` = `bloc_operatoire`.`bloc_operatoire_id`\r\n                  WHERE `sallesbloc`.`salle_id` = `daily_check_list`.`object_id`\r\n                )\r\n                WHERE `daily_check_list`.`object_class` = 'CSalle'";
     $this->addQuery($query);
     // Update CBlocOperatoire
     $query = "UPDATE `daily_check_list` SET\r\n                `daily_check_list`.`group_id` = (\r\n                  SELECT `group_id`\r\n                  FROM `bloc_operatoire`\r\n                  WHERE `bloc_operatoire_id` = `daily_check_list`.`object_id`\r\n                )\r\n                WHERE `daily_check_list`.`object_class` = 'CBlocOperatoire'";
     $this->addQuery($query);
     // Update COperation
     $query = "UPDATE `daily_check_list` SET\r\n                `daily_check_list`.`group_id` = (\r\n                  SELECT `group_id`\r\n                  FROM `sejour`\r\n                  LEFT JOIN `operations` ON `operations`.`sejour_id` = `sejour`.`sejour_id`\r\n                  WHERE `operations`.`operation_id` = `daily_check_list`.`object_id`\r\n                )\r\n                WHERE `daily_check_list`.`object_class` = 'COperation'";
     $this->addQuery($query);
     // Update CPoseDispositifVasculaire
     $query = "UPDATE `daily_check_list` SET\r\n                `daily_check_list`.`group_id` = (\r\n                  SELECT `group_id`\r\n                  FROM `sejour`\r\n                  LEFT JOIN `pose_dispositif_vasculaire` ON `pose_dispositif_vasculaire`.`sejour_id` = `sejour`.`sejour_id`\r\n                  WHERE `pose_dispositif_vasculaire`.`pose_dispositif_vasculaire_id` = `daily_check_list`.`object_id`\r\n                )\r\n                WHERE `daily_check_list`.`object_class` = 'CPoseDispositifVasculaire'";
     $this->addQuery($query);
     $this->makeRevision("0.52");
     $query = "ALTER TABLE `acte_ccam`\r\n                ADD `num_facture` INT (11) UNSIGNED NOT NULL DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.53");
     self::addDefaultConfig("dPsalleOp COperation use_sortie_reveil_reel");
     $this->makeRevision("0.54");
     $query = "ALTER TABLE `daily_check_list_type`\r\n                ADD `type_validateur` TEXT;";
     $this->addQuery($query);
     $this->makeRevision("0.55");
     $query = "UPDATE `daily_check_list_type` SET\r\n                `type_validateur` = 'chir|anesth|op|op_panseuse|iade|sagefemme|manipulateur'\r\n                WHERE `object_class` = 'CSalle'";
     $this->addQuery($query);
     $query = "UPDATE `daily_check_list_type` SET\r\n                `type_validateur` = 'reveil'\r\n                WHERE `object_class` = 'CBlocOperatoire'";
     $this->addQuery($query);
     $this->makeRevision("0.56");
     $query = "ALTER TABLE `daily_check_item_category`\r\n                CHANGE `type` `type` ENUM ('preanesth','preop','postop','preendoscopie','postendoscopie','preendoscopie_bronchique','postendoscopie_bronchique','preanesth_radio','preop_radio','postop_radio','disp_vasc_avant','disp_vasc_pendant','disp_vasc_apres', 'avant_indu_cesar', 'cesarienne_avant', 'cesarienne_apres');";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_list`\r\n                CHANGE `type` `type` ENUM ('preanesth','preop','postop','preendoscopie','postendoscopie','preendoscopie_bronchique','postendoscopie_bronchique','preanesth_radio','preop_radio','postop_radio','disp_vasc_avant','disp_vasc_pendant','disp_vasc_apres', 'avant_indu_cesar', 'cesarienne_avant', 'cesarienne_apres');";
     $this->addQuery($query);
     $check_list = array('01' => array('avant_indu_cesar', 'Identité patient', array(array('Identité de la patiente est correct', 'normal', 'yes'))), '02' => array('avant_indu_cesar', 'Les éléments essentiels à la prise en charge sont connus par l\'équipe', array(array('La localisation du placenta', 'normal', 'yes'), array('La présentation de l\'enfant', 'normal', 'yes'), array('Les bruits du coeur sont vérifiés', 'normal', 'yes'), array('La documentation clinique et para clinique nécessaire est disponible en salle:' . 'Bilan sanguin, carte de groupe, ACI', 'normal', 'yes'))), '03' => array('avant_indu_cesar', null, array(array('Le pédiatre est prévenu', 'notapplicable', 'yes'))), '04' => array('avant_indu_cesar', null, array(array('La préparation cutanée de la patiente est documentée dans la fiche de liaison service / bloc opératoire (ou autre ' . 'procédure en oeuvre dans l\'établissement)', 'notapplicable', 'yes'))), '05' => array('avant_indu_cesar', 'L\'équipe / matériel nécessaire pour l\'intervention est vérifié et fonctionnel:', array(array('Pour la partie obstétricale', 'normal', 'yes'), array('Pour la partie anesthésique (mère)', 'normal', 'yes'), array('Pour la partie réanimation (nouveau né)', 'normal', 'yes'))), '06' => array('avant_indu_cesar', 'Vérification croisée par l\'équipe de points critiques et mise en oeuvre des mesures adéquats' . '. La patiente présente-t-elle un?', array(array('risque alergique', 'normal', 'no'), array('de la difficulté d\'intubation ou de ventilation au masque', 'normal', 'no'), array('risque de saignement supérieur à 1000ml', 'normal', 'no'), array('L\'administration d\'antiacide  a été effectuée', 'normal', 'yes'))), '07' => array('cesarienne_avant', 'Vérification "ultime" croisée au sein de l\'équipe', array(array('identité patiente confirmée', 'normal', 'yes'), array('installation correcte confirmée', 'normal', 'yes'), array('sondage urinaire efficace', 'normal', 'yes'), array('compte initial de textiles et d\'instruments confirmé', 'normal', 'yes'), array('electrode de scalp otée', 'notapplicable', 'yes'))), '08' => array('cesarienne_avant', null, array(array('Présence du pédiatre', 'notapplicable', 'yes'))), '09' => array('cesarienne_avant', 'Partage des informations essentielles oralement au sein de l\'équipe sur les éléments à' . ' risque / étapes critiques de l\'intervention', array(array('sur le plan obtétrical (temps opératoire difficile, localisation du placenta, points spécifiques de l\'intervention' . ', prélèvements cordon placenta, identification des matériels nécessaires, confirmation de leur opérationnalité, etc.)', 'normal', 'yes'), array('sur le plan anesthésique (risque potentiels liés au terrain ou à des traitements éventuellement maintenus, etc.)', 'normal', 'yes'))), '10' => array('cesarienne_avant', null, array(array('La préparation du champ opératoire est réalisée selon le protocole en vigeur dans l\'établissement', 'normal', 'yes'))), '11' => array('cesarienne_apres', 'Confirmation orale par le personnel auprès de l\'équipe', array(array('du compte final concordant des textiles, aiguilles, instruments, etc.', 'normal', 'yes'), array('de l\'enregistrement des pertes sanguines totales', 'normal', 'yes'), array('si des évènements indésirables ou porteurs de risques médicaux sont survenus: ont-ils fait l\'objet d\'un ' . 'signalement / déclaration', 'notapplicable', 'yes'))), '12' => array('cesarienne_apres', null, array(array('L\'antibioprophylaxie a été effectuée selon les recommandations et protocoles en vigueur dans l\'établissement', 'normal', 'yes'), array('Les prescriptions pour les suites opératoires immédiates sont faites de manière conjointe entre les équipes ' . 'obstétricale et anesthésiste', 'normal', 'yes'))), '13' => array('cesarienne_apres', null, array(array('Le ou les nouveaux nés sont identifiés selon les protocoles en vigueur dans l\'établissement', 'normal', 'yes'))));
     $this->addNewCheckList($check_list);
     $this->makeRevision("0.57");
     $query = "UPDATE `daily_check_item_type` SET `title` = 'Identité de la patiente est correcte'\r\n            WHERE `title` = 'Identité de la patiente est correct'";
     $this->addQuery($query);
     $query = "UPDATE `daily_check_item_type` SET `title` = 'un risque alergique'\r\n            WHERE `title` = 'risque alergique'";
     $this->addQuery($query);
     $query = "UPDATE `daily_check_item_type` SET `title` = 'un risque de saignement supérieur à 1000ml'\r\n            WHERE `title` = 'risque de saignement supérieur à 1000ml'";
     $this->addQuery($query);
     $query = "UPDATE `daily_check_item_type` SET `title` = 'électrode de scalp ôtée'\r\n            WHERE `title` = 'electrode de scalp otée'";
     $this->addQuery($query);
     $query = "UPDATE `daily_check_item_category`\r\n      SET `desc` = 'Vérification croisée par l''équipe de points critiques et mise en oeuvre des mesures adéquates. La patiente présente-t-elle  ? '\r\n      WHERE `target_class` = 'COperation'\r\n      AND `type` = 'avant_indu_cesar'\r\n      AND `title` =  '06'";
     $this->addQuery($query);
     $this->makeRevision("0.58");
     $query = "ALTER TABLE `daily_check_item_category`\r\n                ADD `index` INT (11) UNSIGNED NOT NULL DEFAULT '1';";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_item_category`\r\n                ADD INDEX (`list_type_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.59");
     $query = "UPDATE `daily_check_item_type` SET `title` = 'un risque allergique'\r\n            WHERE `title` = 'un risque alergique'";
     $this->addQuery($query);
     $query = "UPDATE `daily_check_item_type`\r\n    SET `title` = 'sur le plan anesthésique (risques potentiels liés au terrain ou à des traitements éventuellement maintenus, etc.)'\r\n    WHERE `title` = 'sur le plan anesthésique (risque potentiels liés au terrain ou à des traitements éventuellement maintenus, etc.)'";
     $this->addQuery($query);
     $query = "UPDATE `daily_check_item_type`\r\n    SET `title` = 'La documentation clinique et para clinique nécessaire est disponible en salle: Bilan sanguin, carte de groupe, ACI'\r\n    WHERE `title` = 'La documentation clinique et para clinique nécessaire est disponible en salle:Bilan sanguin, carte de groupe, ACI'";
     $this->addQuery($query);
     $this->makeRevision("0.60");
     $this->addPrefQuery("autosigne_sortie", "1");
     $this->makeRevision('0.61');
     $query = "ALTER TABLE `acte_ccam`\r\n                ADD `gratuit` ENUM('0', '1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision('0.62');
     $category_type = "'preanesth','preop','postop'\r\n                ,'preendoscopie','postendoscopie'\r\n                ,'preendoscopie_bronchique','postendoscopie_bronchique'\r\n                ,'preanesth_radio','preop_radio','postop_radio'\r\n                ,'disp_vasc_avant','disp_vasc_pendant','disp_vasc_apres'\r\n                ,'avant_indu_cesar', 'cesarienne_avant', 'cesarienne_apres'\r\n                ,'preanesth_ch', 'preop_ch', 'postop_ch'";
     $query = "ALTER TABLE `daily_check_item_category`\r\n                CHANGE `type` `type` ENUM ({$category_type});";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_list`\r\n                CHANGE `type` `type` ENUM ({$category_type});";
     $this->addQuery($query);
     $check_list = array('01' => array('preanesth_ch', null, array(array('Dossiers cliniques et personnel du patient disponibles en salle', 'normal', 'yes'))), '02' => array('preanesth_ch', 'Identité', array(array('Patient confirme: nom, prénom, date de naissance', 'normal', 'yes'), array('Concordance avec bracelet d\'identité', 'normal', 'yes'), array('Concordance avec dossier', 'normal', 'yes'), array('Patient confirme le site', 'normal', 'yes'))), '03' => array('preanesth_ch', null, array(array('Site marqué', 'notapplicable', 'yes'))), '04' => array('preanesth_ch', 'Risques évalués', array(array('Allergie', 'normal', 'yes'), array('Broncho-aspiration (estomac plein, jeûne, patho gastro_oeso)', 'normal', 'yes'), array('Voies aériennes', 'normal', 'yes'), array('Saignement anticipé (>500 ml, 10 ml/kg en pédiatrie)', 'normal', 'yes'), array('Contamination (MRSA, TBC, hépatite, HIV, ...)', 'normal', 'yes'))), '05' => array('preanesth_ch', 'Vérifications', array(array('Mode d\'installation', 'normal', 'yes'), array('Matériel particulier pour l\'anesthésie', 'normal', 'yes'))), '06' => array('preanesth_ch', null, array(array('Confirmation matériel chirurgical avant induction', 'normal', 'yes'))), '07' => array('preop_ch', null, array(array('Vérification identité intervenants et visiteurs', 'normal', 'yes'))), '08' => array('preop_ch', 'Confirmation par le trinôme anesthésiste/chirurgien/instrumentiste sous la conduitre de l\'infirmière circulante', array(array('Identité patient', 'normal', 'yes'), array('Site opératoire', 'normal', 'yes'), array('Intervention', 'normal', 'yes'), array('Installation opératoire', 'normal', 'yes'), array('Matériel', 'normal', 'yes'), array('Etapes critiques', 'normal', 'yes'), array('Prophylaxie antibiotique si indiquée', 'normal', 'yes'))), '09' => array('postop_ch', 'Infirmière circulante confirme verbalement avec l\'équipe:', array(array('Nom de l\'acte chirurgical réalisé', 'normal', 'yes'), array('Compte de compresses / guersounis', 'normal', 'yes'))), '10' => array('postop_ch', 'Prélèvements', array(array('Etiquetage: concordance identité patient', 'normal', 'yes'), array('Milieu de conservation', 'normal', 'yes'), array('Laboratoire de destination', 'normal', 'yes'), array('Envoi de destination', 'notapplicable', 'yes'))), '11' => array('postop_ch', 'Debriefing chirurgien - anesthésiste', array(array('Revue des évènements critiques', 'normal', 'yes'))), '12' => array('postop_ch', 'Documents complétés', array(array('Feuille d\'ordre par anesthésiste', 'normal', 'yes'), array('Feuille d\'ordre par chirurgien', 'normal', 'yes'))));
     $this->addNewCheckList($check_list);
     $this->makeRevision('0.63');
     $this->addPrefQuery("default_salles_id", "{}");
     $this->makeRevision('0.64');
     $query = "ALTER TABLE `daily_check_list_type`\r\n                ADD `type` ENUM ('salle','op','preop') NOT NULL DEFAULT 'salle';";
     $this->addQuery($query);
     $query = "UPDATE `daily_check_list_type`\r\n                SET `type` = 'op'\r\n                WHERE `object_class` = 'CBlocOperatoire'";
     $this->addQuery($query);
     $this->makeRevision('0.65');
     $query = "ALTER TABLE `daily_check_list_type`\r\n                CHANGE `type` `type` ENUM ('ouverture_salle','ouverture_sspi','ouverture_preop') NOT NULL DEFAULT 'ouverture_salle';";
     $this->addQuery($query);
     $query = "UPDATE `daily_check_list_type`\r\n                SET `type` = 'ouverture_sspi'\r\n                WHERE `object_class` = 'CBlocOperatoire'";
     $this->addQuery($query);
     $query = "UPDATE `daily_check_list_type`\r\n                SET `type` = 'ouverture_salle'\r\n                WHERE `object_class` = 'CSalle'";
     $this->addQuery($query);
     $this->makeRevision('0.66');
     $query = "ALTER TABLE `daily_check_list_type`\r\n                CHANGE `type` `type` ENUM ('ouverture_salle','ouverture_sspi','ouverture_preop', 'fermeture_salle') NOT NULL DEFAULT 'ouverture_salle';";
     $this->addQuery($query);
     $this->makeRevision('0.67');
     $query = "ALTER TABLE `acte_ccam`\r\n                CHANGE `object_class` `object_class` ENUM('COperation','CSejour','CConsultation', 'CDevisCodage') NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision('0.68');
     $query = "ALTER TABLE `daily_check_list_type`\r\n                ADD `check_list_group_id` INT (11) UNSIGNED,\r\n                CHANGE `type` `type` ENUM ('ouverture_salle','ouverture_sspi','ouverture_preop','fermeture_salle','intervention') NOT NULL DEFAULT 'ouverture_salle';";
     $this->addQuery($query);
     $query = "CREATE TABLE `daily_check_list_group` (\r\n                `check_list_group_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `group_id` INT (11) UNSIGNED NOT NULL,\r\n                `title` VARCHAR (255) NOT NULL,\r\n                `description` TEXT,\r\n                `actif` ENUM ('0','1') DEFAULT '1'\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_list_group`\r\n                ADD INDEX (`group_id`);";
     $this->addQuery($query);
     $this->makeRevision('0.69');
     $query = "ALTER TABLE `daily_check_list_type`\r\n                CHANGE `type` `type` ENUM ('ouverture_salle','ouverture_sspi','ouverture_preop','fermeture_salle','intervention','fermeture_sspi','fermeture_preop') NOT NULL DEFAULT 'ouverture_salle';";
     $this->addQuery($query);
     $this->makeRevision('0.70');
     $this->addDefaultConfig("dPsalleOp CDailyCheckList active_salle_reveil", "dPsalleOp CDailyCheckList active_salle_reveil");
     $this->addDefaultConfig("dPsalleOp CDailyCheckList active", "dPsalleOp CDailyCheckList active");
     $this->addDefaultConfig("dPsalleOp Default_good_answer default_good_answer_COperation", "dPsalleOp CDailyCheckList default_good_answer_COperation");
     $this->addDefaultConfig("dPsalleOp Default_good_answer default_good_answer_CBlocOperatoire", "dPsalleOp CDailyCheckList default_good_answer_CBlocOperatoire");
     $this->addDefaultConfig("dPsalleOp Default_good_answer default_good_answer_CSalle", "dPsalleOp CDailyCheckList default_good_answer_CSalle");
     $this->addDefaultConfig("dPsalleOp Default_good_answer default_good_answer_CPoseDispositifVasculaire", "dPsalleOp CDailyCheckList default_good_answer_CPoseDispositifVasculaire");
     $this->makeRevision('0.71');
     $query = "ALTER TABLE `daily_check_list`\r\n                ADD `date_validate` DATETIME;";
     $this->addQuery($query);
     $query = "ALTER TABLE `daily_check_list`\r\n                ADD INDEX (`date_validate`);";
     $this->addQuery($query);
     $this->mod_version = '0.72';
 }
Ejemplo n.º 27
0
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "hprimxml";
     $this->makeRevision("all");
     $this->makeRevision("0.10");
     $query = "CREATE TABLE `destinataire_hprim` (\r\n              `dest_hprim_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n              `nom` VARCHAR (255) NOT NULL,\r\n              `type` ENUM ('cip','sip') NOT NULL DEFAULT 'cip',\r\n              `url` TEXT NOT NULL,\r\n              `username` VARCHAR (255) NOT NULL,\r\n              `password` VARCHAR (50) NOT NULL,\r\n              `actif` ENUM ('0','1') NOT NULL DEFAULT '0',\r\n              `group_id` INT (11) UNSIGNED NOT NULL\r\n            ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `destinataire_hprim`\r\n            ADD INDEX (`group_id`);";
     $this->addQuery($query);
     $query = "CREATE TABLE `echange_hprim` (\r\n              `echange_hprim_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n              `date_production` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',\r\n              `emetteur` VARCHAR (255),\r\n              `identifiant_emetteur` VARCHAR (255),\r\n              `destinataire` VARCHAR (255) NOT NULL,\r\n              `type` VARCHAR (255),\r\n              `sous_type` VARCHAR (255),\r\n              `date_echange` DATETIME,\r\n              `message` MEDIUMTEXT NOT NULL,\r\n              `acquittement` MEDIUMTEXT,\r\n              `initiateur_id` INT (11) UNSIGNED,\r\n              `statut_acquittement` VARCHAR (255),\r\n              `message_valide` ENUM ('0','1'),\r\n              `acquittement_valide` ENUM ('0','1'),\r\n              `group_id` INT (11) UNSIGNED NOT NULL,\r\n              `id_permanent` VARCHAR (25),\r\n              `object_id` INT (11) UNSIGNED DEFAULT NULL,\r\n              `object_class` VARCHAR (255) DEFAULT NULL,\r\n              `compressed` ENUM ('0','1') DEFAULT '0'\r\n            ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `echange_hprim`\r\n              ADD INDEX (`date_production`),\r\n              ADD INDEX (`date_echange`),\r\n              ADD INDEX (`initiateur_id`),\r\n              ADD INDEX (`group_id`),\r\n              ADD INDEX (`object_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.11");
     $query = "ALTER TABLE `destinataire_hprim`\r\n              ADD `evenement` ENUM ('pmsi','patients','stock') DEFAULT 'patients';";
     $this->addQuery($query);
     $this->makeRevision("0.12");
     $query = "ALTER TABLE `echange_hprim`\r\n            ADD INDEX (`emetteur`),\r\n            ADD INDEX (`identifiant_emetteur`),\r\n            ADD INDEX (`destinataire`),\r\n            ADD INDEX (`type`),\r\n            ADD INDEX (`sous_type`),\r\n            ADD INDEX (`statut_acquittement`),\r\n            ADD INDEX (`message_valide`),\r\n            ADD INDEX (`acquittement_valide`),\r\n            ADD INDEX (`id_permanent`),\r\n            ADD INDEX (`object_class`);";
     $this->addQuery($query);
     $this->makeRevision("0.13");
     $query = "ALTER TABLE `destinataire_hprim`\r\n              CHANGE `evenement` `message` ENUM ('pmsi','patients','stock') DEFAULT 'patients';";
     $this->addQuery($query);
     $this->makeRevision("0.14");
     $this->setTimeLimit(3600);
     $query = "UPDATE `echange_hprim`\r\n            SET `compressed` = '0' WHERE `compressed` = '1';";
     $this->addQuery($query);
     $query = "ALTER TABLE `echange_hprim`\r\n              CHANGE `compressed` `purge` ENUM ('0','1') DEFAULT '0',\r\n              CHANGE `message` `message` MEDIUMTEXT;";
     $this->addQuery($query);
     $this->makeRevision("0.15");
     $this->setTimeLimit(3600);
     $query = "INSERT INTO content_xml (`content`, `import_id`)\r\n              SELECT `message`, `echange_hprim_id` FROM `echange_hprim`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `echange_hprim`\r\n              DROP `message`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `echange_hprim`\r\n              ADD `message_content_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "ALTER TABLE `echange_hprim`\r\n              ADD INDEX (`message_content_id`);";
     $this->addQuery($query);
     $query = "UPDATE echange_hprim e\r\n              JOIN content_xml cx ON e.echange_hprim_id = cx.import_id\r\n              SET  e.message_content_id = cx.content_id;";
     $this->addQuery($query);
     $query = "UPDATE content_xml\r\n              SET import_id = NULL;";
     $this->addQuery($query);
     $query = "INSERT INTO content_xml (`content`, `import_id`)\r\n              SELECT `acquittement`, `echange_hprim_id` FROM `echange_hprim`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `echange_hprim`\r\n              DROP `acquittement`,\r\n              DROP `purge`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `echange_hprim`\r\n              ADD `acquittement_content_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $query = "ALTER TABLE `echange_hprim`\r\n              ADD INDEX (`acquittement_content_id`);";
     $this->addQuery($query);
     $query = "UPDATE echange_hprim e\r\n              JOIN content_xml cx ON e.echange_hprim_id = cx.import_id\r\n              SET  e.acquittement_content_id = cx.content_id\r\n              WHERE import_id IS NOT NULL;";
     $this->addQuery($query);
     $query = "UPDATE content_xml\r\n              SET import_id = NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.16");
     $query = "CREATE TABLE `destinataire_hprim_config` (\r\n              `dest_hprim_config_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n              `object_id` INT (11) UNSIGNED,\r\n              `send_sortie_prevue` ENUM ('0','1') DEFAULT '1',\r\n              `type_sej_hospi` VARCHAR (255),\r\n              `type_sej_ambu` VARCHAR (255),\r\n              `type_sej_urg` VARCHAR (255),\r\n              `type_sej_scanner` VARCHAR (255),\r\n              `type_sej_chimio` VARCHAR (255),\r\n              `type_sej_dialyse` VARCHAR (255)\r\n          ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `destinataire_hprim_config`\r\n             ADD INDEX (`object_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.17");
     $query = "ALTER TABLE `destinataire_hprim`\r\n             DROP `url`,\r\n             DROP `username`,\r\n             DROP `password`;";
     $this->addQuery($query);
     $this->makeRevision("0.18");
     $query = "ALTER TABLE `echange_hprim`\r\n             ADD `emetteur_id` INT (11) UNSIGNED AFTER `emetteur`,\r\n             ADD `destinataire_id` INT (11) UNSIGNED AFTER `destinataire`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `echange_hprim`\r\n             ADD INDEX (`emetteur_id`),\r\n             ADD INDEX (`destinataire_id`);";
     $this->addQuery($query);
     $query = "UPDATE `echange_hprim`\r\n             SET `emetteur_id` = (SELECT `destinataire_hprim`.dest_hprim_id\r\n             FROM `destinataire_hprim`\r\n             WHERE `echange_hprim`.emetteur = `destinataire_hprim`.nom);";
     $this->addQuery($query);
     $query = "UPDATE `echange_hprim`\r\n             SET `emetteur_id` = NULL\r\n             WHERE `echange_hprim`.emetteur = '" . CAppUI::conf("mb_id") . "';";
     $this->addQuery($query);
     $query = "UPDATE `echange_hprim`\r\n             SET `destinataire_id` = (SELECT `destinataire_hprim`.dest_hprim_id\r\n             FROM `destinataire_hprim`\r\n             WHERE `echange_hprim`.destinataire = `destinataire_hprim`.nom);";
     $this->addQuery($query);
     $query = "UPDATE `echange_hprim`\r\n             SET `destinataire_id` = NULL\r\n             WHERE `echange_hprim`.destinataire = '" . CAppUI::conf("mb_id") . "';";
     $this->addQuery($query);
     $this->makeRevision("0.19");
     $query = "ALTER TABLE `destinataire_hprim`\r\n             ADD `libelle` VARCHAR (255) AFTER `nom`;";
     $this->addQuery($query);
     $this->makeRevision("0.20");
     $query = "ALTER TABLE `destinataire_hprim_config`\r\n             ADD `receive_ack` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.21");
     $query = "ALTER TABLE `destinataire_hprim_config`\r\n             ADD `send_all_patients` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $query = "ALTER TABLE `destinataire_hprim`\r\n             ADD `register` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.22");
     $query = "ALTER TABLE `destinataire_hprim_config`\r\n              CHANGE `send_all_patients` `send_all_patients` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.23");
     $query = "ALTER TABLE `destinataire_hprim_config`\r\n              ADD `send_debiteurs_venue` ENUM ('0','1') DEFAULT '1',\r\n              ADD `send_mvt_patients` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.24");
     $query = "ALTER TABLE `echange_hprim`\r\n              CHANGE `object_class` `object_class` ENUM ('CPatient','CSejour','COperation','CAffectation');";
     $this->makeRevision("0.25");
     $query = "ALTER TABLE `destinataire_hprim_config`\r\n              ADD `send_default_serv_with_type_sej` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.26");
     $query = "ALTER TABLE `destinataire_hprim`\r\n             ADD `code_appli` VARCHAR (255),\r\n             ADD `code_acteur` VARCHAR (255),\r\n             ADD `code_syst` VARCHAR (255);";
     $this->addQuery($query);
     $this->makeRevision("0.27");
     $query = "ALTER TABLE `destinataire_hprim_config`\r\n              ADD `type_sej_pa` VARCHAR (255),\r\n              ADD `use_sortie_matching` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.28");
     $query = "ALTER TABLE `destinataire_hprim_config`\r\n              ADD `fully_qualified` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.29");
     $query = "UPDATE `echange_soap`\r\n              SET `type` = 'CDestinataireHprim'\r\n              WHERE `type` = 'hprimxml';";
     $this->addQuery($query, true);
     $query = "UPDATE `source_soap`\r\n              SET `type_echange` = 'CDestinataireHprim'\r\n              WHERE `type_echange` = 'hprimxml';";
     $this->addQuery($query, true);
     $this->makeRevision("0.30");
     $query = "ALTER TABLE `destinataire_hprim_config`\r\n              ADD `type_sej_exte` VARCHAR (255);";
     $this->addQuery($query);
     $this->makeRevision("0.31");
     $query = "ALTER TABLE `echange_hprim`\r\n              DROP `emetteur`,\r\n              DROP `destinataire`,\r\n              DROP INDEX `message_content_id`,\r\n              DROP INDEX `acquittement_content_id`;";
     $this->addQuery($query);
     $this->makeRevision("0.32");
     $query = "ALTER TABLE `echange_hprim`\r\n                CHANGE `destinataire_id` `receiver_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $this->makeRevision("0.33");
     $query = "ALTER TABLE `echange_hprim`\r\n                ADD `sender_id` INT (11) UNSIGNED AFTER `emetteur_id`,\r\n                ADD `sender_class` ENUM ('CSenderFTP','CSenderSOAP') AFTER `sender_id`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `echange_hprim`\r\n                ADD INDEX (`sender_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.34");
     $query = "CREATE TABLE `hprimxml_config` (\r\n                `hprimxml_config_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `sender_id` INT (11) UNSIGNED,\r\n                `sender_class` ENUM ('CSenderFTP','CSenderSOAP'),\r\n                `type_sej_hospi` VARCHAR (255),\r\n                `type_sej_ambu` VARCHAR (255),\r\n                `type_sej_urg` VARCHAR (255),\r\n                `type_sej_exte` VARCHAR (255),\r\n                `type_sej_scanner` VARCHAR (255),\r\n                `type_sej_chimio` VARCHAR (255),\r\n                `type_sej_dialyse` VARCHAR (255),\r\n                `type_sej_pa` VARCHAR (255),\r\n                `use_sortie_matching` ENUM ('0','1') DEFAULT '1',\r\n                `fully_qualified` ENUM ('0','1') DEFAULT '1'\r\n              ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `hprimxml_config`\r\n              ADD INDEX (`sender_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.35");
     $query = "ALTER TABLE `echange_hprim`\r\n                ADD INDEX (`message_content_id`),\r\n                ADD INDEX (`acquittement_content_id`),\r\n                DROP INDEX `emetteur_id`;";
     $this->addQuery($query);
     $this->makeRevision("0.36");
     $query = "ALTER TABLE `destinataire_hprim_config`\r\n              ADD `uppercase_fields` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.37");
     $query = "ALTER TABLE `echange_hprim`\r\n                CHANGE `sender_class` `sender_class` ENUM ('CSenderFTP','CSenderSOAP','CSenderMLLP');";
     $this->addQuery($query);
     $this->makeRevision("0.38");
     $query = "ALTER TABLE `echange_hprim`\r\n                CHANGE `sender_class` `sender_class` ENUM ('CSenderFTP','CSenderSOAP');";
     $this->addQuery($query);
     $this->makeRevision("0.39");
     $query = "ALTER TABLE `echange_hprim`\r\n                CHANGE `sender_class` `sender_class` VARCHAR (80);";
     $this->addQuery($query);
     $this->makeRevision("0.40");
     $query = "ALTER TABLE `destinataire_hprim_config`\r\n                ADD `encoding` ENUM ('UTF-8','ISO-8859-1') DEFAULT 'UTF-8';";
     $this->addQuery($query);
     $query = "ALTER TABLE `destinataire_hprim_config`\r\n                DROP `send_debiteurs_venue`,\r\n                DROP `send_mvt_patients`";
     $this->addQuery($query);
     $this->makeRevision("0.41");
     $query = "ALTER TABLE `hprimxml_config`\r\n                ADD `encoding` ENUM ('UTF-8','ISO-8859-1') DEFAULT 'UTF-8';";
     $this->addQuery($query);
     $this->makeRevision("0.42");
     $query = "ALTER TABLE `hprimxml_config`\r\n                CHANGE `sender_class` `sender_class` VARCHAR (80);";
     $this->addQuery($query);
     $this->makeRevision("0.43");
     $query = "ALTER TABLE `hprimxml_config`\r\n                ADD `repair_patient` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.44");
     $query = "ALTER TABLE `hprimxml_config`\r\n                ADD `purge_idex_movements` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.45");
     $query = "ALTER TABLE `echange_hprim`\r\n                ADD `reprocess` TINYINT (4) UNSIGNED DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.46");
     $query = "ALTER TABLE `destinataire_hprim_config`\r\n                ADD `send_volet_medical` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.47");
     $query = "ALTER TABLE `destinataire_hprim_config`\r\n                ADD `send_movement_location` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.48");
     $query = "ALTER TABLE `destinataire_hprim`\r\n                ADD `OID` VARCHAR (255);";
     $this->addQuery($query);
     $this->makeRevision("0.49");
     $query = "ALTER TABLE `destinataire_hprim`\r\n                ADD `display_errors` ENUM ('0','1') NOT NULL DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.50");
     $query = "ALTER TABLE `hprimxml_config`\r\n                ADD `display_errors` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.51");
     $query = "ALTER TABLE `destinataire_hprim_config`\r\n                ADD `check_similar` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.52");
     $query = "ALTER TABLE `destinataire_hprim`\r\n                ADD `synchronous` ENUM ('0','1') NOT NULL DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.53");
     $query = "ALTER TABLE `hprimxml_config`\r\n                ADD `check_similar` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.54");
     $query = "ALTER TABLE `hprimxml_config`\r\n                ADD `att_system` ENUM ('acteur','application','système','finessgeographique','finessjuridique') DEFAULT 'système';";
     $this->addQuery($query);
     $this->makeRevision("0.55");
     $query = "ALTER TABLE `hprimxml_config`\r\n                ADD `insc_integrated` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.56");
     $query = "ALTER TABLE `destinataire_hprim`\r\n                ADD `monitor_sources` ENUM ('0','1') NOT NULL DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.57");
     $query = "ALTER TABLE `destinataire_hprim_config`\r\n                ADD `send_insured_without_admit` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.58");
     $query = "ALTER TABLE `echange_hprim`\r\n                ADD `master_idex_missing` ENUM ('0','1') DEFAULT '0',\r\n                ADD INDEX (`master_idex_missing`);";
     $this->addQuery($query);
     $this->mod_version = "0.59";
 }
Ejemplo n.º 28
0
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "dPlabo";
     $this->makeRevision("all");
     $query = "CREATE TABLE `catalogue_labo` (" . "\n`catalogue_labo_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ," . "\n`pere_id` INT(11) UNSIGNED DEFAULT NULL ," . "\n`identifiant` VARCHAR(255) NOT NULL ," . "\n`libelle` VARCHAR(255) NOT NULL," . "\nPRIMARY KEY (`catalogue_labo_id`) ," . "\nINDEX ( `pere_id` )) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "CREATE TABLE `examen_labo` (" . "\n`examen_labo_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ," . "\n`catalogue_labo_id` INT(11) UNSIGNED NOT NULL DEFAULT 0 ," . "\n`identifiant` VARCHAR(255) NOT NULL ," . "\n`libelle` VARCHAR(255) NOT NULL," . "\n`type` ENUM('bool','num','str') NOT NULL DEFAULT 'num' ," . "\n`unite` VARCHAR(255) DEFAULT NULL," . "\n`min` FLOAT DEFAULT NULL," . "\n`max` FLOAT DEFAULT NULL," . "\nPRIMARY KEY ( `examen_labo_id` ) ," . "\nINDEX ( `catalogue_labo_id` )) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("0.1");
     $query = "CREATE TABLE `pack_examens_labo` (" . "\n`pack_examens_labo_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ," . "\n`function_id` INT(11) UNSIGNED DEFAULT NULL ," . "\n`libelle` VARCHAR(255) NOT NULL," . "\nPRIMARY KEY ( `pack_examens_labo_id` ) ," . "\nINDEX ( `function_id` )) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "CREATE TABLE `pack_item_examen_labo` (" . "\n`pack_item_examen_labo_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ," . "\n`catalogue_labo_id` INT(11) UNSIGNED NOT NULL DEFAULT 0 ," . "\n`pack_examens_labo_id` INT(11) UNSIGNED NOT NULL DEFAULT 0 ," . "\n`examen_labo_id` INT(11) UNSIGNED NOT NULL DEFAULT 0 ," . "\nPRIMARY KEY ( `pack_item_examen_labo_id` ) ," . "\nINDEX ( `pack_examens_labo_id` ) ," . "\nINDEX ( `examen_labo_id` )" . ") /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("0.11");
     $query = "ALTER TABLE `pack_item_examen_labo` DROP `catalogue_labo_id`";
     $this->addQuery($query);
     $query = "CREATE TABLE `prescription_labo` (" . "\n`prescription_labo_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ," . "\n`consultation_id` INT(11) UNSIGNED DEFAULT NULL ," . "\nPRIMARY KEY ( `prescription_labo_id` ) ," . "\nINDEX ( `consultation_id` )) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "CREATE TABLE `prescription_labo_examen` (" . "\n`prescription_labo_examen_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ," . "\n`prescription_labo_id` INT(11) UNSIGNED NOT NULL DEFAULT 0 ," . "\n`examen_labo_id` INT(11) UNSIGNED NOT NULL DEFAULT 0 ," . "\nPRIMARY KEY ( `prescription_labo_examen_id` ) ," . "\nINDEX ( `prescription_labo_id` ) ," . "\nINDEX ( `examen_labo_id` )" . ") /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $this->makeRevision("0.12");
     $this->addDependency("dPpatients", "0.1");
     $query = "ALTER TABLE `prescription_labo`" . "\nCHANGE `consultation_id` `patient_id` INT( 11 ) UNSIGNED NOT NULL DEFAULT 0;";
     $this->addQuery($query);
     $query = "ALTER TABLE `prescription_labo`" . "\nADD `praticien_id` INT( 11 ) UNSIGNED NOT NULL DEFAULT 0 AFTER `patient_id`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `prescription_labo`" . "\nADD `date` DATETIME DEFAULT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.13");
     $query = "ALTER TABLE `prescription_labo_examen`" . "\nADD `resultat` VARCHAR( 255 ) DEFAULT NULL," . "\nADD `date` DATETIME DEFAULT NULL," . "\nADD `commentaire` TEXT DEFAULT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.14");
     $query = "ALTER TABLE `prescription_labo_examen`" . "\nCHANGE `date` `date` DATE DEFAULT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.15");
     $query = "ALTER TABLE `examen_labo`" . "\nADD `deb_application` DATE," . "\nADD `fin_application` DATE," . "\nADD `realisateur` INT(11) UNSIGNED," . "\nADD `applicabilite` ENUM('homme','femme','unisexe')," . "\nADD `age_min` INT(11) UNSIGNED," . "\nADD `age_max` INT(11) UNSIGNED," . "\nADD `technique` TEXT," . "\nADD `materiel` TEXT," . "\nADD `type_prelevement` VARCHAR(255)," . "\nADD `methode_prelevement` TEXT," . "\nADD `conservation` TEXT," . "\nADD `temps_conservation` INT(11) UNSIGNED," . "\nADD `quantité` INT(11) UNSIGNED," . "\nADD `jour_execution` VARCHAR(255)," . "\nADD `duree_execution` INT(11) UNSIGNED," . "\nADD `remarques` TEXT;";
     $this->addQuery($query);
     $this->makeRevision("0.16");
     $query = "ALTER TABLE `examen_labo`" . "\nCHANGE `quantité` `quantite` INT(11) UNSIGNED;";
     $this->addQuery($query);
     $this->makeRevision("0.17");
     $query = "ALTER TABLE `examen_labo`" . "\nCHANGE `type_prelevement` `type_prelevement` ENUM('sang','urine','biopsie');";
     $this->addQuery($query);
     $this->makeRevision("0.18");
     $query = "ALTER TABLE `examen_labo`" . "\nADD `execution_lun` ENUM('0','1')," . "\nADD `execution_mar` ENUM('0','1')," . "\nADD `execution_mer` ENUM('0','1')," . "\nADD `execution_jeu` ENUM('0','1')," . "\nADD `execution_ven` ENUM('0','1')," . "\nADD `execution_sam` ENUM('0','1')," . "\nADD `execution_dim` ENUM('0','1')," . "\nDROP `jour_execution`;";
     $this->addQuery($query);
     $this->makeRevision("0.19");
     $query = "ALTER TABLE `examen_labo`" . "\nCHANGE `quantite` `quantite_prelevement` FLOAT," . "\nADD `unite_prelevement` VARCHAR(255);";
     $this->addQuery($query);
     $this->makeRevision("0.20");
     $query = "ALTER TABLE `prescription_labo`\r\n            ADD `verouillee` ENUM('0','1');";
     $this->addQuery($query);
     $this->makeRevision("0.21");
     $query = "ALTER TABLE `prescription_labo`\r\n            ADD `validee` ENUM('0','1');";
     $this->addQuery($query);
     $this->makeRevision("0.22");
     $query = "ALTER TABLE `pack_item_examen_labo` ADD UNIQUE (" . "\n`pack_examens_labo_id` ," . "\n`examen_labo_id`);";
     $this->addQuery($query);
     $query = "ALTER TABLE `prescription_labo_examen` ADD UNIQUE (" . "\n`prescription_labo_id` ," . "\n`examen_labo_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.23");
     $query = "ALTER TABLE `prescription_labo`\r\n            ADD `urgence` ENUM('0','1');";
     $this->addQuery($query);
     $this->makeRevision("0.24");
     $query = "ALTER TABLE `pack_examens_labo`\r\n            ADD `code` INT(11);";
     $this->addQuery($query);
     $this->makeRevision("0.25");
     $query = "ALTER TABLE `prescription_labo_examen`\r\n            ADD `pack_examens_labo_id` INT(11) UNSIGNED;";
     $this->addQuery($query);
     $this->makeRevision("0.26");
     $query = "ALTER TABLE `catalogue_labo`\r\n            ADD `function_id` INT(11) UNSIGNED;";
     $this->addQuery($query);
     $this->makeRevision("0.27");
     $query = "ALTER TABLE `examen_labo`\r\n            ADD `obsolete` ENUM('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $query = "ALTER TABLE `catalogue_labo`\r\n            CHANGE `identifiant` `identifiant` VARCHAR(10) NOT NULL, \r\n            ADD `obsolete` ENUM('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $query = "ALTER TABLE `pack_examens_labo`  \r\n            ADD `obsolete` ENUM('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.28");
     $query = "ALTER TABLE `catalogue_labo` \r\n              ADD INDEX (`function_id`);";
     $this->addQuery($query);
     $query = "ALTER TABLE `examen_labo` \r\n              ADD INDEX (`deb_application`),\r\n              ADD INDEX (`fin_application`),\r\n              ADD INDEX (`realisateur`);";
     $this->addQuery($query);
     $query = "ALTER TABLE `prescription_labo` \r\n              ADD INDEX (`date`),\r\n              ADD INDEX (`praticien_id`);";
     $this->addQuery($query);
     $query = "ALTER TABLE `prescription_labo_examen` \r\n              ADD INDEX (`pack_examens_labo_id`),\r\n              ADD INDEX (`date`);";
     $this->addQuery($query);
     $this->mod_version = "0.29";
 }
Ejemplo n.º 29
0
 /**
  * Tells if we are still in the old preferences system
  *
  * @param bool $core_upgrade True if core upgrading (after initial install)
  *
  * @return bool
  */
 static function isOldPrefSystem($core_upgrade = false)
 {
     if (self::$_old_pref_system === null || $core_upgrade) {
         $ds = CSQLDataSource::get("std");
         self::$_old_pref_system = $ds->loadField("user_preferences", "pref_name") != null;
     }
     return self::$_old_pref_system;
 }
Ejemplo n.º 30
0
 function __construct()
 {
     parent::__construct();
     $this->mod_name = "dPbloc";
     $this->makeRevision("all");
     $query = "CREATE TABLE plagesop (\r\n                id bigint(20) NOT NULL auto_increment,\r\n                id_chir varchar(20) NOT NULL default '0',\r\n                id_anesth varchar(20) default NULL,\r\n                id_spec tinyint(4) default NULL,\r\n                id_salle tinyint(4) NOT NULL default '0',\r\n                date date NOT NULL default '0000-00-00',\r\n                debut time NOT NULL default '00:00:00',\r\n                fin time NOT NULL default '00:00:00',\r\n                PRIMARY KEY  (id)\r\n              ) /*! ENGINE=MyISAM */ COMMENT='Table des plages d opération';";
     $this->addQuery($query);
     $query = "CREATE TABLE sallesbloc (\r\n                id tinyint(4) NOT NULL auto_increment,\r\n                nom varchar(50) NOT NULL default '',\r\n                PRIMARY KEY  (id)\r\n              ) /*! ENGINE=MyISAM */ COMMENT='Table des salles d opération du bloc';";
     $this->addQuery($query);
     $this->makeRevision("0.1");
     $query = "ALTER TABLE `plagesop`\r\n                ADD INDEX ( `id_chir` ),\r\n                ADD INDEX ( `id_anesth` ),\r\n                ADD INDEX ( `id_spec` ),\r\n                ADD INDEX ( `id_salle` ),\r\n                ADD INDEX ( `date` )";
     $this->addQuery($query);
     $this->makeRevision("0.11");
     $query = "ALTER TABLE `plagesop`\r\n                ADD `chir_id` BIGINT DEFAULT '0' NOT NULL AFTER `id`,\r\n                ADD `anesth_id` BIGINT DEFAULT '0' NOT NULL AFTER `chir_id`,\r\n                ADD INDEX ( `chir_id` ),\r\n                ADD INDEX ( `anesth_id` );";
     $this->addQuery($query);
     $this->addMethod("swapPratIds");
     $this->makeRevision("0.12");
     $query = "ALTER TABLE `sallesbloc` ADD `stats` TINYINT DEFAULT '0' NOT NULL AFTER `nom` ;";
     $this->addQuery($query);
     $this->makeRevision("0.13");
     $this->addDependency("dPetablissement", "0.1");
     $query = "ALTER TABLE `sallesbloc` ADD `group_id` INT UNSIGNED NOT NULL DEFAULT 1 AFTER `id`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `sallesbloc` ADD INDEX ( `group_id` ) ;";
     $this->addQuery($query);
     $this->makeRevision("0.14");
     $query = "ALTER TABLE `plagesop` DROP `id_chir` ;";
     $this->addQuery($query);
     $query = "ALTER TABLE `plagesop` DROP `id_anesth` ;";
     $this->addQuery($query);
     $this->makeRevision("0.15");
     $query = "ALTER TABLE `plagesop` CHANGE `id` `plageop_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT ;";
     $this->addQuery($query);
     $query = "ALTER TABLE `sallesbloc` CHANGE `id` `salle_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT ;";
     $this->addQuery($query);
     $query = "ALTER TABLE `plagesop` CHANGE `id_spec` `spec_id` INT( 10 ) DEFAULT NULL ;";
     $this->addQuery($query);
     $query = "ALTER TABLE `plagesop` CHANGE `id_salle` `salle_id` INT( 10 ) DEFAULT '0' NOT NULL ;";
     $this->addQuery($query);
     $this->makeRevision("0.16");
     $query = "ALTER TABLE `plagesop` ADD `temps_inter_op` TIME NOT NULL DEFAULT '00:15:00' ;";
     $this->addQuery($query);
     $this->makeRevision("0.17");
     $query = "ALTER TABLE `plagesop`\r\n                CHANGE `plageop_id` `plageop_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n                CHANGE `chir_id` `chir_id` int(11) unsigned NOT NULL DEFAULT '0',\r\n                CHANGE `anesth_id` `anesth_id` int(11) unsigned NOT NULL DEFAULT '0',\r\n                CHANGE `spec_id` `spec_id` int(11) unsigned NULL,\r\n                CHANGE `salle_id` `salle_id` int(11) unsigned NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $query = "ALTER TABLE `sallesbloc`\r\n                CHANGE `salle_id` `salle_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n                CHANGE `group_id` `group_id` int(11) unsigned NOT NULL DEFAULT '1',\r\n                CHANGE `stats` `stats` enum('0','1') NOT NULL DEFAULT '0',\r\n                CHANGE `nom` `nom` varchar(255) NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.18");
     $query = "ALTER TABLE `plagesop` ADD INDEX ( `debut` )";
     $this->addQuery($query);
     $query = "ALTER TABLE `plagesop` ADD INDEX ( `fin` )";
     $this->addQuery($query);
     $this->makeRevision("0.19");
     $query = "ALTER TABLE `plagesop`\r\n                CHANGE `chir_id` `chir_id` int(11) unsigned NULL DEFAULT NULL,\r\n                CHANGE `anesth_id` `anesth_id` int(11) unsigned NULL DEFAULT NULL;";
     $this->addQuery($query);
     $query = "UPDATE `plagesop` SET `chir_id` = NULL WHERE `chir_id` = '0';";
     $this->addQuery($query);
     $query = "UPDATE `plagesop` SET `anesth_id` = NULL WHERE `anesth_id` = '0';";
     $this->addQuery($query);
     $query = "UPDATE `plagesop` SET `spec_id` = NULL WHERE `spec_id` = '0';";
     $this->addQuery($query);
     $this->makeRevision("0.20");
     $query = "ALTER TABLE `plagesop`\r\n            ADD `max_intervention` int(11) unsigned NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.21");
     $query = "ALTER TABLE `plagesop`\r\n            CHANGE `max_intervention` `max_intervention` INT(11);";
     $this->addQuery($query);
     $this->makeRevision("0.22");
     $query = "CREATE TABLE `bloc_operatoire` (\r\n            `bloc_operatoire_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n            `group_id` INT (11) UNSIGNED NOT NULL,\r\n            `nom` VARCHAR (255) NOT NULL) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `bloc_operatoire` ADD INDEX (`group_id`);";
     $this->addQuery($query);
     $query = "INSERT INTO `bloc_operatoire` (`nom`, `group_id`)\r\n            SELECT 'Bloc principal', `group_id`\r\n            FROM `groups_mediboard`";
     $this->addQuery($query);
     $query = "ALTER TABLE `sallesbloc` \r\n            CHANGE `group_id` `bloc_id` INT( 11 ) UNSIGNED NOT NULL";
     $this->addQuery($query);
     $query = "UPDATE `sallesbloc` \r\n            SET `bloc_id` = (\r\n              SELECT `bloc_operatoire_id` \r\n              FROM `bloc_operatoire` \r\n              WHERE `sallesbloc`.`bloc_id` = `bloc_operatoire`.`group_id`\r\n              LIMIT 1\r\n            );";
     $this->addQuery($query);
     $this->makeRevision("0.23");
     $query = "ALTER TABLE `plagesop` \r\n            ADD `spec_repl_id` INT (11) UNSIGNED,\r\n            ADD `delay_repl` INT (11);";
     $this->addQuery($query);
     $query = "ALTER TABLE `plagesop`\r\n            ADD INDEX (`spec_repl_id`),\r\n            ADD INDEX (`delay_repl`)";
     $this->addQuery($query);
     $this->makeRevision("0.24");
     $query = "ALTER TABLE `plagesop` \r\n            ADD `actes_locked` ENUM('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.25");
     $query = "ALTER TABLE `plagesop` ADD `unique_chir` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.26");
     $query = "ALTER TABLE `sallesbloc`\r\n              ADD `dh` ENUM ('0','1') NOT NULL DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.27");
     $query = "ALTER TABLE `bloc_operatoire`\r\n      ADD `days_locked` INT (11) UNSIGNED DEFAULT '0';";
     $this->addQuery($query);
     global $dPconfig;
     $days_locked = isset($dPconfig["dPbloc"]["CPlageOp"]["days_locked"]) ? CAppUI::conf("dPbloc CPlageOp days_locked") : 0;
     $query = "UPDATE `bloc_operatoire`\r\n     SET days_locked = '{$days_locked}'";
     $this->addQuery($query);
     $this->makeRevision("0.28");
     $query = "ALTER TABLE `plagesop` \r\n      ADD `verrouillage` ENUM ('defaut','non','oui') DEFAULT 'defaut' AFTER max_intervention;";
     $this->addQuery($query);
     $this->makeRevision("0.29");
     $this->addPrefQuery("suivisalleAutonome", 0);
     $this->makeRevision("0.30");
     $query = "CREATE TABLE `blocage` (\r\n      `blocage_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `salle_id` INT (11) UNSIGNED NOT NULL,\r\n      `libelle` VARCHAR (255),\r\n      `deb` DATE NOT NULL,\r\n      `fin` DATE NOT NULL\r\n      ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `blocage` \r\n      ADD INDEX (`salle_id`),\r\n      ADD INDEX (`deb`),\r\n      ADD INDEX (`fin`);";
     $this->addQuery($query);
     $this->makeRevision("0.31");
     $query = "CREATE TABLE `ressource_materielle` (\r\n      `ressource_materielle_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `type_ressource_id` INT (11) UNSIGNED NOT NULL,\r\n      `group_id` INT (11) UNSIGNED NOT NULL,\r\n      `libelle` VARCHAR (255) NOT NULL,\r\n      `deb_activite` DATE,\r\n      `fin_activite` DATE,\r\n      `retablissement` ENUM ('0','1') DEFAULT '0'\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `ressource_materielle`\r\n      ADD INDEX (`type_ressource_id`),\r\n      ADD INDEX (`group_id`),\r\n      ADD INDEX (`deb_activite`),\r\n      ADD INDEX (`fin_activite`),\r\n      ADD INDEX (`retablissement`);";
     $this->addQuery($query);
     $query = "CREATE TABLE `type_ressource` (\r\n      `type_ressource_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `group_id` INT (11) UNSIGNED NOT NULL,\r\n      `libelle` VARCHAR (255) NOT NULL,\r\n      `description` TEXT\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `type_ressource` \r\n      ADD INDEX (`group_id`);";
     $this->addQuery($query);
     $query = "CREATE TABLE `usage_ressource` (\r\n      `usage_ressource_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `ressource_materielle_id` INT (11) UNSIGNED NOT NULL,\r\n      `besoin_id` INT (11) UNSIGNED NOT NULL,\r\n      `commentaire` TEXT\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `usage_ressource` \r\n      ADD INDEX (`ressource_materielle_id`),\r\n      ADD INDEX (`besoin_id`);";
     $this->addQuery($query);
     $query = "CREATE TABLE `indispo_ressource` (\r\n      `indispo_ressource_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `ressource_materielle_id` INT (11) UNSIGNED NOT NULL,\r\n      `deb` DATE NOT NULL,\r\n      `fin` DATE NOT NULL,\r\n      `commentaire` TEXT\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "CREATE TABLE `besoin_ressource` (\r\n      `besoin_ressource_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `type_ressource_id` INT (11) UNSIGNED NOT NULL,\r\n      `protocole_id` INT (11) UNSIGNED NOT NULL,\r\n      `operation_id` INT (11) UNSIGNED NOT NULL,\r\n      `commentaire` TEXT\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `besoin_ressource` \r\n      ADD INDEX (`type_ressource_id`),\r\n      ADD INDEX (`protocole_id`),\r\n      ADD INDEX (`operation_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.32");
     $query = "ALTER TABLE `usage_ressource`\r\n      CHANGE `besoin_id` `besoin_ressource_id` INT (11) UNSIGNED NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.33");
     $query = "ALTER TABLE `ressource_materielle` \r\n      CHANGE `retablissement` `retablissement` TIME;";
     $this->addQuery($query);
     $this->makeRevision("0.34");
     $query = "UPDATE `ressource_materielle`\r\n      SET `retablissement` = '00:00:00'\r\n      WHERE `retablissement` IS NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.35");
     $query = "CREATE TABLE `poste_sspi` (\r\n      `poste_sspi_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n      `group_id` INT (11) UNSIGNED NOT NULL,\r\n      `nom` VARCHAR (255) NOT NULL\r\n    ) /*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `poste_sspi`\r\n      ADD INDEX (`group_id`);";
     $this->addQuery($query);
     $query = "ALTER TABLE `bloc_operatoire` \r\n      ADD `poste_sspi_id` INT (11) UNSIGNED AFTER `group_id`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `bloc_operatoire` \r\n      ADD INDEX (`poste_sspi_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.36");
     $query = "ALTER TABLE `bloc_operatoire`\r\n      DROP `poste_sspi_id`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `poste_sspi`\r\n                ADD `bloc_id` INT (11) UNSIGNED;";
     $this->addQuery($query);
     $this->makeRevision("0.37");
     $query = "ALTER TABLE `plagesop`\r\n                ADD `secondary_function_id` INT (11) UNSIGNED AFTER `chir_id`,\r\n                ADD INDEX (`secondary_function_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.38");
     $query = "ALTER TABLE `bloc_operatoire`\r\n                ADD `tel` VARCHAR (20),\r\n                ADD `fax` VARCHAR (20);";
     $this->addQuery($query);
     $this->makeRevision("0.39");
     $query = "ALTER TABLE `indispo_ressource`\r\n      CHANGE `deb` `deb` DATETIME NOT NULL,\r\n      CHANGE `fin` `fin` DATETIME NOT NULL;";
     $this->addQuery($query);
     $this->makeRevision("0.40");
     $query = "ALTER TABLE `bloc_operatoire`\r\n                ADD `type` ENUM ('chir','obst') NOT NULL DEFAULT 'chir' AFTER `nom`;";
     $this->addQuery($query);
     $this->makeEmptyRevision("0.41");
     $this->addPrefQuery("startAutoRefreshAtStartup", 0);
     $this->makeRevision("0.42");
     $query = "ALTER TABLE `bloc_operatoire`\r\n                ADD `cheklist_man` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.43");
     $query = "ALTER TABLE `bloc_operatoire`\r\n                DROP `cheklist_man`;";
     $this->addQuery($query);
     $query = "ALTER TABLE `sallesbloc`\r\n                ADD `cheklist_man` ENUM ('0','1') DEFAULT '0';";
     $this->addQuery($query);
     $this->makeRevision("0.44");
     $query = "ALTER TABLE `plagesop`\r\n      ADD `original_owner_id` INT (11) UNSIGNED AFTER `salle_id`,\r\n      ADD `original_function_id` INT (11) UNSIGNED AFTER `original_owner_id`,\r\n      ADD INDEX (`original_owner_id`),\r\n      ADD INDEX (`original_function_id`);";
     $this->addQuery($query);
     $this->makeRevision("0.45");
     $query = "ALTER TABLE `poste_sspi`\r\n                ADD `type` ENUM ('sspi','preop') DEFAULT 'sspi';";
     $this->addQuery($query);
     $this->makeRevision("0.46");
     $query = "UPDATE `plagesop`\r\n      SET `original_owner_id` = `chir_id`\r\n      WHERE `original_owner_id` IS NULL";
     $this->addQuery($query);
     $query = "UPDATE `plagesop`\r\n      SET `original_function_id` = `spec_id`\r\n      WHERE `original_function_id` IS NULL";
     $this->addQuery($query);
     $this->makeRevision("0.47");
     $query = "ALTER TABLE `bloc_operatoire`\r\n                ADD `use_brancardage` ENUM ('0','1') DEFAULT '1';";
     $this->addQuery($query);
     $this->makeRevision("0.48");
     $query = "\r\n    CREATE TABLE `salle_daily_occupation` (\r\n                `miner_id` INT (11) UNSIGNED NOT NULL auto_increment PRIMARY KEY,\r\n                `salle_id` INT (11) UNSIGNED NOT NULL DEFAULT '0',\r\n                `date` DATE NOT NULL,\r\n                `status` ENUM ('mined','remined','postmined'),\r\n                `cumulative_plages_planned` INT (11),\r\n                `nb_plages_planned` INT (11),\r\n                `nb_plages_planned_valid` INT (11),\r\n                `cumulative_real_interventions` INT (11),\r\n                `nb_real_interventions` INT (11),\r\n                `nb_real_intervention_valid` INT (11),\r\n                `cumulative_opened_patient` INT (11),\r\n                `nb_interventions_opened_patient` INT (11),\r\n                `nb_intervention_opened_patient_valid` INT (11),\r\n                `cumulative_plages_minus_interventions` INT (11),\r\n                `cumulative_interventions_minus_plages` INT (11)\r\n              )/*! ENGINE=MyISAM */;";
     $this->addQuery($query);
     $query = "ALTER TABLE `salle_daily_occupation`\r\n                ADD INDEX (`salle_id`),\r\n                ADD INDEX (`date`);";
     $this->addQuery($query);
     $this->makeRevision("0.49");
     $query = "ALTER TABLE `plagesop`\r\n                ADD `entree_chir` TIME,\r\n                ADD `entree_anesth` TIME;";
     $this->addQuery($query);
     $this->addFunctionalPermQuery("allowed_check_entry_bloc", "0");
     $this->mod_version = "0.50";
 }