ad_text.install in Advertisement 5

File

text/ad_text.install

<?php

/**
 * Ad_text module database schema.
 * Copyright (c) 2005-2006 Jeremy Andrews <[e-mail]>.  
 * All rights reserved.
 */
function ad_text_install() {
  switch ($GLOBALS['db_type']) {
    case 'pgsql':

      /**
       * The ad_text table stores each line of the actual text ad.
       */
      db_query("CREATE TABLE {ad_text} (\n        aid INT NOT NULL DEFAULT '0' PRIMARY KEY,\n\n        url VARCHAR(255) NOT NULL DEFAULT '',\n        adheader VARCHAR(255) NOT NULL DEFAULT '',\n        adbody TEXT NOT NULL DEFAULT ''\n      );");
      break;
    case 'mysql':
    case 'mysqli':
    default:

      /**
       * The ad_text table stores each line of the actual text ad.
       */
      db_query("CREATE TABLE {ad_text} (\n        aid INT(10) UNSIGNED NOT NULL DEFAULT '0',\n\n        url VARCHAR(255) NOT NULL DEFAULT '',\n        adheader VARCHAR(255) NOT NULL DEFAULT '',\n        adbody TEXT NULL,\n\n        PRIMARY KEY (aid)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
  }
  drupal_set_message(t('The necessary ad_text module tables have been created.'));
}

/**
 * Allow complete uninstallation of the ad_text module.
 */
function ad_text_uninstall() {

  // Delete all ad_text content.
  $result = db_query("SELECT aid FROM {ad_text}");
  while ($aid = db_result($result)) {
    node_delete($aid);
  }

  // Drop all ad_text module tables.
  db_query('DROP TABLE {ad_text}');
}

/**
 * Convert to utf8 character set for all tables to allow for proper 
 * internationalization.
 */
function ad_text_update_1() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'pgsql':
      break;
    default:
      $ret[] = update_sql("ALTER TABLE {ad_text} CONVERT TO CHARACTER SET utf8");
  }
  return $ret;
}

Functions

Name	Description
ad_text_install	Ad_text module database schema. Copyright (c) 2005-2006 Jeremy Andrews <[e-mail]>. All rights reserved.
ad_text_uninstall	Allow complete uninstallation of the ad_text module.
ad_text_update_1	Convert to utf8 character set for all tables to allow for proper internationalization.