function ad_permission_install in Advertisement 5.2

Ad module permissions system database schema. Copyright (c) 2008 Jeremy Andrews <jeremy@tag1consulting.com>.

File

permission/ad_permission.install, line 8

Code

function ad_permission_install() {
  switch ($GLOBALS['db_type']) {
    case 'pgsql':

      /**
       * Every ad can have one or more owners.
       */
      db_query("CREATE TABLE {ad_owners} (\n       oid SERIAL NOT NULL PRIMARY KEY,\n       aid INT NOT NULL DEFAULT '0',\n       uid INT NOT NULL DEFAULT '0'\n     );");

      /**
       * Permissions can be granted to each owner of each ad.  The same owner
       * can own multiple ads, and can have different permissions for each ad.
       */
      db_query("CREATE TABLE {ad_permissions} (\n       oid INT NOT NULL DEFAULT '0' PRIMARY KEY,\n       permissions TEXT NULL DEFAULT ''\n     );");

      /**
       * The ad_hosts table is used to configure users that can display ads
       * remotely.
       */
      db_query("CREATE TABLE {ad_hosts} (\n        uid INT NOT NULL DEFAULT '0' PRIMARY KEY,\n \n        hostid varchar(32) DEFAULT '',\n        status INT NOT NULL DEFAULT '0',\n        description TEXT NOT NULL DEFAULT ''\n      );");
      break;
    case 'mysql':
    case 'mysqli':
    default:

      /**
       * Every ad can have one or more owners.
       */
      db_query("CREATE TABLE IF NOT EXISTS {ad_owners} (\n        oid INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,\n        aid INT(10) UNSIGNED NOT NULL DEFAULT '0',\n        uid INT(10) UNSIGNED NOT NULL DEFAULT '0',\n\n        PRIMARY KEY  (oid),\n        KEY  (aid),\n        KEY  (uid)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");

      /**
       * Permissions can be granted to each owner of each ad.  The same owner
       * can own multiple ads, and can have different permissions for each ad.
       */
      db_query("CREATE TABLE IF NOT EXISTS {ad_permissions} (\n        oid INT(11) UNSIGNED NOT NULL DEFAULT '0',\n        permissions LONGTEXT NULL,\n        PRIMARY KEY  (oid)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");

      /**
       * The ad_hosts table is used to configure users that can display ads
       * remotely.
       */
      db_query("CREATE TABLE IF NOT EXISTS {ad_hosts} (\n        uid INT UNSIGNED NOT NULL DEFAULT '0',\n\n        hostid varchar(32) DEFAULT '',\n\n        status INT(2) UNSIGNED NOT NULL DEFAULT '0',\n        description TEXT NULL,\n\n        PRIMARY KEY  (uid),\n        KEY  (status),\n        KEY  (hostid)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;
  }
  drupal_set_message(t('The necessary ad module tables have been created.'));
}