ad_html.install in Advertisement 5.2

File

html/ad_html.install

<?php

/**
 * Ad_html module database schema.
 * Copyright (c) 2007 Jeremy Andrews <[e-mail]>.  
 * All rights reserved.
 */
function ad_html_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
    default:

      /**
       * The ad_html table stores the html ad.
       */
      db_query("CREATE TABLE {ad_html} (\n        aid INT(10) UNSIGNED NOT NULL DEFAULT '0',\n\n        html TEXT NULL,\n\n        PRIMARY KEY (aid)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;
    case 'pgsql':

      /**
       * The ad_html table stores the html ad.
       */
      db_query("CREATE TABLE {ad_html} (\n        aid INT NOT NULL DEFAULT '0' PRIMARY KEY,\n\n        html TEXT NOT NULL DEFAULT ''\n      );");
      break;
  }
  drupal_set_message(t('The necessary ad_html module tables have been created.'));
}

/**
 * Allow complete uninstallation of the ad_html module.
 */
function ad_html_uninstall() {

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

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

Functions

Name	Description
ad_html_install	Ad_html module database schema. Copyright (c) 2007 Jeremy Andrews <[e-mail]>. All rights reserved.
ad_html_uninstall	Allow complete uninstallation of the ad_html module.