function auto_expire_install in Auto Expire 5

Same name and namespace in other branches

1. 7 auto_expire.install \auto_expire_install()

File

./auto_expire.install, line 6

Code

function auto_expire_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $result = db_query("CREATE TABLE {auto_expire} (\n        nid int(10) unsigned NOT NULL,\n        warned int(1) unsigned NOT NULL DEFAULT 0,\n        expire int(11) NOT NULL,\n        extended int(3) unsigned NOT NULL DEFAULT 0,\n        primary key (nid)\n        );\n      ");
      if ($result) {
        drupal_set_message('Auto Expire module mysql table {auto_expire} created successfully.');
      }
      else {
        drupal_set_message('Auto Expire module mysql table {auto_expire} creation failed!', 'error');
      }
      break;
    case 'pgsql':
      $result = db_query("CREATE TABLE {auto_expire} (\n        nid int_unsigned NOT NULL,\n        warned smallint NOT NULL DEFAULT 0,\n        expire int NOT NULL,\n        extended smallint_unsigned NOT NULL DEFAULT 0,\n        primary key (nid)\n        );\n      ");
      if ($result) {
        drupal_set_message('Auto Expire module postgresql table {auto_expire} created successfully.');
      }
      else {
        drupal_set_message('Auto Expire module postgresql table {auto_expire} creation failed!', 'error');
      }
      break;
  }
}