[adminer-tracker] [ adminer-Bugs and Features-3459296 ] Mistakes in Foreign keys section
Database management in a single PHP file
Brought to you by:
jakubvrana
From: SourceForge.net <no...@so...> - 2012-06-29 22:42:59
|
Bugs and Features item #3459296, was opened at 2011-12-14 02:05 Message generated for change (Settings changed) made by jakubvrana 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: Pending Resolution: Works For Me 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 ); -- ---------------------------------------------------------------------- Comment By: Jakub Vrána (jakubvrana) Date: 2012-06-29 15:42 Message: I couldn't reproduce this. Do you use SQLite 2 or 3? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3459296&group_id=264133 |