[adminer-tracker] [ adminer-Bugs and Features-3459296 ] Mistakes in Foreign keys section

[SourceForge.net <no...@so...>]

Bugs and Features item #3459296, was opened at 2011-12-14 02:05
Message generated for change (Tracker Item Submitted) made by 
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3459296&group_id=264133

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQLite
Group: 3.3.3
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Rostyslav ()
Assigned to: Jakub Vrána (jakubvrana)
Summary: Mistakes in Foreign keys section

Initial Comment:
Foreign key target name is shown in double quotes ("table1"), and the same is in link URL (adminer.php?sqlite=&username=&db=&table="table1"), it never find the table if you follow the link.

ON DELETE action is shown empty whenever it's set to CASCADE.


Here is example's dump.

-- Adminer 3.3.3 SQLite 3 dump

CREATE TABLE "table1" (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT
);


CREATE TABLE "table2" (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "table1_id" integer NOT NULL,
  FOREIGN KEY ("table1_id") REFERENCES "table1" ("id") ON DELETE CASCADE
);


-- 

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3459296&group_id=264133