location_phone.install in Location 5

File

contrib/location_phone/location_phone.install

<?php

function location_phone_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("\n      CREATE TABLE {location_phone} (\n        lid int(10) unsigned NOT NULL default '0',\n        phone varchar(31) default NULL,\n        PRIMARY KEY  (lid)\n      ) /*!40100 DEFAULT CHARACTER SET utf8 */;\n      ");
      break;
    case 'pgsql':
      db_query("\n        CREATE TABLE {location_phone} (\n        lid int NOT NULL default '0' CHECK (eid >= 0),\n        phone varchar(31) default NULL,\n        postal_code varchar(16) default NULL,\n        PRIMARY KEY  (lid)\n      ) /*!40100 DEFAULT CHARACTER SET utf8 */;\n      ");
      break;
  }
  drupal_set_message(t('Installed tables for module location_phone'));
}

//TODO: drop 'postal_code' column in pgsql version of table

//That's what you get for a lousy copy-paste-modify job

Functions

Name	Description
location_phone_install