suitedesk/modules/storm/storm.install

<?php

/**
 * @file
 * Install, update and uninstall functions for the SuiteDesk module.
 */

/**
 * @function
 * Install function for the SuiteDesk module
 */
function storm_install() {
  variable_set('storm_report_header', '');
  variable_set('storm_icons_path', drupal_get_path('module', 'storm') .'/icons');
  variable_set('storm_organization_nid', 0);
  variable_set('storm_yearsrangebegin', 2010);
  variable_set('storm_yearsrangeend', 2025);

  // Set the weight to 2 (to execute module hooks after pathauto):
# db_query("UPDATE {system} SET weight = 2 WHERE name = 'storm'");

  // Clear the cache to get these to take effect:
# cache_clear_all();

  drupal_install_schema('storm');
}

/**
 * @function
 * Uninstall function for the SuiteDesk module
 */
function storm_uninstall() {
  global $conf;

  variable_del('storm_report_header');
  variable_del('storm_icons_path');
  variable_del('storm_organization_nid');
  variable_del('storm_yearsrangebegin');
  variable_del('storm_yearsrangeend');

  // Delete all notifications variables:
  db_query("DELETE FROM {variable} WHERE name LIKE 'notify_%'");
  cache_clear_all('variables', 'cache');
  unset($conf[$name]);

  // Uninstall Chamilo user table:
# variable_del('chamilo_sso_protocol');
# variable_del('chamilo_server');

  drupal_uninstall_schema('storm');
}

function storm_schema() {
  $schema['stormattribute'] = array(
    'fields'          => array(
      'aid'           => array('type' => 'serial', 'not null' => TRUE),
      'domain'        => array('type' => 'varchar', 'length' => 100),
      'akey'          => array('type' => 'varchar', 'length' => 100),
      'avalue'        => array('type' => 'varchar', 'length' => 100),
      'parent_domain' => array('type' => 'varchar', 'length' => 100),
      'weight'        => array('type' => 'int', 'not null' => FALSE, 'default' => 0, 'size' => 'small'),
      'isdefault'     => array('type' => 'int', 'not null' => FALSE, 'default' => 0, 'size' => 'tiny'),
      'isactive'      => array('type' => 'int', 'not null' => FALSE, 'default' => 1, 'size' => 'tiny'),
    ),
    'primary key' => array('aid'),
    'indexes' => array(
      'domain'        => array('domain'),
    ),
  );

  // SuiteDesk user notifications:
  $schema['notify'] = array(
    'fields' => array(
      'uid' => array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, 'disp-width' => '10'),
      'status' => array('type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, 'disp-width' => '2'),
      'node' => array('type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, 'disp-width' => '2'),
      'comment' => array('type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, 'disp-width' => '2'),
      'attempts' => array('type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, 'disp-width' => '4'),
    ),
    'primary key' => array('uid'),
  );
/*
  // User data abaout chamilo:
  $schema['chamilo_user'] = array(
    'fields' => array(
      'user_id' => array('type' => 'int', 'not null' => TRUE, 'default' => 0),
      'duser' => array('type' => 'varchar', 'length' => 20, 'not null' => TRUE, 'default' => ''),
      'apikey' => array('type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => ''),
      'course_visibility' => array('type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => ''),
      'agenda_time_frame' => array('type' => 'int', 'not null' => TRUE, 'default' => 0),
    ),
    'primary key' => array('user_id'),
  );
*/
  return $schema;
}

/**
 * @function
 * Implementation of hook_update_N().
 * Removes stormteammember table if it exists, cleanup from stormteam transition
 */
function storm_update_6101() {
  $ret = array();

  if (db_table_exists('stormteammember')) {
    db_drop_table($ret, 'stormteammember');
  }

  return $ret;
}

/**
 * Move SuiteDesk Attribute updates into storm.module
 */
function storm_update_6201() {
  $ret = array();

  // Only run this update if was not previously run as part of the legacy stormattribute module
  if (db_result(db_query("SELECT schema_version FROM {system} WHERE name = 'stormattribute'")) < 5) {
    db_add_field($ret, 'stormattribute', 'parent_domain', array('type' => 'varchar', 'length' => 100));
    db_add_field($ret, 'stormattribute', 'isactive', array('type' => 'int', 'not null' => FALSE, 'default' => 1, 'size' => 'tiny'));
    db_add_field($ret, 'stormattribute', 'isdefault', array('type' => 'int', 'not null' => FALSE, 'default' => 0, 'size' => 'tiny'));
  }

  if (db_result(db_query("SELECT schema_version FROM {system} WHERE name = 'stormattribute'")) < 6) {
    switch ($GLOBALS['db_type']) {
      case 'mysql':
      case 'mysqli':
        $ret[] = update_sql("ALTER TABLE {stormattribute} CHANGE COLUMN weight weight SMALLINT NOT NULL default 0");
        break;
      case 'pgsql':
        db_change_column($ret, 'stormattribute', "weight", "weight", 'int', array('not null' => FALSE, 'default' => 0, 'size' => 'small'));
        break;
    }
  }

  if (db_result(db_query("SELECT schema_version FROM {system} WHERE name = 'stormattribute'")) < 6201) {
    db_add_index($ret, 'stormattribute', 'domain', array('domain'));
  }

  return $ret;
}

/**
 * Set storm contrib dashboard settings to the new storm dashboard settings.
 */
function storm_update_6202() {
  $block_settings_old = variable_get('storm_extension_dashboard_activate_top_navigation', array());
  $page_settings = variable_get('storm_extension_dashboard_settings', array());

  $block_settings_new = array();
  if (!empty($page_settings)) {
    // weight of links was combined before
    foreach ($page_settings as $link) {
      $block_settings_new[$link['path']] = array();
      $block_settings_new[$link['path']]['weight'] = $link['weight'];
      $block_settings_new[$link['path']]['active'] = $link['active'];
    }
    foreach ($block_settings_old as $link) {
      $block_settings_new[$link['path']]['active'] = $link['active'];
    }
  }

  variable_set('storm_pagedashboard_settings', $page_settings);
  variable_set('storm_blockdashboard_settings', $block_settings_new);
  variable_del('storm_extension_dashboard_activate_top_navigation');
  variable_del('storm_extension_dashboard_settings');
  return array(array('success' => TRUE, 'query' => 'Set storm contrib dashboard settings to the new storm dashboard settings.'));
}