<?php
/* $Id: dbfm.install,v 1.1.2.24 2008/09/08 14:08:25 geoffeagles Exp $ */

/**
 * Implementation of hook_install().
 * note that I chose to make flang an int and all dates were made datetimes - rob's version is an int - people will
 * want to give their versions all sorts of names: draft0a etc. some use the publisher field for the author - I've 
 * chosen to make it a new field
 * removed newdesc, newname
 * language chaanged to int
 */
function dbfm_install(){
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {dbfm_file} (
        `fid` int(10) NOT NULL AUTO_INCREMENT,
        `uid` int(10) NOT NULL DEFAULT '0',
        `fpath` varchar(255) NOT NULL,
        `fname` varchar(255) NOT NULL DEFAULT '',
        `fsize` int(10) NOT NULL DEFAULT '0',
        `fmime` varchar(255) NOT NULL DEFAULT '',
        `ftitle` varchar(255) NOT NULL DEFAULT '',
        `fdesc` text,
        `fcreatedate` datetime NOT NULL COMMENT 'changed from the original int(11)',
        `flang` int(2) NOT NULL DEFAULT '0',
        `fversion` int(10) NOT NULL DEFAULT '0',
        `fauthor` varchar(50) NOT NULL DEFAULT '',
        `fnewver` varchar(30) DEFAULT '',
        `flastmod` datetime NOT NULL,
        `fparent` int(10) NOT NULL DEFAULT '0' COMMENT 'the parent fid, a directory id',
        `fchild` int(10) NOT NULL DEFAULT '0' COMMENT 'the fid of the default revision',
        `fimagesize` varchar(16) NOT NULL DEFAULT '0' COMMENT 'holds image size as a text string',
        `fimageh` int(4) NOT NULL DEFAULT '0',
        `fimagew` int(4) NOT NULL DEFAULT '0',
        `fdown` int(4) NOT NULL DEFAULT '0' COMMENT 'a bit generous with the size!',
        `fclass` int(2) DEFAULT NULL,
        `fstatus` int(4) unsigned DEFAULT NULL,
        `fkeywords` text,
        `fdistribution` int(4) unsigned NOT NULL DEFAULT '0',
        `fwaccess` int(1) unsigned NOT NULL DEFAULT '0',
        `fraccess` int(1) unsigned NOT NULL DEFAULT '0',
        `fblobmod` datetime NOT NULL,
        `fmd5` varchar(32) NOT NULL,
        PRIMARY KEY (`fid`),
        UNIQUE KEY `fid` (`fid`),
        KEY `fpath` (`fpath`),
        KEY `fparent` (`fparent`)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */");
      db_query("CREATE TABLE {dbfm_perm} (
        `fid` int(10) unsigned NOT NULL,
        `rgaccess` int(1) unsigned NOT NULL DEFAULT '0',
        `rgid` int(4) unsigned NOT NULL DEFAULT '0',
        KEY `fid` (`fid`)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */");
      db_query("CREATE TABLE {dbfm_data} (
        `fid` int(10) NOT NULL,
        `fblob` longblob,
        `fblobmod` datetime NOT NULL,
        `fmd5` varchar(32) NOT NULL,
        PRIMARY KEY (`fid`),
        UNIQUE KEY `fid` (`fid`)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */");
      db_query("CREATE TABLE {dbfm_cronlist} (
        `fid` int(10) NOT NULL,
        `fmd5` varchar(32) default NULL,
        `crontype` int(2) NOT NULL,
        `fdate` datetime NOT NULL,
        `fsize` int(10) default NULL,
        `fmime` varchar(255) NOT NULL,
        `fpath` text NOT NULL,
        `status` varchar(64) default NULL,
        `retries` int(2) NOT NULL default '0',
        `fparent` int(10) default NULL,
        `fversion` int(2) default NULL
      ) /*!40100 DEFAULT CHARACTER SET utf8 */");
      $currentdate = date("Y-m-d H:i:s");
      db_query("INSERT INTO {dbfm_file} (fid, uid, fname, fpath, fsize, fwaccess, fraccess, fcreatedate, flastmod, fblobmod, fparent) VALUES (1,1, 'dbfm', '/dbfm', 0, 1 ,0,'" . $currentdate . "','" . $currentdate . "','" . $currentdate . "',0)");
	  db_query("INSERT INTO {sequences} (name, id) VALUES ('dbfm_file_fid', 2)" );   
    break;

    default:
      drupal_set_message('dbfm_install currently supports the MySQL database only', error);
    break;
  }
}

/**
 * Implementation of hook_uninstall().
 */
function dbfm_uninstall() {
  db_query('DROP TABLE {dbfm_file}');
  db_query('DROP TABLE {dbfm_perm}');
  db_query('DROP TABLE {dbfm_data}');
  db_query('DROP TABLE {dbfm_cronlist}');
  db_query("DELETE FROM {sequences} WHERE name = 'dbfm_file_fid'");
  db_query("DELETE FROM {variable} WHERE name LIKE 'dbfm!_%' escape '!'");
  cache_clear_all('variables', 'cache');
}

/**
 * Implementation of hook_update_N()
 */


function dbfm_update_1() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      /**
       * Changes to DBFM_FILE
       */
      $ret[] = update_sql("ALTER TABLE {dbfm_file} CHANGE fpath fpath varchar(255) NOT NULL");
      $ret[] = update_sql("ALTER TABLE {dbfm_file} DROP fuser");
      $ret[] = update_sql("ALTER TABLE {dbfm_file} change fblob fblob longblob");
      $ret[] = update_sql("ALTER TABLE {dbfm_file} DROP fstat");
      $ret[] = update_sql("ALTER TABLE {dbfm_file} DROP faccess");
      $ret[] = update_sql("ALTER TABLE {dbfm_file} ADD fwaccess int(1) unsigned NOT NULL default '0'");
      $ret[] = update_sql("ALTER TABLE {dbfm_file} ADD fraccess int(1) unsigned NOT NULL default '0'");
      $ret[] = update_sql("ALTER TABLE {dbfm_file} CHANGE fclass fclass int(2)");
      /**
       * Add indexing
       */
      $ret[] = update_sql("ALTER TABLE {dbfm_file} ADD UNIQUE KEY fid (fid)");
      $ret[] = update_sql("ALTER TABLE {dbfm_file} ADD KEY fpath (fpath)");
      $ret[] = update_sql("ALTER TABLE {dbfm_file} ADD KEY fparent (fparent)");
      /**
       * Add DBFM_PERM for access control
       */
      $ret[] = update_sql("CREATE TABLE `dbfm_perm` (
        `fid` int(10) unsigned NOT NULL,
	`rgaccess` int(1) unsigned NOT NULL default '0',
	`rgid` int(4) unsigned NOT NULL default '0',
	KEY `fid` (`fid`)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */");
      break;
    default:
      drupal_set_message('dbfm_update currently supports the MySQL database only', error);
      break;
  }

  return $ret;
}

function dbfm_update_2() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      /**
       * Changes to file path - strip files/ from all paths
       * We also need to strip the / from the first record (root)
       */
       $ret[] = update_sql("UPDATE {dbfm_file} SET fpath = SUBSTRING(fpath,INSTR(fpath,'/'))");
       $ret[] = update_sql("UPDATE {dbfm_file} SET fname = SUBSTRING(fname,2) where fid = 1");
       $ret[] = update_sql("UPDATE {dbfm_file} SET fwaccess = 1 where fid = 1");  //set admin only access for the root directory
       
      /**
       * Add new fchild field - used to determine the currently issued revision of a document
       */
       $ret[] = update_sql("ALTER TABLE dbfm_file add fchild int(10) NOT NULL default '0'");

      break;
    default:
      drupal_set_message('dbfm_update currently supports the MySQL database only', error);
      break;
  }

  return $ret;
}

