protected function checkOiNameConstraint()
{
if ($this->db->hasConstraint("oldimage_oi_name_fkey_cascaded")) {
$this->output("...table 'oldimage' has correct cascading delete/update foreign key to image\n");
} else {
if ($this->db->hasConstraint("oldimage_oi_name_fkey")) {
$this->db->query("ALTER TABLE oldimage DROP CONSTRAINT oldimage_oi_name_fkey");
}
if ($this->db->hasConstraint("oldimage_oi_name_fkey_cascade")) {
$this->db->query("ALTER TABLE oldimage DROP CONSTRAINT oldimage_oi_name_fkey_cascade");
}
$this->output("Making foreign key on table 'oldimage' (to image) a cascade delete/update\n");
$this->db->query("ALTER TABLE oldimage ADD CONSTRAINT oldimage_oi_name_fkey_cascaded " . "FOREIGN KEY (oi_name) REFERENCES image(img_name) ON DELETE CASCADE ON UPDATE CASCADE");
}
}
