You are here

Home » API reference » Weather_es 5 » weather_es.install

function weather_es_install in Weather_es 5

Same name and namespace in other branches
  1. 6.3 weather_es.install \weather_es_install()
  2. 6 weather_es.install \weather_es_install()
  3. 6.2 weather_es.install \weather_es_install()
  4. 7 weather_es.install \weather_es_install()

Implementation of hook_install().

File

./weather_es.install, line 35
Non-displayable characters.

Code

function weather_es_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("\n      CREATE TABLE {weather_es_config} (\n      uid INT(3) UNSIGNED DEFAULT 0 NOT NULL,\n      cod_pro INT(2) UNSIGNED ZEROFILL DEFAULT 0 NOT NULL,\n      cod_loc INT(3) UNSIGNED ZEROFILL DEFAULT 0 NOT NULL,\n      cit_nam VARCHAR(50) DEFAULT '',\n      lan VARCHAR(2) DEFAULT 'es',\n      pro_act INT(10) UNSIGNED DEFAULT 0 NOT NULL,\n      sky VARCHAR(50) DEFAULT '',\n      rain VARCHAR(50) DEFAULT '',\n      snow VARCHAR(50) DEFAULT '',\n      tmax VARCHAR(50) DEFAULT '',\n      tmin VARCHAR(50) DEFAULT '',\n      win_dir VARCHAR(50) DEFAULT '',\n      win_spd VARCHAR(50) DEFAULT '',\n      iv VARCHAR(50) DEFAULT '',\n      rsk VARCHAR(50) DEFAULT '',\n      PRIMARY KEY(uid, cod_pro, cod_loc))\n      /*!40100 DEFAULT CHARACTER SET utf8 */\n      ");
      db_query("\n      CREATE TABLE {weather_es_data} (\n      did SMALLINT NOT NULL AUTO_INCREMENT,\n      cod_pro INT(2) UNSIGNED ZEROFILL DEFAULT 0 NOT NULL,\n      cod_loc INT(3) UNSIGNED ZEROFILL DEFAULT 0 NOT NULL,\n      day VARCHAR(15) DEFAULT '',\n      ampm VARCHAR(2) DEFAULT '',\n      sky_txt1 VARCHAR(50) DEFAULT '',\n      sky_txt2 VARCHAR(50) DEFAULT '',\n      sky_img1 VARCHAR(25) DEFAULT 'nodata',\n      sky_img2 VARCHAR(25) DEFAULT 'nodata',\n      rain INT(3) UNSIGNED DEFAULT 999,\n      snow INT(4) UNSIGNED DEFAULT 9999,\n      tmax INT(2) DEFAULT 99,\n      tmin INT(2) DEFAULT 99,\n      win_dir1 VARCHAR(50) DEFAULT '',\n      win_dir2 VARCHAR(50) DEFAULT '',\n      win_spd1 INT(3) UNSIGNED DEFAULT 999,\n      win_spd2 INT(3) UNSIGNED DEFAULT 999,\n      iv_max INT(2) UNSIGNED DEFAULT 99,\n      rsk VARCHAR(50) DEFAULT '',\n      PRIMARY KEY(cod_pro, cod_loc, did))\n      /*!40100 DEFAULT CHARACTER SET utf8 */\n      ");
      db_query("\n      CREATE TABLE {weather_es_aemet} (\n      cod_pro INT(2) UNSIGNED ZEROFILL DEFAULT 0 NOT NULL,\n      cod_loc INT(3) UNSIGNED ZEROFILL DEFAULT 0 NOT NULL,\n      cit_nam VARCHAR(50) DEFAULT '',\n      PRIMARY KEY(cod_pro, cod_loc))\n      /*!40100 DEFAULT CHARACTER SET utf8 */\n      ");
      break;
  }

  // Insert the AEMET cities code
  require_once drupal_get_path('module', 'weather_es') . '/weather_es_data.inc';
  _weather_es_fill_aemet_table();
}