Source for file update_T_DBMS_FORMRIGHTS.phpinc

Documentation is available at update_T_DBMS_FORMRIGHTS.phpinc

  1. <?php
  2.  
  3. /**
  4.   * upgrade table T_DBMS_FORMRIGHTS
  5.   *
  6.   * @project    Open CSP-Management
  7.   * @package    dbms
  8.   * @category   versioncheck
  9.   *
  10.   * @author     Peter Krebs <p.krebs@wpus.at>
  11.   * @copyright  (c) 2002-2005 by WURM & Parnter Unternehmensservice GmbH
  12.   * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
  13.   *
  14.   * @since pk-06-01-26
  15.   *
  16.   ***/
  17.  
  18.  
  19. $query="SELECT * FROM T_SYS_TABLES WHERE TBL_NAME ='T_DBMS_FORMRIGHTS' ORDER BY TBL_VERSION DESC";
  20. if (!$tblVer=$GLOBALS['USRDB']->quickQuery($query)) {
  21.     $tblVer=array();
  22.     $tblVer['TBL_NAME']="T_DBMS_FORMRIGHTS";
  23.     $tblVer['TBL_VERSION']=0;
  24.     $tblVer['TBL_SELECT']=0;
  25.     $tblVer['TBL_INSERT']=0;
  26.     $tblVer['TBL_UPDATE']=75;
  27.     $tblVer['TBL_DELETE']=100;
  28.     $tblVer['TBL_LASTCHANGE']=0;
  29. }
  30.  
  31. require_once $GLOBALS['PROJECT']['PHPINCPATH']."db/update/functions_mySQL.phpinc";
  32.  
  33. if (intval($tblVer['TBL_VERSION']) < 20) { 
  34.     DB_UPDATE_execCmd("ALTER TABLE T_DBMS_FORMRIGHTS ADD FRI_EXPORT TINYINT DEFAULT '0' NOT NULL AFTER FRI_DELETE");
  35.     $tblVer['TBL_VERSION']=20;
  36. }
  37.  
  38.  
  39. DB_UPDATE_setVersion($tblVer);
  40.  
  41. ?>

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