Ejemplo n.º 1
0
 /**
  * Removed forcing of invalid state on recentchanges_fk2.
  * cascading taken in account in the deleting function
  */
 protected function doRecentchangesFK2Cascade()
 {
     $meta = $this->db->query('SELECT 1 FROM all_constraints WHERE owner = \'' . strtoupper($this->db->getDBname()) . '\' AND constraint_name = \'' . $this->db->tablePrefix() . 'RECENTCHANGES_FK2\' AND delete_rule = \'CASCADE\'');
     $row = $meta->fetchRow();
     if ($row) {
         return;
     }
     $this->applyPatch('patch_recentchanges_fk2_cascade.sql', false, "Altering RECENTCHANGES_FK2");
 }
Ejemplo n.º 2
0
 /**
  * Fixed wrong PK, UK definition
  */
 protected function doPageRestrictionsPKUKFix()
 {
     $this->output("Altering PAGE_RESTRICTIONS keys ... ");
     $meta = $this->db->query('SELECT column_name FROM all_cons_columns WHERE owner = \'' . strtoupper($this->db->getDBname()) . '\' AND constraint_name = \'' . $this->db->tablePrefix() . 'PAGE_RESTRICTIONS_PK\' AND rownum = 1');
     $row = $meta->fetchRow();
     if ($row['column_name'] == 'PR_ID') {
         $this->output("seems to be up to date.\n");
         return;
     }
     $this->applyPatch('patch-page_restrictions_pkuk_fix.sql', false);
     $this->output("ok\n");
 }