From a036d7f3c6a3a4d38d1d9fb1e878354d7992010f Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Thu, 3 Jul 2008 17:07:54 +0000
Subject: [PATCH] Clean empty role_names. MDL-15284 ; merged from 19_STABLE

---
 lib/db/upgrade.php | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php
index 70483e4530..904d1e2699 100644
--- a/lib/db/upgrade.php
+++ b/lib/db/upgrade.php
@@ -187,6 +187,11 @@ function xmldb_main_upgrade($oldversion=0) {
         upgrade_main_savepoint($result, 2008063002);
     }
 
+    if ($result && $oldversion < 2008070300) {
+        $result = $DB->delete_records_select('role_names', $DB->sql_isempty('role_names', 'name', false, false));
+        upgrade_main_savepoint($result, 2008070300);
+    }
+
 /*
  * TODO:
  *   drop adodb_logsql table and create a new general sql log table
-- 
2.39.5