<?php
// $Id: releasemonitor.install,v 1.8 2007/02/19 01:29:51 douggreen Exp $
// $Name: DRUPAL-5--1-0 $

function releasemonitor_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $status = db_query("CREATE TABLE {version} (
          vid int(10) unsigned NOT NULL default '0',
          name varchar(255) NOT NULL default '',
          info varchar(255) default '',
          cvstag varchar(255) default '',
          cvsid varchar(255) default '',
          cvsversions longtext default '',
          cvslasthttp int(11) NOT NULL default '0',
          changed int(11) NOT NULL default '0',
          PRIMARY KEY (`name`)
        )
        /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
	
    case 'pgsql':
      $status[] = db_query("CREATE TABLE {version} (
          vid integer NOT NULL default '0' check(vid >=0),
          name varchar(255) NOT NULL default '',
          info varchar(255) default '',
          cvstag varchar(255) default '',
          cvsid varchar(255) default '',
          cvsversions text default '',
          cvslasthttp integer NOT NULL default '0',
          changed integer NOT NULL default '0',
          PRIMARY KEY (name)
        );");
      $status[] = db_query("CREATE SEQUENCE {version}_seq;");
      break;
  }
  if ($status) {
    drupal_set_message(t('Release Monitor tables created successfully.'));
  }
  else {
    drupal_set_message(t('Release Monitor tables need to be installed manually (see releasemonitor.install).'), 'error');
  }
}