function alterSequenceProps($seqrs, $increment, $minvalue, $maxvalue, $restartvalue, $cachevalue, $cycledvalue, $startvalue)
{
$sql = '';
/* vars are cleaned in _alterSequence */
if (!empty($increment) && $increment != $seqrs->fields['increment_by']) {
$sql .= " INCREMENT {$increment}";
}
if (!empty($minvalue) && $minvalue != $seqrs->fields['min_value']) {
$sql .= " MINVALUE {$minvalue}";
}
if (!empty($maxvalue) && $maxvalue != $seqrs->fields['max_value']) {
$sql .= " MAXVALUE {$maxvalue}";
}
if (!empty($restartvalue) && $restartvalue != $seqrs->fields['last_value']) {
$sql .= " RESTART {$restartvalue}";
}
if (!empty($cachevalue) && $cachevalue != $seqrs->fields['cache_value']) {
$sql .= " CACHE {$cachevalue}";
}
if (!empty($startvalue) && $startvalue != $seqrs->fields['start_value']) {
$sql .= " START {$startvalue}";
}
// toggle cycle yes/no
if (!is_null($cycledvalue)) {
$sql .= (!$cycledvalue ? ' NO ' : '') . " CYCLE";
}
if ($sql != '') {
$f_schema = $this->_schema;
$this->fieldClean($f_schema);
$sql = "ALTER SEQUENCE \"{$f_schema}\".\"{$seqrs->fields['seqname']}\" {$sql}";
return $this->execute($sql);
}
return 0;
}