dbmigrate_2.0-2.5-pre.php

Go to the documentation of this file.

<?php
/*
 SPDX-FileCopyrightText: © 2014 Hewlett-Packard Development Company, L.P.
 
 SPDX-License-Identifier: GPL-2.0-only
*/
 
function Migrate_20_25($Verbose)
{
  global $PG_CONN;
 
  $sql = "select count(*) from pg_class where relname='copyright';";
  $result = pg_query($PG_CONN, $sql);
  DBCheckResult($result, $sql, __FILE__, __LINE__);
  $row = pg_fetch_assoc($result);
  pg_free_result($result);
  if (1 > $row['count']) {
    return 0; // fresh install, even no copyright table
  }
 
  $sql = "delete from copyright where pfile_fk not in (select pfile_pk from pfile);";
  $result = pg_query($PG_CONN, $sql);
  DBCheckResult($result, $sql, __FILE__, __LINE__);
  pg_free_result($result);
 
  $sql = "SELECT conname from pg_constraint where conname= 'copyright_pfile_fk_fkey';";
  $conresult = pg_query($PG_CONN, $sql);
  DBCheckResult($conresult, $sql, __FILE__, __LINE__);
  if (pg_num_rows($conresult) == 0) {
    $sql = "ALTER TABLE copyright ADD CONSTRAINT copyright_pfile_fk_fkey FOREIGN KEY (pfile_fk) REFERENCES pfile (pfile_pk) ON DELETE CASCADE; ";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    pg_free_result($result);
    print "add contr\n";
  }
  pg_free_result($conresult);
  return 0;
} // Migrate_20_25()