Show drop-downs for view and indexes

https://sourceforge.net/tracker/?func=detail&atid=117457&aid=3110252&group_id=17457

diff --git a/mysql/edit_dbase.cgi b/mysql/edit_dbase.cgi
index ecb987e..f3a9073 100755 (executable)
--- a/mysql/edit_dbase.cgi
+++ b/mysql/edit_dbase.cgi
@@ -45,6 +45,7 @@ if (@titles+@indexes+@views > $max_dbs && !$in{'search'}) {
        print &ui_submit($text{'index_search'}),"<br>\n";
        print &ui_form_end();
 
+       # Table selector
        print &ui_form_start("edit_table.cgi");
        print $text{'dbase_jump'},"\n";
        print &ui_hidden("db", $in{'db'}),"\n";
@@ -52,6 +53,28 @@ if (@titles+@indexes+@views > $max_dbs && !$in{'search'}) {
                         1, 0, 0, 0, "onChange='form.submit()'"),"\n";
        print &ui_submit($text{'index_jumpok'}),"<br>\n";
        print &ui_form_end();
+
+       # View selector (if any)
+       if (@views) {
+               print &ui_form_start("edit_view.cgi");
+               print $text{'dbase_vjump'},"\n";
+               print &ui_hidden("db", $in{'db'}),"\n";
+               print &ui_select("view", undef, [ map { [ $_ ] } @views ],
+                                1, 0, 0, 0, "onChange='form.submit()'"),"\n";
+               print &ui_submit($text{'index_jumpok'}),"<br>\n";
+               print &ui_form_end();
+               }
+
+       # Index selector (if any)
+       if (@indexes) {
+               print &ui_form_start("edit_index.cgi");
+               print $text{'dbase_ijump'},"\n";
+               print &ui_hidden("db", $in{'db'}),"\n";
+               print &ui_select("index", undef, [ map { [ $_ ] } @indexes ],
+                                1, 0, 0, 0, "onChange='form.submit()'"),"\n";
+               print &ui_submit($text{'index_jumpok'}),"<br>\n";
+               print &ui_form_end();
+               }
        }
 elsif (@titles || @indexes) {
        @icons = ( ( map { "images/table.gif" } @titles ),

diff --git a/mysql/lang/en b/mysql/lang/en
index bd6d505..856626e 100644 (file)
--- a/mysql/lang/en
+++ b/mysql/lang/en
@@ -70,7 +70,9 @@ dbase_toomany=There are too many tables to display. Find tables matching:
 dbase_index=Index
 dbase_view=View
 dbase_addview=Create View
-dbase_jump=Or edit table:
+dbase_jump=Edit table:
+dbase_vjump=Edit view:
+dbase_ijump=Edit index:
 
 ddrop_err=Failed to drop database
 ddrop_title=Drop Database

diff --git a/postgresql/edit_dbase.cgi b/postgresql/edit_dbase.cgi
index 9db6327..582dabb 100755 (executable)
--- a/postgresql/edit_dbase.cgi
+++ b/postgresql/edit_dbase.cgi
@@ -57,6 +57,7 @@ if (@titles+@indexes+@views+@seqs > $max_dbs && !$in{'search'}) {
        print &ui_submit($text{'index_search'}),"<br>\n";
        print &ui_form_end();
 
+       # Table selector
        print &ui_form_start("edit_table.cgi");
        print $text{'dbase_jump'},"\n";
        print &ui_hidden("db", $in{'db'}),"\n";
@@ -64,6 +65,39 @@ if (@titles+@indexes+@views+@seqs > $max_dbs && !$in{'search'}) {
                         1, 0, 0, 0, "onChange='form.submit()'"),"\n";
        print &ui_submit($text{'index_jumpok'}),"<br>\n";
        print &ui_form_end();
+
+       # View selector (if any)
+       if (@views) {
+               print &ui_form_start("edit_view.cgi");
+               print $text{'dbase_vjump'},"\n";
+               print &ui_hidden("db", $in{'db'}),"\n";
+               print &ui_select("view", undef, [ map { [ $_ ] } @views ],
+                                1, 0, 0, 0, "onChange='form.submit()'"),"\n";
+               print &ui_submit($text{'index_jumpok'}),"<br>\n";
+               print &ui_form_end();
+               }
+
+       # Index selector (if any)
+       if (@indexes) {
+               print &ui_form_start("edit_index.cgi");
+               print $text{'dbase_ijump'},"\n";
+               print &ui_hidden("db", $in{'db'}),"\n";
+               print &ui_select("index", undef, [ map { [ $_ ] } @indexes ],
+                                1, 0, 0, 0, "onChange='form.submit()'"),"\n";
+               print &ui_submit($text{'index_jumpok'}),"<br>\n";
+               print &ui_form_end();
+               }
+
+       # Sequence selector (if any)
+       if (@seqs) {
+               print &ui_form_start("edit_seq.cgi");
+               print $text{'dbase_sjump'},"\n";
+               print &ui_hidden("db", $in{'db'}),"\n";
+               print &ui_select("seq", undef, [ map { [ $_ ] } @seqs ],
+                                1, 0, 0, 0, "onChange='form.submit()'"),"\n";
+               print &ui_submit($text{'index_jumpok'}),"<br>\n";
+               print &ui_form_end();
+               }
        }
 elsif (@titles || @indexes || @views || @seqs) {
        @icons = ( ( map { "images/table.gif" } @titles ),

diff --git a/postgresql/lang/en b/postgresql/lang/en
index 8ecf1bb..faf5f2e 100644 (file)
--- a/postgresql/lang/en
+++ b/postgresql/lang/en
@@ -74,7 +74,10 @@ dbase_toomany=There are too many objects to display. Find objects matching:
 dbase_index=Index
 dbase_view=View
 dbase_seq=Sequence
-dbase_jump=Or edit table:
+dbase_jump=Edit table:
+dbase_vjump=Edit view:
+dbase_ijump=Edit index:
+dbase_sjump=Edit sequence:
 
 table_title=Edit Table
 table_title2=Create Table