function linkchecker_update_1000 in Link checker 5

Update table definitions.

File

./linkchecker.install, line 49

Code

function linkchecker_update_1000() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql("CREATE TABLE `linkchecker_tasks` (\n                 `taskid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,\n                 `nodeid` INT( 10 ) NOT NULL ,\n                 `status` INT( 10 ) DEFAULT '0' NOT NULL ,\n                 `update` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,\n                  PRIMARY KEY ( `taskid` )\n                 ) TYPE = MYISAM;");
      $ret[] = update_sql("CREATE TABLE `linkchecker_results` (\n                 `taskid` int(10) NOT NULL default '0',\n                 `url` text NOT NULL,\n                 `response` varchar(255) NOT NULL default '0',\n                 KEY `taskid` (`taskid`)\n                 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ");
      break;
  }
  return $ret;
}