Source for file update_T_MOD_HOOKS.phpinc

Documentation is available at update_T_MOD_HOOKS.phpinc

  1. <?php
  2. /**
  3.   * T_MOD_HOOKS
  4.   *
  5.   * @project    Open CSP-Management
  6.   * @package    dbms
  7.   *
  8.   * @author     Peter Krebs <p.krebs@lvus.at>
  9.   * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
  10.   *
  11.   *
  12.   ***/
  13.  
  14. $query="SELECT * FROM T_SYS_TABLES WHERE TBL_NAME ='T_MOD_HOOKS' ORDER BY TBL_VERSION DESC";
  15. if (!$tblVer=$GLOBALS['USRDB']->quickQuery($query)) {
  16.     $tblVer=array();
  17.     $tblVer['TBL_NAME']="T_MOD_HOOKS";
  18.     $tblVer['TBL_VERSION']=0;
  19.     $tblVer['TBL_SELECT']=0;
  20.     $tblVer['TBL_INSERT']=75;
  21.     $tblVer['TBL_UPDATE']=75;
  22.     $tblVer['TBL_DELETE']=100;
  23.     $tblVer['TBL_LASTCHANGE']=0;
  24. }
  25.  
  26. require_once $GLOBALS['PROJECT']['PHPINCPATH']."db/update/functions_mySQL.phpinc";
  27. if ($tblVer['TBL_VERSION']<10) {
  28.     DB_UPDATE_execCmd("CREATE TABLE IF NOT EXISTS T_MOD_HOOKS (
  29.             HOO_ID              INT NOT NULL auto_increment,
  30.             MOD_ID                INT NOT NULL,
  31.             
  32.             HOO_SYSTEM            VARCHAR(128) NOT NULL,
  33.             HOO_PART            VARCHAR(128) NOT NULL,
  34.             HOO_CMD                VARCHAR(128) NOT NULL,
  35.             
  36.             HOO_CLASS            VARCHAR(128) NOT NULL,
  37.  
  38.             PRIMARY KEY (HOO_ID),
  39.             KEY (MOD_ID),
  40.             KEY (HOO_SYSTEM,HOO_PART,HOO_CMD)
  41.         ) TYPE=MyISAM;
  42.     ");
  43.     $tblVer['TBL_VERSION']=10;
  44. } else {
  45.     DB_UPDATE_backupTable("T_MOD_HOOKS");
  46. }
  47.  
  48. DB_UPDATE_setVersion($tblVer);
  49.  
  50. ?>

Documentation generated on Thu, 08 Jan 2009 17:49:09 +0100 by phpDocumentor 1.4.0a2