// Added for v5.x.3.0
function dbfm_update_3() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      /**
       * Changes to file path - strip files/ from all paths
       * We also need to strip the / from the first record (root)
       */
       // If we are NOT a slave we need to update dbfm_file
       $ret[] = update_sql('ALTER TABLE {dbfm_file} ADD fblobmod datetime NOT NULL');
       $ret[] = update_sql('ALTER TABLE {dbfm_file} ADD fmd5 varchar(32) NOT NULL');
       $ret[] = update_sql('ALTER TABLE {dbfm_file} DROP fformat');
         
       // For every record (one at a time) we need to calculate the MD5 sum, this will take a while...
       $maxfidquery = ('SELECT MAX(fid) as maxfid FROM {dbfm_file}');
       $maxfidqueryresult = db_query($maxfidquery);
       $fidrec = db_fetch_object($maxfidqueryresult);

       // Set the initial value for the fidcounter to zero and increment each time through the loop
       $fidcounter = 0;
       while ($fidcounter++ < $fidrec->maxfid) {

         // Try to grab the record - if it fails, continue.
         if (($filerec = dbfm_selected_file_record($fidcounter, $path = NULL, $erroron = FALSE)) == FALSE) continue;

         // If it's a version or a directory, continue.
         if (($filerec->fmime == 'version') || ($filerec->fmime == 'directory')) continue;

         // Calculate the MD5 checksum
         $md5sum = md5($filerec->fblob);
         $updatequery = sprintf ("UPDATE {dbfm_file} SET fblobmod='%s', fmd5='%s' where fid=%d", $filerec->fcreatedate, $md5sum, $fidcounter);
         $ret[] = update_sql($updatequery);

       }
       $newmaxfid = ($fidrec->maxfid + 1);
       //the fid's no longer auto-increment. Instead we use the sequence table to issue new file id's
       $sequencesquery = sprintf("INSERT INTO {sequences} (name, id) VALUES ('dbfm_file_fid', %d)", $newmaxfid);
       $ret[] = update_sql($sequencesquery);
       $ret[] = update_sql("CREATE TABLE `dbfm_cronlist` ( `fid` int(10) NOT NULL, `fmd5` varchar(32) default NULL, `crontype` int(2) NOT NULL, `fdate` datetime NOT NULL, `fsize` int(10) default NULL, `fmime` varchar(255) NOT NULL, `fpath` text NOT NULL, `status` varchar(64) default NULL, `retries` int(2) NOT NULL default '0', `fparent` int(10) default NULL, `fversion` int(2) default NULL)");
       $ret[] = update_sql("CREATE TABLE {dbfm_data} (select fid, fblob, fcreatedate, fmd5 from dbfm_file where fmime != 'directory' and fmime != 'version')");
       $ret[] = update_sql("ALTER TABLE {dbfm_data} ADD PRIMARY KEY (`fid`)");
       $ret[] = update_sql("ALTER TABLE {dbfm_data} ADD UNIQUE KEY `fid` (`fid`)");
       $ret[] = update_sql("ALTER TABLE {dbfm_data} CHANGE fcreatedate fblobmod datetime NOT NULL");
       $ret[] = update_sql("ALTER TABLE {dbfm_file} DROP fblob");

      break;
    default:
      drupal_set_message('dbfm_update currently supports the MySQL database only', error);
      break;
  }

  return $ret;
}