#215 Mistakes in Foreign keys section

3.3.3
closed-works-for-me
SQLite (26)
5
2014-02-24
2011-12-14
Anonymous
No

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
);

--

Discussion

  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2011-12-14

    Foreign keys section screenshot

     
  • Jakub Vrána

    Jakub Vrána - 2012-06-29
    • status: open --> closed-works-for-me
     
  • Jakub Vrána

    Jakub Vrána - 2012-06-29

    I couldn't reproduce this. Do you use SQLite 2 or 3?

     
  • Jakub Vrána

    Jakub Vrána - 2012-06-29
    • status: closed-works-for-me --> pending-works-for-me
     
  • Jakub Vrána

    Jakub Vrána - 2014-02-24
    • status: pending-works-for-me --> closed-works-for-me
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks