rfe #2988633 Improve ON DELETE/ON UPDATE drop-downs

1 files changed, 26 insertions, 0 deletions

diff --git a/js/tbl_relation.js b/js/tbl_relation.js
new file mode 100644
index 0000000000..5cdb0d7d9f
--- /dev/null
+++ b/js/tbl_relation.js
@@ -0,0 +1,26 @@
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * for tbl_relation.php 
+ *
+ */
+function show_hide_clauses(thisDropdown) {
+    // here, one span contains the label and the clause dropdown
+    // and we have one span for ON DELETE and one for ON UPDATE
+    //
+    if (thisDropdown.val() != '') {
+        thisDropdown.parent().next('span').show().next('span').show();
+    } else {
+        thisDropdown.parent().next('span').hide().next('span').hide();
+    }
+}
+
+$(document).ready(function() {
+    // initial display
+    $('.referenced_column_dropdown').each(function(index, one_dropdown) {
+        show_hide_clauses($(one_dropdown));
+    });
+    // change
+    $('.referenced_column_dropdown').change(function() {
+        show_hide_clauses($(this));
+    });
+});